SUMMARY

• 8+ years of experience as a Business Analyst with solid understanding of Business Requirement gathering, Business Process Flow, Business Process Modelling and Business Analysis.
• Extensive experience in Banking Industry group including Credit, Risk, Investment and Operational Risk Banking that involve knowledge in CCAR, Basel, Dodd Frank, Charles River.
• Extensive experience in Object Oriented Analysis and Design using UML, Rational Unified Process (RUP) and MS Visio.
• Proficient in developing Use Case Diagrams, Analysis Model, Design Model, Behaviour diagrams (Sequence diagrams, Collaboration diagrams, Activity Diagrams), and Class Diagrams based on UML
• Responsible for analyzing the requirements through client requirement walkthrough sessions/JAD sessions and finalizing the user requirement documents (BRDs) and functional requirement specifications (FRS).
• Strong presentation and communication skills, capable of interpreting stakeholder's needs and positions to ensure the success of the projects and functional areas of business.
• Rich knowledge and experience with RDBMS, Data Warehousing, Data Mapping, OLAP, and OLTP. Proficient in the creation of source to target data mapping documents and execution of SQL queries in a data warehouse environment
• Conducted and participated in UAT to get users and stakeholders' acceptance.
• Supported the development of the test plan and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Supported process owners in CCAR related operational risk activities, identifying and monitoring risks, and independently assessing the adequacy of capital planning and stress testing controls based on the following: Risk and Control Self - Assessments (RCSA), Risk Dashboards, Issue Tracking, and Key Risk Indicators (KRIs).
• Worked on producing CCAR FRY Y - 14 M/Q, FRY- 14Q, FRY - 14 A, consolidating data for Retail, Wholesale, Securitization, Market and Operational Risk.
• Supported Data Requirements for Basel II, Basel IIII and DFAST reporting for producing FFIEC 101, FFIEC 102 and Pillar III, FRY 14 A and Pillar III Reports.
• Involved in strategic and tactical solutions for implementing CCAR stress testing and Regulatory reporting.
• Supported to maintain CCAR (Comprehensive Capital Analysis & Review) operating rhythm and governance framework
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Full understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT).
• Experience in Scrum Process and thorough understanding of Extreme Programming (Software Development Methodology and Object-Oriented Analysis (OOA).
• Used Sharepoint Portal and Documentum Web Publisher, exposure to SAP Finance (FI) module.
• Experience in Competitive Analysis, Data Analysis, Gap Analysis and understanding of ROI Analysis, P&L Analysis, SWOT Analysis, Impact Analysis and Cost-Benefit Analysis
• Experience in creating the process flow diagrams depicting “AS-IS” and “To-Be” state.
• Possess end to end Project Life Cycle experience - Right from pre- discovery phase to roll out.
• Excellent analytical, negotiation & inter-personal skills with demonstrated relationship management abilities.
• Highly articulate, confident and persuasive team-builder, able to motivate and communicate to achieve goal.

TECHNICAL SKILLS

Data Analysis and Technology: Hadoop, MapReduce, SQL, PL/SQL, SSIS, SSRS, SSAS, Oracle 11g, Microsoft SQL Server Analytics and Management

Tools: QlikView, Tableau, Spotfire, Microsoft Project Planner, SharePoint, Axiom

Design Tools: Microsoft Visio v15. 0, IBM WebSphere Business Modeler v7. 0, IBM Rational Software Modeler v6. 0

PROFESSIONAL EXPERIENCE

Senior Business Analyst

Confidential - New York, NY

Responsibilities:

• Working in CCAR project mainly on FRY-14A, Analyze, Interpret and write the CCAR requirements/changes for FRY-14A, FRY-14Q and FRY-9C reports for the Development team to code using Axiom Controller View.
• Analyze and interpret the additions and changes in CCAR/DFAST reports like FRY-14A, FRY-14Q, and FRY-9C by FED to implement the correct solutions.
• Collect the functional requirements from the users and provide Technical implementation details using Axiom Controller View tool.
• Analyze, Test and maintain the data items populated in Axiom in various reports CCAR reports.
• Work closely with Development and QA teams to ensure the requirements are properly coded in Axiom and then tested.
• Integrated FR 2052a/LCR solution that leverages the core UDM data set and produces both the Liquidity Coverage Ratio and the FR 2052a (formerly 5G) report with consistency and transparency from the source through the output reports using AxiomSL.
• Worked on reviewing and modification of the BRD for the enhancement of OTC derivatives, product control and private banking based on Basel III norms and Reg W Affiliates.
• Gathered business requirements, performed Gap Analysis for client’s requirements and generated system workflows.
• Troubleshoot CCAR issues pertaining to releasing documents, managing budgets, new and existingCCAR accounts, CCAR records and allocation.
• Involved in testing of regulatory analytics and financial calculation (Reg W Exposure, Gross Profit, Gross Loss, NPV, Credit Exposure, etc.) for the daily and monthly feeds of OTC derivatives exposure details and credit collateral files for Reg W Affiliates based on Basel III Norms.
• Closely coordinated with the PMO team to create milestones and timelines for deliverables on a weekly basis and detect and report Risks and Issues.
• Recommended changes to existing workflows for the end to end process to be compliant with Dodd Frank requirements.
• Manage all processes, documentation, and queries surrounding the Basel III regulations.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Created test scripts and expected results for internal testing for Dodd Frank Reporting.
• Provide reports to brokers and clients such as Basel III, Stress Analysis, Fund Fact Sheets and Compliance documents.
• Prepared process flow diagrams depicting “AS-IS” and “To-Be” state.
• Analyzed and documented existing OTC process flows across asset classes to determine changes needed once Dodd Frank is effective. These processes included execution, booking, confirmation, clearing, and reconciliation.
• Analyze RiskAuthorityTM, a Moody’s product, towards readiness for Basel III for different functional requirements like compliance and capital calculations.
• Prepared and validated high-level and detailed requirements.
• Conduct training to program managers and financial analysts on budget procedures, execution, and various financial management issues in CCAR.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Led a team to measure transformations, calculations and business processes used in the calculation of Basel II risk parameters as well as the generation and review of the FFIEC 101 Schedules while focusing on testing of derivatives portfolio.
• Analyzed the potential areas of improvement in the data management processes.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Manage Sharepoint site and document (functional & technical) source to target mappings, process flows, procedures and business requirements.
• Closely involved in planning and execution of all the testing phases including UAT (onsite), proactively performed thorough reviews of System/UAT test-cases and data-sets.
• Partner with Functional/Development leads to ensure timely delivery against project schedules.
• Preparation of various Documents like Crystal Reports, Software Requirement Specifications, Requirements Traceability Matrix etc.

Business Analyst

Confidential - New York, NY

Responsibilities:

• Collaborated in the implementation of a risk management framework to ensure corporate functions are in compliance with the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) and Basel III Regulatory reporting requirements and implementing US GAAP framework and systems implementation
• Build and maintain CCAR (Comprehensive Capital Analysis & Review) operating rhythm and governance framework. Liaise with FR Y-14 template owners to ensure compliance with instructions and report timing.
• Identify correct data sourcing to delivery STTM documents.
• Establish cross-functional reconciliation framework for tie points between FR-Y9C and FR-Y14 reporting templates.
• Build a dedicated DataMart to support all the regulatory data needs for Basel III and CCAR producing FFIEC001, FFIEC 002, FRY Y - 14 M/Q, FRY- 14Q, FRY - 14 A also supporting FFIEC 002S, FFFIEC 004, FFIEC031, FFIEC041, FR Y-9C/LP, FR Y-11/S, FR Y-15 and FFIEC009.
• Conducted user interviews; gathered, and analyzed operational requirements in consultation with traders, developers, and end users using Requisite Pro.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Identified risks involved for desire project such as market risk, inflation risk, credit risk, and default risk. Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Cash management practices were implemented in project for automated clearing house, sweep accounts, and balance reporting services.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Worked extensively with QA team for designing Test Plan and Test Cases for User Acceptance Testing.
• Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update scripts.
• Developed timelines for project delivery, and managed projects and resources to successful completion.
• Generated SQL queries to develop risk reports.

