Resume Detail

Back To Resumes

About The Candidate

Resume ID #: 597
Current Location: Germantown MD
Position Desired: Contract
Travel: Weekly
Relocate: Yes
Experience
SAS Experience
SAS Version5x, 6x, 7x, 8x, 9x
SAS Certifications
SAS Certifications
SAS Certified Base Programmer for SAS 9
SAS Certified Advanced Programmer for SAS 9
Other Experience
Industry Experience
Automotive
Implementation Consulting
Upgrades
Financial Services
End-user Training
Functional Production Support
Pharmaceutical and Biotechnology
Public Sector
Retail
Telecommunications
SAS Experience
System Administration
SQL programming skills
SAS Product Experience
AppDev Studio™ Software
Base SAS®
SAS® Data Quality - Cleanse software
Enterprise Guide®
Enterprise Miner™
Enterprise Reporter®
SAS® Integration Technologies
SAS / ACCESS®
SAS / AF®
SAS / CONNECT®
SAS / GRAPH®
SAS QC®
SAS / STAT®
SAS / Warehouse Administrator®

Work History

Freddie Mac 04/04 to 04/2007
SAS Programmer
Developed data extracts of various data sources and loaded into financial data warehouse. Developed programs for account reconciliations process to compare accounting entries between mainframe and PeopleSoft. PeopleSoft entries were queried via SQL, and mainframe data was extracted by SAS programs. Conducted code reviews and tuning on various programs including SAS, SQL, and COBOL.
PNC Bank 09/06 to 06/2003
SAS Programmer
Use SAS on MVS mainframe to extract legacy financial data into files and used DB2 loader to load data into DB2 tables required by PeopleSoft implementation. Transformed legacy data into PeopleSoft translate fields, including code translation, date formatting, data set selection and merging, and SAS macros processing, and file creation.
Prudential Mortgage 01/12 to 12/1996
SAS Programmer
Provided systems support for corporate accounting. Responsibilities include report creation using SAS, DB2, SPUFI and Focus in an MVS mainframe environment. Performed monthly file creation using SAS and maintained GDGs using SAS and JCL.
MCI 05/12 to 12/1995
SAS Programmer
Developed applications such as account auditing tools in SAS JCL, CLIST, TSO,and ISPF Panels. Developed various modules, user interfaces, queries, data validation routines and reports. Used Mainframe tools, such as File Aid, SyncSort, VSAM.
Ford Motor Company 01/07 to 07/1991
Statistical Data Analyst
Conducted statistical data analysis using various statistical distribution models, regression, ANOVA, GLM, MEANS, UNIVARIATE, and SAS plots and charts to improve product reliability and quality.

Education and Professional Training

Oakland University / to /
Rochester MI
Master Of Science in Statistics

SAS Experience Narrative

Freddie Mac, Vienna, VA 4/2005 - 4/2007
Software Engineer

• Developed data extracts of various data sources and loaded into financial data warehouse.
• Developed programs for account reconciliations process to compare accounting entries between mainframe and PeopleSoft. PeopleSoft entries were queried via SQL, and mainframe data was extracted by SAS programs.
• Conducted code reviews and tuning on various programs including SAS, SQL, and COBOL.

Target, Minneapolis, MN 11/2004 – 3/2005
System Conversion Consultant

• Worked on the PeopleSoft 8.8 HCM and EPM conversion team as a consultant.
• Created data mappings to convert history data from Tesseract to PeopleSoft HCM and EPM.
• Used SAS ETL to manage ETL process flows for the extraction, transformation, and loading of data from various sources into PeopleSoft data warehouse.
• Used Base SAS, SAS/ACCESS and SAS/CONNECT for code execution, access SAS data and DBMS data, and interaction with remote libraries.

E<

Non-SAS Experience Narrative

USDA, Beltsville/MD, 3/2008 – 2/2009
Software Engineer

• Used ClearQuest to manage web design, application lifecycle development defect submission, defect tracking, change request, program migration, querying, reporting and design documentations.
• Customized Employee workflow in HR systems to automate employee actions.
• Developed technical services and business services in ERP web service registry to expose the functionality of existing systems using JAVA, XML and WSDL.

State of Tennessee, Nashville/TN, 5/2007 – 2/2008
Software Engineer

• Designed various interfaces via Integration Broker to facilitate data and service exchanges between payroll and financial systems using request-response operations. Asynchronous integrations allow financial systems to be updated after each payroll cycle to keep accounting data synchronized between these systems.
• Developed interface from Financial Speedcharts to HCM TL Task Profiles, using integration Brokers technology.

Target, <