Spiro “Skip” Woolis adicgx@r.postjobfree.com

*** ****** ***** ***** ***** 209

Medina OH 44256 330-***-****

A proven IT professional with over 25 years of experience working with multiple database engines on numerous platforms, providing project methodologies, performance tuning, development, testing matrixes, and implementation strategies. Have over 20 years of Pl/SQL experience within multi-layered application architecture and design middle-tier administration, application development, integration, and implementation arenas. Most currently I have taken two Oracle APEX courses to bring myself up to speed.

Professional Experience

USTechSolutions Consultant August 2020-Present

Consulting engagement with the U.S. Department of Defense within the DFAS organization performing data migration from decentralized military branches into central reporting database.

HireTech Consultant September 2019- December 2019

Consulting engagement with Sherwin Williams to ETL data to their Netezza BI environment.

Primarily using Bash and PostgreSQL SQL.

HP Corp/DXC Consultant February 2013- July 2018

Consulting engagement with the U.S. Department of Defense within the DFAS organization helping to construct and develop accounting and reporting solutions within an Oracle 11G environment. This includes the tools of Oracle Designer, and Oracle Developer. Also included performance tuning Trial balances reports within the Oracle automatic tuning environment with analytical algorithms by determining Oracles load plans and adjusting the SQL. Developed a meta-data driven drill report drill down solution. This allowed for the reports and their respective drill downs to be dynamic in nature and driven by meta-data in lieu of hard coding. Designed and participated in development of an administrative KPI using Oracle and Scripting with AJAX.

Lead design and development for DFAS DIT (Deposits in Transit) system which attempts to automatically match and/or adjust all Debit and Credit vouchers reporting to Treasury.

Lead on writing and testing controls on applications for FISCAM audits. Participated in FFMIA audit, ACART certification, COOP exercise, and FISMA certification.

Oracle 12c Environment and Oracle 11 Application server.

Working with DBMS_XMLDOM, DBMS_XMLGEN, HTP packages.

Working with PL/SQL in creation of packages, functions, procedures, and triggers for accounting system. Using TKPROF and explain plans for SQL tuning and optimum performance. Worked with Korn shell both interactively and writing scripts.

Worked with HTML and Javascript.

Obtained NACLC IT-2, ENTNAC, and PTSBI security clearances

Farmers Insurance Application Architect II March 2005 – July 2012

Hands on manager of Oracle DBAs, PL/SQL Developers, WebSphere Administrators, and Java Developers on multi terabyte clustered environment.

Architected inference engine to allow business to develop “what if” scenarios within production environments to determine premium analysis. This was designed as a web facing UI from multi vendors onto an IBM Web Server to a WebSphere business layer with Data from an OS400 DB2 data store. This was a business requested solution that required a POC with business.

Architected solutions for eSignature, Archiving to Amazon AWS, line of business re-platform, and multiple middle tier services. This was a global solution using SOA services going to the cloud and required a continuous collaboration with business.

Architected an object-oriented meta-data driven POS system to sell P&C insurance. This was a web facing UI, going back to an IBM web server load balancing to a clustered WebSphere application set of servers using JMS as the ESB. The data access was entirely in Hibernate and the data store was a clustered Oracle 10G environment. This required much prototyping for the business community and multiple code reviews with the developers to ensure project success. Over a three year period the project came in under the budget of 10 million dollars.

Designed and architected messaging infrastructure using ACORD XML standards. Managed, designed, and implemented SOA service allowing outside entities to obtain premium information, credit information, vehicle information, payment information, and quotes based upon available services. This used IBM MQ as the ESB.

Architected multiple solutions on SharePoint 2003 services that were all Web Facing intranet solutions using SQL Server 2000 as the data store. This consisted of employee provisioning, intranet ready mail scanning into a home grown document repository.

Architected a customer service workflow system using EASYLINK, as the 3rd party vendor to acquire all documents for processing either through faxes or being fed from internal systems. This was a web facing UI with C# and Java as the development components all working with the 3rd party vendor systems through SOAP transactions.

Architected in house incident management system using MS ASP with C# on the business layer on an IIS clustered environment to a persistence layer on SQL server 2005.

Was member of GiTAG (Global IT Architecture Group) designing both best practices and governance models for enterprise architecture. Perform business justification cost analysis and (ROM) rough order of magnitude per resource and cost needs and timelines for enterprise projects consisting of both in-house and off shore resourcing. These are all multi-million dollar projects with ROIs ranging from 1.5 months to 2 years.

3X Corporation Project Architect, DBA & Project Manager positions 1998-2005

Integrated use of 3rd party association software into legacy systems for multiple organizations using Visual Basic Enterprise 6.0 and MS Access 2000 with ETL design.

Developed and implemented Oracle and SQL Server engines for numerous not-for-profit organizations.

Created an attorney/judge grievance workflow solution using Visual Basic 6.0 with Sybase backend database for Cleveland Bar Association.

Architected central data repository data warehousing environment for Nutrition Services Center within CCF.

Architected solution to take a Fox Pro for DOS underwriting system into Visual Basic with a DB2 AS400 backend for insurance specialty carrier

Designed needed data elements, modes of retrieval, storage, and modes of export to different media.

Developed real-time communications between accounting package and 3rd party law department software using SQL Server 7.0 for Notre Dame College.

Conducted performance tuning for Oracle 7.3.4, tuning of degradation in development, honeycomb and fragmentation control for Oracle servers, upgrades and installations of new instances Oracle databases and development tools, creation of stored procedures, triggers, packages, backup and disaster control, export/import, SQL loader and creation of segments, profiles, users, and schemas working with over 1.4 terabytes of data on an HP-UX Unix system in Oracle.

Conducted work with distributed databases, Oracle Pipes, SPX and TCP/IP connections, remote links, and transaction processing enabling communication a legacy system and client/server home grown front end

Responsible for framework build in Windows communicating with COBOL and Oracle RDBMS on HP-UX through Oracle pipes using Power Builder 6.0 as the front-end.

Victoria Financial Corporation Oracle DBA/Development Manager 1995-1998

Installed and maintained 3 Oracle servers on Novell and 1 Oracle server on Sun SPARC, including performance tuning, and creation of segments, users, profiles, remote links, and schemas

Managed the development of insurance rating disks supplied to over 5,000 independent agencies in Power Builder, Paradox and Visual Fox Pro

Project supervisor for on-line Agency Upload/Download System

Architected a HALAPI package using Visual Basic 4.0 communicating with IBM Personal Communications APIs to initiate real time modem transaction transmittal to Ivans cloud via 5250 emulation

Architected solution to make calls to AS400 DB2 to retrieve validated data from agency upload, parse the information, validate against business rules, and then update client/server system using PowerBuilder 5.0

BP Oil America LAN Administration/Programmer Analyst 1990-1995

Created and maintained image-based transaction transmittal system for national credit card center

Developed solutions in Rbase, Clipper, ANSI SQL, and ANSI C

Assisted maintaining Novell network servers

Contact this candidate