Bashar Ilyas
InfoVision Inc. / Client: Comerica Bank
Lewisville,United States
11
years of professional experience
Dynamic Cloud and Data Engineer with a decade of technical experience, specializing in AWS, Snowflake, dbt, SQL, Python, and Informatica Cloud. Expertise in designing, developing, automating, validating, troubleshooting, and optimizing scalable ELT/ETL pipelines for analytics, regulatory reporting, financial data processing, and business intelligence applications. A strong background in AWS-based data workflows and Snowflake performance tuning complements proficiency in Python-driven data quality automation and SQL transformation logic. Merging cloud data engineering skills with a solid systems engineering foundation enables structured troubleshooting, root-cause analysis, meticulous documentation practices, operational reliability, and effective stakeholder collaboration within complex enterprise environments.
Work History
Data Engineer - Cloud
2 Years- Designed, developed, and maintained scalable ELT data pipelines using Snowflake, SQL, Python, dbt, and Informatica Cloud to support enterprise analytics and regulatory reporting workloads.
- Worked on AWS-based data workflows involving Amazon S3, AWS Lambda, AWS Glue, IAM, CloudWatch, Step Functions, EventBridge, EC2, and Secrets Manager to support ingestion, automation, monitoring, and secure configuration management.
- Supported cloud-based data modernization initiatives involving AWS-hosted Snowflake environments, improving scalability, reliability, and operational efficiency.
- Developed Python-based automation frameworks to validate high-volume financial data across source and target systems, improving consistency, repeatability, and reducing manual validation effort.
- Built Python and Snowpark scripts to automate completeness checks, duplicate checks, null checks, primary key validation, count reconciliation, transformation validation, and data integrity checks.
- Used SQL extensively to analyze data issues, validate transformation logic, perform source-to-target comparisons, and support regulatory reporting workflows.
- Performed Snowflake query tuning, workload analysis, warehouse optimization, and data model improvements to reduce pipeline bottlenecks and improve execution performance.
- Troubleshot production pipeline issues, including failed loads, schema mismatches, transformation defects, file ingestion issues, data discrepancies, performance degradation, and source file issues.
- Used CloudWatch and enterprise monitoring tools to investigate job failures, review logs, track pipeline health, and support operational troubleshooting.
- Partnered with data analysts, engineering teams, QA teams, and business stakeholders to define transformation rules, source-to-target mappings, reporting logic, and release requirements.
- Contributed to CI/CD and release management practices using Git, GitLab Pipelines, Docker, and Terraform to improve deployment consistency and reduce manual effort.
- Designed traceable and auditable data flows to support governance, compliance, regulatory reporting, and enterprise data quality standards.
- Participated in Agile delivery using JIRA, supporting sprint planning, backlog refinement, defect resolution, release readiness, and production support.
Systems Engineer - Data Automation
5 Months- Developed Python-based automation and reporting workflows to process, validate, and analyze financial and operational data across multiple healthcare facilities.
- Used Python, Pandas, and structured data transformation logic to clean, reconcile, and prepare datasets for leadership reporting and operational decision-making.
- Designed automated data workflows to reduce manual reporting effort, improve process consistency, and support faster review of business and financial performance.
- Built Microsoft Power Platform applications and workflow automations to streamline healthcare operations, approvals, tracking, and cross-facility business processes.
- Troubleshot data inconsistencies, reporting gaps, workflow failures, and process bottlenecks to improve data reliability and operational efficiency.
- Partnered with business stakeholders to gather requirements, translate operational needs into data-driven automation solutions, and deliver practical reporting improvements.
- Supported performance improvement initiatives by analyzing operational trends, identifying inefficiencies, and recommending process changes based on data insights.
Systems & Software Engineer
7 Months- Developed and maintained ETL workflows for financial reporting using Informatica Cloud, Snowflake, SQL, and Python.
- Developed Python-based validation scripts to compare source and target datasets, identify mismatches, and verify transformation accuracy.
- Automated data quality checks using Python to improve testing consistency, reduce manual QA effort, and support repeatable validation processes.
- Used SQL for data analysis, transformation validation, reconciliation, and root-cause investigation of data discrepancies.
- Supported Snowflake workload tuning and SQL optimization for high-volume financial data processing.
- Collaborated with cross-functional teams to define transformation logic, deployment strategies, regulatory data flow requirements, and defect resolution plans.
- Used JIRA to track development tasks, production issues, sprint commitments, release dependencies, and QA deliverables.
- Contributed to data governance through traceable, auditable, and well-documented data pipeline processes.
Systems Engineer
5 Years 2 Months- Led system integration, testing, troubleshooting, validation, and performance improvement initiatives in mission-critical technical environments.
- Performed root-cause analysis for complex system issues and coordinated corrective actions with engineering teams, stakeholders, and vendors.
- Improved operational procedures to strengthen reliability, reduce turnaround time, and increase delivery consistency.
- Supported technical documentation, risk mitigation, quality validation, environment readiness, and service continuity activities.
- Built a strong systems engineering foundation in structured troubleshooting, reliability improvement, technical documentation, operational discipline, and performance optimization.
Education
Master of Science - Systems Engineering & Management
Bachelor of Electronics Engineering
Skills
Cloud Platforms: AWS
Amazon S3
AWS Lambda
AWS Glue
IAM
EC2
Step Functions
EventBridge
CloudWatch
Secrets Manager
AWS-hosted data environments
Data Warehousing: Snowflake
Snowpark
cloud data warehousing
warehouse optimization
query tuning
Data Transformation: dbt
Informatica Cloud / IICS
SQL transformation logic
source-to-target mapping
Programming & Scripting: Python
SQL
Pandas
Node.js
Python Automation: data validation automation
reconciliation scripts
metadata-driven testing
pipeline checks
data quality frameworks
Data Engineering: ELT/ETL pipelines
data modeling
data migration
batch processing
regulatory reporting workflows
Performance Tuning: Snowflake query tuning
SQL optimization
workload analysis
pipeline performance improvement
root-cause analysis
Data Quality & Governance: validation frameworks
reconciliation
audit-ready data flows
data integrity checks
regulatory compliance
GitLab Pipelines
Git
Docker
Terraform
Monitoring & Observability: CloudWatch
Datadog
Prometheus
Grafana
Methodologies: Agile/Scrum
JIRA
stakeholder collaboration
production troubleshooting
Languages
English
Timeline
Data Engineer - Cloud
InfoVision Inc. / Client: Comerica Bank
06.2024 - CurrentRead More
Systems Engineer - Data Automation
Riceland Healthcare
01.2024 - 06.2024Read More
Systems & Software Engineer
InfoVision Inc. / Client: Comerica Bank
05.2023 - 12.2023Read More
Systems Engineer
Naval Precision Electronic Complex / Karachi Shipyard / Yard Services Department
12.2015 - 02.2021Read More
National University of Sciences & Technology
Bachelor of Electronics Engineering
Read More
University of Texas at Dallas
Master of Science from Systems Engineering & Management
Read More
ADDITIONAL INFORMATION
- Work Authorization: H-1B Visa — Authorized to work in the United States
- Location: Lewisville, TX — Available for Dallas onsite/hybrid/remote roles
- Interests: AI-driven automation, cloud architecture, enterprise data modernization, scalable analytics platforms