SUMMARY:

• Over 11+ years of Extensive experience in Analysis, Design, Development, Testing, Implementation, Supporting and upgrading Oracle Applications/EBS 11i, R12 modules.
• Extensive experience in Procure to Pay and Order to Cash business flows.
• Sound Technical/Functional knowledge in Oracle Financials (AP, AR, CM, FA & GL), Supply Chain Management ( SCM ) including Order Management ( OM ), Shipping ( WSH ) and Inventory ( INV ), Purchasing ( PO ), WIP, BOM, WMS, HRMS (Payroll, SSHR, iRecruitment, Learning Management, OTL) and AOL .
• Extensive experience in TCA architecture, MOAC, IBY, SLA, Business Events .
• Extensively worked on Oracle back - end programming and Front-end development using tools like Oracle Forms 10g/6.0, Oracle Reports 10g/6.0, XML/BI Publisher, OBIEE, Discoverer, WED ADI, Business Events, Oracle Alerts, Forms Personalization, Custom.pll, Performance Tuning, SQl, PL/SQL, SQL Developer, SQL*Loader, TOAD.
• Extensive experience in RICEW/CEMLI components ( Reports, Interfaces, Conversions, Extensions and Workflow ), OAF, OBIEE and knowledge on Middleware SOA/BPEL .
• Experience in debugging, testing and deploying the applications, designed and developed interactive GUI screens and reports using oracle forms/reports, creating LDT files and creation of SR with Oracle Support, obtaining patches from oracle support and applying patches with coordination of Apps DBA.
• Strong programming experience in creating Procedures, API’s, Packages, Functions, Triggers and other database objects using SQL, PL/SQL, UTL File and UNIX etc.
• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency by using Explain Plan and TKPROF
• Experience in Application Object Library ( AOL ) such as creating custom responsibilities, custom menus, menus exclusion, form functions, Concurrent programs, creating value sets, profile options, messages, look ups, list of values, Flex Fields etc.
• Experienced in preparing Technical specs ( MD070 ), Functional Specs ( MD050 ), Installation Documents ( MD120 ), User Training Documents, Test procedures documents ( TE020 ) and Conversions ( CV060 ) using SDLC/AIM & Agile methodology.
• Excellent in team collaboration (Onsite-Offshore), quick adaption and problem solving with good communication and interpersonal skills.
• Proven ability to lead and manage multiple end-to-end project implementations.

TECHNICAL SKILLS:

Oracle Applications (EBS): Oracle Apps 11i, R12x

Financials: GL, AP, AR, CM, FA, PA, SLA

SCM: PO, OM, INV,OPM,WSH, BOM, WIP, Pricing, WMS

HRMS/SSHRMS: HRMS, PAYROLL, OAB, OTL & SSHRMS

Development Tools Oracle Workflow, WEBADI, Reports 6i & 10g, XML/BI Publisher, Discoverer, Oracle Forms 6i, 10g, Oracle JDeveloper 10g/11g.

Middleware/Framework: SOA/BPEL, OAF

Database: Oracle 9i, 10g, 11g and 12c

BI & ETL: OBIEE 10g,11g and Informatica power center 8.6.1

Utilities: SQL * Loader, SQL * PLUS, TOAD, Putty, Winscp

Languages: C, C++, Java, SQL, PL/SQL, XSL and XSLT, Shell Script

Operating Systems: Windows XX and Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential

SR Technical consultant

• Developed various batch processing Interfaces in Finance (Customer Conversion, AR/AP Invoices, AR receipts) Modules and SCM (Item Import, on hand Quantity/Lot/Serial no, Requisitions, Purchase Order).
• Developed a custom API to split the Delivery Lines (WSH) based on Customer Demand.
• Developed XML Bursting Program to FTP the GL Balances data in to third party financial system.
• Created a several Drill Down reports from GL TO AP/AR by using SLA.
• Customized COGS workflow as per business requirement.
• Consumed GOOGLE API’s to calculate the distance between two locations which will be used in Shipping module for transportation calculation.
• For RMA orders, restricted return reason for few users by using forms personalization.
• Developed Several RICE/CEMLI Components in PO, OM, AR, AP and INV.
• Extensively used Standard API’s of OM, INV, HRMS, PO, AP & AR Modules for various requirements.
• Responsible for creating Alerts, RDF Reports, BI Publisher Reports in different modules.
• Responsible for preparing MD70, CV60, TE20 and MD120 documents.
• Developing functions, procedures and packages for the new and existing components.
• Responsible for creating LDT files for concurrent programs.
• Providing the production support to the business users.

Confidential

Tech Lead

