Professional Summary

Highly dedicated and resourceful individual seeks challenging and rewarding position in information technology field.

Relevant Experience

Confidential

Oracle BI Publisher Developer

Duties and Responsibilities:

• Assumed contract from the prior Application Development Organization ADO , created the first two production fixes for the Provider Quality Reporting System PQRS .
• Supported two application releases for the Hospital Reporting HR Annual Payment Update APU application which is a Cognos dashboard used by CMS hospitals to scorecard progress and success for their possible annual incentive payment.
• Lead developer for the Hospital Reporting 1.0 Annual Payment Update dashboard, which is a real time measuring tool for Hospital incentive payments.
• Team lead and main contact for DECC to CMS' Infrastructure Contractor for the Cognos 8.3 to Cognos 8.4.1 fix pack 3 upgrade which was required in order to upgraded to Oracle 11g to meet and fix security holes
• Cognos framework developer for 8.2, 8.3, 8.4.1, and 10.2 that made changes to models for scheduled application releases.
• Application developer that worked with data architects to help them understand and develop and enterprise solution that would support the legacy, current and future data requirements for HR and PQRS.
• Assistant Cognos administrator responsible for monitoring jobs, migrating reports from and to environments, and Cognos report developers' users access.
• Oracle BI Publisher converted legacy PowerBuilder reports to new Enterprise application.

Confidential

Data Warehouse Developer

Duties and Responsibilities:

• Supported application that streamlined help desk staff's work. Application ETL data from one MSSQL2005 data source then manipulated the results before pushing the data to another location.
• Created applications that use data grids and list frames to facilitate quick user look up.
• Created a Quality Assurance application that followed SDLC methodology. Application was delivered on time and under budget with close user support.
• Created an All-In-One Universal Reporting application in for Project Managers, so required deliverable reports for the contract would be immediately accessible to them in one location.
• Supported and continued to developed in CMS Monthly call statistic reports that presented total calls and individual user statistics.
• Supported and continued to develop in M.M.A. client satisfaction reports in MS Excel 2007 format. Application imported MS Word responses returned by randomly selected callers to the Help Desk from the prior month. Application had three levels of security.
• All application development utilized three levels of security that included two MSSQL levels and one internally coded in VB.
• All application utilized mechanism where BETA testers could be managed at the application level.

MicroStrategy System Administrator and Report Developer

Confidential

Duties and Responsibilities:

• Oversaw Two Production, Two Development, and a Single Training environments running HP UNIX using multi tier level security.
• Created scheduled reports that were automatically sent to select groups.
• Responsible for troubleshooting and problem resolution.

COGNOS Report Developer

Confidential

Duties and Responsibilities:

• Created reports for employee utilization, financial planning, and profitability in COGNOS ReportNet from a MS SQL 2005 data warehouse.
• Participated in regression testing, and report fixing for conversion over to COGNOS 8.

COGNOS Business Intelligence and Oracle Data Warehouse Developer

Confidential

Duties and Responsibilities:

• Responsible for Oracle's Star Schema's ETL, views, and stored procedures changes that processed new and logically deleted columns.
• Responsible for column changes in COGNOS PowerPlay cubes and Impromptu reports.
• Migrated 43 statistical reports COGNOS series 7 reports to a single COGNOS ReportNet report.
• Provided technical support C.M.S. Staff for Impromptu and PowerPlay
• Trained CMS staff on ReportNet

Confidential

Business Intelligence Developer

Duties and Responsibilities:

• Programmer assigned to supporting Maine Medicaid Reporting, Decision Support, and Surveillance and Utilization Review subsystem.
• Responsible for letters and reports creation using Cognos Impromptu.
• Manage, publish, and maintain Cognos IWR report server.
• Support and enhanced Provider Remittance Advice reports.
• Responsible for keeping the Reporting subsystem Work Break-down Structure up to date.
• Responsible for exchanging letters and report documentation between CNSI and the State of Maine.
• Responsible for weekly MeCMS Reports meetings between CNSI and the State of Maine's Reports team.
• Responsible for keeping the all developed MeCMS project letters and reports current and safe in CNSI's Microsoft VSS database.
• Created weekly dynamic Oracle scripts with MSM-Workstation.

