PROFESSIONAL SUMMARY:

• Extensive experience developing and working with diverse collection of applications and 8+ years of professional experience as Microsoft SQL server database administration and SSIS Developer.
• Highly experienced in MS SQL Server 2012/2008R 2/2008/2005/2000 with Business Intelligence inSQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Extensively performed database administration tasks: Installing, Configuring, Managing, Monitoring and Troubleshooting MS SQL Server 2012/2008R 2/2008/2005/2000 on Windows 2003/2003R2/2008/2008 R2/2012 servers.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities and an extremely diligent strong team player with an ability to take new roles.
• Possessed Excellent T - SQL Programming skills and effectively used Advanced Programming concepts like CTE’s, Windows Functions, Table Partitioning, Apply Operators, Table Valued Parameters,Output Clause, Merge Statement, Pivot, XML, Dynamic SQL, Table Valued Functions etc.
• Highly experienced in creating complex Views, Stored Procedures, DDL/DML Triggers and User-Defined Functions (UDF) to implement Business Logic and Data Protection.
• Experienced with SQL Server and T-SQL in constructing triggers, tables, user defined functions (UDF), views, indexes, user profiles and relational database models with data integrity.
• Used SQL Profiler, Execution Plans, DMV’s, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization.
• Implemented Stored Procedures with TRY-CATCH Blocks,Database E-mail for Error Handling and Effectively Used Join Hints, Isolation Levels to reduce Locking and Blocking.
• Used DMV’s and Locking Queries to find out Locks, Deadlocks and Long running Queries or Transactions.
• Written Scripts for deploying the code across various SDLC Environments like TEST,UAT and Production.
• Experience in implementing different types of Replication models like Snapshot, Transactional and Merge.
• Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Involved in monitoring database maintenance plans for checking database Integrity, Rebuilding, Reorganizing Indexes, Shrinking Databases, updating statistics, Creating and Scheduling SQL Server Agent Jobs.
• Used Some of T-SQL 2012 New Features like Sequencer, ThrowStatement, Fetch and Offset and FunctionsLikeLead(),Format(),Concat(),First Value(),Last Value(),EOMonth(),TRY Convert() etc.SSIS Experience (ETL):
• Designed ETL packages dealing with different data sources (SQL Server, Oracle, Flat Files, Excel Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed SSIS Packages with Custom error handling, Logging using event handlers, Send E-mail Task and Used Checkpoints to rerun Packages from Point of Failure.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Designed SSIS Packages with Dynamic Tasks and Connections Using Variables, Expressions and Packages Configurations and followed best practices to maintain Optimized performance.
• Loaded Data warehouse Fact Tables and Dimension tables of type 1 and type 2 attributes Using Transformations Lookup, Merge Join, Conditional Split and also Using T-SQL 2008 Merge Statement
• Debugged the Packages Using Break Points, Data Viewers, Script Task, Deployed the Packages Using DTUtil Commands,Deployment Utility and Scheduled Packages with DTExec Commands.
• Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, Sub reports.
• Used Report Manager to assign roles, permissions and Created report schedules and Subscriptions.
• Expert in creating traditional as well as Web-based interactive reports using SSRS.
• Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems.SSAS Experience (OLAP):
• Experienced in building Star schema and Snow Flake schema depending on business requirements.
• Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Defined Dimension Granularity within a Measure Group.
• Experienced in developing and modifying cubes and dimensions in cubes using SSAS.
• Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
• Experienced in Developing, Deploying and Processing SSAS Cubes and writing MDX queries.

TECHNICAL SKILLS:

Data Warehousing/BI Tools: MS SQL Server Business Intelligence (MSBI) Development - SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Server Management Studio(SSMS) 2000/2005/2008/2008 R2/2012, Visual Studio (VS) 2005/ 2008/2010/2012

RDBMS/DBMS: MS SQL Server 2000/2005/2008/2008 R2/2012, ORACLE 9i/10g, MS Access, DB2, Sybase

Tools: MS SQL Server Management Studio (SSMS), Performance Monitor, Power Pivot, SSIS Documenter, SQL Agent, SQL Mail, Erwin, Team Foundation Server (TFS) 2008/2010/2012 , Microsoft Visio 2003/2007/2010/2013 , Visual SourceSafe (VSS), Import/Export Wizard.

Web Technologies: HTML, DHTML, XML, IIS, Apache.

Programming Languages: T-SQL, PL/SQL, C#.net, Core Java, C, Java Script,VB Script, XML, HTML

Operating Systems: Windows 8/7/Vista/XP, Windows Server 2000/2003/2008/2012.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. SQL BI-SSIS/SSAS/SSRS Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards and scorecards.
• Involved in the dimensional modeling of Data warehouse using Erwin tool.
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions andViews to support efficient data storage and manipulation in SQL server management studio(SSMS).
• Created appropriate Triggers to assist efficient data manipulation and data consistency.
• Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement.
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS).
• Extensively used transformations, control flow tasks, containers and event handlers.
• Used checkpoints to implement the restart ability of the packages in SSIS.
• Implemented custom logging in SSIS using event handlers and execute SQL task.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio(MSVS).
• Created dynamic Package Configuration of type SQL Server table.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan.

