SUMMARY:

• Senior SAS developer with over 29 years of experience in development, design, automation, implementation and upgrading of complex SAS code and analytical processes.
• Utilized agile model methodology to design, develop and deploy an automated process in SAS Enterprise Guide on UNIX to replace an existing SAS process resulting in 97% reduced processing time from start to finish.
• Integrated test plan and use cases for Origins process and led QA testing of new process alongside expected results.
• Developed an end - state dynamic and automated SAS software solution for all Disney Cruise Line qualitative surveys by utilizing SAS SQL, SAS macros, PROC REPORT, PROC TRANSPOSE and SAS multi-dimensional array processing, thereby eliminating need for repetitious manual SAS and Excel VBA coding updates.
• Led efforts in Disney CIMA (Consumer Insight Management and Analytics) to adhere to best practices and coding standards in all facets of SAS Version 9.4 Software programming in SAS.
• Optimized Microsoft SQL Server T-SQL code to manipulate and modify DCL survey data on SQL tables.
• Wrote SQL Stored Procedures to control roles for security, create parameters and allow for reusable code for modular programming.
• Tasked with understanding data and business needs in order to translate business requirements to technical specifications.
• Managed offshore resources to prioritize work schedule based on Jira KANBAN board requests.
• Utilized Perl to parse survey data responses using technology to identify strings in data columns.

TECHNICAL SKILLS:

Operating Systems: Mainframe, UNIX (HP-UX, AIX, Solaris), Windows (NT, 95, 2000, XP) TSO/ISPF

SAS Modules: BASE, EG, MACRO, ODS, STAT, SQL, Graph, BI, DI Studio 4.9, Visual AnalyticsSoftware:Python, Teradata, SQL, SQL Server, JavaScript, HTML, Oracle, DB2, NETEZZA

PROFESSIONAL EXPERIENCE:

Confidential

Senior SAS Developer

Responsibilities:

• Standardized and homogenized CECL Probability of Default (PD) and Loss Given Default (LGD) economic model variables in retail markets.
• Created efficiencies in logistic regression models by utilizing extensive SAS macros and array processing in SAS.
• Performed unit regression testing on all new code and changes to the existing code.
• Led effort in QA of data mapping for new and existing model parameters and financial variables.

Confidential

Contract - Senior SAS Developer

Responsibilities:

• Led effort to develop SAS Enterprise Guide Version 9.4 Software automated process to convert manual Microsoft Excel software solution to monitor and quantify health care measures and EPIC data in accordance with HIPAA guidelines.
• Constructed Microsoft Excel files and table lookups to interact with SAS code to dynamically filter and output data and reporting.
• Developed SAS Graph reporting with SAS SGPLOT to PDF using SAS Software ODS REGION and SAS macro code.
• Consulted with business stakeholders and SAS programmers to solicit feedback and proposals for continued conversion efforts.
• Acted as Project Manager to solidify requirements and track steps in project plan.
• Reduced processing time of updating and reporting process from two months to one day and eliminated manual data entry.

Confidential

Contract - Senior Data Scientist

Responsibilities:

• Streamlined and overhauled SAS Version 9.4 process on Linux to combine CMS Medicare files, Hospital data and other health care claims data in order build summary datasets for on-line web reporting tool for tracking and reporting.
• Utilized PROC SGPLOT and SGPANEL in SAS Graph to produce bar charts and line plots for analytic reporting.
• Designed and programmed SAS code to create data relationships based on DRG, CPT, ICD-10 code requirements.
• Maintained and fostered a collaborative relationship with internal Health Economics & Market Access (HEMA) and external customers Marketing, Clinical, New Business Development and Corporate Sales .
• Developed hash code in SAS to decrease processing time of large table joins.
• Confirmed CMS release data period per reporting cycle and ensured appropriate Limited Data Sets (LDS) files were downloaded and saved in programs for extraction of data.
• Mentored junior SAS programmers in order to create efficiencies and reduce processing time in data analysis.
• Utilized Truven Health MarketScan Research Databases for validating results of longitudinal studies of procedures

Confidential

Senior SAS Developer

Responsibilities:

