Ridhima Dhawan

469-***-**** ac2ege@r.postjobfree.com LinkedIn 91 Beechwood Place, Plano,TX-75075 EDUCATION

The University of Texas at Dallas May 2017

M.S., Information Technology Management 3.82 / 4.00 Rajasthan Technical University, India June 2011

B.Tech., Information Technology 3.75 / 4.00

TECHNICAL SKILLS

Certification: Google Analytics IQ, Google AdWords Languages: R,SAS, Python, STATA, SQL, SSRS, SSIS, SSAS Analytics Tools: SAS Enterprise Miner, Tableau, MS Excel, R, Omniture ETL/DW/Reporting: SAP BW, SAP HANA, Business Objects, Cognos Database: Teradata, Oracle, MySQL, SQL Server, MS Access BI & Analytics skills: Data Mining, Visualization, Statistical Analysis, Predictive Modeling, Forecasting, A/B Testing, Test and Control Design

Project Management: JIRA, MS Project, Agile,SCRUM, Waterfall, Requirement Analysis, Fit/Gap Analysis, SDLC, STLC BUSINESS EXPERIENCE

Accenture Aug 2011 – July 2015

Business Analyst

• Performed quantitative analysis and provided recommendations on customer complaint data for various business regions using SQL and Tableau for risk mitigation planning to help improve customer satisfaction index by 2.5%

• Designed 5 new performance metrics dashboards for internal and external stakeholders using Tableau & Qlikview to restructure the reporting process and improving visibility for management executives

• Led a team of 20 as project manager to deliver 2 major sprints of the key release of complaint portal and was recognized with Accenture SPOT award

• Optimized functioning and directed process improvement efforts using Lean Six Sigma methodology for the billing module by identifying underperforming blocks of code

• Directed weekly cross-functional team meetings for forecast, inventory, and sales operations continuous improvement processes

• Mentored 5+ new joiners by facilitating knowledge transfer sessions and orientation manuals for smooth transition

• Led multiple rounds of UAT by identifying the appropriate stakeholders and created executable test scripts

• Analyzed UAT and regression testing results from users and conducted multiple rounds of defect testing to resolve any issues within the system leading to final sign-off from the users PROJECTS

Customer Acquisition & Segmentation – ShipBob Data Challenge Apr 2017 - May 2017

• Defined the various customer segments using RFM and cluster analysis in R and studied segment behavior

• Analyzed the churn rate for each segment and calculated their average lifetime value

• Evaluated the ideal cost of acquisition for each segment and developed the marketing strategy around it Marketing Predictive Analytics on Product Retail Data using SAS Feb 2016 – May 2016

• Analyzed store and panel level data having million transactions spread over 10 years for retail and consumer analytics

• Segmented customers,assessed loyalty patterns and price elasticity metrics to find market insights

• Recommended promotion strategies to the 2nd best brand based on competitor analysis and customer profiling Google Online Marketing Challenge Feb 2016 – May 2016

• Devised an online marketing strategy for our e-commerce client dealing in infant gifts and managed their GA account

• Identified Advertising goals and KPI`s and emphasized on choosing right key words

• Increased website traffic by ~27%; increased the number of signups and baby registries Business Intelligence -Analysis using R, Kaggle Dataset Sep 2015 - Nov 2015

• Performed descriptive analysis on 116 factors to identify key factors affecting a start-up’s success

• Cleaned data and achieved dimensionality reduction up to 90% using clustering and principle component analysis

• Proposed an 86% accurate data model to facilitate investment decision of an angel investor in a startup

Contact this candidate