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
India03.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