Executive Summary

Senior-level developer of business applications using numerous technologies including PowerBuilder, Oracle, PL SQL, Sybase SQL Server, Sybase ASE, T SQL, ASP.NET MVC, SQL Server, Java, MySQL, Cobol, and MVS JCL Mainframe. Expertise in all areas of the system development life cycle. A self-starter capable of taking on new responsibilities with very little guidance. Experience working in a broad range of IT environments and roles. Customer focused, easy to work with, and possessing a unique combination of strong analytical and communication skills. Confident and capable working solo or in team environments. Thrives on solving problems and learning new technologies.

Skill Summary

• PowerBuilder 3, 4, 6 though 12.5.NET 19 years
• Oracle 6, 7, 8, 9, 10 11, MS SQL Server, PL SQL 15 years
• Sybase SQL Server 11, 11.9.2, Sybase ASE 15, T SQL, CT-Lib, DB-Lib 6 years
• Unix C, Silverlight, ASP.NET MVC2, 3 4, jQuery, Bootstrap, OOP, IoC 3 years
• Desktop Automation using SAP BAPI, OLE, OCX and DDE 5 years
• Mainframe Technologies, Cobol, Easytrieve, MVS JCL 3 years
• WaveMaker Java 1 year

Professional Experience

Confidential

Created four different WordPress blogs running on both Linux and Windows servers. Utilized MySQL, SQL Server, PHP, Silverlight, ASP.NET MVC3, WaveMaker, Java, Spring, Hibernate, Struts, Dojo Framework, JavaScript, CSS, HTML, Tomcat 8, Apache PowerBuilder 10.5 against SQL Server MySQL, PowerBuilder 12.5 Web Services consumed by ASP.NET MVC Application, Visual Studio 2010, 2012, C .NET. Created a Silverlight application used in one of the WordPress websites, it was created using Silverlight 4 via C .NET and Microsoft SQL Server. The application is a simple blood plasma half-life elimination charting tool. Utilized Silverlight charts, XAML, CSS, HTML, and created a WordPress plug-in for inserting the Silverlight application into the website. Also created a note-taking Java application that has built in security, is multi-tenant and uses MySQL for the back-end database. Wrote numerous PowerBuilder, WaveMaker and Visual Studio instructional blog articles on a personal blog.

Sr. PowerBuilder

Responsibilities include creation of new modules and support of two legacy multi-tier PowerBuilder applications that support the insurance claims benefit business areas. Utilized Unix-C, Oracle, DB2 and Web Services as part of n-tier servers to PowerBuilder, Java and .NET applications. Migrated components of a drug-administration application from PowerBuilder 10.5 to ASP.NET MVC using C , XML and Web Services. Assumed high-levels of responsibility for many applications covering all phases of application development from creation of high-level design, detail-design documents, development, code-reviews, unit-testing, creation of implementation plans and assisting QA in the creation of system test-plans.

Confidential

• Volunteered to take sole-responsibility of Unix-C, Oracle, Web Services middle-ware components when developers supporting it left the company. Assisted Java developers with enhancements to Java applications that overlapped business functionality in the BenAdmin PowerBuilder system. Took initiative in implementing PowerBuilder Source Control in areas where it was not being used including creation of training instructional documents on Sharepoint.
• An impending merger between Express Scripts and Medco caused downsizing of staff and code-freezes. The work environment went from fast-paced and challenging to one with very little work and lack of challenge. Took initiative to document the PowerBuilder and middle-tier systems on the Sharepoint system during the slow period. I made the decision to leave IBM primarily because of the merger and lack of work. The first year of this contract was 100 travel with a weekly 2,600 mile round-trip commute and was able to exceed expectations sometimes working in excess of 60 hours weekly. During the final year while working for IBM all work was completed from my home office. I left this position by choice do to lack of work related to the pending merger, and can provide outstanding director level references.

Confidential

• Assumed leadership role as the Oracle expert in the migration of a PowerBuilder system that handled billing for telecommunication products for large corporate accounts. The system was written in PowerBuilder 11.5 against Sybase ASE 15 and was migrated to PowerBuilder 12 against Oracle 11. The system was very large and complex having about two dozen PowerBuilder libraries and hundreds of database objects that needed to be re-written for Oracle. Assisted the team in re-designing trigger code in Oracle which was much different than the way processing was handled with the Sybase database. Converted Sybase Procedures to Oracle Packages and Procedures.
• Redesigned many of the back-end processes that could not be ported directly to Oracle using new Oracle packages having functions that simulated Sybase ASE functions. Also utilized existing Oracle packages such as UTL FILE, UTL SMTP along with UNIX scripts to replace interface logic where external files needed to be created and sent to other systems. Used SQL Loader and Oracle Directory Objects for interface files that were loaded from other systems into the Oracle database. Created an installation program for the new application including use of the new Oracle Instant Client library.

Confidential

Implemented a WordPress MySQL Open Source Content Management System that was used for one of the online publications. Utilized WordPress, MySQL, Linux and Amazon EC2 Cloud Servers. Was sole developer reporting to one of the directors of the company. This small company could not afford a full time IT consultant, so when the task was completed I moved on to AT T.

Confidential

Develop new PowerBuilder/Oracle applications and modify existing PowerBuilder/Oracle applications that facilitate the engineering and design of new Power Generation plants for Siemens external customers. Sole developer of all PowerBuilder systems at Siemens for the last six years of the contract due to attrition of developers over the eight year contract. Used PowerBuilder versions 8, 9, 10, 10.5, 11 and 11.5 against Oracle 8, 9 and 10.

