Individual Traits:

• Ability to work independently
• Able to tackle the client in a professional manner
• Actionoriented and have the ability to take a Task completion
• Meticulous and Painstaking in ensuring accuracy of numbers

Software Experience (5.6 Years) ON ERP (Oracle Apps 11i):

Recently joined Genisys Information System and working with their customer Accenture, mumbai since last 5 months. Working on oracle application 11i, 12i – OM, Quote, Istore, Configurator modules.

Worked with Patni Computer Systems LTD. around 3 years.
Completed Motorola Russia BuySell Project successfully in 12 months
Completed Motorola LCOM (Order Management) Testing Project – Iteration / Phases 1, 2
successfully in 3 months
Worked on Motorola’s ECC Configurator Project since last 17 Months.
Worked for customer AVEVA, UK – Oracle forms 10G, Oracle Sql/Plsql for 6 months
Worked on database objects (Plsql), RICE and Oracle Application 11i Reports Customization
for OM, AR, PO, AP, GL, INV, WMS, CASH MGMT modules with Accenture Team for
1 year 4 months in Asahi India Glass Ltd. which is located at Kalamboli Kharghar, Mumbai.
Made more than 300 reports for all the above ERP modules of oracleapplication 11i for
Asahi India Glass Ltd.
Done Glass CuttingPacking (CNP) and ProductionPlanning (PPD) module project
enhancement in OracleApplication 11i for Asahi India Glass Ltd by using oracleforms 6i
and Oracle 9i as a database. Migrate above old system into oracleapplication 11i as well.

Made OracleReports for Vijay Fire (Kidde Ltd), Navi Mumbai for their new enhancement.

Implemented Import Export system module for OracleApplication 11i with TCS Team for
4 months by using oracleforms 6i and database 9i in West Coast Paper Mills Ltd which is
located at Karnataka (Dandeli)
Worked on Chola Mandalam Insurance project with Access Team, Seepzmumbai for
6 months by using Oracleforms 6i and oraclereports 6i.

Projects Detail Description

1. Job Profile For Genisys Information Systems LTD:

Confidential Project – oracle application 11i,12i configurator

Project 1 Confidential CZ Configurator
Employer Confidential.
Role Team Member
Platform Windows XP
Software Oracle application 11i, Oracle 9i
Duration 5 Months
Client Accenture, Mumbai
Project Duration 27Oct2009 06Apr2010
Tools Visual SourceSafe, Toad, Eroom

Confidential
Confidential works with organizations around the world, in every industry, in the public and private sectors, and of every size, from startups to the Fortune Global 500. Their customers include banks and other financial services firms, manufacturers, healthcare and life sciences organizations, Internet service and telecommunications providers, airlines and transportation companies, educational institutions, and publicsector agencies. EMC also provides technology, products, and services to consumers in more than 100 countries.

Confidential
In every Work Request (WR), Internal/External Defect, Break Fix we’re following below
phases:
Customer requirements study, Unit test case preparation, Development, Self test, Unit test
result preparation, PeerPeer Test, Integration Test, System Test, document uploading on
eroom.

We have achieved following milestones in the project:
Analyze the requirement document (RD)
Test cases creation with expected results
Scheduling peer reviews of test case report prior to test case execution
Development/Code creation using oracle application 11i configurator – BOM refresh, Non
BOM structure, Rules, UI, publication of models on test environment.
Executing of test scenarios (UAT)
Capturing test evidence
Documenting actual test results
Attend status meetings as scheduled by the test leads to report progress
To obtain signoff/approval of Test cases from project Test Leads, onsite SDG lead
ReTest where applicable, following the Quality EQUIPIT processes. Upload document on
Eroom for further system testing execute by TCOE team, Banglore

2. Job Profile For Patni Computer Systems LTD:

Confidential Project – oracle forms 10G, oracle 10

Project 1 Confidential Form Customization, Enhancement
Employer Confidential
Role Team Member
Platform Windows 2000
Software D2K (Forms 10G /Reports 10G), Oracle 10G
Duration 6 Months
Client Aveva
Project Duration 29Apr2009 20Oct2009
Tools TFS, Visual SourceSafe, Toad

