Summary
Overview
Work History
Education
Skills
Websites
Certification
Additional Information
Technical Skills
Timeline
Generic

Ameya Pade

Pune

Summary

Results-driven Data Engineer with 3+ years of experience in designing and optimizing data pipelines, ETL workflows, and data models across cloud and on-prem environments. Adept in SQL, Python, PySpark, and Azure ecosystem, with hands-on exposure to Airflow, Kafka, and NoSQL systems. Proven track record in delivering scalable data solutions, improving system performance, and supporting business intelligence initiatives. Known for taking ownership, collaborating with stakeholders, and building reusable, high-quality data assets that align with enterprise analytics goals.

Overview

5
5
years of professional experience
4
4
years of post-secondary education
3
3
Certifications

Work History

Software Analyst

Yardi Software
Pune
04.2023 - Current
  • Designed and optimized ETL pipelines using SQL and Azure Data Factory to consolidate and clean data from diverse systems.
  • Leveraged Azure Databricks and PySpark for distributed data processing to support reporting and analytics needs.
  • Integrated and worked with NoSQL databases (MongoDB, Cassandra) during performance analysis and data migration use cases.
  • Resolved complex post-conversion issues across Yardi platforms (Voyager, Breeze, Classic, Beacon) using SQL and Excel-based analytics.
  • Conducted performance tuning on SQL procedures and implemented indexing strategies for efficient data warehousing and data retrieval.
  • Developed and deployed monitoring solutions using Airflow and Docker, improving ETL reliability and traceability.
  • Supported real-time and batch data workflows with Kafka exposure, contributing to streaming data architecture improvements.
  • Participated in dimensional modeling and schema design to optimize data structures for Power BI reporting.
  • Created internal documentation and reusable scripts to streamline reporting and support agile delivery.

System Engineer

Tata Consultancy Services
Pune
05.2021 - 03.2023
  • Developed Python automation scripts to manage and monitor batch jobs, significantly reducing manual intervention.
  • Created reporting pipelines using Cognos and SQL for high-frequency operational dashboards.
  • Implemented solutions using Pandas and Python scripting to perform data cleaning and exploratory data analysis (EDA).
  • Gained hands-on exposure to Docker for containerization of internal tooling and job runners.
  • Collaborated with teams to implement data virtualization techniques, reducing dependency on physical database layers.
  • Analyzed and optimized ticket resolution patterns, providing data-driven insights for customer support improvement.
  • Assisted in stakeholder communication, bridging technical execution and business expectations in agile projects.

Co-founder & CTO

UFF (Startup Venture)
Ch. Samhajinagar
12.2019 - 12.2020
  • Led data engineering operations including automation of billing, customer segmentation, and procurement forecasting.
  • Designed and deployed a Power BI dashboard for executive decision-making.
  • Applied SQL and ML models for customer behavior analysis and procurement quantity prediction.
  • Conducted cohort analysis to improve customer retention and identify business growth trends.
  • Managed business operations across procurement, logistics, and CRM using custom tools and spreadsheets.

Education

B.Tech - Mechanical Engineering

VIT University
Vellore, TN
07.2015 - 05.2019

Skills

Python

SQL

PySpark

Pandas

MySQL

Git

Azure Data Factory

Azure Databricks

Kafka

Airflow

Power BI

Excel

Tableau

Cognos

ETL Pipelines

Dimensional Modeling

Data Warehousing

Data Virtualization

MongoDB

Cassandra

Docker

Machine Learning Basics

Cohort Analysis

Certification

Google Data Analytics - Coursera

Additional Information

Familiar with Agile/Scrum methodologies and ceremonies, Strong communication and stakeholder engagement skills, Interest in emerging trends: GenAI, LangChain, ML integrations, Enjoy mentoring peers and working in multicultural, cross-functional teams

Technical Skills

Python, SQL, PySpark, Pandas, MySQL, Git, Azure Data Factory, Azure Databricks, Kafka, Airflow, Power BI, Excel, Tableau, Cognos, ETL Pipelines, Dimensional Modeling, Data Warehousing, Data Virtualization, MongoDB, Cassandra, Docker, Machine Learning Basics, Cohort Analysis

Timeline

Software Analyst

Yardi Software
04.2023 - Current

System Engineer

Tata Consultancy Services
05.2021 - 03.2023

Co-founder & CTO

UFF (Startup Venture)
12.2019 - 12.2020

B.Tech - Mechanical Engineering

VIT University
07.2015 - 05.2019

Similar Profiles

CREATE PROFILE
Ameya Pade