SUMMARY:

• Oracle Apps Techno - Functional Lead Analyst/SME/BSA having 14 years of experience in implementing Oracle Applications 11i E-Business Suite/R12 and experienced with Global Delivery Models with excellent leadership skills in managing people in offshore and onsite teams and developing motivated, high performing teams to take on challenges to work collaboratively to contribute towards organizational vision & growth.Around 9 years of USA experience as a Team Lead, SME, Technical-Functional Consultant, Business System Analyst and Data Analyst.
• Worked in Oracle Applications 11i E-Business Suite/R12 Applications
• (MDM, CRM, Financials & Supply Chain Modules)
• PDH (Product Data Hub, PLM, PIM) R12.
• CRM Foundation: TCA, Resource Management, Territory Management.
• CRM: Install Base, Service Contracts, Customer Care, Service, Teleservice, Tele salesSales Online, Sales Offline and Incentive Compensation.
• Financials & SCM: Account Receivables, Inventory, Advanced Pricing, Billing and
• Order Management.
• Expertise in Salesforce (SalesForce.com) CRM business processes such as Account and Contact Management, Opportunity Management, Task and Event Management, Campaign Management, Forecasting, Territory Management, Lead Management, Case Management etc.
• Expert in Service Contracts and Contact Billing and month end closures, worked on Service Contracts/Advanced Pricing, creating mandatory items on the pricelists, defining the billing types on the service contracts programmatically integrating the legacy systems.
• Had experience in interfacing the data between Enovia (Engineering System) and Oracle PIM/PLM for the indented BOM, ECO's and implement model/unit effectivity.
• Had experience of working on MDM (Master Data management) TCA, Customer Data Hub, Customer Data Integration (CDI) using Trillium and Dun & Bradstreet.
• Worked on Service Contracts/Advanced Pricing, creating mandatory items on the pricelists, defining the billing types on the service contracts programmatically integrating the legacy systems.
• Strong experience of Oracle Business Events, message queuing and designing integrated business interfaces.
• Expertise in implementing MDM-CDH, PIM/PLM integrating with financial systems and global order management systems.
• Worked as a System Business Analyst for Integrations for Oracle Systems and Salesforce Dot com.
• Worked as a Team Lead managing offshore/onsite teams, working closely with IT Managers and Directors, track the project deliverables/CEMLI releases and working closely with the IT Mangers/Directors.
• Worked as an SME/Data Analyst for MDM/Oracle Apps Customer Master 11i/R12 to EDW (Enterprise Data Warehouse) data extraction & ETL.
• Designed and developed the integration with the Pitney Bowes to print/send the PB invoices to customers.
• Worked on integration with Concur & Oracle Payables for employee expenses-Importing employee expenses from Concur & create invoices and send payment confirmation and remittance to AMEX and Bank of America for credit card expenses.
• Extensively worked with integration tools like Interconnect, Tibco, BPEL & Fusion Middleware and web services.
• Designed and developed the interfaces between oracle apps and applications like AS400, Siebel, SFDC (Sales Force Dot Com), Partner Net, Concur, BAAN, Mainframes, Job Design & financial systems like PPR, Morning Star, Paris and different Legacy applications).
• Expertise in developing reports using XML/BI publisher.
• Experienced in analysis, testing and reporting for SOx compliance & Experienced in Software Development Life Cycle (SDLC) and AIM.
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Expertise in designing the inbound and outbound interfaces in Oracle E-Business across the application. Experience in System Requirement Study, System Design, Database Design, Programming, testing and Implementation.
• Proficient in designing, writing Technical and functional Specification documents, gathering end user and business requirements and GAP analysis.
• Designed/Developed the business processes and multiple service windows in oracle Service contracts from which the route maintenance is done for the servicing the service locations like ATM's.

WORK EXPERIENCE:

Oracle Applications MDM/Supply Chain Consultant

Confidential, Irving, TX

