Summary
Overview
Work History
Education
Skills
Education Certifications
Technical Expertise
Timeline
Hi, I’m

Sundhar Alagumalai

Sr Solutions Architect
Fort Worth,TX
Sundhar Alagumalai

Summary

Sundhar is a well-experienced, most innovative, and strategic thinker with around 16 years of experience in creating, building solutions and speaks the business challenges for global organizations in a rapid changing environment, who possess comprehensive enterprise expertise in software design, development, and solution architecture for multi-Cloud. As a proactive and result-oriented Team Leader, with proficient in Cloud Adaptation, Big Data Platforms, Data migration, Data Warehousing, Data Lake, Data Mart, Lake house concepts and built robust Data Pipelines with Data Security, Data Quality and Data Governance. Experienced in administering and creating interactive dashboards, custom reports and performing ad-hoc analytics. Moreover, he has a proven track record of cultivating a positive and productive team environment. In addition, his ability to communicate effectively and contribute as a valuable team player sets him apart and significantly contributes to the success of the projects. Exclusively experienced in working for Banking and Financial services, Healthcare domains for large customers in united states.

Overview

15
years of professional experience
4
years of post-secondary education
1
Language

Work History

Southwest Airlines
Dallas, TX

Solutions Architect(Enterprise-Data,AI/ML,GenAI)
09.2023 - Current

Job overview

  • Developed and Lead 13 ARB for solutions for Operations Data Foundation initiative by working with multiple teams across technology and business executives on connecting business strategy to the technology strategy execution on across Operations.
  • Responsible for the portfolio technology strategy for high critical Southwest's Required to Fly and Required to Operate systems that support our Aircraft Operations applications AirOps, TechOps and Ground Operations.
  • Conducted comprehensive assessments of existing and emerging GenAI technologies Amazon Bedrock.
  • Partner with Southwest business and technology leaders to understand business outcomes and help them formulate the vision/strategy for Re/re legacy systems to drive technical direction/priories.
  • Responsible for the technology strategy for Southwest's Operations Near Real time systems.
  • Responsible for people leadership of Solution Architects staff and mentoring rising technical talent to ensure we are building up technical pipeline for multi-year and million investment strategy.
  • Executed impactful production platform modernization and migration initiatives with success.Delivered highly-available systems utilizing load balancing techniques, allowing for seamless scalability during peak usage periods.
  • Conduct research to provide technical solutions to scale AI/ML powered features for real-time network optimization. Making trade-offs based on quality, scalability, performance.
  • Contributed to the Architecture team that developed of AI models and implemented scalable AI solutions for flight following route optimization.

AMAZON- AWS
Dallas, TX

Senior Solutions Architect-AL/ML Data
10.2022 - 07.2023

Job overview

  • Delved deep into understanding customer requirements and led the team of customers and implemented, delivered customized architectures, prototypes, and implementations strategy for 5 engagements Highlights: Lab use case Real-Time User Analytics (Hi-Rez Studio), Data Lake (VitalConnect, DOR-MA, NARA)
  • Applied the 'invent and simplify' principle to validate architectures prepared for customers against nonfunctional requirements and educate them on AWS resources and helped evaluation of current technology and leads evaluation of new technologies using existing standards and frameworks
  • As a thought-provoking Leader, acquired ownership and delivered results with a 'think big' mindset, which earned me high customer satisfaction (CSAT) scores and accolades from the account team
  • Collaborated with customers to build Minimum Viable Product (MVP) solutions using various AWS services, such as Elastic Map Reduce (EMR), Redshift, Kinesis, Amazon Athena, Lake Formation, Amazon S3, AWS DMS, AWS Glue, DynamoDB, ElastiCache and Relational Database Service (RDS)
  • Created architecture and design briefs by thoroughly analyzing key features and decision points for the use case built in the Data Lab, while maintaining a standard of excellence with a 'Insist on the Highest Standards' approach using JAVA/Scala/Python based on customer's preference
  • Database migration- Assisted customers in migrating their databases from self-managed to managed database services, including the transition from commercial databases to open-source databases on AWS using AWS DMS, and building new databases using open-source engines like MySQL and PostgreSQL
  • Data lakes and analytics-In my role as a Data Lab Architect at AWS Data Lab, collaborated with clients to devise data lake solutions.These solutions have included transferring pre-existing data lakes and/or Hadoop systems from on-premises to AWS, as well as constructing new data lakes and transactional data lakes
  • Real-time data pipelines- assisted clients in creating and constructing near real-time data pipelines that have supported various applications, high throughput, low latency data processing system, custom machine learning model training, and the execution of real-time predictions
  • As part of a large initiative aimed at enabling Amazon employees in the AMER region to obtain the AWS Certified Data Analytics-Specialty certification, conducted training sessions on Amazon Managed Streaming for Apache Kafka (MSK) for over 200 participants.

HEALTHCARE SERVICE CORPORATION, Blue Cross Blue Shield
Dallas, TX

Sr SA-Engineering (Full-Time)
08.2020 - 10.2022

Job overview

  • Implemented an end-to-end ingestion ETL pipeline that processes 18 sets of dynamic delimited text files obtained from a third-party vendor using Pyspark, Python.The pipeline successfully ingests the data into the Data Lake, supporting RX Pharmacy in our domain clinical data product
  • Utilized interoperability mandate program various tools and technologies such as Spark, Azure, SQL, Python, Excel, and Talend to ingest 20 Fast Healthcare Interoperability Resources (FHIR) resource files from JSON into Azure Data Lake using Java with Spark
  • Enabled part of leading the architecture of data warehousing and data modeling procedures, aiding the creation of efficient ETL pipelines. These pipelines extract and transform data from multiple sources and consolidate it in Azure ADLS Gen2 for use in our domain clinical data product.
  • Designed, built, and deployed an automated framework to clean Consolidated Clinical Document Architecture (CCDA) XML files, consolidating numerous small files in an On-Premises Data Lake.This solution effectively reduced the name node space by over 30%, managing over 2 million files per week.

