Umapathy Dhanapal
Rahway,United States
Summary
Experienced DE & BI Architect skilled at driving results, with a consistent history of delivering software solutions, optimizing processes, and leading projects for prominent organizations. I demonstrated expertise in aligning business strategy with the development of Data Products in Data Lake and Lakehouse, Data Warehousing, and BI solutions. Proven success in software project management, fostering cross-functional relationships, and leading growth-focused initiatives. Visionary leader with a strong foundation in Data Governance, change management, strategic planning, BI solutions, and operational process automation. Committed professional excelling in interpersonal communication, organizational skills, project management, and successful product implementation.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Technical Manager | Data Engineering | BI Architect
HCL America Inc. – Merck Inc.
2013.04 - Current
- Led Data & Analytics SME role in Manufacturing, collaborating across internal and external sites
- Bridged projects between Business, Site SME, Data Science Group, Process, Test automation team, and other Technology teams
- Utilized Data Build Tool (DBT) with Python and SQL for efficient data transformation and modeling, enhancing data reliability and accessibility
- Extensive proficiency in SQL, PL/SQL, complex Joins, Aggregation functions, DBT, Python, Data frames, and Spark, ensuring robust data manipulation and analysis capabilities
- Proficient in GitHub and CI/CD Pipelines, as well as AWS Infrastructure components like IAM Role, Secrets, and S3 buckets, ensuring secure and scalable data management
- Designed and developed product Data Marts with customized business logic for PDM products Keytruda, PCV, and Gardasil on Manufacturing data for internal and external sites
- PL/SQL (Tuning, Tables, and Stored Procedures) with airflow Orchestration
- Built Batch Genealogy and Batch Consumption of PCV and Gardasil Products, delivered as data product in Access Layer / BI
- Independently addressed and resolved problems, delivering Data Products (Source Confirming Layer) through DBT-TRINO and AWS Redshift from big data environments (Data Lake and Lakehouse)
- Developed a Data Product involving highly complex business calculations for chromatography attributes (Retention Time, N plates, and Asymmetry) related to the Elution process of the Gardasil (GID) product
- Processed a substantial volume of time course data efficiently and effectively, delivering results to the Gardasil Investigational Business team
- Played a key role in developing a robust cycle number and implementing intricate business logic
- This was particularly significant for Gardasil, where the time course data exhibited high volume
- The resulting solution effectively managed and processed the temporal aspects of the data, ensuring accuracy and efficiency in cycle numbering for enhanced analytical insights
- Led initiatives to migrate Product Data Management from on-premises Teradata to AWS Cloud Technology migration
- Automated Unit Testing using Python Robot Framework and Jenkins
- Automation of Data Quality Checks in Redshift and highlight violations or potential issues as part of the Airflow Job
- Built data model (Dimensions, Facts) to enable reporting & analytical capabilities and ensure optimal design & performance, incorporating appropriate security mechanisms for Quality Customer Complaint (QCC4), External Supplier Audit Management (ESAM), Global Safety and Environment (GSE HtR) with appropriate security mechanisms for various domains
- Built BI Dashboards for QCC4 and ESAM and Delivered a Product model for super user consumption
- Expertise in dashboard performance improvement, tuning Backend, and front-end techniques
- Executed solutions for BI use cases, leveraging BI features to balance dashboard performance and post-loading response for 'Train of Thoughts' analysis
- Designed end-to-end solutions for multiple streams, enabling the data integration team to process data through Informatica and advanced SQL and PL/SQL
- Built optimized dashboards for cross-functional teams, including sales dashboards for executives, managers, and sales reps; product dashboards; BI Environment Usage Dashboard; automation of reports distribution to user email
- Collaborated with workstream teams to develop architecture, data, and process flow diagrams for data product & analytics projects
- Involved in data identification, integration, reporting & analytics
- Supported new initiatives on presales activities, building POC, providing time and cost estimates, and presenting to leadership and customers.
BI Technical Lead | Data Analyst | Sr. BI Developer | Support Analyst
HCL Technologies Ltd. – Merck Inc.
2006.06 - 2013.03
- Oversaw technical leadership for multiple concurrent projects within the Global Reporting and Analytical Model (GRAM) Solution Delivery framework
- Directed the Business Intelligence (BI) workstream, encompassing Data Modeling, ETL, and BI Reporting, and facilitated collaboration across different workstreams
- Developed Sales & Activity Dashboards, authored technical documentation, and supported the Data Modeling and ETL teams for business and technical inquiries and project estimations
- Validated requirements and high-level designs with Japan's IT Divisional team and collaborated with Operations and BISS teams for security validations
- Successfully migrated from Cognos 8.2 to 8.4, resolving all associated migration challenges
- Provided support for System Integration Testing (SIT), User Acceptance Testing (UAT), deployment, and hyper care phases
- Participated in reverse engineering and data validation for BI reports and existing natural language report outputs
- Led the gathering and analyzing of business requirements, designing, and developing IBM Cognos Framework Models, reports, and Transformer models, and coordinated team efforts to meet requirements
- Delivered second-level support for BI applications
- Executed cube swap and refresh tasks on Unix/Linux and Windows platforms
- Accountable for migration and upgrade projects within the BI domain
- Maintained Authentication and Authorization (A&A) of LDAP Security across all environments
- Created and upheld Standard Operating Procedures (SOPs) and operational checklists for all BI environments
- Provided third-level support for BI Applications across HR, Finance, MRL, MMD, and GHH departments.
Education
Master of Computer Applications -
Madurai Kamaraj University
Madurai, Tamil Nadu01.2006
Bachelor of Science in Computer Science -
University of Madras
Chennai, Tamil Nadu01.2003
Skills
- Data Engineering
- Data & Analytics
- Big Data / Data Lake
- RDBMS / Data Marts
- Business Requirements
- Healthcare Domain
- Process Automation
- Team Collaboration
- SDLC, GxP Compliance
- Cloud Data Architecture
- AWS Glue
- Athena
- SQL
- Redshift
- DBT
- TRINO
- PL/SQL
- JIRA
- DevOps (CI/CD)
- Git
- GitHub
- Jenkins
- Airflow
- Python
- SAP Power Designer
- GenAI
- Power BI
Certification
- IBM Cognos Professional Certified, Metadata Modeling, Authoring, Administration, Access Manager
- AWS Solution ARCHITECT: Associate, Live classroom Course Training, expected to be completed by May 2024.
Accomplishments
- Provides direct leadership for 10 associates including Business Analysts, Data Analysts, BI Analysts, data engineers, modelers, data scientists & testers (i.e., solution, Peer reviews, mentoring, development, and training).
- Developed a tool that automatically generates impromptu catalog information in Rich Text Format (RTF) for metadata, aiding application owners in identifying data sources, and database objects, and mapping business columns to technical columns. This initiative resulted in cost savings while migrating legacy platforms to a new version of BI tools.
- Annual saving of $500K by automating the 'Report generation and Distribution' process, which reduced manual effort.
- Optimized Data Mart Objects for Dashboards which gained 85% performance improvements.
- Utilized PySpark to process and analyze large datasets in a Data Lake environment, improving data retrieval efficiency by 30%.
- Annual saving of 5700 person-hours by automating test cases for System Integration Testing and Unit Testing through Python
- In-depth knowledge of data architecture principles and best practices, including data modeling, data warehousing, data lakes, and data integration, working with CDC, Batch processing/loading, ETL, and ELT
- Demonstrated experience in leading large Data Engineering teams to design and build platforms with complex architectures and diverse features including various data flow patterns, relational and no-SQL databases, production-grade performance, and delivery to downstream use cases and applications.
- Hands-on experience in designing end-to-end architectures and pipelines that collect process and deliver data to its destination efficiently and reliably.
- Proficiency in data modeling techniques and the ability to choose appropriate architectural design patterns.
- Proficiency in Apache Airflow for orchestrating and automating data workflows, complemented by experience with containerization technologies like Docker for efficient deployment and management of data workloads.
- Proficiency in version control systems and knowledge of DevOps practices for automating data engineering workflows
- Specialized in Business Intelligence with expertise in IBM Cognos, Spotfire, Power BI, Tableau, SQL & PL/SQL. Worked on state-of-the-art tools and technologies AWS Cloud Services such as Athena, Glue, S3, Spark
- Strong organizational and documentation skills from both business and technology perspectives.
- Actively interacts cross-functionally with a wide variety of people and teams.
- Experience in end-to-end development of a new set of reports, dashboards, and stories.
- Extensively used Tableau reporting functionalities such as hierarchy, drill down and drill up, group, calculated fields, filters, ranking, parameters, graphs, forecasting, trend, and reference lines.
- Created various reports and dashboards in Tableau Desktop based on business requirements using various charts such as heat maps, scatter plots, stack bars, bar graphs, geographical maps, and pie.
- Actively involved as a Data Analyst in Desktop / Server architecture, analysis, design, modeling, and development of charts, graphs, dashboards, and interactive reports using various data sources like RDBMS(Oracle, Redshift, MS SQL Server), Data warehouse, DataMart, Python, Databricks, Big Data stores, and AWS Cloud.
- Analyzed complex, high-volume, high-dimensionality data from various sources with data cleansing, data transformation, and data classifications. Query Performance Tuning.
- Designed and developed Dashboards using Spotfire, IBM Cognos, Tableau & Power BI for Manufacturing information.
- Strong experience in report creation and visualizations that summarize data sets and provide data-driven insights to Business users and Customers. Represented BI COE (Centre of Excellence)
- Experience in connecting Tableau to a variety of on-premises and Cloud-based databases extracting data from different data sources and conducting an analysis to create database joins in Tableau to model data.
- Responsible for fine-tuning SQL queries to improve performance and optimization.
- Champion best practices for the development and management of reporting solutions thereby providing faster turnaround time for all the Tableau dashboards. Involved in IBM Cognos and Tableau Admin activities.
- Worked in coordination with clients for the feasibility study of the projects in IBM Cognos, Spotfire, Power BI, and Tableau
- Experience in SDLC development life cycle. Involve in all phases starting from requirement gatherings to production deployment such as Analysis, Design, Development, implementation, and deployment.
- Prepared all SDLC documents (Risk Assessment, QAP, RS/FRS, DTP, DS/DCS, DSR, RTM, TP, ATP, IQOQs, TS, QASR, CRQ, etc.) and worked closely with Technical, Business, and Quality Unit to ensure successful delivery.
- Experience with relational databases, JSON, XML, and related tools and languages (e.g., SQL, Python, R) for data wrangling and automation.
Hobbies and Interests
- Volleyball
- Marathon running
- Cycling
Timeline
Technical Manager | Data Engineering | BI Architect
HCL America Inc. – Merck Inc.
2013.04 - Current
BI Technical Lead | Data Analyst | Sr. BI Developer | Support Analyst
HCL Technologies Ltd. – Merck Inc.
2006.06 - 2013.03
Master of Computer Applications -
Madurai Kamaraj University
Bachelor of Science in Computer Science -
University of Madras