Sr Business System Consultant V Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
  • , , 100 Montgomery St. 10th Floor
  • H: (555) 432-1000
  • C:
  • Date of Birth:
  • India:
  • :
  • single:
Professional Summary

Experienced Business Analyst professional with strong leadership and relationship-building 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
Vertafore Windsor, , NC
  • 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
Vertafore Denver, , NY
  • 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
Relx Group Heathrow, , CA
  • 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
PNC Financial Services Group City, , PA
  • 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.
M.S: Information Systems Management, Expected in
Stratford University - Falls Church, VA
Bachelor of Arts: Economics, Expected in
Devi Ahilya Vishwavidyalaya - Indore,
Fun Fact

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

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

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.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


Resume Strength

  • Clear Contact Info
  • Formatting
  • Personalization
  • Target Job

Resume Overview

School Attended
  • Stratford University
  • Devi Ahilya Vishwavidyalaya
Job Titles Held:
  • Sr. Business System Consultant V
  • Sr. Business Analyst
  • Sr. Business Analyst
  • Sr Business Analyst
  • M.S
  • Bachelor of Arts

Similar Resume

View All
Agile Business System Analyst/ Sr. Consultant
SR. Business System Test Analyst
Sr. Business System Analyst