PROFESSIONAL SUMMARY:

• 12 years of Technical experience in analysis, design, development, enhancement, customization, troubleshooting, implementation and support of Oracle Application (EBS) projects.
• Experienced in 8 Implementation, 2 Upgrade and 3 support/enhancement projects in Oracle Applications (EBS) (R12, 11i).
• Strong Techno Functional experience in Purchasing, Accounts Payables, Account Receivables, Order Management, Fixed Assets, General Ledger, iExpense, Cash Management, Inventory, Costing, Work In Progress, Bills Of Material, Manufacturing, Service Contracts, Projects modules.
• Extensively worked on RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) components.
• Excellent proficiency in,
• SQL and PLSQL, Shell Script, Java Script
• XML Publishers, Oracle Reports and Forms
• Oracle Application Framework (OAF)
• Oracle Application Express (APEX)
• Workflow, Business Event, Alerts, AOL, API, UTL File, EDI
• Excellent understanding of Multi - org, MOAC features and Applications Object Library.
• Extensively worked on Confidential (Trading Community Architecture) and solved issues for Month End Close.
• Proficient implementation knowledge of Multibyte language, Multicurrency, Encryption (PGP / GPG), FTP, SFTP, PSFTP, Web ADI, AME, UDA, Tradesphere, LDAP, EDI.
• Experienced in XML Publisher Reports with PDF, EXCEL output using RTF, EXCEL, XSL-FO templates.
• Worked in Interface between multiple boundary systems (Essbase, Oracle DRM, SFDC, Workday, SAP, Siebel) Integrated with SOA and TIBCO middleware.
• Strong knowledge of Data Conversion including data extraction from 3rd party, transformation and loading (ETL). Processes using UNIX shell scripting, SQL, PL/SQL, SQL Loader, UTL files, APIs and Oracle Open Interfaces.
• Strong in performance tuning using Explain plan, TKPROF, Gather Stats and Indexing.
• Strong in Frontend Form / Page creation using Oracle FORMS, OAF and APEX. Having knowledge of Custom.pll customization, Form and OAF page Personalization.
• Modified seeded Workflows and created new workflows to implement new business flows.
• Using OAF, APEX, FORMS and Shell Scripting developed Customer Modules integrated with Oracle Apps and Common Framework for Bank Payment Files processing, Interface and Conversion Status Reporting, Automated interfacing files with Encryption and Decryption.
• Hands on experience in ADF development and migration.
• Used Business Events to handle workflow and custom event raising requirements during customization.
• Extensively used FNDLOAD, WFLOAD, XML Importer, Unix and SQL scripts for code migration.
• Working knowledge of Java concurrent programs.
• Extensive experience in CEMLI objects post upgrade from 11i to R12.
• Prepared Documents required in AIM methodology like FS Review, MD070, MD120, UTP etc.
• Having good knowledge of Testing, Unit Testing, Smoke Testing, Black Box Testing, Stress Testing, Integration Testing etc.
• Used various revision Control Systems like PVCS, RTC, etc. and Code Migration Tools like Kintana.
• Strong troubleshooting, bug fixing and problem solving skills.
• Experience in gathering requirements from business users, analyzing gaps, developing and designing business solutions.
• Possess good analytical, interpersonal and communication skills to effectively coordinate with business users, functional consultants, developers, DBAs, QA testers and other internal/external team members.
• Exceptional ability to master new concepts and ideas.
• Worked 24X7 with Oracle in solving Sev1 and Sev2 SRs.
• Worked with OMCS (Oracle Managed Cloud Service) for RFC creation and execution.

TECHNICAL PROFICIENCY:

Software Language: SQL, PL/SQL, XML, Shell Script, Java Script

ERP: Oracle Applications (R12 and 11i) Modules worked on: Inventory, Fixed Assets, Costing, Work in progress, Bills of material, Manufacturing, Purchasing, Account Payables, Account Receivables, Order Management, iExpense, Service Contracts, Projects, General Ledger, Cash Management.

