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

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.

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.