Post Job Free

Resume

Sign in

Oracle apps technical consultant

Location:
Smyrna, GA
Posted:
November 19, 2016

Contact this candidate

Original resume on Jobvertise

Resume:

MRADULA M RAI

Mobile No: 609-***-****

Email id: acxkbv@r.postjobfree.com

Synopsis

Over 5.75 years of technical experience surrounding high volume databases in Retail

systems domain. I have indepth understanding of the development life cycle process through

my experience. I am adaptable to new technologies and can handle tight deadlines through

effective communication.

Experience Summary

Work experience of 5.75 years as Oracle Applications Technical Consultant.

Excellent communication, presentation, analytical and problem solving skills with

varied experience across different process areas.

Major Strengths in Oracle Application Framework.

Experience in Oracle Applications version R12 customization

Creation and registration of OAF pages,PL/SQL Procedures, Packages, Menus,

Functions, Value Sets, Concurrent programs.

Good exposure in different self service applications, Project Accounting Modules

Involved in analysis, design and Development and Implementation Phases of complete

software Development Life cycle. Developed MD50, MD70 and MD 120.

Experience

Previously worked with Capgemini Pvt Ltd as Senior Systems Engineer at from Aug

2014 to Jun 2016.

Previously worked with Infosys Technologies Limited from Aug 2010 to Aug 2014.

I worked in various team sizes ranging from 6 to 20.

Education Details

Major and Specialization Aggregate

Degree and Date Institute

Bachelors in PES Institute of Electronics and 78.88

Engineering, 2010 Technology, Visvesvaraya Communication

University

2nd PUC, 2006 St Annes PU PCMB 95.00

College,Karnataka State

Board

10th STD, 2004 Kavery School,Karnataka N/a 93.92

State Board

Software Skills sets

Oracle Applications 11i/R12

ERP :

Programming Language : SQL, PL/SQL

GUI Tools : Oracle Application Framework, AOL, Oracle

WebADI

Tools and Utilities: SQL * Loader, TOAD, JDeveloper, Putty,

WINSCP, Sql Developer

Environment : JDeveloper, UNIX

Databases : 10g.

Trained in Oracle Forms 10g, Oracle Reports 10g, XML Publisher and Java

Functional Skills

Self Service applications(Manager Self Service, Employee Self Service, Performance

Management)

Oracle Incentive Compensation.

Oracle Projects

Have exposure to modules like OM,GL,AR,CM and AR.

Project Details

Infosys:

Client RICOH USA

Team size 15 (Offshore and Onsite)

Period April 2011Aug 2014

Client Description Ricoh is a leading role player in the field of providing office setup. Its

a $4 bn company, acquired IKON, InfoTech, which is of same field.

The company is located in Houston, USA.

Functional Area Oracle HRMS, AR, AP and CM

Responsibilities Working in Design and Development team of Finance, HR and

Customer Master

Worked mainly in developing OAF pages. Also worked

extensively on Extensions and Personalization.

Was able to develop myself from a fresher to a primary point of

contact for my onsite. Also, I got a firsthand experience of

handling a team in absence of my team lead.

Mentoring fresher and new people joining in the team. Helping

them in understanding the business process and technical

issues.

Also provided training within the team and across different

teams of the project.

Technologies used Oracle Apps EBS, Oracle Apps Forms 10g(Personalization), Oracle

PL/SQL, OAF, XML, UNIX Scripts and WebADI.

Project Details:

Deal Tracker System :It was system used for calculating the commissions for the Sales Person

and their Managers for number of deals they have booked for a period of Month.

Responsibilties:

Analyzing the User Requirements, discussing functional document (MD 50) and

preparing the technical design (MD 70) document.

Design and coding the custom pages using the OAF with java and database stored

procedures.

Doing basic OAF setup including database and runtime connections with

responsibilities and applications.

Creation of Application Modules, Controller Objects, Entity Objects and View Objects

and their Implementation files.

Create Packages using PL/SQL having functions and Procedures and call them from

OAF Controller Objects and Application Module Implementation Files.

Moving the developed codes to the production instance.

Integrating the module to eBusiness suite through standard oracle functions and

menus.

Unit testing the developed components.

System Integration Testing the entire application.

Support in User Acceptance Testing.

Received appreciation from clients and Managers and also got the OTS Award (On

The Spot) in Infosys.

Performance Management System (PMP)System : This System is a systematic process by

which the Department of Commerce involves its employees, as individuals and members of a

group, in improving organizational effectiveness in the accomplishment of agency mission and

goals .

Compensation Workbench (CWB) : Tool which would calculate the merit increase salary for

the employees for a plan period specified

Responsibilties:

Analyzing the functional document and creating the technical design document.

Substituting AM, VO, EO to change the business logic.

Extending Controller and Personalizing OAF Pages.

