ROMIL GODHA
ac8qyf@r.postjobfree.com 315-***-**** www.linkedin.com/in/godha-romil03 https://github.com/romil5044 EDUCATION
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