Sql Server Data

Professional Summary

*+years of strong experience and worked as senior, with demonstrated success in the Database Design, development of SQL Server 2000/2005/2008/2008R2/2012/2014/2016.

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers(DDL&DML), User Defined Data types and Functions(UDF).

Experience in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

Excellent understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modelling.

Extensive experience in Database and Business Intelligence technologies with expertise in Installing, Upgrading, Troubleshooting and Configuring MS SQL Server Database, SSIS, SSRS, SSAS.

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

Experience in implementing MDM (Master Data Management) using SQL Server.

Experience in implementing DQS (Data Quality Services) using SQL Server.

Excellent understanding and Designing of Star and Snow Flake data models Schema used in Relational, Dimensional and Multidimensional data modelling.

Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.

Exhaustive experience in Data Extraction and Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) in MS SQL Server to import/Export data, Bulk insert and BCP.

Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.

Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, and Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot).

Strong experience in creating dashboards, KPI’s and scorecards using gauges and charts for analysis using SSRS 2014/2012/2008 R2 and SharePoint 2010.

Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.

Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS).

Expertise in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle DB and DB2.

Experience in Dimensional modelling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin,

E-R Studio.

Education

Bachelors of technology in Computer Science & Engineering.

Technical Skills

RDBMS

SQLSERVER 2016/2014/2012/2008R2/2008/2005/2000, Oracle 10G/9i, Teradata, MySQL

Database Tools

BIDS, SS Management Studio, Query Analyser, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Bulk Insert and BCP, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL, Data Quality Services(DQS), Master Data Services(MDS).

ETL & Reporting Tools

SSIS, SSRS, SSAS, Pentaho Data Integration (Kettle), QNXT reporting, Excel 2010, Cognos 8...3/8.4, QlikView, Power View

Programming Languages

SQL, T-SQL, MySQL, ANSI SQL, PL/SQL, C, C++, JAVA, C#, VB 6.0, Unix, Python

Operating System

Windows 95/98, NT, Windows XP/2003/2000, Unix, Linux, MS-DOS

Web technologies

HTML, XML, VBScript, SharePoint 2010, C#, ASP.NET, ADO.NET, VB.NET, WINSCP, Putty, FileZilla.

Tools

Erwin 7.2, Visual Studio 2010/2008/2005, Visio, Visual Source Safe, Toad

Professional Experience

Societe Generale, Chicago, IL Mar 2017 – Till Date

SQL Server BI Developer

Description

Societe Generale is a multinational banking and financial services company headquarters in Paris. The company is a universal bank and has divisions supporting Financial services, Corporate and Investment Banking, Private Banking. The scope of the project is to design and develop data warehouse and migrate the data from different sources and load into data warehouse using SSIS.Updating and changing UC4 connections to the new data and testing all required UC4 changes to comply with the new environment.

Responsibilities:

Created complex SSIS packages using control and data flow elements and scheduled SSIS packages to extract data flowing.

Involved in scheduling the SSIS package to deliver files on a Daily, Weekly and Monthly basis.

Create notification alerts to update clients/Business partners on the successful delivery of the files using UC4.

Involved in writing SQL queries, complex stored procedures, triggers, views, constraints, joins, DDL, DML and user defined functions (UDF) to implement the business logic.

Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Used various control flow tasks such as FTP, bulk insert task, transfer job task and different data flow tasks along with For Loop and For Each Loop containers to create SSlS packages.

Created ETL meta-data reports using SSRS, reports including execution times for the SSIS packages and failure reports with error description.

Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.

Worked in SSRS development from analysing business requirement, designing report, developing report from scratch using SSRS, deploying report and managing report through report manager.

Applied conditional formatting in SSRS to highlight key areas in the report data.

Developed various types of complex reports including drill down, drill through, cross tab reports and involved in designing reports and used delivery methods like standard subscriptions, data-driven subscription and URL access.

Responsible for Analysis, Design, Coding, Debugging and Deployment.

Worked with the team to design, develop, test & implement system.

Extensive use of Visual Source Safe (VSS) for version controlling and source code management.

Involved in Migration of Oracle to Exadata.

Involved in creating Indexes, passing hints, analysing the table statistics and Table partitioning, complex views that require complex joins.

Environment: MS SQL Server 2014/2016, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, Microsoft SQL Server Management Studio(SSMS), Visual Studio, MS Excel 2013, MS Access, MS Excel, & Windows 2003 server, Linux, UC4.

Kiewit, Omaha, Nebraska May 2016 – Feb 2017

SQL Server BI Developer

Description

The project is to create SSIS packages for migrating data to Data Warehouse and generating reports by extracting data from data warehouse for different investors during a month end close. Here we load the input files into data the database and creating output flies for those loaded. This project is also involved the creation of SSIS packages to integrate the data contained in various heterogeneous file systems and SQL Server Database and create reports using SSRS.

Responsibilities

Design and Development of SSIS Packages to import data from Oracle database in form of flat files transform and load data into SQL Server database.

Transformation of Data into SQL Server database by development of views, staging tables, ODS and load data into tables using Stored Procedures.

Upgraded SSIS packages for an entire Application from 2005 to 2008 using Project wizard and successfully deployed packages.

Managed the complete migration of SQL Server 2008R2 to SQL Server 2012.

