SUMMARY:

• Technically sophisticated and seasoned professional powered with broad - based experience for over 15+ years in Oracle eBusiness suite and Client-Server Technologies.
• Possess stellar reputation in providing solutions that meet or exceed diverse clients’ requirements.
• Excel at leading large-scale data migration and integration projects with high-volume, high-concurrency, and multi-platform environments.
• Known for consistently delivering highly-complex and mission-critical projects on time and under budget.
• Hands-on Techno-Functional experience in complex business solution integration and implementation of different Oracle E-Business suite (R12/11i) modules.
• Extensive in-depth knowledge in Oracle apps modules and Technical architecture, Apps Tables, APIs, Data Flow Between Modules, Set-ups, Design, RICE Components, Data Mapping, Data Migration/Conversion, Integration/Interfaces, Customizations, Reports/Forms, OA Framework, Upgrades, Workaround solutions, AIM Methodology, Multi org, Performance tuning, Debugging, Data Extraction, Order to Cash, Procure to Pay, Supply chain, Upstream Oil and Gas production management.
• Strong team player with extensive Oracle ERP experience with successful implementations/Upgrade involving RICE objects after thorough technical analysis of user requirements. Capa ble of time estimation and mentoring highly productive teams.
• Support & Issue Management: Have good exposure in outsourced project environment. Worked with ‘Oracle on demand support team’ to get fixes for issues, patch applications process and system maintenance.
• Worked in different countries and with different language user groups, have good experience in ‘user support and management’ directly and remotely also.
• Outstanding IT leader with remarkable ability in motivating and coordinating cross-functional teams. Displays keen eye for detail with proven capability to multitask in a globally competitive and fast-paced situation.
• Renders exceptional skills in presentation and communication, onsite-offshore delivery management, continuous process and performance improvement, impact and gap analysis, quality assurance and regulatory compliance.

TECHNICAL SKILLS:

• Oracle General Ledger
• Oracle Purchasing
• Oracle Accounts Payable
• Oracle Accounts Receivables
• Oracle Order Management
• Oracle Shipping & WMS
• Oracle INV & BOM
• Oracle Fixed Assets
• Oracle Project Accounting
• Oracle iProcurement
• Oracle iRecruitment
• Oracle iReceivables
• Oracle Alerts
• AME
• Oracle Workflow
• Application Object Library
• Enterprise Upstream
• (EB/EU/ER/EK/EJ)
• Tobin Enterprise Land
• Developer 6i/2000 (Forms 6i/5/4.5, Reports 6i/3/2.5/2/1.1)BI/XML Publisher, Reports Wand, Oracle Workflow Builder, ADI,
• SQL, PL/SQL, HTML PL/SQLSQL Loader, Data Loader, TOAD, JDeveloper /OAF, SOA/BPEL, UNIX Shell Scripting, HTML, XML, Style Sheets, Stylus STUDIO AND Talend
• QVCS, PVCS, Putty, HP Reflections,
• MS Office Suite, Share point, TFS,
• Project and Portfolio Management
• SVN, CC Builder

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Oracle Apps technical Consultant

Responsibilities:

