Sr. Business Analyst

NIRMALA GAVALI

Sr. Business Analyst/Data Analyst

***************@*****.*** 631-***-****

Professional Experience

-A result oriented professional with 10+ years of cross-functional experience in Business requirements gathering, Documentation, Data Analysis, Gap Analysis, Functional testing, Reference Data Management in IT environment

-Worked with major financial organizations- Bank of America, Morgan Stanley, Lehman Brothers, ABN AMRO BANK to leverage finance knowledge and use technical expertise to solve organizational information problems and requirements by analyzing requirements; designing computer programs, recommending system controls and protocols.

-Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.

-Facilitate discussions with business groups to help stakeholders define their needs and translate these needs into quantifiable business requirements. Defines current (As-Is) and Future (To-Be) scenarios (processes, models, use cases, user stories, plans and solutions.

-Build consensus among stakeholders to validate and finalize the requirements

-Good at working on data modeling required to create different DW table’s structure

-Adroit at conducting Business Analysis and Documentation such as:

o Business requirement document

o Functional specification document

o Use Cases

o Project plan

o UAT Test Scripts

o End to end UAT handling

o High Level cost Estimation

o Maintaining Artifacts

-Single handedly conduct UAT for monthly release done by reporting team

-Skillful at using HP Quality Testing tool – Quality Center

-Proficient at working on different projects at the same time, in order to meet the timelines and objectives of business

-Preforming high level project estimation, preparing/tracking the project plan with project team for status and updates

-Worked on Reference Data System for analyzing and enhancing the Securities Master Data for all the feeds coming from vendors like Bloomberg, Reuters and other internal data service providers.

-Recent role- Senior Analyst Programmer for BI Analytics team to reports on Investment /Corporate banking sales performance to Top Management.

-Performance Management Reporting was based on IBM BI Tool- Cognos

-Adroit at performing requirement gathering, impact analysis, data analysis to be worked on IBM- Cognos BI tool for developing Reports/Dashboards using Report Studio and Analysis Studio.

-Proficient in using Query Object of Report Studio-Query Explorer for generating the queries based on FM model and reports

-Work on SQL tool Toad to generate queries of the reports build using FM Model which are based on ETL tables

Skills

Business Management

-Client Support and Co-ordination, Client Management, Client Presentation

-Process Flow Diagram, Business Requirement Documentation

-Requirement Analysis, Gap and Impact Analysis, data analysis, data structuring to be developed using the ETL process.

Functional domain

-Investment Banking and Core Banking Segment

-Equity Operations and Clearing and Settlement system & Processes

-Sound Knowledge of other assets class of capital market (Wealth management, Debt Market Instruments)

-Working on Business Intelligence tool(BI) – IBM Cognos

-Reference Data Management (RDM)

Testing

-Scenario Generation for business functionality and operation

-Test cases and data preparation and reporting

-Unit/Integration/Functional Testing

Technical Exposure

-Operating Systems: Windows 2000/ XP

-Tools : MS Visio, MS Office, MS-Access, IBM-Cognos, HP Quality Center

-Data Bases : Oracle

-Languages : PL/SQL

Project Experience

Bank of America- New York September 2013-December 2016

Role: Sr. Business Analyst/Data Analyst

Project Title: Sales Performance (Cognos Reporting)

Project Details:

Reports and dashboard are prepared using Report Studio and Analysis Studio of Cognos. It provides consolidated information of deals, revenue, products purchased/sold to various industries and regions. It also provides information on banks involvement in various Mergers & Acquisitions deals that take place across product/region/industry. Reports are sent to Business Owners/Managers using Scheduled Job Processes and also on Adhoc request basis. Some of the reports and dashboards are made available to the Investment Bankers, Business Managers and other Finance team on internal Cognos portal accessed based on user’s security setup and per reporting lines. It acts as good sales performance tracking tool for the senior management team of the Bank. Business team is also provided with banker performance details such as Calls made by the banker to the clients, type of clients targeted by the banker, product/region/industry banker concentrates for generating the revenues. Reports also provides information that are available from feeds of Dealogic/Factset

Responsibilities

oLiaison with customers to gather and define business requirements

oAnalyze Business Requirement

oPerform data analysis of the requirement

oPrepare Business Requirement Document & Project Functional Specification Document

oPrepare Project Plan, track project plan with the team for percentage completion and report status to the Project Manager

oWork with ETL team to make sure data is available as required by Cognos Development team for developing the reports

oPerformed extensive data analysis by developing SQL queries using multiple tables, joins, outer joins

oWork with development team to understand data load/data mapping issues or data modeling gaps to make sure data warehouse tables are developed as per the business requirements

oInteract with technical team to provide clarifications of the requirements to ensure the data is captured correctly in ETL tables and reports and dashboards are developed as per business requirement

oAs a BI Analyst/ Data Analyst worked on the analysis, report development and data validations.

oPerformed system analysis, mapped the reporting requirement on different data elements and built report

oCo-ordinate with QA team for testing reports before they are send for User Acceptance

oWork on HP QC tools to keep track of defects raised by QA team and to ensure that defects are taken care by developers and also provide requirement clarification if any

oPrepare Business Test Scenario documentation/Test Script to be send to UAT Testers for the Enhancement/New releases scheduled

oConduct UAT KICK-OFF calls with the users to ensure UAT is performed by respective business users

oEnsure UAT issues are resolved at earliest by development team, signoff are achieved from UAT LEADS as per scheduled timelines

oPrepare/Distribute Release Notes which mentions the status(SUCCESS/FAIL) of the various releases and brief the achievements of releases made

BA Continuum Solutions India Pvt. Ltd

(Non-bank subsidiary of Bank of America) December 2009-August 2013

Role: Senior Business Analyst

Project Title: Sales Performance - Reference Data Management

Project Details:

ETL Tool- Informatica was used for modeling the raw data provided by various upstream systems like Dealogic/Factset and other internal systems. The raw data included data of Products, Industry, Countries and bankers, revenues earned by bankers. These data was maintained in a hierarchy structure form.

These structured information is used by various downstream systems for preparing reports and dashboards. These data provided consolidated information of deals, revenue, products purchased/sold to various industries and regions. Downstream systems are also provided with banker performance details such as Calls made by the banker to the clients, type of clients targeted by the banker, product/region/industry banker concentrates for generating the revenues.

Responsibilities

oLiaison with downstream systems to gather business requirements

oAnalyze Business Requirement

oPerform data analysis of the requirement

oPrepare Business Requirement Document & Project Functional Specification Document

oPrepare Project Plan, track project plan with the team for percentage completion and report status to the Project Manager

oWork with ETL development team to make sure data is modeled & available in the DW tables that can be used by down streams as required

oAnalyzing data sourced in ETL tables and doing data mapping using SQL

oDocumented source system functionality, data imports, data types in order to help Data Integration and ETL developers.

oWork with ETL team to understand data load/data mapping issues to make sure data warehouse tables are developed as per the business requirements

oInteract with technical team to provide clarifications of the requirements to ensure the data is captured correctly in ETL tables

oCo-ordinate with QA team for testing of ETL tables developed,

oWork on HP QC tools to keep track of defects raised by QA team and to ensure that defects are taken care by developers and also provide requirement clarification if any

TATA Consultancy Services Ltd March 2005 – November 2009

Business Analyst

1.Project Title: RIMS-Equity Settlements Re-engineering

Project Details:

RIMS - Back-Office settlements systems used in Royal Bank of Scotland (RBS) for settling trades sent using front-office systems Fidessa & other internal systems of RBS. Project vision was to perform strategic analysis of settlement process & compare it with an ideal trade life Cycle to find fundamental/process changes to be implemented in the model to reduce exceptions, avoid breakages and increase capacity of the system to handle high volume trades.

Responsibilities

oPreparing Terms of Reference/Project Definition document

oAnalyzing the Requirements

oPreparing the Prioritized Requirements List (PRL)

oPreparing Business Requirement Specification document

oArranging Strategic Planning workshop with SME’s

Client Name: Royal Bank of Scotland, Mumbai

2.Project Title: Enterprise Security Master -Reference Data Management (RDM)

Project Details:

Project role involved analyzing and enhancing Securities Master Data like Exchange Code, ticker details, issuer details, pricing and various other street Identifiers of trades, for all feeds coming from vendors like Bloomberg, Reuters and other Internal Lehman data service providers. These data provided by vendors stored in raw-format was provided to different Middle-Office and Front Office systems in Lehman to perform regular trades. Project Role also involved performing analysis and enhancements for the Enterprise Accounting System (EAM) of Lehman Brothers. EAM system was used by the Operations team to create new accounts/clients as per the customer’s requirements and financials. This system mainly divides the client into two types a) Retail Clients and b) Firm Accounts.