• Redesigned and automated KYC (Know Your Customer) Wealth Management application in SAS by utilizing SAS hashing techniques and dynamic SAS macros to produce automated Excel reports to email.
• Utilized SAS LIBNAME and FASTLOAD options in UNIX SAS to create Teradata tables linked as external sources in Microsoft Access applications.
• Created ETL tool to source and summarize transactional data for reporting.
• Constructed complex SQL queries and sub-queries to join multiple tables in Teradata and DB2 environments using SAS Pass-Through logic and Teradata SQL on UNIX SAS Grid environment.
• Created SAS Version 9.4 Macro code in UNIX platform to zip and delete files dynamically within SAS on UNIX modules.

Confidential

Contract - Senior Data Scientist

Responsibilities:

• Collaborated with senior statisticians and epidemiologists in order to generate oncological/statistical analyses (e.g. tables, listings, figures, graphs and other statistical output) to illustrate longitudinal patterns of cancer drug therapy in order to find trends and patterns.
• Extracted and ensured data quality of oncological metrics pulled from clinical study databases including IMS for RX data, prevalence and incidence data, CMS Medicare and Wolters Kluwer drug information using Base SAS software.
• Produced benchmarking metrics integrating such factors as physician specialty, drug volume, incidence, prevalence and various demographic classifications in order to validate plots and table illustrations produced by SAS Graph.
• Ensured the validation and quality assurance of the output by independent programming of SAS Macro code to generate dynamic QA results thereby eliminating the time-consuming and error-prone manual checks.
• Built and implemented SAS programs and reusable macros containing complex SAS PROC GPLOT graphs and various statistical outputs.
• Developed efficient SAS code to extract and manipulate large datasets for patient or disease cohorts, and summary data for reporting and trend analysis.

Confidential

Contract - Senior SAS Developer

Responsibilities:

• Developed SAS Version 9.4 macros and provided technical assistance to analysts at Bank of America who supported the marketing campaigns of customer retention vis a vis attrition.
• Designed complex Teradata SQL queries and ensured optimal and efficient code.
• Delivered SAS programs to apply filters for purposes of segmenting accounts across different account structures.
• Produced rigorous testing methodology for ensuring quality assurance of financial data metrics.

Confidential - Wilmington, DE

Senior SAS Engineer

Responsibilities:

• Delivered an end-to-end Model Risk Management MRM (Dynamic Scoring Engine) utilizing SAS Software and SAS Macro language on a UNIX platform in support of a G-SIFI CCAR/CECL mandate for Consumer Credit Cards.
• Provided technical documentation, validation and inventory control for all Transitional Matrix Model development.
• Developed independently a “glass-box” front-end driver to bundle efficient SAS Software source programs.
• Built automated predictive model, dynamic transition matrix formulas, compound and dynamic transformations of macro-economic variables, scoring programs and automated conditional probabilities on multinomial and binomial distributions.
• Constructed extensive SAS macros in order to automate and facilitate the calculations of forecasted data based on current and future economic metrics including Housing Price Index, Unemployment Rate, GDP.
• Guided SAS Version 9.4 programming in CCAR model development toward construction of dynamic transformation of economic data and probability factors to enhance model efficiency and quality.
• Led functional testing and impact analysis of CCAR model development.

Confidential

Senior SAS Developer

Responsibilities:

• Created SAS Version 9.4 code to report and tabulate results for Broadband outcalls and sales summarized by agent and management levels.
• Automated SAS reporting by utilizing UNIX shell scripting with trigger commands and do loops.
• Built ETL Teradata SQL queries to support marketing initiatives and product launches.
• Reviewed current manual processes for reports, gathered business requirements and automated programs that would provide those reports to business customers in a scheduled manner (Daily, Weekly, etc.).
• Designed, built and delivered BI solutions utilizing Cognos Analytics.
• Developed rigorous data quality checks to ensure validity and integrity of data.

Confidential

Contract - Sr. SAS Developer

Responsibilities:

• Streamlined extraction and reporting of provider-based claims in health care data reporting via database warehouse.
• Constructed parameter input driven SAS MACROS to eliminate manual processes in Utilization and High Cost reporting of patient and pharmacy claims.
• Upgraded existing metrics by constructing dynamic and automated SAS ODS to EXCEL reporting.
• Eliminated manual user inputs and processes by creating efficient driver SAS programs in order to pass user parameters dynamically.
• Used SAS Macro code within SAS PROC SQL Pass-Through to eliminate redundancies and slow processing.

