Project Developer
Resume:
DEBAJYOTI SAHOO
Email: ********@*****.*** in Phone: 095********
Current Role Description
Assigned as an Associate in Cognizant Technology Solutions
Skill / Experience Summary
1.From 12 March, 2012 till date Cognizant Technology Solutions In development and implementation with a good experience in PL/SQL, and Oracle 11g,SIEBEL-EIM,DATASTAGE,UNIX
2.From 25nd June, 2010 to 05th March,2012 in EXILANT TECHNOLOGIES PVT. LTD In development and implementation with a good experience in PRO*C,PL/SQL, developer 2000 and Oracle 9i/10g.
3.From 22nd June, 2009 to 15th June, 2010 in SQL STAR INTERNATIONAL LTD. In analysis, design and development with a good experience in PL/SQL, developer 2000 and Oracle 9i/10g.
4.From 15th October, 2007 to 19th June, 2009 in CMC Ltd. In analysis, design and development with a good experience in PL/SQL, developer 2000, Pro*C, UNIX and Oracle 9i/10g.
5.from July 2006 to June 2007 in Sponsored Research Industrial Consultancy (SRIC) - Indian Institute of Technology, Kharagpur with good experience in PL/SQL, developer 2000, Oracle 9i/10g
Technology Experience
Software
Oracle 9i/10g, Oracle 9i Pro-C/C++, Developer 2000,SIEBEL-EIM
Hardware
HP ES45 Alpha Server, HP ML570 Server and PC-AT/386/486/Pentium Series.
Tools
Oracle 9i/10g/11g, Pro-C/C++ Precompiler, Developer 2000 forms/reports 6i,Toad,SQL Navigator, Datastage
Domain Experience
1.Domain In T&H of STARWOOD HOTELS.
2.Domain In Loyalty of AMERICAN AIRLINES.
3.Domain in Permit section of KOLKATA PORT TRUST(KOPT)
4. Domain in Chief Material Management (CMM) of KOLKATA PORT TRUST(KOPT)
5. Domain in Hospital Management System (HMS) of KOLKATA PORT TRUST(KOPT)
6. Domain in Railway Pay Roll and Personnel areas, Advanced Finance System.
7.Domain in Coal India production information system
Education Summary
Degree and Date
Institute
Major and Specialization
Master in Computer
Application, July 2006
Jadavpur university
System
Professional training
Professional training
DURATION
C,C++,JAVA,ORACLE-9i/10g,DEVELOPER-2000,UNIX
From CMC Ltd
15 October,2007 to 29 February,2008
Certification
Database
Version
Product
Associate
Oracle9i Database
9i
Oracle9i Database
Oracle9i DBA/OCA
Experience Profile – Key Projects
Project #1
Project Title
STARWOOD HOTELS
Duration
March 2013 – Till Date
Location
Kolkata
Hardware
Intel based PC
Operating Systems
Windows 7 Enterprise
PROJECT DESCRIPTION
The main objective of the project is to migrate property data from Legacy systems to ISAC (Siebel application). Each property has their own Legacy application hosted on independent database and few properties share the same database. As the property has independent applications there is a need to migrate each application separately at a time. The migration of data from the Property Legacy system into ISAC involves a multi-stage approach to gather property-specific rules, extract the data from the Legacy database, transform, cleanse, and enrich the data, and load the data into the ISAC Siebel Database.
CLIENT DESCRIPTION
STARWOOD HOTELS
TECHNOLOGIES
Siebel-EIM, Oracle SQL, PL/SQL, UNIX,JAVA
ROLES AND RESPONSIBILITIES IN THE PROJECT
Analyse the requirement for Data Migration and Interfaces, validate data for
Data migration/interfaces from the legacy system, and develop PLSQL scripts and
EIM ifbs to load data to Siebel
Design and develop automation scripts in UNIX for Migration framework and
Otherwise deliver customized requirements for Starwood ISAC.
Status reporting, planning, and execution of project with specific focus on
Requirement analysis and design Client calls to clarify process implementations
And answer any questions that they might have.
Project #2
Project Title
AA VENTANA
Duration
September 2012 – March 2013
Location
Kolkata
Hardware
Intel based PC
Operating Systems
Windows 7 Enterprise
PROJECT DESCRIPTION
To implement Siebel Loyalty system to replace the ageing and expensive to maintain Mainframe based Loyalty Solution and bring in the best in class loyalty functionalities available with the Siebel-Oracle Suite. The project is for implementation of Siebel Loyalty and Integration Call Centre Application for 500 Call Centre Agents in United States. The goal of this project is to phase out the ageing and expensive to maintain Mainframe based Loyalty Application and implement best in class loyalty functionalities available in Oracle-Siebel Suite. The project is cantered on designing, developing and testing of the application.
CLIENT DESCRIPTION
American Airlines Inc.
American Airlines, Inc. (AA) is the world's fifth largest airline in passenger miles transported and operating revenues. American Airlines is a subsidiary of the AMR Corporation and is headquartered in Fort Worth, Texas, adjacent to its largest hub at Dallas/Fort worth International Airport. American operates an extensive international and domestic network, with scheduled flights throughout North America, the Caribbean, South America, Europe, and Asia/Pacific.
TECHNOLOGIES
Data stage, Siebel-EIM, Oracle SQL, PL/SQL
ROLES AND RESPONSIBILITIES IN THE PROJECT
Develop Jobs for both Batch and Mosaic user stories for loading Data into Siebel.
Create IFB files for data load into Siebel Base tables
Develop Data validation routines using SQL scripts
Automate Data validation routines using procedures.
Develop Outbound and Inbound Interfaces.
Performance tuning activities
Preparing Mosaic Data validation and Status Report.
Project #3
Project Title
Manulife CSMS, Hongkong
Duration
Mar 2012 – May 2012
Location
Kolkata
Hardware
Intel based PC
Operating Systems
Windows XP
Version Management & Bug Reporting
subversion
PROJECT DESCRIPTION
Manulife Financial is a leading Canada-based financial services group operating in 21 countries and territories worldwide. Manulife offers financial protection and wealth management products and services. These products and services include individual life insurance, group life and health insurance, long-term care services, pension products, annuities, mutual funds and banking products. Manulife also provide asset management services to institutional customers worldwide and offer reinsurance solutions, specializing in property and casualty retrocession. The Company operates in Canada and Asia through the brand name “Manulife Financial” and in the United States primarily through the brand name “John Hancock“. The project follows the onsite-offshore model, which means the enhancement requested by clients will be worked on from offshore as well as onsite. The project includes analysis and solution proposition of service requests raised by business users. Service Request is basically a change or enhancement that is driven by business or another application. A service request involves analysis, design document preparation, coding and testing. Technologies involved are Oracle, Pl/SQL, OBIEE, OSDM and ODI
CLIENT DESCRIPTION
Manulife Financial, Hong Kong
TECHNOLOGIES
Oracle SQL, PL/SQL, OSDM, OBIEE 11g
ROLES AND RESPONSIBILITIES IN THE PROJECT
Requirement gathering and requirement analysis.
Develop and test Oracle Stored Procedures, Functions and Packages.
Tuning queries in Oracle SQL and PL/SQL.
Involved in DBA activities and Shell Scripting.
Review of code changes, test procedure, test plans and other deliverables.
Project #4
Project Title
Indian Railways
Duration
Jun 2010 – Mar 2012
Location
Bangalore, Mumbai, Malda, Kolkata
Hardware
Intel based PC
Operating Systems
Windows 2000,HP Tru64 Unix
Programming Languages
Oracle SQL, PL/SQL, Oracle Forms, Reports,pro*c
PROJECT DESCRIPTION
Indian Railways is developing departmental MIS applications. INET project involves 2 separate applications dealing with various railway activities like finance & Budget & accounting processes, Payroll related system. All of the modules are related with each other and solid integration is there among them. The application is in Pro*c, Developer 2000 with Oracle9i/10g as backend support in HP Tru64 Unix platform.
CLIENT DESCRIPTION
Indian Railways (IR) is an Indian state owned railway company headquartered in New Delhi, India. It is owned and operated by Government of India through Ministry Of Railway
TECHNOLOGIES
Oracle SQL, PL/SQL, Oracle Forms, Reports, Pro*c
ROLES AND RESPONSIBILITIES IN THE PROJECT
Team member for the team of 25 people in onsite and 5 people in offshore.
Effort Estimation and Reporting Resource allocation.
Requirement gathering and Implementation
Develop Procedure, function, trigger, package and other required oracle object for application
Generate forms and reports using oracle forms and reports based on requirements.
Involved in the training session for the Business users.
Project #5
Project Title
KOPT
Duration
Jun 2009 – Jun 2010
Location
Port Trust, Kolkata
Hardware
Pentium based PCs
Operating Systems
Windows 2000
Tools
Business Objects
Database
Oracle 10g
PROJECT DESCRIPTION
This project cover all the activities of Kolkata Port Trust like- Admin, Revenue Collection, Permit, CMM, Hospital, Civil, Cash & Pay, and Boat Registration. To cover all of these activities we dived This System into different module:
Module 1: Admin Module.
This module is basically used to create user id and password with the proper password policy and provide Permission for different activities like – Addition, Deletion, Modification and Query for different forms and reports to different users.
Module 2: Revenue/Collection Module.
This module is basically used to collect the revenue from different Earning points. LIKE-Cargo, Containers, Liquid Bulk etc. And according to the requirement Reports can also be generated
Module3: Permit Module
This module is basically used to Issue the different types of Permit like- Vehicle/ Man on the basis of temporary/ Daily/ Monthly/ Yearly with the different rates of permit then approval of the permit, Re-issue/ Amendment of the permit, Sending for Police verification, Received from Police verification.
Module 4: Cash & Pay.
This module is basically divide into four part –
a) Receive Transaction – having three parts – Daily collection from earning points/Treasury Receipt, T/R Cancelation, T/R allocation.
b) Payment Transaction – List of Pending bills for payment, Consolidated ECS Cheque Preparation, Non – ECS cheque preparation.
c) Cash Book Transaction – Cash Transaction Form, Cash Payment Checking
d) Investment – New Investment, Withdrawal of Investment, Interest on Investment
Module 5: MMD.
MMD Module consists of Budget, Purchase Request, Indents, Enquiry, Quotation, Purchase Order, Receipt, Issue & Bill passing system. At first budget is determined through the system, then based on Budget from purchase request to purchase order of materials has been done through this system. Materials are given by vendor and store them into the stock and materials are distributed through the stock to the required departments. The bills against the materials are prepared and payment will be made to the vendor. This all processes are maintained through MMD system
Module 6: HMS.
This module is basically related to Kopt Hospital having the facility of OPD, Pharmacy, Pathology, Ward, Equipment, Stores etc.
CLIENT DESCRIPTION
The Port of Kolkata is a riverine port in the city of Kolkata, India. It is the oldest operating port in India, having originally been constructed by the British East India Company. The Port has two distinct dock systems - Kolkata Docks at Kolkata and a deep water dock at Haldia Dock Complex, Haldia.
TECHNOLOGIES
Oracle SQL, PL/SQL, Oracle Forms, Reports, Pro*c
ROLES AND RESPONSIBILITIES IN THE PROJECT
Team member in a team of 8 at onsite and 1 at offshore.
Effort Estimation and Reporting Resource allocation.
Requirement analysis and implementation
Develop different procedure, function, trigger, package and other required oracle object for application
Generated various kinds of forms and reports using oracle forms and reports.
Involved in the training session for the Business users.
Application maintenance and support.
Project #6
Project Title
SECR iNET
Duration
March 2008 – June 2009
Location
Bilaspur, Raipur, Nagpur
Hardware
Intel based PC
Operating Systems
Windows 2000,HP Tru64 Unix
Programming Languages
Oracle SQL, PL/SQL, pro*c, Oracle Forms, Reports
PROJECT DESCRIPTION
South East Central Railway Zone is a Railway Government Organization, is developing departmental MIS applications. INET project involves 7 separate applications dealing with various railway activities like finance & Budget & accounting processes, Payroll related system, Material management system, Freight & Passenger accounting system, Personnel management system, and Commercial management systems, Integrated Project Management System etc. All of the modules are related with each other and solid integration is there among them. The application is in Developer 2000 with Oracle9i as backend support in HP Tru64 Unix platform.
CLIENT DESCRIPTION
The South East Central Railway is one of the sixteen railway zones in India. It is headquartered at Bilaspur and comprises Nagpur division, reorganized Bilaspur division of South Eastern Railway and new Raipur division.
TECHNOLOGIES
Oracle SQL, PL/SQL, Oracle Forms, Reports, Pro*c
ROLES AND RESPONSIBILITIES IN THE PROJECT
Team member for the team of 8 people in onsite and 1 people in offshore.
Develop different procedure, function, trigger, package and other required oracle object for application
Data validation by writing SQL scripts.
Generated various kinds of forms and reports using oracle forms and reports.
Involved in the training session for the Business users.
Involved for application maintenance.
Project #7
Project Title
Coal-Net
Duration
Jul 2006 – Jun 2007
Location
Kharagpur IIT,BCCL Dhanbad
Hardware
Pentium based PCs
Operating Systems
Windows 2000
Tools
Business Objects
Database
Oracle 9i
PROJECT DESCRIPTION
COALNET is an ERP solution for Coal India Ltd (CIL). Coal India is a public sector consisting of seven subsidiaries (e.g. ECL, BCCL, NCL, MCL etc.). It operates 486 collieries and produces and sells over 280 million tons of twenty different grades of coal and consists over half a million employees. We are developing a Web Based Application system, which integrates the different functional areas of Coal India Ltd. and its subsidiaries. This application system is divided into different modules such as Personnel, Payroll, Sales and Marketing, Finance, Production, Project, Material and Equipment.
CLIENT DESCRIPTION
Coal India Limited (CIL) is an Indian state-controlled coal mining company headquartered in Kolkata, West Bengal, India and the world's largest coal. It was formerly owned entirely by the Union Government of India, under the administrative control of the Ministry of Coal. It is involved in coal mining and production industry. In April 2011, CIL was conferred the Maharatna status by the Union Government of India [4] and ranked as one of India's most valuable company by market value.
TECHNOLOGIES
Reports 6.0, SQL Script
ROLES AND RESPONSIBILITIES IN THE PROJECT
Involved in the training session for the Business users.
Generated various kinds of reports using oracle reports
Perform data validation by creating SQL queries.
Involved for application maintenance.
Employment Summary
Dates
Organization
Role
12-MAR-2012 to
Till Date
25-JUN-2010 to 05-MAR-2012
22-JUN-2009 to 15-JUN-2010
01-MAR-2008 to
19-JUN-2009
15-OCT-2007 to
29-FEB-2008
July,2006 to
June,2007
Cognizant Technology Solutions
EXILANT TECHNOLOGIES PVT.LTD
SQL STAR INTERNATIONAL LTD
CMC LIMTED
CMC LIMTED
In Sponsored Research Industrial Consultancy (SRIC) - Indian Institute of Technology, Kharagpur
Analysis, Development,
Implementation &Maintenance
Analysis, Development,
Implementation &Maintenance
Analysis, Development,
Implementation &Maintenance
Analysis, Development,
Implementation &Maintenance
Corporate Training
Development, Implementation
&Maintenance
Skills: SQL, PL/SQL, Pro*C, Developer-2000, Oracle9i/10g/11g, SIEBEL-EIM, Datastage
Personal Details
Date of Birth
02-01-1983
Nationality
Indian
Permanent Address
S/O- Amulya Sahoo
At+po-Sautia,Dist- Paschim Medinipur,West Bengal
PIN-721457
West Bengal
Current Address
Saptarshi Apartment,
23 Purba Sinthee,Dumdum
Kolkata-700030
West Bengal
Contact this candidate