SUBHAM SARKAR

1) Working as a Data engineer. Developing PLSQL script, creating views, Tables, constraints, Index .

3)Handling Customer/Transaction data ranging from Delta to Type2 table using PLSQL and running batch using Procman.

3) Working on Unix scripts.

4) Supporting a applications and handling complex cliants quarry and providing solution.

5) Oversaw technology services delivery, consulting with relevant personnel to assist with migration and troubleshooting.

6) USED AI tools like Copilot.

• Working as a Data engineer. Developing PLSQL script, creating views, Tables, constraints, Index . Working on ETL technologies like DataStage as well to extract data from different sources.
• Experience in database normalization theory technique.
• Using Java Database Connectivity (JDBC) provides a bridge to execute PL/SQL code such as stored procedures, functions, and packages.
• Worked on a banking project. Handling Customer/Transaction data ranging from Delta to Type2 table using PLSQL and running batch using Control m.
• Working on Shell scripts to write Jobs which helps injecting data from a view to Table in data warehouse. Also used shell scripts to setup ETL environment.
• Contribute to the technical design for system enhancements.
• Participate as member of software development team with minimal supervision and occasional guidance.
• Working on different AWS applications like redshift, DMS (Data migration services) etc. Worked on redshift to create tables/views. Worked on S3 bucket to load csv file and take data out of the csv file. Automated the provisioning of AWS services (EC2, RDS, S3, and Lambda) through reusable and parameterized CloudFormation stacks.
• Working on partitioning, and indexing for improved data warehouse performance and scalability
• Working with application like Coginity pro(Accecing db2 Datawarehouse), Putty(Connecting to the UNIX server), Winscp(moving files from one server to another server).
• Participate in code reviews. Committing codes in bitbucket using Source Tree
• Contribute in support and technical troubleshooting activity. Good communication and organization skills working within a DevOps team supporting a wider IT delivery team
• Using Jira for project management.
• Working on PROD.UAT, DEV environments.
• Wrote and developed new and well-tested code for different software projects.

• Worked on an Ecommerce Project.
• Taking Backup (Full, Differential and Bulk logged)
• Solving issues/Tickets in service now for performance related activities like solving deadlock issues/Disk utilization etc.
• Worked in support for 7 months.
• Moved to PLSQL development. Strong experience in data warehousing concepts.
• Shell Script Development and Production Support
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Contribute to the technical design for system enhancements.
• Created and modified SQL Plus, PL/SQL and SQL Loader scripts for data conversions
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on
• Running Stored procedure.
• Working experience with CI/CD tools such as BitBucket, Jira.
• Partnered with engineering team to check and optimize interfaces between hardware and software applications.
• Working experience with automation / job scheduling tools such as Jenkins.
• Assessed customer needs and modified existing databases to meet specified client requirements.
• Established hardware requirements and devised database storage solutions to accommodate client needs.
• Worked on AWS application such as Cloud formation, S3 bucket, Redshift.