Project Portfolio

Projects

MontyCloud
Role: Senior Data Engineer
Tech Stack : Python,SQL,Lambda, Treasure Data , CDP,Digdag,
dbt,Pandas,PyCharm,Docker,WebSockets, AWS ,S3, EC2, CloudWatch, Lambda, SNS, SQS, REST APIs
Description:
MontyCloud is a cloud-native platform that delivers scalable, event-driven solutions using AWS
services. It utilizes the MERN stack to develop high-performance, full-stack applications while
integrating real-time features and serverless computing. The platform is designed for efficient data
processing and analytics, making it suitable for large-scale cloud workloads and enterprise-level
systems.
Responsibility
● Develop and maintain scalable, event-driven solutions using AWS services.
● Design and implement high-performance, full-stack applications with the MERN stack.
● Integrate real-time features and serverless computing for enhanced performance.

● Ensure efficient data processing and analytics for large-scale cloud workloads.

● Collaborate with cross-functional teams to optimize platform functionality.
● Implement best practices for cloud security, data governance, and compliance.
● Troubleshoot and resolve issues to ensure platform reliability and scalability.

Swim-Time
Role: Senior Data Engineer
Tech Stack: Python,Lambda,SQL, Digdag,CDP, dbt,Treasure Data,AWS, Django,
DynamoDB, Pycharm, Git, Slack,
Jira, Cron job, Apache Airflow, Docker, PySpark
Description: This project is responsible for booking your class for swimming. This project helps
you to book class comfortably for swimming. You need to book your class with a suitable
instructor from which you want to learn swimming. For that, you need to make payment via cash
or card on the platform you need to choose the options and make at least the % of the amount
that the instructor set. You can also book a class as a complete course and you can book a class
for individual days also on the days only on which the instructor is available. Instructors can also
add break time on different days.
Responsibility

● Developed and maintained data pipelines for managing class bookings and instructor schedules.
● Implemented Airflow-based workflows to automate booking validation and payment processing.
● Designed and optimized a DynamoDB database for efficient storage and retrieval of class
schedules.
● Created ETL pipelines using PySpark for data analytics and reporting on user engagement.
● Integrated Dockerized microservices for seamless deployment and scaling.
● Ensured secure payment processing through robust data encryption and AWS best practices.

● Makaan
Role: Senior Data Engineer
Tech Stack: Python, Flask, Lambda, SQL ,CDP,Shell Scripts, PostgreSQL, Pycharm,
postman, redis,

Celery, Apache, Treasure Data,Celery, Redis, Third party API Airflow,
Docker
Description: This project is responsible for booking the property according to your comfort and
at your suitable location. In this project, you can buy property you can sell out the property, and
rent as well. Here we have two sections in this project one for booking and selling, and the other
one is for investment if a user wants to invest some amount he can do that very easily, and
according to his investment, we will provide them the profit and all things on the portal.
Responsibility

● Built and optimized PostgreSQL-based data models for property listings, transactions, and
investments.
● Developed ETL workflows using Airflow to process and transform real estate data.
● Integrated Redis and Celery for background job processing and real-time property availability
updates.
● Created Shell scripts for automating data extraction and loading from third-party APIs.
● Deployed and maintained the application using Docker, ensuring high availability and scalability.
● Designed data validation and fraud detection mechanisms for secure transactions.

● Betrics.io
Role: Data Engineer
Languages: Python,Digdag,SQL,Django,CDP, PostgreSQL, Pycharm, PgAdmin, Slack,
Zoom,
Jira, Docker, PySpark, S3, SNS, SQS, SonarQube, Celery, Redis
Description: Developed a dynamic and responsive betting website catering to NFL and NBA
matches. Ensured minimal delays to offer users the best prices, providing a seamless experience
for placing bets without any interruptions.
Responsibility

● Developed data pipelines using PySpark to process real-time betting data.
● Implemented Django Rest Framework (DRF) APIs for managing betting odds and user
transactions.

● Utilized AWS S3 for data storage, with SQS and SNS for event-driven notifications.
● Deployed Celery and Redis for handling background tasks like bet validation and user
notifications.
● Integrated SonarQube for code quality analysis and performance optimization.
● Automated cron jobs for periodic updates and data cleanups.

