Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic
Haripriya Subramani

Haripriya Subramani

Bangalore

Summary

Senior Manager/Lead Data Engineer with 10+ years of experience in building and managing high-performing teams, Data Engineering & SQL Development. Highly skilled in designing and implementing data solutions by working closely with stakeholders and product owner. Looking for a challenging role in an organization to utilize my leadership and technical expertise to deliver the project milestones

Overview

11
11
years of professional experience
1
1
Certificate

Work History

Senior Manager

Factspan Analytics
Bengaluru
04.2024 - Current
  • Managing teams of 12+ employees by providing guidance, setting goals and objectives, delegating tasks, and monitoring performance.
  • Handling delivery of multiple accounts and working closely with leadership team in driving initiatives.
  • Participated in recruitment initiatives by interviewing potential candidates and selecting suitable hires.
  • Reported to executive leadership on performance metrics, challenges, and strategic opportunities.
  • Established and maintained relationships with key stakeholders to support business objectives.
  • Facilitated Scrum ceremonies, such as Sprint Planning, Daily Stand-Ups, Retrospectives and Reviews.

Lead Data Engineer

Accenture - British Petroleum
Bengaluru
03.2021 - 03.2024
  • Expertise in leading the data engineering team and handled data modeling, ETL/ELT transformation, data integration, data warehousing.
  • Led the team in delivering critical use cases designed to depict fuels and Site profit KPIs.
  • Optimized critical pipelines in production to cut down the cost by 33% effectively.
  • Worked in AWS services like Redshift, Spectrum, Glue, Athena, S3, IAM, Cloud Formation, Cloud Watch, Step functions and Cloudera Data platform with Apache Hive/Impala engine
  • Gained expertise in AWS Big Data – writing complex data pipelines and quantitative queries used for critical decision making on Fuel margins and sales volumes.
  • Designed and implemented ETL process for transforming raw data into meaningful insights.
  • Collaborated with stakeholders to understand their requirements and develop solutions accordingly.
  • Monitored job execution logs to ensure efficient functioning of all ETL jobs running in production environment.
  • Developed and maintained data pipelines to ingest and store large volumes of data from multiple sources.

SSIS Developer & Migration Specialist

TCS - JP Morgan Chase
Bengaluru
01.2020 - 03.2021
  • Worked on creating, enhancing, optimizing SSIS Packages in Global Technology.
  • Experience in coding T-SQL Stored procedures, views and functions to support business requirements.
  • Performance Tuning and Query Optimization in the pipelines.
  • Upgrading SSIS packages from SQL Server 2012 to 2019 version & Migrating Trading applications and Databases from Sybase to SQL Server
  • Developed ETL packages for data loading from various sources such as flat files, XML files and databases into the Data Warehouse using SSIS.
  • Configured error handling for all SSIS packages by establishing connection managers, event handlers and logging to track package execution status.

SQL Developer/Migration Specialist

TCS - Comerica Bank
Bengaluru
05.2019 - 01.2020
  • Led the team in migrating 1000+ Access databases to Azure SQL Managed Instance.
  • Designing and testing the initial POC of SSMA on Access and worked closely on analyzing the Business User requirements and handling timely deliverables.
  • Worked on End User experience/Access Developer/DB training Manuals.

SQL Developer/Administrator

TCS - Ameriprise Financial Inc
Bengaluru
10.2013 - 01.2018
  • Experience in handling priority issues in production complex databases/platform in SQL Server.
  • Expertise in Always-On Availability Groups (AAG), Log Shipping, Database Mirroring, Clustering, Backup/Recovery, Disaster recovery and planning.
  • Hands-on automating reports using Integration Services (SSIS) packages and Reporting Services (SSRS).
  • Worked on monitoring tools like Spotlight and SCOM.
  • Rebuilding and monitoring the indexes at regular intervals for better DB performance.
  • Expertise in analyzing DB space issues, server disk capacity planning and maintenance job failures.

Education

Bachelor of Engineering - Electronics And Communication Engineering

SRM Easwari Engineering College
Chennai
05.2013

Higher Secondary -

Indian Matriculation School
Harur, TamilNadu
05.2009

Skills

  • Delivery Excellence
  • People Management
  • SQL and Databases
  • AWS Cloud Services - S3, Redshift, Spectrum, Athena, Glue, Step functions, CloudFormation, CloudWatch, DynamoDB, Lambda, IAM
  • Big Data
  • ETL
  • Data Warehousing/Data Modelling
  • Hive/Impala
  • Hadoop
  • Apache Spark
  • SSIS
  • Agile
  • GIT
  • Python
  • Azure DevOps
  • Denormalization/Normalization
  • SQL Server Developer
  • SSMA(Migration Assistant) for Access & Sybase

Languages

Tamil, English
First Language
Telugu
Intermediate
B1
Bengali
Intermediate
B1

Certification

  • Querying Microsoft SQL Server 2012

Timeline

Senior Manager

Factspan Analytics
04.2024 - Current

Lead Data Engineer

Accenture - British Petroleum
03.2021 - 03.2024

SSIS Developer & Migration Specialist

TCS - JP Morgan Chase
01.2020 - 03.2021

SQL Developer/Migration Specialist

TCS - Comerica Bank
05.2019 - 01.2020

SQL Developer/Administrator

TCS - Ameriprise Financial Inc
10.2013 - 01.2018

Bachelor of Engineering - Electronics And Communication Engineering

SRM Easwari Engineering College

Higher Secondary -

Indian Matriculation School

Similar Profiles

CREATE PROFILE
Haripriya Subramani