Responsibilities:

oHandling business issues of down-stream system for data send through extract files of ESM.

oHandling issues regarding incorrect data sometimes send to downstream system.

oUsing PL/SQL queries, working on issues with regards to data received from vendors like Bloomberg and Reuters

oHandling notices that are received from Vendors for the changes in the exchange data extract that are send in the raw file and performing impact analysis of the same in ESM.

oAnalyzing the Vendor Unmapped (Exception Report) for the feeds that are received in the raw files and which are not been mapped in ESM system. This Exception Report pulls all the attributes that are not been mapped in ESM Database Code Manager.

oAnalyzing various enhancements request received from Middle-Office/Front-Office systems to meet business requirements more effectively and efficiently

oPerforming the UAT in co-ordination with the development team of the enhancement

Client Name: LEHMAN BROTHERS, USA

3.Project Title: Precision- eBroking Back Office Solution

Project Details:

The product designed as BackOffice system for multiple exchange and segments (Equity & Derivatives) operations offering a comprehensive solution to varying needs of the broker/dealers operating in the institutional and retail client segments.

Responsibilities

oAnalyzing the business requirements, impacts and gaps in the product with regard to regulatory changes, clients’ requirements

oBusiness Test Scenario documentation-Test scenario design, Test Cases, Use Cases

