VAIDHYANATHAN KS

• Served as an Application L2 and L3 support professional, with a strong background in banking and finance.
• Leveraged technical expertise in Linux, SQL, Hadoop, AWS, and OpenShift to resolve complex IT issues efficiently.
• Demonstrated a commitment to service excellence by improving incident resolution times, enhancing first-call resolution rates, and exceeding client expectations.
• Managed the SLA Tracker and Tableau for all applications supported.
• Proactively monitored the applications to avoid downtime, applying preventive measures to re-run applications within response time.
• Active participation in change implementation, PIV (Post Implementation Validation), and DR (Disaster Recovery) activities.
• Proactive involvement in problem management, analyzing tickets, and providing solutions/fixes for repetitive issues.
• Mentored junior developers, fostering a culture of continuous learning and skill improvement.
• Collaborated with product managers to define technical requirements and develop innovative solutions for complex problems.

Key Projects & Achievements

Project 1: Bank of Data and CRM (Client: Bank of Montreal)

Role: Application Support Analyst – L2/Tech Lead (Jan 2025 – Present)

• Provided end-to-end application support for data extraction and transformation processes, ensuring seamless integration of data from various sources.
• Troubleshoot and resolve issues related to data pipelines and workflows, maintaining high availability and accuracy of data services using ETL and Python.
• Utilized SQL to validate data integrity, troubleshoot discrepancies, and identify potential issues in data pipelines.
• Proactively monitored system health, addressed performance bottlenecks, and implemented fixes to optimize application efficiency.
• Coordinated with IDP operations and sales performance teams to collect and manage daily data essential for business decision-making.
• Technologies Used: AWS Lambda, S3, Redshift, Glue, Airflow, SQL, and Python.

Project 2: Royal Bank of Canada – Capital Markets.

Role: Application Support Analyst – L3 (June 2021 – January 2025)

• Supported a multinational bank's market risk assessment program, enabling consistent reporting on high-risk customers across the enterprise.
• Managed data ingestion from 30 different sources through proprietary applications, performing transformations until the data reached the OLAP server.

Application: Counterparty Credit Risk (CCR).

• Worked on CCR systems, executing and monitoring end-to-end batch jobs using OpenShift, Autosys, and Stonebranch. Responsible for data extraction (Hadoop, SQL, Sybase), and report validation, ensuring SLA compliance and accurate risk assessments.

Application: Credit Checker (CC).

• Supported EOD batch jobs for exposure data using Apache Kafka, Java/Spring microservices, and AWS SNS. Proactively resolved Kafka publish/timeout issues and performed offset recovery using Postman APIs, ensuring uninterrupted batch completion within SLA.
• Technologies Used: HIVE, HADOOP, MSSQL, shell scripting, Oracle, Autosys.

• Conducted in-depth research on EU customs regulations and messaging formats.
• Acquired the standard message format required by EU customs, and developed detailed Business Requirements (BRD) and System Requirements Specifications (SRS).
• Coded in Python to calculate cargo dimensions (length, width, and height), and visually represented this data in a 3D format for a Loading Optimizer project.