LEELAMBAR THAPA

Jaipur

Summary

Skilled software engineer with over 4 years of experience in Application Support and Oracle Database Development. Demonstrated success in supporting production environments and optimizing SQL queries for government applications, ensuring efficient service delivery. Expertise in client interaction and resolving production issues while providing reliable database solutions.

Overview

years of professional experience

Work History

Software Engineer

Trigyn Technologies Pvt. Ltd.

JAIPUR

07.2022 - Current

Managing the Application, Utility, and Finance modules of the e-Mitra platform.
Creating and maintaining database objects, including procedures, packages, triggers, views, and scheduler jobs.
Writing optimized SQL queries and reports for various government departments.
Database performance tuning and ensuring production stability.
Client interaction for requirement clarification, issue resolution, and status updates.
Preparing functional and technical documentation, and supporting deployments.

Sr. Executive, IT Desk

Vayam Info Solutions Pvt. Ltd.

Jaipur

09.2018 - 06.2022

Managed incident response and escalated issues to ensure swift resolution.
Delivered user support through effective communication and troubleshooting techniques.
Conducted reporting and metrics analysis to track performance indicators.
Administered IT asset management to optimize resource utilization.
Provided application and database support for e-Mitra services using SQL and PL/SQL.
Coordinated with development teams to resolve production incidents promptly.

Education

Bachelor of Computer Applications -

University Commerce College

JAIPUR

07-2015

Skills

Oracle Database: PL/SQL and SQL
PostgreSQL: SQL querying, database objects, and performance-aware query design
Database Objects: Procedures, packages, triggers, views, tables, indexes, constraints
Job Automation: DBMS_SCHEDULER and DBMS_JOB
Performance Tuning: Query optimization and index strategy (Oracle & PostgreSQL)

Data Utilities: Data Pump and SQL*Loader
Tools: TOAD and Oracle SQL Developer
Application Support: Production support and incident management
Domain Experience: Government e-Governance systems
Power BI: Dashboard creation and reporting using SQL/Oracle data sources

Accomplishments

ACE TRIGYN’ITE OF THE QUARTER, Q2 2024-2025

Timeline