PROFESSIONAL SUMMARY:

• SAS administration at Confidential and Dell, on Unix System.
• Five years in campaign tracking, analytics and identifies appropriate customer
• Reporting and ETL process. Five years in BI with SAS analysis.
• Five years in pharmaceutical companies doing Clinical Trials.
• Ten years in Microsoft Project, Microsoft Office, Microsoft Outlook and Microsoft SQL Server 2005 and 2008.
• SAS experience on thirteen years on Mainframe and ten years on UNIX. License in stocks, funds and bonds at World Financial Group. Manager for four years at Employer Insurance in SAS Reports, SAS Statistics and Modeling.
• Major SAS and ETL process was to write a procedure that compile in SAS for to help Wells Fargo.
• Major SQL to write macros for select, where and group in automation for monthly reports in CRON.
• Major business is to win an award for outstanding employee services for helping business to acquire a million dollar client. Report development using Business Objects Web Intelligence platform with OLAP. Scorecard performance reporting.
• Experience as a BI development for five years. UNIX SAS programmer with extensive experience developing ETL scripts for building, loading, appending and updating Oracle tables in versions 10g and 11g. Experience programming in SAS on UNIX and in Oracle SQL.
• 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 Philip W. Metzger. Strong SAS Macro with all development.
• Five years had experience in Data Miner and Enterprise Miner. Two years in SAS Data Integration Studio 4.2. Administrator help desk for Confidential, Wells Fargo and Dell. SAS load utility (MDI).
• Five years in ETL process 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 reference for stating and put statements of the fields. SQL Server 2008, using SQL and SSIS.
• 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 Sprint Marketing.
• 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. Four years in M204.
• Ten years in Teradata.

TECHNICAL SKILLS:

• 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
• UNIX 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

Senior Systems Engineer

Responsibilities:

• Developed SAS code on UNIX and PC in Medical billing code
• Developed COBOL on Mainframe.
• Develop systems and enhancements for commodities market Value at Risk.
• Microsoft SQL Server 2010 for SQL program
• All work was done in remote.
• Contractor to develop systems in COBOL and SAS.
• Maintain Production jobs and used SDM documentation.

Confidential, Plano, TX

SAS Developer

Responsibilities:

• At Confidential, developed SAS code on UNIX and PC in Marketing Department.
• Develop systems and enhancements for commodities market Value at Risk.
• Microsoft SQL Server 2010 for SQL program
• All work was done in remote.

Confidential, San Antonio, TX

App Developer Senior

Responsibilities:

• Microsoft SQL Server 2008 for SQL programs. SAS Macros in Java Script. Using the SAS/Internet on the server to produce web pages for twenty applications for Randolph Air Force Base. Speed of SAS and learning the Air Force terms is complex.

Confidential, San Antonio, TX

SAS Lead Consultant

Responsibilities:

• Analysis, designing and implementation of large projects. System, programming and testing of solution.
• Microsoft SQL Server 2008 for SQL programs.
• Assist project team to resolve any kind of technical issues raised during design.
• Long term technology strategic initiatives, provide architecture and technology inputs for other ongoing projects. Version 9.2 for SAS.

Confidential, Irving, TX

SAS Consultant

Responsibilities:

• BI development for analysis, designing and implementation of large projects. System, programming and testing of solution.
• Campaign tracking, analytics and identifies appropriate customer segments and SAS reporting.
• Microsoft SQL Server 2008 for SQL program.
• SAS Data Integration Studio 4.21. Experience in SPD Server for table
• Loader and SQL Transformations. Deploy jobs for scheduling. Experience in reports feature..
• Develop pro SAS/ Developed Macros, SAS/Connect, 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. SQL Server 2008, using SQL and SSIS.
• Automated SAS applications to CRON and used Shell Script,
• Sequel and SAS RSUBMIT for getting files from other servers.
• All work was done in remote.

Confidential, Phoenix, AZ

SAS Lead Consultant

Responsibilities:

• Code in SAS/ Developed 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. SQL Server 2008, using SQL and SSIS.
• Automated SAS applications to CRON and used Shell Script,
• Sequel and SAS RSUBMIT for getting files from other servers.
• ETL to Data Marts and Warehouse. File with put statements for ETL. Version 9.2 for SAS.
• SAS Data Integration Studio 4.21. Importing, Exporting, and Copying Metadata. Exporting SAS package Metadata. Importing new Metadata with a SAS Metadata Bridge.
• Administrator and help desk for SAS. Used SAS Macros in all development.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• At Confidential, developed SAS code on UNIX and PC in Marketing Department.
• Develop systems and enhancements for commodities market Value at Risk.
• Microsoft SQL Server 2008 for SQL program
• SAS Data Integration Studio 4.21. Experience in SPD Server for table Loader and SQL. Deploy jobs for scheduling. Experience in reports.
• 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. ETL to SAS Data Warehouse. SQL Server 2008, using SQL and SSIS.
• Reports on companies like Fox Hall and the performance.
• ETL to Data Marts and Warehouse. SAS Data Integration Studio 4.21. Importing, Exporting, and Copying Metadata. Exporting SAS package Metadata. Importing new Metadata with a SAS Metadata Bridge. Used SAS Marcos for all development.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• Campaign tracking, analytics and identifies appropriate customer segments and SAS reporting.
• 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 at Confidential . SQL Server 2008, using SQL.
• 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.
• Administrator and help desk for SAS.
• SAS Data Integration studio 4.21. Experience in SPD Server for table Loader and SQL Transformations. Deploy jobs for scheduling.
• 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.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• SAS Expert for Help Desk and Administrator functions. SAS load Utility(MDI).
• 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.
• ETL to Data Marts and Warehouse.
• Sequel and SQL for Microsoft Server 2005.

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, Meta Data, Enterprise Miner, Enterprise Guide and Microsoft Office.

Confidential, Plano, TX

SAS Lead Consultant

Responsibilities:

• SAS Coding Health Plans reports and statistics.
• Campaign tracking, analytics and identifies appropriate customer segments and SAS reporting.
• 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, Squibb, 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.