Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Subrata Sarkar

Jersey City

Summary

Accomplished Senior Oracle PL/SQL Developer with extensive experience at Cigna Evernorth, excelling in performance tuning and multi-threading to reduce processing time by 84%. Proficient in Oracle APEX and Power BI, demonstrating strong analytical skills and problem-solving abilities. Adept at collaborating with teams to deliver innovative solutions and drive business success.

Overview

27
27
years of professional experience
1
1
Certification

Work History

Senior Oracle PL/SQL Developer/Analyst, Oracle APEX Developer

Cigna Evernorth
Jersey City
03.2025 - Current
  • Worked on development of multi-threading of PL/SQL Package ICGEN (Invoice generation) to reduce the processing time by 84%
  • Generated reporting dashboards for bank’s Regulatory Reporting metrics using Power BI
  • Responsible for developing and enhancing Forms 12 c and Reports 12c as per business requirements
  • Worked on fixing PROD issue of duplicate kit items
  • Worked on fixing PROD issue of SAVEON ODT task suppression
  • Tuned Long running PROD queries
  • Created Reports in Oracle APEX and PDF Printing with BI Publisher Desktop Plugin.
  • Upgrade complex Oracle Forms 12c to Apex 24.2
  • Upgrade complex Oracle Reports to Apex Reports with pdf printing with bi publisher desktop.
  • Extensive use of java script, CSS, AJAX, PL/SQL, Application Process and Dynamic Actions
  • Create Custom Authentication scheme for LDAP Authentication.

Senior Oracle PL/SQL Developer/Analyst

Citi Bank
Jersey City
04.2023 - Current
  • Responsible for performance tuning including optimizing queries and analyzing AWR reports
  • Generated reporting dashboards for bank’s Regulatory Reporting metrics using Power BI. This data warehouse has a size of 60TB.
  • Implemented Muti-threading in PL/SQL package to bring down the processing time from 40 mins to 2 mins.
  • Architecting/redesigning the data model to utilize Oracle Muti-tenant architecture by splitting the data based on client code for better performance and scalability.
  • Generate PL/SQL Reports for FSR (Fund Services Reporting) – Meta data and Stored Procedure
  • Involved in data loading using PL/SQL and SQL
  • Loader calling UNIX scripts to download and manipulate files.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL
  • TRACE, TKPROF and AUTOTRACE.
  • Developed wrapper in Python for instantiating multi-threaded application and running with other applications.
  • Development of testing framework using Python.
  • Worked with Oracle 19c and tuned DB Code for better performance – proactive and reactive.
  • Performed DB Table Shrink based on Recommendation of Oracle Segment Advisor
  • Used Oracle SQL Tuning Advisor for tuning poor performing SQLs
  • Implemented Auto DOP for overall DB Performance.
  • Used Github/Bitbucket for source code repository
  • Implemented Oracle In-Memory to enhance DB performance.
  • Utilized Autosys for scheduling
  • Created scripts to create new tables, views, queries for new enhancement in the application using SQL Developer Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Senior Oracle PL/SQL Developer/Analyst

Desjardins Bank
Charlotte
06.2020 - 04.2023
  • Participated in analysis of requirement and data for the new enhancements of the bank.
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Consume web services from PL/SQL
  • Creation of Oracle 12c database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL
  • Plus.
  • Partitioned the fact tables and materialized views to enhance the performance.
  • Extensively used bulk collection in PL/SQL objects for improving the performance.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Develop customization of J2EE product OBPM for Check Digit Validation and Stop Payment of checks.
  • Develop Java modules in J2EE product ELCM for Non-Revolving Special Line requirement – Coded for NEW, ALTER, INCREASE, DECREASE, REVERSE of Utilization for current dated and backdated transactions.
  • Develop the complex PL/SQL interface (packages and stored procedures) for integration of FCUBS 10.5 with ELCM 14.4 for Limits Utilization.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Design different types of screens(forms) & reports in Oracle APEX.
  • Extensive use of java script, CSS, AJAX, JQuery, Application Process and Dynamic Actions.
  • Use APEX_ITEM to create dynamic forms.
  • Google map integration with provision of storing marker persistently in the database and ability to add, delete, move marker with mouse click.
  • Customize apex tree to enable drag & drop feature and right click menu option.
  • Custom authentication and authorization.
  • Master with multiple details implementation using Interactive Grid.
  • Build Enterprise Reports using APEX integrated with BI Publisher and using AOP.
  • Build PDF reports using PL/SQL and APEX.
  • Creating and consuming RESTFUL webservices in Oracle APEX.
  • Create custom themes and templates for richer looking UI.
  • Incorporate Twitter Bootstrap theme in Oracle APEX Application for better look and feel.

Tech Lead

