About me

I'm a Technical Project Lead and Sr. Database Engineer with 6 years of professional experience architecting enterprise-grade relational database systems. My expertise in PostgreSQL administration, advanced PL/pgSQL programming, and proficiency in troubleshooting technical issues related to distributed computing systems set me apart.

I'm equally skilled in developing web-based Enterprise applications using Node.js, Express.js, PostgreSQL, and MongoDB, with hands-on experience in database provisioning, schema design, query optimization, and ETL processes. I have a proven track record of implementing scalable solutions for efficient database and application performance, with an emphasis on clean code.

My Strengths

  • Web development icon

    Database Administration

    Specialize in the development and optimization of complex SQL queries, indexing strategies, and data partitioning techniques. Also skilled in troubleshooting database-related issues, ensuring availability, security and optimal performance.

  • Web development icon

    Web development

    Proficient in backend development leveraging Node.Js and Express.Js to create RESTful APIs for robust HRIS web solutions. Well-versed with authorization and authentication protocols (SAML, OAuth2.0), and SDLC framework.

Daniel lewis
quote icon

Daniel lewis

Richard was hired to create a corporate identity. We were very pleased with the work done. She has a lot of experience and is very concerned about the needs of client. Lorem ipsum dolor sit amet, ullamcous cididt consectetur adipiscing elit, seds do et eiusmod tempor incididunt ut laborels dolore magnarels alia.

Resume

Education

  1. St. Xavier's College (Autonomous), Kolkata, IN

    Jul 2017 — Jun 2019

    M.Sc. in Computer Science - 7.18 CGPA [First Class]

  2. Vidyasagar College (Calcutta University), Kolkata, IN

    Jul 2014 - Jun 2017

    B.Sc. in Computer Science - 63.75% [Hons. First Class]

Experience

  1. Apprentice Leader

    Mu Sigma Inc.

    Dec 2022 — Present
    • Organize daily Scrum meetings with teams and weekly business reviews with stakeholders to ensure project alignment.
    • Oversee the productivity and effectiveness of a 10-member development team, assigning tasks, setting deadlines, and monitoring progress.
    • Designed multiple data marts from a financial data warehouse to support the Business Rule Engine of an SoW and Invoice app. The query performance was boosted by a factor of 75%, bringing down ETL pipeline execution time by 40%.
    • Migrated 500GB+ of legacy HRIS data from MSSQL to a combined solution of Postgres DW for structured data and MongoDB DMS for blobs.
    • Architected database solutions based on business needs, keeping enough room to support future growth while minimizing downtime and maintenance.
    • Developed ETL pipelines for seamless data synchronization across platforms and third-party hosts, ensuring real-time data availability. Implemented triggers for data manipulation and refreshing materialized views.
    • Optimized complex SQL queries and stored procedures through indexing strategies, and data partitioning techniques, enhancing user experience and operational efficiency.
    • Addressed security vulnerabilities and took part in security audits, reducing data breach risk by up to 50%.

  2. Trainee Decision Scientist

    Mu Sigma Inc.

    Nov 2019 - Nov 2022
    • Addressed challenges related to database and ensured scalable solutions without the need for future intervention.
    • Implemented database replication and clustering strategies to ensure high availability up to 99.5%.
    • Ensured data consistency by applying best practices related to normalization and constraints.
    • Streamlined reporting and analytics processes using advanced SQL techniques and automated pipelines.
    • Developed RESTful APIs for seamless backend integration across multiple modules.
    • Configured Nginx and Tomcat servers for application deployment in Linux environments.
    • Administered version and release control via GitLab, ensuring structured code management.

  3. Consultant

    Nielsen India Pvt. Ltd.

    Apr 2019 - Oct 2019
    • Conducted detailed data analyses for government programs, delivering actionable insights to drive improvements.
    • Automated data processing workflows using Excel VBA, reducing manual intervention and errors.
    • Prepared comprehensive assessment reports with data visualizations for stakeholder decision-making.

Certifications

  1. SQL (Advanced) Certification, HackerRank

    Mar 2025View

  2. SQL (Intermediate) Certification, HackerRank

    Mar 2025View

  3. SQL (Basic) Certification, HackerRank

    Mar 2025View

Tech Stack

  1. C/C++, Python and Java
  2. MySQL and Machine Learning
  3. AWS and HTML/CSS
  4. React and Node JS
  5. TensorFlow
  6. Linux and Windows
  • JavaScript

    JavaScript

  • Node JS

    Node JS

  • MySQL

    MySQL

  • React

    React

  • AWS

    AWS

  • Python

    Python

  • Jupyter

    Jupyter

  • Tensorflow

    Tensorflow

  • Linux

    Linux

  • HTML/CSS

    HTML/CSS

My skills

  • Web Dev
    80%
  • Machine Learning
    80%
  • Designing
    90%
  • Computer Vision
    70%

Portfolio

  • finance

    Adhyayan

    Web development

    Gamified learning website for kids and site contains UNITY games for development of children and having fun while learning.

    • React and Node Js
    • Express.js Server
    • Bootstrap and UNITY
    • MongoDB

    Live Github
  • HandSign-Detection

    HandSign-Detection

    Computer Vision

    Hand Sign Language Recognition (SLR) is a computational task that involves recognizing actions from hand sign languages.

    • OpenCV and Tensorflow
    • CV Zone and Mediapipe
    • Model Training
    • Teachable Machine web

    Github
  • customer-segmentation

    Starbucks Customer Segmentation

    Machine Learning

    Segmentation to make better use of marketing budgets, gain a competitive advantage over competitors.

    • Tensorflow (keras)
    • NumPy and Seaborn
    • Matplotlib and flask

    Github
  • react-state-scripts

    SCANNY Multi-Purpose OCR APP

    Machine Learning

    It is a multi-purpose OCR Scanner android app, it extract the text as output from any given image, PDF, captcha and number plate of a vehicle.

    • Java and Flutter
    • Machine Learning
    • Firebase

    Github
  • Phishing-Website Detection

    Phishing-Website Detection

    Machine Learning

    The objective of this project is to train machine learning models and deep neural nets on the dataset created to predict phishing websites.

    • ML Algorithms
    • Python libraries
    • Jupyter

    Github
  • JobHunt

    JobHunt

    Applications

    A React Native Application that helps you find your dream job, built using Expo, React Native and Rapid Api.

    • React Native
    • Rapid Api
    • Expo
    • Metro

    Live Github