Looking for a job

Vikas Mehrunkar

@vikasmehrunkar

Engineering Manager at GEICO who supported a 70TB Claims database and helped maintain its 99.99% availability goal.

At GEICO Inc., I supported the Oracle database for the company’s Cloud-hosted Claims application and managed the Data Model team, which met its 99.99% availability goal each year. I recommended database indexes that improved application performance by 50% or more and implemented an archive policy that reduced storage costs by 10%.

At COE Inc., I managed production data loading for an 8TB Oracle database and achieved a 100% success rate against OPM’s data loading SLA. Earlier, I managed a team of nine at the US Census Bureau and led user acceptance testing at Fannie Mae.

Experience

Work history, roles, and key accomplishments

Technical Lead - Database

GEICO Inc.

Oct 2017 - Dec 2023 (6 years 2 months)

Supported a critical 70TB Oracle OLTP database for a cloud-hosted 24x7 Claims web application, achieving 99.99% availability. Managed data model changes, resolved replication issues, and reduced storage costs by 10%.

Oracle SQL Pl SQL UNIX Shell Scripting Informatica Guide Wires Cloud Computing Data Modeling Performance Optimization Data Replication Kanban Linux Jira Confluence

Data Warehouse Lead

COE Inc.

Feb 2009 - Sep 2017 (8 years 7 months)

Managed bi-weekly production data loading for an 8TB Oracle database, achieving 100% SLA compliance. Led data quality analysis, mentored analysts, and coordinated with clients and infrastructure teams.

Oracle SQL Informatica ETL Data Warehouse Jira Data Analysis Mentorship Client Management

Operations Lead

US Census Bureau

May 2007 - Jan 2009 (1 year 8 months)

Managed a team of 9 for monthly releases of survey products and ad-hoc hot fixes. Coordinated with stakeholders, DBA, and systems engineering teams for deployment and data warehouse loads.

Data Warehouse Release Management Team Leadership Websphere SQL Testing

UAT Lead

Fannie Mae

Mar 2006 - Apr 2007 (1 year 1 month)

Led UAT for the Restatement project, coordinating end-to-end data integrity testing across source, staging, reporting, and OLAP cubes. Developed test cases, evaluated SQL, and managed defect resolution.

UAT SQL ETL Business Objects Hyperion Essbase Test Planning Defect Management