Manasa Amaravathi
Bangalore
Summary
Detail-oriented Data Analyst with 3.4 years of experience in eCommerce analytics specializing in sales optimization, customer insights, and predictive analytics. Skilled in SQL, Python, Power BI, Tableau, and SSIS with proven expertise in ETL pipelines, dashboard automation, and business performance improvement. Adept at collaborating with cross-functional teams to deliver data-driven solutions.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Systems Engineer / Data Analyst
Tata Consultancy Services (TCS)
12.2021 - 04.2025
- Designed and optimized ETL workflows using SSIS to extract, transform, and load sales and customer data from SQL Server, Excel.
- Automated data integration pipelines with SSIS, reducing manual effort and improving data refresh efficiency by 40%.
- Developed SQL queries, stored procedures, and complex joins to analyze large-scale eCommerce sales, customer, and inventory data.
- Cleaned and transformed raw data using Python (Pandas, NumPy) and Excel (Power Query, advanced formulas) for reliable reporting.
- Built and optimized data models in Power BI and Tableau using DAX to calculate complex KPIs such as revenue growth, churn rate, and sales trends.
- Implemented Row-Level Security (RLS) in Power BI dashboards to control user-level access and ensure compliance with organizational policies.
- Designed interactive dashboards in Power BI/Tableau for sales performance, campaign analysis, RFM segmentation, and demand forecasting.
- Conducted Exploratory Data Analysis (EDA) to identify customer behavior trends, seasonal patterns, and revenue-driving product categories.
- Collaborated with Data Scientists to prepare datasets for churn prediction and demand forecasting models using regression and classification techniques.
- Monitored and analyzed A/B testing experiments for marketing campaigns, recommending optimization strategies that improved ROI by 18%.
- Partnered with stakeholders to track KPIs such as revenue per customer, conversion rates, and campaign effectiveness, and presented insights to senior leadership.
- Documented data transformation steps, ETL workflows, and KPI definitions to ensure process transparency and reproducibility.
Education
Bachelor of Computer Applications (BCA) -
Shri Gnanambica Degree College
10-2021
Skills
- Data Tools : SQL, SSIS, Power BI, Tableau, Excel, Python
- Analytics : Customer Segmentation (RFM), Predictive Modeling, A/B Testing, Forecasting
- ETL & Data Management : Data Cleaning, Transformation, Integration, SSIS Packages, Automation
- Soft Skills : Stakeholder Communication, Problem-Solving, Cross-Functional Collaboration
Accomplishments
- Increased revenue by 24% through targeted promotions and pricing strategies.
- Reduced customer churn by 15% via predictive modeling.
- Improved marketing ROI by 18% through advanced campaign analytics.
- Minimized inventory waste by 18% using demand forecasting models.
- Reduced reporting turnaround time by 40% through SSIS automation & BI dashboards.
Certification
Microsoft Certified: Power BI Data Analyst Associate – PL 300 (Feb 2025 – Feb 2026)
Timeline
Systems Engineer / Data Analyst
Tata Consultancy Services (TCS)
12.2021 - 04.2025
Bachelor of Computer Applications (BCA) -
Shri Gnanambica Degree College
CORE COMPETENCIES
- Self-motivated and proactive, with a continuous learning mindset to keep up with evolving data tools and technologies.
- Naturally curious and driven to ask the right questions that lead to meaningful business improvements. Ethical and responsible, with a strong sense of data privacy, integrity, and professionalism.
- Collaborative team player who enjoys working with cross-functional teams to solve real-world problems using data.
Awards
Contextual Master Award (TCS): Recognized for deep client business knowledge.
On-The-Spot Team Award (TCS): Exceptional project contribution.
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
Shrushti GirapShrushti Girap
Automation Tester at Tata Consultancy Services (TCS)Automation Tester at Tata Consultancy Services (TCS)
Gyata JainGyata Jain
Senior SQL Server DBA at Tata Consultancy Services (TCS)Senior SQL Server DBA at Tata Consultancy Services (TCS)
GURMUKHUPKAR SINGHGURMUKHUPKAR SINGH
Technical Lead at IP INFUSION SOFTWARE INDIA PRIVATE LTDTechnical Lead at IP INFUSION SOFTWARE INDIA PRIVATE LTD