Mounika Balireddy
Montreal,QC
Summary
Experienced BI and Azure Engineer with 5+ years of successful track record, delivering excellence in data-driven solutions through advanced analytics, seamless cloud integration, and scalable technologies.
Overview
5
5
years of professional experience
Work History
Sr Cloud and MSBI Engineer
Power Factors
Burlington, ON
10.2022 - 05.2024
- Ensuring Guaranteeing data integrity through meticulous data quality checks and profiling tasks within SSIS packages
- Establishing robust data connections by seamlessly integrating Azure Purview with external data sources, fostering comprehensive insights
- Synchronizing data integration with visualization and reporting tools, creating a visual masterpiece of clear data representation and insights within Azure Data Factory
- Implementing interactive features like report drilldown and sorting in SSRS, empowering users to explore data deeply and customize sorting preferences
- Designing and implementing effective data partitioning strategies to enhance data management and retrieval
- Orchestrating data lake integration with Azure Event Hubs, enabling swift and efficient real-time data ingestion and processing
- Configuring and managing backup and restore strategies meticulously for Azure DevOps pipelines and configurations
- Utilizing Azure Key Vault's event-based triggers for automated key rotation based on predefined conditions
- Overseeing data ingestion processes in Azure Databricks, ensuring seamless data flow into the platform
- Conducting rigorous database testing, validation, and quality assurance to ensure data accuracy and system stability
- Implementing strategies for data transformation and enrichment
- Collaborating with security teams to enable encryption at rest for data stored in Azure Blob Storage, ensuring data security
- Creating and maintaining Power BI reports with customized report subscriptions for scheduled delivery
- Leveraging Azure Cosmos DB's multi-region replication capabilities to ensure high availability and disaster recovery for globally distributed applications
- Developing Python scripts for data analysis and reporting purposes
- Utilizing Git's revert command to undo specific commits while preserving the commit history, maintaining a clear record of changes
- Implementing change management processes for SSAS packages to manage version control and ensure smooth deployment across different environments
- Adhering to change management practices to efficiently track and manage SSAS package changes
- Implementing data integration and federation processes to combine and aggregate data from multiple sources
- Skillfully managing SSRS report subscriptions and automating report delivery, streamlining the process and ensuring timely access to critical information through scheduled reports
- Expertly integrating Azure Synapse with other Azure services and tools, creating a seamless and interconnected data ecosystem
- Developing and maintaining data alerts and notifications in Power BI to inform users of critical data changes
- Aptly configuring and managing package variables and expressions in SSIS, ingeniously utilizing variables and expressions to regulate package behavior and introduce adaptability
- Ensuring data quality, consistency, and accuracy within SSAS databases
MSBI and Azure Developer
Nainital Bank
Nainital, IN
11.2020 - 08.2022
- Ensuring data Ensuring excellence in data validation and error handling within SSIS packages, meticulously examining data integrity and adeptly managing errors
- Overseeing machine learning model training and deployment in Azure Databricks, harnessing the power of AI capabilities
- Enhancing user navigation by implementing report drill-through and linking to external resources in SSRS, providing seamless exploration of data
- Establishing and maintaining database performance baselines to monitor performance trends and anomalies as a DBA
- Creating and managing Azure DevOps test suites and test plans for automated testing, ensuring comprehensive test coverage
- Collaborating with developers, data engineers, and database administrators for seamless integration of SSAS with other systems and applications
- Optimizing database performance for ETL operations in collaboration with database administrators
- Designing and developing OLAP and OLTP database triggers to enforce data integrity constraints and automate data validation
- Cultivating comprehensive data glossaries within Azure Purview to promote a shared understanding of data terminologies and contexts
- Implementing and managing database capacity planning and scalability, ensuring the database infrastructure can handle growing data volumes
- Creating and maintaining documentation for Power BI and MSBI solutions, including user guides and training materials
- Integrating various data sources into Power BI for comprehensive data analysis using Power BI connectors and APIs
- Designing scalable, performant, and reliable SSIS data integration solutions to meet business demands
- Efficiently migrating data between access tiers by configuring Blob Storage access tier migration
- Configuring and managing data sharing and collaboration features in Azure Synapse to facilitate seamless data collaboration among teams
- Setting up and managing data retention and archival policies, ensuring optimal data lifecycle management on Azure Data Lake
- Implementing proactive caching and incremental processing in SSAS to optimize query response times by pre-calculating and caching results
- Carefully configuring data compression and encryption during data movement in Azure Data Factory to ensure secure data transfer
- Providing comprehensive training and support to end-users in SSRS report generation and utilization, empathetically addressing their needs
- Utilizing Git's reflog to recover lost commits or branches, revert accidental changes, and ensure data recovery while minimizing downtime
- Developing and maintaining Power BI dataflows to enable data preparation, integration, and data refresh processes
- Designing and executing SQL scripts for database migration testing to ensure data integrity and consistency during migration
Jr Azure and MSBI Engineer
Hinduja Global Solutions
Bengaluru, IN
08.2019 - 11.2020
- Developed systems for enhancing data value and usability through data enrichment and transformation
- Applied intricate control flow logic in SSIS packages, integrating loops, branches, and conditional execution for precise data processing
- Managed Power BI datasets and dataflows to ensure data consistency across reports and enable data reuse
- Optimized data lake integration with Azure Stream Analytics, enabling real-time data processing and insightful analytics
- Implemented ETL processes in BI development to extract, transform, and load data from various sources, ensuring accuracy and completeness
- Resolved issues related to SSAS databases and cubes through troubleshooting and proactive management
- Configured access control policies within Azure Key Vault for fine-grained permission management, ensuring tailored access for users and applications while upholding data privacy and security
- Designed and implemented SSRS report subscriptions, automating report delivery via email or file-sharing platforms with customized delivery options and scheduling
- Collaborated with database administrators to monitor and troubleshoot SQL server performance, ensuring optimal database operation
- Designed Azure DevOps build triggers for automated continuous integration, fostering frequent code integration
- Created and managed Azure Data Factory triggers, orchestrating data integration processes based on schedules or events
- Implemented row-level security in Power BI, restricting data access based on user permissions and organizational policies
- Managed custom data serialization formats in Azure Data Bricks for efficient data processing
- Implemented SSIS checkpoints for easy package restart and recovery in case of interruptions
- Developed custom data versioning and change tracking in Azure Cosmos DB for data history and rollback
- Utilized SSAS perspectives to create virtual cubes, offering tailored data views for different user groups and simplifying the browsing experience
Education
Bachelor of Technology -
GITAM University
Andhrapradesh, IndiaSkills
- Database Development
- Azure Expertise
- SQL Proficiency
- Data Optimization
- MSBI Stack
- Performance Tuning
- Reporting Skills
- Data Analysis
- Data Processing
- Communication
- Agile Project Management
Timeline
Sr Cloud and MSBI Engineer
Power Factors
10.2022 - 05.2024
MSBI and Azure Developer
Nainital Bank
11.2020 - 08.2022
Jr Azure and MSBI Engineer
Hinduja Global Solutions
08.2019 - 11.2020
Bachelor of Technology -
GITAM University