Karthick A
Chennai
Summary
Results-driven data analyst with 5 years of experience in SQL, Python (Pandas, NumPy, Matplotlib), and business optimization. Skilled in ETL, data modeling, and creating interactive Power BI dashboards. Experienced in trend analysis, performance reporting, and cross-functional collaboration to deliver data-driven insights that enhance operational efficiency and support strategic goals.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Data Analyst, Process Specialist
Amazon
04.2024 - Current
- Led process optimization by analyzing large datasets using SQL and Python , improving efficiency and reducing operational costs.
- Designed and deployed scalable ETL pipelines using Amazon Redshift , automating data extraction, transformation, and loading workflows.
- Developed and maintained Power BI dashboards and implemented DAX measures for real-time business intelligence reporting.
- Collaborated with cross-functional teams to translate business requirements into data-driven solutions , supporting continuous improvement.
- Applied 5+ years of experience in data analytics , utilizing Pandas , NumPy , Matplotlib , SQL , and data modeling to deliver actionable insights.
Data Analyst
Amazon
10.2022 - 03.2024
- Built and delivered 30+ Week on Week performance dashboards using Excel and Power BI , supporting strategic decision-making and process improvements.
- Analyzed and resolved catalog data inconsistencies using SQL , improving data accuracy and integrity across systems.
- Collaborated with stakeholders to streamline catalog operations, implement workflow automation , and ensure timely, accurate data updates.
Junior Data Analyst, Associate
Amazon
08.2020 - 09.2022
- Collected, cleaned, and analyzed large datasets using Excel and SQL to identify trends, resolve data issues, and support daily operations.
- Created performance reports and dashboards to help stakeholders monitor key metrics and make data-driven decisions.
- Performed market and competitor analysis to provide insights for pricing strategies and operational improvements.
Education
B.E - Mechanical Engineering
Apollo Engineering College
Chennai04-2018
Higher Secondary - Computer Mathematics
Ellen Sharma Mat School
Chennai04-2014
Skills
- Python, Pandas, NumPy, Matplotlib, Seaborn, Advance SQL
- Snowflake, Amazon Redshift, ETL Pipelines
- Power BI, Amazon QuickSight, Power Query, DAX
- Data Cleaning, Data Profiling, Big Data Analysis
- Microsoft Access, Advanced Excel
- Data Modeling, Reporting, Automation
Certification
- Data Analyst Bootcamp – Udemy
Completed comprehensive training in data analysis covering Python, Pandas, NumPy, SQL, data visualization, and real-world projects.
Awards
- Rockie Rockstar (2021): For outstanding performance as a new joiner.
- Stellar Award (2022, 2023, 2024, 2025): For consistent ownership and result delivery.
- Extra Miler (2023): For executing high-impact ideas independently.
- Mountain Mover (2024): For solving critical challenges.
- Shout-Outs (2024): For ownership and deep problem-solving.
- Wall of Fame (Multiple): Recognized multiple times as a top performer.
Projects
- Developed ROI dashboards using SQL, DAX, and Power Query on ETL tables to identify high-return activities and guide resource allocation, improving workforce efficiency by 30% and enabling precise bandwidth planning.
- Created SQL-driven Power BI dashboards monitoring Amazon's performance metrics affected by competitor crawl issues, selection changes, and pricing adjustments, providing actionable insights to support strategic decisions.
- Utilized SQL and ETL pipelines with S3 data storage to analyze seasonal and annual demand trends across brands and categories, generating dynamic feeds and DWP reports that forecast brand-level spikes and informed pricing strategies, contributing to achieving annual revenue goals.
- Published detailed SQL-based reports identifying Amazon's reference price errors by analyzing catalog and competitor pricing data, quantifying pricing discrepancies and revenue loss, empowering leadership to optimize pricing accuracy and recover lost revenue.
Accomplishments
Qualified GATE – Mechanical Engineering (ME) in 2018, 2019, and 2020
Languages
English
Tamil
Hindi
Timeline
Senior Data Analyst, Process Specialist
Amazon
04.2024 - Current
Data Analyst
Amazon
10.2022 - 03.2024
Junior Data Analyst, Associate
Amazon
08.2020 - 09.2022
B.E - Mechanical Engineering
Apollo Engineering College
Higher Secondary - Computer Mathematics
Ellen Sharma Mat School