Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

VINOTHKUMAR CHANDRASEKARAN

Bangalore,KA

Summary

Total 13+ years of experience in IT industry, 4 years of proven relevant expertise in Azure Databricks, Azure DataLake Gen2, PySpark, Azure Data Factory, 3 years of relevant experience in Informatica Power Center and Oracle SQL Developer 3+ years of experience as SQL /PLSQL developer and 3+years of Experience as Mainframe developer.

Overview

13
13
years of professional experience

Work History

Data Modelling Specialist

Accenture Pvt Ltd
09.2016 - Current
  • Design, code, test, debug, and document complex database solutions to ensure that data processing production systems meet user needs
  • Troubleshoot and resolve complex production issues
  • Design relational models for small- and large-scale applications
  • Provide data analysis and validation
  • Co-ordination with onsite team and other stake holders
  • Then moving ahead with Design, development and testing phase
  • Bug fixing and resolving issues related to UAT
  • Resolving productions issues (L3 Support) by providing data patch and provide RCA for issue to Client
  • Creation of Deployment plan document, deployment plan review with release maintaining teams and its testing
  • Extracted data from different data sources related to clinical data and stored on Azure Cloud
  • Transformation activity is performed on raw data and clean data is stored on Azure SQL using ADF and Azure Databricks
  • To extract unstructured data (DICOM Image) and convert data into structured format using Databricks
  • Coordinate and collaborate with clients and business to understand their requirement and implement solution.

Informatica/PLSQL Developer/Team leader

Polaris Financial Technologies
11.2014 - 09.2016
  • Includes analysis, design, development, documentation and testing for new enhancements
  • Co-ordination with onsite team and other stake holders
  • Then moving ahead with Design, development and testing phase
  • Bug fixing and resolving issues related to UAT
  • Resolving productions issues ( L3 Support) by providing data patch
  • Creation of Deployment plan document, deployment plan review with release maintaining teams and its testing
  • Created mappings using different transformations like Source qualifier, SQL Transformation, union, Filter, Expression, Aggregator, Sorter, Joiner, Lookup and Update Strategy.

Senior Software Developer

PATNI Computer Systems
01.2011 - 10.2014
  • Analyzed sources, targets, transformed data as per business needs and loaded into targets using Informatica
  • Created mappings using different transformations like Source qualifier, SQL Transformation, union, Filter, Expression, Aggregator, Sorter, Joiner, Lookup and Update Strategy
  • Identified performance issues in existing sources, targets and mappings by analyzing data flow, evaluating transformations and tuned accordingly for better performance
  • Worked with heterogeneous source to extract data from Oracle database, flat files and loaded to a relational Oracle warehouse
  • Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected), Filter, stored procedure and Update Strategy
  • Creating Variables in mapping level and workflow level to pass values between sessions

Education

Post-Graduation MBA -

Vellore Institute of Business School
Vellore
05.2007

Bachelor of Engineering -

Anna University
PSYEC Engineering College Sivagangai
05.2005

Skills

  • SQL/PLSQL, Python, PySpark, Scala, COREJAVA, Transact SQL, PIG, HIVE, SQOOP, Unix Shell Scripting, COBOL
  • Git hub
  • Azure Databricks, Informatica PowerCenter 91, Toad, SQL Developer, MYSQL Developer, ZOS
  • Oracle, MYSQL, DB2
  • UNIX/LINUX

Languages

English
Hindi

Timeline

Data Modelling Specialist

Accenture Pvt Ltd
09.2016 - Current

Informatica/PLSQL Developer/Team leader

Polaris Financial Technologies
11.2014 - 09.2016

Senior Software Developer

PATNI Computer Systems
01.2011 - 10.2014

Post-Graduation MBA -

Vellore Institute of Business School

Bachelor of Engineering -

Anna University

Similar Profiles

CREATE PROFILE
VINOTHKUMAR CHANDRASEKARAN