Summary
Overview
Work History
Education
Skills
Timeline
Generic

Teja Indukuri

London

Summary

Committed Business Intelligence Analyst with experience in developing, testing, and optimizing BI solutions. Proficient in data analysis, reporting, and visualization, with a strong background in SQL, ETL processes, and BI tools. Adept at working with cross functional teams to translate business needs into actionable insights and deliver high-quality solutions.

Overview

7
7
years of professional experience

Work History

Business Intelligence Analyst

Global Banking School (GBS)
12.2023 - Current
  • Develop and maintain SQL – Server Integration Services (SSIS) packages to extract, transform, and load data from various sources into an operational database using Visual Studio
  • Created a variety of Microsoft Forms for collecting student feedback and linked them to Power Automate for data maintenance
  • Design and implement dashboards and reports using Power BI to provide actionable insights to stakeholders
  • Collaborated with business users and stakeholders to understand the new requirements and enhancements
  • Engage in ongoing collaboration with stakeholders to obtain the data and update the Power BI reports
  • Transformed raw data into actionable reports and recommendations, leading to measurable changes
  • Analyzed complex datasets, offering clear examples and insights when leveraging data to propose changes using SQL Server Management Studio (SSMS) and My SQL Workbench
  • Raised data quality issues during development and unit testing to improve the efficiency of the PBI reports.

Business Intelligence Tester

Global Banking School (GBS)
08.2022 - 11.2023
  • Developed test plans and maintained a test environment in Azure with more than 600 valid test cases for several Power BI reports
  • Collaborated with software developers, BI Developers, Data Analysts to understand the requirements and improve quality and reliability of reports
  • Identified bugs, risks and anomalies during the testing phase
  • Maintained test logs and documented all tests, providing accurate and timely status updates
  • Performed Regression testing to ensure the existing functionality or reports are not affected when a new change has been implemented by developers
  • Tested various Data Models in Data Warehouse that are used to create Power BI reports
  • Raised several data quality issues during the testing phase to improve the efficiency of the Power BI reports
  • Validated data models and data transformations by examining the PBI file along with the report
  • Maintaining the database daily by executing the SSIS packages in visual studio
  • Proactively communicating the testing process, issues, and risks to business analyst, providing regular status updates, and addressing concerns to BI Manager
  • Managing access and permissions to Power BI reports and workspaces.

Senior Software Engineer

Capgemini Technology Solutions India
04.2017 - 01.2022
  • Analysis of the specifications provided by the clients
  • Develop/Execute ETL Test cases to validate business requirements
  • As part of test build/Design Phase created test scripts (Basically using SQL queries) for the given requirements in BRD to test those scripts in test execution phase
  • In Test execution phase, executed the test scripts using various tools such as DB2 Netezza and AQT, documenting and validating test results and reporting the defects found to the stakeholders (BA and Developers)
  • Logged defects using HP-ALM and get it fixed by BA or developers
  • Validates the mappings, transformations which are designed by the developers
  • Creating test data for requirements to validate against Salesforce application
  • Tested the end-to-end functionality across Salesforce application
  • Executing the test cases through HP ALM, logging the defects and tracking the defects in QC
  • Knowledge sharing with various Stake holders and team
  • Requirement analysis and Query log updating
  • Key role in managing the defects
  • Regression Testing.

Education

Bachelor of Science - Computer Science

Adikavi Nannaya University
India
03.2017

Skills

SQL, Microsoft Power BI, Microsoft Power Platform
SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), My SQL Workbench, Data Warehouse
Visual Studio, Data Pipelines, Data Models
System Testing, Functional Testing, Performance Testing, Regression Testing, Smoke Testing, Unit Testing
Data Analysis, Microsoft Excel

Timeline

Business Intelligence Analyst

Global Banking School (GBS)
12.2023 - Current

Business Intelligence Tester

Global Banking School (GBS)
08.2022 - 11.2023

Senior Software Engineer

Capgemini Technology Solutions India
04.2017 - 01.2022

Bachelor of Science - Computer Science

Adikavi Nannaya University

Similar Profiles

CREATE PROFILE
Teja Indukuri