Professional Summary:

Deepti Santsharan is an experienced Oracle Applications e-business Suite R11i Techno-Functional Consultant, who possesses over 6 years of IT experience. Currently working with leading corporations and provides her expertise in developing Oracle Applications 11i (e-business R11i) projects. She also possesses strong leadership skills.

• 6 years of experience in full lifecycle software development, support, testing and maintenance of applications developed in Oracle SQL, PL/SQL, Developer 2000 (Reports 6i and Forms 6i), Data Conversions and Interfaces in which over 4+ years as an Oracle Apps Techno-Functional consultant.

• Strong Technical Consultant in implementing, customizing, supporting and maintaining Oracle Applications /Oracle e-business Suite R11i the main concentration being in the modules: Oracle Account Payables (AP), Oracle IExpenses (IExp), Oracle General ledger(GL), Oracle Receivables (AR), Oracle Iprocurement (Iproc) , Oracle Purchasing (PO) ,Application Object Library (AOL), System Administration.

• Strong Functional Consultant in implementing, supporting and maintaining Procure to pay (P2P) process.

• Period close for Account Payables and Quarter close experience

• Expertise in SQL and PL/SQL programming to develop stored procedures, functions, packages and triggers.

• Extensive experience in Design, Development and Testing of Oracle Reports/Oracle Forms

• Worked with Workflow builder, writing PL/SQL procedures for Workflow

• Well versed with AIM Methodology and documenting the work done in a well-fashioned manner.

• Worked with Oracle Utilities like SQL*Loader, Toad, Putty

• Excellent analytical, presentation, and communication skills. Strong logic, solid business acumen, Strong leadership, facilitation and organizational skills

• Technical leadership with responsibility for delivering technical services and delivery of on-time, Quality data. Act as a technical liaison with project team members and managers to drive the Technical aspects of project delivery.

• Writing and maintaining Technical Specification document MD70 and Functional Specification document MD50.

• Excellent analytical, presentation, and communication skills. Strong logic, solid business acumen, Strong leadership, facilitation and organizational skills

• Ability to effectively gather and refine report requirements from Users and Management and give appropriate attention to details. Proficient troubleshooting skills.

• Ability to manage time spent on multiple projects to meet deadlines. Ability to work independently and as part of a team.

Education/Certifications/Training :

• Bachelor of Computer Science, Coimbatore Institute of Technology, Coimbatore, TN, India

• Oracle Certified Associate (OCA), Oracle Corporation.

• ODI 11g workshop, Oracle Corporation.

• ADF Training, Oracle Corporation

• OBIEE 11g Workshop, Oracle Corporation

Education:

• B.E (Bachelor of Engineering) in Computer Science - First class with Distinction from CIT, Coimbatore, India

Employers :

• COMPUTER SCIENCES CORPORATION INDIA PVT., LTD., HYDERABAD from 18th JULY 2005 to FEB 2010

• COMPUTER SCIENCES CORPORATION INDIA PVT., LTD., BANGALORE from MAR 2010 to SEP 2010

• CAPGEMINI, BANGALORE from SEP 2010 to MAR 2011

• CAPGEMINI, HYDERABAD from MAR 2011 to TILL DATE

RECOGNITIONS EARNED :

• Winner of 'EMPLOYEE OF THE QUARTER' from employer - CSC

• TOP RANKED in all the APPRAISALS in CSC

• Received ‘CERTIFICATE OF ACHIEVEMENT’ from CSC

• ‘Project Star Award’ from Capgemini

Technical Skills:

ERP : Oracle Financial modules like AP/PO/GL/AR/IExpenses/

IProcurement, Oracle Applied Technologies like Workflow,

System Administrator, Oracle Apps 11i

RDBMS : Oracle 8i/9i/10g

Tools : Oracle Developer(Forms 6i/9i, Reports 6i), Java, HTML,

Oracle Workflow 2.5/2.6,Toad, Putty.

Operating System : Solaris, MS Windows (9x, NT, 2K, XP), UNIX

Other Software : CVS, Kintana

Other: Exposure to R12

Professional Experience:

Client: Office Depot, USA

Duration: Mar’11-Till Date

Project: OD – SDR and Tech Depot Services

Role: Oracle Apps Techno - Functional Consultant

Description:

This project includes the customization in finance module along with new services to be included by the client, Office Depot.

Responsibilities:

• Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs.

• Developing custom interfaces between various Applications for integration.

• Developing reports through Oracle Reports and XML Publisher.

• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.

• Collecting Business requirement and Leveraging with Oracle Applications

• Created Procedures, Functions and other database objects using SQL and PL/SQL.

• Defining Concurrent Programs, Executables.

• Customization and development Reports as per client requirements.

• Writing Unit Test cases and testing after completion of the Object.

• Supported all go-live activities and post-production troubleshooting.

• Preparation of MD070 Technical specification documents based on Functional Specifications.

Environment: Oracle E-Business Suite [R11i (11.5.10)], Oracle Financials Modules like AR, AP, Developer 2k, UNIX and Sqldeveloper.

Client: Walt Disney, USA

Duration: Sep’10 – Mar’11

Project: OTM - Reporting

Role: Oracle Techno - Functional Consultant

Description:

Oracle Transportation Management delivers robust transportation planning and execution capabilities to shippers and third party logistics providers. It integrates and streamlines transportation planning, execution, freight payment, and business process automation on a single application across all modes of transportation, from full truckload to complex multileg air, ocean, and rail shipments

OTM Reporting deals with the reports which help to analyze the data and track the shipments

Responsibilities:

• Customized and Developed BI Reports per business requirements.

• Involved in Report development using XML Publisher

• Writing Unit Test cases and testing after completion of the Object.

• Preparation of MD070 Technical specification documents based on Functional Specifications.

• Developed the documents so as to train the end users.

Environment: Oracle BI Publisher

Client: Petrofac, Sharjah, UAE

Duration: Apr'10- Sep’10

Project: Petrofac– ETL implementation

Role: Oracle ETL Consultant

Description:

Petrofac is an international provider of facilities solutions to the oil & gas production and processing industries. PCS project is for handling the progress and completion of the Infrastructure projects taken by Petrofac. This application would help client in tracking the project phase and the time and efforts required in completion of the task.

Responsibilities:

• Part of ETL design team, to design and develop the ELT mappings for populating the Dimension and Fact tables, based on which the reporting would be done.

• Developed mappings in ODI tool for various Dimension schemas

• Customization and development of BI Reports.

• Customization and development of Forms.

• Writing Unit Test cases and testing after completion of the Object.

• Preparation of MD070 Technical specification documents based on Functional Specifications.

• Understanding the Report functionality, Analysis and Review of High Level documents mainly MD050 Functional Specification.

Environment: Oracle Data Integrator, OBI

Client: Sun Microsystems Inc, USA

Duration: Jun’07- Apr’10

Project: IBIS, Financials - System Analyst

Role: Oracle Developer

Description:

As part of IBIS, Sun is performing a giant consolidation onto a single Oracle instance to support all applications throughout the company.

IBIS (Integrated Business Information Solution) is a SMI wide project, the purpose being:

• Application integration

• Workflow simplification

• Process re-engineering

• Business transformation

Responsibilities:

• Techno functional consultant in Oracle financials.

• As an onsite co-coordinator, Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs.

• Developing custom interfaces between various Applications for integration.

• Develop custom reports based on the Business requirement

• Developed data fix scripts for identifying the issues related to Invoices that are stuck in the interface table.

• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.

• Created and Registered concurrent executables and concurrent programs.

• Interacted with users to resolve any issues during the production, development and enhancement phases.

• Coordinating with Oracle Support through Meta link to resolve issues.

• Scheduled maintenance of business specific processes.

• Supported all go-live activities and post-production troubleshooting.

• Technical and Functional support for Period close and Quarter close for Sun Microsystems.

• Worked on listing the POXML WF errors, that occurs when transmitting the Pos to the external supplier.

• Preparation of technical specifications. Coding, testing and test plan preparation.

• Prepare/Report the daily/Weekly status reports

Environment: Oracle 11i financial modules - AP, Iexpenses, Iprocurement, PO, GL, P2P cycle, SQL, PL/SQL, Oracle 10g, UNIX

Client: Brooks automation

Duration: Sep ’06 –Jun ’07

Project: Oracle Financial and SCM modules

Role: Oracle Developer

Description:

Brooks automation is semiconductors and robotics manufacturing company. We implemented Financials and SCM of oracle applications 11.5.10 converting data from legacy applications like JDE, Hyperion

Responsibilities:

• Study and analyze the business requirements.

• Development of Stored Procedures to encapsulate Business processes

• Designed PL/SQL routines to translate, validate, log the exceptions and errors and transfer the legacy data.

• Involved in AOL activities.

• Reviewed the Design documents, program codes, test documents, installation scripts.

• Developed interface and conversion in AP, PO.

• Developed SQL loader control files

• Writing procedures, functions and package.

• Writing Database Triggers.

• Writing Program units.

• Client discussions.

• Designing and implementation of Reports.

• Adding the triggers in form level, block level and Item level.

Environment: Oracle 11i (AP, PO)

Client: Sun Microsystems Inc, USA

Duration: Jul ’05 – Sep ‘06

Project: Legacy, Financials - System Analyst

Role: Oracle Developer

Description:

SUNTEA is a customized module which has the functionality of IExpense. Before implementing IExpense module in IBIS, SUN uses SUNTEA tool for Travel and other reimbursements for the employees

Responsibilities:

Analysis of the SUNTEA Processes and Resolving the various defects discovered through analysis

Creating SQL, Object Views, PL/SQL database objects.

Developed Unix scripts based on client requirements.

Developed Adhoc queries using SQL

Performed Unit/System Testing

Improved the performance by adding new functional features

Interaction with the Client.

Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.

Tested the entire application in Testing environment and exported to Production.

Development of PL/SQL Scripts and Forms

Code fixes and Code enhancements.

Documentation.

Environment: SQL, PL/SQL, Java Applets, Basic HTML, Oracle 9, UNIX

Reference:

Furnished upon request

Contact this candidate