Consultant / Powerbuilder Developer Resume Profile
Omaha, NE
Experience Summary:
- Sixteen Plus years of technical expertise in Client/Server development. Programming experience includes PowerBuilder, PFC, 'C', C , COBOL, Install Shield, HTML, Perl/CGI, and Unix Bourne, Korn shell scripting.
- Source code includes Microsoft Source Safe and MTF, MKS Integrity, PVCS, ClearCase, Harvest
- Database development includes Oracle 7.3, 10G and 11G, Sybase System 11, DB2,MS SQL Server 2008, SSIS, and Gupta SQLBase, ODBC.
Technical Skills: MKS Integrity, Clearcase, PowerBuilder 2.0A - 7,9,10,5,11.5 , PFC, Sybase SQL Server, Informix, SQL Builder, Java 2, Jaguar, Ea Server, Eclipse, T/SQL, bcp, isql, Oracle PL/SQL, SQL Plus, C/C , Perl 4 and 5 , MS SQL Server, Tivoli, Citrix, PVCS, Desktop DBA, Enterprise Manager, Perl/CGI, Remedy, Erwin, Visio, Lotus Notes, MS Project, Autosys, Tuxedo, Entera OEC, HTML, SMS, COBOL, TCP/IP, FTP, telnet.
Work Experiences:
Title: Consultant / PowerBuilder Developer
- Responsible for PowerBuilder 8. Development of PowerBuilder application for Confidential.
- Used Remote Procedures for data input.
Confidential
Title: Consultant / PowerBuilder Developer
- Responsible for PowerBuilder 11.5 and Oracle 10G development.
- Responsible for maintenance of Child Welfare application for the state of Arkansas.
- Maintained packages, stored procedures functions and triggers in Oracle 10G.
- Migrated Chris application successfully to PowerBuilder 12.5.
- Some experience with Sql Server SSIS.
Confidential
Title: Consultant /Sr. Power Builder Developer
- Responsible for PowerBuilder 12.5 and Sybase ASE development.
- Maintenance of Court Reporting application for Judicial software company.
- company. Maintained stored procedures and triggers in Oracle 11 G.
- Responsible for customer support of IMDSPlus Court application.
Confidential
Title: Consultant / Sr. PowerBuilder Developer
- Responsible for PowerBuilder 12.1 and Sybase ASE development.
- Maintenance of Material Requests for Confidential application for energy company. They claim it is the 2nd largest PB application in the country .
Confidential
Title: Consultant / PowerBuilder
- Responsible for PowerBuilder 9 and 11.5 and Oracle 11g development.
- Developed korn shell scripts using Oracle 11g PL/SQL.
Confidential
Title: Consultant / PowerBuilder
- Responsible for PowerBuilder 9 programming of Car Auction application.
- Developed stored procedures and SQL scripts in MS SQL Server 2008.
- Source control was ClearCase.
Confidential
Title: Developer / PowerBuilder
- Responsible for coding of manufacturing application in PowerBuilder 9, 10, 11 and Sybase SQL Anywhere.
- Worked with Hagen software and Progress RDB for inventory.
- Custom changes to Payroll, Accounts Receivable, Inventory Control.
- Maintained the 2 inventory applications that used the PFC in PowerBuilder 9.
- Perl 5.8 scripting. - Wrote a script to convert a PowerBuilder .pbd file from version11 to version9.
- Responsible for in-house application production support.
Confidential
Title: Programmer
- Responsible for 'C' programming of Subrogation module for Student Loans.
- Experienced with ANSI 'C', Informix, Perl, A.I.X.
- Responsible for 24x7 on-call production support.
Confidential
Title: Developer / PowerBuilder
- Responsible for the PowerBuilder 9 design, coding, and support of IMES manufacturing system at 3M.
- Architecture includes MS SQL Server 2000, Lotus Notes, WSDL, XML, and Web services calling Web Services through PowerBuilder .
Confidential
Title: Developer / PowerBuilder
- Created PowerBuilder objects and code using PowerBuilder 10 for Medicare/Medicaid processing, including Security tables.
- Developed Java classes using Eclipse Maintained Java code to create and parse XML code from text input.
Confidential
Title: Programmer / Developer
- Created database and client design for Sybase database using Word and Visio. Developed time analysis in MS Project.
- Created stored procedures with T/SQL and triggers using Desktop DBA.
- Used Sybase Showplan to optimize performance of SQL.
- Used Sybase Trace to track problems in stored procedures.
- Coordinated with Lead Programmer for regression testing, using Remedy to track issues and issue resolutions.
Confidential
Title: Developer / PowerBuilder
- Designed and developed Perl scripts using ODBC to perform data migration from MS SQL Server SMS tables to Sybase Database.
- Used Sybase bcp for data imports to Sybase tables.
- Developed Windows NT DLLs using MS Visual C/C Version 6.0 to create SMS MIF files from Sybase database.
- Performed routine database maintenance of Sybase database using Enterprise Manager.
Confidential
Title: PowerBuilder Analyst
- Involved in gathering business requirements, design, development and implementation for the entire CI system.
- Designed the logical and physical model of the CI system using Lotus Notes.
- Tuned SQL scripts and statements using optimizer hints and indexes.
- Analyzed the query path of Oracle queries using Explain plan for their optimum performance.
- Developed Unit Test Scripts using program designed by Andersen Consulting and manually performed scripts and documented results. Developed GUI interface using PowerBuilder 5.0.
- Responsible for 24x7 on-call production support.
Confidential
Title: PowerBuilder Programmer
- Wrote SQL scripts to populate tables.
- Installed and tested Citrix Windows Terminal Server.
- Installed and tested windows applications using Citrix.
- Developed data conversion scripts in TLink and PowerBuilder 6.5.
- Wrote Use Cases using Visio.
- Coordinated testing of changes for new releases with head of QA department.
- Designed and developed the parent class windows and user objects for the Admission and Census Module using the PFC's extension layer.
- Provided specs to programming team in California for changes to Admission and Census and reviewed their work.
- Created stored procedures in SQL Server to centralize code, to enforce business rules, and to increase maintainability.
Confidential
Title: Senior Programmer/Analyst
- Designed, developed and implemented the On-line Reporting System.
- Tuned SQL queries for their optimal performance to enable faster data retrieval.
- Wrote Perl scripts to analyze the results of test SQL queries against the DB2 database.
- Maintained OEC data services written in AIX C.
- Wrote 'C' function for converting column and table names in SQL for new data warehouse names.
- Provided project management in MS Project.
- Developed installation program using InstallShield.
- Involved in writing test scripts, system testing and regression testing of On-Line Reporting project.
- Designed, developed, and implemented the intranet security application for creating and maintaining users using Perl, HTML, and CGI.
- Mentored Junior programmer by giving him program specs and reviewing his work.
- Installed and validated Tuxedo software on HP-UX server. Responsible for maintenance and upgrades of Tuxedo.
- Supported programmers and clients with Tuxedo problems.
- Developed automated file transfer batch programs using Perl and Autosys.
- Responsible for 24x7 on-call production support.
Confidential
Title: Consultant
- Designed, and developed InfoMaker user query system using PB InfoMaker and Sybase SQL Server10.
- Involved in data migration of DB2 mainframe data to Sybase Database, including denormalization, database design and creation of tables.
- Involved in creation of canned queries for PB Infomaker.
Confidential
Title: Consultant
- Involved in the creation of Requirements document, ERD diagrams, main process flow and user documentation.
- Created project management system using Keane methodology.
- Involved in creation and implementation of stored procedures in Sybase System 10 database.
- Involved in data migration from Gupta SQLBase to Sybase System 10 database.
- Responsible for creation of PowerBuilder application using PB 3.0 including framework, menus, windows, and datawindow objects.
- Involved in testing of application and user acceptance.
- Wrote HP 'C' program for communication with remote transaction manager using Unix socket programming.
- Wrote HP 'C' program for importing text file into Sybase database using DB-LIB calls.
Confidential
Title: Consultant
- Involved in the creation of Clinic Transfer application in PowerBuilder 3 and WATCOM database.
Confidential
Title: Programmer/Analyst
- Developed prototypes, ERDs, and process specifications for Credit applications.
- Worked with Credit Manager to define business requirements.
- Developed Word basic macros for merging of business data with forms in MS Word.
- Developed PB 3.0 code for printing dunning letters, statements, and contract cancellations.
- Created and maintained Gupta SQLBase tables and indexes.
- Developed 'C' libraries and applications for embedding printer codes into text documents for printing on high-speed laser printers.
Confidential
Title: Programmer/Analyst
- Developed COBOL applications for the PC environment for premium estimation.