• Business Experience: Expert-level ability in the design and development of SAS / Netezza SQL programs. Accomplished in design and construction of both analytic and transactional data repositories. Developed computer systems and reports for research/statistical analysis, customer marketing analysis, extraction, transformation and data warehousing/reporting systems for Clinical Research, Sales, Marketing, Banking and Financial Services, Call Centers, among other businesses.
• Personal Qualities: Strong organizational and interpersonal skills Highly Motivated - Self Starter - Team Player - Tutor and Mentor
• SAS PLATFORMS: Microsoft Windows Server 2008 R2, 2000 XP, NT 4.0 PC SAS and SAS Server 9.2 IBM MVS S/390 SAS 8.2 , IBM zOS 1.4 UNIX System Services HP UNIX 11.11 on HP-9000 SAS 8.2 , Sun OS 5.8 SAS 9.1.3

SAS/BASE:

• Datastep: Reading non-SAS data: Input, : / Data sorting merging and manipulation BY Processing: FIRST. and LAST. Indexing for very large datasets Program Control: IF-THEN-ELSE, Iterative DOs, DO WHILE, SELECT SAS Functions Data NULL ODS.
• PROCS: SQL, APPEND, CONTENTS, DATASETS, FORMAT, FREQ, MEANS, GRAPH, GMAP, UNIVARIATE, OPTIONS, PLOT, PRINT, PRINTTO, REPORT, SORT, SUMMARY, TABULATE, TRANSPOSE, IMPORT, EXPORT, UPLOAD, DOWNLOAD.
• MACROS: To automate and add flexibility to SAS code for repetitive use and allow a more modular approach.

Other SAS Products

• SAS Enterprise Guide 4.:, Development platform for SAS Intelligence Platform.
• SAS/Information Delivery Portal - SAS/IntrNet: SAS Web platform for user interaction and data/report presentation.
• SAS Management Console SMC : Manage Metadata for the Intelligence Platform and User management
• Cross-Environment Data Access CEDA : Access data on multiple platforms including Unix System Services Mainframe OS/390 and Z/OS.
• SAS/ACCESS: Pass-Through SQL to execute SQL in the native DB environment, Create ACCESS and VIEW descriptors for accessing data in Netezza, ORACLE, MS SQL Server, plus ODBC connections.
• SAS/CONNECT: Read Microsoft Access and Excel data.
• SAS/FSP: PROC FSEDIT to create data entry and viewing screens.
• SAS/GRAPH: GPLOT, GBAR, GPLOT.
• SAS/Add-In for Microsoft Office.

EXPERIENCE:

Confidential

Manager

Modify and enhance business system that identified cost savings for health insurance business. Converted Oracle SQL to Netezza SQL programs. Added SAS macros to automate, customize and increase functionality to existing programs.. Analyzed programs to determine resolutions for business team issues. Optimize Netezza SQL loads. Test and QA all work. HHS/CMS/Health Care data.

Confidential

Sr SAS Consultant

Modify and enhance an extremely complex enterprise business system tailor made for this particular insurance business. Customized SAS programs to interface with the PeopleSoft General Ledger system. Added SAS macros to replace hard coded passwords allow a smooth secure interface between environments. Analyzed programs to determine resolutions for business team issues. Optimized SQL downloads, refractor COGNOS push for cube data. Test and QA all work.

Confidential

Sr SAS Consultant

Confidential SAS to upgrade, modify and optimize pre-existing web reports and dashboards for the Executive Decision makers.

Confidential

Healthcare Data Analyst

Responsible for reporting and analyzing Outreach outcomes in support of Medicare outreach strategies and Contact Center activities. Prepare reports provide relevant information and key insights for leadership's business intelligence and analytics. Maintain and manage relationships with key business stakeholders and IT. Handle multiple tasks simultaneously, work independently or with a project team. Create workflows, conduct research and develop solutions, as well as specify requirements. Utilize SAS Enterprise Guide 4.3 and the SAS Intelligence Platform to design solutions and metrics for the Executive Decision makers.

Confidential

IT Specialist .

