DARUN DASS C

Accomplished Software Engineer at Cripton Technosoft Pvt Ltd, skilled in SQL and PL/SQL, with a proven track record of optimizing database performance and enhancing data integrity. Adept at translating business requirements into technical solutions, fostering collaboration with stakeholders to drive actionable insights and improve system adoption.

I hereby declare that all the information provided by me in this resume is true and correct to the best of my knowledge and belief

Title:      Loan Management System

Domain: Banking

Client:    ING Bank (Sydney)

In a Loan Management System for Banking at ING Bank, Sydney, I developed PL/SQL procedures and functions to manage customer data, including customer onboarding, updates, and deletion processes, and created triggers to capture changes in customer status and automatically notify relevant departments, designed and optimized complex SQL queries to extract insights from customer interactions and transaction histories, and implemented data validation and cleansing routines to ensure data integrity across the system, developed materialized views and reports to provide actionable insights to the sales and marketing team, worked with stakeholders to identify business requirements and translate them into technical specifications, conducted performance tuning and optimization of database operations to enhance system responsiveness, created user documentation, and provided training sessions for end users to maximize system adoption, utilized Oracle Database, PL/SQL, SQL, Oracle APEX, DBMS_SCHEDULER, and data visualization tools for reporting (e.g., Oracle BI).

Title: Financial Transaction Processing System

Domain: Banking

Client: GHI Healthcare Solutions (Canada)

In a financial transaction processing system for banking at GHI Healthcare Solutions in Canada, I developed PL/SQL procedures, packages, and triggers to automate transaction processing, ensuring real-time data updates, and maintaining data integrity across multiple banking operations I wrote optimized SQL queries to retrieve and analyze transaction data, improving the efficiency of financial reporting and analytics Implemented dynamic SQL to allow flexible querying of transaction records, enabling users to generate customized reports based on specific criteria; designed and maintained materialized views to aggregate transaction data, ensuring quick access to summary reports and improving overall system performance; utilized bulk collect and FORALL statements to efficiently handle large volumes of transaction records, significantly reducing execution time and enhancing user experience.