Anita Upadrasta
Ottawa
Summary
Experienced Business Intelligence Analyst with over4 years in data warehousing and BI tools like Power BI and MSBI (SSRS, SSIS). Proficient in generating reports and visualizations from diverse data sources such as SQL Server, Snowflake, MySQL, and Excel. Expertise in real-time data integration into Power BI dashboards, configuring streaming datasets, Direct Query mode, and developing custom visuals and alerts. Skilled in managing Power BI Service, ensuring secure data access, enabling real-time collaboration, and integrating with APIs for dynamic dashboards. Strong technical proficiency in SQL, Python, Common Data Service, and Power BI Desktop reporting. Adept at designing dimensions and cubes with SSAS, creating complex SSRS reports, and optimizing performance through cube partitioning. Experienced in cloud data warehousing, data migration, and ETL processes with a solid understanding of relational databases, data modeling, and SDLC.
Overview
6
6
years of professional experience
1
1
Certification
Work History
BI Analyst
Open Circle
06.2024 - Current
- Engaged with stakeholders to understand their data needs and gather detailed requirements for reporting and dashboard development
- This includes coordinating with subject matter experts from various departments to ensure that data sources and metrics align with business objectives
- Designed and developed interactive Power BI dashboards based on stakeholder requirements using DAX
- Integrated data using ETL tools such as SQL server from various sources into a centralized data lake by using ADF
- Implemented data validation processes and maintained data governance standards to ensure integrity of the reports and dashboards
- Used Python for cleaning, manipulation, and automation of data in handling unstructured data by advanced analytics
- Efficient in Visio for creating process flow diagrams and representations of data workflows and architecture
ETL/BI Analyst
Broker Link Insurance
04.2023 - 05.2024
- Designed and implemented databases and data models using SQL Server, utilizing both star and snowflake schemas
- I also developed detailed data mapping documentation and set up efficient SSIS ETL processes to ensure smooth data flow
- Connected various data sources to Power BI, created calculated columns and KPIs with DAX, and optimized reports for better performance
- Additionally, I managed the entire BI strategy, from data sourcing to comprehensive reporting, to support informed decision-making
- Built and automated data pipelines in Azure Data Factory, created and scheduled stored procedures in Azure, and developed effective migration strategies to transition traditional systems to the cloud seamlessly
- Designed logical and physical data models, defining fact and dimension tables with appropriate keys, constraints, and relationships
- Created dimensional models with optimized granularity, conformed dimensions, and aggregated tables for faster analytical queries
- Implemented best practices in data integrity, indexing, and normalization to ensure scalability and maintainability of databases
SQL Developer
Amex
11.2018 - 12.2021
- Developed and optimized ETL packages using SSIS to handle data from various sources such as SQL Server, flat files, and Excel
- Enhanced and maintained reports using SSRS, and automated tasks to streamline monthly data refreshes
- Participated in code reviews, unit testing, and performance tuning to ensure efficient and accurate data processing
- Created and improved complex stored procedures and views to support robust reporting solutions in SSRS
- Generated detailed metrics reports, performed performance optimization, and troubleshoot SSIS packages
- Designed packages utilizing various SSIS components like Merge Join, Derived Columns, and Conditional Split to enhance data workflow efficiency
- Maintained comprehensive documentation for all processes and code changes
- Engaged in ongoing technical training to stay current with industry best practices
- Utilized tools like TFS for version control and unit testing, ensuring high-quality and reliable data solutions
Education
DBA -
Lincoln College University
MBA -
University Canada West
07-2023
Computer Science
Krishna University
Machlipatnam05-2015
Skills
- Data Analysis & Visualization: Power BI, Tableau, MSBI (SSIS, SSRS, SSAS), Excel, Python
- Databases & Data Storage: SQL Server, MongoDB, MS Access
- ETL & Data Integration: SSIS (SQL Server Integration Services), ADF (Azure Data Factory), TSQL, Data Warehousing
- Data Modeling & Design: Data Modeling (ERD, Dimensional Modeling, Star and Snowflake Schema), Data Mapping
- Cloud & Integration: Azure (Azure Data Factory, Azure SQL Database, Azure Blob Storage), On-Premises Data Gateway, API Integrations
- Business Intelligence & Reporting: Power BI, SSRS (SQL Server Reporting Services), Tableau
- Version Control & CI/CD: VSTS (Azure DevOps), Git, Jenkins
- Performance & Optimization: Performance Tuning (SQL Optimization, Indexing, Query Optimization)
- Programming & Scripting: Python, R, T-SQL, PowerShell
- Collaboration & Project Management: SharePoint, Jira, Confluence
Certification
Microsoft Dynamics365 Fundamentals (CRM)
Languages
English
Full Professional
Hindi
Full Professional
Telugu
Full Professional
Timeline
BI Analyst
Open Circle
06.2024 - Current
ETL/BI Analyst
Broker Link Insurance
04.2023 - 05.2024
SQL Developer
Amex
11.2018 - 12.2021
DBA -
Lincoln College University
MBA -
University Canada West
Computer Science
Krishna University
Similar Profiles
Paige MullenPaige Mullen
Client Care Representative at Open Circle BenefitsClient Care Representative at Open Circle Benefits
NANDINI SINGHNANDINI SINGH
Volunteer at Open Mind Open Canoe AssociationVolunteer at Open Mind Open Canoe Association
Tania CoriaTania Coria
Business Development Executive BDE LATAM at Open English / Open Education LCCBusiness Development Executive BDE LATAM at Open English / Open Education LCC