We provide IT Staff Augmentation Services!

Business Analyst Resume

New York, NY

SUMMARY:

  • 8 years ofBusinessAnalystworking in Federal Regulations, Finance and Accounting domain for web applications and data warehouses.
  • Domain experience includes knowledge ofCCAR, FRY9C, Equity, Bonds, Loans, Money markets, Benchmark Index, General Ledger, Credit Bills, Credit Reports, and Accounts Receivable/Payable.
  • Strong knowledge of the Software Development Life Cycle (SDLC), Agile and Waterfall Methodology
  • Expertise in Data Analysis, Data Validation and conducting Gap Analysis for Data Warehousing projects Expertise in Change Control Management and managing requirement traceability and work in collaboration withBusinessusers, developers/admins/architects and QA team.
  • Extensive knowledge of QA methodology, issue prioritization, bug tracking and reporting testing status process.
  • Extensive experience in building and executing Test Plans, Test Scenarios, Test Cases according toBusiness, Functional and User Requirement Specifications and Writing Test Scripts and Reports.

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential

Responsibilities:

  • Support the facilitation, oversight and control of theCCAR, DFAST and Stress Testing program across.
  • Responsible for QA, UAT and production planning, testing and execution for Mid Year/ Year end CCARreporting.
  • Coordinate for Qualitative analysis and developCCARdeliverables.
  • Coordinate with PMO's, senior management and various stakeholders across the organization for finalizing the scope and schedule, resolution of issues, implementing the test strategy across various lines ofbusiness.
  • Prepare and reviewed traceability matrix, test plan, test cases and relevant testing documentation, and seeking approvals/signoff's across the board.
  • Coordinate for creating Line of Business's Quantitative projections over 9 - quarter horizon.
  • Monitored and followed up on operational risk events, deficiencies and incidents.
  • Maintained input data quality of risk management systems.
  • Gather and manageBusiness/ Stakeholder/ functional requirements through the complete SDLC, using iterative project methodology and JAD sessions.
  • Document the agreed upon requirements asBusinessrequirements and functional requirements for the to-be system.
  • Analyze and document the existing systems' architecture to facilitate an accurate assessment of dependencies between different applications, databases, and impacted functionalities.
  • Created User interface mock-ups, Process flows,Businessflows using Visio, Blueprint and Wireframes.
  • Worked on creating use cases,businessrules for advance system usability.
  • Worked under Regulatory Line ofBusiness(RLOB) and Basel lll regulations.

Environment: Risk Management,CCAR, DFAST,BusinessObject, Micro Strategy, RLOB, MCA, MS Word, MS Excel, MS Visio, BPMN, SharePoint, HP Quality Center, AGILE methodology.

BusinessAnalyst(CCAR)

Confidential - New York, NY

Responsibilities:

  • Involved in the FRY9C andCCARQ/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.
  • CreatedBusinessRule requirements using JRules for Income Statement and Balance Sheet and also created mock - up reports in Cognos for the IT team.
  • Analyzed and created requirement for the Sign Convention for different systems to understand how the signs for different Account Class change when flowing from one system to other; and how the data should be reported to the Regulators via Axiom.
  • Working with the Data Sourcing team to identify the data gap attributes and the procedures/steps required to map the data to an existing EUDA or creating a new EUDA around it.
  • Created a PowerPoint presentation from an Infrastructure prospective to understand all the requirements needed to deliver an accurate Average Daily Balance Sheet for the FRY9C/CCAR requirements.
  • Analysed and documented the current and the future state of reports related to Credit Risk and different types of securities.
  • Documentation of the processes for all Manual Data feeds and in future to create a Strategic process around the manually sourced data.
  • Worked with theBusinessand the E&Y Team to analyze and document the PPNR Historical Data and FRY9C filing to the Federals.
  • Currently working on analyzing and documenting the Nine Quarter Projections for theCCARfiling.

Environment: MS Strategy, MS Access, ETL, Cognos, Axiom, Basel III

BusinessAnalyst

Confidential - Chicago, IL

