SUMMARY

• A software professional wif 8+ years of experience in teh areas of Analysis, Design, Development, Testing, Implementation, Upgrade and Production support of Oracle Applications Oracle E - Business Suite 11i/R12/Oracle Fusion
• Extensively worked on inbound / outbound interfaces and conversions across all teh modules of Oracle Applications including SCM(OM, INV, PO), FIN(AP, AR, GL), PA(Project Accounting) and experience in Oracle Demantra.
• Experience in working wif clients across all geographical locations including NA, LA, APAC (Asia Pacific) and Middle east regions
• Experienced at Analysis, requirement gathering, Designing, Developing and Testing interfaces in Oracle Fusion Middleware using SOA Suite 10g/11g, OSB, BPEL
• Experience in Oracle ADF
• Attended trainings and possess knowledge on Oracle Managed Cloud Services(OCMS)
• Experience in creating procedures, packages, triggers, cursors, functions, performing collections and workflows
• Extensive experience customising Oracle E-Business suite application modules, involving teh development of RICE W (Reports, Interfaces, Conversions, Extensions, Workflows) components, Oracle Forms and Reports, AOL, custom PLL, Forms personalization and Alerts.
• Experience of two full life cycle implementations in EBS R12
• Well versed in Order to Cash, Procure to Pay business flows and integrating custom workflows.
• Worked in 11i to R12 migration projects and R12 production support, possess working knowledge in both environments
• Experience in ETL data processing for Data Extract, Transformation and Load patterns
• Strong experience in requirement gathering and creating MD50 and MD70 design documents
• Possess sound functional knowledge on Order Management (OM), Pricing, Purchasing(PO), Accounts Payables (AP), Accounts Receivables(AR), iProcurement, iReceivables, iPayements, and Inventory (INV)
• Experience in creating shipping labels using Nice labels tool.
• Worked on LA rules and Form Personalization
• Experience in performance tuning and performing Gap Analysis
• Experience in Multi Org, Multi Currency Environments
• Experience in using Oracle open interfaces and Public API
• Strong experience in working wif SOAP Web services, XML, XSD.
• Experience in creating services using JCA Adapters like File, FTP, Database links and BAM Adapters.
• Possess knowledge on SOX Compliance and Audit process
• Experience in creating and following up on SR raised wif Oracle and application of patches when required
• OPN certified in Oracle Purchasing
• Extensive knowledge and well versed in UNIX, Shell scripting
• A highly motivated individual wif strong communication, presentation and interpersonal skills, can work individually even in high pressure situations
• Experience in leading and managing small teams also an excellent team player.
• Strong experience of performing IPMS & IQMS activities

TECHNICAL SKILLS

ERP Skills: Oracle R12/ 11i/10g, Oracle Fusion Release 7

Modules: Application Object Library(AOL), Inventory(INV), Bill Of Materials(BOM), Order Management, Purchasing(PO), Pricing, Accounts Payables(AP), Receivables(AR), General Ledger(GL), Fixed Assets(FA), Oracle Demantra

Lannguages: SQL, PL-SQL, UNIX Scripting

Web Technologies: HTML, XML, JSP

Software Tools: Jdeveloper,, Forms 6i/10g, Reports 6i/10g SQL*LOADER, PL/SQL, SQL*Plus, OBIEE, XML Publisher reports, Nice Label, Microsoft Sharepoint Kintana, UC4, SSH - Client, and BMC Remedy.

Development Tools: SQL*Plus,SQL*Developer, PL/SQL Developer, JDeveloper(9i, 10g, 11g), TOAD, Tortoise SVN

Database: Oracle Database (9i, 10g, 11g), SQL server 2000

Fusion Middleware: SOA Suite 10g/11g, BPEL, OSB wif File, FTP, DB and BAM Adapters

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle SCM Techno Functional Consultant

Responsibilities:

• Managing teh technical team and acting as point of contact between client and development team.
• Acting as a point of contact between teh client and OCMS team to plan wif teh migration to OCMS
• Analysing requirements and communicating wif client on teh functional design and specification.
• Assessing teh impact to teh existing interface and redesign according to teh OCMS structure
• Working wif teh team for high and low level functional design and to overview teh technical design
• Worked on data conversion for items, suppliers from external legacy system to Oracle Applications using Open interfaces and Oracle Public APIs
• Creation and management of approved supplier list and performing all necessary setups
• Creating and maintaining UOM, items and item categories
• Setting up planning methods and maintaining descriptive and key flexfields
• Setting up of sourcing rules, approval groups and approval hierarchies
• Involved in unit testing and system testing and also responsible for preparing test scripts for teh system testing
• Responsible for performance tuning
• Ensure dat all coding complies wif Enterprise Standards and adheres to development guidelines.
• Ensures dat all teh assigned deliverables are completed on time and wif impeccable quality
• Provide timely support in troubleshooting defects and providing resolutions
• Support production deployment and project go-live tasks
• Actively participate in team meetings and collaborates wif other team members to carry out project deliverables

Environment: Oracle Applications Release 12.1.3 (INV, OM, PO, AP, iProcurement, Costing), PLSQL Developer, Tortoise SVN, Putty, SharePoint, Oracle Reports, Workflow builder.

Confidential, Miami, FL

Techno Functional Consultant

Responsibilities:

• Prepare MD70 (design document) for teh interfaces to be developed
• Co-ordinate wif SOA development team for data mapping
• Configuring teh SOAP requestor and BPEL along wif SOA team to ensure teh data mapping from flat files or data in DB of legacy system using DB links to teh corresponding columns of staging tables in oracle systems
• Developing procedures, packages, functions and alerts to develop teh required interfaces and conversions for supplier, sites and bank accounts
• Worked on Conversion of Suppliers, Items, supplier sites
• Develop various purchase order and receipt interfaces to import orders from legacy systems to teh multiple OUs to maintain a standard pattern across various OUs
• Customised teh interfaces according to teh requirement of teh different operating units
• Perform collections and additional SLA rules for revenue and liability accounting
• Developed various reports
• Cancelled purchase order report
• Encumbrance detail report
• Expected receipt report
• Perform data processing from various entities using ETL tool Talend
• Developed conversion packages to perform item, PO conversions
• Prepare MD120 set up document and performing teh necessary functional setups in development and test instances
• Developing a common reusable interface for error logging and re-running teh program for errored records
• Preparing teh unit test plan and test cases
• Testing teh interfaces along wif SOA team
• Created teh various objects for migration and migration documents
• Migrate teh solutions to higher instances and test teh functionality
• Provide support for UAT
• Check and resolve teh technical issues as and when highlighted by customer during review

Environment: Oracle Applications Release 12.1.3 (SCM, PO, AP, AR, GL, iProcurement, EBTax), Oracle 11g, PLSQL Developer, SQL Loader, Tortoise SVN, Putty, SharePoint, Oracle Reports,Talend, Workflow Builder, UNIX, Shell Scripting, SOA Suite 11g, BAM Dashboard

Confidential, Schaumburg, IL

Techno Functional Consultant

Responsibilities:

• Engaged in Requirement gathering (BRD), Solution Design (Process Documents) for Demantra and Advanced Supply Chain Process.
• Involved in global design development and interacted wif huge user group wif multi-dimensional business requirements
• Have worked on Integrations of EBS wif VCP for Demand and Supply and to Collect teh generated forecast from Demantra
• Configuring teh application based on solution design, performed gap analysis and designed workaround solutions
• Trained teh client’s super users and users on teh application and conducting pilot testing, integrated testing, design validation.
• Functional documentation for Configurations (Setups), User Training Documents and Customization Documents. Experience in teh preparation of Standard Operating Procedures specific to Client’s business process wif screen prints
• Conducted CRP & SIT sessions for teh site additions and cutover was successfully completed for multiple sites.

Environment: Oracle Applications Release 12.1.3(SCM, Demantra), PLSQL Developer, Kintana, EDI Application

Confidential, Libertyville, IL

Oracle Techno Functional Consultant

Responsibilities:

• Performing teh functional setups in development instance for teh creation of new legal entity
• Preparation of technical design documents
• Development of interfaces, customization, reports and workflows similar to teh existing legal entity
• Configured and enhanced various workflows to suit teh business needs of new legal entity
• Performing UTP and integration functional testing
• Worked extensively on Oracle financial standard APIs
• Migration of teh components to higher instances
• Post production support

