Vishnu Prasanth Loganathan

About Vishnu Prasanth Loganathan

Designed and optimized database schemas for large-scale financial applications, resulting in improved performance and scalability-Implemented table partitioning, indexing, and query optimization techniques, leading to a improvement in financial reconciliation process efficiency-Proficient in writing complex SQL queries, utilizing JOINs, subqueries, and window functions to analyze large datasets in financial reconciliation, facilitating accurate and efficient comparisons of financial transactions-Utilized PostgreSQL for ETL processes, enabling seamless import, cleaning, and integration of bank statements, financial data, and transaction records from multiple sources for reconciliation-Developed efficient stored procedures and functions to automate financial calculations, reducing processing time -Implemented database triggers for real-time data validation and reconciliation updates, ensuring data accuracy and integrity across multiple bank accounts and financial records-Utilized PostgreSQL constraints to enforce business rules, guaranteeing data consistency and accuracy in the reconciliation process-Leveraged PostgreSQL with PGADMIN4 to generate comprehensive reconciliation reports and visually informative dashboards, facilitating informed decision-making.

Experience

1. Postgresql Developer

   Mylapay

   Dec 2024 — Present · Chennai, IN

   Experienced in developing and optimizing PostgreSQL databases for UPI reconciliation processes across multiple banks. Skilled in improving transaction management efficiency and delivering fast reconciliation for end users. Proficient in utilizing ETL methods for data extraction, transformation, and ensuring accurate, regular client outputs. Contributed to the development and troubleshooting of automated reconciliation scripts, enhancing system performance and reliability in high-transaction environments.

Education

• PA College of Engineering and Technology

  Bachelor of Engineering - BE

  2016 — 2020