Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic
Karthikeyan Mohanasundaram

Karthikeyan Mohanasundaram

Lead
Chennai

Summary

  • Industry experience of 8+ years primarily in Oracle database and 1+ years in Azure Data Factory/ADLS/Dremio.
  • Technologies: Oracle SQL, Oracle PL/SQL, T-SQL, Dremio Cloud, Azure Data Factory, Azure Data Lake, TIBCO TDV Studio, Oracle SQR, Oracle Forms Reports and Oracle APEX.
  • Rich experience of 4+ years in US banking domain( 3 years in Fiserv DNA product ) work experience and 4 years in shipping industry work experience.
  • Having product work experience in US Mortgage loan and good knowledge in Escrow Analysis in Mortgage Loan.
  • Having 1+ years work experience in Data Analytics project in US banking.
  • Created and managed database objects viz. Packages, procedures, functions, tables, views, Materialized views, Indexes, partitions, sequences, triggers etc for 8 years.
  • Having experience in Requirement analysis, Designing and Development of PLSQL code using Stored procedures, Functions, Pipeline Functions, Packages, cursors, triggers.
  • Creating physical and virtual datasets for the business logics in dremio.
  • Advising and Implementing logics in complex SQL queries as per business needs and creating virtual datasets on top of that in Dremio.
  • Worked on database performance optimization using bulk collects, collections, indexes, hints, partitions etc.
  • Creating procedures, views and webservice in TIBCO TDV studio 8.7 as per requirements from react team.
  • Creating pipeline in Azure Data Factory and transforming the data in ADF and transfer the data to ADLS/Azure SQL Database.
  • Involved in execution of all phases of the SDLC (Software Development Life Cycle) in both waterfall and Agile methodologies.
  • Having experience in Agile mindset workflow Management tool - JIRA. Experience in working with multiple vendors and geographically distributed teams.
  • Mentoring and leading a team of developers and providing guidance to them to meet the targets within projected time

Overview

10
10
years of professional experience
5
5
years of post-secondary education
3
3
Certificates

Work History

Lead

HTC Global Services
6 2022 - Current

This project is based on developing IFC Dashboard and the objective of this project is to visualize the data/reports for the modules program/pipeline, portfolio and other related modules. The core application’s front end is developed using react and power BI. Backend data is coming from several data sources such as ADLS, Composite, MS SQL Server, Oracle and SharePoint.

Senior Associate Consultant

Infosys Chennai
06.2019 - 06.2022
  • The project is based on a modern, flexible, real-time account processing platform with a unique open architecture
  • The core banking flagship product enables complete management of banking activities such as Customer information management, Product management, Account Management, Access controls, online transactions etc
  • The core application's front end is developed using dot net and database used is Oracle 11g


Oracle Developer

Information Dynamics India
11.2017 - 05.2019
  • The objective of the project is to give customer and user additional functionality for existing module and create new module for client requirements
  • Product having front end technology based on Oracle Forms and Oracle database 11g for backend

Analyst Programmer

Aetins Global Services Pvt Ltd
06.2017 - 11.2017

The application was developed primarily to store and maintain large number of financial transaction data of the organization. The core application's front end is developed using Oracle Forms and database used is Oracle 11g.

Junior Application Specialist

Tranpac Software Solutions
03.2015 - 05.2017
  • EMARS is a system that tracks the maintenance of the containers from, the containers coming into the depot till the repair is completed.
  • FMS tracks the vessels that cannot come into a port, helps the containers from these vessels to be delivered using feeder ships. It engulfs the entire process of shipping from booking of the feeder ships till the container goods are delivered to the consignee
  • HRIS is a system to support the Human Resources team, HRIS was created to track the employee details such as their day to day login, daily activities through time sheets. HRIS also contains consolidated employee information such as Personal Profile, Previous Experience details, Leave and Permission Request Process. For the management, HRIS has Employee Movement, Leave and Permission Approval and Rejection Process, Employee Performance Management Process, Assets Management. The core application's front end is developed using Oracle APEX and database used is Oracle 11g.

Software Developer Trainee

Orange Office Technologies
08.2014 - 03.2015

FM Global Logistics is one of the leading freight forwarder in the shipping industry handling Logistics and distribution. This project contains of major modules as Forwarding, Accounts, CFS module. In forwarding module contains Air Freight, Sea Freight, Quotation, Consol, sailing schedule, etc. E-document, Doc Data option provided. History details are also maintained in the system. The core application's front end is developed using Oracle Forms and database used is Oracle 11g

Education

Bachelor of Engineering - Electronics And Communication Engineering

TJ Institute of Technology
Chennai
08.2010 - 04.2014

Higher Secondary School - Computer Science

Vellayan Chettiyar Higher Secondary School
Chennai
06.2009 - 03.2010

SSLC - Mathematics

Vellayan Chettiyar Higher Secondary School
Chennai
06.2007 - 03.2008

Skills

Oracle PL SQL, SQL , T-SQL, Dremio Cloud

Certification

Dremio | D101: Dremio Fundamentals

Accomplishments

· Consistent good performance ratings ( Commendable ) in Infosys consecutive years.

· Course Completion in “Masters in Data Science” @TopMentor Pune.

Timeline

Dremio | D102: Dremio Data Reflections

11-2022

Dremio | D103: Dremio for Data Consumers

11-2022

Dremio | D101: Dremio Fundamentals

08-2022

Senior Associate Consultant

Infosys Chennai
06.2019 - 06.2022

Oracle Developer

Information Dynamics India
11.2017 - 05.2019

Analyst Programmer

Aetins Global Services Pvt Ltd
06.2017 - 11.2017

Junior Application Specialist

Tranpac Software Solutions
03.2015 - 05.2017

Software Developer Trainee

Orange Office Technologies
08.2014 - 03.2015

Bachelor of Engineering - Electronics And Communication Engineering

TJ Institute of Technology
08.2010 - 04.2014

Higher Secondary School - Computer Science

Vellayan Chettiyar Higher Secondary School
06.2009 - 03.2010

SSLC - Mathematics

Vellayan Chettiyar Higher Secondary School
06.2007 - 03.2008

Lead

HTC Global Services
6 2022 - Current
Karthikeyan MohanasundaramLead