Data Microsoft Office

ALFRED J. FIGUEROA

Home 317-***-****

Cell 317-***-****

Email ********@*********.***

PROFESSIONAL SUMMARY:

Mr. Alfred J. Figueroa has over 16 years of experience in analyzing, programming and evaluation on various applications, including IBM Mainframe environment utilizing SAS, CICS and MVS/TSO, as well as the UNIX and PC SAS environment. Mr. Figueroa can communicate with both technical and user personnel professionally. His experience includes manufacturing, pharmaceutical, financial and telecommunications marketing systems applications.

TECHNICAL SUMMARY

HARDWARE: IBM MAIN FRAME, AST/BRAVO 386, NT Servers, AT&T 6300 PCs, VMS(VAC MAINFRAME), NEC MultiSync M700

OPERATING

SYSTEMS: MVS/TSO/ISPF, PC-SAS, UNIX, OS/MVS/TSO, DOS/IBM MVS/TSO/REFLECTIONS, IBM MAINFRAME, VAX

WINDOWS 95, 97, 98, 2000, XP, Enterprise Guide(SAS 9.1.3), T.O.A.D

SOFTWARE: ESP, NOVELL, ONLINE, MICROSOFT/WORD, LOTUS NOTES

SABER/MENU, WORD PERFECT, OS/JCL, SAS/MACRO

SAS V 6.04 thru V 9.1.3, EXCEL, LAN, SAS/GRAPH, EXPLORER

MICROSOFT OFFICE, FREE LANCE PLUS

COMPUTER

LANGUAGES: MAINFRAME SAS, UNIX, PC SAS

EDUCATION: SAS Institute - SAS/BASE, SAS/GRAPH, SAS/MACRO, PC SAS

CompuTrain - Beginning and Intermediate Lotus and Lotus Notes

Indiana University – 2 years Various Businesses Classes

Roosevelt High School - Graduated

EXPERIENCE:

Bucher & Christen

Eli Lilly & Company

Clinical SAS Programmer/Analyst (Consultant)

Jan 2007- Nov 2011

Programmed in SAS and utilizing SDD to performed level 4 validation on clinical trial data to create analysis data sets (ADS) for the safety trial data teams.

Interfaced with ADS requirements writers, coordinators, programmers, data management, and ADS standards team members.

Pinnacle Solutions

Mead Johnson

Sr. SAS Developer

March 2006 – July 2006

Working as a Sr. SAS Developer responsibilities include designing, developing, implementing and validating Global Macros as well as creation of tables, listings and graphs for reporting purposes. Usage of Enterprise Guide

In order to upload SAS programs to a Unix platform.

Ambassador Solutions

Eli Lilly & Company

Data Management Analyst

April 2004 – October 2005

Validation of numerous B.U.M.(Broad Use Macros) for Statistician and Customer usage as well as re-use across various projects. Program validation for Data Extraction and Transformation for customer(C.D.M.C.) evaluations. Creation and Utilization of D(Data) B(Base) Q(Quality) R(Review) program for use in verifying and validating CRF’s across multiple studies. Develop Auto submit programs to run at off peak hours.

VENTURI Technology Partners

Bristol-Myers Squibb CO.

SAS Programmer III

June 2003 – December 2003

Responsibilities included the analyzing and creation of Converted Clinical Trial Tables and data from Oracle and DB2 databases per specifications for usage in current SAS Clinical Trial programs by statisticians utilizing Proc SQL to create the tables and Proc Compare to verify that the tables matched. Another aspect of the position included working closely with project leaders and data base managers to rectify any discrepancies to insure all programs where up to standards. Environment was UNIX while using SAS 8.2 Program Editor when needed and EXCEL as well as WORD.

VOLT

Eli Lilly & Company

Data Consulting Analyst

September 2000 – November 2002

