Sign in

Data Project

Syracuse, NY
March 11, 2019

Contact this candidate



Syracuse University, Syracuse, New York, United States of America Aug 2017-May 2019 Master of Science Information Management GPA - 3.85 RGPV University, Bhopal, Madhya Pradesh, India Aug 2013-May 2017 Bachelor of Engineering Computer Science GPA - 3.49 COURSES

Technical - Database Systems, Data Warehouse, Applied Data Science (R), Big Data Analytics (Python), Data Mining Management - Agile Project Management, Enterprise Risk Management, Business Analytics, Economics for Business Managers TECHNICAL/CONSULTING SKILLS

Programming Skills - R, Python, SQL

Analytics & Visualization - Apache Spark, SSIS, SSRS, SSAS, Tableau, PowerBI, Tibco Spotfire, MicroStrategy Database Systems - MS-SQL Server, MS-Access, MySQL, Oracle, MongoDB Business Analysis & Project Management - Advanced MS-Excel, MS-Visio, MS-Project, MS-Office Suite, JIRA, Trello Consulting Skills - Scrum, Kanban, SDLC, System Analysis, Project Management, Business Case Development WORK EXPERIENCE

Business Technology Analyst ZS Associates, San Francisco, California Jun 2018-Aug 2018

• Designed & developed Tableau dashboards that increased marketing campaign efficiency by 6.3% for a Fortune 200 pharma client

• Created quality check metrics & prepared VBA scripts to evaluate & reduce inaccuracies in medicinal marketing datasets by 12.5%

• Documented technical & functional requirements by conducting client interviews & brainstorming sessions with technical teams

• Led offshore team meetings to automate & enhance client’s reporting system & designed UAT as well as functional test cases Business Intelligence Analyst iConsult, Syracuse, New York Aug 2017-Dec 2017

• Created data pipelines using Python & SQL to automate extraction & cleaning of City of Syracuse’s water supply databases

• Generated PowerBI based 360 business dashboards with multiple panels to identify & reduce business process inefficiencies

• Built a database application for a pharma client using MS-Access & SQL, increasing the data retrieval & storage efficiency by 27% Business Technology Analyst MoreYeahs Inc, Indore, India Apr 2016-Aug 2016

• Gathered client’s business requirements through interviews, prototyping, document analysis & workflow analysis

• Prepared use cases, process flows & test plans based on user stories & out of scope requirements for multiple clients

• Led workshops to train client teams on utilizing the deliverable & documented future requirements from key stakeholders

• Mapped an ERD schema & developed the physical schema for an inventory management app using MS-Visio & SQL LEADERSHIP

• Creativity lead at Nanhi Kali - Organize fundraisers to raise money for providing education to unprivileged girls in India

• Co-founder of a marketing app BUISSEXPO - Provided a platform for small businesses to market & network with customers

• Data-entry head for a UNICEF project - Led a team of 6 which conducted & documented surveys in Shivpuri district ACADEMIC PROJECTS

Income Prediction – US Census Income Dataset Python, Apache Spark Aug 2018-Dec 2018

• Prepared US Census dataset for ML by performing exploratory data analysis, feature engineering & dimensionality reduction

• Achieved an accuracy of 83% in predicting annual income of employees using logistic regression & random forest models Zomato Rating Recommendation System Python Jan 2018-May 2018

• Explored Zomato dataset by utilizing NumPy, Pandas & Scikit-learn libraries to clean the dataset & predict restaurant ratings

• Analyzed Twitter feed for Zomato by performing sentimental analysis on all restaurants to gather their popularity quotient

• Combined predicted ratings & popularity quotient of restaurants to develop a new restaurant rating mechanism for Zomato International Recruiting Campaign by Syracuse University MS-Excel, MS-Access Dec 2017-Feb 2018

• Applied regression, VLOOKUP, pivot tables to find patterns between the recruiting process & total recruits over the years

• Gathered insights to create a business plan that would increase the number of recruits by 7% & reduce recruiting costs by 29K Hyatt Hotel Data Analysis R, Tableau Sep 2017-Dec 2017

• Identified correlations between falling customer satisfaction and hotel attributes using linear regression, SVM & apriori models

• Built a BI dashboard in Tableau highlighting Hyatt’s current bottlenecks & future improvements to increase customer satisfaction

Contact this candidate