Terry L.

Terry L.

Software Developer with varied languages, specializing in SAS Data Integration Studio

White Bear Lake , United States

Experience: 31 Years

Terry

White Bear Lake , United States

Software Developer with varied languages, specializing in SAS Data Integration Studio

132000 USD / Year

  • Immediate: Available

31 Years

Now you can Instantly Chat with Terry!

About Me

 

Led the development effort for incorporating Data Integration systems at Bank of America mostly on a remote basis.  In a major project at Blue Cross Blue Shield of Tennessee, I was instrumental in saving the company over 200 hours per ...

  

Show More

Portfolio Projects

Nestle Purina

Company

Nestle Purina

Description

Instrumental in migrating the Demand Planning System ETL and reporting BASE SAS programs to Data Integration Studio jobs.   Design and develop a batch process to run system in a production environment.  Also used SAS EG.

Show More Show Less

Bank of America

Company

Bank of America

Description

 

Tech Lead for the development effort in leveraging multiple data sources to transition Credit Card, Mortgage, Home Equity and Risk Control Framework systems into SAS EBI environment for the Enterprise Consumer Analytics and Reporting Solution (ECARS) program.  Full Life Cycle duties within the Consumer Risk Group using SAS Data Integration Studio 4.2 , SAS Enterprise Guide, Base SAS, UNIX, ETL, LSF Scheduler.  Converting quantitative analyst’s Base SAS code to SAS DATA INTEGRATION ETL jobs. 

Show More Show Less

Bank of America - 2nd stint

Company

Bank of America - 2nd stint

Description

 

Tech Lead for the development effort in leveraging multiple data sources to transition Top of House Card and GWIM systems into SAS EBI environment for the Enterprise Consumer Analytics and Reporting Solution (ECARS) program.  Full Life Cycle duties within the Consumer Risk Group using SAS Data Integration Studio 4.2 , SAS Enterprise Guide, SAS Information Studio, Web Report Studio, Base SAS, UNIX, ETL, LSF Scheduler.    Working closely with LOB subject matter experts and technical business analysts in integrating data into end-to-end SAS data mart solution for risk analytics and reporting.  Creating Low Level Documents (tech spec).  Using TortoiseSVN interface to Subversion for source control.  Light SAS Admin duties (promoting code from DEV to SIT, creating folders, registering tables in SPDS).

 

Expertise in extracting and aggregating mutil million rows of data from DB2, Oracle and Teradata data bases and creating Metadata for DI jobs.

  

Show More Show Less

Bank of America 3rd stint

Company

Bank of America 3rd stint

Description

 

Member of Risk Data Management Platform group working on the development effort in automating the Federal Reserve Board 14M Regulatory project, which consists of multiple sources feeding into custom jumbo mortgages. Also working on the Data Sourcing and Home Loans projects doing source to target analysis in the conversion from SAS and DI Studio to Neteeza and Informatica.  In charge of migrating metadata from current User Work Space to future target environment.  These projects use the Agile Methodology.

  

Show More Show Less

St Paul Travelors

Company

St Paul Travelors

Description

 

Reviews, analyzes, and modifies programming systems including coding, testing, and debugging.  Lead Developer for the Management Reporting system. Maintained and developed batch application programs using Mainframe SAS, SAS/ACCESS, COBOL, DB2 and IMS.  Developed specifications, diagrams and flowcharts.

Show More Show Less

Tools

DB2 IMS /dc

Blue Cross Blue Shield of Tennessee

Company

Blue Cross Blue Shield of Tennessee

Description

 

Full life cycle development; including requirements analysis, design, programming, data transfer from old system, testing, implementation, and application enhancements.
Major Account Reporting System:  New development using COBOL, Mainframe SAS, SAS/ACCESS, DB2 and Easytrieve Plus working on financial reporting systems . Creating extracts and reports from financial data in large Data Warehouse  for  clients of BCBST in the areas of Medical Claims, Member databases, Prescription Drugs and Case Management. Eligibility, Provider, Pharmacy Claims, Dental Claims.

 

Additional duties include compiling extensive test scripts for QA.

 

Report Migration Project – Lead Developer: Converted user reports to IS standards reports using PC SAS, Mainframe  SAS, COBOL, Easytrieve Plus across multiple platforms.  Created front-end for system to capture user parameters using Visual Basic 6.0. Verifies program logic by preparing test data and conducting unit tests. - Participants in the systems testing and user acceptance testing.  Converted many COBOL reports to Adobe Acrobat PDF’s using SAS ODS.

 

Environment: MVS, IBM Mainframe, COBOL, DB2, SQL, SAS, QMF, Easytrieve Plus, Visual Basic.

 

Financial Data Mart:  Converting Legacy reports from retrieving data from Data Warehouse to retrieving data from new Financial data mart using  Easytrieve Plus, COBOL, DB2.

 

Cash Financial Data Mart:  Designed program specs for Extract and Transform programs.  Analysis of old system reports for conversion to new system.  Easytrieve Plus, COBOL, DB2.

  

Show More Show Less

Skills

COBOL DB2

Tools

SAS BASE