Manager Developer

Location:

Lawrenceville, GA

Salary:

95K

Posted:

September 08, 2016

Contact this candidate

Resume:

pointCover Page

I've been involved in lead development of software solutions for over thirty years and almost twenty of those years have been as a consultant. I've experienced a broad array of software and platforms including UNIX and Windows Servers, Oracle Enterprise Server, MySQL, Web Applications Servers, PL/SQL, Transact SQL, Java and PowerBuilder.

In 2009 I worked for the Department of the Navy. As a result, I was thoroughly vetted with a clearance sufficient to work on critical Department of Defense applications. Additionally, I have a Q clearance to work with applications involving nuclear materials.

Having such a broad background is especially helpful when it comes to troubleshooting the myriad of possible causes when systems degrade and perform poorly. On that note, I have extensive Oracle Performance Tuning experience.

As for Oracle, I have worked extensively with this database starting with version 5 and as recently as 12c either as a Database Administrator or developer and often serving both roles. During that time, I have created Oracle centric solutions such as:

•Building database models using products like Erwin and deployed as Operational and Data Warehouse data stores

•Installing and configuring Oracle Operational and Data Warehouse data stores on Microsoft Server and UNIX platforms

•Developing Stored Procedures, Functions, Packages and Triggers

•Designing ETL processes involving Oracle Scheduler or other third party ETL solutions using Pentaho, Appworx, AutoSys, Crontab, etc.)

•Developing and/or troubleshooting of Web and Client Server based UI solutions involving Java JSP and PowerBuilder

•Database and SQL Tuning

For more information, visit http://www.linkedin.com/in/jackwhaynesjr

Please take the time to review the comments others have written regarding my work.

Sincerely,

Jack W. Haynes, Jr.

Senior IT Consultant

Mobile: 404-***-****

Email: ************@*****.***

Highlights:

Operational and Data Warehouse Development involving:

•Over 30 years of Life Cycle Development and team leadership including Business Analysis and Design with more than fifteen years of GUI OO client server and web development utilizing a variety of languages such as PowerBuilder, Core Java, Java JSP, J2EE and Web Services, MS Access and the Oracle Developer Suite in both Unix and Windows Server environments.

•Over ten years of technical writing, training and mentoring

•Senior Level Oracle PL/SQL Application Development

•Senior Level ETL Development

•Senior Level Database design using ERwin and S-Designer

•Mid to Senior Level Oracle DBA using Oracle 7 thru 12c including RAC

•Mid to Senior Level Oracle Performance Tuning including AWR, ADDM and ASH

•Outstanding communication skills, experienced in leading teams and initiatives, interacting with clients, instruction, and mentoring

Education:

Graduated from North Carolina State University with a Bachelor’s of Science Degree in Applied Mathematics with a strong background in Computer Science.

Software Summary:

Software

Years of Experience

Last Used

Apache Web Server

2016

Crystal Reports

2012

Erwin and S-Designer

2010

HTML, DHTML, JavaScript

2015

IDE (Eclipse, WebSphere, Net Beans)

2015

Java

2015

Java Spring Framework

2015

JDeveloper IDE

2015

Job Scheduler (Tidal, Oracle, Appworx, AutoSys)

2015

MySql

2012

ODBC and JDBC

2014

Oracle Enterprise Manager (10g, 11g, 12c)

10+

2016

Oracle Forms and Reports 6.1

2012

Oracle PL/SQL

10+

2016

Oracle Enterprise (7, 8, 9, 10g, 11g, 12c)

2016

Oracle Utilities (Sqlloader, impdp, expdp, sqlplus, srvmgrl, Oracle Enterprise Manager (OEM) Grid Control, OEM, Tuning Advisor, Explain Plan, ADW, ADDM, ASH, RMAN, ASM, Data Guard, Golden Gate Replication)

10+

2016

Pentaho

2012

PowerBuilder 5, 6.5, 10.2, 11.5

2012

SQL (Oracle, Transact SQL)

10+

2015

SQL Developer

2016

SQL Server (2005, 2008)

2014

