Hi, I’m
KR Dhanapal
Data Analyst
Bangalore
Summary
Dynamic Data Analyst with over 12 years of experience in business intelligence and analytics, dedicated to driving operational excellence. Proven expertise in Power BI development, Data analytics, network design, optimization, demand planning, and forecasting. Skilled in statistical analysis, data visualization, and strategic reporting, consistently delivering actionable insights that enhance decision-making processes. Committed to tackling complex challenges and contributing innovative solutions within a forward-thinking organization.
Overview
14
years of professional experience
Work History
Expeditors International Pvt Ltd (Onyx Strategic Insights)Bangalore
Data Analyst
04.2024 - Current
Job overview
- Proficiently utilized Azure ADF, ETL, and PowerBI/Tableau to conduct comprehensive data analytics and visualization, emphasizing report optimization to enhance efficiency.
- Demonstrated expertise in SQL, Tableau, Power BI, and DAX, crafting visually stunning and dynamic visualizations that effectively communicate insights to stakeholders.
- Orchestrated ETL processes to seamlessly integrate and cleanse data from disparate sources, ensuring data quality and consistency for analysis.
- Leveraged SAP BW, SQL, and Azure DevOps for seamless data transformation into Power BI, ensuring smooth integration and accessibility of critical business data.
- Spearheaded initiatives to optimize reports, significantly improving the performance and efficiency of analytics dashboards and reports.
- Proficiently developed various database objects, including tables, views, and materialized views using SQL, contributing to the organization's data infrastructure.
- Maintained and updated dashboards and reports using Power BI and SQL, effectively communicating findings and insights to stakeholders
- Collaborated closely with stakeholders to gather and analyze business requirements, translating them into technical specifications and actionable, data-driven insights. Spearheaded advanced data analysis initiatives leveraging Microsoft Fabric, Azure Databricks resulting in enhanced data scalability, integrity, and overall system performance.
RPMPCG-GSC IndiaCoimbatore
Data Analyst
11.2022 - 04.2024
Job overview
- Built 7 Power BI projects from scratch, making it much easier for the team to see their data and make decisions quickly.
- Talked directly with business users to turn their requests into easy-to-use dashboards that met company goals.
- Set up ETL processes to pull and clean data for Power BI, making sure the numbers were always correct and consistent.
- Cleaned and organized data (EDA) to find errors and hidden insights, making our business decisions more accurate.
- Built a project forecasting tool in Python (using PyCharm) to help the team predict future trends based on old data. Used machine learning and stats to find patterns in our data, which helped us plan better for upcoming months.
- Wrote and fixed Python scripts for processing data and training models, which made our predictions 20% more accurate.
- Worked with different departments to understand what they needed and made sure the technical solutions actually solved their problems.
- Gave regular updates to managers about how the project was going, handled any blockers, and kept everyone on the same page.
Genpact India Pvt LtdBangalore, Karnataka
Business Analyst
09.2021 - 11.2022
Job overview
- Developed custom Power BI projects that streamlined reporting processes and reduced manual data extraction time.
- Facilitated requirement-gathering sessions with business users to design user-centric BI tools, improving departmental productivity and KPI tracking.
- Optimized data architecture by designing robust ETL workflows, significantly reducing reporting errors and maintaining consistent data quality across the organization.
- Automated Reporting: Used R Studio to automate weekly reports, which replaced manual work and gave faster recommendations for ordering and repairing parts.
- Reduced Shipping Costs: Built a routing tool in R Studio to find the shortest global paths for shipments, saving the company money on logistics and reducing wait times.
- Improved Parts Planning: Increased forecasting accuracy by 5% for spare parts by analyzing lead times and demand categories (SLE) to make sure the right stock was available.
- Global Problem Solving: Monitored the global supply chain network to find gaps or delays, providing data-driven solutions to keep operations running smoothly.
- Multi-Tool Expert: Built high-level dashboards and scorecards using a mix of Power BI, Python, R, and Advanced Excel to show sales trends and forecast results.
- Strategic Planning: Consulted on business process design and network layouts to help clients optimize how their products move from warehouses to customers.
Rising Stars Mobiles India Pvt LtdChennai, Tamil Nadu
Project Management Associate
12.2017 - 09.2021
Job overview
- Developed new business forecasting models, analyzed market trends, and conducted professional research.
- Improved forecast accuracy by 5%, implemented new metrics, and produced detailed reports.
- Participated in weekly team meetings with managers, presented results, and assisted in decision-making.
- Maintained and organized documents and records, supported colleagues, and fulfilled additional duties as assigned.
- Acknowledged by executives for consistently delivering exceptional work.
- Prepare plans for all NPI projects and coordinate with all stakeholders.
- Prepare & Work with Cross Functional team for project timelines and identify all resources requirement and evaluate financials for manufacturing processes.
- Assist and manage communication across all departments for smooth flow NPI process.
- Participate in new product launches through the Product Development Process. Develop strategic plans to support new products and programs.
Mitsubishi Electric Automotive India Pvt LtdChennai, Tamil Nadu
Engineer E1- Sales
11.2014 - 02.2016
IHD Industries India Pvt LtdChennai, Tamil Nadu
Junior Engineer - Sales
04.2012 - 10.2014
Education
Anna University of TechnologyCoimbatore, Tamilnadu
Bachelor from Electronics & Communication Engineering
06-2011
University Overview
GPA: 73.7%
Thiagarajar Polytechnic CollegeSalem, Tamilnadu
Diploma from Electrical & Electronics Engineering
07-2008
University Overview
GPA: 81%
Skills
Power BI Development
Network Design
Forecasting
Solution development
ETL Process
Operational analysis
Business Intelligence
SAS Programming
SAS VA
Python
Azure ADF
Excel
PowerBI
Personal Information
Age: 36
Timeline
Data Analyst
Expeditors International Pvt Ltd (Onyx Strategic Insights)
04.2024 - Current
Data Analyst
RPMPCG-GSC India
11.2022 - 04.2024
Business Analyst
Genpact India Pvt Ltd
09.2021 - 11.2022
Project Management Associate
Rising Stars Mobiles India Pvt Ltd
12.2017 - 09.2021
Engineer E1- Sales
Mitsubishi Electric Automotive India Pvt Ltd
11.2014 - 02.2016
Junior Engineer - Sales
IHD Industries India Pvt Ltd
04.2012 - 10.2014
Thiagarajar Polytechnic College
Diploma from Electrical & Electronics Engineering
Anna University of Technology
Bachelor from Electronics & Communication Engineering