Sangam Kumar

Data Scientist

Bengaluru, Karnataka, India1 yr 8 mos experience

Most Likely To Switch

Key Highlights

Expert in automating ETL workflows for data management.
Proficient in creating interactive dashboards for data visualization.
Strong analytical skills with a focus on KPI tracking and reporting.

Stackforce AI infers this person is a Data Engineer with expertise in data analysis and visualization in logistics and operational efficiency.

Contact

Skills

Core Skills

Data Extraction, Transformation, And Loading (etl)Data VisualizationData AnalysisOperational EfficiencyAutomation

Other Skills

Analytical ReasoningAnalytical SkillsAnalyticsApache AirflowDAXDashboardsData ModelsDatabase Management System (DBMS)DatasetsETLExcelExcel FormulasExcel PivotExploratory Data AnalysisExtract, Transform, Load (ETL)

About

I'm a passionate data enthusiast with hands-on experience delivering impactful data projects through freelancing, real-world datasets, and challenges like the Codebasics Resume Project Challenge. I focus on turning raw data into valuable insights that drive informed business decisions. I specialize in the following areas: ✔️ Data extraction, transformation, and loading (ETL) using Python (Pandas) and MySQL ✔️ Automating ETL workflows with Apache Airflow for efficient data management ✔️ Creating interactive dashboards and live reporting with Power BI and Looker Studio ✔️ Data analysis, trend identification, KPI tracking, and performance reporting ✔️ Working with relational databases like MySQL and PostgreSQL ✔️ Data cleaning, processing, and visualization using Excel, Power Query, and DAX Technologies I frequently work with: 👨‍💻 Programming: Python (Pandas, NumPy, Matplotlib), SQL, DAX 🛠️ Tools: Power BI, Looker Studio, Advanced Excel, Google Sheets, Jupyter Notebook, Apache Airflow, Docker, AWS EC2 (Linux) 🗄️ Databases: MySQL, PostgreSQL I am actively looking for opportunities where I can apply my skills to help organizations make data-driven decisions and optimize their operations

Experience

1 yr 8 mos

Total Experience

10 mos

Average Tenure

1 yr 4 mos

Current Experience

Freelance

Data Analyst

Feb 2025 – Present · 1 yr 4 mos · Mumbai, Maharashtra, India · Remote

● Designed, built, and deployed an ETL pipeline on a Linux-based AWS EC2 instance using Python and Pandas to extract data from 5+ APIs, transform it, and load it into a MySQL database.
● Automated the entire ETL workflow to run hourly by creating and scheduling Apache Airflow DAGs, ensuring timely and reliable data update.
● Developed interactive dashboard in Looker Studio, scheduled automated email reports, and set up role-based access control for secure and targeted insights delivery.

ETLPythonPandasApache AirflowMySQLLooker Studio+2

Licious

Vice Captain, Logistics

Oct 2024 – Mar 2025 · 5 mos · Mumbai, Maharashtra, India · On-site

● Managed daily operations, tracking key performance indicators (KPIs) such as SLA, Drift & Sequence
Compliance, and FEFO Loss, identifying trends and areas for improvement, and providing actionable insights that led to improved operational efficiency.
● Used Excel, Power BI to analyze operational data, identify trends, optimize processes for route management and inventory control, resulting in an 6% improvement in SLA breaches, closing variance, and FEFO loss.
● Automated some daily reporting workflows by integrating Metabase data directly into Excel using Power Query and M language, saving 20 hours per month in manual effort and increasing report accuracy.

KPI TrackingExcelPower BIData AnalysisAutomationOperational Efficiency