Tools: / Framework: Sql Loader, Dataloader, Oracle Developer 2000 (6i, 9i, 10g), Oracle Workflow Builder, XML/BI Publisher, Sql Developer, Toad, JDeveloper, Oracle Application Framework (OAF), Application Development Framework (ADF), Oracle Application Express (APEX), SOA and BPEL (10g, 11g)

Databases: Oracle 9i,10g,11g,12c, Sql Server, Ms Access

Operating System: Windows, Dos, Ubuntu, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Lead Consultant

Environment: Oracle Apps (EBS) R11.5.10.2, R12.0.1, Database-11.2, 10.2, OS-Linux X86, Sun Solaries

Responsibilities:

• Working as Lead Consultant for enhancement of Oracle Apps 11i source systems involved in the oracle Confidential architecture implementation.
• Designed and Implemented Dun & Bradstreet real time REST API configuration and integration with Oracle MDM system.
• Implemented JSON features in oracle 10g database while the seeded oracle scope for JSON is 12c onwards.
• Performance tuning for custom PLSQL programs and seeded api / interface programs.
• Integration between SMP (Subscription Management Platform) and Oracle Receivables and General Ledger.

Confidential, Sunnyvale, CA

Senior Technical Consultant

Environment: Oracle Apps (EBS) - R11.5.10.2 and R12.2.5, Database-10g/11g, OS-Linux X86, BI Publisher, OAF, ADF, SOA, OBIEE

Responsibilities:

• Worked as Technical Consultant for supporting Oracle Apps 11i and R12.2.5 upgrade.
• R12 upgrade includes Inventory, Fixed Assets, Purchase Order, Order Management, Payables, Receivables, Cash Management and General Ledger modules.
• Working closely with business users & functional consultants for requirement gathering & analyzing the gaps.
• Participated in Quality Assurance testing before releasing for Product testing and UAT.
• Configured Blackline boundary systems with Fixed Asset and General Ledger data.
• Customized Create Accounting - Assets Exception report to run global.
• Modified GTRACK tool in OAF to automate completion of US and LOCAL GAAP closing jobs.
• Created new LDT migration script to meet migration time cutover during R12 upgrade.
• Customized User Provisioning tool in OAF for all Confidential regions.
• Created common file upload utility using OAF.
• Worked on performance tuning for custom OAF pages.
• Upgraded common Confidential FAST framework to auto generate user control OAF pages for Asset Category creation and FA book assignment. Automated Asset Category creation and assigning FA books.
• Enhanced Fixed Assets and General Ledger reports using XML Publisher,
• Enhanced interfaces using PLSQL procedures, UTL files, WSDL and connection based Procedural call.
• Worked on troubleshooting below workflows,
• Confidential Region control and assignment approval workflow
• Confidential User Provisioning access control approval workflow.
• Completed SAM (Streamline Asset Manager) project.
• Done asset interfacing with Blackline boundary systems.
• Worded on Oracle GRC (Governance, Risk and Compliance) implementation.
• Worked as solo responsible person for ADF and SOA deployment in UAT and PROD.
• Worked on troubleshooting and fixing of day to day code bugs and performance issues.
• Worked on MD050, MD070, MD120 and UTP documents for different deliverables.
• Worked with OMCS (Oracle Managed Cloud Service) and Confidential Cloud Services.

Confidential

Lead Consultant

Environment: Oracle Apps (EBS) R12.2.4, Database-11g, OS-Linux X86, BI Publisher, OAF, OBIEE, ODI, SOA

Responsibilities:

