Mahesh Padalkar
Manufacturing Business Analyst
Pune,MH
Overview
5
5
years of professional experience
5
5
Years of Education
Work History
Business Analyst - Projects Specialist
Franklin Electric Remote
12.2021 - Current
- Coordinated quality activities in new projects, conducted gap analysis, identified quality requirements, and performed risk analysis
- Prepared weekly and monthly warranty reports, including trend and pareto analysis for top field failures
- Analyzed customer warranty for responsibility, reason, cost, and resolution
- Boosted production efficiency by 20% through Power BI dashboards, leading to significant cost savings
- Designed and implemented Power BI dashboards resulting in 25% increase in data accessibility and improved decision making
- Created interactive Power BI dashboards with 95% user adoption, leading to 20% increase in data-driven decision making
- Collaborated with cross-functional teams to develop customized Power BI solutions, improving data accuracy and insights by 75%
- Implemented advanced data modeling techniques in Power BI to improve data accuracy by 75%, leading to more reliable and efficient reporting for the company.
- Bridged communication gaps between technical and non-technical stakeholders by translating complex data concepts into easily understood terms, fostering a shared understanding of project goals and objectives.
- Evaluated the success of implemented BI strategies through rigorous post-implementation analysis, ensuring alignment with business objectives.
- Delivered customized training sessions to end-users on BI tool usage, enhancing adoption rates across the organization.
- Developed robust SQL scripts to extract relevant information from large datasets quickly and accurately, expediting ad hoc report requests.
- Reduced report turnaround times by automating manual procedures through the implementation of efficient ETL workflows.
- Managed complex BI projects from inception to completion, consistently delivering high-quality results within budgetary constraints and strict timelines.
- Evaluated vendor offerings for BI solutions, conducting thorough assessments of product functionality, scalability, and cost-effectiveness to make informed recommendations for purchase decisions.
- Led cross-functional team to launch new product, exceeding initial sales forecasts.
Mechanical Intern
KSB Ltd
Pune Pune, Maharashtra
12.2019 - 01.2020
- Assisted in the collection and interpretation of Pump data from manufacturing equipment, providing valuable insights for predictive maintenance and reducing downtime by 15%
- Conducted comprehensive failure analysis on a defective component, pinpointing the root cause through rigorous testing and data analysis, resulting in a 50% decline in equipment failures and significant cost savings for the company
- Investigated and diagnosed the root cause of a faulty component, leveraging advanced analytical techniques and collaborating with cross-functional teams, leading to the successful implementation of a solution that reduced equipment failures by 50% and improved operational efficiency.
Education
Bachelor of Mechanical Engineering - Mechanical, Supply - Chain , ERP
Bharati Vidyapeeth’s College of Engineering
Pune 06.2018 - 05.2021
Diploma - Mechanical Engineering
Institute of Civil And Rural Engineering
Aug 2018
Skills
- Technical Skills
- Programming Languages:
- SQL, Python, Basics of C/C
- Power BI: Data analytics, Importing data, Manipulating data, Data modeling in the query editor, Table
- Relationships and Data Analysis Expressions (DAX), Building data visualizations and reports
- Databases: SQL Server 2014, SSAS, Access database, Power BI database, Excel spreadsheets, Ofeed, Azure data
- Services
- Manufacturing Processes: Lean manufacturing, 6 Sigma, Kanban, Just-in-time (JIT), Quality control (QC)
- Production planning, Supply chain management (SCM), OEE, FPY, Defect rate, Downtime analysis, RCA
- Manufacturing Metrics: Production volume, Unit cost, Labor productivity, Machine utilization, Scrap rate, OTD
- CSAT, ROI, Cost savings, Lead time reduction
- BI Tools Technologies: Power BI, Tableau, SAP Analytics Cloud, QlikView, Microsoft Power BI Desktop
- Microsoft Excel, SQL, Python, R, Data warehousing, Data visualization, Data mining, Machine learning, Predictive
- Analytics
- Soft Skills: Communication, Analytical Thinking, Problem-Solving, Attention to Detail, Time Management
- Collaboration and Teamwork, Adaptability, Customer Focus, Emotional Intelligence, Leadership
- Certifications
- LinkedIn Learning: Data-Driven Decisions With Power BI, Tableau for Beginners, 6 Sigma-Green Belt
- Skill UP: Business Analytics with Excel
- Projects
Accomplishments
- Power BI Live Dashboard
- Developed a Quality Metrics live dashboard - Implemented a dynamic and interactive Power BI live dashboard to monitor and analyze key quality metrics
- Established Manufacturing operations dashboard - Given operations and accounts teams the ability to centrally analyze general ledger, procurement, order fulfillment, and deliveries of manufactured goods
- Designed Production metrics live dashboard - Electronics and electromechanics
- Oracle ERP pick tickets - We can get direct information about expired products and pick ticktes
- Power APP
- I have helped develop an app for IGBT data entry using Power Apps
- This app facilitates selecting the right product after entering data from a SharePoint database
Summary
Personable and highly adaptable, bringing strong analytical abilities and collaborative spirit. Proficient in data analysis and project management, with solid grasp of industry-specific software. Committed to driving impactful results and contributing to team success. Developed versatile skill set in fast-paced, collaborative environment, seeking to transition into new field. Expertise in data analysis and process optimization, with talent for problem-solving and strategic planning. Eager to leverage these transferable skills to contribute effectively in new role. Offering solid foundation in problem-solving and teamwork, eager to learn and develop in professional environment. Contributes keen ability to quickly grasp new concepts and apply them effectively in practical situations. Ready to use and develop analytical and project management skills in [Desired Position] role.
Timeline
Business Analyst - Projects Specialist
Franklin Electric Remote
12.2021 - Current
Mechanical Intern
KSB Ltd
12.2019 - 01.2020
Bachelor of Mechanical Engineering - Mechanical, Supply - Chain , ERP
Bharati Vidyapeeth’s College of Engineering
06.2018 - 05.2021
Diploma - Mechanical Engineering
Institute of Civil And Rural Engineering
Similar Profiles
Max HeislerMax Heisler
Mechanical Engineering Technician Intern at Franklin ElectricMechanical Engineering Technician Intern at Franklin Electric
Lucas ConleyLucas Conley
Quality Technician at Franklin ElectricQuality Technician at Franklin Electric
Patrick KekanaPatrick Kekana
HSE & Quality Manager at Franklin Electric South Africa (Pty) LtdHSE & Quality Manager at Franklin Electric South Africa (Pty) Ltd
SHUBHAM CHAUDHARISHUBHAM CHAUDHARI
Sales Manager at Square Yards Real EstateSales Manager at Square Yards Real Estate
Milind PatilMilind Patil
Senior Software Engineer at Netcracker Technology SolutionsSenior Software Engineer at Netcracker Technology Solutions