Summary
Overview
Work History
Education
Key Highlights
Core Skills
Websites
Certification
Timeline
Generic

Udhayapriya Maruthaiyan

Los Angeles,California

Summary

Accomplished Senior Software Engineer at ADP LLC with expertise in Oracle SQL and data visualization. Spearheaded the migration of tax compliance data for 500,000 clients, enhancing data accessibility. Adept at leading Agile teams and mentoring developers, driving efficiency and innovation in high-stakes environments.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Senior Software Engineer

ADP LLC
Pasadena, CA
06.2019 - Current
  • Migrated tax compliance data of half million small business clients from legacy DB2 Mainframe to Oracle 12c using Oracle plsql stored procedures
  • Performed Data Analysis and visualization using SQL, Databricks and Tableau.
  • Created Data pipelines using Databricks and PostgreSQL for a chatbot GenAI application.
  • Led the support and maintenance of a suite of high-tech Java applications built on Spring Boot framework, Nodejs and AWS Lambda ensuring 24/7 availability and quick resolution of production issues.
  • Managed AWS ECR, EKS, AWS API Gateway, S3, JIRA, Confluence, and SharePoint for tracking team progress, ensuring efficient software development lifecycle execution.
  • Actively conducted Agile ceremonies as a scrum master and performed UAT and provided training for end-users.
  • Tech Stack: Oracle 12c PL/SQL, Unix Shell, DB2, Databricks, PostgreSQL, Tableau, Java, Dynatrace, Splunk, Docker, GitHub, Bitbucket, Jenkins, Autosys

Database Technical Lead

Abbvie Pharmaceuticals
Waukegan, IL
03.2015 - 12.2018
  • Company Overview: Cognizant Technology Solutions
  • Designed logical & physical DB models for cost and margin reporting applications.
  • Developed PL/SQL & T-SQL stored procedures; implemented VPD – Virtual private database for data security.
  • Performance Tuning of Oracle 11g databases; maintained metadata in postGresSQL.
  • Provided SME-level support to business users and mentored junior developers.
  • Cognizant Technology Solutions
  • Tech Stack: Oracle 11g, PostgreSQL, Unix, Toad, Autosys, MKS Integrity

Database Lead

The Nielsen Company
Schaumburg, IL
05.2010 - 03.2015
  • Company Overview: Tata Consultancy Services
  • Led design and development of data warehousing components (fact/dimension tables)
  • Performed data transformations using PL/SQL, T-SQL, and Netezza SQL.
  • Created interactive analytical dashboards and reports in Tableau for executive decision-making, leveraging multi-source data to uncover trends and insights.
  • Conducted in-depth data analysis, ensuring consistency, data quality, and actionable intelligence for client-facing insights.
  • Built ETL pipelines using Tableau and SSIS to transform large-scale POS and Homescan datasets.
  • Created complex ETL pipelines using DataStage and SSIS.
  • Built robust Unix shell scripts and orchestrated services via Tibco OpsConsole.
  • Tata Consultancy Services
  • Tech Stack: Oracle 10g, IBM Netezza, Tableau, Unix, DataStage, SSIS, Tibco OpsConsole

Data Modeller

Standard Chartered Bank
Geneva
07.2009 - 04.2010
  • Company Overview: Tata Consultancy Services
  • Designed and optimized Oracle stored procedures to support AML tracking.
  • Developed complex reporting logic; implemented logical/physical data models.
  • Interacted with frontend teams and contributed to Spring-based design.
  • Tata Consultancy Services
  • Tech Stack: Oracle 10g, Unix, MS Visio

Database Developer

Citi Cards
Jacksonville, FL
11.2006 - 06.2009
  • Company Overview: Tata Consultancy Services
  • Developed and maintained backend components for credit approval workflows.
  • Interfaced with VB-based Capstone engine; handled test plans and QA cycles.
  • Forecasted capacity and led defect prevention initiatives.
  • Tata Consultancy Services
  • Tech Stack: Oracle 9i, Unix, Capstone, HP Quality Center

Education

Bachelor of Engineering - Information Technology

Anna University
India

Key Highlights

  • Data Migration success, Migrated over 500,000 client records with 100% data integrity
  • 8+ years of Team Lead experience, Led team of high skilled developers in data intensive Java and Oracle applications as a scrum master.
  • ETL Pipeline Optimization, Decreased ETL process runtimes by 30% using optimized pipelines
  • AI/ML Concepts, Adept in exploratory data analysis, Feature engineering, data cleansing, creating data pipelines for GenAI application.
  • Expert in High volume multisource data, Worked with multiple TB of data in varied sources like Oracle, IBM Netezza, Mainframe DB and AWS S3

Core Skills

Oracle SQL, PL/SQL, Unix Shell scripting, Core Java, Oracle, Mainframe DB2, IBM Netezza, AWS PostgresSQL, Databricks, RAG data pipelines, Tableau, Erwin, MS Visio, Data modelling , Virtual Private Database (security), Splunk, Dynatrace, Maven, GitHub, Docker, Bitbucket, Jenkins, DB Maestro, Jira, Confluence, Machine Learning concepts, Exploratory Data Analysis, Feature Engineering, Python: Numpy, Pandas, Seaborn

Certification

  • Oracle SQL Certification (OCA - IZ0-007)
  • Certified Scrum Master Certification from Agile
  • Lean Six Sigma (Green Belt)
  • Life Sciences – Pharmaceutical Fundamentals
  • Payment Cards & Banking Domain Competency
  • Machine Learning Engineer Bootcamp

Timeline

Senior Software Engineer

ADP LLC
06.2019 - Current

Database Technical Lead

Abbvie Pharmaceuticals
03.2015 - 12.2018

Database Lead

The Nielsen Company
05.2010 - 03.2015

Data Modeller

Standard Chartered Bank
07.2009 - 04.2010

Database Developer

Citi Cards
11.2006 - 06.2009

Bachelor of Engineering - Information Technology

Anna University
Udhayapriya Maruthaiyan