Dynamic Data Engineer and Lead Mainframe Developer with extensive experience at ASR/Aegon Netherlands B.V. Proven expertise in SQL and Python, successfully migrating legacy applications to Azure and AWS. Adept at optimizing data workflows and enhancing system performance, while demonstrating strong problem-solving skills and delivering impactful solutions in high-pressure environments.
Overview
19
19
years of professional experience
2
2
Languages
Work History
Data Engineer/Lead Mainframe Developer
ASR/Aegon Netherlands B.V./HCL Netherlands B.V.
05.2011 - Current
As a Data Engineer,
Helped in migrating LIFE Applications/Data from Legacy/AWS to Azure.
Developed and executed Python/SQL notebooks in Azure Synapse Analytics,utilizing Apache Spark pools for efficient big data processing.
Monitored and optimized data workflows using AWS CloudWatch and AWS Glue, ensuring system reliability and performance.
Migrated the On-premise Mortgages Applications(Nexus) into AWS Cloud.
Created, Deployed and managed the pipelines using Azure CI/CD.
Performed production runs in both AWS and Azure environments
As a Mainframe Developer,
Involved in the migration of VSAM to DB2 using REXX/COBOL.
Developed programs in COBOL for the migration of Application data to msg-life and to datalake tables where the data from these tables will be copied to AWS datalake.
Created PowerBI reports and dashboards for finance statistical analysis with user interactive slicers.
Provided maintenance and support for the Non-Life Applications.
Involved in the migration of Non-Life Business Policies to external vendor & decommissioned all Non-Life applications.
Developed automated scripts using R/Rstudio/Shiny on migration for performing Report level validation.
Preprocess the RAW data from instance and applied PowerBI model to create meaningful PowerBI visualizations, developed data quality analysis by creating metrics for various Business rules in Non-Life Reports.
Used Informatica Power Center client tools for transforming the data during the migration.
Acquired knowledge transfer on Applications like Mortgage, Non-Life, Generic Cobol Applications from different Business Lines and provided the necessary support.
Involved in migrating COBOL-IDMS programs to COBOL-DB2 programs.
Created innovated tools using REXX for the faster delivery of requirements in the project.
Provided permanent solutions for the incidents, reducing the incident count and on-call support for the batches.
Unisure/Mainframe Developer
Aegon UK/HCL Technologies Ltd.
06.2009 - 04.2011
Involved in the complete life cycle of an insurance product starting from the design stage to until the deployment using Lync language in Unisure environment.
Provided maintenance and support for Price corrections Application in ZOS Mainframe where fund prices will be adjusted.
Senior Mainframe Developer
Belgacom/HCL Technologies Ltd.
02.2009 - 06.2009
Involved in the conversion of Programs, Procs, IDMC DC Programs and Dialogs from Fujitsu Mainframe ( BS2K ) to IBM ZOS.
Mainframe Developer
IBM/ACS Ltd
06.2007 - 01.2009
Monitored code and overall application to drive seamless performance.
Designed and developed robust COBOL programs, resulting in improved operational productivity.
Developed and executed complex system test plans to support quality.
Troubleshot business logic and performance issues in existing mainframe applications.
Provided on-call support for the production batches