P rateek Dhyani

+91-903*******

acddvo@r.postjobfree.com

Software engineer having around 3 years of experience as an Oracle Apps techno / functional

consultant

Synopsis

Around 3 years of experience in Analysis, Design, Development, Testing and Implementation

of Software Applications using Oracle Applications 11.5.x/R12 spread across

I mplementations, Version upgrades, Data conversions and Customizations

Experience in three full lifecycle implementations. Strong knowledge of Procure to Pay Cycles.

Extensive experience in Oracle Application Modules which include General Ledger(GL),

P urchasing(PO), iProcurement modules.

Expertise in Workflow Customization according to business needs.

Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes

Familiar with Software development life cycle

Defined value sets, concurrent programs, request sets, registering reports and PL/SQL

P rocedures,

Packages, UTL_PACKAGE

Strong analytical, diagnostic and t roubleshooting skills and ability to work in a fast-paced and

team-oriented environment.

E xperience in environments requiring direct customer in teraction during specifications,

documentation,

design and development and implementation phases.

Quick learner and adaptable to new professional situations.

Got t raining in SQL, PL/SQL, Oracle Forms/Reports, Oracle Workflow, BI Publisher.

Employment

UST Global Assoc. Softwa re Developer

UST Global is a software company and is a leading provider for end to end IT and BPO

services for Fortune 500 listed companies

Client : General Electricals(GE)

P roject Details: I t is an 11i to R12 migration project, in which we are migrating all the

business processes from 11i to R12 with the changes as suggested by business.

Work Experience

2

T echnical Experience& Responsibilities: -

About 3 Years of Oracle Applications experience - Responsible for gathering

B usiness Requirements, creation of Technical Design Documents and user

Documents.

Developed Shell Script,PL/SQL Packages, Procedures and Functions to Customize

t he Purchasing Document Reset Program to meet the business needs like resetting

t he status of the document for multiple document types at a time, resetting the

s tatus of the document even if accounting entries are not proper etc.

Customized oracle seeded workflows like PO Approval Workflow to meet business

needs

l ike, Update buyer of the PO with last modified person, Make projects mandatory

for

certain code combinations, Send PO to supervisor when Buyer and Requestor are

same,

I mplemented notification reminder and Timeout needs etc.

Customized POR_CUSTOM_PKG to meet business needs like, every supplier should

be mapped to a buyer, Project mandatory for certain code combinations.

Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and

I ndexes

Developed functional and technical specifications as well as test plans and test

scenarios.

Excellent communication skills, adapt in client in teraction and understanding

business applications.

Pro-actively identify areas of opportunity and work to finding solutions that meet

t he business needs of the customer.

Absolutely capable of working in a fast paced, dynamic, team-oriented environment

w ith 24x7 support.

Functional Experience:-

iPO (Internet Procurement): Excellent knowledge of the whole implementation path

(business requirements definition & mapping, set up, testing, production support).

Requisitions (catalog, non-catalog, public lists, punchout), Approval, Receiving,

I nquiries. Catalog Administration, Stores, Content Zones, Shopping Categories and

Category Mapping

PO (Oracle Purchasing) Module specialist: Excellent knowledge of the whole

i mplementation path (business requirements definition & mapping, set up, testing,

p roduction support). Approval, Security and Control issues, Requisitions, Purchase

O rders (Standard, Local and Global Blanket Agreements, Planned Agreements,

2

Local and Global Contract Agreement, Auto creation), Supply Base Management

(Request For Quotation, Quotations, Approved Supplier L ists, Automatic Sourcing),

Receiving.

SA (System Administrator): Good knowledge of module’s features. Security, Users

definition, Responsibilities definition, Menus defini tion, Profile options, Sequences

and Categories, Scheduling Processes and reports, Descriptive Flexfield.

Extensively involved in gathering customer requirements, defining setup according

to the requirements and business practices. Support to testing activities.

Good in documentation (Preparing BR100 documents for setups done, MD200,

U TC).

Technologies

Worked technologies: Oracle APPS 11.5 and 12.0.3, SQL, PL/SQL, Workflow, AOL

Modules: iProcurement, Purchasing

Tools: SQL Developer, putty, WinSCP, Toad, Workflow Builder

Academia

• B.Tech Computer Science from M IT, Meerut affiliated to UPTU with 70.08% aggregate.

(2007-2011)

• In termediate from CBSE Board with 82.8%.(2007)

• 10th from CBSE Board with 75.6%.(2005)

Personal Details

Name:Prateek Dhyani

Father's Name:Mr. O.P.Sharma

4

th

Date of Birth:4 April,1989

Marital Status:Single

Nationality:Indian

Linguistic Competence:English and Hindi

Passport Details

Passport No:J9542023

Passport Issue Place: Ghaziabad

Passport Expiry:16/10/2021

4

Contact this candidate