Vijayakumar Alagasamy
Data Engineer
Singapore
Summary
Over 15 years of experience in designing, developing, and maintaining large-scale business applications including data migration, requirement gathering, integration, team management, and testing. 6+ years of hands-on experience in the Hadoop ecosystem with strong expertise in designing and developing and support Big Data applications. Proven domain expertise across Banking, Finance, Gaming, and Logistics industries. Performed Spark failure analysis (executor OOM, memory tuning, data skew) Supported Hive queries, partitioning strategies, and performance optimization
Overview
18
18
years of professional experience
4
4
Certifications
Work History
Big Data Support Engineer
Citibank-NA, Singapore (LTIMindtree)
01.2022 - 11.2025
- The Vallar program was designed and deployed in Asia as a result of significant internal fraud identified in GCG. The current implementation of Vallar utilizes Oracle database to centralize the data acquired from regional and country sources. The data is fed to Actimize, a vendor product. Actimize applies set of rules to the data to generate issues and alerts. The alerts are sent to Case Management Tool for further investigation. We have migrated the legacy Actimize application into a Big Data environment to enhance scalability and processing capabilities.
- Roles:
- Provided L2 production support for Hadoop and Spark jobs running on multi-node clusters.
- Monitored daily batch and streaming jobs; resolved job failures within SLA.
- Analyzed Spark executor failures, memory issues, and data skew problems.
- Handled incident, problem, and change tickets using ServiceNow.
- Supported Hive queries and optimized performance using partitioning and indexing.
- Engaged in data identification, sourcing, profiling, cleansing, integration, and delivering actionable insights.
- Reduced repeat Spark failures through memory tuning and configuration fixes.
- Tools and Technologies: Cloudera, PySpark, Airflow, Talend Framework, Shell Script, Hive, Oracle 11g, AutoSys, ServiceNow
Support Engineer
Singapore Airlines, Singapore (Tata Consultancy Services)
01.2021 - 01.2022
- Coordinated with Dev and Infra teams during production outages.
- Supported ETL pipelines using Sqoop and Hive.
- Scheduled and monitored workflows via AutoSys.
- Provided L2 production support for Hadoop and Spark jobs running on multi-node clusters.
- Monitored daily batch and streaming jobs; resolved job failures within SLA.
- First-level analysis of job failures and alerts.
- Restarting failed jobs and validating data completeness.
- Tools and Technologies: HDFS, Apache Airflow, Apache Spark, MySQL, AWS RDS, AWS EC2, S3
Application Support Engineer
ABN AMRO, Singapore (Tata Consultancy Services)
07.2019 - 12.2020
- Supported ETL pipelines using Sqoop and Hive.
- Scheduled and monitored workflows via AutoSys.
- Investigated data quality issues impacting downstream reports.
- Created shell scripts for automation and monitoring.
- Analyzed application and system logs using Linux commands.
- Tools and Technologies: HDFS, Hive, Python, Airflow, PySpark, Sqoop, MySQL, Control-M
Data Migration/Senior ETL Developer
Schroders, Singapore
01.2018 - 03.2019
- Work with various source data formats such as Oracle, SQL Server, MS Access, MS Excel and Text files to extract relevant data and migrate to our Data warehouse databases.
- Design and implement a table partitioning on a very large databases (VLD) in order to maximize scale and performance of VLDBs and tuned much more granularly than smaller databases.
- Develop SSIS packages with C# logic in SSIS script task to customize for data formatting purpose.
- We have used Bulk copy program for small databases.
- Scheduled the Jobs in Management Console and monitored by configuring to Email.
- Tools and Technologies: SQL Server, SSIS, SSRS, Tortoise SVN,TFS,GIT
Contractor (Senior Associate)
Core Banking, Credit Suisse Bank
05.2017 - 01.2018
- ETL, data profiling, data quality and clean ups for SSIS packages.
- Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
- Created SSIS packages to populate data from various data sources.
- Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
- Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
- Involved in Tuning and Performance and Query optimization of the Database as required by the application.
- Created mapping tables to find out the missing attributes for the ETL process.
- Tools and Technologies: SQL Server, SSIS, SSRS, Tortoise SVN
Contractor (Senior Technical Consultant)
Digital Retail Internet Banking, OCBC Bank
12.2016 - 05.2017
- Providing banking services to customer with screen / flow optimized for desktop browser.
- Built using combination of HTML rendered by ASP.NET MVC. Index/Entry page to function is using full HTML rendered by server side; operation will return partial HTML rendered by server side but via AJAX calls.
- Created SQL Stored Procedures, Triggers and Functions.
- Tools and Technologies: VS.NET 2010 Framework 4, C#.NET, SQL Server, Tortoise SVN, MVC, jQuery
Contractor (Senior Technical Consultant)
Fund Service Reporting System, Standard Chartered Bank
05.2016 - 11.2016
- Designed Technical Design Document for the main modules.
- Designed & Developed the dataset for another system call straight2Bank (S2B) to generate the report.
- Data migration using SQL loader for the historical data.
- Responsible for the development of report generation using Oracle BI Publisher.
- Tools and Technologies: Oracle PL/SQL 11g, and Oracle BI Publisher
Direct Contractor (Senior Technical Consultant)
Accenture thru Manpower, Singapore
06.2015 - 01.2016
- Logistics Super Suite (LSS) : Developed DOTNET API Components in LSS Application for APL Logistics.
- Tools and Technologies: VS.NET 2013 with MS Framework 4.5, C#.NET, Oracle, SpreadsheetGear (enhanced Excel component), VBA
Contractor (Senior Technical Consultant)
VISA Inc. thru Encora, Singapore
03.2014 - 06.2015
- Client Administrative Tools and Services (CATS) is a suite of tools used to support Debit Processing. CATS typically refer to the single page portal that enumerates the tools found under the CATS umbrella. Site Minder is used for authentication to specific tools.
- Risk Services Management (RSM) is a tool used to define debit card fraud rules for each client. The fraud rules are stored on Tandem and retrieved by calling stored procedures directly on Tandem via a .NET to Java translator.
- Role & Responsibilities:
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
- Reporting using SSRS.
- Proficient in design, develop, test, troubleshoot and maintain Excel macros using VBA.
- Work within the governance structure to ensure that requirements are prioritized and delivered within deadline.
- Participating in Unit Testing/SIT/UAT.
- Created SQL Stored Procedures, Triggers and Functions.
- Tools and Technologies: VS.NET 2010 with MS Framework 4, C#.NET, ASP.Net, JQuery, Component Art, WCF, SSRS, SQL Server, MVC,TFS, Tandem, SQLLINK
Contractor (Senior Technical Consultant)
oneWB Work Bench, Standard Chartered Bank
06.2013 - 03.2014
- OneWB is the single platform for all client facing people to manage their client relationships and perform activities on behalf of their clients. It provides superior client management by aggregating everything we know about our clients automates key business processes and provides a platform for collaboration across all businesses in the Wholesale Bank.
- Role & Responsibilities:
- Involved in development.
- Developed Stored Procedures, Triggers and Functions.
- Participating in Unit Testing/SIT/UAT.
- Providing necessary training to team members based on their technical/functional efficiency.
- Tools and Technologies: VS.NET 2010 with MS Framework 4, C#.NET, ASP.Net, WCF, SQL Server, SVN
Contractor (Senior Technical Consultant)
Risk Based Computing (RBC), Standard Chartered Bank
08.2012 - 05.2013
- This project has number of RBC reports for SG country for regulatory purpose. It show list of equity & fixed income investments held in funds/fund group. The outcome of these reports is to calculate the specific & generic risks of the securities held. Developed the front end of an application used by the bank’s security service team users. Coded in 3-tier architecture i.e. the user interface layer, business layer and the database layer. Participated in the entire life cycle (requirements, use cases, test cases, design, coding, testing.
- Role & Responsibilities:
- Involved in the design and development.
- Developed Stored Procedures, Triggers and Functions.
- Interacting with the users for change requests and issues.
- Performance tuning of application objects. Usage of indexes, Query rewriting, Views.
- Participating in Unit Testing/SIT/UAT.
- Tools and Technologies: VS.NET 2010 Framework 4, C#.NET, ASP.Net, Access VBA, Oracle 10g, SVN
Contractor (Senior Technical Consultant)
FI Future FOBO, Barclays Capital (Product Control – IT)
01.2012 - 03.2012
- The FI Futures FOBO reconciliation tool calculates the adjustment by applying Asia Closes to the R&N Trade and Position data. This tool also uses to reconcile the position and trade differences and recognize breaks that are caused by timing issues. Such breaks can be manually selected by the Product Control user to be rolled forward until they are cleared by the matching position in the opposite system.
- Role & Responsibilities:
- Involved in the design and development.
- Developed Stored Procedures, Triggers and Functions.
- CruiseControl.NET implementation.
- Created deployment build script using Microsoft Build.
- Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge
- Tools and Technologies: WPF, SSIS, Barclays RPFP Framework, SQL Server 2005/2008, LINQ, Entity Framework, ASP.Net, MVC, Perforce (Source Control) and TeamCity (build), MS Build Script
Contractor (Senior Technical Consultant)
Prime Service Futures Commission, Barclays Capital (Product Control – IT)
03.2011 - 12.2011
- The futures commission attribution process is performed daily by prime services team for Asia and London books. This tool contains all the data required for product control to do reporting and is a much more robust and properly supported application.
- Role & Responsibilities:
- Developed Stored Procedures, Triggers and Functions.
- Designed SSIS packages for migrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data).
- Tools and Technologies: WPF, SSIS, Barclays RPFP Framework, SQL Server 2005/2008, LINQ, Entity Framework, Excel/ Access VBA, Perforce (Source Control)
Production Support Dashboard, Standard Chartered Bank
06.2007 - 11.2010
- This Production Support Dashboard is developed on .NET with different databases and used "Building Layered Applications" which brings many advantages, including cleaner code, increased maintainability and the ability to spread application's load over multiple servers.
- Responsibilities:
- Involved in the design and development of various batch jobs and web forms.
- Design and development of T-SQL Stored Procedures, Triggers, Functions.
- Technology: MS Project, ASP.Net, C#, WPF, MVC,JavaScript, jQuery, AJAX, Sybase, Oracle 10g, MSSQL, Tortoise SVN
Education
Master of Science - Computer
M.Sc.
Bachelor of Science - Computer
B.Sc.
Diploma - Computer Science and Engineering
D.C.Sc.E
Diploma - RDBMS
Oracle
Diploma - Data warehousing
Erwin, COGNOS, Informatica and BO
Skills
Data Eco System: Hadoop, Sqoop, Hive, Apache Spark, AWS, YARN, BigQuery
undefinedCertification
Microsoft Certified Application Developer for Microsoft .NET (MCAD.Net) (Transcript # 3090447)
Experience Highlights
- Lead Specialist – Data Engineer, LTIMindtree Jan’22 – Nov’25
- Assistant Consultant, TCS Jul’19 – Jan’22
- Senior Developer, Schroders Jan’18 – Mar’19
- Senior Associate, Cognizant, Singapore May’17 – Jan’18
- OCBC Bank thru Comtel, Singapore Dec’16 – May’17
- Standard Chartered Bank, Singapore May’16 – Nov’16
- Accenture thru Manpower, Singapore Jun’15 – Jan’16
- Visa Inc. thru Encora, Singapore Mar’14 – Jun’15
- Standard Chartered Bank, Singapore Jun’12 – Mar’14
- Barclays Capital, Singapore (thru iKas) Mar’11 – Mar’12
- Standard Chartered Bank, Singapore Jun ’07 – Nov’10
Timeline
Big Data Support Engineer - Citibank-NA, Singapore (LTIMindtree)
01.2022 - 11.2025
Support Engineer - Singapore Airlines, Singapore (Tata Consultancy Services)
01.2021 - 01.2022
Application Support Engineer - ABN AMRO, Singapore (Tata Consultancy Services)
07.2019 - 12.2020
Data Migration/Senior ETL Developer - Schroders, Singapore
01.2018 - 03.2019
Contractor (Senior Associate) - Core Banking, Credit Suisse Bank
05.2017 - 01.2018
Contractor (Senior Technical Consultant) - Digital Retail Internet Banking, OCBC Bank
12.2016 - 05.2017
Contractor (Senior Technical Consultant) - Fund Service Reporting System, Standard Chartered Bank
05.2016 - 11.2016
Direct Contractor (Senior Technical Consultant) - Accenture thru Manpower, Singapore
06.2015 - 01.2016
Contractor (Senior Technical Consultant) - VISA Inc. thru Encora, Singapore
03.2014 - 06.2015
Contractor (Senior Technical Consultant) - oneWB Work Bench, Standard Chartered Bank
06.2013 - 03.2014
Contractor (Senior Technical Consultant) - Risk Based Computing (RBC), Standard Chartered Bank
08.2012 - 05.2013
Contractor (Senior Technical Consultant) - FI Future FOBO, Barclays Capital (Product Control – IT)
01.2012 - 03.2012
Contractor (Senior Technical Consultant) - Prime Service Futures Commission, Barclays Capital (Product Control – IT)
03.2011 - 12.2011
- Production Support Dashboard, Standard Chartered Bank
06.2007 - 11.2010
Alagappa University - Master of Science, Computer
Bharathiar University - Bachelor of Science, Computer
- Diploma, Computer Science and Engineering
- Diploma, RDBMS
- Diploma, Data warehousing