PROFESSIONAL SUMMARY

• 24 years in Information Technology 4 years teaching college computer and math courses
• Strengths include
• MS-SQL Server 2005/2008 database systems stored procedures and triggers Transact/SQL
• 17 yrs experience using PowerBuilder 3.0a thru 12.5 for development and maintenance of
• mission critical applications. These applications included OLE Web Services auto faxing and emailing functionality using complex composite and/or nested datawindows
• Oracle 9i 10g SQL tuning SQL Loader application DBA
• 6 yrs Oracle database system Stored Procedures and Triggers
• Ad hoc reporting via SQL and PL/SQL Toad SQLDeveloper
• 8 yrs Informix 7 9 10 Stored Procedures and Triggers
• Microsoft Visio
• Excellent written and verbal communications
• Gathering and analyzing requirements MS-SQL Server/Informix/Oracle database systems. Provided
• application design development maintenance implementation and database design and systems
• analysis
• OpenLink/Solarc Right Angle
• Ability to apply logic analysis common sense and critical thinking to short and long range projects
• Last 19 years concentrated in client server application development using PowerBuilder/Visual Basic
• Held project lead roles software mentor server designer source control librarian
• Developed applications for Purchasing Enterprise Finance Transportation Order Processing
• Manufacturing Payroll Human Resources Sales Budgeting and Marketing Unemployment Insurance Petroleum Refining ERP
• Proven experience working with end user community to ensure common understanding of requirements

TECHNICAL SUMMARY

PROFESSIONAL EXPERIENCE

confidential

• Support existing RightAngle application
• MS SQLServer database system
• ORACLE database system
• PowerBuilder 9.0 code base
• Create and modify stored procedures packages and triggers for database access
• Validate code changes
• Tune SQL statements and PL/SQL code
• Plan develop and unit test Power Builder code
• Crystal Reports exposure

Environment Windows data servers Windows 7 OS MS SQLServer RDBMS SQL Oracle PL/SQL

confidential

• Create test plans for project modifications
• Sybase DBMS
• PowerBuilder code base
• Create and modify stored procedures and triggers for database access
• Validate code changes
• Plan develop and unit test Power Builder code

Environment Windows data servers WinXP Sybase RDBMS SQL

confidential

• Analyzed changes to online prescription supply application for adherence to Federal guidelines
• Oracle 11i DBMS
• PL/SQL code base
• Create and modify stored procedures and triggers for database access
• Validate code changes
• Plan develop and unit test Oracle PL/SQL code

Environment Windows data servers WinXP Oracle 11.2g RDBMS SQL

confidential

• Engineered enhancements and fixes for comprehensive nationally distributed election and voter registration application. Oracle 11.2gi database PL/SQL stored procedures and triggers.
• PowerBuilder 12.5.2 interface.
• Create and modify stored procedures and triggers for database access
• Design visual and non-visual objects and code logic to create reports and edit interfaces.
• Plan develop and unit test PowerBuilder PB 12.5.2 code
• Datawindows used to facilitate printing ballots notices and voter ID cards

Created batch processes for reports and ad hoc data extraction

Environment Sun UNIX database servers WinXP PowerBuilder 12.5.2 development tool 11.2g RDBMS SQL PowerBuilder PFC TCP/IP VSS and SVN source control.

07/12 02/13 confidential

• Create new and modify modules and objects to enhance EarthLink order processing application
• Performed as application level DBA to create and maintain database tables and views
• Debugged and test scripts triggers and PowerBuilder code
• Create SQL scripts to modify database tables as necessary
• Audit and revise WebConfig files as necessary
• Analyze database table schemas to implement efficient and effective solutions for order processing

Environment Windows XP Pro PowerBuilder 11.5.1 WinSQL/AnySQL Maestro database development tools DB2 DBMS SQL

confidential

Sr. Programmer

• Design code and implement modifications to database insurance administraion application.
• Create and modify stored procedures and triggers for database access
• Create SQL scripts to modify database tables and views
• Debug and test scripts triggers and PL/SQL stored procedures.
• Analyze and audit previous stored procedures for accuracy and efficiency

Environment UNIX Database Servers Windows XP Pro SQL Developer database development tool Oracle 10g DBMS SQL PVCS source control.

confidential

Sr. Programmer

• Design code and implement modifications to survey management application.
• Create and modify stored procedures and triggers for database access
• Create SQL scripts to modify database tables and views
• Datawindows used to facilitate information screen displays and reports.

Environment UNIX Database Servers Windows 7 PowerBuilder 12 development tool Sybase SQL Anywhere DBMS SQL TFS source control.

confidential

Sr. Programmer/Analyst

• Analyze design and implement modifications to Order Entry application for recycling business.
• Comprehensive order entry invoice and payable system
• Create and modify stored procedures and triggers for database access
• Design tables and views for new application functionality
• Datawindows used to facilitate information screen displays and reports.

Environment UNIX Database Servers Windows 7 PowerBuilder 10.2 development tool Oracle DBMS SQL TCP/IP VSS source control RightFax.

confidential

