SUMMARY:

• PMP certified professional with experience in Business Analysis, Project Management and Software Quality Assurance.
• Involved in defining Project Scope, developing Project Planning, Execution, Monitoring and Controlling and stakeholder acceptance of the project deliverables.
• Excellent skills in Business Analysis, Data Analysis, GAP Analysis, Financial Data Analysis, Risk Analysis, Requirement Analysis, Business Modeling and Use Case.
• Strong Knowledge of Software Development Life Cycle (SDLC), development methodologies like RUP, Agile and Project Management activities.
• Knowledge in regulatory and compliance related to Capital Markets (CCAR, DFAST, Basel I, II & III etc.).
• Knowledge in Credit Risk, Market Risk, Operational Risk and various Risk Measures ( PE, EPE, ENE, EEPE, EAD, LGD, PD, RWA etc.)
• Knowledge of Fixed Income & Equity instruments such as Fixed Income securities, Derivatives (Exchange Traded & OTC - Options, Credit Default Swaps, and Interest Rate Swaps etc.), Exchange-traded Funds, Asset-Backed Securities and Mortgage-Backed Securities.
• Knowledge in Reference Data Management, Trading, Pricing, Reconciliation, Clearing and Settlement.
• Performed analysis of Reference, Pricing and Rating Data vendor feeds such as Bloomberg, Reuters, Markit, S&P, Moody’s etc.
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, and document them using MS Visio.
• Experience in developing business and functional Requirements Documents (BRD & FRD) including requirements traceability, categorization, and prioritization.
• Developed and Executed Test Plans, Test Cases, Test Scenarios and Test Strategies to perform Software Quality Assurance and testing of the business requirements.
• Performed different types of testing such as Functional, Integration, System, Regression and User Acceptance Testing (UAT).
• Experience in design GUI, Wireframes, & Screen Mockups
• Experience with ETL rules for data transfer from different databases to Data Warehouse
• Experience in using a balance of technology and business skills to deliver implementations.
• Experience working with Off-shore and other external resources.
• Certified PMI Project Management Professional (PMP)

TECHNICAL SKILLS:

Analytic Tools: InvestorTool Perform, BarclaysPoint

ETL Tool & Data Modeling: Informatica PowerCenter, IBM DataStage, ERwin

Databases: MS Access, MS SQL Server 2005, Sybase 12.5, Oracle 9/10g, DB2, Netezza, TeraData

Programming Languages: Java, C++, Visual Basic 6.0, HTML, SQL

Operating Systems: Windows 2003 Server, Sun Solaris, IBM AIX, HP-UX

Authentication Server: iPlanet SunOne

Issue Tracking System: Remedy Action Request System, JIRA, VersionOne

Testing Tools: Quick Test Professional, WinRunner, TestDirector/Qulaity Center

Others: MS Project, Visio, MS Office(XL, Word, PPT, Access), MS Outlook, Rational Suite Requisite Pro, Rose, Clear Case, Clear Quest, TOAD, Mainframe (AS/400), Eagle Pace Security Master Data Warehouse Platform, Eagle SRM (Security Reference Manager), CompassPoint, Bloomberg

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst Lead/ Project Manager

• Lead the discussion among BIR (Basel Independent Review), Capital (RCMO), Chief Data Office (CDO), Counterparty Credit Risk and WCAS to identify the scope, relevancy and accuracy of the BIR (Basel Independent Review) Phase 3 Critical Data Elements (CDE).
• Perform the data analysis of BIR CDEs to determine the data lineage and develop the proposed controls for Phase 3 Action Plan (AP).
• Performed the Current State and Gap analysis of BIR Phase 2 January Action Plan Critical Data Elements (CDE).
• Performed the analysis of BIR Phase 2 CDE to develop proposed controls for System of Records (SOR) and Authoritative Data Source (ADS).
• Worked closely with Basel Data Governance and WCAS to provide the definitions for key business terms for credit risk required to update the Wholesale Credit Risk Data Dictionary (WCRDD) and Data book (Firm wide Data Dictionary).
• Developed Common Data Dictionaries for the data elements by analyzing the input data files used to produce CCAR (Comprehensive Capital Analysis and Review) 14Q/14A Reports.
• Document End to End Data Mapping and lineage for CCAR 14Q/14A Report data elements for CCAR CFO Attestation program.
• Performed the decomposition of complex CCAR 14Q/14A reporting SQL Queries to identify the data elements used to produce CCAR 14A reports.
• Coordinated among the CCAR team members and performed project management activities to ensure the quality of deliverables and achieve the project goals.
• Developed Project Plan for creating CCAR 14Q/14A input data file data dictionaries.
• Developed scorecards to measure the progress of CCAR 14Q/14A input data file data dictionaries.
• Identify the risk and issues and provided weekly status report to senior management
• Coordinated with CCAR team members on task allocation, mentoring junior team members and issue resolution.

