SUMMARY

• Having 8+ years of experience in Customization, Extensions, Interfaces, Reports in various modules including Finance, Procure to Pay (Supply Chain Modules) and Manufacturing Modules.
• Oracle Applications (ERP) - Technical Consultant with sound functional knowledge in various modules.
• Rich experience in Oracle Applications 11i and R12 module such as General Ledger, Accounts Receivables (AR), Account Payables (AP), Inventory (INV), and Work in Process (WIP), Bills of Materials (BOM) Purchasing (PO), Application Developer, and System Administration.
• Worked on Oracle Applications (R12) RICEW components (Forms/Reports, AOL), PL/SQL
• Experience in working with Custom Reports and developing the interfaces in AP, GL, AR, WIP, BOM PO, and OM.
• Strong knowledge and experience in Procure to Pay (P2P) and Order to Cash (O2C) business flows
• Developing Oracle Applications Reports, Interfaces, Conversions and customization of Apps Reports and Enhancement of Interfaces & Conversions.
• Experience in programming with Oracle tools such as Forms&Reports10g, PL/SQL, SQL, SQL*Loader, UTL FILE Packages.
• Experience in PL/SQL coding like Cursors, Packages, Collections, Stored Procedures and Functions.
• Hands on Experience in XML Publisher and BI Report Development.
• Worked on Forms Development, Forms Personalization and Custom.pll
• Worked on Oracle XML Gateway/E-Commerce Gateway
• Worked on Oracle Workflow Customizations.
• Worked on Oracle Applications Framework (OAF) using JDeveloper.
• Hands on experience working with WebADI tool.
• Hands on experience working with Oracle Discoverer tool
• Hands on experience in SQL performance tuning.
• Hands on Experience in developing Shell Scripts in Linux Environment.
• Expertise in Creating Value sets, Lookup Codes, Messages, and Alerts.
• Registration of Concurrent Programs, Concurrent Executables, Request Groups, Menus, Functions.
• Worked effectively on customizing existing approval workflows using Workflow Builder as per client requirements.
• Knowledge on OBIEE Tool.
• Knowledge on SOA and BPEL technologies.
• Knowledge on Trading Community Architecture (TCA).
• Exposure in design documents like MD70, MD60, RD60, MD120 and TE20.
• Exposure to Oracle AIM (Application Implementation Methodology).
• Adapt at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user accepting testing, production support, documentation and completion.
• Significant experience in performing day-to-day maintenance and support of existing Oracle ERP applications in parallel with the analysis, design, development and co-ordination activities for new applications.
• Collaborate well with project management, business analysts and department management teams.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite(EBS) R12 (General Ledger, Account Payables, Purchasing, Account Receivables, e-Commerce Gateway, Shipping Execution, Inventory, Order Management, AOL), Oracle Applications E-Business suite (EBS) 11i

Oracle ERP: Versions 11. .0.3/12.1.1/12.1.3

RDBMS: Oracle 10g/9i

Programming Languages: SQL, PL/SQL, Java, Shell Script, XML, HTML, Awk Script

Development Tools: SQL*Plus, SQL-Loader, SQL Navigator/TOAD/SQL DeveloperXML/BI Publisher, Oracle Reports 6i/10g, Oracle Forms 6i/10gOracle Workflow Builder, JDeveloper.

Methodologies: Application Implementation Methodology (AIM)

Operating Systems: Windows 7/XP/NT/2000, UNIX, Linux, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle EBS/EDI Developer

Responsibilities:

• Worked on EDI Outbound Interface for sending 850 Purchase Orders to Client vendors via DICentral Gateway.
• Worked on EDI Inbound interface for 810 receiving vendor invoices from EDI gateway to Account Payables System.
• Worked on new responsibilities and menu creation.
• Developed XML Publisher reports to generate Customer Invoice details.

Confidential, McHenry, IL

Oracle Applications Developer

Responsibilities:

• Developed an AP Invoice Register BI Report in Account Payables based on MD50 business requirement.
• Developed Daily Currency Exchange Rate Auto upload in General Ledger as per MD50 business requirement.
• Worked on Account Analysis XML Report in General Ledger as per MD50 business requirement.
• Developed AR Invoice Pre-Processor to add discounts to eligible customers before “AutoInvoice” and insert discounted lines in RA INTERFACE LINES ALL interface table.
• Developed a Custom Outbound Interface for sending Local & Export Customer AR Invoices to Mexico SAT systems.
• Worked on EDI Outbound Interface for sending 810 AR Invoices to Client Customers via Gentran Gateway.
• Worked on EDI Outbound interface for 856 shipping template to send ASNs to Gentran EDI System.
• Worked on EDI Inbound interface for 850/DELJIT/DELFOR transactions to import into OM system.
• Developed Drop ship ASN Program from scratch to send ASNs ultimately to Shipping Customers.
• Worked on production tickets to fix EDI Inbound and Outbound Interface Programs.
• Daily coordinating with E-Commerce Gateway users to break fix EDI Transactions in Supply Chain areas.
• Prepared unit test cases for EDI programs and participated in system integration testing with EDI team.
• Developed validation program to load Purchasing data into OE HEADERS IFACE ALL, OE LINES IFACE ALL tables. Then, the data loaded into OM standard tables.
• Developed a shell script to invoke order import standard open interface in Order Management module
• Performed Unit testing and prepared TE20 documents
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Developed a PO Inbound interface program to load external data from legacy system using SQL* Loader into PO HEADERS INTERFACE, PO LINES INTERFACE & PO DISTRIBUTIONS INTERFACE interface tables.
• Peer review of the team objects as per functionality for final sign off delivery.

