Summary
Overview
Work History
Education
Skills
Certification
Software and Tools
Clients
Domain
Visa Status
Software and Tools
Clients
Domain
Visa Status
Software and Tools
Clients
Domain
Visa Status
Generic

Thirumurugan Haridasspandian

Doylestown

Summary

Self-motivated ETL Architect with 10+ years of experience in warehouse data management. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems. Bringing comprehensive understanding of warehouse operations and documentation needs. Technologically savvy and focused ETL Architect with strong background in advanced data management and troubleshooting skills . Effective in developing and optimizing data systems to meet customer needs. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

17
17
years of professional experience
1
1
Certificate

Work History

ETL Architect

HCL America Inc
11.2014 - Current

Client : Merck & Co Inc.,

  • Enhanced ETL performance by optimizing data pipelines and implementing parallel processing techniques.
  • Reduced data load times by identifying bottlenecks and improving database indexing strategies.
  • Designed and implemented scalable ETL solutions for efficient data extraction, transformation, and loading across various platforms.
  • Streamlined data integration tasks by automating manual processes and introducing scheduling tools.
  • Improved data quality by implementing comprehensive validation checks and error handling procedures within ETL workflows.
  • Have Created robust framework for Regional / Global Sales reconciliation process to improve data quality and reliability.
  • Achieved high level Data Quality through Automation and Proactive monitoring.
  • Designed and implemented Veeva Network MDM solution by using Informatica ETL for customer master data in Veeva CRM
  • Designed and Implemented MCM module in Veeva CRM by integrating external source by using Informatica ETL
  • Worked on successful migration of legacy systems by designing robust ETL architectures compatible with newer technologies. Ex: Oracle to Redshift Migration and Informatica Power Center to IDMC migrations.
  • Led a team of developers in delivering high-quality ETL solutions on time and within budget, fostering strong working relationships among team members.
  • Created detailed documentation outlining design specifications for each stage of the ETL process, enhancing knowledge sharing among team members.
  • Collaborated with data analysts and business intelligence teams to identify data requirements and ensure that ETL processes support their reporting needs.
  • Collaborated with cross-functional teams to gather requirements for the development of ETL processes, ensuring accurate data transformation.
  • Implemented data ingestion to Redshift by using IDMC.
  • Implementation of Share point data integration by using IDMC.

Technical Lead

HCL Technologies
01.2012 - 11.2014

Client : Merck & Co Inc.,

  • Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
  • Led team of developers to successfully deliver high-quality software projects on time and within budget constraints.
  • Implemented continuous integration and deployment strategies for faster release cycles and improved application reliability.
  • Increased application stability by regularly monitoring performance metrics, addressing bottlenecks proactively to minimize downtime occurrences.
  • Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
  • Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
  • Collaborated with product managers, designers, and business stakeholders to define project requirements, ensuring alignment with organizational goals.
  • Optimized resource allocation across multiple concurrent projects by closely tracking team capacity levels against project deadlines and milestones.
  • Facilitated knowledge sharing sessions within technical team to improve skillsets and encourage innovative solution development.
  • Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.
  • Investigated system issues and implemented resolutions to reduce downtime.
  • Offered input on technical and platform-related strategic planning initiatives.
  • Advised management, business and technical staff on solutions using specific domains or technology.
  • Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
  • Teamed on development of technology road map spanning 4 Years

Project Lead

Mahindra Satyam
10.2010 - 12.2011

Client : Nissan North America Inc.,

  • Streamlined project management processes by implementing Agile methodologies and improving team communication.
  • Enhanced client satisfaction by consistently delivering high-quality projects within budget and on schedule.
  • Mentored junior team members, fostering professional growth and increasing overall team efficiency.
  • Reduced project completion timeframes through strategic resource allocation and efficient task delegation.
  • Planned and promoted total 5 projects in 2 years

Senior Software Engineer

Mahindra Satyam
09.2006 - 09.2010

Client : Sony Electronics, North America.,

  • Enhanced software functionality by identifying and resolving complex technical issues.
  • Optimized code performance for improved user experience and system efficiency.
  • Collaborated with cross-functional teams to design innovative software solutions.
  • Mentored junior developers, fostering professional growth and enhancing team productivity.
  • Delivered exceptional client support by promptly addressing concerns and implementing requested changes or enhancements to software solutions.
  • Regularly reviewed peers'' code contributions, offering constructive feedback to enhance overall product quality.
  • Proactively identified areas for process improvement, implementing changes that led to significant time savings for team.
  • Worked with project managers, developers, quality assurance and customers to resolve technical issues.
  • Provided technical support using knowledge of complex technology to solve problems and support new projects.
  • Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
  • Delivered unit-tested systems within customer-prescribed timeframes.
  • Updated old code bases to modern development standards, improving functionality.

Education

B.Tech - Textile Technology

Anna University
Chennai, India

Skills

  • Project Management Experience
  • ETL Modeling
  • Data Quality Management
  • Master Data Management
  • Performance Tuning Abilities
  • Agile Methodologies
  • ETL Tool Proficiency
  • Data Integration Expertise
  • Data Warehousing Knowledge
  • Code Review
  • Analytical Skills
  • Problem-Solving
  • Team Building
  • Data Migration
  • Requirements Gathering
  • Technical Troubleshooting

Certification

Issuer: DataBricks Academy Accreditationhttps://credentials.databricks.com/a6c7efad-18f2-4a95-b7b0-8da1b7b3f720Valid: Till Jan 17,2025

  • AWS Certified Cloud Practitioner

Issuer: Amazon Web Services Training and Certification

Valid till Jan 10, 2027

  • Achieved Badge on AWS Certified Cloud Practitioner

Issuer: Amazon Web Services Training and Certification

https://www.credly.com/badges/c59fb3d2-f2db-4df9-bb64-75f653c14eaa/public_url

  • Achieved Badge on AWS Cloud Essentials

Issuer: Amazon Web Services Training and Certification

https://www.credly.com/badges/5abc2df2-6b5f-43be-b406-2ee8bfdcf8a2/public_url

  • Achieved Badge on Data Bricks Lake House Fundamentals.


Software and Tools

Informatica Power Center

IDMC(Informatica Data Management Cloud)

Veeva CRM( Sales Force)

Veeva Network

Oracle

Redshift

Linux

JIRA(Agile Board)

MEDS(Documents repository)

Remedy

Clients

Sony Electronics USA

Nissan Motors, USA

Merck & Co Inc.

Domain

Manufacturing,Automobile and Healthcare

Visa Status

H1B Valid till 21 Nov 2025 (140 Approved)

Passport Number : V3992319

Software and Tools

Informatica Power Center

IICS / IDMC(Informatica Data Management Cloud)

Veeva CRM( Sales Force)

Veeva Network

Oracle

Redshift

Linux

JIRA(Agile Board)

MEDS(Documents repository)

Remedy

Clients

Sony Electronics USA

Nissan Motors, USA

Merck & Co Inc.

Domain

Manufacturing,Automobile and Healthcare

Visa Status

H1B Valid till 21 Nov 2025 (140 Approved)

Passport Number : V3992319

Software and Tools

Informatica Power Center

IICS / IDMC(Informatica Data Management Cloud)

Veeva CRM( Sales Force)

Veeva Network

Oracle

Redshift

Linux

JIRA(Agile Board)

MEDS(Documents repository)

Remedy

Clients

Sony Electronics USA

Nissan Motors, USA

Merck & Co Inc.

Domain

Manufacturing,Automobile and Healthcare

Visa Status

H1B Valid till 21 Nov 2025 (140 Approved)

Passport Number : V3992319

Thirumurugan Haridasspandian