Ajay Vasantha
Liberty Hill,TX
Summary
Accomplished ETL Developer with extensive experience at Fiserv, specializing in SAP BODS and cloud data integration. Proven track record in designing scalable data pipelines and optimizing performance, while demonstrating strong problem-solving skills. Expert in AWS and Snowflake, delivering impactful solutions that enhance data quality and reporting capabilities.
Overview
20
20
years of professional experience
1
1
Certification
Work History
ETL Developer / Migration Consultant / Data Engineer
HPI
Infosys, TX
07.2022 - 01.2025
- - Built data lake architecture using AWS Lake Formation and Amazon S3.
- - Integrated Azure Data Lake Storage and Snowflake for hybrid data processing.
- - Led SAP S/4HANA migration using SAP BODS and SLT.
- - Developed profiling jobs using SAP BODS and Information Steward.
- - Designed DQ rules, exception handling, and scalable pipelines on AWS Glue.
- - Automated transformations with Python, Lambda, and Cloud Functions.
- - Integrated SAP and non-SAP data into Snowflake for enterprise reporting.
Sr. SAP BODS / S4 HANA Migration Consultant / Cloud Data Engineer
Fiserv
Infosys, Atlanta
01.2022 - 06.2022
- - Designed SAP BODS pipelines integrating Azure/AWS data into Snowflake.
- - Built LTMC templates and configured SLT for real-time replication.
- - Developed HANA views, performance tuning, and Syniti integration.
- - Automated audit and reconciliation between SAP and Snowflake.
Sr. SAP BODS Lead
Costco
Infosys, WA
06.2021 - 12.2021
- - Extracted data from MDG and rebuilt SAP BW flows as native HANA models.
- - Implemented ETL automation and reusable BODS components.
sortation associate
Amazon services llc
DAU7, AUSTIN, TX
09.2020 - 04.2021
Sr. SAP BODS Consultant
ExxonMobil
Houston, TX
05.2019 - 08.2019
- - Developed HANA-optimized BODS workflows and migrated SAP BW logic.
DevOps Migration Consultant / BODS-HANA Developer & Admin
Bank of America
, TX
11.2016 - 08.2018
- - Migrated SAP Ariba data using SAP BODS and Informatica.
- - Developed reusable automation scripts and CI/CD pipelines using Jenkins & GitLab CI.
- - Containerized scripts using Docker; used Ansible for provisioning.
- - Created IaC using Terraform, and integrated monitoring via Prometheus/Grafana.
- - Centralized logging using ELK Stack; supported migration to AWS.
Sr. Database DBA / BODS-BOBJ Developer & Admin
Flowserve
, TX
06.2014 - 03.2015
- - Developed reports with SAP BO (WebI, Crystal, Dashboards).
- - Built ETL using BODS, SSIS, Oracle PL/SQL; optimized queries using Toad/SQL Developer.
- - Administered Oracle/SQL Server DBs with RMAN, performance tuning, and monitoring.
- - Automated deployments via Jenkins; implemented monitoring with ELK.
Power BI Reporting Consultant / BODS-BOBJ Developer
DCP Midstream
Denver, CO
12.2013 - 05.2014
- - Developed ETL pipelines using SAP BODS for enterprise data integration and transformation.
- - Created reports and dashboards using SAP BusinessObjects Web Intelligence (WebI), Crystal Reports, and Xcelsius.
- - Designed interactive dashboards and visualizations in Microsoft Power BI for operational KPIs and executive reporting.
- - Built data models in Power BI using DAX and Power Query to enable self-service BI.
- - Integrated data from Oracle, SQL Server, and SAP systems into Power BI for unified analytics.
- - Published Power BI reports to the Power BI Service with scheduled refreshes and row-level security.
- - Collaborated with business users to gather requirements and deliver actionable insights.
BODS ETL Migration Specialist
Verizon
, TX
02.2012 - 11.2013
- - Led BODS migration for vSAP; built dashboards and universes using BO tools.
BO/BODS Administrator / Developer
TransAlta Corporation
, Canada
03.2010 - 03.2011
- - Managed ETL environments, performed data quality analysis.
BO/BODS Consultant
ICW Group
San Diego, CA
06.2009 - 02.2010
- - Built Medicaid ETL pipelines and performed address cleansing.
BO/BODS Consultant
Citi Bank
, TX & India
08.2005 - 10.2008
- - Delivered SAP R/3 and BW data conversions using BODS and BO.
BO/BODS Consultant
Unilever
, India
05.2005 - 07.2005
- - Created BODS mappings and dataflows; performed cleansing and validation.
Education
MCA -
Bharathidasan University
Chennai, India01.2001
Skills
- ETL & Data Migration: SAP BODS, Informatica PowerCenter, Informatica IICS, Talend, Syniti ADM, SAP SLT, SAP Migration Cockpit
- Data Warehousing: Oracle, SQL Server, SAP HANA, Snowflake, Teradata
- BI & Reporting: SAP BOBJ (WebI, Crystal, Xcelsius), Power BI, SAP Fiori, Tableau
- Cloud Platforms: AWS (S3, EC2, RDS), Azure (Data Factory, Blob Storage), GCP (BigQuery, Cloud Storage)
- Database & Scripting: Oracle DBA, PL/SQL, SQL, Python, Shell Scripting
- DevOps Tools: Jenkins, GitLab CI/CD, Azure DevOps, Ansible, Terraform, Docker
- Monitoring & Logging: ELK Stack, Prometheus, Grafana
- Data Science & ML Tools: Python (Pandas, NumPy, Scikit-learn, Matplotlib, Seaborn), Jupyter, TensorFlow (basic), MLflow, Power BI, SQL, AWS S3, SAP HANA, Git
- SAP Technologies: SAP S/4HANA, SAP MM, SAP BTP, Fiori, IDocs, BAPIs, RFCs, Web Services, OData
- Data integration
- ETL development
- Data warehousing
- Data quality
- SQL programming
- Cloud solutions
- Data modeling
- Performance tuning
- Version control
- Python programming
- Data profiling
- Data mapping
- Data transformation
- Data validation
- Data security
- Data migration
- ETL modeling
- AWS database services
- Microsoft SQL server
- Change data capture
- Data warehousing management
- Metadata management
- Report generation
Accomplishments
- got good appriciation from hpi clients to deliver ontime with high efficient etl data framework
Certification
- snowflake certification
References
References available upon request.
Status
U.S. Permanent Resident (Green Card)
Timeline
ETL Developer / Migration Consultant / Data Engineer
HPI
07.2022 - 01.2025
Sr. SAP BODS / S4 HANA Migration Consultant / Cloud Data Engineer
Fiserv
01.2022 - 06.2022
Sr. SAP BODS Lead
Costco
06.2021 - 12.2021
sortation associate
Amazon services llc
09.2020 - 04.2021
Sr. SAP BODS Consultant
ExxonMobil
05.2019 - 08.2019
DevOps Migration Consultant / BODS-HANA Developer & Admin
Bank of America
11.2016 - 08.2018
Sr. Database DBA / BODS-BOBJ Developer & Admin
Flowserve
06.2014 - 03.2015
Power BI Reporting Consultant / BODS-BOBJ Developer
DCP Midstream
12.2013 - 05.2014
BODS ETL Migration Specialist
Verizon
02.2012 - 11.2013
BO/BODS Administrator / Developer
TransAlta Corporation
03.2010 - 03.2011
BO/BODS Consultant
ICW Group
06.2009 - 02.2010
BO/BODS Consultant
Citi Bank
08.2005 - 10.2008
BO/BODS Consultant
Unilever
05.2005 - 07.2005
MCA -
Bharathidasan University
Similar Profiles
Dennis BatesDennis Bates
Field Service Technician at HPIField Service Technician at HPI
Kay WangKay Wang
Senior Business Operation Manager at HPISenior Business Operation Manager at HPI
KARANKUMAR RASURKARANKUMAR RASUR
Test Lead at HPITest Lead at HPI
John DoyéJohn Doyé
Senior Production Supervisor at BuildASign.comSenior Production Supervisor at BuildASign.com
Alejandro PerezAlejandro Perez
IT Support Specialist at City of AustinIT Support Specialist at City of Austin