HELP DESK SUPPORT / SAS PROGRAMMER / SYSTEMS ANALYST DATA MANAGER

Ready To Accept Challenges Articulate Resourceful Detail Oriented

Results - oriented Professional with over 20 years of programming and data management experience in telecommunications banking information technology and the health research industries. Demonstrated project management skill set that consists of providing technical direction and managing intermediate to senior level System/Programmer Analysts Health Research Analysts and IT professionals assigned to multiple tasks. Highly self-motivated Professional recognized for accomplishing assigned tasks and goals utilizing strong communication interpersonal and team-building skill sets.

CORE COMPETENCIES

• Specialties Statistical Analysis/Modeling and Data Management Clinical Trials Informatics Design of Relational Databases Quality Control Data Mining and Marketing Campaigns
• Skills Base SAS Enterprise Guide SAS Stat SAS Graph Macros SAS ACCESS ODS SAS SQL Report Transpose Summary Means Tabulate and Merge Procedures PROCS
• Statistical Modeling Univarate and Multivariate Regression Analysis Generalized Regression Modeling ANOVA/ANCOVA/MANOVA Non-Parametric methods Categorical and Longitudinal Data Analysis Survival Analysis mixed models Factor Analysis PCA LDA Sampling methods Bayesian Statistics Monte Carlo Markov Chain simulation Experimental Design Protocol Design Survey Sampling
• Data Mining Linear Programming Clustering/Classification Kernelization Feature Selection SVM Boosting and Tree Generation CART EM Method Loss/Risk Functions Score Functions Decision Trees CHAID Linear Optimization
• Computer Languages SAS Fortran90/95 C/C MySQL SQL UNIX/LINUX/WINDOWS COBOL JavaScript HTML
• Technical Blackboard Visual Studio IBM z/OS Windows 7 XP 2000 WiFi infrastructure SAS/Connect SAS/SHARE SAS Scheduling Load Sharing Facility LSF PeopleSoft Oracle 12c ABT Project Workbench 3.1 Microsoft Project Professional 2003 Microsoft Office Access Excel Outlook Power Point Word Visio Microsoft SharePoint Microsoft Works 4.5 SPFPC DBMS Copy V7 Flow Charting 4 Knowledge Seeker Easytrieve HP OpenMail HP OpenTime and Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential

IT Analyst

Developed and scheduled reoccurring production reports using strong quality control methods and analytical ability to assess accuracy of reporting output which included researching details of summarized reports while incorporating advanced programming skill set. Demonstrated an ability to understand DB2 relational databases in order to write effective and efficient SAS code and SQL extract data. As a member of the Applications Services Team provided support and ad hoc reporting solutions using SAS Job Control Language JCL Sync Sort and SQL to the power companies Alabama Power Georgia Power Gulf Power and Mississippi Power as a member of the Applications Services team. Utilized interpersonal written and verbal communications customer service time management planning and organizational skills to accomplish assigned tasks independently or as a team member. Incorporated IT change management policies and procedures while accomplishing the development of full life-cycle tasks or adhoc assignments. Demonstrated the ability to handle multiple tasks with competing priorities as well as prioritize work assignments and meet deadlines.

Confidential

Senior Auditor

Utilize Computer Science skill set to understand and reverse engineer the Teller Data Analysis system which was written using VBScript Microsoft Sequel Server Job Control Language JCL and Easytrieve. Provide subject matter expertise in Time Sharing Option/Interactive System Productivity Facility TSO/ISPF Job Control Language SAS/BASE and SAS Enterprise Guide 5.1. Utilize SAS Enterprise Guide to create Microsoft Access Database tables and Excel Spreadsheets from ARGO and BANCSTAR data.

Confidential

Statistician/Statistical SAS Programmer Health Research Analyst

Provided knowledge and subject matter expertise in using the Consolidated Statistical Platform CSP in order to write and execute Base SAS 9.2 programs. Wrote and bench marked SAS programs executing across multiple compute nodes on the CSP for the purpose of streamlining processing time during metadata uploads of the Immunizations Demographic and Vaccination metadata into TIPS using the newly created data libraries. Created MS Excel spreadsheets to calculate 20 year space allocation projections for the Immunizations Demographic and Vaccinations data used in TIPS. Wrote SAS programs to produce Immunization reports in accordance to the IISS-TIPS requirements document. SAS Subject Matter Expert SME provided knowledge and subject matter expertise in the research and design of a SAS Grid computing environment using the Red Hat Enterprise LINUX operating system. Provided SAS templates for using Base SAS 9.2 and SAS Enterprise Guide 4.2 in a Grid computing environment using Windows as the operating system. Attended Research and Development Center RaDC meetings in order to provide SAS SME support to all research initiatives.

Confidential

Statistical SAS Programmer Lead Data Manager

