Karthikeyan Mochai
Data Analyst
Tirupati
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
5
5
years of professional experience
Work History
Data Analyst
TCL POTPL
01.2021 - Current
- Analyzing, validating, interpreting and displaying data using different approaches and business intelligence tools.
- Utilized PLSQL to modify and update the production related data in database and Skilled in data cleaning, data modeling, DAX, Exploratory data analysis (EDA) and dashboard design.
- Extracted large datasets, performed data cleaning and transformation with Pandas, and conducted in-depth EDA to identify trends in customer purchasing behavior and product sales.
- I also built interactive dashboards in POWER BI to visualize KPIs such as revenue trends, customer retention, and top-performing products.
- Skilled in writing Complex queries for data extraction and analysis.
- Skilled in optimization techniques.
- Collaborated with business users and Stakeholders (Product, Eng, Ops) to gather requirements for the features, and define success metrics.
- Automated recurring reporting tasks by integrating SQL and Pandas, reducing manual reporting time by 50% and also provided actionable insights to the marketing and operations team that led to a 12% improvement in targeted promotions and stock optimization.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Reduced data redundancy with effective data modeling, ensuring optimal use of storage resources.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
Education
Certifications -
Skill Nation
Advanced Excel And Power BI 04.2001 -
B.Tech -
Sreekalahasteeswara Institute of Technology
Tirupati, India 04.2001 -
Skills
Data quality enhancement
Data analysis
Data visualization expertise
Data manipulation using SQL
Data analysis using Google Analytics
Data structure design
Excel functions
Time management
Data storytelling
Data warehousing
Microsoft Azure expertise
Python programming
Timeline
Data Analyst
TCL POTPL
01.2021 - Current
Certifications -
Skill Nation
04.2001 -
B.Tech -
Sreekalahasteeswara Institute of Technology
04.2001 -