Used Automated Processing Environment (APE) Application for Automating daily SQL jobs and for execution of packages automatically.

Developed Package labels for test and production environments and execution of SSIS packages.

Provided organizational reporting and timely reports utilizing SSRS.

Using SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.

Development of different types of reports like Parameterized reports, Drill down reports, Ad- hoc reports, Snapshot reports and Sub reports.

Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and snapshotting via SharePoint User Interface.

Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.

Maintained and Supported Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and reports.

Created star schema in SSAS and developed SSRS reports based on the cubes.

Managed Query Optimization and Performance Tuning of Stored Procedures, Functions and several complex queries.

Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems.

Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning.

Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.

Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases.

Scheduled jobs for backup, and created alerts for Error reporting.

Environment: SQL Server 2005/2008 R2/ 2012/2014, Visual Studio 2005/2008/2010, T-SQL, MS Access, MS Excel, SQL Server Integration Services, SQL Server Reporting Services, SharePoint MOSS, VB.Net, C#.Net.

IT Commence, TX Aug 2015-Nov 2015

MS SQL Server Developer/SSIS/SSRS/SSAS

Description:

Client have very huge environment with the landscape of reports scheduled instances per month which are used by end users. These reports have multiple data sources which is leading to poor data quality and performance. The goal of the project is to create a data warehouse by extracting data from various data sources, which will act as single source of data for all reports and dashboards with enhanced performance and data quality.

Responsibilities

Involved in Designing and Developing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems using SSIS.

To maintain and restore the SQL databases across various environments.

Designed SSIS ETL packages to extract and load from different data sources including SQL Server, Flat Files, Excel Files, and XML Files etc.

Developed packages using Control Flow Task like For Loop Container, For each Loop Container, Sequence Container, Execute SQL Task and Data Flow Task to load the Data.

Created Deployment utilities to deploy the package using File System Deployment and SQL Server and Implemented Error handling using Event Handlers and Schedule the SSIS packages through SQL agent jobs.

Designed and Developed Business Intelligence data model using SSAS and created dimension and fact table in Data Warehouse systems.

Generated Ad-hoc reports and designed attractive report pages based on clients' request.

Developed matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using SSRS.

Created Matrix Reports with all aggregate functions and expressions, dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.

Developed T-SQL stored procedures, functions, Views and data load scripts for the product development team.

Created reports in Power BI preview portal utilizing the SSAS Tabular and prepared dashboards using Tableau to make it more attractive.

Followed agile development methodology for development and conducted Scrum meetings.

Environment: MS SQL Server 2012/2014, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio(BIDS), Windows 7/10, T-SQL, Microsoft SQL Server Management Studio(SSMS), Visual Studio, MS Excel 2013.

True Process, India July 2013 – Nov 2014

SQL Server BI Developer

Description:

True Process is an IT consulting firm that provides various services like Development, Consulting, Implementation, Integration and support for Health Care suppliers and end-users. The project is about analysing the day to day transactions and usage of SIGMA drug infusing pumps. This is a Data Migration Project from SQL Server 2000 to 2008 R2.

Responsibilities

Worked with the end users to gather the requirements to build DataMart for inventory management and MDS user interface.

Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.

Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.

Created Source to target mappings, Technical design documents and Conceptual and Physical Models for MDS.

Worked on Master Data Management: Business process design for managing Master Data throughout the lifecycle, including data quality, metadata and workflow technologies.

Implementation experience on SQL Server 2012 Master Data Services and Data Quality Services.

Created business rules and workflows in MDS to maintain quality and accuracy of master data.

Deployment of SSIS packages using visual studio 2012.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS). Designed various operational, drill-through, drill-down, sub reports and parameterized reports and developed these reports using the Global variables, Functions.

Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0 and involved in Migration of SSRS 2005 to SSRS 2008.

Design and Develop new SSAS Tabular models and provide operational support to existing SSAS Tabular models to satisfy business requirements.

Involved in Technical Design Specification Documentations and Data Dictionaries for the related work for each SSAS models.

Developed MDX queries against SSAS Cubes to generate reports for analysis.

Built MOLAP cubes for fast data retrieval and complex calculations.

Designed SSAS Cube and developed MDX queries for Analysis.

Environment: SQL Server 2012 and 2008R2 Enterprise Edition, Teradata, Oracle10G/9i, VB.NET, T-SQL, MDS 2012, MS Access, MS Excel, & Windows 2003 server, Linux, Business Intelligent technologies like SSIS, SSRS, SSAS, Data Quality Services.

Honeywell, India Jan 2011 – May 2013

BI Developer /Business Analyst

Description:

This project involved the preliminary assessment of the Business process, analysing requirements for up gradation and migration. Project mainly focus on data ingress process among all the business units, Data Acquisition, Data standardization and validation.

Responsibilities:

Created and Developed T- SQL queries for data retrieval and created other database objects like tables, views, Stored Procedures, Functions, Triggers and indexes.

Interacted with Team and Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system.

Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.

Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler.

Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Involved in performing database Backup and Recovery.

Worked on Documentation using MS word.

Environment: Windows 2000 Server, SQL Server 2000/2005, Query Analyser, Enterprise Manager, Import and Export, SQL Profiler.

Contact this candidate