SUMMARY

• Looking for a position that will challenge my SAS skills in Base SAS, Macro, ODS and SQL on UNIX, Windows, and Mainframe platforms.
• Experienced in using Base SAS to do ETL processing (Extract, Transform, and Load). Developed SAS SQL Data retrieval from Oracle, Sybase, Teradata, Netezza, and SQL Server databases as well as flat files
• Excel Spreadsheet files for the gathering, processing, and reporting of data.
• Developed process automation using UNIX shell script applications.
• Experienced in analyzing SAS code developed by someone else and repairing, converting, and upgrading the code.
• Proven ability to deliver and solve problems under tight deadlines while also learning new Business Processes.
• Assisted personnel as a UNIX and SAS knowledge resource.

PROFESSIONAL EXPERIENCE

Confidential

SAS Programmer/Data Analysis

Environment: SAS 9.1.3 & 9.3, SQL Server, Oracle, & DB2 DB

Responsibilities:

• Create Mainframe SAS Code and SQL queries for Partnership Benefit Monitor Control projects. Data was extracted from Production Mainframe GDG tapes, DB2 Data Warehouses, and Production Datasets..
• Responsible for the Monthly Running and Distribution of the Control Reports for the Benefits Triage group. .
• Responsible for the Creation and update of the Documentation of the Control Report Process.

Confidential

SAS Programmer/Data Analysis/SAS Admin

Environment: SAS 9.1.3, SAS EG 4.1, Oracle, Teradata, Netezza, & DB2 DB. UNIX & Windows XP & 7.

Responsibilities:

• Create SAS Code and SQL queries for senior statistician for fraud detection projects. Data was extracted from Teradata and Netezza Data Warehouses.
• SAS Admin of SAS Server for both SAS Foundation and SAS EG.
• Install both SAS EG and SAS E-Miner onto end users Windows platforms.
• Responsible for 24/7 application support of Marketing and Finance SAS Reports from Oracle databases

Confidential

SAS Programmer

Environment: SAS 9.2, SAS EG 4.1, Oracle DB, UNIX & Window XP

Responsibilities:

• Responsible for validation of data attributes for a comprehensive review of data integrity for capital planning.
• Build and execute sql queries from multiple sources of data (Oracle and SAS Datasets) in a SAS environment.
• Created documentation to explain the results achieved when performing data validation.
• Help Wife with Second Total-Knee (Right) replacement recovery.
• Helped Son with rehabilitation after knee repair surgery after Snow Boarding accident.

Confidential

Sr. SAS Developer

Environment: SAS 9.3, SQL Server DB. UNIX

Responsibilities:

• Responsible to analyze, design, implement, and test program code changes to Korn Shells and SAS programs used for business reports.
• Was ICD9 to10 Project team member responsible to analyze, design, implement, and test changes made to SAS programs used in Main Frame to Warehouse data feeds. The SAS programs were for reading Main frame data files, ETL processing and creating dlm load files.
• All work was done with using SDLC processes.
• All version control of code changes were done using Dimensions CM.

Confidential

SAS Programmer,

Responsibilities:

• Responsible for Creation of an ETL Solution programmed in Base SAS. This is for a Meta Data Database. The metadata for 3 source DB's and 3 target DB’s are being loaded at this time.
• Develop and debug SAS ETL programs to create the new SAS Datasets to be used for database loading.
• Responsible for testing and validation of metadata DB.
• Responsible for testing, validation, and Documentation of the SAS ETL Programs
• Took some on-line SAS Training Sessions.
• Help Wife with First Total-Knee(Left) replacement recovery.
• Helped Son with rehabilitation after knee repair surgery after bike accident.

Confidential

SAS Programmer

Responsibilities:

• Responsible for heavy data manipulation to create new SAS datasets from the new Credit Data System to look like the Old Credit Data System to ensure current SAS Reports and queries were maintained.
• Develop and debug SAS programs to create the new SAS Datasets to be used for database loading.
• Responsible for testing and validation of conversion to new outside vendor that is used to process new credit card accounts. Up to 5 different Credit Bureau data (3 in the USA and 2 in Canada) is processed.
• Create SAS Program to read and process feed files from Credit bureau and compare the results with results from new outside Vendor.
• Analysis the non-matching records and work with outside Vendor to understand and fix the errors with their code.
• Worked with UNIX Administrators to transfer data to SAS.