Environment: Informatica MDM, Oracle Applications MDM R12 (Customer Master, Account Receivables, Order Management, Billing, Oracle Service Contracts).

Responsibilities:

• Involved in Oracle MDM/Oracle E - Business Suite R12 projects which includes the customer related Master Data Management in Oracle's Trading Community Architecture.
• Administering Customer Master Data which includes Customers, Parties, Accounts and contacts and involves Data conversion and interfacing between Oracle and legacy systems and maintain Customer Master.
• Responsible for designing & developing APIs/Interfaces, Data Dictionaries, Entity Relationship diagrams, data analysis and data architecture to ensure Data Quality and governance.
• Data mappings, Data Validations, Data Standardization, defining business rules for cleansing, matching, merging and maintaining data.
• Involved in Converting the data from AS400 and ISeries a Sql server database, which includes Customers, Blanket Sales Agreements, Billing information, Install base.
• Involved in converting CRM Customer Service windows as part of Legacy Schedules Conversions.
• Involved in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs and providing support to application users for any technical issues.
• Responsible for writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.

Oracle/ Sales Force Dot Com Lead Consultant

Confidential, Dallas, TX

Environment: Oracle, Sales Force Dot Com, Riva, Lotus Notes, Informatica, DMS, AWF, OASVAS, RPAY, Web Services.

Responsibilities:

• Involved in functional analysis and design regarding the Data flow between the Sales Force and DMS (Document Management System) where the policy related documents are stored, and the document were indexed through web services calls.
• Designed the workflows for the integrations for Ebusiness and Salesforce Case Management with different applications like AWF, and Informatica etc. for servicing the different kind of policies record types and work types.
• Worked on the Riva and Sales Force Integration to Ensure the Lotus Notes and Outlook Calendars were synched and thereby creating the Tasks, appointments/Meeting in both Lotus Notes/Outlook and Sales Force.
• Involved in the Enterprise level Proxy Server Upgrade testing to ensure the Integrations is working fine across Oracle DB Systems and Sales Force Dot com.
• Analyzed and provided the design for multiple LOB customizations where the activity history is maintained for the accounts and contacts across multiple line of Business with designing the Custom Settings and LOB Mappings.
• Designed Data Model for Custom objects and Junction objects.
• Worked on Processing the Policy information from informatica into Sales Force as part of the batch job processing.

Oracle CRM Consultant Lead

Confidential, Dallas, TX

Environment: Oracle Applications R12 (Accounts Receivables, Oracle Order Management, Oracle Service Contracts, Inventory, Oracle Advance Pricing, XML/BI Publisher).

Responsibilities:

• Worked as a Team Lead managing offshore team, tracking the CEMLI releases and working closely with IT/Business Directors.
• Worked closely with the Confidential business managers to enhance the business process across Confidential Oracle Applications.
• Worked on data interfacing between Oracle and legacy systems like Itrack, Icash, Heat which are the feeder systems for the daily transactions of Confidential for the line of businesses like Money processing, ATM, CIT, CompuSafe, COIN and Heat. Used HVOP for the same.
• Worked on HVOP - high volume order processing which is used for creating orders at a high volume Eg: 300K orders per day.
• Provided technical support to the Confidential month end process and work closely with business team to resolve the issues related to contracts and Billing. Able to Reduce the processing time for the month end closure from 7 days to 7 hours.
• Worked on JPMC Special Billing where Confidential have different logic for their sales orders for their usage billing (Sales orders and invoicing).
• Involved in Developing Split Account Receivables invoicing for the Confidential Customers depending the Split Criteria.
• Worked on the UFPC and Miami surcharges for the usage Billing - automate create sales order and invoice the orders and Contract Billing.
• Effectively resolve the Vertex and EB-tax issues with in Confidential .
• Involved in Design of Sending EDI Invoices for Confidential Customers.

Oracle CRM Consultant Lead

Confidential, Dallas, TX

Environment: Oracle Applications R12 (Accounts Receivables, Oracle Order Management, Oracle Service Contracts, Inventory, Oracle Advance Pricing, XML/BI Publisher).

