SUMMARY

• 10+ years of experience wif teh 32bit, 64 - bit Microsoft SQL SERVER as Developer in OLTP and OLAP wif 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 wif Microsoft Business Intelligence (MSBI) SQL Server Analysis Services (SSAS) creating CUBES wif Fact, Dimensions, calculations and good noledge in creating Partition & aggregation
• 3 years of experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Extensively Worked on BI and ETL in teh SQL SERVER.
• Automated manual process wif SSIS packages for import, export and bulk insert data wif transformations from various data sources.
• Used all teh 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 teh 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 teh script task for data conversions in SSIS packages.
• Experience installing MS SQL SERVER 2000 and 2005; updating wif 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 teh DMVs, DMFs, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for teh 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 teh 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 teh Isolation Level and Concurrency TEMPEffects.
• Extensively used teh 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 teh 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 wif 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 wif extensive noledge of Relational Database Management Systems wif in-depth of T-SQL.
• Actively involved in management of Change Control Requests.
• Excellent Team Player. My objective was to deliver projects wifin scope, time and costs while following department standards, methodologies and guidelines.
• Strong experience in mentoring wif 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 2003/ XP /2008, Uni

Database: Microsoft SQL Server 2000/2005/2008, Teradata

Front end: Active-Insight, Tableau 7

Office Tools: MS-Word, MS-Excel, MS-Powerpoint, MS-Visio, Outlook, Lotus Notes.

SQL Server tools: Management Studio, Query Analyser, Profiler

Data Modeling: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

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

PROFESSIONAL EXPERIENCE

Confidential

Microsoft BI Lead

Responsibilities:

• Requirement Analysis and creating understanding document
• Providing project plan wif phase by phase timelines and resources allocation
• Designing database and ETL frame work and establishing development environment
• Development and team co-ordination wif offshore
• Data modeling wif Visio and implementing table structures (Dim and Fact)
• Creating SSIS packages to populate data in Dim and Fact tables
• Creating and processing OLAP using Analysis Services (SSAS).
• Testing teh package individually - Unit Testing
• Testing teh process end to end - Integration testing
• Handling offshore Team to co-ordinate development activities
• Meeting Clients wif weekly status and provide project plans
• Creating reports for teh end user wif SSRS and Tableau.
• Supporting teh system till teh warranty period
• Fixing issues during UAT and when Production support needs help.
• Coordinating wif all teh people involved in entire cycle of teh project like, requirements team, Production support, Validation team, release management team, DBA, offshore and users

Environment: SQL Server 2005 and 2008, T-SQL, Windows 2003 and 2008 Servers, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Confidential

MSBI Developer

Responsibilities:

• Requirement Analysis and creating understanding document
• Providing project plan wif phase by phase timelines and resources allocation
• Designing database and ETL frame work and establishing development environment
• Development and team co-ordination
• Data modeling wif Visio and implementing table structures (Dim and Fact)
• Creating SSIS packages to populate data in Dim and Fact tables
• Creating and processing OLAP using Analysis Services (SSAS).
• Testing teh package individually - Unit Testing
• Testing teh process end to end - Integration testing
• Handling offshore Team to co-ordinate development activities
• Meeting Clients wif weekly status and provide project plans
• Testing and deployment of ETL packages
• Supporting teh system till teh warranty period
• Fixing issues during UAT and when Production support needs help.

Environment: SQL Server 2005 and 2008, T-SQL, Windows 2003 and 2008 Servers, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Confidential - Tampa, FL

SQL Server Database Admin / ETL Developer

Responsibilities:

• Managed and Administrated SQL Server 2005/2000 production and Non-production (Data warehousing) servers..
• Automated many manual ETL process using SSIS and Supported wif existing complex Production SSIS Packages.
• Used all teh 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 teh 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 wif 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 teh Complete Backing up of Database and Restoring teh 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 wif 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 teh requirements for Ad-hoc tasks.
• Documenting teh Projects and flow chats wif 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 )

Confidential - Basking Ridge, NJ

SQL Server DBA / ELT Developer

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 wif 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 wif 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 teh Complete Backing up of Database and Restoring teh Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for 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 teh Application.
• Extensive testing on teh Performance of teh Stored Procedures.

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

Confidential

SQL Developer/DBA

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 wif 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 teh same to optimize application and system performance.
• Handled up to half TB Size databases wif 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.

Confidential

SQL Developer

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 teh databases whenever changes were made to stored procedures or views.
• Excellent noledge in Import / Export using DTS and BCP utility.
• Performed query tuning and reduced response time by 60%
• Discussions wif Product team for new features
• Performed query plans and enforced indexing in each and every query
• Propped up teh 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 teh 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.