• Developed various batch processing Interfaces in Finance (Customer Conversion, AR/AP Invoices, AR receipts) Modules and SCM (Requisitions, Purchase Order).
• Developed a Custom Concurrent program to update the PO details by using API PO CHANGE API1 S.
• Created a several Drill Down reports from GL TO AP/AR by using SLA.
• Responsible to send Custom AR Invoice detail report to the customer by using bursting technology.
• Developed Several RICE/CEMLI Components in PO, OM, AR, AP and INV.
• Developed SOAP services to run the BI Publisher reports from Oracle EBS and Legacy Applications.
• Developed a custom workflow to approve the AP on hold invoices.
• Extensively used Standard API’s of OM, INV, PO, AP & AR Modules for various requirements.
• Responsible for creating Alerts, RDF Reports, BI Publisher Reports in different modules.
• Responsible for preparing MD70, CV60, TE20 and MD120 documents.
• Developing functions, procedures and packages for the new and existing components.
• Responsible for creating LDT files for concurrent programs.
• Providing the production support to the business users.

Confidential

Tech Lead

• Partner with Other vendor teams, business team to identify and remedy key issues introduced by upgrade.
• Retrofitted/Re-engineered Custom CEMLI objects of 11i
• Reviewed code generated by other developers
• Proactively manage changes in project technical scope, anticipate potential issues, and take responsibility for their resolution.
• Identify and resolve issues and conflicts within the technical application development team.
• Work closely with technical and business project stakeholders on an ongoing basis.
• Development of New CEMLI’s and Participated in Continuous Improvement activities.

Confidential

Tech Lead

• Responsible for Development and maintenance of several Oracle applications Interfaces/Conversions like (Customers, AR Transactions and Receipts) (Data Integration between SIEBEL to Oracle ERP).
• Designed and developed several Customized XML/BIP/RDF reports.
• Implementation and supporting of AR Receipts/Transactions automation (SIEBEL to ERP system).
• Preparation of MD070, TE020 and CV060 Documents.
• Involved in end to end custom module development of Managing Pensioners by using OAF.
• Responsible for Bug Fixing and Technical Design.
• Responsible for Data extractions as requested.
• Development of several Oracle procedures, functions and packages for different requirements.
• Development of several Alerts (Via Email) for different requirements.
• Responsible for monthly data load activities from Siebel to Oracle ERP.
• Development of several BI publisher reports for SIEBEL application.

Confidential

Sr Technical Consultant

• Responsible for Managing the CEMLI/RICE development team.
• Create business process flows and implementing Purchasing, Payables, Inventory and Receivables Modules on Oracle EBS
• Lead for all CEMLI/RICE components
• Involved in gathering client requirements
• Provide estimates for all technical components
• Preparation of data Conversion Strategy from legacy to oracle database as per the client standards
• Involved in negotiation of project estimates
• Developed several interfaces like AR Invoices, AP Invoices by using oracle API’s.
• Development and update of technical design/migration documents MD070s and MD120s, CV060s.

Confidential

Sr Technical Consultant

• Developed several complex reports by using Oracle Business Intelligence Publisher for Different Modules.
• Designed, developed and customized various Reports in AR, AP, GL, INV, PO, HRMS & SSHRMS using Oracle Reports Builder and XML.
• Involved in Bug Fixing and technical design.
• Preparation of MD070, CV060, TE020 and MD120 Documents.
• Custom Alert Development and Business Events
• Developed data conversions/Interfaces for several modules.

Confidential

Sr Technical Consultant

• Designed, developed and customized various Reports in AR, AP, GL, INV, PO, HRMS & SSHRMS using Oracle Reports Builder and XML.
• Developed Custom forms for Projects module and Integrated to standard tables by using API’s
• Involved in Bug Fixing and technical design.
• Preparation of MD070, CV060, TE020 and MD120 Documents.
• Custom Alert Development and Business Events
• Developed data conversions/Interfaces for several modules.

Confidential

Sr Technical Consultant

• Created Interactive Dash boards with charts, tickers, prompts, BI Gauge views, graphs, view selector view etc.
• Build new Subject Areas, Fact, Dimensions and Hierarchies.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created Mappings for new subject areas and solved different bugs in existing Mappings.
• Solving Daily Load Issues.
• Designed, developed and customized various RICE Components in AR, AP, GL, INV, PO, HRMS & SSHRMS
• Involved in Bug Fixing and technical design.
• Preparation of MD070, CV060, TE020 and MD120 Documents.
• Custom Alert Development and Business Events
• Developed data conversions/Interfaces for several modules.

Confidential

Technical Consultant

• Designed, developed and customized various Reports in AR, AP, GL, INV, PO, HRMS & SSHRMS using Oracle Reports Builder and XML.
• Actively Involved in Inventory, BOM, Purchasing, AP and AR Interfaces.
• Involved in Bug Fixing and technical design.
• Preparation of MD070, CV060, TE020 and MD120 Documents.
• Post Production Support.
• Developed several CEMLI/RICE Components.