PROFESSIONAL SUMMARY:

• 13.7 years of experience with last 11.7 years working as Oracle Techno/Functional in Oracle Applications E - Business Suite SCM/Financials/Manufacturing/OTM/GTM modules Release Fusion R12 Cloud Financials, EBS R12(12.1.3,12.2.4), 11i (11.5.10.2), OTM 6.3.X,6.4.X(Cloud) can work independently as well as in a Team Environments.
• Strong Techno Functional Consultant in implementing, customizing, supporting and maintaining Oracle Applications /Oracle e-Business Suite R11i/R12 .The main concentration being in modules: Order Management (OM), Core Contracts (OKC), Service Contracts (OKS), Inventory (INV), WSH, WMS, MSCA(Mobile Supply Chain Application), iSupplier, iProcurement, BOM, WIP, ASCP, Oracle Transportation Management(OTM), Global Trade Management(GTM), Oracle Customer Data Hub (CDH), Oracle Supplier Data Hub(SDH), MRP/MPS, Oracle Account Payables (AP), Oracle General Ledger (GL), Fixed Assets (FA), Oracle Cash Management (CM), Oracle Purchasing (PO), Project Accounting, Time and Labor, Trading Community Architecture (TCA), Application Object Library (AOL), System Administration and Workflow.
• Responsible for Requirements gathering, Systems and Gap Analysis, Designing, Development, Implementation, Customization, Enhancements, Testing and Implementation of Oracle SCM/Financials/Manufacturing R12, 11i (11.5.10.2) Standard Applications Modules and Customized Applications in Oracle Applications Environment. Complete understanding of Software Development Life Cycle Processes.
• Experienced in Global Instance implementation, Multi-Org, Multi-Currency & Multi-Lingual implementations and support
• Configured & customized modules Oracle Purchasing, iProcurement, Inventory, Order Management, Approvals Management Engine (AME), XML Gateway, Sourcing, iSupplier Portal, Oracle Supplier Network, Application Developer, Application Object Library, e-Commerce Gateway & System Administrator.
• Proficient in implementing, supporting and maintaining Procure to pay (P2P) process and Quote to Cash (Q2C) cycles, Supply Chain, Financial, Manufacturing and Distribution Modules.
• Implementation and Support Experience in Oracle Customer Data Hub (CDH) and Trading Community Architecture (TCA).
• Competent in full understanding of the functionality of core Oracle Financial Modules (GL, AP, AR, CM, FA, I-Proc, I-Exp) and their interplay in the application set-ups and overall accounting structure of an organization with its sub organizations.
• Experience in analysis, design, build and test of Oracle Application Framework (OAF).
• Expertise in using Oracle 8i/9i/10g and 11g databases.
• Experience in designing web pages through Oracle Application Framework (OAF) using Jdeveloper 9i, 10g, 11g and 12c.
• Experience in designing and developing Mobile applications using Application Development Framework (ADF) using Jdeveloper 11g and 12c.
• Expertise in SQL and PL/SQL programming to develop stored procedures, functions, packages and triggers.
• Extensive experience in Design, Development and Testing of Oracle Reports/Oracle Forms.
• Very good experience on Oracle Service Oriented Architecture (SOA) and Business Process Execution Language (BPEL).
• Study of current business processes, future business flows, connectivity with 3rd party applications if any and identification of gaps and workarounds.
• Business requirement mappings for INV, OM, WSH, WMS and MSCA
• Designing Oracle Applications Inventory and operating structure of client organization (multi-org structure)
• Setup of Inventory, Order Management, Warehouse Management Systems and Mobile Supply Chain Application
• Data migration from legacy systems using APIs and Open Interfaces.
• Worked in multiple Integrations using Oracle Advanced Queuing.
• Implementation and Support Experience in OTM/GTM Modules integration with Oracle Application Modules.
• Worked in SOA Integration Project, where SOA integration replacing the existing TIBCO integration.
• Strong experience and expertise in OBI/XML and BI Publisher  and Form Personalization's
• Worked with Concurrent programs, PL/SQL API's
• Expertise in Code Migrations using KINTANA tool
• Experience in supporting Sabrix Tax Engine
• Experience in Java Programming (Servlets, JDBC, JSP, Web Services)
• Well versed with AIM Methodology and documenting the work done in a well-fashioned manner.
• Worked with Oracle Utilities like SQL*Loader, UTL File, Toad, Putty and other utilities like SQL developer and data Studio.
• Ability to manage time spent on multiple projects to meet deadlines. Ability to work independently and as part of a team.
• Excellent analytical, presentation, and communication skills. Strong logic, solid business acumen, Strong leadership, facilitation and organizational skills
• Technical leadership with responsibility for delivering technical services and delivery of Quality data on time. Act as a technical liaison with project team members and managers to drive the Technical aspects of project delivery.
• Writing and maintaining Technical Specification document MD70 and Functional Specification document MD50.
• Ability to effectively gather and refine report requirements from Users and Management and give appropriate attention to details. Proficient troubleshooting skills.