● Dashible
Role: Data Engineer
Languages: Python,Digdag,Lamda,Treasure Data,CDP, FastAPI, MongoDB, Pycharm,
VScode, Slack,
ES, Jira,Apache Airflow, Shell Scripts, OpenStack, Bit Bucket CI, Zappa
Description: This is an application that functions like a GPT. Users can inquire about anything
related to the business, and the system provides answers based on embeddings created from
scraped pages. Users can select a location and view all nearby businesses to gather the
information they need.
Responsibility

● Built FastAPI-based microservices for real-time business searches.
● Designed MongoDB schemas for storing business embeddings and metadata.
● Developed Airflow DAGs to automate data scraping and indexing processes.
● Integrated Elasticsearch for high-speed querying and full-text search capabilities.
● Utilized Bitbucket CI/CD pipelines for continuous integration and deployment.
● Implemented serverless deployment using Zappa on AWS Lambda.

● Linework
Role: Data Engineer
Tech Stack: Kubernetes, Treasure Data,Aws, Docker, GitLab, Restful API, Aws
glue,Lambda, Cloudwatch,Python,Apache Airflow, Pyspark, MySQL,
GraphQL.

Description: Linework is a versatile app that acts as a one-stop solution for various needs. It
functions as a marketplace for products, services, and art, along with offering social networking and
crypto-based banking features. The application is divided into three main components: E-commerce,
Social Media, and Web3. In essence, Linework aims to simplify and connect various aspects of daily

life in a single, user-friendly platform.
Responsibility
● Developed and optimized PySpark data pipelines for handling high-volume transactions.
● Designed GraphQL APIs to provide seamless data access across multiple services.
● Implemented AWS Glue ETL jobs for processing and transforming large datasets.
● Set up Kubernetes-based container orchestration for scalable service deployment.
● Monitored system performance using AWS CloudWatch and implemented alerts for data
anomalies.

Skill Set

• Aws
• Azure
• Data Engineer
• ETL
• Graphql
• Kubenretes

Project Portfolio

Skill Set

• Developer Console

Project Portfolio

Project: OneIS Datahub, India | July 2022 – Present
Role: Azure Data Engineer & Power BI Developer

Sensitivit
y
L
a
b
e
l
:
G
e
n
e
r
a
l

This project is about providing a cloud voice platform to provide Audio and Video conferencing services to their
clients, here we used ADF to migrate the data from On-Premises and Azure Databases and Power BI to
generate reports and dashboards for visualization.
Responsibilities:
• Worked with International Clients to gather Architectural Changes needed to be made in project from the
business perspective.
• Performed Data Profiling and Data Analysis on source data prior to development of each ETL pipeline.
• Implemented various Performance Improvement and Optimization strategies to promote continuous
improvement in project.
• Reduce Project Cost to 40% by reducing databases from 6 to 3.
• Developed Complete ETL pipelines from Data Mining (extraction from multiple sources), Data
Transformation to loading data into Datahub (Data Warehouse) using Azure Data Factory and Visual Studio
(SQL) with Unit Testing and Documentation.
• Created fully dynamic ADF architecture for loading data (i.e. Full Load & Incremental Load) from multiple
sources like SQL DBs (both Azure and On-Premises), Files (Excel, CSV, text etc.), JSON Rest APIs etc.
• Created On-Premises Integration Runtime and performed successful integration of On-Premises DB to load
data.
• Created complex Stored Procedures, queries based on ETL requirements.
• Created Azure Logic APP to SFTP Files from ADLS to SharePoint.
• Created Data Lineage Process to track Data Flows between different systems.
• Used Azure Data Lake/Blob Storage to load incoming source files for further transformation and ingestion.
• Performed SQL and ADF optimization to boost data load performance.
• Designed and developed interactive Reports & Dashboards using Power BI.
• Formulated data using DAX and Power Query as per the client and data requirement.
• Gathered data from various data sources using different connections in Power BI
• Implemented RLS (Row Level Security), OLS (Object Level Security) & CLS (Column Level Security) as per the
user’s access privileges and achieved abstraction.
• Installed and Configured Power BI Gateways to keep the dashboards and reports up to date by scheduling
the Refresh.
• Integrated Power BI with ADF to automate Scheduled Refresh of Dataset, Dataflow and Linked Dataflow at
regular periods to achieve data consistency.
• Created custom visuals and analysed data using varied visualizations like Stacked Bar Chart, Donut Chart,
Line and Clustered Column Chart, Pie Chart, Word Cloud Chart.
• Automated Dataflow backup to ADLS (Azure Data Lake Storage) using ADF and Power BI Cmdlet’s & Rest
API.