Northern Trust
Chicago
09.2019 - 06.2020
  • Analyzing AWRs and suggesting recommendation for handling performance tuning of EOD batches.
  • Implementing recommendations at site with great result – RESULT CACHE, PARALLEL DML, BULK COLLECT, FORALL with SAVE EXCEPTION, multi-threading, archiving, partitioning, pinning of better plan via dbms_spm, query optimization, index creation.
  • Improving batch timing from over 4 hours to 15 minutes.
  • Participating in Load Runner Stress Testing exercise with up to 500k/ Hour transaction load.
  • Analyzing the AWR, ASH, SQL Trace, TKProf, Alert Log, Trace Files to identify the bottlenecks and tune the batches and resolve issues.
  • Identifying memory leak and heaping usage in web logic middleware by analyzing JFR recordings and fix the issues related to memory leak in the Java code.
  • Participating in Load Testing of Rest URL (OBPM) through JMeter.

Senior Oracle Developer/ Analyst

Wells Fargo
Charlotte
09.2018 - 09.2019
  • Developed Advance PL/SQL packages, stored procedures, triggers, functions, Indexes and Collections to implement business logic.
  • Consumed web services in PL/SQL.
  • Built the Time Tracker application using Spring Boot and Thymeleaf also built web crawler application using Jsoup, Java Servlet, Hibernate and Oracle DB.
  • Developed Apache Camel and Spring Boot application to process data and generate message (parse and transform) to JMS Queue and read message from JMS Queue and populate Oracle DB Tables.
  • Developed custom MDB in JAVA to read from JMS Queue and deliver the messages to IBM MQ Topic using MQ Qalias which has target set to MQ Topic.
  • Work on customization of OBLM and OBVAM products in micro service-based architecture using Spring Boot, Spring Cloud Config Server, Feign, Netflix Eureka, Spring Cloud API Gateway, Zipkin, Rabit MQ, Docker, Kubernetes.
  • Installed and configured OBLM 14.2 in LAB which consisted of 16 database schemas and 7 web logic domains.
  • Installed Oracle 12c database in LAB; created multi-tenant database with two PDBs; Create 16 OBLM and 13 OBVAM Schemas in the PDBs.
  • Imported the offshore data dump to OBVAM Schema.
  • Patched the newly created database to latest released patch for Oracle 18c.
  • Installed OBIEE and configured BI Publisher in LAB also configured OBLM to use the BI Publisher to generate canned reports from OBLM.
  • Repointed OBLM application from 12c database to newly created 18 c database.
  • Applied new patch sets on the OBLM application in LAB.
  • OBLM application validation and follow-up with Engineering for the Bug Fixes.
  • Secured Wells Fargo Production database with Two Schema Approach.
  • Consolidated several OBIEE instances in one physical server with one FMW and BI for infrastructure improvement.
  • Analyzed defects raised in IUT and UAT environment and provide L0 support for FLEXCUBE and OBPM Product.

Technical Consultant

Citi Bank
Jersey City
07.2018 - 08.2018
  • Developed Advance PL/SQL packages, stored procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Created management analysis reporting using Parallel Queries, Java stored procedure, HTPP Package.
  • Consume web services from PL/SQL.

Oracle Developer/ Analyst