Confidential

Sr. Business Analyst/ Project Manager

• Involved in gathering requirements by performing Business Process Analysis of existing counterparty credit risk platform CreditStudio for counterparty credit risk aggregation process.
• Involved in developing Functional Requirement Document (FRD) for target state Counterparty Credit Risk aggregation process QzAggregation to produce the collateralized and uncollateralized exposure profiles (PE, EPE, ENE, EEPE) based on Credit and Capital Rules (Basel I, II & III) and quantitative models.
• Performed detailed data analysis and identify Input and Output Data Requirements for counterparty credit risk aggregation process.
• Gather and document business process workflows for both current and future states across business functions.
• Worked with QA team on System and UAT testing to ensure development is in line with functional specification.
• Planed, coordinated and facilitated meetings with the appropriate subject matter experts and stakeholders to define requirements and identify issues.
• Worked with the Development team to facilitate the Build effort and ensured build team understands the specifications.
• Partnered with the CCRA (Counterparty Credit Risk Analytics) business to ensure sign-off on all requirements, testing and implementation.
• Supported and coordinated with business (CVA Desk) and development team on producing the CCAR Reports (14Q & 14A) for Base and Stress Scenarios by analyzing business requirements and producing the requirement specifications.
• Performed detailed data analysis and identify Data Requirements for CCAR Reports.
• Worked closely with business and technology stakeholders to assess current state, perform gap analysis, and develop requirements for business process to address the gaps for CCAR reports generation.
• Performed End to End Data Sourcing and Mapping for CCAR 14Q and 14A reports.
• Provided technical and functional support throughout the project lifecycle, including creating Business Requirements.
• Performed detailed system documentation by analysis of system code base.
• Developed and conducted walkthrough of Test Scenarios and Test Cases with stakeholders.
• Executed Test cases & documented Test results in JIRA.
• Conducted the daily Scrum, Grooming and Sprint Planning sessions for QzAggregation project.
• Identify the risk and issues and provided weekly status report to senior management.

Confidential

Sr. Business Analyst/ Project Manager

• Coordinated with Risk Governance RWA Workstream Leads (Wholesale, Securitization, Equity, SFT, Derivatives, Retail etc.) on Weekly Status Updates.
• Coordinated with RWA Securitization Workstream lead on developing Project Plan for CCAR Mid-Cycle submission.
• Worked with RWA Workstream Leads on identifying the Risks, Issues & Mitigation Strategies for CCAR Mid-cycle Submission.
• Worked with Securitization RWA lead on creating Forecasting RWA Risk Parameters for Base & Stress Scenarios for CCAR Mid-Cycle Submission.
• Reviewed the CCAR Submission Process Flows with Risk Governance RWA Work stream leads for currency and relevancy.
• Assisted Risk Governance Group creating Business Engagement Decks for Senior Management.
• Coordinated with Risk Governance RWA workstreams on tracking FRB MRA & MRIA items.
• Worked with Risk Governance Group (Securities Financing Transaction) gathering Business Requirements and creating Business Requirement Document (BRD).
• Coordinated with Technology on walking through the Business Requirement Documents.
• Conducted meetings, followed up the Action Items and distributed meeting minutes.

Confidential

Sr. Business Analyst/ Project Manager

