Power BI
Mahesh S. Jyotik
Pune
Summary
Detail-oriented Pricing Analyst with a background in deploying pricing processes and developing insightful Power BI dashboards. Experienced in implementing value-based SaaS pricing models and analyzing transactional pricing to drive strategic decision-making. Proven ability to support sales organizations with effective price management and maintain data integrity, delivering actionable insights that enhance financial and operational performance.
Overview
10
10
years of professional experience
7
7
years of post-secondary education
Work History
Business Analyst II
Johnson Controls India PVT Ltd
11.2021 - Current
- Implement pricing-related processes, guidelines, and reporting mechanisms to achieve financial and operational objectives
- Lead a team in designing Power App solutions for efficient pricing workflows
- Collaborate with leadership as a Pricing Analyst to implement a new value-based SaaS pricing model, including validation, UAT testing, and active participation in model development
- Create various pricing and financial dashboards using Power BI and SQL to support informed business decision-making
- Design backend databases, front-end user interfaces, and logical layers according to Power Platform business requirements
- Engage in transactional pricing and DOA processes by reviewing, analyzing, and providing actionable recommendations
- Manage weekly and monthly data refreshes for Pricing Datalake requirements
- Develop tools for analyzing deal performance, focusing on win/loss analysis, pricing trends, and profitability
Associate Pricing Analyst
Eaton Technologies Pvt. Ltd
08.2016 - 10.2021
- Provide support to country sales organizations in component-based price management for designated regions, including pricing approvals, contract quotes, and requests
- Calculate price quotations, trigger discount prices, and establish pricing guidelines
- Analyze deal performance through win/loss analysis, pricing trends, and profitability assessments, generating reports and dashboards to deliver insights and recommendations to senior management
- Assist in projects and programs related to price and quote management, coordinating efforts across cross-functional teams
- Maintain and manage quotes, contracts, pricing structures, and price lists across various databases, addressing data integrity issues as they arise (e.g., incorrect prices, discounts, quotes)
- Developed a dashboard to track request trends and associated win rates
- Generate monthly reports in Power BI to showcase team performance and Greenline scores
- Created Power BI dashboards to visualize win/loss performance by region and product division
Sales – Coordinator
AESSEAL India Pvt. Ltd.
02.2016 - 07.2016
- Assisting the sales team with administrative tasks such as preparing proposals, quotes, and contracts
- Coordinating sales meetings and events, including scheduling, logistics, and materials preparation
- Communicating with customers to provide information, support, and follow-up on sales activities
- Maintaining and updating sales records and customer databases
- Generating sales reports and analyzing sales data to identify trends and opportunities
- Coordinating with other departments, such as marketing and logistics, to support sales activities
- Providing administrative support to the sales team, such as managing calendars and travel arrangements
Trainee Engineer
Cleantech Systems Pvt. Ltd
12.2014 - 08.2015
- Identifying potential suppliers and researching their products and services
- Negotiating prices, contracts, and terms with suppliers to ensure the best value for the company
- Project Management oversees project workflow and supports internal and external resources to ensure timely delivery of the project’s expected quality and allotted budget
- Developing and implementing purchasing strategies to optimize costs and increase efficiency
- Facing ISO audit for Purchase Department
Education
Master of Business Administration (MBA) - Supply Chain Management
Pune University
01.2016 - 01.2018
Bachelor of Engineering (B.E.) - Mechanical Engineering
Pune University
01.2010 - 01.2015
Skills
Pricing Process Implementation
Data Visualization and Analysis
Database Design
Reporting and Insights
Value-Based SASS Pricing Implementation
Cross-Functional Project Support
Team Leadership
Problem-solving
Requirements gathering
Analytical thinking
Project management
Accomplishments
- Successfully Automated Customer Change order management process at Johnson Controls by implementing the Power Automate platform.
- Completed Business Process Improvement [BPI] for two processes and completed the FMEA Project for the TF UK Site at Eaton.
- Received award for KAIZEN and FMEA project on the TF UK process in Eaton.
- Successfully restructured the order management process in AESSEAL India Pvt. Ltd.
Personal Information
- Date of Birth: 01/01/92
- Gender: Male
- Marital Status: Married
Software
Power Platform
SQL
Advance Excel
Python
Work Preference
Work Type
Full TimeLocation Preference
On-SiteRemoteHybridImportant To Me
Company CultureWork-life balanceCareer advancementLanguages
English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)
Marathi
Bilingual or Proficient (C2)
Timeline
Business Analyst II
Johnson Controls India PVT Ltd
11.2021 - Current
Associate Pricing Analyst
Eaton Technologies Pvt. Ltd
08.2016 - 10.2021
Sales – Coordinator
AESSEAL India Pvt. Ltd.
02.2016 - 07.2016
Master of Business Administration (MBA) - Supply Chain Management
Pune University
01.2016 - 01.2018
Trainee Engineer
Cleantech Systems Pvt. Ltd
12.2014 - 08.2015
Bachelor of Engineering (B.E.) - Mechanical Engineering
Pune University
01.2010 - 01.2015