ETL, PLSQL Develope,r Data Engineering

Visruthi Thummala

***********@*****.*** 940-***-****

Professional Summary:

Highly experienced PL/SQL Developer with 10+ years of success in database development and data engineering across Pharmacy, Insurance, Finance, and Trading domains.

Specialized in Oracle-based systems with strong expertise in PL/SQL programming, performance tuning, ETL processes, Prod support and data replication strategies.

Proven ability to manage full SDLC and support high-volume transactional systems.

Core Competencies:

PL/SQL, SQL, Dynamic SQL, Ref Cursors, Materialized Views, Triggers, Sequences, Indexes, T-SQL

SQL*Loader, Data Warehousing, ETL, Performance Tuning (EXPLAIN PLAN, TKPROF, AUTOTRACE)

Big Data Concepts, GoldenGate Data Replication, DataStage migration

Scripting: UNIX Shell, Perl, JavaScript

Scheduling Tools: DBMS_SCHEDULER, Autosys, CAWorkloadAutomation, UC4, Cron

Tools: TOAD, SQL Developer, Informatica, Oracle Reports, Putty/MobaXterm, Jenkins, Git, SourceTree, Jira

Oracle 19c/12c/11g, SQL Server, MySQL, Sybase

PROFESSIONAL EXPERIENCE

Conduent – Remote

ETL/PLSQL Developer Apr 2023 – Jul 2025

MA-PBM (Pharmacy Benefit Management)

Migrated legacy warehouse to a new EIM architecture, consolidating source systems for reporting.

Designed and implemented PL/SQL packages, functions, and procedures for transformation logic.

Built job automation with DBMS_SCHEDULER and Cron jobs for daily/weekly/monthly runs.

Optimized SQL scripts to handle large volumes of pharmacy claims data.

Involved in Production support, reviewing, and fixes.

Environment: Oracle 19c, Toad, UNIX/Putty/MobaXterm, SVN.

Fidelity Investments – Remote

Sr. Database Developer Mar 2020 – Apr 2023

HOBS (Health & Other Benefits System)

Developed and maintained complex PL/SQL codebase for participant benefit systems.

Generated eligibility extracts with dynamic packages.

Automated file creation in Delimited formats.

Engaged in sprint planning, on-call PROD support.

Collaborated with cross-functional teams on Business requirements, data refreshes, and QA cycles.

Environment: Oracle 19c, Toad, Eclipse/Java, Git/Bitbucket/SourceTree, Confluence, Jira.

DTCC (Depository Trust & Clearing Corp) – Dallas, TX

PL/SQL Developer Jan 2018 – Feb 2020

It is a financial market that provides clearing, settlement, and trade reporting services.

Engineered procedures and packages to process settlement and equity data.

Enabled Java-triggered Oracle procedures through cursor-based processing.

Set up GoldenGate for real-time data replication across transactional databases.

Worked on DataStage integration tool to move data from Sybase to Oracle.

Involved in performance tuning, deployments, and AutoSys job setups.

Environment: Oracle 12c, GoldenGate, Sybase, Autosys, Informatica,DataStage, Bitbucket.

Societe Generale – Chicago, IL

Oracle Database Developer Jun 2014 – Apr 2017

Dolce AMI (Advanced Model Indicator) - is a French multinational banking and financial services company.

Designed PL/SQL-based extracts for financial and market risk data.

Used SQL/XML functions for creating structured XML reports.

Scheduled daily/monthly jobs via UC4; implemented FTP-based file drops.

Performed sub-partitioning and TOAD-based tuning.

Environment: Oracle 11g, SQL Server, TOAD, UC4, WinSCP.

Thomson Reuters – Eagan, MN

Software Programmer Jun 2013 – May 2014

FindLaw - is vendor-based application for attorneys to increase search ratings and traffic to their website.

Developed PL/SQL procedures for auto-publishing legal content to client websites.

Migrated flat/XML files into Oracle tables using SQLLDR and Perl scripts.

Performed SQL tuning using DBMS_SQLTUNE and TKPROF.

Environment: Oracle 11g, Eclipse/Java, UNIX, Axway Synchrony, Jira.

Osmania University – Hyderabad, India

Jr. Software Engineer Sep 2007 – May 2011

PGRRCDE - Built .NET-based web forms for university administration system.

Developed VB.NET backend logic and ASP.NET UI for enrollment and exam processing.

Environment: SQL Server 2005, VB.NET, ASP.NET.

Education & Certifications

Bachelor of Computer Science and Engineering JNTU, India – May 2007

Oracle Certified SQL Associate (1Z0-051: Oracle 10g SQL Fundamentals)

Contact this candidate