Dec 2022 – Mar 2026 · 3 yrs 3 mos

• Developed packages and procedures to automate repetitive SQL statements, improving efficiency and reducing
• manual effort by 30%.
• Migrated existing code base from Oracle to Snowflake, ensuring seamless functionality and optimized performance.
• Implemented Snow pipe to automate continuous data ingestion from externalsources into Snowflake,
• ensuring timely and efficient data availability for downstream processes.
• Created and managed tasks and task graphs in Snowflake to automate the execution of procedures,
• streamline workflow orchestration, and monitor processes, improving operational efficiency, ensuring
• timely data processing, and reducing manual intervention.
• Identifiedand optimized slow-running complexqueriesusingOracle performance tuning techniquessuch as
• SQL query refactoring, indexing strategies, partitioning, and execution plan analysis, resulting in a 30%
• reduction in execution time and improved program efficiency.
• Designed and deployed PL/SQL packages to automate email notifications with attachments, ensuring
• timely communication to targeted recipients and reducing manual effort.
• Created tables, views, sequences, synonyms, and other database objects in line with project
• requirements, ensuring data integrity and implementing appropriate security controls and access
• permissions.
• Utilized Snowflake warehouses strategically, using high-scaled (Large/XL) warehouses only for timeconsuming, complex processes, while optimizing smaller warehouses for routine workloads to balance
• performance and cost-efficiency.

Dec 2021 – Nov 2022 · 11 mos

• Managed IT returns processing at the Central Processing Centre, designing PL/SQL procedures with multithreading to processlakhs ofreturns in parallel, ensuring smooth, accurate, and timely handling of complex
• returns.
• Utilized advanced PL/SQL concepts such as PRAGMA AUTONOMOUS_TRANSACTION, BULK COLLECT, and
• FORALL (bulk binding) for debugging and faster computation, improving transaction efficiency by 30%.
• Created anonymous blocks and patches in coordination with clients to prioritize returns, resolved technical
• incidents, and supported emergency patches to maintain uninterrupted operations.
• Worked extensively with Oracle objects including tables, views, cursors, indexes, constraints, procedures,
• functions, packages, and temporary tables.
• Conducted unit testing and Business Acceptance Testing (BAT), and deployed required changes successfully.
• Managed data migration and backups using expdp and impdp, and scheduled programs to ensure seamless
• processing.
• Implemented error-handling and logging mechanisms within PL/SQL code to enhance maintainability and simplify
• troubleshooting.
• Implemented error-handling mechanisms within PL/SQL code to enhance maintainability.
• Created loggingmechanismsto simplify troubleshooting and track execution outcomes.