Pradeep Kumar
609-216-3435
N.Pradeep@gmx.com
SUMMARY
7 + years of IT experience out of which three years of extensive experience in
Database Administration, Implementation and Development for use of integration
Application.
2 years of experience in Web Development using C#, VB.NET,
Expert in Database Administration, Management using RDBMS such as SQL Server
under WINDOWS environment.
Strong Knowledge in SQL Server disaster recovery, backup/restore, migration,
and upgrade.
Hands on experience in installing, configuring, managing, monitoring and
troubleshooting SQL Server2005.
Experience in developing and monitoring SSIS, SSRS, and SSAS Packages.
Extensive experience with SQL Server T-SQL in constructing triggers, stored
procedures, user defined functions, views, indexes, relational database models,
data integrity.
Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 using any
suitable approach.
Importing and Exporting Data.
Managing Logins, Users, Roles and User Permissions.
We Provided Database Administrative Support through 24X7.
Using SQL Server Profiler and other tools for trace analysis.
Extensive experience with monitor, tunes, and analyzes db performance and
allocates resources to achieve optimum db performance.
Extensive experience in design techniques, ETL processes, relational database
theory, N-Tier development.
Excellent Report creation skills using Microsoft Reporting Services.
Extensive experience in Crystal Reports, and Crystal Analysis.
Excellent experience in Microsoft Analysis Services.
Excellent communication, presentation and interpersonal skills.
Strong troubleshooting and organizational skills.
Technical Skills:
SQL Server Tools: Enterprise Manager, Profiler, Query Analyser, Export & Import
(DTS)
Databases: MS-SQL Server 6.5/7.0/2000/2005, MS Access 97 & 2000
Reporting Tools: MS SQL Server Reporting Services, Integrating Services, Crystal
Reports, Informatica,
Web Servers: IIS 5 and 6
Languages: MS SQL Server 2005/2000/7.0/6.5, T-SQL, VB.NET,C#,
ASP.NET,XML,PL/SQL, VB Script, JavaScript, Turbo C, C++, Java.
Tools: MS SourceSafe, MS Office 97/2000/XP, MS FrontPage 98/2000, MS Outlook
97/2000
Operating System: Windows 2000 Advanced Server/Server 2003/Professional/ NT 4.0,
Win XP Prof/Standard, Win 98.
Professional Experience:
AlwaysInStyle New York City, NY Dec 07 Present
Database Administrator
Always(In Style)ฎ International, Inc. is a personal style training, customer
profiling, and data warehousing company that provides customized fashion, beauty,
style, and etiquette analysis and advice to both individuals and organizations.
Founded in 1982 by Doris Poser, with the publication of her first book, Always In
Style, the Always(In Style)ฎ profiling software, books, products and training
programs have been rolled out in 25 countries. Always(In Style)ฎs corporate
assets, including but not limited to it's proprietary Personal Profiling
software, reflects over $8 million in investment and 25 years of operational
experience.
Responsibilities:
Production Infrastructure DBA Support-Responsible for administration of almost
a several instances comprising of several databases with size up to 300GB to
500GB.
Upgrade and migrating of SQL Server 2000 to SQL Server 2005. Identifying
inefficient server settings and database options of existing servers/databases
change as necessary.
Administering the MS SQL Server by creating user logins with appropriate
roles, dropping and locking the logins, monitoring the user accounts, creation of
groups, granting the privileges to users and groups.
Proper use of views to prevent unauthorized access.
Using the Database Maintenance Wizard to make some necessary changes and
keeping the performance of the server at acceptable levels.
Ensuring that all the databases are backed up on the regular basis by
monitoring Full, Differential, and Transactional Log backups for OLTP, WAREHOUSE
and Business Object Repositories. Fix backup failures, address and implement
resolutions.
Restoring databases as requested; Recover/Restore as necessary; troubleshoot
databases with data consistency/torn page problems.
Involved in writing T-SQL Statements and Stored Procedures and Triggers.
Tested and Implemented Log Shipping technique for disasters recovery
Successfully Implemented Log Shipping for Production databases and Event Log
database servers.
Running of Performance monitor, SQL Profiler or Query Server to identify
performance problems on servers experiencing bottlenecks.
Generated Few Reports using Microsoft Reporting tool SSRS
Documentation of SQLs Server Standard operations, procedures.
Environment: Windows 2003 Server, MS SQL Server 2005
Merrill Lynch Hopewell, NJ June 07 to Dec 07
Database Administrator\Developer
Merrill Lynch is one of the worlds Leading wealth management, capital markets
and advisory companies, with offices in 40 countries and territories and total
client assets of approximately $1.6 trillion.
Merrill Lynch offers a broad range of services to private clients, small
businesses, and institutions and corporations, organizing its activities into two
interrelated business segments-Global Markets & Investment Banking and Global
Wealth Management, which is comprised of Global Private Client and Global
Investment Management.
Responsibilities:
Installing and configuring and tuning and providing 24X 7 supports for SQL
Server 2000 and 2005 in development and production environment.
Created and scheduled jobs to setup Log shipping between production servers.
Implementing Database Mirroring on SQL Server2005 production databases.
Job Monitoring and making sure all jobs run successfully every night.
Creating databases and Logins with permissions in SQL Server 2005 as per
developers request.
Worked extensively on SQL Server Reporting Services to generate reports.
Upgrade and migrating from SQL Server 2000 to SQL Server 2005. Identifying
inefficient server settings and database options of existing servers/databases
change as necessary.
Daily, Weekly and monthly production data processing, monitoring, and trouble
shooting in an environment of mission-critical operational systems, benchmark
establishment, and capacity planning.
Implemented a well-planned backup and restore strategy that protects database
against data loss.
Managed all database servers in production, staging and development and test
environment.
Generated Few Reports using Microsoft Reporting Tool SSRS.
Wrote and maintained database documentation, including data standards,
procedures,
Definitions for the data dictionary and logical and physical models of the
databases.
Environment: Windows Server 2003, MSSQL Server 2005
Chevron Corporation, Richmond, CA Jan 06 to June 07
Database Administrator
Chevron is one of the world's largest integrated energy companies. Headquartered
in San Ramon, California, we conduct business in more than 100 countries. We are
engaged in every aspect of the oil and natural gas industry, including
exploration and production, manufacturing, marketing and transportation,
chemicals manufacturing and sales, geothermal, and power generation. We're also
investing in renewable and advanced technologies.
Responsibilities:
MS SQL DBA infrastructure support provide and support on remote production and
development servers in US, clustered/non clustered environment DBMS maintenance,
backup and recovery Implement, configure, administer replication and log shipping
Installation/upgrade, patch application, database migration..
Security implementation and user management on SQL Servers Capacity Planning,
manage data storage and data file placements.
Performance monitoring, tuning, implement performance improvements of database
instances/environment.
Created Stored Procedures for the implementing complex business logic Using
T-SQL.
Extensively used joins and sub-queries to simplify complex queries involving
multiple tables.
Implemented well planned backup and restore strategy that protects database
against data loss.
Extensively used joins and sub-queries to simplify complex queries involving
multiple tables.
Running DBCC Consistency checks and fixing data corruption in user database.
Involved in Security Administration creating users and assigning them roles
and privileges.
Involved in generating Reports using Microsoft Reporting services Tool.
Wrote and maintained database documentation, including data standards,
procedures,
Definitions for the data dictionary and logical and physical models of the
databases.
Environment: Windows Server 2003, MS SQL Server 2005
East Collaborative Strategies Edison, New Jersey April 2004 to Oct 2005
Database Administrator/Developer
Systemic Enterprise Connector (SEC)
SEC PLM is a online project life cycle management system with powerful
Enterprise Application Integration processing needs in engineering and
manufacturing enterprise Confronted by various functions/departments having
operations at a tactical level to Strategic policy level.
Configuration control features in all the systems facilitate decision-making
persons or Groups of people across the product development or project hierarchy
for evaluating and approving or disapproving pieces of data/ information in
transactions.
SECPLM is highly scalable and integrated internet/intranet environment with
robust Systems that interplays addressing large data, information and time bound
functions. More specific to product development enterprise.
Responsibilities:
Administration including Planning, Installation, Deployment/Implementation
Advanced Configuration of MS SQL Server.
Implemented well planned backup restore strategy that protects database
against Data loss.
See that there are no technical problems during daily operations.
Responsible for security in the system and network.
Configure and maintain DNS servers as primary and secondary with Active
Directory Integration.
Running DBCC Consistency checks and fixing data corruption in user database.
Successfully implemented Log Shipping, Replication, and Mirroring in
Production DB.
Responsible for trouble shooting of workstations in the departments.
Proper use of views to prevent unauthorized access.
Involved in security administration creating users and assigning them roles
and privileges.
Configuration and Importing Data from Oracle 9i server to MS SQL Server 2000
using linked servers on OLEDB Provider and Data Transformation Services(DTS).
Tested and configured automated routine maintenance tasks like performance
tuning indexes and stored procedures. Checked deadlocks and create scheduled
jobs.
Involved in writing T-SQL Statements and Stored Procedures and Triggers.
Involved in generating Crystal Reports.
Wrote and maintained database documentation, including data standards,
procedures, definitions for the data dictionary and logical and physical models
of databases
Environment: Windows Server 2000, MS SQL Server 2000, Crystal Reports
System Domain Technology, Bangalore April 2003 to April 2004
Application Programmer
Human Resource Management System: This project deals with the automation of the
some of the steps involved in Human Resource Management Process. In this era of
software revolution. Human Resource Management plays a significant role.
This Software is used to meet the requirement of the System Domain in Human
Resource Management Process. The software is an intranet application, which can
be extended to the internet with few modifications. The employees are provided
with a well defined GUI to carry out their operations along with a greater
security and ease.
Responsibilities:
Designed and developed user interfaces using web forms.
Played a key role in the development.
Implemented Stored Procedures for entire project.
Worked on various validation controls using JavaScripts.
Regular interaction with the project manager for requirement gathering.
Made changes in applications according to the suggestions given by manager.
Environment: VB.NET, ASP. NET, SQL Server 2000, ADO.NET, and Windows 2000,
Nizam Institute of Medical Sciences, Hyderabad, India OCT 2002 to
April 2003
Research Programmer
Computer Analysis of EMG Diagnostic Software Application
A Diagnostic software application is developed to process the acquired EMG
signals. The acquired data is used to classify the patients based up on their
Motor Neuron Count.
Responsibilities:
Generated the Data Samples of various patients.
Various Statistical Algorithms were implemented along with SVD, which is a
Clustering Algorithm.
Graphics library in C++ was extensively used to develop the GUI.
Extensively used various Object Oriented Programming Techniques.
Played a Key Role in the development of the software as group lead.
.
|