Confidential
Confidential is the world's leading engineering IT software provider to the plant, power and marine
industries. AVEVA has harnessed the power of information technology and transformed entire
industries. These demanding industries, that once used drawing boards and plastic models,
now depend on AVEVA's integrated engineering software to drive every phase of a project's
engineering workflow. From initial design and specification, through 3D engineering layout to
procurement, materials management and project control, AVEVA's software combines technical
excellence with unrivalled data integrity – all within a framework of applications flexible enough
to meet the diverse requirements of all its use.

Confidential Project
In every Change Request (CR), we worked on the below phases:
Customer Requirements study, Design, Unit Test, Development, Self Test, PeerPeer Test,
Integration Test, System Test, code uploading in TFS

We have achieved following milestones in the project:
Study the requirement specification
Creating High Level, Low Level design document
Creating test cases with expected results
Scheduling peer reviews of test case report templates prior to test case execution
Development/Code creation using oracle form 10G and oracle 10G database
Executing of test scenarios
Capturing test evidence
Documenting actual test results
Attend status meetings as scheduled by the test leads to report progress
To obtain signoff/approval of Test cases from Project Test Leads, BA’s & BSA’s
ReTest where applicable, following the Quality EQUIPIT processes. Upload code in TFS for
alpha testing execute by customer

Confidential Configurator Project 2:

Project 2 ECC Configurator project
Employer Confidential
Role Team Member
Platform Windows 2000
Software Oracle Application 11.5.10.2 (OM, BOM, CONFIGURATOR),
D2K Forms 6I/Reports 6I
Duration 14 Months
Client Motorola and Emerson
Project Duration 22 Nov2007 22May2008
28Aug2008 – 28Apr2009
Tools Kintana, Clearcase, Visual SourceSafe, Toad

Made User Interface, Rules (Constraints) for the Oracle Configurator Bill of material (BOM) as
per business requirements in the CZ schema in 11.5.9 Apps version. User interface makes it
easy to select the parts/items as per the order. It reduces the number of errors at the time
of order entry. Configurator provides product manufacturing instructions / Graphical
representation which will be used to build the model/product.

Now working on Configurator 11.5.10.2 version of oracle application. Basically we have to pull the new/old BOM from apps manufacturing to Configurator and then have to create new rules and user interface for that BOM and publish the model in test/production mode.
Once model is published successfully in CZ schema (Model status is pending now), we have to run “Process Single Publication” concurrent program from apps which will make the status as “Complete”. Now user will test the model by creating new sales order and setting profile as test/production mode.

In 11.5.10.2 version of oracle application, CZ schema concept is not there. Oracle provides new responsibility i.e. “Configurator Developer” for creating new UI, Rules in 11.5.10.2 version of oracle application itself.

Worked on the customized triggers on sales order form as per logic developed for base item of
the BOM. Working on production support issues (Monet Tickets) also.
Migration of code handled through Kintana Tool (Pick up the code from clear case server only)

Confidential Testing Project – 3:

Project 3 Motorola LCOM Testing Project
Employer Confidential
Role Team Member
Platform Windows 2000
Software Oracle Application 11.5.10.2 (OM, BOM, CONFIGURATOR,
INV, PO, AR, and GL)
D2K – Forms 6I /Reports 6I
Duration 3 Months
Client Motorola
Project Duration 23May2008 28Aug2008
Tools Visual SourceSafe, Toad, Compass, Clear Quest

The scope of this project was to performed all necessary testing, including WRICE elements
(Workflows, Reports, Interfaces, Conversions & Extensions), Setups and Configurations to
ensured the successful implementation of customer requirements related to the B2B Long
Cycle Order Management Deployment.

The B2B Order Management Transformation Project involved design of a Global solution for
Order Management for the former G&PS long cycle systems (North America, EMEA and APAC
Regions) and former CHS.

Business processes related to the following Oracle modules has been mapped:
Order Management
Advanced Pricing
Configurator
Purchasing
Inventory

In every Iteration we worked on the below phases:
Customer Requirements, Development Requirements, Design, Development, Unit Test,
Integration Test, System Test, CAT

