AJAY MISHRA
Pune
Summary
Data & Analytics Engineering Leader with 15+ years of experience in enterprise data platforms, data engineering, cloud transformation, and analytics across financial services and technology environments. Currently an Manager,Solution Engineering leading scalable data engineering and pipeline initiatives focused on data quality, automation, governance, and data-driven decision-making. Strong expertise in AWS, Snowflake, Talend, Apache Spark, and Amazon EMR, with additional experience in GCP BigQuery, Amazon Redshift, Python, and enterprise data integration.
Overview
16
16
years of professional experience
Work History
Manager, Solution Engineering
WESTERN UNION
05.2025 - Current
- Led enterprise data and analytics transformation initiatives to build a Unified Analytics Platform, establishing a single source of truth and enabling a 360-degree view of enterprise data to support data-driven decision-making and business outcomes.
- Led cross-functional engineering teams to design and deliver scalable data solutions using AWS, Snowflake, Talend, Apache Spark, and Amazon EMR, ensuring platform reliability, scalability, and performance.
- Owned programme roadmap execution and delivery governance, including stakeholder management, resource planning, prioritization, risk and dependency management, and alignment across business, product, architecture, and engineering teams.
- Improved data platform scalability, data quality, and operational efficiency through automation, intelligent data engineering, and AI-driven solutions to reduce manual effort and accelerate delivery.
- Partnered with senior business, product, architecture, and engineering stakeholders to define strategic data capabilities, translate business requirements into technology solutions, and deliver actionable analytics and insights.
- Led automation and framework initiatives that delivered ~$100K in quarterly cost savings while reducing engineering effort by 15–20%.
Technology Delivery Lead
TATA CONSULTANCY SERVICES (TCS) – PAYPAL
10.2021 - 01.2026
- Led a 20+ member distributed technology team focused on enterprise data, reporting and analytics, enabling data-driven decision-making across payment platforms.
- Led design and implementation of a new reporting platform, contributing to a 20% improvement in product performance.
- Migrated 5,000+ reporting queries from Amazon Redshift to GCP BigQuery, ensuring timely delivery of 50,000+ reports daily within SLA.
- Automated manual production activities, reducing recurring issues by 25% and manual effort by 30%.
- Enforced DQMF controls in reporting and data warehousing processes, enhancing data quality and ensuring compliance.
- Collaborated with architecture and engineering teams to design scalable, reliable and production-ready data solutions.
- Coordinated with cross-functional teams to address production challenges, manage priorities, and uphold delivery commitments.
- Provided end-to-end technology support for payment applications including Fastlane, Checkout, Merchant Onboarding, Post Payments and Settlement Withdrawals.
Assistant Consultant
TATA CONSULTANCY SERVICES (TCS) – STANDARD CHARTERED BANK
05.2017 - 10.2021
- Consulted on data strategy, architecture and technology standards, engaging stakeholders across business, technology and operations to define requirements and deliver data solutions that aligned with organisational goals.
- Developed and implemented a multi-country Data Governance Operating Model, enhancing ownership, accountability, data integrity, and analytics capabilities across regions.
- Supported Future State Architecture initiatives covering data collection, storage, distribution and controls, helping reduce data-related technical debt.
- Designed data ingestion mechanisms across multiple source systems into data lakes and developed a Common Data Model.
- Led distributed-data processing using Hadoop, MapReduce, Spark, Hive and Presto, processing approximately 2–2.5 TB of data daily.
- Developed a BFS customer onboarding digitisation solution using SCD2 updates in Hadoop.
- Developed cloud-resource optimisation solutions generating approximately USD 100K annual savings.
- Led Hadoop-as-a-Service migration activities including coding standards and Kerberos security implementation.
- Delivered regulatory data extraction and secure transfer solutions using shell scripting and Hive queries, ensuring compliance with industry standards and enhancing data security.
Telco SME / Application BI Architect
IBM INDIA – VODAFONE ESSAR LIMITED
05.2015 - 04.2017
- Led Teradata-to-Netezza migration and optimisation, including end-to-end transition support and a 40% reduction in query response times.
- Led automation of ETL and reporting workflows, achieving 25% efficiency improvement and generating USD 150K in annual savings.
- Architected and implemented enterprise BI solution to enhance data accessibility and support informed decision-making.
- Delivered architectural enhancements, migration strategies, and operational improvements across data warehouse and BI environments.
Senior Developer
ENCORA TECHNOLOGIES – SCOPE INTERNATIONAL / STANDARD CHARTERED
01.2014 - 03.2015
- Led end-to-end delivery from design to production deployment, coordinating developers, testers, and support teams to ensure timely project completion.
- Developed data marts and conducted source-data normalisation, FSLDM mapping, and data profiling, enhancing data accessibility through Pig/Hive processing for refined partitioned datasets.
Technical Support Specialist
IBM INDIA – VODAFONE ESSAR LIMITED
11.2010 - 01.2014
- Facilitated Teradata-to-DataStage ETL migration and EDW optimisation; converted 500+ SAS reports to Cognos, decreasing report generation time by 30%.
- Improved data latency from D-8 to D-2 and increased SLA performance from 60% to 98%.
- Optimised platform and resources, reducing Teradata nodes by 30% and lowering manpower costs by 25%.
Education
Post Graduate Diploma - Machine Learning & AI
International Institute of Information Technology
Bangalore01-2022
Bachelor of Engineering - Information Technology
Shri Govindram Seksaria Institute of Technology & Science
Indore01-2010
Skills
- Cloud & Data Platforms: AWS (S3, EMR, EC2, Glue, Athena, Lambda, Kinesis, DMS), Snowflake, GCP BigQuery, Redshift
- Data Engineering: Talend, Apache Spark/PySpark, Hadoop, Hive, Presto, Airflow, ETL/ELT, data integration
- Programming & Databases: Python, SQL, Shell scripting, Oracle, Teradata, Netezza, MySQL, SQL Server
- Analytics & BI: Tableau, SAS, Cognos, PAXATA, KPI development, dashboards, enterprise reporting
- Data Management: Data Governance, Data Quality, DQ controls, data modelling, metadata concepts, privacy/controls
- Data pipeline automation
- Delivery: Agile/Scrum, programme governance, stakeholder management, production readiness, risk/dependency management
- Data transformation
- Programme leadership
- Data governance
- Cloud architecture
CERTIFICATIONS
- AWS Certified Cloud Practitioner
- Microsoft Azure Fundamentals
- Teradata Certified Professional (V2R12)
- IBM Certified – Cognos 10 BI Reports
Timeline
Manager, Solution Engineering
WESTERN UNION
05.2025 - Current
Technology Delivery Lead
TATA CONSULTANCY SERVICES (TCS) – PAYPAL
10.2021 - 01.2026
Assistant Consultant
TATA CONSULTANCY SERVICES (TCS) – STANDARD CHARTERED BANK
05.2017 - 10.2021
Telco SME / Application BI Architect
IBM INDIA – VODAFONE ESSAR LIMITED
05.2015 - 04.2017
Senior Developer
ENCORA TECHNOLOGIES – SCOPE INTERNATIONAL / STANDARD CHARTERED
01.2014 - 03.2015
Technical Support Specialist
IBM INDIA – VODAFONE ESSAR LIMITED
11.2010 - 01.2014
Post Graduate Diploma - Machine Learning & AI
International Institute of Information Technology
Bachelor of Engineering - Information Technology
Shri Govindram Seksaria Institute of Technology & Science