p
pavan_gsp

Pavan Kumar Ch

@pavan_gsp

Data Analyst

United States
English
About me
I am a Data Analyst with 3+ years of experience leveraging SQL, Python, and cloud-based ETL to deliver actionable business insights and scalable data solutions. I am skilled in statistical analysis, predictive modeling, and data visualization. I am passionate about turning raw data into insights.... Read more

Skills

p
pavan_gsp
Pavan Kumar Ch
Offline • 
Average response time: 1 hour

See my services

Automations
I will clean, format and analyze your excel data professionally
From$40 / projectMore details
Data Dashboards
I will build a professional power bi dashboard for your business
From$50 / projectMore details

Work experience

Flipkart

Flipkart

Full-time • 3 yrs 1 mo

Data Analyst

Jun 2021 - Jul 2023 • 2 yrs 1 mo

Collected logistics and delivery data from multiple sources including warehouse scans, last-mile tracking, and vendor SLAs. Collaborated with supply chain, tech, and operations teams in Agile sprints for requirement gathering and iterative development. Utilized Azure Data Factory for ETL processes and wrote optimized SQL queries to extract delivery logs and order timelines from Azure Synapse. Improved query efficiency by 28% and streamlined dataset pipelines for daily updates. Performed Root Cause Analysis (RCA) using Pareto and time-series analysis to uncover delay patterns. Developed predictive delivery-time models using Python with NumPy and Pandas, simulating various logistic constraints.

Junior Data Analyst

May 2020 - May 2021 • 1 yr

Supported data collection from multiple business systems including warehouse logs, delivery scans, and tracking records. Collaborated with senior analysts and cross-functional teams to ensure accuracy and completeness of collected datasets. Assisted in writing and optimizing SQL queries for extracting structured data. Worked with Azure Data Factory to support ETL processes and maintain consistent, reliable data pipelines across internal reporting systems. Contributed to building interactive Tableau dashboards by preparing cleaned datasets and applying Level of Detail (LOD) expressions.