We have achieved following milestones in the project:
Creating test cases with expected results
Scheduling peer reviews of test case report templates prior to test case execution
Executing of test scenarios
Capturing test evidence
Documenting actual test results
Logging test defects in Clear Quest
Attend status meetings as scheduled by the test leads to report progress
To obtain signoff of Test cases from Project Test Leads, BA’s & BSA’s
ReTest where applicable
Following the Quality EQUIPIT processes and Templates

Confidential Project – 4:

Project 4 Russia buy sell (legal Entity) Project
Employer Confidential
Role Team Member
Platform Windows 2000
Software Oracle Application 11.5.10.2 (OM, PO, INV, AR, AP, GL),
D2K (Forms/Reports), UNIX Shell Script
Duration 12 Months
Client Motorola
Project Duration 21Nov2006 21Nov2007
Tools Kintana, Clearcase, Visual SourceSafe, Toad

Confidential Russia is one of the key growth areas in Europe as the market is large with a relatively low penetration of mobile phone users. Currently, the Motorola customer is responsible for customs clearance. During the last 12 months there have been several large confiscations of Motorola product because there have been apparent discrepancies in the importation process used. Apart from that the delivery time to customers in Russia varies significantly and tends to be lengthy. As per business requirement we have setting up Motorola’s own buysell entity in Russia.

Confidential Russia BuySell Project :
Made OracleApplication 11i concurrent programs (plsql pkg), oracle forms and Customized table scripts for Motorola Russia BuySell Project for internal sales order for Russia.

Made PO Receipt generation concurrent program (Interface for phase I)
Made XML Tag generation concurrent program (phase I)
Made FTP generic concurrent program – Unix Shell Script (Phase II) for several servers
Created Customized oracle form to capture different FTP server information
Created Customized oracle form to capture additional shipment information
Gave Technical Support to Motorola Russia BuySell Project for phase I, II

Created the concurrent programs to print Original Invoice/Credit Note (Russia),
VAT Invoice (Russia),
Torg12 (Russia),
Pack List (Russia)

Modified Motorola Russia Buy Sell FSS AR Interface Concurrent program which used to
extract all the invoices data for Russia Entity and send it to the FSS.

Modified Motorola Russia Buy Sell – FSS AP Interface Concurrent program which used to
extract all the Receipts data for Russia Entity and send it to the FSS and then NTS server.

3. Job Profile For Enhanced Software Solutions LTD:

Project 5 Oracle Application Forms, Confidential
Employer Confidential
Role Team Leader
Platform Windows 2000
Software Oracle Application 11.5.10 (OM, AR, PO, AP, GL, INV,
WMS, MFG, CASH MGMT),
D2K – Forms 6I /Reports 6I
Duration 16 Months
Client Asahi India Glass Ltd
Project Duration 27Jun2005 18Nov2006
Tools Kintana, Clearcase, Toad

Confidential The Group's principal activity is to manufacture and sell automotive and float glass. The Group operates in two segments: Automotive glass and Float glass. The Automotive glass segment manufactures and sells safety glass which includes laminated safety glass. The Float glass segment manufactures and sells float glass of thickness of 2mm12mm in different shades and in varying sizes. Asahi India Glass Limited requires oracle reports for their business purpose/internal organization use. All the reports were based on the OM, AR, PO, AP, INV, GL modules.

Created/modified Oracle Application 11i reports for Asahi India Glass Ltd which were based
on OM , AR , PO , AP , GL , INV , WMS ,MFG ,CASH MGMT modules.

Migrated old system i.e. glass cutting and packing project (CNP/PPD module) in oracle
Application 11i.

Done new enhancement i.e. made new oracleforms and reports
Made existing forms modification in glass cutting and packing projectCNP/PPD module.

CNP/PPD project includes:

Production Planning i.e. Excel sheet received from marketing (zone) staff.
Production Requisition i.e. Entering different glass size (length/wdth), colour, thickness,
Customer, glass mes, glass type, glass quality, packing type
Production Campaigning i.e. Considering above requisitions in campaign
Production Scheduling i.e. Considering above campaigns in schedule.
Generation of itemcodes i.e. Generation of new nonexisting items in oracleapps 11i
Generation of barcodes i.e. Individual barcode series has been developed for
Online, offline, loose pallete glass production
Printing barcodes i.e. Barcode get printed after production
Verification of barcodes i.e. Printed barcode get verified on their existence of item check

