Senior Azure BI Developer
2020 - PRESENTWoolworths Group- Designed and developed the shopper performance dashboard, including modeling, building the fact-and-dimension tables and dashboard using Azure Synapse, Data Factory, and Tableau.
- Developed multiple Azure Data Factory pipelines to dynamically copy data into Azure Blob storage as per business request.
- Built delivery subscription Power BI dashboards using Azure Synapse, Data Factory, Analysis service, and Power BI. The solution helps businesses to improve customer satisfaction, increase sales, and save on costs.
- Migrated the seven existing fulfillment web reports of Woolworths' online sales to SSRS reports using Azure Synapse and SSRS.
Technologies: Azure Synapse, Azure Analysis Services, Microsoft Power BI, Azure Data Factory, Tableau, Azure SQL Databases, Azure Logic Apps, Data Warehouse Design, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Engineering, SQL, Google BigQuery, DAX, Apache Airflow, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, APIs, Data Migration, API Connectors, ETL, XML, REST, ETL Tools, Business Intelligence (BI), Dashboards, Data Visualization, Pandas, Data Pipelines, Data Analytics, Data Lake Design, Data Lakes, Data, Cloud Platforms, Data Modeling, Data AnalysisAzure BI Consultant and Data Architect
2018 - 2020Antares Solution- Designed and developed the ETL, data warehouse, cube, and reports of a digital email campaign for a leading health supplement company. This automation saved the client a substantial amount of time instead of having to manually generate the reports regularly.
- Delivered a real-time big data analytics architecture including designing a big data, real-time, IoT, machine learning, and advanced analytics platform for a leading entertainment company.
- Developed text classification for clients using Python, Keras, word embedding, NLP, Word2vec, GloVe, deep learning, and CNN.
- Built a movie recommendation proof of concept (POC) using Azure Databricks, machine learning, collaborative filtering, real-time data ingestion, Azure Event Hubs, Spark MLlib, and Python.
Technologies: Azure Data Factory, Databricks, Azure Analysis Services, Microsoft Power BI, SSRS Reports, SQL Server Integration Services (SSIS), Python, Azure Event Hubs, Azure Stream Analytics, Azure Logic Apps, GloVe, Natural Language Processing (NLP), Data Warehouse Design, Microsoft SQL Server, Data Architecture, SQL Server Analysis Services (SSAS), Data Engineering, SQL, DAX, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, Azure Machine Learning, APIs, Data Migration, API Connectors, ETL, XML, REST, ETL Tools, Business Intelligence (BI), Dashboards, Data Visualization, Pandas, Data Pipelines, Data Analytics, Marketing, PostgreSQL, Data Lake Design, Data Lakes, Data, Redshift, Cloud Platforms, Data Modeling, Data AnalysisSenior Azure BI Developer
2017 - 2018Woolworths Group- Designed and built a dimensional modeling data warehouse, a tabular cube, and Power BI dashboard of online sales using Azure Data Warehouse, Azure Analysis Services cube, and Power BI.
- Performance-tuned large volume data with table partition, cube partition, polybase, and hash distribution on Azure Data Warehouse.
- Automated the cube process using Azure Automation account, runbooks, and webhooks.
Technologies: Azure Data Factory, Azure Synapse, Microsoft Power BI, Azure Analysis Services, Azure Logic Apps, Data Warehouse Design, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Engineering, SQL, DAX, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, Data Migration, ETL, ETL Tools, Business Intelligence (BI), Dashboards, Tableau, Data Visualization, Data Pipelines, Data Analytics, Data Lake Design, Data Lakes, Data, Cloud Platforms, Data Modeling, Data AnalysisSenior SQL BI Consultant
2016 - 2017Agile BI- Delivered high-quality BI solutions and projects for clients on BI visualization and reports, data warehousing, SSAS tabular model cube, DAX/MDX, SQL Server, Microsoft BI, and Power BI.
- Modeled, designed, and developed independently a sales cube using a SSAS tabular model cube and DAX for a large wholesale/retail company.
- Delivered an advanced benchmark BI system and advanced SSRS reports for a leading accounting firm using SSRS, MDX, SSAS, an OLAP cube, and SQL Server.
Technologies: SQL Server Integration Services (SSIS), SSRS Reports, SQL Server BI, SSAS Tabular, DAX, Microsoft Power BI, MDX, Data Warehouse Design, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Engineering, SQL, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, APIs, Data Migration, ETL, ETL Tools, Business Intelligence (BI), Dashboards, Data Visualization, Data Pipelines, Data Analytics, Microsoft Access, Data, Cloud Platforms, Data Modeling, Data AnalysisSenior SQL BI Developer
2011 - 2016Aussie Home Loan- Designed and developed independently a new data warehouse, cube, ETL, and some reports for analyzing mortgage and non-mortgage sales data (including home loan, insurance other financial data).
- Designed and developed a GL cube for the finance department.
- Optimized and performance-tuned a large volume BI data warehouse.
Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server BISQL BI Developer
2010 - 2011Hyundai- Developed several reports using SSRS (Reporting Service 2008) for finance, marketing, and sales departments.
- Oversaw and was in charge of ETL development and developed an SSIS package to extract data from an ERP system and transformed and processed the data using SQL Server 2008.
- Worked with an analysis programmer and other developer to realize the system based on InfoPath, Microsoft Web Services, Workflow, and SQL Server 2008.
Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server BIMicrosoft BI Developer
2006 - 2010Pactera- Worked onsite at Microsoft and contributed to the development and support of five BI applications based on SQL Server, SSRS (reporting service), SSAS (cube), SSIS, ETL, data warehousing development, dimensional modeling design, and schema design.
- Developed reports using SSRS and implemented ETL through programming store procedures and SSIS package.
- Constructed the ETL with an SSIS package—slowly changing dimensions with store procedures, aggregation, a processing cube, and so on.
Technologies: C#.NET, SQL Server BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Multidimensional Expressions (MDX)