SUMMARY

Highly skilled and versatile technical expert in application and database development/ maintenance in the healthcare IT field primary experience in pharmacy Medicaid claims . Served as effective team lead as well as hands-on developer, principally on Solaris Unix platform with Oracle databases, with a variety of application programming languages Pro COBOL, Pro C, Micro Focus COBOL, SQL, VB.NET, C .NET, and others . Fifteen years of experience as an ORACLE DBA working with version 7 to version 11.2.0.3. Proficient in Unix scripting, SQL loader, Import/Export, and the Informatica ETL tool, Also worked on Windows/SQL Server platform prior IBM mainframe/COBOL experience, including DB2, and OS/JCL. Excellent written and verbal communication and teamwork skills. Solid skills in entire Microsoft Office suite, including MS-Project. Seeking a position to fully apply my diverse skill set toward organizational success.

WORK EXPERIENCE

Confidential

• Major responsibility is to support Project Managers by researching business technical and application-related questions posted by our clients pertaining to the data that they send. The data that is sent is used to be reformatted into an Encounter 837 file and/or RAPS file to be sent to CMS and State agencies.
• Analyze PL/SQL procedures that creates the Encounter 837 and RAPS files to determine why data from the client did not process correctly
• Write PL/SQL procedures to create custom reports requested by the clients. This requires using SQL loader and LINUX scripting when writing reports to compare data on different servers.
• Creates LINUX scripts to automate the creation of custom reports to be sent to a client via email or FTP
• Developing LINUX scripts to automate the process that reformats the data sent into Encounter 837 and RAPS files.

Confidential

• Responsible for all ongoing administrative tasks to maintain the Oracle databases for a production and a DR point-of-sale system. This includes the installation of patches, all version upgrades, and the use of the OEM tool for monitoring performance and tuning.
• Implemented the RMAN backup utility for both databases.
• Backup ORACLE DBA for an Oracle Database Warehouse System of two terabytes of claims information that I was a major contributor on implementing.
• Manages and coordinates workload for team of five staff members involved in modifications and enhancements to the Medicaid point-of-sale pharmacy system.
• Provides guidance, mentoring, review of code and test results, and performance evaluations to team members. Provide final approval for all technical changes to the production environment.
• Provides leadership, direction and guidance for major projects:
• Pharmacy NCPDP D.0, among the first Medicaid systems to be implemented
• Enhancements for complex editing for pharmacy claims, including Drug Utilization Review
• POSWeb, significant enhancement to provide user interface and table update capability to POS system tables
• Budget initiatives, series of annual projects involving significant enhancements to POS system for NJ state revenue savings
• Automated the process to switch POS processing between the production and hot backup sites for high-availability/disaster recovery capability. During Hurricane Sandy, the POS system processed without interruption, which is a highly visible system for meeting needs of real time dispensing of medication to Medicaid beneficiaries.
• Proactively added Unix scripts to monitoring process to determine if there has been some failure which requires sending automated notification to on-call staff members.
• Serves as liaison to keep State customer continually informed of all significant production issues and any requests for necessary production downtimes.
• Hands-on involvement in any major migration to upgrade the server environment.

Confidential

• Developed all Unix and SQL scripts to create an Oracle Data Warehouse of two terabytes of claims information on a Sun Solaris platform to be used for a Decision Support System DSS .
• Responsible for all ongoing administrative tasks including the OEM tool for monitoring performance and tuning, installation of patches and RMAN backup utility to maintain the DSS.
• Assumed higher level of responsibility as a technical team lead for nine staff members that are responsible for loading data into the DSS and creating reports using the information in the DSS.
• For initial implementation of DSS, modified the ETL tool Informatica sessions to load data into the DSS, wrote a reconciliation process using UNIX scripts and PL/SQL to confirm that the data extracted and downloaded from a mainframe platform was loaded into the DSS correctly.
• For improved ongoing system performance, wrote and implemented all procedures to complete the weekly load of the DSS database without manual intervention.
• In addition to function as DSS team lead, because of need for an additional highly skilled technical resource to work on POS system, completed all coding and testing of major upgrade for the NCPDP 5.1 transaction process, which introduced many new pharmacy features, including the ability to submit compound claims electronically. Involved numerous changes to ProCOBOL modules, Pro C modules, Unix shell scripts, and mainframe COBOL/ JCL/ DB2 changes.
• Performed all coding and testing for the Medicare Part D initiative, where the POS system pays the remaining claim balance after the Part D PDP has processed the claim.

Confidential

• Major responsibility was design and implementation of a real time statewide pharmacy point-of-sale system written in 'C', Pro C and ProCOBOL that accesses an Oracle database, based on a multi-processor Unix system.
• Converted POS system from a U6000/650 platform to a SUN/Solaris platform.
• Responsible for all ongoing database administrative tasks, and also acted as backup Unix system administrator.
• Processing of system modification requests for specific change orders to the system, including preparation of all test plans for presentation to State customer review.
• Demonstrated problem-solving and critical thinking in proactively researching, identifying, and proposing corrective actions for a series of processing problems and issues in the pharmacy POS Solaris UNIX system and associated mainframe interactions.

Confidential

Developed and implemented specialized patient information programs for direct billing and third party reimbursement for Health Service Providers using CBASIC, ASKSAM , Concurrent and MS-DOS. Created relational database for Baxter Laboratory Library.

Confidential

Customized Information Management database for end users and system analysts. Developed Report Form Tables and Stored Response Chain programs on request and supervised data entry personnel working with TSO/ISPF on an IBM MVS 3279. Designed, formulated and created programs using IBM 370 Assembler and Statistical Analytical Systems. Trained end users on use of Information Management product.