Data Management

SAHIL JHAVERI, MBA Jersey City, NJ 508-***-**** ********@******.***

https://www.linkedin.com/in/sahil-jhaveri-209b1344/ MBA certified finance professional with 2 years of experience in finance and banking domain as Business Analyst with solid understanding of business process modeling, agile software skills and data analysis. Risk Management Process Improvement Reporting & Presenting Market Research Optimization Predictive Modelling Test Proctoring Statistical Analysis Financial planning & analysis Data Mining SDLC TECHNOLOGY SKILLS

Agile, Bloomberg Terminal, Tableau, Jira, IBM Watson Analytics, OLAP, Data Visualization, Oracle, R Studio, SQL, Access, Excel, Macros, PowerPoint, SLATE, NetSuite, Pivot Tables, VLOOKUP, HTML & CSS PROFESSIONAL EXPERIENCE

StHealth Capital Investment Corporation, New York, NY Aug 2018 to Nov 2018 Analyst-Intern

• Analyzing current and past financial data and performance

• Preparing reports and projections based on the analysis

• Evaluating current capital expenditures and depreciation

• Exploring investment opportunities

• Identifying trends in financial performance and providing recommendations for improvement

• Coordinating with other members of the finance team to review financial information and forecasts University of Massachusetts, Dartmouth, MA Sept 2017 to May 2018 Graduate Assistant

• Extracted and organized data for nearly 50% of listed companies on NASDAQ.

• Managed applications on SLATE (Admissions Software), performed analysis, created reports by running queries in SQL to facilitate management decision.

Royal Bank of Scotland, Mumbai, IND Oct 2014 to July 2016 Agile Business Analyst

Associated with the Online Credit Card Marketing Division’s Promotional Rewards Engine which was to track and qualify the transactions or behaviors and calculate the promotional rewards earnings for consumer card members Services. The Promotional Rewards Engine would only identify the rewards offers that were entered and stored on the Offer Management System. Worked with the Rewards Redemption Application. RRA included the steps to ensure all point transfers, adjustments and redemption errors were communicated and settled between fulfillment ecommerce vendors and Credit Card Services. The main functionality of the application was to process and store all the files coming in and out of Credit Card services and to create missing files reports on a daily.

• Gather requirements from Product Owner, Quality managers at various departments.

• Created Product Backlog, Sprint Backlog and managed User stories.

• Led daily stand-up meetings.

• Coordinated with the team to help them better understand the requirements and corresponded the management of project on MS SharePoint.

• Prepared UML diagrams such as use case diagrams and activity diagrams using MS Visio Nouam Financial Consultants Pvt. Ltd, Mumbai, IND Jun 2014 to Sept 2014 Business Analyst

The project was to provide online trading solution consisting of a window based trading front-end. It consists of an integrated order routing system via the Internet, and a real time, on-line trading tool. This enabled traders to get online and conduct business, analyze the market via graphs and charts available. It also provides payment gateways, portfolio management and a real-time risk analysis and strategic management tools

• Reviewed and updated policies and procedures and communicated them to business partners

• Prepared high-quality documentation for stakeholders and customers

• Documented and preserved service specifications and assisted in their execution

• Organized, conducted JAD sessions for requirements gathering.

• Coordinated and facilitated extensive user interviews and workshops to gather and analyze requirements

• Developed crucial functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specification

Graduate Course Projects – 2016/2018

• Developed an analytically driven interactive Tableau dashboard as a special Business Intelligence project to conduct a Performance Analytics Assessment.

• Created Internal Database System (tables, forms, reports) using Relational Database Management System – Microsoft Access.

• Created a Stock Trak Portfolio and managed it to create a 12-week report on the performance and analysis of securities.

• Created Technical OLAP report for Northwind Traders dataset using Microsoft Access, Excel. (Pivot tables, queries, Data Cubes)

• Developed a Misclassification error report using Decision Tree, Random Forest, Support Vector Machines, Logistic Regression and Neural Networks – R Studio.

• Researched and Developed on how BI n KM help in analyzing the business strategies/data help the growth of supply chain and logistics business to make it profitable.

EDUCATION/CREDENTIALS

Master of Business Administration, Business Analytics & Finance; University of Massachusetts Dartmouth, North Dartmouth, MA, May 2018 Diploma, Financial Management; Prin. L. N. Welingkar Institute of Management Development & Research, Mumbai, IND, Dec 2015 Bachelor of Business Administration (HONS), Accounting; Kingston University, London, UK, May 2014 Certification: Introduction to Corporate Finance (CFI), Excel (CFI), Fixed Income (CFI), Reading Financial Statements (CFI), Master Tableau in Data Science (Udemy), Big Data (Cognitive), Blockchain Essentials (Cognitive), Bloomberg Market Concepts

Contact this candidate