Available for new opportunities

Ayaz
Mirza

Senior Consultant · Data Engineer · ETL Specialist

Senior Consultant at Wipro with 6+ years building high-volume ETL pipelines using Ab Initio, scripting automation with Shell & Ansible, and deploying scalable solutions on AWS, Azure & GCP.

Get In Touch ↗ View My Work
6+
Years Experience
13+
Projects Completed
15+
Technologies
2+
Happy Clients

Who I Am

Data Engineer with 6+ years of experience in designing, building, and optimizing high-volume ETL pipelines using Ab Initio and SQL. I specialize in turning raw, messy data into reliable, structured workflows that power business decisions.

Skilled in automation with Shell scripting and Ansible, data visualization with Power BI, and leveraging GCP & AWS for scalable cloud-based solutions. Strong background in troubleshooting performance issues and ensuring data quality.

I'm also a frontend enthusiast who builds AI-powered tools with React, Gemini, and various LLM APIs. Based in Lucknow, India, currently at Wipro Limited.

ayazmirza54@gmail.com
Languages
JavaScript Shell Script C++ HTML5 CSS3 SQL
Frameworks & Libraries
React Node.js Express.js TailwindCSS Bootstrap
Data & ETL
Ab Initio ETL Power BI PostgreSQL MySQL Grafana
Cloud & DevOps
AWS GCP Azure Ansible Git
AI & Tools
Gemini AI Claude AI ChatGPT Figma Notion

Where I've Worked

Nov 2019 – Present
Wipro Limited
Greater Noida, India
● Current
Senior Consultant
  • Process client-side information via Ab Initio ETL to provide actionable business insights
  • Extensive experience designing graphs and scheduling jobs through Control Centre
  • Proficient in scripting Unix shell commands for ETL pipeline optimization
  • Monitor ETL job execution and address issues proactively to minimize delays
  • Created shell scripts to automate monitoring of critical server metrics
  • Leveraged Grafana, Control Center, Queryit, and SQLExplorer for operational efficiency
  • Appointed as L2, providing technical guidance to L1 teammates
June 2019 – Oct 2019
Cosmo Infosolutions
Lucknow, India
Completed
Frontend Web Developer
  • Built responsive landing pages using HTML, CSS, JavaScript, and ReactJS
  • Designed layouts that are visually engaging and easy to navigate on all screen sizes
  • Applied careful attention to typography, color, and layout for polished user experience
  • Created seamless, enjoyable interfaces for every user across desktop and mobile

Things I've Built

Web / AI Projects
01
Text to Content AI
AI-powered tool that converts raw text into polished content using the Gemini API with real-time generation.
02
Intellisketch — AI Drawing Tool
AI-powered drawing app that uses Google Gemini to interpret and solve mathematical sketches and graphical problems in real-time.
03
Text/Code Utils.AI
AI-enhanced utility tool by Gemini for streamlined text analysis, transformation, and intelligent code generation workflows.
04
Chat2PDF — Conversational PDF
AI-powered app for conversational PDF interaction using Gemini and LangChain — chat with your documents naturally.
DevOps / Cloud Projects
05
UnixBot — Shell Command Chatbot
A Gemini-powered chatbot specializing in Unix commands, scripting, and shell knowledge for power users.
06
QuerySmith — SQL Generator
Natural language to SQL chatbot powered by Gemini. Ask questions in plain English, get optimized SQL queries back.
07
EC2 Manager TUI
A terminal UI tool to manage AWS EC2 instances via the Python SDK — control your cloud from the command line.
08
System Metrics Logger
Automated script that logs CPU and memory usage metrics to a PostgreSQL database for monitoring and analytics.
Other Noteworthy
Studysensei
Quiz Generator using Gemini AI API
React TailwindCSS Gemini
Live ↗
Movie Finder
Movie search using The Movie Database API
JavaScript TMDB API
Live ↗
Stone Paper Scissors
Classic game built with React and TailwindCSS
HTML/CSS JavaScript
Live ↗
Quote Generator
Dynamic quote generation from external API
React Axios
Live ↗

From My Blog

Dev.to Oct 12, 2024 5 min read
Intellisketch: AI Powered Drawing Tool 🖌️
Building an AI-Powered Mathematical Sketching App with Gemini and real-time canvas interaction.
Dev.to Sept 14, 2024 4 min read
Migrating from ChatGPT API to Gemini AI API
A practical walkthrough of migrating a production app from OpenAI's ChatGPT API to Google's Gemini AI API.
Dev.to Apr 13, 2023 6 min read
ChatGPT on Loop using BabyAGI and AutoGPT 🤖
Exploring autonomous AI agents — using BabyAGI and AutoGPT to orchestrate ChatGPT in continuous task loops.
Dev.to Jan 28, 2023 7 min read
Text and Code Utilities App using OpenAI API
Building a full-featured text analysis and code generation utility app powered by the OpenAI API from scratch.

Let's Work Together

Have a project in mind or want to chat about data engineering, ETL pipelines, or AI tools? My inbox is always open.

ayazmirza54@gmail.com