PL/SQL Developer working on reporting to accurately manage data from a legacy customer billing system.

Database developer for the logistics arm of WSI/360 data. Working in Oracle 12.2, Visual Studio 2017, EDI.

Oracle 12.2, Visual Studio 2017. Working as an Oracle Database Developer in logistics within the trucking industry.

• Developer helping to maintain client members and provider data, helping to manage and process claims.• Working in Oracle 11g to maintain and develop procedures, functions, triggers for management of membership and provider information data as well as claims processing.• Working with Appeon PowerBuilder for GUI interface for customer support to handle all aspects of member and provider inquiries.• Use of Automate 10 scheduling tool for process automation

Maintain and manage data using Control-M, with Linux shell scripts in a Sybase 16 database environment, interfacing with Business Analysts to troubleshoot link between Provider/Member data.

• Developer of customizable billing system used by global clients. Additional duties as the Database Administrator in an Oracle environment.• Maintain and enhance the rating and billing functionality for the global customer base with secondary responsibilities maintaining two production Oracle databases. Manage an external partner to help monitor the health of our database farm and enhance the existing Conference Reservation and Billing System software.• Created and maintained Oracle Linux CRON Scripts for automated reporting and Database monitoring.• Working in SQL Server 2008, and C# coding enhancing a global billing system.• Designed and created Offer Maintenance application(C#) for in-house representatives to create and deploy new offers on our website.• Mentored other developers within my department.• Acted as lead developer on teams of 2 to 5 developers.• Developed module for billing call detail records from an outside source, providing credit card details regarding each transaction in order to bill back to the appropriate group(s).• Performed tuning of current Oracle PL/SQL code.• Performed as System Analyst to scope and design an automated operator assignment process to better staff operator assisted and managed audio conferences. Implementation of the skill-tracking portion of this project was completed in a dot net web(C#) application.• Designed process to allow for billing work orders to be created for ancillary billing items for additional charges to existing invoices or to create separate invoices for services rendered.• Helped to create and implement code and documentation standards for both Oracle PL/SQL development and PowerBuilder.• Acted as lead Oracle PL/SQL Developer, working on code efficiency and mentoring of Packages, Procedures, Functions and Triggers.• Performed DBA duties, performance tuning, data file maintenance, code release management, database backups, capacity planning, etc.

Webmaster of parish website until 2008, and co-chair of website committee.

Consulting work for Blue Cross Blue Shield Quaker Oats