Oracle Techno Functional Consultant

Oindrila Sen

650-***-**** ***.********@*****.******* h

http h

Professional Summary:

●More than Ten years of IT experience including Analysis, Design, development, Conversion, Interfaces, implementation and upgradation of Oracle Applications R11i/R12, SQL, PL/SQL, Oracle 10g/9i/8i, Forms6i/9i and Reports 6i/9i

●Having more than Nine years of extensive experience in Oracle Application Modules which include Order Management (OM),Inventory (Inv), Bill of Materials (BOM), General Ledger (GL), Accounts Receivable (AR), Purchasing (PO), Service Contracts, Install Base, Alerts, Accounts Payable (AP), iExpense, Advanced Pricing, Application Object Library (AOL) and System Administration.

●Strong technical skills and hands on experience in SQL, PL/SQL, Oracle Forms 4.5/6i/9i, Reports 2.5/6i/9i, Workflow, SQL*Loader, Discoverer, BI Publisher, Pentaho, UNIX Shell scripting, Performance Tuning.

●Experience in Oracle AIM technical documentation and familiar to Oracle R12 Upgrade and its Implementation.

●Worked extensively on Order To Cash(OTC) and Procure to Pay(P2P) cycles.

●Hands on experience on RICE components (Reports, Interfaces, Conversions and Extensions) of Oracle Apps.

●Thorough understanding and work experience in Oracle Trading Community Architecture(TCA) and OA Frameworks.

●Expertise in Forms Personalization and CUSTOM PLL and ZOOM functionality.

●Thorough experience on Requirements gathering, Systems and Gap Analysis, Designing, Development, Implementation, Customization, Enhancements and Testing Standard Applications Modules and Customized Applications in Oracle. Complete understanding of Software Development Life Cycle Processes.

●Highly proficient in technical aspects of Oracle Applications namely Customizations, Interfaces or data Conversions.

●Extensive experience in developing Interface/Conversion Programs to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL file, external table etc.

●Extensive Experience with AOL to develop Flex fields, Value sets, Forms, Reports, Concurrent programs and Menus into Oracle Applications.

●Extensive experience in developing and customization of Oracle Forms, XML Publisher, Oracle Reports, Discoverer, Workflow Builder

●Ability to interact effectively with clients, Understanding their requirements and providing optimum solution and support

●Can work independently as well as in a Team Environments. As a project lead, I have handled teams of up to 8 offshore resources.

●Excellent communication skills, proficient in client interaction and understanding business applications. Absolutely capable of working in a fast paced, dynamic, team-oriented environment and can pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.

TECHNICAL SKILLS

Tools

SQL Developer 6i/10g, Workflow Builder, JDeveloper, BI Publisher, Oracle Reports 6i/9i, Oracle Forms 6i/9i, TOAD, SQL Navigator, Discoverer, Pentaho

Programming Languages

SQL, PL/SQL, UNIX Shell Scripting

Oracle Application Modules

Order Management (OM), Account Receivables (AR), Inventory Management, Pricing, Service Contracts, Install Base, Alerts, Purchasing, HRMS, Oracle Payables, General Ledger, Application Object Library, Accounts Payables, IExpense, AOL, System Administrator, Workflow Administrator (R12(12.2.3), 11i(11.5.10.2))

Databases

Oracle –9i/10g/11g

Other Utilities

PVCS, Kintana, TOAD, FileZilla, Putty, WINSCP, Tivoli Scheduler, Remedy

EDUCATION:

●Bachelor Degree (B. Tech) in Information Technology from West Bengal University of Technology, India

●Oracle Certified Professional

Hitachi Data Systems, Santa Clara, CA Jul16 – Present

Oracle Logistics Developer

Hitachi Data Systems (HDS) is a company that provides modular mid-range and high-end storage systems, software and services. Hitachi is integrating SFDC(Salesforce) with oracle to receive quotes and insight orders through Mulesoft using AGILE methodology.

Role and Responsibilities:

Create a process to import sales order from SFDC system(Salesforce) and create in Oracle in Booked status.

Fetch the Configuration Instruction for the products and create a XML publisher report to be used in WMS

Send the order status for both header and lines to SFDC(Salesforce) at different stages using Oracle Queues.

Create and update Approved Supplier List for items using API

Analysis for closing a factory and thus move all the transactions to the new factory and code and setups for the same.

Create a new process for Exchange items to customers with a new portal and setups.

Create Support Dashboard to display all records for Production Support like Concurrent programs running, error out scheduled programs, Inventory interface error, Ready to Pick Orders, Table Locks, Long Running, costing error etc.

Technologies And Oracle Modules

