Operations Analyst

SAHIL KOHLI

***A **nd Street Brooklyn NY ***** 917-***-****

*****.*****@***.*** linkedin.com/sahilkohli26

EDUCATION

New York University Tandon School of Engineering Brooklyn, NY Master of Science in Management of Technology, GPA: 3.8/4.0 May 2017

• Honors: Awarded graduate merit scholarship

• Coursework includes: Business Analytics, Financial Risk Management, Project Management, Management Science GGS Indraprastha University New Delhi, India

Bachelor of Technology in Mechanical and Automation Engineering, GPA: 3.4/4.0 May 2014

• Relevant Projects: Cantilever buckling analysis using MATLAB, Inventory optimization modelling using Excel SKILLS

• Programming Languages: Python, R Programming, MySQL, SAS, VBA, MATLAB, C

• Tools: Tableau, MS Excel, QM, Solver, MS Access, Qlikview, Agile, MS Project, MS Visio, DBMS

• Certifications: Bloomberg Market Concepts, Google Analytics, Google Adwords

• Analytics: Data Mining, Case studies, Predictive modeling, Regression, Use cases, Visualization EXPERIENCE

Finance and Risk Engineering, NYU Brooklyn, NY

Operations Analyst March 2016 – Present

• Create and maintain the 1000+ student database system and perform analysis to generate results using MySQL

• Generate detailed reports in Tableau based on demographic and educational student data to forecast future enrollments

• Determine the department funding by performing Use Case analysis on the enrollment and financial aid data

• Monitor operations and provide recommendations based on KPI’s to increase efficiency of business processes Assessment and Institutional Research, NYU Brooklyn, NY Data Analyst December 2015 – January 2016

• Analyzed and documented detailed institutional reports using PivotTables and VLOOKUP function in Excel

• Prepared electronic versions of 40 years of data to extract historical trends to improve University ranking using Tableau

• Designed and conducted feedback surveys to evaluate academic program, course methods, and student progress

• Extract vital information from surveys using Topic Modelling in R programming to generate course feedback reports Indo Overseas - India New Delhi, India

Technology Associate May 2014 – June 2015

• Successfully developed and deployed a Python based inventory ordering system for the company cutting time and costs

• Converted production and sales data into reports for optimum scheduling using SQL leading to 20% increase in production

• Developed routing models using Excel QM and Solver tools for channeling and transport of wires and cables produced at 3 facilities to clients in India and UAE

• Improved the asset management at the company by providing insights on financial performance and resource handling ACADEMIC PROJECTS

Vision Zero - NYC Big Data Analytics

• Determine the predictor variables for the causes of accidents in New York City using data spanning over 4 years

• Techniques used included Time Series, LDA, Topic Modelling and Tableau Dashboard Credit Default Swap & VaR Analysis Financial Risk Management

• Plot the shift in correlation values between AIG’s Equity index and CDS values during the 2008 crisis

• Calculate AIG’s Value at Risk, Corporate Risks, Credit Risks and FX Risks using PerformanceAnalytics package in R Sony’s Decreasing Market Share Capstone Project

• Documented a case study to thoroughly analyze Sony’s depleting market share in the electronics industry using techniques such as SWOT analysis, S-curve, User utility map and strategic profiling Alien Invasion A 2-D Python game

• Created a 2-dimensional arcade-style game in Python using the Pygame platform Object Inspection and Rejection Machine Final Year Project

• Designed and fabricated a fully functional bottle inspection conveyor belt system. Programmed sensors to detect required bottle parameters using Arduino Uno kit

LEADERSHIP

• Technical Head, Techsurge and Mridang (2013-2014) Lead a 16-member team to deploy/manage technical solutions on mobile application and website for the festival

• Vice President for 3 years at The Green Concept, an environmental reclamation club with over 200 members

• Coordinator at the Consulting Club, where managed seminars and consulting cases for the 150-member club

Contact this candidate