We provide IT Staff Augmentation Services!

Sr. Ccar Business Analyst Resume

Atlanta, GA

SUMMARY:

  • Over 7+ years of progressive experience in regulatory Finance and Data Governance within top tier financial firms also involved in Regulatory Reporting and overall diversified experience in the IT and Banking & Finance.
  • Experience on CCAR, Basel II, Basel III, Dodd - Frank Regulatory Reporting FR Y-14A/Q Monthly, Quarterly, Annual, FRY9-C, DFA 165, DFA 165E and others required for banks for compliance reporting to various regulatory agencies.
  • Prepared FRDs that help drive the design of the infrastructure necessary for the organization to meet new CCAR reporting requirements.
  • Member of strategic team responsible for implementing Federal Reserve Board's Comprehensive Capital Analysis and Review (CCAR) supervisory stress testing program.
  • Supported DFAST regulatory team as a key data provider with LOB revenue and expense inputs used for stress test modelling.
  • Strong SQL queries experience for data validation, data reference, and data retriever
  • Knowledge of asset liability management, PPNR and financial risk concepts.
  • Elicited requirements by conducting JAD sessions with key stakeholders from the Capital Markets IT Group, Business Area and Application Development team for the portfolio, forecast and reporting module of the portfolio management system.
  • Present project included working within the Counterparty Credit Risk team as a Business Analyst focusing on CCAR and GMS (Global Market Shocks).
  • Expertise in drafting technical documentation such as BRD, FRD, System Design Specification, Requirement Traceability Matrix, Test Cases.
  • Liaising with Internal Audit and Compliance to ensure timely and accurate remediation in response to observations and recommendations.
  • Gather CCAR, PPNR and supplementary metrics (FR Y-14, FR Y-9C) forecast from different business units.
  • Update and manage SharePoint Site for each CCAR cycle that is utilized for CCAR communication, storage of key CCAR files including business models, and automatic audit trail that is sent to internal audit team.
  • Provided requirements for CCAR Dashboard, and TSA module enhancement for the upcoming 2017 CCAR cycle.
  • In-depth knowledge of a wide variety of financial instruments including Retail and Commercial Loans, Line of Credits, Mortgage, Equities, Fixed Income, Derivatives, Mutual Funds.
  • Coordinated the renewal of Legal, Internal Audit and Treasury Licensing, Support, and Maintenance.
  • Measured 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 portfolios.
  • Wrote SOX compliance internal controls for Revenue Audit Department and coordinated all other departments implementation.
  • Extensive experience with Capital Market, Portfolio Management, Credit Risk, Liquidity risk, Credit Rates, Market Risk, Operational Risk, ACH.
  • Strong knowledge with Basel III, CCAR, KYC rules and regulations. Expertise in Serving as Data Validation and serving as SOX application migration.
  • Expertise in working with the internal audit department to ensure operational, financial and system controls are in place according to the compliance compact.
  • Expert knowledge of Asset management, Risk management, Retail banking and Investment banking.
  • Expertise in CCAR market shock exercise prepared application mapping for FR Y-14Q report.
  • Experienced in enhancement of next generation capabilities including CCAR and DFAST to a leading practice standard.
  • Extensive understanding of Software Development Life Cycle (SDLC) including Waterfall, Agile Scrum and Rational Unified Process (RUP).
  • Expertise in Providing communication briefings to finance leadership and financial analysts regarding the implementation progress of the transition to an enterprise common system.
  • Established and maintained effective working relationships with auditees and senior business leaders to ensure optimum sharing of information between the business and Internal Audit.

PROFESSIONAL EXPERIENCE

Sr. CCAR Business Analyst

Confidential, Atlanta, GA

