Summary
Overview
Work History
Education
Skills
Timeline
Generic

Divyasree V

Winnipeg,MB

Summary

6 years of IT experience in Business Intelligence solutions with expertise in customer stakeholder management. Proficient in implementing Microsoft BI/Azure BI solutions, including Azure Data Factory, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, and Power BI. Skilled in creating business rules for ETL processes using Azure Data Factory and SQL Server Integration Services.

Overview

6
6
years of professional experience

Work History

Senior Data Engineer

BCLC
08.2023 - Current
  • Orchestrated complex data integration projects, aligning with business objectives and strategic vision
  • Developed and maintained dynamic dashboards for real-time KPI monitoring, enabling data-driven decision-making across multiple business units
  • Established comprehensive data governance and master data management systems, ensuring data quality, control, and compliance with regulatory requirements
  • Implemented advanced data masking and anonymization practices within SSIS packages, safeguarding sensitive data during ETL processes and ensuring data privacy
  • Conducted extensive load testing and stress testing of ETL processes, optimizing for scalability and robustness to handle increasing data volumes
  • Designed and developed custom assemblies and extensions for SSAS, significantly enhancing functionality and performance of analytical models.

Senior Data Engineer

Weever
01.2023 - 08.2023
  • Spearheaded the design and development of Power BI reports with custom error handling and exception reporting, improving data validation processes and report reliability
  • Collaborated closely with business stakeholders to define and implement data enrichment processes, enhancing data quality and analytical capabilities
  • Implemented advanced SQL server database performance tuning techniques, resulting in significant improvements in query response times and overall system efficiency
  • Developed and maintained complex SSIS project configurations, expertly parameterizing package execution for flexibility across different environments
  • Created and managed Power BI datasets with incremental data refresh and data compression, optimizing performance and reducing data processing time.

Data & BI Developer

Power Factors
03.2021 - 01.2023
  • Led initiatives to establish robust data governance frameworks, aligning with organizational objectives and industry best practices
  • Designed and implemented comprehensive data migration and integration platforms, ensuring seamless data flow between disparate systems
  • Developed and maintained Power BI reports with dynamic visuals and conditional formatting, enhancing data interpretation and decision-making capabilities
  • Configured and managed complex data replication and synchronization processes between various data sources, ensuring data consistency across the enterprise
  • Collaborated with business intelligence teams to integrate SSIS packages with reporting and analytics platforms, enabling advanced data-driven insights.

SQL/MSBI Developer

Punjab National Bank
02.2019 - 01.2021
  • Established and managed seamless data integration processes, harmonizing diverse data sources to create a unified view of organizational data
  • Created and managed perspectives and translations in SSAS tabular models, providing tailored views of data and supporting multilingual reporting capabilities
  • Developed and maintained sophisticated ETL performance tuning strategies, significantly improving data processing efficiency and reducing processing times
  • Implemented comprehensive SQL server database performance benchmarking, assessing and optimizing database performance improvements
  • Collaborated with data scientists to design and implement scalable machine learning pipelines, enhancing predictive analytics capabilities.

ETL Developer

Big Bazaar
04.2018 - 02.2019
  • Implemented and delivered comprehensive MSBI platform solutions for ETL, analytical reporting, and dashboards using SSAS, SSIS/DTS, and SSRS
  • Developed, deployed, and monitored complex SSIS Packages for new ETL Processes, ensuring data integrity and timely data updates
  • Successfully migrated legacy DTS packages to modern SSIS packages, improving system performance and maintainability
  • Optimized database performance through advanced tuning of Stored Procedures and Queries, significantly reducing query execution times
  • Developed and maintained SQL Server Maintenance plans, job scheduling, and alerting systems, ensuring smooth database operations and proactive issue resolution.

Education

Bachelor of Science -

KITSW
Warangal

Skills

  • Data Integration: Extensive experience in designing and implementing data integration solutions, including ETL processes and data migration strategies
  • Business Intelligence: Proficient in SSRS, SSIS, SSAS, and Power BI for creating comprehensive BI solutions
  • Database Management: Strong skills in SQL Server, including performance tuning, optimization, and data integrity maintenance
  • Cloud Technologies: Hands-on experience with Azure services, including Azure Data Factory and Azure Databricks
  • Data Modeling: Expertise in dimensional data modeling, star schema, and snowflake modeling for both OLTP and OLAP systems
  • Project Management: Experience in Agile and Scrum methodologies, with a track record of managing multiple simultaneous projects

Timeline

Senior Data Engineer

BCLC
08.2023 - Current

Senior Data Engineer

Weever
01.2023 - 08.2023

Data & BI Developer

Power Factors
03.2021 - 01.2023

SQL/MSBI Developer

Punjab National Bank
02.2019 - 01.2021

ETL Developer

Big Bazaar
04.2018 - 02.2019

Bachelor of Science -

KITSW

Similar Profiles

CREATE PROFILE
Divyasree V