Upgrade and enhance a SAS/IntrNet web based disease surveillance system from Windows Server 2000 - SAS 9.1.3 to Windows Server 2003 SAS 9.2. Design and develop original programs to perform complex processing on normalized SQL databases. Modified SAS programs to utilize SQL tables. Developed and trouble shoot SAS programs for statistical analysis. Advise senior management and consult with peers to automate a UAT process for an OLTP database. Build tools for comparing data and develop reports delivered on the web. Modify SAS programs and data structures to transition ICD-9 disease codes.

Confidential

. Consultant,

Upgrade and enhance a SAS program to add parent/child hierarchies to the reporting schemes. Design and develop original programs to perform complex processing on transactional SQL databases. Modified SAS programs to utilize SQL tables. Developed and trouble shoot SAS programs for statistical analysis. Advise senior management and consult with peers to automate a UAT process for an OLTP database. Build tools for comparing data and develop reports delivered on the web.

Confidential

Consultant

Upgrade and enhance a SAS/IntrNet web based system that enables non-technical users to perform disease surveillance analysis. Developed web programs in html, xml/JavaScript, CSS forms that interact with a SAS-SQL backend upgraded SAS programs for annual processing. Design and develop original programs to perform complex processing on normalized SQL databases. Modified SAS programs to utilize SQL tables. Developed and trouble shoot SAS programs for statistical analysis. Advise senior management and consult with peers to automate a UAT process for an OLTP database. Build tools for comparing data and develop reports delivered on the web.

Confidential

Consultant

Upgrade and enhance a SAS/Excel financial risk analysis system on credit card/revolving debt. Upgraded SAS programs to accommodate a new line of business.

Confidential

Produce statistical analysis of clinical study data to ensure integrity of information. Developed SAS programs that produce Patient Profiles, FDA listings and summary tables of clinical data. Assist statisticians in developing meaningful analysis of clinical data. Developed SAS Macros to provide adhoc statistical analysis to statisticians and medical staff and help data management to identify data issues based on the review of tables and listings.

Confidential

Consultant

SAS support of a CRM function for a marketing group within a major credit card company, gathering, cleansing and grouping data. Produce statistical analysis of data to ensure integrity. Perform independent analysis of data, make recommendations and assist in group decisions and conferences with entire group.

Confidential

.

SAS support of a Clinical Study Data System, gathering, cleansing and grouping data. Produce statistical analysis of clinical study data to ensure integrity of information. Automated the writing of programs that produce FDA listings and summary tables of clinical data. Assist statisticians in developing meaningful analysis of clinical data. Develop SAS code on Windows XP. Maintain, enhance and modify all aspect of Base SAS code on Windows clients and Windows 2003/NT Servers. Create group presentations/training for SyMetrics Clinical Data software. Produce project tracking. Created reports utilizing MS Excel, MS SQL and html for a marketing group.

Confidential

Consultant

SAS support of a CRM system, gathering, cleansing and grouping data from a wide variety of platforms. Developed SAS PROC SQL code on SUN OS 5.8 Oracle 8i, IBM MVS DB/2. Maintain, enhance and modify all aspect of Base SAS code on MVS, SUN, HP, Windows NT platforms. Develop SAS CEDA code utilizing seamless connectivity from zOS 1.4 UNIX System Services on several IBM mainframes to SUN OS 5.8, to Windows and HP UNIX 11. Produce statistical analysis of data to ensure integrity of information utilizing MS Excel Macros, Pivot Tables, for a marketing group. Perform independent analysis of data, make recommendations and assist in group decisions and conferences with entire group. The mainframe work included many batch utilities including JCL, FTP, PKZIP. UNIX shell scripts were developed for batch procedures.

Confidential

Web Developer

Analyze, design and develop an interactive web site to promote the local beach news paper. Developed using HTML, VBScript, Java Script and graphics files.

Confidential

Sr. Programmer Analyst.

Develop user dialogs for customer service in Visual Basic. Develop Transact SQL scripts to import and cleanse data.

Confidential

Sr. Programmer Analyst.

Designed and developed PC SAS programs to extract million plus VSAM records on the mainframe summarize them and import to the network to create user reports. Optimized other jobs for cpu, space and memory constraints. Installed PC SAS 8.0 on several machines.

