Sql Developer Technical Lead

Name: Anupama Shenoy

Phone: +1-562-***-**** Email: ***********@*****.***

Professional Summary: 15+ years of progressive experience as an Oracle PL/SQL Developer and Technical Lead, specializing in the analysis, design, development, optimization, and maintenance of enterprise-scale business applications using Oracle RDBMS across diverse domains, including retail, banking, airline operations, and customer loyalty programs.

Delivered end-to-end SDLC ownership from requirements gathering, system analysis, and database design to coding, testing, deployment, and production support, ensuring high-quality deliverables within aggressive timelines while improving release predictability.

Expert in database architecture design using data flow diagrams (DFD), normalization techniques, entity-relationship modeling (ERD), and data dictionaries, delivering scalable, maintainable, and high-performance database systems.

Proficient in developing and maintaining complex Oracle database objects such as tables, views, materialized views, indexes (B-Tree, Bitmap, function-based), triggers, synonyms, and sequences to support high-volume transactional and analytical systems.

Applied advanced Oracle features, including table partitioning, analytical functions, collections, and query rewrite to optimize query execution times, reduce system latency, and enhance application performance.

Spearheaded database code optimization initiatives, refactoring SQL and PL/SQL logic to reduce report generation runtimes by 99%, significantly improving data availability for decision-makers.

Highly skilled in Oracle database versions 19c, 12c, 11g, 10g, 9i, and 8i, with hands-on expertise in PL/SQL, SQL Developer, TOAD, and Pg Admin.

Adept at leveraging performance tuning utilities such as EXPLAIN PLAN, SQL Trace, TKPROF, and AWR reports to identify bottlenecks and implement best-practice optimizations.

Designed, implemented, and optimized ETL workflows using Ab Initio and other ETL tools to support large-scale Data Warehouse (DWH) integrations, reducing batch processing time by up to 30% while ensuring data accuracy.

Led data migration projects utilizing Oracle External Tables, SQL*Loader, Import/Export, and bulk/batch processing techniques, guaranteeing seamless migration with zero data loss and minimal downtime.

Experienced in DBA-related activities, including user account management, privilege control, backup strategies, and database security policies, ensuring high system availability and compliance.

Expertise in UNIX and AIX environments, leveraging shell scripting and automation to streamline operational tasks, enhance system monitoring, and support incident resolution.

Well-versed in ETL processes, large-scale data exports/imports, and enterprise reporting, generating actionable insights through tools like Tableau, IBM Cognos, TOAD, and SQL Developer.

Skilled in dimensional modeling techniques such as Star Schema and Snowflake Schema for analytical reporting, and experienced in designing ER diagrams using tools like TOAD and Microsoft Visio.

Authored comprehensive technical design documentation, unit test cases, and solution architecture diagrams, ensuring code maintainability, scalability, and reusability for long-term support.

Proficient experience on Python for data manipulation, automation scripting, and process optimization, with a commitment to continuous learning through hands-on project work.

Recognized for strong leadership and communication skills, mentoring junior developers, fostering cross-functional collaboration, and bridging the gap between development, QA, DevOps, and business stakeholders to ensure alignment with organizational goals.

Proven track record of delivering secure, high-performance, and business-critical solutions in Agile and Waterfall environments, consistently meeting compliance, scalability, and performance benchmarks.

Education and Certification:

Masters in Software Systems, Birla Institute of Technology and Science, Pilani, India.

Bachelors in Biotechnology, Nitte Maha Linga Adyanthaya Memorial Institute of Technology, Nitte, India.

Advanced Databases and SQL Querying

ICAgile Product Owner

Technical Skills:

Core Competencies

Agile Project Management (Scrum, SAFe), Cross-Functional Stakeholder Collaboration, Data Platform Strategy & Modernization, Data Pipeline & ETL Optimization (RESTful & 3rd Party APIs), Data Storytelling & Visualization, Engineering & Delivery Leadership, Risk & Compliance Management (PCI, Migration), Coaching & Mentoring, Customer Focus, Innovation Management, Multitasking & Project Execution

RDBMS

Oracle SQL, PL/SQL, Performance Tuning, DBMS Concepts, SDLC, Agile

ETL Tools

Ab Initio, SQL*Loader, External Tables, Global Temporary Tables (GTT), ETL Process Development, Data Migration & Integration

Data Visualization & Reporting

Tableau, IBM Cognos

Programming Languages

Pro*C, Unix Shell Scripting, Python, Object-Oriented Programming, Oracle PL/SQL

Operating Systems

Windows, Linux, Unix

Development & Deployment Tools

SQL Developer, TOAD, Visual Studio, vi Editor, Anaconda, Oracle APEX, Job Control Tools (JCL, Control-M, Autosys, cron), API Integration with PL/SQL, Git, GitHub Actions, TFS, SVN, Putty

