Nidhish Shah

Professional Summary:

Proficient Business/Data Analyst with experience in fields of Information Technology and Finance Industry.

Experience in capital markets, Asset management/Portfolio management, Wealth Management, Risk management, Investment banking and Regulatory Reporting.

Knowledge of Capital Market instruments like fixed income, Derivatives (Swap, Options, Warrants), Equities, Bonds, Structured Products, Foreign Exchange, Securities and Hedge Funds/Mutual funds. Knowledge of trade life cycle, Loan Cycle.

Worked with compliance like Basel II and III; (BCBS)Dodd-Frank Act, CCAR (FRY 14A, FRY 14M) for defining and validating capital requirements.

Expert in preparation of Business Requirement Document (BRD), Functional Specifications, System Requirement Specification (SRS), Data element documents.

Deep insights and efficiency in SDLC methodologies like Agile Scrum, Waterfall.

Excellent documentation skills and experience developing Test Cases, defect tracking and Requirement Traceability Matrix (RTM).

Worked with compliance like Basel II and III; (BCBS)Dodd-Frank Act, CCAR (FRY 14A, FRY 9C, FRY 14M) for defining and validating capital requirements.

Expert in conducting User Acceptance Test (UAT), System Integration Testing (SIT), Regression Testing, Functional Testing.

Expertise in Data Modelling, Data Analysis, Data Warehousing and Data Mapping, Development of Entity Relationship diagram, SQL and reporting process.

Technical Background and initiating experience of SQL, Excel Modeling, and MS Access to communicate with the IT team and assist in design, development and implementing the projects.

Understanding of the fundamentals of data bases and data structures

Excellent Interpersonal, negotiations and presentation skills.

Organized, goal oriented, priorities multiple task effectively, exceptional problem solving and sound decision-making capabilities with excellent Communication and Analytical skills.

Professional Experience:

PNC Financial Services

(Business Analyst/Data Analyst) Pittsburgh, PA January 2017 - Present

Project 1

The project involves supporting the Capital Markets and Fixed Income team within Risk Management, in building a platform that would integrate the data from different sources, aggregate it and make it available to be consumed by various models. The platform (CCAR central Database) would relay the aggregated data, for creating the CCAR (regulatory/compliance reporting standard) results for reporting to the Fed Reserve (XML format), to the Reporting Layer (Tableau based platform)

Lead the technology team in gathering and analyzing the business requirements (BRD) based on the guidelines of Dodd Frank Act and CCAR (regulatory reporting standard - BCBS). Responsible for defining the scope and creation of lineage documents for CCAR Central database for FRY-14A submissions.

Involved with mapping and applying notional calculations (based on Macro Economics and Capital growth rates, Operational Risks, Retail/Mortgage Repurchase and Credit Losses) to the underlying system.

Manage individual work-set project plans and gathering functional requirements by following a mixture of Waterfall and Agile SDLCs.

Create data flow / process flow diagrams using MS Visio for requirements and reporting purposes.

Created the Functional Requirements (FRD) to enable the developers to setup the system per the user’s need.

Responsible for data profiling of the source systems required to input data to the CCAR Central Database using various SQL queries for the SQL Databases (Oracle/SSIS). Responsible for ongoing development of key data quality and data profiling processes required for CCAR and other Risk/Regulatory (Compliance) initiatives using the SQL queries

Managed validation/testing criteria to ensure the data is consistent to the overall defined data related requirements.

Validated data between the Oracle databases excel inputs (source) and Tableau reports to ensure computation accuracy.

Responsible for training the users in the User Interface and the features/functionalities of the User Interface (UI).

Tools: Microsoft Office (Word, Outlook, Excel, Visio), Oracle, PL/SQL,SSMS/SSIS, Tableau,Informatica Vena, OLAP, VBA,Macro,HP ALM

(Business Analyst/Data Analyst) Pittsburgh, PA

April 2015 – January 2017

Project 2

Focused in area of 14M schedules of CCAR understanding the business requirements in building schedules in Vena based on the requirements drafted by the business users.

Created the Functional Requirements (FRD) to enable the developers to setup the system per the user’s need.

Performed for data profiling of the source systems using various SQL queries for the SQL Databases

Worked with ongoing development of data quality and data profiling processes required for CCAR and other Risk/Regulatory (Compliance) initiatives using the SQL queries

Managed validation/testing criteria to ensure the data is consistent to the overall defined data related requirements.

Validated data between the various databases, excel inputs (source) and Tableau reports to ensure accuracy.

Responsible for training the users in UAT and explain the features/functionalities of the User Interface (UI).

Tools: Microsoft Office (Word, Outlook, Excel, Visio), Oracle PL/SQL, SSMS/SSIS, Tableau, Informatica,Vena, OLAP, VBA Macro,HP ALM

Wells Fargo

