Analyst Data
Resume:
JASON MICHAEL O'QUINN
Business/Data Analyst II
**********@*****.***
SUMMARY:
Senior Business Analyst/Database Analyst business professional with over 12 (accumulated) years of experience in Business Analysis (21 years professional experience overall), Data Analysis and the SDLC from Requirement Gathering to Testing to implementation and finally to post-production support of complex information technology projects in Financial, Banking & Investment sectors
Worked as a Process Consultant to facilitate sessions to gather and fully document business system requirements within the SDLC, using the BP methodology (BPM).
Worked on eliciting business and functional specifications on mortgage servicing applications, both new and updates to existing applications. Testing of solutions via test matrices also accompanied these initiatives.
Utilized the Enterprise Architect (UML) tool to develop and document the business and systems requirements into Use Case and BPM documentation (BRD, PDD, Use Case Diagrams).
Lead BPM and Use Case training sessions regarding current and future state updates to lending applications for end users within Wells Fargo using Enterprise Architect, similar tool to Visio.
Authored required technical requirements documentation detailing the MAM system and the EDBI database and PICCT system and how these two systems will be combined.
Experience with PD model creation using Python, developing and troubleshooting Test Matrices for the models.
Worked with both Database administrators (DBAs) and Data modelers with regards to SQL query creation/usage/testing/validation/mapping of data for various databases supporting various applications/reports/ratios etc.
Data cleansing, troubleshooting and updating query results within the effort of database analysis. This included (truncation/insertion/optimization)/mapping via various tools within SQL Server/Oracle and Access.
Understanding which methods to use in performing analysis of Database table structure, table relationships and how these are utilized when knowing how to construct the appropriate SQL queries as required.
Managing JAD sessions in gathering business/technical and data requirements.
DEV, DEMO, UAT/BAT (Testing), PROD Environment experience regarding software updates and UAT testing and verifying Compliance of application systems.
Have experience working with 3rd party vendors in assisting the development of a Payment Acceptance application for the project.
Data Warehouse experience, DataMart development and Database analysis experience utilizing SQL queries to mine data and pull reports for further analysis.
Possesses Advanced coding skills in SQR, SQL, VB for Access, Excel
Possesses intermediate (previous) coding skills with VBA, Cognos, ASP, HTML, JavaScript, Python
In college I was trained in COBOL, I can read the code and make updates.
Experience with Agile project methodology, Jira, Use Cases, User Stories, BPM
EDUCATION:
University of North Carolina at Greensboro, May 1997
Bachelor of Science, Double Major in Accounting and Information Systems
Technical Skills:
Enterprise Manager - Optimist Accounting Software, Moodys, Scrum Methodology, Agile and Waterfall Methodologies, Risk Model creation, UML, RUP, Jira and Agile Methodology, Use Case Modeling, SQL Server 2008 – Database Table and View and Query Analysis – Loan Origination; Microsoft Access 14, 16; Mortgage Insurance; Visual Studio/Interdev 6.0; Visual SourceSafe, Personal Web Server; Oracle Developer 2000;
Past Web and Database development/Support including Database/Table/Query/View/DTS package creation
INTERMEDIATE PROGRAMMING LANGUAGE EXPERIENCE (Present to Past):
SQR, SQL, Dynamic SQL, VBA, HTML, JavaScript, PL/SQL, ASP w/ VBScript, Python
PROFESSIONAL EXPERIENCE:
UTC Corporation, Mebane NC January 2020 - March 2020
Worked as a Business Systems SQL Analyst on the Kidde products sales Marketing team.
Worked on troubleshooting, updating and the PIM backend data warehousing application that feeds the following sales sites: Amazon, Walmart and Home Depot to assist in accurate marketing legal “copy” that supports the liabilities of the company via verbiage pertaining to each end product.
New database/table creation specifications handed off to the DBA team also helped to house and assist in reporting on sales data.
LabCorp, Burlington, NC December 2017-April 2019
BUSINESS ANALYST/Project Coordinator - Contract
Worked as a Business Systems/Project Coordinator SQL Analyst on the HRIM Diagnostic team.
Worked on troubleshooting, updating and the creation of SQR programs to process/manipulate/verify data within the EV5 HR system using SQL Server and Oracle backend databases.
Duties also included taking in ADHOC report requests for HR information, analyzing/troubleshooting the needs, and then coding the reports in Access/SQL to provide the reports requested.
Assisted the Lead BA in performing Mass migrations of data into the EV5 system via SQR’s.
Assisted with testing/coding and support of an internal Excel/Access VBA-based “ANHIB” and
“ADFLC” application.
Supported a core group of End Users with reports, training and testing with any questions/additional needs they may require.
AGFIRST FARM CREDIT BANK, COLUMBIA, SC August 2013 -June 2017
BUSINESS ANALYST
Worked as a Business Systems Analyst on the ongoing high level, very visible Loan Origination Services Lending Lifecycle project with the Lending Payment Acceptance Accounting software “Optimist” that utilized Oracle as the backend Database. AgFirst was an Agile shop and we utilized Jira for Sprints.
Worked with the 3rd Party Association user groups and the 3rd Party Vendor in performing User Acceptances and Business Acceptance (SME) Testing in PD Risk model verification.
When working with the “core” set of associations that were the initial end users, we had to facilitate the requirements from all 3 stakeholders. Worked to clarify and solidify the core requirements for the COA and the PD models from conflicting and differing end user requirements.
Elicited technical and business specifications from associations to help develop Risk Model elements within the Optimist application, allowing for coding specifications to be created.
Performed detailed query and requirements analysis in documenting the COAL system upload, this entailed SQL analysis, Loan origination Servicing analysis and mapping fields from the ACL system to the Mainframe Upload process. Additional analysis of existing formulas that derive the fields was performed and documented field by field.
Performed analysia for Optimist to handle liquidity risk analysis and management of the end client, the farmers obtaining the farm origination loan.
Elicited quantitative risk managemwnt in conjunction for the credit loans to manage customer risk. Optimist produ ed risk models which i created and tested for complete and accurate results .
Created and supported all Risk Models for 5 of the associations. This initiative included coding formulas using the language Python within Optimist.
I worked on replicating/developing 65-+ ratios/formulas from Moody’s into Optimist for Compliance and Regulatory Reporting. This included data mapping from the COA accounts within Moody’s to those created within Optimist. SQL data mining and analysis was performed on each ratio to verify results through UAT verification, thus, data was validated via backend reports created using the new matching Optimist ratios. Cleansing of the Optimist database of extraneous records was performed on the backend of the process, with updates made first in STG then moved into Production on weekly “deployments”.
Tracked progress with the team in Jira
Worked on verifying the data mapped elements into the core data structure of the Optimist application.
Semi-Professional Experience – Web Developer Spring 2012 – June 2013
While I was looking for a new Business Analyst assignment, I worked in 2 Chinese restaurants part-time. I worked with a friend/college fraternity contact in starting up his family’s new Chinese restaurant. I helped to run the cash register, I began work on a website that they decided was not necessary for marketing the restaurant, but it was started. I also worked with him in his relative’s Japanese restaurant.
WELLS FARGO/WACHOVIA, INC., GREENSBORO, NC April 2006 – Feb 2012
BUSINESS ANALYST II
Worked as a Business Analyst to facilitate sessions to gather and fully document business system requirements within the SDLC, using the BP methodology (BPM), Waterfall and Agile methodologies, utilizing Jira with Wells Fargo.
Duties included the creation of Functional Specifications Documentation detailing various internal application process, Use Cases and technical details of the project.
Utilized the Enterprise Architect (UML) tool to develop and document the business and systems requirements into Use Case and BPM documentation (BRD, PDD, Use Case Diagrams).
Facilitated meetings with the Project stakeholders, (Managers, DBA's, SME’s and technical staff) to ascertain the exact needs of each project, creating Use Cases and BPM models to support Consumer Lending initiatives.
Projects ranged within various platforms and LOB’s including 2 Mortgage-based projects, one to modify an existing insurance system and the other for creation of a new user-interface mortgage application.
Lead BPM and Use Case training sessions for end users within Wells Fargo, included writing up User Stories to assist this effort.
All documentation that was created from these meetings was then delivered in the BRD template and additional Use Case/BPM reports were created from Enterprise Architect as hand-off material to the Project leads.
Assisted with User Acceptance testing. The test cases were created in an Excel template and fed into the Quality Center software.
Worked on the DBMS Risk Remediation project to fully analyze and catalog/inventory all of Wachovia's Databases and associated Applications.
Worked on eliciting business and functional specifications on mortgage servicing applications, both new and updates to existing mortgage-based applications.
The meetings involved meeting with various Database Administrators, Subject Matter Experts and developers to ascertain the exact needs of each project in which I was assigned.
Gathered requirements and created the required technical documentation detailing the MAM system (including flat file databases local to computer for analysis) and the EDBI database and PICCT system and how these two systems will be combined.
JEFFERSON PILOT INSURANCE (Lincoln Financial), GREENSBORO, NC Nov 2004 – NOV 2005
APPLICATIONS SPECIALIST (SOS Team)
Developed ASP applications for several of the company's main Intranet projects for the Investments team.
Modified and created VB scripts, HTML applications, SQL procedures and functions for data analysis.
Created Crystal Reports for use by the Investments team.
The team also performed end user support of hardware/software/application needs.
Assignment was a 1 year contract.
Team Project Manager utilized Microsoft Project for tracking and planning the SOS weekly activities and application support efforts.
THE TODD ORGANIZATION, GREENSBORO NC MAR 2001 – AUG 2004
APPLICATIONS SPECIALIST / IT GROUP
PARTNERS NHPNC, WINSTON SALEM, NC JUL 2000 – MAR 2001
PROGRAMMER ANALYST PART OF THE MIS APPLICATIONS
AMERICAN EXPRESS, GREENSBORO NC DEC 1998 - DECEMBER, 1999
PROGRAMMER ANALYST I
INTEGON INSURANCE, WINSTON-SALEM NC JUN 1997 – SEPT 1998
COMPUTER ANALYST PROGRAMMER ON THE DATA WAREHOUSE TEAM
Contact this candidate