Environment: Erwin, SQL Server 2008 R2/2012, Business Intelligence Development Studio (BIDS 2008 R2), SSIS, SSRS, SSAS, Visual Studio 2012/2010, Team Foundation Server 20012/2010, BI Xpress V4.0.0, .NET Framework, T-SQL, MS-Excel, XML, Window 2007 Server, Crystal Reports, Share Point Server 2010.

Confidential, Chicago, IL

Sr. MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and MasterDetail reports.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
• Created cubestructure for the analysis of business condition and for creation of report using SSAS.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Worked on with Report Manager, Report Builder, and Reporting Security and Reporting ServicesConfiguration manager.

Environment: MS SQL Server 2008/2008R2, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows 7.

Confidential, CT

SQL Server Developer/ BI Developer

Responsibilities:

• Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
• Connected various applications to the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Created reports from complex SQL queries and MDX queries.
• Created and implemented the staging database prior to the final data warehouse.
• Involved in Migration of different DTS packages to SSIS packages.
• Expert in FTP task, ETL script task, look up transformation and data flow tasks to load staging databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
• Created and scheduled SSIS packages to load the data form OLTP source system to data staging environment and then to data warehouse environment.
• Designed the SSIS Package for the Scheduling the task for the different operations like extracting the data, to perform appropriate transformation and Loading purposes.
• Involved in the performance tuning for the OLAP Cube.
• Designed and implemented data marts, facts dimensions and OLAP cubes using dimensional modeling standards in SQL server 2005.
• Involved in the SSAS partitions and calculation of queries with MDX, developing reports using MDX and T-SQL.
• Worked with SharePoint Server 2007 while deploying SSRS reports.
• Performed daily tasks including backup and restore by using SQL server 2005/2008 tools.
• Responsible for maintaining UAT (User Acceptance Testing) and Production environment.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows XP,Excel, Acrobat Reader, Microsoft Office SharePoint Server.

Confidential, Dallas, TX

Sr. MS SQL Server Developer (SSIS/SSAS/SSRS)/DBA

Responsibilities:

• Performed Migration of SQL Server 2005 to SQL Server 2008.
• Generated Logical and Physical Data Models using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Migrated Stored Procedures from 2005 to SQL Server 2008 to refer to Dynamic Management Views.
• Created and Deployed of Ad-hoc and Customized Reports to satisfy business needs using SSRS.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.
• Used SQLCMD utility in command prompt to access SQL Server.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements
• Maintained all the SQL documents include installation and data conversion Procedure documents.
• Monitored Indexes, file growths and analyzed blocking & locking issues to remove the performance bottlenecks.

Environment: MSSQL Server 2005/2008,SSIS, SSRS, SSAS, T-SQL, ERWIN, windows 2003/2005 platform, Excel, Access, Crystal Reports 2008 and Windows NT, DTS.

Confidential, St Louis, MO

MS SQL Server/BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Upgraded the server from SQL Server 2000 to SQL Server 2005.
• Migrated databases from MS SQL Server 2000 to MS SQL Server 2005 using Backup and Restore method.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions by writing complex Queries and Joins.
• Developed and delivered dynamic reporting solutions using Crystal Reports 11.0.
• Tuned SQL queries using execution plans for better performance.
• Remediated database objects including triggers, stored procedures, functions, user-defined functions.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, views and user security management.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Created reports like tabular, matrix, ad-hoc, drill down and drill through reports using SSRS.
• Extensively usedDatabase Tuning Advisor (DTA) to improve the performance of Query (Query Optimization).
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2000 Enterprise Edition, SQL Server 2005 Enterprise Edition, Crystal Reports 11.0, ODBC, VBScript, Windows2000/2003Server

Confidential

MS SQL Developer/BI developer

Responsibilities:

• Created Logical and Physical data models using Erwin 4.0 data modeling tool.
• Developed complex Stored Procedures, Functions,DTS (Data Transformation Service) packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migrated the data from various sources using DTS.
• Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
• Compressed data files by removing empty database pages and updating index statistics.
• Developed and edited many complex reports with Crystal Reports 10.0.
• Designed and implemented user log in and security.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Planned the complete back-up of databases for disaster recovery (DR) scenarios.
• Reorganized database structures as needed, automated procedures at regular intervals.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in project planning, scheduling for database module with project managers.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access 2003, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2003 Server, Crystal Reports 10.0