TECHNICAL SKILLS:

ERP: Oracle modules like OM, INV, BOM, WIP, ASCP, WSH, WMS, OTM, GTM, Quoting, AP, PO, FA, GL, CM, OPA, T&L, TCA, CDH, SDH, MRP/MPS, MSCA, Oracle Applied Technologies like Workflow, AOL, System Administrator, Oracle Applications 10.7, 11.0.3, Oracle Apps 11i (Versions 11.5.7, 11.5.9, 11.5.10, 11.5.10.2, R12), Oracle EBS R12(12.1.3, 12.2.4), Oracle Fusion Cloud Financials

RDBMS: Oracle 8i/9i/10g/11g

Tools &Technologies: Oracle Application Framework (OAF), Demantra 7.1.1, Jdeveloper 9i/10g/11g/12c, Oracle Developer (Forms 6i/9i, Reports 6i/9i), Java, HTML, XML, Brio, Optio, Oracle Workflow 2.5/2.6, Toad, Putty, SQL Loader, SQL Developer, KINTANA, SOA Suite, BPEL Process, Application Development Framework (ADF), ADF Mobile, XML/BI Publisher

Operating System: Solaris, MS Windows (9x, NT, 2K, XP, 7, 8x), Linux and UNIX.

Languages : SQL, PL/SQL, UNIX Shell Programming, JAVA

Other Software : CVS, ARCS, KINTANA, StarTeam.

PROFESSIONAL EXPERIENCE:

Functional Consultant

Responsibilities:

• Provided Training to the Internal Team for Oracle Fusion Cloud Financials on modules GL, AP, AR, FA and CM.
• Analyzing the As-is business processes & Functionality in Data Architecture point of view.
• Setup configurations for POC in Oracle Fusion Cloud Financials based on the existing Business processes.
• Providing detail training to the users about the functionality flow and administration tasks.
• Experience with application design and development from business requirements analysis through implementation in Oracle Fusion Cloud Financials including but not limited to workflow Automation Agents, Web ADI, ADFBDI, Excel sheet templates for Rapid Implementations, Journals, GL Daily Rates, Invoices, Payments.
• Oracle Fusion Cloud Financials implementation of new application implementations/upgrades and application enhancements.
• Hands on experience with triage of day to day Oracle Finance systems issues and providing resolution on complex issues.
• Generate Reports using BI Publisher.
• Writing Unit Test cases and testing after completion of the Object.

Environment: Oracle EBS 11.5.10, Oracle Fusion Cloud Financials Release 12, BI Publisher, Oracle11g, UNIX, Toad, SQL Developer.

Oracle OTM/GTM Techno - Functional Consultant

Responsibilities:

• OTM Expert, both Functionally and technically (Setup * configuration, shipment management, rates, master data, bulk planning parameters, user configuration, screen set development, SQL queries, and working with CSV & XML files).
• Setup the Master Data for the scenarios provided by the Client for the requirement in POC.
• Configuring the OTM Cloud Instance for the Scenarios Direct Shipment, Multi-Stop Shipments, Multi-Leg Shipments and Crosdocks, Ocean Shipments.
• Providing detail training to the users about the functionality flow and administration tasks.
• Experience with application design and development from business requirements analysis through implementation in Oracle Transportation Management (OTM) including but not limited to workflow Automation Agents, Out XML Profiles, Integration xml templates for Release, TransOrder, PlannedShipment, TenderOffer, TenderResponse as well as ShipmentStatus.
• OTM implementation of new application implementations/upgrades and application enhancements.
• Hands on experience with triage of day to day OTM systems issues and providing resolution on complex issues.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• OTM/GTM Configurations, Agent Automations, Interface Programs, ITM Configurations.
• OTM Rate/Route Upload/Download templates - Experience in Promote-to-Production (Change Migration process) functionality.
• Customizing look and feel of OTM to fit Client Business requirement.
• Generate Reports using BI Publisher and migrated to OTM.
• Configuring OTM, transportation planning and Modeled OTM scenarios.
• Configuring GTM, including trade classification, restricted party screening, license and document determination and management.
• Writing Unit Test cases and testing after completion of the Object.

