Vigneshwaran G

PH : +91-893*******

Email ID:adc548@r.postjobfree.com

Professional summary

Having 3+ years of experience in Oracle (SQL,PLSQL),UNIX and K2View ETL tool.

Having good experience in Oracle SQL scripts,Joins,Subqueries,Sequence.

Having good knowedge in Synonyms,views,Materialized Views,Indexes and SQL functions.

Having good experience in SQL development and adequate knowledge in PL/SQL development like creating Stored Procedures,Functions,Cursors,Triggers and Packages, Bulk collections, etc

Extensively used the utilities like SQL Developer and DBeaver.

Experienced in Extraction Transformation and Loading (ETL) process.

Experienced in version control system like GIT and SVN.

Worked in Application Support, attending production calls, troubleshooting the application and resolving bugs.

Having good experience in migration Projects.

Excellent communication, leadership, organizing, debugging, team building and motivation skills

Technical Skills:

Industry/Domain

BFSI & Telecom

Databases

Oracle 11g,

Tools exposure

SQL Developer, DBeaver,JIRA,K2View ETL tool,Putty

Programming Languages

Oracle SQL,PL/SQL,Unix,Core Java

Version Control

SVN,Git

Work Experience

Tech Mahindra Ltd from November 2018 to Present

Project #1

Project : K2View Test Data Management(TDM)

Domain : Telecom

Client : AT&T

Tools : k2VIEW,DBeaver,Putty

Role : Development

Environment : Oracle 11g,Cassandra.Unix,Java,

Version Control : SVN,Git

Project Description:

K2view Test Data Management (TDM) offers an automated solution to copy a subset of entities from source systems into selected testing environments and provide data to testing teams. Data is organized by the logical unit of the business. Each logical instance is treated as a micro-database containing all data about the entity. K2View’s Fabric retrieves and stores the data based on business logic, hence the name Logical Unit. Using the Schema, K2View Fabric automatically retrieves all information associated with a specific Logical Unit Type using embedded, in-memory migration (ETL) capabilities. The data is then accessed, distributed, and stored in K2View Fabric as Logical Unit Instances, allowing for incredible performance, enhanced security, high availability, and customizable data synchronization.

Responsibilities :

Responsible for creating interfaces for different database sources.

Responsible for performing joins, subqueries and sql functions .

Responsible for creating LU(logical unit) using K2View framework with the interfaces connected.

Worked on creating logical units including configuration of instances,key columns,linking tables and defining the table population.

Responsible for creating Parsers to load data from data files or data sources to Cassandra tables.

Responsible for creating Reference tables to sync data between data source and target database.

Creating keyspaces,tables and queries using Cassandra.

Responsible for deploying the design in fabric servers and loading it to the target database using ADI(Advanced Data Integration).

Responsible for creating a sequence for the applications to avoid duplication of data in the target database.

Responsible for integrating different applications using TDM GUI.

Project #2

Tech Mahindra Ltd from August 2016 to November 2018.

Project : Supply Chain Finance Unit(SCFU)

Domain : Banking

Tools : SQL developer,Putty,WinSCP,JIRA

Client : State Bank of India(SBI).

Role : Application Support

Environment : Oracle 10g,11g,UNIX.

Project Description:

SBI Corporate Banking offers two products (electronic Vendor Finance System, and electronic-Dealer Finance System) under supply chain finance, caters to the financing requirements of Industry majors (IM) who are clients of State Bank of India. The application aims to automate the loan disbursal and interest recovery process and provides a repayment model through the Internet banking and other channel system for dealers and vendors.

Responsibilities:

Analyzing and understanding user requirements.

Responsible for performing joins, subqueries and sql functions .

Development of Change Requests based on client requirements.

Technical fixes, enhancements, and support at database level.

Hands-on SQL scripting for backend activities like manual report generation and DML Operations.

Daily interaction with the clients and dealers on resolving technical glitches.

Handled monthly end activities of dealer /vendor accounts and reporting.

Process documentation and creation of Project Knowledge Base.

Creation of database objects like Tables, Procedure, Function using SQL developer.

Responsible for monitoring the routines and the application servers.

Educational Qualification:

Course

Name of the Institution

Year of passing

Percentage B.E

(Electronics and Communication)

Srinivasa Institute of Engineering and Technology,

Poonamalle,

Chennai-600056.

2015

67.8

HSC

St.Bede’s Anglo Indian Higher Secondary School,

Santhome,

Chennai-600004.

2011

86.16

SSLC

St.Bede’s Anglo Indian Higher Secondary School,

Santhome,

Chennai-600004.

2009

86.4

Achievements:

Recognized with “Pat on the Back Award” for being a consistent performer for SBI client.

Recognized with “Bravo Award” for being a consistent performer for AT&T.

Co-Curricular Activities:

Organized Non-technical events in our college symposium “Techkrithi 2k14”.

Organised our college Farewell.

Participated in many college symposium events.

Personal Profile:

Name : Vigneshwaran.G

Father’s Name : Gajendran.D

Date of Birth : 20th September 1993

Gender : Male

Marital Status : Single

Nationality : Indian

Languages Known : Tamil and English (Read,Write and Speak)

Hobbies : Listening to songs,Surfing.

DECLARATION:

I hereby declare that all the details mentioned above are true to the best of my Knowledge and ability.

Place: Chennai

Date: (VIGNESHWARAN.G)

Contact this candidate