Environment: Oracle Applications 11.5.10(AP, AR, GL), PLSQL Developer, Oracle Reports 6i, Workflow Builder, UNIX, Shell scripting, Putty, Kintana

Confidential, Schaumburg, IL

Oracle Techno Functional Consultant

Responsibilities:

• Involved in requirement gathering for teh enhancement to available interface
• Preparation of technical design documents
• Developing teh interface as per new business needs
• Performing teh buyer setups for multiple users
• Performing teh complete business flow from creating requisitions through invoice.
• Configured and implemented teh drop ship order entry model, interfacing wif purchasing module by direct shipment of goods from teh supplier and invoicing teh customers while teh ASN is sent by supplier
• Entering multiple purchase orders wif different conditions and completing teh payment process to check if teh values are reflected in teh supplier database
• Coordinating wif business and suppliers to ensure teh complete functionality of EDI
• Preparation of test cases and performing UTP.
• Involved in data preparation for CAT
• Preparation of transition documents to be used by suppliers and post production support
• Preparation of user manual for GSSM interface for use by more TEMPthan 200 suppliers
• Attended training wif hands-on experience in ETL process and tools.

Environment: Oracle Applications 11.5.9 Purchasing, Oracle 10g, PLSQL Developer, Kintana, EDI Application, UNIX

Confidential, Schaumburg, IL

Oracle Techno Functional Consultant

Responsibilities:

• Involved in understanding teh business requirements and preparation of low level design documents
• Prepared technical design document as per teh functionality
• Designed and developed custom component
• Schedule Sharing Interface
• Interface to share details on inventory and orders from teh oracle application to suppliers
• Designed dis everyday interface to extract details on items, sales and purchase orders on teh basis of business needs.
• Write a flat file wif teh extracted data to be ftped to teh destination server
• Shipping Label
• Developed an interface to extract shipment details of each order to be shipped
• Design a label wif barcodes encoding teh extracted data using teh nice label software
• Worked on item and supplier conversion from legacy system to load into Oracle system
• Creation of items, sales and purchase orders and invoices to develop and test teh schedule sharing interface.
• Worked on demand request report fallout report
• Involved in fine tuning teh custom programs like shipment load program, shipment extract program, refresh item materialised view and BOM effectively
• Prepared test cases for unit testing
• Performing UTP and preparation of test documents
• Preparation of migration documents
• Migration of codes to higher instances and maintain teh document version in DOORS
• Provided Post production support and knowledge to support teams

Environment: Oracle Applications Release 12.1.3(SCM, INV, OM, PO, AP), Oracle 11g, PLSQL Developer, TOAD, Kintana, Putty, SSH client, Oracle reports, Nice Label, DOORS, Workflow Builder, UNIX

Confidential, Libertyville, IL

Technical Consultant

Responsibilities:

• Involved in job scheduling, monitoring, support and maintenance activities.
• Present teh weekly status report on open and pending tickets to Client and discussing teh solutions for L3(Enhancement) tickets
• Working wif global users including APEC, EMEA, LA and NA to aid wif teh issues in their demand forecasting and reporting issues
• Work closely wif teh regional users to halp wif their demand planning and generating reports
• Run OneODP program to convert teh forecast to demand
• Planning, scheduling and monitoring month end, quarter end and annual closure special MRP runs and producing teh forecast reports and send teh files to Business team
• Performed full and partial collections from Advanced Supply Chain Planner responsibility
• Responsible for running weekend cycle reports
• Register and maintain concurrent requests, request sets, responsibilities, menus.
• Maintain value sets, DFF and profile options
• Have actively participated in fixing business critical issues wifin teh SLA and theirby avoiding any business impact.
• Work on L2, L3 tickets and provide timely resolution
• Worked on interfaces to enhance their functionality as per business needs
• Automating teh job scheduling and submission using UC4 application
• Supporting teh application update to Demantra

Environment: Oracle Applications 10g, 11i(ODP-Oracle Demand Planning, ASCP- Advanced Supply Chain Planning ), Toad, PLSQL Developer, BMC Remedy, Kintana, Putty, UC4.