SQL Server Utilities (SSIS)

2014

Sybase

2012

Toad

2015

Tomcat Application Server

2016

UNIX (Oracle Linux, Red Hat Linux, AIX, HP-UX)

2016

UNIX KORN Shell Scripting

2016

UNIX Utilities (crontab, ssh, ftp, sftp, telnet)

2016

Windows Server (includes NT and 2000, 2003, 2005 and 2008)

10+

2014

Functional Role Summary:

Development Area

Discipline

Years of

Experience

Last Used

Business Analysis

10+

2012

Crystal Report Development

0.5

2002

Data Mart/Data Warehouse Development

2014

Data Modeling

2012

Database Architect

10+

2014

Java Developer

2012

Microsoft Access Developer

2010

MySql Database Administration

2012

Oracle Database Administration

2016

Oracle Production Support

2016

Oracle Forms, Oracle Reports, Discoverer Development/Admin

2012

Performance Tuning

10+

2016

PL/SQL Developer

10+

2015

PowerBuilder Developer

2012

SQL Server Database Administration

0.5

2011

System Designer

10+

2012

Technical Writer

10+

2016

Training, Mentoring

2015

Summary of Application Experience:

Discipline

Years of

Experience

Asset Management

Broadcasting

Defense Manufacturing

10+

Non-Defense Manufacturing

Banking

Case Management

Energy Management

Financial Accounting

Government Systems

Healthcare

Inventory Management

Military Supply

Other (Data Migration, Utilities, etc.)

Pharmaceuticals

Quality Assurance

Retail

Sales and Commissions

Telephony (Including Mobile)

Television Broadcasting

Workman’s Compensation Insurance

Work Experience

Home Depot Oracle DBA, Developer 11/15 –1/16

Home Depot’s year end was rapidly approaching and there were a number of tasks that needed to be completed. With manpower short, they called me in to help them troubleshoot and resolve the problems they were experiencing in their Oracle environment which included a database farm of over fifty databases employing RMAN backup with some database configurations involving Data Guard/Failover, Golden Gate replication and RAC. As a result of that effort, I help reduce their pages and email alerts by over one third and completely eliminated their RMAN backup standby errors. One type of error required substantial KORN shell script enhancements which eliminated unnecessary pages and email alerts involving ASM Utilization. While performing production support, I monitored, troubleshot and resolved production issues involving, memory, CPU, process, network, performance and disk space issues involving mount point and ASM and at times requiring bridge calls involving application, network and UNIX System Administration groups. Additionally, I developed over 60 pages of production support documentation providing detailed instructions on how to resolve their most common production support issues which was handed off to the Oracle DBA Team.

Software Used: Linux UNIX and utilities, Oracle 11 (Cloud Offering), Oracle Enterprise Manager (OEM) Grid Control, OEM, Tuning Advisor, Explain Plan, ADW, ADDM, ASH, RMAN, ASM, Data Guard, Golden Gate Replication, SQL Developer, telnet, WinSCP

AT&T PL/SQL Developer, Web Service Tester 5/15 – 10/15

AT&T needed a very broad based developer. Initially I was responsible for the development of PL/SQL Packages, Procedures and Functions and the creation of autonomous blocks that would assist in the automatic deployment of PL/SQL and SQL (DML and DDL) code so that it could be deployed without human intervention into their many development, test, UAT and production environments. The automated deployment portion of development required an extensive background in the various Oracle Database Objects such as Tables, Views, Materialized Views and Logs, Database Links, XML Data Types and supporting XML Package, DBA/User Tables, Oracle Performance Tables, Oracle Scheduler, etc. Additional tasks involved the testing and troubleshooting Java Web Service APIs which required the ability to review subversion managed Java Web Service Code, review Application Server Logs, monitoring and troubleshooting using the WebLogic Administrative Console and review of data found in the many Oracle 11 Database Repositories. Additionally, I developed over 200 pages of support documentation which was handed off to the team to help any new hires that would come on board in the future.

