Sql Server Manager

Keerthi Kottha

Ph: 630-***-****

*******@*****.***

SQL BI/Power BI Consultant

CAREER SUMMARY:

A Microsoft Certified Professional with over 6+ years of experience in Design, Development, Implementation, Reporting, and Analytics in OLTP/ETL environments using MSSQL Server 2016/2012/2008R2 across all SDLC environments

Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions

Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models

Very Good Experience in Business Intelligence applications using DTS/SSIS/SSAS/SSRS

Handled ETL process development, implementation and support for Terabyte+ data warehouse environments

Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert utilities

Extensively worked on upgrading DTS SSIS packages and Involved in Development, Deployment, and support of SSIS packages

Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors

Extensive experience in creating enterprise reports using SSRS 2008/2016 using Report Manager, Report Builder, and BIDS

Created many Drill Through, Drill Down, Parameterized reports using SSRS 2005/2008

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs

Expertise in Power BI, Power BI Pro, Power BI Mobile

Expert in creating and developing Power BI Dashboards in to rich look

Experienced in developing WCF (Windows Communication Foundation) Services and Web Services using C#.NET

Excellent knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX

Experience in designing, building and deploying Cubes with Star Schema and Snowflake Schema using SQL Server Analysis Services (SSAS 2005/2008)

Expert in calculating measures and dimension members using MDX, mathematical formulas, and user-defined functions

Have hands on experience in Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks

Extensively worked in Migration for MS SQL 2000 to MS SQL 2005 to MS SQL 2008

Worked with different types of Replication Models like Transaction, Snapshot, and Merge

Experience working with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor

Hands on Experience working with Oracle databases

Excellent Communication skills, Analytical skills and Team Player

TECHNICAL SKILLS:

Languages

SQL, T-SQL, PL/SQL, C, C++, HTML, DHTML, XML

RDBMS

MS SQL Server 2016/2012/2008 R2, MS Access, Oracle 9i and 10g

Database Tools

SSRS, SSIS, SSAS, DTS, BCP, Business Intelligence Studio(BIDS), Query Analyzer, SQL Management Studio, SQL Server profiler, SQL Enterprise Manager, Power BI

Operating Systems

Windows 98/2000/XP/NT/Vista, Windows 2000/2003 Advanced Servers, UNIX

Architecture

Relational DBMS, Client-Server Architecture

Version control Tools

Team Foundation Server, Visual Source Safe

Other Tools

Crystal Reports, Microsoft Visual Studio 2003/2005

PROFESSIONAL EXPERIENCE:

Infodat Inc, Houston, TX Feb 2017 – Present

Sr. SQL Server BI/ Power BI Developer

Infodat provide services to major healthcare firms mainly Cardinal Health and New Century Health. Infodat helps in transforming their raw data into an intelligent enterprise information platform that provides intelligent, real-time information to help make better decisions. Infodat also provides on-time analytical insights to their clients that help sharpen all their business decisions.

Roles and Responsibilities:

Installation of SQL Server on Windows 2010 Advance Server

Involved in Installation and Configuration of MS SQL Server 2016

Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems

Designed and documented the entire Architecture of Power BI proof of concept

Developed Power BI reports and dashboards from multiple data sources using data blending

Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports

Expertise in writing complex DAX functions in Power BI and Power Pivot

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning

Published Power BI Reports in the required organization and made Power BI Dashboards available in Web clients and mobile apps

Scheduled Automatic refresh and scheduling refresh in Power BI Service

Utilized Power BI gateway to keep dashboards and reports up-to-date with on premise data sources

Implemented code check-in/check-out and managed multiple versions of complicated code within Team Foundation Server (TFS)

Contributed in the development of knowledge transfer documentation

Responsible for creating SSIS packages to extract data from various sources consolidate and merge into one only source

Used various transformations while creating SSIS packages such as Derived Column, Data Conversion, Lookup, Union All, Merge Join, Conditional Split etc

Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers

Responsible for creating the Tables, Views, Stored Procedures, Cursors, Triggers

Participated in creating Indexes to improve the performance of database

Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries

Created Constraints and Views

Used Data Transformation Services (DTS) to export and import data

Assisted in taking database backup and restored them and resolved issues related to it

Used SQL server profilers to trouble shoot the issues and checked the activity of the SQL server

Involved in creating users and assigning permissions to access the database

Experience in documenting the codes for easy understanding in future

Environment:

MS SQL Server 2016, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, Power BI, Power Pivot, Power Map

Jvion, Johns Creek, GA Apr 2015 – Jan 2017

SQL Server/BI Developer

Jvion use data to change the way it looks at and deliver healthcare. It started a revolution that helps providers protect lives while protecting their revenues and it will continue this transformation through an approach that combines the latest machine intelligence and healthcare expertise with a lot of ingenuity.

Roles and Responsibilities:

Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer

Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server – Using Stored Procedures, Triggers, User-defined Functions, Views, and Cursors

Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems

Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations

Involved in query tuning by creating Cluster and Non-Cluster Indexes on the tables, also used Index Tuning Wizard (ITW) for enhancing the query performance

Written complex Stored Procedures using temporary tables

Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Derived Column, Lookup, Merge Join, Conditional Split, Slowly Changing Dimension, and Data Conversion etc.) in SSIS packages

Used event handlers for error handling includes (On Pre-Execute, On Post Execute and On Error)

Implemented SSIS package configuration files in SQL Server, XML files, Environment Variables and Parent Package Variables

Implemented Package logging in both standard (SQL Server and file based) and custom logging using customer Stored Procedures and tables

Involved in development, deployment, scheduling, and troubleshooting SSIS packages

Involved in troubleshooting Complex SSIS Packages and Production Support tasks

Implemented Standard and Custom SSIS Package logging in SQL Server tables and text files

Used SSIS Package Configurations stored in XML files and SQL Server Tables

Involved in installation, reporting services configuration, maintenance, deployment and troubleshooting SSRS reports in (2005/2008)

Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports, Drill Down, Drill Through, and Chart reports using complex data set queries, Stored Procedures, Views in SSRS 2005/2008

Generated and formatted reports using Global Variables, Expressions, and Functions

Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded parameters

Developed complex Report Models which provides ability to the users to create their own reports using Report Builder and save it in the Report Manager. Also, created Linked reports to optimize redundancy of the reports on the report server

Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC environments

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF, MS Word (from 2008), and Excel formats using SSRS 2005/2008

Involved in creation of create and edit views in the CIS and Involved in the creation of the Composite views and publish each view to make it available to client applications that connect to the server through JDBC and/or ODBC

Created reports using time intelligence calculations and functions

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily

Executed dashboard setups and data manipulation using DAX

Wrote Calculated Columns, Measures query’s in Power BI Desktop to show good data analysis techniques

Weekly presentation to the business users about the reports and their changes as required

Environment:

MS SQL Server 2012, SSRS, SSIS, T-SQL, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005, Crystal Reports, Power BI, DAX

WCA, Houston, TX Nov 2014 – Feb 2015

SQL Server/BI Developer

WCA is a vertically integrated non-hazardous solid waste management company providing waste collection, transfer, material processing and disposal services. WCA commenced business operations in 2000 in Houston, Texas and has expanded under the guidance of a veteran management team to cover twelve states.

Roles and Responsibilities:

Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer

Wrote user requirement documents, created technical specs and design documents for various projects

Written complex Stored Procedures using temporary tables

Hands on experience in using DDL Triggers (After and Instead of Triggers) to keep track of data manipulations using Audit functionalities

Worked with several Control Flow Tasks, Data Flow Tasks and Transformations in SSIS packages

Implemented SSIS package configuration files in SQL Server, XML files, Environment Variables and Parent Package Variables

