Nilap

1.           Software Projects:

Title

HSBC Bank (Vault) - Synechron

Technology Used

MongoDB, Shell Script, Opsmanager, solace, control-m

Description

This project contains trade data for HSBC all over the world. It includes Mutual Fund, Equities, Debt Scheme Trading, Forex Trading and Many more

Members

20

Role & Contribution

(MongoDB DBA)

-Installation, Configure, Maintenance of MongoDB Infrastructure with 10 Shards (Replication and Shading)

-Configuring Monitoring Alerts

-User management for MongoDB Servers

-Index Management & maintenance

-Responsible 24 * 7 Support

-It includes Introduction, CRUD, Advanced Queries, Aggregation, Indexes

-Creating collection, Automate Purging and Decide backup strategy

Duration

Nov-20 – Dec-21

Title

SQL Server to MongoDB Migration Product (Australia) - Freelacer

Technology Used

Core Java, Maven, Multi-threading, Quartz, MongoDB Atlas, Cloud Manager, Shell Script, SQL Server, SSIS

Description

Designed & developed SQL to MongoDB Migration Product for Australia based company. This very dynamic product which can migrate SQL to MongoDB by just adding some mapping into XML. This product includes straight table migration, joining two tables to produce sub document, Array of sub documents, creating indexes & it also includes syncing feature as well.

Members

3

Role & Contribution

(MongoDB Expert – Data Scientist)

-Write Dynamic Migration Script Using JAVA + Multi-threading + Maven

-Responsible for Deployment for migration

-There are different builds developed onetime migration & syncing

-Responsible for client communication

-Responsible for Schema Design

-Responsible for Data for SQL & MongoDB & closely working with reporting team & Application team

-Rewarded for Most Innovative Employee for Migration

-Currently working for exception logging & resync those data while next migration

-SQL Server to SQL Server Migrationusing SSIS.

Duration

Apr 18 to Oct-20

Title

Nutri Shopping + MongoDB Trainer for DBA + Developer

Technology Used

MongoDB Atlas, Cloud Manager, Shell Script, Tableau Reports

Description

In this project, I was involved from the beginning. I am responsible for MongoDB related tasks for this project.

Members

10

Role & Contribution

(MongoDB Trainer / Team Lead)

-Installation, Configure, Maintenance of MongoDB Servers

-Used MongoDB BI connector with Tableau reporting

-Configuring Monitoring Alerts

-User management for MongoDB Servers

-Scripting to Automate unnecessary records from database

-Index Management & maintenance

-Responsible 24 * 7 Support

-I have performed MongoDB Training for all other DBA + Developers

-It includes Introduction, CRUD, Advanced Queries, Aggregation, Indexes, Schema Design, Replication, Shading, Profiling, Map Reduce

-Responsible for Backup & Recovery for MongoDB

-Creating Jobs, Scheduling & Maintenance of Jobs for SQL Server

-Responsible for User Management

Duration

July 17 to April-18