oPreparation of specifications for the products based on guidance from domain experts/client coordinators

oLiaison with customers to gather and define business requirements

oObtain sign-off from business stakeholders

oInteract with technical team to provide clarifications of the requirements to ensure the systems are developed as per the business requirement

Client Name: HDFC Securities Ltd, Apollo Sindhoori Capital Investments Ltd (ASCIL)

4.Project Title: Money Movement-Online Banking

Project Details:

Money Movement system is online web based application used by the customer to create new accounts, perform online transaction and money transfer for Inter Bank and Outside Morgan Stanley transaction

Responsibilities:

oResponsible for Business Requirement gathering and analysis.

oPreparing the Functional Specification documents (FRS).

oResponsible for developing Functional Use cases and Functional testing.

oPreparing Use Case and Test case for various internal and External (International Transfer) functions and GUI Testing of the Online Banking System.

Client Name: Morgan Stanley, USA

5.Project Title: PICASSO- Online Banking

Project Details:

Build an automated system called Generic Signing for all the products & Services of the Banks using direct sales channels like Customer Contact Center (CCC) and Internet Banking. These facility was offered for all existing customers of ABN AMRO Bank for all products & Services that they wish to get from the Bank. Since project has direct link with CCC and Internet Banking (IB), team also worked on finding the related interfaces and the changes that need to be built for implementing generic signing.

Responsibilities:

oUnderstanding Business Requirements for PICASSO with regards to CCC, Internet Banking System

oAnalyzing Requirements

oPreparing Prioritized Requirements List (PRL) for PICASSO

oPreparing Business Area Definition (BAD) and Business Process Model (BPM)

Client Name: ABN AMRO BANK, Netherlands

JP Morgan Chase (India), Mumbai October 2004 to Feb 2005

Team Member (Query Resolution Department)

Project Title – Corporate Accounting

Project Details:

Project involved handling of Invoice processing for the various payment request raised by CHASE employees across global offices which includes processing of Repeat payments, putting a stop payment on the check if required, processing of invoices for HVV’s and also part of Fixed Assets processing

Responsibilities:

oSolving queries received from CHASE Employees via Calls, email and faxes.

oSolving queries related to General Ledger and Cost Center to be used to charge for the Invoices.

oPerforming daily Audit for payments made to vendors and also initiating refunds or placing credit request against vendor for duplicate payments made, in coordination with USA Team.

oMaking analysis and preparing Monthly Report on request received and time taken to resolve

oActed as Process Trainer to team members to give them cross functional training of Invoice Processing Process of Accounts Payable

Other Achievements:

-Banking Domain Certified- Investment Banking and Capital Operations

-Certified for PMP – Study Facilitation Program

-Advanced MS-Excel and MS-PowerPoint Certified

-Association of Mutual Funds India (AMFI)- Certification in Mutual Funds (Advisor Module)

-International Certification on Core Banking and Financial Knowledge

-Certification in Investment Banking & Securities Market Operation

Academia

-Masters In Management Studies (M.M.S)-Finance - 2003 from Bharati Vidyapeeth’s Institutes of Managements Studies and Research, Mumbai University.

-Bachelor of Commerce (Finance & Accountancy) - 1999 from Mumbai University.

-Diploma in Computer Applications -1999 from NIIT Ltd

Contact this candidate