Mukesh Kumar Sao
Longueuil,QC
Summary
Accomplished Data Analyst with a proven track record at Cyient Limited, excelling in Power BI dashboards development and data modeling. Demonstrated leadership in driving data-driven solutions and enhancing operational efficiency for Pratt and Whitney Canada. Skilled in SQL and adept at fostering team collaboration, significantly improving data visualization and business insights.
Overview
7
7
years of professional experience
Work History
Onsite Coordinator- Lead Data Analyst
Cyient Canada inc.
08.2022 - Current
- Company Overview: Client: Pratt and Whitney Canada
- Providing insight in the business by analyzing the data and publishing it across the value stream
- Understand Customer/Business Requirement and Provide a solution by providing insights and Opportunities
- Conducting weekly stand up meetings with Flow and producibility focus team along with other stakeholders for P&WC to align on business priorities and address challenges
- Periodic interaction with producibility focus and Flow team onsite to ensure all actions are integrated into the overall plan for achieving the operational objectives as defined in the scorecards
- Managing all data related to various dashboards developed in previous Years as a part of STO transformation and data analytics project
- Expanding the scope of dashboards as required to collaborate with other organization involved in QN value stream
- Worked on SQL , Hadoop Datalake integration with powerbi Dashboard to enable seamless data ingestion and storage for large datasets.
- Collaboration with DXC team to integrate hadoop data lake with databreaks, facilitating realtime data processing and analytics.
- Data modelling to translate complex data into clear business narative.
- Client: Pratt and Whitney Canada
Data Analyst and Power Bi Visualization
Cyient Limited
11.2017 - 08.2022
- Company Overview: Client: Pratt and Whitney Canada, Bangalore
- Involved in Dashboards developments in STO Projects
- Priority QN(All Shortage) Dashboard: which tracks all the priority QNs and QNs turnaround time and other info
- Responsible to prioritize the QNs based on shortage meeting and requests from IMF in Dashboard
- Master QN Dashboard: Which tracks important KPIs like QNS routed to engineering, all engineering department performance, Turnaround time of QNs
- Development of Weekly newsletter and organizing a meeting for discussion of the top bottle necks in the QN coordination flow
- Providing insight in the business by analyzing the data and publishing it across the value stream
- Refreshing and maintaining all developed STO PowerBI Dashboards by updating latest source files
- Analyze the historic dispositions and coming up with the actions to improve the flow efficiency by reducing the shuttling of QN between Quality and Engineering
- Automating tasks to reduce manual intervention, mistake proof and increase productivity savings
- Improving the process efficiency by identifying the areas of improvement and proposing the solutions
- Calculating turnaround time (TAT) for QN turnaround time calculations
- Developing Scripts in VBA for automating the tasks
- Developed interactive dashboards for seamless sharing of priority information using PowerBI
- Client: Pratt and Whitney Canada, Bangalore
Education
Bachelor Degree - Mechanical Engineering
Lovely Professional University
Jalandhar, Punjab01.2017
Skills
- Power BI Dashboards Development and visualization
- Data modeling
- Data transformations
- DAX language
- Visualization
- Haddop Datalake
- SQL
- Python basics for statical analysis
- Problem solving
- Advanced excel
- Multi-tasking
- Leadership
- Communication Skills
- Gas turbine engine, catia, solid works
Languages
English
Full Professional
Accomplishments
- Design and analytical support for PWC developmental aero engine components
- Addressed 500+ quality notifications on aero engine parts
- Coordinated Priority and Line stop QNs with 90% OTD
- Developed Power BI Dashboards for performance monitoring
- Created productivity improvement tools
- Provided business insights through data analysis
- Automated report generation with VBA macros
Summary
6+ year of experience at Pratt and Whitney Canada Centre of Excellence, Cyient Ltd, includes 2+ year in onsite experience under Support to Operations Group.Result-driven Data analyst with experience-in leveraging data to drive business decisions and improve operational efficiency. Proficient in power bi , visuals.data insights, data lake, business insights, dedicated to enhancing data quality and supporting cross functional teams in achieving strategic objectives.
Personal Information
- Passport Number: R7146482
- Father's Name: Rajkumar Sao
- Mother's Name: Jayanti Sao
- Date of Birth: 06/12/95
- Nationality: Indian
- Marital Status: Single
Timeline
Onsite Coordinator- Lead Data Analyst
Cyient Canada inc.
08.2022 - Current
Data Analyst and Power Bi Visualization
Cyient Limited
11.2017 - 08.2022
Bachelor Degree - Mechanical Engineering
Lovely Professional University
Similar Profiles
GOPICHAND SINGH BUDHATHOKIGOPICHAND SINGH BUDHATHOKI
Field Technician (telecommunication) at CYIENT CANADA INC.Field Technician (telecommunication) at CYIENT CANADA INC.
Bharat KhotBharat Khot
Onsite Coordinator at Client: Pratt & Whitney Canada (Cyient Canada INC)Onsite Coordinator at Client: Pratt & Whitney Canada (Cyient Canada INC)
Jegan Arumugam ChandrasekaranJegan Arumugam Chandrasekaran
Senior Project Manager– PMO at Cyient LtdSenior Project Manager– PMO at Cyient Ltd