PROFESSIONAL SUMMARY:

• Manager for four years at Employer Insurance in SAS Reports, SAS Statistics and Modeling.
• QA Supervisor, problem solver with the ability to encourage others in collaborative problem solving.
• Reviews of business requirements and functional specification of the software to the test specification of desire results. Programs went through cycles, using software development methodology such as Second Edition “Managing a Programming Project” by Confidential .
• Five years had experience in Data Miner and Enterprise Miner.
• Five years experience of Informatica PowerExchange to load, and deliver data as part of the Extract - Transform-Load (ETL) process to a development data mart or data warehouse.
• Used SAS Keyword File with file for stating and put statements of the fields.
• Seven years in Oracle and Teradata. Ten years in PC and Unix with SAS.
• Thirteen years of experience with SAS, SAS Connect and SAS MPConnect to Server and DB2 as a programmer on a Mainframe and JCL and COBOL.
• Eight years of SAS, SAS Connect, SAS MPConnect and DB2 in an AIX UNIX environment. Campaigns and branding experience at Confidential, Javelin and Confidential .
• Six years in Clinical Trials in Eye, Cancer, Depression medicines.
• Two years in MetaData.
• Additional Background includes SQL, SPSS, JAVA, HTML, BASE SAS, SAS/STAT, SAS, SAS Macros, SCL, SAS FSP, ETS, IML, ETL, EPIC/DYNAM/D, SAS Data Warehouse, Microsoft SQL Server 2000, PL/SQL, SQL, SAS9 Data Warehousing, Business Intelligence, Data Integration Studio, Information Map Studio, SAS Management Console Microsoft Office, OLAP Cubes, SAS /ODS. Two years in Crystal Enterprise.
• Five+ years working with TERADATA, DB2, Oracle, Shell Scripts, MS Excel, VBA and MS Access.
• Extensive background working as a liaison between customers and clients.
• Acted as a project lead responsible for designing specifications and projecting costs.
• Primary focus on Mainframe environments. 
• Ten years in Teradata.
• Experience in Microsoft Project, Microsoft Office, Microsoft Outlook and Microsoft SQL Server 2000 and 2005.
• Worked in Remedy 4 to new Remedy7.

TECHNICAL SUMMARY:

• IBM 3090 IBM PC VM (CMS) UNIX IMS DB/DC TSO/ISPF REXX T-SQL QMF FOCUS
• CHANGEMAN LOTUS NOTES WINDOWS 95/98/NT WINDOWS 2000/NT
• SHELL SCRIPTS VISUAL BASIC SAS SAS/MACRO SAS/SQL ETL
• SAS/STAT SAS/AF FSP SCL SAS/GRAPH SAS/EIS/MDDB SAS/SHARE
• ETS ETL IML VBA SAS / WAREHOUSE SAS ODS DB2 SAS CHANGEMAN
• DISPLAY MANAGER ORACLE ACCESS SQL,ORACLE/SQL PL/SQL SYNCSORT PINNACLE CLI
• MICROSOFT SERVER 2005 MICROSOFT SERVER 2003 SAS 9 BI M204 MICROSOFT PROJECT

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

SAS Lead Consultant

Responsibilities:

• Used SAS to clean files.
• SAS reports for analyses and validate the data.

Confidential, Phoenix, AZ

SAS Lead Consultant

Responsibilities:

• Developed code in SAS/Macros, SAS/Connect, SAS MPConnect, SAS/Base, SAS Enterprise 4, Microsoft Visio, MetaData, ETL, SAS Business Intelligence, Shell Scripts, SQL and Java Scripts on Unix. SAS Enterprise on PC and connected to different Unix Server, Oracle and Teradata.
• Upload SAS tables to DB2 tables and worked with toad with Sequel to do changing the DB2 tables.
• Reports were done on Microsoft SQL Server for analyses.
• Automated SAS applications to CRON and used Shell Script,
• Sequel and SAS RSUBMIT for getting files from other servers.
• Informatica PowerExchange for ETL to Data Marts and Warehouse. File with put statements for ETL.

Environment: ETL, SAS Business Intelligence, SQL, TERADATA, Oracle and SAS.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• developed SAS code on Unix and PC in Marketing Department.
• Responsible for pulling data by SQL and using Proc Export to Excel to put reports on Server.
• Used SAS Macros, Data Warehousing, Business Intelligence, and ODS, Studio and ETL.
• Finance Company roll over smaller 401K accounts to a bigger account with active Mangers, like Fox Hall.
• Reports on companies like Fox Hall and the performance.
• Informatica PowerExchange for ETL to Data Marts and Warehouse.

