SEARCH

Sr. Business System Consultant V Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
SR. BUSINESS SYSTEM CONSULTANT V
Professional Summary

Experienced Business Analyst professional with strong leadership and relationship-building skills.

Skills
  • Data Analysis and Technology: SQL, PL/SQL, Microsoft SQL Server, Business Object, Tableau, Axiom, Informatica
  • Testing and Management Tools: Microsoft Project , Quality Center, JIRA, Rally, Microsoft Visual Studio, Microsoft Office
  • Core Competencies: Data warehousing, Regulatory Reporting, Business Intelligence, Agile, Waterfall, Requirement elicitation, Testing, Project planning and execution
  • Agile, Waterfall, Project planning
  • Automation, Quality Assurance
Work History
Sr. Business System Consultant V, 08/2018 to Current
Company Name – City, State
  • Working as lead Business Analyst on Enterprise One regulatory reporting project to support various US Fed reports including: CCAR 14M & Q, FFIEC 031, 41, Y9C
  • Coordinate development and testing effort for periodic releases
  • Working on Data Governance Integration Project (BCBS 239) in identifying data controls, data quality rules and systems at different data processing stages for the purpose of Regulatory reporting including gap analyses for missing balances and record count
  • Maintained documents to establish the linkage between BIM (Business information metadata) to KDE (Key Data elements) and physical data attribute
  • Created data lineage for tracing reports information from end reports to system of records
  • Perform root cause analysis for variances in reconciliation and develop processes to fix them
  • Conducting business testing to validate application functionality based on functional requirement
  • Managing Data Quality rules for the entire system by working with multiple SME's to gather data accuracy standards
  • Work with data warehouse developers to evaluate impact of changes in current system including redesign of ETL logic
  • Execute DDL, DML statements in Oracle for maintaining Sand box environments
  • Executed BAU plan and also ingested any future enhancements , collaborated with IT and SME's from various LOB's to gather the requirement for data enhancement
Sr. Business Analyst, 07/2017 to 07/2018
Company Name – City, State
  • Worked on Credit Risk Data Warehouse (CRDW) Decommissioning Project.
  • Worked on: GL Recon Tool, Workflow Tool and Rules Engine to facilitate data transformation, Reporting tools and a new Collateral Haircut Engine to improve regulatory reporting and supporting analytics.
  • Analyzing the Functional Requirement Documents and High Level Design Documents to provide the testing effort involved.
  • Also involved in the designing activities to understand the data flow of a project and plan the test effort accordingly.
  • Creating test plan document and present to client to get the approvals for the testing effort estimated; further analyzing the data architecture specification document and preparing test cases.
  • Prioritizing and planning test cases and defects.
  • Participated in releases and performed systems integration testing and user acceptance testing.
  • Prepared various artifacts for testing such as defect process flow and JIRA report.
  • Working on General Ledger (GL) reconciliation in Finance Regulatory Reporting Project (FRRP) vs different layers of enterprise architecture.
  • Developed automated reports to check the GL balances for all source systems across different environments.
  • Worked on profiling the production data to identify the different anomalies with respect to CDE's.
  • Lead for reporting and process automation initiative across all functions of finance especially to GL team.
  • Responsible for preparing various reports and making it available to the senior management for weekly working group meetings.
Sr. Business Analyst, 02/2016 to 05/2017
Company Name – City, State
  • Worked on a project to create a Regulatory Reporting data warehouse (FARM) to meet reporting and analytical business needs for the BNP Paribas IHC, BHC and Bank of the West CCAR, 2052A, Basel III, and other regulatory reports.
  • Delivered source to target mapping, BRD's, System Requirement document, Data Analysis and weekly defect status reports.
  • Performed data gap analysis, data remediation plan for Risk Data Aggregation & Reporting.
  • Compile a list of all attributes and performed Data conformance all across source system for Loans and Deposits to bring the data into the central data warehouse “FARM” Finance and Risk Data Mart.
  • Lead liaison between Business and Technical BI developers to implement BI solutions for internal Treasury Finance Reporting.
  • Worked on Change Requests/Design/Source to Target Mappings for fulfilling the requirements indicating gap analysis.
Sr Business Analyst, 02/2012 to 12/2015
Company Name – City, State
  • Spearheaded the effort to produce FFIEC 101, Pillar III and 2052a Liquidity report
  • Responsible for all technical PM activities for Retail Asset class
  • Lead teams of Business/Data analyst to move the data into warehouse as per the requirements ;created mapping documents
  • Published documents related to requirements gathering, test plans, traceability matrix, Data lineage and defect management
  • Participated in QA , UAT and END to END testing cycles
  • Provisioning data for OFSAA FSDF from various source systems and analysis of cash flows generated in OFSAA ALM processing area as well as OFSAA LRMS processing area.
  • Provisioning data for OFSAA FSDF from various source systems and analysis of cash flows generated in OFSAA ALM processing area as well as OFSAA LRMS processing area.
  • Perform Data Analysis and Data Validation by writing complex SQL Queries.
  • Responsible for making the report available for scheduling or viewing on demand.
  • Record project changes on a weekly basis to update plan and provide up to date information for project status reporting.
Education
M.S: Information Systems ManagementStratford University - City, State
Bachelor of Arts: EconomicsDevi Ahilya Vishwavidyalaya - City
Fun Fact

I traveled over 15 countries, can speak 3 languages, play tennis and love hiking

Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Stratford University
  • Devi Ahilya Vishwavidyalaya

Job Titles Held:

  • Sr. Business System Consultant V
  • Sr. Business Analyst
  • Sr Business Analyst

Degrees

  • M.S : Information Systems Management
    Bachelor of Arts : Economics

Similar Resumes

View All
Sr.-Business-System-Analyst-resume-sample

Sr. Business System Analyst

Columbus, Ohio