SUMMARY

Over 25 years of Information Technology experience ranging from design and programming to department supervision. Fifteen years of significant contributions and accomplishments in the healthcare/managed care industry. Created research databases and worked on Bush Foundation Projects. Developed and implemented a state-of-the-art benchmark reporting systems.

PROFESSIONAL EXPERIENCE

Confidential,Minneapolis, MN 03/2012 – Present

• Loading Oracle and text data to Teradata databases. Generating DDLs to create and insert data thru views. Use proc compare to validate data attributes and values between two RDBMs. Load using BTEQ, FastLoad, and Mload, depending on row counts/Indexes. Using Teradata Assistant, Oracle Toad, Sybase PowerDesigner, SAS 9.1, Unix, WinsSCP, puTTY, MS Lync. Agile methodology with sprints and scrums.

Confidential,Golden Valley, MN 11/2011 – 02/2012

• Created 4 extracts for the state of Massachusetts: Claims, Eligibility, etc. Extracted the data from MS SQL Server databases and used SAS to build flat files, analysis and send email. Used SAS EG, SAS 9.1 on Unix, Unix Shell Scripts, Reflection, MS Studio 2008, Toad, Putty, VPN, Visio, and WinSCP.

Confidential,Minneapolis, MN 06/2011 – 10/2011

• 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 acessed SQL/Server tables to Linux base SAS tables. Refreshed Server tables by deleting and inserting . Built daily response history, weekly contact history. Used SAS9.2, SAS-EG, UltraEdit, Putty, Linux, Linux Shell Scripts, WinSCP, MS SQL Studio 2008 R2, Stored Procedures, Toad, VNC, and Lotus Notes.

Confidential,Eden Prairie, MN 04/2011 – 05/2011

• 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 04/2010 – 04/2011

• Worked in ARO Legacy (Audit/Recovery Ops –recovery opportunities), Production Support (AutoSys & ITD Ticketing), and COB Extract Updates (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 04/2009 – 12/2009

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

Confidential, Roseville, MN 2008 - 2009

• Updated Wells Fargo’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.

Confidential,Watertown, MA 2000 – 2008

• Ran and maintained Symmetry’s Episode Treatment Grouper (ETG) programs. Project manager on migrations from Symmetry ETG 5.0 to ETG 6.0 and SAS v6 to v8 and then v8 to v9. Processed, parsed, translated, (ETL) and grouped raw input files (using Symmetry’s ETG Grouper) from over 100 plans and 3.7 billion claims via Internet connection to the company’s UNIX boxes. SAS/Oracle/SQL
• Recommended and implemented testing with a 10% sample database before running full scale extracts.
• Evaluated SAS BI, SAP BO, and Oracle BI, before acquiring Oracle Enterprise Manager 9.
• Ensured data quality and completeness for 3.7 billion records on more than 15 terabytes of disk space.
• Converted UNIX reporting systems from SAS v8 to v9, rebuilding the format libraries via the v9 engine.
• Developed DQ metrics to compare plan iterations to identify any data issues before external clients do.
• Generated many SAS 9 reports using gplot, gchart, gslide, and 3x5 dashboards (greplay of these 3 reports).

Confidential,Eden Prairie, MN
Owner and Principal
Consulted with over 25 organizations to provide state-of-the-art IT support and services. Helped outsource to offshore programmers in Hyderabad. Have experience providing data, reports and verification for clinical trials. Highlights and summaries of most recent and relevant contracts are outlined below:

Confidential,Eden Prairie, MN 2000

• Merged MetraHealth claims data within UHG DB2 data warehouse. SAS/SQL
• Loaded MetraHealth data to UNIPRISE business services.
• Developed Year of the Heart Campaign for Human Resources.

Confidential,Eagan, MN 1998 – 1999 and 1995 – 1997

• Developed 3 major SAS reporting systems for the provider area to replace portions of older STAR and CRIB systems maintained by AIS.
• Designed, coded and tested monthly and quarterly benchmark reports, comparing PMPMs and other costs to regional and national averages developed by Milleman and Roberts (Actuary).
• Led the development and implementation of a Financial Reporting System that age-sex adjusted and member shifted the claims data by category of care for review by the Board.
• Instrumental in litigation by gathering patient demographics from various systems and coordinating work with Deloitte at the state level.

Confidential,Edina, MN 1997 – 1998 and 1993 – 1994

• Developed 12 of the HEDIS 3.0 performance rules, including antidepression, diabetes, and hypertension.
• These HEDIS reports were loaded to MS Access for further enhancements and printing.
• Key contributor with the Arthur Anderson audit of HEDIS reports for St. Louis and NCQA’s new audit standards for HEDIS for Salt Lake City HMO.
• Designed and implemented the Center’s Research Data Base of doctor, hospital and Rx claims for 10 HMOs. Loaded warehouse in SAS and DB2.
• Developed an extract program called cruncher to then pull claims from the SAS data warehouse.

Confidential, Edina, MN 1994 – 1995

• Converted systems that had been personally developed (the CRUNCHER and OTTO systems) at UHC to run on DPS’s UNIX box. This involved porting the SAS code and data from an IBM/MVS platform to an IBM/UNIX platform and developing UNIX shell scripts to replace IBM JCL to execute above 2 extracting/reporting systems..Have experience providing data, reports and verification for clinical trials.

Confidential,Bloomington, MN 1992 – 1993

• As a consultant, Mr. Fischer was the primary contact for any SAS related questions (SAS Help Desk). He helped in the orderly transfer of programs and data when Aetna “sold off” MedCenters Health Plan, which was then merged with Group Health to become Health Partners.
• Mr. Fischer assisted the department head of the University of Minnesota’s Graduate Program in Health Studies in doing a study for the Bush Foundation involving 27 various episodes of care over a two year study period. He also helped the Group Health Foundation do a study with Johns Hopkins University Medical Center involving seniors; their membership and Medicare costs.

Confidential,Minneapolis, MN 1991 – 1992

• As a consultant, Mr. Fischer was the SAS Help Desk contact for all SAS and JCL questions for all of Aetna’s five regional offices through out the US. Mr. Fischer also took over all SAS development for the last six months of his stay for the Virginia Mason Health Plan in Seattle, WA

YEARS OF EXPERIENCE

Unix and Scripting (15yrs),
Mainframe and JCL (12yrs),
DB/2 and-SQL(8yrs),
Oracle and SQL (7yrs)
SAS 6.12 (8yrs), SAS 8.2 (6 yrs), SAS 9.1 (3 yrs), SAS 9.2 (6 mths), Enterprise Guide (2 yrs)

Proc SQL with ANSI standards was introduced as a SAS Procedure in version 6 in 1990 (20 yrs ago).

Masters in IT