Environment: SAS, Windows Server 2003, SQL, SUN Solaris

Confidential

Brio SQR Programmer,

Responsibilities:

• Responsible for supporting OTS clients’ internal customer service staff, production, and developers, as well as the designing of Brio SQR reports and charts that would be utilized for OTS client use.
• Design, develop, and deploy new reports and enhancements to existing reports, for various systems as assigned

Environment: HP Server, Windows Server 2003, SQL, Brio SQR

Confidential

Applications Support Engineer,

Responsibilities:

• Responsible for application support of EDI processing and monitoring applications.
• ON-Call rotation for 24/7/365 application support
• Team Member responsible for generating reports to support team and department report requirements. Used sqlplus, shell scripts, and excel spreadsheets.
• Created 3 XI WEBI reports for tracking support team SR ticket analysis.

Environment: Business Objects, BO WEBI, Sun Solaris, Windows, UNIX

Confidential

Sr. Brio SQR Programmer,

Responsibilities:

• Responsible to analyze, design, implement, and test program code changes to Brio SQR Reports and Business Objects Reports.
• Team Member responsible for report conversion of 25 Brio SQR reports and supporting sh & ksh wrapper scripts.
• Updated or rewrote 12 korn shell wrapper scripts
• Analyzed and Remediate 12 Business Objects reports after I was up to schedule with my Brio SQR Reports.

Environment: Brio SQR, Business Objects, UNIX, borne shell, ksh, Oracle, SQL

Confidential, CA

SAS Administrator,

Responsibilities:

• Responsible for supporting 150 SAS users running SAS reporting applications on 4 Sun/Solaris Servers.
• Responsible to convert all users and their programs from SAS 8.x to SAS 9.x.

Environment: SAS, Sun Solaris, UNIX

Confidential

SAS Programmer,

Responsibilities:

• Develop SAS programs to report on Health Care Data for both Members and Providers.
• Debug and update UNIX shell control scripts.
• Team member responsible for Creating Regulatory State reports using SAS.
• Team member responsible for Creating Adhoc reports for internal usage using SAS.
• Responsible to Debug and Update current SAS reports per user requests.
• Responsible to Analyze and repair SAS Macros and UNIX control Scripts.

Environment: SAS, SQL, UNIX, shell scripting, Sun Solaris

Confidential

SAS Programmer / Brio Programmer

Responsibilities:

• Team Member responsible for conversion from Business Objects reporting to Brio reporting (converted and combined 100+ Business Objects reports to 40 Brio reports).
• Designed, Developed, Implemented, and maintained BRIO and SAS report applications to support the Field service and support functions.
• Team Member responsible for production reporting system conversion during two different part planning system implementations (DRP to Xelus, Xelus to Servigistics Global Planning Tool). Required conversion of SAS (Used for data extraction, combining, modeling, and loading), 15 Brio reports, and shell scripts from Sybase DBs to Oracle DBs.
• Responsible for daily production processing, storing, and reporting of Local Level Of Availability data from off-site Part Distribution Vendor using SAS (For Extraction, Processing, and loading), Oracle DB, and Brio Reports.
• On call 24x7 by pager to support production reporting systems and applications. Created Shell scripts that monitored system and processing status and e-mailed results to pager.

Environment: SAS, SQL, UNIX, shell scripting, Brio, Business Objects

Confidential

Software Systems Engineer

Responsibilities:

• Created over 20 daily email reports for Logistic Planners using SAS and Shell Scripts and cron jobs. Gathered and processed data from multiple databases.
• Accomplished a smooth migration of an email responder reporting application (Unix Shell Scripts gathering and reporting inventory data) from an end-users desktop machine in California to a production machine in Colorado.
• Developed Global Information System (GIS) Operational data feeds using Shell Scripts calling SAS jobs launch by cron jobs. Loaded into ESRI ArcView application.
• Reduced Software Distribution Costs by 50% by creating automatic address label feeds from software contracts database using SAS and Shell scripts.
• Developed Unix Shell/Sybase SQL & SQR reports to locate Top 10 Highest used Field Replaceable Units (FRU) to increase the available stock levels at the regional stocking locations (RSL).
• Created 8 Unix Shell/Sybase SQL reports to analyze repair data which improved part failure detection of ATE Test programs.