John F. York Cell 213-***-****

***** ******* ***** **

Albuquerque, NM 87111 EMail ac8i3d@r.postjobfree.com

Skill Sets and Tools:

Languages: MS Visual Studio, VBA, C/C++

Applications/Tools: SAS (SAS 9.2 & Enterprise Guide 4.2), MS Office, MS PowerPoint, MS Project, MS Visio, Rational Unified Process (IBM), Oracle (OBIEE & OFSAA), QRM

Databases: MS SQL (6.5 – 2016) using T-SQL, SQL Server Integration Services (SSIS), and ANSI SQL, Oracle & OBIEE, MySQL, Access/Excel, PeopleSoft

EXPERIENCE:

Consultant / Business Systems Analyst ATRI

Zebra Inc., Holtsville, NY 11742

March 2016 to August 2016 `

Involved with Zebra a manufacture of logistic hardware and software using barcode readers, RFID, thermal printers, etc. Worked on assigning compensation credit for a sales force of over 400 stationed around the world. Used existing systems to assign sales credit against nine different compensation plans. Used OBIEE & OFSAA, Access, and MS SQL to gather and analyze the data and produce the correct sales credit to each individual salesperson. Involved in this process is an Indian software contractor (Zyme). Interfaced with PeopleSoft This included tracking the data as it is transferred through various business systems using different databases, ETL protocols, and numerous file types. Put in place an End-To-End accountability for all data elements moving through Zebra’s applications.

Consultant / Systems Analyst Meridian

Bank of America, Wilmington, DE 19884

June 2015 to December 2015

Worked on Metadata databases and systems in support of CCAR. Reviewed, changed, and updated metadata for all financial, compliance and accounting systems. Included End-To-End accountability of all data elements moving through the bank’s 200 plus applications for changes in names, data types as the data is passed from system to system. Directly involved with business subject matter specialists (SMEs) from the mortgage, credit card, investment, compliance and risk management using the multitude of financial reporting applications. Mortgage alone has over 38k elements. Wrote Excel VBA to streamline certain aspects of metadata verification.

Used three departments and one enterprise metadata applications to research linage and definitions.

Verified and corrected metadata before submission to BAC Metadata Portal.

Worked directly with business users and SMEs to verify all aspects of metadata.

Consultant / Systems Analyst Apex

TIAA CREF, Iselin, NJ 08420

September 2014 to April 2015

Working in Financial Services. Involved in converting TIAA CREF’s financial reporting systems (PeopleSoft) to a new reporting database (Oracle with OBIEE & OFSAA) for tracking all financial instruments – derivatives, real estate, real assets, securities, etc. The purpose is to speed up and improve monthly, quarterly and yearly closing reports for regulatory, internal and external clients. Developed requirements for developing reports using OBIEE to tie financial reports to the general ledger (PeopleSoft).

Liaising between technical and business teams for gathering mortgage data.

Generation of ad hoc and routine reports for all levels of management

Consultant / Systems Analyst Randstad

Bank of America, Agoura Hills, CA 91301

June 2012 to April 2014

Working in legacy (CountryWide) asset mortgages of BAC. Involved in analyzing bank systems and introducing a mechanism for ensuring bank systems and applications complying with Basel 2, OCC, and CFPB requirements. Worked directly with the business stakeholders to gather, refine, and publish business requirements and providing technical documentation to development teams. Engaged in writing and implementing specifications for minor and major changes to banking databases and processes.

Manipulation and analysis of large data sets involving all aspects of mortgage processing – origination to servicing to the final closing of the loan including foreclosure. Extensive use of ETL.

Daily creation of SQL queries against 39 terabytes of data involving 6000 plus tables. Changes are processed through CIT, SIT, UAT, and Prod.

Liaising between technical and business teams for gathering mortgage data. Major rewrite for compliance with new CFPB regulations.

Generation of ad-hoc and routine reports for presentation to all levels of management

Implementing CFBP requirements by mapping data elements from 17 different databases to produce a data mapping/data dictionary tracking over 4000 key business elements (KBEs) to support a reporting database.

Consultant / Business Systems Analyst GSU

PNC Bank, Miamisburg, OH 45342

June 2011 to June 2012

Working at PNC Bank Credit auditing the Mortgage Bank’s loan originations with focus on underwriters’ performance in complying with all Federal and State rules and regulations and borrowers’ credit history to determine the risk level. Using Cogent (Audit and Servicing systems) and Hyperion to produce management and tracking reports for compliance. Compiling and developing data for legal and compliance issues with consolidated detail reports and summaries. Automated the Excel reporting process and implementing conversion to SAS enterprise databases linked to MS SQL & Oracle databases.

Directly supported the conversion of Cogent to an entirely SQL

Providing analysis of loan originations directly from Cogent backend MS SQL databases.

Managed conversion of audit system to MS SQL server. Wrote SQL queries to track progress and accuracy of conversion.

Performed daily Excel reports from both systems to track differences between daily and monthly reports.

Sr. Business Analyst

PIR Capital LLC, Pasadena, CA 91030

August 2009 to June 2011

Developing analytic tools, reporting and analysis for auditing mortgage-backed securities (MBS) for compliance with governing documents. Streamed lined cumulative loss reporting and repurchase request loan tracking. Developed systems to download numerous loan files in many different formats (TXT, Excel, compressed) and extract data for analysis and audit. Wrote code to extract data and produce Excel spreadsheets to find specific loans out of compliance with the audit rules.

Defining software development environment for future processes.

Used Access to pull time series reports for Excel summary reports.

Risk Analyst

WesCorp San Dimas, CA 90071

May 2003 to July 2009

Worked in the Risk Management Department to extract data from three databases (MS SQL, Access, and Oracle) into meaningful presentations for internal analysis and modeling, and external customer reports. Processed data using a variety of analytical tools and formulas. Databases supported over 1000 credit unions (CUs). External presentations were delivered in Word and Excel formats. Extracted data using MS SQL SSIS and other ETL tools for custom interest rate modeling QRM ALM application. Worked with individual CUs to determine the duration of their non-maturity assets involving extensive data mining and summary presentations. Processed large amounts of customer data (up to 18M+ records) in various formats using MS SQL and VBA/Visual Studio as part of the ETL process. Imported data using DTS or bulk transfer. Used stored procedures and various other SQL tools (triggers, complex indexes, in line logic checks, etc.). Built tables on the fly.

Built system to interactively query three different databases using Excel coupled with ETL tools.

Principal

BMIS San Dimas, CA 90121

February 2003 to May 2003

Was Proposal Manager for five (5) Proposals in response to Requests for Proposals (RFPs) from Department of Energy. Area of interest was fuel cell technology.

Extensive use of Visio, Excel, MS Project and Word.

Manager -- Applications Development

Bank of America, Los Angeles, CA 90071

April 1998 to February 2003

Responsible for five banking systems supporting 300+ users at over 20 sites. Systems tracked over $32B in assets. Expanded the original servicing system to include origination on the front-end tracking performance of loan officers through securitization, servicing, and master servicing on the back end. Managed 5 to 8 software developers. Hired and developed entire staff. Converted VB6 applications and developed new programs with Java J2EE applications supporting three departments. One system had 10,000 loans valued at $20.5 B. Used multi-tiered architecture – VB GUI, COM Objects, and Oracle/MS SQL/Sybase. With team members initiated new software architecture by transitioning all databases to Oracle 8i from Sybase and MS SQL. Also rewrote ASP and VB programs into Java J2EE architecture.

Programmer Analyst

SpeedFram Chandler, AZ

June 1997 to April 1998

Built an application that used the internet to transfer information concerning the operation and maintenance of $3-4 M manufacturing tools to polish wafers for the semiconductor industry.

Programmer Analyst

Software Solutions Unlimited, Albuquerque, NM 87109

September 1996 to June 1997

Built an application for a Newton handheld computer that sends work order information to a Progress database.

Senior Consultant

BMIS Moses Lake, WA 98837

July 1995 to September 1996

Built an interactive electric trading system for an electric utility using Visual Basic and Access over a Novell LAN. Connected to SCADA system controlling dams.

Computer Services Supervisor Southern California Gas

Southern California Gas Company, Los Angeles, CA 90017

July 1990 to July 1995

Provided all systems information support to the Human Resources Department (454 workstations at 13 sites) included is all computer and networking activities supporting all computer applications -- mainframe, micro, and distributed.

Designed and installed Automatic Meter Reading Systems for collection, calculation, and integration of gas meters.

Manager, Software Engineering

Planning Research Corporation, McLean, VA

October 1987 to July 1990

Developed business and scientific applications in COBOL, FORTRAN, and C on DEC, Sun and DG platforms. Marketed company services to increase contract work to $1.2M. Managed tasks involving analysis, evaluation, and plans for computer and telecommunications systems.

Career Officer, U.S. Army

The US. Army, Washington, DC,

July 1966 to October 1987

Career Field: Information Technology, Infantry

Attained rank of Lieutenant Colonel.

EDUCATION:

M. S. Computer Science, Kansas State University, 1981

B. S. Chemistry, Illinois Wesleyan University, 1966

U. S. Army Command and General Staff College, 1980

Contact this candidate