EXPERIENCE SUMMARY:
*+ years of experience in Oracle Apps EBS – Account Payables (AP), General Ledger (GL), Cash Management (CE), E B Tax, Oracle Internet Expenses (OIE), Receivables (AR), payment, Procurement Modules Purchasing (PO), iProcurement, Manufacturing Modules Work In Process (WIP), Quality (QA), Flow Manufacturing (FLM), Logistics Modules Inventory (INV), Warehouse Management System (WMS), eCommerce Gateway (EDI), System Administrator on Version 11.5.7, 11.5.9, 11.5.10 and R12.
Handled various task along with consulting, attending and addressing day-to-day issues with Oracle and client, managing enhancement requests & effort estimation.
Currently:
Oracle R12 Implementation
Senior Functional Consultant
Capgemini Financial Services
App Version: Oracle EBS 12.1.2
Description: Customer is reputed financial services firm in USA, having operations in Europe, Asia-Pacific & Americas. Current scope of implementation is Accounting hub, GL, AP, AR, FA, AGIS, Payments, and E B Tax etc.
Reviewed Business Process design documents.
Created/ Reviewed RD50 for Payables Invoice and Payment process.
Created BR100 for Payables, E B Tax, Payments, FA and AR.
Created MD065 for various RICE objects from AP, AGIS, and E-B Tax.
Responsible for configuration of said modules during CRP phase, UAT phase, Production etc.
Worked closely with development counterpart to deliver 15+ RICE objects.
PRIOR EXPERIENCE:
Oracle R12 Upgrade January 2008 – December 2009
Oracle Apps Functional Consultant
Wipro Technologies
Platform: Oracle Apps Financials R12
Description: Cadena Commercial (OXXO) is a chain of convenience stores from Mexico, with over 4,300 stores across Latin America; it is the largest chain of this kind of store in the country. CLIENT has implemented Oracle EBS 11.5.7, GL, AP, AR, CE, EAM, PN, PO, INV, OIE and FA modules. This project’s objective to upgrade EBS 11.5.7 to R12 with all existing modules.
There were also requests by business to enhance the existing functionality. Some of them are:
Responsibilities: As a functional consultant, responsible for studying the business process. Prepared AS-IS understanding document for GL, AP, PO, OIE and custom modules (IETU, Comissionist).
Assisted in business process reengineering, created TO-BE process document.
Delivered session on CLIENT’s business process and created documents to make presentation to the client.
Performed GAP analysis and prepared solution presentation for review, functional assessment for GL, AP, PO, OIE and custom modules.
Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
Prepared Mapping document BR.030 and setup document BR.100 for Payables module.
Testing of various test scenarios of Procure to Pay & Order to Cash cycle in Oracle Purchasing.
Worked on Oracle Internet Expense Templates, gathering information for Templates, used data load to load the expense items for various country specific templates.
Worked on iProcurement module to streamline ordering process, effective procurement process / policies, Catalog management etc.
Worked on iSupplier to manage supply base relationships, configuring events and notification for suppliers, establish communication between buyers and suppliers etc.
Define Credit Card Suppliers and Credit Card programs for managing corporate credit Cards distributed among employees.
Reconciling Cash Transactions against banks, managing cash transactions between banks and companies.
Setting Up E-B Tax - Tax Configuration, Tax Regime, Tax Status, Tax Rates, Tax Authority, Tax jurisdiction, Tax applicability Rules, Regime to rate flow setups and functional considerations.
Setting Up Account Payables - Supplier and Supplier Site creation, Bank and Bank Account setups, Tax Code and Tax Group setups, configuration of Withholding Tax Setups, Pay Groups, Payment Methods, Payment documents (Payables). Setting up profiles.
Creating Cash Forecast Templates and Cash Forecasts in relation with Oracle Treasury.
Preparing existing interfaces and provided AS-IS documents, performed CRP tests at client’s location.
Employment creation assigning roles and responsibilities to employees, Employee maintenance list.
Creating new responsibilities and defining the required system profile options, creating value set and assigning its values.
Prepared Test scripts and involved in Application Integration Testing and System Integration Testing at clients place.
Prepare issue and risk tracker and submit to client weekly basis.
Worked with technical team to resolve / provide technical issues.
Writing / executing scripts using SQL Navigator to perform various extracts from database.
Unit Testing, documentation & training to support people
Oracle 11.5.10 Upgrade,R12 Implementation November 2005 – January 2008
Oracle Apps Consultant
NCR Corporation
Platform: Oracle Apps Financials R12
Description: NCR Corporation, formed in 1884, is the world’s largest manufacturer of Cash registers and ATMs. CLIENT has over 35000 employees Worldwide and numerous customers in retail, financial services, government and services sector Worldwide. CLIENT has a strong presence in providing software, hardware and solutions support specifically in ATMs in around 100 countries worldwide with over 80% global market share in ATM and PoS markets.
CLIENT has one of the largest Oracle Applications installed base globally with over 40 modules implemented and over 25000 users, CLIENT continually strives to upgrade its technology
Infrastructure, and a 100 strong in house team works to keep the system up to the latest technology (Version 11.5.10 currently) and deployed R 12.
Responsibilities: Created BR100 documents (Application Setups) for new modules lined up for implementation.
Review and scope new requirements, requests for change and problems for modules already implemented.
Creating/updating automation files for removing ‘repetitive’ and ‘Non Value add’ activities
Participating in new environment builds and application upgrades. Recently participated in the Oracle Application upgrade at CLIENT, from 11.5.8 to 11.5.10
Worked on different release phases i.e. CIT/SAT, UAT and PORD. Maintain Logs, Log Audits etc.
Worked on data conversion tasks for AP Suppliers, Banks, Bank Accounts, AP Invoices, and Accounting.
Execute processes to validate data before and after Migration, creating comparison sheets (XLS), updating data and Data mapping sheets.
Worked on GL setups – Security Rules, Accounting KFF, SOB, COA, Calendar, Creation of various accounts (suspense, intercompany), setting up profiles, legal entity, Organization and Organization parameter, Operating Unit and Inventory Organization, Audit Trail setups, and Currency setups. Creation of JE headers, JE lines, Batch processing’s.
Worked on Account Payables setups – Supplier and Supplier Site creation, Bank and Bank Account setups, Tax Code and Tax Group setups, configuration of Withholding Tax Setups, Pay Groups, Payment Methods, Payment documents (Payables). Setting up profiles.
Worked on Click to Order iStore configurations, Creation and Addition of stores, Product Catalog, iStore integrations etc.
Worked on Oracle Internet Expense Templates, gathering information for Templates, used dataload to load the expense items for various country specific templates.
Define Credit Card Suppliers and Credit Card programs for managing corporate credit Cards distributed among employees.
Worked on iProcurement module to streamline ordering process, effective procurement process / policies, Catalog management etc.
Worked on iSupplier to manage supply base relationships, configuring events and notification for suppliers, establish communication between buyers and suppliers etc.
Define sets of credit card codes that can be used to create default accounting distributions.
Define Organizational Hierarchies to restrict access to data in specific group by OIE responsibility.
Worked on Financials Track implemented iPayment, Oracle Internet Expenses (OIE), Cash Management (CE) in addition to AP and GL.
Worked on Manufacturing Track implemented Quality, Flow Manufacturing modules.
Worked on Logistics Track implemented Inventory Management (INV), Warehouse Management (WMS).
Creation of Employees (Employment creation), assigning roles and responsibilities to employees, Employee maintenance list.
Fixed Assets Configuration - Assign Asset Organization to OU, Category, Location, Identification, Control Book, Security by Book, Setting up profiles, security list maintenance program, Asset category define, location code , depreciation method and quick code.
Worked on SOX auditing where in worked with SOX consultants of PwC to submit proofs that ERP implemented is SOX compliant.
Worked with IT Audit Manager and prepared IT internal control documentation. Taken screen shots of Oracle ERP systems and tested to fulfill requirement.
Executed test cases of IT internal controls to ensure Operating bifurcation / security.
Used FNDLOAD for Messages and Responsibilities templates migration from one instances to other instances.
Prepare issue and risk tracker and for roll outs for various go-live projects.
Prepared BR 100 for Quality module and Implemented Quality Module for one release.
Involved in some activities for Oracle System Administration module such as Registering the Users and assigning responsibilities, printers in Oracle Apps.
Setting up the General Ledger, Multi-Org, Account Payables, Oracle Purchasing, ASCP, WMS, System Administrator and Inventory module.
Creating SOB, LE, Operating Unit and Organization.
Creating new responsibilities and defining the required system profile options, Enabling Key Flex field and Descriptive Flex field.
Creating the user, printers, responsibilities, request groups, creating value set and assigning its values.
Involved in Unit Testing and Performance Testing, Testing of various test scenarios including Negative and Boundary test cases.
Performing application setups during CRP and for new countries ‘Go-Live’: Determination of the implementation model for a new country and working with the business users and development teams to accumulate the necessary information for new setups.
Oracle ERP Maintenance & Support January 2005 – November2005
Project Associate
World Fashion Exchange
Platform: Oracle 11.5.7, 11.5.10, CLIENT ERP I, ERP II, EDI, BizTalk 2004, Data Loader, TOAD, SQL Navigator, SQL 2000, MS Excel, MS Word, MS Outlook.
Lead on project to integrate Production\warehouse info (EDI 850, 856, 810, 997) using BizTalk Server 2004.
Worked on data conversion tasks for AP Suppliers, Banks, Bank Accounts, AP Invoices, and Accounting.
Execute processes to validate data before and after Migration, creating comparison sheets (XLS), updating data and Data mapping sheets.
Worked on GL setups – Security Rules, Accounting KFF, SOB, COA, Calendar, Creation of various accounts (suspense, Intercompany), setting up profiles, legal entity, Organization and Organization parameter, Operating Unit and Inventory Organization, Audit Trail setups, and Currency setups. Creation of JE headers, JE lines, Batch processing’s.
Worked on Account Payables setups – Supplier and Supplier Site creation, Bank and Bank Account setups, Tax Code and Tax Group setups, configuration of Withholding Tax Setups, Pay Groups, Payment Methods, Payment documents (Payables). Setting up profiles.
Creation of Employees (Employment creation), assigning roles and responsibilities to employees, Employee maintenance list.
Worked on Financials Track implemented iPayment, Oracle Internet Expenses (OIE), Cash Management (CE) in addition to AP and GL.
Worked on Manufacturing Track implemented Quality, Flow Manufacturing modules.
Worked on Logistics Track implemented Inventory Management (INV), Warehouse Management (WMS).
Used BizTalk mapper to map source messages to destination message.
Created Business processes using Orchestrations.
Developed EDI mapping of Flat File to EDI (ANSI X12), and EDI to Flat File, EDI to Database (SQL 2000), Database to EDI.
Creation and maintenance of Trading Partners in the EDI Translator and public VANS.
Worked on application module setups.
Created documents to train end-users.
Involved in Unit Testing and Performance Testing, Testing of various test scenarios including Negative and Boundary test cases.
Oracle ERP Support Aug 2004 – Dec 2004
Tilak Software,
Project Associate
Platform: Oracle 11.5.7, 11.5.10, PL/SQL, MS Excel, MS Word, MS Outlook.
Worked on Account Payables setups – Supplier and Supplier Site creation, Bank and Bank Account setups, Tax Code and Tax Group setups, configuration of Withholding Tax Setups, Pay Groups, Payment Methods, Payment documents (Payables). Setting up profiles.
Worked on data conversion tasks for AP Suppliers, Banks, Bank Accounts, AP Invoices, and Accounting.
Creation of Employees (Employment creation), assigning roles and responsibilities to employees, Employee maintenance list.
Involved in Unit Testing and Performance Testing, Testing of various test scenarios including Negative and Boundary test cases.
As a project associate created End User Training guide
Provided Post Implementation Support tasks, user issues.
Creating the user, printers, responsibilities, request groups
Creating new responsibilities and defining the required system profile options
Education: B. Tech (Electronics & Communication Engineering) with Honors from Kurukshetra University, India
Training and Seminars
Delivered several trainigs on Oracle Apps Financials – Account Payables, Account Receivables, General Ledger, E B Tax, Oracle Payments, Oracle R12 etc.
Month-Yr Topics Customer (User Group)
Oct 2009 Oracle R12 Overview, Oracle R12 – 11i Comparison, Payables, E B Tax, Payments Audience of Wipro Technologies Project Team
May 2009 Oracle R12 Overview, Oracle R12 – 11i Comparison, Payables, E B Tax, Payments Reputed customer in Retail Domain
Dec 2008 Oracle 11.5.10, Oracle Quality, Flow Manufacturing Reputed customer in North India
Certifications
Oracle E-Business Suite R12 Financials Best Practices Implementation Boot Camp Assessment (Oracle)
Oracle E-Business Suite R12 Financial Management System Implementation Boot Camp Assessment (Oracle)
Certifications
# References will be made available upon request.