Environment: ETL, Data Warehouse, SAS, DB2, MetaData, Business Intelligence, Oracle, TERADATA.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• Responsible for Brand Merchandising Analysis in JTEST written in SAS with SAS Macros. System was on Unix and & LET statements produce an Excel Table by ODS.
• FTP up to the PC and give report to the BDM clients .
• System is not perfect, so I had to produce SQL and SAS program to duplicate reports.
• SAS Administrator for SAS/AF.
• Wrote SAS/AF with SCL on version 9.1 for customer transactions with SAS Macros inside SCL. ODBC for regular SQL and SAS SIGNON to remote server to create a table inside SQL.
• Used SAS ODS to export files to Excel.
• Developed formulas in work sheets to have the results what the client expects in Microsoft Excel.
• Used SQL queries inside SAS/AF to get data in TERADATA and DB2.
• Developed Icon for SAS/AF and conducted testing in PC SAS.
• Helped People on Mainframe for DB2 questions on it.
• Mainframe and JCL, VSAM and SAS with SAS Macros.
• JAVA and HTML for the web.
• Modifications on JCP.COM.

Environment: Mainframe, DB2, ETL, Oracle, TERADATA and Unix.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• SAS Expert for Help Desk functions.
• Duties included Enterprise Miner, Data Miner on servers for SAS.
• Installed 9.3 with Console.
• Installed Enterprise Miner latest version in version 9.
• Communicated with SAS institute for update core of SAS on expiration date.
• Designed and developed extracts for BHI warehouse and wrote documents for support.
• Used T-SQL, SQL queries and Unix Scripting in TERADATA, Oracle, JAVA and HTML for the web.
• CITRIX Server for SAS applications.
• Web for the Help Desk modifications.
• Informatica PowerExchange for ETL to Data Marts and Warehouse.
• Sequel and SQL for Microsoft Server 2005.

Environment: SAS 9 Business, SAS 91.3 Intelligence Platform, Enterprise Guide, MetaData, Data Integration Studio, information map Studio, Unix, TERADATA, SAS Management Console, ETL, Enterprise guide, Metadata, Enterprise Miner, Data Miner, Oracle and Microsoft Office.

Confidential, Austin, TX

SAS Lead Consultant

Responsibilities:

• Moving files from Test to Production.
• Designed Test system with SAS, SAS Macros, Meta Data, Oracle SQL, Oracle, AIX/Unix and Unix Shell Scripts.
• Used Microsoft SQL Server 2000 for SQL.
• Produced SAS Graphs for Engineers.
• Documented the Processes of the System.
• Downloaded SAS files to Microsoft Excel.
• Responsible for SAS Data Warehouse from different files in Test and Production.
• Designed and developed extracts for BHI warehouse and wrote documents for support. Installed 9.3 versions of SAS. Used SQL queries in Oracle and Unix Scripting. Java and HTML for the Engineer to changed the Data Warehouse through the Web.
• Sequel and SQL for Microsoft Server 2005.

Environment: Metadata, Unix, ETL, MetaData, Enterprise Miner, Enterprise Guide and Microsoft Office.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• Responsible for Analytics, Microsoft Server Query Analyzer, PC SAS, and SAS Enterprise Guide 3.0. SQL Inner and Outer Joins.
• SAS and SAS Macros to produce reports.

Environment: Unix, ETL, Metadata, Enterprise Miner, Enterprise Guide and Data Miner

Confidential, Irving, TX

SAS/Crystal Consultant

Responsibilities:

• Responsible for Crystal Reporting, SAS, Excel, SQL and TCL for Oracle.
• Used SQL queries and Unix Scripting in TERADATA.
• Large scale loan and lease in Accounting.
• Moved Crystal reports to CITRIX Server for people in accounting to login to get reports.
• Used CHANGEMAN to Control Change to Production
• Sequel and SQL for Microsoft Server 2003.

Environment: Unix, ETL, Enterprise Guide and Microsoft Office.

Confidential, Dunedin, FL

SAS Consultant

Responsibilities:

• Responsible for SAS, PL/1, M204 and SQL Queries.
• SAS in REMEDY 4 and 7, M204 and PL/1 software for reporting for Clients at Television Stations for ratings.
• The environment is VM (CMS), TSO and MVS JCL and Microsoft VISUAL BASIC.
• Used Remedy software for work on solving tickets.
• Used SQL queries and Unix Scripting.
• SQL in TERADATA and DB2.
• SAS, COBOL, JCL on the Mainframe.

Environment: Mainframe, ETL, Enterprise Guide and Microsoft Office.

Confidential, Kalamazoo, MI

SAS Consultant

Responsibilities:

• Used SQL on AIX/Unix to pulled data from Oracle tables.
• Responsible for SAS table and listings programming Adverse Events of Summary tables, which used Proc SQL to do counts of number observation of Patients and Unique Patient numbers by Body or Adverse group by Treatment Groups like Placebo and the drug dosage. Proc Report was the main report tool. The drugs were Valdecoxib (Bextra) for acute pain and Parecoxib for acute pain.
• Verifications of tables were done in Confidential ’s PHA verification process.
• Safety tables included Adverse Events (AE), Vital Signs, Laboratory Values, and Concurrent Medications.
• Mainframe, PC SAS and through Exceed to get on Unix to place the files and do development.

Environment: Unix, ETL, Enterprise Guide, Microsoft Office and Mainframe.

Confidential, CT

SAS Consultant

Responsibilities:

• Responsible for four Protocols from CRF documents by SAS SQL, AIX/Unix, Macros and SAS Compare to validate data from Oracle Clinical and Clinical Trial data.
• Write edit checks from the Data Cleaning Plan (DCP) specifications.
• SAS Tables and Listing programming Adverse Events of Summary tables, which used Proc SQL to do counts of number observation of Patients and Unique Patient numbers by Body or Adverse group by Treatment Groups like Placebo and the drug dosage.
• Proc Report was the main report tool.
• SAS macros to generate listings and tables for Protocol and each study in that Protocol for NDA New Drug Application submissions.

Environment: Unix, ETL and Metadata

Confidential, Charleston, SC

SAS Consultant

Responsibilities:

• Responsible for writing Frame and SCL code behind Frame in Version 6 and update SCL code to in a SAS/AF v.8.2 environment, macro code, OLAP Cubes, Metadata Cubes, ETL, SAS SQL and SAS/EIS/MDDB.
• Worked FSP for data entry.
• Unix and PC SAS environment and used basic SAS procedures such as Means, SQL and Summary.
• Handled large database more that ten million records.
• Created METADATA files on Unix with CRON to automate daily processes for the SCL code to retrieve the data and put the information on Frame by the SCL code.
• Used SQL queries and Unix Scripting.

Environment: Metadata, Unix, Mainframe, Microsoft Office.

Confidential, Indianapolis, IN

SAS Consultant

Responsibilities:

• Responsible for Statistical programming from SAS/STAT PROCS and Base SAS for producing SOP.
• Analyses, tabulations, graphics, tables and listings from Clinical Trial data.
• Data aggregation for producing studies in a common SAS data set.
• Data Modeling.
• Worked SAS Clinical Trials Phase I-IV through several studies.
• Provided analysis plans and test plans to test required code, displays, and statistical reports. Perform quality assurance procedures on work by others.
• Experience with ICH guidelines and Electronic Submission standards for the FDA.
• Transfer Adverse Event files on Unix to Oracle tables.
• Worked in SAS v8.1 on SAS PC Windows.
• Used SQL queries and Unix Scripting.

Environment: Unix and Microsoft Office.

Confidential, Irving, TX

SAS Consultant

Responsibilities:

• Responsibilities include writing SAS MACRO CODE, SCL to read and create METADATA files on Unix.
• OLAP Cubes and ETL skills to provide for all types of programs.
• Pulled DB2 fields for marketing campaigns and used SAS for reporting campaigns. Additionally, pull
• INTERNET. The development environment consists of SAS/AF, SAS/FSP, ADABAS, Natural, JCL, BETQ, GQL, Oracle, SAS/EIS, SAS/MDDB, SAS ENTERPRISE, SAS DISPLAY MANAGER, SAS MINER, SAS/CONNECT, MS Excel, COBOL, OLAP, ETL and DB2.
• Used SQL queries and Unix Scripting.

Environment: OLAP Cubes, ETL, Metadata, Mainframe, Unix and Microsoft Office.