Amarendra Mahapatra
Data Analyst
Bhubaneswar
Summary
Data Analyst & Power BI Developer with 3+ years of experience, combining analytics and technical support. Skilled in Power BI, SQL, and Power Query, with a track record of delivering clear insights and automating reports across FMCG, healthcare, and finance domains.
Overview
5
5
years of professional experience
2
2
Certifications
Work History
Data Analyst
Capgemini
04.2024 - Current
- Designed and maintaining interactive Power BI dashboards to track sales, inventory, and regional performance for FMCG analytics.
- Developed dynamic reports and KPIs, aligning with evolving business needs.
- Enabled deeper insights with drill-through reports and filters for supply chain analytics.
- Conducted data validation to ensure accuracy and stakeholder trust in reports.
Power BI Developer
Capgemini
03.2023 - 01.2024
- Led the enhancement of analytics for Optima Analytics using Power BI.
- Reduced report generation time by automating reporting processes.
- Designed KPI-driven dashboards that optimized resource utilization and improved production planning.
Data Analyst
Capgemini
01.2022 - 11.2022
- Cleaned and structured large-scale healthcare data for a US-based provider using MySQL and Excel Power Query.
- Removed data inconsistencies and redundancies, improving reporting reliability.
- Automated repetitive data preparation tasks, reducing manual effort.
L2/L3 Support Analyst
Capgemini
11.2020 - 12.2021
- Provided tiered support for Discover Financial Services and New York Life Insurance.
- Diagnosed and resolved technical issues, improving customer satisfaction.
- Contributed to the support knowledge base, enabling quicker resolution times.
Education
B. Tech - Mechanical Engineering
ITER, Siksha 'O' Anusandhan University
Skills
Power BI
Certification
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Timeline
Data Analyst
Capgemini
04.2024 - Current
Power BI Developer
Capgemini
03.2023 - 01.2024
Data Analyst
Capgemini
01.2022 - 11.2022
L2/L3 Support Analyst
Capgemini
11.2020 - 12.2021
B. Tech - Mechanical Engineering
ITER, Siksha 'O' Anusandhan University
Similar Profiles
Mithilesh KUMARMithilesh KUMAR
QA Leads – GE at CapgeminiQA Leads – GE at Capgemini
Tamaghna BanerjeeTamaghna Banerjee
Senior Data Engineer at CAPGEMINISenior Data Engineer at CAPGEMINI
RUBINA JAMADARRUBINA JAMADAR
Senior Software Consultant at CapgeminiSenior Software Consultant at Capgemini
Rupal MalviRupal Malvi
Azure Data Analyst at CapgeminiAzure Data Analyst at Capgemini
Kartikey PandeyKartikey Pandey
Curriculum Developer - Logical Reasoning & Mathematics at Kidway Education Pvt. Ltd.Curriculum Developer - Logical Reasoning & Mathematics at Kidway Education Pvt. Ltd.