Summary
Overview
Work history
Education
Skills
Certification
Timeline
Generic

Aamani Veldandi

Summary

Results-driven Senior Data Engineer with 11+ years of experience in data analytics, ETL, and data warehousing. Adept at leveraging SQL, Python, Unix scripting to extract insights and drive business decisions. Proven expertise in IBM Infosphere DataStage, Power BI, SQL, Oracle, Netezza, Python, Informatica PowerCenter, OBIEE. Strong problem-solving and stakeholder management skills, with experience in Agile and Waterfall methodologies. Proven ability to lead and mentor teams, as well as work independently to deliver complex projects on time. Have experience as BMC Control-M admin and writing test cases in robot framework as well.

Overview

12
12
years of professional experience
4
4
years of post-secondary education
1
1
Certification

Work history

Senior technical consultant

HSBC
05.2024 - 11.2024
  • Part of ABS Automation project which mainly aims to automate the build and testing of Control-M packages.
  • Responsible for creating the robot framework tests to automate the testing for Control-M Agent Functionality.
  • Created the ansible templates for automating the build and testing of Control-M packages.
  • Created the Jenkins pipelines to automate the ansible templates and robot framework agent tests.
  • Responsible for installing the version 9.0.20.200 Control-M Enterprise Managers, Control-M servers with a high availability node set up.
  • Responsible for installing the control-M agents on the application VM’s.
  • Did analysis on how AppDynamics monitors the Control-M system’s CPU, memory, process.
  • Wrote test cases in Robot framework using API’s gather the information from AppDynamics and prepare a report.

Shared Services Migration Engineer

Deutsche Bank
01.2023 - 03.2024
  • Part of the Proetus Shared Services team formed for the migration of applications from On-Prem Deutsche Bank to cloud DWS.
  • Responsible for end to end on boarding of applications on to shared services, Control-M Informatica IICS, Axway MFT.
  • Responsible for installing the IICS Secure agents on GCP VM’s and migrating the on-premise Deutsche Bank informatica PowerCenter applications to IICS GCP cloud.
  • Responsible for installing the version 9.0.20.100 Control-M Enterprise Managers, Control-M servers on GCP VM’s across regions with a high availability node set up.
  • Responsible for creating the mail accounts in Axway MFT and configuring the file transfer process for applications.
  • Managed ITIL-based processes for incident, change, and problem management, ensuring timely resolution and continuous improvement.
  • Responsible for installing the control-M agents on the application VM’s.
  • Successfully performed the disaster recovery for Control-M, Axway applications.
  • Successfully upgraded the Control-M EM, Control-M servers, Control-M agents from version 9.0.20.100 to 9.0.21.200 and again further to version 9.0.21.200.
  • Worked on automating the control-m deployment process by creating the python scripts using Control-M swagger API’s and integrating them with Jenkins.
  • Created the python scripts using the Control-M APIs to automate creation of site standards in Control-M for individual applications.

Data Engineer

Department for Education, UK
11.2022 - 01.2023
  • Worked on Creating the ETL Pipelines using Informatica DEI tool as part of the Attainment Indicator Project.
  • Responsible for Coordinating with Business Analysts to understand the requirements and create the ETL pipelines required by Attainment project
  • Responsible for giving the sessions for new joiners to install Informatica DEI and get all the access
  • Responsible for Creating the onboarding document which can be reused by new joiners

Senior data engineer

HSBC | Wipro Private Limited
08.2021 - 07.2022
  • Prepared the solution design document for an Oracle version upgrade project from oracle v11g to v19c and successfully delivered it with zero defect ensuring business affect is minimal
  • Responsible for Enterprise level application support(L3) making sure, they completed on time within SLA, involved in abend resolution, doing reverse engineering to find out the issues, RCA and resolve them.
  • Designed the ETL pipelines using DataStage to integrate the applications with data coming from various sources.
  • Successfully delivered the datacenter migration project where we migrated the applications involving Oracle, DataStage, Cognos as part of datacenter shutdown process
  • Involved in conducting successful disaster recovery exercise on the application and database
  • Worked on enhancements which involved addition of new logic, alteration of existing logic, addition of new columns and integrating new systems into them

Lead Data Engineer