Responsibility:

  • Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
  • Managed team on various senior management queries consisting of risk validations and Basel 3 rule changes.
  • Worked on CCAR 14Q report for new FRB requirement like Disposition Loans, Disposed Scheduled Shift & Syndication Loan.
  • Created Test Data according to Axiom Mapping Logic and Filteration Logics of the FFIEC 031, FFIEC 041, FRY 14M/Q as per the required Schedules
  • Created efficiencies which allowed expanding the role to include Compliance and Internal Audit initiatives.
  • Interacted with country user, operation, risk management, product control, finance and other stakeholders to capture business requirements and involved in creating enterprise level flows and timelines.
  • Serving as Data Validation Team Lead and serving as SOX application migration team lead.
  • Maintained audit controls for SOX compliance and GAAP accounting and business practices.
  • Reviewed and updated DFAST process enhancements for presentation to examiners.
  • Responsible for liquidity gap that measures expected funding needs by comparing the amount of assets and liabilities maturing over specific time intervals.
  • Created Blank Instances from Source Maintenance - Axiom Controller View for the FFIEC 031, FFIEC 041, FRY 14M/Q Reports.
  • Conduct independent and comprehensive tests of Pre-provision Net Revenue (PPNR) models for CCAR.
  • Lead on the data sourcing effort for Retail Schedules pertaining to CCAR and the FR Y-14Q reporting to FED.
  • Supported a database of telecommunications rates through a research and data entry process and internal audit.
  • Gathered requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for user stories creation and obtain timely sign-off by all respective parties
  • Assisted the execution of CCAR stress testing framework including gathering requirements of multiple stress scenarios and defining data elements required by stress tests.
  • Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
  • Worked and conducted meetings with SOX and Internal Audit teams to implement SOX controls.
  • Performed analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST).
  • Assisted on CCAR model validation enhancement, including PPNR models, Y-14Q and Y 14-A models.
  • From CCAR Dashboards by mapping MDRM keys validated each of the line items in FR Y-14A Summary report (Standardized and Advanced).
  • Conducted meetings to ensure proposed changes as well as the project team produced solutions that meet established standards, procedures, risks and mitigation plans.
  • Extensive knowledge of financial statements, accounting principles, derivatives, capital market, portfolio analysis, amortization, cash, deposits, risk management, credit risk, market risk.
  • Involved with regulatory submission and internal audit requirements which were properly gathered and identified from the Subject Matter Entities (SMEs) via meetings, phone interviews, workshops, surveys, site visits, and JAD sessions.
  • Designed the Business Requirement Documents and acted as a liaison between the AML Compliance end users and the Sharepoint Developers in developing and maintaining automated systems.
  • Wrote SQL Queries extensively against different databases, generated different reports and analyzed them as per request.
  • Responsible for applying regulations based on Basel III, which further can be implemented into DFAST and CCAR, which help to project Liquidity Impact.
  • Worked extensively with onsite/offshore development teams during whole development cycle.
  • Collaborated with upstream/downstream data consumers, SMEs, QAs, Release managers and PMs to monitor test plans, test cases, UAT, post-implementation checks and future enhancements.
  • Meticulously addressed every detail to ensure a successful end-to-end business process.
  • Develop and manage business, design and end user requirements for strategic Basel 3 Standardized CCAR stress testing.
  • Participated in configuration of IHC Reporting System and other in-house reporting software /systems
  • Responsible for translation of PPNR to interest income, non-interest-income, net-interest-expense and transfer pricing and developed an internal audit program resulting in an overall 60% decrease in error rates and an increase in claim processing up to 40%.
  • Conducted multiple gap analysis against Basel II, II.5 and III rules. Validated Basel II framework, including internal rating systems (PD, LGD, EAD models) and RWA calculation.
  • Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
  • A result-oriented and dynamic business analyst in the Capital Market and Money Market.

CCAR Business Analyst

Confidential, Memphis, TN

