Summary
Overview
Work History
Education
Skills
Certification
Professional Experience
Roles
Industries
Timeline
Generic
Ankita Dwivedi

Ankita Dwivedi

Bangalore

Summary

8+ years of experience in data engineering and reporting landscape using Microsoft Azure cloud platform and Azure data bricks.

Highly-motivated with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Excellent communication skills, highly organized and self -motivated team player. Quick learner, versatile, adaptable, and process-oriented, with a high customer orientation.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

IBM
01.2021 - Current
  • Working with Business & Analysts to understand the requirements, designing the solution & prioritized the same in sprint planning meetings with team
  • Developing & maintaining the data pipelines for different integration which brings data to ingestion layer and then to prep and SSAS cube layer for reporting
  • Working as Maintenance lead and SME for application & guiding team in solving complex business issues.
  • Created SQL scripts to query, update, and manage databases as well as optimize queries for performance improvement.
  • Optimized existing database structures to improve scalability, efficiency, and performance.

Senior Data Engineer

01.2019 - 01.2021
  • Responsible for developing SSAS model module wise and re-writing SQL reporting queries (generated from business object) to similar DAX queries
  • Developed dynamic stored proc to load the data into transaction and dimension tables
  • Created SSIS package to download the CSV files shared in SharePoint folders and processed the files using dynamic variable functionality as files were inconsistent.

Software Engineer

01.2015 - 01.2018
  • Played the role of PowerBI reports & dashboard developer
  • Developed calculated measures in Azure Analysis service as per the reporting requirement
  • Implemented linked services, Input/output dataset & function app to validate and run the pipeline
  • Did performance testing & tuning of DAX queries in Power BI and Azure Analysis services
  • Created consumer behavior reports and dashboards in PowerBI

Education

B.Tech - Computer Science

Rajasthan Technical University
Rajasthan
06-2014

Skills

  • Azure Data Lake
  • Azure Managed Instance
  • Azure Data Factory
  • Logic Apps
  • Azure Data Bricks
  • Power Apps
  • Power BI
  • SSAS Tabular Model
  • SSIS
  • MS SQL Server
  • Pyspark
  • DAX
  • T-SQL

Certification

  • Google Cloud Certified: Professional Data Engineer.
  • Microsoft Certified: Azure Data Engineer
  • Microsoft certified: Azure Fundamentals.

Professional Experience

I am working as Lead data engineer and responsible for new enhancement & maintaining the product on daily basis. I primarily work on Microsoft Azure cloud where get involve in requirement gathering , Development & Code review. I have experience in Data modelling, designing and Hands-on experience in Microsoft DWH and MSBI Technologies including MS Azure. Experience on fact and dimensional model like star and snowflake schema She has a good understanding on ELT or ETL Concepts along with Data Modelling/ warehousing. Aware of Business intelligence development lifecycle including requirement gathering, Solutioning, Design, Development, and unit testing. She has Worked on Azure components like LogicApp, Data factory, Azure Key vault, Automation runbook, Azure service bus Topic , Queue, Event Grid. Real time data processing. I am a quick learner & highly organized and self -motivated team player and excellent problem solver regardless of technology and has been able to understand and tackle azure cloud related challenges effectively.

Roles

  • Lead Data Engineer
  • Senior Data Engineer
  • Software Engineer

Industries

  • Retail- FMCG
  • Fashion

Timeline

Lead Data Engineer

IBM
01.2021 - Current

Senior Data Engineer

01.2019 - 01.2021

Software Engineer

01.2015 - 01.2018

B.Tech - Computer Science

Rajasthan Technical University

Similar Profiles

CREATE PROFILE
Ankita Dwivedi