Software Used: Linux UNIX and utilities, Standard AT&T ITO Cloud Linux servers, Eclipse STS IDE, Weblogic 12c (Cloud Offering) Application Server, Oracle 11 (Cloud Offering), Java 1.8, Spring 3.1 and 4.0, Hibernate 4.1, Splunk, SONAR, RALLY, AT&T instance of JIRA, SubVerson, SCM Build Tools, Eclipse Spring Tools Edition, Wily Introscope, Optier, Angular,js, Log4J, FishEye, Crucible, SOAP UI, Maven, Spring Continuous Integration Framework, Hudson, Active VOS (Informatica), Quartz Timers – Open Source, Subversion

Verizon Wireless PL/SQL Developer 12/14 – 4/15

Verizon Wireless needed a very broad based developer in support of their mission critical Enterprise Prepaid System (EPS) and SMART UI who had a background involving Web Applications Servers, Java and Oracle. I was responsible for troubleshooting production Java application errors and troubleshooting and resolving PL/SQL errors involving packages, procedures and functions which required enhancements and providing Oracle performance tuning analysis and support which often involved the rewrite of complex SQL. Verizon databases included a massive data warehouse with one table growing by 56G per day capturing up to six months of audit data. Another database was accessed by online users using the SMART UI where transaction time improvements of even ten percent were considered significant as it affected thousands of online users throughout the work day. Additionally, I developed over 350 pages of production support documentation which was handed off to the team to help any new hires that would come on board in the future.

Software Used: Linux UNIX and utilities, FileZilla, SSH, Oracle SQL Developer, Oracle PL/SQL, SQL Plus, Toad for Oracle, IBM WebSphere IDE, IBM WebSphere WAS, AccuRev Version Control, Java 1.6, CA Workload Manager, Introscope (Wily) Monitor

Ventyx Inc. Oracle DBA, Designer, PL/SQL Developer 5/13 – 7/14

Ventyx is a supplier of software solutions for Utility companies. They were ramping up their consulting arm in anticipation of software orders as a result of being acquired by the multinational conglomerate ABB. As a result, I signed on to assist in the development of customer specific enhancements needed in support of two Focal Point Modules: Work Management System (WMS) and the Outage Management System (OMS). In addition to extensive training in the Focal Point product line, I was responsible for leading and providing technical support involving:

•Led the development, enhancement, testing, tuning, documentation and deployment of Oracle 11 PL/SQL Table Functions, Stored Procedures and Packages involving Focal Point WMS and OMS data warehouse and operational data stores

•Led Focal Point WMS and OMS Software WebPart Development and/or Enhancements

•Led WMS and OMS ETL Development and support using FPETL and the OSIS Job Scheduler

•Provided presentation and mentoring of new product features

•Architected/Modeled all customer ETL staging data stores

•Focal Point WebPart Editor and Administrator tool installs, troubleshooting and usage

•Spearheaded the Oracle 11/Focal Point Performance Tuning involving OLTP and Warehouse Databases supporting WMS and OMS

•Responsible for developing the creation and implementation of remote database links, external tables and data warehouse tables in support of the Focal Point WMS and OMS

•Installed, tuned and troubleshot Focal Point Web Applications Servers and Oracle 11 Databases in support of WMS and OMS

•Led the troubleshooting and resolution efforts related to spatial reporting and ETL issues in support of OMS

•Responsible for the creation of over 200 pages of Focal Point implementation documentation in support of OMS

Oracle 11 Enterprise Server, Oracle AWR, Oracle ADDM, Oracle ASH, Oracle 11 PL/SQL, Focal Point Tools (WebPart Editor, WebPart Administrator, Spatial Administrator), Focal Point Modules (WMS and OMS), Toad, and Oracle SQL Developer

LWCC Designer, PL/SQL Developer 3/12 – 10/12

LWCC had a backlog of critical enhancements that they needed which required a wide range of software skills:

•Led the development and enhancement, testing, documentation and deployment of PL/SQL triggers, Stored Procedures and Packages supporting both the PHS, Lagniappe and Policy Holder System (PHS) PowerBuilder 10.2 Applications