Responsibilities:

• Worked as a Team Lead managing offshore/onsite team on a day to day basis, track the CEMLI releases and working closely with IT/Business Directors.
• Worked as an SME for Billing & Invoicing data transformation from E - Business Suite to Enterprise Data Warehouse.
• Designed and developed the business process and multiple service windows in oracle Service contracts from which the route maintenance is done for the servicing the service locations like ATM's.
• Worked closely with Pricing Managers to design/define Price lists, creating the mandatory items on the price lists.
• Worked on defining the billing types on the service contracts programmatically integrating the legacy systems.
• Designed and developed the Invoice Print Mechanism and Email delivery to send the invoices to the customers on every month end close.
• Worked on integration with the Pitney Bowes to print/send the PB invoices to Confidential customers.
• Worked closely with the Confidential pricing managers to design and develop the price lifts as part of annual and mid-term uplifts.
• Provided technical support to the Confidential month end process and work closely with business team to resolve the issues related to contracts and contract prints.
• Developed reports for Tax re-conciliation and Revenue Summary reports which were used for the tax accounting and Revenue reconciliation across Confidential .
• Developed the CEMLI for calculating/creating the Fuel surcharge on all of the service done for transportation while invoicing.

Oracle PIM/PLM System Business Analyst

Confidential, Houston, TX

Environment: Oracle Applications 11i, PDH/PLM 11.5.10, Enovia.

Responsibilities:

• Worked as a System Analyst and analyzed the Enovia system to implement Model/unit effectivity in PIM, to import the ECO's, Manufacturing BOM, Sourcing rules into PIM.
• Done the pre and post patch impact analysis for the rollup patches for PIM.
• Done the setups required for making the PIM up and running for the using PIM as a front end application for Master Item and indented BOM in Product workbench.
• Worked on ECO's with in Manufacturing and PIM, Created structures for the BOM's.
• Created attributes groups and attributes for the Enovia specific attributes.
• Worked on business events for the Model/unit Effectivity.
• Conducted CRP's/ user trainings to make understand the Planner and buyer groups in Confidential for using PIM compatible to Enovia.
• Created User manuals for the PIM/PLM users across GE.
• Enabled attachments functionality for uploading the engineering design specifications of the parts.

Oracle PIM/PLM Consultant Lead

Confidential, Nashville, TN

Environment: Oracle Applications R12, PDH/PLM R12, AIA 2.4, PDQ integration, SQL, PL/SQL.

Responsibilities:

• Involved in preparing test cases, supported implementation PDH for integrating Confidential Global order management systems.
• Deployed Go live activities for supporting the AIA 2.4 implementation.
• Designed and developed DB link solutions as part of the custom PIP solutions as part of PLM.
• Provided support for the integrating their Singapore, Mechelen and China Order management systems.

Oracle Apps Consultant

Confidential, Hartford, CT

Environment: Oracle Applications R12, Oracle PIM/PDH/PLM R12, PDQ integration, Forms 6i, Reports 6i, SQL, PL/SQL, XML Publisher.

Responsibilities:

• Involved in Gap analysis and prepared business requirement documents based on As - Is Business Processes and To-be process.
• Developed business flows for To-be business process and interacted with business team to get the approvals.
• Worked on Product data hub/ Oracle Product Information Management Data Hub (R12) & Product Data Quality server to centralize all product information from heterogeneous systems, creating a single view of product information that can be leveraged across all functional applications.
• Designed the catalogs & catalog groups depending upon the products/funds which Confidential maintains.
• Defined catalog hierarchies, attribute groups, attributes, related value sets.
• Developed custom user defined functions in PDH/PIM application for the business functionality.
• Worked on business events in order to maintain the data synchronization within the application & multiple legacy applications.
• Provided data synchronization solution for multiple systems like Paris, Morning Star, PPR etc which were the Confidential retirements fund maintenance systems.
• Developed XML publisher reports as per the business requirements like available for sale funds etc.
• Worked on BOM interfaces and defined custom BOM component attribute groups in the product work bench.
• Developed business events and pl/sql procedures for calculating the BOM calculations against the attributes on the components.

