Personal and Confidential Page * of *

Steven Stowers

US Citizen Siloam Springs, AR adjmf9@r.postjobfree.com Goal

My goal is to find a good company where I can share my 12+ years of hands-on Oracle APEX and PL/SQL development experience. To create and/or update APEX applications that are intuitive, easy to use and clean while being easy to navigate. These applications would be built using known best practices, development standards and the latest web technologies.

Experience

Genentech/Roche Pharma – Remote

August 1, 2019 – July 31, 2020

Contract Senior Oracle APEX Developer

Develop APEX applications to monitor and report on drugs currently in development or in the marketplace. Provide various reporting and visuals for progress through the pipeline showing in detail any Submission or Regulatory issues, meetings with FDA or other worldwide regulatory bodies. My contract will be expiring very soon. Technical Environment:

Oracle 12.2g, APEX 19.1, ORDS 18.x, BI Pub PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, AJAX, SQL (ANSI), Materialized Views, DBlinks, Migration Packaging, REST Services, Development Standards and Best Practices implementation, AOP implementation and development. DOI/BLM Remote

July 1, 2018 – July 1, 2019

Contract – Senior Oracle APEX Developer/Software Developer III Dept. of the Interior/BLM Wildfire group to upgrade/rewrite their current, outdated software used to track weather observations as well as the software used maintain the many weather stations in remote areas. The software reports on the various type of observations from the weather stations which sends this data to various satellites which is then provided to multiple clients. Part of the software includes various REST services, some of which will be made available to the general public. This system is used extensively by the Wildfire management during fire season. Technical Environment:

Oracle 12.2g, APEX 18.2, ORDS 18.x, BI Pub PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, RESTful Services, AJAX, SQL (ANSI), Regular Expressions. Simmons Foods – Siloam Springs, AR

Nov. 1, 2016 – March, 2018

Permanent – Senior APEX Developer

Hired as the Senior Oracle APEX Developer. Create new APEX applications and BI Pub reports integrating various data sources including EBS and EAM. Reviewed existing applications and submitted suggestions to increase security and improve coding methods while eliminating redundant code. Worked JIRA tickets for production support and a team resource. Helped guide the effort to upgrade from APEX 4.2 to 5.04 as well as implementing ORDS. Technical Environment:

Oracle 11.2g, APEX 5.04, ORDS 3.x, BI Pub 11.2, Oracle eAM, Oracle EBS PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, AJAX, SQL (ANSI), Regular Expressions

S. Stowers Resume – cont.

Personal and Confidential Page 2 of 7

Oracle – Los Alamos National Laboratories, Los Alamos, NM March 7 – June 7, 2016

Contract – Project Lead APEX and PL/SQL Developer

As the Lead APEX developer on this project I helped upgrade from legacy mainframe systems to Oracle EBS. This required various additional functionality using Oracle APEX 5. The key functionality was a complex ETL process to bring new and legacy batch transactions from Excel spreadsheets into the EBS Projects module using external and internal data validation. Created/prototyped new security model using jQuery tree and drag and drop methods and properties. Technical Environment:

Oracle 11.2g, APEX 5.01, PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, AJAX, SQL (ANSI) and Regular Expressions Cigna Insurance– Windsor, CT (Remote)

November 1, 2015 – February 5, 2016

Contract – APEX and PL/SQL Development

Work primarily as the Sr. APEX developer bring older applications up to date in order to take advantage of new features in APEX 5. New work included design and implementation of data models and building APEX application shells for the various data models.

Technical Environment:

Oracle 12.1c, APEX 5.03, Toad Modeler, PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, AJAX, SQL (ANSI) and Regular Expressions. Siemens Energy – Power Generating Turbines– Orlando, FL June1 – November 6, 2015

Contract – APEX and PL/SQL Development

