SUMMARY:

• Over 8 years of experience in Database Development, Design and Administration of MS SQL Server 2008/2005/2000/7.0
• Extensive knowledge of Relational Database Management Systems especially SQL Server
• Strong experience in installation, administration and maintenance of databases on SQL Server 2008/2005/2000/7.0 in standalone as well as MS clustered environments
• Expertise in T - SQL development, developing Stored Procedures, Views, and Complex Queries to facilitate efficient data manipulation and data consistency with all version of MS- SQL Server
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts and execution of test plans for loading the data successfully into the targets
• Proficient in T-SQL, DTS packages, troubleshoot and performance tuning of databases
• Proficient in performing DBA tasks including installing and configuring SQL servers and database backups and recovery of server failures and disaster recovery of databases
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, creating and scheduling jobs, alert and operators with SQL Server Agent and SQL Profiler
• Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks using Index Tuning Wizard, troubleshooting deadlocks
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring. Supported large databases for OLTP/OLAP systems
• Performed database health checks using SQL profiler, SQL performance monitor and performance counters
• Experience in Developing, transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS. Migrated Data to SQL Server 2005/2008 by using SQL SSIS
• Experience in installing, administering SQL Reporting Services and SQL Analysis Services. Experience in developing reports by using SQL SSRS and maintaining OLAP cubes using SSAS and data warehouse systems
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS:

Database: RDBMS, SQL Server 2000/2005/2008, MS Access

Languages: C language, T-SQL

Data warehouse Tools: SSIS, SSAS

Operating Systems: Windows NT/98/2000, DOS, Windows Server 2003, Windows Server 2005

Web Technologies: HTML, ISS, and XML, XSLT, Dream weaver

Packages / Applications: MS Office, Visual Source safe, SQL Log Explorer, Visual Studio.NET2005, MS Visio, Remedy, Reports Designer, XML Spy, Microsoft Project 2000, Red-gate SQL Bundle, Ultra edit

PROFESSIONAL EXPERIENCE:

Confidential, NY

BI Developer/SQL Developer

Responsibilities:

• Responsible for maintain and enhance the existing data warehouse, exports and reports and troubleshooting & problem solving of Production database
• Implemented and released of database changes according to agreed timescales and costs
• Wrote Complex Stored Procedures, advance T-SQL codes, Views, functions, triggers
• Designed the tables with indexes, primary key and foreign key constraint
• Created maintenance plan for consistency check (DBCC) and maintained Index statistics of Database Application
• Developed SSIS Packages dat loads data files, extracted from SAP and Oracle DB, into SQL database with necessary transformation
• Responsible for the maintenance, enhancements and troubleshooting of SSIS using Business Intelligent development studio
• Designed DTS packages for the ETL process of data using SQL 2000 Enterprise Manager and apply various data transformations to meet business requirement
• Support the operations of existing Applications / Stored Procedures
• Define, develop, maintain and execute test Scripts on time and solve issues and risk as appropriate to keep project running on time
• Responsible for Functionality Testing and bug fixes /issue resolution during the various quality assurance testing cycles
• Working very closely with SAP and Cognos team to meet the critical Reporting requirements of Business & end-users
• Manage day-to-day project activities and coordinate tasks with other teams
• Prepared necessary Documentation for new Developments and Approvals for promote-to-production
• Responsible for ensuring availability and performance of the databases dat support the BI-Cognos Reporting system along with daily backup and failover restore of database
• Handling installation and creation of new instances of SQL server databases
• Managing user creations, assigning roles to SQL databases and Security
• Monitoring the scheduled Jobs on different production servers

Environment: SQL Server 2008 R2, SQL Server 2005, SQL Server 2000, DTS, SSIS, Cognos 8, Excel, T-SQL, SAPWindows Server 2003/2008

Confidential, NJ

SQL Developer/Business Intelligence Developer

Responsibilities:

• Installed and maintained multiple SQL server 2008 instances in non-production (test, staging) environments
• Designed the database and table structure and data partitioning and indexes for optimum query performance
• Created several tables, views using SQL Server management studio, based upon the functional specifications
• Hands on experience in developing stored procedures for complex queries for better performance, views for controlled access to data and triggers for data access audit purposes
• Strong working knowledge of SQL Server Integration Services, developed several SSIS packages to load data from excel sources
• Cleaned dirty data of excel sources using Fuzzy lookup and Fuzzy group transformation and load back to SQL server 2008
• Performed daily tasks including backup and restore by using SQL Server Management Studio
• Setup profiler traces to support trouble shooting activities in QA environments
• Created report for policy holders by using SQL server Reporting service (SSRS)

Environment: SQL Server 2008, Windows 2003, SSIS, SSRS, Excel, T-SQL

Confidential, NJ

Business Intelligence/SQL Developer

Responsibilities:

• Involved in migration of database from MS SQL Server 2005 to SQL Server 2008
• Evaluated data storage considerations to store databases and transaction logs, Optimized the physical disk performance through RAID-1, RAID-5 levels for fault tolerant database partitions
• Involved in Data Modeling, creation of logical physical data models
• Worked closely with business users in source data analysis, designing and mappings for data extraction also responsible for design and development of SSIS packages to load the data from various databases and files and transferred data (ETL) to data warehouse environment using SSIS
• Worked in the development of complex Stored Procedures, Triggers, functions, DTS packages to support multiple business applications. Developed and maintained Stored Procedures using T-SQL.
• Worked extensively in tuning and optimizing the performance of production databases by creating new indexes and re-writing SQL queries to utilize indexes.
• Worked with Snapshot & Transactional Replication between SQL Server databases.
• Participated in Test Plan, test case review meetings and Supported QA activities.
• Stored and maintained database scripts in Clear case.
• Extensive experience in trouble shooting of client connections, viewing error log and applications
• Maintaining the database consistency with DBCC at regular intervals and by re-indexing table
• Created, designed and deployed drill down reports using MS SQL Server reporting services (SSRS)
• Involved in administration, performance analysis, and production support for large (VLDB) databases up to 1 TB

Environment: SQL Server 2008/2005, Windows 2003, SSIS, SSRS, ASP.NET, MS Access, T-SQL

Confidential, Kansas City, MO

BI/SQL Server Developer

Responsibilities:

• Implemented a database maintenance plans, backup and restore strategy dat protects databases against data loss and for backup and disaster recovery of databases
• Modified database structures as directed by developers for test/develop environments and assisted with writing stored procedures for design and performance tuning of the application.
• Wrote DTS packages to transfer data from various database & different files format to SQL Server. Develop SSIS packages to transform data from Excel/Access file to destination SQL Server database
• Installed and configured SQL Analysis services (SSAS). Implemented and maintained physical database designs for Client Server OLTP applications
• Responsible for installation, configuration, security, maintenance of SSRS on Windows Server 2003
• Created several stored procedures, triggers, and wrote complex T-SQL queries for database development and ad hoc report generation
• Working very closely with other developers for AMC requirements, worked with business analyst and end users to understand the report requirements
• Extensive Data Modeling skills for Logical and physical database design using Erwin tool
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database
• Used DBCC utilities to fix data corruption in application databases
• Used third party tools like Red gate for compressed backups and easy to restore
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future

Environment: MS SQL Server 2005 Enterprise Edition, UML, XML, C#, T-SQL, ODBC, Excel, SSAS, SSIS, SSRS, SQL Profiler, Windows 2003 Server

Confidential, NJ

SQL Server Developer

Responsibilities:

• Prepared documentation to set standards, guidelines and best practices for SQL Server database installation, administration, backup & restore procedures, database security, and SQL database development
• Monitored performance monitor and SQL Profiler to optimize queries and enhance the performance of servers
• Designing, maintenance, updating of application schema structure / data models
• Experienced on database creation, database tuning, and performance planning, backup planning and database administration
• Created DTS packages to pull data from oracle and flat files
• Configured IIS using TCP/IP protocols (Web Server)
• Monitoring the CPU usage, IO statistics, Memory usage to identify any OS level performance killers, enabling database level trace for performance test
• Design new database reports for employees to view daily sales data, finance, customer Care, and management using Reporting Services SSRS
• Extracted data from SQL Server for report and testing purpose by using SSIS
• Creation and execution of TSQL Scripts (Stored Procedures, Triggers and complex queries) in SQL Server 2005
• Used DBCC utilities to fix data corruption in application databases
• Created new database with objects such as tables, views, indexes etc
• Development of business rules implemented as constraints, triggers and or stored procedures
• Scheduling jobs on various stored procedures and packages
• Extensively involved in maintaining & updating the database documentation

Environment: SQL Server 2005, SSIS, SSAS, SSRS, SQL Server Management Studio, Query Analyzer, SQL Profiler, XML, SAP, C#

Confidential

SQL Server DBA/SQL Developer

Responsibilities:

• Installation and configuration of SQL Server 2000 on Window 2000 OS
• High level of expertise in implementing different types of Replication Models such as Transactional, Snapshot and Merge Replication and failover clustering
• Managing of database objects like Tables, Views, Indexes etc
• Maintained login and user management in SQL Server database by managing of users including creation/alteration, grant of system/db roles and permission on various database objects,
• Managing backup and restore export and import
• Worked on high availability SQL Server solutions, including log shipping, mirroring and SQL Server clustering
• Developed DTS packages to transfer the data between SQL Server and other database and files
• Well experienced with tools like Query Analyzer, SQL Enterprise Manager
• Used Data Transformation Services (DTS), an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using the concept of OLE DB
• Creation and management of database maintenance plan for various database consistency checks
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• Automation and execution of data transformation scripts
• Developed T-SQL scripts to enforce business rules and creating reports from OLAP database

Environment: MS SQL Server 2000, Windows 2000, Win NT v4, MS Access, T-SQL, DTS, UNIX