PROJECTS UNDERTAKEN
CAPA & PCCF based Vendor Issue Management & Auditing Application
Project Summary
Optum handles 100+ vendor products. Managing the issues related to project is mostly manual with a team recording everything on a Sharepoint page, getting clarification and fix from respective vendors using email and then maintaining record for auditing purpose. This project simplifies the flow with minimal human interaction. Creation and tracking of issue is maintained via Angular application with all data stored in T-SQL database for audit and easy maintenance. Email based notification, automated approval systems and AI based issue fixing insights ensures all round automation with total compliance.
Tools & Methodology
- Open AI APIs from instruction-tuned insights.
- Angular 19 based web application hosted over AWS S3 for cost optimization and performance.
- .NET 8 based API for super quick performance
- .NET based webjobs for cheaper automation option
RTO Scheduling and compliance management Tool
Project Summary
Tool to automate seating arrangement for 40k+ employees of Optum Philippines. The tool maintain daily working schedule, updation, compliance and outlier detection resulting in optimized seat utilisatiion and >80% RTO.
Methodology
- Worked on database and front-end development by using Angular 17, TypeScript and .NET&
- Automated scheduling, compliance and reporting
- Handing an average user traffic of 10k+ per day.
- SSO authentication, centralised RBAC, PowerBI integration and Github Actions Based CI/CD Pipelining.
Developing a platform to automate work contracts for Optum Vendors and Clients
Project Summary
Developing a platform to automate and ease out contract management for the external stakeholders in the company's initiative.
Methodology
- Worked on database and front-end development by using Angular, JavaScript and SQL Server technologies
- Automated auto approval and data updating mechanism using Azure functions and .NET Core based webjobs
- Created CI-CD pipelining using GitHub actions to automate deployment
- Integrated SSO authentication into platform by using Ping federate and organization’s Azure AD
Deliverables
- Developed a process to automate data sanity by syncing with external data source with zero manual intervention
- Devised a model of email-based approval process to perform verification, auditing and versioning of contracts
- Optimized first load time by lazy loading heavy components and SSO to minimize time-to-interact on platform
- Directly create incident with ServiceNow platform to simplify client request mngt. and query resolution
Achievements
- Recognized for the contributions in project with 6 internal Bravo awards
Techstacks Used
Angular 9, .NET Core, Kendo UI, SQL Server, Github Actions, Azure Web jobs
Automated NPS score decrement factors of Claims related calls using Angular, Python and BARD libraries
Project Summary
Web application to simplify resource requirement planning for the various department in the company.
Methodology
- BARD libraries used to classify consumer calls responses into possible categories
- Cloud storage to save monthly call information for handy access
- Angular based platform for uploading excel related data and dashboard view
Deliverables
Complete automation of improving NPS score related insights for Claims team which otherwise required manual listening and then classifying the calls for possible improvements
Techstacks Used
Angular 9, ngPrime, .NET Core, SQL Server, Github Actions
Developing a documentation site for all the applications
Methodology
- Created using low code technologies including MKDocs and Git
- Automated editing and deployment using Git pull requests and Actions
- Very fast loading time (<1 sec) and can be easily edited by non-coders as it uses markdown.
Techstacks Used
MkDocs, Azure Object Storage, Github Actions