Dheeraj kumar

Data And Client Reporting

• Developed and optimized reports for Ares client on the Oxane Panorama platform.
• Wrote complex SQL queries for efficient data fetching, ensuring high performance and accuracy.
• Optimized database queries to enhance system efficiency and response time.
• Collaborated with cross-functional teams to deliver data-driven insights for better decision-making.

Ares Client Sign-Off Module Development

• Engineered a robust sign-off module featuring multi-level approver hierarchies.
• Enabled specific user access for approving or disapproving transaction reports on given dates.
• Implemented audit trails to log user actions and comments.
• Automated report finalization—locking reports once all approval stages are complete, with options to reset the workflow if needed.

Apollo Client Data ETL & Borrowing Base Automation

• Developed a data entry module to extract client data, apply logical transformations using Spring Boot Expression Language, and load the data into a database.
• Automated the borrowing base calculation process, ensuring efficient and accurate financial analysis for the client.
• Streamlined data processing for downstream modules, enhancing overall system performance and reliability.