SUMMARY

• Around 7 years of experience in Oracle Apps eBusiness Suit (11i and R12) design, development & implementation of various projects.
• Worked as Sr Oracle Apps Techno Functional consultant and Oracle Apps EBS Developer during my experience period.
• Possess good techno - functional knowledge of various modules in Oracle Applications (Financials, Procure to Pay(P2P),Supply Chain and Project Accounting modules and OLM ) and database design principles and Oracle Development tools(Form Builder, Report Builder, Workflow Builder, jDeveloper and XML Publisher) along with good analytical and communication skills
• Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Order Management(OM),Inventory(INV),General Ledger(GL),Accounts Receivable(AR),Accounts Payables(AP),Purchasing (PO), BOM.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Expertise on designing and implementingOracle AlertsandLookups.
• Well experienced with SCM modules(Inventory, BOM, WIP, Engeering, OM and AR)design, configuration and support
• Designed and developed various interfaces to import Orders, Bill of Material, Items to Oracle ERP
• Developed various BI/XML publisher reports as part modernizing the Payment process in R12
• Well versed with all the IBY tables and related API’s
• Well versed with R12 Vendor, Vendor sites and Bank interface and API’s
• Very good working knowledge on all types Order processing including WIP, Engineering, BOM and inventory
• Supported different ERP business teams by resolving various issues included but not limited to Oracle Applications forms access, log in issues, data issues, master data creation issue and data import and extract issues
• Expertise in designing pre-conversion strategies and setup dependences for all the Financials Supply Chain conversions
• Expertise in creating conversion mapping documents from legacy systems to Oracle and from Oracle to Oracle
• Expertise in designing MD50 and MD70 for all the extensions in Oracle eBusiness suite modules
• Expertise in creation of migration scripts(LDT’s) and install instructions/migration documents(MD120) for all RICE/CEMLI objects
• Hands on experience in designing and developing Applications Extensions(CEMLI/RICE) objects
• Expertise in troubling shooting issues in RICE objects as part of R12-up-gradation and re-implementations
• Re-designed and developed all (CEMLI/RICE)objects in R12 from 11i
• Well versed with Oracle Workflow customizations and creation of new workflows as per the business requirements
• Well versed with Oracle OAF Personalization/Extensions and customizations and Oracle JDeveloper
• Expertise in converting RDF reports to BI Publishers reports in R12 using XML Publishers converter utility
• Hands on experience on writing PL/SQL procedure, Functions and Packages with best coding standards (Implemented PL/SQL Collections for better performance)

TECHNICAL SKILLS

Oracle Applications: Oracle Applications 11i, R12 Modules like Financial Accounting Hub/ Sub-Ledger Accounting(FAH/SLA), General Ledger(GL), Payables (AP),iProcurement(iProc),,Cash Management(CM), Purchasing(PO), Receivables (AR), Order Management (OM), Application Object Library (AOL) and System Administrator.

Languages: SQL, PL/SQL, C, C++, Unix, HTML, and Java Scripts

Databases: Oracle 11g/10g/9i

Software Tools: Toad, SQL*Loader, PL/SQL Developer, Putty, WinScp, Filezille, SQL*PLUS, Data Loader, Quality Center (QC), HP Service Management (HPSM)

GUI Tools: Oracle Reports, XML(BI) Publisher, Workflow Builder 2.6

Operating Systems: Windows 7/8/NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Oracle apps Technical Consultant

Responsibilities:

• Worked on the development of Interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, AR, PO and AP.
• Developed new forms and customized existing forms in the AP module according to the client’s requirements.
• Created a package and seeded wrapper program to delete/move the file from source location to submit the seed request and then move the file to archive folder.
• DevelopedData ConversionsandInterface Programs. UsedSQL * Loaderto Load Data into Oracle Database
• DevelopedOrder Management,Inventory, Receivablesqueries to compare summary information of the standard and custom reports.
• Involved inPerformance tuningof various queries and stored procedures.
• Designed and DevelopedStored procedures,FunctionsandTriggersinPL/SQLto implement complex business rules.
• MigratedGLandAPcustom interfaces and reports, during oracle financials upgrade project.
• Customized the credit analysis report, trucking manifest and pick slip reports in Order Management (OM).
• Developed a program for Auto Invoice Interface to import customer invoices, Credit and Debit memos in receivables.
• Worked on GL Conversion for One time conversion of GL journal entries from release 11i to release r12 of General Ledger module.
• Validated Custom Scripts in 11i and made the changes in R12 standard script.
• Provided technical support on oracle payables, oracle receivables, purchasing, procure to pay and oracle inventory modules.
• Created several RFC’s and new jobset as per the client requirement to submit Auto invoice on particular day and time.
• Well versed with client server environment and tools like sql*plus, PL/SQL, Toad, Oracle Forms and Reports.
• Developed the Triggers for implementing the complex business rules.
• Interacted with the users, fixed bugs, developed test plans and provided daily production support.
• Designed and configured a ETL integration from external vendors to import Orders to Oracle
• Developed test cases and templates to test the custom report migration process.
• Developed PL/SQL batch jobs using UNIX Shell scripting.
• Performed Various System Administrator activities like defining a concurrent program, creating users, creating menus, creating responsibilities.
• Register generatedreports, forms,Flex fields. DefinedDescriptive Flex fields,value setsand also registeredPL/SQLstored procedures,SQL*Plusscripts etc.
• Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
• Customized standard reports such asARCustomer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.
• Raising Oracle Service Request, Providing requested information, implementing resolution and communicating to the users.
• Involved in setting up a new operating unit for Brazil, which involved in developing new process, item conversion, Order Management workflow customization, SLA changes to derive COGS account based on OU and the item category, various org specific XML reports
• Involved in the day to day activities of Production Support of oracle application environment in AP, AR, INV, OM and GL modules.
• Developed various complex SCM SQL extracts which helped business uses to audit daily transaction flows

Environment: Oracle Applications 12.1.2, Oracle 10g, PL/SQL, SQL, Forms 9i, Reports 9i, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2, UNIX, XML Publisher, Discoverer.

Confidential, NYC, NY

Responsibilities:

• Communicated with business users about the implementation and requirement gathering questionnaire, explaining oracle’s functionality extension from R12 vs. 11.5.10 within oracle financials and Purchasing.
• Analyzed business requirements, designed, implemented business solution design and development.
• Designed and implemented customSummary Billing Utility in AR with integration to Trading Community and Receivables.Implementation involves design and development of various objects using Oracle SQL & PLSQL, Oracle Forms, Oracle Reports and Oracle Discoverer.
• Analyzed the requirements, performing risk analysis and mapping the business processes. Understanding the gaps, recommended the necessary customizations.
• Developed various PL/SQL process as part of inventory managing which involved in assigning items to new org’s, item components to child orgs in bill of materials, modification to item category and price lists
• Worked on various workflow customizations across SCM modules including Order Management and Purchasing
• Developed various XML reports across SMC and Financials modules
• Responsible for troubleshooting and resolving day to day production tickets across supply Chain and Order to Cash modules includes (OM, Inv, BOM, Engeering, WIP and AR)
• Worked on customizing various workflows as part of custom Order processing and custom ATO process
• As part of ATO order processing, configured custom templates to create WIP job and integrated with custom PLM system to import Bill Of Material to Oracle BOM
• As we have different Inventory systems along with Oracle Inventory, integrated all inventories along with Global Oracle order systems
• Developed various alerts as part of ATO order processing
• Supported various ECO (Engineering Change Orders) with custom inventory import
• Supported users to smooth period close in all sub ledger modules
• Designed and configured a ETL integration from external vendors to import Orders to Oracle
• Supported Inventory business teams buy resolving item transfer and move orders transactions

Environment: Oracle Apps R12.1.3 (SLA/FAH, GL, AP, PO), Oracle 10g, PL/SQL, Reports 10g, SQL*Loader, Data loader, PL/SQL Developer, UNIX, XML Publisher, Discoverer 10g.

Confidential, Louisville, KY

Techno Functional Support Analyst

Responsibilities:

• Communicated with business users about the implementation and requirement gathering questionnaire, explaining oracle’s functionality extension from R12 vs. 11.5.10 within oracle financials and Purchasing.
• Analyzed business requirements, designed, implemented business solution design and development.
• Authored Functional design documents (MD050) and Technical Design Documents (MD070) for customization and development of interfaces, reports and extensions across various financial/Procurement modules, interacting with business users.
• Developed lots of custom reports using XML Publisher.
• Responsible for troubleshooting and resolving day to day production tickets across supply Chain and Order to Cash modules includes (OM, Inv, BOM, Engeering, WIP and AR)
• Developed various complex SCM SQL extracts which helped business uses to audit daily transaction flows
• Worked on customizing various workflows as part of custom Order processing and custom ATO process
• As part of ATO order processing, configured custom templates to create WIP job and integrated with custom PLM system to import Bill Of Material to Oracle BOM
• As we have different Inventory systems along with Oracle Inventory, integrated all inventories along with Global Oracle order systems
• Developed various alerts as part of ATO order processing
• Designed and implemented various Conversions including Suppliers and GL Actual from legacy 11.5.10 into R12.
• Designed and configured a ETL integration from external vendors to import Orders to Oracle
• Worked in various phases of project from process design, development to unit testing, performance testing, regression testing, UAT, pre-production and post-go live support.

