Rohil is a Data Engineer with expertise in facilitating efficient and effective analysis and empowering users with multiple data types - building clean pipelines and maintaining data products on projects. He provides solutions to maintain reports, dashboards, and metrics to enhance the performance of data - summarizing analyses, making recommendations, and providing appropriate information that meets the needs of analysts and business owners.
Developed new database solutions to reduce licensing costs and improve the performance of the read servers.
Migrated the existing database infrastructure to MySQL, deployed Kafka pipelines for replication tasks, and integrated 3rd-party dashboards.
Set up 5 new servers for Media.net, optimized an existing system to perform 100x faster, added new features to multiple systems, and enhanced integration.
Built and implemented a new data infrastructure that generates different reports on a primary reporting interface for Media.Net.
Delivered a generic code for the primary reporting interface and implemented solutions to limit the max waiting time to 2s on the download queue.
Implemented a new MSSQL server to handle failover requirements, executed Powershell for file handling, and reduced maintenance time by 10X using a generic package.