Hello !
I’m a Bussiness Intelligence / Data Analyst Developer in Canada !
About Me
Seasoned Data Analyst / BI Develeoper with 6 years of experience in analyzing complex datasets and delivering actionable insights. Proficient in Python, SQL, data visualization, and statistical analysis. Expertise in data extraction, cleansing, and transformation. Strong problem-solving abilities and a track record of driving data-informed decision-making to support business growth and optimization.
Microsoft Power BI | SQL | MYSQL | SSIS | MS Excel | Oracle | Python Scripting Power Apps | UI Path | DAX | Power Query | MS Office | Power Point | Agile | GIT | Star Schema | Snowflake Schema | Data Warehouse | Azure SQL | TSQL | ETL | Data Modeling | Tableau | Advanced Excel Macros | Azure Services | SSRS | AWS
Companies I've had worked
Work Experience
Power BI developer / Data Analyst
2020 - 2022
- Developed visually compelling dashboards and visualizations using Power BI and Looker, leading to a 20% improvement in communication of complex student data trends, including enrollment patterns, project participation, and credit distribution
- Developed and maintained complex SQL queries in BigQuery to extract, transform, and analyze vast volumes of data from diverse sources, ensuring data integrity and reliability in decision-making processes.
- Leveraged a deep understanding of academic project management to enhance the student graduation report, streamlining the assessment process for full-time and part-time projects, and improving the tracking of earned credits and completed courses
- Expertise in implementing Power BI security standard methodologies, including role-based access control (RBAC) and row-level security (RLS), ensuring data confidentiality, integrity, and compliance with regulatory requirements
- Designed and implemented scalable data stores on Azure, utilizing services such as Azure SQL Database, Cosmos DB, and Azure Blob Storage.
- Orchestrated data workflows using Azure Data Factory, enabling seamless data movement and transformation across various Azure services
- Utilized statistical methodologies to validate hypotheses, conduct A/B testing, and uncover patterns and trends within datasets
- Designed and developed a comprehensive student graduation report, reducing assessment time and improving accuracy in tracking full-time and part-time projects, earned credits, and completed courses
- Employed advanced data analysis techniques to extract meaningful insights from student data, leading to evidence-based strategies that improved academic program effectiveness
- Conducted regular data quality assessments and validation processes, ensuring a high accuracy rate in the integrity and reliability of information presented in reports
- Utilized advanced Excel functions such as VLOOKUP, HLOOKUP, and INDEX/MATCH for efficient data retrieval and analysis, improving data accuracy and reducing errors
- Proficiently used Python and SQL to extract, transform, and load (ETL) data from various sources into the Azure ecosystem, achieving improvement in data integration efficiency
- Incorporated the Pandas, NumPy libraries to enhance the efficiency of data cleansing tasks, ensuring data consistency and integrity throughout the entire data processing pipeline
- Collaborated effectively with cross-functional teams, sharing findings, insights, and best practices to foster a culture of continuous learning and innovation within the organization
- Gained familiarity with SaaS business metrics such as Monthly Recurring Revenue (MRR), churn rate, and customer lifetime value, enabling strategic decision-making and performance tracking.
- Acquired comprehensive understanding and practical experience with Windows operating systems, including Windows 10 and Windows Server platforms, through daily tasks such as system configuration, software installation, and user account management.
Power BI developer / Data Analyst
2018 - 2020
- Seamlessly integrated academic background in Business/Commerce, Finance, Economics, or Real Estate with practical experience in both retail and finance sectors, facilitating a holistic approach to strategic decision-making
- Developed and maintained data pipelines performing data cleansing and pre processing tasks using Python and SQL resulting in a significant improvement in data quality
- Led Agile development teams in sprint planning, backlog grooming, and daily stand-ups to ensure timely delivery of data solutions.
- Acquired expertise in dimensional data modeling techniques, including star and snowflake schema, to design robust and scalable data architectures
- Utilized DAX to create calculated columns and measures to built a dynamic dashboard with features such as KPIs trends Top Performers etc
- Created Power BI reports using complex SQL queries with Joins from multiple tables across databases providing comprehensive insights into business performance
- Owned and managed the PowerBI infrastructure, ensuring reliability, scalability, and performance while coordinating with technical stakeholders to meet organizational requirements
- Utilized Power Query in Power BI to Pivot and Unpivot the data model for data cleansing and massaging enhancing the accuracy of data representations
- Served as the Subject Matter Expert (SME) in design reviews, ensuring the feasibility, quality, and performance of products and solutions while adhering to best practices.
- Managed code repositories in Azure DevOps TFS and GIT ensuring version control and code quality
- Leveraged Azure services including Azure SQL Database and Azure Blob Storage to store and retrieve data for reporting and analysis purposes optimizing data storage and retrieval processes
- Developed data pipelines using Azure Data Factory to ingest transform and load data from various sources into Azure data storage reducing data processing time by 15%
- Connected Power BI to various data sources including SharePoint SQL databases Excel files and cloud based applications enabling comprehensive data analysis and reporting
- Utilized SSIS transformations to manipulate data formats perform aggregations and handle data anomalies within the Microsoft SQL Server environment improving data quality and reducing anomalies by 25%
- Implemented complex Excel formulas including nested IF statements array formulas and custom functions to automate and streamline data processing tasks reducing manual intervention
- Utilized advanced knowledge of PowerBI, including DAX, Access Controls, Data Ingestion, and Complex Reporting, to deliver high-quality dashboards and visualization models.
- Leveraged considerable knowledge of Azure Synapse in conjunction with PowerBI, optimizing data integration and analytics capabilities for enhanced business insights.
- Implemented UiPath automation to streamline testing processes for Power BI reports ensuring accurate and reliable results
Database Developer
2016 - 2018
- Responsible for database development. In charge of requirements gathering for all jobs.
- Troubleshoot complex queries and stored procedures.
- Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator.
- Designed, developed and maintained relational databases
- Designing and developing Power BI reports and dashboards to meet business needs and requirements.
- Providing training and support to end-users on Power BI functionality and usage.
- Troubleshooting and resolving issues related to Power BI reports and dashboards.
- Experienced in setting up data refresh schedules and managing data source connections to ensure accurate and up-to-date information is available to all users
- Proven track record of working collaboratively with business stakeholders, IT teams, and data analysts to understand requirements and deliver solutions that meet their needs.
- Created various Stored Procedures, Tables, indexes, functions and make use of Azure datasource for Power Bi reports
Projects
Serviceable Details
Sales Management
Rental Order Report
Covid Report Ontario 2022
Company Layoff 2022
Say Hi
I am a Power BI Developer / Data Aanlyst with a passion for transforming data into meaningful insights. With my expertise in Power BI and data visualization, I am able to create interactive dashboards that allow businesses to easily understand and make informed decisions based on their data.
I have a strong background in data analysis and a deep understanding of data warehousing, which allows me to create robust data models to support my Power BI visualizations. I am also experienced in data integration and data manipulation, ensuring that the data being visualized is accurate and up-to-date.
In addition to my Power BI skills, I am also well-versed in Azure Data Factory, a powerful data integration and orchestration tool. I have successfully developed data pipelines using Azure Data Factory to efficiently ingest, transform, and load data from various sources into Azure data storage. This has enabled me to create end-to-end data solutions that support the seamless flow of data for reporting and analysis purposes.
Email Call