Vinoth Kumar
Tuticorin
Summary
To work in a competitive environment on challenging assignments that shall yield the twin benefits of job satisfaction and steady-paced professional growth.
Overview
13
13
years of professional experience
Work History
Associate Consultant
Tata Consultancy Services
06.2021 - Current
- Worked on complete V9 to v10 migration for Singapore reporting i.e MAS reporting.
- Experience in Controller View objects like Data Sources, Data model, Aggregation, Shorthand,Portfolio, Modify models, Freeform, Tabular Reports, etc.
- Implemented business logic, data lineage mapping, and traceability for Mas649 and Mas610 reports .
- Extensively worked on Node JS script to load data from external system .
- Analysing business requirements, Estimate the effort required to complete Change Request/ SMW Fixes, Develop and integrate IT solutions by using appropriate development methodologies and Standards
- Perform Unit testing in DEV and provide support for UAT
- Extensive experience in Financial Service industry related : Credit risk , Market risk and Liquidity risk .
- Involve in SQL Query tuning, Report generation and database design.
Assistant Consultant
Tata Consultancy Services
01.2017 - 05.2021
- Involved in complete Agile Process
- Extensively worked on SQL Loader to load data from external system and developed PL/SQL programs to dump the data from temporary tables into base tables
- Written Complex SQL statements using joins, sub queries, inline views and Oracle Analytical Functions
- Analysing business requirements, Estimate the effort required to complete Change Request/ SMW Fixes, Develop and integrate IT solutions by using appropriate development methodologies and Standards
- Perform Unit testing in DEV and provide support for UAT
- Create DB objects – Procedures, Functions, Views, Packages, and Indexes as part of FRRs
- Have good exposure to Oracle Supplied packages, Bulk Collect, PL/SQL Collections, Materialized Views, Ref Cursor, Dynamic SQL Concepts and Exceptions
- Involve in SQL Query tuning, Report generation and database design
- Ensure that the proper quality procedures and standards are followed in all the phases
- Actively participate in daily Status Meeting and internal meetings
- Created project related documents
DB Developer
Plintron Global Technology Pvt Ltd
04.2012 - 12.2016
- Involved in complete Software Development Life Cycle (SDLC)
- Extensively worked on SQL Loader to load data from external system and developed PL/SQL programs to dump the data from temporary tables into base tables
- Written Complex SQL statements using joins, sub queries, inline views and Oracle Analytical Functions
- Analyse business requirements, Estimate the effort required to complete Change Request/ SMW Fixes, Develop and integrate IT solutions by using appropriate Development methodologies and Standards
- Perform Unit testing in DEV and inform customer for UAT
- Create DB objects – Procedures, Functions, Views, Packages, and Indexes as part of FRRs
- Have good exposure to Oracle Supplied packages, Bulk Collect, PL/SQL Collections, Materialized Views, Ref Cursor, Dynamic SQL Concepts and Exceptions
- Involve in SQL Query tuning, Report generation and database design
- Ensure that the proper quality procedures and standards are followed in all the phases
- Create proper tags for FRRs in Visual Source safe Tool (Accuracy)
- Involve in resolving production issues and ensure the SLA is met
- Organize weekly Status Meeting and internal meetings
- Perform Disaster Recovery test for the application and work closely with Server team
Education
Bachelor of Engineering - Computer Science and Engg
SCAD College of Engineering and Technology
TirunelveliSkills
- Axiom SL
- UNIX
- PL/SQL
- SQL
- Shell Script
- SQL Server
- MYSQL
- Node js
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge.
Personal Information
- Father's Name: K. KANAGA SUNDAR
- Date of Birth: 22/Aug/1989
- Marital Status: Married
Timeline
Associate Consultant
Tata Consultancy Services
06.2021 - Current
Assistant Consultant
Tata Consultancy Services
01.2017 - 05.2021
DB Developer
Plintron Global Technology Pvt Ltd
04.2012 - 12.2016
Bachelor of Engineering - Computer Science and Engg
SCAD College of Engineering and Technology
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services