Koutil Gujjari

Mobile: +1-330-***-****

E-Mail: ac4ay1@r.postjobfree.com

* ***** ** *********** ********** experience in all phases of Software development life cycle including Database administration, Data Analysis and Business Intelligence.

Extensive experience in advanced SQL Queries and T-SQL in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures, functions, Joins, clustering, T- SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.

In-depth knowledge of T- SQL (DDL, DML), Designing and Normalization techniques on the database tables.

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

Expertise in using SQL on Oracle, MS SQL Server and MySQL.

Extract data from access, excel, flat file, and different data base and load in SQL data base using SSIS packages and ETL

Worked extensively on Power BI and created Reports/Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc. to make it more attractive and explored data in a Variety of ways and across multiple visualizations using Power BI.

Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI.

Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.

Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI Service.

Created many calculated columns and measures using DAX in Power BI based on report requirements and published Power BI reports to end user via mobile.

Navigated file systems and other structures using PowerShell.

Wrote simple PowerShell command line scripts.

Also have a clear understanding of PowerShell scripts

I also have some experience in Azure.

Education:

Master’s Degree in Computer Science Engineering

Kent State University, Ohio, USA

Bachelor’s Degree in Computer Science Engineering

Vignana Bharathi Institute of Technology, India

Skills:

RDBMS

SQL Server 2012/2014/2016, MySQL, Oracle

Programming Languages

T-SQL, Oracle, DAX, C, C#

BI Tools

SSIS, SSAS, SSRS, Power BI

Development tools

SQL Server Management Studio, MS Visual Studio

Operating Systems

Windows 2007/2008, Unix

Office Tools

MS Office (Excel, PowerPoint, MS Word)

Professional Certification and Accomplishments:

Certified by Microsoft in Analyzing and Visualizing data with Power BI

https://courses.edx.org/certificates/f1314b3a412948a38e560d11bf30bb80

Professional Experience:

Company: Quadrant Resource/Microsoft, WA, U.S.A (Nov 17 - Present)

Role: SQL/Power BI developer

Responsibilities:

Created Visualizations with drill down, drill through features in Power BI

Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI

Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers

Used analytics to get the trend and forecast for reports

Knowledge of publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets

Knowledge of managing security and metrics of the data presented using the Admin portal

Knowledge of notifications and alerts, subscriptions to reports in the Power BI service

Conducted audit on SQL Databases

Worked on writing complex SQL queries, Sub queries, and nested queries in the process of analyzing the data to solve specific business problems

Company: Lenora Systems, WA, U.S.A (Jan 17 – Oct 17)

Role: SQL/Power BI developer

Project Description: The project “TEKZENIUS” is a global platform for learning and teaching online. It offers an interactive and innovative way of teaching online. Using this, students can register for their desired courses and instructors and register as a trainer. This helps students to pursue wide variety of courses. Students can view their course material and recorded classes online for the courses they have registered.

Responsibilities:

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints

Experience in writing complex TSQL queries, User Defined Functions, store procedures and views

Experience in Normalizing/DE normalizing the tables

Navigated files systems using PowerShell

Responsible for extracting the data from OLTP to OLAP using SSIS

Worked with various tasks and transformations in Control flow and Data flow items

Developed SSIS packages that can extract data from different sources and merge into one single source

Implemented advanced data cleansing in SSIS using Derived Column, Fuzzy Lookup, Fuzzy Grouping

Worked with various data transformations like Merge, Sort, Conditional Split and Multicast

Modified existing SSIS packages according to the current business needs

Experience in working with both Multidimensional and Tabular models

Designed Data source views by selecting tables from different data sources and responsible for establishing relationships between them

Experience in creating named Queries and Named calculations in Data source views

Created SSAS cubes using various dimensions and measure groups

Worked on performance tuning of SSAS cubes by creating partitions and hierarchies

Responsible for creating calculated members using MDX queries

Created complex calculations, Aggregations and actions on the cubes as per end user requirements

Developed various types of Reports like Tabular, Matrix, and Charts using SSRS

I also used to manage Power BI report data refreshes by using Power Shell

Experience in creating different visualizations and dashboards using Power BI

Environment: Windows 2010, SQL Server, MySQL, T-SQL, MS Office, Visual Studio, SQL Server Management Studio, SSIS, SSRS, SSAS and Power BI.

Company: SAAS Pro Software Solutions, Hyderabad, India (Jan 14 – Nov 2015)

Project Name: Prediction manager

Role: SQL Developer

Description: Prediction manager is an Excel Add-in budgeting tool which is used for forecasting and budgeting for the future Quarters.

Responsibilities:

Created custom filters queries where the users can easily create, edit, update and delete data as per their needs

Wrote code using SQL to add data to a workbook from the SQL server when it is saved

Built and run the project to test it

Cleaning up the completed project so that the VSTO Add-in no longer runs automatically on your development computer

Updated server data to a temporary database table and then use a stored procedure to update a source database table using the temporary table

Environment: Windows 2008, SQL Server 2014, T-SQL, Visual Studio 2014, SQL Server Management Studio, SSIS.

Contact this candidate