Software Engineer Oracle
Resume:
P rateek Dhyani
***************@*****.***
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