Environment: Oracle OTM Cloud 6.4.2, Oracle GTM, BI Publisher, Oracle Application framework, Oracle SOA, Jdeveloper11g, Solaris, Oracle11g, Developer Suite 10g, UNIX, Toad, SQL Developer.

Oracle OTM/GTM Techno - Functional Consultant

Responsibilities:

• OTM Expert, both Functionally and technically (Setup * configuration, shipment management, rates, master data, bulk planning parameters, user configuration, screen set development, SQL queries, and working with CSV & XML files).
• Experience with application design and development from business requirements analysis through implementation in Oracle Transportation Management (OTM) including but not limited to workflow Automation Agents, Out XML Profiles, Integration xml templates for Release, TransOrder, PlannedShipment, TenderOffer, TenderResponse as well as ShipmentStatus.
• OTM implementation of new application implementations/upgrades and application enhancements.
• Hands on experience with triage of day to day OTM systems issues and providing resolution on complex issues.
• Experience in OTM Network Routing, PC Miler and SMC Rateware preferred.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• OTM/GTM Configurations, Agent Automations, Interface Programs, ITM Configurations.
• OTM Rate/Route Upload/Download templates - Experience in Promote-to-Production (Change Migration process) functionality.
• Customizing look and feel of OTM to fit Client Business requirement.
• Generate Reports using BI Publisher and migrated to OTM.
• Configuring OTM, transportation planning and Modeled OTM scenarios.
• Configuring GTM, including trade classification, restricted party screening, license and document determination and management.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Report status of ongoing prioritized projects to Logistics and IT leadership. Identify and resolve ongoing day-to-day business issues pertaining to IT support.
• Provide on-going support on “break-fix” issues for existing applications.
• Improve business processes, analyze data, map processes and implement improvements enabled by technology.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Preparation of BR100 and MD050 for the Business Requirements.

Environment: Oracle E-Business Suite R12, WMSA, Oracle OTM 6.3.4.1, Oracle GTM, BI Publisher, Oracle Application framework, Oracle SOA, Jdeveloper11g, Solaris, Oracle11g, Developer Suite 10g, UNIX, Toad, SQL Developer.

Oracle Apps Techno - Functional Consultant

Responsibilities:

• Extended the OAF page functionality for Customer and Supplier Forms Address Validation according to the client requirements.
• Integrated Address Validation functionality with Trillium Software.
• Developed Sales Order Conversion PL/SQL programs to update the Sales Orders for R12 Use.
• Customizations, personalization and Extensions on Customers Online pages using Oracle Application Framework as per client requirement.
• Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention
• Design and maintain the business process in integration of Multiple Source Systems into CDH & SDH.
• Involvement in Integration of Oracle R12 (CDH) system with outside vendors.
• Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention
• Used JDeveloper IDE for coding OAF Page Customizations for Address Validations.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Setups for Tax Validations and Geography Validations.
• Defining Concurrent Programs, Executables and Setups.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Preparation of BR100 and MD050 for the Business Requirements.

Environment: Oracle E-Business Suite R12, Oracle CDH, SDH, DQM, SCM modules like Quoting, OM, INV, BOM, WIP and WMS, OTM, GTM, Oracle Application framework, Oracle SOA, Jdeveloper11g, Solaris, Workflow Builder, Oracle11g, Developer Suite 10g, UNIX, Toad, SQL Developer.

Oracle Apps Techno - Functional CDH Consultant

Responsibilities:

• Extended the OAF page functionality according to the client requirements.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Customizations, personalization and Extensions on Customers Online pages using Oracle Application Framework as per client requirement.
• Created custom user interfaces to maintain Party, Location, Party sites, Party site extensions, Contact, Contact Points, Account, Account Sites, Customer profiles.
• Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention
• Design and maintain the business process in integration of Multiple Source Systems into CDH like Salesforce.com
• Design and maintain the data cleansing process in CDH
• Design and maintain the data enrichment process in CDH
• Design the Word Replacements to standardize the Customer Master Data
• Design, Fine Tune and maintain the Match Rules in CDH for De-duplication of Customer Master Data within Source systems and across source systems
• Design multiple hierarchies for customer master data based on source systems and also based on DUNS Hierarchy
• Architect the SST and survivorship rules in the merge process of the CDH de-duplication
• Involvement in Integration of Oracle R12 (CDH) system with outside vendors.
• Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention
• Used JDeveloper IDE for coding BPEL Process Models.
• Developed different SOAP services and Web Services using WSDL, SOAP, AXIS, and Oracle JDeveloper
• Involved in design and implementation of Oracle BPEL.
• Involved in design and implementation of WebServices.
• Configured E-Mail Notifications for a BPEL Process.
• Experience with Oracle environment using JDeveloper, and SOA suite.
• Loaded workflows, replace seeded workflows, ran workflow maintenance scripts against database
• Customized MSCA Label Bar Code for Multi language Environment and Developed Scripts using PL/SQL.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables and Setups.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite R12, Oracle CDH, DQM, SCM modules like Quoting, OM, INV, BOM, WIP and WMS, OTM, GTM, Oracle Application framework, Oracle SOA, Jdeveloper9i/10g/11g, Solaris, Workflow Builder, Oracle9i/10g/11g, Developer 2000, UNIX, Toad, SQL Developer.

Oracle Apps SCM/OTM Techno - Functional Consultant

Responsibilities:

• Team Lead of Managing a team of 10 members in the Offshore to lead development of formalized solution methodologies.
• Onsite coordination with Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.
• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)
• Extended the OAF page functionality according to the client requirements.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Involved in end to end testing from Quote Creation to Order and Order to Cash.
• Worked on forms, reports, pl/sql concurrent programs involving OM, Inventory, Metering Custom module and Core Contracts(OKC).
• Customizations, personalization and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.
• Created custom user interfaces to maintain Party, Location, Party sites, Party site extensions, Contact, Contact Points, Account, Account Sites, Customer profiles.
• Worked on TCA and Supplier integration.
• Created and set up Data Quality Management (DQM) rules for search, duplicate identification and duplicate prevention
• Design, development and deployment of Web Services was done using Oracle BPEL, JAVA, and XML (WSDLs)Created a Human Task in BPEL, Defined users, worked on Notification Services.
• Used JDeveloper IDE for coding BPEL Process Models.
• Implemented Exception Handling for the BPEL Process models to handle System, Business exceptions and used Compensation handlers to handle the transaction if an exception occurs.
• Developed middle ware solution for interfaces using BPEL Process Manager and Jdeveloper.
• Developed WSDL for BPEL process, partner links and BPEL process templates.
• Implement old processes into new modules and make sure all the business needs are addressed.
• Extended the MSCA page functionality per the requirement.
• OTM/GTM Configurations, Agent Automations, Interface Programs.
• Implemented Oracle ITM Solution for EBS to GTM integration that reduced significant cost of developing EBS to GTM interfaces for Item, Party, Sales Order and Delivery.
• Worked in implementation of OTM/GTM to Client.
• Customizing look and feel of OTM to fit Client Business requirement.
• Generate Reports using BI Publisher and migrated to OTM.
• Configuring OTM, transportation planning and Modeled OTM scenarios.
• Configuring GTM, including trade classification, restricted party screening, license and document determination and management.
• Kewill Interface, EDI Interfaces through TIBCO.
• Worked on multiple Carrier Integrations using Oracle Advanced Queuing.
• Created Concurrent Programs to move/place Files from One server to other Servers through FTP.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Worked in the integration Project, where SOA integration replacing the existing TIBCO integration.

Environment: Oracle E-Business Suite 11.5.10 /R12, Oracle modules like Quoting, OM, OKC, INV, BOM, WIP and WMS, OTM, GTM, CDH, TCA, Oracle Application framework, Oracle SOA, Jdeveloper9i/10g/11g, Solaris, Workflow Builder, Demantra 7.1.1, Oracle9i/10g/11g, Developer 2000, UNIX, Toad, SQL Developer.

Oracle Apps Techno - Functional Consultant

Responsibilities:

• Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walk through.
• Extended the OAF page functionality according to the client requirements.
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects).
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Collecting Oracle’s Business requirement and Leveraging with Oracle Applications
• Involved in end to end testing from Quote Creation to Order.
• Customizations, personalization and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite R12 (12.1.3), Oracle SCM modules like Quoting, OM and OIP, Oracle Application framework, Jdeveloper9i/10g, Solaris, Workflow Builder, Oracle9i/10g, Developer 2000, UNIX, Toad, SQL Developer.

