Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kishore Sakamuri

Stamford,U.S.A

Summary

Having 10 years of experience in designing and implementing data warehousing solutions using SQL Server, SSIS, SSAS, and SSRS. Proficient in developing interactive Power BI dashboards and reports, enabling data-driven decision-making across various business functions. Experienced in leveraging Azure services, including Azure Data Factory and Azure SQL Database, to build scalable and efficient data integration and transformation pipelines. Demonstrated ability to collaborate with cross-functional teams to gather requirements and deliver customized BI solutions that enhance operational efficiency and provide actionable insights. Strong experience in Software Development Life Cycle(SDLC) including Requirements Analysis, Design.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Lead BI Specialist

Charter communications
Stamford, CT
12.2023 - Current
  • Worked closely with various teams across the company to identify and solve business challenges
  • Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation
  • Import data from different data sources to create Power BI reports and Dashboards
  • Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements
  • Transform, define, navigate the data from data source and performed merge and append queries using Power Query
  • Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX
  • Performed different types of context like Row context, filter context and query context using Power BI Desktop
  • Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query
  • Performed Query Folding using Power Query to filter data in the data source server
  • Created different chart types and drill down, Drill Through reports using Power Bi Desktop
  • Involved in defining report layout in SSRS
  • Created complex SSAS cubes with multiple fact measure groups and multiple dimensions hierarchies in SQL server
  • Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI
  • Published reports and visualizations to Power BI Service and thereby created dashboards
  • Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc
  • Designed and developed comprehensive financial dashboards in Power BI to monitor key performance indicators (KPIs) like revenue, profit margins, cash flow, and cost analysis
  • Utilized various chart types (bar charts, line graphs, heatmaps) to visualize trends and identify anomalies in financial data
  • Performed data cleansing and transformation using Power Query to ensure data accuracy for financial analysis
  • Built data models using DAX calculations to create calculated measures and KPIs relevant to financial reporting
  • Analyzed financial data to identify trends, patterns, and correlations for strategic decision-making
  • Utilized DAX calculations to create custom financial metrics like 'customer lifetime value' and 'return on investment' for targeted marketing campaigns
  • Streamlined financial reporting process by automating the generation of weekly P&L statements, enabling faster decision-making by management
  • Improved financial reporting efficiency by automating data aggregation and visualization
  • Enabled data-driven decision making by providing timely and actionable insights to leadership
  • Used Power BI Gateways to keep the dashboards and reports up to date
  • Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements
  • Experience in generating on-demand and scheduled reports for business analysis or management decision
  • Used recently introduced Power BI to create self-service BI capabilities and use tabular models
  • Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests
  • Shared the created workspace across the organization using Power BI Apps
  • Responsible for creating Row-Level Security (RLS) based on the business requirements
  • Environment: Power BI desktop, Power BI Server, Power BI Publisher, MS SQL server, Azure Cloud, Azure SQL Server, Azure Data Warehouse, Snowflake, Informatica, and MS Excel

SR Data Analyst

CIO Accenture
Hyderabad, India
04.2019 - 07.2022
  • Designed, developed, and optimized data pipelines and ETL processes using Databricks, Spark, and other tools to handle large-scale data processing
  • Developed a comprehensive Power BI dashboard to monitor sales performance across regions, utilizing DAX for advanced calculations and data insights
  • Built a Power BI solution to automate compliance reporting, ensuring adherence to FR Y-14 and other regulatory standards
  • Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the SQL Activity
  • Managed extraction, transformation, and loading (ETL) processes with Azure Data Factory, T-SQL, Spark SQL, and U-SQL, processing data from various source systems into Azure Data Storage
  • Implement data security measures including encryption, data masking, and access control using Azure IAM, Azure Key Vault, and Azure Policy
  • Implemented OOP design patterns such as Strategy and Decorator to solve complex business logic and enhance code flexibility
  • Architected multi-tier applications by leveraging OOP principles to separate concerns and promote scalability
  • Used Azure Key Vault for managing and protecting sensitive data such as encryption keys and secrets
  • Used Pig as ETL tool to do transformations, joins and some pre-aggregations before storing the data into HDFS
  • Used python and shell scripts to automate Teradata ELT and Admin activities
  • Developed Databricks ETL pipelines using notebooks, Spark DataFrames, Spark SQL and python scripting
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary tables to support Power BI and Tableau reports
  • Created Power BI and Tableau visualizations and dashboards as per requirements, providing comprehensive and interactive reporting solutions
  • Incorporated Power BI to enhance data visualization and reporting, creating dynamic dashboards and reports that provided actionable insights and improved decision-making
  • Actively participating in Agile ceremonies such as daily stand-ups, sprint planning, sprint reviews, and retrospectives to ensure alignment with team goals and continuous improvement
  • Environment: MS SQL Server 2016/2014, SQL server integration services(SSIS), SQL Server Reporting Service(SSRS), Visual Studio 2012, Python, Azure Data Factory, Azure Data lake, Azure Blob, Power BI, Tableau, Shell script, Databricks, Qlik View, Qlik Scence, Jenkins, Azure Key Vault, RDBMS (SQL Server, MongoDB), Docker, Kubernetes, Python

