SUMMARY

• 9 Years of experience in IT predominantly in Oracle EBS implementation and Enterprise Applications Practice with proven expertise in Developing, Customizing and Supporting Oracle Applications (11i & R12), and AOL of Oracle E - business Suite.
• These include Analysis, Design, Development and Implementation of different projects for applications based on Relational DBMS, and in the field of Oracle e-business Suite.
• Exclusive experience in 12.2.4 upgrade
• Good Expertise in developing applications using SQL, PL/SQL, Database Triggers, Stored Procedures, Oracle 10g/9i/8i/8.0.5/7.x and Developer 6i and 10g.
• Expertise in RICEW (Reports, Interfaces, Conversions, Extensions and Workflow).
• Highly proficient in requirements gathering, business systems study, technical solution design, and system document preparation using AIM methodology
• Good Expertise in Query and Performance tuning in Oracle.
• Good Expertise in developing automated processes using Oracle Workflow 2.6 /AME
• Good Expertise in developing self service applications using Oracle Application Framework (OA Framework) using Oracle Jdeveloper 9.0.3/10g.
• Extensive experience in conversion of legacy data into Oracle Applications using SQL Loader and PL/SQL.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Extensive Experience in using Oracle Application Object Library (AOL) features including implementation of Flexfields (Like Implementing Cross Validation Rules, Implementation flexfields in reports, Security rules), creating and scheduling of Concurrent programs etc.
• Experienced in Full software development life cycle implementation (SDLC).
• Extensive experience in design and development of applications under UNIX and Linux environments.
• Setup and Configured applications to support client requirements.
• Good Expertise in TCA (Trading Community Architecture).
• Good Expertise in functionality of Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Oracle Purchase Order(PO), Oracle Order Management (OM), Oracle Projects (PA), Oracle Inventory (INV), Bill of Material (BOM), Work in process (WIP) and Oracle Application Object Library (AOL).
• Good functional expertise on Open Interfaces (Includes both inbound and outbound interface) in Oracle Manufacturing and Financials.
• Experience in E-R Modeling to create Data Models both Logical and Physical design using ER Win.
• Experienced in working with Huge Datasets comprising of at least greater than 10 Mill records.
• Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.
• Exposure to data support on Multiple Environments like UAT, SIT, INT, INT2, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board.
• Enthusiastic to learn new skills with a shorter learning curve.
• Excellent Communication, Good Work Ethics and a Team Player.

TECHNICAL SKILLS

ERP: Oracle Financials Release 12, 11i, and Release 10.7.

Modules: Oracle Inventory (INV), Oracle Purchasing (PO)Oracle Order Management (OM), Oracle Work in Progress (WIP), Oracle Payables (AP), Oracle Receivables (AR), Oracle General Ledger (GL), Oracle Projects (PA), Oracle iProcurement and Oracle iExpense and TCA

Others: Oracle Application Object Library (AOL) and Oracle System Administrator (Sysadmin), Oracle Workflow version 2.6 and Oracle XML Gateway

Primary Skills: Oracle Apps Techno functional

Databases: Oracle 11g, 10g, 9i, 8.x/7.x/6.x, SQL Sever (v7.0).

Development Tools: Oracle Developer - Forms 10g/6.x/5.0, Reports 6.x/3.0/2.5 Oracle Discoverer 4i, 3.0, Oracle Jdeveloper 11g (OA framework)

Programming Languages: Core Java, SQL, PL SQL, HTML, XML, WSDL

Operating Systems: Windows 2000, Windows NT, Windows 98/95UNIX, Sun Solaris, AIX, HP-UX, IRIX.

Hardware: Intel Based Servers and Workstations, HP DEC AlphaDEC VAX.

Case Tools: Oracle Designer 2000

Version Control Tool: PCVS, STAT.

Tools: TOAD, SQL-Navigator, SQL Loader, SQL Developer and PL/SQL Developer

Scripting: ksh/ C shell/ Bourne

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Oracle EBS Tech Consultant

Responsibilities:

• Developed Expenditure extraction outbound interface.
• Developed Sales order extract outbound interface.
• Developed sales order extraction outbound interface and transmitted the data to third party systems.
• Developed requisition interface between Oracle and Maximo systems.
• Developed discrete job routing with MIS information report.
• Developed Intercompany report in Oracle Order management.
• Developed Project commitment report in Oracle Projects module.
• Worked on Project transactions extensions.
• Developed on Project commitment report.
• Worked on project accounting expenditure report.
• Customized Invoice print report in AR module.
• Worked on OAF customizations in Oracle Order Management module.
• Worked on duplicate project
• Developed the OAF customizations in Customers pages which are changed from Forms to OAF.
• Developed/Retrofitted AP check printing program according to R12.
• Retrofitted objects of OM, PO, AP, AR and GL in accordance to 12.2.4 standards.
• Co-ordinated with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.
• Developed UNIX shell scripts
• Co-ordinated with offshore in retrofitting other module objects.
• Involved in arranging the sequence of objects for migration activities.
• Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance.

