Home

Ghanashyam Putta - SQL Data Analyst | Power BI | MSBI(SSIS/SSAS/SSRS) | SQL |

[email protected]

Location: Bristol, Connecticut, USA

Relocation: Open

Visa: H1B

Linked In : https://www.linkedin.com/in/ghana-putta/ Certified Sr. MSBI (SSIS, SSRS, SSAS) / Data Analyst / Power BI/ SQL BI / Tableau Developer SUMMARY Sr. MSBI developer with 11+ years of IT experience in Database Development of SQL Server and Oracle and providing Business Intelligence solutions using Microsoft BI Stack (SSIS, SSRS, SSAS-Multidimensional Cube, Tabular Models, Power BI, Excel-Power Pivot, Power Query) of SQL Server. Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2008/2012/2014/2016/2017/2019. Extensive experience in working with Tableau, OBIEE, Siebel Analytics, SAP Hana, EBS Oracle R12 and Informatica. Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau. Experienced in Star Schema and Snowflake Data Modeling Techniques as well as following Bill Inmon and Ralph Kimball principles in Managing Data marts and EDW Environments. Excellent experience in writing T SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, CTE's, stored procedures, and other advanced SQL concepts. Expertise in Developing and Tuning T- SQL, Oracle PL/ SQL Complex Queries, Stored Procedures, Packages, User Defined Functions, Triggers, Cursors, Views, Indexed Views , Materialized views and error handling techniques. Extensively worked on SSIS to automate ETL Loads / Processes by using Control Flow items (for Loop, execute package, script task, send mail task, etc.,) and SSIS Data Flow items. Experience in creating configuration files to deploy the SSIS packages across all environments. Skilled in SSIS error and event handling: precedence Constraints, Break Points, check points and applying different logging mechanisms. Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports Using Microsoft SSRS and experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems. Worked on SSAS ( SQL Server Analysis Services) to build analytical cubes on Multi-Dimensional and Tabular Models and exposed data for Ad-Hoc Reporting for the end User. Well versed in using multi-dimensional expression (MDX) queries, Mathematical formulas, and User-Defined Functions (UDF) for developing reports from Multi-Dimensional OLAP Cubes. Developed Python script to for processing large data sets and also to extract data from different files. Worked On R Data Wrangling Techniques using R functions and R libraries like Data.table, Tidyverse, dplyr, purr, readxl, broom, lubridate etc. libraries and developed RMarkdown Reports also leveraged them into flexdashboards for more interactivity of statistical Analysis and had scheduled the PDF RMarkdown Reports using RConnect in weekly and Monthly Basis for end users to consume those Reports. Strong experience in creating DAX queries to build formulas and expressions in Microsoft SQL Server Analysis Services, Power Pivot in Excel, and Power BI Desktop. Have an in-depth knowledge of agile, Kanban working environment and have good understanding of Software Development Life Cycle (SDLC) methodologies and principles. Keywords: business intelligence active directory rlang information technology procedural language