Data Sas
Resume:
Randall W. Cartwright
**** ***** **., *****, ** *8184
**************@*****.***
Professional Summary:
SAS Certified Base Programmer for SAS 9.
Over 25 years SAS experience working in a wide variety of environments fulfilling an extensive range of job requirements.
Fully capable of working as part of a team or as an independent programmer.
Professional attitude and behavior interacting with clients and coworkers.
Analytical, logical, structured, creative, mature, and dedicated.
Committed to ongoing learning of new techniques and tools.
Professional Experience:
October 2013 – May 2015 RDA Group Senior Programmer/Analyst
Responsible for downloading, decrypting, and validating data from client sources for use in report programs.
Responsible for running and updating SAS programs to handle generation of data sets and copying data to SQL files. Files are used for mailing satisfaction surveys to auto purchasers for multiple clients and multiple times in service.
Responsible for updating and running survey response rate reports for use by project staff in dealing with automotive clients.
Responsible for creating and running ad hoc reports for use by project staff.
April 2012 – May 2013 Ford Motor Credit Corporation (FMCC) (Contract w/ DPM) SAS Programmer
Created SAS programs on an IBM mainframe to generate master files of Ford credit data for use by FMCC employees. Also created extracts of the master files in SAS CPORT format for transport to the Linux environment. Used PROC FREQ and PROC UNIVARIATE to check validity of data and for future reference.
After FTP’ing SAS files to Linux, used SAS Enterprise Guide to perform transformations in SAS on the CPORT format data to reformat and restructure data. Then used PROC SQL to FASTLOAD data into Teradata tables. Ran PROC FREQ and PROC UNIVARIATE code to perform validity checks on transformed data.
Created improvements to existing SAS code to bring about greater efficiency and accuracy.
August, 2011 – April 2012 Physicians’ Health Plan/Sparrow Hospital (Contract w/ MRI) SAS Programmer
Using SAS Enterprise Guide, tested dozens of SAS programs to verify programs were running correctly for database changeover from Facets 4.21 to Facets 4.81. Made necessary changes to accommodate cases where variables changed names or were eliminated. Documented all changes and coordinated with other programmers doing testing.
Provided SAS support and assistance to other members of IT department.
Assumed primary responsibility for managing continuing requests for special ad hoc reports recording requests in MS Access database, assigning responsibility for creating reports, tracking completion and requestor approval.
Assumed primary responsibility for running regular daily/weekly/monthly standard reports for in-house clients.
June, 2010 – April, 2011 Ford Motor Co.(Contract w/ TTI) SAS Analyst/Developer
Ran series of SAS programs and used program output to create Excel spreadsheets. Programs were SAS code including access of Teradata using PROC SQL, run under UNIX. Checked numbers for consistency and accuracy.
Used spreadsheet results in PowerPoint reports describing performance of quarterly Ford customer magazine. Reports compared responses of customers receiving magazine incentive offers with those not receiving offers. Described results and provide analysis and interpretation.
Presented PowerPoint reports to upper management on a regular basis. Answered questions and provided followup for any concerns.
Reviewed and modified existing SAS programs and Excel spreadsheets to improve efficiency and accommodate changes in quarterly requirements.
August, 2008 – May, 2010 University of Michigan, Kidney Epidemiology and Cost Center (UM-KECC) Applications Programmer/Analyst Intermediate
Created and updated SAS programs to monitor performance of kidney dialysis centers nationwide. Reports showed performance at facility, state, network, and national levels and covered a broad spectrum of measures to assess performance. Monitored internal consistency of reports from month to month.
Unloaded monthly dialysis facility data file from CD and created data files used in facility report generation.
Updated a series of existing SAS programs to make them more efficient and easier to use. Improved code for greater efficiency, added documentation and running instructions. Added macro code to make programs more flexible.
Developed method to download and extract data tables contained in online monthly .pdf file and incorporate the data into existing reports.
Created ad-hoc SAS programs on short notice to provide data to analysts.
Demonstrated extreme flexibility in constantly updating code being created to meet ongoing changes in desired functionality, format, and outcome.
Acquired more extensive programming skills in the use of SAS tools such as PROC SQL, PROC TABULATE, and SAS functions. Also acquired proficiency in Microsoft Visio from online tutorial to create flowcharts for documentation.
Contributed to the creation of documentation for both client and in-house use including researcher’s guides, report descriptions, and final contract reports to clients.
August, 2003 – February, 2008 Auto Club Group (ACG) (AAA Michigan) Senior Data Extraction Analyst
Created ad-hoc and ongoing reports at user request, primarily involving mainframe programming in SAS, Easytrieve, and Quikjob. Modified reports as originally created to make it possible to send reports to corporate shared drive, thus making them more accessible and also saving paper and eliminating redundant distribution. Reports involved SAS programming including accessing DB2 tables with SAS PROC SQL and SAS Macro language.
Using SAS, created demographic analyses of AAA renewing vs. non-renewing members in order to determine demographic groups that would receive targeted AAA renewal information and incentives.
Ran high-visibility reports for Finance department on a monthly basis. Modified programs to select out desired reports and transfer to PC shared drive.
Updated, maintained, and modified existing code to preserve up-to-date status and to accommodate changing requirements.
Updated SAS information tables using interactive SAS and PROC FSEDIT to accommodate continuing changes in user requirements.
Provided SAS and mainframe training to coworkers and in-house clients.
Maintained SAS and MS Excel files denoting AAA branch management alignments in eight-state ACG region.
Created departmental SAS programming standards document and made presentation to departmental staff.
April, 2003 – May, 2003 J. D. Power & Associates(Contract) SAS Programmer
On short-term contract, created SAS code involving SAS Macros and SAS Base to streamline and automate internal J. D. Power analytical and data input procedures. Programs created save hundreds of hours of time for other programmers and analysts. Creation of code required extensive ongoing interaction with J. D. Power end users.
Provided general SAS support.
August, 2000 – September, 2001 Ford Motor Credit Corporation(Contract) Senior Programmer
Coordinated a monthly processing cycle involving over 40 interconnected JCL and SAS production programs processing millions of monthly FMCC records.
Responsible for all JCL/SAS updates and modifications made by self and others.
Closely monitored running of cycle, and made timely corrections to errors when they occurred.
Provided general SAS and mainframe support.
February, 1995 – August, 2000 Blue Cross Blue Shield of MI Senior Analyst
Worked from minimal specifications and under very tight deadline to develop a series of reports to be distributed to thousands of physicians in SE Michigan, determining the disbursement of several millions of dollars in incentive funds. The programs generating these reports entailed over 4,000 lines of SAS code.
Expanded reports to include physicians in other areas of Michigan, increasing the amount of SAS code involved to approximately 15,000 lines
Performed significant amounts of SAS programming for the annual HEDIS report (a major series of self-assessments required of HMO’s for accreditation).
Education:
B.S. (Honors), Physical Geography, U. of Michigan
M.A., Geophysical Fluid Dynamics, The Johns Hopkins University
M.S., Meteorology & Climatology, U. of Maryland
Professional Certification:
SAS Base Programmer Certification November, 2010
Languages:
SAS 9.2, SAS 9.1.2, JCL, FORTRAN77, FOCUS, Easytrieve, Quikjob
Hardware:
IBM Mainframe (3270, 3290), IBM PC
Operating Systems:
OS/MVS, VM/CMS, MS Windows 7, MS Windows 2000, MS Windows NT, DOS, UNIX
Databases:
FOCUS (mainframe and PC), Paradox, MS Access
Software/Ancillary:
TSO/ISPF
SAS BASE, SAS PROCS (e.g., SORT, PRINT, SUMMARY, SQL),
SAS MACRO, SAS STAT, SAS AF, SAS SCL, SAS FSP,
SAS Display Manager, SAS Enterprise Guide
MS Word, MS Excel, MS Access, MS Visio
WinSCP, PuTTY, Teradata SQL Assistant
Training:
SAS/MACRO, 01/91, SAS Institute, Cary, NC
SAS/AF& SAS/SCL, 06/93, SAS Institute, Chicago, IL
Easytrieve Beginning and Intermediate, 10/03, Computer Associates, Chicago, IL
Advanced Topics in the SAS Macro Language, 06/05, Metro Detroit SAS Users’ Group, Livonia, MI
The SAS Output Delivery System for Data Analysts and Statisticians, 06/05, Metro Detroit SAS Users’ Group, Livonia, MI
SAS/Stat Software, 03/06, Metro Detroit SAS Users’ Group, Livonia, MI
Exchanging Data between SAS & Microsoft Products, 03/06, Metro Detroit SAS Users’ Group, Livonia, MI
Professional/Personal Characteristics:
Intelligent, analytical, creative, professional, knowledgeable, persistent, inquisitive, mature, dedicated, calm
Professional Memberships:
Metro Detroit SAS Users Group (MSUG) Member since 1991
Contact this candidate