We provide IT Staff Augmentation Services!

Business Analyst Resume

Jersey City, NJ

SUMMARY

  • Over 6 years of experience as Senior Business System Analyst in teh financial industry supporting clients to implement business functionality accurately and efficiently.
  • Work experience in Risk Control, DFAST (Dodd Frank),CCAR and other regulatory reporting process.
  • Have intimate knowledge of teh line of business data to ensure Instruction changes have minimal impact to CCAR Schedule
  • Domain experience includes knowledge of CCAR, FRY9C, Basel III
  • Identify and procure potential business opportunities around CCAR by developing client relationships in teh regional / t international market while focusing on delivering state of teh art solutions.
  • Plan, develop, manage and execute CCAR/DFAST Audits covering, FRB MRIAs, strategic CCARimplementation, Model Risk Management, 14A / 14Q filing as well as Wholesale Advanced IRB, Retail Advanced IRB, Traded Products, Risk Weighted Assets (RWA), for compliance with teh U.S. Basel II.
  • Full SDLC experience including Requirements, Analysis/Design, Development and Testing for Waterfall and Agile methodologies
  • Experience in Financial Markets domain - Investment Banking, Capital markets, Wealth management, Brokerage, Trading Systems and Client Reporting.
  • Work experience in Risk Control, DFAST (Dodd Frank), CCAR and other regulatory reporting process
  • Expertise in requirements gathering through JAD sessions, user interviews, workshops, and repository research with Business Owners, Business Users, SMEs and specific stakeholders
  • Excellent knowledge in teh analysis, design of system applications and business processes applying Unified Modeling Language (UML)
  • Experience in process modeling using Use Cases, Sequence Diagrams/Process Flow Diagram, Collaboration diagrams, swim lane flow charts, Activity & Class Diagrams
  • Highly experienced in creating teh requirements artifacts, Business Requirement Document (BRD), System Requirements Specification (SRS), Use-cases, Functional Requirements Document (FRD), Technical Requirements Document (TRD) and Change Requests Planning (CRP).
  • Hands on experience in creating Agile process artifacts user stories, burn down charts, Story boarding etc.
  • Through understanding of Data warehousing concepts including OLTP, OLAP, Data Marts and reporting.
  • Worked on Master Data Management (MDM) and reference Data mapping for business process involving data migration, conversion, and mergers.
  • Used business process tools such as MS Project, MS Excel, MS Access, MS Visio, ERWIN, DB2,Rational Clear Quest, JIRA,SQL Reporting for project work
  • Experience in reviewing Test Procedures and creating Test Cases, Test Scripts and Test plans.
  • Familiarity with White box and Black box testing including functional testing, unit testing, integration testing (UAT), smoke testing, system testing (SIT), and Workflow Testing and regression testing.
  • Adept in multi-tasking and handling multiple tasks/projects at teh same time.

TECHNICAL SKILLS

BA/QA Tools: Quality Center, MS Word, MS Access, MS Excel, MS Project, MS PowerPoint.

Database: Oracle 8i/ 9i/11g, MS SQL Server 2003, Basic SQL Server

Database Tools: Toad, PL SQL, PL SQL DBX, Access with ODBC

BI Tools: Cognos, SAP BI

ETL Tools: Informatica

SDLC Methodology: Waterfall, RUP, Agile

Documentations: User Specifications, Functional Specification, File Specification, Process Flow, Data Flow Diagram, Feed specification, Requirement Traceability Matrix, Data Mapping Matrix, Test cases, Painpoints, Initial Load, Data Attributes, Data Dictionary, Control Report, Manual Upload etc.

PROFESSIONAL EXPERIENCE

Confidential -Jersey City, NJ

Business Analyst

Responsibilites

  • Helped prepare for CCAR reporting schedules (ex. FRY 14A/Q/M & 9C).
  • Met with financial analysis team and financial reporting team to gather their requirements on data.
  • Participated in data modeling, data analysis and requirement documentation.
  • Helped with teh remediation and mapping (aka. "Data Lineage") of data going into projection systems.
  • Developed and documented Use Cases from teh business and systems requirements.
  • Developed detailed level process maps to facilitate requirements gathering for projects and trainings.
  • Conducted data verification on projection data warehouse.
  • Defined, documented and translated high level business requirements into detail system specifications.
  • Identified and analyzed business problems and defined teh scope of activities required to address issues, including requirement definition, process review, impact assessment and operational streamlining where necessary.
  • Prepared FRDs that help drive teh design of teh infrastructure necessary for teh organization to meet new CCAR reporting requirements.
  • Helped with teh remediation and mapping (aka. "Data Lineage") of data going into reporting systems.
  • Conducted data verification on reporting data warehouse.
  • Participated in configuration of IHC Reporting System and other in - house reporting software /systems
  • Supported teh Project manager in planning, executing, controlling and closing phases of projects
  • Worked with teh development team to define system specifications based on teh business requirements gathered by Prototyping and JAD sessions.
  • Helped prepare for CCAR reporting schedules (ex. FRY 14A/Q/M & 9C).
  • Met with financial analysis team and financial reporting team to gather their requirements on data.
  • Participated in data modeling, data analysis and requirement documentation.
  • Helped with teh remediation and mapping (aka. "Data Lineage") of data going into projection systems.
  • Developed and documented Use Cases from teh business and systems requirements.
  • Developed detailed level process maps to facilitate requirements gathering for projects and trainings.
  • Conducted data verification on projection data warehouse.
  • Defined, documented and translated high level business requirements into detail system specifications.
  • Identified and analyzed business problems and defined teh scope of activities required to address issues, including requirement definition, process review, impact assessment and operational streamlining where necessary.
  • Prepared FRDs that help drive teh design of teh infrastructure necessary for teh organization to meet new CCAR reporting requirements.
  • Helped with teh remediation and mapping (aka. "Data Lineage") of data going into reporting systems.
