Sql Server Data

Summary:

●* years of IT experience in Database designing /Database Administration and Development using MS SQL Server 7.0/2000/2005/2008/2012/2014 for both OLTP and OLAP Systems.

●Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS in different fields.

●Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) for 2012, 2008 R2, 2005.

●Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.

●Strong working experience in SQL Server and T-SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.

●Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data profiling and other database related activities.

●Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

●Experienced in logical and physical data modeling, forward and Reverse engineering using Erwin, Normalization, de-normalization and building Referential Integrity Constraints.

●Involved in huge data migrations, transfers using Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

●Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

●Experienced in Error handling of SSIS packages using transactions, check points (package restart ability features), break points and Error logging procedures.

●Experience in creating various type of 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.

●Working experience in Relational Database Management systems (RDBMS), Star Schema, Snowflake schema in Multidimensional Data Modeling.

●Experience in SSRS reports - Report Services integration and deployment, Subscription.

●Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.

●A thorough professional with proactive attitude, out of the box thinking and generating new ideas.

●Expertise in creating and maintaining jobs in various job scheduling systems includes SQL Server Agent job, Maestro Scheduler and Tivoli Work Load Scheduler.

●Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.

●Ability to comprehend business concepts and translate them into technical requirements.

●Desires to show initiative in solving problems and can work both independently and in team environments.

●Has the ability to prioritize and adapt quickly to work load changes

Technical Skills:

RDBMS/DBMS:

MS SQL Server 2008,2005,2000, 7.0, MS-Access, Oracle10.i/9.i/8.i

Database Technologies/Tools:

SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, T-SQL, PL/SQL, DTS, SSIS, OLTP, ADO, SQL OLEDB, DBCC,, SSRS,SSAS, VERITAS Netback up 6.0, Light Speed, ERWIN 3.5/4.0,ER Studio 7.0, Visio 2002, Visual Source safe, TFS, MS Access.

ETL & Reporting:

SQL Server Integration Services (SSIS), SQL Server Reporting Services, Data Quality Service (DQS)

Operating System:

Windows 2008/2003/2000/NT/Vista Datacenter and Advanced Server -32bit/64bit. Windows 2000/2003 Advanced Server, Windows Exchange Server 2003/2008,Windows NT 4.0/3.5, Windows9.x, Windows XP

Programming Languages:

C/C++, HTML, JavaScript, C#, .NET, T-SQL, PL/SQL.

Others:

MS Office 2000/2003/2007, Outlook etc.

Professional Experience:

Client: National Heritage Academies Jan ’16 – Feb’ 17

SQL BI Developer

Project Description: Worked on Migration Project (k-12 Industry), used SQL Server Management Studio, SSIS, SSRS and SSAS on a daily basis. Write complex SQL Scripts to pull data for report generation and handling complex scenarios for rendering report layout with optimized performance.

●Involved in Database design, and create schemas, tables, views and indexes.

●Backend database development in MS SQL Server, writing complex ad-hoc queries, stored procedures, views, triggers, cursors, UDFs.

●Developing and maintaining complex stored procedures using T-SQL.

●Troubleshooting data issues, validating result sets, performing unit testing.

●Involved in SSIS package Upgrade/Migration from SQL Server 2008 to 2014.

●Designed & developed various SSIS packages (ETL) to extract & transform data & involved in Scheduling SSIS Packages.

●Created SSIS Package to import and export data from Flat Files and csv files to SSMS. Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

●Played Key role in team of ETL developers for re-writing DTS packages and updating them to SSIS packages.

●Complete SSRS Report writing, which includes an understanding of the underlying data, data structure and business terminology.

●Created Cross-Tabs, Drill-down and Sub-Reports in SSRS using different types of properties like Chart controls, filters, Interactive Sorting, SQL parameters etc. deployed RDLs to Report Server.

●Created and Managed OLAP Cubes using SSAS.

●Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.

●Involving in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.

●Reviewed cubes, changed the cubes and documentation according to the requirement based on evaluation using SSAS.

●Migrate reports from the old system to the new by utilizing the existing report layout and making changes to the backend call.

●Optimize the reports and underlying stored procedures that take longer to run.

●Use of version control software, such as Microsoft TFS.

●Performed data analysis and data profiling using complex SQL on various sources systems using DQS.

Environment: MS SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Data tools 2012, XML, Team Foundation Server, SQL Server Analysis/Integration and Reporting Services, SharePoint 2010/2013, DQS.

Client: Ironshore services Inc, one state street, NY Nov ’13 – Dec’15

SQL BI Developer

