SUMMARY

• 12 years of experience with last 10 years working as Oracle Techno/Functional in Oracle Applications E - Business Suite SCM/Financials/Manufacturing modules Release R12 (12.1.3), 11i(11.5.10.2) 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), Inventory (INV), WSH, WMS, MSCA(Mobile Supply Chain Application), BOM, WIP, ASCP, OTM, GTM, Oracle Customer Data Hub (CDH), 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.
• 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).
• Understand MDM opportunities and develop MDM strategy around Oracle MDM technology.
• Design Data Governance Organization, Data Quality MDM Solution architecture for Customers.
• Build MDM Implementation strategy and Roadmaps for Customers.
• Solution Design Data Consolidation, Governance, Data Quality and Integration MDM Solution architecture.
• Competent in full understanding of the functionality of coreOracle 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 3rdparty 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.
• 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 inOBI/XML and BI PublisherandForm 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, Quoting, AP, PO, FA, GL, CM, OPA, T&L, TCA, CDH, 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)

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

Confidential, Westlake Village, CA

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
• 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
• Build DNB Implementation strategy and Roadmaps for Customers.
• 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 ofOracle 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 seededworkflows, ran workflow maintenance scripts against database
• CustomizedMSCALabel 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.

Confidential, Brea, CA

Oracle Apps 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 inOAF. This involves analyzingMD50(Functional Spec) and then writingMD70(Technical Spec)
• Worked in implementation of OTM/GTM to Client
• Identified areas of transportation planning and Modeled OTM scenarios
• Created Organizational profit loss reports using OTM BI Publisher
• Understand the Trade practice of the Organization and provided a complete Global Trade solution using GTM
• Created the Workflow for all the different kind of screenings and license creations
• Identified the customs reports and customized them depending on the business needs
• Configuring OTM, transportation planning and Modeled OTM scenarios.
• Configuring GTM, including trade item classification, restricted party screening, license and document determination and management.
• Created Procedures, Functions and other database objects using SQL and PL/SQL.
• Configuring OTM, transportation planning and Modeled OTM scenarios.
• Configuring Multi-Leg, Multi-Stop Business scenarios.
• Import & Export CSV files into OTM and GTM.
• Automation Agent configuration for Agent Headers, Actions and Error Handling.
• Configuring GTM, including trade item classification, restricted party screening, license and document determination and management.
• 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.
• 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 according to the requirement.
• Kewill Interface, EDI Interfaces to TIBCO.
• Created Concurrent Programs to Confidential /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., Oracle modules like Quoting, OM, 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.

Confidential, Redwood Shores, CA

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.
• Creatednew OAFpages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data throughEO(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, personalizations 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.

Confidential, Santa Clara, CA

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 Confidential /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.

Confidential, Santa Clara, CA,

Sr. Application Developer

Responsibilities:

• Technical and Functional support for Period close and Quarter close for Confidential 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 Confidential /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.

Confidential

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

Confidential

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.
• Adding the triggers in the Form level, Block level and Item level
• Attached Descriptive Flex Field
• Attached Calendar to the Data fields
• Experience in customizing forms using Libraries Custom.pll, Appcore.pll, Appdaypk.pll, Fndsqf.pll
• Created Query Find Window for Existing Window
• 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.
• 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