SUMMARY

• Technically sophisticated, result oriented professional offering around 10+ years in Oracle E - Business Suite application as Technical and Techno-Functional Consultant.
• Experience on Oracle E-Business Suite R12.4.2, 11.5.10.2, 11.5.8 and 11.0.3
• Expertise in Functional Modules SCM (OM, INV, PO), Discrete MFG (BOM, WIP) and Finance Modules (AP, AR). And Worked with RICEFW Components using System Administration and Application Object Library (AOL)
• Experience in Order to Cash and Procure to Pay Process.
• Strong programming experience with SQL, PL/SQL and UNIX - Shell Scripting
• Worked with OAF Pages, D2K Forms, D2K Reports, XML Publisher Reports and BI Publisher Reports. Familiar with SOA Technology and XML Language.
• Rich Experience with Conversions /Data-Loads and System Integration using Inbound, Outbound Interfaces using Oracle SOA Suit, FTP Process and DB-Links methods.
• Extensively Involved in Performance tuning, troubleshooting, debugging and fixing the codes/scripts, Month-end activities and production support.
• Closely work with Oracle SOA Team for Integration Oracle Ebiz with Other Systems/applications and Internal / external systems.
• Having offshore, on-site experiences with various countries environments like USA, Malaysia and India., and Manufacturing Plants, Warehouses visit experiences.
• Prepared technical design documents (MD070, CV060 and CV070) for Implementations, customizations and conversions using AIM documentation methodology. Worked with B100 document and MD50 documents.
• Interaction with Project Managers, Business Analysts, Plant Users and Customers of the Business, to Understand the requirements/Issues and address them.

TECHNICAL SKILLS

Primary Skills: Oracle EBS Technical Development (RICEW Components), Interface (Inbound and Outbound), Conversions, Extensions, Forms, Form Personalization, Workflow builder, XML Publisher & BI Publisher Reports

Packages (Incl ver): Oracle EBS 12.2.6, 11.5.10, 11.5.9

Modules: Oracle EBS Supply Chain (SCM), Manufacturing Modules and Oracle EBS Financial, Order Management (OM), Account Receivables (AR), Purchasing (PO), Account Payables (AP), Inventory (INV), Work In Progress (WIP), Bill of Materials (BOM).

Languages: XML, SQL, PL/SQL and UNIX-Shell Scripts

RDBMS: Oracle 11g, 10g and 9i

Tools: /Utilities: TOAD 10.5/9.0, SQL Developer, SQL*Loader, SQL*PLUS, Harvest, GitLab, Core FTP, WinSCP, Putty, SSLVPN and JDeveloper.

GUI: Forms 6i, Reports 6i, XML Publishers, BI Publishers and OAF

Operating System: Windows 7, XP, 2000 and UNIX

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Apps Techno Functional Consultant

Responsibilities:

• Participated in Requirement gathering, Analysis, Design, Development, Testing, and Deployment of the Project. Created User support Documentation and R&D to achieve required functionality of the Project.
• Worked for Inventory application Setups, Supply Chain Planning Application Setup and Purchasing Application Setup against to BR100 document.
• Participate in CRPs, SIT, UAT and prepare the cut over document.
• Authorize universally accepted documentations used for tracking the Business processes like RD20, MD50, BR100, MD70 and TE040.
• Worked of EDI transactions like (850,852,861,945R and 945D) with 3PL (third party warehouse) process.
• Shopfloor system, Shipping, Label printing and User Interfaces Integration with Oracle ERP
• Worked together with Oracle DBA team to establish system integration between oracle Apps system and other systems like Shop-floor, Label Printing systems, Shipping Systems, User Interface. And Worked with Unix Team for FTP process Integration with warehouse system.
• Coordinated with Project Manager, Business users, Customers, Other System technical people to understand the requirement and resource allocation as per provided the quote of hours for the project developments. And Delivery of the work.
• Participated In planning project backlogs, 2 week sprints and daily stand up meetings to analyse the time frame and report the status of the projects
• Travelled to Malaysia Plants during CRP, SIT and UAT testings and effectively communicated with Order management, Purchasing, Shipping and Planning teams in the plant, along with subsystems and warehouse users.
• Written stored Packages, Procedures and Functions, using pl/sql tables, arrays, nested tables, created staging tables, temporary tables, Indexes, provide grants, synonyms, views, sequences, creating DB Links to meet the business requirement
• Worked for the Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Worked for the Development and customization of XML Publisher Reports, OAF pages.
• Worked on Inbound and outbound Interfaces for subsystems and warehouse by using utilities SQL*Loader, UTL FILE and Standard API’s /Programs.
• Sending mail using the PL/SQL procedure(s)/Package(s) as well as by Shell scripting as per requirement
• Unix Shell Scripting for FTP process. Implemented Secure FTP, Watchdog process and alerts for failed FTP
• Involved for data migration/merger. Have all the pre-validations done before proceeding with data loads
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Coordinated with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement
• Attending staff meetings with onsite team weekly basis and conducting team meetings with off shore team to discuss resources work load, status of the projects and upcoming projects information
• Written custom packages using API’s to develop the interface Programs.
• Guide and Train users through the ERP end to end business process during CRPs.
• Participate the GO-Live and provide the post Go-Live support

