SUMMARY

• 8 years of experience with the 32bit, 64-bit Microsoft SQL SERVER as Developer in OLTP and OLAP with Production, Development and Testing in Clustered and Stand alone Server Environment.
• 5 years of experience in ETL process - SQL Server Integration Services (SSIS) and DTS
• 3 years of experience in Data warehousing Project with Microsoft Business Intelligence (MSBI) SQL Server Analysis Services (SSAS) creating CUBES with Fact and Dimension Tables and Multi Dimensional EXpressions (MDX) queries.
• 3 years of experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Extensively Worked on BI and ETL in the SQL SERVER.
• Automated manual process with SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Used all the major Control flow tasks in SSIS like ...Containers ( Forloop / Foreach / Sequential ) , File system task, Data flow task , Bulk Insert , FTP task , SMTP task, Exec SQL task , Exec Process Task, Exec package task etc...
• Extensively worked on SSIS for transferring data from Heterogeneous Database ( OLE DB , Excel , Flat file , Data reader for Teradata Tables ) to create Data Marts
• Used all the major Data Flow Transformations ( Aggregate , character map , condition split, data conversion , derived column, Data Conversion, Lookup, Fuzzy lookup, Merge, Merge Join, Multicast, OLEDB command, Slowly changing Dimension, Sort, Union All, Row count)
• Scripted VB.net in the script task for data conversions in SSIS packages.
• Experience installing MS SQL SERVER 2000 and 2005; updating with hot fix and service packs.
• Extensively worked on Active-Active and Active-Passive Clustering environment.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using the DMVs, DMFs, SP_PROCS, INFORMATION_SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, Temp tables and Dynamic SQL queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
• Excellent expertise in automated incremental processing of SSAS OLAP cubes
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Expertise on administration, change management processes, performance analysis, production Support for large database.
• Extensively worked on Full and differential Backups; Security Management, Managing server and client Connections
• Configured SMTP Server for Database Mail setup and received Alerts.
• Extensively used Repositories like Visual source safe.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Auditing of database for users transaction, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• Actively involved in management of Change Control Requests.
• Excellent Team Player. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS

Operating System : Windows , Unix
Database : Microsoft SQL Server 2005, Teradata
Front end : Active-Insight
Office Tools : MS-Word, MS-Excel, MS-Powerpoint, MS-Visio,
Outlook, Lotus Notes.
SQL Server tools : Management Studio, Query Analyser, Profiler
MSBI ( ETL ) : SQL Server Integration Services - SSIS,
SQL Server Analysis Services - SSAS,
SQL Server Reporting Services - SSRS
Concepts : Object Oriented Programming (OOPS)
DataBase Management System (DBMS)
ETL (Teradata) : Fast export, BTEQ and Multiload

EDUCATION

• Master of Computer Applications
• Bachelors in Mathematics

PROFESSIONAL EXPERIENCE

aEDW (active Enterprise Data Warehousing ) Feb 2008 - Till date
Confidential - Tampa, FL.
SQL Server Database Admin / BI Developer / ETL Developer

Confidential is Leading Telecom Company and we were working on Data warehousing reports for Business team. The source tables are in Teradata (RDBMS). We process the data using BTEQ and creating Fact and Dimension tables which are migrated either by using Data flow task or using Fexp (Fast Export- Teradata Utility) to SQL server databases. In SQL Server we have stored procedures to further cleanse the table. All the above steps are automated using SSIS (SQL Server Integration Services). Then using SSAS (SQL Server Analysis Services) we create Cubes (multidimensional data viewing). These Cubes are connected to Portal which can be accessed by the client. Apart from this we create Ad-hoc reports using T-SQL and export the results to Excel and SSRS

Responsibilities:

• Managed and Administrated SQL Server 2005/2000 production and Non-production (Data warehousing ) servers..
• Automated many manual ETL process using SSIS and Supported with existing complex Production SSIS Packages.
• Used all the major Control flow tasks in SSIS like ...Containers ( foreach / sequential ) , File system task, Data flow task , Bulk Insert , FTP task , SMTP task, Exec SQL task , Exec Process Task, Exec package task etc...
• Extensively worked on SSIS for transferring data from Heterogeneous Database ( OLE DB , Excel , Flat file , Data reader for Teradata Tables ) to create Data Marts
• Used all the major Data Flow Transformations ( Aggregate , character map , condition split, data conversion , derived column, Data Conversion, Lookup, Fuzzy lookup, Merge, Merge Join, Multicast, OLEDB command, Slowly changing Dimension, Sort, Union All, Row count.
• Created logical and physical data modeling using ERWIN and MSVISIO for Normalizing flat file / Table to Dimension model ( Star and snow flake schema )
• Created Molap cubes using SSAS using Dimension Hierarchy and Fact tables with monthly Partition.
• Used MDX Query in BIDS against fact and Dimension tables.
• Created BTEQs and SQL Script to create FACT and Dimension Tables.
• Created regular and ad-hoc reports using SSRS as per clients requirement (Verizon Business)
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created SSRS reports with dataset parameters, expressions in Properties, drill down reports.
• Created regular and ad-hoc reports using SSRS as per clients requirement (Verizon Business)
• Created maintenance plans for monthly back-up, shrinking database , truncating log and refreshing indexes.
• Created of Fastload, OLEload and Mload scripts ( Teradata Utilities ) for loading data according to the requirements for Ad-hoc tasks.
• Documenting the Projects and flow chats with VISIO and MS-Word.

Environment: SQL Server 2005 and 2008, T-SQL, Access, Windows 2003 and 2008 Servers, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and Teradata ( BTEQ , Mload, Fexp and OLEload )

SPRF (Specialized Processing Request Form) Aug 2005 - Dec 2007
Confidential - Basking Ridge, NJ
SQL Server DBA / ELT Developer

SPRF project is one of the streams of CPR2 (Claims Process Reengineering and Re-architecture) in TOPS (The Online Processing System) Application. SPRF team gets requirements for Enhancements and we analyze the requirements and enhance the existing process based on the requirement. It is a multi-platform system and our team worked for the SQL Server RDBMS and ETL process between other systems and SQL Server.

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 databases.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and stand alone environment
• Configured Transactional replication on migrated server.
• Created packages to automate ETL process using SSIS.
• Extensively worked on Dynamic Management Views (DMV's) and Dynamic Management Functions (DMF's).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Plan for rebuilding Index , Shrinking, truncate log and Back up Databases of SQL Server 2005.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shippingfor synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Environment: T-SQL, MS SQL SERVER 2000/2005, Management Studio, Profiler, Visual Studio 2005, BIDS, Windows Server 2003, SSIS.

Field Expansion Dec 2003 - July 2005
Confidential
SQL Developer/DBA

The Field Expansion stream of work is a multi-phase project to standardize some of the currency and non-currency variables within TOPS in support of already approved initiatives to expand fields such as Deductible, Unit, Remark Code (RC), Line Charge, Total Charge, Co-pay, Out of pocket and Coinsurance. This is being done to meet the current business needs. The various phases of the Field Expansion project are: 1. Identifying the impacted programs, files and copybooks 2. Modify/Upgrade the working storage variables of the impacted programs as well as the Internal Files. 3. Modify the Upstream Files and Foundation Views. 4. Modify the Downstream Files and Screen Variables. 5. Execute and write One-shot programs to modify the file to a new acceptable layout. All the script and stored procedures were modified to implement the enhancement.

Responsibilities:

• Database Administrator, Database Programming.
• Administered SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilt indexes at regular intervals for better performance
• Involved in trouble shooting and fine-tuning of databases for better performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered databases from backup in disasters
• Maintained database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Administered SQL Server configuration settings.
• Excellent experience in data modeling and metadata services.
• 24 X 7 Production Database on Call Support.
• Monitored SQL server performance using profiler to find performance and dead locks.
• Responsible for Maximum performance and uptime in production environment.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Handled up to half TB Size databases with clustered and replication environment
• Administered SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Implemented database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• Performed installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• Designed & developed data models and performed forward and reverse engineering using data modeling tools like ERWIN.

Environment: Windows 2003, MS SQL Server 2000, MS Access, Erwin, Enterprise manager, Query Analyzer, SQL profiler.

PRIME Application July 2003 - Nov 2003
Client: Confidential
SQL Developer

This project is a maintenance and Enhancement project for the UNIPRISE small group health insurance. PRIME is a complex system, which takes care of small group applications. PRIME Renewal is a sub system of PRIME, which involves procedure that renews the policies in the PRIME system. Inputs are gathered from various sources including SQL Server 2000.

Responsibilities:

• Installed and configured MS SQL Server and Clients.
• Involved in Database design, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity
• Performed Data migration (import & export BCP) from Text to SQL Server. Data transfer using BCP and DTS
• Managed Disk space, memory and User connections
• Generated Script files of the databases whenever changes were made to stored procedures or views.
• Excellent knowledge in Import / Export using DTS and BCP utility.
• Performed query tuning and reduced response time by 60%
• Discussions with Product team for new features
• Performed query plans and enforced indexing in each and every query
• Propped up the new schema changes and additional new features on Development, Staging/QA and Production servers
• Designed DTS packages to refresh data on Development and QA/Staging
• Wrote dynamic stored procedures to create Database Roles and grant permission to roles and adding logins to specified roles
• Designed new schema for data partition and creating Partition views for better performance.
• Programmed in T-SQL to implement Stored Procedures and Functions for different tasks
• Implemented Performance Tuning, Analysis, tuning and optimization of SQL Server Applications using performance monitor. Assisted the SQL Developers in query tuning and optimization.
• Created updatable partitioned views
• Created Stored Procedures and triggers to perform automated rules and updation of related tables

Environment: MS SQL server 2000, Windows 2000, Enterprise manager, Query Analyzer, SQL profiler.