MPHASIS, JPMorgan Chase
Wilmington, DE

Project Lead/Big Data Architect
09.2017 - 07.2020

Job overview

  • Spearheaded a global team of 8 data engineers as the Project Lead to transform approximately 10 billion card transactions from various source systems into a Data Lake
  • The objective was to generate risk predictive scores for enterprise wholesale customers located in the US, facilitating analysis using Scala, Java, Spark
  • Contributed to the design, architecture, and development of custom, highly available, and scalable architecture on the AWS platform for the Wholesale credit risk program built using Scala, Java, Apache
    Spark.
  • As part of a company-wide strategic data repository initiative, effectively integrated approximately 150 tables from Oracle into Cloudera Data Lake for customer analytics reporting infrastructure in Consumer and Community Banking Mortgage
  • I accomplished this by implementing data modeling, ETL using Hive Spark, architecture, and developing an efficient framework for ingestion and enrichment

ATOS SYNTEL, AMERICAN EXPRESS
Chennai, India

Technology Specialist-ETL
03.2015 - 09.2017

Job overview

  • Created a design and re-architecture solution for real-time and batch data loads, which involved 50+ job loads, from an ETL Ab Initio application to a Big Data using Java, hive, Spark.
  • Designed the adoption and migration to Big Data enabled Amex to save on licensing costs for their proprietary tools for this project using Java (Map Reduce), Apache Hive, Apache Spark, Unix.
  • Served as a function-wide subject matter expert in one or more areas of focus.

TCS (AIG, SOUTHWEST Airlines)
Chennai, IN

IT Analyst
09.2009 - 03.2015

Job overview

  • Consistently involved in addressing significant data challenges using technologies such as MapReduce, Hive, HDFS, Sqoop, and MySQL, utilizing more than 20 Ab Itinito Graphs.
  • Constructed the Enterprise Data Warehouse Project and created three data marts sourced from various systems, comprising a total of 300 tables
  • As a Tech Lead, successfully mentored over 15 recent graduates in application and system training
  • Started as an ETL developer working on multiple tools Java, JBoss, Pentaho BI Server.

Education

Thiagarajar College of Engineering
Tamil Nadu, India

Bachelor of Science from Information Technology
08.2005 - 05.2009

University Overview

Skills

AWS Cloud Services

undefined

Education Certifications

Education Certifications
  • Microsoft Certified Azure Architect Expert, Microsoft, 2023
  • AWS Solutions Architect Professional, AWS, 2023
  • Executive Artificial Intelligence: Business Strategies and Applications Certification, Haas School of Business, University of California, Berkeley, 2022
  • Bachelor of Technology in Information Technology (B-Tech), Thiagarajar College of Engineering, Madurai, India

Technical Expertise

Technical Expertise
S3, EMR, Glue, Glue Studio, SQS, SNS, Eventbridge, IAM, Aurora, stepFunction, Kinesis, Athena, Redshift, Lake Formation, RDS, MSK, Databricks, Spark, Hadoop, Hive, Pig, Kafka, Spark Streaming, Kafka Streams, API Gateway, Java, Python, Scala, SQL, Shell Scripting, Azure, Azure Databricks, Azure Synapse Analytics, Data Factory, GCP, Big Query, Redshift, Snowflake, Oracle, Postgres, MySQL, DynamoDB, DocumentDB, HBase, Informatica, Ab Initio, Pentaho, Quick Sight, Airflow, Apache Iceberg, Hudi, ORC, Delta Lake, Parquet, RESTful APIs, GitHub, Jenkins, Bitbucket, Data Architecture, Solution Architecture, Data Engineering, Data Ingestion, Data Processing Architecture Patterns, Agile Methodologies, Data Modeling, Cloud Computing, Data Systems, Data Governance, Extract, Transform, Load, SDLC, SnowFlake, Data Management, Distributed Systems, Business Intelligence (BI), Web Services, Data Analysis, Data Streaming, Databases, Software Architecture, Microservices, DevOps, OLAP, Cloud Engineering, Dimensional Modeling, Programming, Data Lineage, Real-Time ETL, Data Mesh, Transactional Data Lake, Observability, Data Solution, Data Migration, Cost efficiency, Engineering Leadership, System Design, Serverless, Team management

Timeline

Solutions Architect(Enterprise-Data,AI/ML,GenAI)
Southwest Airlines
09.2023 - Current
Senior Solutions Architect-AL/ML Data
AMAZON- AWS
10.2022 - 07.2023
Sr SA-Engineering (Full-Time)
HEALTHCARE SERVICE CORPORATION, Blue Cross Blue Shield
08.2020 - 10.2022
Project Lead/Big Data Architect
MPHASIS, JPMorgan Chase
09.2017 - 07.2020
Technology Specialist-ETL
ATOS SYNTEL, AMERICAN EXPRESS
03.2015 - 09.2017
IT Analyst
TCS (AIG, SOUTHWEST Airlines)
09.2009 - 03.2015
Thiagarajar College of Engineering
Bachelor of Science from Information Technology
08.2005 - 05.2009

Similar Profiles

CREATE PROFILE
Sundhar AlagumalaiSr Solutions Architect