Talha Shafique Email & Phone Number

Lahore, Pk

Lahore, Punjab, Pakistan

Lahore, Punjab, Pakistan

• Developed a scalable data warehouse architecture in BigQuery, optimizing storage, query performance, and data organization, resulting in a 60% reduction in query response time and enhanced accessibility through data marts for growth, marketplace, and other critical business areas.• Orchestrated an AWS Glue ETL pipeline, extracting 30+ GBs of data from AWS RDS to BigQuery while implementing incremental updates and applying transformations, achieving with a 30% reduction in data processing time and a 15% improvement in data accuracy for streamlined analytics.• Designed and deployed automated data validation scripts, reducing manual validation efforts by 80% and improving data quality.• Deployed data migration of AWS RDS to BigQuery, enabling BizOps and CX teams to generate real-time dashboards in Looker Studio, resulting in a 25% increase in accuracy of sales and inventory metrics.

Lahore, Punjab, Pakistan

• Developed data pipelines to create CSV, Excel, and PDF reports used by over 1000’s of SimpledCard users.• Successfully migrated Pentaho Data Integration jobs to Python.• Designed and implemented a CI/CD pipeline using AWS CDK, including CodeBuild, Code Pipeline, CodeDeploy,and Docker. The pipeline was used to deploy an ML project that processed over 1 million SimpledCard data points per day.• Designed and developed REST APIs to provide secure access to the data. The APIs are used by over 1000 SimpledCard applications.• Currently working on shifting the whole process of creating reports to AWS SAM serverless model using Lambdas. The serverless model is expected to reduce the cost of running the reports by 50%.• Collaborated effectively with cross-functional teams, resulting in a 20% increase in data-drivendecision-making across the organization.• Leveraged AWS Athena for ad-hoc data analysis, enabling faster insights and reducing analysis timeby 50%.• Worked on the Notification Center of SimpledCard that includes sending mails to customers using Maizzle and Flask.• Automated tests for my project using pytest covering data integrity, data formatting & data cleaning.

Islamabad, Islāmābād, Pakistan

• Experienced in utilizing Python, Flask, Plotly DASH, and D3.js for building robust and interactive applications.• Collaborated on a client-side project focused on developing a comprehensive 360-degree view of employees and customers. Utilized Python Flask, AWS Cognito, and Plotly DASH to build interactive dashboards, enabling data-driven decision-making.• Successfully managed Salesforce instances, configured user permissions, and wrote SOQL queries to retrieve and analyze relevant data.• Developed APIs using the AWS SAM framework for seamless integration with other systems

Multan, Punjab, Pakistan