Badges
Certifications
Work Experience
Data Engineer
MNPβ’Β Β December 2022 - August 2023
Project 1: β’ Orchestrated end-to-end data transformation and analytics initiative by seamlessly integrating Snowflake as the core data warehousing solution and utilizing Power BI for impactful data visualizations. β’ Acted as an Individual Contributor overseeing the migration process: Set up Snowflake architecture, and clusters, and Migrated required files from a local file system to Snowflakeβs Internal Stage based on the clientβs preferences and enabled loading into tables using a Snowpipe. β’ Utilized Snowflake's Snowsight and query profiling tools to identify and optimize resource-intensive queries, leading to a reduction in overall credit usage by 50%. β’ Created Snowflake Tasks to monitor data loads ensuring accurate and timely data delivery. Project 2: β’ Successfully transitioned data workflows from legacy on-premise systems to modern cloud-based architecture, utilizing Informatica and Azure Data Factory. β’ Designed and executed parameterized pipelines and data loading strategies in ADF, facilitating efficient data extraction from diverse sources. It further helped us to achieve a 30% reduction in data latency and data delivery to meet real-time business demands. β’ Led intricate data transformations using Azure Databricks Unity Catalog feature to establish a cohesive data management framework. β’ Developed a dynamic Databricks function to retrieve sequence numbers and execute stored procedures, significantly optimizing data workflows. This initiative led to a 45% reduction in processing time and resource utilization. β’ Deployed automated ADF triggers to accelerate data processing and enhance pipeline reliability.
Data Engineer
HCL Technologiesβ’Β Β April 2021 - November 2022
Project 1: β’ Completed a comprehensive end-to-end overhaul of Successhub CRM, upgrading it to the latest V1 version and seamlessly integrating essential entities through ADF and Synapse pipelines. β’ Oversaw Performance Tuning using Polybase in ADF as a copy method and brought down Azure resource consumption by 70% in terms of data movement speeds and query processing costs. β’ Documented every possible ADF Product-related bug, and its workaround and presented them in MS Ignite. β’ Wrote production-level SQL and Kusto queries to bring in data related to various use cases in Dynamics 365. β’ Highly involved in creating Azure DevOps pipelines, tasks, and work items every sprint and sent a status update with a Pivot chart to both management teams for better alignment of work. β’ Shared knowledge with other teams in the organization and mentored entry-level developers. Project 2: β’ Solely responsible for migrating Databricks notebooks to Azure Synapse Analytics by rewriting required functionalities in Spark and adding web activities in ADF to optimize this change. β’ Handled Production jobs related to SQL, ADF, and Tabular Models using Lens Explorer and made sure incidents were mitigated. β’ Developed interactive reports and dashboards in Power BI for product teams like Support, and Case Review and contributed to several KPI calculations. β’ Along with an FTE of Microsoft, migrated all the reports in every product area from Tabular Model to Power BI Service modeling with data quality. β’ Resolved outages on mission-critical cube and pipeline failures, provided root-cause analysis in the Production Environment, and worked in multi-functional agile teams to continuously experiment, iterate, and deliver on new product objectives.
Crew Trainer
Mcdonaldsβ’Β Β November 2018 - April 2021
β’ Maintaining higher standards of customer service during high-volume, fast-paced operations and consistently providing quality food and great hospitality. β’ Performing various tasks within the restaurant: including preparation and production, according to McDonald's standards. β’ Responsible for training our crew members and motivating them to be good team players both in the kitchen as well as in front.
Database Developer
Vizag Steelβ’Β Β May 2017 - April 2018
Worked in a team of four, as a Web Developer, as well as a database administrator with Rashtriya Ispat Nigam. The project is about developing an Entry Control application and maintenance of their data on the database which lets employees enter individual departments in the industry. β’ Design the web pages using HTML, CSS, and JavaScript. β’ Build a user interface and prototype for the application and troubleshoot website problems. β’ Develop database architecture using MySQL and optimize the database through different normalization techniques. β’ Connect the database to the website with PHP and maintain the website periodically. β’ Focused more on the database rather than the UI.
Education
Concordia University
Software Engineering, MSβ’Β Β September 2018 - December 2020
I'm pretty sure, of all the years I've studied, these two amazing years have become my life-changing years. It's true that with the great power of knowledge comes great responsibility, I came to understand the core concepts of Software Engineering. Practiced coding for a long time and learned various application development techniques both frontend and backend. Some exciting courses are Human-Computer Interaction and Interfaces, Advanced Programming Practises, Software Measurement, Software Project Measurement. These helped me a lot professionally.