•Led the development and enhancement, testing, documentation and deployment of the Oracle PL/SQL HTP Web Package based Agency/Policy Holder Web Portal

•Provided presentation and mentoring of new product features

JDeveloper 10g, JDeveloper 11G, SQL Developer, PL/SQL, Oracle Forms 6.0, Oracle Reports 6.0, PowerBuilder 10.2, Oracle HTP Web Package, Oracle Enterprise Server 10.2, SQL Navigator 6.0, SQL Tools 1.6, SQL Plus for 10g, SQL*Loader for 10g, StarTeam, Hyperion SQR Developer 8.3

McKesson Oracle DBA, PL/SQL Developer 5/11 – 11/11

McKesson management needed someone with a core Oracle DBA and Oracle Development background who could work with their developers in a fast paced Java/J2EE development environment. They had a huge backlog of DBA work that needed to be worked for their development team to get back on track. The application being supported involved PL/SQL, Core Java, JSP, Hibernate Database Objects, J2EE EJB and Web Services.

Provided database support services including:

•PL/SQL Store Procedure and Trigger Development and Tuning

•Architected/Modeled all Operational Data Stores

•Data Dictionary Development

•Database backup and restores including RAC Clusters

•Database porting and upgrading

•Database Cloning

•Database solutions involving RAC Clusters

•Database Analysis and Recommendations

•AWR Analysis and Database Tuning

Responsibilities also included production support. Troubleshooting included numerous platforms and software including Database, Client Server, Batch Job and Web Application issues running on Microsoft and UNIX Servers.

Environment: Oracle Enterprise 10g, PL/SQL, Recovery Manager (RMAN), ASM, AIX Unix, Oracle Linux 6, Toad for Oracle 9.6, SQL Developer, SQL Plus, Oracle Datapump, SQL Loader, SSH Secure Shell Client, StarTeam Source Repository

REM Enterprise Solutions Designer, Lead Developer 6/10 – 4/11

AT&T was having a problem managing their 4G rollout. They were bogged down with a database solution that wasn’t robust enough for managing their project management tasks and reporting. They had to step up to an enterprise database solution and quickly. Additionally, they had several mission critical Java EJB and Web Service Applications that needed to be enhanced in order to continue their support agreement with Oracle. To facilitate that effort:

•Led the analysis, migration and documentation of AT&T’s Java, Web and Web Service Bison and BonsCS applications from WebLogic 8.1 to 10.3

•Led the development of the data model for the target repository as well as the supporting data dictionary

•Led the effort to install, administer and configure the WebLogic 10.3 Application Server to insure deployment of migrated Web Applications and supporting EJBs and Web Services were successful

•Led the design and deployment of their new consolidated database using the Quest Toad Data Modeling tool

•Provided presentation and mentoring of new product features

•Led the development, testing and deployment of AT&T’s ETL batch processes to transmit Oracle remote repositories into a consolidated SQL Server Database using:

1.Microsoft SSIS migrating data from ODBC sources involving excel spreadsheets, Oracle Tables, SQL Server 2005 and 2008 Tables, MS Access Tables and tab and comma delimited files

2.FTP

3.Stored Procedures

Environment: Oracle 10g, Oracle 11g, Enterprise Manager, JDeveloper 11g, Oracle SQL Developer, SQL Server 2005/2008, SSIS, Microsoft Access 2003/2007, Red Hat Linux 5, Oracle Linux 6, Quest Toad Data Modeler, Microsoft Data Management Studio, IIS, WebLogic 10.3, SQL Plus, SQL Loader, SQL Developer, Maximo Asset Manager

Floor and Décor Outlets Designer, PL/SQL Developer 2/10 – 6/10

Floor and Décor had neglected their IT budget. As a result, they had a huge backlog of PL/SQL enhancements, database performance issues and just broken application software. As a production support resource, it was incumbent on me to fix the issues and provide technical guidance. As a result of that effort:

Developed or enhanced and deployed several PL/SQL Stored Procedures

