Tejaswi Kammeli
Hyderabad
Summary
Data Analyst with 10+ years of experience in data interpretation and analysis, delivering impactful business solutions. Expertise in developing and maintaining reports using Power BI and MS Excel. Skilled in sales forecasting, market research, and performance metrics through strategic reporting and dashboard creation.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Assistant Manager Zonal MIS Analyst
Pernod Ricard India Pvt Ltd
05.2020 - Current
- Compiled and maintained daily and monthly sales and development reports.
- Managed organization’s master database utilizing MDM tools.
- Analyzed business processes, automating sales reports with Power BI and advanced Excel.
- Forecasted sales volumes, delivering accurate predictions via Anaplan Portal.
- Collaborated with sales, marketing, and finance teams to align demand forecasts.
- Developed comparative reports of budgeted versus actual volume at brand level.
- Updated monthly channel-play metrics to track KPIs for sales and marketing teams.
- Created ad-hoc reports according to specific business requirements.
Regional MIS Analyst
Pernod Ricard India Pvt Ltd
12.2018 - 05.2020
- Executed monthly, quarterly, and annual reports with gap analysis against targets and forecasts.
- Coordinated with Supply Chain and Sales teams to prepare monthly sales forecast plans.
- Developed Excel trackers and dashboards for KPI monitoring across all management levels.
- Managed Master Data Management (MDM) activities to ensure data integrity.
- Monitored Data Governance Cockpit for SMILE application, implementing necessary data corrections.
- Generated and distributed management reports accurately and promptly while analyzing industry sales and market shares.
- Prepared Regional Sales and Development presentations to identify improvement opportunities.
- Updated monthly Pepup metrics for sales and marketing teams, tracking KPIs consistently.
- Worked on Qliksense ERP tool for preparing reports as per requirement
Plant MIS Analyst
Hindustan Coca-Cola Beverages Pvt Ltd
04.2015 - 11.2018
- Developed MIS reports enhancing reporting efficiency and consistency in customer management.
- Provided comprehensive KPI reporting and analytical support to management.
- Participated in cross-functional meetings addressing recurring internal issues.
- Reconciled monthly data between source system, SRS, and SAP.
- Prepared incentives for workmen and staff based on KPI target achievements.
TPM Executive (Total Productive Maintenance)
Hindustan Coca-Cola Beverages Pvt Ltd
04.2014 - 08.2016
- Drove site-wide behavioral change through targeted coaching and influence.
- Oversaw operational units in TPM role to optimize efficiency.
- Identified breakdown causes and applied problem-solving tools for equipment rectification.
- Planned and executed maintenance schedules to maximize machine uptime.
- Conducted downtime analysis to enhance maintenance activities and performance.
- Implemented Computerized Maintenance Management Systems for tracking critical spare parts.
- Assessed training needs and scheduled essential employee development sessions.
Production Engineer (Plant operation)
Hindustan Coca-Cola Beverages Pvt Ltd
07.2011 - 03.2014
- Oversaw production tasks encompassing planning, execution, and control processes.
- Established production targets and consistently achieved them within time and cost parameters.
- Monitored production to ensure compliance with quality standards and customer specifications.
- Analyzed production data and initiated corrective actions for continuous improvement.
- Optimized utilization of manpower and machinery to meet predefined production goals.
- Conducted daily rejection analysis and implemented strategies to reduce product rejections.
- Controlled manufacturing costs by identifying key result areas through statistical techniques.
Education
B.Tech. - Electronics and Instrumentation Engineering
V.R.Siddhartha Engineering College
A.P03-2011
Skills
- Advanced Excel and Power BI
- Data visualization and analysis
- DAX and cube formulas
- Sales forecasting and trend analysis
- Demand planning and execution
- Master data management
- Microsoft Access and SQL
- Cross-functional collaboration
- Data governance
- FMCG expertise
- SAP PP and MP modules
Certification
- Data modeling with Power BI: Advanced DAX calculations
- Business Intelligence, Power Query, and DAX
- Microsoft Access Usage.
- Process: TPM – CII certified for TPM implementation
- Core: beverage processing and filling, water treatment, good manufacturing practices
- Self-development: situational leadership behavior skills, supervisory development
Awards
- National level winner in 'I see I care' safety challenge.
- Monetary Reward from Chief HR for Project Phoenix implementation.
- Recognized by various regional heads for gaining top position in MIS nationally.
Timeline
Assistant Manager Zonal MIS Analyst
Pernod Ricard India Pvt Ltd
05.2020 - Current
Regional MIS Analyst
Pernod Ricard India Pvt Ltd
12.2018 - 05.2020
Plant MIS Analyst
Hindustan Coca-Cola Beverages Pvt Ltd
04.2015 - 11.2018
TPM Executive (Total Productive Maintenance)
Hindustan Coca-Cola Beverages Pvt Ltd
04.2014 - 08.2016
Production Engineer (Plant operation)
Hindustan Coca-Cola Beverages Pvt Ltd
07.2011 - 03.2014
B.Tech. - Electronics and Instrumentation Engineering
V.R.Siddhartha Engineering College