Integration of custom development to the standard applications.

Moving the developed codes to the test and production instances using WinSCP.

Creating different PL/SQL packages to be called from java codes using callable

interface.

Updating the technical documents after complete development of the component.

Designing the code migration documents which will be used by the DBA to migrate

the code in production.

Also got good exposure to HRMS module

Non Inventory Purchase Order (NIPO) : It is an Oracle based program where any employee

can enter a check request or expense range form, get approved, and route to Accounts Payable

to process the check request or invoice in Payables for payment.

Responsibilties:

Analyzing the User Requirements, discussing functional document (MD 50) and

preparing the technical design (MD 70) document.

Design and coding the custom pages using the OAF with java and database stored

procedures.

Doing basic OAF setup including database and runtime connections with

responsibilities and applications.

Creation of Application Modules, Controller Objects, Entity Objects and View Objects

and their Implementation files.

Create Packages using PL/SQL having functions and Procedures and call them from

OAF Controller Objects and Application Module Implementation Files.

Developed WebADI to upload bulk data into the system

Moving the developed codes to the production instance.

Integrating the module to eBusiness suite through standard oracle functions and

menus.

Unit testing the developed components.

System Integration Testing the entire application.

Support in User Acceptance Testing.

This was a very critical project with dead tight deadlines where we managed to deliver

on time. I have received MVP(Most Valuable Player Award)for this.

Capgemini:

Client GE

Project IGGL Workbench tool development(Internal Project)

Team size 3

Period Oct 2014Dec 2014

Functional Area GL

Responsibilities Working in Design and Development team dealing with

multiple Customizations of seeded OAF pages

Also provided training to freshers on OAF.

Technologies used Oracle Apps,Oracle PL/SQL, OAF

Client Black and Veatch Enhancement Team

Client Description Black & Veatch is a leading global engineering, consulting and

construction company. They specialize in major markets like

Energy,Water,Telecommunications,Federal and Management

Consulting

Team size 3

Period Dec 2014Present

Functional Area PO, Oracle Projects

Responsibilities Working in Design and Development of OAF pages.

Also worked on developing webADI.

Acting team leader

Technologies used Oracle Apps,Oracle PL/SQL, OAF, webADI

Project Details:

Requisition Interface : Worked on the design and development of custom Error Correction

Screen for Users to correct the Requisition Data which has errored in the staging table during

the requisition interface process.

Responsibilties:

Analyzing the User Requirements, discussing functional document (MD 50) and

preparing the technical design (MD 70) document.

Design and coding the custom pages using the OAF with java and database stored

procedures.

Doing basic OAF setup including database and runtime connections with

responsibilities and applications.

Creation of Application Modules, Controller Objects, Entity Objects and View Objects

and their Implementation files.

Create Packages using PL/SQL having functions and Procedures and call them from

OAF Controller Objects and Application Module Implementation Files.

Moving the developed codes to the production instance.

Integrating the module to eBusiness suite through standard oracle functions and

menus.

Unit testing the developed components.

System Integration Testing the entire application.

Support in User Acceptance Testing.

PROMIS Implementation: As part of finance roadmap implementation, PROMIS was

identified to be replaced with Oracle eBusiness Suite Projects module. Foundation

implementation consists of bringing structure above Project in Oracle including Master

Project and Super Revenue Project.

Responsibilties:

Analyzing the User Requirements, discussing functional document (MD 50) and

1.

preparing the technical design (MD 70) document.

Design and coding the custom pages using the OAF with java and database stored

2.

procedures.

Doing basic OAF setup including database and runtime connections with

3.

responsibilities and applications.

Creation of Application Modules, Controller Objects, Entity Objects and View Objects

4.

and their Implementation files.

Create Packages using PL/SQL having functions and Procedures and call them from

5.

OAF Controller Objects and Application Module Implementation Files.

Moving the developed codes to the production instance.

6.

Integrating the module to eBusiness suite through standard oracle functions and

7.

menus.

Unit testing the developed components.

8.

System Integration Testing the entire application.

9.

Support in User Acceptance Testing.

10.

Won Pat on the back award for this

11.

Achievements

Winner of Spot Award in the team, nominated by Project Manager for the year 2011

2012.

Winner of MVP(Most Valuable Player Award) for the year 20132014.

Winner of Pat on the back Award for the year 2015

Have secured distinction in 1st 5th, 7th 8th semester in B.E

Was awarded in recognition of meritorious performance for securing first place to the

district in second PUC State Board Examination 200506.

Have secured 4th place for the district in 10th State Board Examination 200304.

PERSONAL PROFILE:

Name : Mradula Rai

Fathers Name : Mohan Rai

Date of birth : 11061988

Marital status : Married

Address : 2139 Lake Park Drive SE, Apt M, Smyrna

GA30080



Contact this candidate