Summary

• 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.3 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, CORR, DATASETS, FORMAT, FREQ, MEANS, GRAPH, GMAP, UNIVARIATE, OPTIONS, PLOT, PRINT, PRINTTO, RAND, 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 5.1:, 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.

Databases:

EXPERIENCE:

Confidential

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. Assisted employees in the use and optimization of SAS Enterprise Guide SAS EG SAS Business Intelligence BI platform to automate and optimize data extraction and reporting.

Confidential

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

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

Confidential

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. SAS Administrator, utilize SAS Management Console to update metadata and create security groups for reports, web and data. SAS BI utilize SAS EG to automate and optimize BI applications to report on Call Center activities and ROI of products.

Confidential

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

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

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

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

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. SAS Administrator - Maintain, upgrade and modify all aspect of Base SAS installation 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

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

Analyze, design and develop an interactive web site to promote the local beach news paper.

Sr. Programmer Analyst.

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

Confidential

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

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

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

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

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. Write SAS programs to utilize the copybook information to report on retail sales data.

Confidential

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 and reporting.

Confidential

Tampa. 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

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

Demonstrate 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

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.