Sonali Chandorkar Email & Phone Number

United Kingdom

Nagpur, India

Worked with Maersk Oil on various Oracle Applications modules

Aberdeen, United Kingdom

Oracle Applications 10.7 to 11.5.10 Migration UpgradeHandled the upgrade of Oracle Applications release 10.7SC to release 11.5.10 taking care of existing data and customizations.ResponsibilitiesInvolved in migration of Oracle Applications 10.7SC to Oracle Applications 11.5.10 mainly with Financial, Inventory, Purchasing modulesExtensively Used Oracle Reports 6i to create and modify various types of existing custom Reports as per the 11.5.10 data model.Extensively used Oracle Form Builder to customize various Purchasing and Inventory Forms.Extensively used Workflow to customize various Purchasing business processes like for example 'Automatically Create PO from Requisition'. Modified HR Appraisal Workflow to meet CNR’s requirements.Made customizations in iProcurement Shopping and Requisition module using OA Framework.Created various scripts for automating various task of upgrade.Used custom PL/SQL procedures that can be executed as automated functions in a workflow process.Created various FNDLOAD scripts for download and uploading customizations between various test and production systems.Defined various processes and guidelines to be used by development team for upgrade.As Development Team Leader, mentored the team of developers in various projects involving upgrade.Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, conversions, customizations and documentation and implementation of modulesLead and mentored the creation of data migration scripts for Purchasing , Inventory and Financials for migrating 10.7 data to 11.5.10General system administrationDeveloped interfaces and data conversion programs for applicationsCreated and reviewed technical design specifications using AIM for various enhancements/projects Addressed operational problems, concerns, and questions posed by business users

Ellesmere Port, Cheshire, United Kingdom

Provide functional and technical support for users on Oracle Applications 11i (Procurement, Financials, HRMS, Payroll, Order Management, Treasury, EAM, Project Accounting, Inventory etc.) for Development and Production issues single handedly.Creating Employees, Terminating Employees, Maintaining Employee Hierarchy, resetting passwords, providing responsibilities and maintaining menus and functions, creating Locations, Organizations etc. in Oracle HRMS.Log TARs with Oracle Metalink and coordinate with the Oracle Support team for resolving of issues by providing them the relevant implementation information on customer site.Extended advice for patches to be applied for issue resolution.Resolved many of the long pending issues.

Hyderabad Area, India

Few of the projects I worked on are listed here. Cant list others due to space restriction.Release 12 Data Migration Project (Oracle eBusiness Suite Release 12)In R12 designed a Unified Catalog datamodel where both Oracle iProcurement and Oracle Purchasing will use the same database schema. The upgrade process is divided as:Pre-upgrade – This can be done with the system being up. 11.5.9/11.5.10 customers will run this step to help mitigate complications that may rise and reduce the time required for the upgrade.Post-upgrade - This step takes care of migrating the delta in case pre-upgrade is already run and will be run with the system down. Each of these is again divided into two steps:Data Cleansing – Here a summary to indicate which catalog items won't be migrated seamlessly like bulk-loaded items with no supplier site or assigned to "all buyers" etc is shown. On this summary page, the user will be provided with the capability to download these items and upload them with the correct data for R12.Data Relocation - It relocates catalog data into their new locations required for R12. Additionally, it should check and migrate data only for those items that haven't been previously migrated.Migrating eContent Manager Module to OA Framework, Oracle Applications Release 11.5.10The purpose of this project was to migrate the Loader/eContent Manager functionalities of iProcurement Family Pack J to OA Framework and incorporate a slate of new features. E-Content Manager provides support to catalog administrator to author content which is organized using "Stores" like Transparent Punch-out Store, Local Catalog Store.Kit Support Enhancement, Oracle Applications Release 11.5.10Sort by Relevance Enhancement, Oracle Applications Release 11.5.8Bulkloader Script for Windows Platform, Oracle iProcurement Release 11.5.8Contributed towards various notes which are published on Metalink Multibyte Charset Issue, Oracle iProcurement (Release 11.5.9

Solely designed & coded the following online applications: 1. Learning Management System (LMS) - This system provides facility to administer, monitor the courses taken by student, modules completed & pose examination at the end of each course. There are different student tools like Virtual Classroom, Mail Service, Event Calendar, Chatting, Campus News etc.2. Online Counseling Test - Here a client can take various psychological tests where he will be given a set of questions with multiple options. Once done with the answers are evaluated and the result is displayed along with the interpretations based on the test results.3. Internet Mail Client - This is a web-based application which uses SMTP and allows a person to send e-mails through a browser from any client computer. The advantage is the client need not login to the mailing system to send email.4. Shopping Cart - The project is being developed to help client shop online with search to help him. Once he selects the product he can add it to the cart, see the total price and can edit or delete the product.5. Online Chat - The chat allows you to select a topic and enter a room for chatting online. Once the client is done with the chat he can Log off & enter another chat room.6. Online Results - The project is being developed to provide Online Results for Educational Institutions using Client Server interaction by the use of Server side scripting and ODBC. The user is provided with the results based on the class chosen by him.7. Database Search Engine - It's a database jiffy search program in which a user can search for educational information on schools, colleges, Universities etc according to different search criteria like the Name, City etc.Contribution - Designing, coding, enhancements & maintenance of all interfaces, modeling and building database for the search engine. Prepared test plans & coordinated testing of software.Environment - Java, Servlets, XML, JSP, ASP, HTML, MS SQL Server

Bengaluru Area, India

1. Intranet Mail Client - Using this intranet application client can send/receive mails locally. The message sent is stored in the database in the receivers inbox & whenever the receiver login he is able to retrieve the message. It has all the functionality of the mail clients like storing addresses, creating folders etc.2. Payroll System - This deals with computerization of payslip preparation. We maintain employee’s records like name, address, DOJ, salary details, PF, leave details. It allows us to validate the records, prepare queries, forms and print report which is payslip for the employee.3. Video Library - This was developed to computerize the various processes in a video library like providing online query based on star cast, movie name, director’s name etc, updating the records if any new cassette is added or deleted, keeping track of library members and of the amount paid.Contribution Involved in designing Coding, Debugging, Validation and Testing.Environment Java 1.2, Ms SQL Server 6.5, C++, Windows 95/98/NT

M.Sc, Physics

Higher Secondary

Education record