SUMMARY:

• Looking for a position that will challenge my skills in Data retrieval (Business Objects, SAS and SQL on UNIX, Windows, and Mainframe platforms.
• Experienced in using Base SAS to do ETL processing (Extract, Transform, and Load). Developed SQL Data retrieval from Oracle, Sybase, Teradata, Netezza, and SQL Server databases as well as flat files, and Excel Spreadsheet files for the gathering, processing, and reporting of data.
• Developed process automation using UNIX shell script applications.
• Experienced in analyzing SQL,SAS,BO 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, SQL, and SAS knowledge resource.

TECHNICAL SKILLS:

• SAS - 9.4, 9.3, 9.2, 9.1.3 (MF, UNIX, Windows), 8.3 & 6.11 (UNIX): Base SAS, SAS ODS, SAS Macro, SAS SQL, sql-pass-thru - 20 yrs
• Teradata - 1yr
• Netezza - 1yr
• Oracle 7-9 - 8 yrs
• Sybase - 7 yrs
• SQL Server - 1 yr
• BRIO (8.x 6.x & 5.x): Brio ODS, Brio Server, Brio SQR, Brio Sched, Brio Designer - 5 yrs
• Business Objects (5.x, 6.x - 2 yrs)
• Business Objects XI WEBI - 1yr
• SQR (8.x) - 3 yrs
• Embarcadero Rapid SQL
• Toad for Oracle (Quest)
• RSQL
• X-Win 32, Putty, WinSCP
• PVCS
• UNIX Shell Scripting - 20 yrs
• SQL (t-sql, sql*plus) - 20 yrs
• PL/SQL - 1 yr
• Perl 5.x - 2 yrs
• SUN Microsystems Server/Desktops running Solaris; PCs and Lap tops running MS Windows
• SUN Solaris 3 thru 10 (System Admin); MS Windows (98se, Vista, XP PRO, XP Home)

PROFESSIONAL EXPERIENCE:

Confidential

Report Analyst

Environment: SAS 9.4, Excel, SQL Server, Oracle, Teradata, Epic, Clarity

Responsibilities:

• Data / Report Analyst within the Business Operations Support Services (BOSS) Analytics Team.
• I support Operations (Clinic ) with Dashboards and reports that are used for Goal Measurement, Staffing needs, Appointment availability slots.
• Tools use are SAS, Bussiness Objects, SQL and Excel . Data is from multi sources. Oracle, SQL Server DBs, data feeds, and Excel files. Data is mostly Clarity (Epic) data.

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, Information Delivery & Support BI Solutions

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

Environment: SAS PC 9.1.3, SQL Server DB.

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, Lone Tree, Co

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, Louisville, Co

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, Greenwood Village, Co

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, Burlingame, 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, Rosemont, IL

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