RAKHI SAPRA

*** ***** **** *******, **

Email: ad2du1@r.postjobfree.com

Phone: (M) 914-***-****

ACCOMPLISHMENTS / KEY SKILLS

Over 7+ years (4+ year with Vanguard) of experience working in analytics projects for clients. Expertise in solving complex business problems based on the experience gained from leading client engagements in Pharmaceutical, CPG, Credit Card, Insurance and other service industries.

Over 5 awards at Synchrony Financial for outstanding performance

Drexel Lebow CORE Analytics Program Certificate for Vanguard

Marketing Analytics and Research expert with experience in Pharmaceutical, Management Consulting and CRM (Customer Relationship Management).

SAS Certified Base Programmer for SAS 9 - Successfully completed the SAS Certified Base Programmer for SAS 9 certification requirements on April, 2013.

Solid project coordination skills with ability to contribute as a creative team member while maintaining focus on timelines and project goals.

PROFESSIONAL EXPERIENCE

IKEA August 2022-Current

Conduct advanced data exploration and analysis using modern data mining techniques (including Machine Learning), visualization tools, or a combination thereof, to provide insights that help co-workers and stakeholders make better decisions o Evaluate the potential and usability of raw, unstructured internal and external data sources for use in product analytics and data-driven decision-making in general o Write highly elaborate SQL queries that Extract, Transform and Load data from storage to an appropriate format, using joins, nesting and more advanced operations as an integral component of data processing pipelines, with cost and execution time efficiency at top of mind o Ensure that solutions fulfill and adapt to actual business needs to continuously generate value for Ingka by listening to and guiding fellow team members from Data & Analytics and co-workers from different functions o Lead and educate the organization on agile ways of working in relation to advanced analytics, especially on topics like performance measurement and hypothesis testing by default to maximize key metrics and ensure that we realize the OKRs set by Group Digital o Proactively manage relevant organizational processes, including meetings with relevant stakeholders and/or teams to drive an intended outcome and ensure that analytics solutions are built according to best practices

Vanguard November 2018 - Present

1. Supported in current role the Analytics team to provide the analytics solutions as RIG wide initiatives are balanced with line specific / sub-division demand (Go Digital)

2. Partner with Analytics Partners (Go Digital) to apply CX analytics to scored clients across various Models

3. Internally, collaborate with other analysts on projects that integrate VOC, client and operational data.

4. Investigated and streamlined the back end process for asset distribution with analytical insights on capacity savings and efficiency improvement

5. Transform the analytics into BAU report to create Tableau Dashboard Report. This clearly outlines or demonstrates value of work that I have done in business. Documented the procedure of that Data Analysis projects.

6. Accomplished important milestone and captured proof analytics study point and deliver value to Go Digital.

7. Completed and contributed to the goal of capacity generation in Go Digital. I have streamlined the back end process for asset distribution

8. Informed the ideation of analytic opportunities to influence business requests and deliverables

9. Uplifted Technology and Tools: Complete analytics training and enablement curriculum with Lynda Data Science Catalog, Drexel and utilizes statistical procedures in delivered projects.

10. Continue to Operationalize and Integrate Business and Voice Analytics intelligence to support Strategic Initiatives aimed at growth, digital containment, operating efficiency and client experience.

11. Delivered projects that included in depth studies or Quick hit analyses on client impact and operational measures related to analytics. Identified opportunities to improve the effectiveness and quality of data and analysis.

12. Built SAS and SQL queries to extract information using various data mining software applications. Applied my understanding of Vanguard's business to analyze and interpret the data.

13. Collaborated and work with other divisions, primarily IT and RCAS. Collaborated with data owners and IT to obtain data from all relevant Vanguard data systems.

A. Created study that has produced output of substance and that is incorporated Go digital published Dashboard. Big contribution to the year-end dashboard report. Transform the analytics into BAU report to create Tableau Dashboard Report. Completed and contributed to the goal of capacity generation in Go Digital.

Synchrony Financial – 1 Dec 2014- Current As a member of the Risk Data Governance team, I have provided required support to IT and offshore team to complete all ALM UAT testing and Unit Trending activities within timeline. I have also been engaged actively in learning and taking ownership of the data tables improvement process.

Build automated SAS code to automate and run UAT tests for Release 1. Recognized and awarded for coding credit line assignment process. Working with Toad to extract data from RDG data warehouses.

Demonstrated my communication skills by effectively addressing data issues in the meeting and calls. Improved my leadership skills by managing off shore team on UAT testing and Unit trending analysis initiatives.

