Summary
Overview
Work History
Education
Skills
References
Timeline
Generic
KARISHMA PAWAR

KARISHMA PAWAR

Pune,India

Summary

Power BI Expert with over 6 years of experience in developing insightful reports and dashboards utilizing advanced DAX and MySQL. Proven ability to transform complex data into actionable insights that drive business decisions. Seeking to leverage analytical skills in a dynamic organization focused on data-driven strategies.

Overview

9
9
years of professional experience

Work History

Power BI Developer

Northcott
Sydney
02.2023 - 04.2024
  • Created dashboard reports using DAX, time series analysis, and KPI metrics in Power BI Desktop.
  • Troubleshot existing Power BI report issues with SQL queries to enhance functionality.
  • Developed performance-focused Power BI dashboards emphasizing standards and testability.
  • Maintained Jira boards for project tasks, ensuring workflow efficiency and collaboration.
  • Facilitated seamless data migration by configuring systems and conducting post-migration testing.
  • Utilized SQL for data extraction, manipulation, and analysis to support accurate reporting.
  • Transformed data through Power BI's Query Editor to optimize ETL processes for reporting datasets.
  • Designed and managed MySQL databases to ensure data accuracy and reliability across projects.

Technical Lead

HCL Technologies
04.2022 - 12.2022
  • Extracted data from multiple sources into Power BI desktop for analysis.
  • Migrated customer SSRS and COGNOS reports to Power BI for improved reporting.
  • Created DAX queries and generated computed columns in Power BI.
  • Developed computed tables using DAX to enhance data modeling.
  • Published reports and dashboards in Power BI to facilitate decision-making.
  • Scheduled and monitored jobs in BMC Control-M for efficient workflow management.
  • Managed Azure APP services, ensuring optimal performance and availability.
  • Provided mentorship on development activities and promoted continuous learning.

Engineer

Cyient
04.2019 - 03.2022
  • Designed and developed Power BI dashboards while maintaining business intelligence reports.
  • Migrated customer reports from Excel and CSV formats to Power BI using SAP HANA.
  • Prepared weekly, monthly, and daily reports utilizing Power BI features.
  • Demonstrated expertise in DAX, Power Query, and data modeling techniques.
  • Created visual dashboards and scorecards for Production and Quality departments.
  • Utilized DAX functions including aggregation, count, calculate, related, and date functions.
  • Executed filter creation, quick filters, table calculations, calculated measures, and parameters in Power BI.
  • Published Power BI reports for organizational use and made dashboards accessible via web clients.

Engineer

Cadtech Engineering Solutions PVT.LTD.
04.2018 - 04.2019
  • Followed up on quality issues with suppliers to ensure timely resolution.
  • Assisted suppliers with quality-related concerns, reporting root causes and corrective actions.
  • Conducted supplier visits as necessary to evaluate compliance with quality standards.
  • Reviewed and prepared PPAP documentation according to DPAR and John Deere specifications.
  • Approved supplier submissions while managing follow-ups for PPAP rejections and resubmissions.
  • Developed quality tools such as Control Plans, SPC, MSA, and PFMEA per design requirements.
  • Prepared PFMEA for welding processes, assigning appropriate risk levels for each task.
  • Created Weld Map (WIAT) to facilitate weld inspectors in documenting defects directly in SAP.

Engineer

Imperial Auto Industry
12.2016 - 12.2017
  • Conducted monthly internal and product audits, reporting findings to relevant stakeholders.
  • Utilized SPC data to identify out-of-control conditions and assess supplier capability.
  • Participated in customer quality audits, addressing findings with prompt responses.
  • Prepared 8D Reports and collaborated with customers on corrective and preventive actions.
  • Demonstrated expertise in APQP processes and development phases.
  • Monitored monthly ppm metrics and performed root cause analysis for continuous improvement.

Engineer

Reliable Engineering
01.2015 - 12.2016
  • Coordinated manpower planning and arrangement for optimal workflow efficiency.
  • Conducted in-process, incoming, and final inspections to ensure quality standards.
  • Updated daily check sheets based on rejection concerns related to firewall and customer feedback.
  • Developed standard operating procedures (SOPs) aligned with process validation reports.

Education

Bachelor of Engineering -

University of Pune - Sinhgad College of Engineering
Pune
05.2015

Skills

  • Power BI and Power Query
  • Dashboard publishing
  • Data modeling
  • Project management
  • DAX calculations and functions
  • MySQL database management
  • Data warehousing
  • Data cleansing

References

References available upon request.

Timeline

Power BI Developer

Northcott
02.2023 - 04.2024

Technical Lead

HCL Technologies
04.2022 - 12.2022

Engineer

Cyient
04.2019 - 03.2022

Engineer

Cadtech Engineering Solutions PVT.LTD.
04.2018 - 04.2019

Engineer

Imperial Auto Industry
12.2016 - 12.2017

Engineer

Reliable Engineering
01.2015 - 12.2016

Bachelor of Engineering -

University of Pune - Sinhgad College of Engineering
KARISHMA PAWAR