Developed a standalone Oracle Forms web application that permitted store managers to maximize the loading of merchandise into tractor trailers. This involved some very sophisticated PL/SQL to generate the load information.

Troubleshot and resolved several mission critical performance issues involving PL/SQL

Environment: Oracle 9i, Enterprise Manager, Oracle PL/SQL, Oracle Forms, Oracle Reports, Quest Toad (PL/SQL Application Development), putty, AIX UNIX, KSH, N3 Version Control Manager

Federal Home Loan Bank Designer, PL/SQL Developer 8/09 – 2/10

The bank needed technical guidance and had a backlog of enhancements, database performance issues and just broken application software. As a production support resource, it was incumbent on me to fix the issues and provide technical guidance. As a result of that effort:

Developed or enhanced several PL/SQL and Sybase Transact SQL Procedures

Troubleshot and resolved several mission critical issues involving:

1.Oracle PL/SQL Stored Procedures and Packages

2.Sybase Transact SQL Stored Procedures and Packages

3.Java Web Service and J2EE Applications

4.PowerBuilder 10.2 and SQR Applications

Conducted data centric code reviews of applications written in Java J2EE, Java Web Services and PowerBuilder 10.2 advising management of issues related to poor performance

Environment: Sybase 12, Oracle 11g, PL/SQL, ERwin, Enterprise Manager, Oracle SQL Developer, Web Logic 10.3 IDE, J2EE Oracle Beehive (Hibernate), Java 1.6, Oracle PL/SQL, SQL Loader, Sybase Transact SQL, Sybase iSQL, Sybase Central, PowerBuilder 10.2, putty, AIX UNIX, KSH, Subversion, Tidal Job Scheduler

Department of the Navy Designer, Lead Developer 8/08 – 08/09

Navy supply and Aviation Maintenance were implementing major improvements to their mission critical application software. Additionally, they needed database design experience to help improve their throughput. As a result of assisting their effort to enhance their applications, the following was accomplished:

•Led the development, testing and deployment of major PowerBuilder enhancements to the Navy’s Supply PowerBuilder Application commonly referred to as R-Supply and the Marines Aviation Maintenance and Configuration Applications commonly referred to NALCOMIS OMA and NALCOMIS AME

•Led the development, testing and deployment of Sybase Transact SQL Stored Procedures

•Led the development, testing and deployment of a Java Application that created an OMA an AME application database usage report

•Led the database review and created the final database model using ERwin in order to provide database performance recommendations.

•Provided presentation and mentoring of new product features

Environment: PowerBuilder 6.5 and 10.2, Sybase 12 and 15, Oracle 10g and Oracle 11g, Eclipse IDE, JDeveloper 10g IDE, Java 1.4, Sybase Transact SQL, Sybase iSQL, Sybase Central, putty, Linux UNIX, HP UNIX, JBoss AS, PVCS

Sun Microsystems Oracle DBA, Designer, Lead Developer 4/03 - 7/08

Sun Management needed to support their customer base more effectively. The number of servers being managed had grown exponentially and it was becoming time prohibitive and error prone while diagnosing the state of health of the server base. My duties involved:

Led the development, testing and deployment of all Database PL/SQL Packages, Procedures, Triggers and Functions supporting the Field Engineer Support Application

Led the Architecture/Modeling effort for all Operational Data Stores and Data Warehouse

Led the development, testing and deployment of the ETL layer between the Oracle database and MySQL Databases using the MySQL, SQL*Loader, PL/SQL Stored Procedures, a custom built Java Applications, FTP and KORN Shell Scripts

Led the effort to configure and troubleshoot the Sun One AS and Tomcat AS and deployment of all Java JSP and J2EE application components

Led the migration effort to move the applications from the Sun One AS to the Glass Fish Application Servers

Administered the Sun One AS and Glass Fish Application Servers

Led the development of the communication interface between the MySQL 3.x and 4.x Databases to an Enterprise Oracle 10g Database using Oracle’s Heterogeneous Services (HSODBC)

Provided presentation and mentoring of new product features

Responsibilities also included production support. Troubleshooting included numerous platforms and software including Database, Batch Job and Web Application issues running on Microsoft and UNIX Servers.

