Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

NITHYA SELVARAJ

Middletown,DE

Summary

Experienced Senior Manager in Data Engineering with 17 years of expertise in data architecture, management, engineering, and leadership. Demonstrated success in designing and implementing scalable data architectures, managing ETL processes, and executing large-scale data migrations. Specializes in optimizing data pipelines for improved efficiency and performance using Data Warehousing ETL tools, Cloud solutions, and the Hadoop Ecosystem. Proven track record in the Banking, Financial, and Healthcare sectors. Adept at leading cross-functional teams, driving innovation, and aligning technology solutions with business goals. Proficient in SDLC methodologies, including Waterfall and Agile. Committed to leveraging diverse technologies to deliver actionable insights and strategic business value through data-driven initiatives.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Senior Manager, Data Engineering

Benefits Data Trust
08.2021 - Current
  • As the Senior Manager and Data Architect at Benefits Data Trust, Led the design of data ingestion pipeline architectures and developed comprehensive data models for managing customer data
  • Led the design and deployment of a scalable automated data processing system, achieving a 90% reduction in processing time and a 40% decrease in compute costs
  • Managed the development and launch of a targeted MarTech outreach campaign across seven states, successfully reaching over 100,000 potential clients through mail and text each month
  • This initiative significantly enhanced engagement and increased overall response and conversion rates
  • Implemented automated pipelines that doubled organization's impact, resulting in 370,000 public benefit enrollments totaling $2.3 billion cumulatively
  • Utilized BigQuery, Google Cloud Functions, and Google Analytics API in Python to ingest data from disparate sources into PostgreSQL, creating data views for Looker dashboards and reports
  • Spearheaded data extraction process from AI-powered Wyatt and RASA Chatbot assistant systems to BigQuery for analytics
  • Played key role in migrating data from Cloud Spanner and PostgreSQL to BigQuery
  • Led design effort in extracting call data from Five9 and applying it to machine learning applications
  • Managed high-performing data engineering team, mentoring junior Data Engineers, conducting comprehensive code reviews, and organizing knowledge-sharing sessions to foster team growth and collaboration.
  • Led cross-functional teams to achieve project milestones and deliver high-quality results.

Application Lead/Technical Manager

Bank of America
01.2019 - 08.2021
  • Led the development of an integrated RECON framework adaptable for various Digital Online Banking and Mobile Banking applications
  • Directed the analysis and design of business requirements, playing a crucial role in enhancing layout designs to improve overall functionality
  • Managed the development of code components for collecting, storing, modeling, and analyzing large datasets
  • Designed Data Model and Metadata components, as well as Spark SQL components and wrapper scripts in Python and Shell, to guarantee the successful execution of reconciliation reports
  • Acted as a liaison between business stakeholders and technical teams, ensuring that data security and privacy considerations were incorporated into strategic discussions while effectively meeting business objectives
  • Engineered operational metrics and Data Quality tools, including implementing email functionalities for success rate notifications
  • Mentored both Onshore and Offshore team through effective communication and active listening
  • Collaborated closely with team members on troubleshooting and debugging tasks.
  • Accomplished multiple tasks within established timeframes.
  • Built high-performing teams through effective recruitment, onboarding, and talent development initiatives.

Technical Lead

Barclays
05.2017 - 01.2019
  • Collaborated with downstream application teams on ETL (Extract, Transform, Load) tasks, ensuring data integrity and maintaining pipeline stability
  • Developed Oracle Procedures, Packages, and Functions to process external vendor data within the data warehouse
  • Created DataStage jobs and shell scripts to split and process vendor input files for loading into Oracle tables
  • Designed Hadoop jobs to split vendor input files and load data into HBase and/or Hive tables
  • Implemented Sqoop and Spark jobs to transfer data from Oracle systems to Hive tables
  • Analyzed explain plans for complex SQL and Hive queries, focusing on performance improvement for large data volumes
  • Created new Control M jobs and optimized existing ones to enhance scheduling efficiency.

Technical Lead

