Summary
Overview
Work History
Education
Skills
Projects
Accomplishments
Dancing, Cycling
Quote
Timeline
BusinessAnalyst
SWAPNAL DIVE

SWAPNAL DIVE

Data Analyst
Canton,MI

Summary

Experienced Data Analyst with 6+ years of expertise in the IT industry, specializing in Banking, Insurance, and Automotive domains. Skilled in processing and organizing data, with a strong ability to maintain and manage large databases. Proficient in utilizing data mining tools and adept at handling complex algorithms for big data analysis.

Overview

9
9
years of professional experience

Work History

Data Analyst

MI-GSO|PCUBED
5 2023 - Current
  • Using data analysis, visualization, and modeling to solve complex problems, improve current products, and assist clients with new merchandise or product offerings.
  • Develop interactive dashboards that provide insights into the data using QlikSense tool.
  • Visualization of data using QlikView and Alteryx.
  • Data Modelling for improving the old models.
  • Operated on Agile Methodology for automotive testing lab data points to provide insights using Visualization tools like QlikSense, which led to a 90% increase in understanding results.
  • Used Looker Studio, BigQuery, and Cloud Storage services of Google Cloud Computing for GCP migration data and visualization.
  • Onsite visit at Ford - London, UK for analyzing and understanding the testing lab process and building a business visualization report dashboard for business analytics.

Data Engineer

Tata Consultancy Services Ltd.
03.2016 - 08.2022

Aviva Life Insurance.

  • Designed optimal ETL mapping using Informatica PowerCenter ETL tool to complete end-to-end ETL project lifecycles, from requirements gathering to deployment.
  • Created shell scripts using Unix and Linux languages for scheduling jobs on UC4 and mainframe platform.
  • Operated on Agile Methodology for financial and insurance data points to provide insights using visualization tools like Tableau, which led to an 80% increase in understanding results.
  • Designed optimized BDM (big data management) flow on Informatica BDM with Hive database and have stored output on AWS cloud S3 buckets.
  • Performed tuning on workflows with data mining algorithms, which impact to increase operational performance by 30%.
  • Developed and maintained data integration and management processes using Informatica Power Centre and Informatica Intelligent Cloud Services (IICS).
  • Build, test, and deploy algorithm to production environment with Jenkins-Github pipeline with 100% accuracy.

Royal Automobile Club:

  • Collaborated closely with the business teams to streamline production release strategy plans. Also, managed a team of five test engineers and developed a data-driven framework that increased application testing depth and breadth by 150%. Maintained a Jira board for Agile Scrum meetings and client interactions.
  • Improved the overall release quality and delivery time by 40%, by introducing and influencing code review and code freeze process, which also eliminated last-minute scope creeps.
  • Provided technical support and troubleshooting services involving application handling ServiceNow tickets for 24/7 duration. Also, worked on compiler design and implementation.

Education

Master of Science - Data Science

University of Michigan-Dearborn
05.2001 -

Skills

Data Visualization tools

Projects

Cars sales prediction: Tableau, Python, Excel, Data mining algorithm for analysing top selling Model for most popular car Manufacturer and also predicted their next year best sell model and its specifications requirement. I have used Linear regression algorithm and obtained R square value of 85% with 91% accuracy rate for predicted result. 

Database Design Project: SQL Developer, Oracle, Power BI, Database design project developed management system for E commerce database schema with analyzing and importing sales data, implementing entity relations (ER Model) and DML/DDL query execution for customer invoice and reporting. 

Cardiac Health prediction using GCP Vertex AI, GCP Vertex AI, Google storage, bigquery, Looker studio, On the basis of basics health parameter as BMI index, height, weight, cholesterol and Blood pressure level, I have predicted cardiac health condition using Vertex Ai GCP services. Also I have used Google storage to store data, bigquery and Looker studio for report visualization. 

Real time face detection using Python: Python, face recognition, NumPy, open cv, Using face recognition, NumPy and open cv libraries of Python, I have created a model which capture real time facial recognition and provide its identity linked to the backed database. This project can be applicable in real time scenario as a Smart Attendance in classroom or Identity recognition by web camera setup at home door.

Accomplishments

  • Modified and improved existing databases of Automobile client, automated their labor statistics process and to reduce manual work by 90% and with 100% accuracy. Also, provided visualization of their monthly and yearly KPI's on dashboard report.

Dancing, Cycling

Dance and music is my relaxing therapy. After work I love to engage my self in dance world and if not that just cycling around and exploring new trails. It clear my mind and make me ready to solve new data puzzle at work.

Quote

Information is the oil of the 21st century, and analytics is the combustion engine.
Peter Sondergaard.

Timeline

Data Engineer

Tata Consultancy Services Ltd.
03.2016 - 08.2022

Master of Science - Data Science

University of Michigan-Dearborn
05.2001 -

Data Analyst

MI-GSO|PCUBED
5 2023 - Current
SWAPNAL DIVEData Analyst