Project Manager Sql Developer

Greg Cason 601-***-**** • ****.*****@***.***

SUMMARY

A highly dependable, energetic, passionate and results-oriented Technical Consultant with 30 years of professional IT experience. Affable and tenacious with proven analytical, design and technical skills. Strengths include data modeling, enterprise data warehouse design and architecture, Oracle EBS implementations and customizations. Experienced in system analysis, business and technical requirement gathering, design and implementation, workflow design and process re-engineering. Throughout career, has provided technical assistance and consulting services through teamwork and customer/client relations, effectively using the latest technologies, applications and methodologies. Thrives on challenges and takes pride in my analytical and problem-solving skills. Core Competencies

Analytical Skills, Change & Risk Management, Coaching and Mentoring, Software Development, Lifecycle, Project Management, Large Scale Deployments, Leadership & Team Development, Enterprise Data Architecture, Process Improvement

Skills

Database: Oracle Database, Oracle Enterprise Manager, Toad, SQL Developer Development: SQL*Plus, PL/SQL, Oracle Forms, Oracle Reports, PeopleTools, PeopleCode, UNIX shell

BI/Reporting: Oracle Discoverer, Business Objects, Domo Enterprise: Oracle Applications/Financials/EBS, P2EU, PeopleSoft Version Control/Management: Numara Footprints, CA Harvest PROFESSIONAL EXPERIENCE

Viking Range, Greenwood, MS Feb 2022 – Present

Oracle EBS Technical Consultant

Technical lead and primary support for Oracle EBS Core Financials/Manufacturing/Order Management 11.5.10.2.

Created a formalized software lifecycle process.

Work regularly with Organization Leadership in order to deliver IT solutions resulting in better Business decision capabilities.

Lead for annual Internal and External EBS SOX audits.

Delivered many enhancements that allow the Business Groups to function more effectively.

• “Poor-Man’s MRP”. Scheduling the manufacture of Items based on numerous industry input standards.

• Bulk Item/Bom Creation

• Bulk Lead Time Update

• Sales Order Interface

Greg Cason ****.*****@***.***

Page 2 of 6

• Cycle Count Audit

• Revenue/COGS

• Shipping Interface

• Plus, many others

Support for Domo Business Intelligence reporting.

Lead/Mentor junior team members.

Diag Partners, Beverly Hills, MI June 2021 – Feb 2022 Independent Consultant

Viking Range

• Technical lead and primary support for Oracle EBS Core Financials/Manufacturing/Order Management 11.5.10.2.

• Discovery effort with internal resources to map AS-IS and TO-BE states.

• Created custom process bulk update Schedule Ship date for Sales Orders.

• Created custom process to display all End Items for a Component Part.

• Support for Domo Business Intelligence reporting. P2 Energy Solutions, Houston, TX Aug 2019 – June 2021 Independent Consultant

Targa Resources Oracle EBS (P2EU) Upgrade

• Senior team member for the upgrade/new installation of Oracle EBS from 12.1.1 to 12.1.3 and upgrade/new installation of Oracle database from 11g to 12c.

• Brought EU(OEL) patch current (patches 12.38-49).

• Identified and migrated customizations from the legacy environment. This included but was not limited to custom schemas, concurrent programs, value sets, flexfields and profiles.

• Migrated Concurrent Requests from the legacy environment.

Aera Energy P2 Land Implementation

• Senior team member for the P2Land 5.10 installation and migration from TLS 5.

• Modified the EU/Revenue custom process, Payment Process – Bank, which processes Royalty Revenue payments.

• Re-wrote the legacy custom process, TRAX Interface, which generates the remittance statements for Lease payments.

• Wrote a process to create Marketing Groups for ENT Division Orders and then create REV Division Orders for the newly created Marketing Groups.

• Wrote a process to link Agreements to the newly created REV Division Orders for the newly created Marketing Groups.

Greg Cason ****.*****@***.***

Page 3 of 6

Aera Energy Oracle EBS (P2EU) Consulting Services

• Provide support services for Revenue, Production Management, Regulatory and Partner Balancing.

• Created custom processes to load external data for the following:

Report Centers (Wells and Completions)

Production Setup (Theoreticals, Events, Oil/Gas Analysis and Allocation Networks)

Regulatory Setup

Sales Allocation

Distribution Transactions

Party Transactions

• Regularly meet with Aera Staff to provide technical support/guidance. Aderas, Reston, VA Nov 2018 – Aug 2019

Senior Oracle Consultant

Team Lead tasked with the investigation and decommissioning of over 600 Database Links from 25 plus Oracle Databases at DMDC.

Cataloged and performed analysis of all database objects for “in-scope” databases. Analysis included but was not limited to redundancy, legacy, and move to middle tier.

Cataloged all scheduled jobs that support DMDC applications.

Recommended standards for what to monitor and alert thresholds for the DMDC databases. Louisiana Technology Consulting, New Orleans, LA Jun 2015 – Nov 2018 PeopleSoft Consultant