AXA EQUITABLE | Tata Consultancy Services
06.2016 - 08.2021
  • Involved in understanding business requirements, preparing the detailed design level mappings
  • Responsible for end-to-end data modelling.
  • Involved in database design to create the objects in IIAS BLUDB
  • Developed the DataStage code to load the target tables integrating various sources XML, txt, csv
  • Responsible for unit testing, Integration testing and deployment of code using CICD methodology
  • Created ETL pipelines using Azure Data Factory to load the data from on prem DB2 database to Azure Blob storage
  • Worked extensively on performance tuning to increase the batch performance.
  • Responsible for migrating around 70 Data Marts from Oracle to
    Netezza in 10 phases ensuring the data matches exactly with minimal affect to business
  • Responsible for implementing DataStage Migration from Version 7.5 -Version 8.7 and then from version 8.7 to version 11.5.
  • Responsible for providing application support to IBM team as subject matter expert to migrate the Datawarehouse from Netezza to IIAS (BLUDB) DB2 along with DataStage version upgrade to version 11.7
  • Successfully delivered the Informatica Rewrite project as part of cost cutting migrated the complete code from Informatica mappings to DataStage jobs
  • Responsible for migrating the Mainframes process to Distributed
    systems, replacing the COBOL programs with DataStage code.

Senior ETL Developer

AXA EQUITABLE| Tata Consultancy Services
Hyderabad
03.2013 - 06.2016
  • Responsible for Enterprise level application support(L3) for OSDW (Operational System Data Warehouse) application.
  • Monitoring the Batch cycle for the various applications, resolving ABEND incidents to meet SLAs and ensure the batch Cycle is unperturbed.
  • Working on Service Requests/Incidents by clients and attack the Known Error Problems and reduced incidents. Worked on process improvements and value Addition, cross training done with in the account.
  • Documentation – Induction Manual, System Manual, Design Documents, Unit Test Plan, Unit Test Results.
  • Continuous improvements – Proactive monitoring and controls, Incident trend analytics
  • Metrics Management – SLA, Service Requests capacity management, Problem ticket management, Defect, and priority management
  • Month-end and Quarter closure support.
  • Batch Support in handling any server outage (unplanned outage due to Netezza maintenance issues/Oracle slowness.) Access Requests and User enquiries.
  • Involved in delivering the project USAA Brokerage re - platform where we developed the DataStage code to replace the existing brokerage platform PH3 with NFS.

Education

Bachelor of Technology - Electronics and Communication Engineering

Kakatiya Institute of Technology And Sciences
Warangal, India
08.2008 - 05.2012

Skills

  • IBM Infosphere DataStage
  • Informatica Power Centre
  • Data Ware housing
  • Power BI
  • OBIEE
  • Oracle DB
  • Netezza
  • IIAS(BLUDB) DB2
  • SQL
  • Python
  • Unix
  • Azure Data Factory
  • GCP
  • IBM Mainframe CA-7
  • Control-M
  • Microsoft VSTS
  • Jira
  • Jenkins
  • GitHub
  • Ansible

Certification

  • Microsoft Azure Fundamental, AZ900
  • IBM Certified Solution Developer - Info Sphere DataStage, v8.5
  • Oracle Database: SQL Certified Expert Certification
  • Oracle Database 11g Administrator Certified Associate Certification
  • Completed LOMA Level-1 in INSURANCE
  • Google Cloud Fundamentals: Core Infrastructure
  • Essential Google Cloud Infrastructure: Foundation

Timeline

Senior technical consultant

HSBC
05.2024 - 11.2024

Shared Services Migration Engineer

Deutsche Bank
01.2023 - 03.2024

Data Engineer

Department for Education, UK
11.2022 - 01.2023

Senior data engineer

HSBC | Wipro Private Limited
08.2021 - 07.2022

Lead Data Engineer

AXA EQUITABLE | Tata Consultancy Services
06.2016 - 08.2021

Senior ETL Developer

AXA EQUITABLE| Tata Consultancy Services
03.2013 - 06.2016

Bachelor of Technology - Electronics and Communication Engineering

Kakatiya Institute of Technology And Sciences
08.2008 - 05.2012
Aamani Veldandi