Sql Server Data

Summary

*+ years of experience in Designing, Developing and Maintaining Relational Databases (MS SQL Server 2008/2012/2014) in OLTP and OLAP environment. Designing and Implementing Business Intelligence Solutions using SQL Server.

Good understanding of (SDLC) software development life cycle process methodologies and principle, and experience in Waterfall and Agile (SCRUM) Models.

Data Modelling, Database Design and T-SQL Development

Strong experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications using SQL Server

Efficient in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Primary keys and Foreign keys etc.

Expert in writing common table expressions (CTEs) and user defined functions, indexed views and DML/DDL triggers for data consistency and data manipulation.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.

Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

ETL Development (SSIS)

Expert in Design and development of ETL Packages using SSIS (SQL Server Integration Services) for integrating data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.

Proficient in handling Different Formats of Data and duplicate data with SSIS using Script Task and SQL Script.

Designed and developed SSIS packages using Control Flow Tasks like For Loop Container, For Each Loop Container, Execute SQL Task, File system Task and Data Flow Tasks like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Multicast, Union All and Merge Join.

Experience in implementing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages using Checkpoints, Data Viewers and Breakpoints.

Expert in Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with MS SQL Server 2008, 2012, 2014.

Created package configurations to provide an easy solution to migrating packages from different business environments like development to testing or testing to production.

BI Reporting (SSRS/SSAS)

Experienced in using SSRS to build Sub-Reports, Drilldown reports, Drill Through reports, Parameterized reports and Map reports based on relational or dimensional sources with data visualizations like KPI, gauges, charts and matrixes, with toggle feature, all of which can be delivered on-demand or configured to be deployed according to schedule.

Proficient in SSRS deployment, and very knowledgeable to create cache/snapshot/subscription (Email and Data-Driven) for SSRS reports.

Experience in creating Ad-hoc reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF.

Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.

Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.

Primary knowledge in C# and VB.NET, Proficiency in Database design, Coding, Unit testing and Implementation.

Experience in designing and implementing Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.

Strong knowledge in identifying various dimensions and facts to implement data-ware house architecture.

Skilled in managing OLAP Cubes, creating Key Performance Indicators (KPI) and set up Security and Perspectives in SSAS

Primary knowledge in creating Calculations, Aggregations and Actions using MDX.

Experience in defining and deploying Cubes using SQL Server Analysis Services (SSAS).

Administration

Creating and Managing users, roles and assigning necessary permissions.

Involvement in Backing up databases and Restoring Data across environments.

Excellent communication and interpersonal skills in handling multiple tasks, able take initiative to handle responsibilities independently as well as a member of team.

Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Analysis Services, SQL Server Reporting Services etc.

Technical Skills:

Operating systems Windows Server 2003/2008 Windows 7,8

Programming Languages

SQL, T-SQL, Dynamic SQL, MDX,, HTML, XML, DHTML, C, C++,VB Script, Shell Scripting, C# .NET,VB .NET, ASP .NET, ADO .NET, Visual Studio, XML, HTTP, ActiveX, Lotus notes.

RDBMS

Microsoft SQL Server 2014/2012/2008/2005, MS-Access 97/2000/2003/2010/2013, Oracle 10g/9i/8i, Sybase Server, SQL, PL/SQL, MS SQL, SQL*Plus, Teradata.

Data warehousing

SQL Server 2012/2008/2005/2000, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS). Business Intelligence Development Studio (BIDS), SQL Server Data Tools, SSMS, DTS Packages, MDX Queries, ETL, Performance Point Server, ProClarity, OLAP, OLTP, SQL*Plus, SQL*Loader,

Database Design Tools and Data Modeling

MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, Fact & Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inman Methodologies, MSX, MS Access, MS Project.

Business Intelligence Tools

SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio, Report Builder.

Tools and Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SOAP.

Packages

MS Office 2013/2010/2003-1997, MS Outlook (Microsoft Office Suite)

Version Control and Configurations

Visual Studio Team Foundation Server.

Portal

SharePoint Portal Server 2003/2007/2010/2013, Windows SharePoint Services

Work Experience

Helix Energy Solutions Group Aug 2015-to present

Houston, TX

SQL SSRS/SSIS Developer

Helix is an American oil and gas services company. It is a global provider of offshore services in well intervention and Remotely Operated Underwater Vehicle operations of new and existing oil and gas fields. My role here is SQL Developer on various projects which include provide database solutions and reporting needs.

Responsibilities:

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database which has to be displayed in various forms.

Used Checkpoints on SSIS packages so that the package would restart from the point of failure.

Used SQL mail agent for sending automatic emails when SSIS package fails or succeeds.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Configured jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.

Developed consolidated tables in SQL Server by joining different tables.

Designed Scripts for Data Flow and Error Handling using Script component in SSIS.

Used DBCC Utilities for Performance Tuning, Query Optimization and Client Server Connectivity & Database consistency checks.

