Amit Kumar

Business Analyst

Pune, Maharashtra, India5 yrs 4 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Designed 15+ interactive dashboards improving sales insights.
Automated KPI reporting saving 30 hours monthly.
Led data-driven strategies enhancing customer retention.

Stackforce AI infers this person is a Data Analytics professional with expertise in IT Services and Packaging industries.

Contact

Skills

Core Skills

Data AnalyticsData VisualizationBusiness Analytics

Other Skills

AWSAdvance MS ExcelAnalytical SkillsDAXData AnalysisData GovernanceData ModelsData ProfilingData ValidationETLExtract, Transform, Load (ETL)MathematicsMicrosoft ExcelMicrosoft Power BIMicrosoft SQL Server

About

Detail-oriented Data Analyst with 5 years of experience in delivering actionable insights using data visualization(Power BI and Tableau), statistical analysis(Python/R), and SQL-based data querying. Skilled in transforming complex data into business value for decision-makers across domains such as finance, Healthcare, Manufacturing, and IT services.

Experience

Tata consultancy services

2 roles

Data Analyst

Jan 2023 – Present · 3 yrs 2 mos · Pune, Maharashtra, India · On-site

Designed and deployed 15+ interactive Power BI dashboards tracking $50M+ annual sales data, enabling regional managers to identify underperforming markets and improve revenue by 12%.
Developed custom DAX measures for inventory turnover analysis, reducing overstock situations by 18% through data-driven recommendations.
Automated monthly KPI reporting by building SQL-based ETL pipelines that reduced manual effort by 30 hours/month while improving data accuracy by 25%.
Collaborated with cross-functional teams to implement AWS data integration solutions, improving report refresh times from 4 hours to 30 minutes
Conducted training sessions for 20+ sales team members on dashboard utilization, improving adoption rates by 40%.

Power BIDAXSQLAWSData VisualizationData Analytics

Data Analyst

Jan 2023 – Present · 3 yrs 2 mos · Pune, Maharashtra, India · On-site

Infosys

Senior System Engineer

Nov 2020 – Jan 2023 · 2 yrs 2 mos · Pune, Maharashtra, India · On-site

Client: Avery Dennison – Global Packaging and Labeling Solutions Provider
Led the design and deployment of interactive Power BI and Tableau dashboards to monitor product sales, customer acquisition, and retention performance.
Translated complex business requirements into actionable BI reports and KPIs for Avery Dennison’s marketing and operations teams.
Performed advanced SQL-based analysis on high-volume customer and transactional data to identify purchasing trends and market opportunities.
Delivered customer segmentation strategies that improved targeting and retention through data-backed insights.
Conducted thorough data validation and quality checks to ensure reporting accuracy.
Optimized SQL queries (using CTEs and window functions) to analyze 10M+ transactional records, uncovering untapped market opportunities in APAC region.

Power BITableauSQLData ValidationData AnalyticsBusiness Analytics