Objective: Seeking a responsible role as a Techno-Functional Analyst in Oracle E-Business Suit EBS , versions 11i and R12.

Professional Summary:

• Have over 8 Years of Oracle Application experience. Experience in Implementing Oracle ERP Applications R12/11i/. Expertise includes Analysis, Design, Development, Deployment, Testing and Training of complex systems, delivering the required functionality and system performance to the client's needs.
• Implemented multiple full life cycle projects. Expert in global implementations, onsite-offshore support models and upgrade of Oracle applications with multiple deployments. Vast experience in Localizations, Data Conversions, Integrations Merger and Acquisitions , consolidations, GAP Analysis, System Configurations, Test Plan preparations, Unit Testing and On-Demand Production support.
• Extensive Functional experience in Oracle Financials GL, AR, AP FA , Supply Chain PO, OM, INV, SC, BOM, WIP, ENG MRP , Oracle Projects Billing and Costing , CRM Sales Support Quoting, Service iSupport , HRMS, Oracle Self Service Modules OTL, iExpense, iProcurement, iSupplier , Multi-Org and TCA Architecture.
• Exposure in Oracle Apps Release 12 futures like SLA, eBusiness Tax Oracle Payments. Ability to gather and analyze system requirements and design and develop specifications for the business solution in liaison with the Business Users Community
• Experience in various industries like Electronics, Telecom, Gaming, Software and Medical with strong analytical and trouble-shooting skills.
• Worked on Full Life Cycle Implementations by demonstrating excellent technical skills in Reports, Interfaces, Conversions, Customizations/Extensions and Workflow RICEW components in the domain of Oracle Applications E-Business Suite.
• Immense experience in various development languages and tools like SQL, PL/SQL, Developer 6i, Oracle Workflow, XML Publisher, Oracle Financial Analyzer, Oracle Configurator, AK Developer, Approval Management Engine AME , Application Desktop Integrator ADI , FSG Reports, Oracle Discoverer, HTML, Pro c, Java, JSP, SQL Loader, EDI, APPWORX, Test Director, C C.
• Hands-On Experienced in developing solutions using Java/J2EE technologies, HTML, JSP, XML, Oracle Applications Framework OAF / Application Development Framework ADF using Oracle Jdeveloper.
• Expertise in Application System Administration. Activities like user setup, defining responsibilities, values sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs and providing support to apps users for any Technical or functional issues.
• Proficiency in Application tuning and Query optimization. SQL Query tuning using explain Plan, SQL Trace and TKPROF.

COMPUTER SKILLS:

• ERP : Oracle Applications Release 10.7, 11.0.3, 11.5.10 Release 12
• General Ledger GL , Oracle Application Developer AOL , System Administration, Oracle Receivables AR , Oracle Payables AP , Fixed Assets FA , Order Management OM , Install Base IB , Service Contracts SC , Inventory INV , Bill Of Materials BOM , Work In Process WIP , Oracle Engineering ECO , Oracle Purchasing PO , Oracle Projects Billing and Costing , Advance Planning and Scheduling APS , Supply Chain Management, Oracle Workflow, iProcurement, iExpense, Sourcing, iSupplier, iSupport, Teleservices, Sales Online, Quoting, Oracle Alerts, Oracle Configurator, Oracle Accelerator, Oracle Discoverer, HRMS/Payroll, Oracle Advanced Benefits OAB , Oracle Absence Management OAM , Employee Self Service ESS , Manager Self Service MSS , Oracle time and Labor OTL , Oracle Configurator, Ecommerce Gateway EDI , OPM Batch Management and OPM Manufacturing
• Operating System : Windows'NT, 2000 2003, Linux, MS-DOS.
• Languages : Pro C, C , Java, JSP, JDBC, J2EE.
• Database : ORACLE 8i/9i/10g/11g.
• Oracle Tools : SQL Loader, Oracle Forms and Reports 10g/6i,
• Oracle Apex 4.0, TOAD, Oracle Discoverer, EDI, FSG, PL/SQL, XML Publisher, JDeveloper, AK Developer, OAF and Visual basic.
• Web Technologies : DHTML, XML, JSP, JavaScript, JSON, Amazon Web Services.

PROJECT EXPERIENCE SUMMARY

Confidential

Software : Oracle Apps R12, AOL, GL, AP, AR, E-Commerce Gateway, PL/SQL, Oracle Forms and Reports 10g, XML/BI Publisher, Amazon Coral Framework, Amazon AWS, JSON, Oracle Workflow, Oracle Applications Framework

Role and Responsibility:

As a Senior Oracle consultant,

1. Enhanced existing custom AP Invoice import to support various currencies and marketplaces.