• Various custom reports has been updated /enhanced. Fine-tuned custom report by performance tuning and adding new parameters. Updated rtf templates and XML definitions to capture new data.
• Developed brand new custom reports to meet the business user requirements.
• Customized Po Output for Communication program to print custom PO PDF. Updated layout/logo/Labels as per custom requirement. Added additional template to PO for po terms conditions.
• Customized RFI/RFQ/Drafts stylesheets for opracle sourcing requirements.
• Developed custom report ‘Texas state Direct Payment Exemption Certification’. This report populates/fill data into PDF form.
• Customized Check print, re-aligned columns and added discount amount column.
• Developed custom payment extracts report for BBVA bank as per bank predefined format of columns.
• Also developed various other Bi Reports using XSL/XML/PDF/RTF/RDF formats.
• Interfaces/Conversion
• Developed item interface program to import Items, flex values, Item category, category assignment and org assignment. Also developed interface custom report out (xls) to track imported items and error records details.
• Customized PR interface program. Added new menu/function to call custom OAF page to upload requisition xls file to staging table, defined new custom request set to import Purchase Requisitions into the system. .
• Enhancements
• Customized AP holds and release logic based on custom tolerance limits. Used ap holds pkg API to assign new holds/releases. Developed custom report as part of this solution to track all historical changes of invoice level hold.
• Customized inspyrus (PR Application) package to handle to inspyrus application triggers. This customization make sure to validate correct project selected for PR.
• Workflow:
• Customized PO Approval Workflow to generate ‘Texas Direct Payment Exemption Certification’ and send it as attachment in supplier/Buyer notification. Customized attachment logic to limit maximum size of 22MB.
• Updated PO approval notication (OAF page) to show line type based on Maxiomo service line.
• BPA Bill Presentment Architecture (BPA)-AR
• Configured BPA for AR Invoices.
• Defined custom content items, logos, templates. Defined rules based on batch source /transaction type and assigned templates accordingly.
• Object Migration:
• Bundled all custom LDT files and objects from one instance to another instance by using Used TFS (Team Foundation Server).
• Hand on experience to use SVN repository and SharePoint to maintain multiple version objects and related AIM documents. OAF Customizations:
• Developed custom OAF page to upload csv files into custom table. From custom table data used for conversion or reporting purpose. Personalized buyer page to select SC team option.
• Custom Alerts:
• Defined various custom alerts to track different process errors/ failures / status. Custom notifications triggers and sends to business users accordingly (AME User Approver Check /receipts and workflow failures / notification failures etc.)
• Form Personalization:
• Personalized requisition form for custom defaulting values based on buyers.
• Adhoc SQL Scripts:
• Prepared various test scripts to validate/ourge data, fixing production issues, for end user training documents to validate and reprocess the interface data.
• SR Management:
• Logged multiple SR to get the fixes/patches for production issues.

Confidential, Houston, TX

Senior Oracle Apps technical Consultant

Responsibilities:

• Developed custom program for mass role assignments and defined various custom alerts Developed custom program to not show credit card related requisitions lines at buyer work center.
• Enhanced the usage of custom table report parameters logic in related to Davison. Added SC team logic to improve data selection criteria for dashboard report.
• Defined business event to trigger account generator at the time of auto creating PO at BWC.
• Updated SQL packages to adopted exception account list for intercompany account generator logic (same package used in eON/eSI).
• Developed ‘PO Approval Analyzer’ program to help user/support team to analyze the PO approval.
• Developed custom scripts to inactivate sub-inventory.
• Involved in developing PO interface, Receipts Interface, receipts Feedback Interface and Suppliers interface.
• Customized PO Approval Workflow to send notification to supplier/Buyer based on selected language in PO Header DFF. Updated PO PDF attachment name based on custom requirements.
• Account Generator workflow customized to apply intercompany logic whenever cost center was updated at BWC.
• Developed brand new custom reports to meet the business user requirements.
• Also been updated /enhanced existing custom reports. Fine tuned custom report by performance tuning and adding new parameters. Updated rtf templates and XML definitions to capture new data.
• Customized PO (‘PO Output for Communication’) to print in multiple languages ( overriding session base LANG set up) and also personalized forms to add regenerate PO option to menu to get latest updated PO PDF. Enhanced PO pdf to accommodate different countries address, fixed number rounding issues, added custom message to PO footer etc.
• Developed custom OAF page to upload csv files into custom table. From custom table data used for conversion or reporting purpose.
• Personalized buyer page to select SC team option.

Confidential, Houston, TX

Senior Oracle Apps/P2 technical Consultant

Responsibilities:

• Reports: Converted RDF reports into XML reports (pdf/excel output) and developed new reports as well as modified existing reports using XML (BI) Publisher. Some of the reports include: Fixed Asset Transactional Summary Report Remittance Advice/-Financial report for YTD Statement of Cash Flow/-Annual royalty letters and labels for TX and KS properties/ AR Invoice/Custom GL Journal Report.
• Involved in Oracle Applications Sysadmin activities like, user setup, defining responsibilities, flex fields, values sets, alerts, registering application objects. In addition to performance tuning and using different oracle development tools also has in depth knowledge of Workflows, XML, Data Modeling and HTML PL/SQL to generate web reports.
• Supported to define custom menu and assign to various level of responsibilities. And also moved all these custom responsibilities from test instance to production instance using FNDLOAD.
• Developed various adhoc reports (SQL scripts) for AP/GL users for GL/AP reconciliations and month end closings.
• Customized AP Check with electronic signature. Signature will be replaced based on approval limits.
• Postproduction Support.
• Phase2 (After BHP acquired Petrohawk) Oracle became legacy to SAP. Prepared GAP analysis documents to support new system requirements.
• Developed various custom scripts to meet SAP data conversion and help users for testing and UAT and conducted demos. Resolved showstopper issues

Confidential, Atlanta, GA

Senior Oracle Apps technical Consultant

Responsibilities:

• Responsible to support production issues in day to day business activity (related to Oracle Financials modules).
• Maintaining the cases log with different change/version management systems like Bugnet/ Remedy/Clarify Case/ Cool Compliance/PVCS/PPM.
• Managing offshore team (manila).

Confidential, Houston, TX

Senior Oracle Apps technical Consultant

Responsibilities:

• Customized ‘APT Interface’ to import the production volumes and information and ‘Accruals Import interface’ to import Estimated Daily Values. The scopes of these interfaces are to receive a file (spreadsheet) and format the data according to the mapping and load the data into EU.
• Developed a couple of custom forms. ‘NOBL INTL APPROVAL GROUPS’; to maintain International approval groups and amount limits (used for custom AP workflow). ‘NOBL EJ PA INTERFACE’ Form; to manage the interfaced items that are shipped from Venice to various oil rigs. ‘NOBL EU JVA X-REF’ Form; to view and manage the existing records in the XREF tables and allowing users to insert a new record for JVA processing.
• Workflow: Developed new AP workflow process for international Invoice approvals based on custom approval hierarchy (No AME for this process). And also customized domestic AP invoice workflow to validate exceeds amount limit invoices. Defined new Approval Management (AME) rules to send this kind of notifications to top management only bypassing regular hierarchy. PO Workflow modification to pick approvers based on custom made rules, Timeout configuration on the PO workflow. Modified irecuritment workflow to timeout on 2 days, if the manager doesn’t respond to the notification. Upon approval, before close will send notification to recruiters about the position status.

Confidential, Houston, TX

Oracle Apps technical Consultant

Responsibilities:

• Highmount implemented EU modules along with financials in two deferent instances. It requires Real time Integration (triggers, synonyms etc) between Energy and Financial instances. Party Integration - integrating Parties with VENDOR/CUSTMR roles from Energy to Financials. JVA accounting, Synchronizing Chart of accounts between Financial and Energy instances.
• Large amount of conversion tasks from SAP to Oracle E-Business. All these conversions involve detailed interface tables mapping(CV40), Design, lookups and scripts using the SQL, PL/SQL, SQL*Loader, UTL FILE and Unix Shell scripts. Some of the Conversion tasks include Vendors and Vendor banks/contacts, Open Purchase Orders, PO Attachments, AR Lockbox, GL account balances, GL Cross Validation Rules, Project Tasks/Transactions, Parties, and JIB Division Orders, Open AFEs, AFE balances.
• Forms Personalization: Added personalization to hide vendor SSN no at supplier form/ap invoices form/ vendor LOV. Customized ‘OE ORDER WF UTIL’ and added Form Personalization to Open Sales Order Form by Workflow Notification. Added personalization to AP invoice form to default the selected international approval group first person (DFF) as Invoice requestor.