SUMMARY:

• Experience on Product Control, Financial Accounting, IT, and Operations to understand and document data and business need in order to meet the FED requirements for IHC/CCAR reporting.
• Reformed banking capitalization and qualification regulated by Basel III compliance base regulatory requirement.
• Extensive experience in ALM Template coding and implementation and assisting users speed up with the ALM process and Dodd - Frank Act Stress Test.
• Responsible for building requirements (business & functional) for topics related to Intermediate Holding Company (IHC), Basel III, Dodd Frank, Federal Reserve, FASB 133 and CCAR.
• Deliver and developed FTP rate files/ templates, on a timely basis to the Operating Groups.
• Knowledge of Basel II/III, CCAR, DFAST, PPNR, ALLL, AML, KYC, Credit Risk/Market Risk/Liquidity Risk Modeling and Management
• Familiarity with Axiom objects such as Data Source, Data Model, Shorthand, Portfolio, Aggregation, Report and Workflow and experience in Stress Testing, Basel I,II,III.
• Identify overlapping data being reported between IFRS and US GAAP, between IHC and other regulatory requirements such as FR Y-9.
• Experience in implementing financial reporting controls and procedures documentation for all accounting functions.
• Performed Enrichment according to the appropriate Project, Branch and Workflows for the FFIEC 031, FFIEC 041, FRY 14M/Q Reports.
• Experienced in risk and regulatory requirements - Dodd-Frank, AML/KYC, Basel II &III, and other regulatory requirements frameworks.
• Delivered a consolidated reporting view of the bank's liquidity risk and assessment, along with the tools necessary to report the liquidity.
• Managed overall project and requirements for the regulatory project. This included process flow changes for product streams, DFA Initiatives, CCAR Initiatives and local development efforts for the Business.
• Basic understanding in creating dashboards with Tableau and Qlikview software.
• Created reports using Excel, Access and SQL to monitor the accuracy of system changes
• Experience in building requirements (business & functional) for topics related to Intermediate Holding Company (IHC), Basel III, Dodd Frank, Federal Reserve, FASB 133 and Comprehensive Capital Analysis and Review (CCAR).
• Extensive experience in IT including audit direction and leadership, regulatory control assessment, quality assurance, business process.
• Analysis and design of CCAR (FRY 14A schedules of Income statement and balance sheet), FRY 9C (few schedules), report requirements in AXIOM.
• Interact with business users and subject matter experts to produce technical documentation and business requirement documents (BRDs) for CCAR filing for FR Y-9C, FR Y 14M, FR Y 14Q, and FFIEC 031 reports as well as IHC filing.
• Full SDLC experience including Requirements, Analysis/Design, Development and Testing for Waterfall and Agile methodologies.
• Ran the Report in Axiom Controller View Tool to view the Output of the FFIEC 031, FFIEC 041, FRY 14M/Q forms.
• Expertise in requirements gathering through JAD sessions, workshops, and repository research with Business Owners, Business Users, SMEs and specific stakeholders.
• Excellent knowledge in the analysis, design of system applications and business processes applying Unified Modeling Language (UML).
• Created different types of reports in Axiom - Control Report, Adjustment Report, Manual Upload template.
• Used business process tools such as MS Project, MS Excel, MS Access, MS Visio, ERWIN, DB2, Rational Clear Quest, JIRA, SQL Reporting for project work
• Exceptional ability to create, comprehend process-level and system-level documents including Functional Specifications, Project Scoping, Project Planning, AS IS vs TO BE analysis, Gap & SWOT Analysis.
• Determined alternative approaches to Basel I regulatory capital calculations allowing significant capital savings.
• Gathered DFAST and CCAR stress-testing data to compare baseline forecast models and assess variances in liquidity risk scenarios, proprietary model results and Call Report submission.
• Experience in process modeling using Use Cases, Sequence Diagrams/Process Flow Diagram, Collaboration diagrams, swim lane flow charts, Activity & Class Diagrams.
• Highly experienced in creating the requirements artifacts, Business Requirement Document (BRD), System Requirements Specification (SRS), Use-cases, Functional Requirements Document (FRD), Technical Requirements Document (TRD) and Change Requests Planning (CRP).
• Experience on Master Data Management (Gap and reference Data mapping for business process involving data migration, conversion, and mergers.
• Experience in reviewing Test Procedures and creating Test Cases, Test Scripts and Test plans.
• Familiarity with White box and Black box testing including functional testing, unit testing, integration testing (UAT), smoke testing, system testing (SIT), and Workflow Testing and regression testing.

WORK EXPERIENCE:

Business System Analyst

Confidential, Malvern, Pennsylvania

Responsibilities:

• Liquidity Risk Management and Compliance - LCR Calculation Reporting. Work with Risk team to calculate the new Basel III Liquidity Coverage Ratio LCR and including liquidity buffer eligibility rules and haircuts. Consolidate leverage,capital and liquidity ratios per booking entity or currency. Managed liquidity risk calculations, regulatory compliance and reporting from a single, integrated platform, offering access to users across the organization. Risk, finance, ALM and liquidity teams can easily access the same underlying data for more consistent and streamlined liquidity risk management.
• Wrote documents in Workiva Wdesk document management system and Implementing Regulatory Reporting Processes.
• Completed IT Audit Risk Assessment for the enterprise, prepared IT Audit Annual Plan that was approved and presented to Audit Committee and Board of Directors.
• Understand the reporting and submission process for CCAR reports and the CCAR reporting architecture.
• Adept in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS).
• Reviewed and updated and Dodd-Frank Act Stress Test (DFAST) process enhancements for presentation to examiners.
• 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).
• Compiled and analyzed public and reporting data on various LFIs for market/ liquidity vulnerabilities.
• Analyzed the AML trade surveillance compliance requirements by interacting with the compliance department and SME experts within the laws/act of compliances.
• Define and manage project to support the needs of Basel III reporting solutions.
• Perform check for AML for all incoming and outgoing payments.
• Analyze and report viability of application software to maximize both GCC and application controls for SOX and operational audits.
• Secured new projects to ignite revenue and elevate IT audit / business systems integration projects.
• Manage annual bank internal audit risk assessment process and testing of internal financial reporting controls in compliance.
• Responsible for the development and oversight of the internal audit function, reporting the results of audits to the audit committee and annual audits of financial reporting controls.
• Attended PMO with SMEs, stakeholders to ensure the proper system, process, and business analysis and requirements gathering for assigned projects information/data security program, regulatory reporting (PF, PQR, PR, ADV, 13F); compliance monitoring.
• Analyzed and created Business Requirements and Functional Requirements for 14Q/A Actuals for various schedules.
• Experience in complete Forecast to Plan (FTP) loading the forecasts to generate MDS, generate ASCP plans.
• Performed an analysis on the systems. Requested owners Business Requirements Document's to identify gaps to US Basel III.
• Assist on-site audit on Cycle Count of Inventory reconciliations and work on special projects (Data Governance) as assigned.
• Improved core business/technical functions & tools including (MIS), financial reporting, forecasting, (IFRS).
• Preparation and analysis of various schedules in the Consolidated Financial Statements for Bank Holding Companies (FR Y-9C) and the Consolidated Reports of Condition and Income FFIEC 031.
• Worked as systems lead in testing all changes in the merchandising systems, reviewed by running may SQL reports and analyzing data prior and post system changes.
• Documented Key Operating Procedures and updated Axiom rules and processes.
• Managed and maintained ownership of a unique FTP server.
• Managed Compliance requirements for reporting employee Disciplinary, Monitoring & Testing, Verification Check, Trade Surveillance and Control Room Surveillance, Issue Management, Barclays Internal Audit, BRES using Business Objects and Tableau
• Develop and Implement new database objects (tables, views) for reporting purposes using T-SQL.
• Analysis and design of CCAR (FRY 14Q and FRY 14M - all schedules), FRY 9C (few schedules), FFIEC102, etc.
• Coordinated with information technology to adopt FTP process for pulling bank files into corporate accounting system in an effort to eliminate dial-up processes at the Cash Desk.
• Supported AML investigation requirements of the WB TMU.
• Plan, implement, coordinate and execute IT Audit processes including testing to ensure adherence with established controls, and reporting known or possible deficiencies
• Helped create the process for the production of the liquidity ratios required by Basel III.
• Maintain a detailed understanding and ongoing review of all U.S. and global regulatory rules.
• Familiar with Basel, Dodd Frank Act, CCAR Regulatory Reporting - FR Y-14 Monthly, Quarterly, Annual, FR Y 9-C and others required for banks for compliance reporting to various regulatory agencies.
• Responsible for the data integrity of the Global General Ledger Reconciliation Log, collecting and analyzing data and evaluating information and systems for CCAR filing for FR Y-9C, FR Y 14M, FR Y 14Q, and FFIEC 031 reports.
• Create sophisticated queries/stored procedures to meet reporting needs using T-SQL
• Collaborated with portfolio compliance, front office, and other internal departments to review regulatory impacts to funds, client accounts, and business.
• Managed daily liquidity, cash reporting, and money market portfolio.
• Created different types of reports in Axiom - Control Report, Adjustment Report, Manual Upload template.
• CCAR/DFAST documents and extracted requirements for Global Market Shocks and Counterparty Default.
• Defined Data Model Requirements to meet Reporting, Analysis & specific Business Objects needs. Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Managed domestic and international banking and liquidity.
• Experienced in conducting JAD sessions with excellent inter-personal & conflict resolving skills.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Conducted End to End functional testing and UAT testing.

