Lead Software Developer - Accenture Solutions Pvt Ltd. - Mumbai
(2022-03)
Supported enterprise-wide banking operations within the financial services domain. Maintained and enhanced approximately 15 web-based applications and Windows services. Enabled critical business processes including monthly payments, hiring workflows, year-end activities, and reporting. Focused on application lifecycle management, system integration, and performance optimization. Ensured high availability, scalability, security compliance, and operational stability for enterprise systems.
- Led Application Architecture backend database design, development, and optimization to support data-intensive enterprise applications and integration workflows.
- Architected and led enterprise-scale PostgreSQL database platforms, defining logical and physical data architectures aligned with business and application requirements.
- Designed and implemented high-performance, scalable, and resilient database architectures, supporting mission-critical applications with strict availability and performance SLAs.
- Developed advanced PL/PGSQL stored procedures, triggers, functions, and batch processes, enabling application enhancements and enforcing data integrity at the database layer.
- Defined and governed database design standards, naming conventions, coding guidelines, and formal code review frameworks to ensure consistency, security, and long-term maintainability.
- Led query optimization and performance engineering initiatives, including execution plan analysis, index strategy design, partitioning, and schema refactoring to significantly improve application performance.
- Object verification of Oracle to PostgreSQL migration programs which is done through informatica tool where covering of all database objects and post migration optimization.
- Acted as an escalation point for production issues, performing deep root-cause analysis and delivering architectural recommendations to prevent recurrence.
- Partnered with application, cloud, and infrastructure teams to ensure database scalability, fault tolerance, disaster recovery, and security compliance.
- Embraced innovative technologies and methodologies to create scalable applications, driving cost efficiency and performance.
- Provided instruction and mentorship to team members on new tech stacks and application development best practices.
- Led by example, demonstrating professionalism and dedication while fostering a collaborative team environment.
- Assisted team members in overcoming challenges and encouraged critical thinking and creative solutions.
Sr. Software Developer - SA technology Limited. - Mumbai
(2021-11 - 2022-03)
The objective of the Learning Mate project is to design and deliver a robust, scalable reporting solution for end clients within the education domain. The system is intended to provide accurate, data-driven insights through dynamic and customizable reports, enabling stakeholders to make informed academic and operational decisions. The project focuses on integrating a .NET-based user interface with a PostgreSQL backend to support efficient data retrieval, report generation, and performance optimization.
Emphasis is placed on data accuracy, system responsiveness, and seamless integration between application layers, while ensuring the solution is maintainable, extensible, and capable of handling growing data volumes and reporting requirements.
- Designed and implemented end-to-end reporting solutions using iReport, delivering 20+ business-critical reports used by academic and operational teams.
- Developed and improved usability and reducing user-reported issues by 30%.
- Created and optimized complex SQL queries in PostgreSQL, reducing report execution time by 40–50% through query tuning and indexing strategies.
- Collaborated with application teams to ensure seamless database integration, resulting in zero data inconsistency issues post-deployment.
- Performed database and application performance tuning, improving overall system responsiveness and report generation efficiency.
- Utilized DBeaver for query analysis, data validation, and troubleshooting, accelerating development and debugging cycles by 25%.
- Resolved production issues through root cause analysis, reducing recurring defects by 35%.
- Supported ongoing application enhancements, enabling faster turnaround for new reporting requirements and feature updates.
- Ensured adherence to coding standards and best practices, contributing to improved system stability and maintainability.
- Actively participated in requirement discussions and technical design reviews, translating business needs into effective technical solutions.
Software Developer - Multiline Business Solutions Pvt Ltd. - Mumbai
(2015-02 - 2021-11)
The objective of this project was to develop and support a reliable, data-driven logistics solution for multiple end clients, including Vision Care, Galderma, Finance, Synthes, and Vetina. The system was designed to streamline logistics operations, improve data accuracy, and enable timely reporting for operational and business decision-making. The solution focused on leveraging PostgreSQL to manage logistics data efficiently, automate reporting processes, and ensure high system availability.
Emphasis was placed on database reliability, performance optimization, and minimizing manual intervention through scheduled reporting, while providing stable production support for mission-critical logistics operations.
- Developed and maintained SQL scripts, complex queries, and PostgreSQL stored procedures to support logistics workflows and reporting requirements.
- Implemented database maintenance activities including data cleanup, performance monitoring, and optimization, improving overall database stability by 25%.
- Supported production database operations, diagnosing and resolving data-related issues, resulting in a 30% reduction in production incidents.
- Optimized SQL queries and stored procedures, reducing report generation and data retrieval time by 35–45%.
- Designed and managed automated report scheduling, eliminating manual reporting efforts and reducing operational workload by 40%.
- Collaborated with application and operations teams to ensure accurate data flow across logistics modules and reporting systems.
- Performed root cause analysis for recurring issues and implemented long-term fixes to improve system reliability.
- Ensured adherence to database development best practices, contributing to improved maintainability and performance of logistics applications.
- Assisted in application enhancements by refining database logic to support new logistics and reporting requirements.