Retail Analytics-Structured Data Flow in a DataWarehouse:I established Apache Hive as the foundation, housing all raw datasets in their initial format.I implemented BigQuery for data enrichment, making it readily accessible for analysis by other teams.I utilized SAP HANA to store the final datasets which were consumed by the sourcing and procuring react dashboard.Automated Workflows:I developed ETL pipelines in Apache Airflow using DAG files… Show more Retail Analytics-Structured Data Flow in a DataWarehouse:I established Apache Hive as the foundation, housing all raw datasets in their initial format.I implemented BigQuery for data enrichment, making it readily accessible for analysis by other teams.I utilized SAP HANA to store the final datasets which were consumed by the sourcing and procuring react dashboard.Automated Workflows:I developed ETL pipelines in Apache Airflow using DAG files. These pipelines automated the movement and transformation of data between each stage, streamlining the entire process.Enhanced Web App Efficiency:I optimized the data access layer in Dreamio to seamlessly point to the new Hive data warehouse. This resulted in significantly faster refresh rates and improved efficiency for the web application relying on this data for sourcing and procurement tasks. Show less

Supply Chain Analytics:Created a recommendation generation pipeline for inventory rebalancing process with extraction component comprising of a pyspark script to consolidate all required metrics from different data points from a data mesh into a single integrated ADS (Analytical Dataset).Analysis component leveraging pyspark script to clean and transform the integrated ADS which is ingested by the optimization model (Gurobi) to produce the most optimal transfers which are… Show more Supply Chain Analytics:Created a recommendation generation pipeline for inventory rebalancing process with extraction component comprising of a pyspark script to consolidate all required metrics from different data points from a data mesh into a single integrated ADS (Analytical Dataset).Analysis component leveraging pyspark script to clean and transform the integrated ADS which is ingested by the optimization model (Gurobi) to produce the most optimal transfers which are stored in a hive asset.Implemented an optimized data management strategy by utilizing partition overwrite in Hive assets to mitigate data duplication and bloating and improved governance by implementing best practices for maintaining Hive assetsDeveloped CI/CD pipelines to enforce industry-standard compliances for seamless flow from development to production environment for activities such as Databricks notebook migration, deploying wheel packages, and updating shell scripts in DBFS, ensuring efficient and reliable software delivery. Show less

Perfect Vision In-Store Analytics:Switched from Azure SQL database to Hive Meta store as Delta Tables.This was undertaken to overcome the size and concurrency limitations of SQLDeveloped global parameterized live stream and batch pipelines utilizing ADF (Azure Data Factory) to facilitate Image Recognition (Yolo V5) with Azure ML. Flow. Leveraged Databricks for robust data analysis and insights for all merchandiser store visitsCreated a dynamic script using Pandas in… Show more Perfect Vision In-Store Analytics:Switched from Azure SQL database to Hive Meta store as Delta Tables.This was undertaken to overcome the size and concurrency limitations of SQLDeveloped global parameterized live stream and batch pipelines utilizing ADF (Azure Data Factory) to facilitate Image Recognition (Yolo V5) with Azure ML. Flow. Leveraged Databricks for robust data analysis and insights for all merchandiser store visitsCreated a dynamic script using Pandas in Databricks to be able to generate concise and comprehensive scorecards and reports for each combination of the store location and Perfect Store Key Performance Indicators (KPIs) along different marketsImplemented Azure Log Analytics workspace to monitor and log all activities within ADF (Azure Data Factory). Leveraged the collected data to create a comprehensive Data Quality Management (DOM) view in a Power BI dashboard, enabling stakeholders to gain valuable insights and track the performance of each pipeline run effectively. Show less

Interned as a Database Developer, contributing to the design and optimization of database structures. Worked on SQL queries, stored procedures, and database management tasks. Collaborated with the team to enhance data efficiency and ensure seamless functionality. Applied problem-solving skills to troubleshoot and optimize database performance

Worked as a web developer collaborating with a team of 5 to improvise the UX design of the e-commerce website. I used ReactJS to enhance the Navigation bar, Shopping Cart, Checkout Option, Login or Signup and also on the various forms such as Newsletter Subscription, Help, and Register. In the backend side, I worked on MongoDB on the inventory of products page and database.

Mainly worked on workflow of mutual funds Web API on visual studio primarily as an MVC controller project. I, further, implemented the project in C# and understood crucial concepts of a web API. I also made a small project on stock trade analysis and used Postman to test the API

Worked extensively on the company's different APIs such as facial recognition, voice recognition Text APIs. Worked on the Permissions and Token generation for these. Used the software SoapUI for executing all assigned work on the APIs. Work on both REST and SOAP APIs