SUMMARY:

• Lead Developer with a total of 17+ years of experience.
• Extensive experience with Oracle EBS 11i/R12 modules such as Financials , Supply Chain, BOM, WIP and Oracle Projects.
• Knowledgeable on Order to Cash and Procure to Pay Cycle.
• Knowledgeable on Integrating SAP Concur to Oracle AP to Create Expense Invoices and Remittance File for Bank.
• Knowledgeable on all aspects of upstream Oil and Gas in areas of Land, Production, Revenue, JVA and projects as well as
• Worked with various SCADA systems such as Cygnet and Howard.
• Gathered on - site requirements from clients like Southwestern Energy, BHP and Confidential and Gas, designed and architected solutions using a variety of technical tools.
• Experience in integrating document management tools such as Docuware URL with Oracle EBS. Also, well-versed with numerous tools reporting tools like Discoverer, BI Publisher, OBI Answers, OBI Dashboard, Pl/SQL, XML Publisher, Oracle Report Builder and Oracle Workflow Builder.
• Working knowledge of ETL tools such as Informatica.

TECHNICAL COMPETENCIES:

Programming/ Scripting Languages: C, C++, PL/SQL and SQL, HTML, XML, Python

Development Tools: Forms and Report Builder 6i/9i/10g, workflow builder, Toad, Pl/SQL Developer BI Publisher

Relational Databases: Oracle 9i,10g, 11, SQL Server

ERP: Oracle E-Business Suite 11i, R12 (PO, OM, INV, AP, AR, GL, FA, IE, iStore)SAP Concur

P2ES: Production, JVA, Revenue

Oracle GRCM: PCG - (Form Rules and Change Control)

Data Warehousing: Informatica, OBIEE (BI Publisher, Answers & Dashboard)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Lead Oracle Apps Technical Consultant

Responsibilities:

• Develop code for converting banks, branches, vendors and vendor accounts.
• Code development for integrating Concur SAP to Oracle AP.
• Design and development of remittance file to AMEX
• Created WEBADI to update Vendor and Vendor Site
• Design and development of code for bringing EXPRT data in to Oracle AP
• Design and develop code for bringing the Legacy SAP data in Oracle Custom schema to create report in OAC
• Created a POC for creating PO requisition using WEBADI template.
• Support production issues on Concur and Remittance file generation process for the bank.

Confidential, Houston, TX

Project Leader

Responsibilities:

• Manage and lead the offshore development team.
• Design the table design and allocation calculations

Confidential, Houston, TX

Lead Oracle Apps Technical Consultant

Responsibilities:

• Worked on RICE items during the implementation such as Open Invoices, Vendor conversions, General Ledger journals import and loading fixed assets, loading Report Centers
• Created interfaces to Create AP invoices for invoices created in Land.
• Create extension to create invoices in AP for Bonus Payments in Land and then clear the record or void the record back in Land once the check is issued or check is void.
• Created interface to create straight line assets and Unit of Production Assets based on data coming from cost sub ledger and pre-distribution in Enterprise Upstream JVA module.
• Created interfaces to Load Invoice from P2 Land to Oracle Receivables.
• Developed interface to create journal entry for dry hole expense from P2ES JVA module.
• Created interface to Create Journal entries in GL for transactions in Land
• Developed interfaces to load Fixed Asset Reserves and Production to Assets.
• Responsible for converting vendor and customer parties
• Create extension to integrate Docuware to AP invoices.
• Implemented various OBIEE reports for reporting on Accounts Payables invoice details and aging, Accounts Receivables aging and Revenue Management

Confidential, Houston, TX

Project Lead

Responsibilities:

• Worked as a team lead on development of various interfaces for Production Management in Upstream Energy.
• Developed interfaces for to load the Gas Meter Readings, Oil Meter Readings and Water Meter Readings and sending monthly allocation data to PDS.

Confidential, Houston, TX

Project Lead

Responsibilities:

• Oil and natural gas companies require consolidated reports for the production, JVA and revenue incurred from multiple sources like P2ES, SAP PRA and TEL.
• Created reports and dashboard on Spotfire for client demo
• Responsible for creating sample reports, charts and dashboard using client data for POC
• Created drill down reports and charts to show the daily and monthly volume produced in Spotfire

Confidential, Houston, TX

Project Lead

Responsibilities:

• Worked on interfacing Cygnet SCADA data into the Enterprise Upstream Production system.
• Developed interfaces for PDS to EU, PI to EU, Well Test, Facility assignment and purge program for clearing the stage table data and Flowcal to EU to load the Gas Meter Readings, Oil Meter Readings and Gas Analysis.
• Worked on bringing data from Flowcal and validating the data received from Flowcal in to EU.
• Created a PL/SQL package to load NGL allocations for Enterprise Upstream Production system.

Confidential

Project Lead

Responsibilities:

• Worked on all RICE items at Southwestern Energy across various modules such as Oracle EBS, Enterprise Upstream (Base, TEL, JVA, Revenue and Production Management).
• Worked on a TEL to Financials interface to load data to Oracle GL from TEL (Enterprise Upstream Production)
• Gathered requirements on-site in Houston in the areas of Party Workflow, RC Workflow, Production Management and Revenue
• Developed Interface to load Cygnet Gas Meter Reading, Water Meter Reading, Oil Meter Reading and Tank Gauge Reading for West Virginia.
• Developed Program to assign Facilities to user.
• Developed Oracle Alerts for various Meter Reading Errors for Cygnet.
• Developed Informatica Workflow to load data from EU to Aries, TIES to EU and EU to TIES Gathering.
• Developed interface for Midstream for loading Wellhead Imbalance and Nomination Interface.
• Developed interface to fetch daily SCADA volume from Cygnet, Flowcal, Source, Elynx and Howard through Informatica in to EU staging table and developed interface to load the data from EU stage table to Gas Meter Reading, Flowcal reading and Water Meter Reading tables.
• Developed Conversion to load the Gas Meter Beginning Balance, Party Netting Balance, EDD Conversion, AMD conversion and JVA Vehicle Utilization
• Developed numerous conversions for Revenue. Some of the conversions include load the Marketing Group XP, Revenue Accrual History, Regulatory History and Regulatory unit upload for MMS and Distributed Party Profile.
• Developed conversion to JVA Chart of Accounts, JVA Allocation Conversion, LOS Conversion and JVA Agreement Conversion
• Created Interface for Finalize Monthly Allocation and Zero Cost Transporter Statement.
• Created Interface for Mileage Upload, Employee Time usage and Tel to Financial Interface.
• Developed interfaces within P2 to load EU volumes to TIES, Volumes Takes to Ties, uploaded GL Transaction and Remittance Transaction upload.
• Worked on Various BI Publisher Reports for Federal State Backup Report, Accrual Manual Delete, Sales Allocation not processed and Equity Balance not generated. Create multiple BI Publisher reports in EBS and EU.
• Created a TPSI report

Confidential

Lead Consultant

Responsibilities:

• Responsible for design of Star Schema in OBIEE.
• Created drill down reports and charts to show the daily and monthly volume produced.
• Created 30 day Moving Average report, daily Field production report, Production Volume YTD report and Daily well production reports in OBIEE

Confidential

Lead Consultant

Responsibilities:

• Implemented a custom Bid tab Analysis, stagger and Visa Management System functionality and customize few functionalities of iStore.
• Designed the database design and implemented a solution to implement a stagger system and a Visa Management system in EBS as a application for Procurement and HRMS process in Confidential .
• Created Interface to load Purchase Orders.
• Created numerous interfaces and guided a team of five members to appropriately deploy the software
• Prepared Technical Document MD070 and Installation Document MD120.
• Ensured creation of install scripts, upload and proper usage of version control system and maintaining proper versioning of software developed
• Created BI Publisher report, updated repository and business logic as well as created reports in Answers
• Created star schema and published the OBIEE report in OBIEE Dashboard

Confidential

Technical Consultant

Responsibilities:

• Created alerts, enabled profile options to monitor activities in Oracle Application R12. Modified controls by adding multiple columns, created functions and modified existing RPD to bring a couple of new views

Confidential

Technical Consultant

Responsibilities:

• Creation of Interfaces, reports and support of Oracle Application R12 Oracle Financials, Order Management, Bill of Materials, Inventory and Work in Process
• Responsible for creation of numerous interfaces including an interface for Bill of Materials, and Item Upload
• Worked on SCM modules and Financial modules.
• Worked on form personalization for ATP (Available To Promise) Order and Drop ship Sales Orders.
• Created dynamic pages in Oracle portal, built reports using Discoverer, OBIEE Answers and BI publisher
• Preparation of Technical Document MD070.
• Responsible for creation of repository in BI Administrator.
• Prepare query to prepare various KPI reports and charts

Confidential

System Admin

Responsibilities:

• Creation of reports and customization of seeded reports and forms and support of Oracle Application 11i Order Management, Oracle Receivables, Oracle Payables, Oracle Purchasing, Oracle HRMS and Oracle Alerts.
• Responsible for discussion with the functional user to get the report changes or new report details after getting approval from Manager.
• Created Alerts for Human Resource Department.
• Created Discoverer reports, customized forms and implemented RICE items
• Form Modification to change the layout of the GRN (Goods Receive Note) screen.
• Customized various Seeded report in Financials like AP Trail Balance, Bank Balance Reports and AR Aging Report.
• Created Oracle Alerts for HRMS module.
• Worked on CRM module to show the marketing materials for SMP and WMP clients.
• Worked on iExpense to track the employee expenses .