Email: adkshf@r.postjobfree.com Mobile: +1-480-***-****

Location: 2915 Sunflower Park Pl, Richmond, Texas – 77406 SUMMARY:

Over 3+ years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2016/ 2012/2008R2 in various domains including health care and insurance.

Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2013/2016.

Extensive experience on RDBMS, Data warehousing concepts, OLTP & OLAP Web based and Windows applications using VB. NET, ASP. NET, ADO. NET.

Excellent in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration creating Indexed Views, complex Stored Procedures, Triggers.

Strong experience in using T-SQL in SQL Server 2005/2008/2012/2014, creating Tables, Stored Procedures, Indexes, Triggers, User Defined Functions.

Thorough understanding of Kimball strategies, KPI, Data mining structures.

Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.

Experienced in application design and development using Azure services. TECHNICAL SKILLS:

RDBMS: MS SQL Server 2016/2012/2008R2/2008, MySQL, PostgreSQL. Programming Languages: Python, C#, SQL, PL/SQL, R Language, JMP, Minitab. Development Skills: T-SQL, PL/SQL, MS-Access 2000, SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), SQL Server Integration Services (SSIS). Reporting Packages: SQL Server Reporting Services (SSRS), MS Excel. BI Tools: Power BI, .Net, Oracle BI, Tableau Server, T-SQL, MS Project, MS Dynamics, MySQL, Looker, Tableau, Power BI.

ETL Tools: Informatica PowerCenter, Azure Data Factory, Oracle Warehouse Builder, Microsoft Azure, Microsoft-SQL Server Integrated Services (SSIS). Operating Systems: Erwin 8.0/7.2/7.1, MS Visio 2010/2007/2005, Visual Studio 2012/2008R2/2008/2005/2000.

PROFESSIONAL EXPERIENCES:

Care Source Dayton, OH June 2019 – Present ETL MSBI Developer

Created Database Objects like Tables, Stored Procedures, Views, Triggers, UDFs and adding/changing tables for data load and transformation and extraction.

Created complex queries involving CTE’s, Sub-queries and Joins and with the used of SSIS packages we are pulling data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer load (ETL) existing data into SQL Server 2014 from different environments for the SSAS cubes.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.).

Using SSRS like different types of Tabular Reports, Matrix Reports, drilldown reports and drill through.

Exposure to Azure cloud solutions and created Dashboards and other virtualization reports using Power BI.

Environment: MS SQL Server 2014/2012, Power Pivot, Power BI, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Tableau, Erwin 8.0.

Easy IT Solutions Charlottesville, VA Aug 2018 - Jun 2019 MS SQL Server BI Developer (Intern)

Worked as a SSRS Reports Developer/Administrator and SQL Server Developer in support of Service Management System.

Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.

Designing and developing software applications with ASP.NET 4.0/3.5/3.0/2.0, ADO.NET, AJAX, LINQ, WCF, Web Services, SOAP, .NET Remoting.

Used C# scripts in SSIS script task to run custom scripts in package flow.

Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.

Created Power BI Visualizations and Dashboard as required.

Performed user acceptance testing on new and modified reports.

Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.

Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.

Environment: Microsoft SQL Server 2008, Visual Studio 2008, Power BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS). Sunraysys Solutions Pvt Ltd India May 2016- June 2017 SQL Server/BI Developer

Responsible for Data Modeling based on the client requirements and daily maintenance.

Design and implementation of SSIS/ETL process for the system.

Data conversion from mainframe system and Oracle databases to SQL server.

Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.

Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles. Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, drill down reports using SSRS.

Responsible for Deployment of the report-to-report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.

Modified stored procedures to meet current design and used them in SQL Server.

Moving data from SQL server to Dynamics CRM and initial entity creation. Environment: MS SQL Server 2012/2014, MS dynamics 2013/2015, Red Gate tools, PowerPivot, TFS 2013, Agile/SCRUM SharePoint 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

EDUCATIONAL QUALIFICATIONS:

Master’s in Industrial Engineering Arizona State University August, 2017 – May, 2019.

Bachelor’s in Mechanical Engineering University of Mumbai August, 2012 – May, 2016.