Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Anjanavarna

Vancouver,Canada

Summary

Passionate ETL developer and implementation consultant with 5 years of experience in the services industry, specializing in data integration, transformation, and the deployment of end-to-end solutions. Skilled in SQL, Data Analysis, Extract, Transform, Load (ETL) and Report generation and media measurement. Worked on requirement analysis, application development, application maintenance, functional Studies, Quality Reviews and Testing for multiple data warehousing projects and Strong capability to research and self-learn.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior ETL Developer

Guidehouse India
Trivandrum, India
03.2023 - 03.2024
  • Assigned with responsibility to develop/ change new ETL process, maintain the existing work flow, Support and improve the performance of existing applications in production using Pentaho Data Integration tool and Pentaho Report Designer
  • Coordinating with business operations and understanding the requirement, analysing the data, assisting in designing data warehouse, loading data as per the infrastructure design and flows, creating test cases and execution of the same, report generation and different metrics creation to make critical business decision
  • Worked with Java Team to implement the OKTA in the RevReport Application (Web Application)
  • Migration of the existing applications to Snowflake interface.
  • Addressed and resolved vulnerability issues within the Pentaho Report Designer web application.

Implementation Consultant

Nielsen
Kochi, Kerala
05.2022 - 01.2023
  • Serve as the technical expert for Multi Touch Attribution Tagging processes/products
  • Ability to troubleshoot and solve technical Tagging client inquiries to answer all BAU client requests
  • Ability to manage multiple Tagging campaigns in parallel, involving tag creation through confirmation of correct output, following standard procedures and meeting deadlines throughout
  • Monitors and analyze campaign performance and conducts QC checks
  • Consolidates and reports results out to clients
  • Responds to client requests in a timely manner; consistently follows through on issue resolution
  • Escalates/engages support as required to ensure timely turnaround time to client.

ETL Developer

Guidehouse India
Trivandrum, Kerala
08.2019 - 05.2022
  • CRPD – (Claims & Remittances Processing
    Department )     Worked on the CRPD Project for migration to Snowflake, implementing necessary Pentaho ETL changes for each iteration. Developed reports using Pentaho Report Designer, tracked all tasks with JIRA tickets, and committed code to GIT.
  • Collaborated with various teams to develop the ETL workflow for the Revapp application.
  • PeaceHealth - Managed file transfers via SFTP, ensured data integrity, automated processes with PowerShell scripts and SSIS packages, and optimized SQL Server stored procedures.
  • Covid Data Management Project - Ensured data integrity , executed SSIS packages for data loading into staging and standard tables, performed quality checks, and prepared comprehensive data load analysis and statistics.
  • PeaceHealth Claim Load Project - Developed SSIS packages for file loading, generated folders during execution, created output files per client specifications, and validated loaded data.
  • MA Data Overview – Developed SSIS packages to load files with varying filenames, loaded data into appropriate tables based on client requirements, and created conditional views. Utilized Power Pivot to generate files and created reports per client specifications
  • Snowflake Project (Duke DEP EnergyWise - Importing Data) – Downloaded files from SFTP, executed SSIS packages to unzip, compress, and Gzip the files, loaded them into Azure Blob Storage, and transferred files from Blob Storage to Snowflake.
  • ComEd_VO - SQL Server to Snowflake Migration – Migrated tables from SQL Server to Snowflake by exporting them as flat files, executing SSIS packages for compression and Gzip, loading the files into Blob Storage, and then transferring the files from Blob Storage to Snowflake as tables.
  • Managed data entry tasks for the MIS team.
  • Web Scraping - Developed Python projects for web scraping, tailored to client specifications.

Education

PG Diploma - Data Analysis

Langara College
Vancouver, Canada
08-2025

B.Tech - Computer Science Engineering

SCMS School of engineering and Technology
Karukutty
06.2018

Skills

  • Client facing experience
  • Requirement Gathering
  • Data Visualization and Analysis
  • Agile Methodology
  • Microsoft Office
  • Linux
  • SQL, SSMS
  • Pentaho Integration , Reporting
  • Jira
  • GitHub, SVN
  • SSIS , SSMS
  • Python
  • Snowflake
  • Azure Blob

Certification

  • People's Click, Banglore - Python
  • WhiteOval Technologies - Java
  • Udemy Certified - Azure Fundamentals
  • Udemy Certified - Pentaho Report Designer

Accomplishments

  • Honored with the 2022 Reward and Recognition Award for exceptional performance on the CRPD project.
  • Awarded the 2023 Reward and Recognition Award for leading the team in Okta implementation and resolving vulnerabilities.

Timeline

Senior ETL Developer

Guidehouse India
03.2023 - 03.2024

Implementation Consultant

Nielsen
05.2022 - 01.2023

ETL Developer

Guidehouse India
08.2019 - 05.2022

PG Diploma - Data Analysis

Langara College

B.Tech - Computer Science Engineering

SCMS School of engineering and Technology

Similar Profiles

CREATE PROFILE
Anjanavarna