Oracle
India
06.2012 - 07.2018
  • Company Overview: Project: Flex cube Implementation
  • Gathered Business requirements and analyzed the existing and new data to support the new business data in the product.
  • Participated in upgrade of Flexcube Product from version 6.2.1 to 12.0 including setting up of both environment, data export and import, data enrichment, LD-CL migration and LM-ELCM migration.
  • Designed and developed Java and PL/SQL modules and java script for customization of the Flexcube Product as per client requirement.
  • Designed and developed FLEXCUBE screens using FCJ RAD Tool and custom JS.
  • Designed and implemented Java Code to resume/pause Flexcube quartz jobs through PL/SQL Layer.
  • Developed customization in Java for FLEXCUBE ELCM functionality.
  • Developed Java code on the Hook provided by engineering on the INFRA Layer to integrate ECA and Accounting from OBPM to FCUBS.
  • Worked as Technical Lead/ major contributor in design, architecture, database development and performance tuning of Oracle FLEXCUBE Product.
  • Optimized performance in a transaction-intensive real-time data feed in VLDB environments.
  • Handled extensive data mining/data cleanup; created /maintained ETL scripts to support variety of data sources.
  • Provided technical support and managed implementation of Oracle Flexcube Product.
  • Customized, handled performance tuning and application optimization, managed environment set up for Flexcube 12.0.2 including configuring and deploying on Web Logic server, Database configuration.
  • Installed Oracle 12c, created database, created schema, imported data dump, applied oracle patch set, and routine maintenance.
  • Architected and designed Oracle Golden Gate Replication for Active/Passive, Active/Active with transformation and filtering for Verizon.
  • Developed and implemented the business logic in Servlets/Java and using PL/SQL.
  • Managed performance tuning of FLEXCUBE implementation by optimizing the code and server-side tuning.
  • Analyzed AWR and tkproff reports to provide tuning recommendation and tune Database code (PL/SQL).
  • Configured Single-Sign-On in Flexcube with Oracle Access Manager, Web Gate, OID and OHS for Wells Fargo.
  • Implemented Fine Grained Access, Data Masking in FLEXCUBE using Oracle Virtual Private Database and Oracle Redaction for Bank of America.
  • Designed and architected log miner-based replication from hub to spoke schema for Wells Fargo.
  • Prepared and implemented technical roadmap for fast data load and unload from/ to Oracle database from/ to ASCII file for Bank of America.
  • Architected and developed multi-threading of CPG payment batch using partitioning for performance enhancement for Wells Fargo.
  • Participated in change and code reviews to understand the testing needs of the change components. Worked on trouble shooting defects in timely manner.
  • Involved in creating UNIX shell Scripting. De-fragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
  • Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
  • Extracted data from the XML file and loaded it into the database.
  • Designed and developed Oracle forms & reports generating up to 60 reports.
  • Performed modifications on existing form as per change request and maintained it.
  • Used Crystal Reports to track logins, mouse overs, click-through, session duration and demo graphical comparisons with SQL database of customer information.
  • Worked on SQL
  • Loader to load data from flat files obtained from various facilities every day.
  • Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding data from source to target data structures.
  • Involved in the continuous enhancements and fixing of production problems.
  • Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
  • Involved in data replication and high availability design scenarios with Oracle Streams.
  • Developed UNIX Shell scripts to automate repetitive database processes.
  • Built databases and table structures following n-tier architecture methodology for web applications.
  • Analyzed and designed relational databases using ER Studio and Erwin Data Model tool.
  • Formulated SQL queries, functions and processes as per customization requirement for APEX.
  • Supported APEX applications and conducted performance tuning for PLSQL.
  • Contributed with database designs and assisted in increasing response time for APEX reports.
  • Designed application framework and developed Oracle APEX Application.
  • Involved in writing database procedures, functions and packages for Front End Module.
  • Used principles of Normalization to improve the performance.
  • Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of.
  • Provided APEX guidance and support to technical staff on application maintenance and SDLC process.
  • Project: Flex cube Implementation

Oracle Database Architect

Mobile 365 Inc
Singapore
10.2010 - 06.2012
  • Architected, designed, and developed the reporting infrastructure for custom reporting.
  • Architect, design and implemented the data encryption and archiving of the operational database.
  • Environment – Oracle 10.2 (10g)/ 9.2.0 (9iR2) on Sun Solaris, Oracle Portal, WebDB; PL/SQL Web Toolkit PL/SQL, UNIX Shell Scripting, Sql Server 2008.

Oracle Developer/ Data Modeler

Ricoh Share Reporting
India
12.2007 - 10.2010
  • Tasked with understanding the core requirements of the Data warehouse and Reporting Data mart from Siebel (Organization, Agreement, Entitlement, Service Asset, Service Request and Activity) and Oracle application 11.5 (Order Management, AR, AP, PO, GL, Contract) data sources.
  • Environment – Oracle 10.2 (10g)/ 9.2.0 (9iR2) on AIX, PL/SQL, Unix Shell Scripting, Data Stage, Rational Data Architect, Cognos.

Oracle Consultant

ABN AMRO
UK
07.2006 - 12.2007
  • Managing and Administering over 30 Databases hosted on different flavors of UNIX O/S like AIX, Redhat Enterprise Linux, etc; Managing ASM/RDBMS Instances, Real Application Clusters, User, Object and Database Space Management; Managing Backup and Recovery with RMAN; Working on Database Patching and Upgrade, Database refresh, Cloning of Database, Database Decomposition and finally Troubleshooting different kind of Database issues.
  • Environment - Oracle 9.2.0 (9iR2) on Sun Solaris (5.9), PL/SQL, Unix Shell Scripting, Informatica, Autosys, Erwin, Business Objects.

Corporate Trainer

IBM
05.2006 - 07.2006
  • Provide technical training to the new joiners at IBM on Oracle DBA.
  • SQL, PL/SQL, Unix and Developer Suite.
  • Total no of participants :40.
  • The assignment also included preparation of training material, case study, hand-on exercise and evaluation of the trainees.

Oracle DBA

AXA DIRECT Japan
Kolkata
10.2004 - 04.2006
  • Oracle DBA - Maintenance of production database and development database which includes table space management, user creation, privileges, roles etc., Tracing, troubleshooting with database performance and tuning issues.
  • Export/Import of oracle databases.
  • Tuning SQL queries.
  • Development of PL/SQL code for implementation of the business logic for the project requirement.
  • Develop new annuity products, improve existing products with new rider features, and be involved in production support for the annuity policy administration system, Transcend.

