We provide IT Staff Augmentation Services!

Sr. Consultant, Oracle Portal Resume Profile

4.00/5 (Submit Your Rating)

Germantown, MD

PROFESSIONAL SUMMARY

  • Over 12 years of Techno-Functional experience with Oracle E-Business Suite including 6 years in R12.
  • Experience with 11i to R12 Upgrade/Re-Implementation project .
  • Hands on experience with several SLDC projects.
  • Over 6 Years of experience in Oracle Federal Financials implementation and support.
  • Excellent with SQL, PL/SQL and Oracle Reports and Forms 6i-10G , BI/XML Publisher.
  • Experience in Order-to-Cash and Procure-to-Pay, Leasing modules and design.
  • Order Management, Purchasing, Inventory, Oracle Loans, Oracle Leasing, Shop Floor Management etc.
  • Excellent with General Ledger, Payables, Receivable, Assets, Cash Management, Oracle CRM,
  • Experience with Shared System Service provider Implementation Centers for Medicare Medicaid Services .
  • Sound knowledge of AOL, Alerts, Workflow, Workflow AME, Sys-Admin and Unix Shell scripting.
  • Lead role experience including Bearing Point, CGEY, IBM, CSC, Deloitte and Oracle Consulting projects.
  • Debugging, Patches Implementation and Production Support expertise.
  • Able to work independently with end-users and within the IT team.
  • Implementation support, Trouble shooting, User Interaction/Issues, Work-around and Problem solving skills.
  • Knowledge of XML, XSLT, JAVA, BPEL,SOA and Web Service Technologies.
  • Knowledge of PVCS, Kintana and Clear case/Clearquest Migration and version control tools.
  • Good with MS Office, VISIO, TOAD, SQL Developer, JDeveloper, XML Marker and XML Spy.
  • Capable of Gap Analysis, MD-50 Design Documentation and Functional/Business Support.
  • Good knowledge of Accounting, Ledger Integration, Reconciliation and experience in post-implementation support.

R12 EXPERIENCE

  • 6 years of R12 Implementation projects 3 and 11i to R12 Upgrade 2 including lead roles.
  • Heavy hands on experience with R12 Data Conversions and Interfaces including from and to Legacy systems.
  • Excellent with Custom Oracle Reports Migration to XML/BI Publisher Reports.
  • Good Knowledge of R12 Database Schema, VPD and Architectural changes from 11i.
  • Exposure Sub-Ledger Accounting, solid experience with custom code migration from 11i to R12.
  • Experience with OAF Personalization and Extensions, Workflow and AME customization experience.
  • Experience with SOA/BPEL integrations and involving inbound and outbound XML files.
  • DBA Skills, Applying patches, troubleshooting, cloning etc. in R12 development environment.

TECHNICAL SKILLS

  • Oracle EBS
  • Oracle 11i to R12
  • Oracle Federal Financials Implementation and support
  • SQL, PL/SQL
  • Oracle Reports and Forms 6i-10G
  • BI/XML Publisher
  • WebLogic, BPEL/SOA, WebServices
  • JAVA,VBSCRIPT
  • BPEL
  • SOA, SOAP UI
  • Web Service Technologies
  • MS Office
  • VISIO
  • TOAD
  • SQL Developer
  • JDeveloper
  • XML Marker and XML Spy
  • RICE Technical Designs
  • Oracle Accounts Payable
  • Oracle Account Receivable
  • Oracle Fixed Assets
  • Oracle Purchasing
  • Oracle General Ledger
  • Oracle Order Management
  • Oracle Inventory
  • Oracle CRM
  • Oracle SupplyChain

PROFESSIONAL EXPERIENCE

Confidential

Oracle Federal Financials EBS Rel-1231.x Sr. Technical Consultant

  • Utilized GL,AP,AR,PO 11i/R12 Oracle 10g/11G, Oracle Tools/PL SQL, OBIEE, Oracle Reports, Forms.
  • Provide expertise in all technical areas including design, development and implementation support.
  • Converted Reports developed in Oracle EBS 11i to R12 environment.
  • Unit Tested OBIEE Reports migrated from 10G environment and fixed bugs.

Confidential

