Nikhil Khapekar
POWER BI DEVELOPER
099******** ******************@*****.*** www.linkedin.com/in/nikhilkhapekar1107 I am results-oriented Power BI developer with a strong passion for leveraging data to empower organizations and drive strategic decision-making. Overall, I have 8.8 years of experience and with 5.1 years of hands-on experience in data visualization and business intelligence. Also, I have 3 years of experience as a stakeholder management. By understanding needs, communicating clearly, managing expectations, and incorporating feedback, I ensure the successful delivery of reporting and analytics solutions that precisely align with stakeholder requirements. Work Experience
Power BI Developer – ZedVenture, Inc Work From Home April.2024 – Jan 2025 Environments: Power BI, Azure SQL Database, DAX, Power Query, Data Integration, SSAS, Performance Optimization, ETL
• Monitor and optimize HR mobility services by tracking employee engagement, satisfaction, and expenses across Advantage, relocation activities, compensation adjustments, and talent development.
• Streamline and enhance the employee relocation journey with end-to-end tracking and support: from departure assistance and immigration process monitoring to destination integration and counseling services.
• The analysis of home and mortgage services focuses on key metrics such as success rates in home buying and selling, property management activities, temporary accommodation usage, transaction times, satisfaction, costs, and loan amounts.
• Enable users to filter data by department, region, or employee type, with intuitive charts, maps, and KPIs. Customize reports based on relocation type or expense category to meet specific business needs.
• Tracked KPIs and developed automated reports, providing real-time information to stakeholders.
• Collaborated with cross-functional teams, gathering requirements and tailoring solutions to meet their needs. Power BI Developer – Nsemble.AI Nagpur, India Jan.2020 – March 2024 FMCG Power BI Report
Environments: Power BI, PostgreySQL, DAX, Power Query, Data Integration, Performance Optimization, Alteryx, Stakeholder Management, SSAS, Data Transformation & Cleaning, Data Modelling, Star Schema.
• Led FMCG Power BI project, enhancing data analysis and decision-making processes.
• Integrated and transformed diverse data sources for accuracy and consistency.
• Designed a robust data model, facilitating efficient data aggregation and navigation.
• Created intuitive dashboards, reports, and visualizations for effective communication of insights.
• Tracked KPIs and developed automated reports, providing real-time information to stakeholders.
• Collaborated with cross-functional teams, gathering requirements and tailoring solutions to meet their needs. Chemical Industry Report
Environments: Power BI, SQL Server, SSAS, DAX, Power Query, Data Integration, Performance Optimization, Stakeholder Management, Data Transformation & Cleaning, ETL, Data Modelling & Analysis, Power Automate
• Led Chemical Industry Power BI project, actively involved in data collection and analysis.
• Utilized skills in data analysis, visualization design, and data modeling to derive insights.
• Developed interactive dashboards and reports using Power BI, presenting data in a user-friendly manner.
• Project had a substantial impact, leading to improved efficiency, cost reduction, and enhanced decision-making in the chemical industry.
• Proficient in additional tools such as SQL and Python for data manipulation.
• Project experience provided valuable insights into the chemical industry and strengthened data analysis skills. Pharma Industry
Environments: Power BI, Oracle, DAX, Power Query, Data Integration, Performance Optimization, Stakeholder Management, Data Transformation & Cleaning, Data Modelling & Analysis, ETL, Custom Visuals (Charticulator)
• Managed stakeholder communication, aligning Power BI solutions with business objectives.
• Extract, clean, and transform data from various sources (SQL, Excel, cloud storage) for reporting.
• Design and optimize data models using relationships, DAX calculations, and star schema for efficient performance.
• Develop interactive Power BI reports and dashboards with advanced visualizations, slicers, and drill-through.
• Publish reports to Power BI Service, configure scheduled refreshes, and set up data gateways for on-premise sources.
• Proficient in Power BI, data modeling, and visualization, with a focus on analyzing financial data.
• Integrated multiple data sources and transformed data to create insightful visualizations.
• Improved decision-making processes, leading to increased revenue and reduced costs.
• Collaborated effectively with stakeholders, including business analysts and senior management. Steel Manufacturing Company
Environments: Power BI, SQL Server, SSAS, DAX, Power Query, Data Integration, Performance Optimization, Stakeholder Management, Data Transformation & Cleaning, Data Modelling & Analysis, ETL, Python Visuals
• Stakeholder Communication – Aligned Power BI solutions with business goals.
• Data Processing – Extracted, cleaned, and transformed data from multiple sources.
• Data Modelling – Designed optimized models with DAX and star schema.
• Report Development – Built interactive Power BI dashboards with advanced visuals
• Deployment & Maintenance – Published reports, scheduled refreshes, and managed data gateways.
• Designed and implemented a comprehensive data integration and ETL pipeline solution for an enterprise-wide analytics initiative.
• Extracted data from various sources, transformed it to meet business requirements, and loaded it into a cloud-based data warehouse.
• Developed complex SQL transformations and data manipulation logic for standardization and cleansing.
• Created comprehensive documentation and presented project updates to management.
• Demonstrated the impact of the project on operational efficiency and data-driven decision-making. Design Engineer - Tecosim Engineering Services Pvt. Ltd Pune, India Dec.2017-Nov.2019
• Design Engineering A-surface as per Environment Data considering part design guidelines.
• Providing Attachment features, strengthening feature to Plastic part (ribs, bosses, locators).
• Snap deflection study, locator study for first point contact for part fixing. Design Engineer - Prolific Corporate It Services Pvt. Ltd Pune, India May.2016-Nov.2017
• Making Draft Analysis, tooling and clash analysis reports.
• Maintaining proper gap & flush with respect to the surrounding parts, Generating parting surface & parting lines.
• Generating Smooth A-surface for Foam as per comfort curves and STO. SKILLS
Power BI Power BI Service Power Automate
DAX (Data Analytics Expression) Alteryx SQL
Python Tableau MySQL
PostgreSQL Data Integration Optimizing Performance Azure SQL Server Azure Database Azure Data Lake
Stakeholder Management Data Modeling & Analysis Data Transformation & Cleansing Report & Dashboard Development ETL (Extract, Transform & Load) Power Query/ M-Query Development SSAS Power BI Gateway SSIS
Education
Rashtrasant Tukadoji Maharaj Nagpur University Nagpur, India July.2010 – June.2014 B.E. IN MECHANICAL ENGINEERING
Percentage: 61.5
Kamla Nehru Mahavidyalaya Nagpur, India July.2008 – May.2010 SENIOR SECONDARY EXAMINATION-CLASS XII (STATE BOARD) Percentage: 59.60