Data Analyst

VAIDEHI DESHPANDE

** ******** ***** *** *** ***, REVERE MA 02151, 857-***-****, ***********@*****.*** WORK EXPERIENCE

Grand Circle Travel - Senior Data Analyst May 2019 – Present

• Led multiple Data Warehouse projects in Agile setup across travel booking, browsing and survey data for 200K customers

• Performed end-to-end cross-functional testing for product webpage updates and designed comprehensive test plans with granular test cases that augmented overall customer engagement by 15%

• Coordinated with stakeholders to extract, analyze & test unidentified customer web activity data that improved sales by 20% YoY

• Developed data pipelines to profile data from disparate sources, apply transformation logic, integrate and load into Tableau dashboards displaying WoW trending analysis for critical metrics leading to enhanced marketing strategies

• Re-engineered complex PL-SQL queries to analyze web browsing data that improved ETL job execution time by 40%

• Mentored 2 offshore team members and project-managed their daily tasks based on changing business priorities Grand Circle Travel - Data Analyst Mar 2018 – May 2019

• Executed source-to-target testing for customer survey data and verified follow-up email deliveries for 5000 travelers each month

• Performed exploratory analysis on 2-year data for high-value customers to ensure top product marketing adding 20% to web traffic

• Increased YoY profit by $300,000 by analyzing booking data and suggesting changes to existing discounts offerings to customers

• Designed and executed A/B testing for vendor data quality software which reduced escalations on business-critical attributes by 80%

• Built new and enhanced existing Tableau data quality dashboards to report and present KPIs to executive leadership MassDoT/MBTA - Data Management Assistant Jan 2017 – Jul 2017

• Integrated transactional data from 4 vendors for 98 parking lots to deploy SQL data warehouse; boosting analyses by 85%

• Created T-SQL scripts to analyze 1TB data, calculate median space utilization & time for lot’s peak capacity

• Built lot utilization dashboard in OBIEE to enable users find optimum parking spots, reducing rush hour bottlenecks by 98%

• Transitioned data from legacy to new queuing system, reducing RMV customer wait-times by 75%

• Determined factors leading to loss of data from commuter rails by performing multiple linear regression with 90% accuracy SAP Labs India – Technology Consultant Sep 2013 - May 2015

• Led upgrades on 6 business critical SAP Data Warehouses; reduced downtime by 99.9% and improved performance by 200%

• Installed data provisioning agents between source SAP and HANA systems that ensured 100% real-time data replication

• Managed transition of critical customers from legacy database systems to HANA with > 95% customer satisfaction reported Cognizant Technology Solutions- Technology Analyst Jun 2010 – Sep 2013

• Designed a customized transport workflow that ensured software compliance and reduced data migration faults by 90%

• Interfaced between the development and functional teams to improve mean processing time of reports by 15%

• Managed user master data for 80k users across 3 continents & 4 landscapes, complying with SOX guidelines

• Trained 4 SAP security consultants for Managed Services model to facilitate round-the-clock client support EDUCATION

Northeastern University, Boston, MA Dec 2017

Master of Science - Information Systems

Coursework: Data Design & DBMS, Data Warehousing & BI, Big Data Management, Advances in Data Sciences, Java, Web Design Vishwakarma Institute of Technology, University of Pune, India May 2010 Bachelor of Engineering – Electronics

Coursework: Computer Organization & Architecture, Data Structure & Files, Coding & Data Compression, Computer Networks ACADEMIC PROJECTS

Federal Reserve Economic Data Analysis, Advances in Data Sciences Apr 2017

• Performed wrangling, transformation and exploratory analysis using Python on 5GB data to analyze trends across 6 states in US US Health Insurance Marketplace: Big Data Management Nov 2016 – Dec 2016

• Analyzed trends using MapReduce on 10GB data and identified key metrics to filter most beneficial insurance plans across country Sales Data Warehouse, Data Warehousing & Business Intelligence Jul 2016 – Aug 2016

• Implemented an enterprise-scale Sales Data Warehouse integrating 2TB data from diverse sources and built interactive dashboards TECHNICAL SKILLS

• Tools and Technology: MS Excel, Toad for Data Analysts, Tableau, Qlik, Toad Data Modeler, Talend, SSIS, Hadoop-MapReduce

• Databases/Datawarehouse: MSSQL, Oracle 11g, SAP HANA, MySQL, Sybase, PostgreSQL, HBase, MongoDB

• Languages: T-SQL, PL/SQL, R, Python, Java, JavaScript, AngularJS, HTML, Shell Script

Contact this candidate