Abhinav Ojha

Experience

1. Assistant Manager

   EXL

   Sep 2024 — Present

   Project Overview:Built and maintained a centralized data warehouse on Amazon Redshift by integrating analytics data from key healthcare systems like Javelina and WLT, creating a reliable single source that supported faster and more informed decision-making. Automated core healthcare insurance processes, including level funding, aggregate stop loss, and specific stop loss, which led to major gains in operational efficiency.Key Contributions:1. Data Lake Replication Automation:* Data replication into a data lake using automation with AWS DMS from various sources like Oracle, PostgreSQL, and MSSQL.* Built infrastructure on demand using AWS CloudFormation and released them after usage to reduce costs.2. Data Warehouse Pipeline:* Built data pipelines using AWS Glue and workflows with Python & Spark to manipulate data from various sources for efficient data analysis and reporting using Amazon Redshift.* Implemented infrastructure automation with AWS CloudFormation.* Tuned Redshift performance through smart partitioning, compression, and workload optimization to handle large healthcare datasets efficiently.3. Serverless Data Pipeline :* Developed & deployed serverless data pipelines using AWS Step Functions & AWS Lambda and utilized Python to facilitate distributed parallel processing of many small files for enhanced efficiency and resource optimization.* Built automatic deployment of serverless data pipelines using AWS CDK.

Education

• ITM Group of Institutions

  Bachelor of Engineering (BE), Computer Science

  2014 — 2018

• St Paul’s School, Gwalior

  Computer Science, Mathematics & General Science

  2000 — 2014

Skills

• Manual
• C
• Testlink
• Jquery
• Ubuntu
• Dbms
• Selenium Ide
• Php
• Cascading Style Sheets (Css)
• Bugzilla
• Javascript
• Tosca
• Html
• Vim Editor
• Data Driven Testing
• Python
• Java
• Selenium Webdriver
• Api Testing
• Testng
• Shell Scripting
• Mysql