SUMMARY:

• 15+ years as an experienced intermediate - level SAS Programmer Analyst and Data Analyst in a custom applications development capacity and in a support capacity within Healthcare and Financial and Insurance Domains using Mainframe DB2 Databases and ORACLE Databases.
• Specialize in SAS Programming, Advanced SAS Macros, SAS Enterprise Guide (SAS EG), Mainframe, UNIX, ORACLE programming. Have UNIX Shell Scripts programming experience.
• 5 YEARS OF RECENT SAS EXPERIENCE; 2 recent assignments (totalling 1 year) have been with SAS; worked with SAS for 3 years at CITI/Smith Barney (from ) and for 1 year at BNY Mellon as well. I am currently preparing (at home while not on assignment) to take the SAS Exam; I have PC/SAS COMPILER installed at home.
• I am a SAS Code contributor on the SUGI Website
• Specialize in producing/modifying/running/distributing Client Performance Reports for Financial Analysts in the Wealth Management and ETL DataWareHouse spaces.
• Specialize in deciphering and documenting old complex code.
• Energetic and self-starter and motivated and conscientious and focused.
• Quick learner; very resourceful—know where to go to find the answer; very good with problem research and root-cause analysis and resolution.
• Global experience analyzing and resolving software issues in a 24X7X365 environment (Onshore-Offshore Business Model).
• Passion to meet the needs of the business and deliver a useful product/tool to the business user on time and to provide top-notch production support.
• Passion to solve challenging complex production and business problems quickly.

TECHNICAL SKILLS:

Technology and Tools: Base SAS, SAS MACROS (5) SAS ENTERPRISE GUIDE (6 months) SAS PROC/SQL and SAS LIBNAME for data extraction (5) DATA ANALYTICS (5) COBOL / COBOL2 (15+) CICS Applications Programming / BMS / SDF I and II (15) VSAM (15+) DB2 Applications Programming and SQL; SPUFI; QMF (15) DB2 Stored Procedures (1) DB2 Utilities (10) JCL, Utilities (15+) EZTRIEVE+ (2) Mainframe (15+) ORACLE and PL/SQL and SQL*PLUS (2) ETL / Data Warehousing (4) UNIX (3) UNIX Shell Scripts (6 months) REXX and CLISTS (15+) IBM BAL (aka ALC or Assembler Language) ISPF Dialog Manager (3) FILEAID (10+) EXPEDITER, INTERTEST, IBM DEBUG TOOL (10+) CHANGEMAN, ENDEVOR (15+) MQSERIES (2) FTP (3) Financial Industry Exp. (10+) Client Performance Reporting (3) Wealth Management (5) Capital Markets and Fixed Income Experience (5) Healthcare Industry Exp. (7) SDLC (20+) Production Support (15+) PeopleSoft SQRibe (3) Microsoft Office (15+) System Documentation (15+)

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

Mainframe Applications Programmer/Analyst

Responsibilities:

• For the COPAY Benefit Pricing System, working on technology gaps created by the merger; merging the systems from a data and programming perspective thereby providing the same look-and-feel for the users. Working with the offshore as well. Coding in COBOL, CICS, DB2, VSAM, JCL, SPROCS. Performing Development and Production Support tasks.
• Used SQL*PLUS and SQL DEVELOPER and PL/SQL to write/update packages and to write/update Stored Procedures, Functions and Triggers that went against the ORACLE Database/Schema. Used SQL*PLUS to create the DDL necessary to create ORACLE Tables and Views and Indexes and Triggers and Stored Procedures and Functions and Triggers. ORACLE Version used was ORACLE 11G.
• Converted 50 SQL SERVER SPROCS to ORACLE SPROCS. Additionally defined and loaded the ORACLE tables and views via SQL LOADER for this project.

Environment: ISPF/TSO; COBOL; CICS; DB2; VSAM; JCL; SPROCS; ENDEVOR; ORACLE; PL/SQL; SQL*PLUS; SQL SERVER.

Confidential, Iselin, NJ

SAS Programmer and Data Analyst

Responsibilities:

• Worked with data from the Operations Dept and the Capital Markets Dept in a ETL DATA WAREHOUSE and read/created SAS Tables/Views and ORACLE Tables/Views and EXCEL SS's and sent final result to Risk Analysts
• Performed weekly, monthly and adhoc SAS/ORACLE/UNIX production support—submitted, monitored and verified Interactive and Batch SAS jobs run on UNIX platform (that performed data extraction and that made extensive use of SAS MACROS for data quality). The predicative model used was called short-sale solicitations. Submitted and wrote SAS Jobs that were triggered by UNIX Shell Scripts.
• Wrote a SAS utility that looked at our job’s logs so as to gather runtime statistics so as to report on how long each PROCS step within our SAS jobs were taking to run/execute.
• Extensively used SAS and SAS/ACCESS and PROC SQL and LIBNAME (created views/table from remote ORACLE data) and SAS ENTERPRISE GUIDE (SAS EG) and ORACLE and TOAD in a UNIX environment and PC SAS in a Windows XP environment. Used PROC SQL and LIBNAME for data extraction. Used SAS ENTERPRISE GUIDE to view the predicative data model.
• Created EXCEL Spreadsheets using Advanced SAS MACROS and ODS and PROC PRINT and PROC REPORT
• Utilized Base SAS 9.2
• Created, modified SAS MACROS / subroutines (that were stored in MACLIBS) for other developers on my team; they would use %INCLUDE and or supply the SASAUTOS option to them within their SAS coding.
• Used PROC SORT and PROC FREQ and PROC MEANS and PROC SUMMARY to identify and eliminate variables that had duplicate and/or missing values.
• Ran WINDOWS/UNIX commands within SAS via the X command
• Used the UNIX SCREEN utility and Putty for Batch job submittal
• Used WINSCP to navigate UNIX and to transfer files
• Setup UNIX Shell Scripts for Batch SAS/UNIX Job submittal

Environment: SAS, PC SAS, SAS MACROS, SAS ENTERPRISE GUIDE, UNIX, Windows XP, ORACLE.

Confidential, Weehawken, NJ

Mainframe Applications Developer

Responsibilities:

• Worked on the Cost Basis Project which was a Fixed Income Project; performed data cleansing and data remediation and repairing of production TAXLOT data.
• Utilized COBOL, DB2, JCL, Utilities, Advanced SORT and ICETOOL, MQSERIES, Stored-Procs while performing maintenance on existing programs and JCL.
• Wrote a Mainframe Production Support Utility for the TAXLOT users that utilized SAS and JCL and REXX and ISPF Dialog Manager and FTP and PKZIP to create Realized and Unrealized Tax Lot Reports in HTML/EXCEL/PDF/XML formats and email these reports (via SAS) to the requesting user and FTP’ed these reports to their server (via SAS). This utility gathered/validated the user’s requests (the input read was mainframe GDG’s and MVS information) and submitted batch SAS jobs to MVS. Created IDCAMS input with SAS (LISTCAT commands) and executed program IDCAMS within SAS; done so as to get the absolute GDG Name and GDG Creation Date within SAS. Used INFILE/FILEVAR so as to read multiple PDS members. Dynamically created PROC FORMATS within SAS.
• Added PKZIP utility to this SAS utility so as to compress the email attachments to assure email delivery
• Utilized Base SAS 9.1 and ODS and Proc DATA, NULL, FORMAT, SORT, PRINT, FREQ, TABULATE, APPEND, TRANSPOSE, PROC/SQL and LIBNAME (database was DB2), CONNECT, MEANS, REPORT, SUMMARY; and Advanced SAS MACROS and arrays and informats and formats and functions (to enforce data quality and to reduce code repetition and to create modular code). Utilized FILENAME and INFILE and INPUT and SET within SAS to read raw data; and FILE and PUT to write reports in SAS. Used IF statement and WHERE statement so as to subset the data within SAS datasets. Used MERGE statement within DATA step for joining data; and MODIFY statement (with indexes and keys) and UPDATE statement to update data within SAS datasets. Created SAS indexes on SAS datasets and used them while reading SAS datasets. Used PROC FORMAT (including the CNTLIN option) for table lookup. Used PROC SORT and PROC FREQ and PROC MEANS and PROC SUMMARY to identify and eliminate variable that had duplicate and/or missing values.
• As data flowed thru DATA and PROC steps, have dropped/kept variables; changed their informat, when necessary, from number to character or character to number (involved a PUT or INPUT function, and a RENAME and a DELETE); extracted desired data via WHERE and IF statement; sorted and de-duped data; used SAS functions to trim the data and/or to give the column an aesthetic format at print time; decoded numbers or codes (via the PROC FORMAT) at print time; aggregated/summarized the data via PROC MEANS/SUM and/or PROC SQL.
• Worked with large SAS tables/views/data; tweaked the SAS dataset’ indexes. FTP'ed SAS reports from the Mainframe to the PC for problem-research and problem-resolution and for data-analysis

