Project Oracle
Resume:
Sneha Patil
***********@*****.***
EXPERIENCE SUMMARY
• Oracle Applications technical specialist with a total work experience of 6+ of which 2+ years at customer location (US,UK and Hungary), specialized in Oracle8i/9i, Oracle Workflows, PL/SQL procedures, Reports, SQL-Loader, UNIX.
• Immense experience in ERP Oracle Applications E-business suite (11i, 11.x, 10.7) Proficient in all phases of Oracle Applications implementation phases with major focus in OM,GL AP,AR, PO, PA
• In depth knowledge of business processes in manufacturing and supply chain, with hands on experience in resolving business issues and end to end implementation practices like - Requirement analysis, design, development, testing and production support.
• Technical role & primary focus in the area of financials modules, P2P (procure to Pay) cycle , Oracle workflow
• Proficient in design and development of RICE components interface, conversion, extension, workflow and reports
• Expertise in system analysis, interfaces, System Administration & production systems support
• Involved in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing custom solutions, and programming, scheduling, & reporting requirements.
• Extensive experience in business process flow development, and configuration of test instances, demonstration, unit and integration testing, documentation, end-user training, go-live and post-implementation support.
• Experience in system admin activities like creation and maintenance of users, creating responsibilities, menu maintenance, creation of requests and request sets, registering applications, forms, reports, concurrent programs, etc
• Good exposure and understanding of US, European markets and Business operating models
• Excellent written & verbal communication, Co-ordination and team skills, customer centric and a versatile team player
• Aware of CMM Level 5, Six Sigma, ISO9001, BS7799 practices and implementations.
ERP
Oracle Applications 11.5.10 / 11.5.8 / 11.5.7 / 11.5.5 / 11.03
Primary Modules – SysAdmin, AOL, Oracle General Ledger, Oracle Purchasing, iExpenses, iProcurement, Requisitions, Oracle Accounts Payables, Oracle CRM, Order Management.
Oracle 8i/9i, Oracle Business Events, XML Publisher
Tools
Reports 6i, Forms 6i, Discoverer, Workflow Builder 2.6, TOAD, SQLDeveloper,SQL*Plus,SQL*Loader, ClearCase,VSS,CVS,Cognos(Impromptu,Transformer,Visualiser), Business Objects, Test Director
Languages
SQL , PL/SQL, C, C++, HTML, Unix Shell Scripts
Training
Six Sigma, Oracle Applications, Java, Communication and Presentation Skills
Educational Qualification : Bachelor of Engineering in Computer Science 1996-2000, Karnataka
Organization Summary
Nov-05 to Jun-07 Tesco as Oracle Apps Technical Consultant
Mar-04 to Nov-05 Accenture as Oracle Apps Technical Consultant
Mar-01 to Feb-04 iGate as a Oracle Apps Technical Developer
Professional Experience
Tesco HSC [Nov 05 to Jun 07]
Role : Oracle Application Technical Consultant
Client: Tesco
TESCO Oracle Financials Implementations / Support: TESCO has implemented Oracle eBusiness Suite 11i on an instance called Core Design.
This Core Design has all the customizations of the Tesco Business Needs. The Tesco business is spread across countries like UK, Central Europe (Hungary, Czech Republic, Slovakia and Poland), Asia (China, Japan and Malaysia) and in United States of America. The Core Design is copied on all the countries and the country can have its own localizations also.
Environment : Oracle Applications 11.5.9 and 11.5.10
Modules : iProcurement, PO, AP, AR, FA, iExpenses, Cash management, Project Accounting
Responsibilities:
• I was responsible to design, configure and implement procure to pay with project modules. It involved complex customization, data migration
• Responsible for setting up the support infrastructure to support Oracle financials implementations.
• Worked on the successful upgrade of Oracle Financials module from version 11.5.9 to 11.5.10.
• Designed the Technical Design Documents as per the business requirements/functional design document for the country specific customizations.
• Supported a global installation of Oracle financials spanning 8 countries
• Involved in the customizations of the PO Account Generator, PO Requisition Account Generator, PO Approval workflow, Project Supplier Invoice Account Generation, AP Invoice workflow, and developed new workflow for the Remittance Advice Notification.
• Involved in solving support issues from various countries and post implementation support
Environment: Oracle Applications 11i (iProcurement,iExpenses,PO,AP,AR,FA,Project Accounting)
Oracle8i, Developer2000, PL/SQL.
Accenture, Bangalore [Mar 04 to Nov 05]
Role : Oracle Application Analyst Programmer
Client : Carillion, UK (Sep-05 to Nov 05)
Project Name : Project Wolf (Customization of Oracle 11i Application)
Carillion plc: Oracle Applications implementation for the Carillion covers the whole suite of Oracle Financial and HRMS Modules. Carillion provides a broad range of business, transport and construction services to commercial and public sector clients in the UK, Sweden, Canada and the Middle East.
Responsibilities:
• Designed the technical design documents as per the business requirements for the below two components
Project Supplier Invoice Account Generation: The design for generating the charge account for the supplier invoice is based on the customization of an existing standard Oracle Workflow 'Projects Supplier Invoice Account Generation'. This workflow must generate the correct charge account for a supplier invoice when the payables user has entered project specific information.
Employees with internet access will enter their expenses via the Oracle Self Service forms. These expenses will be processed by the Expenses workflow, which will route the necessary approval requests for the expenses and process the exceptions.
• Involved in development of customs components using Oracle pl/sql, Oracle Workflow and Concurrent Program registrations.
• Customized Projects Supplier Invoice Account Generation workflow to pick up the charge account (Cost centre) based on the project information.
• Preparation of Unit Test Scripts and Plans, Involved in the execution of unit tests
• Release of the components as per the standards.
• Quality Coordinator for the project as the additional responsibility.
Environment : Oracle Applications11i(Financials Modules and HRMS implementation,
iExpenses, Oracle8i, Developer2000, PL/SQL.
Role: Oracle Application Analyst Programmer
Client : Rural Payment Agency-UK Government (Mar-04 to Nov 04, Bangalore)
Rural Payment Agency-UK Government (Nov-04 to Aug 05, Reading UK)
Project Name : Rural Payment Agency (Customization of Oracle 11i Application)
RPA (Rural Payment Agency - Accenture's biggest project for UK Government (2002- 2009) which has 3 years for development and 4 years of Support and Maintenance)
The Rural Payments Agency (RPA) is an Executive Agency of the Department for Environment, Food and Rural Affairs (DEFRA). It is the single paying agency responsible for Common Agricultural Policy (CAP) schemes in England and certain schemes throughout the UK. Their primary purpose is to ensure that aid/subsidy is paid to the customers with appropriate rules and regulations. It is a Claim to pay (CTP) process in which the farmers will claim for the aid / subsidy through a web based application form and payment will be made for the same claim. The project consists of 3 deliveries. Delivery1 consists of land register and customer registration. Delivery2 was to prove the CTP process for a single CAP scheme and delivery3 for multiple CAP schemes.
The solution is composed of multiple workflows, interfaces, integration with Oracle CRM, Universal Work Queue, Order Management, Field Service, and a user interface layer, the "e-Channel". The processes involved in Claim to pay are as follows.
• Customer submits the claim through a user interface layer 'e-Channel' which is a web based application
• The claim will be picked up by the custom programs / workflows which will create the order header in Order Management
• Inspections will take place to ensure that the claim is valid and correct so that the aid/subsidy will be paid to the customers
• After the inspection, based on the claim type, order lines will get created in the Order Management
• Financial details like Invoice details, accounting entries, payment amount etc. about the claim will be created by the custom programs and the same will be imported to the payables interface tables
• Claims will be authorized by the custom programs so that aid amount will be paid to the customers.
• Payments for the authorized claims will be generated by Accounts Payables module and the same will be handed over to the customers.
Offshore Responsibilities:
• Designed the Technical Design Documents as per the Functional Design
• Worked on TCA APIs and was involved in programming of TCA functionalities
• Involved in development of customs components using Oracle pl/sql, code reviews
• Preparation of Unit Test Scripts and Plans, involved in the execution of unit tests
• Quality Coordinator for the project as the additional responsibility.
Onsite Responsibilities:
• Involved in the client interaction to collect the business requirements and sign off of the functional design documents.
• Preparation of test plans for application integration testing and System Integration Testing(business scenario level testing)
• Involved in test script execution and bug fixing
Environment : Oracle Applications11i(Order Management, Oracle CRM, Accounts
Payables, General Ledger), Oracle8i, Developer2000, PL/SQL
iGATE Global Solutions Ltd. [Mar-01 to Feb-04]
Role : Oracle Application Analyst Technical Developer
Client : GE (Power Systems) Schenectady, US (Apr-03 to Feb 04)
Project Name : O2S (Order to Settlement) /ePO (Electronic Purchase Order web portal)
O2S :This project integrates Oracle Purchasing and the Electronic Purchase Order (ePO) application; also know as Order to Settlement (O2S).The O2S application represents a digitization of the Purchase Order, Shipment, and Settlement cycle. It is the primary web based tool used by GEPS suppliers for PO collaboration and settlement.The aim of the project is to keep Oracle and O2S System in Synchronization for which Purchase Orders, Receipts, ASNs (Advanced Shipment Notices) and Payment Requests are considered. The O2S application contains two primary modules
(1) Electronic Purchase Order (ePO) which provides a web enabled Purchase Order process.
(2) Electronic Shipment and Settlement (eSS) which collects and links shipment and receipt
data to facilitate the automation of the settlement cycle, generating payment based on
evaluated receipt.
Responsibilities
• Requirement Gathering and Creating necessary packages/procedures to integrate the data between Oracle and O2S and test their functional and technical performance.
• PO’s and ASN’s Reconciliation
• Resolving Production Issues
• Unit testing, Integration Testing of several procedures
• Maintaining / Creating UNIX Shell Scripts
• Preparation of Installation Document and Deploying the application in production at clients place
Environment : OracleApps10.7, 11.0.3, 11i, Oracle 8i, Optio, Work Flow, Web Methods, LDAP,Java
Client : University of Chicago Hospitals (UCH) (Dec-02 to Mar 03)
Project Name : Implementation of Oracle Application11i for UCH
Brief description
University of Chicago Hospitals has upgraded their 10.7 Apps to 11i. This project involved migration and customization of components.
Responsibilities
• Developing Extensions, Interfaces and Conversion Programs
• Review of functional and technical design documents, Coding, Preparation of Unit test scripts, performing unit testing and support during Integration testing
• Preparation of Unit Test Plan/Installation document and Performing Unit Tests
Client : Oracle Corporation for Labatt Breweries of Canada (Jun-02 to Nov 02)
Project Name : Implementation of Oracle Application11i for Labatt Breweries of Canada
Brief description:
Labatt Breweries, a major brewer and distributor in North America, is re-implementing Oracle Apps 11i e-business suite to replace its legacy/Apps Rel 10.7 systems and thus integrate various business functions at various locations spread across Canada and US. This project involves migration of data, customizations and development of new objects in the modules GL, AP, PO, OM, INV, BOM, HR etc. Implementation is being done as per Oracle AIM Methodology and scope includes technical design, development, testing. Implementation of Conversions, Interfaces, Programs, Reports and Forms is taken care. This project is executed through the Onsite-Offshore delivery model and involved standard Oracle Apps technologies viz PL/SQL, Forms 6i, Reports 6i, SQL*Loader and Shell scripts. Documentation (MD70, TE020, MD120 etc), coding, testing and installation scripts were executed from offshore using PVCS and VSS version control systems.
Responsibilities:
• Developing Extension, Interfaces and Conversion Programs
• Preparation of Conversion Program (CV060) and Unit Test Plan and Installation Document
• Performing Unit Tests
Client : GE Power Systems (Nov-01 to May 02)
Project Name : GEPS –Pyramid AMO
Brief description: The Project covered Maintenance and Production support.
General Electric Power System (GEPS) has converted its General Ledger data from the legacy system to Oracle General Ledger and the interfaces and conversion was done by iGATE. This phase of the project is support, maintenance and enhancement of the GL Consolidation system development. This also includes upgrade of Oracle Applications to 11i from 11.0.3. The Financial data from the Legacy Systems flow to the Oracle General Ledger Tables of the Oracle Applications
Responsibilities
• Preparation of Technical Design Documents (LLD) based on the Functional Designs for reports and forms.
• Developing Extensions, Interfaces and Conversion Programs
• Testing the Prototype for functional requirement fulfillment.
• Maintaining the Project Status and Quality through the Project Status Reports, Quality Control Reports of the project and Span data Sheet.
• Configuration Management
• Loading of the data from the General Ledger Tables to OFA takes place for once in 15 days, during which the run has to be taken care continuously through registered concurrent programs
Client : GE Aircraft Engines (Jun-01 to Nov 01)
Project Name : GE- Aircraft Engines, USA
Brief description:
The database is Oracle 8i, UNIX being the platform. The final product of this project is to generate the reports using the COGNOS tools and also in Java to make it web enabled.
The project has 3 phases –
• Fetching the data into the SA (Staging area tables)
• Cleaning and authenticating the data to ensure correct and complete data is transferred to a centralized database CDW (Central Data Warehouse)
• Generation of cubes and reports using the COGNOS tools.
The scope of my activity in the project involved development of reports using COGNOS tool and data loading.
Responsibilities:
• Preparation of Low Level design document
• Writing PL/SQL procedures for extraction of data
• Writing the SQL Queries to verify the data generated on Cognos reports
• Testing the application (Reports) against the functionality and the Test cases prepared.
Associate Trainee at iGate Global Solutions Mar-01 to Jun-01
Contact this candidate