PROFESSIONAL SUMMARY

Security Clearance: NACI

• 24 years in Information Technology, 4 years teaching college computer and math courses
• OpenLink/Solarc Right Angle

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
• 8 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, database
• design and systems analysis
• Ability to apply logic, analysis, common sense, and critical thinking, to short and long range
• projects
• Last 23 years concentrated in client server application development using PowerBuilder, PL/SQL,
• Transact/SQL
• 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, Health Insurance
• Proven experience working with end user community to ensure common understanding of
• requirements

TECHNICAL SUMMARY

• HARDWARE
• IBM PC Compatibles Intel , IBM Mainframe, UNISYS Mainframe
• OPERATING SYSTEMS
• Windows XP, Windows 2000, Windows 2003 Server, DOS/VSE, UNISYS 1100/2200, Unix, MS DOS/PC DOS
• LANGUAGES
• PowerBuilder 3 through 12.0, C .NET, Visual Basic 4.0/6.0, SQL, COBOL, Basic, JAVA training
• DATABASES FILE STRUCTURES
• MS SQL Server 6.5 - 2005, Oracle 9i/10g, Access, Informix 7.x - 9.x, DB2, Sybase, VSAM
• SOFTWARE TOOLS
• Transact/SQL, OpenLink RightAngle, Oracle PL/SQL, TOAD 9.1, PB PFC, Oracle Forms Reports, MS Access 2.0/7.0, SQL Anywhere 12, Windows API, TCP/IP, OLE, MS Office, Visual SourceSafe, PVCS and TFS source control, Microsoft Visio, PL/SQL Developer
• MISCELLANEOUS
• MS SQLServer, Oracle, Informix, DB2, Sybase stored procedures, Hyperion, Watcom JAVA training, .Net Framework training, C training, Auto task batch processing, WEB Services
• FUNCTIONS
• Sr. Programmer/Analyst, Technical lead, Data Librarian, Development Engineer

PROFESSIONAL EXPERIENCE

Confidential

Programmer/Analyst

• Support existing comprehensive Project Estimation applications
• ORACLE database system
• PowerBuilder 11.5/12.6 code base
• Create and modify stored procedures, packages, and triggers for database access
• Validate code changes
• Create, Update, Modify Tune PL/SQL code
• Plan, develop and unit test Power Builder code

Environment: Citrix data servers, Windows 7 OS, SQL, Oracle, PL/SQL

Confidential

Programmer/Analyst

• Support existing OpenLink RightAngle V3 application
• MS SQLServer database system
• ORACLE database system interface RightAngle data
• PowerBuilder 5.0/9.0 code base
• Create and modify stored procedures, packages, and triggers for database access
• Validate code changes
• Tune T-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

Programmer/Analyst

• 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

Quality Assurance Analyst

• Analyzed changes to online prescription supply application 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

Programmer/Analyst

• 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

Programmer/Analyst

• 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 tested 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 administration
• application.
• Create, tune 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 OpenLink RightAngle S9, S10 , a
• 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
• Created new invoices with style sheets and XML.
• 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 complex database code to insert 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.
• Created, modified MS SQL Server stored procedures and triggers for database access
• Removed hard coded addressing from application and modified to be database driven
• Used SQL Developer 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 or 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
• Modified 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 reports

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 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 public notices to be created and disseminated through application
• Design visual/non-visual objects, code enhancements 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 C .NET 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. Education: Completed C .NET, Framework .NET training, Informix SQL training

Confidential

Sr. Programmer/Analyst

• Assigned to client development team to enhance purchased ERP package, OpenLink
• RightAngle RAIV . Responsible for creating custom reports and Oracle
• interfaces. Coded 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 manager,
• application builds, moving PowerBuilder code through test, acceptance, and
• production.
• Provide enhanced functionality to system.
• Created custom objects and MS SQLServer stored procedures to create .PDF files
• for Dissiminating and archiving reports.
• PB 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, OpenLink RightAngle. Education: Completed JAVA training

Confidential

Sr. 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 Confidential 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 Confidential

• 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.