Project 1: Sandvik, India | Feb 2017 – Dec 2022
Role: Data Engineer - Advanced Analytics
This project is about providing growth driven insight with respect to mining industry, here we use IBM
product Maximo Asset Monitor tool to generate the KPI.
Responsibilities:

Sensitivit
y
L
a
b
e
l
:
G
e
n
e
r
a
l

• Performed data analysis, data wrangling of raw sensor data from IBM Watson IoT and created data
pipeline using Python (Pandas and NumPy libraries) & IBM Maximo Asset Monitor to develop over 200
KPIs.
• Build complex SQL queries to display the generated KPI's on the dashboard varying with the time
frequency.
• Build AMS Tool for application monitoring using Python, Jira and Pager Duty.
• Data Pipeline created using Python in integration with Microsoft Azure Blob Storage to store the data to
DB2.
• Optimize complex Queries to increase performance of dashboard.
• Created Node JS/Express JS script to read the data from Azure service bus, stores data to AWS S3 bucket
and back to Database.
• Stored Procedures and Triggers created in DB2 database.
Project 2: Lumen, India | Oct 2021 – June 2022
Role: Database Developer
This project is basically migration project i.e. migrate oracle database to Microsoft SQL and migrate dot net
framework to dot net core application and deploy it on the OpenShift.
Responsibilities:
• Engaged in Database Migration from oracle to Microsoft SQL using tool SSMA, and few object that are not
handled while migration are captured and migrated manually.
• Data Pipeline created using tool SSIS for data copying between the servers.
• Data Pipelines created using ADF for data copying from files to Azure SQL DB.
Organization: Wipro
Project: Telenor Communication (Campaign), India | Oct 2014 – Feb 2017
Role: Software Engineer
Project is about to manage the life cycle of a campaign, starting from campaign definition, target list
generation, to execution via multiple communication channels, along with the ability to assess the effectiveness of
a campaign based on responses received.
Responsibilities:
• Management and enhancement of the (in-house product) Campaign management system.
• Managing the team to ensure maximum availability.
• Worked under tight schedules for successful development and implementation.
• Analysing Requirements and convert requirements into technical software solution.
• Resolving issues during the test cycles.

Skill Set

• Aws
• Azure
• Azure Portal

Project Portfolio

Hyderabad, India Jul 2022 to
Current
Accumulated three years of Playwright Automation experience using JavaScript.
Acquired two years of WebDriver IO Automation experience with Selenium and
Cypress.
Executed manual and automation testing across various platforms including
web and APIs.
Created and executed automation scripts utilizing JavaScript, Selenium,
WebDriver IO, JSON, and XML.
Led offshore team of four while managing client communications as onsite lead.
Trained 20 resources in transitioning from manual to automation testing.
Generated QA certificates for each release and prepared comprehensive project
status reports.
Analyzed test results, documented defects thoroughly, and tracked resolutions
efficiently.
Senior Analyst
Hyderabad, India
Confidential/ Apr 2019 to Jul 2022

Conducted requirement analysis to inform test design and execution strategies.
Developed test cases utilizing Selenium with Java for automated testing.
Prepared test data and executed tests to ensure software quality.
Logged defects in JIRA to facilitate tracking and resolution.
Acquired two years of WebDriver IO Automation experience with Selenium and
Cypress.

Skill Set

• Azure
• Extensible Markup Language (XML)
• JavaScript

Project Portfolio

Hyderabad, India Jul 2022 to
Current
Accumulated three years of Playwright Automation experience using JavaScript.
Acquired two years of WebDriver IO Automation experience with Selenium and
Cypress.
Executed manual and automation testing across various platforms including
web and APIs.
Created and executed automation scripts utilizing JavaScript, Selenium,
WebDriver IO, JSON, and XML.
Led offshore team of four while managing client communications as onsite lead.
Trained 20 resources in transitioning from manual to automation testing.
Generated QA certificates for each release and prepared comprehensive project
status reports.
Analyzed test results, documented defects thoroughly, and tracked resolutions
efficiently.
Senior Analyst
Hyderabad, India
Confidential/ Apr 2019 to Jul 2022

