Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Sathish Kumar Vijayagopalan

Bengaluru

Summary

Results-driven Lead Data Engineer at EY with expertise in ETL solutions and data automation. Successfully designed scalable Alteryx workflows and Python scripts, enhancing operational efficiency. Proven analytical thinker, achieving over 400 hours in time savings through automation projects. Adept at project management and delivering impactful data transformations.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

EY
Bengaluru
11.2021 - Current
  • Designed and implemented scalable data automation and ETL solutions using Alteryx, Python, SQL, and batch scripting, significantly improving operational efficiency across audit and assurance processes.
  • Led the development of the EY Cash Cortex application using advanced Alteryx macros and robust logic to handle multi-select transformation configurations, which are now undergoing testing for global deployment.
  • Engineered a solution to parse and transform unstructured .txt files into analysis-ready datasets using Python, regex, and Alteryx workflows.
  • Developed custom Alteryx workflows replicating complex SQL logic for the Oracle ERP Cluster, enabling automated data processing and reporting.
  • Automated revenue analytics reporting for the State Street Audit team, and developed solutions for the Whitebox and CQS Audit teams using Alteryx.
  • Created dynamic Excel-based tools using VBA, including a user feedback form and an ERP Clusters knowledge repository dashboard, improving team collaboration and solution traceability.

Associate

JP Morgan Chase & Co
Bengaluru
08.2018 - 10.2021
  • Automated MIS Reports (daily, weekly, monthly, quarterly) for the team and other stakeholders.
  • Handled ad hoc automation projects for the leadership team and other stakeholders.
  • I worked on dashboards using data for the leadership team and used Tableau for visualization.
  • By using Excel, VBA, Tableau, and SQL in automation projects, I was able to show a time savings of over 400 hours in a year.

Technical Analyst

DXC Technology (Legacy Hewlett Packard Enterprise)
Bengaluru
06.2014 - 08.2018
  • Prepared reports outlining findings from analysis activities along with recommended solutions.
  • Provided technical support to users, troubleshooting system issues and resolving problems in a timely manner.
  • Developed reports related to helpdesk activities and performance metrics.
  • Assisted customers with basic software and hardware setup and configuration.

Education

Master of Pharmacy - Microbiology

Asan Memorial College of Arts And Science
Chennai, India
10-2013

Skills

  • ETL solutions
  • Alteryx workflows
  • Python scripting
  • SQL programming
  • Data automation
  • Data visualization
  • Data transformation
  • Project management
  • Analytical thinking

Certification

  • Alteryx Advanced

Languages

Telugu
First Language
English
Upper Intermediate (B2)
B2
Tamil
Upper Intermediate (B2)
B2
Hindi
Intermediate (B1)
B1
Kannada
Elementary (A2)
A2

Timeline

Lead Data Engineer

EY
11.2021 - Current

Associate

JP Morgan Chase & Co
08.2018 - 10.2021

Technical Analyst

DXC Technology (Legacy Hewlett Packard Enterprise)
06.2014 - 08.2018

Master of Pharmacy - Microbiology

Asan Memorial College of Arts And Science
Sathish Kumar Vijayagopalan