Oracle PIM Consultant

Confidential, Buffalo, NY

Environment: Oracle Applications R12, PIM/PLM R12, SQL, PL/SQL.

Responsibilities:

• Worked on business events in order to maintain the data synchronization within the application & multiple legacy applications.
• Worked on Interfaces and data migration for migrating the item and UDA information into PIM.
• Worked on Change management.
• Working on XML publisher reports for Change management tracking.
• Created user defined functions for populating the values based on the attributes with in and multiple attribute groups.
• Worked on user defined attributes and attribute groups for defining values which are dependent and independent.

Oracle Apps Consultant

Confidential, Richardson, TX

Environment: Oracle ApplicationsR12, GL, AP, AR, OM, Oracle CRM, TCA, Oracle Sales, Field Service, Service contracts, Mainframes, BAAN, Job Design, Forms 6i, Reports 6i, SQL, PL/SQL.

Responsibilities:

• Worked as a Sr Developer/System Analyst to gather the requirements and did the analysis as part of the BAAN & Job Design feeds from Oracle.
• Integrated Main Frame application with Customer Master in Oracle.
• Designed & developed custom solution for the Customer classification codes as part of customer classification and class code assignments.
• Worked on Customer Hierarchy and Relationships.
• Worked on Customer outbound extracts for BAAN and job design applications.
• Developed x - ref (original system reference) at customer level implementing the SG business logic to provide x-reference across the organization.
• Worked on creating inventory distributions.
• Worked on inventory transactions for creating CTP, DTP, and PO Variance.
• Customized the standard package cstpschk to create the code combinations and to create the distributions as per the account aliases.
• Developed PL/SQL routines for interfacing the GL Feeds, Customer information, Inventory distributions, Service Contracts, Sales Orders, Service requests into BAAN & Job design from Oracle.

Oracle Apps Consultant

Confidential, Mountain View, CA

Environment: Oracle ApplicationsR12, Oracle CRM, AP, AR, OM, OCO R12 (Customer Online), MDM-CDH R12 (Customer Data Hub), PDH R12 (Product data Hub), Oracle Fusion Middleware, Concur, SFDC, Partner Net, Forms 6i, Reports 6i, SQL, PL/SQL.

Responsibilities:

• Involved in Gap analysis and prepared business requirement documents based on As - Is Business Processes and To-be process.
• Worked on Product data hub/ Oracle Product Information Management Data Hub (R12) & Product Data Quality server to centralize all product information from heterogeneous systems, creating a single view of product information that can be leveraged across all functional applications.
• Worked on conversions & interfacing data between cross applications (between Oracle Customer Data Hub and different systems like SFDC (Sales Force Dot Com), Partner Net & different Legacy applications).
• Worked with third party organization (Dun & Bradstreet) for Confidential integration for CDH R12 & Customer Online.
• Worked on AP invoices-Extracted employee expenses from Concur (third Party tool instead of iExpenses) and created invoices in payables.
• Worked on Automatic payments & remittance system for sending remittance and payments confirmation files to AMEX (American Express) and Bank of America.
• Written Pl/Sql routines to send employee list & projects list to Concur as an outbound extract using UNIX and FTP processes between 2 different systems (Oracle and Concur).
• Worked as a SME/Data Analyst for the Apps Customer Data Hub R12 to EDW (Enterprise Data Warehouse) data extraction & ETL.
• Developed Pl/sql wrappers for encrypting and decrypting Credit cards for Credit card authorization for Order processing and service contracts.

Oracle Apps Consultant

Confidential, CA

Environment: Oracle Applications11i, Oracle CRM, CDH 11i, OCO (Oracle customer Online), Siebel, Forms 6i, Reports 6i, SQL, PL/SQL, Xml, Jaxb, Toplink, Tibco.