Oracle Apps Techno - Functional Consultant

Responsibilities:

• Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs.
• Developing custom interfaces between various Applications for integration.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Created Concurrent Programs to move/place Files from One server to other Servers through FTP
• Collecting Sun’s Business requirement and Leveraging with Oracle Applications
• Created setups for Oracle SCM & Financial Modules like OM, INV, AP, FA, PO, GL, iExpenses and iProcurement.
• Customizing iExpenses and iProcurement web pages using Oracle Application Framework as per client requirement.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Customization and development Reports as per client requirements.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Provided support to the users on the regular basis regarding their financial 11i systems. The issues covered GL, AP, PO, GL, FA, AR and System Administration modules.
• Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite R11i (11.5.10), Oracle SCM & Financial Modules like OM, INV, AP, FA, GL, CM, PO, iExpenses, iProcurement and OPA, Oracle Application framework, Jdeveloper9i/10g, Solaris, Workflow Builder, Oracle9i/10g, Developer 2000, UNIX and Toad.

Santa Clara, CA

Sr. Application Developer

Responsibilities

• Technical and Functional support for Period close and Quarter close for Sun Microsystems business
• Defining Concurrent Programs, Executables into Oracle financials through AOL and System Administration.
• Customization and development of Reports.
• Customization and development of Forms.
• PL/SQL method of submitting Concurrent programs.
• Working with business to resolve the critical issues
• Writing Unit Test cases and testing after completion of the Object.
• Created Concurrent Programs to move/place Files from One server to other Servers through FTP
• Developing scripts to provide adhoc reporting to business using Brio.
• Modified workflows to make the required changes as per business requirements.
• Providing production support as needed, and tracking of end user’s business issues.
• Configuring AOL setup in Oracle Applications 11i, registering Executables, Concurrent programs, assigning in Request Groups.
• Supported Sun Applications like POLAR, SOLAR, SUNTEA etc.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Understanding the Report functionality, Analysis and Review of High Level documents mainly MD050 Functional Specification.
• Analysis of the GL/FA/PO Processes and Resolving of the various defects discovered through analysis.

Environment: Oracle Applications 10.7, 11.0.3, Oracle E-Business Suite R11i (11.5.9), Oracle Modules like OM, TCA, INV, AP, GL, FA, PO, CM, Solaris, Workflow Builder, Developer 2000, Oracle8i/9i, Toad and UNIX.

Oracle Developer

Responsibilities:

• Providing production support as needed, and tracking of end user’s business issues.
• Working with business to resolve the critical issues
• Work with Oracle Tar (SR’s) Support to resolve issues affecting Business process
• Streamlining issue handling process.
• Getting involved in crisis call/tech calls and driving the issues to resolution
• Analysis of the GL/FA/PO Processes and Resolving of the various defects discovered through analysis
• Supporting Period close for Account Payables, General Ledger and also Quarter close.

Environment: Windows 2000, SQL, PL/SQL, Oracle E-Business Suite R11i (11.5.9), Oracle Financial Modules like AP, GL, PO, FA, CM, AR

Oracle Developer

Responsibilities:

• Registration of tables, columns, schema objects etc.
• Designed and developed of GUI Screens according to sample forms and register the forms
• Creation of key flex fields and descriptive flex fields
• Developing database stored procedures, functions and packages
• Oracle General Ledger Journal import using an utl file and SQL*Loader.

Form Customization:

• Experience in Customization of Oracle Applications Form
• Adding the triggers in the Form level, Block level and Item level
• Attached Descriptive Flex Field
• Attached Calendar to the Date fields
• Experience in customizing forms using Libraries Custom.pll, Appcore.pll, Appdaypk.pll, Fndsqf.pll
• Created Query Find Window for Existing Window

Involved in other activities like:

• Registration of Tables and Forms for custom applications.
• Executing concurrent programs from PL/SQL.
• Creation of Value sets in various Modules of the application.
• Defining Menu and Reports.
• Defining Concurrent Programs, Executables.

Concurrent Programming:

• Used SQL * Loader utility to load data from legacy system to interface table to upload resource data in PO Module.
• Developed various Package Procedures and Host programs.

Environment: Windows, SQL, PL/SQL, UNIX shell scripting, HTML, Oracle7.3/8i, Oracle Applications 11.5.7