Edmund (Ted) Skeen Data Warehouse Consultant, Senior Oracle PL/SQL Programmer / Analyst, DBA

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.

Skeen Consulting, Inc.2009-PresentPresident & CEO

Established in January 2009 to provide clients with database consulting and custom development services.

ThinkDirect Marketing Group2011-PresentDatabase Consultant

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.

Kyra InfoTech, Inc.2009-2012Data Warehouse Developer / DBA

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.

Gentiva Healthcare Services, Inc.2007-2009Information Systems Architect

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.

Veredus Corp.2007-2007Oracle PL/SQL Programmer, Performance Tuning Analyst

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.

Princeton Information / HSN2006-2007Software Developer

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.

Veredus Corp. / Publix2006-2007Oracle PL/SQL Programmer

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.

Electronic Data, Inc.2003-2005Maximo Implementation Specialist

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.

Keyspan Energy, Inc. (Formerly Boston Gas Co.)1998-2002Software Engineer

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.

Northeastern University2000-2001Certificate, Computer Programming
State University of New York College at Purchase1996-1998MFA, Music Perormance
Cleveland Institute of Music / Case Western Reserve University1991-1995BM, Music Performance
Application Development
Database Programming
Performance Tuning
Data Modeling
Data Warehousing
Data Migrations
Enterprise Systems Implementation
Technical Skills
Oracle SE Linux
MS Windows
Unix / Linux (HP / UX, AIX)
Apple Mac OS X10.x Client and Server Editions.
Mobile / PDA (Windows Syclo SDK on Symbol H/WIncluding barcode scanners and wireless enabled devices.
Oracle PL / SQL
Oracle Database12c, 11gR2/R1, 10gR2/R1, 9i, 8i
Oracle Database Appliance
Oracle Warehouse Builder11g and 10g
Embarcadero ER Studios 8.0
Visual Studio Professional
Toad 7.x - 12.x
PL/SQL Developer
BO Enterprisei.e. Data Integrator, Crystal Enterprise, etc.
Crystal Reports
Visual Studio
Database Design & Maintenance
Data-Driven Applications
Business Intelligence
Data Warehousing
Architecture Solutions
Full Stack DevelopmentMultiple platforms
Database Tuning & Query PerformanceSpecialized for fast and responsive applications.
Migrations & ImplementationsSpecialized to maximize or eliminate downtime.
Integrated SolutionsCustomized to work with your systems, staff, and strengths
Clear and Efficient CodeTo extend the life of legacy technology.
Complex Data MigrationFor contrasting relationship models to innovate.
Performance TuningVia code refactoring.