Professional Summary

Senior level developer with several years experience in data processing and object oriented software design and development. 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. Experience composing formal technical documentation and help systems. Knowledge and light experience in ASP and C .NET utilizing MS Visual Studio.

Technical Skills

Software/Languages PowerBuilder vers 2 to 12.5 PFC Merrill Lynch Publish- -Subscribe framework vers 4 Rational Team Concert RTC vers 4.0.5 HP Quality Center vers 11 ProDiff vers 1.0.12 MS SQL Server Query Analyzer 2000 MS SQL Server Enterprise Manager 2000 MS SQL Server Management Studio 2008 DTS VB Macros PVCS MS Visual Source Safe DBArtisan PL/SQL T-SQL PhotoShop MS Office PowerPoint RoboHelp ASP.NET and C .NET using MS Visual Studio 2005 with .NET 2.0 Framework MS Visual Studio 2010 with .NET 4.0 Framework 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

• Maintain Call Center applications created in PowerBuilder 12.5 with Oracle 9 DBMS.
• Code interface scripts to communicate with other front-end applications utilizing Merrill Lynch publish-and-subscribe framework MLE4 .
• Generate PowerBuilder web proxy components using in-house ProxyGen tool to enable interfacing with corporate customer and associate facing web services.
• Code web interface services in PowerBuilder front-end application to access BOA web services.
• Maintain version control using Rational Team Concert RTC and track defects using HP Quality Center QC .
• Utilize ProDiff to track and maintain source code change accuracy to confirm and ensure correct versioning and escalation toward user acceptance and production environments.
• Added business rules to application service layer components and modified existing rules per changes in corporate policy and international law.
• Addressed existing issues involving application performance to implement advanced coding methods resulting in benchmarked improvements in application response memory usage and general usability.
• General maintenance of SQL scripts in stored procedures and triggers where changes were required.
• Enhance existing web communications proxy components with faster less error prone method redesigns.
• Compose high and low level process and coding documentation and general knowledge transfer documents.

Confidential

• Created installation walk-through help system in RoboHelp and deployed new version to all clients.
• Created InstallShield scripts in C RUL subset to implement the database changes which is automatically invoked during application installation.
• Updated all data-aware components to utilize SQL generic to both database management systems in order to create seamless DBMS switching capability.
• Added new services to enable the application to run on Sybase as well as MS SQL Server which can be selected at runtime.
• Coded SQL utilities to implement table and database structure updates as well as utilities to back up the existing database files and data.
• Created triggers functions and stored procedures to maintain database synchronization to allow extended data flexibility.
• Utilized PowerBuilder V 10.5.2 with Sybase SQL Studio and MS SQL Server to create a new release of an existing ATS staffing application to run on two separate database management systems.
• PowerBuilder Developer/SQL Programmer

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 master installation setup program coded in PowerBuilder which automated the entire setup process including database update installation options and InstallShield invocation.
• Coded setup scripts in the InstallShield C language RUL code subset.
• Developed a deployment installation program using InstallShield shell.
• Database access modules were developed using PowerBuilder V7 V8 and Visual Basic V6.
• Interface objects were developed using Tab Folders Tree Structures Composite reports complex data windows and non-visual service objects.
• The subject application utilized Oracle Sybase SQL Anywhere or MS Access database engines to facilitate existing database software.
• Composed application proposal documents for authorization by local county state and federal agencies addressing multiple compliance issues.
• Demonstrated communication skills interacting with multiple police departments to develop and finalize specifications for a custom Police Records Management System.
• 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.

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

Positions Include

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.