Muhammad Usman Email & Phone Number

- Designed and deployed dbt transformation pipelines, establishing a robust foundation forAnalytics/Machine Learning teams.- Automated seamless data ingestion from S3 to Glue Catalog by building an event-triggered pipeline with Lambda, Glue Crawler, and CloudWatch, ensuring real-time data processing.- Deployed Lambda function to streamline S3 to DynamoDB data transfer, achieving an impressive 85% reduction in processing time.- Deployed 1k+ models, configured 5k+ dbt tests, enhanced data validation accuracy, and improved data quality by a substantial 65%.- Implemented password authentication for dbt documentation hosted on CloudFront through AWS Lambda.- Reduced dbt transformation time by 5x to prevent Athena timeout using SQL Window Functions.- Built AWS infrastructure through Terraform, deployed on the GitHub Actions CI pipeline. Ensured the secure handling of AWS Secrets by leveraging GitHub Secrets.- Developed Jinja macros to efficiently summarize tests for all database tables, reducing troubleshooting time to a single query.- Built and hosted the Docker container on AWS ECR, providing the team with a standardized environment for working with dbt.- Implemented Zero-Copy clones of the production database using dbt, guaranteeing data freshness and achieving 0% downtime for workflows.- Utilized dbt's lineage feature to reconstruct databases within an hour following an accidental deletion incident, drastically reducing recovery time from what would have taken days.- Ensured dbt workflow success by introducing stateful retries.

Islāmābād, Pakistan

Islāmābād, Pakistan

- Implemented advanced web scraping techniques using Selenium, Scrapy, Proxy Servers, SQL, and S3 to scrape over 2k+ SKUs.- Implemented data-driven A/B testing strategies to optimize marketing campaigns, resulting in a 2x increase in conversion rates and a significant decrease in CAC and CPC.- Conducted Ad Hoc analyses and provided data-driven insights to support business decisions, such as pricing strategy, that contributed to a 10% increase in profit margins.- Conducted thorough keyword research and competitor analysis to implement effective SEO strategies that led to a steady increase in sales and improved rankings on eCommerce sites.- Created Interactive Power BI reports that facilitated effective communication with stakeholders.

Islāmābād, Pakistan

• Prepared data visualizations and reports to communicate findings with the team and help in informed business decisions.• Conducted analysis to get insights using tools like Excel or Python.

Faisalabad, Punjab, Pakistan

• Highly skilled in conducting extensive Web Research.• Expert in LinkedIn Lead Generation.• Strategic approach to Data gathering and Analysis.• Experienced in working long hours and handling various research projects.