Pavithra Srinivasan

Adept Data Analyst with a proven track record at Groupon, leveraging SQL, Teradata and Tableau to drive decision-making and enhance performance monitoring. Excelled in facilitating team brainstorming and implementing Salesforce CRM best practices, showcasing strong analytical prowess and innovative problem-solving skills. Demonstrated leadership in business analysis and customer service excellence at Cognizant Technologies Solutions.

• Hands on Tableau Training for Data Science
• ·Masterd SQL from Basics to Pro by working daily on real time project.

Merchant Service/Merchant Research (April 2017 to March 2019)

• Merchant Research is one of the first step Groupon takes towards a deal.
• Merchant Support is a supporting phase for a Merchant from Groupon. I take care of the data involved in each and every phase to analyze the time taken to resolve an issue.
• Understand SFDC/ Merchant Support and Merchant Research to build the Dashboard for Business Reviews using ETL and Teradata.
• Breakdowns for each level of data which would help stake holders to slice and dice the requirement.
• Graphical representation using measures and dimensions. Provided context filter, quick filter and user filters for the Tableau Dashboard.

Backlog for Zendesk and Salesforce (Sep 2016 - Oct 2016)

• Identify data source for the dashboard.
• Query the necessary information needed for the dashboard.
• Schedule job in ELT (optimus)
• Design tableau dashboard based on the requirements
• Publish tableau dashboard on staging server for stake holder’s review based on the review comments publish the dashboard in production server

Business continuity process reports

• Query the data for different region to generate the report in Excel
• Create a ODBC connection in excel to connect it to Teradata
• Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.
• Send the report to stakeholders for the weekly review to understand the business gap.

RPA Merchant Research (Feb 2018 to March 2020)

• Understand the requirement and document it for the developer to automate it using selenium.
• Help the robotics team with data analytics as it involves 3M data.
• Involve in data analysis to check the accuracy of automation process.

PRISM (May 2012 to October 2013)

• Handled complete data analysis from source to the PRISM system.
• Worked in ETL process to run the daily packages.
• Involved in Requirement gathering phase, designing and in AGILE process.
• Efficient participation in development, System Integration Testing, User Acceptance Testing and Performance Testing.
• Post production activities and making sure that the application is effectively used by the customers.

Portal Rationalization (October 2013 to May 2014)

• Working in excel to find the gaps between internal application and BU BPM applications.
• Interacting with Verticals and Horizontals to accommodate the internal applications which are already on board.
• Gathering the requirement from the business to fill the gaps missing in existing applications.
• Following AGILE technology to satisfy the customer needs.

CResource Planner (October 2014 to Sep 2016)

• Explored in MS excel to analyse the data between source to destination system.
• To document the business process by identifying the requirements.
• Preparing excellent documentation on business requirements.
• Handling various activities of the project like information gathering, analysing the information gathered, documenting the functional or business requirements.
• To make the Test plan for the testing team.
• To do the User acceptance testing in the final project.
• Acted as single point of contact between Project Management and appropriate IT groups from solution planning, sizing, to fulfilment.
• Persuade visual designers by understanding usability and design principles.