We provide IT Staff Augmentation Services!

Powerbuilder / Sql Developer Resume

Houston, TexaS

PROFESSIONAL SUMMARY:

Possesses over twenty - five years in the IT industry as an application developer/analyst with extensive experience in providing production and application support. Excellent verbal and written communication skills. Comfortable interacting with peers and managers at all levels.

TECHNICAL SKILLS:

Operating Systems: Windows NT / 2000, Novell Netware, UNIX

Languages: PowerBuilder (v2.0 to v2018), SQR, SQL, PL/SQL

Software: Oracle 8i, Sybase 9/10, MS SQL Server (2017), PFC 12.6

Applications: Customer Care Toolkit (proprietary), MS Office, MS Project

Energy Trading Apps: GASMAN, GTS, Altra GMS (Caminus), Epsilon (Sungard)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

Powerbuilder / SQL Developer

Responsibilities:

  • Maintained and enhanced a mature software package built for Oil & Gas traders and transporters using Powerbuilder 12.6 and SQL Server 2016.
  • Learned how to maintain the supporting infrastructure of a SQL Server Service Broker based architecture for communication between databases.
  • Evolved the product from reliance upon a single database to a Service Broker based architecture that links multiple databases.
  • Currently working on an AWS Certified Solutions Architect .
  • Upgraded our software to Powerbuilder 2017

Confidential

Powerbuilder Developer

Responsibilities:

  • The client owns a chain of dental practices that are all connected by a large Powerbuilder 12.5 application running on SQL Server 2008.
  • Perform maintenance and enhancements to Powerbuilder 12.5 application.
  • Maintain and develop SQL Server 2008 stored procedures and triggers
  • Developed several new screens and processes pulled from a backlog of enhancement requests submitted by the user community.

Confidential, Houston, Texas

Powerbuilder Developer

Responsibilities:

  • Perform maintenance and enhancements to 3 legacy Powerbuilder 9.0 applications
  • Maintain SQL Server 2008 stored procedures and triggers
  • Currently migrating the applications to Powerbuilder 12.5

Confidential, Houston, Texas

Lead Developer

Responsibilities:

  • Brought in to build a new system from the ground up to replace the client’s existing Powerbuilder application.
  • Using Powerbuilder 11.5, PFC 11, and SQL Server 2008, built 95% of all datawindows, windows, reports, and stored procedures.
  • Regularly interfaced with client personnel to resolve issues and gather additional requirements
  • Moved access of the application to the web using Appeon for Powerbuilder.
  • Performed all releases and builds to the Production environment including release notes.
  • Resolved several showstopper issues with Appeon which resulted in maintenance releases from this vendor.
  • Responsible for applying Powerbuilder maintenance EBFs when necessary.
  • Regularly used SQL Server 2008 Management Studio to move data between databases and assign appropriate permissions to tables and stored procedures.
  • Successfully completed first 2 phases of the project which resulted in a feature complete product ready for commercial sale.
  • Currently preparing for migration to Powerbuilder 12

Confidential, San Antonio, Texas

Contract Programmer

Responsibilities:

  • Provide technical analysis, development, on-call support, and maintenance of applications used to manage a railroad transportation management and EDI system. Tools included PowerBuilder 6.5 and 10, SQL 2000, MS VB6, MS Visual Studio 2005, proprietary issue tracking system, Crystal Reports 7.0, Sterling’s Gentran:Server for Windows 5.1.
  • Work with client and users to analyze the business requirements and recommend solutions.
  • Spec and code modifications to existing application code in PowerBuilder.
  • Develop test cases and write test plans.
  • Compile, prepare, and deploy software releases.
  • Manage updates of industry data files.
  • Manage updates of industry EDI standards data mapping.

Confidential, Houston, Texas

Contract Programmer

Responsibilities:

  • Hired on to aid in the completion of a large project for the Veteran’s Administration.
  • Built datawindows to house large medical forms using Powerbuilder 11.0 .
  • Learned and began to build ASPX pages using HTML and Microsoft Visual Studio.
  • Responsible for translating data elements on a medical form into XML.
  • Built and maintained a process in SQL Server 2005 that parsed values out of an XML string in to a Powerbuilder datawindow and then pushed the data into a MS Word document.
  • Became the informal interface between the users and the technology group to clarify requirements.

Confidential, Houston, Texas

Lead Developer

Responsibilities:

  • Provided production support for an existing Powerbuilder 9.0 application
  • Developed enhancements to that application based upon new user requirements
  • Gathered and documented all user requirements for a new system involving the management of cash flow for large pipeline construction projects
  • Developed a thorough understanding of the overall business of my user group
  • Created the functional and technical design for the application
  • Designed the structure of all database tables and defined the relationships between them.
  • Performed most programming tasks in the construction of the application.
  • Written multiple Database stored procedures and query programming using T-SQL
  • Was later asked to lead two additional developers when the scope of the project increased.
  • Provided technical support to my user group for many non-Powerbuilder related issues - no problem was left unsolved
  • Provided troubleshooting assistance for a new PeopleSoft implementation when several critical issues remained unsolved

Confidential, Houston, Texas

Internet Business Owner

Responsibilities:

  • Ran two internet businesses from my home. Nutritional and domain sales.

Confidential, Houston, Texas

Support Analyst

Responsibilities:

  • Provided production support for four large oil and gas companies using our software.
  • Part of a project team tasked with the design and development of additional functionality for a small Risk Management package.
  • Resolved any customer issues reported for that package as well as our trading software (GASMAN) and gathering / transportation software (GTS).
  • Was required to perform the technical design and development for enhancements to each system.
  • Achieved a level of system stability where only one customer had reported any issues in the last two months.
  • Technologies utilized were PowerBuilder 7.0, Sybase SQL Server.
  • Performed technical design and database design for a customer issue tracking system developed in-house. This system, the Customer Care Toolkit, was developed using the C sharp and the .Net framework.
  • Worked with potential users of the system to capture their data and properly identify required screens and reports.
  • Milestones for the project were maintained using MS Project.

Hire Now