4. Job Profile For Chenab Information Technology:

Project 6 Confidential Import and Export Management System project
Employer Confidential
Role Team Member
Platform Windows 2000
Software Oracle Application 11i (OM), D2K Forms 6I /Reports 6I
Duration 4 Months
Client West Coast Paper Mills Ltd
Project Duration 18Feb2005 25Jun2005
Tools Toad, Oracle D2k – 6i

Confidential The Company manufactures writing, printing & wrapping papers The Company manufactures paper as per the specification of the end users including industrial users.

The end use of paper / paper board is for diaries, calendars, multicolor printing and ledger books EMS should track bill of entry for the purpose of export benefits tracking. EMS should provide tracking of export benefits like DEPB, AL and DFRC

I have done Integration with oracle application 11i with TCS Team for West Coast Paper Mills
Limited, Karnataka and made the oracleforms and documents (reports) for Import and Export Management System which is not covered in oracleapplication 11i
Above Import and Export system i.e. EMS tracks bill of entry for the purpose of export benefits tracking
EMS provides tracking of export benefits like DEPB, AL and DFRC

5. Job Profile For Chola Mandalam Insurance Company:

Project 7 AIMS Access Insurance Management System Project
Employer Confidential
Role Team Member
Platform Windows 2000
Software Oracle Application 11i, D2K Forms 6I/Reports 6I
Duration 6 Months
Client Cholamandalam MS General Insurance Company Limited
Project Duration 16Aug2004 – 16Feb2005
Tools Toad

Confidential
CholaMS deals with strong and rich portfolio of insurance products and services for the Indian customer for both retail and commercial segments. The wide range of products includes Accident and Health, Marine, Casualty lines, Property and Engineering besides Motor, Travel & Rural segments as part of its “customized risk solutions” approach, CholaMS requires risk advisory services to provide a holistic view of the risk management framework for the customer.

Made new forms for the SIGNIN system.
Made new reports for Access Insurance Management System Project (AIMS).
Customized the existing forms, reports for the Chola Mandalam Insurance Company
by using oracle forms and reports 6i.

Educational Qualification :
BE VIIl Sem Information Technology
BE VII Sem Information Technology
Diploma in Electrical Engineering

Computer Skills :

Front End Oracle Application 11i, Oracleforms 6i/9i, Oracle–reports,C,C++,
UNIX Shell Script
Back End Oracle Database 8i, 9i (Sql, Plsql), Sql server
Operating System Linux (Red Hat), Windows98/NT/XP
Microprocessor 8085, 8086,8051,8250,8255

BE Projects Undertaken:

Computer Network Simulator (C / Windows)
This project simulates computer network and evaluates its performance.
Done the project as fulfillment of final year (Degree Course) engineering curriculum from
Aditya Birla Group of Rayon Industries (Taxation Dept)

Technical Resources:

Hardware Resources: X86 based computer machine with at least 286 processor,
16 MB Ram, 1GB Hard Disk, color Monitor.

Software Resources: Operating System: MSDos 6.22,
Borland Turbo C compiler 3.0

Activities:

While in M.H.Saboo Siddik College I participated in cricket and our team stood second at intra college level.
I stood second in Table Tennis, chess and third in carrom.

Interests:
Listening good music Visiting new places Making friends Working out at gymnasium

Summary:
Mr. Pranay Dattaram Karawade is a Senior Software Engineer having around 5.6 years of IT experience. During this tenure, he has worked through various phases of SDLC such as Requirements Analysis, Design, Construction, Testing, and UAT. He has strong technical skills in the areas of Oracle Applications including Oracle PL/SQL, RICE, Interfaces, D2KForms/Reports 6I and 10G, Unix Shell Script. He has worked on Oracle Application 11i across OM, QUOTING, ISTORE, PO, INV, BOM, CONFIGURATOR, AR, AP, GL modules