Environment: Oracle Apps R12.1.3 (SLA/FAH, GL, AP, PO), Oracle 10g, PL/SQL, Reports 10g, SQL*Loader, PL/SQL Developer and UNIX, SQL*Loader, Toad, Oracle Workflow, XML Publisher, Discoverer 10g.

Confidential, Houston TX

Sr. Oracle Apps Techno Functional Consultant/Apps Developer

Responsibilities:

• Responsible for Oracle eBusiness(Financials & Project) production environment of LA Metro
• Worked with Business users to resolve the production tickets across all modules
• Developed various complex BI publisher reports
• Developed Payable invoice interface for 7 different vendors and 3 Payable payment interface (Outbound) to BOA
• Supported business users by resolving day to day production tickets
• Worked on various period closing issues in Payables
• Developed a custom form to maintain TAX rates across Oracle eBusiness
• Developed various custom workflows and resolved issues in custom workflow
• Configured Cash Management bank transaction codes and developed interface in Cash Management to load bank statements
• Worked on AR auto invoice and lock box interface in Receivables
• Developed and converted various reports to BI Publisher
• Converted AR invoice printing report and used XML Bursting process to print customer based invoice
• Resolved various issues as part GL interface loading
• Personalized various iExpenses pages based on customer requirements
• Extended OAF pages in iExpenses
• Configured custom AOL messages in OAF pages by extending iExpenses pages
• Developed various Oracle Alerts

Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX.

Confidential, Grafton, WI

Sr. Oracle Apps Techno Functional Consultant/Apps Developer

Responsibilities:

• As a senior Oracle Apps Techno Functional consultant at on site, my primary job function was to responsible for all the module extensions (RICE/CEMLI) objects and conversions from 11i to R12 part of R12 re-implementation(Financial, Procure to Pay(P2P), Order to Cash (O2C), Supply Chain and Project Accounting modules) modules
• As part of 11i SCM production support team, researched, coordinated with Oracle through Oracle SR and resolved various complex production issues
• Customized PTO and ATO Order process to satisfy global requirements
• Reviewed key processes for OM, WIP processes to identify the product gaps in key Order fulfillment processes like Back to back orders for service orders, Order Enquiry, ATP check, Quick order Quote
• Supported Transacting Inventory
• Trouble shoot performance issues with Trip stop
• Presented the gaps for key process to Oracle development team to include in next releases
• As part of R12 re-implementation, Developed various conversion processes(Supplier, Customers, Item, Banks and Transactional Data) from 11i systems to R12 system
• Approval workflow, Account Generator and Invoice Approval Workflow
• Created a brand new workflow as part of custom Supplier Lifecycle Management functionality implementation
• Involved in creation custom OBIEE dashboards source as Oracle SCM modules
• Resolved various Order process issues like shipping transaction is not completed, shipped but not invoiced struck in AR auto invoice
• Resolved various issues as part of BOM importing
• Developed various reports which helped shipping label printing
• Resolved various cycle counting issue as part of period closing

Environment: Financials (AR), SCM modules, SQL, PL-SQL, Workflow, Reports, SQL*Loader

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• This project involved in production support and new technical development
• Setting up Accounting flex fields, Defining Journal Sources, Journal categories, Document sequences and their assignment, Chart of Accounts maintenance.
• Involved in Oracle Apps 11i financials production support
• Developed various custom reports in General Ledger module as per the customer requirement to stream line period end activates
• Involved in Development and Customization of Oracle forms
• Financial reporting - Oracle Standard reports (GL) developed using Financial Statement Generator (FSG), Account Analysis reports development, Trial balance reports development.
• Generation and analysis of Consolidation reports like Consolidation Exception reports, Journals report, Consolidation rules report, Summary Trial balance reports, etc.
• Month end and Year end reconciliations for closure of subledger modules - AR and AP.

Environment: SQL, PL-SQL, SQL*Loader, Forms (4.5), Reports 6i, Financials (AP, AR), UNIX.