- Cricket and Badminton lover
- Special interest in Music and playing ukulele
- Cooking
Shibasis Dhar
Kolkata
Summary
GCP Data Engineer with extensive experience in designing and managing data solutions using Google Cloud Platform, including BigQuery and Google Cloud Storage, Pub Sub and Looker studio for dashboards. Skilled in SQL, PL/SQL, and Unix/Linux environments, with hands-on expertise in job scheduling using Control-M. Proven ability to ensure and analyze data quality issues , automate monitoring processes, and support large-scale data systems. Experienced in service management tools like ServiceNow and Jira, with a strong track record in production support and issue resolution.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Consultant Specialist
HSBC SOFTWARE DEVELOPMENT PVT LTD
12.2021 - Current
- Managed the regulatory reporting platform (FOTC) across 37 countries on GCP, generating batch-based extract reports stored in GCS.
- Performed BigQuery data analysis, writing and optimising complex SQL queries and views for reporting, and reconciliation.
- Optimised storage and reduced cloud costs by archiving historical data in BigQuery and analysing BigQuery and GCS billing usage to identify cost-saving opportunities.
- Contributed to GCP project decommissioning (demise) activities, ensuring proper archival, cleanup, and efficient cost management.
- Designed and developed interactive dashboards in Looker Studio for business reporting and insights, using BigQuery datasets.
- Automated deployment support tasks using Python scripting, including file search, validation, and checks across GitHub repositories.
- Analysed SQL logic from GitHub and contributed to PL/SQL enhancements to ensure accurate regulatory reporting.
- Maintained data quality checks and resolved inconsistencies in batch processing workflows.
- Handled end-to-end job scheduling using Control-M and Unix/Linux cron, including dependency setup, monitoring, and failure resolution.
- Monitored batch execution using GCP Stackdriver (Cloud Logging) and troubleshot issues such as job failures, temp table errors, and missing inputs.
- Supported release management, including GitHub tagging, weekend deployments, and post-release validation.
- Developed liquidity monitoring solutions using complex SQL views and automated monitoring processes.
- Managed batch processes involving PL/SQL execution within GCP workflows for report generation.
- Extracted and processed regulatory reports (loan data, account details, NPAs, etc.). For downstream business consumption.
- Ensured smooth production operations by monitoring, rerunning failed jobs, and maintaining SLA compliance.
- Used ServiceNow and Jira for incident and change management, ensuring timely issue resolution.
Senior Production Support Engineer
VINCULUM SOLUTIONS PVT LTD
07.2020 - 12.2021
- This is a SAAS project that deals with the ecommerce domain where we provide software’s as an application to track client orders, inventories, shipments and deliveries seamlessly.
- We have multiple clients like Flipkart, amazon, Myntra, cloud tail, ajio, Tatacliq and we have customers from all the companies who want to sell their products on the online platform for example: Bata, Biba, Page, Armani etc.
- Here we have integrated all the online marketplaces in a single application based on ERP (E- retail Platform). and we also have 3 different servers to maintain the same.
- Main role of the project is to make sure that all the orders from market placed are completing their cycle from placed till delivery without any hic ups, and all the client issues are raised in the JIRA tool and has to be resolved accordingly with in their SLAs.
Production Engineer
SELLCRAFT GLOBAL SOLUTIONS PVT LTD
05.2019 - 06.2020
- This Project takes account of providing production-based support to business across applications like flex cube, QNG, SFMS and FCDB.
- The relevant motto of the projects to look after payment applications and interact with the business in an efficient manner and to assist them resolve issued related to the payment’s application.
- As an effective member of this project resolving tickets of severities 1 ,2 ,3 and 4, generating reports related to payments IMPS, NEFT and RTGS in a daily or monthly basis and analysis of payment not getting processed as well as run AutoSys and Tivoli jobs belong to my level of expertise.
Programmer Analyst
COGNIZANT TECHNOLOGY SOLUTIONS PVT LTD
01.2016 - 05.2019
- This project involves the providing of batch support and production-based support to all across DCS (Disability Claim System) application.
- The sole purpose of the project was to interact with Business Directly to help them resolve issues in the application itself.
- As part of this project, analysis the job and providing the resolution to the end user within the time frame when the job failure has occurred.
- And, to look after whether reports and output files have been delivered to business users and QA team.
Education
B. Tech - Computer Science And Engineering
FUTURE INSTITUTE OF ENGINEERING & MANAGEMENT
Kolkata01-2015
Higher Secondary -
Springdale High School
Kalyani01-2011
Madhyamik -
Springdale High School
Kalyani01-2009
Skills
- GCP architecture expertise(Google Cloud Architect Certified)
- Data analysis with BigQuery
- GCP workflow creation
- Pub/Sub and IAM management
- Looker Studio report development
- Python development skills
- AI productivity tools knowledge
- Oracle Forms and PL/SQL experience
- Deployment using GitHub
- Job scheduling with Control-M and Autosys
- Service management with ServiceNow and Jira
Profile Snapshot
GCP Data Engineer with strong expertise in building and managing data pipelines on Google Cloud Platform. Experienced in BigQuery data analysis, SQL/PLSQL development, and batch processing frameworks. Proficient in Python, Unix/Linux, and Control-M for workflow automation and scheduling. Skilled in data quality management, cost optimization, and production support, with hands-on experience in tools like GitHub, ServiceNow, and Looker Studio.
Interests
Runners-up in the PAPYRUS event (Content Writing) organized in college Non-Technical Festival 'PHOENIX 2K12'. Represented College Cricket Team, F.I.E.M at national level organized by BITS-PILANI in 2011. Organized and Winners of Inter College Cricket Tournament in my own college in 2014 as an official event of 'PHOENIX 2k14'. Champion of Inter Department College Cricket tournament. Singing in many stage shows.
Projects
- Finance on the Cloud(FOTC), HSBC Software Development Pvt Ltd, 2021-12-01, Present, Bank and Finance, The sole idea of the project FOTC is regulatory submission, where we run the batches for 37 Countries in GCP that generates extracts reports in the google Cloud buckets.
- Vin E retail, Vinculum Solutions Private Limited, 2020-07-01, 2021-12-01, E retail, This is a SAAS project that deals with the ecommerce domain where we provide software’s as an application to track client orders, inventories, shipments and deliveries seamlessly.
- Barclays bank, 2019-05-01, 2020-06-01, Banking(Flex cube), This Project takes account of providing production-based support to business across applications like flex cube, QNG, SFMS and FCDB.
- HLI-CCM-GBD-MISC: Hartford Insurance, Cognizant, 2016-01-01, 2019-05-01, Insurance, This project involves the providing of batch support and production-based support to all across DCS (Disability Claim System) application.
Disclaimer
I hereby declare that all the Information Furnished Above are true to the best of my Knowledge.
Certification
- Google Professional Cloud Architect certified.
Interests
Timeline
Consultant Specialist
HSBC SOFTWARE DEVELOPMENT PVT LTD
12.2021 - Current
Senior Production Support Engineer
VINCULUM SOLUTIONS PVT LTD
07.2020 - 12.2021
Production Engineer
SELLCRAFT GLOBAL SOLUTIONS PVT LTD
05.2019 - 06.2020
Programmer Analyst
COGNIZANT TECHNOLOGY SOLUTIONS PVT LTD
01.2016 - 05.2019
B. Tech - Computer Science And Engineering
FUTURE INSTITUTE OF ENGINEERING & MANAGEMENT
Higher Secondary -
Springdale High School
Madhyamik -
Springdale High School