Manager Oracle
Resume:
MANORANJAN DASH
+91-33-221*****, 833-***-****(Mobile)
********@*******.***, *********@*****.***
PASSPORT NO.: S7345873
Career objective:
Aspiring for a career where innovative thoughts are nourished and dynamic learning curve is encouraged. I do possess excellent inter personal and communication skills. I aim to reach astounding heights in career growth through result oriented work and relevant knowledge.
•Have 18 years of software development experience, which includes two years of experience at Techna Digital Services Ltd., executing software development as Programmer Analyst and seven months at NIIT LTD., which includes executing software development as Systems Executive and four months at I-Flex Solutions Ltd., Bangalore includes executing software development as Associate Consultant and thirty six months at computer associates tcg software pvt. Ltd.
•Delegated responsibilities at Cognizant Technology Solutions Ltd Kolkata as Associate for duration of fifteen months. I had delegated my responsibilities at L & T InfoTech as Project Leader for duration of eight months. I had delegated my responsibilities at IBM Bangalore as Senior System Engineer for duration of twenty four months. I had delegated responsibilities as Senior System Analyst-It Is at CTS Bangalore for duration of eight months.
•Have 10+ years of experience as ORACLE DBA.
•Also delegated responsibilities at London, UK And New York, US
•I had delegated responsibilities at NEW YORK,USA on H1B VISA from FEB. 2008 to AUGUST 2008.
•Currently I am delegating responsibilities as PROJECT MANAGER at TECH MAHINDRA PUNE from JUNE 2007 to present.
Work Experience
TECH MAHINDRA,PUNE - June 2007 to present
Cognizant, Bangalore - November 2006 to June 2007
IBM, Bangalore - November 2004 to November 2006
L & T InfoTech - April 2004 to November 2004
Cognizant, Kolkata - December 2002 to April 2004
CATS-TCG Software - December 1999 to December 2002
NIIT Technologies, Kolkata - February 1999 to December 1999
Academic Qualification
S.No
Examinations
University and
Duration (from & to)
Percentage obtained
1
BE (Ceramic Engg)
Calcutta University
(1989 to 1993)
68%
2
B.SC. (Physics, Chemistry & Mathematics)
Calcutta University
(1987 to 1989)
56%
3
H.S. (10+2)
W.B. Council Of Higher Secondary Education (1985 to 1987)
55.2%
4
MADHYAMIK (CLASS X)
W.B. Board Of Secondary Education (1985)
73%
5
PGCACS (Post Graduate Course in Applied Computer Science)
CMC LTD. (1995 to 1996)
C Grade
Certification:
Certified Oracle Professional (OCP) in SQL and PL/SQL from ORACLE CORPORATION through successful clearing of the on-line examination at TECHNA DIGITAL SERVICES LTD, CALCUTTA, INDIA an authorised SYLVAN PROMETRIC TESTING CENTRE for INDIA.
Date: 24 June, 1998 Score: 650 out of 800
Professional Achievements
Received award from income tax department(form no.1 6) for conducting excellent walk-in interviews during the tenure at tech mahindra pune.
Skill Sets / Competencies :
Language : C++, JAVA, C
Database : ORACLE 9i,ORACLE 8i, ORACLE 8.0,
ORACLE 7.3
Front end Tool : Developer 2000 (Forms 4.5,FORMS 5.0, Reports 2.5,
Reports 3.0)
Designer Tool : Rational Rose(Booch’s UML)
GUI/Front end : RACLE JDeveloper
O/S USED : SUN SOLARIS 5.8,SCO UNIX,WINDOWS NT 4.0
Project Profile:
#1 Installation of RAC Cluster
Period : June 2007 to till date
Client : NetApp, USA
Team Size : 7
Technology : Oracle 10G, Oracle 9i RAC CLUSTER.
Description :
NetApp maintains storage of databases. NetApp storage solutions include specialized hardware, software, and services, providing seamless storage management for open network environments. The objective of the project was to install oracle 9i RAC product.
The installation of oracle 9i RAC consists of the following high level steps:-
•Install oracle cluster manager 9.2.0
•Configure the oracle cluster manager
•Patch the oracle cluster manager to 9.2.0.7
•Switch gcc binaries.
•Install oracle database 9.2.0.7
•Patch oracle database 9.2.0.7.
Role & Responsibility:-
Project manager:-
As project manager, I have taken interviews of the candidates for oracle dba.
•Oracle Database Architecture Server version: 10g, 8i and 9i o/s
Platform: Solaris 5.0, Solaris 2.8, Windows NT, DOS
•Memory configuration of oracle database
Server version: 8i and 9i o/s platform: Solaris 5.0, sco UNIX, Windows NT.
•Database backup: Daily exp. backup of full database data export/import;
Server version: 8i and 9i o/s platform: Solaris 5.0
Tools: export and import of oracle
•Monitoring system performance using diagnostic Unix shell scripts
•Development and Tuning of stored procedures and triggers.
Server version: 9i o/s platform: Solaris 5.0
•Imparted training on oracle 11g dba to the team members.
#2 ISIP (Information Security Improvement Programme)
Period : September 2005 to June 2007
Client : Shell, Netherlands
Team Size : 51
Technology : Oracle 10G, Oracle 9i, .Net Technologies, Java, j2ee.
Description :
ISIP is information Security Improvement program. All data within shell group required to be classified. After classification, the level of security should be applied to the data. ISIP implements Data Security Controls across Shell Group IT infrastructures. Data Security is connected with Applications. ISIP program implements various specifications (i.e. 024,030) which are SOX compliant.
Role & Responsibility: -
DBA lead
Database backup: Daily exp. Backup of full database data export/import;
• Oracle Database Architecture
Server version: 10g, 8i and 9i
o/s Platform: Solaris 5.0, Solaris 2.8, windows NT, DOS
•Memory configuration of oracle database
Server version: 8i and 9i
o/s platform: Solaris 5.0, sco Unix, windows NT.
•Monitoring system performance using diagnostic Unix shell scripts
•Development and Tuning of stored procedures and triggers.
Server version: 9i
o/s platform: Solaris 5.0
#3 BMO (Bank of Montreal)
Period : August 2005 to September 2005
Client : BMO, Canada
Team Size : 7
Technology : Oracle 10g, Oracle 9i, . Forms builder, oracle 6i forms builder,
Oracle10g Application Server, Oracle Developer Suite 10g,
Description :
RIS front end was migrated to Oracle 10g, the supporting application server being Oracle 10g. The retail information system maintains all the financial functionalities of the bank of Montreal. The application was upgraded from 6i to 10g.
Role :
•Worked extensively with database performance tuning the buffer cache, shared pool, sort area, temp tablespace usage and rollback segment contention. Used
•DBMS_STATS, UTLBSTAT/UTLESTAT and general data dictionary queries for the above purpose.
•Scripting RMAN backup for 9 databases. Scripting export backup of large tables
•and partitions with run time zip and splitting into smaller files.
•Installed ORACLE software on Linux Platform.
#4 SPT (Supply Planning Tool)
Period : April 2005 to August 2005
Client : Ericsson, Switzerland
Team Size : 10
Technology : Oracle 8i, Forms 6i, Reports 6i, Oracle Discoverer, SUN SOLARIS 5.8
Description :
SPT (Supply Planning Tool) is an application to support the common forecasting and supply planning processes within Ericsson. There are between 1000 to 2000 users of this system in more than 100 companies. Besides, there are almost 200 external users, mainly suppliers. All users do not have the same authority to the system. Hence, there are different roles within the system. Some users can use only the web interface, some only the client server interface or only the discoverer reports. This application is used by sellers and different market units for making forecasts for customers. It is also used by the planning team to make plans for suppliers.
Role & Responsibility:
•Worked extensively with database tuning. Tuned the buffer cache and memory cache.
•Used the package statspack for tuning.
•Scripted RMAN scripts for the database.
#5 AT&T Applications
Period : November 2004 to April 2005
Client : AT&T, USA
Team Size : 15
Technology : Oracle 9i, Oracle 8i, SUN SOLARIS 5.8, UNIX Server, Versant
Database
Description :
AT & T consists of many applications. Applications are MNTS, TAM, Appi, Otusm, Data Services, NRIS,. The system maintains and tracks all the ISDN calls handled by the AT & T. The application covers all the aspects of the system.
Role :
•I was delegating my responsibilities as TEAM LEADER.
•I was involved in monitoring the back end scripts for maintaining the system.
•I was leading and mentoring the team members.
•I was also delegating my responsibilities as oracle DBA.
•Scripted RMAN scripts for the database.
•Used the package dbms_stats for tuning.
•Performed DBA activities such as user creation, privilege granting, access security and backup.
•Performed database backup using export and import tools.
#6 RADAR
Period : April 2004 to October 2004
Client : UBS Bank, London
Team Size : 15
Technology : Oracle 9i, Oracle 9i Application Server, Sun Solaris 5.8, UNIX server
Description :
Radar is an application product development developed for the client. The client can dial the application and the application will email the client details about the equities. The application primarily deals with the research of the equities and informs the client details about the equities. It has portlet pages developed using oracle 9i application server and Oracle 9i database as back end.
Role :
•I was working at onsite, London and delegated the responsibilities as database specialist.
•I was instrumental in performance tuning of the system and troubleshooting of the database.
•I was involved in team meeting of the project and suggested some innovative changes.
•Performed database tuning using statspack and explain plan.
•Performed application tuning using hints.
•Scripted RMAN scripts for the database.
#7 American Online System for Experian Inc, NY (USA)
Period : April 2003 to March 2004
Client : Experian Information Solutions INC., New York, USA on
Behalf of Cognizant Technology Solutions Limited.
Team Size : 16
Technology : Oracle 9i, Sun Solaris 5.8, Unix Server
Description :
American Online (AOL) system project is developed to consolidate separate databases into a single database which will be used to extract records for campaign management. It will implement indirect marketing channels. Business requirements of the system include the extraction of prospect customers who will be entitled for the free CD. Entitlement for the free internet AOL hours will be decided after the application of various suppression logic and criteria to the system. The system receives the feeds from a mainframe system located at Rye, New York and the feed is then passed through a client-server system to filter out the final records and populate the respective tables.
The system consists of following modules.
•Individual load module
•Address Load module
•Household Load module
•Business Load module
•Business Association Load module
•DataPrep module
Role :
•I have tuned the database (oracle 9i) of product by configuring parameter files of the database as an Oracle DBA.
•I have been assigned role to look after the system performance issue of the software.
•Prepared the Program Specifications of the modules and also reviewed the PS of the team members.
•Mentored the junior project team members designated as Programmer Analyst and Programmer Trainee.
•Reviewed the detailed technical design document compiled by senior team members.
•Created the client database production server database instance.
•As a DBA, I have taken the backup of the database using RMAN. The database size was 5TB.
•As Oracle DBA, I was also assigned the recovery of the client database in case of disaster.
•I have proposed the system architecture to the client.
•I am involved in tuning of the database using STATSPACK package of ORACLE.
•I am involved in PL/SQL code tuning of the system using ORACLE’s built-in-package DBMS_PROFILER.
•I have also tuned the code using TKPROF and EXPLAIN PLAN.
•I have also recommended indexes needed for this DSS system.
•I have also performed code reviews and technical architecture review for the above project.
•I have also led the team consisting of programmer, programmer analyst.
#8 POS 2000 SYSTEM
Period : December 2002 to April 2003
Client : First Data Merchant Services (U.S.A.) on behalf of Cognizant
Technology Solutions
Team Size : 16
Technology : Oracle 8.1.7, RS 6000, AIX 4.3, JAVA 2
Description :
POS 2000 system is used by FDMS to maintain all information about Vendor, Equipment and Merchants. It involves the use of some specialized programmable devices and their associated software’s to track sales and inventory. The system is a combination of a standard PC and custom written software designed especially for retail businesses, Vendor’s information, equipments and billing.
It contains five modules. They are:-
•Merchants module
•Equipment module
•Request module
•History module
•Entitlements module
Role:
•Performed database backup using export and import tool.
•Scripted RMAN scripts for the database.
•Performed database tuning using STATSPACK and dbms_stats package.
•Performed DBA activities as user creation, tablespace creation and granting of privileges.
#9 Datagym Software (Product)
Period : July 2001 to December 2002
Client : American Express Bank (U.S.A.) for Computer
Associates International INC.
Team Size : 6
Technology : Java 2, VB 6.0, Oracle 8i, 733 MHz Processor Pentium Pc, Windows
NT 4.0, Solaris 7.0
Description :
Datagym is a middleware and e-business infrastructure software tool. It is designed to automate database marketing option of any type of business. It can also implement CRM and e-PRM of any business relation within 90 days. It is particularly useful for financial applications.
It contains six modules. They are:-
•Consolidation module
•Household module
•Extraction module
•Rationalization module
•Instant Match module
•Sample-IT module
Role:
•I have tuned the database(oracle 8i) of product by configuring parameter files of the database as a Oracle DBA.
•I have been assigned role to look after the system performance issue of the software.
•I have written the packages and stored procedures of Rationalization module.
•I have been assigned to enable parallel query feature in the database.
•I have written the Unix (Solaris) shell scripting for the database.
#10 Online Shopping Cart
Period : December 1999 to March 2001
Client : Computer Associates, USA
Team Size : 6
Technology : Oracle 8.0, SQL*PLUS, Java 2, Jakarta Tomcat Server, Windows NT,
Rational Rose
Description :
Online Shopping Cart is the electronic shopping cart to be deployed on the web. The shopping cart keeps a list of continuous list of what the user want to buy and how much it costs while shopping over the web. The virtual shopping cart keeps track of items selected by the user.
Role:
•I was responsible on behalf of ca-tcg software pvt. Ltd. for development of shopping cart application to provide 100% code generation of application using java2 and jdbc to assist in coding.
•I was involved in the design and analysis of shopping cart application using Rational rose 2000.
•I was involved in database design of tables to be used for shopping cart application using oracle 8i.
•I was involved in tuning of the database and sizing of the database.
•I developed the shopping cart applet and the shopping cart containers used in the application.
#11 Emerging Local Corporate (ELC) Credit
Period : August 1999 to November 1999
Client : Citibank London On Behalf Of I-Flex Solutions Ltd
Team Size : 16
Technology : ORACLE 8.0, SQL*PLUS, VB 6.0, Windows NT
Description :
ELC CS is a system catering to LOCAL corporate. The system provides credit worth more than 50 billion dollars to corporate. It maps the local currency of the relevant country to international currency. The system automates the whole loan processing system of Citibank London for the corporate. The system consists of the following modules.
•Infrastructure module.
•Planning module.
•Approval module.
Role: I was involved on behalf of Citicorp Information Technology Industries Ltd. (now I-FLEX SOLUTIONS LTD.) in the emerging local corporate credit software system as developer and database assistant.
I was also involved in:
•Development of Stored Procedures for the back end of the Planning module.
•Database design and tuning of SQL statements
•Creation and definition of tables which are used in the credit software system.
•Coding of Stored procedures used in all the modules.
#12 Account General Voucher Level Computerization systems (AGVLC).
Period : February 1999 to July 1999
Client : Account General of Punjab, Haryana & Himachal Pradesh.
Team Size : 16
Technology : ORACLE 8.0, SQL*PLUS, Designer/2000 v1.3, Developer/2000
(Forms 4.5 & Reports2.5), PL/SQL, Windows NT
Description :
AGVLC is a system catering to computerise the voucher level of transaction. The transaction feature includes a detailed report of estimated expenses incurred on various Governmental heads and the actual expenses incurred. The system also automates the financial accounting procedures. It contains following modules.
•Account current module.
•DC module.
•Public Works module.
•Book keeping module.
•Budget module.
Role: The entire project resided on Designer/2000 repositories and was developed using Developer/ 2000 and Oracle8.0, SQL *Plus 8.0, PL/SQL 2.0. I was involved on behalf of NIIT Ltd. In:
•Development of stored procedures for the back end of Public works module and Budget module.
•Assisted in design of database and creation of tables.
•Development of 20 forms for the front end of Account current module using Developer2000.
#13 A fully integrated financial accounting system, named integrated financial management system.
Period : September 1998 to November 1998
Client : Shrachi Security Ltd.
Team Size : 7
Technology : ORACLE 7.3, SQL*PLUS, SQL*FORMS 4.5, WINDOWS NT 4.0
Description :
IFMS is a system catering to the different functionality of NBFC's or non banking financial companies like Shraci Security Ltd. It involves the following three different modules.
•Financial Accounting
•Fixed Deposit
•Lease-Hire Purchase
Role:
I created the database and its elements including tables, indexes, stored procedures and
Triggers During the project on behalf of Techna Digital Services Ltd, I
•Developed few reports for Hire purchase, Fixed Deposit and Financial Accounting modules using Reports 2.5.
•Involved in the analysis and detailed design phase of Fixed Deposit module.
•Solely contributed to performance tuning of the system using TKPROF and EXPLAIN PLAN feature of ORACLE.
Foreign Language Known: FRENCH
Contact this candidate