2. As part of Amazon Kindle's global expansion program, designed a solution to integrate Deutsche Bank's FX4Cash platform with vendor payments for global remittances

3. Designed and developed a Remittance Landing platform to integrate Amazon Web Services with Payments.

4. Enhanced Employee iExpense portal to expand self-service by allowing Amazon employees to add Bank account information for disbursements instead of manually sending a voided check for verification.

5. Participated in Month-end Closing activities technically in resolving issues or writing adhoc queries

6. Customized Remittance Email Advice APPWFE to use email vendors based on invoice marketplace and vendor pay groups

7. Designed and customized various XML Publisher reports like Employee Expense Report, PO Print, and Account Analysis Report etc.

8. Participated in code migration activities by creating Loader Data files LDTs for every customization.

II. Title: Sr. Oracle Applications Functional

Confidential

• Software : Oracle Apps R12, AOL, GL, AP, AR, PO, INV, OM, E-Commerce
• Gateway, PL/SQL, Oracle Forms and Reports 10g, XML/BI Publisher, Discoverer,
• Soap UI, Workflow 2.6.3.

Role and Responsibility:

As a senior oracle Functional consultant,

1. Involved in understanding the requirements, providing solutions, designing and developing the application.

2. Support team technically in resolving issues review the code, making sure no slippage in quality and delivery dates.

3. Designed various XML Publisher reports like PO Print, AR Invoice, Check Print, OM SOA and RMA doc.

4. Developed Project Billing Invoice and Revenue Extensions.

5. Customized the Accounting codes for project related accounting transactions using Projects Auto Accounting rules and Account Generator workflows like PO, Project supplier invoice and Expense Report.

6. Designed interface programs for integration of OM orders, customers, products and price list with Sales Force SFDC .

7. Designed EDI 856 Inbound process to import the ASNs from suppliers. The process does custom validations and sends an 824 outbound process back to the suppliers in case of any failed validations. An included workflow component helps in deciding which shipments to reject.

8. Designed and developed a custom program to update the B2B Purchase Orders and PO Requisitions as soon as the Sales Order is updated.

9. Worked on Interfacing multiple vendors with Oracle purchasing using various SCM EDI interfaces such as EDI 855, EDI 824, EDI 860

10. Developed shell scripts to schedule Oracle concurrent programs from BMC Control-M.

11. Developed outbound interface program to transfer Invoice and GL extracts from Oracle to multiple external systems such as PeopleSoft, Starbod, CMS etc.

12. Participated and supported users in testing the system End-to-End, providing ad-hoc queries whenever needed.

13. As part of Conversions from the legacy main frame systems, developed Sales Order and Item conversions.

14. Customized the OM Order Header Workflow to modify the Standard Sales Order closing logic.

15. Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and BI/XML Publisher

16. Designed and developed custom form to enable user to edit DFF information on Receiving Transactions using Oracle Forms

17. As post go-live activity, currently supporting and enhancing the solution to meet the necessities

18. Gathered and document new requirements to enhance the existing design

II. Title: Sr. Oracle Applications Functional

Confidential

Software : Oracle Apps R12 OM, AR, PO, INV and Projects , Oracle 10g, Forms 10g, Reports 10g, OSA, BPEL, AME, ADF, XML Designer, XML Publisher, OA Framework, JDeveloper 10g, PVCS and Workflow 2.6

Role and Responsibility:

As a senior oracle Techno-Functional consultant,

1. Significant experience in deploying Oracle applications in a FDA regulated Computer Systems validation environment.

2. Leverage Phase Review Discipline for quality deliverables in a SDLC using vigorous design, development and code review processes.

3. Designed conversions to import the patients and prescriptions information from various pharmacies into Oracle EBS.

4. Developed custom Adjudication process to calculate coverage and co-pay amounts used for billing purposes.

5. Created a custom APEX application for integrating the conversion process.

6. Involved in the design and development of data models using MySQL Workbench.

7. Undergoing the current development phase in Sprint/Agile methodology with a very short turnaround time.

8. Customized and converted the AR invoices, consolidated invoices and PO report into PDF Output Using the BI Publisher.

9. Developed automation of email/print/fax AR Invoices and consolidated Invoices using the BI Publisher Bursting control program.

10. Provided production support in the areas of OM, INV, CM, AR and PO modules.

11. Developed common utilities wrapper PL/SQL package, generates a XML Payload, to raise the business events, to handle Bulk load process and to handle error message.

12. Developed a report in discoverer to show all purchase orders receipts transacted by PO creator.

III. Sr.Oracle Applications Techno-Functional Consultant

Confidential

