Business Analyst Resume
Birmingham, AL
SUMMARY:
- Over 7 years of extensive work experience as a Business Analyst, Risk Analyst, Credit Risk Analyst and Insurance, Reinsurance, Underwriting, Claims Analyst in Banking, Finance, Insurance, Reinsurance, P&C insurance and Health Insurance domains with Expert knowledge of Asset management, Risk management, Retail banking and Investment banking.
- Extensive experience of using the financial instruments including Equities, Fixed Income Instruments, Derivatives (Future, Option, Swap, Forwards), and Alternative Investments (REIT, Hedge Fund, ETF, Mutual Fund)
- Comprehensive experience in analyzing Financial Risk such as Interest Rate Risk, Default Risk, Credit Risk, Inflation Risk, Operational Risk, Market Risk, Systematic Risk, and Volatility Risk associated with investing in securities. Detailed knowledge in Risk Management using metrics such as Greeks, VaR, Duration and Convexity.
- Comprehensive knowledge of Anti Money Laundering (AML), Bank Secrecy Act (BSA), Comprehensive Capital Analysis and Review (CCAR), AML - KYC, BASEL II and III, and Dodd-Frank Act.
- Broad Financial product expertise, with specialty in Fixed Income, Interest Rates/Credit Derivatives, Foreign Exchange, Equity Derivatives, and IHC/CCAR Regulatory programs.
- Strong experience in CCAR Regulatory Reporting especially in FRY 9C, FRY 14M/Q/A, FFIEC 041, FFIEC 031 reports and the related schedules.
- Vast experience in working in the domains various financial securities such as Equities, Fixed Income (Corporate Bonds, Treasury Bonds / Notes / Bills, Munis), Structured Products (ABS, MBS, CDO, CMO), Derivatives (Options, Futures, Forwards, Swaps, Interest Rate Derivatives) and Credit Derivatives (CDS, TRS, Strips)
- Comprehensive experience of working in the domains of Bankruptcy, Foreclosure, In House Loan Modifications, Look-Back, Letters of credit/trade finance, Government Modification, Loss Mitigation, Foreclosure Fees, Respa and Internal Audit. Anti-Money Laundering, KYC, BSA, CCAR/Volcker Rule and Economic Sanctions, Money Tracing, Financial Reconciliation, SOX/FFIEC and Dodd Frank.
- Expertise with Regulatory Reporting - Dodd Frank, Comprehensive Capital Analysis & Review (CCAR), Intermediate Holding Companies/ Bank Holding Companies (IHC/BHC), FRTB, Basel III, Trading and Risk Management Systems Implementations (Calypso/Murex).
- Wide experience of performing tasks associated with Software/System Development Life Cycle- creating and developing project plans, feasibility and scope management, communication and bridging gaps between users, technical team, and QA team.
- Vast experience in performing SDLC tasks - Requirement gathering, Analysis and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low Level Design documents etc.
- Experienced in working with Testing team, participated in writing Test Plan, Test Cases, Test Scenarios, RTM, Test Reports, and conducting various forms of testing, which include Integration Testing, Smoke Testing, Regression Testing.
- Experience with creating of UML diagrams such as Activity, Use Case, Flowcharts, using rational products and MS Visio.
- Adept in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy (BCP), creating Dynamic packages for Incremental Loads and Data Cleansing in Data Ware House.
- Extensive understanding of Software Development Life Cycle (SDLC) including Waterfall, Agile Scrum and Rational Unified Process (RUP).
- Valuable experience in assisting database designers by defining and analyzing the data requirements to construct Entity-Relationship (ER) Diagram (conceptual, logical, and physical schema) to build RDBMS.
- Extensive experience in Implementing UML methodologies to design Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, and Sequence Diagrams.
- Expertise in Developing econometric stress testing (CCAR/DFAST) models to assess market and credit risk associated with adverse economic conditions under guidelines from the Federal Reserve Bank and other regulatory agencies.
- Extensive experience in m anaging Sarbanes-Oxley (SOX) administration efforts, including assessment and continuously improvement of all IT General Controls (GC) and application controls;
- Experienced in conducting GAP Analysis, User Acceptance Testing (UAT), Operational Readiness Testing (ORT), SWOT analysis, Cost benefit analysis and ROI analysis.
- Well versed in creating Requirement Traceability Matrix (RTM) to link Business Requirements, Functional Specifications, and Test Cases to ensure end-to-end traceability throughout project lifecycle.
- 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.
ADDITIONAL SKILLS:
Domain expertise: -CCAR, FRY 9C, FRY 14C, FRY Forms BASEL I, II and III, Equities, Risk management, Stress testing, Regulatory compliance, EMIR, FX, Asset management, Derivatives, Bonds, Hedge fund, Credit risk, Market risk, Tax compliance, SOX, FAT, ETL, Data warehouse.
Methodologies: - Agile, Waterfall, Scrum, RUP, UML
Database tools: - SQL*Plus, SQL*Loader, MySQL, Toad
Business tools: - MS Visio, MS Project, MS Access, MS Office Suite, Business Object, MicroStrategy.
Databases: - IBM DB2 9, MS SQL Server, Oracle 10g/11g
PROFESSIONAL EXPERIENCE:
Confidential
Birmingham,AL
Business Analyst
Responsibilities
- Extensively worked on reconcilements and controls to ensure completeness and accuracy of information and compliance with CCAR requirements.
- Performed due diligence in rolling out next generation’s products and managed Risk & Controls, Compliance & Information Security policies such as OCC, PCI, FISMA, SOX, CobiT compliance, SAS70/SSAE16, SOC1, Vulnerability Assessment, Disaster Recovery, Third Party Information Security Assessment (TPISA) and Escrow Agreements.
- 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.
- Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
- Planned and tested external and internal audits, and ensure SOX compliance for banking and financial services providers, Perform testing around deposits, loans, investments, domestic and international wires.
- Responsible for the design, development and implementation of the valuation model for the funds distressed debt, OTC, FX, revolvers, RMBS and distressed loan holdings.
- Worked directly with the firm's clients in defining and documenting business and resource requirements and workflows in the fund accounting, P&L reporting and securities processing divisions of mutual funds, hedge funds and banks.
- Involved in the identification and measurement process of the reports, and supported the creation and management of CCAR capital planning and Dodd-Frank stress testing scenarios.
- Conducted Business Process Modeling to visually represent and analyze requirements by using different techniques like BPMN, UML diagrams, workflow diagrams, process flow charts, Activity diagrams, Swim-Lane Diagrams, Simulation model using MS visio.
- Facilitated JAD sessions and focus group sessions by bringing together business users, IT team, and QA team in a highly focused workshop to set the road map, design development strategies, and resolve conflicts.
- Designed and deployed various ETL packages to migrate the data coming from flat file, Excel, XML and SQL Server and to synchronize daily transaction data.
- Analyzed and prepared Input exhibits spreadsheets for the database by considering state wise product rules, compliances, and FAT.
- Analyzed big data, reconcile, compile, Forecast, Managed the submission of data for regulatory compliance filings (State and Federal - annual, quarterly, and monthly).
- Partnered with the business and IT stakeholders to gather, document, analyze and communicate BASEL 2 business requirements for OTC Derivatives and Secured Finance products.
- Coordinated control documentation requests for PwC, Internal Audit and Treasury Compliance, which assisted in understanding key Treasury processes and controls.
- Involved with the design for the strategic template for the CI system in features like Mutual Funds, Investment Portfolios including Equities and Fixed Income(Options, Futures, Bonds) Fees Distribution, Educational Services. SWOT Analysis, Product Features and strategic decisions.
- Created UML diagrams such as Use case diagrams, Activity diagrams, Swim-Lane Diagrams, Sequence diagrams, Class diagrams, Business workflow, and Data workflow diagrams to depict system functionality.
- Formed CCAR Dashboards by mapping MDRM keys validated each of the line items in FRY 14A Summary report (Standardized and Advanced).
- Involved in the creation of Requirements Traceability Matrix (RTM) to map and track business requirements, test cases and defects.
- Implemented business logic, data lineage mapping and traceability for Dodd Frank regulatory reports: Monthly and Quarterly FR Y-14 and Quarterly Call Reports (FFIEC031, FFIEC 041, FR Y-9LP & FR Y-9C).
- Monitored suspicious transactions and compiling and reporting associated currency transaction reports (CTRs) and monetary instrument logs (MILs) generated by Actimize AML.
- Conducted Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design (OOD) using Rational Rose according to the UML methodology.
- Involved in requirements and functional solution for building of Segregated Collateral System to comply with Dodd-Frank and EMIR requirements of holding pledged collaterals in a segregated accounts.
- Involved in implementing formula and data analysis for FRY 14A form from Data Dictionary
Confidential
New York, NY
Business Analyst
Responsibilities
- Designed, implemented and oversaw the project plan, strategy document, resource plan and estimation model for the remediation and development of fund accounting, operations, P&L reporting, and trade processing policies and procedures for a large mutual fund, multi asset class hedge fund, and off shore multinational bank.
- Assisted Treasury unit with the development of organization-wide reporting framework to comply with CCAR mandates.
- Presented the tenets of fundamental and technical analysis of equities, valuation of bonds, and corporate financing strategies.
- Coordinated data system testing by utilizing Toad for MySQL and Toad Oracle.
- Worked with the development team to define system specifications based on the business requirements gathered by Prototyping and JAD sessions.
- Performed AML analysis and work with the business line to complete the documentation requirements to create the Customer Due Diligence (CDD).
- Complied with Anti-Money Laundering (AML) and Anti-Terrorist Financing (ATF) laws and regulations. Observe Know-Your-Customer (KYC) principles and customer identification regulations.
- Coordinated with the PwC and Internal Audit on efficiencies which can be gained through defining the appropriate test procedures for SOX IT General Controls.
- Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
- Assisted the execution of CCAR stress testing framework including gathering requirements of multiple stress scenarios and defining data elements required by stress tests.
- Facilitated JAD sessions with the management, developers and analysts from all the dependent systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
- Designed services to provide data enrichment, aggregation, calculation and reporting related to CCAR, Basel II and other risk reports.
- Built out a data lineage model for source system data feeding into the CCAR templates.
- Provided Fixed Income data management analysis that focuses on data design, integration, data relationships, data quality and transformation.
- Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
- Implemented business rules via IBM ODM and BPM tool to manage rule and process flows.
- Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
- Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Created and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to their business requirements and the test case requirements to their functional requirements.
- Prepared FRDs that help drive the design of the infrastructure necessary for the organization to meet new CCAR reporting requirements.
- Assisted Quality Assurance team in developing the Test Plan, Test Strategy, Test Cases, and Test Scripts to perform Functional testing, Integration testing, System testing, Performance testing, GUI testing, Sanity testing, Regression testing, and extensively supported UAT in each sprint.
- Interacted extensively with customers and UI designers to determine ways to improve the UI feel and the user experiences. Documented the gathered business requirements into detailed Business Requirement Documents (BRDs) for Basel III and its Addendum.
- Responsible for the quarterly pricing and valuation process for the funds distressed debt, OTC, FX, revolvers, RMBS, and distressed loan holdings.
- Coordinated, managed and assisted in the preparation and completion of the year end audit for multiple multi-asset class domestic and off-shore Hedge Funds.
- Followed Rational Unified Process (RUP) methodology and its guidelines for project planning, analysis, design, development, resource allocation, testing, and implementation.
- Oversaw the external audit process and ensure it proceeds and is authorized as per the SOX requisites. Efficient at drafting reports and presenting complex data in simplified version.
- Developed internal models to validate third party stress testing methods related to regulatory compliance (CCAR).
- Created and maintained MS access database for various holdings and transactions. Add new functionality upon team request through VBA and SQL. Analyzed any database issues and resolve it.
- Involved in creating Business Flow Diagrams, Dataflow diagrams, UML Activity diagrams, Sequence diagrams, and USE cases diagrams using MS VISIO.
Confidential
Riverwoods, IL
Business Analyst
Responsibilities
- Analyzed and Documented Business Requirement Document (BRD), Functional Specification Documentation, and System Requirement Documentation, using UML methodologies.
- Created Use Cases after accessing the status, scope of the project and the business process.
- Developed and implemented test cases on the GUI interface to ensure that requirements were met.
- Wrote SQL Queries extensively against different databases, generated different reports and analyzed them as per request.
- Validated Loss Data for external CCAR reporting, also Conduct root cause analysis for Data Remediation.
- Updated and manage SharePoint Site for each CCAR cycle that is utilized for CCAR communication.
- Automated the FRY 8 Fed report by reverse engineering manual processes, UAT testing and deployment into production.
- Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
- Coordinated data set up in production for CCAR regulatory activities.
- Evaluated the internal control measures and procedures for SOX requirements and standards and report the non-complying areas.
- Assessed management's key risks & issues (i.e. systems migration, audit, SOX, operational issues, etc.).
- Developed pro forma financials, compliance documents, and other necessary analyses for banking center consolidation, closure, and expansion.
- Translated Business Requirements into functional and non-functional requirements using industry standard documentation processes like Data Flow Diagram (DFDs) and UML Diagrams (Use Case, Sequence and Activities Diagrams).
- Designed the project development plan based on Agile methodology of SDLC.
- Identified and assessed potential data source of Interest Rate, helped the market data team to integrate data using ETL tools.
- Interacted with fixed income business heads to finalize the Business Requirements for the Risk Management process.
- Performed Gap analysis and built future state CCAR process operating model.