Other Tools

MS SQL Studio, Toad for Data Analysis, ServiceNow, Remedy, WinSCP, Jira, Confluence

Domain Expertise

Banking & Finance, Cards & Payments, Retail, Warehouse, Airport Baggage

Professional Experience:

Client: Citigroup Inc., Irving, Texas May 2025 – Present

Role: Oracle PL/SQL Developer / Technical Lead

Project Description: Working as a lead Oracle PL/SQL Developer within Citigroup’s enterprise banking data management platform, responsible for designing, optimizing, and maintaining high-performance database solutions supporting critical financial operations. The role involves modernizing legacy PL/SQL codebases, enhancing query performance, ensuring data integrity, and providing production support for mission-critical applications in a highly regulated financial environment. Leveraging Oracle RDBMS, advanced PL/SQL programming, performance tuning, and database optimization techniques to ensure high availability, scalability, and compliance with corporate data governance standards.

Key Roles & Responsibilities:

Designed, developed, and deployed high-performance PL/SQL stored procedures, functions, triggers, and packages to streamline core financial workflows, ensuring optimal execution times and reduced system latency.

Optimized complex SQL queries through execution plan analysis, Oracle Hints, indexing strategies, and Ref Cursor utilization, resulting in significant performance gains across high-volume transaction systems.

Led legacy codebase refactoring, implementing modular and reusable PL/SQL components that improved maintainability, reduced technical debt, and aligned with modern Oracle development best practices.

Worked extensively with collections, temporary tables, and cursor management to efficiently handle bulk data operations and improve transaction throughput.

Conducted comprehensive performance tuning using EXPLAIN PLAN, TKPROF, and Oracle diagnostic tools to proactively identify and resolve bottlenecks in database processing.

Developed and implemented data validation frameworks ensuring integrity, accuracy, and compliance during ETL processes and database transactions.

Performed routine database maintenance including index rebuilds, table reorganizations, and statistics gathering to sustain peak database performance and minimize downtime.

Provided 24/7 production support for critical incidents, troubleshooting PL/SQL code, query performance issues, and database availability problems to maintain uninterrupted banking operations.

Collaborated closely with application developers, business analysts, and infrastructure teams to design efficient database schemas, optimize SQL joins, and align data models with business needs.

Authored detailed technical documentation, code comments, and user guides, enabling efficient knowledge transfer and adherence to Citigroup’s software development lifecycle (SDLC) and compliance standards.

Executed database health checks, performance audits, and capacity planning to ensure scalability and readiness for increased transaction volumes.

Leveraged Agile/Scrum methodologies and version control (Git) for efficient development cycles, change management, and controlled deployments.

Coordinated cross-functional integration with upstream and downstream applications, ensuring smooth data flow across multiple banking platforms.

Environment: Oracle 19c, Oracle RDBMS, PL/SQL, SQL*Plus, TOAD, SQL Developer, Ref Cursor, Collections, Temporary Tables, Explain Plan, Hints, TKPROF, Unix/Linux Shell Scripting, Git, Agile/Scrum, SDLC, Data Validation Frameworks, Performance Tuning, Indexing, Table Partitioning.

Client: Commonwealth Bank of Australia, Bangalore, India July 2022 – March 2025

Role: Oracle PL/SQL Developer-Lead

Project Description: Contributed to the design, development, optimization, and maintenance of enterprise-scale Oracle database solutions for high-volume banking applications. Led automation initiatives to improve operational efficiency, database performance, and reporting accuracy. The role encompassed full SDLC involvement, from requirements gathering and solution design to development, performance tuning, and deployment, within an Agile onsite–offshore delivery model.

Key Roles & Responsibilities:

Participated in the end-to-end software development lifecycle, including requirement analysis, solution design, database development, testing, and implementation.

Designed, developed, and maintained Oracle PL/SQL database objects, including tables, views, indexes, materialized views, constraints, triggers, functions, procedures, and packages to implement complex business logic.

Developed and optimized complex SQL queries involving joins, subqueries, analytical functions, hints, and query rewrite for operational and client-specific reporting.

Designed data loading solutions to import large datasets from CSV files into Oracle databases using PL/SQL procedures, improving data ingestion reliability and reducing manual intervention.

Implemented table partitioning (range partitioning) and indexing strategies to enhance query performance and manage large-scale datasets efficiently.

Utilized Oracle-supplied packages such as DBMS_SQL, DBMS_JOB, and UTL_FILE for scheduling jobs, file processing, and dynamic SQL execution.

Conducted database performance tuning using Explain Plan and AWR reports, achieving up to 90% improvement in query execution times. Spearheaded the Risk Insite Program, automating data extraction workflows with PL/SQL and Shell scripting, increasing process efficiency by 30%.

