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.