Senior Data Engineer with an experience of 7 years in the development/implementation of various projects using SAP HANA, Native SQL, Snowflake and BODS in the IT field.
<p>Creates information models using SQL scripting methods in HANA.<br>
Worked in creating complex Table Functions and Stored Procedures as per the requirement.<br>
Monitor Informatica jobs.<br>
Created command tasks and workflows in informatica to replicate tables from HANA to Hive.<br>
Created data ingestion to replicate jobs from HANA to Hive.<br>
Tracked performance of views after every change to ensure the report performance and present it for Architecture Review if major change occurs.<br>
Worked in SAP HANA to Snowflake Migration project wherein worked in analyzing the tool to be used for Data Validations, optimizing Snowflake models and redesigning critical HANA objects in Snowflake.<br>
Leading the team in Snowflake migration and conducting KT sessions for up skilling them in Snowflake.<br>
Creating optimized views, UDFs and Stored Procedures in Snowflake.<br>
Creating Tasks depending on the orchestration needs and creating role/row based access as per the requirement.<br>
Using Streams, Tasks and SnowPipe for various orchestration jobs and data loads.<br>
Using Dynamic Tables and query optimizations in Snowflake.<br>
Carried out Performance Tuning for Snowflake objects.<br>
Worked on Data Sharing in Snowflake</p>
❖ Creates information models using SQL scripting methods in HANA.
❖ Worked in creating complex Table Functions and Stored Procedures as per the requirement.
❖ Monitor Informatica jobs.
❖ Created command tasks and workflows in informatica to replicate tables from HANA to Hive.
❖ Created data ingestion to replicate jobs from HANA to Hive.
❖ Tracked performance of views after every change to ensure the report performance and
present it for Architecture Review if major change occurs.
❖ Worked in SAP HANA to Snowflake Migration project wherein worked in analyzing the tool to
be used for Data Validations, optimizing Snowflake models and redesigning critical HANA
objects in Snowflake.
❖ Leading the team in Snowflake migration and conducting KT sessions for up skilling them in
Snowflake.
❖ Creating optimized views, UDFs and Stored Procedures in Snowflake.
❖ Creating Tasks depending on the orchestration needs and creating role/row based access as
per the requirement.
❖ Using Streams, Tasks and SnowPipe for various orchestration jobs and data loads.
❖ Using Dynamic Tables and query optimizations in Snowflake.
❖ Carried out Performance Tuning for Snowflake objects.
<p>SQL analytical privileges to implement row level security.<br>
Optimized the report performance using various optimizing techniques.<br>
Carried out Currency Conversion for various Business Units involved.<br>
Materialized reporting views and retrieved through Direct Query from Power BI which improved data refresh time.<br>
Developed level hierarchies for the master data.<br>
Achieved Slowly Changing Dimensions (SCD) Implementation using BODS.<br>
Accomplished Case Transform and Validation Transform for data cleansing which corrected data.<br>
Modelled Information Views using proper optimized approach.<br>
Optimized SAP HANA views design using appropriate join options.<br>
Formulated HDBDD tables for providing scalability to the tables.<br>
Created cells for the cell level restrictions given by the client requirement.<br>
Executed Bex queries using calculated key figures, restricted key figures, variables, exceptions, and conditions.</p>
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
