SUMMARY:

• More than Fifteen Years of experience in providing services for implementing Oracle Applications and Oracle BI Solutions projects as Oracle EBS Architect and BI Architect for several clients.
• Extensive experience with R12 Oracle Apps with Financials, Manufacturing, Supply Chain, EDI, OTC, P2P modules, Oracle Service and data mapping of Oracle Functionality with Business requirements, Conversions, Interfaces, Solution Design for Customizations and development of RICE objects with various Oracle development tools.
• Extensive experience with Custom Data Warehouse design, Oracle Fusion Middleware 11g, OBIA, Financial, Supply Chain Analytical, Oracle ETL tool ODI, OBIEE, BI Publisher and Microsoft Power BI.
• Extensive experience with data base design\data model, ODI for mapping and data load, OBIEE for creating analysis and subject areas, Answers for creating dash boards and interactive reports and KPIs and BI Publisher for reports, Enterprise Manager and OBIEE Administration.
• Complete understanding of Oracle AIM methodology and preparation of MD050, MD070, and BR100 as per standards.
• As EBS Architect and BI Architect for several implementations, responsible for leading onsite and offshore teams, preparation of development standards, code review, preparation of installation and migration procedures, and production support.
• Extensive experience as Oracle Apps Techno - Functional, EBS Architect
• Extensive experience as Oracle BI Architect - OBIA, ODI, OBIEE, BI Publisher and Discoverer
• Extensive experience as EBS Architect - Oracle Applications, Tech Architect, EDI
• Extensive experience with 11i to R12 Upgrade and Re-implementation Projects
• Extensive experience with Oracle Fusion Middle Ware 11g BI Solutions for various industries
• Knowledge Transfer, Code Review, Migrations, Documentation and Production Support
• Extensive experience with Project Management, on-site and off-shore teams

SKILL:

Software: R12 Oracle Apps, Financials, Supply Chain, PL/SQL, RICE Objects & EDI Oracle Fusion Middleware, OBIA, ODI, OBIEE, BI Publisher, Discoverer

OS & Hardware: UNIX \ Windows, Microsoft Office Tools and Project Management Tools

EMPLOYMENT HISTORY:

Confidential

Oracle Apps R12.2 EBS Apps, Fusion Middleware 11g Sr. Apps Techno-Functional

Responsibilities:

• Work as Sr. Techno-Functional Consultant for EBS R12 Apps project.
• This project is implemented from legacy system and responsible for the RICEW objects and also gap analysis and solution design for various business requirements as EBS Consultant.
• My job includes gap analysis for financials and supply chain modules, GL, AR, AP and integration with Financials, PO, P2P and so on and technical solution design and mapping for various module transactions, development standards, code review and development of various RICE objects include interfaces, conversions, customizations using developer tools and converted several EBS reports using BI Publisher and testing, preparation of test scripts, test in multiple instances and so on.
• My job also involves design custom data ware house for Oracle BI solutions, ODI for data mapping and load, OBIEE to create analysis for various analytical reporting, analysis to create various dashboards and pages and analysis and interactive reporting.

Environment: Oracle Apps R12.2 Apps, Supply Chain, Developer Tools, ODI, OBIEE, BI Publisher

Confidential, PA

Oracle Apps R12.2 EBS Apps, Fusion Middleware 11g Sr. Apps Techno-Functional

Responsibilities:

• My job includes gap analysis for financials and supply chain modules, OM, PO, INV, Advanced Pricing and so on and technical solution design and mapping for various module transactions, development standards, code review and development of various RICE objects including interfaces, conversions, customizations using developer tools and converted several EBS reports using BI Publisher.
• My job also involves design custom data ware house for Oracle BI solutions, ODI for data mapping and load, OBIEE to create analysis for various analytical reporting, analysis to create various dashboards and pages and analysis and interactive reporting.

Environment: Oracle Apps R12.2 Apps, Supply Chain, Developer Tools, ODI, OBIEE, BI Publisher

Confidential

Oracle Apps R12 Financials R12 Sr. Techno-Functional

Responsibilities:

• Designed and developed PL/SQL packages for several transactions including conversions, using APIs, custom.pll and other custom objects related to Financials AP Module.
• Created document for OM sales order import process for large volume of transactions and import process strategy for analysis and decision making for the project manager and other custom objects related to OM, Install Base, Service Contracts, Oracle Service modules and project management team to decide the approach.
• Create several functional and technical documents as per Oracle Methodology including MD50, MD70, Conversion, Test Scripts and Migration documents.

Environment: Oracle Apps R12.2 Apps, Supply Chain, Developer Tools, ODI, OBIEE, BI Publisher

Confidential, CA

Oracle Apps R12 Apps and Oracle Fusion Middleware 11g Sr. Apps Techno-Functional

Responsibilities:

• Gap analysis, technical solution design and mapping for various module transactions, development standards, code review and development of various RICE objects including interfaces, conversions, customizations using developer tools, BI publisher, forms personalization and PL/SQL are some of my responsibilities.
• My responsibilities as an Architect for Oracle BI Apps Analytical, design data warehouse and schema, load data with ODI and design and development of various dash boards, reports and subject areas with OBIEE.
• Also responsible to lead Oracle developer and BI technical teams both on-site and off-site.
• My responsibilities also include preparation of development standards, code review, and development of complex interfaces, development of subject areas for BI apps for various business requirements, migration procedures, and production support.
• Oracle developer tools 10g, PL/SQL, BI Publisher, ODI, OBIEE, and Oracle BI Apps Analytical are used in this implementation.

Environment: Oracle Apps R12.2 Apps, Supply Chain, Developer Tools, ODI, OBIEE, BI Publisher

Confidential, CA

Oracle Apps R12, Manufacturing Techno-Functional Consultant

Responsibilities:

• My job mainly includes gap analysis for supply chain, OM, PO, Items, BOMS, WIP and financial modules and preparation of custom design solutions for various conversions\interfaces and custom objects.
• Designed and developed PL/SQL packages for several transactions including conversions, interfaces using APIs, custom.pll and other custom objects related to OM, Install Base, Service Contracts, Oracle Service modules and developed several custom objects using Forms Personalization related to Financials, Supply Chain modules.
• Design DW, loading .rpd files created with Noetix Views and Generator, Creating repositories, dash boards and several reports with OBIEE and Discoverer and providing user access as an administrator.
• ODI is used in this implementation and as BI Architect, designed data warehouse and schema and loaded data from custom applications using ODI.
• Defined development standards and prepared migration documents for the project and designed forms customizations, forms personalization and other XML Publisher requirements.

Environment: Oracle Apps R12, BI Apps, DW, Discoverer

Confidential, CA

Oracle Apps R12 Federal Financials, Supply Chain, BI Apps EBS Techno-Functional Consultant

Responsibilities:

• Designed and developed PL/SQL packages for several transactions including conversions, using APIs, custom.pll and other custom objects related to Financials, Supply Chain, and designed interfaces for all custom requirements and developed using PL/Sql processes for these modules for creating various high volume plans for OM, Items, BOM, WIP and other modules.
• Also design data warehouse and data model for dashboards and reports development.
• Oracle ODI tool is used for loading data from external systems into data warehouse schema.
• Oracle BI Apps Financial Analytical is used and modified several dash boards and reports related to financial modules using OBIEE.

Environment: Oracle Apps R12, Federal Financials, Procurement, Supply Chain, and other modules

Confidential, CA

Oracle Apps R12 Financials, OTC, P2P and other modules Techno-Functional & Architect

Responsibilities:

• Work as Sr. Consultant and Architect for Financials, OTC, OM, AR, P2P, Items, BOM, WIP and other modules related to Oracle Apps R12 re-implementation project.
• Designed and developed PL/SQL packages for several transactions including conversions, using APIs, custom.pll and other custom objects related to OM, Install Base, Service Contracts, Oracle Service modules and designed interfaces for all custom requirements and developed using PL/Sql processes for these modules for creating\updating service contracts, install base and order management transactions.
• Defined all development standards for the project and lead the technical team for development of custom forms, reports and interfaces using oracle developer tools.
• Designed very complex interfaces with third party software related to these modules and also with to OM, Install Base, Service Contracts and Shipping Execution modules.
• Designed Data Warehouse as per business reports requirements, designed the custom tables, views, loading the data with custom processes, and developed reports and dash boards using OBIEE.
• Data from external systems loaded using ODI into data warehouse schema. Also defined user roles, created email notifications and defined backup procedures.