Bank of America
09.2012 - 05.2015
  • Developed technical solutions for rule engine governing Customer Indicator and Segmentation data
  • Played significant role in development and testing phases during migration from Customer Data Mart (CDM) in Teradata to Customer Repository Hub (CRH) in Vertica
  • Acted as Subject Matter Expert (SME) for migrating critical components (Platinum privileged Customers) to Vertica within CRH application
  • Managed space allocation across Teradata environments including SIT, UAT, and Pre-Prod
  • Played key role in analyzing business requirements and designing solutions for requested changes
  • Participated in business calls with Line of Business (LOB) stakeholders and actively contributed to defect triage sessions
  • Oversaw development team offshore responsible for Platinum Privileges Indicators and Preferred Rewards Indicators.

Project Manager

Keane Inc (Chennai, India)
02.2009 - 05.2011
  • Managed Quality team including (SQA and PMG group) with a team size of over 30 for over 2 years
  • Improved product Quality by mandating tools for code review (E.g.: SONAR for both Java and .NET projects)
  • Responsible and Brain behind the development of a code review and reporting tool (SQA RR tool)
  • Prepared metrics like Defect Slippage to SQA and Customer slippage and came up with process improvements based on the metrics
  • Organized system infrastructure documentation and operating procedures, strengthening controls and enhancing overall performance
  • Ensured verification and certification of appropriate test data and test environment that replicates production environment.

Project Lead/Team Lead/Developer

Keane Inc (Chennai, India)
03.2005 - 02.2009
  • Began career with Keane Inc as Oracle/Java Developer and progressed through various positions, eventually rising to Senior Developer, Team Lead, and Project Lead
  • Deputed to US (Boston) as Onsite coordinator and Onsite team lead for project
  • As team lead, was responsible for planning, estimating and development of various applications and reports in Cognos
  • Involved in development and testing of Netcool User Roles, Groups, User Accounts, Menus, Tools and Triggers
  • Responsible for developing PL/SQL package to validate data entered against each column
  • Was part of development team in migrating entire application from Oracle 8i to 9i
  • Additional responsibilities include conducting milestone review meetings and training and induction for any new resources in team.

Education

Bachelor of Engineering - Electronics and Communication Engineering

University of Madras
Chennai, India
05.2004

Skills

  • Cloud Technologies: Google Cloud Platform (GCP), AWS
  • GCP Tools: BigQuery, Snowflake, Cloud Functions, Kubernetes, Terraform, Docker, ElasticSearch
  • Workflow Orchestration: Airflow, Autosys, Control M
  • Databases: Oracle, SQL, Teradata, HBase, Hive, MongoDB (NoSQL)
  • Programming Languages: Python, Shell Scripting, PL/SQL
  • Big Data Frameworks: Spark (PySpark, SparkSQL), Kafka
  • ETL Data Warehouse - Snowflake, BigQuery
  • Informatica PowerCenter, DataStage
  • BI Reporting Tools: Tableau, Looker
  • Agile Technologies: JIRA, Rally, Confluence

Certification

  • Google Project Management Certification - 07/2024
  • MongoDB for DBAs Certification - 07/2016
  • IBM BigData Certification - 11/2016

Accomplishments

  • Recognized as a visionary Engineering Manager at BDT for achieving a significant reduction in list ingestion times, from 30 days to just a few hours.
  • Recognized as a great asset by various LOBs in Bank of America for the successful implementation of Voices and Recon projects.
  • Received numerous Spot awards.
  • Selected to be part of the gold club member for outstanding achievement.
  • Received Gem Award.
  • Received Best Team lead award

Timeline

Senior Manager, Data Engineering

Benefits Data Trust
08.2021 - Current

Application Lead/Technical Manager

Bank of America
01.2019 - 08.2021

Technical Lead

Barclays
05.2017 - 01.2019

Technical Lead

Bank of America
09.2012 - 05.2015

Project Manager

Keane Inc (Chennai, India)
02.2009 - 05.2011

Project Lead/Team Lead/Developer

Keane Inc (Chennai, India)
03.2005 - 02.2009

Bachelor of Engineering - Electronics and Communication Engineering

University of Madras

Similar Profiles

CREATE PROFILE
NITHYA SELVARAJ