Talha Zafar

Supported Coles Group’s enterprise Master Data Management program for four and a half years, ensuring consistent, high-quality product data across all platforms.

Led discovery and analysis of product data flows and customer touchpoints to inform strategic decisions.

Owned end-to-end analysis of inbound and outbound integrations, guaranteeing data accuracy and reliability.

Designed integrations utilizing Azure Data Factory, Azure Service Bus, and structured file-based interfaces.

Collaborated with Product Managers and Engineers to ensure data-driven product decisions aligned with enterprise goals.

Documented functional and non-functional requirements through workshops, process mapping, and assessments.

Translated analytical insights into user stories, acceptance criteria, and prioritized backlogs in JIRA.

Coordinated integration testing and User Acceptance Testing to validate functionality and user experience.

Oversaw regional accounts as Regional Lead Data Engineer for APAC.

Managed six Data Engineers, providing technical guidance to meet deliverables on time.

Designed ETL processes on Talend to extract, stage, and load data into Data Warehouse.

Architected Data Warehouse models using OLAP Star Schema for multiple projects.

Served as primary contact for clients, gathering requirements and translating them into technical designs.

Reported to Senior Director of Data Engineering, providing regular project updates.

Developed ETL processes to capture data from multiple sources into Housing Datamart.

Implemented SQL Server Replication in clustered environments for enhanced data availability.

Simplified ETL in data warehouse applications through SCD Type-II dimensions using Change Data Capture (CDC).

Managed CI/CD Azure DevOps pipelines for releases in complex, multi-team environments.

Maintained reporting processes and provided user support for effective utilization.

Created stored procedures, views, and indexes while performing query optimization.

Resolved bugs identified by Implementation Team to ensure smooth functionality.

Prepared documentation including requirement specifications and data dictionaries.

Developed interactive dashboards using Microsoft Power BI for Finance, Operations, and Risk teams.

Gathered and documented requirements from users to create actionable reports.

Maintained reporting processes and provided user support for effective utilization.

Created stored procedures, views, and indexes while optimizing query performance.

Implemented bug fixes identified by Implementation Team to enhance system functionality.

Automated manual calculations for key measures used by Risk & Compliance Team.

Prepared requirement specifications and data dictionaries to support data governance.

Enhanced Data Warehouse utilized by approximately 160 reports across various Bank teams.

Served as Technical Lead for projects across FMCG, Retail, and Financial Services.

Acted as primary contact for clients, gathering requirements and translating business processes into technical designs.

Built dashboards using Tableau, Power BI, and Tibco Spotfire for data visualization.

Designed ETL processes in Microsoft SSIS to extract, stage, and load data into Data Warehouse.

Architected Data Warehouse models utilizing OLAP Star Schema technique for various projects.

Transformed on-premises databases to Azure environments for client data warehouses.

Developed Multi-Dimensional and Tabular Cubes using Microsoft SSAS for analytical purposes.

Scheduled and monitored ETL jobs and Power BI dashboards to ensure successful execution.

Developed ETL adaptors for various banking servicing systems.

Executed unit testing of data integration processes to ensure reliability.

Gathered and documented requirements from business users to facilitate data-driven reporting.

Implemented enhancements and bug fixes based on feedback from feature teams.

Addressed bug fixes raised by the Implementation team to improve functionality.

Created detailed sales and inventory reports using Microsoft SSRS for comprehensive analysis.

Optimized report performance to enhance data retrieval speed and accuracy.

Developed multi-dimensional cubes with Microsoft SSAS to enable advanced analytics.

Implemented dynamic partitioning of cubes annually and monthly through Microsoft SSIS packages.

Enhanced and resolved bugs in BI reports on stocks, sales, and inventory.