We provide IT Staff Augmentation Services!

Sas /cobol Migration Consultant Resume

3.00/5 (Submit Your Rating)

Denver, ColoradO

SUMMARY:

  • Have Been a top level SAS Consultant for many years working for major Banks and other corporations.
  • Over 9 years of experience as SAS Analyst / Programmer in a SAS 9 environment with Sales Operations or Commercial experience in Pharmaceutical domain
  • Over 10 years of experience with SAS v9.2, SAS Macro, Excel and VBA and 5 years of experience with Sales data (SP, SD, 867, 852 etc) including programming, design, architecture and .
  • Expertise with SQL procedures SAS MACROS, SAS processing on PC and UNIX systems.
  • Involved with many new and existing systems including reporting methodology involved with system performance and utilization.
  • Extensive documentation of changes and procedures.
  • Complex queries of large SQL table(s), efficiently utilizing SAS, SAS/Access to SQL and Enterprise Guide.
  • Good Understanding of SAS product security, performance, server design, Microsoft Windows integration, and storage;
  • Excellence knowledge of change management procedures and version control
  • Have the ability to effectively communicate designs and decisions to peers, customers and management.
  • Excellence problem - solving skills.
  • Have strong expertise in Data Warehouse / Business Intelligence systems, Data Warehouse design using Kimball methodology.
  • Have SAS BI products including Integration Services.
  • Solution for risk analytics and reporting using SAS Data Integration Studio 4.2.
  • Used Data Integration Studio ETL and traceability features to ensure data validity and auditing for LOB reporting and compliance with Data QA standards.
  • Maintained DI Jobs, scheduling, maintenance and enhancements. ETL procedures to combine all

TECHNICAL SKILLS:

IBM: 3083, 3081, 370, 4341, 4361, 4381, 3350, 3380, 3380 MASS STORAGE, 3390 ; OS/MVS/XA, DOS/VSE, MICS, BASE SAS, CAPTURE, IMS/VS, IMS DB/DC, CICS, BESTII, PL/1 COBOL, TSO, SMF, SMP, OMEGAMON, RMF, NFA, OS/JCL, ALC, SMP-E, SLR, MXG, CA PRODUCTS, SMS, SAS/DB2/SQL

SAS Enterprise: Guide, ORACLE, Teradata, SAS, SAS/AF, PROC REPORT, ENDEVOR, MS ACCESS, SAS Data Integration Studio 7.1, SAS/GRAPH 9.4 SAS/STAT 14.2 CCAR Modeling.

SAS BI: using OLAP processing with linking cubes and hypercube. AS Enterprise Guide 7, 1 SAS 9.4

Experience: SharePoint Administration and SharePoint Owner Certified Informatics developer

PROFESSIONAL EXPERIENCE:

Confidential, Denver, Colorado

SAS /COBOL Migration Consultant

Responsibilities:

  • Migrated SAS Mainframe programs from Rel 9.4 to SAS 9.4 SAS Enterprise Guide 5.1.
  • Converted Programs and trained users in SAS Enterprise Guide 5.1.
  • Specializing in SAS automation and modularization of complex financial and quantitative models developed in MS Excel, MS Access, and R Language

Environment: SAS 94 EG 7.1 SAS Mainframe SAS Window Explorer. SAS SPDS, SQL, worked with the business units to develop requirements gathering for present and future projects.

Confidential, Charlotte, NC

SAS Consultant

Responsibilities:

  • Duties include SAS Development and data Analyst with the SAS Financial Crimes Suite.
  • Experience supporting AML/BSA, Customer Due Diligence, economic sanctions/OFAC or other compliance related initiatives in a large, complex, highly-regulated financial institution
  • Experience with Bank Anti-Money Laundering (AML) and/or Customer Due Diligence (CDD) related systems.
  • Strong planning, implementation and negotiation skills
  • Effective interpersonal, verbal and written communication skills

