Senthil Kumar Velusamy

Background

About Senthil Kumar Velusamy

Experienced SAP Business Warehouse and GCP data engineer with over 16 years of experience in managing SAP data warehousing applications. Recognized consistently for performance excellence and contributions for successful BAU operations. Strengths in stakeholder management & good business acumen.Working as an technical lead and data engineer in managing the data warehouse platforms in both SAP BW (on HANA) and Google big data (BIG QUERY).SAP BW maintenance & enhancement:o Process chain creation / modification, o Data load performance tuning for transactional data loading by building aggregates, indexes etco Analyzing custom ABAP extractors & routines,o Data load failures of both master & transaction datao Strong working knowledge on the reporting using Business Explorer and Bex Analyzer, customizing bex queries based on requiremento Enhancing (User Exits) and created generic data source extractors using function modules for various BW reports based on the user requiremento Developed and tested new objects (Info objects, DSO, Info cube, BEX query and WAD template) according to the user requirementGCP Data Engineer:• Requirement gathering across projects and providing guidance on Data modelling & Transformation as per business requirements using cloud and Bigdata based solutions.• Responsible for maintenance of data ingestion in GCP Bigquery and data file processing from landing google cloud storage bucket into the Bigquery tables and monitoring alerts.• Maintenance of cloud schedulers, cloud Functions using Python, batch query SQL and Apache airflow DAGs for data ingestion in Google cloud Big query.• Responsible for Maintenance of Dataset tables & DataMart views and integrated layers in GCP Big query for business teams and stakeholders using SQL scripts and batches.• Responsible for Maintenance of data ingestion pipelines in Hadoop using Nifi application and data import/export into other on prem databases SAP BW / HANA and applications using Sqoop. • Drawing data retention policies and optimizing data storage by setting expiration values set at table levels in BigQuery. Files storage in GCS buckets are maintained and kept intact by setting up bucket level retention policies.• Creation of data visualization and reconciliation reports, dashboards in Tableau and cloud Data studio.• Actively participated in migrating SAP BW / HANA Data Warehousing into the GCP (new cloud-based platform for woolworths).