Prakash
9140 00919849350964
26D RBI Colony Shalimar Bagh New Delhi 110052
Current Location: Hyderabad
Title: / sql server dbaWork Experience: / 5 years
Skills: / sql server dba
Current Organization: / satyam computer service ltd
Previous Organization(s): / ITIL
Industry: / IT/ Computers Software
Highest Degree Held: / MCA/PGDCA (Computers) ,IGNOU
Gender: / Male
Date of Birth: / 7th Feburary 1978
Current Annual Salary (Rs. in Lacs): / 6
Detailed Resume:
Prakash S Narayanan
CAREER SUMMARY
More than 5 yrs. of IT experience. I have worked mostly in RDBMS - SQL
Server environment (MS SQL Server 6.5, 7.0 & 2000) and with various
Microsoft BackOffice products and also working in various Developing Tools
like Visio, Rational Rose and Various OLAP Tools
I am fairly experienced with SQL Server DBA related activities, maintaining
and troubleshooting SQL Server related problems and in optimization of SQL
code.
I am currently a part of technical support team in a software development
environment with a fairly large user base in a LAN/WAN setup, and involved,
primarily in maintaining and administering database servers.
All in all, my primary skills developed over the years have been SQL (T-
SQL), Database administration but well versed with data centre management
related activities.
Excellent analytical & communication skills.
EDUCATION
Indira Gandhi National Open University - New Delhi, India
Post Graduate Diploma in Computer Application
University Of Delhi - New Delhi, India
Bachelor of Science, 1998
Certifications
Microsoft Certified Professional in:
Implementing and Designing Database Using MS-SQL Server 2000.
Administering Database Using MS-SQL Server 2000.
Installing, administering and configuring Microsoft Windows 2000.
Implementing and Administering a Microsoft Windows 2000 Network
Infrastructure
Implementing and Designing Database Using MS-SQL Server 7.0.
Administering Database Using MS-SQL Server 7.0.
MSE 2.0 (Microsoft Service Enterprise)
SKILL SUMMARY
Languages: XML, HTML, T-SQL
RDBMS: MS_ SQL Server 6.5/ 7.0/ 2000, Sybase 10.x
Web Server: IIS 5.0
Operating System: Windows 95, 98, NT 4.0, 2000 Server, XP
Modelling Tool: Visio, and ERWIN 4.1
Warehousing Tool: OLAP (Analytical Server)
Reporting Tool: Crystal Report 9.0, Cognos
ETL Tools: Informatica 5.0 & 6.0
Other Tool: Data Script, SQLZIP, and ADO Explorer, SQLLiteSpeed
EXPERIENCE
Satyam Computers Services Ltd.
Emeapremier : Microsoft India (R& D) Ltd
Microsoft India (R& D) Ltd: Microsoft has an off-shore development and R &
D centre in Hyderabad, India.
About Project: Emeapremier ( is an internal site of MS.
It generally deals with MS employee dealing with end customer for any of
the software. The MS employee called as TAM (Technical Account Manager)
enters the data in the Clarify database and further put in the PRW server,
which is generally a deal with reporting purpose.Emeapremier, gets the data
from the PRW server through the job running in the server. These jobs are
scheduled to be run in the night time.Emeapremier is generally for the
total amount of time spent by a TAM on a single service request.
Team Size: 2
My Role: I was responsible in Estimating the size of the Database. Database
by creating test databases, working with database options, alerting and
expanding databases. Setting up and managing users for SQL Server by
developing a security strategy. Managing security for new and existing
users. Setup and manage Tasks, Alerts, and Operators. Monitoring the server
Using Tools like SiteScope.Setting a mail option on failure and success of
the jobs. Running the DBCC command through the Job for checking the
consistency. Configuring log shipping process between the servers. Using
SQL Lite speed for backup and recovery process. Working on the linked
servers. Designing and implementing Cubes, Dimensions, Virtual Dimensions
etc.Writing MDX Queries using MDX Sample Application. Optimizing linked
server queries. Fixing Hot fixes in the production server.
Information Technologies Ltd., Delhi, India
Port Cargo Automation, Patrick Freight Systems
Patrick Freight Systems: Patrick Port Services is a Logistics company
providing specialized services including cold storage, warehousing and
transport with a focus on providing supply chain solutions that reduce
total supply chain costs for its customers. They are involved in the
overall Freight maintenance and Depot management. Patrick Port Service has
Depots at Sydney, Adelaide, and Melbourne and uses Park Master/Unpack
application for their day-to-day operations. The scope of this project is
to develop the software to handle Freight movements
About Project: Patrick Port Cargo Automation is a web-based Application
System for handling the Container movement/Operations like inward and
outward movement of containers from the park and also for repairing &
maintenance of the containers. System accounts for storing the invoice data
posted for accounts payable or General Ledger. The entire application is
built in to the .Net Platform using Web Services, COM+ and XML based
profiling system for its security system and data interchange.
Team Size: 10
My Role: I was Responsible for the installation and configuration of SQL
Server 2000 on Windows 2000 platform in the lab environment. Performed
database administrative functions such as Installing SQL Server Client
Edition on different nodes and managing the Server (SQL Server Enterprise
Edition). Estimate the size of the Database. Manage the databases by
creating test databases, working with database options, altering and
expanding databases. Set up and manage users for SQL Server by developing a
security strategy. Manage security for new and existing users. Set up and
manage Tasks, Alerts, and Operators. Porting Data from Various Source like
.txt, .xml & .xls files. Tune the SQL Server for the optimal performance.
Time Share Management, Country Inn
About Country Inn: Country Inn has multiple resorts through out India. They
offer various Packages to attract the customers.
About Project: The concept of Timeshare is to offer good quality resort
accommodation to members for a period of time at an economic price. This
reduces the holidaying expenses of members. This System Contained Admin
Module, Security Module, Customer care Department Module and Accounts
Department Module.
Team Size: 7
My Role: I was Responsible for the installation and configuration of SQL
Server 2000 on Windows 2000 platform in the lab environment, Perform
database administrative functions such as Installing SQL Server Client
Edition on different nodes. Manage the databases by creating test
databases, working with database options, altering and expanding databases.
Set up and manage users for SQL Server by developing a security strategy.
Manage security for new and existing users. Setup and manage Tasks, Alerts,
and Operators. Manage the replication environment. Tune the SQL Server for
the optimal performance.
Pay hound
About Payhound: Payhound is a subsidiary of check line bank (UK). Payhound
is an online money exchange and buying system. This is a B2B as well as B2C
system. If the end user wants to open an account, they can do it online &
can deposit/Withdraw money using Credit Card or Bank Account into the
payhound account. Credit Card verification is done through WIN EFT NT
(Which is a third party tool). Bank Account verification is done by BACSTEL
(Which is a third party tool). These two tools are basically act as a
payment gateway. Users can close their account online. This system
provides users online shopping & payments can be made using their payhound
account instead of a credit card or bank account making this system a Pre
paid e-Commerce system.
About Project: The project mainly deals with the money transaction on an
online shopping site.
Team Size: 5
My Role: I was Responsible for the installation and configuration of SQL
Server 2000 on Windows NT 4.0 platform in the production environment,
Perform database administrative functions such as Backing up the databases
to a backup device. Restoring the databases from the backups. Manage the
databases by creating test databases, working with database options,
altering and expanding databases. Set up and manage users for SQL Server by
developing a security strategy. Manage security for new and existing users.
Setup and manage Tasks, Alerts, and Operators. Manage the replication
environment. Tune the SQL Server for the optimal performance. Troubleshoot
SQL Server problems. Developing and designing the Warehousing concept for
the Database Using Olap Tool.
Refer:
SAS, Chennai, India
FHL Gelaac, GE Capital International Services
About GE: GE Capital International Services (GECIS) one among the best,
mainly deals in the Insurance sector.
About Project FHL Gelaac: EOD i.e. End Of the Day, project was implemented
to transfer text files & reports to the client at USA. Every day we get
some images from the mainframe server at USA & Australia. These are scanned
images of client's forms or applications. Data entry operators process the
data and store them in the database server. These application records the
number of image files received, number of image files processed, and number
of bad images. At the end of the day it puts the information on to a text
file and transfers the file to USA using FTP.
Team Size: 15
My Role: I was involved in the data migration process from the text file to
the Database server. Replication was performed along with the Regular
backup of the server, which was the key task in this project. Managing the
security task and User configuration to the various levels of Users.
Handling windows based Schedulers.
M.V. Chandramouleeswaran, Chennai, India
Project: CITIBANK N.A (Certified Public Accountant)
About Citibank CPA: The CPA division is associated with the Citibank Out
Source Department, which acts like a Client to the Bank. The prime job of
the CPA is to handle the various cash cheques and ensures that it has been
put into the Database Server for further processing.
About Project: Generally deals with cheque transactions from the clients,
which is updated in the database. Cheque details are stored in the
database. Cheques are checked for discrepancies, which results in the
rejection of the cheque & rejection details are stored in the detail table.
Team Size: 7
My Role:
I was responsible for migrating the Database from a Microsoft Excel to SQL
Server 6.5 and towards upgrading the software to SQL Sever 7.0.Backing up
the databases to a backup device. Restoring the databases from the backups.
Manage the databases by creating test databases, working with database
options, altering and expanding databases. Set up and manage users for SQL
Server by developing a security strategy. Manage security for new and
existing users. Setup and manage Tasks, Alerts, and Operators.
PERSONAL INFORMATION
Date of Birth: February 7, 1978
Sex: Male
Nationality: Indian
Marital Status: Single
Address: 26- D, RBI Colony, Shalimar Bagh, New Delhi -110088, INDIA
Email:
Languages Known: English, Hindi
REFERENCES
Available on request
Resume of Prakash Page 1