Implemented Package logging in both standard (SQL Server and file based) and custom logging using customer Stored Procedures and tables

Involved in development, deployment, scheduling, and troubleshooting SSIS packages

Implemented Standard and Custom SSIS Package logging in SQL Server tables and text files

Used SSIS Package Configurations stored in XML files and SQL Server Tables

Involved in Monitoring and Deployment of SSIS Packages across DEV, UAT, SIT and Production environments using DTEXEC Utility, command prompt with .bat files etc

Responsible for writing test plans

Used WCF in implementation of internal messaging

Used WCF in communicating the internal portfolio managing system.

Data was exposed to the Web as XML and transformed using XSLT to display the reports.

Involved in installation, reporting services configuration, maintenance, deployment and troubleshooting SSRS reports in (2005/2008)

Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports, Drill Down, Drill Through, and Chart reports using complex data set queries, Stored Procedures, Views in SSRS 2005/2008

Created Ad-hoc reports more often based on end user requirements

Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded parameters

Developed complex Report Models which provides ability to the users to create their own reports using Report Builder and save it in the Report Manager. Also, created Linked reports to optimize redundancy of the reports on the report server

Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC environments

Involved in publishing views to the newly created CIS database

Environment:

MS SQL Server 2005/2000, SSRS, SSIS, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio 2005, Crystal Reports, C#, ASP.NET, ADO.NET, XML

Maximus Coffee Group, Houston, TX Dec 2013 – Oct 2014

SQL Server/BI Developer

Maximus Coffee Group is the premier coffee and related products manufacturing group in North America, providing the most integrated, world-class services and products at the highest quality and value to its long-term clients.

Roles and Responsibilities:

Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer

Extensively studied the existing OLTP system(s) to create data mart and warehouse systems using the facts, dimensions and star schema

Wrote user requirement documents, created technical specs and design documents for various projects

Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server – Using Stored Procedures, Triggers, User-defined Functions, Views, and Cursors

Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems

Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations

Written complex Stored Procedures using temporary tables, table variables, error handling (TRY & CATCH) methodology for data loads

Hands on experience in using DDL Triggers (After and Instead of Triggers) to keep track of data manipulations using Audit functionalities

Involved in development, deployment, scheduling, and troubleshooting SSIS packages

Involved in complex SSIS package development with Microsoft BI standards and Development strategies to pull data from various data sources such as (SQL Server, Oracle, DB2, Excel, and Flat file etc.)

Participated in upgrading from dts (MS SQL 2000) to dtsx (SQL SERVER 2005) packages and from (2005) dtsx to (2008) dtsx

Involved in Package deployment to DEV, TEST and Production for both SQL Server and File system using DTUTIL, DTEXEC, .bat file, using Manifest file and using 3rd party tools like BIDS Helper

Involved in SSIS package scheduling using SQL Agent jobs and using tools such as Windows Scheduler and Control M

Involved in installation, reporting services configuration, maintenance, deployment and troubleshooting SSRS reports in (2005/2008)

Created complex reports like Table reports, Matrix reports, Cascaded reports, Sub reports, Drill Down, Drill Through, and Chart reports using complex data set queries, Stored Procedures, Views in SSRS 2005/2008

Generated and formatted reports using Global Variables, Expressions, and Functions

Involved in developing parameterized reports using Single Valued, Multi Valued and Cascaded parameters

Developed complex Report Models which provides ability to the users to create their own reports using Report Builder and save it in the Report Manager. Also, created Linked reports to optimize redundancy of the reports on the report server

Involved in Configuring and deployment of all the Reports (RDL, RDS) across various SDLC environments

Implemented Reports subscriptions using both data driven subscription and time driven subscriptions

Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF, MS Word (from 2008), and Excel formats using SSRS 2005/2008

Involved in building the Cubes for various departments and monitored cube loads and refreshes (Process full and Incremental loads)

Designed dimensions and cubes with star schema and snowflake schema

Designed and developed more than 100+ enterprise reports (SSRS/Crystal Reports) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources

Environment:

SQL Server 2000/2005/2008/2008 R2 Enterprise Edition, SSIS, SSRS, SSAS, Oracle 9i and 10g, .NET Framework, C#, ASP.NET, ADO.NET, Crystal Reports, Erwin, T-SQL, Java, J2EE, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access, Visual Studio 05

CareFirst BCBS, Owings Mills, MD Aug 2012 – Oct 2013

SQL Server/BI Developer

CareFirst, Inc. is the not-for-profit, non-stock, parent company of CareFirst of Maryland, Inc., and Group Hospitalization and Medical Services, Inc., affiliates that do business as CareFirst BlueCross BlueShield. CareFirst is a regional leader in providing health care coverage and related services throughout the Maryland, Washington D.C., and Northern Virginia areas.

Roles and Responsibilities:

Involved in Installation and Configuration of MS SQL Server 2005/2008

Responsible for developing Stored Procedures, Triggers, Views, and User defined functions for all the database change requests

Fine tuning of stored procedures to improve the performance using best coding practices, proper indexes and ANSI standards

Wrote database triggers in T-SQL for auditing and integrity checks on the database

Used TRY–CATCH error handling methodology to report errors

Responsible for writing some PL SQL queries, triggers and packages to be used on Oracle databases

Monitored and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases

Responsible for creating SSIS packages to extract data from various sources consolidate and merge into one single source

Used various transformations while creating SSIS packages such as Derived Column, Data Conversion, Lookup, Union All, Merge Join, Conditional Split etc

Used DTS packages to implement Extraction, Transformation and Load (ETL) and scheduled the packages using SQL Server Agent and other 3rd party tools

Involved in development of ETL Scripts extracting, transforming and loading (ETL) into enterprise data warehouse system and corresponding data marts

Wrote stored procedures to be used in the SSIS packages

Involved in SSIS package deployment to both SQL Server and File system using .bat file, DTUTIL and manifest file

Generated weekly, monthly and quarterly reports using SSRS Reports and scheduled delivery of reports through Emails

Developed appropriate layout and designs for required reports using the SSRS and Stored procedures to retrieve data from the SQL Server using appropriate SQL language (PL/SQL, T-SQL) to provide optimal performance

Involved in Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill Through functionality and Graphical representation for effective analysis

Created Tabular reports, Matrix reports, List reports, and Sub reports using SSRS

Used complex expressions to Calculate, Group, Filter, Parameterize and Format the contents of the report per the business requirements

Used Conditional Formatting to change the behavior of the report depending on the requirements

Worked on Custom Development in reporting services using Custom code, Functions, Class libraries, Data processing extensions and generating RDL

Scheduled report delivery in formats like PDF, Excel, CSV, Microsoft Word and text files by creating subscriptions on the report server to business users as a mail attachment

Generated Reports that can handle dynamic grouping and dynamic sorting for efficient and clear viewing the reports

Involved in SSRS Reports deployment to report server and maintenance

Migrated and Converted over 200 Crystal Reports to SQL Server Reporting Services (SSRS)

Involved in the code review sessions and reviewed cubes, changed the cubes and documentation per the requirement based on evaluation and revenue opportunities using SSAS

Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS)

Extensively involved in the SSAS storage methods (MOLAP, HOLAP, and ROLAP), partitions, aggregations, calculation of queries, data mining models, developing reports using MDX and SQL

Environment:

MS SQL Server 2008R2, SSRS, SSIS, Oracle 9i and 10g, Business Intelligence Development studio, T-SQL, Crystal Reports, Visual source safe, Visual studio 2005, Erwin, Java, J2EE, MS Excel, MS Access

EDUCATION:

Bachelor’s Degree in Information Technology from JNTU, AP, India

CERTIFICATIONS:

Microsoft Certified Technology Specialist in SQL Server 2008

Microsoft Certified IT Professional – Business Intelligence

Contact this candidate