Swapan
Roychoudhury, OCP9i Sr. Oracle DBA
Project #14
Download Resume Format
Phone: 03323592147 Mobile 9433620987
Email: swapan@gmail.com
___________________________________________________________
SUMMARY
·
Highly
skilled, self-motivated Sr. Oracle DBA in Production and Development Database.
Administration..
·
Installation, Up gradation from older version to Oracle
10g, Security Management, Re-organization of database from one Unix box to
another Unix box using shell script. Backup Recovery Plan using RMAN (Recovery
Manager), Standby DB management – managed standby and automatic, Monitoring
alter log automated, Space Management, Rollback segment Management, Redundant
Constraints identification, Oracle 10g recycle bin automated to remove older
objects, performance tuned on sqls, memory, job management. Handled multiple US
client concurrently, with multiple database and multiple vendor like Oracle,
Sql Server, Mysql. Migrated data from different platform to Oracle.
·
Oracle Apps 11i DBA – Installed on multi nodes, Applied
patches, Admin Security, Concurrent Manager.
·
Programmer:
SQL, PL/SQL, Pro*C, COBOL, Perl, Shell Scripting, VB6+, Oracle Form and
Reports, Crystal Report.
·
UNIX
and WINDOWS system administration
·
Application knowledge on Sales order, production
planning, inventory control, purchase order, finance, US health Insurance.
·
Skill Set
Skill Name Skill
Level Last Used Experience
ORACLE Database
Administration Expert currently used 8 years
UNIX System
Administration Intermediate currently used 8 years
Windows System
Administration Intermediate currently used 6 years
SQL Programming Expert currently used 8 years
PL/SQL Programming Expert currently used 8 years
Shell scripting Intermediate currently used 2 years
Pro*C Intermediate 8 years ago 3 years
VB6 Intermediate 8 Months ago 3 Years
Crystal Report Intermediate 8 Months ago 2 Years
PeopleSoft Intermediate 7 Years ago 1 Year
Oracle Forms/Report Intermediate 7 Years
ago 4 Years
COBOL Expert 5 Years ago 5 Years
PC Hardware Intermediate
currently used 8 years
Total Experience:
16+ Years
Education:
Bachelor of
Commerce, Calcutta University (India)
Professional
Certification: Oracle9i Certified Professional.
Overseas Experience
One Year Experience
as Oracle DBA/People Soft Technical in USA
Project
Implementation and Project Study at USA
5 Months Experience
as Oracle DBA in Germany
Industry Experience
Consulting,
Manufacturing, Education, Food Processing, Oil, Health Care.
Project Details
Project #1
Sr. Database
Administrator for Pythian India Pvt Ltd(India support center of Pythian Group,
Ottawa, Canada)
Duration Jul2005 to
Present
The Pythian Group is North America's
leading provider of remote DBA services. Experts at getting fine-tuned
performance out of the Oracle database symphony, the Pythian Group provides its
clients with an unrivalled level of DBA proficiency, sophisticated Oracle
monitoring and reporting, and 24X7X365 service.
The company’s remote Oracle Database
Administration includes custom software solutions developed to answer specific
business needs efficiently and comprehensively. From advanced graphics-based
trends analysis to sophisticated time tracking by-the-minute, The Pythian Group
DBA tools leverage the maximum out of the Oracle software for every database.
Role : DBA, Data
migration, Functional on application migration.
Project #2
ERP
Consultant/Oracle DBA for a Manufacture Group of Companies.
Duration: Jun2004
to Jun2005
Project Description
The Company Manufactures machinery for Jute Industry, Jute Yarn to Export, Raw
Jute and Other Jute Products to export. The ERP has aimed to cover most of the
activities of Company. The main area of the functionality has been covered
Finance Purchase
Order & Inventory Control Payroll and HR Sales, Invoicing, and Production
Planning
Technology Oracle
10g/ Developer Suit 10g
Role Project
Manager/DBA Implementation of Old System in Oracle / VB6. Study, Design as well
as following DBA Activities
DB Creation
Storage Creation
Table Creation
Integrity Creation
Other Object
Creation
Data Migration
Stored Procedure
Migration
Project #3
Project Name
Migration from SQL Server2000 to Oracle8i including 600 Stored Procedures for
CTS, AL
USA
DurationJan2003 to
Jun2003
Project
Description: Computer Technology Solution is based on Alabama, has awarded this
project. Migration includes
- DB Creation
- Storage Creation
- Table Creation
- Other Object Creation
- Data Migration
- Stored Procedure Migration
Technology SQL
Server 2000 to Oracle8i on Windows2000
Responsibilities
Project Leader
Project #4
Project Name
HMOSOFT Project Manager/Oracle DBA for Empire Solution, FL USA.
DurationJuly02 to
Jun03
Project Description
Empire Solution a leading service provider in Tampa, FL, USA awarded a project
to develop an application which will automate the most of the task of a Health Maintenance Organization in USA that
will be included the following features:-
- Provider Network
- Benefit Package
- Member Enrolment
- Pre-certification
- Referral
- Authorization
- Claims Adjudication
- Billing
- Accounts Payable
Technology Oracle
8i, .NET of Microsoft in n-tire architecture
Role
System Study at
Client Place
Preparation of SRS
Entire Project
planning and execution.
Create and organize
tablespaces, rollback segments and data! files
Creation of
Database & its associated tablespaces, RBSs, users, tables etc. with
storage parameters
Creation and
maintenance of procedures, standards and interfaces for centralized database
management with particular focus on security
Project #5
Project Name Project Manager/Oracle DBA for
web based customer support services for Wellcare Inc.
Tampa, FL, USA
Duration Oct
2000 Jun2002
Project Description Wellcare is a leading Healthcare
insurance provider in USA. I am responsible for their
dynamic web hosting
project (www.wellcare.com) as well as other project like Capitation, Service
Fund, Pharmacy Claims, Commercial and Medicare Commission, Claim Tracking.
Technology Oracle
8i,Java, JSP
Role
Entire Project
planning and execution.
Create and organize
tablespaces, rollback segments and data files
Creation of
Database & its associated tablespaces, RBSs, users, tables etc. with
storage parameters.
Creation and maintenance
of procedures, standards and interfaces for centralized database management
with particular focus on security
Technical
assistance to personnel responsible for data analysis and database design
Project #6
Project Name
Project Study for Integrated Healthcare Provider Office Solutions for Park
Medical
Associates, Baltimore, MD,USA
TitleJun2001 Jul2001
Project Description
Park Medical Associates (PMA) is Baltimore Based Primary Health Care Provider.
They have a system called Medical Manager and Lab Manager. Medical Manager is
character-based system on SCO UNIX platform. The system captures patient
demographic information to Claim placement to Health Insurance Provider. Lab
Manager is DOS based system basically catering to Lab related activity. We have
given them an integrated Software Solution that will cater from patient
registration to claims realization from Insurance Company.
Project #7
Project Name Oracle
DBA for Vitago.com (Munich, Germany)
Duration May 2000
Sept 2000
Project
Description: The system is aimed for online trading, providing customers the
highest level of satisfaction while e-transactions. Goods are checked against
purchase order information and ultimately the stock tables are updated. The
changes in the product information done by the business development people are
uploaded every night to the server. In the near future, they are planning to go
for data warehousing so that they can easily access data from remote DB with
high-level security.
Technology Oracle
8.1.5/Weblogic/JAVA
Role
Create and organize
tablespaces, rollback segments and data files
Creation of
Database & its associated tablespaces, RBSs, users, tables etc. with
storage parameters
Creation and
maintenance of procedures, standards and interfaces for centralized database
management with particular focus on security
Creation and
maintenance of materialized vi!ews for data warehousing
Technical
assistance to personnel responsible for data analysis and database design
Conversion of
Access files into Oracle using Sql*loader for upload on server
Project #8
Project NameProject
Leader & DBA for West Cost Paper Mills Ltd, Bangalore
Duration Feb
2000 Apr2000
Project Description
West Cost Paper Mills is the second largest paper mills in India. Presently
they have host based system using Oracle7.0 using Forms3, Report 1.1 and Pro*C.
Migrated successfully from Forms 3.0 to Oracle Forms6.
Technology Oracle
8i, Forms 6, Report 6
Role
Create and organize
table spaces, rollback segments and data files
Migration of Data
from Oracle 7.0 to Oracle 8i
Sample testing to
migrate Forms3 to Forms6
Sample testing to
migrate Report1.1 to Report6
Strategy planning
for the entire migration.
Project #9
Project NameProject
Leader for Indian Institute of Social Welfare & Business Management!, Calcutta
Duration Oct
1999 Jan 2000
Project Description
IISWBM is a premium B-School in Eastern Region. They has entrusted us to
Automated some of their regular Activity. Total Computerization divided into 5 Modules like
Student Information Management, Administration Information System, Asset
Management System, Library Information System, and Hostel Management System.
Technology Oracle
7.3 with D2K
Role
Preparation of
System Design Document
Oracle Database
Design
Oracle
Installation, Database Creation and Maintenance
Database disk space
management.
Monitor and grant
access/privileges to users.
Create and organize
tablespaces, rollback segments and data files
Project #10
Project NameProject
Leader for Fort Gloster Industries, Calcutta
Duration Jun 1999 -
Sep 1999
Project Description
MMS, a versatile and comprehensive package helps to manage detailed information
viz. Details of various cables manufactured by FGI, Enquires received by FGI
(segregated based on the cable type viz. - PVC, XLPE, PILC, Rubber cables
etc.), Work Sheet generated by Marketing Department, Quotation Generation,
Purchase Order Information capturing, Acknowledgement of Order Issuing, Details
of Customer, Competitors, Agents, Dealers, etc. The package generates the
necessary entries for unknown product, which are required for the processing of
Technical Design System. Fort Gloster's Marketing department wants a totally
integrated computerized information management system to follow - up the entire
process starting right from enquiry stage to quotation stage, through the
design and production stages, till dispatch and payment, keeping the tight
schedule from last date of quotation to submission to delivery date.
Technology Oracle
7.3 with D2K
Role
Oracle Installation, Database Creation and Maintenance
Database disk space management.
Monitor and grant access/privileges to users.
Create and !organize tablespaces, rollback
segments and data files
Plan Back up process
Implementation and Project Leader for
Manufacturing Process Automation.
Project #11
Project Name Oracle
DBA for Detroit Public Schools, Michigan, USA
Duration Jan
1999 May 1999
Project Description
Detroit Public Schools is Apex body of all public schools of Detroit Metro
Area. They are Implementing Peoplesoft HR.
Technology Oracle
8.0 with People Soft HR
Team Size20
Role
Installation of
People Soft File Server including tools and application
PS Database
Creation
Configuration of
Client Set-up
Process Scheduler
Configuration
COBOL Batch file
Compilation
Oracle Installation
and Maintenance
Oracle database
creation for People Soft Database
Configure Oracle
Client using Sqlnet, Tnsnames and Listener.
Created multiple
instances running on a Single machine.
Database disk space
management.
Monitor and grant
access/privileges to users.
Create and organize
tablespaces, rollback segments and data files
Project #12
Project Name People
Soft Technical for Ernst Young of Lyndhurst, New Jersey, USA
DurationJun 1998 -
Dec 1998
Project Description
Ernst Young one of big 5 consulting firm in US implementing Peoplesoft Finance
for their
internal usage.
Technology Oracle
7.3 with Peoplesoft HR.
Role
Configuration of
Client Workstation Station
Process Scheduler
Configuration
Complex report
writing in SQR
Developed Panels
with People Soft Code
Project #13
Project Name
Integrated Hospital Management System for Duncan Gleneagles Hospital Ltd. (In
House Development Project)
Duration 1995 to
May 98
Project Description
Duncan Gleneagles Hospital is one of the leader heath care provider in
Calcutta(Now it is named to Apollo Gleneagles Hospital). It has taken a plan to
automated entire Healthcare operations. )
It is a Modular development of! an Integrated Hospital Management System using Client/Server
Technology. The entire project is
developing in collaboration with Peerless Technology Ltd. Using the methodology
of Object Modelling Technique of Humbugs.
Major Modules:-
Admission,
Discharge, Transfer, Reservation
Emergency
Outdoor Patient
Department
In Patient Billing
Diagnostics
Pharmacy
Nurse Station
Blood Bank
Operation Theatre
Staff Management
F/A
Material Accounting
Personnel
Information System & Payroll
Personnel
Information System & Payroll
Technology:
Oracle7.3 Server and Oracle Developer 2000 with Forms 4.5 and Report 2.5
Role:
System Analysis,
Design and implementation of Material Accounting, Finance, Personnel
Information System and Payroll,
Equipment Maintenance .
Installation and
maintenance of Oracle.
Database disk space
management.
Monitor and grant
access/privileges to users.
Create and
orga!nize tablespaces, rollback segments and data files.
Tuned memory and
IO.
Completed backup
plan.
Recover instances
from failure.
Projects for Mother
Dairy Calcutta India (From Jan 87 - Jun 95) In-house project deveopement
Project #14
Project Name Milk
Distribution System
DurationJan 95 to
Jun 95
Project
DescriptionMother Dairy Calcutta is the leader in Milk Processing in Greater
Calcutta. It distributes daily
through 500
outlets. System designed and developed to perform Invoicing, Tracking
Accounts Receivable,
Sales Analysis, Retailer Monitoring, MIS Reports and total DBA
responsibilities
Software: Oracle7
with Sql*DBA, SQL*Plus, Pro*C, Forms3.0, Report 1.1
Role: Analyze,
design, develop and implement Phase I of the project. Write Programs, design Forms
and Reports and total DBA responsibilities
Project#14
Project NameOn-line
Inventory Control & Purchase Order and Payroll.
DurationJan 93 to
Jun 95
Proje!ct
DescriptionAbove online systems designed, developed and implemented with the
following modules:
Material Accounting
System:
Automated Indents
Purchase Order
Processing
Good Received Note,
Store Requisition
Note
Store Ledgers
MIS Reports.
Payroll:
Pre-processing
Entry & Checklists
Payroll Processing
Post Payroll
Statutory Reports,
MIS Reports and
Annual Reports.
Technology Oracle6
with Pro*C, Forms3.0, Report 1.1
Role: Programming,
Form & Report Design, Implementation, migrated entire Data from COBOL
and FoxPro to Oracle 6, responsibilities of
DBA and Maintenance of the application.
Project #15
Project
NameIntegrated Financial Accounting with Inventory Control and Payroll
DurationJul 1989 to
Dec 1993
Project Description
Covers major areas of dairy automation implemented in following manner:
Financial
Accounting System:-
Distribution System
& Sales Accounting
Accounts
R!eceivable & Payable
Milk Billing
Milk Material
Accounting & Monitoring
Asset Accounting
Costing &
Budgetary Control
Inventory Control
System:-
Indent
Purchase Order
Goods Received Note
Stores Requisition
Notes
Stores Ledgers and
MIS Reports.
Payroll System:-
Pre-Processing
Entry & Checklists
Payroll Processing
Post Payroll
Statutory Reports
MIS Reports and
Annual Reports.
Technology Wipros
Proprietary Database with COBOL interface.
RoleAnalysis,
design, development and implementation of the Inventory Control and Payroll
along with maintenance of Financial accounting
System.
Personnel
Information:
Fathers Name: Late Dinesh
Roychowdhury
Date of Birth: 8th
October 1958
Address
(Permanent): GC 147/4 Salt Lake Sector -
I Calcutta -700 091
Phone 23592147, email: swapan@rediffmail.com
Martial Status:
Married with One Kid
Passport D!etails:
R8112121 valid till 21-Oct-2024
0 comments:
Post a Comment