Sr. Business Analyst

Pooja Sharma

Email: ******.**@*****.***

Summary

Business Analyst with more than 8 years of experience in business process

analysis/modeling, business requirements gathering, analysis and

documentation for financial applications. In depth knowledge of Front

Office, Middle Office and Back Office of Hedge Funds, Portfolio Management,

Fixed Income and Derivatives, Asset Management, Brokerage Institutions and

Prime Services, Capital Markets, Fixed Income, Equities, Risk management

(Credit Risk, Over The Counter (OTC) Trading, Security Master. Expertise

in gathering business and technical requirements from both formal and

informal sessions.

Professional/ Technical Skills

Rational Requisite Pro,Abinitio, Rational Rose, MS-Visio, Rational Clear

Quest, Rational Clear Case, HP Quality Center, Assembly, UML, HTML,

Microsoft Access, Oracle, My SQL, SQL Server, DB2, Business objects

(Business Intelligence Software), Microsoft Office Suite, Microsoft

Project, Erwin, TOAD, My SQL, MS office, Informatica, Cognos, SDLC

Methodologies such as Agile, Scrum, XP, RUP, RAD and Waterfall. JAD

Sessions, Activity Diagrams, Use cases, Data Mapping, User Acceptance

Testing, Black-Box Testing and Functionality Testing.

Experience

[pic]

OppenheimerFunds, Inc., New York, NY Aug 2012 -

Present

Sr. Business Analyst

OppenheimerFunds is an investment bank and full-service investment firm

offering investment banking, financial advisory services, capital markets

services, asset management, wealth management and related products and

services worldwide. The Project was to merge the historical data spread

across multiple legacy database. Marketing team sets up investors and

investor contacts, processes the transactions and generates reports from

Investor Data Ware application (IDW). Currently the marketing RFP team

consumes data from IDW, accesses reports from this application and

disseminates them to intended recipients. IDW has data stored since 2010

and the marketing RFP team needs data since 2005. This includes the

enhancements and functionalities that need to be added in IDW database and

the necessary interfaces that need to be developed, so that the reports

generated from (Cognos) IDW can effectively meet the needs of investors.

The system is to be enhanced, in such a way that it can support client

driven customized distribution lists and also can support ad-hoc contact

level reporting and can support fund level disseminations.

Responsibilities:

. Gathered business requirements from Portfolio manager, marketing team,

analyzed business requirements.

. Document Business and Functional requirements in BRD and FRS.

. Facilitated JAD sessions with SMEs, users and stakeholders for resolving

disputes.

. Ensured decomposition traceability of high-level business requirements

into functional requirements.

. Worked with market data and security master data for different asset

classes used by various business groups in Oppenheimer firm.

. Created and managed project templates, use-case templates, requirement

types & traceability relationships.

. Worked on Bloomberg terminal so as to backfill the historical asset class

data.

. Delivered the Bloomberg cost analysis of switching from data license to

the back office license.

. Delivered all the reports essential for calculating the leverage in

Marketing Collateral as mandated by the Enterprise Data Policy Council.

. Documented and mapped the Ratings of S&P, Moody's and Fitch at the

security level.

. Planned and defined system requirements to Use Case and Use Case

Narrative using the UML methodologies.

. Created Activity Diagrams and Sequence Diagrams in MS Visio.Created

wireframes and Mock-up forms in MS Visio for better visualization of

enhancements of screens for users.

. Scheduled meetings with developers, system analyst and testers to

collaborate resource allocation and project completion using MS Project.

. Prepared Logical Data Models containing the essential business elements,

detailed definitions and descriptions of the relationships between the

data elements to analyze and document business requirements.

. Worked on data modeling and produced data mapping and data definition &

ETL specification documentation.

. Identified & documented data sources and transformation rules required to

populate and maintain data warehouse content.

. Designed and implemented basic SQL queries in large data bases of various

applications for drilling down and slicing and dicing of the data.

. Assigned problems to technical development team for fixes via MS Project.

. Developed strategies with Quality Assurance group to implement Test

Cases.

. Conducted UAT and developed strategies with Quality Assurance group to

implement Test Cases.

. Planned, developed and coordinated the preparation of financial analyses

reports including, but not limited to, operational and financial

statements, cost analyses and other financial information.

. Worked on documenting user manual, reference guide and documentation for

administrative procedures.

Environment: MS Excel, MS Access, MS Visio, PL/SQL, SQL Server, Cognos,

Sharepoint and HP QC.

Capital One Financial Corporation. Richmond, VA

May 2011- July 2012

Business System Analyst

Capital One Financial Corporation is a Fortune 500 company specializing in

credit cards, banking, and home and auto loans and saving products. This

project is a part of ongoing efforts to bring the Capital One Financial

under Basel II compliances.

. Involved in the full capacity in the multiphase project.

. Worked in digitalization of FAS forms, LGD data element capture and

financial modeling required for data capture.

. Involved in the Foreclosure and Direct Expenses forecasting of real

estates (RE) and other than real estates (OREO).

. Enabled the user to track the loan record in the commercial work stream

to its complete life cycle.

. Interacted with business customer at a large extent to gather

requirements in periodic meetings.

. Developed critical documents including Business/System Requirements

Document, Project Scope Document, Test Strategy Document and Release

Strategy Document, NPA data Maintenance Strategy Document, Deployment

Strategy Document as well as Capacity Planning, Performance Matrix and

Test ID maintenance Strategy documents.

. Developed Use cases and complex Business case scenario.

. Interacted and worked with Process Engineering team to create process

flow diagrams.

. Delivered requirements for integrating transaction, previous day and

current day information reporting for various funds

. Highly contributed to the enterprise metadata efforts by completing the

data mapping repository (DMR) information.

. Developed Requirement Traceability Matrix to view the coverage of

Business Requirements till Test cases. This Traceability was also used

for project close activities.

. Assisted User to use the application by creating User Guide, giving user

training and developing Help Desk Scripts and FAQ files.

Environment:

MS Word (2003), MS Excel (2003), MS PowerPoint (2003), SQL Developer

(1.1.3), Oracle10g, TOAD, HP Quality Center 10.00, Business Objects,

Crystal Reports 9.0.

Barclays, DE

Jan 2010 - April 2011

Business Analyst

The aim of the project was to develop and implement applications to support

the hedge fund's algorithmic trading strategies for Alternate Investment

Services (AIS). Pre-defined trade parameters were incorporated into the

design of automated trading applications that were integrated into the

firm's front end platform.

. Studied the administration process of fund of hedge funds and fund of

fund for AIS with a focus on accounting and web reporting

. Developed certain strategies (Convertible Arbitrage, Emerging Markets,

Distressed Securities, Relative Value and Event Driven), to evaluated

the correlation coefficient with market conditions deteriorate.

. Gather requirement for the various accounts and analyzes complex fund

structures

. Analyzed and created the process flow diagrams for the Fund of Hedge

Funds, Accounting and Trade Execution business groups;

. Formulated multiple sets of books within the same fund to create

customized sub-ledgers.

. Developed new work flows to reduce costs and risks by eliminating manual

processing. It also generates customized reports to satisfy investor or

regulatory requirements.

. Participated in writing data mapping documents and performing gap

analysis on the systems.

. Analyzed user statement of requirements to develop new reports.

. Designed Use Case Diagrams and wrote specifications in the Use Case

Specification documents based on requirements gathered.

. Facilitated and managed meeting sessions with committee of SMEs from

various business areas including the operations team and the reporting

team.

. Co-ordinated with the business, PM, developers and testers from offshore

as well as onshore team, during the testing iterations

Environment:

MS Office, MS Project, UML, Visio, Windows, MS SQL 2005, C#, UNIX Test

Director, Rational Rose and Requisite Pro.

TD Waterhouse, Paramus, NJ

April 2008 - Dec 2009

Business Analyst

The System is built to help the portfolio managers to access the securities

database from Bloomberg and perform the various analysis queries such as

optimal rebalancing rule with fixed costs and proportional costs, before

they arrive at portfolio for a required yield, on a given portfolio of

assets.

. Designed and coauthored Business Requirement Documents (BRD), Functional

Specifications and Technical maps for Asset Management stream.

. Understanding various methods involved for Equity, Bonds, FX, Commodity,

Options and developing the Use Cases and Workflow diagrams.

. Responsible for integration of Wall Street on Demand and Nasdaq Level II

streaming quotes with the front end systems.

. Developed Business Requirement Document and Use Cases.

. Responsible for communications between the off-shore development team and

on-site Project Team and other related departments.

. Vendor software compliance, database integrity and performance

evaluation.

. Used Visio to develop Use Case diagrams, Activity Diagrams and Sequence

Diagrams.

. Conducted training sessions for the end users and documented various

training manuals.

Environment:

MS project, MS Visio, MS Word, Excel, Erwin 7.1, Oracle 10g, SQL*Plus,

Quality Center, Manual Testing and Test scripts.

ING Financial, Denver, CO

Nov 2007 - Feb 2008

Business Analyst

This project dealt with Cash Management Services including Account

Reconcilement Services, Automated Clearing House, Balance Reporting

Services, Cash Concentration Services and Sweep Accounts to large business

customers.

. Used SDLC Method specifically Agile Methodology more specifically Scrum.

. Identified the Problem in creating an application and had solved with

developers and analyzed data defects in As-Is System.

. Analyzed and solved the problems in existing system and implement it into

the system.

. Collaborated with SMEs to facilitate the scoping and definition of the

Business Opportunities

. Helped the Project Manager in initiating the project, preparing the

Business case and planning it

. Defined the solution model, Analyze the functional requirements, prepared

the Use cases, defined user profiles, defined the supplementary

requirements, defined assumptions and prepare the traceability matrix and

validate the requirements.

. Development of SharePoint portals with extensive workflow capabilities to

manage client projects

. Performed NYSE Stock Record analysis to reconcile with Real Time Stock

Record system of the brokerage house and analyze if it is indeed real

time.

. Received trader information, customer information and depository

information from the trading systems, settlement systems and the security

guardians.

. Defined scope, objectives, deliverables and timeline; ensure that

everyone adheres to them.

. Reviewed the use cases, functions and features list, map the requirements

to design, and update the requirements traceability matrix

. Managed Traceability Matrix to trace Business Requirements, Functional

Requirements

. Used Microsoft Project to manage schedules, deadlines, and resources and

collaborate on the project.

GMAC Mortgage, Horsham, PA

Jan 2007 - Oct 2007

Business/Data Analyst

Projects involved analyzing, design and develop Reporting Services.

. Followed Rational Unified Process (RUP) methodology for creating

artifacts.

. Facilitated (JAD) Joint Application Development sessions to resolve

issues relating to difference between business requirements and technical

design.

. Created Business Requirements and converted them into detailed Use Cases,

Report Specifications and Non Functional Requirements.

. Created and maintained Data Dictionary and pursued to reach consensus.

. Coordinated with System Analyst and Project Manager to setup the pre-

validation and validation environment to execute the scripts.

. Analyzed user requirements, attended Change Request meetings to document

changes and implemented procedures to test changes

. Involved in preparing a simple and detailed User manual for the

application, for an intended novice user.

Environment:

SAP, Oracle 9i, SQL*Plus, Rapid SQL, Word, Clear Quest, UNIX 5.0, Excel, MS

PowerPoint, SQL Developer, TOAD 7.5, Window XP

ADT - HSS (Home Securities Services) Canada

Jan 2006 - Dec 2006

Business Systems Analyst

The customer ADT Inc. is leading home security company in Canada/North

America, protecting almost 5 million homes by their varieties of services.

. Requirement Gathering & Gap Identification for enhancement of application

and client profiling.

. Requirement Analysis and Documentation for business users across North

America & Canada.

. Participate in the onsite/offshore calls with business users.

Environment:

MS Visio, MS Office, SQL 2005, MS-Access, Java, Oracle 9i, SQL-Developer

Rapid Effect Ltd., India Oct 2004 - Dec 2005

Pressure Reducing Station (PRS) - Forbes Marshall Ltd.

Business Analyst

The customer, Forbes Marshall is the manufacturer of cast steel & cast iron

safety-valve and gadgets in MIDC, Pune.

. Participated in the requirements gathering and conduct daily / routine

meeting with subject matter expertise, takes notes & published agendas,

meeting outcomes and follow-up for now next meeting.

. Documents all the requirements to validate the invoices and payment

information from the legacy system.

Environment:

MS Visio, MS Project, MS Office, SQL-Plus, MS-Access, Oracle-8i, TOAD 6.0,

Oracle Web Applications, Oracle Forms 6i & Oracle Reports 6i, Oracle

Developer 2000.

Education

Bachelor of Commerce (BCOM)

Master of Commerce (MCOM)

Post Graduate Diploma in Business Administration (PGDBM)

Master's in Business Administration with specialization in Finance (MBA)

Contact this candidate