Contributed to the opening and validation of IT tickets on potential data issues within timelines. Actively completed the data testing activities and I have delivered quality output with no surprises on data accuracy while working on data mapping document, default values, data dictionary and other supporting documents.

Streamlined look-up table process, delivered unit trending analysis, engaged in work stream requirement discussion and opened IT tickets for potential data issues.

Recognized by the team and received Synchrony Stars Award Nova (Cash) Award along with other Risk Governance Team member.

Boehringer Ingelheim - BI July 2013 – 30 Nov 2015

Commercial Business Operations - Sales Force Optimization - Senior Analyst

Responsible for sales planning and alignment processes requiring timely delivery and execution prior to every POA. Supported sales planning and alignment process that determined sales representative requirements, designed geographical assignments, and thereby defining target customer base and sales activities.

Managed and delivered detailed sales plan diagnostics process measuring strategic sales coverage of BI brands, defining changes in target counts, and product details. Developed and maintained direct relationship with management addressing details such as sales plan national targets, excess capacity utilization, sales plan detailing and measuring reach in all target segments.

Streamlined, automated and implemented the sales plan diagnostic processes to improve turnaround time, decision making, and reduce cost during sales plan cycles to support a process improvement initiative. Communicated and collaborated with other teams to implement new sales force structure process.

Assist in developing and implementing the HCP and account based call plans process for BI products.

Citizens Financial Group (CFG) - Royal Bank of Scotland Jan 2011 – Mar 2013

Responsibilities include: Credit Risk - Maintain Credit Card solicitation process and ensure pre-approval processes are all functioning as expected by Credit policy design and regulatory requirements. Provides analytical support to team in terms of target expansion strategies and implementation, as well as producing, validating and analyzing credit cards activity for monthly and ad hoc process.

Developed solutions to a variety of complex problems, including those not covered by policies and practices and may require significant interpretation.

Developed daily and monthly reports with key performance indicators to track promotional activity in credit card channel.

Worked on efforts to pull data source from different warehouses. This is to understand different channels disparities to align where prudent to ensure consistent customer treatment.

Investigated and resolved queries in regard to credit cards data, as well as making adjustments to campaigns.

Modified and developed reports for quality check analysis on large datasets to ensure data accuracy. Investigated the data anomalies and trends.

AC Nielsen -BASES Jan 2010 – Aug 2010

Responsibilities included: New product launches and line extension business

Mined and organized data based on client business issues. Conducted statistical hypothesis testing, linear and nonlinear regression analyses, correlation analysis and other statistical analysis for proposing preliminary solutions.

Built logistics regression model to identify main drivers of the business sales. Did marketing mix modeling to optimize the Pricing, Marketing and Promotional activity.

Accenture Aug 2006 – Oct 2009

Responsibilities included:

Identified and designed solution to business problems using various statistical techniques like Logistic Regression, Time Series Regression, Segmentations, etc.

Applied analytical skills to analyze large data sets; constructed and reviewed regression model, sales performance management analysis, sales, pricing and profiling analysis.

Telecom Wireless Client- Segmentation and Customer Retention Project:

Identified top 10 profitable content providers from a pool of more than 400 providers by integrating huge data sets, performing segmentation (profiling) & quantitative analysis on content providers for strategists to come up with schemes offering incentives to the customers – more profitability and lower customer attrition for the Client.

Churn Modeling and Segmentation Analysis project:

Researched & identified key drivers resulting in high customer attrition (80% customers left after 3 months) using data sets integrated into data mart, logistic regressions to create strategic models, cross-sell association rules & campaigns.

Worked with SQL query analyzer for pulling data from different warehouses for generating reports.

Proposed customer retention strategy for running promotional campaigns on selected customer base.

Global Operations Center of Information Resources Incorporated (www.infores.com, Symphony Services Private Ltd) May 2005 - Jun 2006

Associate Consultant /Analyst – Responsibilities included:

Experience in evaluating volumetric sales potential and Forecasting of new and existing products.

TECHNICAL PROFICIENCIES

Data Mining Software MS Office, MS Excel, MS Access; Statistical Packages: SAS

EDUCATION

Masters in Economics, Delhi School of Economics, Delhi University, India; Aug 2003 - May 2005

Masters of Economics(Previous), Jamia Milia Islamia, JMI University, India; Jul 2002 - May 2003

Bachelors of Arts (Economics Honors), Shri Ram College of Commerce; Delhi University, India; Jul 1999 - May 2002

Possess authorization to work in the US - Green Card

SAS Certified Base Programmer for SAS 9 issued on April 03, 2013

AWARDS RECEIVED

5 awards received at Synchrony Financial for outstanding performance

Contact this candidate