Sr. CCAR Business Analyst

Confidential, Des Peres, Missouri

Responsibilities:

• Managed overall project and requirements for the regulatory project. This included process flow changes for product streams, DFA Initiatives, CCAR Initiatives and local development efforts for the Business.
• Assisted in the development and testing of new reporting tool to replace reporting application used for internal allocations of foreign transactions booked on domestic offices (PRF) on Foreign Income Statement of the Call Report (FFIEC 031).
• Captured existing process of funding, banking and transfer, conducted Comprehensive Capital Analysis and Review (CCAR) which is the initial part of the three phases of Basel.
• Collaborated with Enterprise Risk Management and Regulatory Capital Policy to devise strategy to meet requirements of Basel II Capital Accord and present such strategy in person or via memoranda to senior management and Federal regulators.
• Review of data governance processes for identifying sensitive data and the technologies deployed to prevent and detect leakage of sensitive data through via various technologies and channels, including e-Mail, Web Surfing and other avenues.
• Introduced IT audit services to new clients and review and testing of high risk banking applications.
• Audited securities pricing (equities, fixed income, and derivatives) and was heavily involved with internal audit to evaluate/improve financial reporting controls.
• Forecasted macroeconomic and financial indicators by running linear and multi-variable regression models on relevant data sets.
• Demonstrated an understanding of the client's environment and assessed the adequacy of the application security, application configuration and automated application controls.
• Reinforced IT audits for Bank Secrecy Act (BSA) E-Filing System electronic filing of forms through a Financial Crimes Enforcement Network (FinCEN) for large cash transactions.
• Worked with developers in defining the data elements for staging area and reporting Data Mart for extraction to Axiom reporting application and CCAR modeling team.
• Extremely familiar with Axiom objects such as Data Source, Data Model, Shorthand, Portfolio, Aggregation, Report and Workflow.
• Extensive experience in Microsoft T-SQL, creating and optimizing all database objects - Stored Procedures, Tables, Views, Triggers, Indexes, User-defined Functions, Subqueries and Joins.
• Build and maintain CCAR (Comprehensive Capital Analysis & Review) operating rhythm and governance framework.
• Worked with Axiom reporting developers to coordinate delivery of interface files to their UAT environment and for resolving data issues with source system teams.
• Worked with Finance Regulatory Reporting Teams and Axiom Report Producers to establish data requirements for FRY-9C schedules with crossed functional data sourcing teams.
• Gathered DFAST and CCAR stress-testing data to compare baseline forecast models and assess variances in liquidity risk scenarios, proprietary model results and Call Report submissions.
• Collaborated with Enterprise Risk Management and Regulatory Capital Policy to devise strategy to meet requirements of Basel II Capital Accord.
• Worked closely with the Mantas/AML compliance team and other stakeholders to agree on system changes to enhance existing AML functionalities in front - back office systems to prevent regulatory violations.
• Developed and deployed Tabular Reports, Matrix Reports, Drill-Down reports, Cross-Tab Reports and Ad hoc reports by using SQL Server reporting services (SSRS).
• Strong business analysis skills and a sound understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP) methodology.
• Experienced in conducting JAD sessions with excellent inter-personal and conflict resolving skills.
• Planned and conducted UAT, UI conformance testing and created test plans, test cases and Requirement traceability matrix.

