Summary
Overview
Work History
Education
Skills
Timeline
Generic
Utkarsh Srivastava

Utkarsh Srivastava

Manager
Gurugram

Summary

Detail-oriented Data Analyst with 6+ years of experience in data migration, transformation, and reconciliation across enterprise systems. Proven track record in SQL development, ETL processes, and ensuring data integrity when migrating from legacy systems to modern platforms. Adept at using tools like SQL Server, Oracle, PostgreSQL, and Excel for audit and validation tasks.

Overview

9
9
years of professional experience
4
4
years of post-secondary education

Work History

Manager

SBI Cards
09.2022 - Current
  • Utilized SQL to extract and manipulate data from related tables within customer transaction databases using advanced JOIN and VIEW operations.
    ● Transformed and filtered data through aggregation and filtering functions to enhance the efficiency and accuracy of the reporting process.
    ● Developed complex SQL queries to derive meaningful insights from raw data, facilitating data-driven decision-making.
    ● Conducted in-depth analysis of customer Transaction patterns, contributing to strategic initiatives aimed at improving performance.

Consultant 1

Exl Service
08.2020 - 09.2022
  • Wrote complex SQL queries to migrate customer data between loan origination and servicing systems.
  • Supported post-migration validation by comparing legacy vs new system values using LEFT JOINs, EXCEPT clauses, and custom logic.
  • Extracted and processed large datasets from Hadoop & Teradata using SQL.
  • Automated and distributed custom risk reports leveraging Various tools.

Data Analyst

Acxiom Technologies
08.2018 - 09.2019
  • Expertise in data preparation, including blending data from multiple sources, creating complex joins, and ensuring data integrity.
    • Supported functional analysis of customer and bank transaction processes.
    • Collaborated with business stakeholders to analyze end-to-end customer onboarding and transaction workflows in core banking systems.
    • Identified key data attributes, transaction types, and exception scenarios to support business rule definition and validation.
    • Utilized strong SQL skills for daily data testing, crafting complex queries to validate data accuracy.
    • Documented and analyzed data flow diagrams to ensure seamless information transitions across modules
    • Performed data testing and issue tracking for critical customer journey features such as money transfer, balance inquiry, and FD management

Data Integrity Analyst

Xeam Ventures pvt LTD
01.2017 - 08.2018
  • Designed and implemented SQL scripts to extract, transform, and load (ETL) data across Oracle and SQL Server systems.
  • Performed field-level and record-level data reconciliation using SQL queries, identifying mismatches and data integrity gaps.
  • Worked with business SMEs to resolve mismatched records using audit logs and lookup tables.

Education

Bachelor Of Engineering - Information Science & Engineering

Nitte Meenakshi Institute Of Technology
09.2011 - 09.2015

Skills

    • SQL

    • Excel

  • Power BI

  • Python

undefined

Timeline

Manager

SBI Cards
09.2022 - Current

Consultant 1

Exl Service
08.2020 - 09.2022

Data Analyst

Acxiom Technologies
08.2018 - 09.2019

Data Integrity Analyst

Xeam Ventures pvt LTD
01.2017 - 08.2018

Bachelor Of Engineering - Information Science & Engineering

Nitte Meenakshi Institute Of Technology
09.2011 - 09.2015
Utkarsh SrivastavaManager