Professional Summary

• Over 9 years of IT experience in Database Development, DBA and Business Intelligence Technologies with expertise on ETL process, Reporting and Analyze using MS SQL Server 2008/2005/2000 as a MS SQL Server Developer.
• Worked in various domains like Publication, Telecom, Retail, Health Care, Financial and Education.
• Ability to comprehend business concepts and translate them into technical requirements.
• Experienced in client requirement Analysis, Physical and Logical design & development (using Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications.
• Possess Solid understanding of both logical and physical data modeling techniques for both relational and dimensional models.
• Expertise in installing, Configuring and maintenance of SQL Server 2000 / 2005 & 2008 on Standalone , Microsoft Clustered servers and Applying latest Service Packs, Hot fixes and security patches in Windows 2003 Enterprise Server in high availability environment.
• Good SQL Server Administration skills using various backup strategies, database maintenance plan, user (NT/SQL) security authorizations, database creation, Tables, indexes.
• Experience in monitoring SQL Server performance tuning using SQL Profiler( Dead Locks/Long running queries), Query analyzer, Database engine tuning wizard, Index tuning wizard, windows Performance monitor, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Conducted JAD Sessions prior to specific software development activities to review and document business processes effectively.
• Migration of logins, DTS packages into SSIS packages and constructed new SSIS packages to extract, transform and load the data from old data ware house to new data ware house and OLTP and OLAP.
• Analyze systems to optimize processes, mitigate risk, and develop strategies to maintain quality, functionality, and teamwork throughout project implementation.
• Facilitate high levels of customer service and create competitive corporate advantage through expert project design and management.
• Proficient in working with enterprise data warehousing.
• Good Knowledge of Data Marts, Data warehousing, Operational Data Source(ODS), OLAP, OLTP, Data Modeling like Multi Dimensional Data Modeling, Star Schema, Snow Flake Modeling, Slowly Changing Dimensions (SCD), FACT and Dimension Tables using Analysis Services.
• Excellent in Migration of SQL Server 2000 to SQL Server 2005 & SQL Server 2005 to SQL Server 2008.
• Collaboration with application developers and data analysts to identify, design and implement solutions for extraction and integration of data in both a real time messaging and batch transaction environment.
• Manage and monitor integration database and system performance. That includes optimization and tuning of data loads, extractions, and the recommendation of appropriate changes to ensure and improve system performance and reliability.
• Experience weighing the tradeoffs between bulk inserts and single updates in database and ETL processes for speed optimization.
• StrongSSISexperience with error handing and package scheduling.
• Involved in all activities related to development, implementation, administration and support of ETL processes for large scale data ware houses using SSIS.
• Involved in Migrating DTS packages to SSIS using Package Migration Wizard.
• Experience in Log Shipping to back up and restore databases to improve Performance.
• Expertise in deploying packages using Deployment Utility, DTUTIL Command Line Tool and SSMS.
• Scheduled packages using CISCO TIDAL Enterprise Scheduler, DTEXECUI windows application and SQL Server Agent.
• Designed interactive reports and custom built reports in SSRS to provide user interaction.
• Experience with User Acceptance Testing (UAT) & release skill set.
• Experienced in optimizing performance of various long running queries and stored procedures using SQL Profiler, Index Tuning Wizard and Database tuning wizard.
• Desires to show initiative in solving problems and can work both independently and in team environments.
• Experience in data modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.

Skill set:

Databases

MS SQL Server 2008 R2/2005/2000/7.0/6.5, MS Access

Database Tools

MS SQL Server 2008 R2/2000/2005, MS-Access, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Development skills

T-SQL, PL/SQL, SSIS/SSRS/SSAS,

Languages

T-SQL, PL/SQL, VB.net, VB Script, SSAS, OLAP, HTML, XML, ASP.NET, Java Script, C, C++ and MDX.

ETL Tools

DTS, SSIS (SQL Server Integration Services), SSRS, SSAS

Reporting Packages

SQL Server Reporting Services, Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel.

Tools/Methodologies

MS Visio, Erwin, MS Project, SQL Profiler, MS Office, TFS, FTP File Zilla, Snag IT 10, chilkar Components, Read Gate Sql Bundler,SQL Idear Diagnostic Manager,Ulta Edit.

Diploma In Advance Software Technology (DAST)
Education:
Master in Computer Application

Projects Summary

CONFIDENTIAL, Middletown, NJ 01/2012- Current 
MS SQL Server Lead DBA/Developer

CONFIDENTIAL is a leader in telecommunication services, including cell phones, wireless, U-verse, digital TV, high speed internet, DSL, home phone.It is the second[citation needed] largest provider of mobile telephony and largest fixed telephony provider[4] in the United States, and is also a provider of broadband subscription television services. As of 2010, CONFIDENTIAL is the 7th largest company in the United States by total revenue, as well as the 4th largest non-oil company in the US (behind Walmart, General Electric, and Bank of America). It is the 3rd largest company in Texas by total revenue (behind ExxonMobil and ConocoPhillips) and the largest non-oil company in Texas. It is also the largest company headquartered in Dallas.[5] In 2011, Forbes listed CONFIDENTIAL as the 14th largest company in the world by market value[6] and the 9th largest non-oil company in the world by market value.[7] It is the 20th largest mobile telecom operator in the world with over 100.7 million mobile customers.

Hardware/Software:
MS SQL Server 2008/2005/2000 and Oracle, TSQL, Microsoft Analysis Services and Reporting Services,SSIS,Visual Studio 2008, Team Foundation Server,SVN,SQL Profiler, Idera.

• General responsibilities include Administering, maintaining all existing SQL Servers across Enterprise.
• Migrated MS SQL 2000 databases to new MS SQL 2005 and MS SQL 2005 to MS SQL 2008.
• Migrated MS SQL 2000 DTS packages to MS SQL 2005 SSIS Packages ,MS SQL 2005 to MS SQL 2008 and troubleshooting migration issues and compatibility.
• Designing and managing SQL DTS and SSIS Packages.
• Developing SQL stored procedures, views and triggers
• Created and maintained all MS SQL database alerts using SQL alert.
• Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting.
• Developing SQL stored procedures, views and triggers.
• Managing Log Shipping for hot standby computers.
• Managing Replication of Data (Snapshot, Transactional, Merge method used).
• Implemented MS SQL 2005 Database mirroring on live production database to support production needs .
• Build SSIS packages to migrate data from heterogeneous data sources like Excel, Access, Flat files and Oracle to SQL Server 2005.
• Improved Performance of the database by creating clustered and non clustered Indexes.
• Created custom C# and VB Scripts to download the file from the WEB, to read data from the .PDF files, to convert .PDF files to .TXT files.
• Designed SSIS packages to load the data from various input source files like .xls, .xlsx, .dat, .txt, .csv and .pdf files to the destination.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created T-SQL queries, dynamic Stored Procedures that calculate by taking the customer details as input.

Confidential, Scranton, PA06/2008- 01/2012 
MS SQL Server Lead DBA/Developer

Confidential is one of the world\'s leading English-language publishers. Headquartered in New York, the company is a subsidiary of News Corporation. Confidential is a broad-based publisher with strengths in literary and commercial fiction, business books, children\'s books, cookbooks, and mystery, romance, reference, religious, and spiritual books. Consistently at the forefront of innovation and technological advancement, Confidential is the first publisher to digitize its content and create a global digital warehouse to protect the rights of its authors, meet consumer demand and generate additional business opportunities. The project is aimed at designing the SSIS packages to maintain the Point Of Sales records, Business procedures to validate the data consistently and developing custom E-Mail extraction tools.
Hardware/Software:
MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2008, Team Foundation Server, MS Office, VB.NET, C#.NET, Outlook 2007, DTS Exchange , SQL Profiler, Transactional Replication, Failover Clustering , SQL Lite Speed V4.8,SQL Profiler, Idera, Excel, Access, IMAP,MAPI outlook server.

• Upgraded SQL Server 7.0/2000 Servers to SQL 2005 Server, 60+ production databases, with database sizes ranging from 100GB to 1.5TB.
• Participated in gathering Business rules to implement functional and technical specifications.
• Participated in JAD sessions to gather the new requirements for the incoming files specifications.
• Designed multiple database using normalization and de-normalization forms in Erwin and then created database in SQL Server.
• Installing and Configuring SQL Server 2005 (64 and 32 bit) on Standalone and Microsoft Clustered servers and Applied the latest Service Packs, Hot fixes and security patches.
• Carrying out day-to-day jobs like performance tuning and troubleshooting batch jobs, which are very critical to the firm.
• Responsible for identifying KPI’s in SSAS 2005 and constructed cubes based on data volumes mostly adhering to star schema.
• Designed and Developed ETL Processes using multiple SSIS packages to upload tables from different sources into staging database and then to destination database using different SSIS transformation.
• Designed SSIS packages to load the data from various input source files like .xls, .xlsx, .dat, .txt, .csv and .pdf files to the destination.
• Implemented custom C# scripts to download files from the FTP client, to find the latest file, to rename the files, to read data from the file, to delete a file and to archive the files.
• Add custom rows using script component transformation in the data flow task.
• Created packages to perform looping through the CSV files, Excel files and sheets in a folder.
• Emailing error log files and work log notification to individual users as attachments depending on requirement.
• Designed SSIS packages to extract the Emails from the Outlook Server and save in a local folder.
• Build C# scripts to download the Email from the Outlook, flip the attachments and body into separate folders and dynamically call child packages to load the data from the attachment.
• SSIS packages to unzip the files using both Chilkat components and Script task utilities.
• Worked with chilkat ZIP, MAIL, IMAP components to unzip .ZIP files, send emails and to extract emails from the IMAP server besides exchange server to Outlook.
• Migrated/re-designed SQL server 2005 packages to SQL server 2008 packages depending upon requirement.
• Scheduled Packages in CISCO TIDAL Enterprise Scheduler.
• Created stored procedure to validate the incoming input file data from the various vendors before loading destination.
• Responsible for the definition,documentationand execution of one or more small-scale projects, actively participating in all phases of the project.
• Created various reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Designed complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Scheduled reports for Daily, Weekly, and monthly and annually based on business requirement.
• Extensively incorporated testing strategies before promoting new applications.
• Executed UAT scripts to gather sign off on financial applications to meet Business.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Worked extensively in performance tuning data cleanups.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Confidential, NJ 11/2007 - 05/2008
Database Administrator
Premier Core Data is to provide Microsoft Premier Management, finance, and operations with consistent views of their business, in a timely manner, to enable rapid decision making and measurement of key performance indicators, driving their business, in an effective, accurate and consistent infrastructure. The project aimed at creating ETL procedures to extract the data from heterogeneous sources using SSIS 2005, and creating, deploying and scheduling reports.
Hardware/Software:
MS SQL Server 2005, SSIS, SSRS, SSAS, T-SQL, MS Office, VB.NET, C#.NET, Outlook Soft 4.2, Visual Studio 2005, SQL Profiler, Excel, Access, Share Point Server 2007.

• Actively participated as a team to gather requirements along with lead, DBA and technical manager.
• Developed T-SQL Scripts with Indexing, Rank, Joins and Common table expressions (CTE).
• Created User Defined Functions, Indexes to generate the distinct data based on the type of input supplied.
• Created Fail-over Cluster (Active/Active, Active/Passive)environments, depending on the application and business requirements.
• Performance tuning in Database level, T-sql level, Operating System level & Hardware level.
• Analyzing the load on the system, based on that laying out disks memory, processors for Production, UAT and Development servers.
• Implementing SQL coding standards in writing Stored Procedures, Triggers, Views, SQL functions and locking issues.
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity and Responsible for keeping system and databases up-to-date by making necessary changes.

• Created C# scripts to extract the date part from the file name and load to the table.
• Implemented FTP task to download and uploads data files from an FTP server to local server.
• Build C# scripts to unzip the Zip files and RAR files in the forecast folder before loading data.
• Writing MDX Queries for querying data from a Multidimensional Warehouse.
• Ensured data changes in the source system by using Slowly Changing Dimension Transformation.
• Configured Send Mail Task to send the mails upon successful deployment of package using STMP.
• Deployed and scheduled packages using SQL Server Agent Job in Management Studio.
• Used VB code and Batch Script for maintenance of reports.
• Used Script Task as a performance counter in packages.
• Performed package configuration to maintain environmental variables for packages.
• Used Analyzing Services to build the data cubes using SSAS.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
• Improved Performance of the database by creating clustered and non clustered Indexes.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Confidential, CA 09/2006 - 10/2007
MS SQL Server Developer/BI Developer
Confidential is world\'s leading BI software company. Confidential software helps organizations gain better insight into their business, improving decision-making and enterprise performance. Companies in every industry use Business Objects products and services to track, understand, and manage information. Business Objects customers - from small businesses to top international corporations - benefit from the industry\'s largest services and support team, a powerful research and development organization.
Hardware/Software:
MS SQL Server 2005, SSIS, SSAS, BI XI R2, SSRS, Windows XP, SQL Profiler, T-SQL, MS Office, C#.NET, ASP.NET, XML, MDX, Outlook Soft 4.2, Visual studio, Excel, Access .

Responsibilities

• Extensive T-SQL Development on SQL Server 2005 for evolving business requirements, enhancement to existing procedures.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Migration of databases from SQL Server 2000 to SQL Server 2005.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Created SSIS package to load data from Flat File, Excel and OLEDB to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used custom .NET assemblies for Script Task in SSIS.
• Deployed and scheduled the packages using SQL Server Agent Job.
• Participated in requirement gathering of the cube design using SSAS.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and write SQL code to access and manipulate data stored in relational databases.
• Developed and implemented Stored Procedures, Triggers, Functions.
• Installing and Configuring SQL Server 2005, Analysis services, Integration Services and Reporting services for QA and DEV.
• Worked in Data Warehousing and analysis skills including MDX language, OLTP, OLAP (MOLAP, HOLAP, DOLAP, and ROLAP), Relational and Dimensional modeling skills (star schema and snowflake schema).
• Performed Migration of data using Import Wizard tool from Business Objects 6.5 to Business Objects XI R2.
• Used @functions like @prompt (for user defined queries), @where (for creating conditional filters), and @select to create duplicate objects in the process of building the universes.
• Created master detail and cross tab reports to view the data in an analyzed way.
• Used the drill down/up, slice and dice features to analyze data, set variables, alerts and group values in the reports.

Confidential, Philadelphia , PA03/2005 - 09/2006
MS SQL Server DBA/Developer
For more than 70 years Confidential has offered quality health care products and services designed specifically to meet the changing health care needs of customers.. The Project mainly involved in creating databases, Migration, loading data from different sources. It also involved in creating ETL procedures and generating Reports using BO. 
Hardware/Software:
MS SQL Server 2000,2005, SSIS, T-SQL, Business Objects, Geo Access Coder, EAP Expert, MS Office, Visual studio, SQL Profiler, Excel, Access, Windows Server XP, IIS 6.0, Erwin, Test Director.

Responsibilities

• Actively involved in all stages of Software Development Life Cycle from requirement gathering to maintenance of databases.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Implemented one to one and one to many relationships between the tables in the database.
• Identified and implemented the tables with Primary Key, foreign Key and Identity columns.
• Maintained the Referential integrity between the tables using Triggers and Stored Procedures.
• Created and manipulated the indexes for faster access of database tables.
• Wrote several SQL Scripts to query the tables to enforce constraints on tables with Identity and Primary Key.
• Migration of databases from SQL Server 2000 to SQL Server 2005.
• Converted DTS packages to SSIS as per client requirements.
• Maintained documentation for overall projects.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Created T-SQL queries, dynamic Stored Procedures that calculate by taking the customer details as input.
• Created views and indexed views to reduce database complexities for the end users.
• Design and develop SSIS package for loading data from OLTP to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension (SCD) to maintain historical data in Data Warehouse.
• Used GeoCoder tool to address-based geocoding application that assigns geographic coordinates to provider, facility, or ancillary location records.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Created reports using SQL Server Reporting Services (SSRS).
• Improved Performance of the database by creating clustered and non clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Unit testing and Integration testing for various modules using Test Director.
• Extensively involved in replication and implemented Snapshot Replications
• Wrote detailed scripts to review object permissions in all databases across the servers.
• Worked in mission critical 24x7 production environment.
• Involved in maintenance of the site.

Confidential, Dallas, TX 02/2004 - 03/2005 
MS SQL Server Developer/BI Developer
Confidential has different systems placed at different time period. To extract the data for reporting they were undergoing complex process to consolidate the data from different sources to make up the report.

Hardware/Software:
SQL Server 2005/2000/ 7.0, Visual .NET, Enterprise Manager, Crystal Enterprise Server, Query Analyzer, T-SQL, IIS 5.0, Windows 2000/NT

Responsibilities:

• Created and Developed Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, T-SQL (DDL, DML) statements and other advanced queries for databases by using SQL Server Management Studio.
• Built a centralized repository in SQL Server 2000 by extracting different sources of data like Text Files, Mainframe Output files, Microsoft Access databases and Excel spread sheets.
• Created and developed the stored procedures to handle complex business rules, history data and audit analysis.
• Performed General Maintenance of All Applications.
• Server Installation, Database Administration, Production and Development Support.
• Used Replication Server in SQL Server 2000 for distributing data and Stored Procedures across the corporation.
• Designed DTS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files
• Involved in Data migration using BCP from text to SQL Server 2005.
• Created packages in SSIS Designer using Control Flow and Data Flow Transformations to implement business rules.
• Created the mappings using transformations such as the Derived Column, Conditional Split, Pivot, Conditional Split, and Script Component.
• Used Control Flow elements like For each loop and Sequence container, Execute SQL task, Execute Process task, Execute package task and Script task, File System task Send Mail Task.
• Scheduled and monitored the SSIS packages for daily load in SQL Server job Agent.
• Involved in Creating Stored Procedures for reports generation.
• Performance Tuning in SQL Server 2000 using SQL Profiler.
• Created and deployed complex reports using multiple parameters from stored procedures, expressions and conditional formatting.
• Created complex table, matrix and chart reports to work with different output formats.
• Conducted performance tuning by using SQL Profiler and database engine tuning advisor.