Corporate Trainer

DSP
09.2004 - 10.2004
  • Provide technical training to the EDP team of DSP(Durgapur Steel Plant) at client location on Oracle DBA, PL/SQL and Developer Suite.
  • Total no of participants :15.
  • The assignment also included preparation of training material, case study, hand-on exercise and evaluation of the trainees.

Oracle DBA

AIG Sun America.
California
06.2000 - 09.2004
  • Production and Development DBA - Chiefly responsible for effective management of multi terabyte of Database, Oracle High Availability (RAC and Data Guard), Backup and Recovery (RMAN), Disaster Recovery, Performance Tuning, Capacity planning.
  • Environment - Oracle 8.1.7 (8i)/ 9.2.0 (9iR2), SQL Server 2000, Oracle Reports 6i, PL/SQL, Java, SQL
  • Loader, Perl 5, ASP .NET 2003, .NET Framework 1.1, ASP 2.0, Sun Solaris 5.8, Windows NT/ 2K, IIS 4, HTML, DHTML, XML.

Senior Developer

TCS
Calcutta
04.1999 - 06.2000
  • Design, Development and implementation of Utility Product.
  • Environment - Developer2000, PL/ SQL, Designer 2000, VSS, Configuration Management, Lotus Screen Scan.

Senior Developer

Life Scan Inc.
California
08.1998 - 04.1999
  • Design, Development and implementation of Y2K compliance.
  • Environment - SQL
  • Forms 3.0, SQL Report Writer 1.1/2.0, SQL
  • Menu 5.0, PL/SQL, PRO
  • C, SQL
  • PLUS, Unix Shell Scripts, ORACLE 7.x RDBMS, SUN SOLARIS O/S.

Developer

MBT
Pune
05.1998 - 08.1998
  • Design, development and maintenance of database applications including Oracle Forms and Reports.
  • Environment - PL/SQL, SQL
  • PLUS, PRO
  • C, SQL
  • LOADER, ETI Conversion Tool, ORACLE 7.3 RDBMS, HP UNIX.

Developer( Consultant)

British Telecom Plc.
Fleet

Education

Bachelor of Engineering -

Jadavpur University
Calcutta, India
01.1990

Skills

  • Oracle PL/SQL
  • SQL
  • Shell Script
  • Python
  • Java
  • Hibernate
  • Spring Boot
  • T-SQL
  • Excel
  • Power BI
  • Oracle 19C
  • Oracle 12C
  • SQL Server
  • Web logic 12c
  • Tomcat
  • ERWin
  • Rational Data Architect
  • Oracle APEX 242
  • Oracle Forms and Reports 12c
  • FLEXCUBE RAD Tool
  • Toad
  • PLSQL Developer
  • SQL Developer
  • JDeveloper
  • VS Code
  • Eclipse
  • Spring Tool Suite
  • GIT
  • BITBUCKET
  • SVN
  • Windows
  • UNIX
  • LINUX

Certification

  • Oracle PL/SQL Certified Professional (OCP), 01/01/24
  • Oracle SQL Certified Associate (OCA), 01/01/23
  • Oracle Cloud Infrastructure Foundations 2020 Certified Associate, 01/01/20
  • Oracle Certified Professional (OCP) - Oracle DBA Track, 01/01/15

Timeline

Senior Oracle PL/SQL Developer/Analyst, Oracle APEX Developer

Cigna Evernorth
03.2025 - Current

Senior Oracle PL/SQL Developer/Analyst

Citi Bank
04.2023 - Current

Senior Oracle PL/SQL Developer/Analyst

Desjardins Bank
06.2020 - 04.2023

Tech Lead

Northern Trust
09.2019 - 06.2020

Senior Oracle Developer/ Analyst

Wells Fargo
09.2018 - 09.2019

Technical Consultant

Citi Bank
07.2018 - 08.2018

Oracle Developer/ Analyst

Oracle
06.2012 - 07.2018

Oracle Database Architect

Mobile 365 Inc
10.2010 - 06.2012

Oracle Developer/ Data Modeler

Ricoh Share Reporting
12.2007 - 10.2010

Oracle Consultant

ABN AMRO
07.2006 - 12.2007

Corporate Trainer

IBM
05.2006 - 07.2006

Oracle DBA

AXA DIRECT Japan
10.2004 - 04.2006

Corporate Trainer

DSP
09.2004 - 10.2004

Oracle DBA

AIG Sun America.
06.2000 - 09.2004

Senior Developer

TCS
04.1999 - 06.2000

Senior Developer

Life Scan Inc.
08.1998 - 04.1999

Developer

MBT
05.1998 - 08.1998

Developer( Consultant)

British Telecom Plc.

Bachelor of Engineering -

Jadavpur University

Similar Profiles

CREATE PROFILE
Subrata Sarkar