Responsibilities:

  • Update and manage SharePoint Site for each CCAR cycle that is utilized for CCAR communication, storage of key CCAR files including business models, and automatic audit trail that is sent to internal audit team.
  • Gather CCAR, PPNR and supplementary metrics (FR Y-14, FR Y-9C) forecast from different business units.
  • Collaborate with stakeholders to discuss the feasibility, profitability, and risk of the project.
  • Analysed and created Business Requirements and Functional Requirements for 14Q/A Actuals for various schedules.
  • Performed Enrichment according to the appropriate Project, Branch and Workflows for the FFIEC 031, FFIEC 041, FRY 14M/Q Reports.
  • Perform audit of End-to-End data analysis for entire global operations which are input to Basel, DFAST and CCAR reporting projections and overall reporting/exposure/forecasting.
  • Wrote SOX compliance internal controls for Revenue Audit Department and coordinated all other departments implementation.
  • Collaborating on IHC wide initiatives by providing Basel III expertise and ensuring that risk-based capital
  • Ensuring the data quality by checking the completeness, consistency and accuracy of risk data for regulations of BASEL III and Comprehensive capital analysis and review(CCAR)
  • Assist to develop project plan using Agile Methodology.
  • Collaborated in the implementation of a risk management framework to ensure the functions are in compliance with the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
  • Gather detailed business requirements and deliver detailed business functional requirements specifications.
  • Created UML diagrams such as Sequence Diagrams, Activity Diagrams and User Stories when needed.
  • Created the initial SOX controls for General Ledger and Inventory segments.
  • Conduct requirement review sessions with Quants, Developers, and Testing Team. Worked closely with management, sales and finance departments.
  • Developed a risk based test plan by selecting appropriate audit approach, test procedures and sampling criteria based on professional judgment and departmentally defined internal audit methodology.
  • Support listed/OTC derivatives and Hedges trade capture or trade ordering requirements for system.
  • Developed internal control procedures to satisfy SOX requirements.
  • Expertise in creating and updating CCAR, BASEL, DODD FRANK presentations to various board management and regulatory bodies.
  • Prepared month-end professional liquidity stress testing commentary and Broker-Dealer stress testing report to the senior management
  • Reviewing CCAR to Custody Reconciliations Identify the discrepancies and take immediate action to fix the issue. If break is due to an erroneous or missing transaction in CCAR make necessary adjustments.
  • Analyzed the new regulatory requirements of Basel Accord of Pillar 1, 2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
  • Experienced in the Financial Industry with exposure to Retail Banking, Investment Banking, Capital Markets, Retail Market and Digital Media Market.
  • Served as a liaison between Internal Audit, Model Development, Model Validation, Finance/Treasury, Business and Technology functions as related to PPNR models and applicable work stream project management requirements.
  • Developed Point of View marketing materials and internal training focused on the evolving liquidity regulatory landscape.
  • Compiled data in the FRY 14A summary templates for mid-year DFAST submissions and the FRY 14A CCAR submission.
  • Worked on a Risk Management System, which supplies users with intra-day and end-of-day speeds, status of modelled bonds, as well as credit and market risk information.
  • Provided credit fixed income support to corporate clients and to the Global Syndicated Finance, Loan Trading, and Debt Capital Markets desks.
  • Work experience in Risk Control, DFAST (Dodd Frank), CCAR and other regulatory reporting process.
  • Interacted with different businesses in RBC to identify the source of the data to satisfy the requirements of PPNR schedules for FR Y-14Q and FR Y-14A.
  • Created suite of Excel models used monthly for analysis and verification of Basel II results in Production environment.
  • Involved in Map-Gap data remediation analysis for 14Q schedules.
  • Utilized knowledge of Equity Capital Markets and developed an understanding of clients' needs to identify business opportunities.
  • Determined alternative approaches to Basel I regulatory capital calculations allowing significant capital savings.

BUSINESS ANALYST (CCAR)

Confidential - Dallas, TX

