Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Sourav Sen

Bengaluru

Summary

As a Lead Data Analyst at Mercedes-Benz Research and Development India, I leverage my advanced business analytics skills and technical expertise to deliver data-driven solutions for improving the component quality of cars.

With over 5 years of relevant experience in data analytics, I have worked with Fortune 200 organizations and renowned businesses in various domains, such as IBM India and Philips India. I am passionate about extracting insights from data and leading the implementation of analytics across business areas in a well-respected market-leading company. I have implemented study of components, using Python, PySpark, Azure Databricks, and exploratory data analysis.

Overview

14
14
years of professional experience

Work History

Lead Data Analyst

Mercedes Benz Research and Development India
11.2019 - Current
  • Saved significant time and cost of the diagnosis team by preventing the need to dismantle fault free starters to identify the root cause of the problem. Time reduced from 60 days to 5min
  • Helped in reducing the cost of manufacturing of components using analytics, cost reduced by optimizing the test plan by benchmarking the damage threshold
  • Managing a team of four in E-drive topics in component testing
  • Trained team mates on best practices in data mining and visualization tools.
  • Single handedly reviewed code for coding standards and best practices for a team of 23 members, created code quality dashboard for regular scoring and hence improving the coding standards of the entire team.
  • Collaborated with German Counterparts and generated multiple projects for MBRD India office
  • Collaborated with stakeholders to define business requirements and objectives.
  • Executed by pipelining the entire process in Data bricks
  • Create driving scenarios and power profiles for different components to ensure durability in designing and testing.
  • Managed large datasets using Python, PySpark, Databricks, SQL as well as Tableau.

Senior Data Analyst

Philips
05.2019 - 11.2019
  • Generated reports and obtained data to develop analytics on key performance and operational metrics for Sales in India.
  • Tracked KPIs, metrics, and trends to evaluate business performance.
  • Built a analytics team from scratch for health care sales department at Philips Bangalore.
  • Built visualizations that enabled users to quickly interpret results from complex analyses.
  • Developed dashboards with Tableau to monitor key performance indicators.
  • Provided data-driven solutions to support decision making.
  • Managed large datasets using Excel, SQL, and other data tools.

Data Analyst

Mercedes Benz Research and Development India
06.2018 - 04.2019
  • Built visualizations that enabled stakeholder to quickly interpret results from complex analyses for quality management of components analyzing monthly warranty data of vehicle for monthly reconciliations.
  • Utilized advanced analytics tools such as SPSS, Excel , to manipulate large volumes of structured and unstructured data sets.
  • Provided data-driven solutions to support decision making.

Senior SQL Developer

IBM India Pvt Ltd
06.2012 - 11.2017
  • Created stored procedures, functions, views, triggers and indexes for efficient data manipulation.
  • Identified gaps in existing processes and provided recommendations on improving overall efficiency.
  • Optimized application performance through regular code reviews.
  • Regularly communicated progress updates with stakeholders and clients.

Software Developer

UST Global
02.2010 - 06.2012
  • Developed, tested and debugged COBOL programs for mainframe applications.
  • Designed, implemented, deployed, tested and troubleshooted applications on IBM Mainframes using COBOL, JCL, DB2, VSAM technologies.
  • Tuned and optimized DB2 SQL queries for better performance in a mainframe environment.

Education

Executive Programme in Advanced Business Analytics -

Indian Institute of Management
Ahmedabad

Master of Computer Applications -

West Bengal University of Technology
Kolkata

Skills

  • Data and Analytics
  • Data Mining & Analytics
  • Data Visualization
  • Automation and scripting
  • Python Programming
  • PySpark Programming
  • SQL Programming
  • Advanced Excel
  • Dashboard creation
  • Business Intelligence
  • Tableau
  • BI dashboards
  • Statistical Methods
  • KPI Tracking
  • Project Delivery
  • Process Improvement
  • Team Coordination & Leadership
  • Requirements Analysis
  • Project Management
  • Continuous Improvement
  • Relationship Building
  • Decision-Making
  • Team building
  • Team Collaboration
  • Problem-Solving
  • Analytical Thinking
  • Problem-solving abilities
  • Stakeholder Communication
  • Customer Communication

Websites

Timeline

Lead Data Analyst

Mercedes Benz Research and Development India
11.2019 - Current

Senior Data Analyst

Philips
05.2019 - 11.2019

Data Analyst

Mercedes Benz Research and Development India
06.2018 - 04.2019

Senior SQL Developer

IBM India Pvt Ltd
06.2012 - 11.2017

Software Developer

UST Global
02.2010 - 06.2012

Executive Programme in Advanced Business Analytics -

Indian Institute of Management

Master of Computer Applications -

West Bengal University of Technology

Similar Profiles

CREATE PROFILE
Sourav Sen