Shivanshu Patel

• I am a system engineer with 2 years of experience in software development and support projects based on Microsoft Cloud Azure in the healthcare domain.
• Experienced in support and development of extract, transformation, mapping, and Loading data from heterogeneous sources (databases and ERP applications) to data warehouse as per the business requirements.
• Experienced in code development for Database objects like Tables, Views, Indexes, Stored Procedures, and User Defined Functions on Azure cloud as per technical designs.
• Experienced in creating ETL Workflows based on Functional Specification Document.
• Worked closely with the Project/Program Managers,Business, Data/ETL in determining the exact business rules and functionalities required for deliverables.

• As a system engineer, my role is to work on new business requirement enhancements, to monitor daily activities to deliver the Extracts and reports to the business without any delay or issue.
• Enhancements, support and maintenance activity for BI Platforms and Independently handling Daily ETL data load and job recovery.
• Regular activity of Customer incidents resolution and request fulfilment using Service Now ticketing tool.
• Enhancements of existing ETL logics for performance tuning and Bug Fixing.
• Writing and implementing business logic using SQL and Azure.
• Investigating and resolving users/business issues.
• Writing moderate SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
• Created Pipelines, copy activities, scripts and dataflows to integrate the data coming from flat files.
• Created Azure Pipelines for loading data from Oracle ERP to cloud database.

Problem-Solving, Time Management, Effective Communication, Self-Awareness, Leadership, Teamwork, Agile way of working.