Software : Oracle Apps 11.5.10, R12 OM, AR, PO, INV and Projects , Oracle9i, Forms 10g, Reports 10g, Java, JSP, XML Designer, XML Publisher, OA Framework, and Workflow 2.6.3.

Role and Responsibility:

As a senior oracle Techno-Functional consultant,

• 1. Developed various conversion programs Customers, Suppliers, Employees, AR Invoices, Open PO's, and Journals...etc using Oracle Apps standard API's and Open Interface programs through advance PL/SQL features.
• 2. Work on Prototypes and proof of concepts on Project Accounting, Purchasing and Account Payable modules.
• 3. Developed Interfaces to create internal Purchase Order Requisitions and Purchase Orders.
• 4. Lead offshore team in developing Item Conversion program to import Items from custom applications at terminated manufacturing plants.
• 5. Developed Conversion program to import customer information corresponding to Obsolete Operating Units to the AR of Sony DADC using TCA APIs
• 6. Developed inbound interfaces for major US Courier services to update the packlists with shipment information and to generate freight invoices for the customers.
• 7. Enhanced the Sony Shipping Application to provide compatibility with FedEx Caf system used at Sony shipping department.
• 8. Responsible for support activities on an on-demand basis for both custom applications and Oracle Applications.
• 9. Designed and customized custom Forms using Oracle Forms 6i
• 10. Developed a custom BOM interface using APIs to load BOM from custom application
• 11. Developed a WIP Late Job Reason program to determine the late reasons of delayed Shop floor jobs.
• 12. Customized standard PO Approval workflow to send user notifications for PO approvals based on preset the approval limits
• 13. Resolved Production Support tickets with a quick turnover time.
• 14. As part of tuning, created Indexes, Histograms on tables when necessary and made sure the cost of the query executions meets the standards set by the Sony DBAs.
• 15. Documented the development process as per AIM standards and Sony norms for each object along with the test cases.
• 16. Involved in Functional specification writing and successful testing for Project Accounting Budget conversion, Bill rate schedules conversion and Billing events conversion.
• 17. Developed custom Reports in Oracle Discoverer.

IV. Title: Oracle Applications Techno-Functional Consultant

Confidential

Software : Oracle Apps 11.5.10 OM, AR, PO, INV and Projects , Oracle9i, Forms 6i, Reports 6i, Java, JSP, XML Designer, Oracle BPEL 10g, Discoverer 10g, Informatica Power center 8.1, XML Publisher, OA Framework, JDeveloper10g and Workflow 2.6, Quoting.

Role and Responsibility:

1. Gathered different EDI Transaction requirements from the client.

2. Involved in the development of Reports, Interfaces, Conversions, Extensions customization of Workflow in Order Management, Inventory, AP, Purchasing and Quoting, Receivables, Payables.

3. Designed and developed the following Conversions during obsolescing the Operating Units

o AR Customer TCA

o AR Invoice

o Item Import

4. Designed and developed a custom Application called SALES application that is being widely used across the organization to track the Sales performance. This Application is tightly integrated with the Quoting, OM, HRMS modules of Oracle Applications with multiple inbound and outbound interfaces.

5. Used Informatica as ETL for consistently moving the data from multiple sources into staging area.

6. Designed and developed a custom program to assign / Un-assign Item statuses using the item interface.

7. Customized the standard oracle reports such as AR Aging Report, AR Invoice Print Report, Inventory Cycle Count Report, Transaction Register Report, Payment Receipt Report and converted them to XML Publisher format

8. Developed Summary, Detail and Matrix Reports using Discoverer 10g.

9. As Discoverer Administrator, monitored activities such as assigning User/Responsibility securities, Production code deployment.

10. Designed and developed custom Ship Confirm Form based on the business requirements using Forms 6i.

11. Created triggers on order lines to perform custom validations.

12. Optimized the performance of Reports and Concurrent Programs by using the Materialized view concept, Indexes, Histograms, and Hints etc.

13. Designed and developed custom workflow Item types to send notifications from Concurrent Programs/PL-SQL procedures.

14. Provided Level 2 support to the business users to identify the problem and give a quick solution.

15. Actively interacted with users in gathering requirements for development. Prepared standard AIM documentation for each object undertaken.

16. Oracle B2B Integration Server trading partner, Document Protocol, Agreements etc.,

17. E-Business Suite responsibilities

o XML Gateway Partner setups

o XML Gateway Mappings Customization XGM Changes

o Customer address DUNNS setup

o Customer Item Setups

V. Title: Oracle Applications Techno-Functional Consultant

Confidential