Provided SAS knowledge and informatics expertise to the Clinical Outcomes Team COT Project Officers Branch leadership team and Data Management colleagues. Adhered to all data security requirements and procedures when handling confidential data and all related materials. Created SAS programs and analytical reports for the Medical Record Abstraction MRA and the Interview components of the Medical Monitoring Project MMP . Applied quality assurance methodologies to the cleaning and verification of all of the CDC and Project Area. Composed and maintained documentation on the procedures used to create SAS data sets for the components of MMP. Created a strategy to convert the AIDS Inventory and Dash Databases which was developed in ADABASE SAS data sets on the Consolidated Statistical Platform CSP as part of the CDC initiative to decommission the IBM 3390 Mainframe. Documented the procedures and programming techniques used to migrate the AIDS Inventory Data from the mainframe platform to the CSP Developed SAS programs in order to create SAS data sets from the sequential files on the CSP as part of the CDC initiative to decommission the IBM 3390 Mainframe. Monitored the usage of storage space for the AIDS Inventory data sets as well as provided projected storage needs for additional data collection.

Confidential

System Analyst

• Provided extensive knowledge utilizing the Interactive System Productivity Facility ISPF to invoke the
• Time-Sharing Option TSO on the IBM 3390 Mainframe in order to create a Data Migration Survey.
• Conducted interviews using the Data Migration Survey to gain knowledge of how the Centers and Branches
• at the CDC are utilizing SAS on the IBM 3390 Mainframe to accomplish its mission. Held meetings with the
• SAS user community at the CDC to gain an understanding of how SAS was being used on the mainframe in
• rder to develop a strategy to convert users to an alternative platform. Provided SAS programming expertise
• in the creation of the Consolidated Statistical Platform CSP utilizing windows based SAS grid computing.
• Used SAS/SHARE to allow multiple users on the CSP to access the resources of the SAS grid computing system simultaneously. Utilized SAS scheduling in conjunction with Load Sharing Facility LSF commands to test the ability of the CSP to execute multiple SAS programs across multiple blades for optimum speed for performance during the user s peak processing times. Created SAS programs to test the functionality and performance of the CSP using various methods such as stress testing and bench marking to verify the functionality of SAS grid computing. Created training templates in order to assist the CDC scientific community on how to use the CSP and its resources. Scheduled CSP Training Sessions with the CDC SAS user community to provide technical instruction both remotely using SMS Tools as well as in a traditional classroom setting. Managed the metadata repository of CSP user profiles adding and deleting users as well as created backups of the metadata for redundancy purposes. Maintained a database of CSP users and their perspective security levels for the purpose of communicating updates and system outages.

Confidential

Associate Program Manager/SAS Developer

Interacted with Marketing Project Managers on creating SAS programs as prescribed by campaign specifications in order to produce time sensitive initiatives to stimulate credit card sales for Home Depot credit card holders. Actively worked with Risk and Decision Management DM teams to support the execution of marketing campaign strategies by converting user supplied specifications into intermediate to complex SAS programs. Provided recommendations to Marketing regarding infrastructure operating guidelines and procedures audit and business reporting for time sensitive campaigns. Supported Citi wide strategic initiatives as prescribed by the campaign specifications. Communicated with Marketing regarding Campaign processing standards and procedures audit requirements and prescribed reporting deliverables. Maintained a close working relationship across functional areas such as Marketing Risk and Decision Management to ensure timely response to business needs.

Confidential

Lead Programmer/Supervisor

Managed and statistically analyzed large databases using SAS on both the mainframe and PC environments. Developed new MS Access applications and modified existing MS Access database applications in accordance to user specifications. Provided user support and troubleshooting techniques for newly developed MS Access applications remotely deployed and utilized nationally in the state health departments. Transferred data from a MS Access based data collection application to relational SAS databases on the mainframe and PC environments. Produced data subsets and performed statistical analysis with the guidance of CDC Health Scientists and Epidemiologists as well as performing data consistency and accuracy checks on the data subsets. Executed intermediate to complex SQL statements in order to create or modify database tables as well as manage the MS Access database indexes and primary keys. Provided documentation for all newly created databases and modifications made to existing database as part of the standard operating procedures SOP s . Communicated all database modifications to Informatics team Health Scientists the Epidemiologists and the state health departments as the Lead Supervisor. Perform evaluations on current and new data sources in order to utilize the most complete data for the database loads. Wrote requirements based on analysis meetings held at the annual grantees events. Provided SAS and JCL programming language training to new and existing Developmental Disability Team members voluntarily and upon request. Provided supervision to a team of Programmer Analysts which required the writing of and administering performance reviews the approval of smart goals time cards vacation requests and business travel expenditures. Provided technical direction to Developmental Disabilities programming analysis team. Monitored workload for the programming and analysis team.

Confidential

Project Leader/Programmer Analyst III

Applied the Corporate Systems Development Methodology CSDM life cycle toward the analysis design programming and testing applications for the Special Services Billing System and the Private Line Billing System. Created and maintained VS COBOL II JCL and SAS programs and the documentation for the Special Services and Private Line Billing Systems. Documented and reported assignment status to the Manager and Project Manager of the Commercial Billing Department.