Environment: Oracle Applications R12 (AP, AR, XLA, GL, PO, OM, INV), Oracle Applications Framework(OAF), Oracle eCommerce Gateway, Red Hat Unix, Oracle 11g, Reports 6i, Forms 6i, TOAD, SQL*Loader, PL/SQL, SQL* Plus, XML publisher.

Confidential

Responsibilities:

• Created SQL Loader scripts to load data from legacy systems to Oracle Apps.
• Modifications of Procedures and Packages according to new Oracle standard tables in R12
• Requisition Details loading using SQL * Loader and PL/SQL. Developed programs to insert, update and validate values into the PO REQUISITIONS INTERFACE ALL and PO REQ DIST INTERRFACE ALL table for each requisition line.
• Developed CTL files for loading CSV files from shared drive to server using SQL * Loader into Staging Tables
• Modified existing workflow notifications to cater the charge account, cost centre information.
• Developed packages to validate and to load data from staging table to Interface tables. Then, using standard Item Import program to load Items into Inventory.
• Developed PLSQL packages for Outbound Interface using UTL FILE utility.

Environment: Modules: OM, PO, INV and SQL, PL-SQL, Reports 10g/6i, Putty, Winscp 3, Linux(Redhat) Server.

Confidential

Oracle Sr. Consultant

Responsibilities:

• Have played a major role in interacting with the client and coordinating with team
• Preparation of Technical documentation like MD70, TE20 etc .
• Ensuring quality deliverables in time, Technical design for report customization and written PL/SQL packages.
• Involved in personalization, extensions and development of new web pages using OAF.
• Created new BI reports using BI Publisher
• Customized BI reports as per client requirements
• Created new Bi reports using PL/SQL packages
• Developed Shell Scripts to email the Concurrent request log and out files
• Developed Shell Scripts to invoke multiple concurrent programs
• Developed Shell Scripts to invoke SQLLOADER control files to push data to tables
• Developed new employee signing limits form using Form Builder
• Developed new charge account mapping form using Form Builder
• Worked on Form Customizations
• Technical design documents preparation and building objects as per client requirements.
• Peer review of the team objects as per functionality for final sign off delivery.

Environment: Oracle Apps Implementation Release R12 (Version), Modules: AP, GL, PO, INV, ZX and SQL, PL-SQL, Reports 10g/6i, Oracle Applications Framework(OAF), Forms Personalization, XML or BI Publisher, Oracle XML Gateway, Workflow, Putty, Winscp 3, Windows XP/2003 and Linux(Redhat) Server.

Confidential

Oracle Consultant

Responsibilities:

• Have played a major role in interacting with the client and coordinating with team
• Preparation of Technical documentation like MD70, TE20 etc .
• Ensuring quality deliverables in time, Technical design for report customization and written PL/SQL packages.
• Created new BI reports using BI Publisher
• Customized BI reports as per client requirements
• Involved in personalization, extensions and development of new web pages using OAF.
• Created new BI reports using PL/SQL packages
• Developed SQLLOADER control files to push data into staging tables.
• Developed Inbound Interfaces in PO, AP, OM modules using PL/SQL Packages.
• Developed Shell Scripts to email the Concurrent request log and out files
• Developed Shell Scripts to invoke multiple concurrent programs
• Developed Shell Scripts to invoke SQLLOADER control files to push data to staging tables
• Developed SQL*Plus based reports
• Worked on Workflow Customizations
• Resolved error workflows notifications
• Played a role in Sysadmin Activities
• Developed PLSQL packages for Outbound Interfaces
• Registering Request Sets in AOL
• Registering Custom Applications, Concurrent Programs.
• Defining Concurrent Programs and Executable
• Technical design documents preparation and building objects as per client requirements.
• Resolved many issues as per R12 standards.
• Transferred AOL objects using ITG kintana and FNDLOAD.

Environment: Oracle Apps Implementation Release R12 (Version), Modules: AP, GL, PO, INV, ZX and SQL, PL-SQL, Reports 10g/6i, Forms Personalization, XML or BI Publisher, Oracle Applications Framework(OAF), Oracle XML Gateway, Workflow, Putty, Winscp 3, Windows XP/2003 and Linux(Redhat) Server.

Confidential

Oracle Consultant

Responsibilities:

• Preparation of Technical Documentation like MD60, RD60
• Ensuring quality deliverables in time, Technical design for report customization and written PLSQL packages.
• Developed new BI reports using PLSQL Packages.
• Customizations of Miscellaneous Accrual Reconciliation Report.
• Developed Accrual Reconciliation Analysis BI Report.
• Remediated Shell Scripts to work with Email functionality and FTP in Linux environment.
• Remediated packages, procedures and functions for R12 environment.
• Remediated packages using UTL FILE, UTL SMTP.
• Remediated Oracle Reports as per R12 standards.
• Prepared and reviewed MD60 documents based on functional documents.
• Registration of custom applications, concurrent programs
• Defining of concurrent programs and executables.
• Customization of AP and PO Accrual Reconciliation Standard Report.
• Customization of Miscellaneous Accrual Reconciliation Standard Report.
• Developed Accrual Reconciliation Analysis BI Publisher Report.
• Technical design documents preparation and building objects as per client requirements.
• Registering Request Sets in AOL
• Registering Custom Applications, Concurrent Programs.
• Defining Concurrent Programs and Executable
• Technical design documents preparation and building objects as per client requirements.
• Resolved many issues as per R12 standards.
• Transferred AOL Objects using ITG Kintana.
• Peer review of the team objects as per functionality for final sign off delivery.

Environment: Oracle Apps Implementation Release R12 (Version), Modules: AP, GL, PO, INV, ZX and SQL, PL-SQL, Reports 10g/6i, Forms Personalization, XML or BI Publisher, Oracle XML Gateway, Workflow, Putty, Winscp 3, Windows XP/2003 and Linux(Exadata) Server.