SAS programmer and DBA Resume

SUMMARY:

Specializing in SQL access, automation and performance tuning for both IBM Z/OS and AIX/UNIX Environments. Proven track record in innovative problem solving, coding and design. Organizational leader with 100% dedication to follow through and getting the job done.

TECHNICAL EXPERTISE:

HARDWARE: IBM Mainframe Z/OS, IBM AIX Power 7

SOFTWARE: COBOL, DB2, SQL, OS JCL, TSO, SPUFI, QMF, ORACLE, AIX/UNIX, SAS, GPFS, IMS/DB/DC, VSAM, Confidential, BMC, PLATINUM, CA7, OMEGAMON, APPTUNE, BUSINESS OBJECTS, HSM/TSM, XPEDITER,INTERTEST, ASSEMBLER, MQ SERIES, ENDEAVOR, REXX, IBM QUERY MONITOR, ERWIN, VISUAL BASIC, PEOPLESOFT, XCHANGE CAMPAIGN MANAGEMENT, GOLDEN GATE, TIBCO BW

PROFESSIONAL EXPERIENCE:

Confidential

SAS programmer and DBA

Responsibilities:

Team member on Confidential System (Retail Unit tracking system)…creating/enhancing various sub processes such as the ATS system, Reservations, Data Archival and Purge, Confidential Confidential inquiry/update screens, Balance processes…etc.
Redesigned Confidential Online Update processes to utilize TIBCO BW processes to remove Mainframe dependencies and to enhance Product availability.
Created High Level Design to migrate Confidential Customer and Audit tables from the Confidential to Unix/ Oracle.
Provided 24 x 7 Production on call support

Confidential

SAS programmer and DBA

Responsibilities:

Developed and coded ETL programs/processes to extract all File System data, HMS storage data and System Performance/Configuration metrics; creating SAS Datamarts with scheduled loads into Oracle and DB2 Databases for Confidential to be used by System Administrators.
Designed and coded HSM/TSM “Spin” reports detailing present and historical space utilization.
Analyzed SQL and SAS performance logs recommending/implementing modifications and performance tuning enhancements.

Confidential

DB2 Z/OS DBA and Cobol/DB2 programmer

Responsibilities:

Author of Confidential, a parameter driven DB2 Database Performance and analysis solution, which analyzes DB2, Vsam and Space statistics and automates Confidential Re - orgs, DB2 Utilities and Analytic Reports. Confidential has been in production at Confidential for over 14 years, monitoring over 10,000 DB2 tables weekly, with many tables over 1 billion rows, and consistently maintains the tables at a minimum of 97% efficiency.
Worked as a Programmer/DBA on multiple application teams, which resulted in better performing programs, highly efficient database physical design.
Developed franchisee invoice reports, customer statements, 3 rd part Vendor feeds and many other reporting processes for Confidential .
Mentored and assisted application teams in all development/maintenance and DB2/SQL training from design, programming techniques, SQL performance recommendations, Stored Procedures, Confidential, triggers, bind considerations and strategies, DB2 Utilities, DB2 version upgrades, etc.
Specialized in coding for performance and automation in both SQL, COBOL etc, utilizing my extensive DBA/SQL experience and knowledge.
Implemented Golden Gates Data Replication tool (similar to DB2 Data Propagator) to support 2-Way data transfer from AIX Oracle and Mainframe DB2 databases
Created many SQL processes for both DB2, and Oracle, supporting Informatica Teams.
Leader in Disaster Recovery procedures reducing recovery time from 72 hours to 5 hours.
Provided 24X7 on-call DB2 DBA and application support for many production environments.
Developed vast experience with Migration techniques and tools from Mainframe to Open Systems.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship