SUMMARY:

Solution Architect / Data Engineer specializing in Energy (Commodity) Trading Risk Management (ETRM/CTRM) solutions. Strong Data Architecture, Data Analysis, Development, Leadership and Communication skills.

KEY POINTS:

Roles have included: Solution Architect, Software Engineer, Data Engineer, Data Architect, PL/SQL Developer, Java developer, Java Development Team Lead, Business Analyst and Project Manager

Development Software: Oracle PL/SQL, Java, Openlink JVS and OpenComponents Java API, Openlink integration framework Connex, Business Objects

Design Software: ER/Studio, Oracle SQL Developer Data Modeler, TOAD, Rational Rose

Solid understanding and in: depth knowledge of Commodities markets (Natural Gas, Power, Crude, Emissions)

Subject Matter Expert in: Dodd Frank requirements analysis and solution design, Data Migration, System Integration, PNL and financial data warehouse reporting

WORK EXPERIENCE:

Confidential

Data Engineer / Data Architect / PL/SQL Developer

Responsibilities:

• As part of a multiyear program implementing Confidential Endur version 14.1 for natural gas trading, architected and implemented a new data warehouse star schema to support complex EOD valuation, exposure, and PNL explained data structures.
• The warehouse supports all regulatory (Dodd Frank) and financial downstream reporting.
• As the senior Oracle PL/SQL resource on the project I developed an abstraction layer of complex views to support backward compatibility for legacy data warehouse data consumers
• Designed and specified Informatica ETL processes to load new schema from Endur transactional schema.
• Designed and Specified new Business Objects universes to support reporting from the new data warehouse schema.
• I have also led testing, data migration and user support for the interfaced data.

Confidential

Senior Endur Support SME

Responsibilities:

• Senior Endur SME responsible for providing resolution to issues escalated from support organization.
• The organization supports all aspects of the Endur implementation: Physical natural gas trading and scheduling, financial trading in Crude Oil, Refined Products, Coal, Freight, and Natural Gas Liquids. The system interfaces with upstream systems including ICE and IPE exchanges and downstream systems including accounting, settlements, credit and Dodd Frank reporting.
• The Confidential technologies employed in the solution include: Trading, Market, Operations and Admin Managers and Connex and Grid services.

Confidential, San Antonio, TX

Solution Architect

Responsibilities:

• Senior technical resource on the new implementation of Endur 12.1 designed to support Confidential worldwide financial oil, products, natural gas and environmental trading.
• Responsible for requirements gathering, functional design and technical design of custom solution deliverables.
• Deliverables were developed offsite by Openlink’s custom solutions team in Houston.
• Reviewed, approved and deployed delivered JVS code solutions.
• Also served as a mentor to Confidential ’s technical implementation team.
• Taught Endur technology 101 classes to onsite personnel.

Confidential, Houston, TX

Development Team Lead

Responsibilities:

• Responsible for leadership of a team of forty consisting of project managers, business analysts, solution architects and developers.
• The team supports three instances of Confidential Endur, which enables physical and financial trading of most major commodities including oil, natural gas, power and precious metals.
• Pmotion, Confidential and Cmotion are also utilized within the solution.
• Managed the relationship with Confidential and third - party consultancies.
• Instituted changes within the team to more closely align with the business organization.
• This facilitated ownership within the team and increased customer satisfaction.
• Worked closely with senior business and IT management on both current work prioritization and on strategic project planning.

Confidential, Houston, TX

Endur SME/Solution Architect

Responsibilities:

• Senior SME responsible for solution architecture and testing leadership for two Endur implementations.
• Project includes implementing the Confidential ICE eConfirm gateway real-time reporting solution for mandatory real-time reporting of swaps and options.

Senior Java Developer

Confidential

Responsibilities:

• Member of JVS developer team supporting the natural gas trading implementation of Confidential Endur and Confidential .
• Assigned to a group focused on supporting the logistics users of Confidential .

Data-Migration/Performance Lead

Confidential

Responsibilities:

• As Data-migration lead I lead a team of twelve responsible for master data migration, deal transformation and data verification.
• Master data migration updated Endur/ Confidential with reference data extracted from Nucleus and other sources.
• Deal transformation moved all deals into the new deal models and linked the new master data to each deal.
• Data verification consisted of data integrity checks and risk exposure and valuation reconciliation.
• Also lead pre and post go-live system performance initiatives.

Endur Solution Architect

Confidential

Responsibilities:

• Project implemented Endur and Cmotion for Crude trading and scheduling. Assigned technical leadership role for three technologies; CONNEX, TPM and Open Components.
• For each technology; Responsible for guidance to the project development team, design review of locally developed deliverables and coordination with Confidential technical management for core enhancements required by the project.
• Provided Endur technical mentoring to development, tech support and configuration management teams.

Technical Team Lead/Software Architect

Confidential

Responsibilities:

• Technical lead on Endur version 5.3 to version 9.0 re-implementation project.
• Responsible for design oversight and code review for team of five AVS developers.
• Team delivered 200+ development deliverables, including twelve integration points with other Shell systems, 100+ AVS conversions, and 80+ stored procedure conversions from Sybase to Oracle.
• Also specified and oversaw implementation of new hardware infrastructure.
• Coordinated with infrastructure and DBA organizations.

Confidential, Houston, TX

Assistant Vice President

Responsibilities:

• Technical lead on Crude and Products Endur financial trading implementation.
• Responsible for design oversight and code review for team of five AVS developers.
• Design and development of data conversion programs to convert 200,000 existing trades into Endur.
• Project includes development of SQL extract scripts from legacy system and AVS import scripts for futures, swaps, options and exchange traded options.

Confidential, Houston, TX

Manager

Responsibilities:

• Technical consultant for the implementation of a newly developed Physical Gas Trading and Scheduling system for a major regional utility.
• Played project manager, technical analyst and business analyst roles on the project.

Confidential, Houston, TX

Senior Technical Consultant

Responsibilities:

• Played developer and development lead roles on Endur implementation projects.
• As a developer responsibilities included analysis, design and development of interfaces and reports.
• As a development lead was responsible for technical leadership of the developers on the project.
• This entailed technically mentoring developers, assigning programming duties and quality assurance through code reviews.
• Integration development included a physical and financial deal interface for a Canadian bank and production volume integration for a Houston natural gas trading firm.
• Report development included front, mid and back office deliverables.
• Developed real-time credit monitoring scripts and scheduling reports for the Confidential module.
• Development was concentrated in the AVS scripting language but also included work in VB and Java.

Confidential, Greenwich, CT

Software Architect/Development Manager

Responsibilities:

• Development Leader in charge of software development for energy trading and risk management. Software developed as part of the Confidential Financial Endur Energy trading and risk management software implementation.
• The role included leadership and coordination responsibilities for all phases of the development life cycle.
• Lead analysts and developers in the analysis and design of reporting and integration architectures.
• All analysis and design utilized the Rational Unified Process and was documented in Rational Rose.
• Lead the team of in house and contracted developers in developing reports and integration real-time data feeds.
• Report development utilized the AVS scripting language and Crystal Reports.
• All integrations utilized Tibco BusinessWorks, Java Message Service (JMS) and the Confidential integration application server Orien.