Omkar Bansode

Data Analyst & Shift Lead

Verificient Solutions Pvt. Ltd.

Nov 2022 - Jun 2026

Performed data configuration and maintenance across examination setup, proctor assignments, and session scheduling for 100,000+ student accounts. Executed end-to-end data mapping between source examination systems and target reporting databases, ensuring structural consistency and field-level accuracy. Reduced data discrepancy incidents by 25% through systematic rule-based validation audits. Built data transformation pipelines using Python (Pandas) and Excel Power Query to standardize raw data feeds from multiple upstream sources. Built Advanced Excel dashboards using Pivot Tables, XLOOKUP, and Power Query — reducing manual reporting effort by 30–40%. Designed and maintained Excel-based reports used by multiple stakeholders for daily, weekly, and monthly business reviews. Developed and optimized SQL queries to extract, clean, and analyze structured data from large relational databases. Documented data mapping rules, validation processes, and configuration standards in structured SOPs — improving new analyst onboarding time by 20%. Supported system upgrades and data migration tasks by defining source-to-target mapping documents and running pre/post-migration validation checks. Troubleshot data-related issues across production environments, providing timely resolution to internal teams and external clients in a fully remote setup. Led a team of analysts as Shift Lead — coordinating daily operations, managing stakeholder communications, and ensuring SLA compliance.