Convert a business/engineering critical legacy application to Oracle APEX and PL/SQL. Their legacy application consisted of various components performing the overall function of creating turbine designs and parts kits for international sales. The software which was developed covered all aspects of design and modeling of large scale power generating turbines. Starting with a Master Frame and customizing through the use of specialized BOM’s to match specific engineering and customer criteria. A BOM is created for each of the “Program Parts” where each part has a lifetime analysis based on Hours or the number of turbine Starts. I was responsible for all aspects of the technical side of the project including the database model and creation of all Oracle objects. This also included designing and implementing the data migration process which included data mapping and ETL. Once the database design and objects were created the business logic was developed and placed in several packages and the front end GUI was developed using Application Express 5.01 and the Universal theme.

Technical Environment:

Oracle 12c, APEX 5.01, Embarcadero ER Studio, PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, AJAX, SQL (ANSI) and Regular Expressions. S. Stowers Resume – cont.

Personal and Confidential Page 3 of 7

Trinoor, LLC – Software Development – Marietta, GA October 1, 2013 – June 13, 2014 6 mo. Contract Extended Lead Developer – PL/SQL and APEX

This company provides consulting and technical staff to large power companies internationally and is trying to enter the high end time management software business for this market. I was hired to bring their time management software, TAStK, to beta so it could be marketed to the same industry to which they provide technical support. After a few months I was charged with Lead Developer responsibilities over 4 junior developers. This task was accomplished on time.

Technical Environment:

Oracle 11.2g 12c, APEX 4.11 4.25, VPD, PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, AJAX, PL/SQL, SQL

SkillBuilders Oracle Database & APEX Development Experts August 1 – December 31, 2014

Contract – As needed staff

Performing APEX and PL/SQL maintenance and consulting as needed. Developing class materials and plugin maintenance for Oracle APEX.

Stanford University – Administrative Systems – Palo Alto, CA January 1, 2012 – October 4, 2013

APEX/PLSQL Developer – 9 month Contract Extended Conflict of Interest, Conflict of Disclosure and Statistical Reporting at Annual and Transaction Levels Contracted to help design and implement a new Conflict of Disclosure/Conflict of Interest reporting system as mandated by the Federal Government, Public Health Services, for all researchers to disclose various data concerning their federally sponsored grants and protocols. Involved in the design and implementation of various systems which interacted with other University systems such as webAuth and Authority Manager to provide tools for researchers to document their interests and potential conflicts related to their research. Once the data was captured, another APEX application reported on the data for various levels of management. Three APEX applications were required, one to capture the data, one for data analysis and a third to perform administrative functions for the system as a whole. Technical Environment:

Oracle 11.1g, APEX 4.11 4.2, VPD, PL/SQL, Views, Types, Packages, Functions, Procedures, CSS, HTML, jQuery, JavaScript, AJAX, SQL (ANSI)

S. Stowers Resume – cont.

Personal and Confidential Page 4 of 7

AT&T Mobility/ AT&T Labs – Alpharetta, GA

September, 2010 – December 31, 2011

Lead Oracle APEX/PLSQL Analyst/ Developer – 6 mo. Contract Extended Lead a group of 7 developers whom designed APEX reports for the Circuit Path Design Organization (CPDO national) showing the actual and forecast delivery dates for the various types of transports; DS1, DS1c, DS3c and ENET. There was considerable APEX development including customizing templates. Most of the coding and logic was handled through PL/SQL on an Oracle 11g instances. Report data came from a combination of 3 or more separate databases including drilling into Granite and Granite Works at the site, circuit, path and equipment levels. These reports are used at a national level with high visibility.

Technical Environment:

Oracle 11g, PL/SQL, APEX v 4.02/3.2.1, Granite, Granite Works, JavaScript, AJAX, HTML, PL/SQL Developer, Views, Types, Packages, Functions, Procedures.

VerizonWireless – Alpharetta, GA

March, 2010 – September, 2010

Oracle/APEX/PLSQL Analyst/ Developer – 6 Mo. Contract Contracted to migrate their Regulatory Submissions Implementation (Site level) application written in MS Access to APEX on Oracle 11g. Determine requirements, interview users group and determine essential requirements. I designed all schema objects in Oracle; tables, indexes, triggers, functions, procedures, packages, sequences, etc. Once the schema and related objects were created the data was ETL from Access to Oracle. The business logic in MS Access was converted to PL/SQL and either placed in the APEX application or the database itself to be called by APEX. The APEX application was designed from the ground up and the various themes and templates were customized to yield the proper end result.