Oracle SQL, PL/SQL, XML Publisher, Order Management, Inventory, BOM, Purchasing, Advanced queue, Pentaho Jobs, Oracle Alerts, Oracle Reports, Oracle Forms, Performance Tuning

Tektronix, Beaverton, OR Apr 14 – Jul 15

Oracle Apps Support – R12 Implementation

Oracle Applications Techno Functional Consultant

The client has implemented the Oracle Applications e business suite – version 11i in a UNIX based environment. Worked on Technical upgrade of SCM modules to 12.2.3 and also merging all the other applications like Manufacturing and Finance.

Role and Responsibilities:

●Worked on Customer, Address, Sites, Site Usage conversions by using TCA API’s in Receivables(AR).

●Written code to identify all the customizations in the setups in DFF, KFF, Pricing Formulas, and Forms Personalization etc. Then verified all these functionalities to check if they were still getting used or obsolete. If obsolete, they were marked as ‘Not Required’ during the Upgrade.

●Worked on Performance issues with Configurator to Sales Order Form after Upgrade.

●Worked on integrating service contract modules along with order management so that they can introduce monthly billing for the customers who buys extended warranties

●Assisted client/users to create new order with extended warranties and proceed it to service contract and troubleshoot the issues happened.

●Worked on Customization in Quote Negotiation Workflow

●Identified the components which require retrofitting

●Retrofitted RICE objects for R12 upgrade.

●Worked on Inter company reports.

●Worked on payment processing reports(PPR) Check Printing Report with MICR Fonts using XML Publisher in R12 and also adding signature block for the check

●Worked with Oracle on Severity1 SRs

●Worked on Order to Cash cycle (OTC) and Procure to Pay(P2P) cycles

●Set up of AME (Approval Management) for Purchase requisition Approval and Purchase Order Approval

●Set the MOAC flag at concurrent program level based on the multi org setup

●Created test data in R12 instance

●Tuned custom programs which were running for long time

●Applied 11i custom workflow changes on top of R12 seeded workflows

●Gathering requirements from business and preparing BRD and Functional Designs

●Participated Business SIT sessions with worldwide users and executed all SIT test scenarios

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Oracle Reports, Oracle Forms, Workflow,XML Publisher, Shell Scripts, Order Management, Receivables(AR), Pricing, Service Contracts, Install Base, AOL, HRMS

Tektronix, Beaverton, OR Feb 13 – Mar 14

Implementation of Credit Card Management System

Oracle Applications Techno Functional Consultant

The client has implemented the Ipayment to accept the Credit Card like VISA, MasterCard and American Express while placing Order Information.

ROLES AND RESPONSIBILITIES

●Worked on understanding the existing Custom Credit Card Management System

●Presentation to Client with the existing Functionality to understand what steps need to follow to phase it out completely in Production

●Phase out the existing Custom Credit Card Validation Programs and reports and the custom forms

●Created New Forms to enter and validate Credit Card Information for Customers

●Created Forms Personalization to Default the Existing Credit Card Details in Sales Order Form for Existing Customers

●Created API to create a Token Number for each Credit card details entered and then create a new bank account with that new token

●Created New Reports to display New tokenized CREDIT CARD Bank Account created with details

●Module Worked is mainly Order management, Receivables

●Tested and Supported Order to cash flow after implementing the Credit Card payment term

●Managed the offshore Team of 7 members from Onsite to deliver on time and without any flaw.

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Oracle Reports, Oracle Forms, Custom.pll, Workflow, Order Management, Receivables (AR), IPayment, AOL

Tektronix Inc, Beaverton, OR Jan12 – Mar 14

Production Support-SP2

Oracle Applications Techno Functional Consultant

Implemented OMAR, MFG and FIN-HR Applications to manage the order to cash and P2P cycle. It has got several custom applications along with the standard one and also a few third party applications.

ROLES AND RESPONSIBILITIES

●Working in a demanding user environment and provided technical support on day to day production issues. This would also involve opening Service Requests with Oracle.

●Support Customer to resolve issues in Order2Cash and Procure2Pay cycles in production

●Customization of AME workflow in Quoting - ASO Approval

●Worked on technical upgrade of manufacturing modules and Finance modules

●Providing corrective workarounds for any data-related Errors, help/assist the client in data fixes

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Oracle Reports, Oracle Forms, Shell Scripting, Workflow, Discoverer, XML Publisher, Order Management, Inventory, Receivables(AR), Pricing, WMS, Purchasing, Payables, HRMS, General Ledger, Quotes, AOL

Cognizant, Bangalore, India Jan 09 – Dec 11

PR News Wire, USA EPB Implementation

Oracle Applications Techno Functional Consultant

The client has implemented the Oracle Applications e business suite – version 11i in a UNIX based environment. Worked on production support and minor technical enhancement

