Rahul Rana

Certifications Cloud Analytics & Reporting Solutions Cross-Functional Collaboration Software Engineering & System Design

At Patterson, I played a key role in designing and delivering modern, cloud-native reporting solutions by leveraging Microsoft Azure, Power BI, and microservices-based architectures, with a strong focus on scalability, security, and performance.

• ✅ Microsoft Certified: Azure AI Engineer Associate
  Credential Link:
  https://learn.microsoft.com/api/credentials/share/en-us/RahulRana-1312/6BFDEE2E72D9A2B5?sharingId=B9A7E8EBB595E9CC
• Power BI Fabric POC (Data Lake–Backed Analytics)
  Developed and executed a Proof of Concept (POC) to embed Power BI Fabric reports within the application using the Power BI JavaScript SDK, with analytics powered by a centralized Data Lake. Implemented service principal–based authentication to securely authorize access to reports, ensuring strict access control while preventing exposure of end-user credentials. This initiative validated the feasibility of delivering secure, scalable, and high-performance in-application analytics, laying the groundwork for production-ready reporting capabilities.
• Asynchronous Event-Driven Reporting Architecture
  Architected and delivered a highly scalable, event-driven asynchronous reporting pipeline leveraging Azure Service Bus queues, queue-triggered Azure Functions, Azure Blob Storage, and Azure SignalR Service to efficiently process long-running and compute-intensive reporting workloads.
  Incoming report requests were decoupled from synchronous API execution and reliably enqueued into Azure Service Bus, eliminating thread blocking, preventing HTTP timeouts, and significantly improving platform responsiveness under peak load.
  A queue-triggered Azure Function dynamically scaled based on queue depth, processing report generation jobs in parallel while maintaining fault tolerance, retry handling, and back-pressure control.
  The function executed the complete report orchestration lifecycle, including data aggregation, transformation, and formatting, before persisting generated artifacts into Azure Blob Storage for durable, highly available, and cost-optimized storage.
  Upon successful completion, the function emitted real-time notifications via Azure SignalR Service, enabling the UI to immediately inform users of report readiness without polling. The frontend then securely retrieved reports directly from Blob Storage using time-bound access mechanisms.
  This architecture enforced strong separation of concerns, promoted horizontal scalability, and aligned with cloud-native best practices such as asynchronous messaging, stateless compute, and event-driven processing—resulting in improved resiliency and a near real-time user experience.
• Collaborated closely with cloud architects, data engineers, frontend developers, and QA teams to ensure the reporting pipeline—from data ingestion to visualization—was optimized, scalable, and aligned with business objectives.
• Vendor & Tool Evaluation: Assessed third-party products and platforms to ensure alignment with organizational standards, scalability requirements, and long-term technical strategy.
• Object-Oriented Development: Designed and built applications using OOP principles, producing modular, reusable, and maintainable codebases.
• System Enhancements & Modernization: Modified and enhanced existing systems by resolving defects, supporting new hardware integrations, and improving user interfaces and performance.
• Embedded Systems & Firmware Development: Designed and implemented firmware components interfacing directly with hardware devices, ensuring robust hardware-software integration.
• Code Quality & Reviews: Conducted rigorous code reviews to maintain coding standards, optimize performance, and ensure production-grade quality.
• Technical Problem Solving: Worked closely with analysts, engineers, and developers to diagnose complex system issues and deliver effective, scalable solutions.
• Requirements & Stakeholder Alignment: Reviewed and refined project requirements to ensure alignment with customer goals, delivery timelines, and resource constraints.
• Continuous Improvement: Analyzed user feedback and system metrics to identify bottlenecks and drive continuous enhancements in application performance and usability.

At Vartopia, I was responsible for developing and maintaining a range of enterprise-level applications focused on channel management solutions. I worked closely with cross-functional teams, including product managers, designers, and QA engineers, to deliver high-quality software aligned with business requirements and timelines.

Key contributions included:
✅ Full-stack development using technologies such as C#, .NET Core, Angular, and JavaScript to build scalable web applications.
✅ Designed and implemented RESTful APIs to support integration between front-end applications, partner systems, and internal services, ensuring robust and efficient data exchange.
✅ Worked on Azure cloud services, including Azure App Services, Azure Functions, and Azure Storage, optimizing performance and reliability for cloud-hosted applications.
✅ Integrated third-party services and APIs into the platform to expand product capabilities, including partner portals and reporting tools.
✅ Contributed to data-driven features by working with SQL Server, designing queries, stored procedures, and optimizing database interactions.
✅ Ensured code quality and maintainability through unit testing, code reviews, and adherence to software engineering best practices.
✅ Collaborated on the transition to a microservices architecture, breaking down monolithic components into smaller, independently deployable services.
✅ Delivered enhanced reporting solutions, improving data visualization and insights for partner and sales performance.

This role strengthened my expertise in cloud-first application development, scalable system design, and delivering solutions that directly support business growth in the channel management space.

✅ Implementing SSO (Single Sign-On) using Okta, allowing seamless access across internal and external applications, improving user experience and reducing login friction.
✅ Configuring Okta applications, groups, and policies to control access based on user roles, ensuring that sensitive data and functionality were protected by robust access controls.
✅ Working with OpenID Connect (OIDC) and OAuth 2.0 protocols to integrate Okta authentication flows into custom applications and services.

Project: Field Measurement Database (FMD) (November 2015 – April 2017)

✅ Project: NCVT-MIS (National Council for Vocational Training – Management Information System)

• Worked on a government project under the Skill India Movement to maintain data for all ITIs (Industrial Training Institutes) and establishments across India.
• Developed and maintained a web application using ASP.NET MVC with SQL Server as the backend.
• Collaborated in a team of 4 developers to build new modules, implement feature enhancements, and support legacy pages.
• Took ownership of assigned tasks, ensuring timely delivery and maintaining high code quality.
• Provided production support, bug fixes, and performance improvements for the platform, ensuring uninterrupted service to thousands of users nationwide.

✅ Key Technologies: ASP.NET MVC, SQL Server, HTML, JavaScript, jQuery, Agile collaboration, production support

Client: British Petroleum (BP)
Role: Junior DotNet Developer

✅ Developed and maintained the Field Measurement Database (FMD) web platform, providing BP employees a centralized system to upload and manage process data.

• Supported user-uploaded Excel files, ensuring seamless data integration into the backend database.
• Worked on the web interface using Kendo Grid for dynamic data display and updates after automated midnight refreshes.
• Focused on ticket-based support, resolving issues and implementing small enhancements under the guidance of senior developers.
• Gained experience in troubleshooting, backend–frontend integration, and understanding enterprise-level workflows and data processing.

✅ Key Technologies: ASP.NET, MVC, Kendo Grid, SQL Server, Excel integration, support ticket resolution, team collaboration