Project Description:Use SQL Server Management Studio, SSIS, SSRS and SSAS on a daily basis. Load Claims information into tables using SSIS with transformations where ever need. Write complex SQL Scripts to pull and analyze data Create Cubes using SSAS so as the non IT users can easily slice and dice the data to analyze and make policy decisions.

Responsibilities

●Involved in Database design, and create schemas, tables, views and indexes.

●Backend database development in MS SQL Server, writing complex ad-hoc queries, stored procedures, views, triggers, cursors, UDFs.

●Performed Database code Migration from SQL Server 2005 to 2008 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe(VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.

●Experience in SQL joins, sub queries, tracing, and performance tuning.

●Extensive use of triggers to implement business logic and for auditing changes to critical tables in the database.

●Identify & record defects with required information for issue to be reproduced by development team.

●Performed Data Cleansing and Data Profiling.

●Provided back-end support for functional tuning and performance testing.

●Performed incremental data load packages in SSIS.

●Involved in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding data marts.

●Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

●Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.

●Experience in SSIS script task, look up transformations and data flow tasks using T-SQL and Visual Basic (VB) scripts.

●Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

●Experience in SSIS script task.

●Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.

●Played critical role in developing ETLs for loading dimension tables using Kimball methodology, creating SSRS reports, batch commands for scheduling.

●Worked on data warehouse Analysis services and developed different reports for analysis.

●Involved in creating Tabular Cubes using SQL Analysis Services (SSAS).

●Used Tabular cubes since there are important calculations based on distinct count measures and complex calculations based on many-to-many relationships.

●Created cubes with full processing and partial processing capabilities.

●Created and maintained users, roles and groups and handled cube security efficiently.

●Trained End users to browse cube data using Microsoft Excel 2013/2010 and Power Pivot.

Environment: MS SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Data tools 2012, XML, MS Visual Source Safe and Windows Server 2003/2008/2012, DQS.

Redbox, Chicago, IL Jan ’13 – Oct’13

SQL BI Developer

Description: Redbox is an American company that specializes in the rental of DVDs, Blu-ray Discs, and video games via automated retail kiosks. As of the end of June 2011, Redbox had over 33,000 kiosks in over 27,800 locations.

Responsibilities:

●Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in Microsoft SQL Server 2008 and 2012.

●Hands on experience with tools like SQL*Plus, Export and Import Utilities along with PL/SQL, Oracle Enterprise Manager (OEM), and TOAD.

●Responsible for creating user groups and assigning permissions.

●Optimized stored procedures and indexed query using Index Tuning Wizard.

●Created SSIS Packages to pull data from Online Database Server to Data-warehouse Server.

●Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel

●Spread sheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

●Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts and used C# and VB.Net scripts in process of designing the SSIS packages.

●Involved in complete Software Development Lifecycle (SDLC).

●Configured SSIS packages using Package configuration wizard to allow packages run on different environments.

●Develop and maintain stored procedures, functions, views, triggers, SSIS packages and SQL Server Agent jobs.

●Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, and process SSAS cubes to store data to OLAP databases.

●Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.

●Created DTS packages to transfer objects from development server to production.

●Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

●Responsible for maintaining cubes using SSAS and populate the cubes with the data.

●Involve in Unit testing, Integration testing and System testing.

Environment: Microsoft SQL Server-2008/2012, Visual Studio-2008/2010, T-SQL, Team Foundation Server, SQL Server Analysis/Integration and Reporting Services, SharePoint 2010/2013

Client: Siemen, GA Aug ’08 – Oct’12

SQL BI Developer

Description: Siemens Energy and Automation helps customers in the industrial, manufacturing and construction sectors succeed by providing complete electrical, engineering and automation solutions.

Responsibilities:

●Involved in User Requirement Gathering and Technical Specification Documentation.

●Involved in Designing of the logical and physical database

●Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.

●Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.

●Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges.

●Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

●Fine-tuned Procedures, Functions and Triggers for optimum performance.Creating transactional and merge replication on different servers.

●Performance tuning at Database level, T-SQL level and operating system level.

●Trouble shooting Problems by using SQL server profiler.

●Creating DTS packages to maintain central repository by extensively using different SQL2000 DTS tasks.

●Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, and flat file, XML in order to create and maintain a centralized data warehouse.

●Plan and implement data roll-up from live site to data warehouse.

●Resolving the bugs in the database.

●Assisted with various ad hoc query requests.

●Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005 Enterprise Edition, SSIS, SSRS, T-SQL, Access 2000 & Windows 2K platform, MS Project.

Contact this candidate