JHARNA MANDAL

[pic]

Oracle Apps Consultant

(: acf2nc@r.postjobfree.com

( : +1-980-***-****

To be a dynamic professional in the field of Information Technology

providing impeccable solution for any given problem with commitment to

Company's excellence.

Experience Summary

. Over 4+ years of extensive experience as Oracle Application Technical

Consultant in implementation, upgrade and customization of Oracle e-

Business Suite Applications (R12, 11i).This includes system study,

design, development, post implementation maintenance and support of

Oracle EBS.

. Extensive experience in Oracle Configurator developer - User Interface

Design, Rules & Model Structure.

. Knowledge in Oracle ERP Application modules such as BOM, Inventory, Order

Management.

. Working on application development platforms like Java, JSP, PL/SQL and

Oracle Applications products

. Experience in designing, developing Forms 10g, Reports 10g.

. Knowledge in object oriented design and development - Java, JSPs,

Servlets.

. Strong in PL/SQL .

. A quick learner with the ability to work under pressure and meet

deadlines.

. Excellent team player, with good analytical and problem solving and

Interpersonal Skills.

Technical Skill Set:

Operating System: Windows XP

Databases: Oracle 9i, 10g

Oracle Apps: 11i version 11.5.3, R12 version 12.0.4

Tools: Oracle reports developer 10g, Oracle form developer 10g,

putty 51, Toad, SQL Plus, SQLl developer Version 1.5.4,

SQL*Plus: Release 10.1.0.4.2, winscp376,JDeveloper 10g

Language/Scripts: C, C++, core JAVA, JavaScript, JSP,P/L SQL.

Academic

2009 B.Tech in Computer Science and Engineering from B.I.E.T (WBUT) with a

aggregate of 8.24 cgpa.

2004 AISSCE Examination from Kendriya Vidyalaya Bokaro Steel City With

78% marks.

2002 AISSE Examination from Kendriya Vidyalaya Bokaro Steel City with

79.6%

marks.

PROFESSIONAL PROJECT PROFILE

Since June'10 with L&T InfoTech Pvt. Ltd.

Allvac Configurator Project (Offshore and Onsite Experience)

Role: Oracle Configurator Developer.

Duration: OCT-2012 - Current

Platform: Oracle Application R12 ( Oracle Configurator,

Order Management

Inventory,BOM)

Responsibilities:

. Technical and Funtional Consultant for Configurator

Implementation and Enhancements.

. Responsible for requirements gathering and definition,

conversion of business requirements into technical

specifications, technical project plans.

. Configurator Extensions created and attached to each case

model through configurator extension rule.

. Rule writing in a way to avoid any maintenance inside

Configurator structure in future

. Designing of MD50 and MD70 documents for Extensions and

Rules

. Development of Different Rules and Extensions as per the

requirement.

. Developed and modified Custom Objects such as

Tables,Views,Packages in database which are being used by

the Extensions to fetch data from Third Party.

. Responsible for publishing content for OM,Quoting.

. Creating UI's as per client requirement.

. Development of Test Cases for testing.

Eaton Hydraulics Configurator Implementation Project

Role: Oracle Apps Technical Consultant.

Duration: MAY 2012-SEPT 2012

Platform: Oracle Apps 11i (Inventory, BOM, OM,

Configurator module)

Description: This project is on Implementing Oracle

Configurator from

Cameleon's Product Configurator.

Responsibilities:

. Technical Consultant for Configurator Implementation

. Responsible for requirements gathering and definition,

conversion of business requirements into technical

specifications, technical project plans

. Responsible for developing Configurator Extension

(Functional Companion) using Java and CIO API to solve

attributes saving problem, model validation, and add

product search function to the existing UI.

. Creating and modifying UI for the new and existing models.

. Developed jsp as per the requirement for pricing.

. Creating and modifying UI for the new and existing models.

Larsen & Toubro Komatsu R12 Upgrade and Implementation Project

(Worked at Client Site)

Role: Oracle Technical consultant

Duration: OCT 2011 - APRIL 2012

Platform: Oracle Apps 11i, Oracle Apps R12

Description: This Project is on Upgrading Oracle EBS from

11i to R12 for LTK.

Responsibilities:

. Involved in Analyzing the Custom objects what needs to get

upgraded and moved to R12 EBS.

. Interacted with Clients for requirement analysis,

development and modification request.

. Involved in assessment of the Standard objects and basic

new functionality in oracle R12.

. Migrated all database custom Objects (

Packages,Procedures,Tables,

Views...etc.) to 10g database.

. Involved in modifying, compiling and migrating Custom

Reports and forms from Oracle 9i database to 10g database.

. Customized the rdf & xml custom reports to meet the

functionality in R12.

. Developed new custom forms as per the requirement.

. Designed menus and responsibilities to different level of

users in the organization.

. Developed and worked on various customer facing invoice

reports.

. Developed few new custom rdf and rtf Reports for AR,GL,SLA

modules

o AP Trial balance Report

This Report contains new functionality in R12, uses

java concurrent programs.

. Tested all the custom objects in R12 EBS.

. Handled SR's related to Migration issues in R12 EBS.

Eaton Electrical Distribution & Control Configurator Implementation Project

Role: Oracle Technical consultant

Duration: APRIL 2011-SEPT-2011

Platform: Oracle Apps 11i (Configurator module)

Description: This project is on Implementing Oracle

Configurator from

SAP Configurator.

Responsibilities:

. Technical Consultant for Configurator Implementation.

. Conversion of Items and BOM structure from SAP to Oracle

format

. Preparations of Item and BOM structure upload templates for

Oracle

. Populating models into configurator Developer of oracle

instance using concurrent program.

. Development of Extensions, Rules and User Interface as per

the requirement.

. Deloped databse Custom Objects used by jsp and Extensions

for data fetching.

. Published and tested the developed model with the SAP

application.

FSD Flowserve Development Project

Role: Oracle Technical Consultant

Duration: JUNE 2010-MARCH 2011

Platform: Oracle Apps 11i

Responsibilities:

. Worked on Item Conversion in the INV Module.

. Documentation using AIM methodologies of MD50's, MD70's

. Developed and worked on various customer facing invoice

reports.

. Created various (Back-end) PL/SQL code to implement

business rules through procedures, functions, and packages

using SQL*Plus Editor.

. Designed menus and responsibilities to different level of

users in the organization.

. Developed Forms like Invoicing, Delivery Order, Quotation,

Stock Inwards, Stock outwards, adjustments etc.

. Fixing Bugs in Forms and Reports previously designed

. Strong Knowledge in Development and Customization of

Forms/Reports with sound understanding ofApplication Object

Library (AOL).

Personal Details

Date of Birth: 16th November 1986

Gender: Female

Permanent Address: 6/33 David hare Road,

B- Zone Durgapur,

Dist- Burdwan (W B),Pin- 713205

Present Address: 1st floors, House No-44,4th A cross,

Rajeshree Layout, Munekkolala, Marathahalli

Bangalore (Karnataka), Pin-560037

Languages known: English, Hindi and Bengali

Declaration

I hereby declare that all the above information is true as best of my

knowledge.

Date

Place: Bangalore (Jharna Mandal)

Contact this candidate