Kalyan Chakravathi Email & Phone Number

● Over 4+ years of experience in MS SQL Server suites of products like SSRS, SSAS and SSIS of MS SQL Server 2016/2014/2012/2008.● Expert in ETL(SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word and Text Format Data.● Experience in using SSIS Import and Export Wizard, SSIS designer and other package execution utilities for performing the ETL operations.● Experience with Power BI data modeling, visualization, and reporting.● Ability to create custom visuals and templates using Power BI.● Strong knowledge of SAS programming, including data manipulation, analysis, and reporting.● Hands on Experience in SSIS Configuration, Logging, Procedural Error Handling and Data Error Handling.● Involved in complex data mapping, modeling data and understanding business data relationships.● Experience in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All and Slowly Changing Dimension.● Experience in creating various SSIS packages, troubleshoot errors and creating alerts using Send Mail tasks.● Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and power pivot.● Experience in designing reports using SQL Server Reporting Services, generated drill down report, parameterized report, linked report, sub reports, matrix dynamic and filter charts in SSRS.● Expert in presenting multi-platform data visualization like pie/bar/graph chart and Dunda’s chart.● Designing SSAS cube, writing MDX Queries, used Partition to manage and store the data and Translation. Deploying and processing SSAS cube.● Experienced in developing OLAP Cubes, Dimensions using SQL Server Analysis Services (SSAS)● Good SQL Server Administration skills including backup recovery, database maintenance, user authorization, Database creation, Tables, Indexes and Partitions. ● Experience in creating Data Marts, Operational Data Store (ODS), OLAP and Dimensional Data Modeling for FACT and Dimension Tables using Analysis Services.● Experience in implementing the Indexes such as clustered index, non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.● Experience in writing Subqueries, Joins, T-SQL queries to create database objects and to simplify complex queries involving different tables, and to create relationships between tables using foreign key and primary key.