Oracle EBS Rel-12.1.x Sr. Technical Consultant

  • Implementing Extensions and develop code extensions meet user requirements.
  • Provide expertise in all technical areas including design, development and implementation support.
  • BPEL/SOA and OBIEE environment.
  • Utilize R12 iStore in a Solaris, Oracle 10G, Oracle Tools/PL SQL, Jdeveloper , Weblogic, VBScript, HTML, JSP,
  • Developed Check Scanner Interface using HTML/Script.
  • SSA to Treasury Department OCTNET integration thru Webservice using jdeveloper, Weblogic, PL/SQL, Java.
  • Developed web service using Jdeveloper, Weblogic and VB Script to make service from Scanner Interface to Oracle EBS.

Confidential

Oracle EBS Rel-12.1.x Sr. Technical Consultant for Enhancements

  • Utilize R12 Payable, Purchasing in a Linux, Oracle 10G, Oracle Tools/PL SQL, BI/XML Publisher, Workflow Builder, FNDLOAD and Jdeveloper11g environment.
  • Provide expertise in all technical areas including design, development and implementation support.
  • Implementing Extensions and develop code extensions meet user requirements.
  • Generated XML Output files using XSLT and XML transformation for PO Interface to IPP.
  • Developed shell scripts for code migration.

Confidential

Oracle EBS Rel-12.1.x Lead Technical Consultant

  • Utilize R12 GL, Payable, Receivable, Assets, Purchasing in a Linux, Oracle 10G, Oracle Tools/PL SQL, BI/XML Publisher, XML Spy, Workflow Builder and Jdeveloper11g environment.
  • Provide expertise in all technical areas as the lead technical consultant to complete the Board upgrade to R12 from 11i version of EBS to Federal Client utilizing only 3 outside independent consultants.
  • Mentor board developers, implement R12 standards, add extensions, and enhance interfaces and Workflows.
  • Perform custom report development using BI/XML Publisher etc.

Confidential

Oracle EBS Rel-12.1.x, Sr. Technical Consultant

  • Utilized R12 Inventory, Order Management, Warehouse Management in a SUN OS 5.10, Oracle 10G, Oracle Tools/PL SQL, BI/XML Publisher, and XML Spy environment.
  • Developed Interfaces and Reports for Inventory and Order Management Modules.
  • Supported Integration testing in resolving technical issues with SQL and PL/SQL code.
  • Modified XML Outbound Interface files using PL/SQL, BPEL SOA .
  • Developed Shipping Labels using ID Automation Barcodes.
  • Supported team management and functional team on various Integration issues.
  • Completed MD70 technical design for Interfaces.

Confidential

Oracle EBS Rel-12.1.xSr. Technical Consultant

  • Utilized R12 Inventory, OM, PO, AP, Shop Floor Management in a Linux, Oracle 10g, BI/XML Publisher, OBIEE and JDeveloper environment.
  • Developed Lots Jobs Interface, Lot Move Jobs and Material Transactions Interfaces.
  • Created technical design documentation MD-70 for Interfaces, Conversion, Extensions and Reports.
  • Developed reports using XML Publisher.
  • Designed MD-70 documentation for Inventory and Shop Floor Management nodules customizations and assisted functional consultants in MD-50 design and custom solutions with in Oracle EBS.
  • Mentored team members on XML Data Template development and Report design using XML Publisher.
  • Utilized RTF Templates and XSLT/XML scripts.
  • Developed Migration scripts for custom objects using Unix Shell Scripts and SQL Plus Commands.

Confidential

Oracle Apps Rel-12.1.xLead Technical Consultant

  • Completed R12 Upgrade from 11i AP, PO, AR, PA, GL in aIBM/AIX Oracle 10G, Oracle Tools/PL SQL, and BI/XML Publisher and OBIEE environment.
  • Implemented Payables Open Interface in R12. Converted reports from R11i to R12 using XML publisher.
  • Provided technical assistance to DBA team in migrating custom objects from R11i to R12 objects.
  • Migrated a total of 15 XML reports from R11. Modified Shell scripts to run under R12 environment.
  • Helped project management team in assessing the impact of custom 11i code and their impact on R12 architecture roll out schedule.