CCAR Business Analyst

Confidential, CA

Responsibilities:

• Created reporting templates within ControllerView based on the regulatory requirements and business rules.
• Create Technical specifications documents based on the functional design document for the ETL coding to build the Source data mart for AxiomSL.
• Comprehensive understanding of the statutory framework (Dodd-Frank, Basel, GAAP, 1940 Act, BSA/AML, FACTA).
• Performed audit of IT general and application controls, information security, systems development, change management, business continuity, disaster recovery and computer operations.
• Preparation of audit documentation and development of IT audit recommendations to help audit clients improve their IT internal control environment.
• Experienced in conducting JAD sessions with excellent inter-personal and conflict resolving skills.
• Review and update templates utilizing the Governance & Oversight Framework and Enterprise Data Governance Policy.
• Assisted with meeting global and local regulatory/management reporting requirements.
• Assisted in development of business plans to support the CCAR process and stress testing requirements while working with the business to assess and challenge the assumptions and forecasting approach.
• Managed the execution plans of the Financial Management (HFM) and Axiom/CCAR Regulatory Reporting.
• Involved in optimizing slow running SQL queries to improve performance and availability by using Execution Plan and SQL Server Profiler.
• Implemented an IT audit approach for validating the interfaces for the policy maintenance system.
• Designed UI by interacting directly with the client and IT team in successful representation of regulatory risk and reference data for client approval and submission to FED.
• Continually collaborated to analyze and mitigate the effects of regulatory changes (Basel I - II) on various business lines.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services.
• Involved in developing the test strategy and assisted in developed Test scenarios, test conditions and test cases.
• Partnered with the technical areas in the research, resolution of system and User Acceptance Testing (UAT).

