FAIYYAJ MUKADAM
Data Analyst and MIS Reporting Specialist
Pune,Maharashtra
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
*Over 5 years of hands-on experience with Power BI, including Power Query, *Power BI Desktop, and Power BI Services.
*More than 11 years of experience in MIS reporting, data analysis, and providing insights tailored to management requirements.
*11+ years of expertise in performance management.
*Over 11 years of experience working with advanced Excel tools and formulas.
*Over 1 year of experience in integrating Power Automate and Power Apps with SharePoint.
Overview
13
13
years of professional experience
4
4
Certifications
Work History
Engineering Coordinator
Magna International
Pune
12.2022 - Current
- Company Overview: Magna Electronics
- Collaborated with the Global Capacity Management Team to oversee site-level and country-level capacity planning
- Partnered with the Global Infrastructure and Program Management Teams to forecast budgets and allocate funds for key competencies and programs
- Coordinated with Finance, Facility, and Procurement departments to present site-level KPIs for specific departments
- Developed Power BI reports for tracking resource planning in alignment with project requirements
- Managed contract resource headcount in accordance with project needs and budget constraints
- Created multiple KPI reports and Power BI dashboards tailored to management's requirements
- Coordinated with European and US teams to gather project-related information for KPI reporting
- Monitored project efforts using SAP and Power BI dashboards
- Integrated Power BI with SharePoint to enhance visualization and consolidate all reports in a single location
- Magna Electronics
Sales Performance Management: Sr Executive
Bajaj Allianz Life Insurance Company
Pune
07.2021 - 08.2022
- Created MIS reports for management
- Developed and maintained incentive and goal sheet calculations in Excel, providing daily, weekly, and monthly updates for a sales team of over 5,000 members
- Calculated final incentive payouts in Excel and managed the monthly and quarterly disbursements for the sales team
- Prepared annual and semi-annual goal sheets to track sales performance and determine promotions based on results
- Shared performance insights and achievements with the Sales Administration and Center of Excellence (COE) teams
Senior Executive
MD India Health Insurance TPA Pvt Ltd
Pune
01.2019 - 07.2021
- Prepared claims tracking reports in Excel, categorized by insurance company and region, and created various MIS reports for management
- Managed the Operational Support Team
- Developed daily, weekly, and monthly data trackers to monitor the performance of the claims processing team
- Created production and attendance trackers for different teams, utilizing Power BI and Power Query for enhanced visualization and data insights
Senior Officer
Jana Small Finance Bank
Pune
02.2018 - 12.2018
- As part of the MIS team, produced various reports for management
- Generated daily, weekly, and monthly reports on collections received and pending, according to management requirements
- Processed and uploaded data to the dialer, optimizing it for the calling team
- Managed shift assignments and tracked attendance
Freelance MIS-Operational Support
HIM Coding Experts, SMD Healthcare Kaalikai Industries Ltd, Chate Coaching Classes, Reliance DSA- (Swati Enterprises)
Pune
04.2012 - 12.2017
- Developed a data repository to organize customer inquiries, invoices, and complaints
- Created automated Excel formats using Power Query and advanced formulas for tracking revenue, tax calculations, student scorecards, and sales executive performance
- Supported the creation of inventory formats for assets and infrastructure items
- Prepared reports to display monthly and yearly revenue, as well as profit and loss statements
- Designed trackers for attendance, monthly sales, and new admissions
Education
MBA - Project Management
Dr DY Patil Vidyapeeth Pune.
06.2024 - Current
Bachelor of Science - Chemistry
Shivaji University
04.2001 -
Skills
Advanced Excel
Budget Management
Capacity Management
Resource Management
Power Apps
SharePoint-Lists
Cost reduction
Power Automate
MS Office
MYSQL
SQL
Power Query
Power BI Services
Power BI Desktop
User Acceptance Testing (UAT) for Sales Performance Management Automation Projects
Data Analysis
Personal Information
Date of Birth: 02/18/93
Certification
Premiership In Business Management
Timeline
Premiership In Business Management
01-2025
Project Management Assessment
12-2024
Scrum Master Assessment
11-2024
Lean Six Sigma Green Belt
08-2024
MBA - Project Management
Dr DY Patil Vidyapeeth Pune.
06.2024 - Current
Engineering Coordinator
Magna International
12.2022 - Current
Sales Performance Management: Sr Executive
Bajaj Allianz Life Insurance Company
07.2021 - 08.2022
Senior Executive
MD India Health Insurance TPA Pvt Ltd
01.2019 - 07.2021
Senior Officer
Jana Small Finance Bank
02.2018 - 12.2018
Freelance MIS-Operational Support
HIM Coding Experts, SMD Healthcare Kaalikai Industries Ltd, Chate Coaching Classes, Reliance DSA- (Swati Enterprises)
04.2012 - 12.2017
Bachelor of Science - Chemistry
Shivaji University
04.2001 -
Similar Profiles
Justin JordanJustin Jordan
Lead Production Worker at Magna InternationalLead Production Worker at Magna International
Bradley BennettBradley Bennett
Journeyman Toolmaker at Magna InternationalJourneyman Toolmaker at Magna International
Jonathan PerryJonathan Perry
Process Engineer at Magna InternationalProcess Engineer at Magna International