Sr. Ccar Business Analyst, Cleveland, Ohio
PROFESSIONAL SUMMARY:
- 7 years of experience in IT as Business Process Modeling, Mapping, Requirement management using Waterfall and Agile.
- Experienced in Consumer & Commercial Banking, Regulatory Reporting, Risk Management, Leasing & Lending, Account Receivables( Confidential /R) & Payables ( Confidential /P), Journal Entries, Trade Finance, Supply Chain Finance(SCF), Cash Management, Payments (Domestic & International), Compliance Framework, BCBS 239 Principles, SOX Compliance (302 & 404) Internal Controls, RCSA Testing, Corporate Stress Testing (CST), Dodd - Frank EPS (US- IHCs), CCAR, DFAST, BSA/Anti Money Laundering(AML) and Know your Customer (KYC).
- Led teams for Systems testing and User Acceptance Testing (UAT) as subject matter expert and automated testing tool coach in Confidential validated environment.
- Expert at analyzing, designing, and re-engineering systems applications and business processes. Highly experienced in integrating systems acquired through mergers and acquisitions.
- Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into business and functional requirements. Adept at preparing business requirements documents (BRD) & Functional requirement documents (FRD).
- Proficient in developing Use case diagrams and Behavior diagrams using Rational Rose and MS Visio.
- Well versed with IBM Rational Software integrated tools for requirements management and analysis use case development, business modeling, and data modeling.
- Experience in managing change management of requirements throughout the Software Development Life Cycle (SDLC).
- Adept in developing and writing test plans, test cases & scripts using manual and automated testing tools such as Rational Suite and Mercury Interactive to perform User Acceptance Testing (UAT).
- Experience in HL7 ADT (Admission, Discharge and Transfer) and DFT (Detailed Financial Transaction) messages.
- Broad experience in conducting Regulatory/Operational Risk Analysis, Cost/ Benefit Analysis, ROI Analysis,
- SWOT Analysis, Gap Analysis, and User Acceptance Testing (UAT) including Behavior-driven development (BDD) and test-driven development (TDD)
- Experienced in all phases of the Project Development Life Cycle: Initiation, Discovery and Concept Validation, Business Analysis, Budgeting, Planning, UX/UI Design, Mock-ups and Wireframes, MVP (Minimum Viable Product) & System Development, Integration and Testing, Delivery, and Operating Model & Maintenance.
- Strong knowledge of Project Management techniques, such as Budget & Time Estimation, Project Planning, Critical Path development, Roles and Responsibilities Charter, Policies and Processes Governance, Scope Management, Resource Planning & Management and Risk Identification & Analysis
- Experienced with several project management tools such as MS Visio, MS project, BaseCamp, Trello, JIRA
- Expert in facilitating all levels of management, developers, QAs, stakeholders, business users and offsite teams in JADs, Brainstorm sessions, conferences and WebEx
TECHNICAL SKILLS
Testing, Aml, Documentation, CCAR, Excel, BI, Coda, Cognos, Ibm, Stress Testing, Cognos, Data Management, DI, MS Visio, Word, PowerPoint, UAT. Unified Modeling Language (UML), Jira, Power designer, Fr Y-9c & Y-11, Gap Analysis Aml / Kyc, PCI (Payment Card Industry), Dodd-frank, Bcbs 239, Sda, Icma, BRD, FRD, SQL, ETL, Data Migration, Sprint, Smoke Testing, Forecasting, UAC, Rational Unified Process (RUP), Waterfall, Agile, SDLC, SharePoint Documentation, Repository System
WORK EXPERIENCE
Sr. CCAR Business Analyst
Confidential - Cleveland, Ohio
Responsibilities:
- Implemented business logic, data lineage mapping and traceability for Dodd Frank regulatory reports: Monthly and Quarterly FR Y 14 and Quarterly Call Reports (FFIEC 031, FFIEC 041, FR Y-9LP & FR Y-9C) for Federal filing 2015 & 2016.
- Created custom monthly report whole sales and retail banking (First lean mortgage, Home equity loans, Auto loans, Small business loans and other consumer loans) for different loan services used by the bank.
- Worked with other line of business on initiative of identifying, researching, and rectifying gaps and discrepancies in regulatory reporting application Axiom.
- Accounted in leading Business Acceptance Testing (BAT) team and finance team in implementing of logic deployed to populate regulatory reporting schedules
- Created Test Data according to Axiom Mapping Logic and Filtration Logics of the FFIEC 031, FFIEC 041, FR Y 14M/Q as per the required Schedules (Schedule Confidential, A2, A7 A9)
- Performed Enrichment according to the appropriate Project, Branch and Workflows for the FFIEC 031, FFIEC 041, FR Y 14M/Q Reports.
- Worked as part of the AXIOM team on the business rules and the change requests when there were changes from Dodd Frank.
- Coordinated the Results with the Superiors and logged Defects where necessary with the Defects Team.
- Solely involved in Managing the Project for TD EMV Technology Team and provided updates to my VP and coordinated with various external vendors/partners: TARGET, ARGUS Inc and TSYS on daily basis.
- Prepared Daily Status Report in QC with Graphs for Senior Management for Decision Making.
- Responsible in adding new Project Releases in QC/HP ALM.
- Responsible for the entire team Defect Management in QC/HP ALM.
- Acted as the Point of contact of TD Bank Technology to Outside Partners: TSYS Team, 3rd party vendor - Argus and Internal Departments - TD BLDM, EBX.
- Resolved issues and problems faced by the Development team in receiving the transmitted Test Files from Upstream partners.
- Coordinated the UAT Testing efforts/updates between the Testing Team and the Business Team.
- Worked independently in Files Transmission process between upstream and downstream partners. (Target, TD EBX, TSYS and Argus)
- Coordinated the testing needs to the Client, on types of Test File needed, format issues and frequency if it's Confidential Daily or Monthly Test File.
CCAR Business Analyst
Confidential
Responsibilities:
- Created documentation (Functional Specifications) for the Development team to code functionality into customer support applications.
- Coordinated with Finance & Regulatory Report Automation Project (Dodd Frank and Call Reporting Process) designed to enhance production efficiencies while decreasing operational risk by using automated reporting application AXIOM SL.
- Created additional documentation to communicate planned system functionality and implementation processes to the business and development teams consists of the following: Use Cases & Process Flows.
- Conducted impact assessments to understand business and application implications to requests being considered.
- Conducted impact assessments to understand business and application implications to requests being considered.
- Analyzed different source systems ( AML), Loan IQ, ACBS, Credit Cards - Target, Maestro, Shaw) and identified the reporting data elements required to report to Dodd Frank and Call Reports.
- Conducted requirement gathering sessions with Risk, Treasury, Finance and Enterprise Data Management groups.
- Conducted requirement gathering sessions to understand source data for consumer, commercial and small business credit cards and how they map to the CCAR credit card monthly (M) schedule.
- Performed source to target data mapping from multiple sources (APPRO - Loan Origination system, FDR and TSYS - loan servicing system) to CCAR credit card schedule. Includes CCAR mapping documents, metadata, reference tables etc.
- Reviewed the requirements with development, test teams. Closely worked with lines of business and SME's to obtain requirement sign-off.
- Gathered requirements for Tactical data acquisition (TDA) for schedule data elements which cannot be automated. Authored and executed sql scripts to obtain the TDA (tactical data acquisition) data elements and handed off to Operations team for upload to CCAR credit card schedule.
- Supported the business and SME's during UAT phase.
- Liaised with cross-functional teams (business groups, IT and PMO organizations) to drive data remediation efforts.
- Experienced in Requirements gathering(BRDs), Business Analysis, Feasibility Study, Proof of Concepts(POCs), AS-IS / TO-BE Study, Gap Analysis, Functional Specifications, Data Analysis, Impact Analysis, Root Cause Analysis, Entry & Exit Criteria, Use Cases, Flow Diagrams, Requirement Traceability Matrix(RTM).
- Designed and Implemented Scorecards / KPIs / Metrics to assess quality of data, increase DWH usage, decline in DWH issues, increase user productivity, decrease costs, accessibility of products and geographical coverage
- Experienced with Project Management, SOWs, Project Proposals, Project Plans, Work Breakdown Structure (WBS), Project Metrics & Milestones, Budget Plans, Effort Estimations, Risk Identification and Mitigation Plans
- Participated in planning and strategic initiative activities and led projects that remediate and issues through Strategy Execution and Plan-Do-Check-Act (PDCA) / Plan-Do-Study -Act (PDSA) processes.
CCAR Business Analyst
Confidential - Richmond, VA
Responsibilities:
- Worked closely with stakeholders, software architects and UI designers to define the software product functionality.
- Documented detailed use cases that translated high-level requirements into system/functional specifications.
- Produced detailed description of user stories, business rules, steps, and data elements required to develop new or modify existing products.
- Ran the Report in Axiom Controller View Tool to view the Output of the FFIEC 031, FFIEC 041, FRY 14M/Q forms.
- Documented system functionality through abstract UML artifacts (e.g. domain/object models, use case diagrams, state charts, etc.)
- Communicated the capabilities of the product suite to development engineers, test analysts, technical writers, trainers and other staffs.
- Conducted the full life cycle testing including system, regression, integration and post implementation testing.
- Created Blank Instances from Source Maintenance - Axiom Controller View for the FFIEC 031, FFIEC 041, FR Y 14M/Q Reports.
- Identify functionality gap which needs to be developed and help the product owner to understand the functionality which needs to be modified based on the future need.
- Be the first point of entry in regards to defining detail requirements from an Epic through Jira
- Influence current needs and future functional needs based on previous exposure and by best industry practices and help enhance the product offerings.
- Analyzing any system/ functional issue and providing root cause behind the issue and the underlying Business Logic between all the interacting systems.
- Facilitate screen mockups through UX designer, lucid chart help understand user flow and make sure UX design and development are in sync with changing functional needs in an agile environment.
- Validate and approve sprint demo's and raise questions or change request if the deliverable does not meet requirements.
- Document high level to detailed level system needs in confluence and hold the development team accountable to those needs.
- Resolved ambiguous and incomplete requirements issues, kept an eye on the long-term goals of project completion and searched out key contributors to clarify confusion and work for understanding consensus to complete requirements issues.
- Effectively translated high-level business requirements into detailed functional Specifications and made changes to the specifications accordingly.
- Used Share point to share information, schedule meetings, and organize files, create/modify/delete use cases and to coordinate with stakeholders.
- Drafted test cases and coordinated testing progress using Mercury Quality Center.
- Involved in creating and updating functional specifications to document existing functionality of the application.
Business/Reporting Analyst
Confidential - MAResponsibilities:
- Conducted requirement gathering sessions with the Credit and Risk teams within securities finance to understand Basel I and Basel II requirements.
- Interpreted, evaluated, translated, analyzed and interrelated researched data, and developed integrated business analysis.
- Engaged with stakeholders to design and construct new reports and analysis using the OBIEE.
- Summarized all the research gathered and defining the scope of the solution, including what is not in scope.
- Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
- Worked as Confidential business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
- Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
- Work with the project manager and development team to create real cost estimates.
- Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML.
- 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.
- Proposed and executed enhancements in OBIEE for reporting on stakeholder feedback and industry best practices.
- Responsible for monitoring the progress of the development and QA team by prepared status report, charting out schedules, allocation and management of technical and human resources using MS Excel and Project
- Established Confidential business Analysis methodology around the RUP (Rational Unified Process).
- Managed and coordinated one or more large requirements research efforts; performed specified data analysis and studied as requested, and developed and presented reports in support of various initiatives.
- Strong Knowledge of SDLC, RUP methodology, and Project life cycles.
- Helped the Business Users while performing the UAT testing and helping them resolve the defects in the environment.
- Coordinated and supported the development and implementation of special research initiatives related to specific research goals.
- Conducted User Acceptance Testing.
- Gathered requirements from key stakeholders and documented business requirement and functional requirement documents.
