SUMMARY:

• Confidential having 13.4 years of IT Experience in Architecting, Analysis & Design, Development, Implementation, Customization, Systems Production Support & Maintenance Oracle eBusiness Suits R12/ Oracle PIM/ Oracle Cloud PDH /Data Quality/ Data Governance.
• Extensive experience in Oracle Application R12, 11i - Oracle PIM, Order management, Shipping.
• 10 + years of Oracle ERP Technical lead in O2C, P2P, C2C side .
• 5+ years of designing and developing in Oracle PIM/Oracle Cloud PDH.
• As SME of Oracle capability was part of pre - sales team involved client engagement, proposal development, estimation and solution plan. Have also presented tools automation to multiple potential clients.
• Worked in different domain like Inventory Management, Order Management, Supply chain management, Account receivable, Account payable, Purchasing, BOM etc in Data Conversion / Data migration/Interface design between different systems and OAF module.
• Worked in Oracle Master Data Management for Product Hub and Customer Hub.
• Using ODI (Oracle Data Integrator) Design and Develop conversions like Item, User Defined Attributes, and item catalog Category, item and UDA Translation.
• Very strong in conversion and interfaces. Worked on many APIs in Order to cash, Shipping, Service Contract, Purchasing and Financial area.
• Design the architecture for whole program flow, error handling strategy in conversions and interfaces.
• Significant work in sending files from UNIX server to mainframe and windows server through plsql packages.
• Significant work with the shipping interfaces between Oracle and TL2000 system in order management.
• Significant work in OAF pages development.
• Worked on TCA APIs.
• Worked on new R12 Shipping Notification Workflow.
• Worked on Oracle business events.
• Experience in development using SQL including DCL, DDL and DML experience, PL/SQL, stored Procedures, triggers and Packages, Forms, Reports, Workflow, FTP, Oracle Application Framework(OAF).
• Experience in reporting tools like Oracle report 6i, Oracle XML publishers.
• Currently working in Master Data Management for Product Hub (PIM/PDH) with ODI.
• Oracle AIM Methodology - MD070, CV060
• EDI ASC X12 transactions like 830,850,860,824,856 in purchasing.
• Worked on multiple development projects in PIM from 2008.
• Worked in Confidential in multiple PIM POC and implementation projects .
• Configured and Integrated PIM with BRM.
• Configured Oracle cloud PDH and did the conversion.
• Configured NIR and CO work flow both in R12 and cloud environment.
• Integrated PIM with SOA and worked with PIM/ODI integration.
• Configured PIM for different Industry like Retail/ Manufacturing/ Telecom.
• Worked in PIM for different interfaces with PIM and data migration in PIM.
• Worked on PIM/ Data Quality Integration.
• Work on PIM/EDQP integration.
• Worked with core development team in Confidential, so know the internal structure of PIM.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Analyst

Responsibilities:

• My role in this project is as a senior analyst role in Oracle Cloud PDH and work in PDH configuration.
• Configured different configuration in cloud PDH like Import Map, attribute group, value sets, item class, security, pages, organization, revision, workflow - NIR/CO, business rules etc.
• Mapped import map using different item template for different item classes.
• Worked on data migration to Oracle Cloud PDH for different item class using import map and resolved the data migration issues.
• Worked in data cleansing solution in cloud PDH.
• Worked with EDQP and SOA CS team during data migration for different issues.

Technologies: Oracle Cloud PDH, Oracle R12 PIM, PLSQL, Data Migration.

Confidential

Senior Analyst

Responsibilities:

• My role in this project is as a senior analyst role in different MDM area and design and test of ETL/ELT/Streaming processes for Analysis & Integration using different Big Data solution.
• Worked in different data transformation using Hive.
• Perform different data analysis and reporting using Hive for supplier MDM.
• Work on the solution for different integration on different retail concept.
• Help testing team on different functional understanding.
• Help UX team on developing different security features.
• Work on Product item, Trade Item, Supply item concept.
• Worked with data migration team on designing the data migration process.
• Worked with Supplier MDM and Location MDM team.

Technologies: PLSQL, Rest Services, Big Data, Pig, Hive, Fiddler, Casandra database, NoSQL.

Confidential

Lead Analyst

Responsibilities:

• My role in this project is as an Lead analyst role in Customer Hub/Product Pub and lead a small team
• Provide solution for complex issues and work on different setup.
• Worked PIM workflow and redesign when necessary.
• Validate different data using PLSQL query.
• Worked with SOA team on different data migration issues.
• Identify the issue with data model and reconfigured different attributes.

Technologies: Oracle eBS R12, PLSQL.

Confidential

PIM Lead

Responsibilities:

• My role in this project is as lead analyst role and lead a small team in all production support activities.
• Worked in Data conversion in PIM using different APIs.
• Worked with NIR and CO for different extension which identified after implementation completed.
• Provide solution for complex issues and work with Oracle by raising different SR. Worked on different Sev1 SR with Oracle and resolved different production issues where fast resolution was important.
• Build different Data Reports using PLSQL which used by the data quality team.
• Worked with SOA and ODI team for different integration issue with Oracle PIM. Most of these issues happened during publishing, when data was not publishing to downstream systems.
• Worked on PIM webservices using SOAP.
• Modified and implemented different configuration in PIM by identifying the issues with the existing PIM configurations.

Technologies: Oracle eBS R12, PLSQL, OAF, Forms

Confidential

Senior analyst

Responsibilities:

• My role in this project is as an analyst role.
• Design and work with the EBS/PDH architecture.
• Design PIM/SOA integration and implemented those solutions.
• Worked on Data migration for different PIM attributes.

Technologies: Oracle eBusiness Suits R12, Oracle PIM module, PLSQL, Workfow.

Confidential

Lead analyst

Responsibilities:

• My role in this project is as an analyst role.
• Work on the critical issues and identify the solution.
• Design and work with the whole architecture.
• Worked with NIR and CO workflow.
• Worked on creating different approval group in NIR workflow.
• Worked on different failed batches and analyzed the issues.
• Worked on different systems owners with different data issues.
• Worked with SOA /ODI team with different data failure issues.

Technologies: Oracle eBusiness Suits R12, Oracle PIM module, AR, AP, GL, PLSQL, Workfow, Forms, Reports, OAF.

Confidential, TX

Oracle EBS onshore Development Lead

Responsibilities:

• My role in this project is as a onshore development lead.
• My role involves in help functional with their technical challenge and develops the complex objects myself.
• Worked on conversions and interfaces.
• Take part in mapping meeting for conversion and provide the APIs details in plsql.
• Gathering new requirements from the client and mapping to the development.
• Help OBIEE team to understand the requirement.
• Coordinating with Oracle for resolving issues.
• Worked on customer conversion.
• Development, Unit Testing, User Acceptance Testing
• At the starting of this project did some feasibility study on xml gateway based on the interfaces between TL2000 and eBS system.
• At the end of this project Create menus in eBS.

Technologies: Oracle eBusiness Suits R12, OM, AR, GL, Report, OAF, XML Publishers, PLSQL.

Confidential, IL

Oracle EBS Technical Lead

Responsibilities:

• My role involves in designing, documenting and development of plsql packages as a part of conversion and interface.
• Take part in mapping meeting for conversion and provide the APIs details in plsql.
• Gathering new requirements from the client and mapping to the development.
• Support EDI and redesign it.
• Design of EDI is a complex process because this need to send data to mainframe process and for its error message handling process.
• Worked with ControlM for scheduling the jobs.
• Participated in analysis of various processes and improving the processes which are time consuming, these are SQL, PL/SQL stored procedures and packages.
• Did significant work in sending files from unix server to mainframe and windows server.
• Worked on a custom workflow in EDI.
• Helped to resolve issue in OAF pages.
• Worked on Purchase order, Quotation, Contract, HR location, Receipts etc. interfaces.
• Conducting meetings and client calls.
• Coordinating with Oracle for resolving issues.
• Development, Unit Testing, User Acceptance Testing

Technologies: Oracle eBusiness Suits R12, PO, OAF, PLSQL.

Confidential, CA

Oracle EBS Technical Lead in Order to Cash (Onsite coordinator)

Responsibilities:

• My role involves in designing, documenting and development of the high level requirement MD70 and mapping to the development.
• Design the whole architecture for conversion and error handling strategies.
• Take part in mapping meeting for conversion and provide the APIs details in plsql.
• Work as an onsite coordinator in Order to Cash area.
• Analyze and develop for Oracle Form personalization.
• Gathering new requirements from the client and mapping to the development.
• Participated in analysis of various processes and improving the processes which are time consuming, these are SQL, PL/SQL stored procedures and packages.
• Worked on the OM interface from Legacy system to Oracle ERP.
• Worked on the OM sales order and RMA.
• Worked on AR auto invoices.
• Worked in TCA party relationship.
• Worked in AR Cash receipts and AR adjustments.
• Worked in BOM and Routing.
• Conducting meetings and client calls.
• Coordinating with Oracle for resolving issues.
• Development, Unit Testing, User Acceptance Testing

Technologies: Oracle eBusiness Suits R12, OM, PO, AR, AP, OAF, PLSQL.

Confidential

Sr Oracle EBS Technical Consultant

Responsibilities:

• My role involves in development the application from offshore.
• Participated in analysis of various processes and improving the processes which are time consuming, these are SQL, PL/SQL stored procedures and packages.
• Interacting with the client for business and design flow for the process.
• Technically involved in analysis, designing of required components. This includes interfacing, Conversions, SQL, PL/SQL Packages, SQL Loader
• Query optimizing using EXPLAIN PLAN and TKPROF
• Creation of Value sets/Concurrent Request / Programs / Request Groups etc
• Customized different forms and reports according to the business requirement.
• Conducted weekly meetings to monitor progress and realignment of priorities.
• Define Users, Hierarchies, Solve Definitions, Develop reports and distribute to the users.

Technologies: Oracle eBusiness Suits R12, OAF, FORMS, PLSQL.

Confidential

Oracle EBS Technical Consultant

Responsibilities:

• Involved in the design, development, testing and implementation of Approval Workflow Process.
• Involved in the Requirement Gathering and Functional Gap Analysis
• Define and customize the new workflow process and make it reusable to all the transaction types.
• Extensively used Workflow for the design
• Prepare Integrated UAT Test Cases
• Analyze and implement the PO and AP Modules
• Defining the descriptive flex fields.
• Prepare Application extensions functional design (MD050) and Application extensions technical design (MD070) documents.
• Involved in the end to end testing and debugging.
• Conducted weekly meetings to monitor progress and realignment of priorities.
• Study the Client business process and prepared the documentation for As Is and To Be
• Involved in the source build using PVCS and deployment in the test environment.

Technologies: Oracle eBusiness Suits R12, OAF, FORMS, PLSQL, GL module.