Sai Kumar Bhopple
Specialist- Data Engineering
Hyderabad
Summary
5 Years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, requirement assessment, design, analysis, development, documentation, coding, enhancement, testing and implementation of the business technology solutions using Microsoft Power BI and IBM Cognos BI
Overview
6
6
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Specialist – Data Engineering
LTI Mindtree
Hyderabad
09.2024 - 12.2024
- Creating staging database for temporary processing of data, consolidating data and Loading database using Integration services
- Writing the Stored Procedures which meet the requirements
- Scheduling reports using Reporting services to e-mail with an attachment in the desired format of report to the top management
- Developing parameterized reports including multi-parameters
- As per the requirements, rendering the reports in the form of Excel and PDF formats
- Deploying the generated reports in DEV & UAT server
- Extensively created calculated columns, calculated measures and custom columns using Power BI Desktop to generate reports for business analysis
- Created the measures according to the business logic in Power BI Desktop using Data analysis expressions(DAX)
- Getting data from different sources, extraction, transform and shape the data using SSAS(Tabular Model) and then loading the data into data modeling
- Understanding of SQL, ability to write performant SQL queries, ability to diagnose queries and work with DBAs
Consultant
Deloitte
12.2021 - 09.2023
- Extracting data from different kinds of source systems into Power BI and then cleansing the data by applying business rules and loading it into Power BI
- Gathering the requirements from business users and analyzing those requirements and providing estimates
- Understanding business requirements in BI context and design data models to transform raw data into meaningful insights by having appropriate relationships
- Creating data flows and datasets for various Power BI applications
- Creating Microsoft Power automated flows to refresh the data flows and datasets on hourly basis and daily basis depending on the user requirement
- Creating calculated measures and columns with DAX in Power BI desktop
- Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
- Implemented Role Level Security as part of user level security in Power BI
- SQL querying for best results, use of filters and graphs for better understanding of data
- Worked on On-Premises Gateway to refresh the data sources and scheduling the data
- Configuring Gateways in the power BI services
- Redefine and make technical/strategic changes to enhance existing Business Intelligence systems
- Developed strong client relationships through consistent communication and attentive service
- Created and managed project plans, timelines and budgets
Senior Data Engineer
Webmaazix Solutions Pvt. Ltd
05.2021 - 11.2021
- Collecting the Requirements, analyzing the requirements and interacting with the client for better Understanding of business requirements and developing reports
- Worked closely with business teams to gather requirements, prepared functional documents and UAT feedback
- Responsible for analyzing the Reporting requirements, Report design discussion, Report development, Unit Testing, Design Document and Unit testing Documentation, Functional/System Testing Support, UAT Defect Fixes
- Developed around 60 Power BI reports by making use of Power BI desktop
- Published the Power BI reports into Power Bi service to collaborate with the end users
- Scheduled the refresh of Power BI reports to fetch the latest data into report
Software Engineer
Frontline Login System Pvt. Ltd
10.2018 - 04.2021
- Collecting the Requirements and analyzing the requirements and interacting with the Onsite coordinators to find the proper information
- Customized data by adding filters at both the Framework Level and Report Level
- Published different packages from Framework Manager to Cognos Connection
- Creating technical design documents and unit test cases
- Created package and published to the Cognos server
- Checking and fixing validation issues at Cognos
- Modified the existing Framework Manger Models to incorporate the new data elements
- Modified existing reports to incorporate the changes in the Source System
- Prepared Unit Test cases for report validation
- Responsible for code migration across environments (DEV, UAT, Prod)
- Responsible for documenting the code changes as per the User change requests
Education
Bachelor of Technology - Electronics and communication
Aurora Scientific Technological And Research Academy
Hyderabad 08.2012 - 06.2016
Skills
- Power BI Desktop
- Power Query
- Power Pivot
- DAX
- M language
- Data modeling
- Reports and Dashboards
- Row level security (RLS)
- Object level security (OLS)
- Power BI service
- Data flows
- Semantic Models
- Query Studio
- Report studio
- Framework manager
- Cognos Analytics
- MS SQL server 2012
- Oracle 11g
- IBM DB2
- DAX Studio
- Tabular Editor
Certification
Microsoft Certified, Data Analyst Associate - Microsoft.
Timeline
Microsoft Certified, Data Analyst Associate - Microsoft.
02-2025
Specialist – Data Engineering
LTI Mindtree
09.2024 - 12.2024
Consultant
Deloitte
12.2021 - 09.2023
Senior Data Engineer
Webmaazix Solutions Pvt. Ltd
05.2021 - 11.2021
Software Engineer
Frontline Login System Pvt. Ltd
10.2018 - 04.2021
Bachelor of Technology - Electronics and communication
Aurora Scientific Technological And Research Academy
08.2012 - 06.2016
Similar Profiles
Chandra Sekhar DummuChandra Sekhar Dummu
Specialist - Package Implementation at LTI MindtreeSpecialist - Package Implementation at LTI Mindtree
Kowsalya KumarKowsalya Kumar
DEVOPS LEAD ENGINEER (CLIENT: CITIBANK) at LTI MINDTREEDEVOPS LEAD ENGINEER (CLIENT: CITIBANK) at LTI MINDTREE
Harshitha VHarshitha V
Senior Engineer Cloud & Infra at LTI MindtreeSenior Engineer Cloud & Infra at LTI Mindtree