Confidential

Sr. Consultant

Tampa. Design and develop a corporate enterprise intranet application based on Microsoft technologies to assist in the management of contracts and customer issues. The presentation layer uses HTML and ASP utilizing VBScript and JAVA Script. Business services layer is based on Microsoft Visual Basic, while the data services were developed on a Microsoft SQL 7 Server database. Utilizing N Tier architecture through Microsoft Transaction Server MTS Internet Information Server IIS and Component Object Module COM written in Visual Basic, ActiveX Data Objects ADO written as Visual Basic Scripts in ASP pages. Develop event and exception handling routines including triggers on the database that called the COM components. Utilize the visual basic debugger to test and debug functions and procedures.

Confidential

Web Developer.

Develop interactive systems for the web. These html or asp screens retrieve data from a Microsoft SQL 7 database and other data sources. Utilizing N Tier architecture through Microsoft transaction server MTS Internet Information server IIS and component object module COM written in Visual Basic, ActiveX Data Objects ADO written as Visual Basic Scripts in ASP pages. Remote Data Objects RDO Develop event and exception handling routines including triggers on the database that called the COM components. Utilize the visual basic debugger to test and debug functions and procedures.

Confidential

Sr. SAS Consultant

Assisting in a Data Warehouse project to report on global sales, competition and strategic performance. Develop PC SAS and SAS on HP UNIX programs in a client server environment, for remote submittal to a UNIX server. The SAS programs utilized mostly SAS/Base along with SAS macros, pass-through SQL, SAS/Access and SAS Connect. The data was collected from Microsoft Excel and Access, IBM AS/400 and MVS VSAM DB/2, along with Oracle. Also utilizing SQL, Oracle 8i database, HP UNIX 10.20 and Windows NT. The data was Extracted, Transformed and loaded into the SAS Data Warehouse. Some UNIX Shell scripts were written to perform various file manipulations including ftp and submitting batch SAS jobs.

Confidential

Work as a COBOL, CICS programmer on a Y2K conversion of the Criminal Justice System for Pinellas County. Analyzed and modified programs for the traffic court system.

Confidential

SAS Consultant

Developed a cross reference application written in SAS to view JOB, PROGRAM, COPYBOOK and FILE information. This was done with SAS/Base and SAS/Macros on an IBM MVS machine.

Confidential

Senior Programmer Analyst

Assisting in Year 2000 conversion of SAS programs. Analyzed programs develop unit test plans and assist in formulating system test plans. Implement SAS program modifications. Coordinate changes with other team members. Move modifications through change control. The programs were written in SAS. The files were extremely large, with tens of millions of records. This was done with SAS/Base, macros and SAS/AF on an MVS machine. The data was on SAS files, VSAM files, flat files and M204 databases. Also modified SAS system used to track film usage by professional photographers. The system used on-line SAS FSEDIT screens for data entry and modifications, with SAS/BASE batch processing for data summarization an reporting.

Confidential

Senior Consultant

Confidential Developed SAS/BASE programs to assist the Finance and Budget department of a major insurance company identify and correct errors in expense allocations. Analyzed the current process to report on Deferred Acquisition Costs, made suggestions to streamline the process. Increased efficiencies by creating two DB2 reference tables and eliminating manual entries. Replaced an IRMA download with a SAS/Connect file transfer to further streamline the process. Used SAS to read Microsoft Access and Excel data and developed DB2 Queries for summarization, analysis and reporting of the information.

Confidential

Systems Analyst, Securities Operations Systems.

Analyzed and modified COBOL85 programs that supported Raymond James Bank. Interacted with end users on project status. Assisted in daily support issues. Developed written system documentation. Trained in Tandem systems including Pathway, Tandem's on-line programming language.

Confidential

Programmer, MIS Department.

D demonstrated adhoc reports with SAS to for use by strategic planners in Marketing, Sales, Accounting and IT under very tight time frames utilizing SAS/Base, SAS/Toolkit and SAS/Connect on an IBM mainframe. Developed programs and then taught a class in SPSS to IT piers.

