Data Project Management

**** ****** ***** #***, ******* Park MD, *****

EDUCATION

Samyak Shah

240-***-**** ******.****@*******.***.***

Robert H. Smith School of Business, University of Maryland, College Park, MD Aug 2015-Dec 2016 Master of Science (MS) - Information Systems GRE: 325/340; GPA: 3.63/4 Data Models and Decisions, Big Data, Data Mining and Predictive Analytics, Business Process Analysis, Healthcare K J Somaiya College of Engineering, University of Mumbai Jul 2011-May 2015 Bachelor of Engineering-Computer Engineering –First Class EXPERIENCE

Paradyme Management, Greenbelt, MD – Technical Analyst Intern Sep 2016 – Dec 2016

Gather requirements, analyze data, map data sources to target, test user reports, document business intelligence processes, and assist with project management.

Work on T-SQL scripts, stored procedures, views and working on SSIS on SQL Server 2012 of Main Caterers.

Use Rstudio to clean and analyze large datasets and develop a help desk system on JIRA Anthem Insurance Companies Inc, Mason, OH – Database intern Jun 2016- Aug 2016

Build reports and dashboards in Tableau regarding Exadata Capacity Planning and Performance measurement for Oracle Databases.

Developed internal dashboard on Oracle APEX for application development teams to monitor database performance using SQL, PL/SQL & HTML

Writing and debugging SQL and PL/SQL queries for application teams

Analyzed healthcare data of around 100k patients to analyze the disease patterns using ICD-10 codes and how they are related to age, gender, location, etc. using SQL and R programming. RAK Commodities, Mumbai, India - Analyst Intern Jun 2014-Jul 2014

Provided Commodities Analysis and valuation to 20 valued customers of firm

Performed Data Analysis using Excel – Vlookup, Macros, Pivot tables and mark-to market calculation helped to increase prediction accuracy of commodities pricing

PROJECTS

Healthcare Visualization Project Sep 2016- Dec 2016

Developed dashboards and reports using the United States Medicare data to analyze the cost and billing patterns, discharge rates across different states and cities

Peer Evaluation project following Scrum Methodology Feb 2016- May 2016

Acted as the Business Analyst and responsible for the requirements gathering, preparing user stories, task board, Scrum documents and also build a report including UML diagrams, business processes and managing the team for a six week project. Customer Care Database management Sep 2015-Dec 2015

Built a suite with a database backend on SQL Server 2012 with tables, views, transactional queries and frontend on Salesforce.com using reports, dashboards, views, workflow rules, validation rules, permission sets and page layouts for banking data Data mining and Predictive Analytics using R Feb 2016- May 2016

Working on the Rossman Stores Dataset to analyze the data using KNN, naïve bayes, Classification and regression algorithms and predict the store sales for 7 weeks with 95% accuracy. Big data Project Feb 2016- May 2016

Perform predictive and descriptive analytics on CDC Death dataset using Hadoop –Hive, Impala & Spark on Cloudera and AWS gaining 60% accuracy on predictions and visualize using MicroStrategy LEADERSHIP

Youth Vision Consultant, Hanoi, Vietnam Jun 2013- Jul 2013

Planned and managed ‘Vietnam Youth Icon’ project and an event named International Youth Day. Worked with 15 interns from 12 different countries for a month and catered to around 150 delegates AIESEC Navi Mumbai, India Feb 2013-Feb 2015

Arranged Youth Leadership Conference being Core Committee (Logistics) in February 2015 in Silvassa, India catering to 400 delegates from all over country

ADDITIONAL INFORMATION

Technical: Java, HTML, SQL, Salesforce.com, Tableau, R, SAS, Wireshark, Microsoft Excel, Statistical tools( @Risk, PrecisionTree, StatTools, SolverTable), Visio, Rational Rose, Python, SharePoint, Hadoop(Impala, Pig, Hive), Spark, Microsoft Project Management, MS Access, Weka, MicroStrategy, PostgreSQL

Contact this candidate