Environment: ISPF/TSO; SAS; COBOL; DB2; SPUFI; VSAM; JCL; UTILITIES; IBM DEBUG TOOL; FTP; REXX; ISPF DIALOG MANAGER; PKZIP

Confidential, New York City, NY

Mainframe Applications Programmer/Analyst

Responsibilities:

• Intensive research and installation and customization and testing of and presentation of IBM DEBUG TOOL V10 (for CICS and BATCH)
• Setting up IBM DEBUG TOOL V10 for CICS/COBOL modules and CICS/Assembler modules
• Performed migration of some ASSEMBLER programs that had ADABAS Direct CALLS to COBOL DB2
• Rewrote a critical Batch/Assembler “poorly performing” process in COBOL/DB2
• Worked on CICS TS 3.2 migration issues
• Created “recommendations for CICS TS 3.2 in a highly available environment” document
• Used Tivoli Workstation Scheduler (TWS) to schedule mainframe batch jobs

Environment: ISPF/TSO, z/OS 111; COBOL; CICS TS 3.2; IBM DEBUG TOOL V10; VSAM; ADABAS/NATURAL; DB2; SPUFI; JCL; ASSEMBLER; TWS

Confidential, Jersey City, NJ

Mainframe Applications Programmer/Analyst (Contract)

Responsibilities:

• Converted many legacy CICS/VSAM/DB2 programs to COBOL/DB2 Stored Procedures
• Worked with the COE offshore staff who wrote the companion JAVA front-end components that triggered our COBOL/DB2 Stored Procedures
• Used DB2CONNECT and Stored Procedure Builder to test Stored Procedures
• Wrote COBOL/DB2/VSAM programs
• Wrote programs to parse XML files from distributed systems; sent XML files to them as well
• Coded a Secure FTP JCL Job, JCL Proc and COBOL/DB2/VSAM program
• Extensively tested all of these new and/or modified components

Environment: ISPF/TSO, OS/390, COBOL, CICS/VSAM, DB2, DB2 Stored Procedures, Stored Procedure Builder, SPUFI, QMF, JCL, Changeman, FTP, Secure FTP

Confidential, NYC, NY

Mainframe Applications Programmer/Analyst (Contract)

Responsibilities:

• Performed full SDLC for each SQRibe modification (and corresponding JCL changes) that included analysis; BRD’s; FRD’s; data-analysis and data-mapping via SPUFIS and QMF; estimates; development; unit and system testing; Q/A testing; documentation; implementation (via CHANGEMAN); and support
• For the Morgan Stanley Joint Venture Effort and for the Pershing Conversion: Made major revisions to the SQRibe programs and to the SAS programs and the COBOL CICS/VSAM DB2 programs and JCL Jobs and Procs (which contained EZTRIEVE+)
• Worked with the Data-Masking/Data Obfuscation/Data Redacting Team to encode/scramble customer’s names and SS#’s
• Wrote a COBOL/DB2 program that invoked a Stored-Procedure that, given employee#, returns his EMAIL
• Ran monthly and quarterly adhoc UNIX/PERL/FTP processing which posted the resultant reports to the FOCUS website
• Solved numerous mainframe SQRibe production problems via root cause analysis
• Modified UNIX Shell Scripts in accordance with business needs
• Modified an APL program on VM
• Modified and wrote many mainframe-based SAS programs using Base SAS Procs Version 9 (and wrote SAS MACROS as well) for a Mutual Funds application
• Modified mainframe-based SAS programs pursuant to the 529 Plan Student Loan regulatory changes
• Wrote, tested and implemented two Mainframe-Based Secure FTP processes that sent success notifications to a UNIX server upon successful completion of mainframe processing
• Onshore-Offshore Business Model

