welcome to my profile
Gaurav Kumar
Data Analyst
- delhi, india
- gkanand969@gmail.com
- 8958904045
- 8958904045
About me
I am a data analyst with 2 years of experience, proficient in programming languages and various analytics tools. I excel at translating complex data into actionable insights and delivering robust business solutions. My strong foundation in arithmetic, statistics, and analytics complements my ability to understand business processes, allowing me to harness the full potential of data effectively.
TECHNICAL SKILLS
Programming Langauges
SQL
Python (Modules: Numpy, Pandas, Matplotlib, Seaborn, Streamlit)
Databases & Data Warehouses
MSSQL Server
MySQL
PostgreSQL
Google BigQuery
Visualization Tools
Micosoft Power BI
Apache Superset
Redash
Excel
Tableau (Intermediate)
Cloud Platforms
Azure
Google Cloud Platform (GCP)
Data Analytics
Data Mining
Data Migration
Data Integration
Data Ingestion
Data Profiling
Data Quality
Data Governance/Policy,
Data Wrangling,
Data Modelling (ERD)
Data Cleaning
Data Visualization
Exploratory Data Analysis (EDA)
Statistics
Exposure with
Azure Data Factory, Azure SQL Database
Google BigQuery, Google Analytics (UA & GA4)
Big Data, Apache Spark, Snowflake, Docker
Agile Methodology, JIRA, Notion, Bitbucket, Git & GitHub
Benthos (A Streaming ETL Service)
Airbyte (Data integration platform to build ELT pipelines)
Experience
Aug 2023 - May 2024
KDataScience Solutions Pvt. Ltd.
Gurugram, India
Data Analyst
→ Built and delivered financial reports and dashboards to clients on a monthly or quarterly basis, tailored to their specific requirements.
.
→ Utilized advanced tools such as Azure Data Factory (ADF), Microsoft SQL Server (MSSQL), and Power BI to streamline data processing, modelling
and visualization.
→ Enhanced ADF pipeline jobs, resulting in a 25% increase in efficiency.
• Ensured data integrity and accuracy through rigorous validation and testing procedures, improving report building and refreshing times by
30%.
→ Led a team for healthcare domain client to automate monthly reports, transitioning from Excel & VBA to SSIS, MSSQL Server, and Power BI.
→ Designed ETL pipelines, performed data manipulation and modelling, and created scheduled, auto-refreshed Power BI reports, reducing
processing time by 80%.
Mar 2022 - July 2023
The Modern Data Company
Indore, India
Analytics Engineer (Data Analyst)
→ This is a data product platform company that delivers data and business analytics solutions and I Collaborated with product team to deliver advanced demonstrations to clients across sectors including retail, healthcare, and e-commerce.
→ Analysed business user requirements to identify key insights for customers, products, marketing funnels, and business KPIs. Translated these
needs into sophisticated reports and dashboards using leading visualization tools such as Power BI, Apache Superset and Redash.
→ Engineered Spark-based ETL pipelines for seamless data ingestion from diverse sources, followed by data profiling and quality checks on ingested data.
→ Crafted complex SQL queries (Joins, CTEs, Views, Window Functions, Sub Queries) for precise data manipulation and in-depth analysis.
Education
Aug 2013 – May 2017
Dr. K. N. Modi Institute of Engineering & Technology, Modinagar, Ghaziabad
Mechanical Engineering (B.Tech)
Mar 2011 - Feb 2013
Pratibha Sagar Sr. Sec. High School,
Muzaffarpur, India
Science stream (PCM)
Projects
Tools Used
- Google Analytics (GA4)
- Google BigQuery
- Microsoft PowerBI & DAX functions
Retail 360: Ecommerce analysis
Retail 360 analysis for Google's ecommerce website (Google Merchandise Store) from Google BihQuery's public data available on Google Analytics.
Tools Used
- Google Analytics (GA4)
- Google BigQuery
- Apache Superset
Web Traffic Analysis
Analytics built around my own educational website, which means I integrated it into Google Analytics 4, exported daily raw data from GA4 to BigQuery, then connected BigQuery to Apache Superset, and finally built a real-time-dashboard to track my website activity.
Certifications
Python - The Data Analyst Course: Complete Data Analyst Bootcamp 2021
Udemy
SQL - MySQL for Data Analytics & Business Intelligence
Udemy
Power BI & Tableau for Data Visualization
Udemy