Data Analysis, SAS, SQL, Data Mining
Resume:
MANSI VORA
Seattle, WA
Ph: +1-425-***-**** E: ************@*****.***
Summary
Dedicated analytics proficient with over 5 years of experience in marketing and retail domains. Can handle tasks independently as well as work in a team, with accuracy and efficiency. Able to play a key role in analyzing problems and come up with creative solutions as well as producing methodologies and files for effective data management. Skills
Analytical Skills:
Look-a-like Model Customer Segmentation
Customer Profiling Trade Area Analysis Campaign Analytics Response Analysis Sentimental Analysis
Technical Skills:
SAS 9.3 (MACROS, SQL and ODS) SQL Server Management Studio Oracle Alteryx 10.1 Tableau 10.0 Map Point R (basic) Microsoft Office (Excel, Word, Power Point) MATLAB (basic) C Programming Experience
Bridgetree Consultancy Pvt. Ltd. July 2010 – Present Project Manager/Sr. Data Analyst
Campaign Analytics
Client: US Based Retail Company
Project Summary: Build Predictive models to identify the potential customers. Data Prep included variable transformations, missing value imputation, outlier treatment, multicollinearity. Logistic model was built in SAS and the model performance was measured by various statistics, scoring the model and validation datasets, creating score deciles, and aggregating sales for each of the deciles.
Mail file Preparation
Client: US Based Retail Company
Project Summary: Data cleansing and hygiene treatment at address, email and phone level. Sorting based on priority order of selection and duplicate checking at various levels. Split the data in main and validation to check response analysis after campaign. Removing records present in the suppression list. Preparation of Waterfall report to track the fall in input quantity in the various steps of mail file preparation.
Customer Profile Analysis
Client: US Based Amusement Park and Entertainment Group Project Summary: File reading, data cleansing and data preparation. Appending demographic information to the customer records through different levels of matching. Preparing demographic and lifestyle profile of the customers. On the basis of demographic profile, selection of prospects for future campaigning.
Response Analysis
Client: US Based Retail Company
Project Summary: Match the transactions from the response time frame to the mailed data and get the actual responses. Calculate various statistics like Response rate, incremental Sales and margin and ROI to measure the impact of the campaign. Customer Segmentation
Client: US Based Sports Company
Project Summary: Performed Customer Segmentation to get a clearer understanding of their customer base. Consequently, helped them compartmentalize their customers, to target them separately. The segmentation facilitated the design of more target-oriented approaches to accrue more sales from different buckets of customers. Data Prep included variable transformations, missing value imputation, outlier treatment and multicollinearity. Factor analysis and Principal Component analysis was done to reduce the variables and clusters was built in SAS. Maintaining, Updating and Reporting on US Voters Population Client: US Based Poll Watching Agency
Project Summary: Maintaining and updating the election data for various US states. Cleaning contact level information. Maintaining different tables in the SQL server for maintaining different levels of information required for generating reports. Generating reports based on survey response analysis and live poll watching data using Tableau. Trade Area Analysis
Client: US Based Healthcare Firm
Project Summary: To identify and surface ideal trade opportunities for new establishments based on zip level profile using the census data.
Sentimental Analysis
Client: US Based e-Commerce Platforms
Project Summary: To get a deeper understanding of unstructured data and correlating it with ratings to identify specific traits to provide targeted feedback to the companies. Education
Academic:
Master of Science: Statistics & Informatics June 2010 Indian Institute of Technology, Kharagpur, WB, India GPA: 9.16/10
Bachelor of Science: Statistics May 2008
Presidency College (University of Calcutta)
GPA: 6.4/10
Other:
Institute of Actuaries of India (IAI)
• CT3 (Probability and Mathematical Statistics)
• CT7 (Economics)
Achievements Ø Received 3 promotions in 5 years of tenure at Bridgetree Consultancy Pvt. Ltd. Ø Best Performance Award for Q3 - Q4, 2012 at Bridgetree Consultancy Pvt. Ltd. Ø Secured 2nd position in M.Sc. (Statistics & Informatics) at IIT Kharagpur Ø AIR 55 in JAM (IIT), 2008
Employment Status: L2 VISA with EAD
Contact this candidate