Naresh Reddy

The oral care reporting project is a Microsoft Azure-based solution to store enterprise-wide data and process the data in a centralized repository. It delivers data-driven insights for sales, operations, digitech, and digi manufacturing teams.

As part of the project, we collected data generated by various departments. We moved it from multiple sources, e.g., Azure SQL DB, SharePoint lists, Cosmos DB APIs, and Blob storage, into Azure Data Lake Store using Azure Data Factory. The data was processed and transformed into dimensional model objects using Azure Databricks. We also pulled the data into Azure Analysis Services and created the KPIs needed for Power BI reporting.

This digital marketing project is an AWS-based solution to pull data from various advertising platforms like Google Adwords, Facebook Ads, Shopify, Klaviyo, Pepperjam, and more into a centralized data warehouse hosted on Amazon Redshift.

I created a generic framework using Python and the Singer library to move data from any source to any target using CLI. I used Python to read data from various source API endpoints and staged the data into a centralized database for the data science team to consume.

Designed and developed a project to maintain the health insurance invoicing process. As part of this project, I created a framework to generate the invoices for the customers in bulk. The framework has brought together all these loosely coupled items:

• Premium calculation for a given month
• Calculating the subsidies paid by the government considering the policy holder's economic slab
• Other miscellaneous charges or discounts provided by the insurance company, e.g., the discounts for newborns
• Accepting and distributing the cash paid across various billing periods
• Advancing pay through the date of a policy
• Generating a monthly invoice

This project aims to help retire old and sluggish SSRS reports. It consists of a reporting database on top of which HTML5 reports are built. This DB also stored historical data to help managers set targets for their next fiscal years.

I coded for several stored procedures and enabled optimal load times of the BI reporting DB. Implemented sliding window partitioning for historical tables and achieved better query performance. Actively participated in all the design and architecture activities of the project. Helped five fresh graduates in the team to ramp up quickly and work on core project activities.

Created a BI reconciliation project that eliminates the need for different applications to answer business client questions. This project also eliminates the existing discrepancies in the system. It stabilizes the data flow from various source systems through a common reporting platform, thus diminishing redundant data and improving reliable consistency. A single global warehouse is built from all the different sources to achieve that so that all the native sources now pick data from this single unified warehouse. We are also accountable for building marts for the various sources on top of which user reports are created.

Our team followed Agile software development methods, meaning daily status reports are sent to clients informing them of our progress. Daily code reviews and daily requirements calls are held to discuss client requirement changes.