• Worked as Technical Lead Consultant for implementing Oracle Apps R12 which includes Inventory, Fixed Assets, Manufacturing, Work in Progress, Bills of Material, Costing, Purchase Order, Projects, Order Management, Payables, Receivables, iExpense, General Ledger modules.
• Managed Off-shore development team in design and development of RICEW components as per delivery tracker.
• Worked closely with business users and functional consultants for requirement gathering and analyzing the gaps.
• Responsible for prioritization, planning and management of technical development in Oracle EBS R12 with On-site, off-Shore model.
• Participated in Quality Assurance testing before releasing for Product testing and UAT.
• Configured Dunning Letter in Account Receivables as per the requirement.
• Created Web ADI integration for Employee data creation and update.
• Customized the Standard Cost Update program.
• Created below reports using XML Publisher,
• Job Operation Master report
• Customer Dunning letter report
• Customer Invoice report
• Purchase Order print report
• Project Expenditure detail report
• General Ledger reconciliation report
• VAT Summary and Detail report
• Build below interfaces using Plsql procedures, UTL files, WSDL and connection based Procedural call.
• Project Header/Task Details Extract Inbound Interface
• Project Expenditure Details Extract Inbound Interface
• Project User Defined attribute inbound interface
• Purchase Order Inbound Interface
• Customized below workflows,
• Invoice Approval Workflow
• Non-PO Project Invoice Account Generator
• Project Status Workflow
• Customized DRM interface through new OAF page, personalization and seeded Java concurrent program modification.
• Created common framework for status reporting, this is used among all the Interfaces and during conversion mock runs.
• Worked on performance tuning for custom Reports and Interfaces.
• Worked on troubleshooting and fixing of day to day code bugs and performance issues.
• Worked on MD070, MD120 and UTP documents for different deliverables.
• Worked 24X7 with oracle in solving Sev1 and Sev2 SRs.
• Worked with OMCS (Oracle Managed Cloud Service) for RFC creation and execution.

Confidential, Houston, Texas

Lead Consultant

Environment: Oracle Apps (EBS) R12.2.2, Database-11g, OS-Linux X86, BI Publisher, OAF, OBIEE, ODI, SOA

Responsibilities:

• Worked as Technical Lead for all the Conversions in Oracle Apps 11.5.9 to R12.2.2 Upgrade project.
• Upgradation of Inventory, Fixed Assets, Manufacturing, Work in Progress, Bills of Material, Purchase Order, Projects, Order Management, Payables, Receivables, iExpense, General Ledger modules were in scope.
• Managed Off-shore development team in design and implementation of RICEW components using AIM methodology.
• Total 46 conversions are developed and executed as a team until Production instance using Sql Loader, Plsql, APIs, seeded Open Interface approaches. Data extraction from legacy system was also part of conversion activities.
• Created conversion reporting dashboard in OAF.
• Worked closely with business users and functional consultants for requirement gathering and analyzing the gaps.
• Responsible for prioritization, planning and management of technical development in Oracle EBS R12 with On-site, off-Shore model.
• Designed, Developed and executed below conversions using Sql Loader, Plsql, APIs and Open Interfaces
• Employees
• Sub-Inventories
• Vendor Master
• Bank Accounts
• Manufacturing Part Number
• UOM conversion
• Open AR invoice
• Open Purchase Order
• PO Receipts invoice
• Open AP invoice
• Performed 4 conversion Mock runs and completed Production load with average 97% success rate.
• Created Web ADI integration for HRMS data, People, Assignment etc.
• Worked on performance tuning for custom PLSQL programs and seeded interface programs. Used custom Indexing on required table for faster processing. Scheduled Gather Stat on schema and tables as required.
• Worked on troubleshooting and fixing of day to day code bugs and performance issues.
• Worked on MD070, MD120 and UTP documents for different deliverables.
• Worked 24X7 with Oracle in solving Sev1 and Sev2 SRs.
• Worked with OMCS (Oracle Managed Cloud Service) for RFC creation and execution.

Confidential, Raleigh, North Carolina

Lead Consultant

Environment: Oracle Apps (EBS) R12.1.3, Database-10.2, OS-Linux X86, BI, D2k, OAF, OBIEE

Responsibilities:

• Worked as Technical Lead for implementing Oracle Apps R12 which includes Inventory, Fixed Assets, Manufacturing, Work in Progress, Bills of Material, Purchase Order, Projects, Service Contracts, Order Management, Payables, Receivables, iExpense, General Ledger modules.
• Managed Off-shore development team in design and implementation of RICEW components using AIM methodology.
• Worked closely with business users and functional consultants for requirement gathering and analyzing the gaps.
• Responsible for prioritization, planning and management of technical development in Oracle EBS R12 with On-site, off-Shore model.
• Implemented EDI payment gateway for various banks.
• Created below reports using XML Publisher
• Customized PO print report with new design
• Zebra Printer reports for label printing
• Customer Invoice Report
• Created below Extensions using Plsql and OAF
• Enabled new menus to lunch custom PO output - Solution provided by creating new OAF controller and multiple FORM personalization.
• Customized standard cost update program using custom hook
• EDI Reconciliation Reports framework in OAF
• Customized Packing Workbench in OAF
• Customized below Workflows,
• Modified COGS account generator workflow
• Modified Project Account generator workflow
• Requisition and PO Account Generator workflow
• Created below Interfaces
• Implemented EDI payment gateway
• Web ADI integration for Employee, Assignment data creation and update.
• Amex inbound interface for iExpense
• Validating AMEX credit card transaction data in iExpense
• Managing Bank Statement to Credit Management.
• Worked on performance tuning for custom PLSQL programs and seeded interface programs. Used custom Indexing on required table for faster processing. Scheduled Gather Stat on schema and tables as required.
• Worked on troubleshooting and fixing of day to day code bugs and performance issues.
• Worked on MD070, MD120 and UTP documents for different deliverables.
• Worked 24X7 with Oracle in solving Sev1 and Sev2 SRs.
• Worked with OMCS (Oracle Managed Cloud Service) for RFC creation and execution.

Confidential, Sunnyvale, California

Senior Technical Consultant

Environment: Oracle Apps (EBS) R11.5.10.2, R12.0.1, Database-9.2.0.6.0, 10.2, OS-Linux X86, Sun Solaries, BI Publisher, D2k, SOA/BPEL, APEX

Responsibilities:

• Worked as Technical Consultant for enhancement of Oracle Apps 11i and R12 source systems involved in the oracle Confidential architecture implementation.
• Integration of 3 Oracle Apps Systems and other third party systems using Fusion Middleware (11g). (Manufacturing (11i) + Quote to Order (R12) + MDM (11i) + Prospect and Customer(SAP) + Prospect (SFDC) + CRM (Siebel)
• Enhance the scope of Customer Data Hub in 11i and R12 systems
• Implemented Supplier and Product Data Hub and maintenance in 11i and R12 systems
• Implementation of multiple third party (Dun & Bradstreet, Trade Automation) auto validation logic into Manufacturing, Purchasing, Quote, Order Management, Payables and Receivables modules
• Implementation of Automatic data auditing between the different Oracle Application systems and Spoke systems.
• Provided Application support for manufacturing module in 11i system.
• Worked on performance tuning for custom PLSQL programs and seeded api / interface programs. Used custom Indexing on required table for faster processing. Scheduled Gather Stat on schema and tables as required.
• Worked on troubleshooting and fixing of day to day code bugs and performance issues.
• Worked on MD070, MD120 and UTP documents for different deliverables.
• Worked 24X7 with Oracle in solving Sev1 and Sev2 SRs.
• Worked with DBA team for code bundle creation and execution.

Confidential, Denver, Colorado

Senior Technical Consultant

Environment: Oracle Apps (EBS) R11.5.10.2, Database-9.2.0.6.0, OS-Linux X86, BI, D2k, SOA/BPEL, OBIEE

Responsibilities:

• As a Technical Consultant I was involved in Production support for Finance modules.
• Solved the issues during month end period closure for Account Receivables, Payables etc.
• Gave a critical solution for non dropping connection between AIX server and Windows server of Tradesphere. Developed a Batch job to replace first connect which uses psftp.
• Provided Technical Solution for,
• Replacing First Connect by batch job between AIX server and Windows server.
• Integration of XML publishers report with OAF page.
• Working closely with Siebel and Fusion team on Interfacing data and data issues.
• Provided solution for Invoice Printing which completes 40 hrs job in 1 hour. Introduced parallel processing of Invoices to be print and copied to Filenet server for backup.
• Validating AMEX credit card transaction data in iExpense.
• Managing invoice Notification and Dunning Letter activities to customers.
• Validating Citi bank global payments in 54 OUs.
• Managing Bank Statement to Credit Management.
• Validation of HR data through LDAP.
• Managing iExpense and payroll data to GL.
• Worked on new change requests (CR).
• Leading RFS offshore team on new enhancements and new developments.
• Priorities the tickets and work as per priority.
• Zero escalation with proper status update to Client.

Confidential, Denver, Colorado

Technical Consultant

Environment: Oracle Apps (EBS) R11.5.10.2, Database-9.2.0.6.0, OS-Linux X86, BI, D2k, SOA/BPEL, OBIEE

Responsibilities:

• Worked on various RICEW objects in this Oracle Apps 11i implementation project. Inventory, Manufacturing, Work in progress, Bills of material, Purchasing, Payables, Order Management, Receivables, Service Contracts, Projects, General Ledger modules were in the implementation scope.
• Prepared documents like FS Review, MD070, MD120, UTP, Code Bundle etc.
• Components are developed using Oracle FORMS, OAF, Workflow, PLSQL, API, Reports, XML Publishers, Shell Scripts, Form Personalization.
• Responsible for the Extensions, Reports to be delivered. Also played an important role in Interface (EDI, SOA/BPEL) and conversion.
• Worked on some B2B related Fusion Middleware objects for Interface.
• Some important Extensions Developed
• Common Framework for Interface and EDI Reconciliation Reports framework in OAF.
• Packing Workbench for star and non start items as per the business requirement in OAF.
• Dashboard for viewing all the data of OM, PO & WIP module (Interlinked & Standalone) in one FORM from nine different Base FORMs using Form Personalization.
• Multi Language Framework for supporting all the multi language translation of the Project.
• Customized the Standard Cost Update program of base apps.
• Common email sending Concurrent Program is made which can attach different type of files, can write the email body in different formats (text, html etc) and is being used by the whole project where ever email sending requirement is present.
• Build the Payment Format program for Citi Bank for 54 unique country and currency combinations with a Common Framework.
• Common FTP program is made for all the inbound and outbound interfaces as a Concurrent Program. This development follows the ldt and lct structure and made in Shell Script.
• Customized some Account Generator workflow such as COGS, Purchasing, Project Accounting etc.
• Using customization Auto Accounting is bypassed during AR Invoice creation from various sources.
• Mapping of Chart Of Accounts of Legacy system with Oracle COA.
• Customized the Billing of Bottom Line Contract at the time of reconciliation of Service Contract.
• Below Reports are developed
• Huge numbers of reports are developed using XML Publishers.
• Standard Purchase Order report is customized using XML, XSL-FO, Java Concurrent Program, PLSQL, Views for all type of Purchase Orders.
• Bursting is used in Reports for printing purpose using XML, Java Class File, Java Concurrent Program.
• Zebra Printer reports are developed.
• EDI Reconciliation reporting framework.
• Below Interfaces are designed and developed
• Outbound Interface for all the payment files to Citi Bank for 54 different Country & Currency Combinations.
• PO Acknowledgement Inbound Interface.
• UPS Freight Invoices Inbound Interface.
• UPS outbound interface using B2B Fusion Middleware
• Amex inbound interface for iExpense.
• Credit Management inbound interfaces to receive bank statements.
• Mentored the Extension and Report team members.
• Done review of developed objects.
• Gave & Tech Talk to the project associates on
• Workflow, Forms, Reports, XML Publishers
• API, Value Set, Concurrent Program, Business Event
• Order to Cash cycle, Procure to Pay cycle
• Did BCP Testing for the Project and Support the project in Internal SME and External audit.
• Support the project team to get a good rating in PMR.
• Contributed 6 technical documents for Oracle FORMS, XML Publishers and some Common Frameworks to IBM GBS assets.