SUMMARY:

• 7+ Years Professional Experience as Business Analyst with strong knowledge in Banking, and Retail Banking and Finance. Collaborated in the implementation of a risk management framework to ensure corporate functions follow the Federal Reserve's Comprehensive Capital Analysis Review (CCAR) regulatory requirements.
• Strong Knowledge and experience of Agile, RUP's Iterative Software Development Life Cycle (SDLC), Waterfall processes.
• In depth knowledge Rational Unified Process (RUP) Waterfall methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Extensive experience in Requirements Gathering, Surveys/Questionnaire Development, Business Requirement Documents (BRD), Functional Requirement Specifications/Documents (FRS/FRD).
• Excellent acknowledge of Banking and Regulatory Compliance, Anti - Money Laundering (AML), Basel Accords, Dodd Frank Act, Customer Identification Program (KYC/CIP) and Fixed Income Clearing Corporation (FICC) compliance rules with hands on experience in risk management.
• Excellent understanding of Dodd-Frank and Basel III regulatory rules, especially in RWA & LCR. Experienced in CCAR Regulatory Reporting and CCAR Stress Testing for Banking Balance Sheet Asset management
• Strong knowledge with CCAR, FR-Y 9C, FR-Y 14Q, PPNR, FR-Y 11, FR-Y 9LP, FFIEC 031, FFIEC 041, FFIEC D09, Dodd-Frank, KYC, AML, FINRA's rules and regulations
• Strong background in CCAR Regulatory Reporting especially in FRY 9C, FRY 14Q, FRY 14A
• Working knowledge of Case Management Applications (Actimize) and Strong product knowledge on financial instruments and payment/Treasury products Understanding of AML, KYC process, and Trade Life Cycle Working knowledge of AML/Financial Data
• Experience in analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST).
• Knowledge of various financial products, retail & commercial lending, credit risk management and regulatory risk reporting like Basel II, Basel III, CCAR and FDIC
• AML/KYC Compliance: Extensive knowledge of Anti-Money Laundering (AML), Know Your Customer (KYC), FATCA compliance
• Extensive knowledge and working experience of financial accounting, SOX, Dodd Frank Act, US GAAP, CCAR, Bank Secrecy Act (BSA), PATRIOTS Act.
• Excellent understanding and work experience over different Equities, Equity derivatives and Fixed Income instruments: Bonds, Cds, Repos, CMOs, CLNs, MBS, ABS; OTC derivatives: Forwards, Futures, Options, Swaps investments. Excellent understanding of fixed income security trading activity and its risk analytics (duration, convexity, spread etc.)
• Extensive experience in conducting Joint Application Development (JAD) sessions with committee of Subject Matter Experts (SME's), senior management and IT groups.
• Performed complex RWA impact assessment for RWA reduction initiatives like Securitization, Hedging, etc. that are required by Front Office, Senior Management and Regulators.
• Solid understanding and knowledge of Equities, Derivatives (Futures, Options, Forwards, Swaps), and Regulatory Reporting (FRY9C, CCAR, FR2420, FFIEC Report)) FFIEC, RWA, Risk Analysis.
• Used Applications: MS Office 2013 - Excel, Access, Word, Outlook, PowerPoint, MS Communicator (focus on Excel, Outlook & Access); eLedger (SAP), BEx (Business Explorer Web), DID (Document Direct), SharePoint, EBIR (Enterprise Business Intelligence Reporting), SolMan (Solution Manager), iGL, Oracle, EPM (Enterprise Performance Management), ClusterSeven and Essbase/Vision, Siebel.

TECHNICAL SKILLS:

Methodologies: Unified Modeling Language (UML), SDLC, RUP, RAD, Agile, Waterfall

Database: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Automation Tools: Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum OS UNIX, Windows Windows Linux

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest, HP Quality Centre, JIRA

Utility Tools: MS Office Suite, MS Project, MS Visio, Lucidchart, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS), Oracle Primevera P6

Version Control: Rational ClearQuest & ClearCase, IBM Lotus Notes, SVN (Subversion)

Testing Tools: Quicktest Pro (QTP), TestDirector, WinRunner, LoadRunner, WorkBench.

WORK EXPERIENCE:

Senior Business Analyst

Confidential - Plano, TX

Responsibilities:

• Responsible for projects in Asset Management, Trading floor (Swift, ETF), Client Availability, Collateral Management, compliance regulatory projects and Liquidity cash management projects (for diverse types of assets Equity and fixed income)
• Managed the project deliverables documents (project estimates/PIR/BFSD (Functional specifications) for multiple releases, overall product Visio and Training Document)
• Responsible for drafting the high-level Cash liquidity management flow for multiple investment vehicles.
• CCAR FR Y-14 internal subject matter expert; provide technical advisement and interpretation of instructions.
• Reviewed and updatedDFASTprocess enhancements for presentation to examiners.
• Worked on creating and validating FR-Y 14 a and Q reports.
• Optimized data from multiple VMS (Vendor Management Systems) allowing balancing of hours, pay rates and bill rates using Excel VBA macros.
• Involved in the FRY9C and CCAR Q/M/A data analysis and reporting.
• Created requirements for FRY14 M/Q/A and interacted with the Axiom team to understand the data flow from station into Axiom.
• Involved in migrating and conversion of databases from Mysql and Oracle to SQL SERVER 2005 using SSIS.
• Consolidated and analyzed client feedback and drove improvements into theOFSAAproduct.
• Worked on preparing metadata for regulatory reporting FFIEC 101, FR-Y 7, FR-Y7Q, FR-Y 14, FR-Y9C, FR-2248, FR 2236, BQ1, BQ2, BL1, BL2, AND on other regulatory reports.
• Automating key reports in Business Intelligence (OBIEE) suit for senior management, branch heads and internal audits.
• Drafted process flow diagrams timelines and build-out theBusinessRequirement Document (BRD) and post-production test plans remediating defects discovered during previous 2015 OCCDFAST/CCAR cycle.
• Managed the resources and cost ramifications. (Via RPS and ATRACK tool)
• Responsible for investment vehicle reconciliation research via SQL queries using Access, Oracle and Excel (pivots)
• Responsible for mapping data and Calculating Regulatory Capital Ratios (Capital Adequacy Ratios), such as Tier I & Tier II capital ratios, Leverage Ratios, Projections of RWA, PPNR and Balances schedules as part of theDFASTexercise
• Work collaboratively with the leads of DML (loan booking system), SLE2 and SLE1 (transaction systems for Auto-borrows, reallocations, adjustments and accruals, trade instruction settlement to SMAC and GSMAC), SSGA (US and Canada Reinvestment) Trading floor, FAD (Financial Accounting Desk), Risk and Compliance
• Worked extensively with SLE2 (Instruction processing and Settlement US and Canada), SLE1 (Non-US), DML (official book of records, the lending system)
• Managed a team of Business Systems Analysts, SQA Leads and Tech Leads for five subsystems within the project.
• Performed sample data analysis and data quality control validation of Basel III regulatory reporting systems using pivot table calculators, stored procedures and SQL queries
• Responsible for business case development, ROI analysis and planning for Securities Finance cash management project.
• Worked with the System Analyst and Development team onOFSAA(RWA) side for integration purposes, as data flows from ODS toOFSAAsystem for calculation and reporting purposes
• Responsible for scope definition, budgeting, SQA issues management and facilitation.
• Responsible for developing the business cases and high-level test scenarios for negative, positive earnings VS reinvestment US and Non-US assets.
• Responsible for developing the business cases and high-level test scenarios for negative, positive earnings VS SSGA reinvestment for US and Non-US.
• Responsible for developing the business test scenarios for duration assets and VCP investment vehicle and comingled vehicles.
• Worked with DT, T2T, Measures of the OFSAA Data Model
• Responsible for developing the business test scenarios for end of day cash balances for USD, GBP, and EUR investment vehicles.
• Responsible for developing the business test scenarios for duration assets and floating rate NAV investment vehicle

Business Analyst

Confidential - Charlotte, NC

Responsibilities:

• Worked on their Banking Module. Banking is primarily the process of enabling clients operate account s Completely Online (Without having to reach for a branch).
• Designed and built a Microsoft Access database for Teller Utilization reporting and Confidential Works reporting.
• Describe processes for landing, staging, calculations and reporting schema with attributes, calculations, and rules for outputs from theOFSAAsuite.
• 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).
• Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new systems operations for the Online Banking project using Rational Requisite Pro.
• Conducting web based sessions to showcase theOFSAAReporting Analytics capability to the Business and Technical Users.
• Interact with business users and subject matter experts to produce technical documentation and business requirement documents (BRDs) for CCAR filing for FRY-9C, FRY 14M, FR Y 14Q, and FFIEC 031 reports as well as IHC filing.
• Regularly holding sessions with Lines of Business (LOB) to document, implement and maintain the metadata and business rules for the bank's data, beginning with the data required for CCAR.
• Provide technical expertise and knowledge to the software engineering team for the functional side of the collaboration tools (JIRA, Confluence and SharePoint) along with Front End and Back End support to the team.
• Liquidity Risk, Market Risk & Portfolio Management, Profitability Management and Asset & Liabilities Management (ALM) and Liquidity Risk Management (LRM), Enterprise Stress Testing & Capital Planning; Business Intelligence & customer Insights.
• Provided statistical guidance to the development team on the interpretation of VaR models, IRB - F/IRB-A Economic Capital calculations, Liquidity Ratios and Stress Testing scenarios as per new BASEL III requirements.
• 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).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed Data Validations and Data checks for RWA calculations or leveraging output from the RWA calculations.
• Involved in validating vendor provided Reveleus software i.e OFSAA which involves all different operational risk modules with many more features including batch execution, scheduling, monitoring, Excel upload into staging and fact table.
• Used Castor to create objects from XML documents. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Complete understanding of the IT architecture and environmental stages (ISO, UAT, Prod, DR) along with code migration.
• Updated the OFSDF data Model to include new BASEL III related entities; Validated the pre-built BASEL III business rules and runs in OFSAAI Application Infrastructure; Enhanced the BASEL II Analytics Solutions to include additional reports as per BASEL III requirements in OBIEE and upgraded the underlying OBIEE repository.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.
• Architected enhancements in group stress testing application (FOREST) for CCAR requirements and scenario generation process.
• Daily user of Oracle, Ariba, CRM, Microsoft Office Suite, PeopleSoft, FileNet, Agile and other various programs.

Business Analyst

Confidential - Pittsburgh, PA

Responsibilities:

• Performed detailed gap analysis for CCAR exercise, which included identification of the RBS group's stress testing capabilities and scenarios, CCAR template analysis, risk factor analysis, and reporting. Summary was used for ExCo and the Board meeting, guiding major strategic decisions for the firm.
• Gather CCAR, PPNR and supplementary metrics (FRY-14, FRY-9C) forecast from different business units.
• Support the assessment of CCAR IHC report preparation environment.
• Gathered requirements from the clients and worked immensely on customer's reviews section on the website with the help of offshore team using WordPress, content management system.
• Worked on the upgrade of FileNet imaging and BPM (Business Process Management) system. This was the daily workflow engine used in the claims department.
• Created data dictionary and data decomposition documents, including FATCA regulations
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Strong experience in conducting Functional Testing, Regression Testing, User Acceptance Testing (UAT), and System Integration testing (SIT).
• Running tax forms through programs such as Comply and Investor Insight to make sure they are FATCA compliant.
• Prepared the groundwork for ETL process and provided the blueprint for this process to the ETL developer by coordinating with database architect and ETL developer
• Environment: SQL, MS Access, MS Project, MS Visio, MS Office Suite, Adobe Acrobat Suite, Jira, AXIOM.
• Performed cost benefit analyses and evaluated alternate courses of actions. Developed Independent Government Cost Estimates (IGCE). Monitored and reported cost benefits for Foreign Excess Personal Property (FEPP),
• Continually collaborated with developers to deliver Basel required results using the OFSAA/Reveleus solution.
• Worked on counterparty stream on CDS (credit default swaps), IR derivatives, foreign exchange, OTC, Repo, Reverse Repo, Inside Trading and Trading and investment part of counterparty for Basel III changes. Counterparty Risk - Commodities, FX, FX options, FX swap options, Non-deliverable Forwards, FX Cross Currency swaps, FX rates and Treasury Funding models, Money Markets, Fixed Income.
• P&L Risk management -monitoring (mainly for hedge funds strategy). Ensured that the modifications suggested by the users were incorporated into the application
• Responsible for updating of the OFSAA/Reveleus Metadata documentation to keep documentation in-line with the solution.
• Advising other assets engaged in the project on OFSAA configuration details.