Senior Business and Data Analyst Resume

SUMMARY

Highly qualified and well - developed Business/Data Analyst/PM with extensive project coordination and systems analysis experience that excels at participating in multiple projects simultaneously.
Solutions-oriented with notable success directing a broad range of initiatives while participating in planning and implementation of information systems solutions in direct support of targeted objectives.
Currently seeking a position that will effectively utilize acquired technical skills and abilities while demonstrating a track record of increasing responsibility in leading projects and coordinating with user departments in system design, product definition, release documentation, and data transmissions.

AREAS OF EXPERTISE

TECHNICAL SKILLS

Oracle, DB2, SQL SERVER 2005, Knowledge of Lotus 1,2,3, Dbase, Paradox CRI System, Money Management System, BOLT 1 and 2 (Sunguard), Intranet
Microlink, BESS System, MS Word, Excel, Power Point, Windows, JJ Kenney, DB2,TSO,Internet, Java script, Bloomberg, ADP, Citrix, Globe Net, Aims
Polaris Auto Rec Systems,Acess., Tracs, Gain, FTP HUMMINGBIRD, SQL, Unix Dbaccess, MS Access, Visual Slick Edit, Windiff., UML, Rational Products
Informix, COBOL,ODBC Visual Slick, C, COMPUTRON, Reuters, Murex version 2.1x, IMAGE PROCESSING, MQSERIES, STP, Reuters, QMF, PLATINUM, Unix scripting, SPUFI,GLOBAL PLUS,Winruner, CLS GUI, Fundtech, Visio,PAYPLUS, Safe Settle, SDLC, TOAD,SQL + Mercury (Test Director)
Business Objects, Sharepoint, SQLLDR, Web Intelligence, iSeries DB2, MS SQL SERVER 2005, XCOLL, SPYDA, COMA

PROFESSIONAL EXPERIENCE

Confidential

Senior Business and Data Analyst

Responsibilities:

Responsible for data mapping for CECL requirements DRD
Performed Testing within SIT/QA/UAT Environments
Responsible for analyzing all Data and writing SQL queries against Databases.
Responsible for writing Business/Functional and Data Mapping Specifications
Credits asset corporate, sovereign, bank, retail, and equity.
Writing BRD and FRD for new Enhancements and Projects/ JIRA IMR
Performed and maintained PMO timeline as it pertained to my tasks
Mappings from SOF to BIM ID for Enterprise Standard values
Working on Data Quality enhancements that impact Regulatory Reporting to Axiom
Performed ACBS source feed data mapping to new Datamart tables created for loans.
Perform Murex source feed data mapping into new data warehouse.
Responsible for testing the ACBS application and ACBS Impacted downstream applications
Perform VAR Measurement calculation estimates
Core Banking responsibilities Loans Retail and Commercial and Credit Cards with Oracle GL
Daily stand up meeting updates in Agile platform

Confidential

Senior Business and Data Analyst

Responsibilities:

Working on analyzing the new requirement on Loan Syndication, origination and servicing functionalities for ACBS application
Analyzing site-specific requirement for Lloyds ACBS application
Conducted Business Requirements Gathering sessions with the end business user, subject matter experts (SME) and the developers
Developed various use cases, workflow, screen mock-ups, and conversion requirements
Responsible for testing the ACBS application and ACBS Impacted downstream applications
Master Test Strategy and High-level execution plan for Testing
Responsible for performing Functional, Integration, Performance Testing and End to End testing.
Monitored project status to ensure progress toward completion, required procedural steps are completed
Worked closely with the IT architecture for identifying solution for various interfaces
Worked closely with development team on the development of MIS/AE hierarchy, BI, BIP reports
Prepared the Master Test document, End of Test Report and documented the release management and maintained structure to adhere with the audit requirement
Worked closely with the Project Manager and management to manage the implementation activities

Confidential

Senior Business and Data Analyst

Responsibilities:

Responsible for data mapping from data warehouse to CCAR schedules 14A, 14Q and 14M
Performed Testing within SIT/QA/UAT Environments
Responsible for Record keeping Dodd Frank requirements enhancements within Data Warehouse
Responsible for analyzing all Data and writing SQL queries against Databases.
Responsible for writing Business/Functional and Data Mapping Specifications Performed for ACBS source feeds.
Core Banking responsibilities (ACBS) Loans for Retail and Commercial and Credit Cards with Oracle GL management.
Perform VAR Measurement calculation
Credit assets corporate, sovereign, bank, retail, and equity.
Perform Murex source feed data mapping into new data warehouse.
Responsible for testing the ACBS application and ACBS Impacted downstream applications
Performed and maintained PMO timeline as it pertained to my tasks

Confidential

Senior Business and Data Analyst

Responsibilities:

Responsible for data mapping from data warehouse to CCAR schedules 14A, 14Q and 14M
Created and maintained testing case scenarios within HP Quality Center
Involved in the testing of all models in which LOB has sent during Jumpoff.
Knowledge of Axiom SL 9X analytical informational and reports used Fed submission for HCR and CCAR 14A,14Q and 14M schedules
Performed testing in SIT/UAT/QA environments
Run SQL queries within Oracle/ DB2 ISERIES/SQL Server databases for testing and accuracy landing of data.
Utilization of Informatica Analytics Tool
Perform VAR Measurement calculation
Responsible for analyzing Capital and PPNR schedules and perform data and root cause analysis
Created the Functional Specifications within the Me2 and LOB UI applications
Worked on the Models for which Me2 UI implementation Balances, NII and NIR for Portfolio and Contract driven models.
Created CCAR Schedules to Data Element comparison and Identified all data mapping from source system to target landing areas.