Confidential

Sr. Computer Programmer Analyst

Modified and developed SAS programs to support the fund raising mission of the University and the financial management functions of the Foundation. Redesigned the Alumni/Donor Database, increased efficiency of all programs - changes valued at 73,000. Redesigned change of address function adding 15,000 good address valued at 50,000 in new contacts and savings from returned mail. Introduced array processing, allowing the recognition of 1,000 new alumni from College of Medicine alone. Developing modular coding techniques, reusable code, copy books, implementing structured methodologies, developing database of programs. Trained junior programmer in mainframe utilities and SAS coding techniques. Produced strategic reports, mailings and files for the Alumni development officers in each of the colleges. This was done with SAS/BASE, SAS Macros, SAS/Toolkit and SAS/AF.

Confidential

Sr. Consultant.

Automated operational functions utilizing REXX Dialog Manager. Performed analysis on data, reports and job streams to resolve error conditions and improve performance. Maintained and populated DB2 Database, write adhoc DB2 SQL queries for problem analysis and resolution.

Confidential

Senior Consultant.

Responsible for planning and operations of an AS/400 business systems and databases provide technical support worldwide. Liaison with the hardware and software vendors, identifying and resolving problems. Design and implement a schedule for maintaining system objects, i.e. deleting spool files, ordering and installing PTFs. Cataloged application software and monitor its use. Performance analysis and tuning resulted in a 10 increase in machine efficiency and reclamation of 15 of total system storage. Setup and installed PCs for use with the AS/400. Configure the AS/400 for use with PCs utilizing 5250 protocols under PC Support/400. Utilized PC Support/400 to upload/download files between PC and the AS/400. Installed application software packages and upgraded the OS/400 operating system. Planned to attach the AS/400 to both the local and wide area networks, utilizing TCP/IP, X.25 protocols across UTP wires. Devised a backup and recovery plan to connect the AS/400 to the mainframe's 3380 tape drive for backup and recovery purposes, saving personnel time and allowing for better utilization of equipment.

Confidential

Senior Programmer Analyst

Assist in conversion of an IBM AS/400 system to an IBM 4381 OS/MVS system. Develop OS/MVS system and programming standards. Development of an on-line AS/400 RPG sales reporting system to validate and summarize store sales data. Analyzed, modified AS/400 job streams and data flow of Point-Of-Sale, General Ledger, Accounts Payable and Accounts Receivable, Distribution and Inventory systems. Created shell COBOL II CICS programs, copybooks, standardized routines and utilities. Developed COBOL II/CICS store sales reporting system.

Confidential

Programmer Analyst, Financial Systems Development Department.

Designed, developed and debugged COBOL II / CICS programs that support the Human Resources, Benefits and Payroll departments. Developed applications to interface with the McCormick Dodge Payroll and Human Resource Systems. Assisted the training new programmers in company data processing standards and procedures.

Confidential

Systems Engineer.

Modified, tested and debugged BAL programs and JCL procedures per client requirements. Rewrote job streams to improve performance. Installed and tested Cybertek's software for clients.

Confidential

Programmer/Analyst

• Merchandise Analysis Control Department and the Merchandise Information Systems Department.
• Created numerous SAS programs, for the company's strategic planners, to report on critical positions in sales and inventory. One Inventory/Sales study resulted in identifying 7 million dollars worth of overstocked items. These SAS programs were written in SAS/Base and SAS/AF.
• Assisted in the design and development of an on-line real-time commitment tracking / sales reporting / inventory control system, written in SAS, used by MIS as a prototype. Managed and maintained that system, along with assisting key personnel in its utilization. Assisted in the conversion of that system, from SAS programs and file structures to a COBOL / CICS / VSAM system.

OTHER TRAINING:

Business Software Applications:

Microsoft Office Word, Excel, Power Point, Access, Outlook , Microsoft Project Lotus Word Pro, Lotus Notes, Lotus 123

Software Development Tools:

PC SAS 9.2, Microsoft Visual Studio, Visual Basic and VBA, Microsoft Access, Microsoft SQL Server 7.0/2007, Home Site, Dream Weaver CS3, ANSI C