Mahesh Babu Alugadda Pandu

Project Overview: The Gateway application serves as a critical integration point for external clients, enabling seamless connectivity to import and export data from the Bloomberg terminal. It facilitates data exchange through multiple methods such as feeds, files, or MQ messages, allowing clients to perform custom business operations on the data.

Key Contributions:

• Led a team to replace the SFTP-based file watcher with a Python solution that subscribes to a Kafka topic with multiple partitions, processing 20 million Kafka messages per day, streamlining data processing, eliminating direct SFTP access, and achieving improved scalability and efficiency. The Python task was deployed in the cloud using Kubernetes, ensuring better resource management, scalability, and seamless deployment.
• Developed a solution to reprocess messages by designing a new message type for the service. Messages are reprocessed using files stored in S3 buckets with a lifecycle policy, ensuring efficient data management. The system currently stores 5 million messages in a bucket at any given time, optimizing data retention and retrieval.
• Migrated Bloomberg Cloud Storage (S3 Storage) to a new version with updated endpoints, buckets, and lifecycle policies, ensuring minimal code changes to the existing service. To minimize service disruption, developed strategies for each bucket: some buckets were fully migrated to new buckets, while others implemented dual publishing to both the old and new buckets during the transition.
• As part of migrating the service from outdated Sun machines to Linux machines, moved sensitive secrets to Subrosa, and set up ACL policies for secure bucket access. This ensured the protection of critical information such as database connection strings, access keys, and S3 secret keys, complying with security best practices.

Environment:

• C#, Java, Python, AWS S3 Storage, AWS ,Docker, PostgreSQL, Kafka, JSON, SQL Server 2014, XUnit, GIT.

Project: Comcast Business

Responsibilities:

• Developed multiple microservices to support key business objects for Comcast Business operations, utilizing C#, .NET Core, and Docker containers on AWS, enabling scalable and efficient backend solutions.
• Implemented an AWS Lambda function to fetch details of customers who showed interest in a service but did not complete the order. This serverless solution was chosen for its cost-efficiency and scalability, with the report running every 40 minutes to provide timely insights without the overhead of managing dedicated servers.
• Stored intermediate data from microservices in Redis cache to enhance performance and reduce response times.
• Developed unit tests with xUnit and Moq, ensuring 80%+ code coverage across all services, and enforced test coverage checks before merging to master, ensuring high code quality and reliability.
• Peer-reviewed and provided feedback on code complexity, memory complexity, and code readability.

Environment:

.NET Framework, .NET Core, C#, AWS, MySQL, JSON, XUnit, MOQ, Docker, GIT.

• Implemented the Restful service using Visual Studio 2018, C#
• Performed code refactoring to improve code maintainability and readability
• Involved in code review, PeerQA, and Hackathon sessions.

Environment: Visual Studio.NET 2018, SQL Server, C#, TeamCity, Docker, AWS, GIT, Splunk, New Relic, React/Redux, Redis

• Implemented the multi-threaded windows service application using C# which receives the tick price and calculates the data points

Environment: C#, Cassandra, AWS, SQL Server 2008/2012

• Improved the performance of rollup logic, journal entries calculation and statement revision creation by 90%

Environment: C# 4.0, WCF, DB2 9.5, Nlog, NUnit, Windows Service

• Developed a demo version of the product to solicit and incorporate feedback into the design