SUMMARY

• Analytical, seasoned professional with 7+ years of experience in financial services.
• Excellent understanding of banking business operations, products/services, systems, and associated risks/controls.
• Recognized for expert analytical skills with a strong knowledge of CCAR/D - FAST, AXIOM & AXIOMSL.
• Dependable, thorough, and well-organized professional who is focused to work effectively with attention to key priorities.
• Experience in reviewing data volumes of secured documents and preparing for legal matters and regulatory reporting and compliance.
• Possess exceptional organizational skills - driving efficiency, accuracy, reporting, and decision-making capabilities.
• Recognized as a team player who consistently meets established deadlines.
• 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.

AREAS OF EXPERTISE

• LCR & NSFR calculator
• Multi-jurisdictional reporting
• Aggregation of LCR compliance Entities and Consolidated Parent
• Aggregation of Liquidity Measures by Business Unit hierarchies
• Dynamic dashboard
• Variance & trend analysis
• Cash flow generation engine
• Liquidity and capital stress testing

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

Sr. 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

Sr. 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 Jersey

Responsibilities:

• 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.
• Conducting/Participating in project inception meeting, capturing high level features and functions.
• Projecting estimations and level of effort for the project.
• 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 agile methodology for running the whole product life cycle in project.
• Participated in GAP analysis around the identification of business rules and system process flows, user administration, requirements and assumptions.
• Conducted JAD sessions during the various stages of upgrading the matching system and discuss the current system preference.
• Have prepared the Test Specification document and review the test cases prepared by team along with complete coverage matrix.
• Write and execute SQL queries to validate actual test results match expected results as per financial rules.
• Identify and log defects if/when a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.

Business Analyst

Confidential

Responsibilities:

• Extensive experience in gathering Business and Functional Specification Document (FSD).
• Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives
• Created "How To" forms and documentation to form a knowledge base on SharePoint.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures to create a Business Requirement Document (BRD) of Mortgage application.
• Created artifacts such as Use Cases, Activity Diagrams, and Sequence Diagrams using MS Visio.
• Conducted JAD sessions during the various stages of upgrading the matching system and discuss the current system preference.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.