SQL Developer,resume profile

TECHNICAL SKILLS

Programming Languages

PowerBuilder 4.0 12.5.2 w/ PFC and custom frameworks

Visual C , C .Net, Pro C/C ,

VB.Net, Visual BASIC, BASIC

FORTRAN IV/77 , Pascal, Assembler Languages

OCX/ActiveX, OLE, DDE Integration

Relational Databases and Utilities

O. S. and Utilities

Source Control and Versioning

Remote Control

Communication and Control

BizTalk and AppWorx,
Network Communications Programming, Berkley Sockets, TCP/IP
Serial Data Communications Programming, RS-232, RS-485
Real-Time Process Control, IEEE-488, D/A, A/D, FM, Data Integration, Counter/Timer, Thermocouple,
Gas Analyzers, Dynamometers, Transducers
Hardware and Software troubleshooting

PROFESSIONAL EXPERIENCE

Confidential

PowerBuilder 12.1, Oracle 10g, Windows 7, TFS Source Control, Oracle VM, IBM Rational

Leader of team to fix bugs and modify the Aria Cancer Patient Treatment EHR applications at the UPMC Cancer Center in Pittsburgh, PA.
Interfaced with client and customer management.
Setup developer workstations with PowerBuilder, Oracle VM and Database, VPN and RDP.
Programmed PowerBuilder defect remediation and documentation.

Confidential

Oracle 11g, SQL Developer, PL/SQL, PuTTY, Unix Scripts, Visual Basic for Apps

Application Architect and Sr. PowerBuilder Developer providing direction and standards for upgrading the on-line applications for the State of Michigan Department of Treasury.
Writing and maintaining PL/SQL stored procedures.
Re-Architected and programmed framework objects achieving enhanced execution, stability, reliability, reuse and maintainability.
Created an independent Logon object with encryption and security features with the ability to be dropped into all of the Collections Department's applications without modification.
Redesigned and programmed a Batch Print system from Word.Basic with DDE to PowerBuilder with Ole Automation supporting multiple concurrent processes to print tens of thousands of various collection letters per day to debtors and their cohorts.
Conducted code reviews of all on-line application development and maintenance with sign-off authority.
Installed and setup Visual Studio Team Foundation Server for source code control. Designed and administered a feature based branching scheme which allows multiple versions of applications to be developed simultaneously.

Confidential

PowerBuilder 12, Visual-C, Pro C, Oracle 10g

Secret clearance

Confidential

BizTalk

Writing PowerBuilder modules for the migration of mainframe based applications.
Writing Sybase ASE stored procedures, triggers and scripts.
Creating Project Charter, Functional Design, System Design and other PMO documents.
Interfacing with customer to design system functions.
Writing new functionality into existing PowerTools framework.
Migration from PowerBuilder to .Net platform.
Resolving Change Requests to the production system and tracking same in Bugzilla.

Confidential

IIS, ASP.Net, Web Services, WSDL, XML, OCX/OLE.

Converting existing PowerBuilder 11 applications to PowerBuilder 12 to deliver and consume Web Services, WCF and WPF.
Creating WSDL and XML, deploying applications to Microsoft IIS.
Converting PFC functions to be compatible with Web Services.
Creating Custom Framework Classes to support Web Service development.
Develop SQL stored procedures utilizing complex joins, grouping and sorting of tables to facilitate the creation of nested reports.
Created a dynamic Admin Utility to facilitate department administration of parameter and message tables.
.Net programming and debugging.

Confidential

Maintain production system for Security Safekeeping.
Rewrote a faxing subsystem delivering 100 times throughput improvement.
Discovered and documented processing bugs in fax hardware system.
Modified production tables to support new reports.
Modified production reports adding new options and columns.
Automated the reconciliation of daily financial transaction discrepancies.
Produced Excel spreadsheets of raw FTP securities transactions.
Integrated OCX components for FAX/Email and data encryption functions.
Oversee and verify the delivery of data in new formats to/from fiduciary banks.
Manage and maintain public/private encryption keys.
Troubleshoot and remediate Biztalk and AppWorx scheduler processes.
Create Oracle 9i/11g stored procedures and triggers to implement business logic.

Confidential

Lead developer on Electronic Receiving System to scan FDA regulated devices returned for repair and dispatch them to the proper repair process queue and initiate the update of SAP inventory status.
Perform analysis and design of Unit and Validation Test Scripts.
Create an API with Camstar Manufacturing Systems turnkey factory MES software.
Interface with Abbott Nutrition's Customer Service application for device R R.
Integrated OCX components for FAX/Email and data encryption.
Produce Excel spreadsheets of Abbott OEM Device History.
Create a standalone Manufacturing Scheduling and Setup system to allocate assembly lines for various devices as required for new production.
Create a standalone utility to produce Lifetime Device History Records in PDF format for single or multiple device serial numbers.
Create Oracle PL/SQL stored procedures to implement business logic.
Participated in the full SDLC design of new software components.
Demonstrate new functionality of software to factory management representatives and participate in the analysis of feedback and design of modifications.