PROFESSIONAL SUMMARY:

• Over 18 years of experience as a programmer with expertise in analysis, design, development, and testing including eighteen years of experience as a SAS Developer/Programmer utilizing SAS/Base, SAS/SQL, and SAS/Macros.
• Involved in SAS maintenance, reporting, statistical and clinical analysis with increasing responsibility for teh scope management and completion of projects.
• Extensive experience working on SAS, including Base SAS, Enterprise Guide (EG), SAS/Macros, SQL, Web Report Studio, EIS, SAS BI, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, Data Integration (DI) Studio, FM, GRID.
• Ability to work on multiple projects simultaneously, meet deadlines as required, and to adapt quickly to new applications and platforms
• Effective team player bringing enthusiasm and energy into group efforts
• Excellent oral and written communication and problem solving skills
• Recognized as assertive, self - motivated, organized, and efficient

TECHNICAL SKILLS:

Languages: SAS (Base, BI, EG, Macros, SQL, OLAP Cube Studio, Web Report studio, EIS, Graph, Stat, ConnectData Integration, GRID) Perl, Shell scripting, MDDB, C, C++, HTML, SQL, Visual Basic 3, COBOL, JCL

Databases: Oracle, SAS ITRM, Teradata, SQL Server, Sybase, MS Access and DB2

Systems: UNIX, LINUX, PC, MVS, VAX/VMS, and Novell

Software: Windows, X-Windows, MS Access, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

Sr. SAS Consultant

Responsibilities:

• Automate SAS EG projects by performance enhancing (Macros, SQL, Advanced technics) and linking to MS tools.
• Convert and streamline SAS projects and programs/analysis to run intuitively on UNIX, PC and Mainframe in batch mode.

Confidential, Washington, DC

Sr. SAS Analyst/Admin

Responsibilities:

• Develop and maintain ETL scripts and SAS Macro programs for DCF (Data Collection Facility) utilizing EG and DI.
• Create and analysis SAS data for teh Work Place Allocation project using Census and Department of Transportation data.
• Develop SAS GRID optimized Macro programs and scripts for teh new Internet Data Collection mode to be stored in SAS warehouse.

Confidential, Foster City, CA

Sr. SAS Programmer

Responsibilities:

• Import large files into SAS datasets for processing using SAS Procedures, Data Steps, Macros and other tools.
• Analyze and build models to create files for outside vendor using SAS, FM, and Shell scripts. Walt Disney (contract), Orlando, FL Sr. SAS Developer/Admin
• Enhance and streamline monthly scoring process for ESPN and ABC using advanced SAS techniques.
• Load SQL server data, Excel spreadsheets and raw data into SAS for modeling, analytical processes and reports.
• Teach junior programmer SAS language, BI Tools, and other modules.

Confidential, San Jose, CA

Sr. SAS Admin/Project Lead

Responsibilities:

• Create and implement projects for a team of 8 or more analysts.
• Communicate with other groups and outside venders regarding technical and software projects.
• Manage teh SAS production and development servers.
• Developed and Maintained SAS BI tools, loading (ETL process), accessing, manipulating and reporting of database (very large) for all site traffic information collected from Tivoli and other sources.
• Create automated daily, weekly, ad-hoc reports and applications to be view/distributed on teh web. Install, update, and teach SAS classes for teh Capacity planning and other teams.

Confidential, San Diego, CA

Sr. Programmer/Admin

Responsibilities:

• Generate tables and listing for phase me and II of a melanoma site injection drug using SAS code with Macros.
• Support Physicians and Statisticians with ad-hoc reports and presentations.
• Communicate with outside venders and transport data from various sources.

Confidential, Berkeley, CA

Project Lead/Analyst

Responsibilities:

• Developed a reporting system with graphs, reports, and tables to be requested and viewed on teh Web by Epidemiologist and Statisticians.
• Teh reports were generated using SAS, Macros, Data Nulls and Proc Tabulate with state tuberculosis data.
• Teh graphs and reports could be viewed in PDF, RTF or HTML format.

Confidential, San Francisco, CA

Sr. Programmer/Admin

Responsibilities:

• List generation for emails and statistical analysis of click through data using SAS, SAS/Stat, SAS/Access, SAS/SQL, SAS/Macro, SAS/Graph, SQL server, Brio, HTML and Oracle on UNIX and Windows NT for teh eCommerce group.
• Convert and upload FDR data to Oracle databases.
• Create and maintain Macro libraries.

Confidential, San Francisco, CA

Sr. Programmer

Responsibilities:

• Run weekly and monthly modeling reports using SAS, SAS/Stat, SAS/Access, SAS/SQL, SAS/Macro, and SAS/Graph on teh MVS for teh Risk Policy & Analysis department.
• Convert MVS SAS jobs to PC SAS (Frames, SCL, Connect, Macro, and SQL) for easy submission and more functionality.
• Access teh Oracle database with SAS on UNIX to build statistical models. Create flat files for third party vendors.

Confidential, San Jose, CA

Manager / Sr. Programmer

Responsibilities:

• FTP weekly production data from remote locations using SUN Sparc stations.
• Convert SAS MDDB format to be used in SAS/EIS, SAS/Frame SAS/SCL, and SAS/Graph applications for management staff.
• Modify and write SAS/EIS methods to add functionality to teh applications.

Confidential, Novato, CA

Sr. Business Programmer / Manager

Responsibilities:

• Develop and modify teh Commercial Information Access Facility (CIAF) using SAS/Frame Entry, SAS/SCL, SAS/AF, SAS/Macro, SAS/Connect, SAS/Report, SAS Base, and HTML under Windows NT and IBM mainframe (MVS).
• Support and monitor Jr. Programmers as needed in multiple projects and tasks.

Confidential, Berkeley, CA

Sr. Programmer / Analyst

Responsibilities:

• Daily duties included input of teh Comprehensive Epidemiological Data Resource (CEDR) data files into SAS data sets from many different file formats.
• Performed data integrity checks and cleansing using SAS Macros and data steps on a SUN Sparc station.

Confidential, Milpitas, CA

Systems Analyst / Clinical Analyst

Responsibilities:

• Daily duties included transferring and converting data from one platform to another to be used for further clinical trials analysts in phases one, two and three.
• Rewrote teh Shurestep One Touch (glucose monitoring devices for diabetics) product calibration program involving FDA general and validation submissions.
• FDA submission experience BLA and NDA.

Confidential, Livermore, CA

Programmer / Clinical Analyst

Responsibilities:

• Developed and executed a medical data reporting system to be implemented on a daily basis or used as an ad-hoc reporting tool.
• Assisted in transferring Mainframe reporting applications to a GUI type application using SAS/Frame, SAS/SCL, SAS/AF, SAS/EIS, SAS/Connect and DB2 for uses on PCs.

Confidential, Tampa, FL

Programmer / Clinical Analyst

Responsibilities:

• Abstracted and maintained data from teh Health Care Financing Administration’s Medicare database for teh state of Florida. Daily functions included programming queries and interactive applications using ICD9 codes, SAS/BASE, SAS/MACRO, SAS/Graph, Visual BASIC, C, and AS400 for clinical studies.