SREEJA SUNKARA 248-***-****

SUMMARY:

. *+ years of Oracle Applications Techno (60%) Functional(40%)

experience with Oracle Applications (R12,11i, 11.0.3) and in

various other Business Application Development projects

. Oracle Technologies with strong Oracle Forms/Reports/SQL/PLSQL/XML

Publisher/Workflow/AME (SSHR,PO & AP Invoice Approvals)/Order & HZ

API experience.

. Extensive experience in analysis, design, development and testing

of business applications, web based and Client/Server environment.

. Extensive experience in Schema Structure design, performance tuning

& optimization, debugging, testing and business support.

. Good working knowledge in all the stages of Software Development

Life Cycle. Involved in review and gap analyses, functional/process

requirement gathering, technical design & test ware authoring.

. Excellent analytical and problem solving skills, excellent

writing/documentation skills, excellent interpersonal and

leadership skills.

. Experience in implementing full project life-cycle application and

database solutions

. Excellent communication skills, self-motivated and an efficient

team player.

KEY ROLES & RESPONSIBILITIES:

. Excellent professional experience of setting up and support of Oracle

Applications R12,11i :Oracle

HRMS,Financial Modules & Distribution Modules- Responsible for AIM

documentations, setups, bugs, enhancement requests, escalations

.Developed As-Is Process Flow Diagrams

.Developed Functional (Setup) Specifications (BR100) for RICEW objects

.Developed Technical - Conversion Specific Documents (MD50)

.Developed End User Training Documents

.Good experience customizing and personalizing approvals using Oracle

Approval Management (AME)

. Handled many of the technical issues such as Creation of Data

Conversion script. Developing Interface programs, Custom forms, Custom

reports, and Functionality customization.

. Excellent experience using Oracle On Demand development tools such as

SQL(Complex Analytical Query writing skills), PL/SQL(Packages,

Procedures, Functions, Triggers, Complex Data Conversion Scripts) and

Oracle Reports, Oracle Forms and Custom PLL,XML Publisher, Application

Desktop Integrator (ADI), Workflow, Financial Statement Generator (FSG),

Application Express (APEX )

. Good Experience working with 3rd party tools such as Secure CRT, Secure

FX, PL/SQL Developer, TOAD, SQL Navigator, SQL Developer, Perforce & PVCS

(Source Control), etc.

.Develop, debug triggers, procedures, packages, functions and views

.Experience with relational and dimensional logical and physical database

design

. Query optimization, performance tuning

. Knowledge of data warehouse management i.e. using ETL tool - OWB and

OLAP tool - Business Objects

. Creating complex queries for Decision Support Systems and integrating

with Financial, Human Resources and ERP systems

. Good Experience with writing functional, technical documentation and

User Manuals

. Provided Hands-On User Training

. Performed QA test cycles in a business development environment,

assisted in Defining Quality Standards and Methodology, QA process,

Release Process Model and Defect Priority Definition documents

overlooking the current site quality and performance, Prepare the Test

Data and Create the Test Scripts and Reviewing and reporting Test Cycle

status & preparing Test Metrics and Test Exit reports

ACADEMIC SUMMARY

Bachelor of Engineering in Electronics and communications

CERTIFICATIONS

. 11i10 Applications Developer - Oracle Implementation Champion

Certificate

. 11i.10 Oracle E-Business Suite HRMS APAC Implementation Champion

Certificate

. 11i Payroll APAC - Oracle Implementation Champion Certificate

ACHEIVMENTS

. Received Star Performer Award in 2010 in Mahindra Satyam

. Was selected for "Emerging Leadership" program at Mahindra &

Mahindra.

. Was selected as "Key Associate" for excellent contribution for Q2

(2009/2010) in Mahindra Satyam.

TECHNICAL KNOWLEDGE

RELATIONAL DATABASES PACKAGED APPLICATIONS DEVELOPER TOOLS

. Oracle 8i, 9i, 10g

. Oracle Financials 11i

. Oracle Developer (6i, 9iDS & 10gDS)

. Oracle, SQL Loader

. PL/SQL Developer

. TOAD

. Rapid SQL

DATA MODELING TOOLS OPERATING SYSTEM

. Oracle Designer (Design & Reverse Engineering),

. Oracle Warehouse Builder . Microsoft Windows

. Unix/Linux

PROFESSIONAL EXPERIENCE

> Mahindra Satyam Computers Services limited, Senior Oracle Apps Techno-

Functional Consultant

Sep '06

- May '11