Technical Environment:

Oracle 10g, Oracle 11g, PL/SQL, APEX v 3.2.1, JavaScript, AJAX, MS Access, Excel, VBA, HTML, Toad Modeler, PL/SQL Developer, MS Visio, Views, Types, Packages, Functions, Procedures. S. Stowers Resume – cont.

Personal and Confidential Page 5 of 7

CCH SFS – Rome, GA

January, 2008 – November, 2009

Lead APEX – PL/SQL Developer 6 mo. Contract Extended After several months was positioned as the lead developer and generally acted as a project manager over a varying number of other developers. Met with stakeholders to create various requirements documents. We were tasked with the design, development and deployment of a web based quote creation and tracking system for their call center using Oracle APEX and 10g/11g database with PL/SQL. This system would be used by 150+ customer service representatives while speaking to customers. This required a fast and efficient system designed with the minimum of page refreshes using AJAX and JavaScript while off loading as much work as possible to the Oracle database back end using PL/SQL. The project also included integration with a new accounting system, a SQL Server based enterprise package called Softrax, and legacy data management applications written in Oracles APEX. Data migration (ETL) was performed primarily through the use of several MS Access and Excel applications written specifically for this project.

Worked independently with stakeholders to gather requirements for the team, create Functional Design Documents, use cases, process and data flow diagrams and an overall project plan including tasks, duration’s assignments and predecessors.

