Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Arun Rajarajan

Fontana,CA

Summary

An experienced Lead Analyst with a strong background in ETL and reporting tools, currently with Systech Solutions. Expertise in leading ETL projects and deep knowledge of data warehousing, ETL tools (DBT, Informatica PowerCenter, SSIS, Talend, Datastage), and reporting tools (Web Query, MicroStrategy). Proficient in database management across platforms like Snowflake, Redshift, Teradata, SQL Server, YellowBrick, and Oracle. Known for technical proficiency, professionalism, and excellent teamwork skills.

Overview

13
13
years of professional experience

Work History

Onsite Architect | Mash

Zurich Insurance
01.2024 - Current
  • Develop a simplified process where policies are given an indicator to make it more efficient in ring-fencing blocks of policies for portfolio transfer to ZLS.
  • Maintained quality control standards and procedures for accurate and precise measurements, illustrations and documentation.

Onsite Architect | Accelerate

Zurich Insurance
01.2023 - 12.2023
  • Data integration solution to process policy level premium financials to Zurich data warehouse

Onsite Architect | SAS to Informatica Conversion

Zurich Insurance
03.2022 - 12.2022
  • SAS to Informatica Conversion, Converted SAS jobs to Informatica, optimized SQL queries, and ensured data accuracy post-migration.

Onsite Architect | Yellowbrick Migration

Zurich Insurance
03.2021 - 02.2022
  • Migrated Zurich's data warehouse from Netezza to Yellowbrick, modifying ETL parameters for optimal performance
  • Optimized ETL loads and report runtimes, enhancing the overall system performance.

Onsite Lead

21st Century Fox
01.2016 - 02.2021
  • Avails – Enhancement and Support
  • Suisse 2.0 - Re-Engineering
  • FoxFast Analytics
  • AWS Migration

Offshore ETL Lead | Category Management Support

21st Century FOX
05.2011 - 12.2016

Education

Master of Computer Application -

Madurai Kamaraj University
Tamil Nadu, India
05.2011

BSc - Computer Science

Madurai Kamaraj University
Tamil Nadu, India
05.2007

Skills

  • Snowflake, YellowBrick, Redshift (AWS), Oracle 10g, MS SQL Server 2012, Netezza 70x
  • ETL/ELT Tools: DBT, Informatica PowerCenter 9x/10x, MS SQL Server Integration Services 2012, DataStage 85
  • Programming: Shell Scripting, Python
  • Languages: PL/SQL

Accomplishments

  • IBM Python for Data Science and AI
  • IBM Netezza PureData System for Analytics v7.0
  • IBM InfoSphere DataStage v9.1
  • ESOL International (Business English Entry Level 3), Cambridge ESOL

Timeline

Onsite Architect | Mash

Zurich Insurance
01.2024 - Current

Onsite Architect | Accelerate

Zurich Insurance
01.2023 - 12.2023

Onsite Architect | SAS to Informatica Conversion

Zurich Insurance
03.2022 - 12.2022

Onsite Architect | Yellowbrick Migration

Zurich Insurance
03.2021 - 02.2022

Onsite Lead

21st Century Fox
01.2016 - 02.2021

Offshore ETL Lead | Category Management Support

21st Century FOX
05.2011 - 12.2016

Master of Computer Application -

Madurai Kamaraj University

BSc - Computer Science

Madurai Kamaraj University
Arun Rajarajan