Team Lead / Senior Software Engineer
Project: Orchestrated Analytics (OA)
Client: IQVIA, USA
Orchestrated Analytics provides data and intelligence to healthcare sectors around the globe. It is a purpose-built life sciences business intelligence solution that empowers commercial leaders, brand managers, launch teams, sales/field force, and marketing leaders with timely insights to identify potential risks and opportunities. It provides highly customizable business intelligence dashboards. This application allows us to define data sources, data type definitions, metadata definition, transform data, manage users, access control, define personas, define KPI, and define business questions and notifications. I was involved in the following microservices which had individual frontend and backend.
Microservice: G2N Forecast:
The G2N Forecast Application helps pharmaceutical companies accurately predict gross-to-net revenue by integrating historical sales data, pricing assumptions, and market trends. It calculates contract demand sales while considering discounts, rebates, and administrative fees. The application dynamically updates forecasts based on real-time changes, allowing finance teams to optimize pricing strategies and mitigate risks.
With built-in scenario planning and what-if analysis, it provides insights into future revenue trends. Seamless integration with ERP systems like SAP and Oracle ensures financial alignment while reducing manual errors. By automating complex calculations, the application enhances financial accuracy, improves compliance, and ensures data-driven decision-making for long-term revenue optimization.
Microservice: G2N Accrual:
The G2N Accrual Application automates accrual calculations for pharmaceutical companies, ensuring accurate financial reserves and reporting. It integrates forecast data with actual sales to dynamically adjust accruals, minimizing financial discrepancies. The system continuously updates reserves, tracks inventory flow, and prevents revenue leakage by automating accrual entries into the general ledger.
By reconciling estimated reserves with actual sales through the true-up process, it enhances financial accuracy. This application reduces manual errors, strengthens financial planning, and improves audit readiness, making it an essential tool for pharmaceutical companies managing complex revenue adjustments.
Microservice: Marketplace:
The system is a microservice-based application built with .NET 8 and Angular, comprising two key modules: Component-Based Deployment (CBD) and Template Management & Deployment (TMD).
The TMD module provides default system configurations through template deployment. It allows the creation of template snapshots, which can be deployed as default configurations for any tenant.
The CBD module interacts with a Python microservice responsible for managing Kubernetes deployments on AWS EKS. This Python service utilizes Kubernetes YAML configurations for pods, deployments, HPA, and replicas, managing approximately 50 microservices. The .NET application orchestrates microservice deployments and terminations within the AWS Kubernetes cluster by communicating with the Python service. A user-friendly interface enables dynamic control over individual microservices, allowing users to start or stop components as needed. When a microservice is activated through the UI, the .NET application triggers the Python service to deploy the respective component to EKS. Conversely, when a microservice is deactivated, the Python service removes all associated resources from EKS.
This architecture ensures scalability, automation, and efficient resource management by leveraging Kubernetes and AWS for dynamic microservice orchestration while maintaining seamless interaction between .NET, Angular, and Python services.
Microservice: PHub:
Personalization Hub is like a smart assistant for sales teams, guiding them on their next best action. Instead of digging through reports, sales reps get AI-driven recommendations on what to do next - whether it's following up with a client, prioritizing a lead, or adjusting strategy. It seamlessly integrates with existing tools, delivering real-time insights where they work. By highlighting critical opportunities and potential risks, it helps sales teams stay proactive, close deals faster, and maximize impact. The result is smarter decisions, better engagement, and stronger sales performance - all powered by data-driven intelligence.
Technologies:
C#, .Net, .NET Core, Asp.NET Core, ASP.NET Web API (RESTFul), IdentityServer4, OAuth 2.0, PL/SQL, Entity Framework, Redis, LINQ, Microservices, Clean Architecture, MS Test, Moq, NUnit, NLog, DI, AutoMapper, FluentValidation, Swagger for API documentation, Angular, TypeScript, HTML5, CSS3, JavaScript, ES6, Bootstrap, JSON, XML, Hangfire, CI/CD, GitLab, GitLab Runner, Visual Studio, Visual Studio Code, JIRA, Confluence, Docker, yaml, MS SQL Server, Kubernetes, Rxjs, AWS cloud services – EC2, EKS, S3, ALB, ALB Ingress Controller, IAM, CodeArtifact, CloudFront, RDS