Amaldass Suvi

Results-driven SQL & PL/SQL Developer with 7+ years of experience in Oracle database application development, performance optimization, and production support. Expert in designing stored procedures, packages, triggers, and collections. Proven track record of delivering performance gains through EXPLAIN PLAN, AUTOTRACE, and advanced indexing. Adept at translating business requirements into scalable database solutions and building impactful Power BI dashboards for data-driven decision-making.

Assistant Manager at ARMSOFT TECH.AIR (2025-09 – 2026-03)

• Led a team to ensure smooth execution of daily operations and timely delivery of business requirements.
• Developed complex SQL queries for data analysis, reporting, and validation of financial transaction data.
• Designed Power BI dashboards to visualize key business metrics, enabling data-driven decisions.
• Reviewed customer payment transactions to identify discrepancies and provide accurate resolution.
• Maintained CRM systems with transaction details, customer interactions, and status tracking.
• Ensured data integrity, compliance, and accuracy while handling sensitive financial records.

Team Leader – PL/SQL Developer at NOVAC Technologies Solution Pvt. Ltd. (2022-05 – 2025-09)

• Designed and developed PL/SQL procedures, functions, packages, and triggers for complex business logic.
• Performed query performance tuning using EXPLAIN PLAN, AUTOTRACE, and SQL hints for large datasets.
• Implemented exception handling and advanced features including collections and PRAGMA AUTONOMOUS_TRANSACTION.
• Used SQL*Loader for efficient bulk data loading and cross-system data migration.
• Built and maintained Power BI dashboards to visualize KPIs and support strategic decisions.
• Ensured database security through user roles, permissions management, and best practices.
• Handled production support tasks including debugging, issue resolution, and backend fixes.

Team Leader – Oracle Developer at ARMSOFTECH Pvt. Ltd. (2019-01 – 2022-05)

• Developed Oracle SQL & PL/SQL programs including stored procedures, functions, packages, and triggers.
• Contributed to the FX Trading project for Fifth Third Bank — backend development and DB optimization.
• Translated trading business logic into efficient SQL queries supporting real-time financial operations.
• Designed and modified database schemas: tables, views, indexes, constraints, sequences, and synonyms.
• Enhanced system performance by analyzing execution plans with AUTOTRACE and EXPLAIN PLAN.
• Performed unit testing, debugging, and documentation for maintainable, production-grade code.

Bachelor of Engineering in Mechanical Engineering – Velalar College of Engineering and Technology (2018)

HSC – Higher Secondary Certificate – Sri Venkateswara Matric Hr. Sec. School (2014)