Swapan Roychoudhury, OCP9i Sr. Oracle DBA
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
DBA Experience: 8 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:
<div class=