Data Analyst Business Intelligence Business Analyst

DHRUVIN SHAH

Greater Boston Area, MA +1-646-***-**** ****.******@*****.***.*** Dhruvin’s LinkedIn EDUCATION

Northeastern University, Boston, Sep 2016 – May 2018 Master of Science Engineering Management

Relevant Courses: Data Mining, Financial Management, Economic Decision Making, Business Dynamics, Project Management, Collect Store and Retrieve Data, Operations Research, Engineering Probability and Statistics University of Mumbai, Mumbai, India Aug 2012 – Jul 2016 Bachelors of Engineering in Chemical Engineering

Relevant Courses: Operations Research, Optimization, Process Automation, Engineering Economics and Management. TECHNICAL SKILLS

• MS Office (Word, PowerPoint, Project, Excel {Pivot Tables, VLOOKUP, Solver, @Risk, Power-Get})

• Programming Skills: R, SQL, Tableau, AMPL, Minitab, Python, Power BI, Tally ERP 9.0, CRM, Salesforce

• Lynda.com: Excel Statistics Essentials, SQL Essentials I Google Analytics Certification EXPERIENCE

Northeastern University, Boston, MA. Jan 2017 - June 2017 Graduate Teaching Assistant – Financial Management – Prof. Seyed H. Noorian

• Guided and assisted students in multiple projects for Financial Analysis and Budgeting.

• Evaluated, graded and proctored examinations, assignments, mid-terms, and recorded grades on-line. Prolific Chemicals Private Ltd, Mumbai, India. May 2016 – Aug 2016 Junior Business Analyst (Data)

• Evaluated movements in historical volume to recommend adjustments for forecasting, inventory and backlog management.

• Conducted analysis to estimate financial/operations outcomes by comparing current and historical business trends. PROJECTS

Performance Evaluation of Stock Market using R (R, Python, MySQL, SQLite, SQL Server)

• Collected real-time data using interactive web sources in R Studio.

• Stored the time-sensitive data (xts objects) into data frames to make it easier to visualize and analyze.

• Plotted and evaluated the stock’s performance using industry level candle charts and zoo plots. Predictive Analysis and Management of FIFATM 2018 Database (R Studio, R, MS Excel, SQL, Data Mining)

• Imported and normalized a database of 18000+ player profiles present in globally recognized soccer leagues.

• Retrieved and analyzed the database in R-Studio using Data aggregation techniques like neural nets and regression trees.

• Improved Data Visualization by adding player portraits.

• Conducted optimal performance analysis to measure KPIs and predict Best Teams and Players. Dynamics of Prevention and Treatment of Opioid Addiction (Vensim PLE, Lingo, MS Power-point, MS Excel)

• Created a model and SIPOC diagram determining the dynamics in Opioid addiction from supplier to consumer.

• Determined and simulated the factors involved in the supply and demand of Opioids.

• Created a feedback mechanism determining the steps needed to be taken for prevention and treatment. Venture Capitalist Investment Risk Analysis (MS PowerPoint Excel {@Risk, VLOOKUP})

• Estimated cash flows, defined capital sources using WACC with a Net MARR of 6%

• Accounted for Depreciation using MACRS-GDS and 200% DDB.

• Determined NPW, AW and IRR to complete an After-Tax Analysis of our ventures.

• Visualized and carried out sensitivity analysis using AHP and @Risk (Visualization) in MS Excel. Optimization and Safety Model of MBTA Boston (MS Project, Google Docs-Slides-Sheets)

• Planned the construction of high-tech safety barriers to improve the safety of public stations.

• Designed a time and resource management plan for the complete duration of the construction project.

• Arranged for alternative transportation routes to re-route passengers and reduce inconvenience. VOLUNTEERING EXPERIENCE

• Make A Difference (MAD) – Math/English Teacher, Education Mentor, Community Leader

• National Service Society (NSS) – Head of Public Relations, Event Manager, Volunteer

Contact this candidate