Sr. Programmer/Analyst

• Analyze design and create new functionality for medical office administration software package.
• Medical provider health administration application
• Create and modify stored procedures and triggers for database access
• Design tables and views for new application functionality
• Datawindows used to facilitate information screen displays and reports.

Environment UNIX Database Servers WindowsXP PowerBuilder 12.1 development tool Sybase SQL Anywhere RDBS SQL TCP/IP VSS source control.

confidential

Sr. Programmer/Analyst

• Code new functionality and maintenance for RightAngle a large commodity tracking application and several auxiliary programs.
• Create and modify MS SQLServer stored procedures and triggers for database access
• Developed code to create complex functionality inserted into existing code base
• Datawindows used to facilitate information screen displays and reports.

Environment UNIX Database Servers RightAngle WindowsXP PowerBuilder 9.2 development tool Sybase and MS SQLServer RDBMS SQL TCP/IP VSS source control CSS XML.

confidential

Programmer/Analyst

• Analyzed designed and developed enhancements and fixes for Child Welfare and Adoption applications. DB2 database stored procedures and triggers. PowerBuilder 11.2 development environment. Design visual and non-visual objects and code logic to create reports and edit interfaces.
• Create and modify stored procedures and triggers for database access
• Developed database code to create complex functionality inserted into existing code base
• Modified tree view to accommodate new functionality
• Datawindows used to facilitate information screen displays and reports.

Environment MS Windows Database Servers Windows2000 PowerBuilder 11.2 development tool DB2 RDBMS SQL TCP/IP PVCS source control.

confidential

Programmer/Analyst

• Analyzed designed and developed enhancements and fixes for Municipal Court and Law Enforcement applications. MS SQL Server 2005 and Oracle 9.0.1 database stored procedures and triggers. PowerBuilder 9.0.1 and 11.5 development environment. Design visual and non-visual objects and code logic to create reports and edit interfaces.
• Create and modify MS SQL Server 2005 stored procedures and triggers for database access
• Removed hard coded addressing from application and modified for database driven data
• SQL Developer MS SQL Server to code complex batch processed ad hoc reports for user community
• Datawindows used to facilitate information screen displays.

Environment IBM mainframe and MS Windows Database Servers WinXP VISTA PowerBuilder 9.0.1 and 11.5 development tool MS SQL Server 2005 RDBMS SQL PowerBuilder PFC TCP/IP VSS source control.

confidential

Sr. Programmer/Analyst

• Analyzed designed and developed enhancements and fixes for comprehensive state tax processing application. Oracle 8.4 10.1g database PL/SQL stored procedures and triggers. PowerBuilder 10.5 development environment. Design visual and non-visual objects and code logic to create reports and edit interfaces.
• Create and modify stored procedures and triggers for database access
• Modifed Virginia state tax application to allow external allocation of excess tax return funds for federal IRS liens.
• SQLDeveloper SQL to code complex ad hoc reports for user community
• Datawindows used to facilitate information screen displays
• Used MS Visio to flow chart added functionality to determine Federal tax liens against state returns

Environment Sun UNIX database servers WinXP PowerBuilder 10.5 development tool Oracle 9i 10g RDBMS SQL PowerBuilder PFC TCP/IP PVCS source control.

confidential

Sr. Programmer/Analyst

• Modify and enhance Oracle stored procedures program code in Oracle 9.2i database environment.
• Create and modify scripts stored procedures and triggers
• Used SQL Loader to populate static data tables for mission critical application
• Test database program code
• Troubleshoot application performance issues
• Tune database script and stored procedure/trigger code to improve application performance
• Convert IDMS files to Oracle RDMS tables. SQL Loader used for data transfer.
• Used MS Visio to document and flow chart the creation of tables and data transfer from IDMS
• files to Oracle tables.

Environment Solaris Database servers WinXP Vista Oracle 9i RDMS SQL PL/SQL TCP/IP TOAD.

confidential

Software Engineer

• Developed Oracle Forms and Reports in an Oracle 10g database environment.
• Design visual and non-visual objects and code logic to create reports and edit interfaces.
• Create and modify scripts stored procedures and triggers for database access
• Debug Oracle PL/SQL program code
• Tested modified and developed forms and report

Environment UNIX Database servers WinXP Oracle 10g RDMS SQL PL/SQL Oracle Developer Forms and Reports TCP/IP TOAD.

confidential

Sr. Programmer/Analyst

• Engineered enhancements and fixes for comprehensive nationally distributed
• election and voter registration application. Oracle 10g database PL/SQL stored procedures and triggers.
• PowerBuilder 9.0.2 interface.
• Create and modify stored procedures and triggers for database access
• Modified election software from single address per department to allow unlimited number of addresses
• Modified election id card datawindows to allow additional required information
• Added functionality to allow newspaper public notices to be created and disseminated through application
• Design visual and non-visual objects and code logic to create reports and edit interfaces.
• Plan develop and unit test PowerBuilder PB 9.0 code
• Datawindows used to facilitate printing ballots notices and voter ID cards
• Tasked with migration of application to PowerBuilder 11.1

