Surya Manikanta Dammu

Developed and maintained the Suspense Account Reconciliation System (SARS), a centralized platform for tracking suspense account transactions and generating audit reports. This system was integrated with various core banking systems to guarantee precise daily reconciliations and compliance-ready monthly reporting.

Key Responsibilities:

• Developed complex PL/SQL procedures to extract day-1 transactions and account balances from multiple cores banking systems, including FCC-HK, FCC-BH, Oracle, Finn one, and FC.
• Implemented reconciliation logic using system-based, manual, and reference ID-based matching techniques, ensuring accurate and auditable transaction alignment.
• Enforced access control mechanisms across branches and departments by applying data-level security rules and roles.
• Enabled partial transaction reconciliation and intra-quarter correction processes in compliance with business rules and audit requirements.
• Designed and integrated dashboards to display transaction reconciliation statuses (pending, approved, rejected) within Maker/Checker/Reviewer approval workflows.
• Integrated iSAC and IMAP systems for role-based access control, master data management, and governance compliance.
• Automated month-end reporting in INR using currency exchange rates sourced from FC-UBS, and connected provision workflows to support internal and external audits.
• Designed data validation rules for matching origin and reversal transactions; implemented automated email alerts for mismatched or failed data fetch events.
• Coordinated phased rollouts involving master data uploads, outstanding transaction migrations, and GL/vintage/provision-based stakeholder reporting.

Achievements:

• Increased reconciliation efficiency by 80% through automation of match logic and system-based validation.
• Reduced manual errors and rework by implementing controlled master data setups and stakeholder notification systems.
• Executed seamless migration from the legacy SAMSA reconciliation platform with zero data loss and no business disruptions.

Developed and maintained core PostgreSQL database solutions to support fire code enforcement, compliance tracking, and incident management systems for the State Fire Marshal’s office.

Key Responsibilities:

• Designed, implemented, and optimized PostgreSQL functions, stored procedures, and triggers to support real-time data operations.
• Ensured database performance, tuning, and availability for mission-critical fire safety compliance modules.
• Managed database security by implementing and monitoring role-based access control (RBAC).
• Created and maintained database objects such as tables, views, and indexes across development and test environments.
• Executed data transformation, migration, and normalization processes to support integration with external data sources and legacy systems.

Contributed to the digital transformation of HR operations at Union Bank of India by developing PL/SQL-based backend processes for automation, feedback systems, and leadership development tools.

Key Responsibilities:

• Developed PL/SQL procedures to support HR automation workflows and reporting requirements.
• Generated operational and leadership-related reports for HR stakeholders.
• Performed advanced query tuning to optimize database performance across HR modules.
• Collaborated with HR domain experts to design scalable data logic for employee lifecycle and feedback management systems.

Government Business Banking (GBB) – Yes Bank

Company: MindGate Solutions Pvt. Ltd. | Duration: February 2022 – December 2022

Role: Software Developer | Technology: Oracle 19c

Description:
Contributed to the development of a centralized banking platform for Yes Bank to manage government fund disbursements, budget tracking, and integration with public financial management systems.

Key Responsibilities:

• Designed and enhanced PL/SQL stored procedures, packages, functions, and database views to automate fund management and reporting processes.
• Created global temporary tables, materialized views, and custom constraints to optimize reporting workflows and reduce query time.
• Implemented robust exception handling mechanisms to ensure application stability and seamless transaction processing.
• Interacted with business users and stakeholders to gather functional requirements and supported production deployments in high-availability environments.Bottom of Form

.

IFMS Integration – AU Small Finance Bank, IDFC Bank, IndusInd Bank

Company: MindGate Solutions Pvt. Ltd. | Role: Software Developer
Duration: February 2022 – December 2022 | Technology: Oracle 19c

Description:
Worked on real-time integration between core banking platforms and the Rajasthan Government’s Integrated Financial Management System (IFMS) to support automated fund flows for state-sponsored welfare schemes.

Key Responsibilities:

• Developed PL/SQL logic and data pipelines to integrate IFMS with internal banking systems.
• Designed schemas, stored procedures, and database triggers to ensure seamless synchronization.
• Optimized SQL queries to improve system performance and maintain data consistency.
• Supported production deployments and handled change requests for business-critical modules.

Implemented PL/SQL-based backend logic for ServitiumCRM, a customer relationship management platform used to manage customer interactions, service requests, and performance analytics for leading consumer brands.

Key Responsibilities:

• Developed and maintained PL/SQL packages and stored procedures for CRM workflows.
• Built optimized schemas, triggers, and SQL queries to support ticketing and service processes.
• Conducted unit testing, resolved bugs in production environments, and ensured data integrity.
• Created ad-hoc SQL scripts to support real-time customer analytics and reporting.

Contributed to a government-led digital transformation project to replace manual Excel-based operations with a scalable PL/SQL-based system for broadband service management, plan categorization, and data reporting.

Key Responsibilities:

• Developed PL/SQL procedures to ingest and process large volumes of customer and plan data.
• Automated report generation and system logic based on plan-wise classification.
• Migrated data from manual systems to structured Oracle databases with performance tuning.
• Supported real-time operational monitoring, report delivery, and stakeholder support.