PROFESSIONAL SUMMARY:

• I have 13.2 years of IT Experience in Architecting, Analysis & Design, Development, Implementation, Customization, Systems Production Support & Maintenance Oracle PIM / Oracle eBusiiness Suits/ Master Data Management (MDM)/Big Data/ Data Quality/ Data Governance.
• Extensive experience in Oracle Application R12, 11i - Oracle PIM, Order management, Shipping.

EXPERTISE SUMMARY:

Oracle PIM Experience:

• Worked on multiple development projects in PIM from 2008.
• 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 Oracle corp, so know the internal structure of PIM.

Informetica MDM Experience:

• Worked as a subject matter expert in Customer / suppliers area.
• Helped IDQ team design the solutions per business requirement as a functional expert.
• Evaluate database model design with business and do the gap analysis with business.

MDM Experience:

• As an Architect of MDM capability was part of pre - sales team involved client engagement, proposal development, estimation and solution plan. Also worked on the design of different MDM product and Data Quality system and custom MDM solution.
• Worked with different MDM team during business requirement analysis and design phase.
• Worked with different Data Quality team as a business analyst and design and integrating with different systems.
• Worked in different MDM flavor like Oracle MDM (Product Hub/PIM), TIBCO MDM.
• Architect Custom MDM Product Hub in Retail domain based on Apache Camel framework (Big data), rule engine, data migration strategy, integration with data governance tool (Collibra).
• Worked in Oracle Master Data Management for Product Hub/ Customer Hub in different development projects.
• Using ODI (Oracle Data Integrator) Design and Develop conversions like Item, User Defined Attributes, and item catalog Category, item and UDA Translation.
• Worked on integration MDM/SOA integration.
• Design and worked on MDM Product Hub integration for JDE using ODI.
• Worked on PDH conversions in Oracle Application.
• Participate in preparing PDH specific environment, for showcase demo to client, where worked with oracle AIA, BRM team. Identify attribute groups specific to telecom industry as per requirement provide by client.
• Helped Informetica team as Business Analyst and designing the data model.
• Completed L2 training in IBM MDM.

Big Data:

• Worked on different big data design solution for MDM.
• Worked on MapReduce (mapR) program in unstructured data using sequencefile, worked on different POC in implementing advanced algorithms.
• Work on data migration using Hive to Casandra in Supplier MDM area.
• Analyze the data using HIVE and Pig.
• Senior analyst role in different MDM area. Design and implementation of ETL/ELT/Streaming processes for Analysis & Integration using different Big Data solution.
• Worked in different data transformation using Hive.
• Worked on pre-processing using Hive and Pig for different ETL solution.
• Perform different data analysis and reporting using Hive for supplier MDM.
• Working on solution on different business scenarios using Apache Spark.

Oracle EBS Experience:

• 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.

TESTING Experience:

• Worked on Functional Testing on a custom product developed based on Big data.
• Used Fiddler/Json Editor/ Kafka queue during web service testing.
• Used CASANDRA data base during testing.
• Developed test plan, design automation process using selenium.
• Crated Test Plan using Testrail.
• Excellent communication and interpersonal skills to work in cross-functional environment with Customers and also with Oracle Support on Service Requests (SR/TAR) to get quick Resolution of Production Issues.
• Experienced in working in tight schedules meeting deadlines.
• Strong background in working with the client to define business processes and develop high-level functional Requirements.
• Worked with Onsite-Offshore Model.
• Coordinating among the team onsite-offshore.
• Giving inductions for the new joiners into the project.
• Excellent work ethics, self-motivated, quick learner and team oriented.
• Continually provided value-added services to the clients through thoughtful experience, productive coding habits, and excellent logical aptitude and Communication skills.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Analyst

Responsibilities

• My role in this project is as a senior analyst role in PDH.
• Worked in different solution like BOM, Business rules, data cleansing solution.
• Worked on designing the solution between GS1 and PDH.

Senior Analyst

Responsibilities

• My role in this project is as a senior analyst role in different MDM area and design and implementation of ETL/ELT/Streaming processes for Analysis & Integration using different Big Data solution.
• Worked in different data transformation using Hive.
• Worked on pre-processing using Hive and Pig for different ETL solution.
• Perform different data analysis and reporting using Hive for supplier MDM.
• Working on solution on different business scenarios using Apache Spark.
• 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.

Senior Analyst

Responsibilities

• My role in this project is as an analyst role in TIBCO MDM and lead a small team
• Provide solution for complex issues.
• Provide solution in Change request.

Technical Lead

Responsibilities

• My role in this project is as an analyst role and lead a small team
• Provide solution for complex issues.
• Work on extension work.

Senior analyst

Responsibilities

• My role in this project is as an analyst role.
• Design and work with the EBS/PDH architecture.

Senior 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.

MDM senior analyst

Responsibilities

• My role in this project is as a senior technical analyst.
• Design and develop conversion for Items, catalog- category, item attributes.
• Worked with interface using ODI.

Oracle EBS senior developer

Responsibilities

• My role in this project is as a senior technical analyst.
• Work with conversion.

Oracle EBS onshore Development Lead

Responsibilities

• My role in this project is as a senior technical analyst.
• Design and develop notification using Shipping Notification Workflow.
• Customize the OM Line Work flow and integrating it to Service Request creation to Order fulfillment process.
• Work with User Interfaces.

Oracle EBS onshore Development Lead

Responsibilities

• My role in this project is as a senior technical analyst.
• My role involves in understand the business with respect to Service contract, Order creation and pricing plan.
• Design and develop the whole interfacing.
• Work with data warehouse to get the data.
• Develop form based on custom pricing engine.

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.

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

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

Sr Oracle EBS Technical Consultant

Responsibilities

• Primary contact for OAF related process.
• Develop new Oracle forms and customized Oracle standard form as implementation of oracle security in different levels.
• Design and Develop forms in OAF.
• Worked on the Interface and Data Conversion from the Legacy systems and Oracle Application Framework. This includes PL/SQL stored procedures and packages using SQL Loader utility.
• Conducting meetings and client calls.

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.

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

Sr Oracle EBS Technical Consultant

Responsibilities

• Involved in the end to end testing and debugging. This involves SQL with DDL, DML, DCL transactions.
• Worked in Project Accounting.
• Worked in extension of project accounting.
• Developed plsql packages in AP, Project Accounting.
• Worked in Oracle reports.
• Study the Client business process and prepared the documentation for As Is and To Be
• System Integration Testing, User Acceptance Testing, Production Roll Out. This involves several SQL, PL/SQL Reports.

Oracle EBS Technical Consultant

Responsibilities

• Work in PLSQL.
• Worked with AOL.
• Prepare Integrated UAT Test Cases
• Involved in the end to end testing and debugging.