Hi, I’m
KHODIDAN GADHAVI
SAP Data Analyst
Gandhinagar
Summary
As a SAP data analyst, I have contributed significantly to the entire product life cycle, from requirements gathering to production implementation. My collaboration with Data Modelers and DBAs has resulted in robust data models and well-structured table designs. I actively participate in designing efficient ETL job flows, execute SQL queries for smooth data operations, and coordinate tasks with both onsite and offsite team members. Customizing SAP modules, implementing insights from data visualization, and managing data migration are also part of my achievements. Notably, my work on the SAP Hana View interface has led to substantial improvements for OwensCorning CFA applications. Additionally, I propose technical feasibility solutions and perform cost-benefit analyses for system enhancements.
Overview
2
years of professional experience
6
years of post-secondary education
Work History
Tata Consultancy Services
Assistant System Engineer
12.2021 - Current
Job overview
- Involved in entire product life cycle development from the requirement gathering through implementation in production.
- Worked with Data Modeler and DBAs to build the data model and table structures.
- Actively participated in discussion sessions to design ETL job flow.
- Developed SQL queries to performed DDL,DML and DCL.
- Coordinated tasks with onsite and offsite team members.
- Customizing SAP modules to align with the organization's business processes that involve statistical analysis, adjusting settings, defining workflows, and tailoring the debugs in the query to fit specific needs.
- Leading or assisting in implementing insights from data visualization. This includes
activities like data migration, data warehouse, testing, and ensuring a smooth transition
from existing systems. - Implemented interface in SAP Hana View to utilize SQL joins and select queries for various roofing and insulation categories that help in minimizing cataloging errors by10% and improving fulfillment speed by 15% for OwensCorning CFA applications.
Education
L.J. INSTITUTE OF ENGG AND TECH.
Bachelor of Engineering - BE from Mechanical Engineering
01.2017 - 04.2021
University Overview
GPA: 7.28
Amarjyot science school
Higher secondary school certificate
05.2015 - 05.2017
Skills
Python
SQL
Advance Excel
VBA
ETL
MIS Reports
SDLC
EDA
BI-Tableau & Power BI
Pipeline
Strategy Building
Numpy
Pandas
Seaborn
Matplotlib
Sci-kit
Statistics and probability
Data warehouse
Root cause
Guess Estimation
Product analysis
Dashboards
CRM
Analytical thinking
Business process improvement
Google big query
Demand analysis
Distribution and predictive analysis
KPIs
Decision Making
Alteryx
Industry Expertise
- Exploratory Data Analysis
- Develop data-driven solutions based on the gathered insights
- Staying updated on the latest data analysis techniques.
Projects
Target Retail - Sql Project, Leveraged SQL to analyze a business case study involving 100,000 orders at Target in Brazil from 2016 to 2018. Extracted valuable insights and recommendations by examining order status, pricing, freight performance, customer location, product attributes, and customer reviews. Discovered a notable 136.98% increase in the cost of orders from 2017 to 2018.
Training
- Sql For Data Analytics
- Tableau
- Python For Data analytics
- Adavance Excle
Strenghts
Data Visualization
- Able to Visualize complex datasets in a comprehensive and engaging way.
Problem Solving
- Always seeking to find ways to improve myself and solve unexpected issues. Able to stay calm in problematic situations.
Team Work
- Collaborated with Operations & Training team to resolve recurring data errors.
Timeline
Assistant System Engineer
Tata Consultancy Services
12.2021 - Current
L.J. INSTITUTE OF ENGG AND TECH.
Bachelor of Engineering - BE from Mechanical Engineering
01.2017 - 04.2021
Amarjyot science school
Higher secondary school certificate
05.2015 - 05.2017