TECHNICAL SKILLS:

Database: Oracle 6 - 12c, MS SQL Server, Informix, DB/2, SYBASE, Access, DBLib/Open Client, Pro C, ISQL/DS, ESQL, IMS, FOCUS, SAS, ODBC, RDO, DAO, OCI, ADO, ADO.Net, ODP.Net

Languages: C#, Visual Basic, .Net, ASP.Net, SQL, PL/SQL, PowerShell, LINQ, Java, HTML, CSS, XML, XSLT, JavaScript, PHP, Python, C, C++, Korn Shell, awk/sed, COBOL, SAS, Focus, REXX, Clist, Exec/2, JCL, CICS, IMS DC

Software: SQL Developer, Erwin, Toad Data Modeler, Visual Studio, Kiln, Mercurial, Vault, Source Safe, SQL Developer, TOAD, TSQL Navigator, SQL Station, Informix DBA, JScape, ActiveX, COM/DCOM, QMF, SPUFI, vi, Data-Xpert, File-Aid, Librarian, Panvalet, SDSF, OSF, RMDS, SmartTest, Xpeditor, Cobtest, Intertest, ESQL/C, Viewpoint, APPC, HLLAPI, MS Office, Telon, Oracle WebDB, EDI, SQLLDR, CAR/IS and CARS/Medicaid, ISPF Dialog Manager, Crystal reports, NUnit, MSTest

EXPERIENCE:

Confidential

Senior Software Engineer

Responsibilities:

• Resident SME for Oracle, supporting daily payment and extract activity related to reporting, data transmissions and ETL processes. Develop and maintain client and online licensing applications for State of Maine (client) using Oracle PL/SQL, views, tables, triggers, materialized views, Java stored procedures, etc. on .Net client and web platforms.
• Primary support for database troubleshooting, SQL tuning and as well as troubleshooting difficult client and web application problems relating to performance, memory leaks and system bugs.
• Designed and implemented system to download compressed zip file containing 1000’s of files and programmatically extract the few desired files as clobs using Java, Oracle Java stored procedures, and views to extract the XML data through a scheduled PL/SQL process for extraction into a DB staging areas for later processing.
• Designed and implemented a scheduled a centralized transceiver process for configured transmission protocols (ftp, sftp, ftps, moveIT, xfer, https, SSH) to transmit/receive data optionally into files or database blobs to replace many ad hoc and custom implementations at the application-level. Wrote custom protocol classes (e.g., ftp, ftps, https) to support necessary interfaces.
• Designed and implemented a nightly scheduled PL/SQL processes that creates read-only views and configured grants for configured tables/views in configured schemas for external read-only access to support nightly transmissions and ETL of data to/from various clients. The external access is controlled through configuration tables to control board/agency data access and schema grants.
• Designed and implemented Oracle monitoring process using PL/SQL objects, views and configuration for scheduled email and ad hoc reports via email for database anomalies as well as other data-related issues (disabled constraints and triggers, invalid indexes and user jobs, unprocessed requests, configuration errors, etc.) to replace various and sundry user/developer manually run scripts which had unenforced execution and prone to undetected failures due to database changes and undiscovered scripting errors.
• Packaged previously run SQL scripts to automate processes and provide real-time database consistency as well as better access and maintainability.
• Replaced existing Deposit Extract system with a highly, customizable extract and reporting system to support numerous State agencies, boards and programs - which also allows for re-running reports for previously extracted data.

Confidential

Data Warehouse ETL Consultant / Team Lead

Responsibilities:

• Lead developer on ETL DW team supporting Contracts Data Warehouse; primary support for Managed Care-area DW and Data Marts including requirements, specifications, project plans, development, maintenance, support and documentation.
• Analyze, design, develop and support of key Territory feeds and structure changes to the Contracts DW.

Confidential

Sr. Consultant

Responsibilities:

• Design, code, test and document the front and back-end changes necessary for Best Prices changes for the Confidential -required DRA.

Confidential

Sr. Consultant/ DBA/ Developer

Responsibilities:

• Chief Technology Officer/Lead Developer for Ideal’s Pharmaceutical Data Validation application development and re-engineering efforts.
• Responsible for technical decision making, Oracle, VB and .net development as well as future direction planning and architecting; Performance tuning, backup, SCC, data modeling, system design, architecting and enhancements.
• Lead technical resource for support of critical client needs. Suggest, develop and estimate new business and additional client work based on opportunity.
• Re-factored Ideal’s flagship product (ECP) - separated Oracle SQL from VB front-end code through the creation of views, PL/SQL components and other design enhancements.
• Picked up work left by departing senior-level employees in the middle of two critical projects to deliver products on time and under budget.
• Technically lead and support Ideal developers and analysts.
• Developed back-end for CARS/Medicaid Dispute Manager to apply system-generated dispute values to CARS/Medicaid (Dispute Resolution Claims) and to provide CARS Medicaid data interfaces.
• Developed and tuned various Crystal reports with view/procedure-based architecture.

Confidential

Sr. Consultant/ DBA/ Co-owner

Responsibilities:

• Managed Care Contracting - Decomposed existing Manage Care Contracting system specifications and data model using self-created tools for identification of Oracle and Visual Basic object dependencies.
• Made recommendations on application improvements in areas of Submission, Tracking, Submission Rebate Calculation, Contract Entry, etc.
• Identified design areas for improvement and proposed various ways forward for application development of MCC.
• Develop system using Oracle, PL/SQL, XML, XSLT, HTML, .Net and Java Script.

Confidential

Consultant

Responsibilities:

• Worked on a general database solution to generate code, triggers, tables, views, indices, etc. based on minimal database meta-data input.
• The database design has data versioning, full trigger-based history, auto-generation of views, history tables and triggers.
• It also contains a Poly model database design to provide flexibility in defining named objects.
• Working on Medicaid and State Supplemental application and GP application.

Confidential

Oracle DBA/Data Architect/Developer

Responsibilities:

• Designed, architected and implemented data model for Confidential (Government) Pricing Calculation ( Confidential ) application to allow for data versioning; full history of data activity; standardized processing of disparate data through common interface implementation; dynamic filtering of data and dynamic validation definition in calculations of AMP and Best Price.
• Architected and implemented the AMP and BP calculation processes to allow for dynamic and static calculation of AMP and Best Price.
• Converted legacy SB Pricing and Rebate Program data to Confidential i-Many CARS/MA data model.
• Supported application GUI development through development of back-end database objects (Views, Triggers, Tables, Indexes, PL/SQL Packages, etc.). Developed various aspects of the GUI front-end (VB6).
• Interface with CARS/IS data to support Confidential Calculations of AMP and BP.
• Implemented I-Many CARS Medicaid upgrade to version 8 with changes to support large database needs.
• Created Data Warehouse for support of Cognos reporting needs including Star Schema with Fact and Dimension tables.

Confidential

Data Structures Manager/DBA

Responsibilities:

• Oracle technical resource for in house transaction management system.
• Full life cycle development of Oracle-based system PL/SQL components.
• Database SQL tuning, view creation, definition, etc.
• Re-architecting of existing Oracle application architecture.
• Specification, definition and clarification of interfaces to 3rd party software. Standardized application coding paradigm.
• Developed metadata application generating components to reduce coding efforts and make efforts reusable.
• Basically, functioned as the Oracle Applications DBA and supported the Administrative/Operational DBA(s).
• Normalized, tuned and optimized existing SQL Server EDI DB.
• Replaced 2000 Microsoft Business Solution of the Year with Oracle-based solution to improve efficiencies and solve app problems.

Confidential

Oracle App DBA

Responsibilities:

• Developed of a Medicaid Rebate system back-end.
• Functioned as Application DBA and VB developer.
• Created all Oracle views and PL/SQL objects.
• Managed schema changes, table definition and organization of Oracle application components.
• Converted and customized an existing system from another company.
• Largely contributed to on-time delivery of what had been a behind schedule effort.
• Managed VB interface to back-end through creation of views and packages to facilitate efficient deployment.