Software : Oracle Apps 11.5.10 GL, AR, AP, FA, CM, PO, INV, BOM, WIP, Projects, OM, iSupport, Sales Online, Quoting, Service Contracts and InstalBase , Oracle9i, Forms 6i, Reports 6i, Java, JSP, XML Publisher, OA Framework, JDeveloper and Workflow 2.6

Role and Responsibility:

As a senior oracle Application consultant and ongoing Support Manager

1. Customized the Accounting codes for project related accounting transactions using Projects Auto Accounting rules and Account Generator workflows like PO, Project supplier invoice and Expense Report.
2. Responsible for development of open interface for interfacing AR transactions from legacy system into AR in Oracle Applications
3. Used Oracle API's across the customization of the Order to Cash process.
4. Used SQL Loader and UNIX shell scripting to load data for the orders in 11.5.10 instance.
5. Created new Oracle Reports and Customized standard Oracle Reports using Reports 9i
6. Created custom utility packages in PL/SQL.
7. Developed and designed various reports using XML Publisher.
8. Developed and migrated Reports using Discoverer 4i for on-site users.
9. Developed Project Billing Invoice and Revenue Extensions.
10. Developed various Oracle Reports, Discoverer reports and XML Publisher reports.
11. Customized the AR Revenue Recognition program based on business requirements for service items.
12. Developed various conversion programs Customers, Suppliers, Employees, AR Invoices, Open PO's, Service Request, Journals...etc using Oracle Apps standard API's and Open Interface programs through advance PL/SQL features.
13. Configure the Knowledge Base and content management as a part of iSupport implementation.

VI. Title: Oracle Applications Techno-Functional

Confidential

Software : Oracle Application 11.5.10 , Oracle8i, Forms 6i, Reports 6i, XML Publisher, EDI, Discoverer 4i and Workflow 2.6

Role and Responsibility:

As a senior oracle Apps Supply chain consultant

1. Understand and Analyze the End-Users problems in prod instance and provide them a solution which can be oracle workaround or feasible through customization.
2. Involved in complete life cycle of Procure to Pay
3. Responsible for Item Master set up and loading using Item Master Open Interface.
4. Developed a custom program for GL Interface.
5. Developed item conversion to load data about the Items form legacy system into oracle applications by writing SQL loader scripts and PL/SQL scripts.
6. Developed Payables open interface import to load the data to the base tables
7. Customized Customer Listing Summary in Receivables based on the requirements.
8. Involved in optimizing the performance of database objects
9. Designed Technical specs in MD 70 using Standards AIM
10. Developed custom reports such as AP check summary report, Cost Paid Invoice Distribution Report.
11. Act as a bridge between the business users and the technical team to support the daily prod issues.
12. Involved in customizing the Oracle Workflows - Requisition Approval, and PO Requisition Account Generator as per the business requirements.

VII. Title Oracle Applications Techno-Functional

Confidential

Software : Oracle Application 11.5.10 GL, AR, AP, FA, OE/OM, PO, HRMS, EDI, INV, BOM, WIP, Service Contracts and Self Service Modules like OTL, iExpense iProcurement , Oracle 10g, PL/SQL, XML Publisher, Developer 6i, Discoverer, Java, JDeveloper, OA Framework, JSP, SQL Loader, Configurator and Workflow 2.6

Role and Responsibility:

1. Prepared the development standards and installation manuals, Involved in developing installation and migration scripts.
2. Worked on RA Customer Interface TCA to import customer data into Oracle Customer base tables. Performed various validations on the staging table to check the validity of data.
3. Developed Item Interface process to Create and Bulk update Items
4. Customized various reports such as Inventory Quantity Summary Report for classification of the material.
5. Developed custom Interface Program to load on-hand inventory transactions from external flat files into Interface tables.
6. Created Vendor Audit Report to display vendor information, with incomplete addresses and contact Information.
7. Customized Standard Suppliers Form, forced e mail field to uppercase, made description field required.
8. Created Workflow based on Purchasing Approval Solution in Oracle Workflow 2.6
9. Designing and Configuring Work structures, Job, Grade, and Organizations in HRMS.
10. Generic Programs were developed for Migrating the Employee and related data and was used across different Business Groups resulting in reduced implementation time. Provided various customized reports like Employee Head Count, New Hire Details, Compensation details, Assignment History etc.
11. Developed various conversion programs Customers, Suppliers, Sales orders, PO, Items...etc using Oracle Apps standard API and Open Interface programs through advance Oracle9i PL/SQL features.
12. Involved in developing major customization using Oracle Developer Suite tools like Oracle Forms Reports, XML Publisher, Forms Personalization, Oracle Discoverer reports and workflow customization.