Created initial database schemas and corresponding objects (tables, procedures, functions, packages, triggers, jobs, etc. Initially developed in Oracle 10g and later migrated to 11g.

Designed and created all backed PL/SQL code packages.

Designed and created web based UI with Oracle APEX and driven by PL/SQL.

Promoted to Project Manager and Lead Developer to oversee project. Technical Environment:

Oracle 10g, Oracle 11g, PL/SQL, APEX v 3.01, JavaScript, AJAX, MS Access, Excel, VBA, HTML, Toad Modeler, PL/SQL Developer, Toad v 9.5, MS SQL Server 2005, MS Project, MS Visio, XML, SQL tuning, Views, Types, Packages, Functions, Procedures.

Acclaim Systems, Inc. – Roswell, GA

March, 2007 – January, 2008

Sr. Oracle Developer and DBA 6 mo. Contract Extended I was hired as the lead Oracle developer with DBA responsibilities for a large project with the State of Georgia Board of Pardons and Paroles. My responsibilities included design, implementation and quality control over the data migration

(ETL) from a very large Lotus Notes application to a new Java (front end) and Oracle 10g (back end) application. A PL/SQL package with proc’s and functions controlled the migration and MS Access and Excel were used in various ways for quality control. In addition to ETL responsibilities I was tasked with the design of the Oracle schema’s and related objects such as tables, indexes, proc’s, functions, triggers, SQL optimization and tuning which included PL/SQL as required to process the many front end initiated system tasks.

ETL of data from Lotus Notes to an Oracle 10g environment using PL/SQL, MS Access and Excel.

Created custom ETL tools using PL/SQL procedures, functions and a QC environment with MS Access and Excel.

Oracle 10g schema and object architecture primarily using Toad Modeler, Toad and PL/SQL Developer, SQL tuning.

Developed and optimized back end code with PL/SQL packages.

Established and documented all back end procedures and practices based on State of Georgia required guidelines.

Technical Environment:

Oracle 10g, MS Access, Excel, VBA, toad, Toad Modeler, PL/SQL Developer, PL/SQL, SQL, ETL, Views, Types, Packages, Functions, Procedures.

S. Stowers Resume – cont.

Personal and Confidential Page 6 of 7

FleetCor Technologies, Inc. – Norcross, GA

February, 2006 – March, 2007

PL/SQL – APEX MS Access Developer – Contract to Permanent Initially contracted to develop multiple MS Access desktop based reporting applications for upper level managers. This evolved into a permanent position as a PL/SQL developer assisting production developers as needed. I was eventually assigned the responsibility of further developing their data mart used for reporting. This encompassed various levels of materialized views and PL/SQL packages to create the proper Fact and Dimension tables. Various PL/SQL packages were created to support management reports and auditing.

Gather requirements and design desktop reporting systems using MS Access, VBA, Excel, Office automation and PL/SQL – Oracle 10g.

Create PL/SQL packages to support high volume OLTP – Oracle 9i/10g.

Data mart development using multiple materialized views, PL/SQL Oracle 10g.

Develop a management reporting system with Access as the front end and Oracle PL/SQL and 10g database as the back end from the data mart detailed SQL tuning. Technical Environment:

Oracle 9i/10g, PL/SQL, Data Mart, Materialized Views, PL/SQL Developer, SQL Navigator, SQL, MS Access, Excel, VBA, ActiveX Automation, Views, Types, Packages, Functions, Procedures. Access1, Inc – Marietta, GA

1997 – 2006

Developer – Permanent

Design and develop MS Access/SQL Server based reporting and analysis systems. Fraudstop, Inc. – Marietta, GA

July, 1996 – January, 1997

Web Developer – Contract

Developed web site for settlement agents to enter real estate addresses prior to closing to determine if there has been fraudulent activity relating to the closing address. Developed password secured site from scratch based on logic and provided parameters. I designed and developed MS Access front end forms for direct customer access to database and various digital dashboard reporting.

Technical Environment:

ASP, VBScript, HTML, MS SQL Server 2000, Stored Procedures, Windows Server 2003, IIS6, MS Access, VBA, Excel, HTML, Views, Types, Packages, Functions, Procedures. S. Stowers Resume – cont.

Personal and Confidential Page 7 of 7

MetalFlex – Atlanta, GA

1980 – 1996

Developer/Network Engineer – Permanent

I designed, developed and maintained their network, web site, database and reporting systems. Also designed and developed a custom manufacturing system which included the following modules: Order Entry, Manufacturing Requirements Planning and Analysis, multi level Bills of Materials including Work in Process, Scheduling and Planning and Purchasing Advice. Development of these systems originally started in Clipper and later was moved to MS Access using VBA and ActiveX Automation.

Technical Environment:

ASP, VBScript, HTML, JavaScript, MS SQL Server, Stored Procedures, Windows NT Server, IIS, Clipper compiler, MS Access 2.0, VBA, Excel

Technical Summary

Database: Oracle PL/SQL, Database 9i/10g/11g, 12c, SQL (ANSI joins), PL/SQL Developer Web Technologies: Oracle APEX 3.0 thru 19.1, custom themes, templates, authorization schemes, dynamic actions, page/application processes, forms, AJAX Callbacks, reports, RESTful Services, ORDS, Glassfish, JavaScript/jQuery, AJAX, HTML, CSS

Hardware: Dell Servers running Windows Servers 2008, 2008 R2, 2012 R2, 2016, Hyper V, VMWare Microsoft: MS Access, Excel, Office Automation with ActiveX, VB Script, ASP, MS Visio, Project, ADO Education – (81 hours towards EE degree from these schools) University of Baltimore, Baltimore, MD

Indiana University, South Bend, IN

Purdue University, West Lafayette, IN

Oracle University Oracle BI Publisher 11g R1: Fundamentals Advanced Oracle APEX Workshop – SkillBuilders, Inc. Advanced SQL – SkillBuilders, Inc.

Other

USMC

Member ODTUG

Server/networking knowledge

o I have a Domain/LAN in my home that which I designed to be a learning tool and support my efforts as a developer. The domain includes two Dell Servers, one of which is a Domain Controller with AD/DNS. The other Server is virtualized and designed to run multiple versions of Oracle database, APEX, ORDS and Glassfish web server in several multitenant environments. There are also numerous workstations and laptops attached with a variety of OS’s configured for development.

Contact this candidate