Business Analyst

Confidential - New York, NY

Responsibilities:

• Strategic Business change offering was created to lead and communicate the definition, ownership, agreement and implementation of business change with and has been driven by Basel II requirements with in FA and IB practices with the agreed end state operating model
• As a Business Analyst, created project schedules, conducting task identification and management, milestone tracking, resource allocation using MS Project.
• Worked on Basel II architecture is being leveraged for a number of other processes, this being performed globally and in partnership with the key stakeholders and programs of work across FA, PC and Risk management for products like Money Market, Derivatives, OTC like CDS, IRSWP, Loans (Collateral and Non- collateral) and Provisions.
• Gathered business requirements, performed Gap Analysis for client’s requirements and generated system workflows.
• Created Functional Requirements Documents for to extracted data from the treasury systems to meetDodd-Frankregulatory requirements.
• Completing Project Status Reports & participated in PMO meetings to update senior management and other stakeholders on the progress, issues and deliverables of the project.
• Implementation of recommendations from Basel Committee on Banking supervision on IT projects for Credit Risk, Operational Risk and Market Risk in line with Basel.
• Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on the progress, issues and deliverables of the project.
• Conducted data mapping & data modeling activities to map products (Equity, Bonds, Loans, etc) with the existing processes.
• Worked with the Release Management, PMO, Executive Management, along with managers/staff in Development, ETT, UAT, Core Business and other areas, to plan, deliver, and track testing progress.
• Create SharePoint work space to manage project, work break down items, prioritization lists, business requirement documents, and manage tasks.
• Optimize business requirements from as-is state documentation, SOPs, interviews with key stakeholders. Current clean in process has resulted in new enhancements to improve productivity and reduce future instruments with invalid reference data.
• Reporting on Project status to stakeholders and senior management with respect to cost overruns, time lines, risk status etc.
• Focused on stakeholders, prepared and validated high-level and detailed requirements.
• Analyzed the potential areas of improvement in the data management processes.
• Reviewed and provided inputs to the testing scenarios and test cases for all critical applications.
• Preparation of Requirements Traceability Matrix.

Business Analyst

Confidential - New York, NY

Responsibilities:

• Review system/application requirements (functional specifications), test results and metrics for quality and completeness.
• Reviewed System Test Plans, wrote test scripts and worked with business folks to validate and execute the test scripts.
• Used Product Life Cycle for implementing System requirement for Data Warehouse and Data Management and State Diagrams bases on UML methodology and process flow diagrams.
• Implemented an agile methodology for running the whole product life cycle in the project.
• Participated in GAP analysis around the identification of business rules and system process flows, user administration.
• Write and execute SQL queries to validate actual test results match expected results as per financial rules.

Business Analyst

Confidential - New York, NY

Responsibilities:

• Developed BRD, Requirements Gathering document, To-Be process document along with To-Be Workflows, Fit-Gap document along with cost/benefit analysis for each gap identified; Functional Design document and Configuration document.
• Work with QA teams to build test cases and test plans, run test scripts and log defect in HP-Quality center.
• Performed Functional testing in testing systems and regression testing on Pre-Production system.
• Identifying the defects and posting the defects in ALM.