Summary
Overview
Skills
Certification
Work History
Education
Timeline
15
Vasanth Kanna Anandan

Vasanth Kanna Anandan

Los Angeles,CA

Summary

Results-oriented Business Intelligence Analyst with over 7 years of experience analyzing complex data sets and delivering insights that drive business growth. Expertise in data engineering, modeling, visualization, and statistical analysis, with strong proficiency in tools like Informatica, Matillion, DBT, Databricks, AWS, Power BI, and SQL. Demonstrated success in identifying trends, patterns, and opportunities to optimize operations and improve decision-making. Dedicated to providing precise, high-quality analyses to support strategic business goals.

Overview

7
7
years of professional experience
3
3
Certification

Skills

  • ETL/ELT Tools: Informatica PowerCenter, Informatica Cloud (IICS), Matillion, DBT, Data Bricks, Five Tran
  • Databases: Snowflake, Redshift, SQL Server, Oracle (11g)
  • Programming Language: Python
  • Reporting Tools: Power BI
  • Orchestration Tools: Controlm, Apache Airflow
  • AWS Services: S3, EC2, SNS, SQS, SES, Lambda, EBS, IAM, Redshift, DMS, Comprehend, Transcribe
  • Code Promotion: GitHub, Jenkins
  • Instance Tracking: Jira, ServiceNow

Certification

AWS Certified Solutions Architect - Associate (2022)

Certified Data Warehouse Engineer in Matillion (2022)

Data Lakehouse fundamentals (2023)

Work History

Data Engineering Lead

Systech Solutions
01.2023 - Current
  • Designing and implementing scalable data architectures, systems, and best practices in data modeling, ETL, and warehousing. Building and managing robust data pipelines using DBT Cloud, while automating workflows for continuous data availability and integrity.
  • Leading and mentoring a team of data engineers, overseeing task assignments, code reviews, and high-quality deliverables. Collaborating with cross-functional teams to define data needs and translate business requirements into technical solutions.
  • Ensuring data quality, compliance with governance policies, and system reliability. Troubleshooting complex data issues, providing strategic guidance, and documenting architecture and code to support maintenance. Communicating progress and technical updates to stakeholders.

Lead Data Engineer

Systech Solutions
10.2019 - 01.2023
    • Developed data integration jobs in Matillion to retrieve data from Redshift, Snowflake, and Salesforce, and managed data migration tasks with AWS DMS. Acted as main contact for integration issue resolution and suggested code improvements.
    • Clarified requirements using Jira and participated in walkthrough with the onsite team. Created Informatica Cloud integration jobs for Client and Policy data marts, built Python scripts for source file automation, and developed AWS Lambda scripts for processing files from Kinesis Firehose to S3 and transferring data to MuleSoft Queues via API.

Software Engineer

Transcentra FTS
10.2017 - 10.2019
    • Integrating data from various sources, such as databases, APIs, and cloud services, into unified data system. Building data ingestion frameworks to support continuous data flow.
    • Enhancing data pipeline performance for fast and efficient processing.
    • Monitoring data workflows, troubleshooting performance issues, and addressing bottlenecks as they arise.

Education

Bachelor of Engineering -

Anna University
Chennai, India
05-2017

Timeline

Data Engineering Lead

Systech Solutions
01.2023 - Current

Lead Data Engineer

Systech Solutions
10.2019 - 01.2023

Software Engineer

Transcentra FTS
10.2017 - 10.2019

AWS Certified Solutions Architect - Associate (2022)

Certified Data Warehouse Engineer in Matillion (2022)

Data Lakehouse fundamentals (2023)

Bachelor of Engineering -

Anna University
Vasanth Kanna Anandan