Confidential

• Created DDL for new Oracle tables and data-model modifications. Performed major conversions, data-transformations and migrations for the IDEA system that supported the engineering department in the creation of Power Generation Plants.
• Key deliverables include a generic workflow engine that was needed for one project, but ultimately used for four different business workflows. Each new workflow required very little coding effort because of the way that the work-flow engine was designed. The work-flow rules were designed to be data driven which allowed Siemens to change quickly with the business while keeping development costs and risk to a minimum. Utilized Oracle procedures and table driven workflows maximizing separation of concerns between the business rules and the graphical interface. Created numerous interfaces and workflows while refining the design so that each took less time and had fewer defects. Other notable accomplishments include creation of NVO's for various SAP interfaces and BAPI's via OCX controls. Worked with SAP developer to create custom BAPI and convert many manual processes or nightly interfaces to real-time interfaces.
• Re-designed one the largest PowerBuilder applications while working as sole developer. Handled all production support, mainteneance, enhancements and new development. The mission critical system, IDEA was responsible for assisting the engineering department take a new power plant from concept to completion. The SAP BAPI interfaces eliminated the need to manually create purchase requisitions in SAP and upon approval of purchaseable items the PR was created automatically. Interfaced with SAP in real-time to tie purchase orders to requisitions in real-time as the items were final-approved by the buyer. The workflow process greatly reduced manual effort making Siemens more competitive in the market-place while increasing internal customer satisfaction, and minimizing liquidated damages resulting from missed deadlines.
• Assumed sole responsibility for the redesign of the MDL process of IDEA. The redesign required a major three-day data-conversion to occur over the Thanksgiving holiday and required a contingency plan should the migration fail. Performed user-training of the new features, handled the creation of DDL for database changes and SQL updates needed to implement new features. The MDL redesign was one of the defining projects of my tenure at Siemens, and was a huge success in all aspects. The redesign improved user satisfaction by reducing window open times from 30-45 seconds to less than five seconds, it also greatly reduced trouble-ticket calls that occurred as a result of the poor design of the system before the re-write. The new MDL system allowed Siemens to request changes to the process without risk of breaking the application due to the redesign which utilized Object Oriented Design techniques such as encapsulation inheritance.
• Assumed responsibility for Plant Design module a complex PowerBuilder 11 application. The application was used to read the database of the CAD tool and locate design conflicts that the CAD tools were not able to do themselves. Utilized UNIX, Shell Scripting, Crontab, and VI Editor for batch processes. Worked with SAP developers in designing and implementing interfaces to SAP.

Confidential

• Worked with other developers on a new ASP.NET applications used for business loan approval. Utilized XML/XSLT and Oracle DBMS. Modified and enhanced existing PowerBuilder/Oracle applications related to business loan approval. Helped to move PowerBuilder functionality to a web based application using ASP.NET. Created design documents, created DDL for new database objects, and worked with QA teams in creating test plans for new changes.
• Lockheed Martin Corporation, Orlando, FL July, 2000 to Jan, 2001 : Sr. PowerBuilder Sybase
• Implemented new interfaces to existing applications using PowerBuilder 6.5/ Sybase 11.9.2/UNIX/WINNT. Tasks include writing Sybase stored procedures and triggers Transact-SQL , UNIX shell scripts, and cron jobs. Performed data-modeling. Perform bulk-loading of tables and data via batch execution of stored procedures. Write programs to clean data.

Confidential

Senior programmer for major military logistics software written in PowerBuilder 6.5 against Oracle 8. Worked in excess of sixty hours per week developing the complex logistics software, specifically on the module that assisted with the planning of asset movement on various cargo ships. This was a short travel contract.

Confidential

• Software engineering consultant responsible for maintenance, enhancement and problem resolution for four client/server systems: Creative Costuming PowerBuilder 6.5/Oracle 8.0.5/Unix , Special Events PowerBuilder 6.5/ Informix 7.3 , Event Production System PowerBuilder 6.5/Informix 7.3 and Guest Comments PowerBuilder 6.5/Informix 7.3 .
• Responsible for the migration of Creative Costuming Procurement System from PowerBuilder 5 / PFC / Sybase 11 environment to PowerBuilder 6.5 / Oracle 8 client/server environment. Effort included conversion of Sybase database containing 80 tables and over 300 Transact-SQL triggers and stored procedures to Oracle tables and PL/SQL triggers. Assumed leadership roles among PB developers, created service-based OO class-library.

Confidential

Worked on a state of the art Interactive Television project utilizing PowerBuilder and Oracle 7. The FSN was an experimental project. Created numerous reports using PB against an Oracle in some cases the tables had in excess of 25 million rows. Experience using Oracle hints explain plan in query optimization. Utilized PowerBuilder 6, ERwin for data-modeling and Crystal Reports. The project nearing it's end when I moved on.

Confidential

Enhanced and maintained very large billing system using Cobol, VSAM, Assembler, MVS JCL Easytrieve. Created batch ACH process for automated payments. Was assigned a new role to develop new applications using PowerBuilder 3 and Oracle. Assumed leadership role in creation of an object-oriented service based class library for PB before the PFC was available. Sole developer of a new PowerBuilder 3 application used by wholesale gas buyers. Utilized Unix Pro C, PowerBuilder 3, ERwin and Oracle.

Confidential

Enhanced and maintained computer systems for the University using DOS JCL, Cobol, Natural2 Adabas and DB2 application while completing my degree in Computer Science. Designed real-time interactive applications with Natural2 Adabas on a Token Ring Network.