Sameer Uddin Email & Phone Number

- Designed and implemented 8+ ETL pipelines, sourcing data from multiple origins to staging areas, improving data availability for analytical reporting and BI dashboards with the help of Python and SQL languages.- Diagnosed and resolved pipeline issues, increasing scalability and optimize performance by 30%, ensuring 99% data pipeline reliability.- Integrated incremental loading techniques, reducing resource consumption up to 80% and improving data synchronization speed by 30%.- Developed and fine-tuned ETL processes to enhance overall efficiency and performance.- Implemented an ETL logging system to track pipeline status, improving bug resolving time by reducing it to 50% less then previous time.- Executed a seamless data migration from PostgreSQL to MS SQL Server, improving access management and system integration.- Successfully Implemented Apache Airflow on standalone ETL pipelines for better scheduling and monitoring.

Karāchi, Sindh, Pakistan

- Collaborating with "The Fertility Partners," a leading organization in the North American and Canadian medical industry, focusing on advanced fertility treatments.- Partnered with senior team members to manage and optimize ETL pipelines coming from 12+ Fertility clinics, ensuring 100% data flow continuity and timely integration.- Utilize AWS Glue for the creation and ongoing monitoring of robust data pipelines with the help of Python language and other required libraries.- Employed AWS Athena with the help of Python & SQL to automate the retrieval and compilation process, which speeds up report generation by 80%.- Utilized AWS S3 for data storage, implementing logical partitioning into Bronze, Silver, and Gold Zones to optimize costs by skipping AWS Redshift and structured S3 as both a data lake and data warehouse, enhancing data management and accessibility for clients.- Scraped data across at least 8+ Canadian provinces, retrieving over 50,000 plus referring physician records across Canada, consolidating information into DynamoDB, improving targeted marketing and schedule management for hospitals.- Created and maintained scalable pipelines for 15+ clients with the help of Terraform. Terraform significantly helped us in scaling ETL pipelines for our multiple clients.

Dubai, United Arab Emirates

- Extract large and complex data with the help of SQL language from client’s data sources by performing ETL process.- Filtered and cleaned data using multiple tools including Python, Alteryx and Excel, improving accuracy of financial reports by up to 95%.- Find useful, and actionable information in large data sets.- Identifying and communicating financial data discrepancies to client and senior management.- Closely work with team lead to Develop and implement data collection systems, data analytics and other strategies to optimize workflow.- Dealt with high influx of projects (more than 6 projects at a time) by setting and adjusting priorities.- Coach other less experienced colleagues provide them with on-the-job training.

Karachi

- Use SQL for fetching large and complex Data from Database for Analytical Reporting.- Make and optimize SQL Queries for Monthly, Weekly and adhoc reporting.- Make Dashboard on Power BI for Yearly and Quarterly Audit reports where they can analyze Audit department's Quarterly and yearly performances.- Use Python language and Data Science Algorithm and Statistical Analysis to Predict Branch Take up with an accuracy of more than 86.7% with almost 5 years of training data.

Karachi

- Worked as a Backend Developer for Game Development.- Used OOP concepts and Logic building for 3D Game development on Unity 3D.- Worked on C# programming language for development.- Successfully perform Unit testing and beta testing for multiple games.