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
12.2018 - 08.2019
- 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
04.2013 - 10.2018
- 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
07.2009 - 03.2013
- 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 06.2007 - 05.2009
B.TECH - Mechanical Engineering
J B INSTITUTE oF ENGINEERING AND TECHNOLOGY
HYDERABAD 08.2002 - 04.2006
Board of Intermediate Education - Mathematics, Physics, Chemistry
Sri Chaitanya Junior College
HyderabadSecondary School Certificate -
St Pauls' High School
Hyderabad 06.1994 - 04.2000
Skills
Data profiling
Defect tracking
Microsoft Visio
Business needs analysis
Process Mapping
Data analysis
Data formatting
Data validation
Activity diagrams
Data quality assurance processes
Technical Analysis
Statistical analysis
Data Mining
Conflict resolution
Written Communication
Collaboration
Good listening skills
Gap analysis
Business process mapping
Detail-oriented
Predictive modeling
Data Mapping
Competitive analysis
Proficient in Power BI
Proficient in Tableau
Developing databases and implementing triggers and joining tables with SQL server
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
04-2020
Business Analyst Training - 1 month
09-2019
Manager
Fiat Chrysler Automobiles
12.2018 - 08.2019
Six Sigma Black Belt (ASQ)
05-2018
Sr Manager
TATA MOTORS LIMITED
04.2013 - 10.2018
Asst. Manager
International Center for Automotive Technology
07.2009 - 03.2013
M. Tech - Automotive Engineering Technology
VIT University
06.2007 - 05.2009
B.TECH - Mechanical Engineering
J B INSTITUTE oF ENGINEERING AND TECHNOLOGY
08.2002 - 04.2006
Secondary School Certificate -
St Pauls' High School
06.1994 - 04.2000
Board of Intermediate Education - Mathematics, Physics, Chemistry
Sri Chaitanya Junior College