Chaitanya Bhalerao
The way to get started is to quit talking and begin doing.
Walt Disney
Summary
Results-driven professional with expertise in budgeting, CRM, and data analytics, dedicated to enhancing business growth and operational efficiency. Demonstrated success in cost analysis, pricing strategies, and data-driven decision-making that significantly improves profitability. Proficient in Power BI, Python, SQL, and Advanced Excel for effective data visualization and financial modeling. Strong collaborator with cross-functional teams to optimize customer relationships and streamline workflows through strategic planning and automation.
Overview
5
5
years of professional experience
7
7
Certificate
Work History
ASSISTANT MANAGER
Vishalfab India Private Limited
07.2024 - Current
- Analyzed RFQs, RFPs, and RFIs, preparing competitive quotations by evaluating raw material costs, process costs, and market trends, ensuring data-driven decision-making.
- Conducted data analysis to optimize pricing strategies, improving RFQ to PO conversion rates by 20-30%.
- Collaborated with cross-functional teams (Engineering, Finance, and Supply Chain) to improve cost estimation models and streamline supply chain analytics.
- Provided commercial analysis and insights to support project delivery and bid submissions, proactively identifying risks and opportunities to enhance commercial performance.
- Developed automated reporting systems to track marketing KPIs and customer engagement metrics, reducing manual reporting time by 30% and enabling faster decision-making.
DATA ANALYST
Vishalfab India Private Limited
Indore
12.2022 - 07.2024
- Analyzed data and used statistical models to forecast copper demand, reducing inventory costs by 20% and improving on-time delivery by 15%, while collaborating with sales and production teams.
- Designed and deployed Power BI dashboards integrating data from SQL databases, cloud services, and APIs, improving decision-making speed and efficiency by 30%.
- Enhanced Customer Relationship Management by providing timely and data-driven quotations, leading to a 20-30% increase in RFQ to PO conversion rate.
- Designed and implemented interactive Power BI dashboards to monitor key performance indicators (KPIs) across production, inventory, and sales, improving decision-making speed and accuracy.
- Conducted workshops and training sessions for non-technical staff on data analytics and data-driven decision-making.
Financial Analyst
XL Dynamics India Private Limited
09.2020 - 08.2022
- Analyzed loan applications, financial statements, and credit risk to assess borrower eligibility, ensuring compliance with Fannie Mae, Freddie Mac, and FHA guidelines.
- Implemented ELT pipelines using SQL, optimizing data ingestion and transformation for real-time mortgage analytics.
- Extracted and cleaned large financial datasets from MySQL databases, ensuring data integrity for reporting and decision-making.
- Developed complex SQL queries in MySQL database servers to support ad-hoc reporting, financial analysis, and mortgage risk assessments.
- Worked on 200+ BI automation reports with various stakeholders, internal departments and investors on report business requirements, documentation, timelines, testing, and technical delivery.
Education
B.TECH - MECHANICAL ENGINEERING
09.2020
CLASS 12TH - SCIENCE STREAM
05.2014
Skills
- Data analysis
- Pricing strategy
- Cost estimation
- Cross-functional collaboration
- Supply chain optimization
- Sales forecasting
- Microsoft office expertise
- Financial reporting
- Decision-making
- Statistical modeling
- APIs integration
- SQL databases
- Dashboard development
- Problem solving
- Predictive analytics
- Market trend analysis
- Big data analytics
- Model evaluation
Certification
- IOTA Academy Data Analyst Certificate
- IBM Data Analyst Professional Certificate
- IATF 16949:2016 Internal Auditor
- ISO 9001:2015 Internal Auditor
- ISO 14001 & 45001 Internal Auditor
- Autodesk AutoCAD User Certificate
- XL Dynamics Skill Enhancement & Employee Development
Accomplishments
- Best Kaizen Award for solving the problem of 'Dent & Damage Defect'.
- Improved RFQ to PO conversion rate by 25%.
- Worked on SEO and increased the RFQ request by over 20%.
- Optimized silver consumption, boosting plating efficiency by 15% and reducing operational costs by 10%.
- Reduced the ICC by 8% increasing revenue.
- Funded the highest amount of loan in a single day.
Work Preference
Work Type
Full TimeWork Location
On-SiteRemoteHybridImportant To Me
Career advancementPersonal development programsHealthcare benefitsCompany CultureTimeline
ASSISTANT MANAGER - Vishalfab India Private Limited
07.2024 - Current
DATA ANALYST - Vishalfab India Private Limited
12.2022 - 07.2024
Financial Analyst - XL Dynamics India Private Limited
09.2020 - 08.2022
SHRI VAISHNAV VIDYAPEETH VISHWAVIDYALAYA - B.TECH, MECHANICAL ENGINEERING
MAHARSHI VIDHYA MANDIR - CLASS 12TH, SCIENCE STREAM
Similar Profiles
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
Saurabh Kumar SinghSaurabh Kumar Singh
Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)Sr. Solution Specialist at Noventiq Services India Private Limited(Former Softline Services India Private Limited)
DEBAJIT HAZARIKADEBAJIT HAZARIKA
SENIOR ENGINEER-PRODUCT SUPPORT at GAINWELL COMMOSALES INDIA PRIVATE LIMITED (FORMERLY TRACTORS INDIA PRIVATE LIMITED)SENIOR ENGINEER-PRODUCT SUPPORT at GAINWELL COMMOSALES INDIA PRIVATE LIMITED (FORMERLY TRACTORS INDIA PRIVATE LIMITED)