Confidential

Contract - Sr. SAS Developer

Responsibilities:

• Upgraded existing code and manual processes in SAS EG programs into streamlined functionality using SAS MACRO.
• Developed automated system of reporting health care Utilization by using SAS ODS and SAS MACRO.
• Discussed functional requirements and defects with business users and stakeholders.
• Executed test case design and built SQL test cases to validate parallel reporting systems.
• Provided analytic support to quantify and validate quarterly and monthly predictive model releases for loss mitigation.
• Tested defect and break-fix specific code modifications using SQL and SAS.
• Expedited and constructed an automated process in SAS Version 9.1 to extract data from Oracle database to replace a manual generation of monthly reporting in Business Objects, in effect reducing turnaround processing time from a month to minutes.
• Enhanced health care reporting capability by creating dynamic user-input interface utilizing EXCEL as a parameter file to SAS on a 900+ reports monthly process.
• Eliminated manual emailing of reporting to BCBS Agents by using SAS to programmatically email in-stream in SAS.
• Led initiative in metrics reporting to streamline all facets of SAS Mainframe reporting.
• Programmed ad-hoc reports for Major Accounts Consulting Group (MACG) and agents of Blue Cross / Blue Shield of FL
• Maintained Monthly / Quarterly Production cycle and submitted reports to staff via Mainframe and UNIX platforms.

Confidential

Contract - SAS Administrator

Responsibilities:

• Collaborated with credit card and retail marketing managers for best business practices for metrics reporting.
• Led efforts to build SAS Data Warehouse via SQL pulls from Oracle for Credit Reporting and Scoring for utilizationin web-based on-line reporting tool.
• Facilitated on-site meetings with software company representatives in efforts to select optimal ETL tool.
• Installed SAS Version 9.1 software on UNIX Servers and trained staff on technology.

Confidential

Contract - Data Analyst

Responsibilities:

• Performed intermediate level system analysis, definition and design activities for new Cognos reporting applications.
• Developed metrics to analyze lift of T1 vs. Control accounts in marketing launches and pop-up campaigns.
• Created efficient SAS Version 9.0 programs to automate daily activity of AOL accounts in Hard/Soft Block status.

Confidential

Contract - Senior SAS Developer

Responsibilities:

• Independently designed, developed and implemented a web-based predictive modeling tool utilizing SAS Version 9.0, HTML, SAS MACRO and Java Script.
• Created an NPL (Non-Performing Loans) Loan Mod Re-Default Collection table using SAS PROC SQL from data collected on CDW ( Corporate Data Warehouse) DB2 tables.
• Designed a Mainframe SAS program to automate Seller Cash Pricing process across Legacy and PE (Project Enterprise) systems.
• Executed test cases, test scripts and contingency plans to support UAT in data validation on the CDW.
• Designed and executed Unix shell scripting to automate and enhance conditional generation of data in SAS programs.

Confidential - New York

Contract - Senior SAS Developer

Responsibilities:

• Coordinated with marketing analysts to discuss reporting requirements in support of marketing strategies and project proposals.
• Designed and implemented automated process of Oracle-to-Excel spreadsheet reporting tools in Windows architecture using SAS MACRO Language, PROC SQL, VBA and DDE.
• Programmed numerous ad-hoc SAS-to-Excel reports and graphs, including Physician Targeting metrics, Payer Plan penetration of products comparisons, Market Share reports, Detailing and Sampling Analysis based on Quintile prescription levels.
• Combined incidence of disease by geographic elements with population demographics and competitive market levels of product to enhance reporting on disease metrics and graphs.
• Programmed SAS Version 8.2 code to extract data from NDC, IMS and aligned drug data with patient health claims to quantify disease combined with RX use to categorize and quantify metrics for Confidential dominant drugs.
• Developed SAS Version 8.1 code to automate transfer of results from PROC FREQ procedure output to Excel spreadsheets utilizing SAS MACRO and DDE.
• Coordinated with IBM representatives to develop reporting specifications based on business rules for transformation logic and conditional output of data.
• Documented all phases of data creation including, the input of IBM metrics data, the transformation logic and final target variable creation.

Confidential

Contract - Mainframe SAS Programmer

Responsibilities:

• Led effort in Capitol One’s expedited six-week timeline to convert Easytrieve on Mainframe to SAS Version 8.1.
• Validated new SAS code and functionality by parallel processing of programs with the use of CA utilities to compare files in UAT.
• Assisted SAS programmers and coordinated efforts toward efficient compliment of skill levels to all levels of complexities in the conversion process.
• Developed SAS Version 8.0 code to segment customers according to billing cycle for Accounts Receivable.
• Coordinated with analysts to obtain requirements and reporting specifications.
• Programmed an automated system in SAS to pass data from Oracle Financials to Excel.

Confidential

Contract - Data Analyst

Responsibilities:

• Selected data elements from HCUP (Healthcare Cost and Utilization Project) including NIS (National Inpatient Sample) and SID(State Inpatient Databases) and SASD (State Ambulatory Surgery Databases) discharge data.
• Developed SAS Version 8.0 programs to link AHA (American Hospital Association) hospital survey data to HCUP databases to provide characteristics of hospitals with associated procedure/diagnosis information of discharged patients.
• Worked with AHRQ (Agency for Healthcare Research and Quality) researchers in formulating analytical approaches andstatistics to support research hypotheses.
• Liaised with NIH researchers to interpret research methodology and hypothesis testing in order to translate requirements
• Created SAS Version 8.0 programs to extract and transform variables from transactional account data in developmentf a customer attrition model based on logistic regression.
• Utilized Informix SQL and SAS SQL Pass through facility in ETL.
• Developed complex SAS Macros to compute both household level transaction data and ratios by channel, and total andpercentage difference in month-to-month dollar amounts by channel type.
• Streamlined USPS mail delivery reporting and metrics by converting complex SQL Macros into SAS Data Step programming.
• Implemented and delivered automated SAS programs for reporting ADVANCE Quality Check System (AQCS) USPS metrics.
• Extracted SAS Data Sets from SUN Solaris servers and transferred reports to Microsoft Excel on Windows95 via DDE.

Confidential

Contract - Mainframe SAS Programmer

Responsibilities:

• Migrated all Mainframe SAS code in Waiver Code Consistency System (WCCS) from US Airways to SABRE.
• Streamlined Mainframe SAS Version 7.0 programs to minimize transactional interface with up-line system requirements.
• Delivered SAS reporting for analysis of Waiver Codes metrics for US Airways staff managers.
• Let effort to safeguard WCCS SAS code against Y2K date anomalies and errors.
• Created roster files from Mainframe SAS for execution of mail campaigns for delivery to Marriott Rewards members.
• Developed Mainframe SAS Version 6.12 programs to quantify Marriott Rewards status based on member hotel stays/nights accessed from RDBMS.
• Coordinated with marketing department staff to finalize specifications and business rules for Marriott Rewards initiatives.
• Functioned as the Lead SAS Developer for all email and postcard campaigns for Marriott Rewards customers. Was responsible for all the weekly and monthly campaigns and worked with the vendors to make sure the campaigns were deployed smoothly.
• Fulfilled ad-hoc email campaign list requests using the SAS software.
• Responsible for coding Mainframe SAS Version 6.12 programs to report financial and geo-coded analysis to marketing division.
• Led initiative in SAS reporting to fulfill Housing and Urban Development (HUD) congressional initiatives.
• Managed effort to automate generation of comma-delimited files for import into Microsoft Excel for reporting and analysis.
• Served as member of a team of SAS programmers in the Credit Card Analysis department.
• Responsible for generating ASCII text files to effect changes to member credit card interest rates.
• Created SAS Version 6.12 code to generate data for bankruptcy analysis and forecasting database.

Confidential

Contract - Mainframe SAS Programmer

Responsibilities:

• Developed system requirements for revenue retrieval from multi-layered toll billing systems.
• Created Mainframe SAS Version 6.11 program for the purpose of converting e-mail text scripts into formatted text files.

Confidential - Washington

Full Time Salary - Data Analyst

Responsibilities:

• Developed and implemented financial database applications using FoxPro for regional offices.
• Accountable for key indicators trend analysis reporting based on SAS Version 6.03 developed code.
• Created Mainframe SAS programs to report key indicators on real estate owned properties, REO.
• Designed and maintained FoxPro database for tracking Key Indicator reporting for Loss Mitigation.