Project Oracle
Resume:
Name: Prasenjeet kumar Taraphdar
Contact No: 01-913-***-****
Email: ace0yp@r.postjobfree.com
Professional Synopsis
. A dynamic professional with 3+ years of rich & extensive experience in
Oracle EBS Development and PL/SQL package development, script
development along with using of Oracle APIs.
. Efficient in end-to-end development using analytical and technical
skill right from designing, coding, testing, de-bugging, documentation
and implementation.
. Gained sound knowledge and experience in project management
responsibilities like Defect Prevention and knowledge transfer. Full
responsibility of Invoicing, status report preparation, presented to
client.
. An effective communicator with excellent leadership qualities,
relationship building & interpersonal skills.
Areas / Applications
. Retail and CPG
- Oracle E-Business Suite R12
> Core HR
> Payroll
> Advanced Benefits
> Oracle Workflow
- Develoment in PL/SQL and Unix
> Package Development
> Unix Script Writing
> Oracle APIs for inbound data from legacy system to
Oracle
. Banking and Financial Services
- Oracle E-Business Suite 11i
> Core HR
> Payroll
- Develoment in PL/SQL and Unix
> Package Development
> Unix Script Writing
> Oracle APIs for inbound data from legacy system to
Oracle
Technology
Below is a list of important hardware, software products, tools and
methods that I have worked with.
Qualifications
Degree and Date Institute Major and
Specialization
Bachelor of BITM (West Bengal Electronics and
Technology, July University of Instrumentation
2010 Technology)
Assignments
The details of the various assignments/Projects that I have handled are
listed here, in chronological order.
Since July 2012 - Till Date Tata Consultancy Services Limited
Project Hallmark Managed Service, USA
Customer Hallmark Cards, Kansas City, USA
Period July 2012 - Till Date
Role Developer and Support Executive
Responsibilities Enhancement and Customization - Analysis of
the requirement and effort estimation,
preparation of technical Design document,
coding and unit testing, Integration and
regression testing.
Enhancement of Oracle Workflow - Design change
and development of workflow, modification of
backend package processing for workflow, unit
testing from Oracle front-end and Migration to
fulfil business requirement.
Analysis and Resolution of tickets related to
Hallmark EBS instance.
Root Cause Analysis of repeating incidents.
Identify and implement a permanent fix.
Design and development for creation of a new
interface related to Oracle HR, Benefits,
Payroll to extract data file.
IQA and peer review of the deliverables
Batch job Monitoring
Status reporting - Reporting the status of the
project and work to client and COE in a weekly
basis.
Project Hallmark Cards Inc., based on Kansas City, MO,
USA is the leading manufacturer of greetings
cards in United States. Their IT operations
and applications are divided into 15 different
subgroups; each sub-group supports IT
applications of one or more than one business
areas. Each sub-group is commonly referred to
as service wheels in general. Under the
managed service contract, TCS is currently
providing the end to end IT support for all
the 15 service wheels and corresponding
applications. As of December 2012, the IT
infrastructure of Sunrise Greetings is merged
with its parent company Hallmark Cards and is
taken under the Hallmark managed service
umbrella. The business activities are tracked
through the Oracle EBS R12 for different
phases in Supply Chain Management and
financial recordings. The SCM modules that are
being used are Order management, Purchasing,
Inventory Management and Warehouse Management
system. The HR module that being used are
Oracle core HR, benefits, payroll, CWB
,discoverer and ods. The project follows an
Onsite-Offshore model. Currently there are 4
associates at offshore and 3 associates in the
onsite location. The purpose of this project
is to provide application maintenance,
enhancement and production support for the
client.
Carried out the following activities:
System and Requirement Analysis
Preparation of Technical Design Document for
Application Enhancement
Coding and Testing
Root cause analysis of repeated issues and
provide permanent solution.
Batch job monitoring
Work Location Kolkata (India) and Kansas City (USA)
Since June 2011 - June 2012 Tata Consultancy Services Limited
Project Experian Development and Enhancement, UK
Customer Experian, UK
Period June 2011 - June 2012
Role Developer
Responsibilities Enhancement and Customization - Analysis of
the requirement and effort estimation,
preparation of technical Design document,
coding and unit testing, Integration and
regression testing.
Created new concurrent programs to automate
the batch job monitoring and sending mails to
the users for most of the batch jobs.
Design and development for creation of a new
interface related to Oracle HR, Benefits,
Payroll to extract data file.
Status reporting - Reporting the status of the
project and work to client in a weekly basis.
Project Experian is the leading global information
services company, providing data and
analytical tools to clients around the world.
The Group helps businesses to manage credit
risk, prevent fraud, target marketing offers
and automate decision making. Experian also
helps individuals to check their credit report
and credit score, and protect against identity
theft. . The HR modules that being used are
Oracle core HR, benefits, payroll, CWB, iRec.
The project followed an Onsite-Offshore model.
The purpose of this project is to provide
application enhancement and development for
the client.
Carried out the following activities:
System and Requirement Analysis
Preparation of Technical Design Document for
Application Enhancement
Coding and Testing
Work Location Kolkata (India)
Since March 2011 - May 2012 Tata Consultancy Services Limited
Project ILP
Customer TCS Internal
Period March 2011 - May 2011
Role Trainee
Responsibilities Attending training on Java and J2EE.
Development of small sample project on J2EE.
Project It is a TCS internal training session to train
trainees on different languages such as JAVA,
.NET, Mainframe.
Carried out the following activities:
System and Requirement Analysis
Preparation of Technical Design Document for
Application Enhancement
Coding and Testing
Work Location Chennai (India)
Training Conducted
Year Title Presented to Location Organised
By
2012 Oracle Apps Sunrise Kolkata, Tata
Core HR R12 Greetings India Consultanc
Offshore y Services
Resources Ltd
Training Attended
Year Title Conducted By Location
2012 Oracle Apps - Tata Consultancy Kolkata,
Advanced Benefits Services Ltd India
and Payroll
2012 Oracle Apps - Tata Consultancy Kolkata,
Compensation Services Ltd India
Workbench R12
Personal Details
Date of Birth June 10, 1989
Sex Male
Nationality Indian
Marital Status Single
Passport Details
Name as on Passport Date of Expiry Date Place of
passport Number Issue Issue
Prasenjeet kumar J3271648 July 09, July 08, Kolkata,
Taraphdar 2010 2020 India
Visa Details
Visa Type Date of Issue Expiry Date
H1B Sep 06, 2013 Aug 27, 2016
Software Products Tools Programming
Languages
Operating Systems Front-End Tools: PL/SQL Developer PL/SQL, UNIX
: WINDOWS Oracle Application 7.1.4, Toad, Script, JAVA,
95/98/2000, 12.1.3,Oracle Oracle Workflow C
WINDOWS Application 11,BMC builder,Discover
XP,WINDOWS 7, Remedy User, er, ODS, Oracle
WINDOWS 8 Service Now Report Builder
6i, Winscp,
Putty,
Attachmate
Reflection
Contact this candidate