Performance Tuning Analyst with extensive work experience in a variety of industries. 18 years of Oracle database experience starting with release 7 through release 12c. Significant experience with multiple complex Oracle-based systems. Providing custom developed solutions and advice on database systems through the entire system life cycle.
Established in January 2009 to provide clients with database consulting and custom development services.
Currently maintaining all in-house application systems. Developed custom solutions. Design, build and maintain database systems. Manage a team of consultants to rapidly develop new applications and web services to fit specific client needs. Implemented payment processing systems.
As a DBA and expert Oracle PL/SQL developer, performance tuned existing applications and database instances. Performed database host migrations and consolidation of database instances. Patched and upgraded databases.
Implementation and integration of payment processing systems, call center platforms and credit card tokenization services.
Data Warehouse Consultant at Southwest Florida Water Management District (SWFWMD).
Migrated their Water Management Information System (WMIS) OLTP database from 10g to 11g. Implementing Oracle 11g new features and performance tuning application SQL and PL/SQL through the transition.
HP/UX Oracle 10gR2 to Oracle 11g Linux RAC migration – Performed re-platforming, re-hosting, and upgrade operations to move a mature Data Warehouse and Dissemination database from Oracle 10g to 11g RAC. Migrated and upgraded Oracle Warehouse Builder projects from 10g to 11g. Converted legacy data pump applications from PL/SQL to OWB mappings and process flows. Re-modeled schema to conform to their new database security standards. Performance tuned existing PL/SQL packages and leveraged Oracle 11g new features. Implemented new indexes and additional table partitioning to optimize performance further in their new system.
Migrated regulatory Environmental Resource Permitting data from legacy system (DB2) to Oracle-based Water Management Information System (WMIS) as part of an IBM decommissioning project.
Developed several data pumps to extract, transform and load water resource data (Radar Rainfall, Evapotranspiration, Geohydrologic) and water quality data from multiple sources into a dissemination database.
Provided maintenance and support assistance on OLTP applications and Operational Data Store / Reporting Database. Performance tuned existing PL/SQL solutions. Developed new ETL solutions using Oracle Warehouse Builder (versions 10g and 11g). Provided DBA support on Development and Support / Patch databases.
Designed, developed, and enhanced application systems interfaces including an HR / Demographics feed to the District’s WMIS system.
Perform as a lead analyst and data warehouse designer within the Business Intelligence Department. Work with Business Objects Enterprise XIR2 to perform ETL, develop and build upon existing data warehouses, as well as design new data models for data marts. Initiating projects to support both business intelligence and best practices in database development.
Lead Developer of CareCentrix Application Development and Legacy application support team. Specialized in Oracle PL/SQL Programming, database instance and application performance tuning, Database Administration, and Data Migration.
Led and mentored a team of VB, Java, and Oracle programmer analysts. Interfaced with director level management to perform business analysis, requirements gathering, solutions design and development, as well as production support. Took on the majority of database development work. Performed both design and code reviews, developing test plans and implementation strategies. Often invited to provide database consulting services to other development groups within the Gentiva Technology Services (TSG) organization.
Provided 24/7 on-call support to Operations (data center), Application Services Group, Infrastructure Services Group, and development groups.
Provided consultation and technological advice to upper management on product life cycle and strategic efforts. Designed solutions for rapidly bringing on board new business and external trading partners. Supported and developed for BizTalk EDI (837) claims submission service. Performed major and significant enhancements to existing Claims, Intake, Provider Maintenance, and Eligibility systems. Re-wrote many undocumented and ‘black box’ systems bringing them into a maintainable and optimized state.
Winner of the 2008 ADG Technology Services Group Outstanding Achievement Award.
Contracted Oracle PL/SQL Programmer / Consultant at Gentiva Healthcare. Performed application development and performance tuning of OLTP and batch-processing systems. Provided support for the Application Development Group (ADG).
Co-wrote a prototype re-write of an existing Intake VB6 application into C# for ASP 2.0 / Oracle 10gR2.
Contracted developer at Home Shopping Network. Developed PL/SQL packages to support a J2EE web-based Carrier Reconciliation System with rule based logic to flag and pend shipper invoice line exceptions received via EDI transactions. Performed SQL tuning assistance and advice to Java developers for client-side (middle tier) SQL and Hibernate queries.
Supported and enhanced existing shipping / warehouse management system. Performed data migration and data staging for warehouse manifest system for their data warehouse.
Developed custom PL/SQL packages for Manugistics Supply Chain system for a demand-side forecasting system. Implemented 9i Bulk DML performance features and re-factored existing PL/SQL procedures to scale from a pilot rollout of several stores worth of data to nearly 1,000 stores. Participated in development of PL/SQL coding standards and presented best practices for exception handling, tracing and logging. Presented a demonstration of PL/SQL Bulk Exception handling and best practices in error handling to the Oracle development team on the C35 Supply Chain project. Teamed with DBA’s and BA’s to perform code review of off-shore deliverables. Participated in design and development of a procedural parallelism solution that enabled several instances of packaged procedures to perform work in concert against multiple logical and physical partitions of dimensional point of sale data.
Performed complete EAM implementations from analysis to implementation for clients in the following industries: Pharmaceutical, Public Transit, Airport Management, and United States Military
Implemented Maximo (versions 4.x through 5.2) as enterprise solutions for Work Management, Preventive and Predictive Maintenance, Vehicle Maintenance, Facilities Maintenance, Calibration, and Inventory Control systems. These solutions included custom tailored applications to perform Field Data Capture, Condition Monitoring, Workflow, Notifications, Barcoding, Mobile Device computing, and reporting.
Developed custom interfaces for clients’ existing enterprise applications. Migrated data of off other client platforms to Oracle from MS SQL Server, DB2, and other flat file formats.
Acted as lead Oracle database developer and administrator. Performed massive database migration project to consolidate several regional instances of Maximo Oracle databases of disparate versions into a single corporate-wide instance on a common platform. Trained the client’ personnel on how to train their employees on the system.
Performed application maintenance, support and development work for GIS, Field Work Management (Maximo), and Field Data Capture / Computer Aided Dispatch, and Automated Mains Management Systems.