Sumita Gochhayat

Results-driven Oracle PL/SQL Developer with 6+ years of experience delivering enterprise database solutions across Banking, Telecom, Manufacturing, and Automotive domains. Proven track record in PL/SQL development (Packages, Procedures, Triggers, Bulk Collect, Collections), ETL pipeline design using SSIS & ADF, Snowflake data engineering (Bronze-Silver-Gold architecture), and Azure cloud platforms.

Microsoft Certified Azure Database

Administrator (DP-300). Immediate joiner with strong client-facing communication and SLA-driven delivery.

Consultant – Database & Data Engineering - Infogain India Pvt. Ltd. - Pune

(2023-04 - 2025-06)

• Designed end-to-end Snowflake data pipeline using layered Bronze-Silver-Gold architecture for customer analytics reporting.
• Ingested raw CSV data into Snowflake internal stages and Bronze layer, preserving records for audit and traceability.
• Built Silver layer transformation logic to clean data — correcting email formats, resolving transaction anomalies, and enforcing data integrity constraints.
• Developed Gold layer aggregations producing business-ready KPIs including revenue summaries and booking counts for downstream consumption.
• Created interactive Snowsight dashboards to visualize Gold-layer metrics for business stakeholders.
• Provided end-to-end production support, issue triaging, and Root Cause Analysis (RCA) for BLT/PM tickets, consistently meeting SLA commitments.
• Debugged and resolved critical failures in PL/SQL packages, stored procedures, triggers, and API integrations using SOAP UI, Postman, and ESB/LMS logs.
• Led joint debugging sessions with onshore teams for high-priority production incidents and conducted regular client sync calls.
• Analyzed data flow across API layers (ESB, LMS, BLUI) to identify and resolve recurring integration issues, reducing repeat incidents.
• Developed and optimized SQL Server stored procedures, functions, and triggers aligned with business requirements.
• Designed and built end-to-end SSIS ETL workflows covering extraction, transformation, and loading from source to staging to data warehouse.
• Led query optimization initiatives reducing data processing time and improving BI reporting performance significantly.
• Ensured data quality, integrity, and reconciliation for downstream reporting and Business Intelligence use cases.
• Designed and implemented Azure Synapse pipelines for data ingestion from multiple heterogeneous sources.
• Built Staging (STG), Hub, and Publication (PUB) layers in Azure Synapse for downstream MRF reporting systems.
• Developed stored procedures, functions, and triggers in Azure Synapse Dedicated SQL Pool as per business logic.
• Performed data quality validation, reconciliation, and post-deployment testing across environments using Azure Data Factory.

Software Engineer – Oracle PL/SQL Developer - Tech Mahindra Ltd. - Bangalore

(2019-07 - 2023-03)

• Supported critical core banking operations including Start Day, Mid Day, and End of Day (EOD) batch processing.
• Modified PL/SQL packages for ledger posting, balance sheet reconciliation, and transaction processing for banking operations.
• Used SQL*Loader for bulk data ingestion from CSV files into Oracle 12c database, handling 10K+ daily records.
• Developed complex SQL queries for transaction reporting and implemented client-specific change requests within SLA.
• Enhanced and maintained PL/SQL packages, procedures, functions, and triggers for telecom network management.
• Developed complex SQL queries using joins, subqueries, and analytical functions for business reporting.
• Implemented structured exception handling and created Collections, Records, and database objects for new features.
• Handled client issue resolution, production support, and change requests within agreed SLAs.

B.Tech - Electronics & Telecommunication Engineering - Biju Patnaik University of Technology (BPUT)