SUMMARY:

11 years of experience working with PowerBuilder from version 2 to 11

TECHNICAL SKILLS:

Programming tools: C#, .Net, VB.Net and .Net Technologies

Database Experience: Oracle, SQL, Sybase

PROFESSIONAL EXPERIENCE:

Confidential, Baytown, TX

PowerBuilder Developer

Responsibilities:

• Developed a package which displays all views / tables in the system. After users click the table / view the selected table / view are displayed. The displayed data can be displayed in graphic. They can be saved to Excel files if users want.
• Modified legacy programs on manager’s request.
• Added pfc scripts to FIND / FILTER data on the screens. Modified Order Entry programs to make it work for the business.
• Inserted scripts in w master to do audit trails, on windows selected by users, plus a non - visual user object n ss audit.
• Write programs to allow users to save our business reports into Excel files. Implemented dragdrop to let users move rows up and down.
• Fixed the infinite loop in corp n cst dwsrv dropdownsearch.

Environment: Powerbuilder 9.03, PFC, Transact Server (SQL Server 2008)

Confidential, Dallas, TX

Onshore Programmer

Responsibilities:

• Absorption, Knowledge Acquisition and Knowledge Transfer from the programmer and technical-support team of Southwest Airline.
• Analyzed the business flows and interfaces of the Cargo Accounting Tracking and Tracing System (CATTS).
• U.S. taxes were mistakenly added to cargo flown from / to foreign cities.
• Added scripts to stop incorrect data found in database which shows 50% of cargo were inspected while 20 pieces out of 20 were inspected.
• Re-instated a customer account when no one knows how (except the programmer who was in training class.)
• Reverse refund.
• Protect and default to reduce operator error. Work on the new release.

Environment: Powerbuilder 10.5, PFC, Sybase ASE 12.5, SQL Builder, Remedy, Unix, Java

Confidential, Austin, TX

Programmer

Responsibilities:

• Modifications on the education database application in Powerbuilder 9 with EAServer, PFC, Sybase 12.5 TSQL, stored procedures, Rapid SQL, Citrix.
• Collected requirements, analyzed, designed and developed an add-on package called 'Fleet Management', then designed database tables, triggers for DBA to execute (He is the only one with privilege) and developed programs covering 4 update programs and 5 reports in PowerBuilder 11, EAServer, PFC, TSQL in Sybase, Aqua Data Studio. Presented the 'Fleet Management' to our team.

Confidential, Houston, TX

Powerbuilder Programmer

Responsibilities:

• Implementation of Terms & Conditions for TX Set 3.0 from ERCOT on Industrial and Commercial and Streetlight Billing Information System for Confidential . The software was written in PowerBuilder 8 with Oracle 9i Database. PL/SQL, 'Toad,' and MS Visio were used.
• I also wrote the following programs in .Net and Oracle databas.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Fixed the lock-up problem of Billing system which was written in PowerBuilder 8, Informix, and Visual Source Safe.
• Researched, analyzed, designed and developed a way to handle multi-currencies in the Billing system for an oil-drilling company. Technical design was involved.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Worked on project team of 5 in the development of a Electricity Trading system using PowerBuilder 10, SQL Navigator, Visual Source Safe on an PL/SQL Oracle 9i platform
• Wrote DML and DDL to modify Oracle database. Technical design was involved

Confidential, Pittsburg, PA

Programmer (Contract)

Responsibilities:

• Responsible for programming enhancement to an Order Entry System using PowerBuilder 6.5, Toad, and PL/SQL running on PL/SQL Oracle 8i.
• The project involved converting large amounts of data into Telcove's databases utilizing SQL Loader, stored procedures and Unix scripts.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Developed inventory reports utilizing Crystal Reports, stored procedures and PL/SQL

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• When users told me that "Monthly Invoicing" didn't work (exist). I worked with managers and users to design and develop programs for monthly Invoicing; Developed partial invoicing; vessel statistics; displayed 'net Oil/Chemical transfer' bypassing the time-consuming processes of batch procedures. Alter table keys and triggers. (involved Technical design).
• Provided support (7 Intertek locations in 3 states) on an application which measures the quantity of oils/chemicals in a vessel. The application was written in PowerBuilder 5/PFC and stored procedures were Oracle 8i and PL/SQL.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Participated in group of 2 to 5 programmers in developing a Cost Estimate application written in PowerBuilder 7/PFC/Tranact SQL (SQL Server).

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Analyzed, designed and developed 1099 Miscellaneous Reporting system using PowerBuilder 5/PFC/MS, stored procedures in Programs retrieved data from 3 databases on 3 servers.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Assisted in fixing bugs, creating/modifying stored procedures and triggers for package written in PowerBuilder 6.5/PFC/SQL Anywhere/Crystal Reports prior to rollout into production environment

Confidential, Texas City, TX

Programmer (Contract)

Responsibilities:

• Analyzed, designed database tables and triggers and Developed a Constraint Management system for oil refinery in PowerBuilder 5.02 and upgraded to PowerBuilder 6.5 PFC running on PL/SQL Oracle 7.3.
• The package was rolled-out to production environment with over 1000 users.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Maintained a three-tiered Energy Transportation package in a PowerBuilder TSQL in Sybase/C++/Entera UNIX environment.
• The package consisted of Ticket, Tariff, Communication, Quality Bank, Loss/Gain and Revenue Accounting. Interfaced with users.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Migrated BFI's Tax Provision system from PowerBuilder 4 to PowerBuilder 5.0 in an PL/SQL Oracle 7.3, TCP/IP, Token Ring, Windows95 and Windows NT 4.0 network environment. Involved table changes and data conversion using SQL and stored procedures.

Confidential, Houston, TX

Programmer (Contract)

Responsibilities:

• Analyzed, designed and developed a non-visual user object which saved data across windows, data windows, and sent e-mail in PowerBuilder/TSQL in Sybase 11. Provided technical assistance to other programmers.
• Worked to develop HR, Time Entries, Company Directory, Facility, and Pager Tracking programs

Confidential, Houston, TX

Programmer

Responsibilities:

• Analyzed, designed and Developed ancestors (2 non-visual user objects and 1 window) in PowerBuilder/Informix and ObjectStart. In charge of the creation of executables.
• Performed code review at consultant site and coordinated daily with managers and programmers