Summary

I am a Senior PowerBuilder-SQL Programmer/Analyst candidate with over 15 years of software development/programming, systems design, maintenance and production support. My background includes full life-cycle design development of client/server business apps using PowerBuilder SQL, maintenance and 24-hr system support for regulated energy commodities trading integrated business applications for several energy Fortune 500 companies, as well as operating as business unit liaison for energy trading companies. Responsibilities have included comprehensive system support for power-trading floors, front end and back end development and comprehensive system support for Sallie Mae's LoanCons financial loan consolidation applications, performance tuning for PowerCerv ERP system, which includes but not limited to business areas of Manufacturing, Distribution, and Financials Automated Integrated Transaction/Replication Server AIS , and for ING's insurance death benefits claims applications. Recent duties include front end and back end development, maintenance, production support operating as systems technical analyst for day-to-day operations for PowerPlant Asset Property Management system.

Technical Experience

PowerBuilder 3.0 12.5 15yrs , PFC. MS SQL Server 4.x-2008 8yrs , Oracle 7.x/8i/9i/10G/11g, PL/SQL, Sybase 10.x/11.x/ASA, Sybase ASE 12.0/12.5/12.53, SQL Anywhere, DB2, Informix, Visual Studio, Visual Web Developer, ClearCase/ClearQuest, Salesforce, ERP, EAM, Remedy, OBIEE Publisher

ASP.NET, VB.NET, CSS, Dreamweaver, Photoshop, C, Transact-SQL, PL/SQL, HTML, XML, JavaScript, VBScript, WinRunner,PVCS SourceSafe, Crystal Reports, Citrix, OLE, DDE, SDK, API, IIS

Professional Experience

PowerBuilder PL/SQL Developer

Confidential

Responsibilities include maintenance support and development for PowerPlant EAM system. Responsible for resolving maintenance task and code development as part of application enhancement/modification, and bug resolution, using PowerBuilder versions 11.2 and Oracle versions 9i/10g/11g. Business areas include but not limited to, Ad-hoc reporting/queries using PL/SQL, Work Orders/Projects, CR, CWIP Charge, Retirement Unit and Property Unit Catalogs, Admin batch interface jobs/tasks, and most recently responsible for rewriting mainframe GL and financial accounting reports, using PL/SQL and Oracle Business Intelligence Publisher.

PowerBuilder PL/SQL Developer

Confidential

• Responsibilities include development for PowerPlant EAM system. Responsible for resolving maintenance task and code development as part of application enhancement/modification, and bug resolution, using PowerBuilder versions 11.2 and Oracle versions 9i/10g/11g. Business areas include but not limited to, Depreciation Studies, Budgeting, ARO, CR, Projects, and most recently part of the development team responsible for the newest Rates Regulatory module.
• Also worked on the Maximo Adapter, creating stored procedures and triggers as part of the third party software integration team.

PowerBuilder Developer

Confidential

Responsibilities include comprehensive production support of EAM system, EMPAC for all licensed client base worldwide responsible for resolving all issues, to include application enhancement/modification, bug resolution, handling client phone calls, etc. Responsibilities also include, though not limited to client and server side development for business critical enterprise asset management system, using PowerBuilder versions 7, 9, 10.5, 11.5, 12.0, 12.5 , and Oracle versions 9i/10g/11g.Duties also include software and hardware recommendations, maintenance, and technical support.

Production Support Specialist

Confidential

Responsibilities include 24/7 comprehensive production support of day-to-day operations for SOX regulated corporate-wide business critical Power Plant Financial Asset Property Management system version 10. System is designed in PowerBuilder v11.5 and running Oracle 10G as back-end, and is integrated with Oracle Financials. Business areas include but not limited to general ledger, allocations, journal entries, book and tax CWIP accounting, month-end closing, charge repository, work order processing, and often responsible for running implementation and corrective PL/SQL scripts. Remedy BugTracking Software

Senior PowerBuilder Programmer/Analyst/VB.NET

Confidential

Redesign, develop, and migrate/convert current metal Re-Bundling application from a VB.NET framework to a PowerBuilder 10.5.2 application utilizing Oracle- PL/SQL as backend to include business areas of inventory management and historical genealogy tracking of parent-child records and relationships.

Senior PowerBuilder Programmer/Analyst

Confidential

First DataBank's standardization project which included development, coding and testing of both client and server side modifications and enhancements to the Drug Product Loader import process for a suite of medical and clinical software applications, WORx, a drug therapy management system.

PowerBuilder 11.1, Informix

Senior PowerBuilder Programmer/Analyst

Confidential

• Migration/enhancement of corporate wide PromoSmart application, a retail promotional tracking software.
• Drafted migration analysis, coordinated efforts with PM, DBA, and Business manager to deliver stand-alone client application, eliminating the necessity to log onto the application via Citrix Metaframe network server. Also responsible for managing, developing, coding, testing and implementation of all system enhancements and modifications, which included database changes necessary to migrate batch processes from multiple databases over to a single database server. Using PowerBuilder 6.5 - 10.5 OraclePL/SQL

Senior PowerBuilder SQL Programmer/Analyst

Confidential

Member of new products development team, responsible for new development of both enhancements and modifications on Retail Annuity system. Worked with user community to gather system requirements, resolving system errors and bug fixes, defining functional specifications, unit testing, system maintenance and training for corporate wide Insurance Claims and Death Benefits financial and accounting systems, which also included any modifications to database objects stored procs / triggers , client side modification/creation of user objects, functions, PFC extensions.

PowerBuilder 9.0, Sybase ASE 12.53, Transact-SQL, Rapid SQL, PVCS SourceSafe.