Environment: ISPF/TSO, OS/390, COBOL, CICS/VSAM, DB2, DB2 Stored Procedures. SPUFI, QMF, JCL, Changeman, FTP, Secure FTP, PeopleSoft SQRibe; ETL; DATAWAREHOUSE

Confidential, Weehawken, NJ

Senior Programmer/Analyst (Contract)

Responsibilities:

• Provided DB2 tables and programming that allowed users to change the account’s CAP limit, to produce reports detailing these CAP limit changes, to add average daily balance and APY earned and interest paid to the statement (within the interest-payout-section), to send this modified statement to the Statement System, and to override the money manager tier
• Performed documentation/analysis/research of the existing system's programs/jobs/procs/data/DB2-tables and performed analysis of the new system
• Created several analysis-related EXCEL spreadsheets
• For the data analysis, created and executed complex ADHOC jobs. All of these results were used to complete the new system's specifications
• Wrote and tested several Batch COBOL DB2 programs that updated the database and wrote and tested several utilities so as to check out the results of these DB2 programs’ database updates
• Used SPUFI's, BMC Tools; PLATINUM; JCL/UTILITIES/SORT; COMPAREX; the firm's match-merge utility; DYL280; MQSERIES
• Attended an IBM-DEBUG Tool Course

Environment: ISPF/TSO; OS/390; COBOL/3; DB2; SPUFI; PLATINUM; JCL/UTILITIES/SORT; Changeman; OPC; CICS/VSAM; IBM-DEBUG-Tool; COBOL DB2 Stored Procedures; COMPAREX; DYL280; IBM DEBUG Tool; MQSERIES

Confidential, New York City, NY

Senior Programmer/Analyst

Responsibilities:

• For the Data-Masking Project: Compared mainframe files via FILEAID and IBM SORT and IBM ICETOOL Utilities

Environment: ISPF/TSO, OS/390, JCL, SORT, ICETOOL, FILEAID

Confidential, New York City, NY

Senior Programmer/Analyst (Contract thru SATYAM)

Responsibilities:

• Responsible for Maintenance, Development and Support of General Ledger, Accounting, Book-Keeping and Balance and Control Reconciliation Systems, Profit and Loss (P & L) Systems, Government Operations Back-Office Systems, and Tax Systems in a Brokerage/Investment Banking environment where report production was time critical
• COBOL, JCL, CICS/VSAM, DB2 and DB2 Utilities, SPUFI, PLATINUM, Changeman, COMPAREX; COBOL Stored Procedures, SQL Stored Procedures in an IBM DB2 Stored Procedure Builder platform
• Wrote numerous complex SPUFIS and complex programs to meet the business needs
• Produced Trade and Book-Keeping Reconciliation reports via querying ADP structures and via querying Book-Keeping and Trade Warehouse DB2 Tables and via reading the street security master file called the MSD
• Performed data conversion due to DB2 table modifications
• Converted a huge non-partitioned DB2 table to a partitioned DB2 table
• Added income and counter-party information to our DB2 table which came from numerous sources (via writing numerous programs, JCL streams, utilities), and wrote/produced report programs that reported on this DB2 data
• Produced flexible dynamic Book-Keeping Journal Reports
• Modified data-entry CICS programs/screens to support new report parameters and report security access
• Added new banks to proprietary Merva process
• Worked with ISO SWIFT Category 5 message types
• Added new reconciliation reports whenever new accounts came on
• Made major Good Friday enhancements to our systems
• Made major Letter of Authorization workflow changes
• Fixed numerous production problems
• Saved users weeks of manual checking via re-writing program so that the TAX-seasonal report could be reset upon discovery of external system’s input data problems
• Created COBOL programs that produced dynamic LOAD/UNLOAD/IMAGE-COPY cards for our partitioned DB2 table
• Wrote an extensive Control-M Keystroke Language Utility
• Attended an EXCEL VBA Course
• Attended a ClearCase class
• Performed extensive production coverage and extensive system documentation as well

