SUMMARY

• Over 8+ years of experience in IT industry as a SQL Server BI Developer with specialized skills in SSIS, SSAS and SSRS.
• Solid experience in RDBMS database design, installation, configuration, performance tuning, optimization, backup and recovery in SQL Server.
• Experienced in all phases of Software Development Life Cycle(SDLC), starting from business requirement gathering and analysis to testing and deployment.
• Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact - SQL coding.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Proficient in OLTP, OLAP and Data warehousing Design concepts.
• Excellent understanding of Relational Database Systems (RDBMS), Normalization, Multi-Dimensional.
• (Star)and Snowflake logical and physical data modeling using ERWIN data modeler and MSVISIO.
• Thorough understanding of Kimball’s’ theory, KPI’S, SQL 2008 Architecture.
• Experience in Migrating from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2005/2000.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Experience in Migrating from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008.
• Excellent experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.
• Proficient in using SQL Profiler, Execution Plan and Performance Monitor.
• Extensive experience in creating complex SSIS packages.
• Extensive experience in using various tasks, containers, sources, transformations and destination in SSIS tool while transferring the data from various sources systems into the destination.
• Used Task Factory components and tasks like Destination, Update batch transformation, Surrogate key transformation and many based on the requirement.
• Transformed data from various data sources to SQL Server using BCP, DTS and SSIS.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Involved in Performance Tuning & Deployment of SSIS packages.
• Proficient in creating different Package Configurations such as SQL Server, XML configuration and Parent package variable.
• Implemented different Logging in SSIS packages to log events during the run time.
• Proficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like SQL Server, Oracle, QVD files, Access, text files, excel documents etc. as per the user requirement.
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and DW concepts.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Monitoring scheduled jobs and disk spaces on all servers.
• Proven ability in database backup and recovery procedures.

TECHNICAL SKILLS

Programming Languages: C, C++,SQL, TSQL, PL/SQL,HTML

RDBMS: MS-SQL Server 2000/2005/2008 , 2012, Oracle 9i/10g, Microsoft Access, DB2

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2012 , DTS

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/2005/2008 , QlikView 11,Tableau

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Teradata, Query Analyzer

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

SQL Server DBA /SSIS/SSRS Developer

Responsibilities:

• Participated in Business Processes with the Business Analyst/Client delivery to understand the requirement and Reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager.
• Participated in Design/Discussions of ETL flow from different source systems into Data warehouse (DWH) model (Start Schema).
• Created Source to Target (STT) mapping document for DWH ETL process.
• Involved in installing and maintaining MS SQL Server 2008 R2/2012.
• Migrated SSIS packages from SQL Server 2008 R2 to SQL Server 2012 as SSIS packages.
• Tuning and Optimization ofStored Procedures and use of Performance Monitor/Profiler to solve DeadLocks/Long running queries.
• Responsible for reviewing,optimizing and deploying database scripts requested by ApplicationDevelopment Team.
• Involved in designing the rules for MDM filed’s requirement for business requirements.
• Implemented data quality solutions for MDM, and BI projects.
• Analyze, identify and resolvedatabase performance issues and bottlenecks.
• Handling database administrative tasks, database monitoring, database and applications access and security, diagnosing and resolving databaseproblems.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS packages to integrate data coming from text files and excel files.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB command, conditional split, lookup, aggregator, multicast and derived column.
• Used task factory components and transformation like Upsert destination, Update batch transformation, Null Handler Transformation, Surrogate Key Transformation, Advanced Email and SMS Task in SSIS packages.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Deployed SSIS package into production and used package configuration to export various package properties to make package environment independent.
• Implemented event handlers and error handling in SSIS packages and notified process results to various user communities.
• Maintained oversight of version control of documents within the Sub version control.
• Created database maintenance plans for backup strategies and involved in database partitioning.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient stored procedures to perform data cleansing and loading task when data is loaded into staging area.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2008 for faster execution and developed database structures.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Provided knowledge transfer to the company’s SQL programmers.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Developed and implemented production database backup and recovery plan to protect business data with full backup, transactional log backup, and differential backup.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Creating databases and logins and users with permissions.
• Created and maintained Full-text index of SQL server.