Implemented indexes on SQL Server tables for significant performance boost.

Used Execute SQL Task, Data flow Task, Look up, Script component, Union All etc. in SSIS packages.

Developed Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and also Modified already existing stored procedures, triggers, views, indexes depending on the requirement.

Configured packages connections, variables etc. configurable and maintained the same on Test and Production environments.

Involved on Migrating from SQL Server 2008R2 to SQL Server 2012.

Worked in the agile methodology using Scrum which has its primary focus on the management part of the software development.

Participated in impact analysis, design and build phase.

Developed recursive queries using Common Table Expression.

Involved in migration of SQL Server objects like stored procedure, tables, triggers and functions.

Support Oracle Applications which use the relational databases.

Enable grouping by a column that is derived from a scalar sub select by using CTE.

Participated in Identification of the dimension, fact tables and created the data warehouse using star schema.

Created SSAS objects - Dimensions, Fact/Measures, cubes and roles.

Developed MDX queries and created OLAP report sourcing from SSAS cube.

Involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.

Created Sub-Reports, Drill down reports, Drill through reports, Tabular Report and Parameterized reports using SSRS.

Developed and implemented datasets and layouts for various reports with SSRS.

Involved in Testing applications for performance, data integrity and validation issues.

Worked on TFS (Team Foundation Server) for Source Control.

Worked on SQL Profiler to trace the slow running queries and optimized query execution with use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SSIS, SSRS, SSAS, Visual Studio, SQL Server Data Tools, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2005, MS Visio 2007, MS Office 2013/2010.

Cal Dive International, Inc. July 2013- Aug 2015

Houston, TX

SQL BI Developer

Cal Dive is a marine contractor that provides an integrated offshore construction solution to its customers, including manned diving, pipe lay and pipe burial, platform installation and salvage, and light well intervention services to the offshore oil and natural gas industry.

Responsibilities:

Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.

Performed database Schema design and development.

Expertise in using T-SQL for creating stored procedures, indexes, cursors and function.

Designed server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

Developed tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and Performed in performance tuning of T-SQL Queries and Stored Procedures.

Created stored procedures and functions for designing various reports.

Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.

Created and used Batch Files to Import Data from other Data Base.

Developed SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.

Modified and deployed the SSIS Packages from development server to production server.

Designed the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.

Involved in and created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.

Developed packages in SSIS with custom error handling and worked with different methods of logging in SSIS.

Experience in SSIS Deploying and Scheduling

Involved in and Defined Key Performance Indicators in SSAS 2005/2008.

Design and process SSAS cubes to store data to OLAP databases

Worked on SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically Designed reports to the Share Point portal.

Created report layouts for formatting the report design as per the need.

Designed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.

Involved in the development of Reports using Global Variables, Expressions and Functions for the reports.

Developed reports and Dash boards using Microsoft Performance Point service.

Designed on-demand reports using Report Builder in SSRS reports and send the reports via email.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, BIDS, SSDT, MS Office, C#, VB.Net, HMTL, XML, Visual Studio 2010 *& 2008, MS Visio 2007, Erwin.

Google Inc. June 2012-May 2013

Hyderabad, INDIA

SQL Developer

Google is a multinational technology company, which specializes in Advertising, Search Engine, Cloud Computing and Maps. My Role here was to work as SQL Developer in Google AdWords Cost per click Project.

Responsibilities:

Worked on creation of ETL packages using SSIS to extract data from different data sources, load the reformatted data into destination tables.

Created SSIS packages to import data from excel/flat file sources to database.

Responsible for deploying/scheduling SSIS packages as per schedule.

Used Team Foundation Server (TFS) for version control, source control, reporting and to maintain the SSIS packages and documenting source code.

Designed packages in SSIS with error handling.

Created Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins for applications and Packages.

Developed SSIS packages using data flow tasks, look up transformations and script tasks.

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

Configured SSRS to integrate with Team Foundation Server (TFS) to develop/build/deploy reports using TFS 2012.

Created and Implemented Unit Test documents for all SSRS reports.

Involved in creation of several stored procedures to handle large amount of data manipulation.

Extensively used Reporting Services (SSRS) to schedule reports to be generate on predetermined time.

Designed Reports to use Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL Server Reporting Services (SSRS) 2005/2008

Enhanced the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.

Designed on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Involved in Dimensional Modeling using SSAS packages for End-User.

Designed and implemented Hierarchies in Dimensional Modeling.

Environment: MS SQL Server 2012/2018, SSIS, SSRS, SSAS, T-SQL, TFS, Windows Server 2008, MS Access, MS Office, Microsoft Business Intelligence Development Studio, SQL Server Data Tools, Microsoft Visual Studio 2010.

Education Qualifications

Bachelor of Technology in Information Technology, JNT University Hyderabad.

Contact this candidate