Analyst Software

David L. Collins

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

Charlotte, NC 28215

_704_590-5015 work, 704_354-0249 pager

Objective: Seeking challenging Senior Programming or Software Development position, preferably SAS.

Education: Over 15 years in overall data processing including roles as: Computer Operator, Operations Analyst, PC and MVS/SAS Programmer, Software Developer, and Software Consultant

1979-1984 B.A., History at Pfeiffer College. 1997 t o present B.S., MIS at Pfeiffer University 5 credits from degree

_.

Recent Work History:

From:

11/12/97

To: Present

Employer: First Union National Bank

/ Charlotte, NC

Duties: Senior Process Reporting Analyst

: IT Process Analyst III. Used Base SAS, PROCS: SQL, FREQ, APPEND, SORT, TABULATE, FORMAT to automate code and extract and manipulate data. Used PROC REPORT and PROC GCHART to report, track, a nd trend KPI/BPI activity. Modified existing SAS programs to enhance processing efficiency. Produced periodic, summary, detail and adhoc SAS web and hardcopy reports. Performed monthly trend analysis using EIS graphs and charts.__ __Provided data map ping of Oracle databases using VISIO. Installed and documented installation of SAS to various team PCs as well as setting up SAS access/views. Assisted in training junior team members in SAS. Used Oracle PL/SQL to do fast snapshots for client questi ons in querying data. Used Oracle SQL engine in NT/SAS/Server remote submit in processing jobs and downloading to local drive. Did some benchmarking of Oracle Views versus Tables. Used Oracle indexed system as well as locally indexing in SAS. Additi onally, experience in SAS/ASSIST: performing remote/local queries_ defining SAS Access and View Descriptors into Oracle Database via ODBC and documenting this process for reporting team_ creating 3D hierarchial file templates using SAS/EIS for Web repor ting team.__Assisted in Y2K testing on all source code to ensure Y2K compliance. Operational Roles: Primary analyst responsible for SAS Web report automation and generation of Corporate KPI and Business Unit Performance measures. Brainstormed with cus tomers, management, and technical peers to refine quality of existing code efficiency, delivery methods, and tools. Supervised and provided operational, technical, and instructional guidance to junior team members while team ensured quality and timeline ss in delivery of SAS Web and other specialty reports. Business Results: Corporate KPI and Business Unit metrics ensured delivery of hardware/software solutions to all First Union employees. Metrics provided a periodic guide to all in quality perfor mance and significant company cost recovery. Catalyst for overhaul of existing business process data flow. Provided needed reporting documentation_ proposed and assisted in developing Excel client request report matrix.__Built SAS Web reporting templat es using SAS/EIS.__Provided data mapping using VISIO for all Oracle reporting databases. Provided Excel histogram template for Process Management team. Established First Union intra-department partnership for free SAS vendor on-site training in exchang e for consulting services

.

From:

3/85

To: 10/12/97

Employer: Duke Power Company

/ Charlotte, NC

Duties: SAS Programmer / Software Consultant /Administrator

: IT Professional II. Provided primary SAS programming support for ITS department. Used Base SAS, PROCS: FREQ, APPEND, SORT, V5TOV6, PDSCOPY, COMPARE, SOURCE to extract and ma nipulate data. Used

PROCS:

REPORT, TABULATE, PRINT, PRINTTO, FORMAT, SUMMARY to report, track, and trend KPI/CA-7 batch throughput activity. Produced customized and adhoc reports as needed. Extensive use of data step manipulation, merges, formats, some do loop, some array, merges, scans, substrings, indexing and date/time formatting. Wrote JCL and SAS code to extract elements from the MVS/JES2/JHS SYSLOG and SMF files. Used SAS/FORMAT and PUT to convert data into desired allowable values for requ ested output in 80 byte fields. Migrated JCL/SAS programs to production. Primary analyst responsible for reporting all MVS CA-7 Batch activity to align business applications to Corporate KPI goals using MVS/SAS. Created/maintained EXCEL and ACCESS s oftware/hardware inventory spreadsheet for all I/T division. Led full SDLC project implementation of vendor software used in prepping production JCL. This established corporate-wide MVS JCL standards for all production application MVS batch jobs.__JOB/S CAN Administrator and SAS MVS Mainframe site consultant. JHS Administrator: primary role in implementing JHS application into Disaster Recovery system. Operations Analyst: Led cascade project providing audit and company cost recovery. Key player in dep artmental effort to define I/M strategic goals.__Conducted first platform testing of all MVS mainframe software. Provided Local I/T support of MVS application software: SAS, JCL, CA7, CA11, ISPF, IOF, EZTRIEVE, JHS, CHANGEMAN, EZTRIEVE, NDM. Conducted c lassroom and one- on -one sessions training team members, clients, and management: in SAS, CHANGEMAN, and JOB/SCAN

.

985_1992_

Duke Power

_Charlotte, NC__Computer Operator Level I, II, and III: Responsible for CA-7 data base maintenance and client thr oughput. Coded REXX EXECS for MVS Console environment automation. Conducted REXX overview class and teammate training. Installed, troubleshoot, and configured IBM 3090 system hardware. Monitored and controlled the IBM MVS corporate system. Provided Client Help Desk and Network Operations Support

Contact this candidate