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.

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. AWS Certified Cloud Practitioner, AWS

    May 2025View

  2. SQL (Advanced) Certification, HackerRank

    Mar 2025View

  3. SQL (Intermediate) Certification, HackerRank

    Mar 2025View

  4. SQL (Basic) Certification, HackerRank

    Mar 2025View

Tech Stack

  1. Database Technologies: PostgreSQL, MongoDB
  2. Cloud Technologies: AWS, Azure, GCP
  3. Programming: Node.Js, Express.Js, Shell scripting
  4. ETL: Pentaho, Apache Hop, CRON
  5. DevOps: Gitlab CI/CD, Docker*
  6. Server Management: Linux, Nginx, Tomcat
  7. Project Management: Agile, OpenProject

Skill Badges

  • AWS Certified Cloud Practitioner
  • CRUD Operations in Mongo
  • Aggregation Fundamentals in Mongo
  • Query Optimization Techniques in Mongo
  • Vector Search Fundamentals in Mongo
  • RAG with Mongo

Portfolio

  • finance

    Test

    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