Environment: RICE Elements, R12.2.4, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 11g, Developer 10g Oracle Jdeveloper (OAF Personalisation, SOA, BPEL, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME. Noetix, Discoverer 10g

Confidential, Houston, TX

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Gathering User requirements and implement them in the best possible way and document the process.
• Experienced with P2P and O2C cycles.
• Defined the Qualifier and Modifier setups in pricing module.
• Automated Employee vendor Bank Account in synch with Payroll Bank Account for Electronic payment.
• Worked on Invoice prepayment report.
• Customised AP EDM Invoice Report.
• Customised I-Supplier Self serviced pages to capture Bank Account Details.
• Developed INBOUND and OUTBOUND Interfaces based technical specifications.
• Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.
• Configured descriptive (DFF) flex fields for storing custom information.
• Developed, Personalized & Configured through Oracle Forms, Oracle Reports, Oracle Workflow, Oracle ADI, Oracle APIs, Fast Formulas, Oracle 10g, PL/SQL, UNIX for Writing registration Scripts for Application Object Library objects, also used FND LOAD to migrate object from one instance to another.
• Post production maintenance for the conversions and interfaces in Oracle Applications.

Environment: RICE Elements, R12.1.3, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Confidential, Houston, Texas

Computer Programmer

Responsibilities:

• Preparing MD070 documents based on MD050.
• Experienced with P2P and O2C cycles.
• Gathering User requirements and implement them in the best possible way and document the process.
• Done the Configuration for GL, AP, AR, and Cash Management modules as per the client needs.
• Interact with third Party vendors like Citibank to setup them as Vendors in Oracle AP module and process invoices, electronic payments for these Vendors.
• All store managers does have corporate credit Cards for their expense maintenance, Confidential sends these Credit Card expenses electronically, we load these transactions as Credit Card Expenses into Payables and these payment for these Credit Card transactions will be made through normal AP Invoice, payment Process.
• Designed Technical Designs for RICEW elements based on Functional Specs.
• Projects Expenditure Transactions Process.
• Developed INBOUND and OUTBOUND Interfaces based technical specifications.
• Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.
• Implementing Forms personalization.
• Internal Sales Order/Internal Requisition process was Configured to establish a simplified Intercompany sales across operating Units
• Developed custom self serviced pages using Oracle Jdeveloper.
• Development of Custom Packages, Procedures and Functions in ERP. Involved in Performance Tuning of the SQL Statements to reduce the process time. Conducted Business meetings for the Project plan.
• Writing registration Scripts for Application Object Library objects, also used FND LOAD to migrate object from one instance to another.
• Developed shell scripts to automate the processes using Autosys scheduler.
• Post production maintenance for the conversions and interfaces in Oracle Applications.

Environment: RICE Elements, R12, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Confidential, Houston, Texas

Oracle apps Technofuctional consultant

Responsibilities:

• Oracle Apps Technical Consultant forsupportand maintenance project.
• Involved in the day to day activities of production support of Oracle applications environment inAP, PO, OM, INV, AR, iExpense, iProcurementand GL.
• Involved in theanalysisof the assignedsupportticketsincluding replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
• Work on the development activities as part ofissueresolution. Perform Unit Testing, Migrate to next environments, assistusertestingand closing thetickets.
• Support includes the transaction integration for Sales Orders, Purchase Orders, and Customer Returns etc. Setup related integration for Items, Vendors, and Customers etc.

Environment: RICE Elements, 11i, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Confidential

Oracle apps Techno Functional Consultant

Responsibilities:

• Worked as team member in the team.
• Developed RDF reports and XML publisher reports.
• Developed and customized on Oracle interfaces by using third party applications like SOA and Web Methods.
• Registration of Concurrent Program Executables, Concurrent Programs, Parameters, Value Sets, Request Sets.
• Worked on Picking and shipping Outbound Interface.
• Developed Internal Requisition Interface by using XML gateway.
• Developed on Debit and Credit Memo Invoice Report.
• Customized on Oracle Supplier and Supplier sites Reports.
• Developed custom Inventory material transactions error XML report as per my client requirement.
• Migration of AOL and Non AOL objects from one Instance to another Instance by using Kintana tool.

Environment: Oracle 9i RICE Elements, 11i,, UNIX Scripting, SQL, PL/SQL, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Confidential

Oracle Apps Technical

Responsibilities:

• Extracted data from existing data source by using SQL, PL/SQL, and UNIX.
• Created tables, views, procedures, SQL scripts.
• Worked on On hand quantity conversion
• Worked on Data loading activities using Data Loader tool.
• Physical and Logical Database Backups. Export/Import Tables.
• Developed forms using Forms 6i using advanced GUI features like pop-ups, stacked canvasses etc.
• Designed & developed reports using Oracle Reports, SQL, PL/SQL.
• Requirement gathering and analysis.
• Implementation of new organizations.
• Development of inbound interface.
• PL/SQL packages, procedure and function creation and modification.
• Enhancing requisition approval workflow by adding new nodes and attributes in requisition workflow.
• Creation of attributes, processes, functions, roles, messages, Notifications in using Oracle workflow builder.
• Carrying out testing from Req creation to invoice creation.
• Coordinating the team during production move.
• Dealing with clients on day to day basis.
• Analysis of impacted reports including PO print rdfs.
• Modifying Oracle reports as per business requirement.
• Providing Support on Post production issues.

Environment: Oracle 9i, Oracle Apps 11i, Developer 2000, SQL, PL/SQL, Unix, Brio, HTML, Word, MS SQL Server, Windows NT and Data Loader.