SUMMARY:

• Over 25 years of Information Technology experience ranging from design thru implementation to department supervision.
• Fifteen years of significant contributions and accomplishments in the healthcare/managed care industry.
• Created SAS research databases and worked on Bush Foundation Projects.
• Developed and implemented state - of-the-art SAS benchmark reporting systems.
• Worked on SAS files of over half a billion claims.
• Made enhancements to several SAS EG projects: added hash programming to speed up (2x) large merges, no need to sort.
• Added emails with attached report and return code (>4 bad) and elapse time displayed in the email subject line.
• Added print-to to retain SAS logs when desired.
• Automated SAS jobs using Task Scheduler in Control Panel/AdminTools on Win 7 to run in the early morning so reports ready by 7:00am.

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Analytic Consultant

Responsibilities:

• I was the SAS programmer/analyst on a project where my client was building new mortgage tables and improving many older tables with new and derived fields. Rarely were the new Teradata tables exact duplicates of the older, retired tables, do SAS proc compare results were inadequate. At the same time, an older SAS datamart was also being replaced with TD tables. We created an excel file to reflect the improvements in each new table.
• Each excel file contained at least a summary file of ever field verified for data accuracy (DQ). When a field had data issues, we would create an excel tab that included up to a thousand entries where the expected values didn’t match the TD values. In the desired outcome, every TD field checked out, and there was only a summary excel tab - no data issues were discovered. SAS Grid, PC SAS 9.4 (rsubmit/endrsubmit), TD SQL Asst, SharePoint.

Confidential, Eden Prairie, MN

Sr Research Consultant

• Productionized over 200 programs and reports. Created standardized %include modules across all programs. Modules like initialization, allocating libraries, creating pdf reports, emailing reports, etc.
• Worked on adhoc reporting for clients, classifying utilization and associated medical costs. Determined patients at risk of developing unwanted events. Used Census Bureau data and SAS 9.4.
• I participated in two phase 1 clinical trials, starting in 2010 and updated again in 2014.

Confidential, Bloomington, MN

Sr Data Quality Analyst

• Validated our monthly SAS loads of pharmacy and medical claims data
• I developed 3 SAS reports: Data Completeness report (null/not - null, compared to previous mths percents), File Integrity report, and a colored Score Card report comparing this mth to previous 3 mth s Q1/Q3 factors. I was a metadata SME for IBM s Infosphere Suite that includes Information Analyzer, FastTrack, DataStage, Asset Manager and Metadata Workbench to generate data lineage reports.
• Enhanced Employer Group Reporting by adding Top 15 drugs this qtr compared to last qtr. Also added 4X2 dashboard.

Confidential, Minneapolis, MN

SAS Consultant Home Mortgage Analytics

• Converted over 300 Oracle databases to Teradata databases. Generating DDLs to create and insert data thru views.
• Used SAS proc compare to validate data attributes and values between both RDBMs were exact.
• Loaded using BTEQ, FastLoad, or Mload, depending on row counts/Indexes.
• Used Teradata Assistant, Oracle Toad, Sybase PowerDesigner, SAS 9.2, Unix, ksh, WinsSCP, puTTY, Sharepoint.
• Agile methodology with sprints and scrums. Three environments: dev, uat, and prod

Confidential, Golden Valley, MN

SAS EG Consultant HealthCare Analytics

• Created 4 text extracts for the state of Massachusetts: Claims, Eligibility, etc.
• Extracted the data from MS SQL Server databases. Used SAS to analyze the data, build text files, and send email results.
• Used SAS EG, SAS 9.1 on Unix, Unix Scripts, MS Studio 2010, Toad, Putty, Visio, and WinSCP.

Confidential, Minneapolis, MN

SAS Consultant Database Marketing & Analytics

• Developed stratified random sampling routines in SAS to build 10% control groups who would not receive revenue generating emails. Compared to 90% who would receive those email blast offers.
• Build CRM subscriber databases, fixed faulty email addresses, remove dups. Migrated from odbc accessed SQL/Server tables to Linux base SAS tables. Refreshed Server tables by deleting/inserting.
• External clients were Continental Airlines, Enterprise Rental, & Chase credit cards (for hotel stays).
• Evaluated Revenue Optimization schemes for clients and further Text Analysis of Customer Reviews.
• Built daily response history, weekly contact history. Used SAS9.2, SAS-EG, UltraEdit, Putty, Linux, Linux Scripts, WinSCP, MS SQL Studio 2008 R2, Stored Procedures, Toad, VNC, and Lotus Notes.

Confidential, Eden Prairie, MN

SAS Consultant

• Follow-up Hypertension Study for NCQA. Parsed raw data from CIGNA, Humana, and KPGA. Reported on Cardiovascular risk levels in persons with Hypertension using certain Rx drugs. SAS.

Confidential, Eden Prairie, MN

Sr SAS Developer

• Worked in ARO Legacy (Audit/RecoveryOpportunities), Production Support (AutoSys & ITD Ticketing), and COB Extract Updates (149 Coordination of Benefits algorithms). SAS/Oracle/SQL.
• Familiar with BI versions of SAS 9 and Cognos 8 for Oracle data warehouses. Browsed with Toad.
• Have completed Teradata training. Used IBM Rational ClearCase for version control (check out/in).
• Automated 3 manual systems within SAS/Unix using Unix Shell Scripts to generate many xls/xml files.

Confidential, Minneapolis, MN

SAS Consultant Home Mortgage

• Further automation of the underwriting functions to reduce fraud and litigation. Worked on Wachovia integration of their Settlement Agent/Underwriting Systems. SAS/DB2/SQL/ODBC and shell scripts.
• Using SAS on UNIX and PC (Enterprise Guide), connecting to UNIX using putty and IPswitch on AIX 5.3 platforms. Helped convert daily treasury programs from DB2 interface to Teradata. All SAS files were proc exported by SAS EG to MS Access and Excel. Routed ODS to html with xls/xml extension.
• Completed all training modules related to protecting sensitive customer information and data privacy.
• Used crontab on unix box to schedule sas builds to run overnight when machine less congested.
• Certain import shell scripts were run every 15 mins to gather any loan applications, day or night.

Confidential, Roseville, MN

SAS Consultant RPS/Trust

• Updated Confidential ’s OMNI Plus Retirement and Pension Solutions (RPS) system. This included SAS programs and SAS Internet (SAS Broker 8 web tools) applications. SAS/DB2/SQL
• Updated data and forms FTP’ed to Broadridge (ADP) via Green Net for customer fulfillment mailing.
• Currently working on compliance issues due for implementation by end of year 2008.