COMSATS University Islamabad

Master of Science in Bioinformatics

CGPA: 3.41/ 4.00

Khawaja Fareed University of Engineering and Information Technology - KFUEIT

Bachelor of Science in Bioinformatics

CGPA: 3.83/ 4.00 (Gold Medal)

Senior Data Engineer

#1-Architected end-to-end data warehousing solutions, including staging areas, data marts, data warehouses, and operational data stores, to support analytics and reporting needs. Used Azure Synapse Analytics and Azure Data Lake to build flexible data models that catered to both current and future business needs. #2-Spearheaded the design, development, and maintenance of scalable data pipelines using Azure Cloud Services, ensuring seamless data integration and processing across the organization. Leveraged Azure Data Factory (ADF) and Azure Databricks to deliver high-performance, reliable solutions that met evolving business requirements. #3-Optimized OLAP systems by tuning cube structures, aggregations, and indexing strategies for improved query performance. #4-Implemented process optimizations for ETL workflows, reducing execution times and increasing efficiency. Led troubleshooting initiatives to quickly identify and resolve issues, ensuring minimal downtime and data accuracy with Azure Data Factory and Azure Databricks. #5-Developed and optimized physical and logical data models in Azure Synapse Analytics and Azure SQL Database, enhancing system performance and reducing latency. Improved query response times for both batch and real-time data processing. #6-Tuned and optimized Azure-based database systems (Azure SQL Database, Azure Synapse Analytics) to improve storage efficiency, query performance, and processing speed. #7-Led data provisioning and access management, ensuring data security and governance. Provided strategic direction to safeguard critical data assets while ensuring they were accessible and compliant with relevant regulations. #8-Ensured high data quality standards by rigorously monitoring, reconciling, and validating ETL processes. Applied Azure Data Factory and Azure Monitor to maintain the integrity of data in the data warehouse. #9-Tools, Technologies, Skills, & Languages: Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Azure SQL Database, Azure Data Lake, SQL, Indexing, Python, PySpark, Data Warehousing, ETL/ELT, Data Migration, Enterprise Data Catalog, Incremental Loading, Semi-Structured Data, SDLC, Data Pruning, Distributed Data Processing, Delta Lake, Medallion Architecture, Big Data.

Data Engineer

#1-Developed, tested, and maintained robust, scalable data pipelines using industry-best practices to ensure seamless data flow and processing across the organization. Consistently delivered optimized solutions that supported evolving business requirements, improving pipeline performance and reliability using AWS Cloud Services. #2-Played a key role in designing the architecture for data warehousing solutions, including staging areas, data warehouses, data marts, and operational data stores. Delivered data models and architectures that supported both current and future analytics and reporting needs. #3-Led troubleshooting efforts for ETL processes, quickly identifying and resolving issues to minimize downtime and ensure data accuracy. Implemented process improvements that reduced ETL execution time and increased efficiency. #4-Tuned and optimized database systems to ensure high performance, recommending and implementing enhancements that improved storage, query performance, and processing speed. #5-Automated critical database processes, creating scripts and tools that improved operational efficiency and reduced manual workloads. #6-Owned data provisioning and access management, providing strategic direction on data security and governance to safeguard critical data assets while ensuring accessibility. #7-Ensured the integrity of data within the data warehouse through rigorous monitoring, reconciliation, and validation of ETL processes, consistently achieving high data quality standards. #8-Tools, Technologies, Skills, & Languages: AWS Lambda, S3, AWS Step Function, AWS SNS, AWS Glue, AWS RDS, AWS Aurora, Snowflake, DBeaver, SQL, Python, Boto3, Master Model, Schema Enforcement, Date Warehousing, ETL/ELT, CDC, Incremental loading, Hashing Algorithm, SCD.

Elevance Health Project, Data Architect

Designed and architected scalable data solutions for health insurance operations, leveraging Snowflake, AWS storage, and Azure storage to build efficient, secure, and compliant data pipelines. Delivered optimized data models and architectures that ensured seamless integration and processing across the health insurance data ecosystem, enhancing analytics, reporting, and decision-making capabilities. || Tools, Technologies, Skills, & Languages: Snowflake, AWS Storage, Azure Storage, PowerDesigner, Data Warehousing, Dimensional Modeling, Conceptual/Logical/Physical Data Modeling, SDLC, SCD, MDM (Golden Row & Golden Model), Informatica Enterprise Data Catalog (EDC), SQL, Python, Data Governance, Data Security, Cloud Architecture, HIPAA and GDPR Compliance.