Sql Server Data

PROFFESIONAL SUMMARY:

Around * years of professional experience in SQL Server database development, Banking (Financials/ Mortgages), Medical Healthcare and Retail sectors as a SQL server Developer that includes Database Design and Development

Hands on experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, and data integrity.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.

Good Knowledge of SQL Server 2014/ 2012/2008R2/2008.

Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases.

Developed complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, and for Loop Sequence Container.

Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.

Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.

Experience in MS SQL Server configuration, performance tuning, query optimization, back-up and recovery, running Database.

Experienced in developing database scripts (DML/ DDL), stored procedures, views and other database objects necessary to accomplish project objectives.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Good Knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.

Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.

Ability in Creating Drill down and Drill through reports with Drop down menu in SSRS.

Tableau Experience in Enterprise Environment and Tableau Administration.

Strong in Writing User Manuals, Documentation, Proposals and also Good team player.

Good Knowledge on Tableau 9.1 and 10.1

Created interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.

Knowledge in creating and implementing interactive charts, graphs, and other user interface elements.

Technical Skills:

Languages

T-SQL, PL/SQL, C#, Tableau 10.1, 9.1, 8.1

RDBMS

SQL Server 2014/2012/2008R2/2008, MS-Access.

Front End

MS Visual Basics 6.0., Visual Studio 2015, 2012, 2008

Version Control

Visual Source Safe, Clear Case.

SQL Server Tools

SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSRS, Data Transformation Services.

Data Modeling

MS Office Visio 2013/2007

Operating System

Windows 2012, Windows Server 2008

Methodologies

Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

Professional Experience

Matrix Medical Network, Phoenix, AZ Dec 2016 – Till Date

Role: SQL BI Developer

Matrix Medical Network is a health care provider that uses Nurse Practitioners to visit health plan customers in their home or a nursing facility on behalf of health plan providers. This project is designed to build an Enterprise Data warehouse which acquires data from different data sources

Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.

Designing and developing new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages by using Visual Studio 2015.

Set up ETL Jobs to run on a daily basis in SQL Server Agent using SQL Server 2014.

Created many complex Stored Procedures/Functions and used them in SSRS Reports directly to generate reports on the fly.

Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.

Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.

Knowledge in design and development of Tableau visualization Solutions.

Development and assisting users in creating and modifying worksheets and data visualization dashboards by using Tableau 10.1

Created drill down and drill up in worksheets in Tableau Dashboard.

Developing a Dashboards and preparing ad-hoc Reporting.

Developed complex SQL queries for creating BI layer on DW for tableau reporting

Environment: Windows 7, Tableau 10.1/ 9.1, MS SQL Server 2014/2012, SSIS, SSRS, T-SQL, SharePoint Portal Server 2010, ETL, MS Office 2010/2013, Visual Studio 2015

Health Net Federal Services, May 2016 – Nov 2016

Rancho Cordova, CA

Role: SQL BI Developer

Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently by using SSRS.

Worked on EDI 835, 837 Inbound and Outbound.

Developing and maintain EDI training manual and system documentation.

Working on experience with permissions, Security, User/User group setup.

Creating Extracts and scheduling them to increase performance of the dashboards.

Monitoring User activity, server performance and user licensing.

Designing and development of Metadata Driven SSIS packages for Data Warehouse for Data moving and Summarization in a Reporting Data Mart.

Developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP

Developing highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, and For Loop Sequence Container.

Creating Database Objects like Tables, Views, Stored Procedures.

Set up ETL Jobs using SSIS to run on a daily basis in SQL Server Agent.

Matrix Medical Network, Aug 2015 – May 2016

Phoenix, AZ

Role: SQL Server SSIS/ Report Developer

Responsibilities:

Published Workbooks by creating user filters so that only appropriate teams can view it.

Analyzed the source data and handled efficiently by modifying the data types.

Worked on security configuration, setup of Sites, Workbooks, Views and Data sources in SSRS.

Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.

Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Hands on experience with permissions, Security, User/User group setup.

Creating Extracts and scheduling them to increase performance of the dashboards.

Designing and Development of ETL Process (SSIS) for integrating data from sources like Excel, CSV, Flat Files, Web Services, XML Source and SQL Server.

Designing and developed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages

Generated Tableau reports with Trend lines.

Created Database Objects like Tables, Views, Stored Procedures.

Responsible for testing of SQL Code, SSIS Packages using MS SQL Integration Services 2008.

Responsible for Scheduling and maintaining reporting and SSIS data load Jobs.

Environment: Windows 7, Tableau 8.0/ 8.1, MS SQL Server 2012,2008R2, SSIS, SSRS, T-SQL, SharePoint Portal Server 2010, ETL, MS Office 2010/2013.

Micron,

Boise, Idaho Dec 2014-July 2015

Role: SQL SSIS/SSRS/Support Role

Responsibilities:

Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008/2008R2/2012 and Worked with users in training and support and also have experience in incremental data loading.

Managed up gradation of DTS packages to SSIS packages

Responsible for developing, monitoring and deploying SSIS 2012/2008R2/2008 packages.

Created various Weekly and Monthly reports showing detailed information in SSRS.

Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language.

Most of my work with Issue Support Role. And also worked on BMC Remedies.

Used Active Directory for Identity management designed to provide strong authentication and authorization for internal and external websites.

Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.

Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.

Environment: MS SQL Server 2012/2008R2/2008, SQL SSIS, SQL SSRS, T-SQL, Visual Studio 2012

Sriven Infosys, NY May 2012-Aug 2013

Role: SQL BI Developer

Responsibilities:

Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.

Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.

Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Installed and configured MySQL on Linux and Windows environments.

Created Queries in T-SQL, Stored Procedures, Clusters and Views to store the data of clients, advisors. worked with multivalve parameters for parameterized reports in SSRS.

Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.

Conducted the Error handling in SSIS (ETL) using the Event Handlers.

SSIS to create ETL packages and validate, extract, transform and load data to data warehouse databases, data mart databases.

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 Environment and extracted the data using SSIS from OLTP to OLAP.

Developed PL/SQL triggers, procedures, functions and packages for the various interfaces.

Generated ad-hoc Tableau reports on demand for providers.

Experience in Handling premium billing, commissions, capitation, and reporting by using Facets.

Generated Parameterized Reports and cascaded Parameterized Reports.

Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.

Worked on up gradation of Database from SQL Server 2008R2 to 2012.

Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.

Environment: SQL Server 2008/2008R2 Enterprise Edition, T-SQL, SSIS, SSRS, Visual Studio 2008

Education:

Masters in Computer Science and Engineering from Valparaiso University, IN

Contact this candidate