BHAGYAREKHA PERUMANDLA
Mississauga,ON
Summary
A highly skilled Data Engineer/BI Developer with over 5 years of experience in building and optimizing data solutions using SQL Server, Azure Data Factory (ADF), Azure Databricks (ADB), SSIS, SSRS, and Power BI. Proficient in ETL processes, data modeling, and creating interactive dashboards and reports to assist stakeholders in data-driven decision-making. Adapt at managing large datasets, troubleshooting complex queries, and collaborating across teams to ensure data quality and integrity.
Overview
7
7
years of professional experience
1
1
Certificate
Work History
Senior Data Engineer
LTI MindTree
Hyderabad
06.2022 - Current
- Develop and manage data pipelines in Azure Data Factory (ADF) to integrate data from multiple on-premise and cloud sources into the data warehouse
- Use Azure Databricks (ADB) to perform large-scale data processing tasks and collaborate with data scientists to build machine learning models
- Design and implement SSIS packages for ETL tasks, optimizing the data transformation process and improving performance by [X]%
- Build interactive Power BI dashboards and reports for business stakeholders, providing insights into key performance indicators (KPIs) for [specific domain/industry]
- Generate automated and dynamic SSRS reports, enabling the management team to view real-time data for critical decision-making
- Work closely with business analysts and product teams to define data requirements and ensure data integrity across platforms
- Troubleshoot and optimize SQL Server queries and stored procedures, achieving a performance improvement of [X]% in query execution time
Software Engineer
IMAP Technologies
Hyderabad
12.2017 - 05.2022
- Led the design and implementation of a centralized data warehouse using SQL Server and SSIS, automating data extraction and transformation for various data sources
- Utilized Azure Data Factory to orchestrate the movement of data from on-premise systems to Azure Data Lake and Azure SQL Database
- Collaborated with business intelligence teams to develop Power BI reports, creating custom visuals and providing insights for sales, operations, and finance departments
- Developed and deployed automated SSRS reports, allowing executives to access key metrics on a scheduled basis, ensuring data accuracy and timeliness
- Improved data processing efficiency by optimizing SQL Server queries and implementing indexing strategies that reduced query times by [X]%
Education
MBA - Finance
Osmania University
Hyderabad08.2013
M.COM -
Osmania University
Hyderabad05.2011
Skills
- SQL Server
- Azure SQL Database
- SQL Server Management Studio (SSMS)
- T-SQL
- Azure Data Factory (ADF)
- SSIS (SQL Server Integration Services)
- Azure Databricks (ADB)
- Power BI
- SSRS (SQL Server Reporting Services)
- Data Modeling
- DAX
- Power Query
- Custom Visuals
- Report Publishing
- Microsoft Azure
- Azure Blob Storage
- Git
- Azure DevOps
- ETL development
- Advanced SQL
Timeline
Senior Data Engineer
LTI MindTree
06.2022 - Current
Software Engineer
IMAP Technologies
12.2017 - 05.2022
MBA - Finance
Osmania University
M.COM -
Osmania University
Certification
- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Power BI Data Analyst Associate
- [Any other relevant certifications]
Projects
[Project Name], [MM/YYYY], [MM/YYYY], Developed an end-to-end ETL pipeline using Azure Data Factory (ADF), transforming raw data from various APIs into structured datasets for business analysis., Created interactive Power BI dashboards for real-time monitoring of sales and operational data, resulting in an [X]% improvement in decision-making speed. [Project Name], [MM/YYYY], [MM/YYYY], Built a data integration pipeline using SSIS to ingest transactional data into the central data warehouse, resulting in a more reliable and scalable reporting solution., Leveraged Azure Databricks for distributed data processing and implemented a real-time analytics system that significantly enhanced reporting capabilities.
Similar Profiles
Diksha AhujaDiksha Ahuja
Specialist - Data Engineering at LTI MindtreeSpecialist - Data Engineering at LTI Mindtree
SAURABH CHOUDHARYSAURABH CHOUDHARY
Senior Mechanical Designer and Project Team Lead at LTI & MINDTREESenior Mechanical Designer and Project Team Lead at LTI & MINDTREE
Rohan SaxenaRohan Saxena
Software Specialist Engineer at LTI MindtreeSoftware Specialist Engineer at LTI Mindtree
Alvaro DeLeonAlvaro DeLeon
Dealer Support Agent at LTI MindtreeDealer Support Agent at LTI Mindtree
NADEEM M AKHTARNADEEM M AKHTAR
Clinical Research Coordinator III in Multi-Clinical Trials (NASH) and Cirrhosis [phase 2 and 3 ] at Fresno Clinical Research CenterClinical Research Coordinator III in Multi-Clinical Trials (NASH) and Cirrhosis [phase 2 and 3 ] at Fresno Clinical Research Center