Power Bi Data Engineer

Mark Johnson

****************@*****.*** — +91-737*******

D-10, Sukhwani Residency, Dapodi, Pune

SUMMARY

Motivated Data Engineer with solid experience building Power BI dashboards, developing ETL pipelines, and crafting optimized DAX calculations. Adept at SQL, Power Query, Python, and data visualization tools such as Power BI and Tableau. Proven ability to support data-driven decision-making through effective business intelligence solutions. Holds MCA and B.Sc. degrees in Computer Science.

PROFESSIONAL EXPERIENCE

Gamaka AI, Pune

Data Engineer Feb 2024 – Feb 2025

• Designed ETL pipelines to feed Power BI dashboards, enabling daily and monthly business reporting.

• Created and optimized Power BI data models, calculated DAX measures, and built interactive dashboards.

• Automated data refresh processes and ensured data consistency through validation checks.

• Collaborated with analysts to translate business requirements into effective visualizations.

• Worked with Azure SQL Database and Power Query for efficient data extraction and transformation. Zeza, Mumbai

Data Engineer Mar 2025 – Jun 2025

• Built data models and interactive reports in Power BI for internal sales and operations teams.

• Developed SQL scripts to extract and transform data from APIs and internal databases.

• Conducted performance tuning for DAX calculations and visual load times.

• Delivered weekly dashboard updates to stakeholders, improving decision-making timelines. TECHNICAL SKILLS

• Languages/Frameworks: Python, Django, SQL, HTML, CSS, JavaScript, React.js

• Visualization: Power BI, Tableau, Qlik Sense

• Tools: DAX, Power Query, Azure SQL, Excel

• Concepts: ETL, Data Modeling, SDLC, Reporting Automation PROJECTS

Skoda O&C Dashboard – Operations & Commercial Performance Power BI, DAX, Azure SQL, Power Query, Excel

• Developed a dashboard to track Daily, MTD, and YTD Margin Performance across brand and segment.

• Implemented dynamic slicers and optimized data models for multi-level analysis.

• Automated data refresh cycles and built DAX KPIs like Daily/Cumulative Margin and Segment-wise Contribution. Audi Aftersales FC-1 Dashboard

Power BI, DAX, Excel, Azure SQL

• Built visualizations to monitor field complaints across zones, dealers, and vehicle models.

• Enabled filtering by complaint type, resolution status, and time metrics like TAT and closure rates.

• Helped service teams isolate problem areas with root cause drill-downs. Adventure Works Sales Analysis

Power BI, DAX, SQL Server, Excel

• Identified top products and regions contributing to sales.

• Analyzed customer churn and underperforming categories.

• Suggested bundling and targeting strategies to enhance revenue. CERTIFICATIONS

• Full Stack Python – CJC Institute

• Gamaka AI – Data Science Training

EDUCATION

MCA, ASM IBMR, Chinchwad 2024

CGPA: 7.1

B.Sc. (Computer Science), MMCC, Shivajinagar 2022

CGPA: 7.5

12th (Science), Vidhya Bhavan, Shivajinagar 2019

Percentage: 56%

10th, MIS 2017

Percentage: 71%

PERSONAL DETAILS

• Date of Birth: 25 Jan 2002

• Languages: English, Hindi, Marathi, Malayalam

• Hobbies: Football, Guitar, Running

Contact this candidate