Vijayakumar Alagasamy

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

Summary

Overview

Work History

Big Data Support Engineer

Support Engineer

Application Support Engineer

Data Migration/Senior ETL Developer

Contractor (Senior Associate)

Contractor (Senior Technical Consultant)

Contractor (Senior Technical Consultant)

Direct Contractor (Senior Technical Consultant)

Contractor (Senior Technical Consultant)

Contractor (Senior Technical Consultant)

Contractor (Senior Technical Consultant)

Contractor (Senior Technical Consultant)

Contractor (Senior Technical Consultant)

Education

Master of Science - Computer

Bachelor of Science - Computer

Diploma - Computer Science and Engineering

Diploma - RDBMS

Diploma - Data warehousing

Skills

Certification

Experience Highlights

Timeline