SUMMARY:

• Around 7 years of Investment Banking Business Analysis experience with the ability to work independently and manage business expectations with a delivery - focused approach to work.
• Used Quality Center, Rational Unified Process (RUP), Rational Rose, Requisite Pro.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis and Risk.
• Liaised with Trading, Risk, Strats, IT teams and external vendors for development of tradable and scalable index products.
• Experience in Investment Banking, Capital Markets, Investment Management and Wealth Management.
• High Level of Expertise in Capital Markets, strong knowledge and exposure to Equities, Fixed Income instruments, Exchange-Traded, Over-the-Counter (OTC) Derivatives and Alternative Investments.
• Expertise in Financial Statements and Analysis with GAAP and IFRS standards, Capital Structures and Budgeting.
• Worked in cash and other GL reconciliation to gathering information in the Reconstruction of accounting records for analysis, design and implementation of a General Ledger system.
• Facilitate requirement-gathering sessions (JAD, JRP and FRS's,) with the business team and stakeholders to collect the business standards, security and service level requirements.
• Experience in GAP analysis, SWOT analysis, Market research analysis of product prices, Risk analysis, Cost-benefit analysis, ROI analysis, User acceptance testing (UAT) and traceability matrices.
• Experience working on ERP system users by providing troubleshooting, reports generating, recommending business process improvements to leverage system features and functionality.
• Diverse experience in distributed Client/Server and Web applications through all stages of the SDLC for Retail and Banking services with emphasis on Business Analysis, Gap Analysis and Quality Assurance of application software.
• Proficient in authoring Business Requirements Document (BRD), deriving Functional Requirements Document (FRD) and detailing into System Requirements Specification (SRS) Documents.
• Design and develop, all reports using Hyperion Financial Reporting Studio.
• Experience in investment banking - Dodd Frank and EMIR regulations.
• Assisted in UAT testing to make sure the application / functionality is working in accordance to the Clients Specifications and requirements.
• Monitored CCAR regulatory reporting to ensure that stress instructions, quality assurance activities, and FRY 14 reporting schedules were being coordinated and submitted in a timely manner.
• Liaised with FRY 14 template owners to ensure compliance with instructions and report timing.
• Knowledge with investment banking regulatory reporting regulations like Basel II Accord.
• Updating internal customer, facilities and guarantor ratings for borrowers In Loan IQ.
• Extensively used Modeling Tools to develop business process models, use case model, process flow diagrams and UML diagrams that include activity, state, sequence, Collaboration, Class, Entity relationship and Business Process diagrams.
• Followed the Agile methodology, RUP Rational Unified Process and SCRUM in the
• Experience in commercial lending system Loan IQ and Infolease. Project development.
• Experienced in writing Test Plans and supporting execution for Integration Testing, Functional/Non Functional, Black Box Testing and User Acceptance Testing.
• Expertise in preparing Test Plan, Test Scenarios, Test Documentation, Test Scripts and Test Cases.

TECHNICAL SKILLS:

Methodologies: Rational Unified Process, Unified Modeling Language

Change Management Tools: Rational Clear Quest, Test Director, Clear Case

Business Modeling Tools: Rational Rose Suite, Microsoft Visio, Irise Studio

Business Intelligence: Business Objects, Crystal Reports, Cognos

Project Management: Microsoft Project, Microsoft Office, Lotus Notes

Programming: Java, SQL, PL\SQL

Databases: Oracle, DB2, MS-SQL Server

Industry Exposure: Financial Services, Credit Cards, Investment Banking

Financial Skills: Financial Analysis, Credit Appraisal, MIS Reports generation, ERP, GL.

PROFESSIONAL EXPERIENCE:

Confidential,Reston,VA

Sr. Business Analyst

Responsibilities:

• Implemented an AGILE process for Fast Lane Trading Platform with complete line of traceability for all the artifacts of web projects.
• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifact (SRS's and SDS's).
• Conducted one on one sessions for gathering User and Business Requirements from various SMEs.
• Worked as Data Analyst, involved in requirements gathering to study the existing system which will help in the designing process for the proposed systems.
• Implemented Hyperion as Analyst by scrutinizing data aggregation/ETL from numerous source systems as part of an Enterprise Resource Planning (ERP) solution.
• Develop User Acceptance Testing and specifications with guidance from AML Compliances.
• Fixed several problems with B2B system that exchanges data between the company and its prime brokerage clients.
• Created a Business Glossary that defined the terms used during modeling.
• Authorized and documented the process for Cash & Securities Reconciliation, GL Account Reconciliation and Profit and Loss account.
• Supporting capital stress testing efforts for the Capital Management, capital reporting, regulatory reporting, and data governance efforts.
• Prepared a Logical solution design document (LSDD) for the Mid Atlantic BI team, documented project summary, current state of systems, analyzed future state systems, provided detailed Visio diagrams, explain the Data flow in the current and future state through various stages.
• Worked closely with SMEs and other stakeholders to develop applications and portals for property and casualty products especially auto and homeowners.
• Key CCAR team thought leader in crafting and delivering the CCAR message to senior leadership and the FRB.
• Assisted in building a business analysis process model using Rational Rose and Visio.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Validated XML transformation and data using DB Filters, logs.
• Handled the implementation of 3D Secure-OTP (one-time-PIN) project for BDO-issued Confidential and MasterCard credit cards.
• Interacted with external auditors on regulatory reporting.
• Ensure completeness and accuracy of Trade and position level data of Loans and Deposits, OTC, Swaps and Capital Market in the strategic.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Assisted in UAT to make sure that all user requirements are catered by application.
• Assist in implementation of new Hyperion products, as needed.
• Document the requirements in a BRD for review, approval and signoff by all parties before sending it to development for implementation.
• Performed User Acceptance Testing (UAT). Developed Test Scenarios and documented Test Plans that contains test scripts, test cases, test data and expected results. Used Toad to run SQL queries to get the useful information from database.
• Undertook back end testing using SQL and wrote queries.
• Worked alongside the alternative investment marketing team specializing in real estate investment.
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.

Confidential,Detroit,MI

Sr. Business Analyst

• Extensively worked on all phases of Data Warehousing project like Data mining, Data Cleansing, Data modeling for data staging & Data Mart, Indexing, Quality Assurance, Data updating plan, and Data presentation to business user.
• Worked with Project Manager in the development of AGILE methodology and documentation strategy.
• Defined and analyze specification for PA-DSS and major credit cards mandate compliance.
• Involved in a team with parallel user groups to ferret out new program requirements, decommission processes, or align new data feeds to maintain data governance.
• Create new Hyperion reports that address current company/user needs and improve reporting.
• Managed documentation of PAM to GL interface business requirements.
• Helped transformed standalone application into an interactive system by implementing APIs and opening live feeds to systems such Loan IQ and BMR (Basel management Reporting).
• Communicated and interacted with Development teams across multiple groups to ensure integration of AML application with multiple applications.
• Creating artifacts like the Business Vision, Business Glossary, Business Architecture Document, Scope Documents, Business Modeling Guidelines and Business Use Case Models.
• Payment Card integration and mandate compliance for major credit cards such as Confidential .
• Conducted workflow, SDS's, process diagram and gap analysis to derive requirements for existing systems enhancements using Use Cases, Activity Diagrams, Sequence Diagrams, OOD using MS Visio.
• Worked on Dodd Frank regulation - Mandatory clearing and SEF regulations.
• Created UAT Test Cases and Test Scripts based on BRD/MDD/SRS.
• Wrote SQL queries to verify the system functionality and provided the users with the needed data and information during operational phase.
• Maintained RISC and Information Security Organization charts.
• Managed break fix and functional enhancements in BI landscape for various data sources, Data targets and reports.
• Worked on connectors to connect VE with different ERP system General Ledgers (GL) such as SAP, Oracle and Hyperion.
• Reviewed equities applications utilized in front office, middle office, and product control in a SOD analysis.
• Involved in various other change order tasks requiring XML, Hyperion reports creation & ERP in-house tool enhancement.
• Knowledge of different asset classes, Asset Management, OTC Derivatives (Futures & Options), cost & competitive analysis, and pricing techniques.
• CCAR FRY 14 internal subject matter expert; provide technical advisement and interpretation of instructions.
• Integrated the Loan origination (Loan IQ) and Loan Servicing System (Capital Stream).
• Used SQL in ACCESS to test, validate and verify Loan IQ data.
• Designed and analysed Business Process Model, Use Case model and test procedures based on RUP methodology using Rational Rose.
• Designed and developed all Use Cases and UML models using Rational Rose and Visio using UML.
• Created Quality Assurance MTP (Master Test Plan) for the RISC Server Optimization project, company wide initiative to migrate all UNIX base applications on SUN Solaris servers to virtualized Linux servers.
• Opened and linked accounts on prime brokerage systems.
• Provided level 3 supports for the Actimize AML production system.
• Involved in requirements gathering and business analysis to provide visibility to corporate customers on Capital markets, Fixed Income and M&A.
• Helped create the 'Business Glossary' to facilitate efficient understanding of the business process amongst the other teams.
• Proficient in testing the POS application with various tender types - cash, check, credit cards, debit cards, prepaid cards, merchandize cards, gift cards, coupons, rebates and promotions.
• Created Requirement documents like BRD, FRD, etc. depicting business flows & rules, processing-sequences, use-cases & inter-dependencies using UML.
• Researching and presenting review key points from DF and ESMA covering OTC Derivatives and Trade Repositories.
• Established strategy to re-engineer enterprise-wide management of capital stress testing models and functions as related to the CCAR program.
• High level of knowledge in retail, loan, and credit card compliance and regulatory practices.

Confidential,Columbus,OH

Business Analyst

• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Experience in commercial lending system Loan IQ and Infolease.
• Working knowledge of derivatives products - OTC Derivatives, FX, Equity, Rates, Credit, Commodities.
• Worked closely with external ERP software vendors to design and implement application customizations to ensure that our business objectives were met. This would include writing functional specifications, maintaining communications with developers and end users and managing the project through implementation.
• Worked with Hyperion planning applications for budgeting and forecasting.
• Scheduled meeting with Developers, SME's and testers Facilitated Joint Application Development (JAD) sessions with all IT groups for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy and to collaborate resource allocation and project completion.
• Team lead for BI integration, worked closely with BPC team to integrate BPC and BI for various module like local / Global statutory, COPA, Budget & forecast.
• To conduct JAD sessions with management, SMEs (Subject Matter Experts), developers, users and other stakeholders for open and pending issues to develop specifications.
• Regularly holding sessions with Lines of Business (LOB) to document, implement and maintain the metadata and business rules for the bank's data, beginning with the data required for CCAR.
• Performed manual testing and recorded results in ClearQuest and used SQL queries for enhancements.
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.
• Created Use Cases using UML in MS Visio and managed the entire Software Development life cycle using Waterfall methodology.
• Involved in overseeing GL entries process at month-end closing and ensure the accuracy of P/L.
• Research and determine impacts of Dodd Frank regulations on current workflows.
• Collected business requirements for determining the metadata for categorization of content based on geography, user profile and also helping in SEO purposes.
• Updated clients' monthly investment activities for use by project teams.
• Used Rational Rose to prepare the design document using the standard UML models.
• Support and complete UAT with the business.
• Prime Brokerage application Excalibur is a trade entry and trade management application and it services hedge fund clients.
• Assist in defining requirements for Dodd Frank initiative specific to the trade capture, processing, matching and outbound messaging.
• Fixed the issues raised during system testing involving aml and java code by replicating in Development environment.
• Review the requests with the business to ensure the correct information has been captured before a BRD (Business Requirement Document) is written.
• Understood XML schema, Flat files and wrote input XML/DAT to output SQL data in test cases.
• Performed Data Analysis of existing data through SQL.