Raghu Sri

Project Title: Digital HRMS Client: In-house Product – Delivered to Multiple Clients Role: SQL Developer

Project Description:
Digital HRMS is an enterprise-level, in-house human resource management platform developed by The Digital Group and deployed for multiple clients. The product encompasses a wide range of modules such as Recruitment Management, Admin Configuration, Workflow Management, Timeport, Resource Allocation, Separation, Report Builder, and Reports. The platform is designed to streamline HR processes and provide scalable, real-time data solutions tailored to client needs.

Responsibilities:

• Actively contributed to the Separation, Resource Allocation, Timeport, and Reports modules with a focus on backend logic and data handling.
• Developed and optimized stored procedures, functions, and triggers for business-critical HR workflows.
• Worked with large datasets and complex queries to support reporting and analytics across client implementations.
• Collaborated with internal teams and clients to gather requirements and deliver module-specific enhancements.
• Implemented role-based access controls for secure data handling across modules.
• Tuned SQL queries for high performance and efficient data processing.
• Provided production support, resolved bugs, and continuously improved system functionality.

Project Title : Mobile Assembly Suite (MAS) & SeaNtry

Client : Disney Cruise Line, Carnival Cruise Line & Virgin Voyages

Role : Senior Database Developer

Project Description:

MAS is a safety system that enables cruise ships to safely and efficiently assemble passengers in emergencies. This Application is meant to capture Guests and Crew during the events of Drills, Emergency (General, Abandon Ship). MAS converts outdated, paper-based models into a digital safety solution that gets critical data to the right crew quickly and accurately. It gives all the reports and data which is useful to coordinate and monitor the rescue operation on the Cruise.

SeaNtry project is mark guest/crew/visitor onboard when they are boarded on ship and offboard when they debark at the end of itinerary. it tracks guest/crew/visitor on ship.

Responsibilities :

• Evaluated, designed, implemented and modified databases and database applications.
• Created & Modified multiple stored procedures, Functions and Triggers.
• Written complex Queries using joins, Sub Queries, Derived Tables and CTE.
• Had exposure on performance tuning.
• Conducted Unit testing to identify issues and make necessary modifications.
• Developed scripts and processes for data integration and maintenance.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Worked on Deployment Process.

Description :

TASK MF (Banking), KFinSapiar is a bank reconciliation processing application used to verify bank balance which are equal in both bank and company at the end of every month. In this process we can do two types of reconciliations, pool and scheme. In pool we are verifying direct account wise balance and In Scheme recon, verifying direct account wise as well as scheme account wise and reports are generated as per banking statements before recon and after recon.

Responsibilities :

• Develop the stored procedures according to the AMC schemes.
• Writing and executing stored to procedures, Functions, Complex T-SQL queries.
• Work on Jobs, Views, Indexes, Query performance, Transactions etc.
• Written complex Queries using joins, Sub Queries, Derived Tables and CTE.
• Used different destinations like OLE DB Destination, Flat file, Excel destinations and different sources like Flat file and OLE DB Source.
• Closely working with AMC clients generate MIS reports for AMCs as per their requirements.
• Debug the already existed stored for production issues.
• Worked on Performance of existing procedures.
• Created Adhoc Reports as per Business criteria.

Description :

TARDIS is a centralized data warehouse across entire Torus Insurance and all end users would connect to the SSAS cube and generate their own reports. TARDIS is very critical to the entire Torus Insurance as it is single version of truth for every line of business which Torus Insurance operates across the global. Torus Insurance is operating in many lines of businesses like Property, Casualty, Liability and Specialty. TARDIS would refresh in every 15 minutes and almost latest data would be available for end users.

Responsibilities :

• Writing and executing stored procedures, Functions and Triggers.
• Written complex Queries using joins, Sub Queries, Derived Tables and CTE.
• Reports are developed as per the requirements in the form of Matrix, Table and Chart Using SQL Server 2008 R2 Reporting Services.
• worked on linked reports and Subscriptions.
• Different Types of reports are designed like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
• Created Parameterized reports like single parameterized reports, multi parameterized reports and cascaded parameterized reports.
• worked on dashboards.
• worked on Complex T-SQL queries.