ROLES AND RESPONSIBILITIES IN THE PROJECT

●Sales Order Conversion and creation of new reports to validate data migration

●Worked on Order to Cash Cycle

●Worked in Implementing Lockbox in Receivables(AR)

●Creation of customer mapping program to map the customer between existing and acquired company

●Modification of custom forms and development of custom RDFs and XML reports

●Creation of several Multi Lingual reports to include new LOGO

●Assist the client in enabling DFFs and lookups based on the new requirements post impact analysis and discussion with the project team

●Assist key users in verifying current processes for errors and advise key users on taking appropriate action to correct them

●Performance Tuning of long running jobs in production

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Oracle Reports, Workflow, Discoverer, XML Publisher,Order Management, Inventory, Receivables (AR), Pricing, WMS, AOL

Cognizant, Kolkata, India Apr 08 – Dec 08

The Direct Programme Support-SP2 for Phones4U

Oracle Applications Techno Functional Consultant

Phones 4u is a direct, agile channel to connect with customers in new ways, with rapidly changing propositions, and will be a platform for material incremental revenues. Cognizant have also been engaged to undertake The Direct Programme Support-SP2. To support their maintenance and future enhancements we are developing and enhancing reports and PL/SQL procedures for inventory, ASCP and order management modules.

ROLES AND RESPONSIBILITIES

●Involved in Understanding requirements from business user and project planning

●Worked on understanding the business needs and conceiving solutions.

●Worked on providing functional workaround for the stuck Timecards in Oracle HRMS.

●Implemented Compensation Workbench in a test instance and also Production

●Did Production Support for SCM modules like Order Management and Inventory (OM, INV)

●Worked on Monitoring of production jobs

●Assisted the client in enabling DFFs based on the new requirements post impact analysis and discussion with the project team

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Oracle Forms, Workflow, Inventory, Order Management, AOL, HRMS, Compensation Workbench,Fixed Assets

Cognizant, Kolkata, India Nov 07 – Mar 08

Phones 4U - Direct Oracle Application Implementation Project

Oracle Applications Techno Functional Consultant

The Supply Chain Management (SCM) modules provide functionality to accept the front office orders, translate them and release them on the warehouse and then manage the cycle through its end, when the packages are dispatched to the customers. Other functionalities like demand planning, replenishment, returns and inventory management will also be provided by the SCM modules of the eBusiness application.

ROLES AND RESPONSIBILITIES

●Development of Custom Reports for Inventory modules and also for Order Management.

●Assist the client in enabling DFFs based on the new requirements post impact analysis and discussion with the project team

●Implementing Order Management OTC cycle using prepayment method and thorough testing end to end

●Assist key users in verifying current processes for errors and advise key users on taking appropriate action to correct them

●Assist users to resolve Oracle Approvals Management (AME) to handle management approval of iExpense reports

●Successfully implemented Purging activities and done an end to end purging for 2005 and 2006

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Oracle Forms, XML Publisher, Workflow, Inventory, Order Management, Receivables (AR), Payables(AP), Iexpense

Cognizant, Kolkata, India Jan 07 – Oct 07

Arrowpointcap Support, Financial Upgrade Project

Oracle Applications Techno Functional Consultant

Arrowpointcap Support has implemented the financial Module like AP, GL, and Fixed Assets of Oracle Applications for maintaining its business. Cognizant is basically providing the providing the Production Support to these modules.

ROLES AND RESPONSIBILITIES

●Proving support to customers to resolve the issues that came up on daily basis in Production

●Preparation of the SDLC documents and then ask for signoffs from client.

●Thorough study of the effects of the changes due to application of patches and then preparation of the Test Cases and also Testing after application of the Patches

●Maintenance and Testing of reports after modifications

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Oracle Reports, Payables,Fixed Assets, Iexpense

Cognizant, Kolkata, India Mar 06 – Dec 06

Hartford VAS Replacement (VRP - Retrofit)

Oracle Applications Techno Functional Consultant

Cognizant did the Retrofit process for VISTA that merges code between two environments (Mainstream and Parallel) to ensure the final code duplicates the production environment. The Retrofit process must be scheduled monthly to update changes from Mainstream to the Parallel environments to ensure the integrity of both testing environments.

ROLES AND RESPONSIBILITIES

●Preparation of Difference Report depicting differences between the two versions of code (Forms, Packages, Procedures)

●Retrofitting the changes that need to incorporate to introduce the required functionalities, after thorough analysis

●Preparation of the Test cases and thorough Testing to check whether the required functionalities have been achieved Preparation

Technologies And Oracle Modules

Oracle SQL, PL/SQL, Reports

Contact this candidate