Environment: SAS 9.4 EG 7.1 SAS Window Explorer SAS Management Console

Confidential, Charlotte, NC

SAS Admin/SAS Consultant

Responsibilities:

  • Duties include SAS Admin functions and Sharepoint Administration for The PPNR Modeling Group
  • Developing application using SAS Enterprise Guide, and SAS Customer Intelligence.
  • Responsible for retracting of the Unix environmement and builing a new Sharepoint site.
  • Defining SAS permissions to the PPNR Modeling Group
  • GRID Administrator Monitor server space and performance and balancing issues

Environment: SAS 9.4 EG 7.1 SAS Window Explorer SAS Management Console

SAS Internal Admin

Confidential, Charlotte, NC

Responsibilities:

  • Duties include Technical Support,, Liaison Between the Sas Admin Group and the Business User Community
  • Involved in code data migration and worked on Technical Solution Document, including ETL designs for the SAS Enterprise Guide & web portal development.
  • Wrote SAS codes to create predictive modeling samples SAS data sets by merging data from multiple data sources
  • Analyze data trend, data manipulation, data cleanse using SAS & SQL.
  • Data validation and profiling of the variables done using SAS Base / Macros using proc reports and proc format.
  • Work closely with the Sas Admin Group using Grid Monitor to monitor the activities of the Bi Business Users.
  • Worked On The migration plans: Capacity planning of the new environment
  • To upgrade from Sas 9.2 to Sas 9.4
  • Evaluation of Enterprise Miner & Model Manager products
  • Enterprise Guide 4.3 to Enterprise Guide 7.1. and migration from netezza to teradata platform.
  • Migration Planing and implemetion from Netezza to Teradata platform by working with the Data Administration group, the SAS Administration and
  • And the Business commercial users, to establish the proper index and table structures, to establish the proper business and technical performance
  • Established the new connection procedures and made to the manuel, and held classes with the business users.
  • Assisted the DBA in defining the new environment and loading the new Teradata tables from the current Netezza environment
  • Developed classes for the Bi Business users.
  • Specializing in SAS automation and modularization of complex financial and quantitative models developed in MS Excel, MS Access, and R Language CCAR Modeling

Environment: SAS 9.3 EG 5.1 SAS Mainframe SAS Window Explorer, SQL, SAS 9.4 EG 7.1 SAS Mainframe SAS Window Explorer SAS/GRAPH 9.4 SAS/STAT 14.2 Performed Sas Coding Support And .

Confidential, Tamp, FL

SAS Consultant

Responsibilities:

  • Migrated SAS Mainframe programs from Rel 8.2 to SAS 9.3 SAS Enterprise Guide 5.1.
  • Converted Programs and trained users in SAS Enterprise Guide 5.1.
  • Specializing in SAS automation and modularization of complex financial and quantitative models developed in MS Excel, MS Access, and R Language

Environment: SAS 9.3 EG 5.1 SAS Mainframe SAS Window Explorer. SAS SPDS, SQL, Worked with the business units to develop requirements gathering for present and future projects.

Confidential, Chicago, IL

SAS Consultant

Responsibilities:

  • Developing application using SAS Enterprise Guide, and SAS Customer Intelligence.
  • Worked with LOB subject matter experts and project team to integrate data into and end-to-end SAS Data Mart
  • Worked with the business units to develop requirements gathering for present and future projects.
  • Specializing in SAS automation and modularization of complex financial and quantitative models developed in MS Excel, MS Access, and R Language CCAR Modeling

Environment: SAS EG SAS, SQL, PC SAS UNIX SAS Mainframe

Confidential, Charlotte, NC

SAS Data Integration Studio Developer

