Product Context: As part of the Reporting & Analytics Team, I specialized in translating raw data into actionable patient insights for dental practices. My key tools, including Opportunity Miner and custom patient data dashboards, drove business outcomes by providing ETL-based reporting and data-driven recommendations that pinpointed growth areas.
Key Responsibilities & Achievements:
- API Development & Database Design
Designed and developed RESTful APIs using .NET Core and SQLKata to dynamically construct data queries and fetch complex filtered datasets from multiple sources (MySQL, SQL Server, Vertica).
Participated in database schema design and optimization for the analytics data warehouse, ensuring denormalized data structures for faster reporting queries.
Implemented query performance tuning and caching mechanisms that improved large dataset retrieval efficiency by 30–40%.
- Frontend Engineering (Angular)
Built modular, reusable Angular components and custom services for Opportunity Miner and reporting dashboards.
Migrated legacy Web Components into Micro Frontend architecture, enabling independent deployments and improving scalability.
Implemented client-specific filters, data visualization, and export functionalities, enhancing user interactivity and product adoption.
- Performance & Scalability
Collaborated with architects to improve query scalability and service responsiveness for high-volume data.
Optimized front-end state management and lazy loading strategies to reduce app load times.
- Testing & Code Quality
Developed unit and integration test suites using Jasmine & Karma for Angular and xUnit for backend APIs.
Maintained >85% test coverage across core modules, preventing regression issues and improving release reliability.
- Collaboration & Agile Development
Actively participated in scrum meetings — grooming, sprint planning, retrospectives, and daily stand-ups.
Worked closely with product owners and business analysts to translate client needs into functional and technical requirements.
Mentored new team members on query optimization, SQLKata usage, and Angular best practices.
- Monitoring & Cloud
Integrated Azure App Insights for real-time error tracking, telemetry, and performance monitoring.
Collaborated with DevOps for smooth deployments and production debugging in Azure environments.
KEY PROJECT – Opportunity Miner (CareStack)
A patient analytics and reporting platform designed to identify collection opportunities and improve patient engagement through data-driven insights and actionable workflows.
- Developed and owned the Opportunity Miner microservice, converting the legacy WebComponent app into a Microfrontend architecture, improving modularity, maintainability, and independent deployments within the CareStack ecosystem.
- Used SQLKata to build a dynamic query generation system, where user-selected filters triggered corresponding query resolvers to fetch relevant patient datasets.
- Designed and implemented a data pipeline (ETL) to transfer data from MySQL and SQL Server into the Vertica warehouse, enabling high-performance analytical queries.
- Enabled actionabilities such as sending messages, emails, and reminders to selected patients by integrating with other internal microservices.
- Built and enhanced the Angular-based UI, improving usability, filtering experience, and responsiveness across devices.
- Applied unit and integration testing using Jasmine, Karma, and xUnit, ensuring stability and data accuracy.