Conducted requirement analysis to inform test design and execution strategies.
Developed test cases utilizing Selenium with Java for automated testing.
Prepared test data and executed tests to ensure software quality.
Logged defects in JIRA to facilitate tracking and resolution.
Acquired two years of WebDriver IO Automation experience with Selenium and
Cypress.

Skill Set

• Automation
• QA

Project Portfolio

Role Automation Practice Lead and PM/BA
Responsibility  Helping Automation Framework designed in Playwright
 Writing Automation scripts for the sprint work done so far
 Creating Components used in Automation Testing
 Gathering requirements
 Updating Status
 Handling DSU (daily stand ups)
 Handling other scrum ceremonies

Project Brief Web solution developed to configure and pay tax returns for US and

Canada Jurisdictions.

Dormakaba
Domain Retail/E-commerce ( Security systems developed for schools and colleges)
Technology Java and Selenium Web driver
Role Automation Engineer and PM/BA
Responsibility  Automating the tech debt

 Resolving the Production Cycle issues for automated tests
 Automating new functionalities
 Automated new product configurations coming in from sales force
 Validating new feature updates on Website
 Handling Client calls
 Gathering requirements
 Story write ups

Project Brief Automated End-to-End flow right from product search to product in the
card and payment with dummy credit card. All the flows included like
removing the product increasing quantity and checking the amount
increased etc.

Online Medicines Sales
Domain Retail/E-commerce (Medicines sales online)
Technology Java and Selenium Web driver

Role Automation Engineer
Responsibility  Automating current sprint user stories

 Automated the work flow right from account creation till medicine
is ordered
 Add to the cart etc.

Project Brief Sell Generics medicines online based on the geographical regions and

connecting to nearby vendor. This was a startup.

Shipping Module System
Domain Logistics
Technology C# , Selenium Web Driver
Role Automation Engineer
Responsibility  Leading Automation efforts

 Creating Automation Frameworks used C# with Specflow Nunit
 Estimating Automation efforts
 Working on Mobile Automation Framework
 Automating Mobile App Regression Suite
Project Brief Project developed to manage the cargo space at ports

Live Advertising Bidding system
Domain Media and advertising
Technology C#, Selenium web driver
Role Automation Engineer
Responsibility  Automation and manual testing

 Leading Automation Efforts for application under test
 Helped Developing Automation framework using Selenium
 Collaborating between onshore and offshore team
 Attending all scrum ceremonies
 Working on task assignment and team velocity

Project Brief Live bidding system to place an advertisement on the space available on

different web sites and papers.

Financial Data Analysis
Domain Finance
Technology C#, Selenium, Python
Role

Senior Quality Engineer

Responsibility  Testing Web based solutions
 Testing using Selenium and C#
 Testing using Python (PyWinAuto,pytest-bdd,pyautogui)

Project Brief

Web solution showing the details and financial fact sheets for all the listed
companies in NYSE

Online Doctor Appointment Mobile Application
Domain Healthcare
Technology C# , Appium Web Driver
Role Automation Engineer
Responsibility  Help in developing automation framework using C# and Specflow

and Appium
 Automating Regression Suite cases
 Automating current sprint tasks

Project Brief Mobile app developed to book the doctors’ appointments in particular
hospitals those have taken the subscription for the application and system.

SMART Healthcare System
Domain Healthcare
Technology C#, Selenium
Role

Quality Analyst

Responsibilit
y

 Getting enhancements or changes on web pages in form of user
stories.
 Estimating QA efforts for PRBs and User Stories.
 Working on user stories manual and automation testing.

Project Brief SMART system was developed to record patients data right from he entered
in hospital till discharge. It was having all the modules like payment
processing and electronic claim generation.

Skill Set

• Automation
• Automation Tester
• QA

Project Portfolio

Skill Set

• React Native

Project Portfolio

Skill Set

• ServiceNow

Project Portfolio

Skill Set

• SFDC toolkit

Project Portfolio

Skill Set

• FourGen Computer-Aided Software Engineering (CASE) Tools