SUMMARY

• Oracle Certified Associate with overall experience of over 8 years and 3 years of US experience in Oracle Applications.
• Strong working experience as an Oracle Techno Functional consultant in Oracle Applications.
• Excellent Working knowledge in Oracle Functional modules like General Ledger, Account Payables, Account Receivables, Cash Management and Fixed Assets.
• Extensive working knowledge in Oracle Master Data Management (MDM) (Product Data Hub (PDH) and Customer data hub (CDH)).
• Experience in AOL concepts like Concurrent Programs, Key Flex Fields and Descriptive Flex Fields.
• Creating users, Responsibilities, Menus, Request Sets, Request Groups, Profile Options, Form functions and Security, Forms Personalization.
• Experience in importing data from legacy systems to Oracle Applications through SQL*Loader and UTL FILE using interface programs and conversion programs.
• Experience in Oracle back - end PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using SQL*Loader, SQL developer, Toad, PL/SQL editor as development tools. Created and maintained Database Objects like Tables, Views, Materialized Views, Inline views, Indexes, Constraints, Ref cursors, Global temporary tables, Bulk collect, Sequence and Synonyms. Building complex integration with UI application using plsql object types and dynamic queries (For Advanced search operations).
• Experience in cross application integration using adapters like File Adapter and DB Adapter, FTP/SFTP adapters etc.
• Excellent Knowledge of XML, DTD’s, XML Schema, WSDL, XSD, XSL, XPath Queries, XPath Expressions.
• Experienced in Performance Tuning and Explain plan, Tkprof, SQL loader, FNDLOAD, UTL File, Indexes, Import and Export.
• Experience in opening, managing and Resolving Oracle TAR's (Service Requests) with Oracle Support.
• Good working experience in registration of forms and reports, tables and columns, Oracle Databases, RDBMS Concepts.
• Experience in all phases of Software Development Life Cycle (SDLC) including Requirement gathering, Analysis, Specification, Development, Maintenance, Testing and Documentation.
• Experience in conducting the training on basics of Oracle ESB.
• Experience in designing and coding applications following specifications using the appropriate tools.
• Experienced in designing, developing, testing, troubleshooting and debugging of the applications.
• Experience in managing smooth implementation and testing of the application.
• Experience in conducting case / system / process study for project planning, scoping, estimation and tracking.
• Excellent interpersonal, communication, documentation and leadership skills.
• Strong technical aptitude, proven ability to rapidly assimilate and design practical applications of new technology.
• Exceptional career track marked by motivation, dedicated follow-through, and unwavering commitment to excellence.

TECHNICAL SKILLS

Tools: TOAD 9.0, SOAP UI, PVCS, Perforce tool, Kintana, HP Quality Center, RallyDev tool (Agile Methodology), Oracle Customers Online (OCO),Oracle TCA, Oracle APEX, Oracle JDeveloper 10.1.3.4, Talend DQ tool.

Domains: AP, AR, GL, FA, PDH, CDH

Packages: EBS 11.5.10.2, Oracle R12.

Programming Languages: SQL, PL/SQL.

Database: Oracle 10g Database, Oracle 11g

Oracle SOA Suite Stack of Products: Oracle BPEL Process Manager 10.1.3.4, Oracle Enterprise Service Bus (ESB) 10.1.3.4, Oracle Technology Adapters (Oracle File Adapter, Oracle DB Adapter, Oracle OA Adapter, Oracle FTP Adapter, Oracle E-Mail Adapter).

Web Services Technologies: XML, XSLT, WSDL, SOAP, XPath, XQuery, Oracle APEX.

SOA Concepts: SOA, ESB, BPM Life Cycle

Middleware Products: Oracle ESB, Oracle BPEL PM.

Application Server: Oracle Application Server 10g

Operating System: Window 98, Windows XP, UNIX, MS Vista.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Technical Lead

Responsibilities:

• Impact Analysis of R12 changes and identify the technical objects impacted in upgrade of Oracle E-Business Suite from v11.5.10.2 to v12.1.3 for the Oracle financial modules like AP, AR, GL, FA and PA.
• Conduct Knowledge transfer sessions related to custom modules and extensions in Oracle E-Business Suite v12.1.3
• Review Oracle EBS v11.5.10.2 customizations and retrofit the impacted technical objects in Oracle E-Business Suite v12.1.3 for proper functioning of the system.
• Prepare documentation like MD 70, TE 20 for the R12 impacted changes.
• Unit Test the changed objects and test the Non-impacted customizations and extensions.
• Code migration of the modifications incorporated in the impacted technical objects from Oracle E-Business Suite from v11.5.10.2 to v12.1.3
• OAF Personalization set ups for modifying the OAF pages as per the Tyco needs.
• Provide expert advice, counsel and technical expertise to the project team to resolve the technical issues encountered during functional testing.
• Organize and conduct CRP/ SIT/UAT sessions with the project team.
• Provide technical solution in optimizing system performance in Oracle E-Business Suite v12.1.3.

