PROVEN DEVELOPMENT PROGRAMMING EXPERTISE IN A CAREER SPANNING 15 YEARS

Technology-driven SAS Professional and project manager with over 15 years experience directing program development and data warehousing, validation and test analysis, and consultancy operations in highly-competitive market environments. Exemplary analytical and documentation abilities with extensive experience in Banking, Insurance and Clinical Studies. Applies well-honed talents in strategic problem solving, cost-savings objectives, and long-range goals. Qualifications include:

• Specialized expertise in SAS programming.
• Recognized internal catalyst for change, continuously driving organizations in a quest for excellence.
• Articulate, innovative, and able to perform proficiently in a high-energy, fast-paced environment.
• Exceptional knowledge in multiple languages.
• Excellent communication skills used to inform, educate, motivate, and interact with industry leaders, co-workers, and clients.
• Broad technical background driving the development of information and database systems to optimize the use of existing infrastructure, maximize individual productivity, and help the company reach its full potential.
• Capable UNIX administrator with the ability to modify, add, and delete user IDs, passwords, and groups.
• Intense desire to turn extensive consultancy experience into a full-time position.
• Clinical Studies worked include Oncology, Diabetes at Pfizer and HIV, Hepatic and Respiratory at Boehringer.

CORE COMPETENCIES

SAS CONSULTANCY

CORPORATE DEVELOPMENT

DATA WAREHOUSING

DATASET SUPPORT

VALIDATION/TEST ANALYSIS

SAS SOFTWARE EXPERTISE

STRATEGIC PLANNING EXECUTION

SAS 9.1.3 WITH ENTERPRISE GUIDE 4.1

BUSINESS OBJECTIVES

SOFTWARE UPGRADE PROJECTS

Key Achievements

• Substantially reduced call costs by 7 , produced an annual cost-savings of 150K and considerably increased customer satisfaction by overseeing the creation of a consolidated Service desk.
• Spearheaded the management of more than 260 software testers, completing SAS and Windows 2000 validation software upgrade products resulting in a unified Windows 2000 system, saving duplication in operating systems and unifying productivity by using one operating system versus four.
• Instrumental in the FDA market acceptance of a new drug by performing the development and implementation of the analytical datasets used for NDA submissions.
• Successfully streamlined auditing processes and elevated the performance of data referencing methods by developing an Excel status-tracking system, in addition to a logbook that collected training data.
• Effectively reduced the number of SAS programs from 1000 to 100, reduced report turnaround time from weeks to seconds via a personally developed SAS front end menu system and reduced data gathering time and repeat problem resolution via Paradox from 6 weeks to slightly more than five hours per week.

PROFESSIONAL CONSULTING EXPERIENCE

SAS Programmer/Business Analyst

Confidential

Created HEDIS SAS data programs on an AS400/IBM system in response to a series of HELPSTAR requests. Wrote technical HEDIS specifications, data dictionaries and designed layouts. Proficient in the use of Base SAS, data steps, Proc Sort, Proc SQL, Proc Format, Proc Freq and SAS Macros. Met customers regularly to gather requirements, mentor new team members and ensure quality deliverables.

SAS Programmer

• Created more efficient datasets and Reports for Presales analytics to replace their ECR summary reports using SAS Enterprise Guide on an AIX/IBM Mainframe , SQL, proc means and reports. Found over 100,000,000 more in claims with improved crosswalk coding techniques. Created a data warehouse for regularly used data with high speed access capabilities. Experience includes training in SAS Management Console, SAS OLAP Cubes and SAS Security.

sAS and Business

• Created Data Warehouses in SAS on an AIX/IBM Mainframe, and Business objects for Claims, Provider, Pharmacy, Members and other subset tables. Provided training in SAS for other BCBS employees. Participated in many corporate required training courses including SAS Business Intelligence and Enterprise Guide courses via the SAS Institute.

SAS Programmer - Created SAS data sets using SAS SQLon an IBM Mainframe for the small business credit lines department CRU using Teradata, DB2 and Oracle as sources for our data warehouse. Rewrites to Teradata was a primary function.

sas programmer Created SAS datasets from DB2 tables using TSO ISPF on an IBM Mainframe, downloaded via CPORT FTP CIMPORT to SAS 9.1.3 on the PC uploaded portions of the data to access and excel for management review of medical event/claim procedures and pharmaceutical data. Also performed SAS XML, SQL via DATAstage, UDB with AIX. Wrote some initial Java scripts, worked with Visio, Project Management Software and Statistics.

SAS Programmer Translated variables from raw datasets to CDISC variables using the annotated CRF methodology, ran tables and listings for BioStats. Medra and Whoart drug trained via previous national clinical data management certification in 2002. See certification below.

SAS Programmer

• Automation, ETL, SAS Management Console, Web Studio and SAS Portal.

SAS UNIX Administrator

• Unix and SAS administrator for the largest sas marketing system in the United States. Sun Solaris 10, SAS 9.1.3, ETL Studio 3.0 with Service Pack 3, Enterprise Guide 3.0/4.1, UltraEdit and Remedy help desk system .

SAS Senior Programmer

