p
pavan_gsp

Pavan Kumar Ch

@pavan_gsp

Data Analyst

Estados Unidos
Inglés
Parte de la información aparece en idioma inglés.
Sobre mí
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.... Lee más

Habilidades

p
pavan_gsp
Pavan Kumar Ch
desconectado • 
Tiempo medio de respuesta: 1 hora

Revisa mis servicios

Automatizaciones
I will clean, format and analyze your excel data professionally
Panel de datos
I will build a professional power bi dashboard for your business

Experiencia laboral

Flipkart

Flipkart

Tiempo completo • 3 yrs 1 mo

Data Analyst

Jun 2021 - Jul 20232 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 20211 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.