Environment: Oracle Apps R12, Data Warehouse, ODI, OBIEE, Developer Tools 10g, and PL/SQL

Confidential, CA

Oracle Apps R12 OTC, P2P, Financials and other modules Sr. Techno-Functional Consultant

Responsibilities:

• Designed several interfaces with third party systems and several customizations with to business requirements and gap analysis related to several modules including OM, Shipping, EDI, PO and other financial modules.
• Defined all development standards for the project and lead the technical team for development of custom forms, reports and interfaces using oracle developer tools and using SOA and B2B.
• Also involved in production support for these modules and involved in change management for various objects after go-live and production support.
• Designed data warehouse schema, loading data using Noetix, and designed several dash boards and reports using OBIEE for various business requirements related to financials and OTC modules.

Environment: Oracle Apps R12 e-Commerce Gateway and Oracle Developer Tools 6i\10g, PL/SQL

Confidential

Oracle Apps 11i\R12 SOA, B2B, 3PL, EDI, OTC and other modules Sr. Techno-Functional

Responsibilities:

• Designed several interfaces and customizations and involved in the preparation of several solution design documents, development of standards and leading the technical team for the development of customizations and interfaces related to all modules.
• Several interfaces designed and developed such as XML interfaces using SOA Middleware and B2B and also several 3PL transactions with external systems and warehouses.
• For various reporting purposes and reporting analysis, data warehouse schema and OBIEE is used to design dash boards and developed reports.

Environment: Oracle Apps 11i\R12 P2P, OM, AR and Developer Tools, PL/SQL, Discoverer, EDI

Confidential, GA

Oracle Apps 11i\R12, SOA, B2B and other modules Sr. Techno-Functional Consultant

Responsibilities:

• Work for the implementation of ERP using Oracle Applications Release 11i/R12. My job mainly related to design of RICE objects which include all conversions, interfaces, and customizations, reports related to all financials and manufacturing modules.
• All the Financials include GL, AP set ups related to Vendors, AR, As Sr. Technical Lead, get the functional and design documents for the approval of the project management team Confidential various levels and RICE objects are developed and tested as per the standards before migrating to other instances.
• As BI Architect, designed Data Warehouse and loading the EBS objects and tables using Noetix views into Data Warehouse, import with OBIEE and performing all administrative tasks.
• Developed various reports using OBIEE related to all financial modules and Supply Chain and Order Management modules and created subject areas for these modules for various reports.

Environment: Oracle Apps Release 11i\R12, EDI, e-Commerce-Gateway and Oracle Developer Tools

Confidential, NJ

Oracle R12, Financials, OLFM, Supply Chain & other Module Sr. Techno-Functional & Architect

Responsibilities:

• My job mainly related to design and development of RICE objects which include all conversions, interfaces, and customizations, reports related to all financials and manufacturing modules.
• All the Financials include GL, AP set ups related to Vendors, AR, Manufacturing and Distribution modules data is converted from Legacy to Oracle designed and developed interfaces with legacy systems and integrated with Oracle Applications.
• As Sr. Technical, designed and developed various interfaces from legacy systems to relate to all Financials modules, Inventory, Purchasing and Order Management modules.

Environment: Oracle Apps Release 11i\R12, OLFM, SOA, BPEL, B2B and Oracle Developer Tools

Confidential, CA

Oracle Apps 11i, Financials, Supply Chain and Other Modules Sr. Technical Lead

Responsibilities:

• Work for the Implementation of ERP using Oracle Applications Release 11i.
• My job mainly related to design and development of conversions, interfaces, Customizations, Custom Forms, Reports, RICE and all Technical design and solutions.
• All Financials and Manufacturing data from legacy systems is converted into Oracle Applications and also legacy data from legacy systems integrated with Oracle applications through several interfaces.
• Also responsible for design all the modifications of several standard Oracle forms using Developer 6i tools Forms 6i.

Environment: Oracle Apps Release 11i, PL/SQL, APIs, SOA, Developer 6i Forms 6i, Reports 6i, XML