Environment: Oracle 8i, Oracle 9i and Oracle 10g, Oracle’s Java 1.6 and Java JSP, Oracle PL/SQL, MS Access, Apache, Sun One AS, Tomcat AS, Glass Fish AS, HTML, DHTML, JavaScript, Sun Solaris 8, 9 & 10, Red Hat Linux 7.2, Sun Solaris X86 9 &10, Oracle Enterprise Manager, Oracle Performance Manager, Oracle’s HSODBC for 10g, puTTY, JDeveloper 9i and 10g, SQL Plus, SQL Worksheet, Perl 5.1, Aqua Studio, Netscape 7.0, Sea Monkey, JavaScript Debugger, Erwin, Toad, Rational Rose, StarUML, Oracle Enterprise Manager, MySql 3.x and 4.x,MySql 4.1 Query Browser, MySql 4.1 Administrator

Contract History

Date Range

End Client

Prime Contractor or Employer Name

Paid

Employee Paid By

11/2015-01/2016

Home Depot

Kforce 990 Hammond Dr., Ste.1000, Atlanta, GA 30328 Ph: 404-***-****

Kforce, Inc.

05/2015-10/2015

AT&T

Amercian CyberSystems, Inc.

2400 Meadowbrook Pkwy

Duluth, GA 30096

American CyberSystem, Inc.

11/2014-

04/2015

Verizon

Rivi Consulting, Inc.

2475 Northwinds Pkwy, Ste 200

Alpharetta, GA 30009

Rivi Consulting, Inc.

08/2014-10/2014

The Weather Channel

The Intersect Group 10 Glenlake Pkwy, Suite 300 South, Atlanta, GA 30328 Reported to: Javier Agosto Ph: 678-***-****

The Intersect Group

05/2013-07/2014

N/A

Ventyx, Inc. 400 Perimeter Center Terrace, Atlanta, GA 30346 Reported to Greg Zavier Ph: 303-***-****

Ventyx, Inc.

11/2012-02/2013

PHH, Inc.

Modis IT, 1040 Crown Pointe Parkway, Suite 810 Atlanta, GA 30338

Reported to : Cliff Culberson, Tel: 770-***-**** or 800-***-****

C2C

Young Technical, Inc.

03/2012-10/2012

Louisiana Workman's Compensation Corporation

JVT Advisors

35 New England Business Center

Suite 210 Reported to: Tyler Nevin Ph: 978-***-****

Andover MA 01810

C2C

Young Technical, Inc.

11/2011-03/2012

N/A

Performance Matters, 1197 Canton St., Roswell, GA 3075 Reported to James Waters Ph: 770-***-****

Performance Matters

05/2011-11/2011

McKesson

Kforce 990 Hammond Dr., Ste.1000, Atlanta, GA 30328 Ph: 404-***-****

Kforce

06/2010-04/2011

N/A

REM Enterprise Solutions, Inc., 1140 Old Peachtree Rd. Suite E, Duluth, GA 30097 Ph: 770-***-****

REM Enterprise Solution, Inc.

02/2010-06/2010

Floor and Décor

Veredus, Inc. 950 E. Paces Ferry Rd. NE, Ste 1585, Atlanta, GA Ph: ***-**-****

C2C

Young Technical, Inc.

08/2009-02/2010

Federal Home Loan Bank

Anteo Group, Inc.

1230 Peachtree St NE #2350, Atlanta, GA 30361

404-***-**** I cannot remember who I reported to

C2C

Young Technical, Inc.

08/2008-08/2009

Department of the Navy

Apex Systems, Inc., 9040 Hampton Blvd., Norfolk, VA 23505 Reported to: Mike Kreider Ph: 757-***-****

Apex Systems, Inc.

04/2003-07/2008

Sun Microsystems

IT Resource Solutions, 10 Technology Dr. Ste 1, East Satauket, NY 11733 I reported to Valerie Cummo Ph: 631-***-****

C2C

Young Technical, Inc.

Contact this candidate