Umapathy Dhanapal

About Umapathy Dhanapal

As a Technical Manager at HCLTech, I develop data Engineering and business intelligence solutions for Merck, one of the world\'s largest pharmaceutical companies. With over 18+ years of experience in designing, developing, and delivering data models, Data Products, and analytics solutions using various tools and technologies, such as Snowflakes, AWS, Redshift, SQL, PL/SQL, PowerDesigner, DBT, Databricks, Airflow, Jenkins, Python, PySpark, Python Robot Framework, TIBCO Spotfire, Tableau, Power BI, and IBM Cognos.I am a certified BI Reporting professional and a subject matter expert in Data Modeling, Databricks, Business Intelligence tools, SQL, PL/SQL, and DataMart. Leveraging the power of Large Language Models (LLMs) such as myself, I can analyze complex data products, identify areas for improvement, and provide insights to optimize solutions.My strong analytical and problem-solving skills, combined with my ability to follow through on complex projects in Data lake/Lakehouse Architecture & DWBI, enable me to deliver high-quality and user-friendly solutions that meet the business needs of Merck and other clients. I am also committed to staying updated with the latest trends and best practices in the Data & Analytics field, utilizing AI-driven tools like natural language processing (NLP) and machine learning (ML) to enhance my skills and expertise.Some of my notable strengths include:Data Engineering : Designing, developing, and delivering scalable data pipelines, data products using AWS, Databricks, trino, redshift oracle, and other technologies.Business Intelligence : Building reports, dashboards, and analytics solutions using tools like Tableau, Power BI, IBM Cognos and TIBCO Spotfire.SQL and PL/SQL : Developing complex queries and stored procedures to extract insights from large datasets.Data Modeling : Designing data models for data lakes, warehouses, lakehouse and other architectures.Collaboration : Working with cross-functional teams to deliver high-quality solutions that meet business needs.Certifications and Expertise:Certified/trained / SME as Data Modeling and Databricks Data ProductPython, SQL and PL/SQL expertiseData integration (ETL/ELT)BI Reporting Experience with data lake/Lakehouse Architecture & DWBI projectsAI and Machine Learning:Utilizing Large Language Models (LLMs) for Generative AI applications to enhance data analysis, reporting, and visualization.Self-learning and experimenting with various LLMs to drive innovation [Leverage LLMs to verify and correct generated content, ensuring accuracy and completeness].

Experience

1. Sr Data Engineer Technical Manager Data Modeler

   HCLTech

   Jul 2021 — Present · Rahway, NJ, US

Education

• University of Madras

  Bachelor’s Degree, Computer Science

  2000 — 2003

• Madurai Kamaraj University

  Master’s Degree, Master of Computer Applications (MCA)

  2003 — 2006