Environment: Oracle EBS R12.2.4, Oracle 11G, Unix, OAF, BI/XML Publisher Reports, D2k Forms and Reports. Oracle SCM and MFG Modules.

Confidential

Senior Oracle Apps Techno Functional Consultant

Responsibilities:

• Participated in Requirement gathering, Analysis, Design, Development, Testing, and Deployment of the Project. Created User support Documentation and R&D to achieve required functionality of the Project
• Perform the functional setups in OM, INV and Purchasing.
• Authorize universally accepted documentations used for tracking the Business processes like RD20, MD50, BR100, MD70, TE040.
• Developed stored Packages, Procedures and Functions, using pl/sql tables, arrays, nested tables, created staging tables, temporary tables, Indexes, provide grants, synonyms, views, sequences to meet the business requirement
• Worked for Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Developed XML/BI Publisher Reports, OAF pages to meet the business requirement
• Developed Inbound and outbound Interfaces for all 3rd party applications/systems/customers by using utilities SQL*Loader, UTL FILE and Standard API’s /Programs. These interfaces are being developed to extract/upload data from/to Oracle.
• Closely work with Oracle SOA team to establish system integration between oracle Apps system and Customer System as well as 3rd Party System/Applications which is the portal for customer.
• Worked for Sending mail using the PL/SQL procedure(s)/Package(s) as well as by Shell scripting as per requirement
• Customized Workflows based on business requirement.
• Developed Unix Shell Scripts for FTP process, calling concurrent jobs and APIs, sending alerts with attachments etc to meet the business requirement
• Involved for data migration/merger. Have all the pre-validations done before proceeding with data loads
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Coordinated with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement
• Attending staff meetings with onsite team weekly basis and conducting team meetings with off shore team to discuss resources work load, status of the projects.
• Involved in developing Technical design documents, and Unit Test Scripts.
• Performed Unit Testing for Outbound Interface and deployed to UAT and then to PROD.
• Written custom packages using API’s to develop the interface Programs.
• Provide the Production support after go live of the project. And Involved in developing Custom Archive and Purge Program, which will Archive Custom Schema tables and Purge data from Custom Table.

Environment: Oracle EBS R12.2.4, Oracle 11G, Unix, OAF, BI/XML Publisher Reports, D2k Forms. Oracle SCM and Manufacturing Modules.

Confidential

Senior Oracle Apps Techno Functional Consultant

Responsibilities:

• Written stored Packages, Procedures and Functions, created staging tables, temporary tables, Indexes, provide grants, synonyms to meet the business requirement
• Developed the outbound Interfaces using UTL FILE and Wrote Unix Shell Scripts for FTP process.
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Production support after go live of the project
• Coordinated with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement
• Attended staff meetings with onsite team weekly basis and conducting team meetings with off shore team to discuss resources work load, status of the project.
• Assists Business users for implementations and Initiatives for testing and Design, Created Use cases, Test Cases, Test Scripts, Test Plans and uploaded to the Quality Center and ran manual testing for Implementation on each release.

Environment: Oracle EBS 11.5.10.2, Oracle 10G, Unix, D2K Reports, Oracle SCM and Manufacturing Modules.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Participated in Requirement gathering, Analysis, Design, Development, Testing, and Deployment of the Project.
• Developed stored Packages, Procedures and Functions, using pl/sql tables, arrays, nested tables, created staging tables, temporary tables, Indexes, provide grants, synonyms, views and sequences to meet the business requirement
• Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Developed Inbound and outbound Interfaces for all 3rd party applications/systems by using utilities SQL*Loader, UTL FILE and Standard API’s /Programs. These interfaces are being developed to extract/upload data from/to Oracle.
• Worked together with Oracle SOA team to establish system integration between oracle Apps system and rTO application and other 3rd Party System/Applications in the Plants in order to synchronize data
• Written Unix Shell Scripting for FTP process, calling concurrent jobs and APIs, sending alerts with attachments etc to meet the business requirement
• Involved for data migration/merger. Have all the pre-validations done before proceeding with data loads
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Coordinated with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement
• Worked on exception handling for the ease of debugging, displaying the error messages in the calling application and stores the logs in auditing table.
• Production support after go live of the project.

