Shilpa Shah profile photo 1 on Tal

Shilpa Shah

Database Tech lead | Oracle Pl/SQL | UNIX | Migration| Insurance| Telecom Domain

Ahmedabad

14+ years of work experience

Tata Consultancy Services
Jan 20242 yrs 7 mosPresent

Ahmedabad, Gujarat, India

Tata Consultancy Services
Nov 20205 yrs 9 mosPresent

Lead a data migration project, owning key decisions on data movement strategy and data-loss mitigation. Coordinate directly with clients to capture business requirements; Developed PL/SQL scripts for regulatory changes and optimize existing queries for improved performance. Create and optimize Stored Procedures, Functions, Packages, Triggers, and SQL scripts. Translate business requirements into Technical specifications and solutions,Unit Test Cases, and AMS Handover documents. Collaborate with Infrastructure, DBA, Integration, and Business teams. Conduct code reviews and ensure adherence to development standards. Troubleshoot and resolve production issues within SLA timelines.
Tata Consultancy Services
Jun 20184 yrsMay 2022

Tata Consultancy Services
Jun 201510 mosMar 2016

Transformed source files into formats consumable by AML Fortent 7.0 for anti-money-laundering processing and data monitoring. Built shell scripts to ingest data from multiple sources and load it into database tables. Monitored UNIX batch jobs processing ~1 year of day-minus-1 incremental data.
Wipro
Sep 20131 yr 10 mosJun 2015

Developed quality SQL, PL/SQL, and UNIX shell code; handled debugging, troubleshooting, application support, and development. Created tables, cursors, procedures, functions, views, constraints, and indexes; loaded data via SQL*Loader. Configured and monitored Oracle GoldenGate, replicating multiple tables from source to target databases. Automated backups, instance start/shutdown, and SQL execution via shell scripts scheduled with CRONTAB. Handled CR/BRPF deployments and provided post-deployment support on live production environments.
Wipro
Aug 20104 yrs 11 mosJun 2015

India

• Optimizing SQL Query to improve the performance • Involved in DB maintenance activity like Database purging, Table Space management, index rebuild, stats gather, Partition creation, Memory management etc. • Troubleshooting in Oracle Golden Gate. • Team handling and working with escalated issues, Interacting with customer for Requirements Analysis
Wipro
Sep 20103 yrs 1 moSep 2013

Developed and Supported CDS application Where I was responsible to ,maintain proper data loading using Golden Gate and UNIX Scripts scripts and fix issue if occurs, smooth generation of Business Reports using PL/SQL, UNIX scripts. Monitored and maintained GoldenGate for real-time data integration. Tuned SQL queries to improve response times; created and maintained reports in OBIEE, PB. Resolve production issues spanning report data quality and data loading. Performed integration testing, defect analysis, and fixes.

Education

Btech, computer science

KSOU

20111 yr2012
ACM RGTU

Polytechnic, Computational Science

ACM RGTU

Join Shilpa and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Shilpa Shah on Tal

Headline

Database Tech lead | Oracle Pl/SQL | UNIX | Migration| Insurance| Telecom Domain

About

Oracle PL/SQL Developer with 14 years of progressive IT experience with a sound background of Oracle Database, SQL, PL/SQL, UNIX shell scripting and Oracle Golden -gate 11g. Have worked on SRS , LLD , HLD and BRPF. Modifying existing programs with enhancements. Expertise in requirement analysis, designing, developing, implementing and executing a project.

Location

Ahmedabad

Work experience

Associate Consultant at Tata Consultancy Services, Jan 2024 - Present · 2 yrs 7 mos, Ahmedabad, Gujarat, India

PL/SQL Developer at Tata Consultancy Services, Nov 2020 - Present · 5 yrs 9 mos, Lead a data migration project, owning key decisions on data movement strategy and data-loss mitigation. Coordinate directly with clients to capture business requirements; Developed PL/SQL scripts for regulatory changes and optimize existing queries for improved performance. Create and optimize Stored Procedures, Functions, Packages, Triggers, and SQL scripts. Translate business requirements into Technical specifications and solutions,Unit Test Cases, and AMS Handover documents. Collaborate with Infrastructure, DBA, Integration, and Business teams. Conduct code reviews and ensure adherence to development standards. Troubleshoot and resolve production issues within SLA timelines.

IT Analyst at Tata Consultancy Services, Jun 2018 - May 2022 · 4 yrs

Unix Developer at Tata Consultancy Services, Jun 2015 - Mar 2016 · 10 mos, Transformed source files into formats consumable by AML Fortent 7.0 for anti-money-laundering processing and data monitoring. Built shell scripts to ingest data from multiple sources and load it into database tables. Monitored UNIX batch jobs processing ~1 year of day-minus-1 incremental data.

PL/SQL Developer at Wipro, Sep 2013 - Jun 2015 · 1 yr 10 mos, Developed quality SQL, PL/SQL, and UNIX shell code; handled debugging, troubleshooting, application support, and development. Created tables, cursors, procedures, functions, views, constraints, and indexes; loaded data via SQL*Loader. Configured and monitored Oracle GoldenGate, replicating multiple tables from source to target databases. Automated backups, instance start/shutdown, and SQL execution via shell scripts scheduled with CRONTAB. Handled CR/BRPF deployments and provided post-deployment support on live production environments.

Software Engineer at Wipro, Aug 2010 - Jun 2015 · 4 yrs 11 mos, India, • Optimizing SQL Query to improve the performance • Involved in DB maintenance activity like Database purging, Table Space management, index rebuild, stats gather, Partition creation, Memory management etc. • Troubleshooting in Oracle Golden Gate. • Team handling and working with escalated issues, Interacting with customer for Requirements Analysis

PL/SQL Developer at Wipro, Sep 2010 - Sep 2013 · 3 yrs 1 mo, Developed and Supported CDS application Where I was responsible to ,maintain proper data loading using Golden Gate and UNIX Scripts scripts and fix issue if occurs, smooth generation of Business Reports using PL/SQL, UNIX scripts. Monitored and maintained GoldenGate for real-time data integration. Tuned SQL queries to improve response times; created and maintained reports in OBIEE, PB. Resolve production issues spanning report data quality and data loading. Performed integration testing, defect analysis, and fixes.

Education

Btech, computer science, KSOU

Polytechnic, Computational Science, ACM RGTU