Power Bi Data Analyst

Sidramappa Shantkumar Shetkar

Power BI Developer Data Analyst Operations BI Analyst

Pune, India +918********* *****************@*****.*** Profile Summary

Business Intelligence Analyst with over 5 years of experience in designing, developing, and optimizing interactive dashboards and reports using Power BI, SQL, and Excel. Skilled in analyzing large and complex datasets, building robust data models, and automating reporting workflows to improve decision-making. Adept at writing advanced DAX queries, performing ETL operations, and resolving BI issues in global enterprise environments. Proven track record of collaborating with cross-functional teams to deliver actionable insights and drive business performance.

Professional Experience

Scymes Services Pvt. Ltd. deputed IATA, Mumbai Mar 2023 – Present Operations BI Analyst

Roles & Responsibilities: -

• Managed global billing operations for BSP/CASS, processing transactions across 100+ countries, ensuring timely and accurate reconciliation.

• Developed and maintained Power BI dashboards and Excel reports to monitor ticket sales, commissions, taxes, and error rates, supporting finance teams across 5 continents.

• Designed robust Star and Snowflake schema data models to streamline reporting on millions of transaction records.

• Created DAX measures and calculated columns to support KPIs and provide insights into agent performance and tax compliance.

• Delivered highly interactive dashboards with drill-through capabilities and dynamic filters, accelerating decision-making and enhancing stakeholder reporting.

• Provided Level 2/3 support for BSPLink/CASSLink platforms, resolving technical issues.

• Automated recurring reports, reducing manual effort and minimizing reporting errors.

• Collaborated with global finance teams and cross-functional stakeholders to define reporting requirements and deliver impactful BI solutions.

• Prepared and presented regular status reports to executive leadership, highlighting project progress, risks, and key performance indicators.

• Tools & Technologies: Power BI, Salesforce, SQL Server, Excel, BSPLink, CASSLink, RET/HOT files, JIRA. Sygnius Ventures Pvt. Ltd. Pune Aug 2020 – Mar 2023 Jr. Power BI Developer

Roles & Responsibilities: -

• Utilized Power BI Query Editor for extensive data cleansing and transformation to ensure accuracy and consistency.

• Created advanced DAX measures and KPIs to support business metrics and enhance analytical capabilities.

• Designed interactive dashboards including Salesperson Performance, Customer Overview, and Product Return Reports for actionable insights.

• Leveraged custom visuals, slicers, and drill-through functionalities to improve user interactivity and data exploration.

• Configured and maintained Row-Level Security (RLS) and managed automated report refresh schedules for secure and up-to-date reporting.

Educational qualification

• Bachelor of Engineering (Mechanical) – BMIT College, Solapur University. Professional Skills

• Good adaptability skills.

• Excellent communication and analytical skills.

• Interpersonal skills and ability to build rapport with clients.

• Good time management skills.

Technical Skills

• Data Analysis & Visualization: Power BI Desktop, Power Query Editor, DAX, Power BI Services

• Advanced Excel: VLOOKUP, SUMIF, COUNTIF, etc., Pivot Tables, Conditional Formatting

• Statistical & Predictive Analysis: Demand Forecasting Analysis

• Data Extraction & Reporting: Salesforce, AWS, JIRA, SQL, Excel/CSV

• Data Warehousing (OLTP OLAP)

• Data Modelling (Star Schema, Snowflake Schema, Fact Constellation Schema) Projects

Project 1: Insurance Data Analysis

Client: AIG Auto Insurance, USA Domain: Vehicle Insurance Tools/Tech: Power BI, Power Query, DAX, SDLC

• Developed comprehensive Power BI reports including Customer Service, Claims, Sales, and Delinquency reports using vehicle insurance data.

• Participated across the SDLC: from requirement gathering and impact analysis to deployment and post- verification testing.

• Identified and resolved bugs; conducted root cause analysis and implemented optimized solutions.

• Used advanced Power Query transformations for data cleaning and shaping to improve report performance and accuracy.

Project 2: Sales Data Analysis Dashboard

Client: Procter & Gamble (P&G), USA Domain: Sales Analytics Tools/Tech: Power BI, DAX, Power Pivot, Power Query, RLS

• Created advanced interactive dashboards in Power BI to analyze invoice data, customer trends, product- level performance, and seasonal sales.

• Designed drill-down and drill-through report features to provide detailed invoice and customer insights.

• Implemented Row-Level Security (RLS) and managed Power BI Gateway for scheduled refreshes.

• Imported custom visuals and utilized diverse chart types (map, tree map, funnel, cards, slicers, etc.) to meet dynamic client requirements.

• Worked closely with business analysts to gather and refine reporting requirements.

• Tracked and communicated weekly project development status to stakeholders. Declaration

I consider myself familiar with this work. I am also confident of my ability to work in a team. I hereby declare that the information furnished above is true to best of my knowledge. Date: Name and Signature

Place:

Contact this candidate