Professional Summary

Senior level developer with several years experience in data processing and object oriented software design and development. Extensive experience in Graphical User Interface design and N-tier architecture with a strong background in service based architecture, Client/Server application design and development, relational database technology, SQL scripting, data modeling, main frame On-Line and batch programming and technical documentation composition. Knowledge and light experience in ASP and C .NET utilizing MS Visual Studio.

Technical Skills

• Software/Languages: PowerBuilder V2-V12.5, PFC Class Library, MS SQL Server Query Analyzer 2000,
• MS SQL Server Enterprise Manager 2000, MS SQL Server Management Studio 2008, DTS, ASP.NET and C .NET using MS Visual Studio 2005 with .NET 2.0 Framework, MS Visual Studio 2010 with .NET 4.0 Framework, Merrill Lynch publish-and-subscribe framework, Borland StarTeam 2008 R-2, HP Quality Center, VB Macros, PVCS, MS Visual Source Safe, DBArtisan, PL/SQL, T-SQL, PhotoShop, MS Office, PowerPoint, RoboHelp, ERWIN, TCP/IP, Java 2, CICS, BMS, IMS/DC, Telon Case Tool, IEF Case Tool, Ramis II,
• VS COBOL II, Basic, ODBC, SPUFI, QMF, VSAM, QSAM, Intertest, FileAid, EasyTrieve, SYNCSort, TSO, PANVALET, OS/JCL.
• Databases: MS SQL Server 2000-2008, Sybase System 11-12, Sybase Adaptive Server, Sybase SQL Anywhere, Informix, Oracle 9, IBM DB2, MS Access, Watcom SQL, IMS/DL1.

Professional Experience

Confidential

PowerBuilder Developer/SQL Programmer

• Work with Borland StarTeam to maintain version control and HP Quality Center to track defects.
• Enhance web communications with faster less error prone method redesigns.
• General maintenance of SQL scripts in stored procedures and triggers where troubleshooting was required.
• Addressed existing problems involving application performance, with advanced coding methods resulting in benchmarked improvements in application response and usability.
• Added business rules to corporate business rules service layer components and modified existing rules as per changes in corporate policy and international law.
• Maintain corporate enterprise applications created in PowerBuilder V 11.5 and 12.5 with Oracle 9 DBMS, which communicates with corporate web services utilizing the Merrill Lynch publish-and-subscribe framework.

Confidential

PowerBuilder Developer/SQL Programmer

• Utilized PowerBuilder V 10.5.2 and Sybase SQL Anywhere Studio 9.0.2 to upgrade ATS staffing application.
• Wrote 46 triggers to maintain database synchronization to allow extended data flexibility as requested.
• Wrote SQL utilities to create new tables and update existing tables, which backed up the existing database and data using the Sybase database backup utility and updated the tables while maintaining existing data.
• Coded SQL utility to create these triggers and to run the table and database structure updates.
• Wrote InstallShield scripts in C to implement the database changes which is invoked during installation.
• Created walk-through help system for implementation in RoboHelp and deployed new version to all clients.

Confidential

PowerBuilder Developer/SQL Programmer

• Responsible for maintaining client web page content on a daily bases including downloadable Power Point presentations, slide images, pictures and video clips for new drug product training.
• Updated client related ASP.NET web pages to implement new code and code changes as needed using
• MS Visual Studio 2005 and 2010 with C 2.0 and 4.0.
• Supported all of the corporate desktop applications coded in PowerBuilder 6.5, 7, 8, 9 10.5.
• Produced new PowerBuilder and SQL applications from high-level requirement specifications provided by company business analysts and user base requests.
• Coded and maintained numerous database stored procedures, functions and triggers in SQL Server 2005.
• Coded DTS packages triggered from stored procedures to import data from Excel files into SQL Server databases, which were then used for reporting and updating of multiple down-stream databases.
• Produced complex stored procedure data window reports with dynamic run parameter wizards.
• Wrote utilities to extract and migrate client data from text and DBF files to production databases.
• Created new database tables via data modeling and physical table creation to support new application functionality as needed, as well as inserting initial test data.
• Supported end users with latest application installations, training and general help documentation.
• Compiled and deployed application executable files and distributed to production servers for automated download.
• Developed back-end common lib service modules to detect new application versions upon application startup,
• which automatically downloaded new application versions to the end user's workstation PC.

Confidential

Lead PowerBuilder Developer/Applications Architect