• Involved in gathering Requirements by performing Business Process Analysis of SABER Basel Risk system for Basel 1, Basel 2 Standard, Basel 2 Advanced, Basel 3 Standard, Basel 3 Advanced and Economic Capital.
• Served as a liaison between Basel Technology, LOB leads and Reporting Teams.
• Involved in development of requirements, scope and priorities for implementation of Basel II & III NPR rules for Wholesale, Retail, and AFS Securities.
• Planed, coordinated and facilitated meetings with the appropriate subject matter experts and stakeholders to define requirements and identify issues.
• Developed Functional Specifications for SABER 2 BASEL Risk Calculator.
• Worked with the development team to facilitate the Build effort and ensured build team understands the specifications,
• Partnered with the ECM (Enterprise Capital Management) business to ensure sign-off on all requirements, testing and implementation.
• Facilitate implementation of new functionality through training sessions, demos, and the development of appropriate documentation.
• Performed End to End Data Mapping for Wholesale, Cash Securities, Retail and Credit Risk Mitigants from Basel Final Views (ECRIS Data warehouse) to SABER Basel Risk Calculators.
• Performed Reconciliation and explains between SABER and SABER 2 exposures for RWA (Risk Weighted Assets), EAD (Exposure at Default), LGD (Loss Given Default), PD (Probability of Default) and M (Maturity).
• Performed detailed data analysis and identify Data Requirements for SABER 2 Basel Calculators for Basel 3 Advanced, Basel 3 Standard, Basel 1 and Economic Capital.
• Provided technical and functional support throughout the project lifecycle, including creating Business Requirements.
• Supported and coordinated UAT, defining testing requirements together with the QA & Testing Team as well as the clients.
• Developed UAT Scenarios and Acceptance criteria in JIRA.
• Developed and conducted walkthrough of Test Scenarios and Test Cases with stakeholders.
• Executed Test cases & documented Test results in JIRA.
• Provided weekly status report to senior management
• Coordinated with different project teams such as Development, QA, UAT teams on project tasks and issues.
• Provided technical and functional support throughout the project lifecycle.
• Developed and contributed to different Process Documents such as Retail Run Book, Business Requirement Document (BRD) etc. as part of Retail work stream Go-Live requirements.

Confidential

Sr. Business Analyst/ Project Manager

• Gathered business requirements from Confidential Confidential Front Office Sales Desk involving Securitization of ARM loans.
• Gathered and documented ARM loan Pricing and Buy Up Buy Down requirements from project stakeholder.
• Conducted Proof of Concept to identify gaps in functionalities in existing Collateral Management and Hedging platform for ARM loan securitization. Collateral Management and Hedging platform is used for hedging, valuation and pooling of Fixed Rate Mortgage loans into MBS by Whole Loan Conduit Group.
• Created End to End upstream to downstream data mapping for Collateral Management and Hedging platform.
• Performed detailed data analysis and identify upstream and downstream data requirement in order to hedge, valuate and pool ARM loans.
• Created ARM Securitization Project Business Requirement Document (BRD).
• Complied business rules governing commingling and pooling of ARM loans.
• Created and executed test cases in QC (Quality Center) for integration testing of SUMMIT to CMH (Collateral Management and Hedging Platform) for Interest Rate Swap hedges.
• Coordinated with different project teams such as Development, QA, UAT teams on project tasks and issues.
• Conducted and facilitated meetings with all the project stakeholders (Commitment, Loan Delivery, Pricing, Summit, Reporting Analytics etc.) to communicate regarding ARM Securitization project and project requirements.
• Involved in overall project planning and determining of project scope, constraints and assumptions for ARM Securitization Project.
• Planed, coordinated and facilitated meetings with the appropriate subject matter experts and stakeholders to define requirements and identify issues.
• Developed and maintained Project Plan and Project Base line using Microsoft Projects.
• Identified, analyzed, tracked and managed project risks and issues.
• Provided weekly status report to senior management using EPPM (Enterprise Project Portfolio Management) tool.
• Created and published meeting minutes to the meeting participants.
• Acted as a point of contact for project problem resolution and escalation.

Confidential

Business System Consultant

