SUMMARY:

• Over 20 years of IT experience as a highly skilled Software Professional. Proficient and well versed in Analysis, Design, Development, Enhancement, Maintenance, and Implementation of various applications including ETRM software. Fast learner, versatile and can easily adapt to frequently changing environment.
• Over 10 years of Client - Server Application Development using various software including Visual Basic, MS SQL Server Transact SQL, Oracle PL/SQL, Crystal Reports, MS Access, MS EXCEL, MS Word, VB SCRIPT, XML, HTML, TRUE DB GRID, VS OCX, INFRAGISTICS
• Over 10 years of MS SQL Server Development using Transact SQL, creating Stored procedures, SQL scripts, functions, triggers, views. Experience in SQL Server Report Server (SSRS), SQL Server Integration Services (SSIS), SQL Server Profiler Tools. Experienced in SQL Server Database Administration.
• Over 8 years of ALLEGRO 8.x (ETRM) implementation, Development, Customization and Enhancement using C# .Net, Crystal Reports, Transact SQL.
• Over 4 years of using .NET C# in development and enhancement of Allegro user interface.
• Over 3 years of Oracle SQL Development using PL/SQL creating Stored procedures, SQL scripts, functions, triggers, views.
• Two (2) years of Share Point and InfoPath development and maintenance programming.
• Three (3) years of Unix-based Application Development using INFORMIX 4GL/SQL, SYBASE.
• Three (3) years of Mainframe Application Development using IMS DB/DC & COBOL.
• Trainings in Microsoft .Net, SAP ABAP 4.0, People soft People Tools 7.0, HTML,, Active Server Pages, Java 2.1, XML, SQL Server Database Administration

PROFESSIONAL EXPERIENCE:

Senior Programmer/Database Administrator

Houston, Texas

Confidential

Responsibilities:

• ALLEGRO 8 Implementation - Allegro is an enterprise-level risk management architecture software that allows companies to manage operations and integrate new components as their needs change. The software is used by traders, risk managers, and decision-makers across the globe, including some of the world’s largest energy industry companies.
• Created the scripts and procedures, and performed data migration of Genesis two legacy system (Lease Management System and CRUDENET system) into Allegro 8.
• Developed a number of user and management reports using Crystal Reports, SQL Server Transact SQL and C# which assist Traders and marketing group in their decision making thereby improving customer relationships with operators and other counterparties.
• Developed and enhanced a number of class events, views and batch process using .NET C# and Transact SQL to customize the system according to the needs of the Genesis Marketing and Accounting users.
• Enhanced the Royalty Statement Reports to reduce the Generation time from 8 hours to 1.5 hours.
• Enhanced Allegro Trade Approval Workflow process resulting in a more efficient approval of the document.
• Developed class event to allow the conversion of the Contract Documents from PDF to Word document to allow contract administrator to customize the file.
• Enhanced the View Index of several allegro custom reports to retrieve index data faster by using an alternate database view for indexes instead on the normal report database view.
• Developed a process to allow automatic emailing of custom allegro Royalty Statements to about 300 Operators and Counterparties.
• Developed allegro check writing module which allows Genesis to generate pulled checks to be printed in-house.
• Developed a custom allegro process to generate, encrypt, and upload Check data to Bank of America FTP site using class events.
• Developed allegro process to generate and email audit log reports to management.
• Helped enhanced custom allegro security reports.
• STAR system - A comprehensive pipeline revenue accounting system built upon flexible accounting principles to handle a variety of pipeline configurations. The application highlights include maintenance setup of equipment and shippers, nominations, run ticket and inventory field data acquisition, and finally ledger account definitions with volume allocation setup procedures and activity postings. It was developed using MS Visual Basic 6.0 with MS SQL Server as its Database.
• Spearheaded the upgrade of application from version 3.9 to version 4.7.2
• Provided continual support and assistance in resolving operational and data issues.
• Administered database and the user security maintenance for the system.
• On Target Share point project - Management and Repository for Application and System Changes. This system used VB .NET and MSSQL server as the backend.
• Developed process workflow to manage Application and System Changes for IT group.
• Created approval views and workflow process to handle Genesis IT enhancement and system development tasks from the submission of the change request to the implementation of the task.
• Provided technical support for Genesis Share Point users.
• LMS (Lease Management System) - LMS is a system which allows the management of Genesis Trading and Contract documents. It allows the tracking of lease and handling of commodity pricing. It was developed in-house using MS Visual Basic and SQL Server.
• Responsible for the Version Control, Building, Migration and Deployment of each release for system.
• Designed, developed and implemented all system enhancement, fixes, and maintenance release for the entire application.
• Administered database and security data for the system.

Senior Programmer/Analyst

Houston, Texas

Confidential

Responsibilities:

• Contract System - This system provides a base for tracking critical contract information during the trade process, as well as improving Contract Management Services' ability to manage these contracts through automated reporting. The application was developed using MS Visual Basic 6.0 and Oracle as the Database.
• As Lead Developer for Contract System, developed a number of modules, forms, DLLs, and OCX for Coal, Gas, and Power contracts provisions using Microsoft Visual Basic 6.0.
• Wrote stored procedure, views, and functions using Oracle PL/SQL.
• Streamlined the implementation of standards for the technical design and architecture to be followed by the Contract System application.
• Counterparty System - This system aims to improve the identification and tracking of trading counterparties across Dynegy Marketing and Trade (DMT) and Dynegy Midstream Services (DMS).
• Involved in the system Implementation which resulted in the improved customer credit tracking and provided the company with single customer identification system for on-line trading. The project resulted in the removal of over 45,000 redundant, inactive, or inaccurate counterparty records across six applications.
• Document Management System (DMS) - This system uses the Smart Discovery Software for the front-end and scanning process that was developed by a third party vendor.
• Developed the Batch Printing Tool for DMS using MS Visual Basic as the front end and Oracle Database as the Back end using Wang Image objects to allow for the viewing and printing of Scanned Documents for Contracts and Confirmation letters.
• Developed a feature to export and convert scanned images to a single or multiple PDF files.
• CPK Reconciliation Reporting Tool.
• Designed and developed the entire Reporting Tool for the Contract and Counterparty systems using Microsoft Visual Basic 6.0 and Oracle Stored procedures.
• Enhanced, implemented, and setup scheduling of batch processes using the NT scheduler.
• Developed the reporting tool to use for the generation of reconciliation reports between Contract System and partner systems (ABACUS, Nucleus), and between Counterparty System and partner applications (ABACUS, Nucleus, PeopleSoft)