Senior BI Developer

CIO Accenture
Hyderabad, India
02.2017 - 03.2019
  • BI solution and development, involving data integration, cleaning, data modeling, DWBI development
  • ETL creation to integrate, filter and transform data set from multiple source systems using SQL Server integration services
  • Creating dashboard using SSRS, Power BI reporting tools End-to-End solution delivery from requirement gathering, Extraction Transformation and Loading (ETL), BI platform creation and data visualization and reporting
  • Analyzing business requirement/queries and development of metrics/KPIs to report business state and performance
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary tables to support Power BI and Tableau reports
  • Created Power BI and Tableau visualizations and dashboards as per requirements, providing comprehensive and interactive reporting solutions
  • Design, Development of T-SQL scripts, Database design and query optimization
  • Weekly reporting of Project tasks to Management
  • Environment: Windows Server 2006, Toad, SQL Developer, SQL
  • Loader, .NET application Monitoring, UNIX/LINUX

BI Developer

British Telecom
Mumbai, India
12.2014 - 01.2017
  • Used transformations inside the data flow task like Derived column, Lookup, Audit, Conditional Split, Data Conversion, Sort, Union All, Merge, Merge Join, and Slowly Changing Dimension to achieve the business requirements
  • Used different tasks in control flow like Sequence Container, For Loop Container, For each Loop Container, Bulk insert load, Data flow task, Execute package task, Execute SQL task, File system task, Send mail task
  • Created and used user defined variables, logging, and configurations for the package as per the requirement and involved in deployment
  • Having good knowledge on creation and scheduling of SQL server agent jobs to run daily ETL's
  • Worked on Generating reports like drill through, drill down, table, matrix, parameterized and charts using SSRS and deploying the reports
  • Creation of Sql External Tables, Views, Triggers, Procedures and Directories as per the requirement
  • Testing and Integrating the Provisioning adapters with the Clients applications
  • Scheduling the monthly, weekly, daily, hourly reports after the month end bill generation
  • Scheduling the business process actions like disconnections, reconnections and renewals as per clients wish based upon the customers status
  • Configuring the monthly Statement of Account reports to the customer’s personal email through the application
  • Environment: MS SQL Server 2016/2014, SQL server integration services(SSIS), SQL Server Reporting Service(SSRS), Power BI

MSBI Developer

Sales Information System
Hyderabad, India
05.2012 - 12.2014
  • Developing various SSIS Packages using Stored Procedures and Complex SQL Queries
  • Creating ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
  • Used transformations like Slowly Changing Dimension, derived column, conditional split, aggregate, lookup, sort, merge join, union all, merge, data conversion to load data into data marts
  • Providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
  • Implemented Package Configuration, Message Logging
  • Involving in Creation of tables, indexes, sequences, constraints and created stored procedures and triggers which were used to implement business rules
  • Generating reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc
  • Generating various reports with drilldowns, drill through, calculated members, and dropdowns from the cubes by connecting to Analysis server and SQL Server from SSRS

Education

Master of Computer Information -

Trine University
Angola, Indiana, U.S.A
01.2023

Bachelor’s degree -

JNT University
Kakinada, India
01.2012

Skills

Scripting Languages

  • Python
  • Scala

Shell Scripting

  • HTML
  • CSS

Databases

  • Microsoft SQL Server
  • MySQL
  • DB2
  • Oracle
  • PLSQL

Database Connecting Tools

  • SQL Developer
  • SQL Star Loader

Cloud technologies

  • Microsoft AZURE

Reporting tools

  • Power BI
  • Tableau
  • SSRS
  • Qlikview
  • QlikSense

ETL tools

  • Informatica
  • SSIS

Version control

  • Git
  • Jira
  • Postman

Operating Systems

  • Unix
  • Linux
  • Windows

API Integration

  • REST
  • SOAP XML
  • OAuth

Microsoft Azure Technologies

  • Azure SQL Server
  • Azure Data Explorer
  • Azure Data Factory
  • Databricks

Certification

  • AZ-204: Microsoft Certified: Developing Solutions for Microsoft Azure
  • AZ-900: Microsoft Certified: Microsoft Azure Fundamentals

Timeline

Lead BI Specialist

Charter communications
12.2023 - Current

SR Data Analyst

CIO Accenture
04.2019 - 07.2022

Senior BI Developer

CIO Accenture
02.2017 - 03.2019

BI Developer

British Telecom
12.2014 - 01.2017

MSBI Developer

Sales Information System
05.2012 - 12.2014

Master of Computer Information -

Trine University

Bachelor’s degree -

JNT University

Similar Profiles

CREATE PROFILE
Kishore Sakamuri