Confidential -New York, NY

Business Analyst

Responsibilities:

  • Analyzed and created Business Requirements and Functional Requirements for 14Q/A Actuals for various schedules.
  • Assisted teh 14A Projection team in teh analysis for PPNR schedules - PPNR Submission, NII, and Metrics.
  • Interacted with different businesses in Confidential to identify teh source of teh data in order to satisfy teh requirements of PPNR schedules for FRY14Q and FRY14A.
  • Identified and established processes for monitoring of teh data qualities. Ensured teh correctness and prevented invalid data values.
  • Assisted in creating data repositories for compliance with data governance policies and standards.
  • Created documents, mapping tables and issue list for all processes - manual and automated.
  • Assisted in creating an access database, which maps teh 14Q/A MDRMs to teh FRY9C MDRMS using GL and SL account information.
  • Compared logic and acceptance thresholds for edit check changes from FRB to Axiom implementation; communicated discrepancies to Axiom for upgrades.
  • Documented teh manual upload process for Axiom team for different schedules - 14Q/A.
  • Involved in teh meetings to identify teh scope and timeline change of teh data, after teh recent merger and acquisition between Confidential and Citi National.
  • Collaborated with developers on effort to develop Axiom reporting for schedules.
  • Created different types of reports in Axiom - Control Report, Adjustment Report, Manual Upload template.
  • Currently involved in testing of FRY9C reports in Axiom - Executing test cases and reporting defects.
  • Established data quality process, governance, and issue tracking process tools.
  • Worked with business and IT partners to remediate identified gaps using both manual and automated solutions.
  • Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
  • Creating RTM and Project Plan for teh team
  • Understanding teh requirement from teh Reference Data point of view
  • Creating Data Flow Diagrams to show business users teh to-be process.
  • Prepared Business Requirement Documents (BRD's) after teh collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
  • Experienced in conducting JAD sessions with excellent inter-personal and conflict resolving skills.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using teh UML (Unified Modeling Language) methodologies.
  • Comparing tables to analyze teh data elements and identifying teh common data types that can be centralized in teh master table.
  • Conducted End to End functional testing and UAT testing.
Confidential -Boston, MA

Business Analyst

Responsibilities:

  • Contributor of BASEL I, II, III frameworks, FFEIC 101 (RWA) Risk analysis, comprehensive Capital Analysis, CCAR, CCAS, Documentation, Implementation of Moodys Software Calculation (EAD, RWA, LGD, PD), oversee all aspects of Moodys Software implementation and deployment UAT, Validate data feeds into RDR.
  • Lead contributor to teh creation and execution of a process to populate teh FR Y - 14Q (quarterlyCCAR), teh present/historical portions of teh FR Y-14A templates (annual CCAR), teh semi-annual Quantitative Impact Studies (BIS), and teh annual FR Y-15 templates (fka Macroprudential Supervisory Group data collection exercise).
  • Assisted external consultants in teh development of an improved Balance Sheet projection model for use in strategic decision making.
  • Collaborated with Enterprise Risk Management and Regulatory Capital Policy to devise strategy to meet requirements of Basel II Capital Accord and present such strategy in person or via memoranda to senior management and Federal regulators.
  • Determined alternative approaches to Basel I regulatory capital calculations allowing significant capital savings.
  • Created suite of Excel models used monthly for analysis and verification of Basel II results in Production environment.
  • Advised IT teams and external vendors in teh implementation of required system enhancements and defect fixes.
  • Constructed templates and manual process for quantitative Basel II Pillar III disclosure tables.
  • Participated in requirement gathering from all areas of teh business and provide tactical and strategic deliverables.
  • Supported teh Production support enhancement and change request as requested by teh business owners
  • Gathered business Requirements, analyze data and workflows.
  • Provided on-going analysis of platform performance and availability for both internal and external stakeholders.
  • Strong business analysis skills and a sound understanding of teh Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP) methodology.
  • Excellent understanding of web security technologies.
  • Experienced in conducting JAD sessions with excellent inter-personal and conflict resolving skills.
  • Planned and conducted UAT, UI conformance testing and created test plans, test cases and Requirement traceability matrix.
Confidential -Minneapolis, MN

Business Analyst

Responsibilities:

  • 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
  • Gathered requirements through users interviews, teleconferences, document analyses, use case analyses and UML diagrams for user stories creation and obtain timely sign - off by all respective parties
  • Cooperated with CCAR team on delivering of teh Basel capital regulatory results to serve teh CCAR various reporting forms
  • Assisted teh execution of CCAR stress testing framework including gathering requirements of multiple stress scenarios and defining data elements required by stress tests
  • Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems
  • Involved in completing Data Mapping and performing data analysis by data modelling, Reporting Analyst, data reconciliations and gap analysis
  • Conducted meetings to ensure proposed changes as well as teh project team produced solutions that meet established standards, procedures, risks and mitigation plans
  • Led Sprint Planning & Estimation sessions, Sprint Retrospectives and Reviews
  • Worked extensively with onsite/offshore development teams during whole development cycle
  • 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
  • Meticulously addressed every detail to ensure a successful end-to-end business process .
  • Prepared FRDs that help drive teh design of teh infrastructure necessary for teh organization to meet new CCAR reporting requirements.

Tools: & Technologies: Jira, SQL Server, UML, MS Office Suite (Word, Excel, Power Point, Visio), SharePoint

Hire Now