Responsibilities:

  • Developing application using SAS Enterprise Guide and SAS Customer Intelligence.
  • Worked with LOB subject matter experts and project team to integrate data into and end-to-end SAS Data Mart
  • Solution for risk analytics and reporting using SAS Data Integration Studio 4.2.
  • Used Data Integration Studio ETL and traceability features to ensure data validity and auditing for LOB reporting and compliance with Data QA standards.
  • Maintained DI Jobs, scheduling, maintenance and enhancements. ETL procedures to combine all Data and Meta Data components.
  • Worked with the business units to develop requirements gathering for present and future projects, MatLab procedures, All Data warehouse used both DB/2 and Teradata Tables.

Environment: SAS EG, SAS CI, SQL

Confidential, Wilmington, DE

SAS Data Consultant

Responsibilities:

  • SAS Data Consultant working on Pc SAS and UNIX systems processing financial market data.
  • A data analyst performing critical market optimization for the Universe Analytics project
  • There are two types critical processing that I perform, Monthly Universe Analytics Data Extraction
  • Various ADHOC's for many users in the bank.
  • This data is transmitted to our vender Epsilon that provides us with critical credit information that is vital for their important business requirements. We are one the only central processing units, obtain this information.
  • This project consists of coding the new programs and modifying exiting program in SAS 9.2
  • Maintained DI Jobs, scheduling, maintenance and enhancements.
  • Worked with the business units to develop requirements gathering for present and future projects.

Environment: s: SAS 9.2 Base and Macros DB/2 Oracle, SQL, Sybase, and Teradata Data mining, Data Warehouse, and Data Marts, and SAS BI using OLAP processing with linking cubes and hypercube standards. UNIX Linux skills and support knowledge of Bank of American Data warehouse, Project used UNIX Scripting for scheduling of monthly reporting marketing reports.

Confidential, New York, NY

SAS and COBOL Consultant

Responsibilities:

  • SAS and COBOL Consultant working with the MIS Business Marketing Group on numerous Product promotions and reporting. Maintain both Ad-hoc and production systems.
  • Created and maintained Both COBOL and SAS programs using extensive JCL and catalog procedures.
  • Performed and guidance in SAS product methodology, these projects consist of coding the new programs in PC SAS 9.1.3, COBOL.

Environment: s: SAS Base and Macros DB/2, SQL, ORACLE mainframe Solaris and PC SAS 9.1.3 COBOL and JCL and TSO and Clist executions of batch production modules.

Confidential, Greenville, NC

SAS Consultant

Responsibilities:

  • SAS Consultant working on converting current Mainframe Financial Systems to SYSBASE ORACLE BANNER al Systems
  • It involved development and system testing, using system test scripts and extensive reporting on the results.
  • It also included developing regression test cases and Business objects.

Environment: s: SAS Base and Macros DB/2 ORACLE, SQL mainframe Solaris and PC SAS 9.1.3

Confidential, VA

SAS Consultant, Mclean

Responsibilities:

  • SAS Consultant working on the IBM/2064 using SAS REL 9.1 and SAS REL 8.02, DB/2, UNIX and SYBASE Data Warehouse environment.
  • SAS, SAS/AF PROC Report and PROC tabulate with Millions of loan data.
  • This project consists of coding, enhancements and documentations of The Cash Pooling System.
  • It involved development and system testing, using system test scripts and extensive reporting on the results. It also included developing regression test cases, Clist executions of batch production modules.

Environment: SQL SAS DB/2 ORACLE

Confidential, Long Beach, CA

SAS Consultant

Responsibilities:

  • SAS consultant working on the IBM/390 using SAS REL 6.09 and SAS REL 8.01, DB/2 Base SAS, PROC REPORT, and SAS MACROS working with millions of records of car production data.
  • All Reports were down loaded in RTF formats and placed on the customer Web Site using Lotus Notes.
  • This position required production support of the mainframe systems. It also included running daily, weekly, and monthly processes and special Ad Hoc requests. This information, consisting of hundreds of reports monthly, was email to high level customer management in both Sales and production planning in both Toyota and Lexus regions.
  • This assignment involved MVS/DB2 and UNIX ORACLE and PC platforms. It also included converting COBOL file layouts and programs to SAS files.

