Professional Summary

Arunkumar M  Having 5+ years of professional experience in the IT industry,

specializing in Power BI and MSBI projects with a focus on ETL
processes and reporting tools like Oracle Server and Power BI.
 Possessing 5+ years of hands-on experience in Microsoft
technologies, specifically Power BI Desktop and Power BI
Service.
 Demonstrated expertise in creating diverse visualized
Personal Profile
dashboards tailored to client requirements.
 Proficient in implementing slicers, Sync slicer in various
arunkumarmanoharan018@gmail.com
visuals, and creating and utilizing different types of filters
such as page level, visual level, report level, and drill-through
filters.
 End-to-end experience in designing and deploying data
visualizations using Power BI, showcasing skills in importing
Technologies: Power BI, Microsoft Busi- data from multiple sources, establishing data relationships,
ness Intelligence Tools (MSBI)
and creating calculated columns and measures using DAX
Databases: SQL Server Query.
 Experienced in creating or utilizing different types of KPIs to
ETL Tools: SQL Server Integration
Services
gain insights from the data.
 Skilled in Power BI Desktop for data visualization through
Reporting Tools: SQL Server Reporting various charts, including Bar charts, Line charts, Scatter plots,
and Pie charts.
Operating Systems: Windows XP, Win 7,  Designed and deployed reports with features like Drill Up and
Drop-down menu options.
 Proficient in writing DAX queries/expressions in Power BI
Desktop to perform advanced calculations.
 Skilled in SQL tuning techniques to optimize query
performance and enhance efficiency.
 Familiarity with star schema design principles, enabling
efficient data modeling and analysis in Power BI.
 Ability to implement best practices in star schema design to
enhance data organization and improve query performance.

Employment History

 Senior Software Engineer, Hexaware Technologies,

Chennai

Jul 2022 - Sep 2023

 Techriffs Info Systems, Chennai

Oct 2018 - Jun 2022
Projects:
Project #3: Amadeus Migration
Client: Amadeus
Duration: Jul 2022 - Sep 2023
Environment: Power BI, SQL Server

Description: Amadeus is a leading Hotel CRM Technology Provider

and Data-Driven Marketing Agency. The project involved the
migration of data to enhance the hotel CRM system.

 Setting Database and Server Parameters as per the

requirements.
 Working the Report Performance Optimization.
 Created Slicers in Power BI.
 Created reports using Power BI desktop which includes drillings,
sorts etc.
 Created filters and apply conditional formatting based on the
user requirement.
 Created measures and columns in Power BI Desktop
 Implement row level security on data and understand security
models in Power BI.
 Implemented Role Based Security as part of security in Power
BI.
 Using Bookmarks, Sync Slicers, Edit Interactions in Power BI.
 Created scheduling the reports using Enterprise Gateway.

Project #2: Analysis Systems (Health Care Domain)

Client: Abbott
Duration: Oct 2020 - May 2022
Environment: Power BI, SQL Server

Description: The project focused on supporting healthcare providers

in understanding and improving the patient experience.

 Involved in Creating Hierarchies and giving the relationship

between attributes to decrease processing time.
 Involved in creating relationships between dimensions and
measure groups as per business requirement.
 I have involved in Creating Calculated Columns and Calculated
Measures.
 Create Visuals and Reports in Power BI Desktop and publish into
Power BI Service.
 Create Reports Using Custom Visuals.
 Create Reports and Dash Boards in Power BI.
  Create Reports in Power BI Desktop as per requirement.
 Generating reports using DAX time intelligence functions and
other kind of DAX functions.
 Creating Content packs and Sharing reports and Dashboards.
 Scheduling using Gateway.
 Connecting Live and extract data from SQL SERVER Tabular
Model into Power BI desktop.
 Design, create, and implement database systems based on the
end user's requirements.
 Develop database schemas, tables, and dictionaries.

Project #1: IDW

Client: JetStream Airline Systems
Duration: Oct 2018 - Sep 2020
Environment: Power BI, SQL Server, Data Analysis Expressions

Description: Implemented a comprehensive aviation analytics

dashboard to provide actionable insights for JetStream Airline
Systems. The project focused on aggregating and visualizing key
performance indicators (KPIs) to enhance decision-making processes
within the aviation domain.

 Integrate various aviation data sources into a unified data

model.
 Ensure data accuracy and consistency.
 Design and develop interactive dashboards and reports using
Power BI.
 Showcase key aviation KPIs, such as on-time performance and
fuel efficiency.
 Implement DAX measures for calculating metrics like aircraft
utilization rates and cost per flight segment.
 Create dynamic drill-down functionalities and filters within
Power BI dashboards.
 Optimize Power BI report performance for large datasets.
 Work closely with aviation experts, operations teams, and
executives.
 Conduct training sessions for end-users on navigating and
interpreting the aviation analytics dashboard.