Project Management

Janeet Arora https://www.linkedin.com/in/janeet-arora-258642

Hartford, CT - 06103, USA. +1-209-***-**** ******.*****@*****.***

Highly skilled Data Analyst with end to end domain knowledge of business processes having MBA Finance and MS Analytics degrees. Determined and focused with a proven work history of succeeding under challenging conditions.

ACADEMIC PROJECTS

Optimum Portfolio Allocation: R-Studio April2017

An R Project to recommend the optimum portfolio allocation given the investment goals and acceptable risk.

Forecasting Food Demand: Developed a forecasting model to forecast the food demand at Apollo hospitals for different food items with a prediction accuracy of 64% March2017 Data Visualization and Communication with Tableau for San Francisco Bike Rentals Presented Visualizations providing insights into how the company can increase its profitability through more efficient use of its parking lots and increasing availability of Bikes at the busiest station. San Francisco Crime Classification: SAS JMP, Tableau, MS PowerPoint Dec2016 This study was conducted on San Francisco crime data. The goal of project is to predict likelihood of next occurrence of crime in San Francisco region. Mega Corporation and the ERP Decision: MS Excel’s Analytical Solver Platform Dec2016 The study was conducted on Mega Corporation. The goal of the project is to build sample portfolio to see if Mega Corporation can implement ERP/CRM system. The project uses spreadsheet analysis with scenario manager, what-if analysis, and risk-analysis simulation. UCONN Graduate Consulting Club: April 2017 Consulting with “Phood Solutions” as part of pro-bono consulting engagement under UCONN Graduate consulting club. Conducting market research for Phood Solutions.

WORK EXPERIENCE SKILLS

Functional Skills Data Analysis, Financial Modelling, Portfolio Management, Asset Management, Equities, Derivatives, Capital Markets

Modelling Tools JMP(SAS Gui), R, Tableau, SAS

Business Tools

MS Visio, Proficient in MS Excel/VBA Modelling, MS Project, MS Access, My Sql, MS Office, Bloomberg Platform

ERP

Oracle Apps 11i and R12 Financials,

Way2Wealth Brokers Ltd., Punjab, India April 2010 – Jun 2016

Quantitative Analyst

Performed client data analytics to find cross selling opportunities.

Conceptualized a trading algorithm and turned it into an end-to-end working product.

Ran portfolio analysis and commentaries for HNI clients and investors

Developed portfolio tools and performed in-depth quantitative analysis on equities

Worked closely with high net worth individuals in formulating asset allocation strategies tailored to current needs, long term goals and risk tolerance.

Bull Forge Pvt. Ltd., Ludhiana, India (www.bullforge.com) May 2012 – Oct 2014

Co-Founder, Director

Designed, planned and setup a manufacturing unit for forged steel auto parts

Developed a plan and received buyoff from all stakeholders to deploy machinery and equipment

Maximized energy and cost savings while procuring and importing electrical equipment

Bootstrapped manufacturing unit by receiving a sales order to kick-start manufacturing process

IBM Global Services, Gurgaon, India May 2007 - March 2010

Finance Functional Consultant ERP

Consultant for Airtel, India to implement revenue accounting of their business in Oracle Apps ERP

Lead consultant for John Lewis, London to implement Payables and Receivable Oracle R12 module

Successfully completed two full life cycle implementations of payables and receivables of Oracle ERP which brought transparency and reduced costs significantly for both the clients

EDUCATION

MS Business Analytics and Project Management

University of Connecticut School of Business, Hartford, USA

Aug 2017

Master of Business Administration, Major: Finance

Punjab University, University Business School (UBS), Chandigarh, India

April 2007

B- Tech, Computer Science

Guru Nanak Dev University, Amritsar, India

July 2005

CERTIFICATIONS AND ACHIEVEMENTS

NISM-Series-VIII: Equity Derivatives Certification and NISM Series I: Currency Derivatives Certification

Member of United States Tennis Association with rating 4.5

Contact this candidate