Mahendar Vangala
Senior Data Engineering | Cloud & Analytics Architect
Hyderabad,TS
Summary
Dynamic Senior Data Engineering and Analytics Leader with over 15 years of experience in architecting scalable data platforms, leading high-performing engineering teams, and executing cloud transformations on AWS and Azure. Expertise includes ETL/ELT pipeline development, real-time and batch data processing, BI modernization, and analytics governance. Proficient in Python, PySpark, SQL, data warehousing, and cloud-native architectures, with a proven track record of enhancing platform reliability and driving strategic data initiatives. Recognized for effective team coaching and collaboration with cross-functional stakeholders to deliver robust enterprise-grade analytics solutions.
Overview
16
16
years of professional experience
3
3
Certifications
Work History
VP Cloud Engineer ( Data Engineering Initiatives )
Synchrony
06.2019 - Current
- Led the enterprise migration of data and analytics platforms to AWS, enabling scalable, secure, cloud-native data processing.
- Directed and mentored data engineering and BI teams, improving delivery efficiency and governance maturity.
- Developed centralized intake and delivery pipelines for BI reporting, improving reporting efficiency by 40%.
- Implemented governance for metadata, access control, dashboards, and enterprise data quality.
- Collaborated with cross-functional teams (product owners, engineers, and analytics leads) to gather requirements and build scalable solutions.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
- Optimized PySpark pipelines supporting data science workloads, improving processing times by 90%.
- Enabled cloud-based analytics platforms through the adoption of IAM, standardized provisioning, and automation-driven workflows.
Lead Data & Analytics Engineer
Fortuna Entertainment Group (Prev Ideaspark Solutions Pvt Ltd)
10.2016 - 06.2019
- Spearheaded end-to-end reporting solutions using Power BI, Tableau, and Azure Analysis Services, providing meaningful insights to stakeholders.
- Developed self-service analytics using Azure Analysis Services and Power BI, enabling business users to generate insights independently.
- Defined reporting KPIs and analytical frameworks, ensuring data integrity, and strategic decision-making.
- Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
- Designed and implemented predictive analytics models for customer segmentation and business optimization.
- Partnered with business teams to understand requirements, enhancing reporting and visualization capabilities.
- Acted as liaison between clients and technical associates, translating complex ideas into easy-to-understand explanations.
- Built and led a 40+ member Data Engineering and BI team, fostering technical innovation and high-performance execution.
- Established data ingestion pipelines and data architectures for multiple gaming and entertainment industry clients.
Associate Project Lead (Data Engineering & Visualization)
Pennyswise Solutions (An Ogilvy & Mather Company)
10.2013 - 10.2016
- Led development of ETL & visualization architecture for global clients in telecom & loyalty sectors.
- Designed ETL solutions for data extraction, transformation, and loading, automating extraction from multiple systems (mainframes and DBs).
- Built end-to-end reporting solutions using Power BI, SQL Server, Power BI streamlining business intelligence.
- Maintained up-to-date knowledge of industry trends and best practices in order to enhance overall effectiveness in managing projects successfully.
- Developed sentiment analysis dashboards, integrating social media, campaign, and KPI monitoring for real-time insights.
- Coordinated cross-functional teams to meet client requirements and achieve project objectives.
ETL Support Engineer
GroupOn
07.2013 - 10.2013
- Played a key role in data migration during a merger of two major gaming organizations, transitioning from Oracle and SQL Server to Teradata.
- Led migration of reporting frameworks from BusinessObjects (BO) to MicroStrategy & Tableau, improving reporting accuracy and scalability.
- Designed certification frameworks processing 2+ million daily transactions to ensure consistency between gaming and account systems.
- Optimized ETL pipelines by refining long-running queries, improving performance using Teradata improvement analyses.
Software Engineer (Data & BI Team)
Inoy Comptech
03.2012 - 07.2013
- Played a key role in data migration during a merger of two major gaming organizations, transitioning from Oracle and SQL Server to Teradata.
- Led migration of reporting frameworks from BusinessObjects (BO) to MicroStrategy & Tableau, improving reporting accuracy and scalability.
- Designed certification frameworks processing 2+ million daily transactions to ensure consistency between gaming and account systems.
- Optimized ETL pipelines by refining long-running queries, improving performance using Teradata improvement analyses.
Systems Engineer (Data Migration & ETL Development)
Infosys
02.2010 - 03.2012
- Infosys Hyderabad, Telangana, India
- Led key data migration and ETL development project for one of the major banks in Turkey, overseeing the development of data migration solutions for a wide range of data products including loans, retail, and corporate banking.
- Designed and developed ETL solutions using Informatica Power Exchange to extract data from multiple systems (mainframes and DBs) to operational data stores, improving data transformation and loading processes.
- Collaborated with business teams to understand project requirements and deliver solutions that met project timelines and objectives.
Education
BTech - ECE
JBIET (Affiliated to JNTU)
Hyderabad, Telangana, India01.2009
Skills
Data Visualization & BI: Tableau, Power BI, Klipfolio, Azure Analysis Services
Cloud Technologies: AWS (EMR, S3, Glue, IAM), Azure (HDInsight, ADF)
Programming & Scripting: Python, PySpark, SQL
Data Engineering & Pipelines: ETL Development using Informatica, DataStage, ADF, SSIS, Data Modelling (Erwin), Ab Initio, SAS Migration
Team leadership,Strategic planning,Coaching and mentoring,Decision-making
Certification
CEO Award Excellence & Star Awards - Synchrony (2022 & 2024)
Accomplishments
- Developed the Visualization team from scratch, expanding it to a 10-member team supporting enterprise-wide reporting solutions.
- Designed and implemented enterprise-wide Power BI dashboards, improving reporting efficiency by 40%.
- Automated repetitive reporting tasks, saving 500+ hours annually.
- Developed self-service analytics using Azure Analysis Services and Power BI, empowering business users.
- Optimized data visualization strategies, enhancing executive decision-making.
- Developed critical dashboards, leading to significant cost savings and saving thousands of dollars.
- Led cross-functional reporting initiatives, aligning analytics with business strategy.
Timeline
VP Cloud Engineer ( Data Engineering Initiatives )
Synchrony
06.2019 - Current
Lead Data & Analytics Engineer
Fortuna Entertainment Group (Prev Ideaspark Solutions Pvt Ltd)
10.2016 - 06.2019
Associate Project Lead (Data Engineering & Visualization)
Pennyswise Solutions (An Ogilvy & Mather Company)
10.2013 - 10.2016
ETL Support Engineer
GroupOn
07.2013 - 10.2013
Software Engineer (Data & BI Team)
Inoy Comptech
03.2012 - 07.2013
Systems Engineer (Data Migration & ETL Development)
Infosys
02.2010 - 03.2012
BTech - ECE
JBIET (Affiliated to JNTU)