Oracle/ Sales Force Dot Com Lead Consultant Resume
Dallas, TX
SUMMARY:
- 19 years of experience in implementing R12, Oracle Applications 11i E - Business Suite
- Have experience with Global Delivery Models in offshore and onsite teams.
- Experience in Oracle Applications 11i/R12 Applications
- 14 years of experience as Techno Functional Consultant, SME, Architect, Lead, Data Analyst and Business System Analyst.
- Product Information Management - PDH/PIM/PLM 11i/R12, Customer Data Hub 11i/R12,
- Order to Cash (Order Management and Receivables), Procure to Pay (Purchasing, Payables and iProcurement), Inventory, Bills of Material, Advance Pricing, SLA and General Ledger.
- Working as a System Business Analyst for Integrations for Oracle Applications and Sales Force Dot com.
- CRM: Service Contracts, Install Base, Advance Pricing, Teleservice, Telesales.
- Expertise in implementing CDH, PIM/PLM integrating with financial systems, Manufacturing and global order management systems.
- Expertise in Oracle Supply Chain, Order to Cash - Order Management, Receivables and Procure to Pay Cycles - Purchasing, Payables.
- Expert in Handling real time and batch loads in PIM/PDH using API’s and Standard Import Processes.
- Had experience in interfacing the data between Engineering Systems (Enovia) and Oracle PIM/PLM for the indented BOM, ECO’s and implement model/unit effectivity.
- Worked on Install Base Conversions and Interfaces.
- Worked on Service Contracts/Advanced Pricing, Expert in Service/Contract Billing, Month End closures and solving issues with Advance pricing.
- Expertise in Oracle/Salesforce 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.
- Had experience of working on MDM (Master Data management), TCA (Trading Community Architecture), Customer Data Hub, Customer Data Integration (CDI) using Trillium and Dun & Bradstreet.
- Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
- 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.
- 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.
- 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.
- Strong experience of Oracle Business Events, message queuing and designing integrated business interfaces.
- Proficient in designing, writing Technical and functional Specification documents, gathering end user and business requirements and GAP analysis.
- Extensively worked with integration tools like Interconnect, Tibco, BPEL & Fusion Middleware and web services.
- 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.
- 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.
- Designed and developed the interfaces between oracle apps and applications like Siebel, SFDC (Sales Force Dot Com), Partner Net, Concur, BAAN, Mainframes, Job Design & financial systems like PPR, Morning Star, Paris and different Legacy applications).
SKILL:
Databases: Oracle 8i, 9i, 10g, 11g,12c.
Oracle Applications: (11i/R12), salesforce.com SCM- Supply Chain Manufacturing, Order to Cash, Account Payables, Account Receivables, Order Management, Oracle Advance Pricing.
MDM: Customer Master, Customer Data Hub 11i/R12, Product Data Hub, PLM, Product Information Management - PIM R12. TCA.
CRM: Resource Management, Territory Management, Customer Online, Install Base, Field Service, Service Contracts, Customer Care, Teleservice, Telesales, Sales Online, Sales Offline and Incentive Compensation.
Salesforce.com: Salesforce CRM. Integrations between Cross application AS400, Enovia (Engineering System), Trillium, Dun & Bradstreet, Siebel, SFDC (Sales Force Dot Com), Concur, BAAN, Mainframes, Partner Net, Job Design & financial systems like PPR, Morning Star, Paris, Itrack, Smart, CompuSafe, Pitney Bowes.
Programming Languages: SQL, PLSQL, XML, HTML, Unix, C, C++, Java.
Middleware Integration Tools: Oracle Fusion Middleware, BPEL, TIBCO, Interconnect
Change Management Tools: Remedy System, STAT, Service Now.
Reporting Tools: Oracle Reports, Discoverer, XML/BI Publisher
Version Control: Perforce, Visual Source Safe (VSS).
Testing Tools: Mercury Quality Center, Test Director.
Other Tools: Toad, SQL Plus, Oracle Forms, SQL Tools, SQL DeveloperSQL *Loader, Jaxb, Toplink, MS Access, MS Excel.
PROFESSIONAL SUMMARY:
Oracle/ Sales Force Dot Com Lead Consultant
Confidential, Dallas, TX
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.
- Worked on Oracle, Sales Force Dot Com, Riva, Lotus Notes, Informatica, DMS, AWF, OASVAS, RPAY, Web Services.
- 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.
Oracle PIM/PLM System Business Analyst
Confidential, Hartford, CT
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.
- Worked on Oracle Applications 11i, PDH/PLM 11.5.10, Inventory, Bills of Material, Enovia.
- 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 s 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 CRM/Supply Chain Consultant
Confidential, Coppell, TX
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 on Oracle Applications R12 (Accounts Receivables, Oracle Order Management, Oracle Service Contracts, Inventory, Oracle Advance Pricing, XML/BI Publisher).
- 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 Apps technical Consultant
Confidential, Irving, TX
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.
- Worked on Oracle Applications R12 (Customer Master, Account Receivables, General Ledger, Order Management, Inventory, Install Base, Billing, Oracle Service Contracts).
- 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.
- The project includes converting the data from ISeries a legacy application and AS400 into Oracle Applications R12 in 2 phases which includes Customers, Services, billing information, install base, Schedules and Service windows using Oracle MDM, Informatica MDM and Address Doctor.
- 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.
Confidential, St. Louis, MO
Technical Specialist - Oracle Apps
Responsibilities:
- Involved in preparing Functional Design documents based on As-Is Business Processes and To-be process and Presented Future state process flows for the business groups.
- The Project includes defining ICCs, Item Pages, Attribute Groups, Attributes for Items, Contracts for Ascensions existing PeopleSoft/Share Point integration, design and development of Interfaces for data interfacing from new data sources like Novatus, Pilot, Capital Equipment and Pharmacy and Outbound extracts to Peoplesoft and Pilot applications.
- Worked on Oracle Applications R12 - MDM (PIM/PDH- Product Data Hub), Inventory.
- Got oracle while doing project
- Worked on PDH R12 to centralize the product information from systems like Novatus, SharePoint, Pilot, Capital Equipment and Pharmacy Item Master like Med Hub.
- Expertise in Item Import and UDA import in PIM.
- Involved in defining New ICCs, Item Pages, Attribute Groups and Attributes.
- Involved in Design and development of Interfaces to import the data into PDH from sources like Novatus, Pilot and Capital Equipment for Items and Install base.
- Re-Architected existing SharePoint Integration between Peoplesoft and Oracle PIM
- Architected data flows for ODI integration for PIM Interfaces.
- Developed Concurrent Programs, PLSQL procedures and used standard Oracle item Import and UDA import Programs for interfacing the data.
- Provided Error Handling and re-process mechanisms.
Oracle CRM/Supply Chain Consultant Lead
Confidential, Coppell, TX
Responsibilities:
- Worked as a Team Lead managing offshore team, tracking the CEMLI releases and working closely with IT/Business Directors.
- Worked on Oracle Applications R12 (Accounts Receivables, Oracle Order Management, Oracle Service Contracts, Inventory, Oracle Advance Pricing, XML/BI Publisher).
- 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 Order Management 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 Apps SCM/MDM Consultant
Confidential, Houston, TX
Responsibilities:
- Involved in Gap analysis and prepared business requirement documents based on As-Is Business Processes and To-be process.
- Worked on Oracle Applications R12, Oracle PIM/PDH/PLM R12, PDQ integration, Forms 6i, Reports 6i, SQL, PL/SQL, XML Publisher.
- 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 prudential 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 prudential 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/PLM Consultant Lead
Confidential, Nashville, TN
Responsibilities:
- Involved in preparing test cases, supported implementation PDH for integrating Confidential Global order management systems.
- Worked on Oracle Applications R12, Inventory, PDH/PLM R12, AIA 2.4, PDQ integration, SQL, PL/SQL.
- 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, Mountain View, CA
Responsibilities:
- Involved in Gap analysis and prepared business requirement documents based on As-Is Business Processes and To-be process.
- Worked on 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.
- 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 DNB 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.
System Analyst
Confidential, Richardson, TX
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.
- Worked on 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.
- 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 ) at customer level implementing the SG business logic to provide x- across the organization.
- 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.