Environment: Toad 9.0, Oracle Reports, Oracle Forms, Oracle PLSQL, Unix, Oracle EBS R12, HP Quality Center, Oracle 10g, Jenkins tool for Code migration, SVN, OAF Personalization.

Confidential

Oracle EBS MDM Lead

Responsibilities:

• Analyze customer attribute from PSION and perform gap analysis against Customer, supplier and item attributes of Customer Data Hub in Trilogy.
• Profiling and basic cleansing of PSION customer data using Talend DQ tool.
• Interaction with customer to show the profiling reports, receive feedback and incorporating appropriate profiling rules.
• Define and document the technical designs of conversion and data cleansing programs from Baan to Oracle R12.
• Co-ordination with offshore to communicate the business requirements and guide them in providing solution to the Customer data quality and migration activities.

Environment: Talend DQ Tool, Toad 9.0, Oracle AR, Oracle CDH (Customer data hub), Oracle EBS R12, HP Quality Center, Oracle 10g, Windows Xp Service Pack 2.

Confidential

Business System Analyst

Responsibilities:

• Conduct an impact analysis of introducing multiple address lines for accounts in source systems such as Oracle EBS, Portals and SFDC and how integration with UCM would need to be modified.
• Preparation of FRDs (Functional Requirement Documents) based on the analysis of the BRD.
• Interaction with different source systems BAs to analyse the impact of Addresslines addition wrt integration with Trillium to maintain the consistency of data.
• Scheduling meetings with business users to understand the business requirements, conduct FRD review meeting and get sign off.

Environment: Toad 9.0, Siebel UCM, Oracle EBS R12, HP Quality Center, Oracle 10g, Windows Xp Service Pack 2.

Confidential

Oracle MDM Technical Lead

Responsibilities:

• Requirement gathering, participation in design, Development, bug fixing and support the GTM hierarchy.
• Developed custom import program to validate and transfer the customer data from the legacy system into the Accounts receivables using APIs.
• Creation of the 3-Level GTM (Go to Market) hierarchy for the customer data using Oracle Trading Community Architecture (TCA).
• Re-Processing the GTM hierarchy based on the business events and attributes using Oracle Business events.
• GTM hierarchy data flow from Oracle CDH to Oracle DRM for including the enrichment attributes and display to end users.
• Development of custom UI for users for creating the GTM hierarchy using Oracle Apex.
• Co-ordination with cross functional teams for end to end testing of the functionalities.
• Supporting QA during system integration testing (SIT) and business users in performing UAT for the developed GTM hierarchy.
• Manages configurations and provides functional and technical configuration expertise within the scope of the Oracle Customer Data Hub and core EBS.
• Leading the development of MDM standards and processes, and ensure proper SLAs are met.
• Ensures reliability, availability and performance of the systems are considered whenever solutions are being designed and built.

Environment: Oracle APEX, Toad 9.0, Oracle AR, Oracle CDH (Customer data hub), Oracle EBS R12, HP Quality Center, SOAP UI, Oracle 10g, Windows Xp Service Pack 2.

Confidential

IT Analyst

Responsibilities:

• Oracle Applications Business Analyst Oracle R12 implementation.
• Participated in Customer registry impact analysis w.r.t C3 System migration from Oracle 11g to Oracle R12.
• Interaction with the cross functional teams (BA’s) to gather the requirement for project and preparation of BRD’s (Business requirement document).
• Responsible for data Quality Assessment and improvement in data accuracy for the integration between C3 and CR system.
• Product data integration with the Oracle PIM for retrieving the product data.
• Impact Assessment of the APIs integrated with C3 and making necessary changes to the code to function in Oracle R12 environment.

Environment: Toad 9.0, Oracle AR, Oracle CDH (Customer data hub), Oracle EBS R12, HP Quality Center, SOAP UI, Oracle 10g, Windows Xp Service Pack 2.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• End to end implementation of the Cisco Item Foundation project using Oracle Product information management (PIM) for the entire product life cycle of Item Inventory.
• Gathering of functional Requirements for the end to end implementation using Oracle PIM.
• Designed the overall integration process for the process flow of the Product life cycle.
• Worked with the cross-functional teams to provide technical expertise in the design and enhancement ofOracle MDM (Product Master, Hierarchy Management, and Data Quality) application solutions.
• Development of OnRamp API for Creating Users and assigning roles and responsibilities to the user (Role based Access) for Item Creation Approval.
• Developed the Access API for retrieving the roles and privileges already assigned to the given roles.
• Development of the integrating Dashboard package for retrieving all the attribute values relevant to the given list of items assigned to the user accessed by the eGenie UI.
• Implementation of Export to excel functionality. Created an API for exporting the Item attributes into an excel sheet.
• Lead design, testing, data migration and go-live activities for the entire Product lifecycle.
• Extensively involved in developing and testing customised APIs relevant to the Oracle Master Data Management (Oracle Product Data Hub).

