PROFESSIONAL SUMMARY

• Over 13 years of Techno-Functional experience with Oracle E-Business Suite including 4 years in R12.
• Over 6 years of experience in Technical lead roles with Big names in consulting industry.
• Experience with 11i to R12 Upgrade/Re-Implementation project.
• 18 Years of IT industry experience with leading names in the consulting industry.
• Over 5 Years of experience in Oracle Federal Financials implementation and support.
• Experience with Shared System Service provider Implementation Centers for Medicare Medicaid Services .
• Excellent with General Ledger, Payables, Receivable, Assets, Cash Management,
• Order Management, Purchasing, Inventory, Oracle Loans, Oracle Leasing, Shop Floor Management etc.
• Experience in Order-to-Cash and Procure-to-Pay modules and design.
• Excellent with SQL, PL/SQL and Oracle Reports and Forms 6i-10G , BI/XML Publisher.
• Sound knowledge of AOL, Alerts, Workflow, Workflow AME, SysAdmin 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 Clearcase/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

• 4 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.
• Excellent with Custom Oracle Reports Migration to XML/BI Publisher Reports.
• Experience with Workflow and AME, Forms and OA Framework personalization.
• 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.
• Very strong experience in developing OBIEE Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access / query/report privileges and scheduling iBots

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
• XSLT
• JAVA
• BPEL
• SOA
• 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

PROFESSIONAL EXPERIENCE

Confidential

Oracle 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 IDAutomation 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.
• Customized Requisition and Invoice Approval workflow using AME.
• Created OAF pages which populated the CCR vendor from the interface.
• Produced functionality to import Supplier from the CCR OAF page, by calling the Supplier API.
• Design and develop custom made Business Intelligence solution according to the plan using BI applications
• Prepare, enhance and configure meta data and data models using OBIEE
• Build interactive dashboards with drill down effect through Oracle BI Answer
• Develop and design complex data structures, ad hoc queries, reports and analytics
• Develop the repository models and create variables in the repository
• Oversee the security of data warehousing and produce alert system

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 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 from 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

• Utilized BI Publisher, Oracle Portal, Oracle 10G, Clearquest, Clearcase,TOAD, SQL, PL/SQL, and XML.
• Designed, developed, testedand supportedFDCA 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

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

• Utilized Receivable, Oracle Loans, and Advanced Collections in a Sun Solaris, Oracle 9.x, Developer6i, and XML Publisher environment.
• 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.
• 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.
• 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, iReceivables and iPayables.