Bhaskar (RID : 1ate6l7svnddb)

  • Data Engineer
  • Jaipur

Rate

₹ 379,000 (Monthly)

Experience

6 Years

Availability

Immediate

Work From

Offsite

Skills

Azure Data FactoryPower BISQL Server Integration ServicesSQL Server Analaysis ServicesAzure Data WarehousePythonAzure SQL

Description

Professional Experience
01/2021 – present
Hyderabad, India

  • Designed of Data warehouse for stable implementation.
  • Designed and developed Azure Data factory pipelines for Data migration.
  • Integrated Azure Data Factory for scheduling Jobs and Triggering other related Job.
  • Created Logic Apps to trigger the mail notification from ADF Pipelines.
  • Implemented Stored Procedures business logic in Azure SQL Data warehouse.
  • Created CI/CD pipelines for ADF deployment in ADO
  • Validated the data at overall and every dimension level.
  • Written test cases to validate data in ADO

09/2018 – 12/2020
Hyderabad, India
MAQ Software (Project: Successful Engagement BI)
Senior Software Engineer

  • Designed of Data warehouse for stable implementation.
  • Designed and developed Azure Data factory pipelines for Data migration.
  • Integrated Azure Data Factory for scheduling Jobs and Triggering other related Job.
  • Created Logic Apps to pull the data from SharePoint excels to ADLS.
  • Implemented Azure Databricks notebooks business logic at Data warehouse level.
  • Created a mount point in Python to access the files reside in ADLS.
  • Created user defined functions using Python.
  • Created data frames, views and tables using Python in Azure Databricks.
  • Used Python loops and aggregation techniques to process data in Azure Databricks.
  • Published the Fact and Dimension tables from ADB to Azure SQL Data warehouse and ADLS using Python.
  • Created validation framework using Python in Azure Databricks.
  • Created Tabular model on Fact and Dimension views which are in Azure SQL Data warehouse.
  • Updated Tabular level measures and dimensions, wrote DAX queries for calculated measures.
  • Validated the data at overall and every dimension level in Tabular, checked on data is slicing at every dimension level
  • Written test cases to validate data in at Tabular in ADO
  • Developed reports using Power BI.
  • Analyst with 6 years of experience in designing architecture and developing high quality Business Intelligence
  • Advaita Services

Senior Azure Consultant
Bhaskar
07/2017 – 08/2018
Hyderabad, India
MAQ Software (Project: One Commercial Partner)
Software Engineer 2

  • Designed and developed relational databases.
  • Guiding team members.
  • Developed SSIS packages to load the data from different sources to SQL and create a Data warehouse.
  • Implemented Stored Procedures to process business logic at Data warehouse level.
  • Created Tabular model on top of Data warehouse
  • Implemented main business logic for financial metrics in Tabular using DAX queries
  • Validated the data at overall and every dimension level in Tabular, checked on data is
  • slicing at every dimension level
  • Developed reports using Power BI.
  • Wrote automated BVT SPs to check values at each level on refresh of data developed script files on big Data platform to make the heavy data to be processed.

04/2016 – 06/2017
Hyderabad, India
MAQ Software (Project: Marketing Insights)
Software Engineer 1

  • Designed of Datawarehouse for stable implementation.
  • Created SQL code in multiple SPs to implement business logic.
  • Modified SSIS packages to load Assessment data to data warehouse.
  • Designed Power BI reports and Dashboards.
  • Implemented Row Level security in Power BI.
  • Wrote automated BVT SPs to check values at each level on refresh of data developed script files on big Data platform to make the heavy data to be processed.
Submit Query icon