Environment: Toad 9.0, Oracle EBS R12. Oracle PDH, HP Quality Center, Windows Xp Service Pack 2

Confidential

IT Analyst and Oracle Senior Technical lead

Responsibilities:

• Focused on gathering/defining functional requirements, designingrequirements, and recommending best practices.
• Actively involved in Data Quality Assessment of the mismatching data between source system and Customer Registry system.
• Participated in Assessment, Design, Transformation and monitoring of the mismatched data.
• Responsible for development of PL/SQL API’s for generic data fixes by analyzing the Data in the source (Customer Registry) and target systems (Systems integrated to Customer Registry to minimize the data variation and synchronize both the systems.

Environment: Toad 9.0, Oracle CDH (Customer data hub), Oracle EBS R12, HP Quality Center, SOAP UI, Windows XP Service Pack 2.

Confidential

IT Analyst and Oracle Senior Technical lead

Responsibilities:

• Active participation in root cause analysis, short term and long term solution for production issuesrelevant to the Customer data.
• Interaction, co-ordination and support various application teams which consume the MDM CR services.
• Experience in analyzing, designing and documenting FSDs and BRDs for the business process flows.
• Identified areas for improvement to increase the stability of the system.
• Participated in supporting the developed custom API’s to store the Customer related data which are used basically to create, update, cleanse and search the Customer data, Organization data, Relationship data and the relationship existing among various entities. It represents the Centralized data hub for customer data.

Environment: Toad 9.0, Oracle CDH (Customer data hub), Oracle EBS R12, HP Quality Center, SOAP UI, Windows Xp Service Pack 2

Confidential

IT Analyst and Senior Oracle Tech lead

Responsibilities:

• Responsible for development of PL/SQL APIs to integrate with the ODS system for data exchange between Customer registry and ODS system for customer profile related data.
• Development of custom programs to load customer data from legacy systems into the Oracle Account Receivables using APIs.
• Co-ordination with the cross functional teams to analyse the integration impact and propose a solution.
• Participated in Customer registry impact analysis w.r.t ODS system migration from Oracle 10g to Oracle 11g.
• Assessing the impact to the integration points with ODS and making necessary code changes to function in Oracle 11g.
• Provided Support to the developed custom API’s testing to QA team (Testing).

Environment: Toad 9.0, Oracle CDH (Customer data hub), Oracle EBS R12, HP Quality Center, SOAP UI, UNIX, Windows Xp Service Pack 2., Oracle EBS 11.5.10 (11i.OIE.K), Forms 6i, Windows Xp Service Pack 2.

Confidential

Oracle Fusion Developer

Responsibilities:

• Developed process integration services for functional sub-domains like Marketing, Campaign and Response.
• Orchestration of synchronous and asynchronous BPEL process to automate the complete functionality. Process Integrations within Siebel CRM 7.5.
• Participating in conducting the requirement analysis & designing. Developing SOA Artefacts (XSD, WSDL, Transformations). Performing Web Service Development, Web Service Orchestration, Web Service Integration with Enterprise Applications & Web Services Testing (Unit and Integration).

Environment: Oracle BPEL, Oracle ESB, Jdev, Oracle SOA Suite, Oracle, Windows XP.

Confidential

Oracle Fusion Tech Associate Consultant

Responsibilities:

• Participating in the requirement analysis & design.
• Performing SOA Artefacts development (XSD, WSDL, Transformations, etc.).
• Implemented the business transformation rules for Purchase Orders and Purchase Order Acknowledgements.
• Transformations of standards like OAGIS 7.2 to OAGIS 9.0 and vice-versa, OAGIS 9.0 to EDI 855 and vice-versa and Flat file to OAGIS 9.0 and vice versa.
• Performing Web Service Development, Web Service Orchestration, Web Service Integration with Enterprise Applications and Web Services Testing (Unit and Integration) using the middleware Technologies like Oracle BPEL PM, Oracle ESB.
• Developed OAGIS standard based Compliance checker BPEL Process.

Environment: Oracle BPEL, Oracle ESB, Jdev 10.1.34, Oracle SOA Suite 10g, Oracle 10g, Windows