SUMMARY

• Sr. Business Analyst with over 7+ years of IT experience in Banking and Financial domain.
• Expertise experience working on the CCAR, Dodd Frank and other financial regulations and experience in customizing financial services applications.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Expertise in interaction with the business users to gather requirements based on the CCAR Regulation for Financial Statements, Interest Rate, Credit Ratings, FRY9C and Investment Securities.
• 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
• Extensive experience in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR and knowledge of standard SDLC methodologies, including RUP, MSF, Prototype and Spiral.
• Experience of SQL Query Performance Tuning using SQL Sentry Performance Monitoring Tool, Analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Strong background in CCAR Regulatory Reporting especially in FRY 9C, FRY 14M/Q/A, FFIEC 041, FFIEC 031 reports and the related schedules.
• Experience with Basel III Rules & Reporting, Risk Management, Internal Audit within Retail Operation, BSA/AML Compliance and SOX Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing of software both before and after completion; conducting and documenting UAT.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture, Professional Global Resources, LLC., CBS, VAS & STA
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modelling Language (UML), Object Modelling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).

TECHNICAL SKILLS

Domain expertise: CCAR, FR Y 9C, FR Y 14C, FR Y 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, AML, LCR, CDD, SAM, SAR, CTR, SOX, FAT, ETL, SOA, GAAP, Dodd-Frank, JAVA, Selenium, Manual Testing, QTP

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, Atlanta, GA

Sr. Business/Data Analyst

Responsibilities:

• Involved in analysis of various types of risks (Credit Risk, Market Risk) which impact the portfolio management.
• Worked on documentation of project vision and scope, cost-benefit analysis, management of project budget and making project schedule with the Project Manager.
• Conducted and guided JAD and Brainstorming Sessions to gather Business Requirements from Market Risk Group, Risk Reporting Team and other SMEs.
• Involved in developing good practices for risk modelling procedures related to CCAR/DFAST.
• Analysis and design of CCAR (FRY 14A schedules of Income statement and balance sheet), FRY 9C (few schedules), report requirements in AXIOM.
• Business Analysis and Functional Specification areas to plan and execute various consent order projects, ensuring adherence to regulatory requirements (AML, KYC, Dodd-Frank, etc.).
• 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.
• Responsible for the development and maintenance of the SAS code and related processes for the CCAR schedule template data generation and reporting.
• Lead on the data sourcing effort for Retail Schedules pertaining to CCAR and the FRY 14Q reporting to FED.
• Involved in preparing 5G reports and internal CLAR MI (Comprehensive Liquidity Analysis and Review) to monitor the liquidity risk that the bank has.
• Involved in creating and modifying Data model using SAP Power Designer 16.0 and ER Studio.
• Worked extensively in building and validating stress-testing, PPNR and credit risk models.
• Modeled the detailed design of the system using UML diagrams including Sequence Diagrams, Activity Diagrams and Use Case, and Data Flow diagrams using Smart Draw.
• Created SQL queries using advanced analytical functions to drill, analyze, and reconcile data against business rules and requirements.
• Managed bugs using Defect Tracking Tool JIRA, reviewed each defect and assigned development team to resolve problems.
• Utilized Star Schema and SAP Power Designer for data modeling and Involved in Developing SQL scripts for Oracle databases using SAP Power Designer.

Confidential - Manhattan, NY

Business Data Analyst

Responsibilities:

• Work with Regulatory Reporting, QA, and data sourcing team in planning, executing, controlling and closing phases of projects and in CCAR reporting automation (FR-Y 9, FR-Y 14Q, PPNR etc.)
• Presented the tenets of fundamental and technical analysis of equities, valuation of bonds, and corporate financing strategies.
• Logged and tracked requests from Internal Audit and worked with business areas to fulfil those requests.
• Performed comprehensive UAT for both Portfolio Authorization Checklist GUI and Backtesting GUI and documented the testing results which need to be submitted to Internal Audit and external regulator.
• Develop BRD and data mapping logic to 14Q line items and Pre-provision Net Revenue (PPNR) configuration in Axiom, validating the data mapping using SQL developer.
• Identify and analyze business problems and defined the scope of activities required to address issues, including requirement definition, logics changes, process review, impact assessment and operational streamlining where necessary
• Partnered with the business and IT stakeholders to gather, document, analyze and communicate BASEL II business requirements for OTC Derivatives and Secured Finance products.
• Performed AML analysis and work with the business line to complete the documentation requirements to create the Customer Due Diligence (CDD).
• Focused in Comprehensive Capital Analysis and Review (CCAR) Reporting, Governance, Risk & Compliance (GRC) and Dodd-Frank Regulatory Reporting, including FRY 9C, FRY 14M/Q/A.

Confidential - Atlanta, GA

CCAR Business Analyst

Responsibilities:

• Interacted with different line of business (Credit Card services, Merchant Services, Mortgage Banking, RFS, Student Loans, Auto Finance, Business Banking, CTO etc.) within the bank to acknowledge the current business flow.
• Updated and managed SharePoint Site for each CCAR cycle that is utilized for CCAR communication.
• Wrote SQL Queries extensively against different databases, generated different reports and analyzed them as per request.
• Assisted in implementation of the Federal Regulation Liquidity Coverage Ratio (LCR) for all Commercial and Retail Lending Products. This required analysis of each section of the LCR regulation to determine proper run-off rates for each loan product.
• Developed internal models to validate third party stress testing methods related to regulatory compliance (CCAR).
• Gathered business requirements through interviews, phone calls and surveys from department managers. Led Joint Application Development (JAD) sessions to resolve urgent issues relating to requirements.
• Delivered Business Requirement Documents (BRD) deliverables high-level manager requested.
• Utilized UML to create a multitude of diagrams including Use Cases Diagram, Activity Diagram and Sequence Diagram.

Confidential - Albany, NY

Business Analyst

Responsibilities:

• Evaluated the work effort to complete requirements and UAT testing to provide project estimates, project plans, business impact analysis and project charters.
• Performed GAP analysis to identify the gap between the optimized allocation and integration of the inputs, and the current level of allocation.
• Conducted JAD sessions with management, SME, vendors and other stakeholders for open, pending and critical issues.
• Worked in association with RUP mentors to ensure fidelity to the standard RUP practices of the institution.
• Involved in testing the Web Applications and Client Server Applications developed using Java.
• Developed Methodology by creating business justification documents, business requirements document, development specs, test plans and procedure documents.
• Followed up on status of documents including required validations and review by Audit department.
• Consulted with internal clients on design and development best practices while keeping the focus on risk areas regarding information security and privacy.
• Assisted in creating scheduled batch jobs using PL/SQL for downloading data into temporary tables to generate the data required for some of the reports