Business Analyst

Confidential

Responsibilities:

• Gathered Business Requirements, defined the scope of the project, analyse and prioritized requirements, developed customized business strategies, and identified high potential business opportunities.
• Assisted in performing liquidity risk & credit risk analysis on outstanding loans under different pressured scenarios.
• Coordinated meetings with IT and business on various solutions within SDLC.
• Write and execute SQL queries to validate actual test results match expected results as per financial rules.
• Work with region and country AML Compliance employee to support start-up of compliance-projects at regional and country levels. Including defining the subsequent phases training, UAT, staff to perform test scripts, data migration and the uplift strategy (updating of customer information to bring them to the new KYC standards) review of customer documentation.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Tera data, and MS Access. Produce performance reports and implement changes for improved reporting.
• Handles Trade Capture team whose main function is to capture the client trades in our system. It is the most crucial process in OTC derivatives department since this team is the source of information for all the verticals of OTC derivatives team.
• Worked on equity reconciliation, confirmation of payment details, and documentation for all fixed income derivative trades to support bond-trading group
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements.
• Reported all the defects in Quality Centre while conducting UAT and stress tests.
• Facilitated UAT and recorded the user feedback for future changes.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit- ratios, captured long running SQL/runaway queries using SQL Server.
• Identified and documented Functional/Non-Functional and other related business decisions for implementing Actimize-SAM to comply with AML Regulations.
• Supported Instruments include FX (spot, forward, and NDF options), Futures (interest rate, FX, and equity), OTC and listed options, interest rate derivatives, credit derivatives, and fixed income.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Designed and developed project document templates based on SDLC methodology
• Played a key role in the planning, User Accepted testing, and Implementation of system enhancements and conversions.
• Daily involvement with the agile software development life cycle (SDLC), documentation and working through systems issues as part of a business analysis team.
• Conducted weekly and monthly meetings to review the business processes, and update the team on project progress.
• Worked closely with the development team to create an Entity Relation Model (ERM) and conducted tests and analysis using SQL queries.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.