Responsibilities:

  • Collaborated closely with Investment Risk, Asset Management, Actuarial, Treasurers and Finance departments to propose most comprehensive Asset-liability Risk Models (ALM) of investment strategies analysis.
  • Analysed and design of CCAR (FR Y-14A schedules of Income statement and balance sheet), FR Y-9C (few schedules), report requirements in AXIOM.
  • Gathered CCAR PPNR and supplementary metrics (FR Y-14) forecast from different business units.
  • Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
  • Participated in data modelling, data analysis and requirement documentation. Involved in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR, stress testing (Dodd-Frank Act Stress Test).
  • Worked cross functional to setup global Key Risk Control Frameworks & IHC Enterprise Risk Management Framework (ERMF) SharePoint to collaborate policies.
  • Developed business and functional requirements and obtain timely sign-off by all respective parties. Developed good practices for risk modelling procedures related to CCAR/DFAST (Dodd-Frank Act Stress Test).
  • As part of CCAR, worked on Stress Testing solution (Dodd-Frank Act Stress Test) to check the health of the portfolio of investments for the client to ascertain Capital adequacy.
  • Conduct Brainstorming and JAD Session to gather Business Requirement s with Regulatory and Compliance subject matter experts to have a good knowledge of CCAR reporting.
  • Designed the various Use Cases as well as corresponding use case description documents.
  • Assisted in the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition.
  • Responsible for business analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
  • Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME's.
  • Prepared Use cases and Activity flow diagrams and Workflow diagrams, considering the scope of the project with MS VISIO 2003
  • Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the Business process owners & stakeholders for implementing the OBIEE reporting tool.
  • Implemented agile methodology for running the whole product life cycle in project.
  • Coordinate closely with traders, middle office, data and technical operations support, various application development teams to report and communicate the execution status back to the business and senior management.
  • Systematically gained knowledge on the business process being followed in the project environment.
  • 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.
  • Managed the bank-wide, stress-testing timeline and exchange of deliverables between process stakeholders during CCAR/DFAST cycles, adhering to deadlines.
  • Dealt with the Society for Worldwide Interbank Financial Telecommunication (SWIFT) in creating the criteria for the auditing of the TQR and Q-Gate review processes.
  • Regularly assisted with maintaining existing Liquidity Risk Infrastructure reporting applications and analyzing Production issues within the infrastructure to garner a resolution
  • Analyzed SWIFT and MQ Series data volumes to derive data mapping. Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions.

Business Analyst

Confidential - Vienna, VA

Responsibilities:

  • Gained experience through whole SDLC from requirement analysis till deployment, using highly efficient RUP process of software development.
  • Gathered requirements and prepared business requirement documents (BRD), translating BRD into functional specifications and test plans
  • Used Rational Tools to create and maintain the various artefacts such as visual modelling using UML through Rational Rose.
  • Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
  • Part of team to elicit, organize, and document required functionality and constraints.
  • Responsible to track, document, capture, manage and communicate the requirements using Rational Requisite Pro which helped in controlling numerous artefacts produced by the teams who are working on same project.
  • Implemented RUP iterative approach, which allowed increasing understanding of the problem through successive refinements, helped us to incrementally grow an effective solution over multiple iterations.
  • Experienced RUP's development cycle with four consecutive phases - Inception, Elaboration, Construction, and Transition.
  • Assisted in performing liquidity risk & credit risk analysis on outstanding loans under different pressured scenarios.
  • Extensively designed use case diagrams, object diagram, class diagram, state diagram, activity diagram, sequence diagram, component diagram and deployment diagram.
  • Maintained Requirement Traceability Matrix (RTM).
  • Reviewed quality with respect to the requirements based on reliability, functionality & performance with the help of QA testing team.
  • Suggested various improvements in the data flow process from transaction systems to back-office accounting systems in Oracle and Access for reporting purposes.
  • Facilitated Join Application Development (JAD) sessions with the IT groups to ensure timely project deliverables.
  • After successful development and testing of the product, participated in UAT, product release and deployment to end-user.

Hire Now