Responsibilities:

  • Was involved in analysis of requirements for collection and reporting of data elements that is required as part of monthly quarterly submissions to Federal Reserve Board.
  • Created process flows to capture requirements for loan population module and its interactions with other modules.
  • Createdbusinessrules for selection of loan records from source system to the target reporting system.
  • Created process flows for Origination Data Store and its interactions with retail and wholesale modules.
  • Created a framework for internal stress test which involved various lines ofbusinessand different support groups across the bank.
  • Was involved in creating a process flow to depict the interactions betweenCCARannual stress test process and various existing process used by the bank such as ICAAP, Model Risk.
  • Conducted interviews with the Source Team andBusinessCustomers for gatheringBusiness Requirements, System Requirements and Functional Requirements.
  • Finalizing DBRs for Retail, Wholesale Mortgage portfolio attribute for Fed Auditing purposes.
  • Created and reviewed DBRs, FSD, Project Schedules, and Test schedules.
  • Directly interacting with the Stakeholders/BusinessManagers and served as a primary point of contact for Data Warehousing and Data Stage reporting solutions depending on project requirements.
  • Performed extensive requirement analysis including Data analysis and GAP analysis.
  • Recommended how to close the data gaps can be from reconciliation on recommendations.
  • Worked on the approval process and sign-off from stakeholders on recommendations.
  • Coordinated with the developers, SME's, testers and the mappers for customer's account database information.
  • Was a single point of contact for the downstream use rest to give current updates on wholesale and retail feeds.
  • CreatedBusinessProcess Models using RUP to document currentbusinessprocess.
  • Conducted and Coordinated Joint Application Development (JAD) sessions with different Teams.
  • Communicated changes in the requirements and in turn changes in the schedules, if any, to the Client Team and Client Services Team.
  • Major role in the planning, testing, and implementation of system improvements and conversions.
  • Also performed risk evaluation, design review, reports, and make sure that end product meet work plan.
  • Acted as a liaison between Management, End Users and Application Team (Developers /QA Team).

BusinessAnalyst

Confidential - Boston, MA

Responsibilities:

  • Worked on restructuring advisory, distressed M&A, crisis and turnaround management assignments.
  • Participated in the development and execution of restructuring alternatives/recommendations.
  • Supported project management efforts of liquidations, wind - downs and asset divestiture programs.
  • Conducted FP&A analysis as part of interim CFO/CRO assignments; budget/variance analysis, cash/working capital management.
  • Assist with external audits from KPMG and Federal Reserve, and regulatory inquiries fromCCAR
  • Built and maintained consolidated financial statement models, valuation analyses and 13-week cash flow forecasts.
  • Extensively used SQL queries to create views and stored procedures to cater ad-hoc reporting needs actively participated in the ETL design reviews and ensured the proposed design met the requirements.
  • Updated Procedural Documents for theBusinessRisk Management Department.
  • Excellent knowledge of SQL/SAS capabilities for analytics and reporting.
  • Have a good understanding of SQL RDBMS, ability to read and understand data flow diagrams and ERD.
  • Developed solutions to streamline the group'sCCARreporting process.
  • CompletedBusinessRequirement Documentation along with High Level Design specifications.
  • Reviewedbusinessplans, turnaround strategies, operating models and forecasts for reasonableness.
  • Collect and analyzebusinessrequirements and create quality user stories in logical order
  • Have a good exposure as entrepreneurial and have the desire to succeed.
  • Developingbusinessflow/requirements specifications frombusinessneeds & defining detailed functional/process design according to operational and technical vision.
  • Interacting with thebusinessusers to gather requirements based on theCCARRegulation for Financial Statements, Interest Rate, Credit Ratings, FRY9C and Investment Securities.
  • Assisted in the development of management presentations, pitches and related materials; coordinated road shows.
  • Worked on the origination and execution of direct equity private placements, PIPEs and registered direct offerings.
  • Vettedbusinessmodels, restructuring plans and management to develop an operational perspective on thebusiness.
  • Applied Agile Methodologies for the project and used practices such as Program Backlogs, Iteration Backlogs and Daily Stand-up Meetings.
  • Communicated risks and issues to both; technical andbusinessusers, seek sign offs on the most appropriate solutions in light of suggestions from IT.
  • Compilation, quality assurance and delivery ofCCARsubmission documentation.
  • Scrum Master responsible for Product Backlog, User Stories, Sprint Plan, Agile Sprint, and maintained many story stubs to improve planning and highlight dependencies. Also, used agile tool Rally for tracking.
  • Analyze the feasibility ofBusinessCase, produced User Stories, budgeting and time estimation schedules in MS Project, and associated Risks and Mitigation action plans.