Resourcer is a robust web-based application developed exclusively for internal Aker users across various roles. With Resourcer, administrators and members can efficiently manage workforce scheduling and assignments. Administrators have the capability to create multiple user profiles, assign work rotation shifts for specific dates, and facilitate the hiring and rehiring processes seamlessly within the platformResponsibilities• Engaged in refinement sessions to discern business needs and gather comprehensive requirements• Designed and implemented tables, views, stored procedures, functions, and user-defined table types using SQL (SSMS) to meet project specifications in the DEV environment• Managed code integrity by committing changes to the development repository via Visual Studio (SSIS), ensuring adherence to approval processes from designated approvers• Designed, developed, and validated ETL processes across DEV, QA, and PROD environments• Identified and addressed root causes of issues, implementing effective solutions to improve system reliability• Actively participated in Scrum meetings, refinement sessions, retrospective meetings, and bug triage calls to enhance team efficiency and project outcomes• Facilitated clear communication with clients to gather additional information and clarify requirements related to master data

This application is developed to different types of Policy, claim and billing an Insurance for different types of LOB (line of business) like home, life, motorcycle and etc.. to the Customers. Provide different types of Insurance in this application. QBE Corporation is a Insurance service billing and compliance service. This Application helps to maintain Policy center, Billing center and Claim Center and it also helps to maintain customer recordsResponsibilities• Developed and optimized simple and complex queries using joins, functions, and set operators• Conducted comprehensive testing to validate source and target data integrity within SQL databases• Designed and prepared test cases aligned with business mapping and requirements• Facilitated effective communication with stakeholders to coordinate various project activities• Executed test scripts and actively participated in defect management processes• Updated work processes in JIIRA and maintained defect evidence documentation• Played a key role in ETL manual testing and validation activities