Responsibilities:

• Created concurrent programs & developed custom interfaces to load data which when kicked, sends asynchronous messages (Customer and prospect data) back & forth from the spoke systems (Siebel) to CDH (CDH 11i & Customer Online)and vice versa. Used Tibco for this purpose.
• Worked with third party organization (Dun & Bradstreet) for Confidential integration for 11i and developed Pl/sql scripts for exporting & importing D&B data.
• Worked as a SME/Architect for the Apps Customer Data Hub 11i to EDW (Enterprise Data Warehouse) data extraction.
• Worked on Data Cleansing and address Cleansing and Customer Data Integration (CDI) using Trillium.
• Involved in maintaining Master Data Management, Cleansing and Standardizing Data, Data Governance, Data Quality.

Oracle Apps Consultant

Confidential

Environment: Oracle Applications11i, Oracle CRM (Telesales, Sales online, OIC) Work Flow, Forms 6i, Reports 6i, SQL, PL/SQL, Windows 2000

Responsibilities:

• Involved in requirement analysis and technical analysis and involved in gap analysis to provide gaps between the existing business & Oracle Applications
• Setup Resources and done setups for Sales Online, OIC, users, assigned roles to users, created new Menus & Responsibilities for user access
• Worked on Api's in Incentive compensation for Standard collection of sales credit transactions using out - of-box integration with Oracle Receivables (for Invoices/Credit Memos/Payments and so on) and Oracle Order Management (for Booked Orders).
• Calculated Commissions for Compensation payments and imported Classification Rules into Oracle Incentive Compensation.
• Displayed Commission Rate & Amount in Commission Lines In Adjust Screen With Significant Decimals.
• Integrated Oracle Incentive Compensation with Oracle Accounts Payable.
• Used transaction Load Program Manage Sales Credit Allocation in Order Sales and Collect in Incentive Compensation.

Confidential

Oracle Consultant

Environment: Oracle Applications 11i, Oracle CRM, Customer Data Hub, Interconnect, Work Flow, Forms 6i, Reports 6i, SQL, PL/SQL.

Responsibilities:

• Involved in Gap analysis and prepared business requirement documents based on As - Is Business Processes and To-be process.
• Developed business flows for To-be business process and interacted with business team to get the approvals.
• Developed custom interfaces to load data from Spoke systems to the Oracle Customer Data Hub using Interconnect.
• Created concurrent programs which when kicked, sends syncronous & asyncronous messages back & forth from the spoke systems to CDH and vice versa. Used Interconnect for this purpose.
• Wrote PL/SQL wrappers for the Forms considering the form functionality. Involved in Unit Testing and Integration Testing.
• Used Data quality management API's for duplicate identification.

Confidential

Environment: Oracle Applications 11i (CRM, AR, AP, GL, OM, PA), Forms 6i, Reports 6i, PL/SQL, SQL.

Responsibilities:

• Involved in customer and contact conversion & Open Invoice Conversion in Account Receivables.
• Developed Data Conversion Scripts using PL/SQL stored procedures: for Customer Master (Customer and Contact conversion), Open AR Transactions (Open Invoice Conversion), and Open Sales Orders conversions.
• Designed and developed custom AR Forecasting using Forms and PL/SQL.
• Used SQL*Loader to load the data into Staging table, after validations data is transferred to interface table and then imported to standard tables using Auto Invoice program.

Confidential, Saint Petersburg, FL

Environment: Oracle Applications 11i (OM, GL, AR, AP, INV), Forms 6i, Reports 6i, PL/SQL, SQL.

Responsibilities:

• Worked extensively on modules such as Oracle Service Contracts, TCA, DQM, Order Management, Accounts Receivables, and Application Object Library.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents for Migrating legacy Customer information to TCA model in Apps using TCA API's for Customer Online.
• Wrote custom code with validations to transfer the data from staging table to interface tables, loaded data to the interface tables and populated data to Standard Tables through Standard Order Import Program.