• Gathered Requirements from Risk Management team in order to convert the current source for Muni Indices from InvestorTool Perform to Barclays POINT.
• Created Custom Benchmarks in Barclays POINT as per Risk Management team requirement.
• Created Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Analyzed Data and created data mapping from InvestorTool Perform to Fixed Income Reporting Engine (FIRE) application.
• Provide daily operational support to Risk & Compliance for correct and accurate Holding, Transactions & Tax Lot Data imports to Investment Repository (IR) application from different upstream systems.
• Collaborate with portfolio operations team to Set up securities, accounts & currencies and create mapping for those in Investment Repository (IR) application.
• Perform monthly cycle for Fixed Income Reporting Engine (FIRE) application by validating data and loading Indices from different analytic systems.
• Ran and executed monthly compliance reports for compliance team
• Wrote and executed SQL Queries on Oracle, SQL Server & Sybase Databases in order to monitor and validate daily and monthly feed status and data quality check for Holding, Transactions, prices, Indices & Tax Lot Data imports.
• Created outbound specifications for Fixed Income Security Master, Coupon & Factors in order to integrate Fixed Income to downstream systems.

Confidential

Project Manager/ Sr. Business Analyst

• Directed and manage development of all project deliverables within the PMO guidelines and standards.
• Developed Business Case, Project Vision and Risk Assessment Document.
• Developed overall project planning and determining of project scope, constraints and assumptions.
• Conducted and facilitated meetings with all the project stakeholders (Fixed Income, Equities, Derivatives (Options, Credit Default Swaps, Interest Rate Swaps etc.), Exchanged Traded Funds (ETF), Mutual Funds, Structured Products, Restricted Stocks, and Finance etc.) to elicit and agree on information required for project initiation.
• Acted as a point of contact for project problem resolution and escalation.
• Planed, coordinated and facilitated meetings with the appropriate subject matter experts and stakeholders to define requirements and identify issues.
• Gathered Reference Data requirements from Fixed Income, Equities, Derivatives, ETF, Mutual Funds, Restricted Stocks, and Finance business groups.
• Performed analysis of Reference, Pricing and Rating Data vendor feeds such as Bloomberg, Reuters, Markit, S&P, Moody’s etc.
• Involved in Logical Data Model for Asset Class categorization scheme for different asset classes.
• Performed extensive requirement analysis including Data Analysis and Gap Analysis.
• Synthesized the written and verbal knowledge of the business users and technical team in order to Capture Process Flows and Process Mapping of the Reference Data System (ITEM).
• Interacted with SME’s and stakeholders to gain a better understanding of the business processes and to gather business requirements.
• Created and maintained Business Requirement Document (BRD).
• Analyzed and defined user requirements and translates them into usable functional requirements.

Confidential

Sr. Business Analyst/ Project Manager

• Created the documentation within the context of the primary applications that comprise the CPP (Consolidated Portfolio Positions) Data Warehouse Platform which sits on Eagle Pace Data Warehouse namely Portfolio Master, Security Master, Holdings, Transactions and Market Data Application.
• Created the logical model for Portfolio Master, Security Master, Holdings and Transactions.
• Worked closely with the Applications Development staff, architects, and program stakeholders to document current state Process Flows and Process Mapping.
• Setup Securities from different accounting and trading platforms to CPP Eagle Pace Security Master platform.
• Managed and coordinated with the Confidential Infrastructure team setting up the necessary environments for offshore as well as onsite team members.
• Coordinated with Confidential Quality Assurance and Release Management teams in order to manage phased releases of Reference Data ETL jobs into production.
• Performed analysis of Reference, Pricing and Rating Data vendor feeds such as Bloomberg, Reuters, Markit, S&P, Moody’s etc.
• Performed extensive requirement analysis including data analysis and Gap analysis.
• Interacted with SME’s and stakeholders to gain a better understanding of the business processes and to gather business requirements.
• Analyzes and defines user requirements and translates them into usable functional requirements.
• Involved in overall project planning and determining of project scope, constraints and assumptions for Reference Data migration project.
• Involved in preparing the Business Case for the Reference Data migration project.
• Developed and Maintained Project Plan and Project Base line using Microsoft Projects.
• Provided status reporting regarding the ongoing projects, project risks and risk mitigation strategies to upper management.
• Planed, coordinated and facilitated meetings with the appropriate subject matter experts and stakeholders to define requirements and identify issues.