SUMMARY

• I have knowledge on SAS Grid Administration and R Studio Administration.
• 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 Confidential .
• 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 JC Penney, Confidential 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 JC Penney, 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, Plano, TX

SAS Developer

Responsibilities:

• Contractor to develop systems in COBOL and SAS.
• Developed Billing System for Medical Doctors payment at different
• VA sites. All work was on Unix and Linus commands. Pulled data with SQL from Oracle and
• Teradata. Work as QA and check software goes in Productiion.
• Maintain Production jobs and used SDM documentation.

Confidential, Plano, TX

SAS Developer

Responsibilities:

• Develop systems and enhancements for commodities market Value at Risk.
• Pulled data from data from Oracle and Teradata.
• 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.
• 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.