Guiding architecture initiatives on Google Cloud Platform and Snowflake, collaborating seamlessly with engineering and vendor teams to deliver high-quality analytical products. Project portfolio encompasses data contracts, data lakes, data mesh, real-time streaming, game analytics modeling, cross-game analytics for players, and proof of concept on Data Plex and Apache Iceberg.

✔ Supported Loblaw's cloud journey in building a petabyte-scale data lake as part of the data architecture team.✔ Collaborated closely with cross-functional business teams to comprehensively gather requirements and formulate high-level architecture designs to meet organizational objectives.✔ Utilized tools like Miro and Confluence to document concept-to-high-level design details, ensuring clear communication and alignment within the team.✔ Contributed to standardization of ingestion patterns for different data requirements.✔ Designed data models for integration processes from data ingestion to the business consumer layer.✔ Ensured data integration and implementation is aligned with data governance best practices.✔ Successfully orchestrated the migration of BigQuery from an on-demand pricing model to a more cost-effective BigQuery Slots commitment approach.✔ Established a dedicated sandbox project environment, enhancing the organization's capacity for conducting proof-of-concept work and innovation.✔ Conducted assessments of external tables, authorized views, BI engines, and the ingestion of various payloads through Pub Sub to optimize data handling and insights generation.✔ Followed Sprint methodology for productionizing tasks in two-week cycles, utilizing GitLab for code management and deployment.✔ Integrated various datasets, including reference, ad hoc, and real-time streaming data into the BigQuery data warehouse.

Worked in Greater Toronto Area providing consulting services to Teradata customers performing the following functions. ✔ Architect, design and develop ETL applications using 3rd party tools✔ Coordinate with architecture team about integration challenges and data issues.✔ Manage database environments on Teradata for integration of EDW.✔ Support and guide the customer projects and enterprise architecture team to align the development and Production processes according to Teradata best practices.✔ Performance tuning of applications and business reports solving customers major performance bottles.

Worked on different phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.✔ Elicit business requirement, Data mapping documents (SMX).✔ ETL Applications design, development and implementation.✔ Technical writing of ETL design and analysis document.✔ Manage and trouble shoot Semantic/BI applications.✔ Coordinate and implement Physical data Model.✔ Code review and ETL specification documentation reviews.✔ Service delivery in alignment with ITIL processes including incident, change, problem, and release and configuration management.✔ Managing and coordinating releases with the Test and Operations team.✔ Performance optimization of SQL and scripts.✔ Work as lead consultant on projects managing and mentoring small teams ✔ Manage Run book document covering technical and operational information and processes.Projects:✔ Swisscom(Switzerland) DWH Consultant✔ Mobilink(Pakistan) Data Mapping✔ Unilever(UK/US) BI Analyst/DBA✔ The Warehouse(NZ) Senior DWH Consultant✔ Sumitomu Mitsui (Japan) - Lead Consultant Migration✔ Ufone (Pakistan) - BI Consultant

Worked in capacity of Managed Services consultant - Teradata DBA and performed the following functions below.✔ Manage Teradata Production and Non-Production environments.✔ User Profiles, Roles rights Management.✔ Data Access and Security Control.✔ TASM analysis and implementation. ✔ DBC Housekeeping of Resusage, DBQL, roles rights.✔ Query Optimization.✔ Backups policy and media maintenance.✔ Capacity and System analysis reports, User audit reports.✔ Teradata Backups and Restores.✔ Stats collection and automation of jobs.✔ Coordination with TDCS for Software bugs, upgrades and root cause analysis.✔ Incident /Release /Change/Problem Management in HP OpenView.✔ Teradata System Monitoring/ Space management/ UC4 Scheduling.✔ Train and mentor junior team members.✔ Locking Logger/ Query Banding.✔ Operational manual and Run book.✔ Trouble shooting and monitoring ETL.Projects:✔ Swisscom Switzerland - DBA✔ Vodafone UK - Application DBA/ETL Developer

✔ Worked as a team member on LDI (Long Distance & International) Network.✔ Communication and coordination with vendors and other departments✔ Business and traffic analysis and trend reporting.✔ Adhoc and data analysis reports✔ Rating and Re-Rating of CDR’s.✔ Analysis and re-conciliation of Bills & CDR’s.✔ Developed automated data loading processes for loading data from LDI network to Oracle.✔ Designed and developed Web based Reporting System that contains different business and traffic data analysis reports.✔ Developed Oracle data backup policy.