Power BI
RAJKUMAR PETER
Business Data Analyst
Hyderabad
Summary
- Detail-focused Business Data Analyst with knowledge in data wrangling, process validation and business needs analysis. Proven ability to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
- Manager with over 10 years of experience in six sigma problem methodologies and business liaising (with Govt agencies). Recognized consistently for performance excellence and contributions to success in automotive industry. Strengths in six sigma tools and analytical software applications backed by training in Power BI and Tableau.
Overview
10
10
years of professional experience
11
11
years of post-secondary education
3
3
Certifications
4
4
Languages
Work History
Manager
Fiat Chrysler Automobiles
Pune
2018.12 - 2019.08
- Reviewed vehicle emission and engine performance data to assess compliance with BS Vi and CAFE regulations.
- Prepare and submit regulatory file applications and supporting documentation.
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
- Produced monthly lab test reports using Power BI dashboards.
- Determined root cause of data quality errors and recommended long-term solutions.
- Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
- Developed and executed data cleanup measures.
- Evaluated large datasets for quality and accuracy and create SQl databases to integrate with API's of organization regulatory portal.
- Determined root cause of deviations and non-conforming results and implemented appropriate corrective and preventive actions throughout product development process.
Sr Manager
TATA MOTORS LIMITED
DHARWAD
2013.04 - 2018.10
- Utilized various professional statistical techniques and maintained large databases to collect and analyze data from partners and customers.
- Identified, analyzed and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.
- Determined root cause of data quality errors and recommended long-term solutions.
- Developed and executed data cleanup measures.
- Researched and determined scope and complexity of issues.
- Determined root cause of deviations and non-conforming results and implemented appropriate corrective and preventive actions throughout product development process.
- Interpreted test results by comparing to established specifications and control limits, making recommendations on appropriateness of data for release.
- Conducted analyses of both in-process and completed sub assemblies,materials, components and products.
- Drafted technical documents such as deviation reports, testing protocol and trend analyses.
- Performed routine maintenance and calibration on testing equipment.
Asst. Manager
International Center for Automotive Technology
Gurugram, Maneser
2009.07 - 2013.03
- Interpreted regulatory rules or rule changes and communicate with testing and operational team of the lab.
- Wrote or updated standard operating procedures, work instructions or policies
- Delivered subject matter expertise for internal and external customers on compliance best practices and quality control.
- Prepare records and data on test cell occupancy, revenue generation, equipment downtime and for quarterly and yearly audits.
- Provided evaluative judgment based on analysis of information in complicated and unique situations and contributed to formulation of standards and strategies for functional areas.
- Developed and improved integrated reporting and analysis capabilities.
- Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
Education
M. Tech - Automotive Engineering Technology
VIT University
Vellore 2007.06 - 2009.05
B.TECH - Mechanical Engineering
J B INSTITUTE oF ENGINEERING AND TECHNOLOGY
HYDERABAD 2002.08 - 2006.04
Board of Intermediate Education - Mathematics, Physics, Chemistry
Sri Chaitanya Junior College
HyderabadSecondary School Certificate -
St Pauls' High School
Hyderabad 1994.06 - 2000.04
Skills
Data profiling
Accomplishments
- Fiat Chrysler Automobiles: Successful reduction of time span of UAT to 5 months against the industry normal of 8 months by efficient contingency & resource planning along with carrying good negotiation skills with Govt regulatory agency
- Acclaimed for collecting, segregating and developing tables and schemas in SQL server to integrate with in company cross team Vehicle safety and regulatory compliance portal developed by in house IT team.
- Tata Motors Ltd: Reduction of takt time by 15% through data analysis of line defects captured at engine assembly end of line PDI area and implement fool proof measures identified through human error detection techniques.
- Tata Motors Ltd: Resolved engine cylinder head warranty and part reliability through exploratory data analysis of vehicle warranty data bringing down the complaints from 250 to (incidents per thousand vehicles).
- ICAT: Recognized for my contribution in conducting and documenting test results and submitting the report with meaningful data visualizations to University of British Columbia for one of their research projects.
Software
Tableau
SQL Server
Minitab 17
Python
Advanced Excel
Certification
Six Sigma Black Belt (ASQ)
Interests
Teaching, Upskilling on trending technologies, Reading, Visiting Historical Places
Timeline
Certified Scrum Product Owner
2020-04
Business Analyst Training - 1 month
2019-09
Manager
Fiat Chrysler Automobiles
2018.12 - 2019.08
Six Sigma Black Belt (ASQ)
2018-05
Sr Manager
TATA MOTORS LIMITED
2013.04 - 2018.10
Asst. Manager
International Center for Automotive Technology
2009.07 - 2013.03
M. Tech - Automotive Engineering Technology
VIT University
2007.06 - 2009.05
B.TECH - Mechanical Engineering
J B INSTITUTE oF ENGINEERING AND TECHNOLOGY
2002.08 - 2006.04
Secondary School Certificate -
St Pauls' High School
1994.06 - 2000.04
Board of Intermediate Education - Mathematics, Physics, Chemistry
Sri Chaitanya Junior College
Similar Profiles
Tamanna LamTamanna Lam
Vehicle Chief Engineer - Advanced Cockpits at Fiat Chrysler Automobiles (Stellantis)Vehicle Chief Engineer - Advanced Cockpits at Fiat Chrysler Automobiles (Stellantis)
Godson SebastianGodson Sebastian
Assembly Line Production Worker at Fiat Chrysler AutomobilesAssembly Line Production Worker at Fiat Chrysler Automobiles
Tiffany JacksonTiffany Jackson
Assembly Line Team Leader at FCA Fiat Chrysler AutomobilesAssembly Line Team Leader at FCA Fiat Chrysler Automobiles