Accomplishments:

• Participated in writing Requirement Trace-ability Matrix, Technical Design Plan, and Implementation Test Plans for MECMS Reporting, Surveillance and Utilization Review, and Decision Support subsystems.

• Participated with the data conversion team and the State of Maine's Division of Technology Support to extract legacy Medicaid claim data.

Automated Tools Used: Cognos Impromptu, Cognos PowerPlay, Cognos Transformer, ERWin 4.0, Quest Software Toad, and MSM-Workstation

Confidential

Senior Consultant

On-site consultant

Duties and Responsibilities:

Data Extraction / Data Warehousing

• Created data extraction tool for an IDX client for financial reporting and collections.
• Installed, customized, and supported DAOU Data Extraction Tool for an IDX New Mexico client. Application extracted legacy data and converted it into a MS SQL 7.0 data warehouse.
• Developed a data warehouse for HMO data using SQL/MUMPS, which loaded encounter/capitation and member data and transmitted the information to a Baltimore-based hospital's O'Pin System for processing.
• Created MS SQL Server database application in MS SQL Server 6.5 to retrieve and report psychiatric care between state agencies and a large private managed behavioral health care Corporation.
• Normalized client's database.
• Developed extensive data checking procedures.

Vendor Support

• Participated as an IDX support engineer for IDX Y2K East Region. Assisted clients in the transition to IDX Y2K compatible version. Resolved problems arising from the upgrade process. Supported applications Billing and Accounts Receivable BAR , Managed Care MCA , Patient Scheduling SCHED , Database Management System DBMS , Electronic Data Interchange EDI , Security Plus SEC , Paperless Collection System PCS , Automated Receipts Tape ARTS .
• Participated as an IDX support engineer for IDX Mid Atlantic Region. Supported applications in SCHED, BAR, MCA, DBMS, and PCS.

Managed Care

• IDX AES Support Programmer for Prudential. Supported and modified programs for conversion from IDX to Prudential property HMO application. Wrote and supported statistical programs that paid providers/vendors.
• Fixed custom accounts receivable reports for HSII client in Modesto, California.
• Wrote programs to find duplicate claims based on the same vendor, date-of-service, and billed amount then, exported the results to a flat file and converted it to Excel.
• Wrote detailed documentation for a new HSII customer who wanted an explanation of how HSII was printing UB-92 claim forms and how data was selected, as well as the source of the data.
• Maintained HSII Downloads and installed fixes.
• Wrote KB SQL queries to print encounter listings by provider to determine if providers were maintaining contracted workloads.
• Enhanced, developed, revamped, and supported the contact tracking system running under a Graphical User Interface GUI for a large mid-western HMO with over a million members to interface the legacy HSII System to the user's desktop, giving the member service representative access to membership, benefits, claims, and referral information.
• Wrote programs to load old encounter data off old system and into HSII, as well as scripting programs to key claims data from old system into HSII.
• Changed electronic claims processing system to print claims to paper for selected groups who have been already converted over to the new HMO system, preventing the system from paying the claims twice.
• Exported data from IDX and manipulated it in MS Access for client specific reporting needs.
• Enhanced IDX BAR applications for a Missouri training hospital. Developed client specific IDX data entry screens for open referrals for a Missouri training hospital.
• Enhanced the Patient Account system to print Co-Pay receipts to HMO members arriving for appointments.
• Mapped an existing M/MUMPS database to KB SQL for a mutual funds investing company.
• Wrote KB SQL queries to pull payment information out of the database these reports added to the existing hard coded M/MUMPS reports.
• Converted HMO system from old version of HSII to an updated version.
• Evaluated new tools for MWAPI and Visual Basic with the prospect of training internal programmers in Visual Basic.

Billing and Time Entry system

• Enhanced Daou-Sentient's billing and time entry system written in VA Fileman.

Automated Tools Used: InterSystems MUMPS, InterSystems M/SQL, MS Access, MS Project, VA Fileman.