Environment: SQL SAS DB/2 ORACLE

Confidential, Boston, MA

SAS Consultant

Responsibilities:

  • SAS consultant working on the IBM/390 using SAS REL 6.09, MS ACCESS, DB/2 Base SAS, PROC REPORT, and SAS MACROS, Working with millions of records of medical claims data reporting on the many accounts within the company, SAS REL 8.0. This position used COBOL2 with DB/2 and VSAM files.
  • Also performed SAS Technical, to the many user communities. This assignment involved MVS/DB2 and UNIX ORACLE platforms. Tested

Environment: SQL SAS DB/2 ORACLE Teradata

Confidential

SAS Consultant, Boston, MA

Responsibilities:

  • SAS consultant working on the IBM/390 using SAS REL 6.09, MS ACCESS, DB/2 Base SAS, PROC REPORT, and SAS MACROS
  • Working with millions of records of medical claims data reporting on the many accounts within the company.
  • Also performed SAS Technical, to the many user communities. This assignment involved MVS/DB2 and UNIX ORACLE platforms. Tested
  • SAS REL 8.0. This position used COBOL2 with DB/2 and VSAM files.

Environment: SQL SAS DB/2 ORACLE Teradata

Confidential

Sr.-Programmer Analyst, Kingsport, TN

Responsibilities:

  • SAS BASE and MACRO processing on the OS390 SYSTEMS using SAS Connect to the corporate data warehouse system using SAS Connect to the UNIX platform. Primary responsibilities include providing customer support to the billing department in:
  • All areas of invoice processing, reporting, and audit functions.

Environment: TSO, JCL, SAS BASE, SAS MACROS, SAS/AF, SQL procedures both inner and outer joins. SAS GRAPH, COBOL II,and DB/2 processing. On multiple sales related tables on the UNIX Oracle Data Warehouse Systems.

Confidential

Sr. Programmer Analyst, Chicago, IL

Responsibilities:

  • Confidential SAS Remediation of all data extracts and user programs to change all date fields to SAS dates. SAS mainframe program running under OS390 and PC platforms. SAS EXCEL and Macro Processing.
  • MS ACCESS interfaces for inventory of existing SAS programs and libraries. of Customer
  • Personnel on new and existing program. Planning of interface testing of programs and file Conversions.

Environment: SAS, COBOL II and DB/2 and VSAM processing.

Confidential

Sr. Programmer Analyst, Spartanburg, SC

Responsibilities:

  • COBOL programmer, worked on Confidential project consisting of grading all COBOL Programs Both batch and CICS to Confidential compliance. This project also involved converting programs to VSE/ESA COBOL and COBOL II. This involved both baselines testing and troubleshooting; all systems ran under VM/ESA.

Environment: SQL SAS DB/2 ORACLE

Confidential

Sr. Programmer Analyst, Baskin Ridge, NJ

Responsibilities:

  • Worked on the VTIN-BACK and promotional modeling system using SAS mainframe programs interfacing with COBOL and PL/I flat files. SAS files and SQL procedures.
  • From the large 30 to 120 million record systems, models of customer profiles were developed using random samples of approximately 500,000 billing telephone numbers.
  • The customers were modeled for either win-back or to promote Confidential & Confidential products.

Environment: SQL SAS DB/2 ORACLE

Confidential

Sr. Programmer Analyst, Boston, MA

Responsibilities:

  • Marketing programs for the New York win-back process SAS, DB2, and COBOL mainframe OS390 and PC platforms.
  • Determining the data sources for marketing groups to get a profile of customer activities, to determine what products or services required to keep the customers from removing their lines, both business and residential, to another carrier.
  • The data reports were downloading to Lotus Notes Cristal Reporting and NDM, to other marketing groups, within Confidential .

Environment: SQL SAS DB/2 ORACLE

We'd love your feedback!