Amar D.
Technology Lead @ Infosys | Database Developer | PL/SQL & Oracle Developer | 7 Yrs | MSSQL · Snowflake · ETL | BFSI · Telecom · Insurance
Indore
7+ years of work experience
Jan 20251 yr 6 mosPresent
Indore, Madhya Pradesh, India
Leading Oracle-to-MSSQL database migration and performance
optimisation for a large Telecom client.
▸ Reduced migration time by 35% by redesigning 100+ stored
procedures, transient table schemas, and index strategies
— zero data-integrity failures across all migrated objects
▸ Improved query execution speed by 40% through execution
plan analysis, ANSI join refactoring, and covering indexes
on high-traffic reporting tables
▸ Decreased UAT defect rate by 30% by owning schema
creation, job testing, and QA validation protocols
▸ Drove zero missed SLAs across 6 consecutive sprints
managing production support across 3 cross-functional teams
▸ Recognised as Top Impacter Q1 2025 — Delivery Excellency
Award, Infosys
Tech: PL/SQL · Oracle · MSSQL · Stored Procedures ·
Performance Tuning · Index Optimisation · ETL · SSMA ·
Agile · SDLC
Apr 20222 yrs 9 mosDec 2024
Indore, Madhya Pradesh, India
Oracle-to-MSSQL migration and ETL optimisation for a
US-based BFSI client handling millions of records daily.
▸ Migrated 200+ Oracle objects (tables, stored procedures,
views) to MSSQL using SSMA — 100% data integrity, zero
post-migration incidents
▸ Reduced BCP data load times by 50% by restructuring
ETL pipelines and optimising staging-to-target data flows
▸ Improved report generation speed by 45% through
execution plan analysis and ANSI join refactoring across
30+ financial reports serving 5,000+ daily users
▸ Maintained 99.9% system availability for 15-member team
▸ Built reusable PL/SQL validation framework cutting
mismatch resolution time by 60%
Tech: PL/SQL · Oracle · MSSQL · SSMA · BCP · ETL ·
Snowflake SQL · PostgreSQL · Performance Tuning
Jul 20192 yrs 9 mosMar 2022
Pune District, Maharashtra, India
PL/SQL Developer on the BALIC Insurance project, working
on the Click PSS product at client site in Pune.
▸ Reduced data parsing and processing time by 55% by
developing and optimising PL/SQL stored procedures,
packages and functions for Click PSS
▸ Reduced staging database load times by 40% by designing
ETL pipelines integrating data from 6+ heterogeneous
sources using linked servers
▸ Cut report refresh times by 30% and eliminated recurring
extraction failures by rebuilding staging schema on
star-schema principles — enabling 6x faster dimensional
queries
▸ Shipped 3 major Click PSS upgrades on time with zero
scope creep — owned full cycle from requirements
gathering through UAT sign-off
Tech: PL/SQL · Oracle · Stored Procedures · ETL ·
Star Schema · Data Warehousing · Linked Servers ·
SQL · Insurance domain
Education
Bachelor of Technology - BTech, Computer Science
Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV), Bhopal
20154 yrs2019
Schooling
kendriya vidyalaya
200312 yrs2015
Join Amar and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal Boss