Mayank Kumar

Coveach System:

• Established secure logging and auditing frameworks.
• Led team in PostgreSQL HA setup utilizing Patroni, etcd, and HAProxy for enhanced availability.

Innovation and Facilitation:

• Leveraged ChatGPT and Cursor AI to expedite code review and enhance development efficiency.
• Developing AI Dashboard Generator chatbot to extract insights and create dashboards from data leveraging gpt 4.0

Key Projects:
Vena – Marketing KPI Platform:

• Built Conversion Metrics KPI dashboard for 290+ clients.
• Enhanced data verification workflows to ensure high reliability.
• Enabled automated sql linting to enhance the readability and syntax validation.

MVP (Marketing View Premium):

• Engineered end-to-end backend for 13 analytical dashboards (Sales, Pricing, Market, and Customer Analysis).
• Built 13 ETLs, 14 APIs, 14 Cloud Functions, and CI/CD pipelines using Terraform and Cloud Build.
• Developed Customer Nurturing recommendation system leveraging predictive analytics for upsell targeting.
• Created scalable data pipeline on GCP (data ingestion → transformation → prediction → visualization).

MIS-Infra:

• Created Grafana dashboards monitoring disk, pod, and node metrics across all environments.
• Improved system visibility and performance monitoring.

GenEye (AI Conference Project):

• Developed backend APIs for Admin and Security modules of GenEye for 3AI Conference launch.

• Built and maintained data pipelines using AWS Lambda, SQS, Redshift, Athena, Kafka.
• Automated analytics workflows for real-time insights and ML feature pipelines.
• Fuel Efficiency: Computed trip-level mileage using telematics data.
• Engine Seizure Prevention: Developed predictive model to avoid engine failures.
• Daily Calling Priority: Automated user prioritization reports for sales outreach.
• Churn Lifecycle Migration: Migrated workflows from Redshift to Athena, improving speed and cost efficiency.
• Driver Score MVP: Rearchitectured driver scoring for partners like ETO and Porter.

• Designed and implemented ETL pipelines using Informatica, Teradata, Oracle, SQL Server.
• Migrated legacy systems from COBOL & DB2 to Informatica-based platforms.
• Automated manual ETL workflows reducing human intervention and errors.
• Delivered BI-ready data marts for insurance product analytics.
• Implemented Slowly Changing Dimensions (SCD Type 2) and optimized data pipelines.