Sep 2023 – Oct 2024 · 1 yr 1 mo · Chennai, Tamil Nadu, India · Hybrid

• As a Lead Consultant at Virtusa, I collaborated with AstraZeneca to deliver data-driven solutions, specializing in data modeling using Snowflake and SQL. I worked extensively with HR Workday and SAP Finance data, contributing to key finance data projects and implementing Power BI dashboards for effective visualization. My responsibilities included managing production issues, executing change requests, creating Source-to-Target Mapping (STTM) documents, and actively participating in migration processes to advanced platforms. Additionally, I provided scalable solution designs and ensured seamless integration, aligning technical implementations with business objectives.

Jul 2022 – Sep 2023 · 1 yr 2 mos · Madurai, Tamil Nadu, India · Remote

• Prepare final analysis reports for the stakeholders to understand the data-analysis steps, enabling
• them to take important decisions based on various facts and trends.
• Responsible for carrying out complex analysis of datasets and conducting appropriate data validation
• Identifying business challenges and initiating process improvement projects
• Working with programmers, engineers, and management heads to identify process improvement
• opportunities, propose system modifications and devise data governance strategies.

Jun 2021 – Jul 2022 · 1 yr 1 mo

• As Deputy Manager, worked with the Market team to understand sales growth and profit objectives (Volume, Net Revenue, Profit – both for PepsiCo and the Customer), and built effective relationships with the and maintained planning models in Trade Promotion Management (TPM) sales system. In addition, the role will complete regular CDA and trade spend reconciliation reviews. Took responsibility for ensuring the forecast is accurate and reflected the latest customer planning.
• Built and maintained TPM planning models
• Worked across multiple functions to aid in collecting insights for the action-oriented causes of change
• analysis
• Implement continued improvements and simplifications of processes, standardization of reporting and
• optimal use of technology

Apr 2019 – Jun 2021 · 2 yrs 2 mos · Greater Chennai Area

• Lead a team of 3 data analysts to provide data analysis and reporting for various business
• functions and projects.
• Prepared weekly, monthly, and quarterly basis reports, and dashboards to identify key opportunities and understand business trends to support decision-making across departments, which resulted in a 45% increase in productivity.
• Perform data modeling to identify patterns, trends, anomalies, and opportunities in the data.
• Translating Cell formulas In Excel into VBA code and using Excel – Based VBA to design, analyze,
• and deploy programs for the B2B process resulting in an increase of 30% team’s SLA productivity
• compared with FY19
• Performed exploratory data analysis (EDA) and descriptive statistics to understand the
• characteristics and trends of the data.
• Investigate data to identify potential issues within ETL pipelines, notify end users and propose
• adequate solutions
• Identify, analyze, and interpret trends or patterns in complex data sets
• Writing SQL scripts to manipulate data for data loads and extracts
• Experience in various Power BI Modeling Techniques using Power Query [M Language] and DAX

Sep 2018 – Apr 2019 · 7 mos

• Created and revised procedures, checklists, and job aids that resulted in process consistency
• and reduced error disputes by 10%
• Ability to identify the Root cause and find trends based on the audit output and aggregate audit
• data based on the audit findings
• Develop and maintain pricing models and tools using Excel
• Monitor and report on pricing performance and trends using dashboards and reports.

May 2016 – Aug 2018 · 2 yrs 3 mos

• Proposed new solutions by analyzing previous trend patterns which helped the team to improve
• productivity from 80% to 95% for the financial year
• Assisted the business intelligence team in creating and modifying business intelligence solutions,
• such as data models, queries, reports
• Perform market research and competitive analysis to identify pricing opportunities and risks.
• Trained and Mentored 10 Junior Associates on data analysis tools, techniques, and best practices.
• Created charts and graphs to visualize data findings using Excel.