Awais Javaid

Principal Consultant in Data Analytics with 8+ years of experience designing, implementing, and optimizing large-scale data platforms and business intelligence solutions. Strong expertise in Google Cloud Platform, BigQuery, DBT, ETL pipelines, analytics engineering, and BI reporting. Proven ability to lead teams, collaborate with enterprise clients, and deliver data-driven insights across retail, banking, and enterprise environments.

Principal Consultant Data Analytics at Systems LTD (2021-06 – Present)

• Designed, tested, and validated multiple use cases for a Generative AI solution for Tapestry for their Coach, Kate Spade and Stuart Wiltzman Brands
• Debugged and resolved functional and performance issues in Generative AI during testing cycles
• Enhanced LLM semantic layer by identifying and fixing data and logic inconsistencies
• Acted as the primary point of contact for client communications and report requirement gathering
• Built interactive Tableau dashboards focused on Product Performance, Regional Sales, and Traffic insights
• Improved report performance through query optimization and data model enhancements
• Developed complex SQL queries and scripts in Snowflake to support analytics and reporting
• Led direct collaboration with US-based enterprise stakeholders for a large-scale Data Lake implementation
• Designed and implemented end-to-end ETL pipelines using GCP, DBT, Apache Airflow, Cloud Functions, and BigQuery
• Integrated and stitched data from Google Analytics, Salesforce Marketing Cloud, and ERP systems
• Developed advanced Tableau and Power BI dashboards for executive and operational reporting
• Built an E-commerce Traffic Dataset to analyze customer behavior and business performance
• Implemented Multi-Touch Attribution (MTA) dashboards linking offline sales with online activity
• Delivered Product Performance Dashboards tracking KPIs such as Sales, Marketing Spend, ROAS, Clicks, and Impressions
• Wrote and optimized complex SQL queries in BigQuery, improving report performance by 50%
• Supported GA3 and GA4 reporting through Looker Studio and Tableau

ETL / BI Developer at TenX (formerly Analytics Private Limited) (2018-08 – 2021-05)

• Led a team of 7 developers delivering enterprise-grade ETL and BI solutions
• Designed and automated ETL workflows using IBM DataStage
• Performed advanced SQL optimization, improving performance by reducing lookup dependencies
• Built semantic data models and BI frameworks using IBM Cognos Analytics
• Developed dashboards and reports for 80+ financial institutions, including Allied Bank, Meezan Bank, HBL, and UBL
• Implemented role-based access control and conditional report scheduling
• Authored key documentation including BRD, ISD, SMX, and data models
• Optimized Cognos reports for memory usage and execution time

Professional Services Consultant at Teradata (2018-02 – 2018-07)

• Delivered Big Data and Data Lake demonstrations using Kylo for Allied Bank
• Worked on data ingestion, data wrangling, and feed monitoring
• Developed Proof-of-Value dashboards for PEPSI-CO using Tableau
• Contributed to analytics solutions for Punjab Safe Cities Authority (PSCA)
• Created advanced 3D visualizations using D3.js

Bachelor of Science in Computer Science – National University of Computer & Emerging Sciences (FAST-NUCES) (2013 – 2017)