Conversion of U.S. Navy mainframe applications, Reserve Headquarters System (RHS) and Inactive Manpower and Personnel Management Information System (IMAPMIS) to the Navy Standard Integrated Personnel System (NSIPS).

Utilized PeopleTools 8.56, Oracle 12c and PeopleSoft 9.2.

Used PeopleSoft Application Designer to create Fields, Records, Pages, Components, Menus, PeopleCode, App Engine Programs, Application Packages, Business Processes and Activities.

Created PeopleSoft Security components (Portal Registry Structures, Roles and Permission Lists).

Created Extraction/Migration programs to port data from the legacy systems to NSIPS utilizing SQL, PL/SQL and Data Mover.

Tested and documented all phases of the conversion. Greg Cason ****.*****@***.***

Page 4 of 6

HighMount Exploration & Production, Houston, TX Aug 2007 – Jun 2015

(formerly Dominion Exploration and Production)

Oracle EBS Technical Consultant

Technical Subject Matter Expert and primary support for Oracle E-Business Suite (EBS) and P2 Enterprise Upstream (P2EU) (Revenue, Production and Market Accounting), P2 Enterprise Upstream (P2EU) Land (Division Orders, Rentals) as well as various Geoscience and Engineering systems.

Responsible for managing the software development team, defining technology direction and standards for Oracle EBS and P2EU.

Worked hands-on with the team to design, develop and deliver enhancements, new modules, performance improvement methodologies, and vendor patches.

Regularly met with IT and Business leadership to provide solutions to client issues, identify business opportunities, project prioritization and deliverables.

Led the effort to rapidly implement Oracle HR and Oracle Time and Labor for the start-up of HighMount, including an engagement with ADP for payroll processing.

Key member of the Procure to Pay Process Improvement project utilizing ADP Open Invoice.

Implemented a formal review process for internal code/enhancements resulting in a 40% decrease in software defects.

Worked closely with IT Compliance to help define IT Policies and Procedures as well as a vital resource in the annual Internal and SOX audits.

Technical Lead for the Oracle EBS upgrade from 11i to R12.

Applications and Data Architect.

Technical Subject Matter Expert for Oracle Development Tools.

Oracle EBS System Administrator.

Harvest Change Control Administrator.

Oracle Discoverer Administrator.

Participated in the annual HighMount Leadership Conference.

Led the post-sale effort to transition financial data to HighMount’s former parent, Loews. Dominion Exploration and Production, Houston, TX, New Orleans, LA Mar 2004 – Aug 2007

(formerly Consolidated Natural Gas)

Oracle EBS Technical Support Specialist

Senior member of the Katrina Disaster Recovery Team that restored IT operations in Houston after the destruction of the New Orleans office.

Technical lead and primary support for Oracle EBS and P2EU.

Created numerous company specific enhancements/customizations for Oracle EBS and P2EU.

Provided guidance and solutions in IT/Business discussions and design sessions.

Supported CRP and UAT testing.

Created numerous Oracle Forms and Reports as well as custom menus, request groups and responsibilities.

Created Value Sets and Flexfields.

Created Personalizations to both the Oracle EBS Professional Forms and OAF Pages.

Created Technical Support and Functional Business documentation. Greg Cason ****.*****@***.***

Page 5 of 6

Diversified Computer Consultants, New Orleans, LA Feb 2000 – Mar 2004 Senior Oracle Consultant

Mississippi Department of Marine Resources, Permitting Application

Neill Corporation, Oracle EBS 11i implementation

TurboTrip, Application Support/Interface

New Orleans Public Schools, Oracle EBS 11i/10.7NCA Support

Tulane University, Oracle EBS 10.7SC Third Party Billing

Tulane University, Oracle EBS 10.7SC Retroactive Labor Re-distribution Consolidated Natural Gas, New Orleans, LA Jul 1995 – Feb 2000 Oracle Systems Analyst

Diversified Computer Consultants, New Orleans, LA Sep 1993 – Jul 1995 Oracle Consultant

US Fish and Wildlife Service (TGS), Lafayette, LA Aug 1992 – Sep 1993 Oracle Software Developer

US Fish and Wildlife Service (Sverdrup), Slidell, LA Jan 1991 – Aug 1991 Co-op Student

Greg Cason ****.*****@***.***

Page 6 of 6

EDUCATION

University of Southern Mississippi

Bachelors’ in Computer Science and Statistics

Applied Computer Science Option

CONTINUING EDUCATION COURSES

Change Leadership Developer/2000 Forms 4.5

Tearing Down Barriers between Business and IT Developer/2000 Report 2.5 Hands-On IT Project Management Advanced PL/SQL

Managing Risk in IT Projects Advanced SQL

Powerful Presentations PL/SQL Program Units

Extending Oracle Applications Introduction to SQL and PL/SQL Personalizing Oracle Applications Introduction to Oracle

Contact this candidate