JDS Uniphase Corporation, USA (Project Name: JDS AMS)

JDS Uniphase is a company that designs and manufactures products for

optical communications products, communications test and measurement

equipment, lasers, optical solutions for authentication and decorative

applications, and other custom optics. It is headquartered in Milpitas,

California, USA. It was formerly known as JDS Uniphase, prior to a

rebranding of its corporate image on September 14, 2005. The legal entity

is now called JDS Uniphase Corporation, whereas elsewhere the company

always refers to itself as JDSU

Responsibilities:

> Responsible for preparing the following Apps Standard Documents for

Oracle HR, GL, FA, AP,PO & OM modules:

V Questionnaire for requirement gathering

V As Is To Be flow diagrams

V BR100 Setup Documents

V MD50 - Data Conversion and Technical Features such as FSG, ADI, Custom

Workflows, Forms Personalization's, etc...

V Demo Slides for Apps Demo

V Apps User Training Documents

V Apps Test Script Documents

> Responsible for Functional Setup of the following modules HR, Payroll,

PO, OM &GL

V Setting the System Profile options at Site, Responsibility and User

level for( HR,GL,PO & OM modules

V Setting up HR,Payroll,GL,PO(&OM module

V Define Key Flex Fields(KFF) - i.e. Define Segments, Values,

Hierarchies for KFF such as Chart of Accounts KFF segments such as

Company, Division, Cost Centre, Accounts& Future, FA KFF

Such as Location, Asset Categories and Asset Keys

V Define descriptive (DFF) flex fields for storing custom information

such as Additional Ship To Address (location) information etc.

V Define security validations for KFF

V Define Calendar Types, Accounting Calendar

V Define GL Code Combinations

V Define Journal Sources, Categories, Auto-Posting & Auto-Reverse

options

V Define Set of Books

V Open-Close Accounting Periods in FA & GL

V Define Financial Budgets, Define and Schedule Recurring Journals,

Define FSG(s), Quick Codes,

Asset Categories, Depreciation Methods, Asset Locations, Setting up

Asset Financial Options for Integration with PO & AP.

V Define Sequences for Order Management

V Setup Customer Transaction types in AR

V Setup custom transaction types(defined custom transaction source type,

transaction action & transaction reasons) in WMS

V Customized existing collection plans to add additional quality

collection elements

V Setup item templates

V Verify setups by processing transactions and verifying the integration

with various modules.

V Customizing Transactions(Source, Action & Types) in the Inventory

module

V Setup custom product templates in Inventory Module

> Responsible for design, development and support of reports, interfaces,

forms, and extensions in the HR and other modules of the Oracle

Applications suite

V Interacting with various functional team members from client's side to

get in-depth understanding of the client's business processes.

V Played an active role in migrating Master and Transactions data by

using PL/SQL procedures to validate data in pre staging table and

importing data to base tables through APIs for HRMS Modules.

V Data migration included Jobs, Organizations, Positions, Locations,

Employees, Assignments, Pay Methods, Salary Proposals, Contact

Details, Passport/Visa Details, initial balance upload, element

entries etc.

V Performed numerous data pulling requests involving SQL scripts, UNIX,

TOAD.

V Wrote stored procedures and packages using PL/SQL

V Development, Registering and Testing of Reports and Interfaces.

V Suggesting Payroll processes using advance system features for more

matured operations.

V PL SQL business logic implementation in system's Fast formulas and

technical assistance to the team.

V Doing the necessary Setup [Creation of payment method, payroll

description, elements, element link, payroll testing].

V Processes: Quick Pays, Regular Pays, Retro pay, Prepayments, Costing

process.

V Absences, accruals and YTD managements..

V Involved in developing Integration Test Scripts and Documenting End-

User Training Materials and Performing Integration Test

Environment: Oracle R12i,Oracle 11.5.10, Oracle 10g/9i, Reports 6i, Forms

6i, Toad 8.0, UNIX, Workflow

Con-way Enterprise Services, USA (Project Name: freight_onsite)

Freight_onsite project is a part of financial sector transactions of Con-

way Enterprise Services (which is a full-fledged transportation and

logistics company in Portland-OR, USA). Major intent is to provide services

for data in and out flow of the legacy system to the Oracle financial

applications through interfacing and various custom components designed.

Responsibilities

> Responsible for development and implementation of various technical

aspects in HR,FA, GL,AP,AR,PO & OM modules on 11i and R12:

V Attending client meetings and knowing business requirements and

designing and developing technicalities suitable.

V Inbound interface development for Oracle purchasing in connection to

the custom components and standard financial setups arranged based on

the current business processes.

V Developed scripts for GL data conversion, Open Invoices(AP & AR)

conversion, Item/Product conversion from Legacy system

V Design, development and support of reports, interfaces, forms using

Forms & Reports Developer(6i) and launch as functions from Apps

V Handled production support tasks( like resolving AR invoicing issues

while interfacing to Finance Module - created data correction scripts,

data queries against AR schema tables to identify the data problems

caused after running the Revenue Recognition Program.

CISCO, USA

Responsibilities:

> Responsible for development and implementation of various technical

aspects in HR,SCM and Fin Modules

V Worked extensively with TCA Model i.e. created custom API for creation

of( consumer sold_to and ship to, Name, Address & Contact details -

creation of sold to consumer as the primary account in HZ_PARTIES as

Person, create & link sold_to address to the party, etc..

V Handled production support tasks( like resolving AR invoicing issues

while interfacing to Finance Module - created data correction scripts,

data queries against AR schema tables to identify the data problems

caused after running the Revenue Recognition Program.

V Created( custom API for AR and AP - Load financially eligible data

from OM to AR interface, triggers against AR and AP interface tables,

for various Custom Concurrent Programs - AR Invoice Consolidation, AR

invoiced data to AP for cash disbursement to vendors.

V Worked on the staging R12 Apps environment to convert AP suppliers &

AP Open Invoices from 11i to TCA Model & AP of R12.

V Conversion of financial data from legacy system (Quick Books) i.e.

Accounting Structure, GL Balances & past 5 years Journal Data to

Oracle General Ledger i.e. Use Open Interface feature of the GL module

to convert existing journal data. Wrote SQL*Loader & other API scripts

to migrate the data from the text files and populated the intermediate

tables like GL_INTERFACE, FND_FLEX and GL Code Combinations tables.

Executed Journal Import program from GL menu

V Developed scripts for GL data conversion, Open Invoices(AP & AR)

conversion, Item/Product conversion from Legacy system

V Create custom financial reports using Financial Statement

Generator(FSG) and integration with Application Desktop

Integrator(ADI) and also used Financial Analyzer to generate the same

financial reports(OFA)

V Design, development and support of reports, interfaces, forms using

Forms & Reports Developer(6i) and launch as functions from Apps

V Create API, Define and( Schedule Concurrent Programs to launch as

Concurrent Requests

V Custom Forms( Personalization's in Order Management & Purchase Order

modules

V Build( Workflows & APIs for order validation (applying holds etc.)

and progressing orders using Oracle Workflow Builder.

V Build several custom APIs for Web( Services for various Inbound and

Outbound processes like Order Address Validation against Web Service

such as FedEx, UPS etc, Ship to address correction, Update Order

Tracking Information etc.

V Create API for Order Pre-process, which is used to load new orders to

Oracle Order Management and integrates with .Net data up loader

> Developed approval rules based on invoice amount for the following

transaction type Payables Invoice Approval using Oracle Approval

Management (AME) and configured action types and actions and set up the

profile option to work for Payables only and also the required setup

through Payables Options form

> Developed, Personalized & Configured through Oracle Forms, Oracle

Reports, Oracle Workflow, Oracle ADI, Oracle APIs, Fast Formulas, Oracle

10g, PL/SQL, UNIX for 11i HRMS module.

> Develop programs that facilitate data conversion from legacy applications

to Oracle's enterprise suite.

> Involved in developing Integration Test Scripts and Documenting End-User

Training Materials for General Ledger, Fixed Assets,

Purchase Order and Accounts Payable modules and Performing Integration

Test

Environment: Oracle 11.5.10, Oracle 10g/9i, Reports 6i, Forms 6i, Toad 8.0,

UNIX, Workflow

> Institute for Electronic Governance, Oracle Apps Developer Jun '03 -

Sep '06

Jawahar Knowledge Center (JKC) is an innovative and pioneering

initiative that attracts the best students from all over the

state, providing them with a world class infrastructure and opportunities

to apply their knowledge to the challenging problems

Responsibilities:

> Supported Knowledge services of the Organization.

> Provided trainings for various clients on Oracle AppsTechnical (Oracle

9i SQL, PL/SQL, Forms, Reports and HR modules) and provided solutions

to the projects designated to the organization.

> Involving in screening process for students to be selected in various

companies.

> Involved in T3 (train the trainer) system for organization base

competency development.

Environment: Oracle 11.0.3, Oracle 10g/9i, Reports 6i

Contact this candidate