• Designed and coded service-based framework architecture for a major upgrade of client's Contract Development application. This application was a contract document management system that included contract creation, workflow routing, document search, security and role verification and contract printing and distribution.
• Developed several unique methodologies to overcome difficult issues involved with the enormous scope of application enhancements and implemented these methods in all required components.
• Added interface services to allow other applications to access the system, including client's Web portal interface and Web based IBM Documentum application DCTM , via Terminal Server and dynamic Web browser invocation.
• Coded special service objects to convert raw unformatted database data into formatted MS Word contract documents. This was accomplished completely within PowerBuilder script by converting the data to HTML using string methods, then into Word documents using VB macros created dynamically within the application code and finally executing the VB macros using object linking and embedding.
• Coded PowerBuilder service objects to connect to and communicate with IBM Documentum application using object linking and embedding,
• Created several Oracle 9 database stored procedures to replace repeated embedded SQL calls throughout the application code. Accomplished this task using generic syntax to maintain compatibility with Sybase Adaptive Server to enable data replication.
• Assisted other developers with difficult coding design issues and advanced methodologies.
• Remained on project after delivery to support system testing changes and corrections.

Confidential

Senior Consultant

• Created PowerBuilder utility applications and SQL scripts for migrating data from many different sources database and file formats , which were then integrated into the client's central database.
• Demonstrated communication skills interacting with multiple police departments, to develop and finalize specifications for a custom Police Records Management System.
• Composed application proposal documents for authorization by local, county, state and federal agencies, addressing multiple compliance issues.
• The subject application utilized Oracle, Sybase SQL Anywhere, or MS Access database engines to facilitate existing database software.
• Interface objects were developed using Tab Folders, Tree Structures, Composite reports, complex data windows and non-visual service objects.
• Database access modules were developed using PowerBuilder V7, V8 and Visual Basic V6.
• Developed and deployment installation program using InstallShield shell.
• Coded 'setup' scripts in the InstallShield 'C' language RUL code subset.
• Created master installation CDs with a front-end program coded in PowerBuilder, which automated the entire setup process including database update installation options.

Confidential

Senior Consultant

• Marketed the application successfully under own business name.
• Completed entire project from concept to deployment and marketing with no outside assistance.
• Implementation of the application and database access modules were created with PowerBuilder V9 and Sybase Adaptive Server 9.
• Designed, developed, copyrighted and licensed an applicant tracking system for the job placement industry. This application facilitated increased revenue for application users, as well as decreased manual intervention to file, retrieve and fulfill job requirements.

Confidential

Senior PowerBuilder Developer/Systems Architect/Team Leader/Team Mentor

• This assignment began one month behind schedule, but was completed and implemented one month early resulting in savings of just over 7500 chargeable man hours.
• Demonstrated leadership ability by guiding a team of seven developers to completion of project.
• Created final end-user executable production deployment files.
• Composed technical documentation and application on-line help system using RoboHelp X6.
• Coded database stored procedures and triggers for Sybase 11, Oracle 7 and Informix.
• Analyzed, designed and implemented dynamic Insurance Policy Contract data collection system using PowerBuilder 6.5 with PowerBuilder Foundation Class library.
• Interacted with all involved departments to ensure full legal compliance.
• Development of application architecture was accomplished using PowerBuilder 6.5 and PowerBuilder Foundation Class Library PFC . All database stored procedures and triggers were coded in Sybase V11 and Oracle V7.
• This improved the underwriting department's overall response time by 50 .
• The application captured and translated insurance contract information generated by on-line applications and parsed and reformatted the data for use in downstream client databases.
• Analyzed, designed and implemented a data-driven download and translation system.

Confidential

• Joined development team during the final stage of a project that was several months behind.
• Coded corrections for all new and outstanding problems reported by the testing team in time to get the application completed before the re-scheduled deadline.
• Publicly received commendations from the client's IT management and vice president for exemplary accomplishments, high productivity, thoroughness and quality of work.

Confidential

• Demonstrated solid technical leadership with a development team of nine members by taking drastic measures to save an already failed project.
• Corrected all reported problems using un-orthodox emergency methods as a last resort, cutting the normal development time to a fraction of the time originally needed to complete the task.
• Created and deployed application executable files for final delivery ahead of schedule, resulting in the prevention of material breach of contract proceedings against the vendor and resulting in the vendor retaining the client account.