Abdullah Khan Email & Phone Number

Monroe Township, NJ, US

Aurora, Ontario, CA

• Built and delivered high-quality data architecture with logical data modules using STAR and SNOWFLAKE schemas, incorporating Dimensional Modeling techniques to ensure technical requirements were effectively met.
• Designing scalable data storage and scheduled ETL jobs using AWS services like Amazon RDS, S3, Redshift, and Glue.
• Implemented resilient architectures using Amazon Route 53, Auto Scaling, and Elastic Load Balancing for uninterrupted service.
• Led the implementation of Apache Airflow through Google Cloud Composer to orchestrate and automate ETL workflows, ensuring efficient scheduling, error handling, and monitoring of data pipelines. Collaborated with.
• Applied AWS security best practices, including IAM policies, AWS Organizations, VPC configurations, and encryption mechanisms. protect data and resources.
• Analyzed AWS cost structures and developed strategies for cost optimization, using Reserved Instances, Spot Instances, and Cost Explorer.

Toronto, ON, CA

• Utilized historical data to develop SQL scripts and identify potential gaps in resources that could be faced during the execution window of D2011 Unit 1 Reactor Outage continued to proposed timeline solutions in.
• Developed SQL scripts to compare the current outage scope with the historical scope and identify work that could be rescheduled to optimize cost reduction and ensure the critical path does not exceed the outage window
• Used engineering drawings to find the most cost-effective and efficient method to change Unit 4 water filter by identifying different routes that water going to the filter could be rerouted without limiting surrounding.
• Managed and defined overall project scope by using SQL scripts to analyze historical and backlog data then continued to develop PowerBI reports determining the most effective work to include in the outage window
• Led Risk Mitigation Milestone for D2011 Unit 1 Outage - Used historical database datasets to identify and categorized potential risks, created insightful data infrastructure and models to track identified risks and.

Toronto, CA

• Collaborated with students from all years across electrical engineering to understand the difficulties they were facing and the changes they would like to see and brought them to light during meetings with faculty.