Dec 2023 – Jan 2025 · 1 yr 1 mo · Hybrid

• Developed frontend solution & APIs for the Seller Self-Service module, empowering around 25K sellers to independently address inventory exceptions directly on the platform, eliminating manual support intervention by 60%.
• Integrated Mixpanel, capturing 50K+ monthly events , to provide insights into user behavior and drive data-driven improvements, boosting seller engagement by 15%.
• Resolved previously unidentified anomalies and optimized existing SQL queries resulting in a massive 70% reduction in query response time.
• Improved user experience by redesigning flag placement and integrating interactive popups, offering sellers concise summaries of inventory issues and recommended actions for resolving inventory problems.
• Collaborated with design team to integrate UI into scalable web applications, boosting user satisfaction score by 20%.
• Maintained code quality through rigorous testing and debugging, reducing bug rate by 15%.
• Took proactive steps to enhance 1-D barcode scanning within the team, integrating QR code capabilities. Collaborated with cross-functional teams to streamline Fulfillment Center operations.
• Led implementation of multi-value field scanning, significantly reducing manual efforts and expediting operations within the Fulfillment Centers.
• Demonstrated adaptability by learning Android development to deliver required features in the absence of available bandwidth from another team.

Nov 2021 – Dec 2023 · 2 yrs 1 mo · Hybrid

• Developed an advanced filtering feature using React-admin for effective data analysis through multiple criteria including date, id and location, which resulted in 20% decrease in data search time.
• Enhanced application performance by implementing an Excel file upload feature, leading to a 90% reduction in data entry time from 1 minute to 10 seconds per entry.
• Implemented a robust bulk delete feature, capable of efficiently removing 10000 data entries in less than 1 minute.
• Resolved critical import/export errors by applying regular expression validation on columns, improving data exchange rate between front end, NestJS back end, and PostgreSQL DB by 50%.
• Designed and developed RESTful APIs using NestJS, enabling seamless communication.
• Created new database schemas and SQL queries for PostgreSQL, while optimizing the existing ones.
• Designed and implemented an API-driven audit trail system to detect and log all user-initiated data alterations made in any table across the application. It captures modification details in respective table, including user identities, enabling change tracking, unauthorized modification detection, and regulatory compliance.
• Utilized GIT for version control, ensuring efficient code management and collaboration.
• Engaged in architectural discussions, technical decision-making, code reviews & collaborated with cross-functional teams to define project requirements, milestones and to resolve complex technical issues ensuring seamless project delivery.
• Mentored peer and junior developers, sharing best practices, providing and receiving constructive feedback to improve code quality and fostering a culture of continuous learning

Sep 2021 – Oct 2021 · 1 mo · Hybrid

• Developed and implemented Spark code to load data into an information product for organizational insights and strategic goal achievement.
• Proficiently handled large datasets by performing ingestion, storage, processing, and analysis.
• Reconciled Power BI and Reporting Services (SSRS) reports on monthly basis for 4 parallel projects using various data systems.
• Discovered and resolved previously unidentified anomalies, optimized existing SQL queries which reduced query response time by 70%.
• Migrated internal SSRS reports from SQL Server to Hive Presto & Trino.
• Oversaw license decommissioning for legacy software in GTS team.
• Designed and implemented a React and Node application to efficiently extract large volumes of data from a Data Lake, effectively reducing SSRS rendering time.

Jan 2021 – Jul 2021 · 6 mos · Hyderabad, Telangana, India

• Responsible for delivering applications that involve Working with Microsoft BI tools and SQL server.
• Processed data cubes using SSAS for visualisation of data in BIReports.
• Derived data using ADF and SSIS after modification using components.
• Worked extensively on writing SQL stored procedures for dimensions and facts.

Aug 2019 – Aug 2019 · 0 mo · Jharkhand, India

• Comprehensive training using Raspberry Pi.
• Working code for smart connected devices.
• Cloud Computing Environment (AWS).
• Sponsored by TEQIP lll Standard.

May 2019 – Jun 2019 · 1 mo · Greater Delhi Area

• Developed an embedded Laser User Interface using PyQt .
• application helps in maintaining effective border control and border security.
• Earned “Letter of Recommendation” from DRDO during the summer internship in 2019.