Environment Sun UNIX database servers WinXP PowerBuilder 9.0 development tool Oracle 9i 10g RDBMS SQL PowerBuilder PFC TCP/IP VSS source control.

confidential

Development Engineer

• Work on team to develop implement and maintain an application Pinnacle to administer unemployment claims for company clients. Provide enhanced functionality to system. Coded using C .NET to create Web Services consumed by Pinnacle PowerBuilder 8.04 10.2 11.2 .
• Coded SQL statements and stored procedures to query databases.
• Consulted with DBA to tune stored procedures and triggers.
• Design PowerBuilder visual/non-visual objects and code for reports and edit interfaces.
• Create C .NET web services for data access.
• Datawindow used to auto-fax and auto-email information request sheets from application
• Assigned code librarian duties Responsible for source code control requests application builds moving PowerBuilder code through test quality assurance acceptance and to production.
• Assigned to team tasked with design and creation an internal Windows application portal
• Performed maintenance on ancillary Visual Basic 6 application.
• Design create test and implement servers for auxiliary application tasks ex. - send fax and email from claims processing application.
• Lead analyst on project to enhance PowerBuilder application to receive host-to-host claims perform ETL and allow integration into the primary application processing sequence
• Analyze design build test and implement a host-to-host file transfer for claims filed for clients in Massachusetts. Designed database tables Coded stored procedures to parse host to host file in batch processing mode into database tables coded triggers to correctly distribute incoming file data to the database and developed interface screens to display data as needed.
• Used MS Visio to diagram added tables for data model for host to host data load and processing

Environment Sun UNIX database servers WinNT WinXP Win2003 Terminal Server OS PowerBuilder 8.0.1 10.2.1 11.2 development tool Informix 9.x RDBMS SQL PowerBuilder PFC Documentum imaging software RightFax fax software TCP/IP PVCS and TFS source control.

confidential

/02 - 03/03 Premcor Refini01ng Company St. Louis MO

Sr. Programmer/Analyst

• Assigned to client development team to enhance purchased ERP package Solarc Right Angle RA . Responsible for creating custom reports and GUI interfaces for custom data processing within RA business logic. Report functionality must use RA interface for custom additions.
• Coded MS SQLServer statements and stored procedures to query database for enhancement of purchased energy commodity software package RA .
• Designed PowerBuilder visual and non-visual objects and code logic to create reports and edit interfaces.
• Assigned code librarian duties Responsible for RA base code VSS application builds moving PowerBuilder code through test acceptance and production.
• Provide enhanced functionality to system.
• Created objects and MS SQLServer stored procedures to create Adobe .PDF files for archiving reports.
• Datawindow used to print custom reports

Environment Windows2000 database servers WinNT Win2000 OS PowerBuilder 7.0 development tool MS SQLServer RDBMS 7.x 2000 AdobeWriter TCP/IP PlanView project planning SourceSafe source control Solarc RightAngle.

confidential

confidential. Programmer/Analyst

• Work on team to develop implement and maintain an application Pinnacle to administer unemployment claims for company clients. Application made process as paperless as possible provided users with help wizards image data capture of mailed claims automated fax and email and provided notification of upcoming task deadlines.
• Redesigned code logic to use non-visual objects for bulk of processing code.
• Participated on project to create custom data handling responses and other correspondence for client.
• Provide maintenance and enhanced functionality to system.
• Wrote SQL statements and stored procedures Informix / MS SQLServer to query databases.

Environment NCR Sun UNIX database servers Win95 WinNT Win2000 OS PowerBuilder 6.5 development tool Informix 7.x RDBMS SQL PowerBuilder PFC Documentum imaging software Faximum email/fax software TCP/IP.

Confidential

Senior Consultant

• Assigned to United States Postal Information Business Systems Service Center. Responsibilities included various modules of a Facilities Management System FMSWIN .
• Developed additional functionality lease payment tracking construction management tracking.
• Mentor for team members on technical issues dealing with the application and PowerBuilder.
• Used MS Word as OLE server to print legal documents associated with facility leases.
• Performed maintenance of current system.
• Wrote SQL statements Oracle to query the database.
• Datawindow used to print lease documents and contracts
• Performed data librarian functions

Environment IBM MVS database servers Win95 WinNT OS PowerBuilder 5.x development tool Oracle 7.3 MVS . RDBMS Oracle stored procedures.

Programmer/Analyst

• Assigned to inhouse project to develop a warehouse management system. Responsibilities were to evaluate VB 6.0 Data Environment object for feasibility of use in development of system.
• Developed visual objects windows using Visual Basic IDE.
• Created and implemented testing scenarios to evaluate feasibility.
• Provided results and recommendations to system design team.
• Wrote SQL statements MS SQLServer to query the database.
• Planned developed and tested MS SQLServer stored procedures
• Debugged MS SQLServer stored procedures

Environment WindowsNT database servers Win95 WinNT OS Visual Basic 6.0 development tool MS SQLServer RDBMS third party GUI controls Visual SourceSafe.