Yousaf

Data Engineer

Upwork • Freelance

May 2021 - Present • 5 yrs 1 mo

- Conducted customer cohort analysis and customer understanding work for Georgie & Tom's, a food delivery startup, using Excel, Python, and Power BI, helping stakeholders understand retention and customer behaviour. - Worked with Ash Lane Consulting to support data analysis and automate manual repetitive tasks, including data consolidation and transformation from SharePoint directories and Airtable workspaces (API). - Worked with Lanetta to build foundational understanding of analytics and data science, and provided guidance on using tools to effectively analyse research data. - Built a Python application to consolidate 1M+ Amazon product listings, automating a manual, error-prone process. - Designed an Excel dashboard (Power Query + Power Pivot) for a South Africa-based NGO supply chain, consolidating multi-source data to track pharmacy deliveries against targets. - Automated daily, weekly, and monthly file consolidations for multiple clients using Excel VBA, significantly reducing manual reporting time. - Created a Power Query-based Excel tool that integrates with the Toggl API, enabling clients to automatically pull logged time data into their reports. - Wrote and optimized custom Power Query M code and functions to automate complex data transformations and tasks for multiple clients. https://www.upwork.com/freelancers/~01ea8e7380f0e36b47

Data Engineer

NCR • Temps plein

Aug 2022 - May 2025 • 2 yrs 9 mos

- Developed and maintained Oracle Data Integrator mappings, packages, and scenarios to automate ETL workflows across staging and core layers for multiple subject areas for a telecom client (CelcomDigi Malaysia). - Built core layer transformation views and ETL control framework stored procedures in Teradata SQL, streamlining data processing and ensuring ETL governance and auditability. - Implemented high-volume data ingestion pipelines using Teradata MLOAD and FASTLOAD, and developed parameterized Python scripts to generate load templates, improving operational efficiency. - Collaborated with the cloud migration team to transition data warehouse workloads from on-premises infrastructure to a hybrid AWS architecture, ensuring a seamless cutover and uninterrupted data availability. - Developed and scheduled shell scripts on AWS EC2 Linux servers using cron to archive large tables based on retention policies and securely transfer backups to AWS S3 Object Storage. - Tuned high-impact queries by analyzing Teradata EXPLAIN plans, applying indexing and partitioning strategies, and automating statistics refresh using cron jobs to improve performance of critical analytical workloads. - Built an ETL monitoring dashboard (Excel, Power Query, VBA, ODBC with Teradata Vantage) to track ETL job health and performance, reducing issue detection and resolution time for operations team by 50%. - Administered SAP BusinessObjects (CMC, CCM) for user access management and supported ETL deployments, version control, and ITIL-based change and incident management processes. - Provided data warehouse consulting for Teradata VaaS on AWS (Target Australia), developing automated SQL scripts to generate weekly and monthly reports and support ad-hoc reporting requests from business users. - Performed Teradata DBA operational tasks, including workload monitoring via Viewpoint, query troubleshooting, backup and recovery (BAR) support, and generating DWH performance KPI reports for stakeholders (Thre