Environment: Oracle EBS 11.5.10.2, Oracle 10G, Unix, D2K Reports, Oracle SCM and Manufacturing Modules.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Participated in Requirement gathering, Analysis, Design, Development, Testing, and Deployment of the Projects. Created User support Documentation and R&D to achieve required functionality of the Projects
• Coordinate with Project Manager, Business users, Customers, Other System technical people to understand the requirement and resource allocation as per provided the quote of hours for the project developments. And Delivery of the work.
• Actively participated In planning project backlogs, 2 week sprints and daily stand up meetings to analyze the time frame and report the status of the projects
• Writing stored Packages, Procedures and Functions, using pl/sql tables, arrays, nested tables, created staging tables, temporary tables, Indexes, provide grants, synonyms, views, sequences, creating DB Links to meet the business requirement
• Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Development and customization of XML Publisher Reports, OAF pages to meet the business requirement
• Inbound and outbound Interfaces Development for all 3rd party applications/systems/customers by using utilities SQL*Loader, UTL FILE and Standard API’s /Programs. These interfaces are being developed to extract/upload data from/to Oracle.
• Working together with Oracle SOA team to establish system integration between oracle Apps system and other system like Customer System, 3rd Party System/Applications in the Plants in order to synchronize data
• Sending mail using the PL/SQL procedure(s)/Package(s) as well as by Shell scripting as per requirement
• Writing Unix Shell Scripting for FTP process, calling concurrent jobs and APIs, sending alerts with attachments etc to meet the business requirement
• Involved for data migration/merger. Have all the pre-validations done before proceeding with data loads
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Production support after go live of the projects
• Coordinate with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement
• Attending staff meetings with onsite team weekly basis and conducting team meetings with off shore team to discuss resources work load, status of the projects and upcoming projects information
• Involved in recruitment and training of new hires

Environment: Oracle EBS 11.5.10.2, Oracle 10G, Unix, D2K Reports, D2K forms, Oracle SCM and Manufacturing Modules.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Participated in Requirement gathering, Analysis, Design, Development, Testing, and Deployment of the Projects. Created User support Documentation and R&D to achieve required functionality of the Projects
• Coordinate with Project Manager, Business users, Customers, Other System technical people to understand the requirement and resource allocation as per provided the quote of hours for the project developments. And Delivery of the work.
• Actively participated In planning project backlogs, 2 week sprints and daily stand up meetings to analyse the time frame and report the status of the projects
• Writing stored Packages, Procedures and Functions, using pl/sql tables, arrays, nested tables, created staging tables, temporary tables, Indexes, provide grants, synonyms, views, sequences, creating DB Links to meet the business requirement
• Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Development and customization of XML Publisher Reports, OAF pages to meet the business requirement
• Inbound and outbound Interfaces Development for all 3rd party applications/systems/customers by using utilities SQL*Loader, UTL FILE and Standard API’s /Programs. These interfaces are being developed to extract/upload data from/to Oracle.
• Working together with Oracle SOA team to establish system integration between oracle Apps system and other system like Customer System, 3rd Party System/Applications in the Plants in order to synchronize data
• Sending mail using the PL/SQL procedure(s)/Package(s) as well as by Shell scripting as per requirement
• Writing Unix Shell Scripting for FTP process, calling concurrent jobs and APIs, sending alerts with attachments etc to meet the business requirement
• Involved for data migration/merger. Have all the pre-validations done before proceeding with data loads
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Production support after go live of the projects
• Coordinate with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement
• Attending staff meetings with onsite team weekly basis and conducting team meetings with off shore team to discuss resources work load, status of the projects and upcoming projects information
• Involved in recruitment and training of new hires

Environment: Oracle EBS 11.5.10.2, Oracle 10G, Unix, D2K Reports, D2K forms, Oracle SCM and Manufacturing Modules.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Closly worked together with Oracle SOA team to establish system integration between oracle Apps system and smartloader application.
• Written stored Packages, Procedures and Functions, using staging tables, temporary tables, Indexes, provide grants, synonyms, views and sequences to meet the business requirement
• Worked on Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Inbound and outbound Interfaces Development for all 3rd party applications/systems/customers by using utilities SQL*Loader, UTL FILE and Standard API’s /Programs. These interfaces are being developed to extract/upload data from/to Oracle.
• Sending mail using the PL/SQL procedure(s)/Package(s) as well as by Shell scripting as per requirement
• Worked on Unix Shell Scripting for FTP process, calling concurrent jobs and APIs, sending alerts to meet the business requirement
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Production support after go live of the projects
• Effective communication with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement

Environment: Oracle EBS 11.5.10.2, Oracle 10G, Unix, D2K Reports, D2K forms, Oracle SCM and Manufacturing Modules.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Worked with API’s on stored Packages, Procedures and Functions, using pl/sql tables, arrays, nested tables, created staging tables, temporary tables, Indexes, provide grants, synonyms, views, sequences, creating DB Links to meet the business requirement
• Inbound and outbound Interfaces Development for all 3rd party applications/systems/customers by using utilities SQL*Loader, UTL FILE and Standard API’s /Programs. These interfaces are being developed to extract/upload data from/to Oracle.
• Worked together with Oracle DBA team to establish system integration between oracle Apps system and Inplan system in the Plants in order to synchronize data. Integration is done through DB-Link Method.
• Sending mail using the PL/SQL procedure(s)/Package(s) as well as by Shell scripting as per requirement
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And incompatibility the programs, enable trace, scheduled the jobs, give priority the jobs under concurrent managers
• Production support after go live of the projects
• Coordinated with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement

Environment: Oracle EBS 11.5.10.2, Oracle 10G, Unix, D2K Reports, D2K forms, Oracle SCM and Manufacturing Modules.

Oracle Applications Technical Consultant

Confidential

Responsibilities:

• Coordinate with Manager and Team Lead to understand the requirement for assigned project developments
• Actively participated in daily stand up meetings to analyse the time frame and report the status of the projects
• Understanding the business requirement. Writing stored Packages, Procedures and Functions, using pl/sql tables, arrays, nested tables to meet requirement
• Created staging tables, temporary tables, Indexes, provide grants, synonyms, views, sequences, creating DB Links as per requirement
• Development and customization of Reports, Forms using Form/Report Builder and Personalization of the forms to meet the business requirement
• Inbound and outbound Interfaces Development for all 3rd party applications/systems/customers by using utilities SQL*Loader and UTL FILE. These interfaces we developed to extract/upload data from/to Oracle
• Working together with Oracle SOA team and Oracle DBA team to establish system integration between oracle Apps system and other system like Customer System, 3rd Party System/Applications in the Plants
• Sending mail using the PL/SQL procedure(s)/Package(s) as well as by Shell scripting as per requirement
• Writing Unix Shell Scripting for FTP process, calling concurrent jobs and APIs, sending alerts with attachments etc to meet the business requirement
• AOL responsibilities such as registration of Executables, concurrent programs along with parameters, request sets, Forms, Functions, Values Sets and Flex fields, attaching them to required Menu. And Incompatibility the programs, enable trace, scheduled the Jobs, give priority the jobs under concurrent managers
• Production support for post-GoLive.
• Working with Oracle Apps Sys Admin, Job Optimization and DBA Teams as per requirement
• Attending staff meetings weekly basis and attending team meetings with off-shore/on-site team to discuss work load, status of the projects

Environment: Oracle EBS 11.5.10.2&11.5.8,Oracle 10G, Unix, D2K Reports, D2K forms, Oracle SCM, Manufacturing Modules and Financial Modules

Confidential

Responsibilities:

• Functional testing of forms, reports and Interfaces for manufacturing and finance modules
• Testing of the interface programs and other application interfaces that are interfaced with Oracle apps.
• Bug fix any report, custom interface program that error during testing
• Write some basic procedures (and register as concurrent programs) for data upload from staging to standard interface tables. These procedures/packages were also used for some basic data validations.
• For standard forms, reports raise a TAR with oracle and follow up for a quick resolution
• Prepare a document with the runtime and scheduled runtime details for the monitoring team to verify the incompatibilities.

Confidential

Responsibilities:

• Troubleshooting and customizations for any kind of oracle related issues that can hamper the production or any kind of reconciliation activities.
• Coordinating with the business plant for strategy, setups, testing and data validation. Make sure to have the go-live as per schedule and plan. And Communication with customers for support
• Guiding and mentoring team to provide a prompt solution, maintain a proper documentation to have an audit trail for that issue
• Major part of support for Interfaces Support, also support for reports and forms partially.
• Identify the long running and frequently used Interfaces and reports. And tune these Interfaces and reports to reduce the runtime considerably

Confidential

Responsibilities:

• Clear the interfaces and the pending transactions
• Schedule the required (purchasing accrual and receipt reports, management reports) reports and interfaces
• Open/Close the PO and INV periods for the next fiscal month
• Journal Import for PO and INV and let the results posted to corporate finance to conclude the month end process for current fiscal month.