Sathiya seelan Jayasekaran

Technology Stack: Oracle PLSql, JIRA, Github, Liquibase Project: Guidewire Policy Center Data Migration Migrating large volume of data from legacy to Guidewire Policy Center application for a Japan based P&C Insurance company

Technology Stack: IBM InfoSphere DataStage 9.1, Sybase, Greenplum, Oracle, Data Modeling S3 Bucket, Agile Environment Designed and developed to handle the large volume of trading data. Data were extracted from the legacy (Sybase, Flat files UNIX server, DB2, Oracle) and tr ansformed (IBM DataStage ETL) and loaded into DWH (Greenplum). ETL code developed with error handling, load monitoring (SOD & Intraday Confirmation mail needs to be sent to participants), reconciliation and multi site load.

Technology Stack: MySQL, Amazon Redshift, Data Modeling, ELT/ETL concepts, SQL , S3 Bucket , JIRA, Gitlab, Agile Methodologies Designed and created facts, dimensions, degenerated dimensions , common dimensions and star schema for the DWH product (ITSM Analytics)

Technology Stack: Informatica PowerCenter 8.6 / 9.1, Oracle, DWH techniques Projects: Auto BDW, Guidewire Claim Center Data Migration for AAA Insurance, USA Designed and developed an end to end robust ETL architecture to convert the data from multiple legacy system to Guidewire ClaimCenter using Informatica PowerCenter 8.6/9.1, Oracle, SQL. ETL architecture includes Restartability, Err or Handling, Bad data capturing, r eprocessing, Reconciliation and Archival process.

Operations Research and Computer Applications SQL, Data Analysis, Data warehousing

SQL, Database and Data warehousing, Mathematics, Java, C, C++