Looking for a job

Swetal Parmar

@swetalparmar

Message

Oracle Database Developer at Citi Bank who automated data patching and built an AI-driven SQL utility.

India

Message

At Citi Bank, I integrated Devin, Stylus, and Copilot into data patching workflows, reaching 70% automated code generation and reducing effort per activity from seven days to three. I also developed SQL Genie, an internal tool that turns natural-language prompts into optimized SQL queries.

I engineered a Python testing framework for database changes that cut manual QA and test execution effort by 85%. I also applied Oracle Advanced Compression and partitioning to historical data warehouse tables, reclaiming 56 TB of space.

Earlier, I converted legacy Informatica ETL logic to Oracle PL/SQL at Barclays and developed database systems for GDPR applications at Wipro. I'm currently pursuing an Executive Post Graduate Programme in Applied AI and Agentic AI at IIITB, Bangalore, while upskilling in Azure data engineering.

Experience

Work history, roles, and key accomplishments

Current

Officer (C11)

Current

Citi Bank

Sep 2024 - Present (2 years 1 month)

Led L3 team of 7 engineers managing end-to-end data patch lifecycle, integrating GenAI platforms to achieve 70% automated code generation and reduce effort from 7 days to 3 days per data patch activity, saving $750K. Engineered automated Python testing framework cutting manual QA effort by 85% and executed Oracle Advanced Compression and partitioning strategy reclaiming 56 TB of space.

Regulatory Reporting Analyst

Barclays

Jul 2022 - Aug 2024 (2 years 1 month)

Led comprehensive database migration converting legacy Informatica ETL logic to high-performance Oracle PL/SQL across 50+ financial products. Managed and mentored 8-person engineering team, engineered regulatory reporting frameworks with Axiom ControllerView for Singapore compliance, and maintained automated batch infrastructure using UNIX Shell Scripting and Autosys.

Pl SQL Informatica AxiomSL ControllerView (CV10)UNIX Shell Scripting Autosys Regulatory Reporting Team Leadership Mentorship Compliance Batch Processing

Senior Lead Engineer (Product)

FIS

Apr 2020 - Jun 2022 (2 years 2 months)

Spearheaded SQL and PL/SQL performance optimization using AWR, ADDM, and ASH diagnostics, implemented Oracle table partitioning, and tuned heavy transactional queries. Developed high-priority stored procedures, architected core database schemas, and delivered L3 production support in high-availability banking environments.

Oracle SQL Pl SQL Performance Optimization AWR ADDM ASH Table Partitioning Stored Procedures UNIX Shell Scripting SQL*Loader Production Support Banking

Database Developer L1 (Client: Aviva)

Wipro

Aug 2015 - Mar 2020 (4 years 7 months)

Developed and maintained complex database systems for GDPR applications, optimized SQL queries for performance, and created interactive Oracle APEX forms and dashboards. Collaborated with stakeholders to gather and analyze data requirements.

Oracle SQL Pl SQL Oracle APEX Database Optimization GDPR Stakeholder Management