Ali Imran Khan

• Architected a multi-agent autonomous software development pipeline that converts JIRA tickets or prompts into production-ready code, automatically refining requirements, creating feature branches, implementing changes, running tests, and opening draft pull requests. • Implemented secure AI orchestration architecture with prompt-injection protection, API-key authentication, rate limiting, Redis-backed async job queues, and least-privilege agent tooling to ensure safe autonomous development workflows. • Architected multi-tenant enterprise API platforms (50+ endpoints) using FastAPI and .NET Core, enabling scalable SaaS services with secure authentication and RBAC. • Designed serverless ETL orchestration systems using AWS Step Functions, Lambda, and S3, automating large-scale data pipelines and distributed processing workflows. • Improved API performance by 70–80% through Redis caching, query optimization, and efficient data access patterns. • Built AI-powered data comparison and analytics systems using OpenAI and OpenSearch vector databases to detect database customization differences and generate intelligent reports. • Developed backend services for the Inspector Gadget platform, implementing large-scale SQL/Oracle dataset comparison pipelines with async processing and Parquet-based workflows. • Containerized microservices using Docker and automated infrastructure provisioning with Terraform, enabling consistent and scalable deployments.

Gained extensive experience in data engineering projects on Azure and AWS cloud platforms Prepared written summaries to accompany results and maintained thorough documentation. Collaborated on ETL (Extract, Transform, Load) tasks, ensuring data integrity and pipeline stability. Contributed ideas and suggestions in team meetings, and provided updates on deadlines, designs, and enhancements. Analyzed complex SQL queries and database structures to identify performance bottlenecks. Implemented query tuning techniques to enhance performance, including indexing, partitioning, and query rewriting. Worked closely with the development team to optimize SQL statements within applications. Conducted regular database performance tests and implemented optimization strategies. Developed and maintained documentation for the database performance tuning process. Provided recommendations for database schema design to optimize performance. Assisted in the design and development of databases, focusing on high-performance requirements.

Executed the migration of millions of records with a variance of 0.01% using SSIS and other tools. Developed comprehensive reconciliation and verification reports. Conducted mapping between various systems to accommodate significant schema changes. Participated in Business & Technical Analysis to lead migration activities. Engaged in code review processes to ensure data integrity and consistency. Tracked and reported project status to various stakeholders. Developed BI processes to collect data from internal IT systems and external sources, prepare it for analysis, run queries, and create data visualizations and reports. This enabled business users to access analytics results for operational decision-making and strategic planning.

Developed complex stored procedures and functions to capture and publish metadata. Determined database structural requirements by analyzing current operations, applications, and programming; reviewed objectives with management; and evaluated current systems. Engaged in functional specification development and design based on requirements. Designed database solutions, defined database physical structure, and established functional capabilities. Created database tables, indexes, constraints, and triggers to ensure data integrity and meet functional requirements. Provided database support by coding stored procedures for data access and data loading. Researched new technologies and standards for database implementation and digital learning services. Achieved 100% data reconciliation after migrating millions of records.

Converted stored procedures, DDLs, and DMLs between SQL and Oracle 10g. Developed SQL validation scripts to ensure data conversion accuracy between Informix and Oracle databases. Identified root causes of data anomalies. Authored test plans and conversion strategy documents. Managed databases, wrote stored procedures and triggers in PL/SQL to ensure data accessibility and integrity, and created logical and physical data models. Developed scripts for software installation, data loading, database creation, and documentation. Conducted database performance tuning. Wrote complex SQL statements, functions, and stored procedures to enhance database accessibility and integrity. Designed and created development databases, and was responsible for unit and integration testing.