Created materialized views and query rewrite mechanisms to optimize reporting and analytics.

Collaborated with cross-functional teams, including QA, DevOps, and business stakeholders, ensuring alignment between database solutions and business objectives.

Applied collections, table functions, and analytical functions to improve query flexibility and reduce processing times. Reviewed and refactored legacy PL/SQL code to improve maintainability, performance, and adherence to best practices.

Worked extensively in an onsite–offshore model, managing client interactions, clarifying requirements, and ensuring timely delivery of enhancements and bug fixes.

Fostered a culture of continuous improvement by mentoring team members on advanced PL/SQL programming, performance tuning techniques, and database best practices.

Environment: Oracle 12c/19c, PL/SQL, SQL Developer, Explain Plan, AWR Reports, Materialized Views, Table Partitioning, DBMS_SQL, DBMS_JOB, UTL_FILE, Collections, Analytical Functions, Shell Scripting, Agile, JIRA, Confluence, Unix/Linux.

Client: Epsilon, Bangalore, India July 2016 – July 2022

Role: Sr. Oracle PL/SQL & ETL Developer

Project Description: Led the design, development, optimization, and delivery of enterprise-scale Oracle PL/SQL and ETL solutions for large-volume transactional and analytical systems, including Citi Bank’s Global Rewards Program. The role involved building high-performance ETL workflows, optimizing Oracle database processes, modernizing legacy systems, and delivering secure, compliant, and scalable data-driven solutions. Operated in an Agile cross-functional environment, collaborating with QA, DevOps, and product teams to ensure high-quality releases with zero downtime and compliance to PCI standards.

Key Roles & Responsibilities:

Participated in functional and technical design sessions, translating business requirements into scalable database and ETL architecture.

Created application design specifications, implementation guides, and reusable database components to standardize coding practices and improve maintainability.

Designed, configured, and managed Oracle databases and schemas for new applications, ensuring optimal storage structures and indexing strategies.

Developed advanced PL/SQL stored procedures, functions, and packages to dynamically perform operations such as TRUNCATE, DROP, PARTITION, and data statistics gathering.

Performed large-scale data loading and migration using SQL Loader, TOAD, and DML scripts, validating data integrity post-load through automated SQL validation scripts.

Built and optimized Ab Initio ETL workflows for Data Warehouse integration, improving processing efficiency by 30% and enabling timely analytics.

Designed scalable ETL pipelines handling massive datasets, optimizing Oracle DB performance to reduce batch processing time from 17.5 hours to under 1 second.

Delivered real-time and batch data solutions for Citibank’s Global Rewards Program, eliminating a 10-day data lag and improving customer satisfaction through timely rewards availability.

Led legacy system migration from SAS to SQL, enhancing reporting speed, data accessibility, and analytical capabilities.

Directed critical security and infrastructure modernization projects, including PCI key rotation and RHEL server migration, reducing PCI rotation time from 2 weeks to 2 days while ensuring full compliance.

Coordinated with QA and DevOps teams to automate release components, streamline deployments, and ensure smooth server migrations.

Oversaw code quality reviews, architectural decisions, and delivery timelines, mentoring junior developers on PL/SQL best practices, ETL optimization, and secure coding standards.

Designed and developed interactive Tableau dashboards and reports by blending multiple data sources (Oracle, Excel, etc.), producing both static outputs (Excel, PDF, Image) and interactive TWB/TWBX visualizations.

Implemented various data visualizations, including crosstab reports, bar charts, stacked bar charts, forecasts, trend lines, doughnut charts, pie charts, and bull’s-eye charts for business intelligence.

Collaborated with business analysts and product owners to define data requirements, create testable acceptance criteria, and enable data-driven decision-making.

Documented requirements, code enhancements, and error-handling logic for maintainability and future scalability.

Environment: Oracle 12c, PL/SQL, SQL Loader, TOAD, Ab Initio, ETL Pipelines, Table Partitioning, SQL DML, Stored Procedures, Functions, Packages, Tableau, Data Blending, Unix/Linux, Shell Scripting, RHEL, PCI Compliance, Agile, JIRA, Confluence.

Client: Oracle, Bangalore, India April 2012 – July 2016

Role: Senior Software Engineer – Oracle Retail Solutions

Project Description: Contributed to Oracle Retail product development and customer support by designing and delivering self-service troubleshooting tools, resolving high-priority production defects, and implementing enterprise-grade enhancements for large retail clients. Drove initiatives that improved SLA compliance, support turnaround time, and code reusability, while ensuring zero downtime deployments for mission-critical retail operations.

Key Roles & Responsibilities:

Led the development of the Rx Diagnostics Module, a self-service troubleshooting platform that reduced support turnaround times by 25%, enabling proactive issue prioritization for production teams.

Designed and implemented reusable PL/SQL libraries, solution templates, and standardized troubleshooting components to accelerate defect resolution and improve maintainability.

Delivered expert-level support for high-profile clients including Macy’s, Walmart, and Costco, diagnosing and resolving critical production defects in Oracle Retail applications.

Collaborated cross-functionally with QA, DevOps, and Product Management to ensure seamless deployment of bug fixes, enhancements, and patches without service disruptions.

Optimized SQL queries and PL/SQL procedures for performance, leveraging execution plan analysis and indexing strategies to maximize resource efficiency.

Authored technical documentation, including architecture diagrams, implementation guidelines, and troubleshooting workflows, reducing onboarding time for new engineers.

Mentored and coached a team of 5 engineers, conducting code reviews, knowledge transfer sessions, and training workshops, improving onboarding efficiency and productivity.

Operated in Agile and customer-facing environments, gathering requirements, communicating project status, and ensuring on-time delivery of enhancements and fixes.

Environment: Oracle Retail Suite, Oracle 11g/12c, PL/SQL, SQL Developer, Unix/Linux, Agile, Jira, Confluence

Client: MindTree, Bangalore, India September 2011 – April 2012

Role: Senior Software Engineer – Airline Baggage Tracking System

Project Description: Enhanced and modernized an airline baggage tracking and notification system built on Oracle PL/SQL and Oracle Forms & Reports, delivering real-time tracking accuracy, proactive customer updates, and 40% faster baggage turnaround. The modernization significantly reduced lost luggage incidents, improving customer satisfaction and operational efficiency for airline clients.

Key Roles & Responsibilities:

Enhanced core baggage tracking modules using Oracle PL/SQL, Forms, and Reports, enabling end-to-end bag tagging, scanning, and status updates across multiple airport locations.

Developed and optimized PL/SQL procedures, triggers, and functions to process high-volume tracking data with reduced processing time and improved accuracy.

Integrated real-time scanning data with operational databases, enabling instant updates for both customers and airline ground staff.

Built dynamic Oracle Reports for baggage status summaries, lost luggage metrics, and performance analytics, supporting data-driven operational decisions.

Implemented automated SMS/email notification workflows for key baggage events (check-in, loading, transfers, arrival), enhancing customer engagement.

Conducted SQL query tuning using Explain Plan and indexing strategies to boost performance during peak travel seasons.

Partnered with business analysts and airline operations teams to align solutions with IATA baggage handling standards.

Maintained comprehensive system documentation, change logs, and troubleshooting guides to ensure operational continuity.

Participated in production deployments and post-go-live support, ensuring zero service disruption during release cycles.

Environment: Oracle 11g, PL/SQL, Oracle Forms & Reports, SQL Developer, Unix/Linux, Explain Plan, Agile, Jira, Airline Operations Systems

Client: Tesco, Bangalore, India November 2009 – September 2011

Role: Software Engineer – Oracle Retail & Backend Systems Integration

Project Description: Played a pivotal role in Tesco’s first cross–business unit product migration, integrating backend systems beyond the Oracle Retail suite to enhance supply chain and sourcing operations. Delivered scalable backend solutions that streamlined supplier onboarding, optimized logistics workflows, and contributed to a $300M profit increase through improved operational efficiency.

Key Roles & Responsibilities:

Led backend development efforts to ensure smooth data integration and interoperability across multiple business divisions during the migration.

Designed and developed PL/SQL stored procedures, functions, packages, and triggers to manage supplier data processing, product catalog integration, and inventory synchronization.

Integrated sourcing systems with the Oracle Retail Suite and external vendor platforms, reducing supplier onboarding time and minimizing process bottlenecks.

Built ETL scripts and data migration workflows for transferring large datasets between legacy systems and the new platform, ensuring data accuracy and integrity.

Implemented table partitioning, indexing strategies, and optimized SQL queries to handle high-volume transactions with improved scalability.

Collaborated with supply chain managers and logistics teams to capture requirements and design technical solutions aligned with business goals.

Created automated validation scripts to verify data consistency before production integration.

Conducted integration testing with QA teams, validating system compatibility, performance, and stability.

Performed performance tuning using execution plan analysis and AWR reports to identify and resolve bottlenecks.

Developed operational dashboards and Oracle Reports for supplier onboarding metrics, logistics cost tracking, and migration status.

Documented integration processes, migration workflows, and backend architecture for future scalability.

Environment: Oracle 11g, PL/SQL, SQL Developer, Oracle Retail Suite, ETL Scripts, Unix/Linux, Explain Plan, AWR, Agile, Jira, Confluence, Supply Chain Systems

Contact this candidate