Senthil Kumar Somasundaram Email & Phone Number

Campbell, California, Us

Passionate Data Architect with a mission to optimize healthcare services through cutting-edge cloud solutions and clinical data management. Currently spearheading innovation and excellence in a customer-facing role at a leading healthcare service provider. Bringing a proven record of crafting and executing data-driven strategies for enhanced patient care, operational efficiency, and strategic decision-making.Collaborating with clients to develop comprehensive data strategies, translating unique needs into tailored solutions.Designing and implementing customized cloud-based solutions for seamless data processing & normalized store, analysis, and accessibility.Architecting robust and scalable data structures with a focus on integrity, security, and compliance.Providing technical leadership and mentorship, fostering continuous learning and best practices adoption.Driving innovation through proactive identification of emerging technologies for enhanced patient outcomes.

Campbell, California, Us

Key responsibilities are to partner with P&C Insurance customers in their Data Modernization Journey on Cloud, delivering successful results with a focus on Project Success & Process Improvement.

Campbell, Ca, Us

Responsible for leading the definition of current and future state solution architectures whichincludes evaluation, selection and integration of vital technical components to build solution designsthat support the defined functional and non-functional requirements. Provide complete architecturedesigns that consider functionality, cost, performance, scalability, reusability, and extensibility.

Santa Clara, Ca, Us

Agilent business needs to form a data lake on cloud platform for their ML, Data analytics and BI Dashboard data requirements:Engaged as a technology leader, take responsibility taken as a Technical Architect, and come up with architectural blue print and project delivery road map to meet Agilent business requirement in terms of integrate with data security standards, control cost of ownership & robustness high scalable big data solutions.Drive significant organizational technology transformation by enhancing revenue-generating initiatives, technology knowledge with product development, and service delivery via the effective utilization of enterprise technologies and applications, which delivered within short span of time.

Oakland, California, Us

Worked as a Sr. Data Engineer involved in:• Collaborated with business and technical leads to understand the key business and architectural requirements, and defined the appropriate ETL/ELT and data solution and architecture & ensured that it meet QA/business needs.• Create ingest framework to extract data from heterogeneous databases and flat-files across multiple locations into Hadoop landing zone.• Involved in creating Kafka jobs to process streaming data from legacy applications; Developed and implementing test validations of kafka jobs• Involved in creating PySpark jobs to perform data transformations extensively used Dataframes and RDDs• Automate the manual validations using Python and Apache Spark and schedule them using Airflow• Build and maintained metadata management for e2e data integration requirements; Performed exploratory data analysis on existing products and datasets (both structured and unstructured).• Create framework to encrypt the PHI data.

Rosemead, Ca, Us

Worked as a Sr. Data Engineer involved in:• Collaborated with business and technical leads to understand the key business and architectural requirements, and defined the appropriate ETL/ELT and data solution and architecture & ensured that it meet QA/business needs.• Create ingest framework to extract data from heterogeneous databases and flat-files across multiple locations into Hadoop landing zone• Involved in creating PySpark jobs to perform data transformations, extensively used Dataframes and RDDs• Automate the manual validations using Python and Apache Spark and schedule them using Airflow• Involved in creating Kafka jobs to process legacy application streaming data• Developing and implementing test validations of HDFS data• Analyzing test results and recommending modifications to the existing hadoop jobs• Create framework to encrypt PHI data in performance environment• Fine tune big-data applications using various performance improvement techniques

Oakland, California, Us

Worked as a Senior ETL Developer / Lead in client location involved in:• Architect, Design for Centralized common data platform. and Develop all ETL/ELT components including data acquisition, cleansing, standardization, validation, staging, database persistence, and job execution processes. Delivered technical architecture various outbound feeds sourcing information from AWS/Heroku Cloud.• Developed an architecture document and designed data models and a data flow processes to support the reporting needs• Conduct assessment to determine the best cloud solution for implementing a cost effective, scalable and repeatable data and analytics solution for AWS, Snowflake and Looker cloud providers.• Outlined end-to-end strategy and roadmap for data platforms and as well as modernized data infrastructure and Built DaaS (Data as a Service) Define real-time and batch data ingestion architecture using Lambda approach using Apache Kafka,• Actively engaged with various external teams to obtain agreements on various matters pertaining to infrastructure setup, design decisions, architectural approach and others.• Lead a team and was actively involved in solution design, data mapping activities and supporting the ETL team during development of inbound & outbound interfaces.• Design and build of the Common Data Platform in AWS/Heroku Cloud. The Common Data Platform host and sync-up data from various PG&E and non-PG&E systems on batch and real time mode wherever possible.• Customer Data Platform will provide a canonical model Reusable Data Store from which data can be consumed by various Salesforce Orgs and other PG&E on premise systems.• Solutions provided the Data Migration Strategy and implemented the Prod & Non-Prod environment.