(Business Analyst/Data Analyst) Chicago, IL August 2013 – March 2015

The project was based on creating a user interface application for user convenience to process 14M schedules of CCAR(BCBS) related data. The project was to develop and enhance the UI to give the users the ability to view their respective data processes, carryout data transmission and view the progress of their data transmission process status during the submission. Implemented the Waterfall methodology.

Responsible for scribing requirements from sessions held for requirements (Technical Writer) gathering from clients and SMEs. Worked in support with the Asset and Liabilities Management Group, Quantitative Risk Management Group and Credit Loss teams.

Finalized and documented the business requirements and Functional requirements based on the requirements of the clients, documenting the need of the alerts and processes built in the User Interface.

Created Use Cases, Business Workflow diagrams, and assisted the development team in creation of the System Requirements Specification Document.

Responsible for creating the MS Visio diagrams describing the architecture and design of the system. Also created and reviewed the wireframes and screen mock-ups with the users. Assisted the Tableau developers on building the real-time individual process status workflow diagrams in Tableau

Assisted in creation of test deliverables like the test plans and test cases and assisted the Quality Assurance team in testing of the product.

Involved in the User Acceptance Testing phase and communicated the user’s suggestions/concerns to the development team.

Tools: Microsoft Office (Word, Outlook, Excel, PowerPoint), Jira, Oracle PL/SQL, Tableau

MB Financials

(Business Analyst/Data Analyst) Chicago, IL December 2012 – July 2013

The basis of the project was to develop a technology-driven approach to research appropriate capital markets instruments to maximize portfolio(Wealth Management )returns. The project involved in creating and managing a portfolio managemen(Wealth Management) system that provided access to information for equity research with future predictions using fundamental ratio analysis to invoke them in their portfolio (Wealth Management )for immediate successful gains

Responsible for gathering business requirements (BRD and FRD) and involved in building a Microsoft excel model (financial forecasting) utilizing VBA macro to rank equities of 600 companies using securities valuation models from the various company’s financial ratios

Incorporated the market information from Yahoo Finance and included the live streams using Bloomberg Terminals.

Model determines the rank of the companies in the equities market and gives a fair idea whether it is worth to invest in the particular company or not. The company list consisted of companies from $4.5B to $500MM in revenue and EV/EBITDA ratio from -220 to +250

Contributed to creation and management of mapping documents during the initial stage of building excel based database for housing the results of the model.

Responsible for creation of key testing deliverables. Managed data profiling processes required during the development phases. Ensure data integrity and accuracy across the systems, namely data pull from Bloomberg and the data utilized/calculated by the in-house model.

Responsible for imparting the training to the equity research analysts team (user of application) and also conducted the UAT to give the users more confidence on the use of the application

Tools: Microsoft Office (Word, Outlook, Excel), VBA Macro, Bloomberg

Microcon

(Business Analyst) Mumbai, India April 2011 – May 2012

The project was designing and creating a prototype of the Building Management System (BMS) is a computer-based control system installed in buildings that controls and monitors the building’s mechanical and electrical equipment such as ventilation, lighting, power systems, fire systems, and security systems

Involved in development of BMS (Building Management Systems), supporting the team with the requirements, updating and modifying the requirements documents

Responsible for managing the testing for the system, including the creation of test documents and supporting the UATs. Involved in testing the data storage using Oracle and Microsoft Excel.

Tools: Microsoft Office (Word, Outlook, Excel, Visio), Oracle PL/SQL

Projects:

CME Trading Challenge 2014

Took part in the commodities trading challenge organized by Chicago Mercantile Exchange (CME).

Managed the portfolio(Wealth Management ) including commodity derivatives for natural gas, gold, oil, e-mini S&P 500.

Finished in the top 35% of all the teams with a return of (7.27%).

Valuation of AT&T (Securities Valuation)

Valued (financial forecasting) and analyzed AT&T including future prediction using the Dividend Discount model and Free-Cash Flow models. Built final reports using Pivot tables to include various charts describing the financial status of the company.

Recommended a buy based on the valuation and used porter analysis to compare with industry. The prediction of $34.75 to $39.59.

Algorithmic Trading:

Used the Tango trading platform provided by the company Real-Time Systems and wrote a code for creating a spread trading based on the gains in the spread. Implemented the algorithm on the securities derivatives structures using moving averages.

Calculated the returns by implementing it on real-time basis and achieved returns over 10%.

Education:

Stuart School of Business, Illinois Institute of Technology

Masters in Science with Finance Chicago, IL July 2012 - May 2014

Skills:

Software: Microsoft Office (Access, Excel, Word, PowerPoint, Visio), VBA Macro, SQL (SQL Data Bases, MySQL, Toad), Tableau, Bloomberg, Financial Modeling, SDLC (Software Implementation Life Cycle), Python

Contact this candidate