• SAS Data Warehouse manager responsible for creating an analysis dataset monthly for 25 actuaries and 20 outside extracts for companies and agencies. Claims, Premiums and Membership data processed. Tools used include Heat for help desk tracking, MoveIt for secured data transfers as well as MS Professional tools. Terminal Server Windows 2003 system with XP local operating system using SAS 9.1.3. Coding, debugging, SAS batch processing with macros and SQL coding are standard daily processes.

SAS/VMS/EXCEL Programmer,

• Provide reports to management in regards to the progress of both offshore and on-site teams, in order to test and install new ARGO banking systems.
• Oversaw the quality assurance of all offshore programming, the addition of macros, development of Technical specifications and documentation, the linking of Proc SQLs to Oracle, testing, gaining user approval of output, and adding programs to production.
• Oversee the summarization of data into an Excel report in order to create graphs and PowerPoint presentations for Managed the programming duties of three offshore programmers, following file specifications required by the bank.
• Performed various functions, such as the loading of new tapes, translating Pic clauses in COBOL into SAS input statements, dataset development, performing Proc Summary, Proc Download and Proc Export in order to create Excel spreadsheets.
• Updated 50 programs in the actuarial system with 8 more years of premium, loss, expense and reporting capability via expanded do loops and arrays. Also tested and implemented the programs into the existing system.
• Developed CSV files and reported offshore progress to management with the use of Excel, as well as storing daily report activity onsite through the creation of an Access database.
• Liaisoned as knowledge expert to the senior vice-president on ad-hoc campaign management reports, developed after various marketing requests.
• Analyzed previous ad-hoc management requests and developed analysis datasets based on those trends.
• Updated the Cognos daily feeds, utilized daily by marketing and management.
• Utilizing the main Oracle database, compared incoming data from outside product vendors in an effort to ensure quality data submissions.
• Created the Edit Check programs on SAS and Linux as a part of a program for the Center for Disease Control, which analyzed symptoms to body systems, and provided for resulting statistics to be uploaded to the internet using SAS IntrNet JavaScripts, in a graphic format.
• Oversaw the production of SAS Analysis DataSets in order to assist hospital directors, and the creation of Proc Tabulate reports, which were sent via ODS HTML.
• Managed the design and development of a new Statistical Reporting System, which utilized JMP from IBM mainframe inputs.
• Designed and developed engineering Statistical results using a graphic format via JMP.
• Utilizing SAS guidelines, created scripts as required by the client.
• Programmed, performed testing on and validated over 100 SAS databases by utilizing Proc Compare in an SAS version 8.2 PC Enterprise Guide environment for the new Auto Actuarial Test and Learn Project.
• Using an Intranet Adobe Acrobat system, copied rates into Excel in order to make them readable in SAS self-created programs, which utilized SQL and macros.
• Developed and provided modifications to new PC SAS version 8.2 programs, utilizing PROC SQL, PROC REPORT and Macros for Claims, Premiums and Membership data.
• Created large Claim datasets average of 205K rows by 80 columns , which included Parents and children receiving Medicare via State Unemployment or Welfare Programs.
• Performed a major role in the support of a 600 million row SAS data warehouse, providing Helpdesk programming and instruction for vertical consumer and collections-run teams.
• Successfully intercepted a crucial data warehouse server crash by accelerating the renewal of 6 SAS licenses about to expire.
• Oversaw the development and implementation of SAS Helpdesk applications and fixes, which involved finding a resolution for ticket problems in over 7000 current programs, Excel input files, or in progress, including issues such as bad/data or logic, SAS licensing, SQL, Macros, Excel CSV, SPDS/Oracle or connection problems.
• Administered an extensive 10-week classroom training class on SAS BASE, Macro SQL and SPDS with the assistance of SameTime/PowerPoint software, and teleconferencing for five off-site locations.
• Performed extensive SAS coding support for Phase III Anti-Viral, Respiratory and Heart Clinical Data reporting in Rage, a centralized program.
• Oversaw the development of SAS applications to retrieve Oracle Database records.
• Created various programs, including SAS PROC Tabulate, PROC FREQ, PROC Means, PROC Sort and PROC Reporting.
• Taught several classes in a high school, including Commercial Electric, HVAC, Carpentry and Computer Repair.
• Supervised 3 QA Analysts using IQ, OQ and PQ.
• Managed the implementation of functional 'black box' testing of Windows 2000-based software, to prepare for a migration from NT/9x.
• Interacted with vendors to acquire certification letters, product documentation and Win2000 test plans, recording and supervising test results in an online application inventory system.

OTHER PERMANENT EXPERIENCE

• Managed a Y2K QC Project, utilizing MS Project Manager in the conversion of sixteen offices across four countries, overseeing ten programmers using SAS, C , Informix and VB, four IT/Helpdesk technicians, 2 statisticians, and 260 validation testers using IQ, OQ, and PQ.
• Created SAS programs in order to extricate data from the VAX and ORACLE clinical databases utilizing SAS view and SAS datasets for Phase II, III and IV phases.
• Deployed a 21 CRF Part 11 security and tracking/versioning system.

State of Connecticut

• Created and implemented the State Department of Mental Health and Addiction Services online claims reporting system, which retrieved client records, created SAS PROC tabulate tables, PROC FREQ, PROC Means, PROC Report and Chi Square reporting for Phase III and IV studies.
• Developed several programs for the State lottery, including Dataflex customer service, marketing, inventory control, management, and accounting reporting programs.