Confidential

  • Oracle Apps Rel-12.1.x Lead Technical Consultant
  • Utilized Accounts Payable, iExpense, General Ledger, Fixed Assets in an IBM/AIX, Oracle 10G, Oracle Tools/PL SQL, and BI/XML Publisher and IBM AS 400 environment.
  • Lead Technical developer for the IBM project which includes EBS and Oracle Retail.
  • Designed AIM Documents and developed GL Open Balance conversions.
  • Developed GL Interface and Payable Open balances from IBM AS 400 Main Frame legacy systems .
  • AP Supplier Conversions, AP Open Invoice Interface and AP History Invoices conversions and Assets Conversion interfaces, Credit Card Interface for iExpense.
  • Modified Check processing program to pay by Supplier from the existing payment functionality by Supplier sites.
  • Provided support for functional and testing teams.
  • Worked with Oracle support team in fixing performance issues and bugs.
  • Ensured GL and AP modules went live.
  • Created UNIX shell scripts to migrate data files across secure server from and to Oracle server.
  • Developed reports using Oracle Reports and XML Publisher.
  • Performed forms personalization in AP.

Confidential

Sr. Consultant, Oracle Portal

  • Utilized BI Publisher, Oracle Portal, Oracle 10G, Clearquest, Clearcase,TOAD, SQL, PL/SQL, and XML.
  • Designed, developed, testedand supported FDCA Releases 3,5 and 6 using Oracle Tools and BI Publisher.
  • Created reports mockups for Census verification for releases 3,5 and 6.
  • Worked on reports with performance issues for a total of 30 BI Publisher reports and labels which were completed.
  • Worked on reports with BARCODES.
  • Coordinated with testing assembly test team for testing the reports and labels.
  • Collaborated with Forms development team for fixing issues with data capturing.
  • Completed a test project on converting Reports into Spanish with Accenture team based in MD.

Confidential

Sr. Consultant, Oracle Apps Rel-11.5.9/10 Sr. Techno-Functional Consultant

  • Developed interfaces for the Contracts, Guarantor and Assets information from the Delage Landen's legacy systems Oralce Leasing using interface tables OKL OPEN INT, OKL OPEN INT PRTY and OKL OPEN INT ASST.

Confidential

Oracle Apps Rel-11.5.9/10 Sr. Techno-Functional Consultant

  • Interacted with Functional teams and end-users on Oracle Loans impact on Receivable modules as loans were maintained as outstanding receivables prior to this Loans implementation.
  • Developed Technical designs for additional extensions due to the Oracle Loans module implementation.
  • Resolved reconciliation issues with Receivable customs reports and GL account Balances by identifying underlying Tables changes due to patches.
  • Utilized Receivable, Oracle Loans, and Advanced Collections in a Sun Solaris, Oracle 9.x, Developer6i, and XML Publisher environment.
  • Setup documentation on Oracle Loans and Oracle Collections contractor roll outs for CMS, Patch Analysis and Testing,
  • Worked on Enhancement requests design and development.
  • Developed reports using XML Publisher and Reports 6i.
  • Supported go-live and post production in Functional and Technical areas.
  • Helped DBAs to configure XML Publisher environment up and running.
  • Worked on upgrading various AR reports from 11.5.9 to 11.5.10 version.

Confidential

Oracle Apps Rel-11.5.9 Technical Team Lead

  • Utilized General Ledger, Payables, T5, TCA, Receivables and iReceivables.
  • Designed and converted GL Balances to Oracle General Ledger from acquired companies of Exel.
  • Documented technical design for Check Printing using postscript fonts.
  • Developed custom reports for GL and AP modules.
  • Provided technical inputs to Functional and Project Leads.
  • Evaluated third party postscript printing products and made suggestions to the project management.
  • Developed Aging extract for end users.

Confidential

Oracle Apps Rel-11.5.9 Sr. Consultant

  • Utilized AR, TCA, and General Ledger.
  • Designed and developed Custom Interfaces for loading Customers and Addresses along with their contact and bank information using TCA API.
  • Designed and developed Receivable Invoice Interfaces and Receipts Interface API.

Confidential

Oracle Apps Rel-11.5.9 Sr. Consultant

  • Utilized AR, TCA, Sales Online, and Oracle Utility Billing
  • Designed and Developed custom extensions and interfaces.
  • Completed new customer interface using TCA APIs, and NACHA payment outbound and inbound to Interface to PNC Bank for City.
  • Supported functional super-users.
  • Designed functional documents.
  • Worked with Oracle Corp's development team in India with custom interfaces and extensions coding.
  • SupportedCustomers Online, TCA, and AR modules.

Confidential

Oracle Apps Rel-11.5.9Lead Consultant

  • Utilized Order to Cash OM, AR, TCA, Install base, Quotes, Service Contracts, Install Base, iReceivables and iPayables.

We'd love your feedback!