Resume Details:           Click here for the printer friendly format   Information about the candidate   Click here to request candidate information Resume ID #:  597 Position desired:  Contract Travel:  Weekly Relocate:  Yes Current location:  DC SAS Certifications SAS Certified Base Programmer™ V9 SAS Certified Advanced Programmer V9 SAS version experience SAS Version 5 SAS Version 6 SAS Version 7 SAS Version 8 SAS Version 9 SAS Product Experience AppDev Studio™ Software Base SAS® SAS® Data Quality - Cleanse software Enterprise Guide® Enterprise Miner™ Enterprise Reporter® SAS® Integration Technologies SAS / ACCESS® software SAS / AF® software SAS / CONNECT® software SAS / GRAPH® software SAS QC® software SAS / STAT® software SAS / Warehouse Administrator® software Industry Experience Automotive for 2 year(s) Financial Services for 5 year(s) Pharmaceutical and Biotechnology for 1 year(s) Public Sector for 2 year(s) Retail for 1 year(s) Telecommunications for 2 year(s) SAS functional experience Implementation Consulting Upgrades End-user Training Functional Production Support SAS technical experience SAS system administration Develop and modify SAS programs SQL programming skills Technical production support SAS software experience:  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. Excel Energy, Minneapolis, MN 1/2005 – 12/2005 System Conversion Consultant • Worked on the PeopleSoft 8.8 HR, Payroll, Time and Labor and Benefit conversion project. • Upgrade COBOL, SQR, and Natural programs from legacy to PeopleSoft. • Designed and tested UNIX shell script to replace MVS JCL to re-platform from MVS to UNIX. Yum Brands, Louisville, KY, 7/2004 - 12/2004 System Conversion Consultant • Coded conversion programs from GEAC legacy system to PeopleSoft Financial modules, such as Asset Management, Project, etc, using SAS, SQR, JCL, SPUFI, etc, in DB2 MVS environment. • Used GEAC Report Writer to extract user required data and used SAS to further process data on the generated reports and transformed and load the data into new PeopleSoft Asset Management. PNC Bank, Pittsburgh, PA 9/2002 – 6/2003 System Conversion Consultant • Converted GL and asset management data from GEAC legacy to PeopleSoft Financials. • 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. Thrivent Financial, Minneapolis, MN 10/2001 - 8/2002 System Conversion Consultant • Worked on the PeopleSoft HRMS conversion project from Tessaract legacy to PeopleSoft version 8. • Coded extract, transform and load programs in SAS, COBOL, JCL and TSO. Used SAS data steps, custom formats, data null steps to write processed data into files that can be loaded into PeopleSoft. • Designed mapping between legacy HR and payroll data in VSAM and file trailer format into relation database tables in SQL Server and PeopleSoft HRMS. USDA, Washington, DC 1/1997 - 10/1997 SAS Programmer • Programmed SAS programs in UNIX environment for data analysis for US farm manure management. Used SAS data steps to process complex data and used regression procedures to analyze nutrient factors affecting yields by crop types. Prudential Mortgage Frederick, MD 1/1996 - 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, Arlington, VA 5/1992 - 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 SAS merge, update and format library to retrieve data from various sources, such as master and transactional data on MVS mainframe. • Used Mainframe development tools, such as File Aid, SyncSort, VSAM, etc. Kaiser Permentente, Washington, DC11/1991 - 4/1992 Clinical Data Analyst • Provided technical support for clinical research projects, such as database design, queries, adhoc reporting, data validation, software installation, setup and configurations as well as technical training. Ford Motor Company Dearborn, MI 1/1989 - 7/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. • Used in SAS to manipulate data from sources and leveraged various SAS data formats. Non-SAS general professional experience:  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, 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. Excel Energy, Minneapolis, MN 1/2005 – 12/2005 System Conversion Consultant • Worked on the PeopleSoft 8.8 HR, Payroll, Time and Labor and Benefit conversion project. • Upgrade COBOL, SQR, and Natural programs from legacy to PeopleSoft. • Designed and tested UNIX shell script to replace MVS JCL to re-platform from MVS to UNIX. Yum Brands, Louisville, KY, 7/2004 - 12/2004 System Conversion Consultant • Coded conversion programs from GEAC legacy system to PeopleSoft Financial modules, such as Asset Management, Project, etc, using SAS, SQR, JCL, SPUFI, etc, in DB2 MVS environment. • Used GEAC Report Writer to extract user required data and used SAS to further process data on the generated reports and transformed and load the data into new PeopleSoft Asset Management. Thrivent Financial, Minneapolis, MN 10/2001 - 8/2002 System Conversion Consultant • Worked on the PeopleSoft HRMS conversion project from Tessaract legacy to PeopleSoft version 8. • Coded extract, transform and load programs in SAS, COBOL, JCL and TSO. Used SAS data steps, custom formats, data null steps to write processed data into files that can be loaded into PeopleSoft. • Designed mapping between legacy HR and payroll data in VSAM and file trailer format into relation database tables in SQL Server and PeopleSoft HRMS. American Red Cross, Falls Church, VA 4/1999 - 9/2001 SQR/Crystal Report Developer • Worked on the PeopleSoft HRMS, Payroll and Pension/Benefit systems on UNIX/Oracle. • Developed custom reports and interfaces using SQR, Crystal reports, MS Access and SQL Plus. Shared Medical Systems, Omaha, NE 11/1998 - 3/1999 SQR/EDI Developer • Worked on the PeopleSoft Financial, GL, AR, AP, Inventory, Purchasing, Budget, HR and Payroll implementation team as a technical developer. • Configured custom EDI setup for sending purchase orders using VendorCom, GenTran, and SQR. Work History Freddie Mac       4/2005 to 4/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       9/2002 to 6/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       1/1996 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       5/1992 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       1/1989 to 7/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 Oakland University - Rochester, MI Master Of Science in Statistics Candidate's Professional training  Click here to request candidate information                         Back to top Questions or comments? Please feel free to contact Implementation Services Group, Inc. at 512/656-7787 or email eric.krohn@sasresources.com Implementation Services Group, Inc. is not affiliated with The SAS Institute, Inc. in any manner. SAS and all other SAS Institute, Inc. product or service names are registered trademarks of SAS Institute, Inc. in the USA and other countries. ® indicates USA registration. Copyright © 2000 - 2010 Implementation Services Group, Inc. Implementation Services Group, Inc. 2423 WestLake Dr. Austin, TX 78746 1-800-474-7079