Working as a Data Consulting Analyst responsibilities included the creation of Tables, Listings and Databases per specifications for statisticians and medical writers in the Clinical Trial development process across multiple protocols during Phase I thru III of Urinary Incontinence study. Significant experience in SAS PROCS: SELECT, WHERE, SORT(NODUP), PRINT, DATA NULL, TRANSPOSE, ARRAY, MERGE, OUTPUT, SAS/Graph. Part of this development included working with the CRO QUINTILES along with Data Management to determine compliance of investigators and subjects within protocol guidelines by developing SAS programs to Edit and Validate CRF reports. Additional aspects included analyzing customer and data requirements, developing, generating, testing, validating, and documenting programs as well as ISS and ISE safety summary reports to meet FDA standards and submission including 21 CFR Part 11 (electronic submissions) as well as performing validation of second programmer coding and programming documentation. Creation, testing, validation and storage of SAS Macros(Local and Global) for current as well as future usage.

Maxim Group

Sprint

Consulting Analyst

December 1999 – JULY 2000

Working as a SAS programming marketing consultant for the small marketing division of a large telecommunications corporation responsibilities included the utilization of multi-million records in the creation of numerous and various SAS ADHOC report listing programs for various aspects of Marketing customer usage. Working knowledge of base SAS Procs such as: Sort (where, rename, keep,nodup,nodupkey), Proc Means-Print-Summary, Match Merging, Data Step Programming as well as utilization of Main Frame and PC SAS, experience in systems analyst/development roles including interpreting customer needs and wants.

Maxim Group

Associates Bancorp

Consulting Analyst

August 1999 – November 1999

Working as an SAS programming consultant for a large financial corporation responsibilities included the creation of numerous and various SAS ADHOC report programs in the conversion trial development process of converting different systems into one common system. Utilization of SAS(Data Null) for downloading from DB2 into a SAS Flat File manipulating and then transferring back to a DB2 table. Significant systems experience in systems analyst/development roles including interpreting customer needs and wants.

Software Synergy, Inc.

Eli Lilly & Company

D.S.A. Analyst

May 1997 – April 1999

Working as a Decision Support Analyst for a large pharmaceutical corporation responsibilities included the creation of report programs in the clinical trial Phase I development process for Smoking Cessation. Significant systems experience in systems analyst/development roles including gathering customer requirements for analyzing, developing, testing, documenting and validating SAS programs to meet FDA standards. Working knowledge of SAS Base concepts(Proc Means, Freq-2way table, Format), SAS/Graph.

Inland Steel Industries

Senior Information Specialist

April 1988 – March 1997

As Senior Information Specialist for a large fortune 500 corporation devised, wrote and tested SAS programs to implement a large scale Scrap Evaluation Project for Accounting and Material Management.

As Senior Information Specialist developed a SAS program and data base by merging Railroad and Truck movement systems to reduce the amount of man-hours spent on paperwork to service an outside contractor; this resulted in the reduction of (1) one FTE(Full Time Employee).

As Senior Information Specialist developed SAS programs used by individuals responsible for the tracking and maintenance of material movement both externally and internally. This involved purchased, sold, produced and consumed specific types of material by designated areas to develop and maintain “costs.”

As Senior Information Specialist developed SAS programs that resulted in the reduction of time along with the virtual elimination of errors and the “catching”: of duplications in the processing of vendor invoices for accounts payable.

As Senior Information Specialist was instrumental in enhancing through the use of ESP along with SAS programs to retrieve and manipulate various programs and databases to automatically “run” at minimum CPU cost per hour times.

As Senior Information Specialist devised, developed, wrote and tested SAS programs that resulted in the implementations of a revised month end close schedule which resulted in the reduction of from (5) five to (3) three business days to “close” in the processing of various General Ledger Accounts.

Environment was SAS, CICS, MVS/TSO and IBM mainframe system, McCormick and Dodge General Ledger System, Saber/Menu, LAN, FREELANCE PLUS and the PC HARD DRIVE.

training, publications, certifications & other qualifications

CompuTrain – Beginning and intermediate Lotus Notes

Indiana University – Various Business Classes

Roosevelt High School – Graduated

Training – “SAS Macro Language”, SAS Institute, May 1997

Training – “SQL Processing With The SAS System”, TEK Systems, May 2000

References:

Statisticians Ilker Yacin @317-***-**** Eli Lilly

Guangbin Peng @ 317-***-**** Eli Lilly

Lead Manger Armand Robles @ 203-***-**** B.M.S.

Lead Programmer Carol Frazee @ 317-***-**** Eli Lilly

Contact this candidate