Environment: ISPF/TSO, OS/390, COBOL, DB2 and DB2 Utilities, SPUFI, PLATINUM, JCL, CICS/VSAM, SQL, Stored Procedures, Changeman, Control-M

Confidential, New York City, NY

Senior Programmer/Analyst (Contract)

Responsibilities:

• Did full project-life-cycle for and migration of a VM-Based REXX/Dialog-Manager ISPF Application to MVS
• Coded in REXX, ISPF Dialog-Manager, COBOL, JCL, and FTP. Wrote FTP Scripts from the Mainframe to UNIX WEB Servers
• Performed extensive testing and created comprehensive test-scripts
• Wrote all of the project documentation and wrote the /turnover document for the Production-Coverage team

Environment: OS/390; Endevor; VM/XEDIT; ISPF/TSO; REXX; Dialog-Manager; COBOL/LE

Confidential, Edison, NJ

Senior Programmer/Analyst (Contract)

Responsibilities:

• Aggregated huge DB2 Tables in a Data Warehouse system
• Wrote numerous SPUFIS
• Wrote file-compare utilities and SORTS
• Wrote a COBOL utility to update load cards with the partition number that corresponded to the data and to update unload cards with the dates that corresponded to the data and deployed this utility successfully within several existing and new job streams
• Wrote several other COBOL programs for this aggregation effort
• Used LOAD/UNLOAD DB2 Utilities
• Did routine COBOL program and job/proc modifications
• Evaluated a PC product called USPS AIRS and wrote mainframe utilities and programs for it
• Wrote SAS programs and procedures. Utilized PROC SQL and LIBNAME for data extraction.
• Wrote EASYTRIEVE procedures

Environment: OS/390; TSO/ISPF; Windows Y2K; COBOL2 and COBOL3 and COBOL/LE; JCL/Utilities/SORT; DB2, SPUFIS and DB2-Utilities; SAS/Easytrieve; PANVALET; EXPEDITER

Confidential, New York City, NY

Senior Programmer/Analyst and SAS Programmer (Employee)

Responsibilities:

• Designed, coded, implemented and enhanced an online and batch system to enable the user to recall archived trades; this system used COBOL/CICS/VSAM/JCL/Utilities/REXX/OPC. Prior to this effort, constructed/tested a design/proof-of-concept utilizing the On-Demand API within the CICS application
• Regarding a DB2 into VSAM integration project on the CICS test-system: Worked with systems to design, code and test a CICS GLUE/TRUE Exit; designed and wrote the supporting application code that processed the old system’s VSAM file updates by invoking DB2 Stored Procedures to update the corresponding new system’s DB2 tables. Prior to this effort, evaluated a Compuware Product called Change Data Mover
• Made major revisions to the test-system compile panels and REXX-EXECS to facilitate DB2; wrote several TSO/ISPF productivity tools for the group (e.g., wrote a Test CICS Region Restore-From-Prod-Backups Utility); wrote a CICS utility to switch remote resources from one test-region to another; aligned all test regions with production; worked on the CICS Error Recovery project for the application
• Documented a large group of programs that were part of a CICS Transaction
• Attended MQ-Series classes and wrote an MQ-Series program
• Wrote a SAS program and procedure; utilized PROC SQL and LIBNAME for data extraction.. Wrote EASYTRIEVE procedures
• So as to solve a CICS file contention problem, wrote a CICS/BAL module to obtain a unique number that the affected programs would CALL

Environment: OS/390; TSO/ISPF; Windows NT; COBOL2 and COBOL3 and COBOL/LE; CICS; VSAM; DB2, DB2 Stored Procedures, SPUFIS; REXX and ISPF Dialog Manager and Edit Macros; JCL/Utilities/SORT; BAL; MQSERIES; SAS/Easytrieve; OPC; ON-DEMAND; ENDEVOR; EXPEDITER; FILEAID; FILEAID/DB2; COMPAREX; MQSERIES