Environment: SQL Server 2008 R2 Enterprise Edition, SQL Server 2012 Enterprise Edition SQL, Enterprise manager, SSIS 2008R2, SSIS 2010, Java script,C# .net

Confidential, Austin, TX

SQL DBA /SSIS/SSRS/SSAS Developer

Responsibilities:

• Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
• Responsible for performance tuning and optimization of SQL queries and indexes.
• Installed, configured and maintained Three SQL fail over cluster environments.
• Created dimension and fact tables and built simple cubes using Analysis Services
• Created Key performance Indicators (KPI’s) using MDX queries.
• Worked on creating calculated measures that fits business logic, using MDX queries
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Developed SSIS Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2008for further Data Analysis and Reporting by using multiple transformations.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Used Log Shipping to synchronize databases.
• Developed Backup and Restore scripts for SQL Server 2005.
• Installed and Configured SQL Server 2005 in Test Environment with latest service packs.
• Involved in Unit, Functional and Integration testing process.
• Developed, deployed and monitored SSIS Packages.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Responsible for fine tuning of the database, trouble shooting, user administration, memory management, and running DBCC commands.
• Perform daily database backup & restoration and monitor the performance of Database Server.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed data model and overall MS N-tier architecture for the online application in all aspects such as network topology, load balancing, SQL Server clustering, network security, user access mode, database server workload, database organization, data structure design, physical data storage arrangement.

Environment: SQL Server 2005 (Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard), SQL Server Reporting Services (SSRS), SSIS, ASP.NET.

Confidential, Alpharetta, GA

Senior SQL DBA SSIS/SSRS Developer

Responsibilities:

• Conducted data migration processes from a legacy environment to an SAP environment utilizing the SSIS Development platform.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Worked on other packages of the SQL server 2005 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Multidimensional Data Modeling (Logical andPhysical Design of OLAP AND OLTP Databases), Normalization and building ReferentialIntegrity Constraints.
• Creation and maintenance of Data Warehouse models, based on Kimball’s Methodology.
• Creation and maintenance of Cubes using SSAS as the primary design tool.
• Scheduling and executing SSIS Packages, using SQL Server Agent.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• 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.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Created Indexes, Constraints and Rules on database objects.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created different chart reports helped in analyzing perfuming counters using SSRS 2005.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Involved in developing and modifying VB and XML reports for exporting the reports to web application.
• On-Call production support on rotation basis.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008, Visual Studio 2008,Share Point, Performance Monitor, Query Optimizer, Oracle 10g, MS Access, Java Script/J Query.

Confidential, Oklahoma City OK

SQL Server DBA /SSIS/SSRS Developer

Responsibilities:

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in data modeling using MS Visio.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous database.
• Involved with technical developers on MDM product capabilities with syndication of import/data manager teams.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel (Pivot tables etc.).
• Created Drill down and Drill through reports using Crystal Reports.

Environment: SQL server 2008/2005. ASp.Net, VB.Net, SSRS 2008, SSIS 2008

Confidential

SQL Server DBA

Responsibilities:

• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Configured SQL Server 2000 Environment.
• Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
• Design and Creation of logical storage (Table spaces, Segments etc.).
• Designed E-R Diagrams, logical and physical data modelling.
• Interacting with business users in getting the reporting requirements.
• Performed installations of Oracle 8i and SQL server databases.
• Backup and Recovery of Oracle database using Recovery Manager (RMAN).
• Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems.
• Used FTP and SCP for keeping important files safe and secure.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database.
• Created tables, indexes, stored procedures and functions.
• Developed and integrated code for enhancement of the application.
• Responsible for optimizing the queries and application tuning.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Developed custom reports using Microsoft reporting Services.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database.

Environment: Windows, SQL server, Oracle 8.1.7.0.1/ 9.2.0.1.0, T-SQL, Query Analyzer, Data Transformation Services.