Gaurav Kumar
CONTACTS
PROFESSIONAL
SUMMARY
PROFESSIONAL
EXPERIENCE
-
|
Data Analyst-
|
LinkedIn
|
GitHub
2+ years of experience in data science, statistical modeling, and data visualization to derive
actionable insights and develop annual insights roadmaps.
Proficient in SQL and Python for data extraction, manipulation, and analyzing complex
datasets, with a strong focus on predictive modeling and business forecasting.
Designed dashboards, conceptual data models, and analytical use cases based on business
requirements, using tools like Power BI, Tableau, and matplotlib.
Aligned and simplified internal audit processes as part of the Data Analyst simplification
agenda, driving process efficiency and business growth.
Effective communicator, presenting complex findings to technical and non-technical
stakeholders, enabling data-driven decision-making and continuous improvement initiatives.
Trantor Inc
June 2022- May 2024
Data Analyst
Performed data analysis on multi-regional sales datasets to identify product trends, driving
strategic decision-making and improving revenue forecasting accuracy.
Achieved 90% accuracy in sales forecasting by applying regression models using Python,
Excel, and historical sales data, supporting seasonal inventory planning.
Led market expansion analysis, recommending 10+ new dealer/distributor locations,
resulting in a 25% increase in market coverage and improved regional penetration.
Automated weekly reporting processes using Excel VBA and MS SQL, reducing manual
reporting time by over 60% and improving reporting accuracy and consistency.
Designed and deployed real-time dashboards using Tableau, enabling upper management to
monitor KPIs and business performance at a glance.
Translated business needs into data-driven dashboards and analytical use cases using
Tableau and data warehousing tools.
Created and optimized complex SQL queries for sales, performance, and operational
analytics, supporting informed business decisions.
Developed conceptual ER diagrams and translated them into relational schemas, ensuring
data integrity and supporting downstream analysis.
Proficient in tools and technologies: SQL, Python, Excel (VLOOKUP, PivotTables, VBA),
Tableau, data modeling, and ETL processes.
Trantor Inc
October 2021- May 2022
Associate Software Engineer
Constructed and maintained over 100+ custom objects, fields, and layouts, ensuring
alignment with business processes and a 15% drop in duplicate data entries.
Streamlined data synchronization across multiple platforms using Salesforce APIs, reducing
redundant operations by 60%.
Contributed to the development of a comprehensive Salesforce CRM solution that achieved a
95% user adoption rate within the first year.
SKILLS
Programming: Python (Pandas, NumPy, Matplotlib), SQL, R, PySpark, TensorFlow, GitHub.
Data Tools: Excel (Pivot Tables, VLOOKUP, Power Query), Tableau, Power BI, Google Sheets, Knime.
Database & Platforms: MySQL, Postgres SQL, BigQuery (basic), GitHub, Jupyter Notebook.
Other: Data Cleaning, Forecasting, Market Analysis, Business Intelligence, ETL,
Reporting Automation.
Soft Skill: Analytical thinking, Problem Solving, Critical thinking, Storytelling with data,
Stakeholder management, Continuous Learning.
EDUCATION
PROJECTS
Great Lakes Learnings and Texas McCombs University|
PGP-Data Science and Business Analytics.
Galgotias University |
Bachelor of Technology in Computer Science Engineering.
September2024- Pursuing
July 2017 - June 2021
Project Title: Customer Demand and Marketing Efficiency Analysis for Auto Motor Company
Skills & Tools Covered:
Pandas Numpy ,Matplotlib Exploratory Analysis Univariate Analysis Bivariate Analysis
Multivariate Analysis Business Recommendation.
Key Skills & Learnings: Data Cleaning & Preprocessing: Handled missing values using median
and mode techniques Removed incomplete records and fixed typographical errors in categorical
data Ensured data consistency for accurate analysis Exploratory Data Analysis.
(EDA): Performed Univariate analysis using histograms and boxplots Detected outliers using the
IQR (Interquartile Range) method Applied statistical summaries to understand data
distributions Python Programming for Data Analysis.
Built custom functions to automate EDA tasks Used core Python libraries: pandas, numpy,
matplotlib, seaborn Applied conditional logic and modular code structure Cloud Integration:
Accessed and processed data from.
Google Drive via Google Colab Demonstrated ability to work in cloud-based notebook
environments.
Project Title: Crime Analytics – Los Angeles (SQL-Based Data Analysis)
Tools: SQL, PostgreSQL/MySQL, ER Diagrams, Data Modeling
Key Skills & Learnings: • Analyzed 1,300+ criminal cases using SQL to answer 10 key business
questions for LA's Criminal Investigation Division, uncovering insights into crime trends, victim
profiles, and locality patterns.
Developed complex SQL queries using JOINS, CASE statements, Window Functions, and
Subqueries to identify high-crime time zones, repeat offenders, and regional crime hotspots.
Conducted relational data analysis using a normalized schema (ER model) involving multiple
tables (officer, victim, location, and report) with over 40+ data fields and foreign key
relationships.
Assessed effectiveness of surveillance systems (CCTV) and law enforcement resource allocation
based on crime patterns across time and geography.
Project Title :- Customer Segmentation & Market Basket Analysis
Tools :- Python, Tableau, KNIME, Excel
Key Skills & Learnings :- Conducted end-to-end sales and customer behavior analysis using
Exploratory Data Analysis (EDA), RFM segmentation, and Market Basket Analysis on 3 years of
transactional data.
Built customer segments (Best, Loyal, At Risk, Lost) using KNIME RFM workflows; developed
targeted re-engagement strategies and VIP reward programs.
Discovered high-lift product associations (e.g., {Milk} → {Bread}) through Association Rule
Mining, leading to combo offers and optimized inventory plans.
Visualized sales trends, seasonality, and geographic insights with Tableau dashboards and
Excel.
Delivered a PDF summary and interactive visuals to support data-driven decision-making for
marketing and CRM teams.
CERTIFICATES
TensorFlow Developer Certificate. Certificate ID: TENSOR1067FLOW.
Generative AI Certificate.
Certificate ID: J5KMLR3VYB
