Summary
Overview
Work History
Education
Work Preference
Skills
Software
Timeline
CustomerServiceRepresentative

VIGNESH NAGARAJ

Chennai,Tamil Nadu

Summary

Having 6+ years of professional experience in ORACLE as a SQL, PLSQL Developer, DB Testing and ETL Testing. Very strong knowledge in most complex SQL. Having good experience in loading the data's using ETL tools and ETL Process. Experience in PLSQL Collections, Bulk Collect, Bulk Bind and Pragma Autonomous transaction. Having good experience in develop the Data Modeling entities using ER studio and Data loading to database through SQL Loader & loading and unloading from database. Proficient in Creation/Modification of PLSQL and SQL objects like Packages, Procedures, Functions, Cursor, Collection, Exception, Tables, Sequence, Synonyms, Joins, Views, Materialized Views, Aggregate Function, Analytical Function, Set Operators and Oracle Supplied Packages. Take part in the actual development/implementation of ETL tools. Adding metadata to enrich the information with details using ETL. Good knowledge verify and testing the seed and transaction data's using ETL tools Data flow validation source tables, stage table and target tables using ETL tools. Experience in Performance Tuning. Good Experience in data migration from Oracle to PostgreSQL database from scratch. Completed a SQL and PLSQL Oracle Certification. Designed and implemented Oracle database schemas to meet specific application requirements. Created table structures, defined relationships, and optimized indexing strategies for efficient data retrieval. Automated database tasks using PL/SQL scripts to improve efficiency and maintainability. Experience with UNIX including basic commands. Combine with others, often with multidisciplinary teams, to achieve tasks/goals. The ability to plan, priorities and make judgments on the basis of a range of available data, to deadlines and under pressure. Collaborate with data architects for Data Model Management and version control. Design, implemented and capture technical Metadata through data modeling. Involved in various projects related to Data Modeling, System/Data Analysis, Design and Developments. Collaborate with BI teams to create Reporting Data Structures. Developed Logical Data Models and Physical Data Models. Good experience in rectifying the Data Mismatch and Fix it based on client requirement. The ability to plan, priorities and make judgments on the basis of a range of available data, to deadlines and under pressure. Having good experience in schema migration from Oracle to MYSQL, MYSQL to PostgreSQL and Oracle to PostgreSQL. Having good experience in data modeling tool ER Studio, code collaborator.

Overview

6
6
years of professional experience

Work History

SENIOR CONSULTANT

SAKSOFT LIMITED
04.2021 - Current
  • Transunion (CIBIL)
  • TransUnion are responsible for collecting and maintaining consumer credit reports in the U.S
  • These reports are then provided to subscribers, such as credit card companies and others who are deciding whether or not to extend you credit.

SOFTWARE ENGINEER

OFS TECHNOLOGIES LIMITED, Sella
12.2019 - 04.2021
  • Banca Sella Holding S.p.A
  • Is an Italian holding company for the Banca Sella Group (Italian: Gruppo Banca
  • Sella)
  • The main company of the group was Banca Sella S.p.A
  • An Italian bank based in Biella, Piedmont.

SENIOR PROCESS ASSOCIATE

TATA CONSULTANCY SERVICES
05.2018 - 11.2019
  • Nielsen
  • Nielsen is a leading measurement company, provides rating for what people on television, listen over the ratio and purchase of various products
  • Worked on code migration from Netezza to Redshift and Oracle to
  • PostgreSQL
  • ROLES AND RESPONSIBILITIE
  • Designed and developed Oracle database schemas based on project requirements and business needs
  • Created and optimized database objects such as tables, indexes, views, and triggers
  • Developed complex SQL queries for data retrieval, manipulation, and reporting purposes
  • Conducted performance analysis and optimization of SQL queries and PLSQL code
  • Implemented indexing strategies and partitioning techniques to enhance query performance
  • Translated business requirements into technical specifications and database design documents
  • Implemented version control for database schema changes using tools like Oracle SQL Developer
  • Managed database change requests, ensuring proper documentation and adherence to change control procedures
  • Implemented data quality checks and validation rules to maintain data consistency and accuracy
  • Developed data validation scripts and procedures to enforce data integrity constraints
  • Developed PL/SQL packages with error handling capabilities
  • UAT and Live support
  • Prepared Root Cause Analysis (RCA) for problems occurred
  • Unit Testing - Test case and data preparation, execution and verification of the test results.

Education

Bachelor of Engineering - undefined

Anna University

Work Preference

Work Type

Full Time

Location Preference

HybridRemote

Skills

ORACLE SQL, PLSQL, POSTGRESQL, DB TESTING, ETL TESTING, DATA MODELING and DATA WAREHOUSE CONCEPT

Software

SQL Developer, Putty, GIT, SVN, WinSCP, Secure CRT, ER Studio, Bit Bucket, Jira, Confluence Page

Timeline

SENIOR CONSULTANT

SAKSOFT LIMITED
04.2021 - Current

SOFTWARE ENGINEER

OFS TECHNOLOGIES LIMITED, Sella
12.2019 - 04.2021

SENIOR PROCESS ASSOCIATE

TATA CONSULTANCY SERVICES
05.2018 - 11.2019

Bachelor of Engineering - undefined

Anna University

Similar Profiles

CREATE PROFILE
VIGNESH NAGARAJ