Kalyan Kumar Viswanathan Rajkumar
Chennai
Summary
Enthusiastic Business Intelligence specialist with 15.5 years (4.5 years in USA, 1 year in Malaysia, Currently in Singapore) experience in Data-warehousing/Analytics projects
Overview
17
17
years of professional experience
1
1
Certification
Work History
Application Developer
Persolkelly
02.2024 - Current
- Worked on loading the target tables in Teradata database for OCBC client using the business requirements specified in mapping sheets, through BTEQ (Basic Teradata Query) and other tools
- Worked on Machine Learning POC projects using R/Python to implement algorithms for automating manual processes and improved the efficiency of operations
- Developed Unix shell scripts to validate the source file for zero record check, file date check, duplicate file check, datatype length check and then to load source table from source file
- Developed target load scripts using Teradata BTEQ to perform SCD (Slowly Changing Dimension) to categorize the stage table records into Insert, Delete and Update and then to load the target table accordingly.
Application Lead
Accord Innovations Sdn Bhd
03.2022 - 03.2023
- Gained expertise in FSLDM framework to configure all the metadata tables to enable the data loads for Standard Chartered Bank client
- Handled support role to fix the PROD failures within stipulated SLA
- Handled a team of 5 freshers to develop BTEQ scripts, stored procedures to load banking data
Technology Specialist
UST Global
09.2019 - 10.2021
- Worked on loading the target tables in Teradata database using the business requirements specified in mapping sheets through BTEQ and other tools
- Performance tuned the SQL queries to ensure the data loads are executed within the stipulated time frame
- Coordinated the deployment of the code artefacts by generating the builds using GIT and Jenkins tool.
Teradata Developer
Reliant Vision Group Inc
05.2018 - 08.2019
- Worked on migration of Teradata stored procedures to Hive scripts as part of Teradata to Hadoop migration
- Developed Informatica mappings for loading target tables from source tables and also optimized the performance
- Used Unix commands to schedule jobs in background.
Senior Associate
Cognizant Technology Solutions US Corp
03.2012 - 05.2018
- Handled role of ETL Developer and worked on loading target tables in Teradata Datawarehouse by implementing SCD in all the above 4 companies.
Senior Analyst
LatentView Analytics
10.2011 - 03.2012
- Handled role of ETL Developer and worked on loading target tables in Teradata Datawarehouse by implementing SCD in all the above 4 companies.
Technology Consultant
Hewlett-Packard GlobalSoft
08.2010 - 09.2011
- Handled role of ETL Developer and worked on loading target tables in Teradata Datawarehouse by implementing SCD in all the above 4 companies.
Project Engineer
Wipro Technologies
06.2007 - 08.2010
- Handled role of ETL Developer and worked on loading target tables in Teradata Datawarehouse by implementing SCD in all the above 4 companies.
Education
Master of Science - Mathematics
Annamalai University
PhD (Ongoing) - Mathematics, Research on Number Theory
California Public University
05.2024
Bachelors of Technology - Information Technology
Madras Institute of Technology, Anna University
05.2007
Skills
- Teradata
- SQL
- Unix
- Statistics
- ETL
- Informatica
- Machine Learning
- MS SQL Server
Websites
Languages
English
Tamil
Telugu
Details
33 Bedok South Ave 2, Singapore, 460033, Singapore, +65 98970803, kalyanvr14@gmail.com, 11/18/1985, Indian
Personal Information
Title: Senior Data Engineer
Extracurricular Activities
Cycling Trekking
Hobbies and Interests
Solving Math puzzles
Certification
AWS Knowledge: Cloud Essentials, Feb 2024
MAPR Certified Spark Developer, May 2017
MAPR Certified Spark Developer
Cleared certification of Spark Developer course from MAPR
Timeline
Application Developer
Persolkelly
02.2024 - Current
Application Lead
Accord Innovations Sdn Bhd
03.2022 - 03.2023
Technology Specialist
UST Global
09.2019 - 10.2021
Teradata Developer
Reliant Vision Group Inc
05.2018 - 08.2019
Senior Associate
Cognizant Technology Solutions US Corp
03.2012 - 05.2018
Senior Analyst
LatentView Analytics
10.2011 - 03.2012
Technology Consultant
Hewlett-Packard GlobalSoft
08.2010 - 09.2011
Project Engineer
Wipro Technologies
06.2007 - 08.2010
Master of Science - Mathematics
Annamalai University
PhD (Ongoing) - Mathematics, Research on Number Theory
California Public University
Bachelors of Technology - Information Technology
Madras Institute of Technology, Anna University
Similar Profiles
Leearnee-Jem PennyLeearnee-Jem Penny
Issuing Officer at PersolKellyIssuing Officer at PersolKelly
JOHN VERNIE DUNGCAJOHN VERNIE DUNGCA
Senior Software Engineer at PersolKellySenior Software Engineer at PersolKelly
Khair Al-Amri Mohd NajibKhair Al-Amri Mohd Najib
Sales Representative at PERSOLKELLYSales Representative at PERSOLKELLY