San Jose, California, Us

Worked as a Senior ETL Developer in client location involved in:• Sensitive Operational data had to protect data at rest, in use, and in motion. • Design and developed framework - each data layers had unique security challenges and provided the viable technical solutions in various technology stacks & achieved 100% data protected in non prod /production.

Teaneck, New Jersey, Us

Common Data Platform, Enterprise Data Lakes & Hadoop Implementation, Enterprise Functions and Services, Data as a Service (Daas)/Software as a Service (Saas), Agile Transformations, Big Data, Analytics, Firmwide Re-Usable Frameworks, Data Migration, Data Wrangling, Data Virtualization, Onshore & Offshore Modeling.Lead the Modern Data Architecture application development, deliver Big Data & Cloud Technologies and provide data engineering solutions to various business requirements. Expertise and hands-on knowledge in Bigdata Platform which include setup environment, Architectural design, development, testing and code deployment into productions.Hands on exposure in Big Data Analyst primarily using Scala, PySpark, HDFS, Flume, Sqoop, Hive, HBase and MongoDB, Kafka and Airflow, HDFS file storage format such as Parquet & Avro.Expertise in ETL methodology for developing/supporting Data Extraction from multi source environments, transformations and loading processed with using Informatica Tools. Hands on-experience in Teradata, Informatica, Oracle, SQL, PL/SQL, and Oracle Business Intelligence, Business Objects, Microsoft Azure. Big Data platform.Good solution design and system development experience in various data warehousing architectures, Data Profiling and Data cleansing frameworks, Data Integration and Data Migration systems. Expertise in data archival/retention implementation on production database SQL Queries performance tuning and workflow dependency analysis preparations, performance tuning of Informatica mappings; testing; Job Scheduling.

Pune, Maharashtra, In

Project: Enterprise Data ware Housing Application is a web-enabled solution based on BI tool that provides push-button reporting capabilities. It aims to fulfill all core reporting needs for UK Based Telecom -Major Business, Global Services & Wholesale Markets, in a systematic and unified way, enabling visibility of business information, supporting educated and faster decision-making.Role & Responsibilities 1) Responsible for technical leadership/code review to a development team. This includes the analysis of use cases and business requirements, involved & implemented various major/ minor releases.2) Responsible for project deliverable which includes Design/Data Mapping document, Deployment Plan with source codes, Configuration Management, UAT Cases and regular update to Run Book/ KT/System Documents.3) Design & coded for flexibility, maintainability, ease of support and operational robustness. Drive reuse by using components such as mapplets and worklets.4) Design & Configured the Informatica mappings into DAC Server.Analysis designed the RPD for Data modeling (Star Schema, Snowflake) as per requirements & business rules.5) Coordinated with release and application support teams to ensure that the solution get deployed smoothly into the QA and Production environments. Also defined support protocols and standard operating procedures. Closely worked with the reporting team to improve query performance for the reports running in OLAPInvolved in Oracle 10g upgrades on production Environment. Identified strategy for data acquisition and archival on production Environment. Attend SCRUM/delivery calls with Development and VV & T Team.Responsible for team management, co-ordination with onsite team, project plan, allocation of work, tracking of tasks and efforts.

In

Project : NPSA planned to migrate from SQL Server 2000 to Oracle 10g. Database data objects were migrated from MS SQL Server2000 (MS) to Oracle 10g(OG), that MS data objects like tables, views stored procedure, functions, Triggers, Job Scheduling and user defined data types are migrated to OG standard. The Data Replication/Migration system was incorporated between OG and MS. It helps to sync the data between both Databases.Technology:Windows Server2000, Tomcat 5.0, MS SQL Server2000, Oracle10g, JSP Oracle Migration Work Bench, Swiss SQL, SQL Developer 6.0 Tool.As a Technical Lead (with a team size of 7 & 3 Months) of the Application Development Group was responsible for the follows:Design and developed the Database Migration strategy (Database tables,Core Business components) .Prepared the Oracle standard Naming conventional documents.Involved in functional and Performance Testing.Involve/Prepared in the LLD, HLD.Design and Implemented the Data Replications for on going incremental data loadResponsible for Version control and release and build activitiesDemonstration and handover to technical support team .

Master’S Degree, Computer Science

Bachelor’S Degree, Physics