Shubhobroto Dey

Experience

• 

  Regent Education and Research Foundation Group of Institutions 263

  Jun 2013 - Feb 2015

  Technical Assistant

  Conducting practical classes on C, C++, Java and Data Structures.Maintenance of Labs (hardware and software support)Administration and maintenance of networks of the labs.Design, development and maintenance of the college website (www.rerf.in)Network administration for the TCS iOn project

• 

  IBM

  Mar 2015 - Nov 2021

  Database Application Developer

  Experienced in working with an operational data store for an ecommerce client and worked on Batch ETL solutions, transformation logic on semi structured data using external tables and MERGE INTO constructs for BI reporting. Hands on experience in optimizing SQL queries by analyzing OLTP reports and tools such as EXPLAIN_PLAN and TKPROF to improve application performance.Designed and deployed an archival and purging solution for a transactional database that adheres to client’s data protection and retention policy. Show less

• 

  Protiviti India Member Firm

  Nov 2021 - now

  • Developing, maintaining and providing technical expertise in order to transfer knowledge of integration technology components to development and support teams• Subject matter expert in delivering integration with My SQL and external systems including Salesforce, SAP, Teradata, Oracle, Files and other custom and cloud-based solutions• Working in Agile project using Scrum methodology with 4 weeks sprint. Taking up most complex task to speed up delivery and helping team meet the deadlines during the closure of each sprint• Interact with client and onshore lead on daily basis to understand the requirements, perform impact analysis, provide most suitable Integration design and assign appropriate tasks to team• Ensure that architecture principles, design and standards are consistently applied across the project and continuously improve on existing ones based on new cloud integrations• Review team’s task, test case documents and ensure bug-free quality output is delivered• Manage and track Serve tickets on daily basis for the tasks assigned to team and ensure proper closure of all Serve tickets before the end of each sprint• Participate in client sprint meetings to provide guidance on ETL estimates and feasibility of solutions with current architecture• Leading a team of 2 deputy managers , 3 senior consultants and 5 consultants. Show less Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment.Perform technical reviews of code and test plans created by team members.Participate in deployment, system integration testing and UAT.Engage in peer reviews during design, coding and testing.Ensure adherence to standards and quality processes.Provide guidance to project team to ensure that all aspects of ETL design and implementation align with the client’s reference model.Address and resolve technical design issues as they are appropriately escalated. Show less Created ETL pipelines using Talend/SAP BODS to extract the data from multiple sources like Flat files, Oracle, xml, csv and delimited files, transformed based on business requirements and loaded to targets.Worked extensively with complex mappings using different transformations like Platform transforms (Query,Case,Map),Data Integrator transforms (Pivot,Reverse Pivot,Key Generation) and Data Quality transforms in SAP BODS.Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment.Perform technical reviews of code and test plans created by team members.Participate in deployment, system integration testing and UAT.Engage in peer reviews during design, coding and testing.Ensure adherence to standards and quality processes.Provide guidance to project team to ensure that all aspects of ETL design and implementation align with the client’s reference model.Address and resolve technical design issues as they are appropriately escalated.Prepare deployment plans when moving a code to production.Perform system testing and monitoring of jobs post production.Implemented automation of various mundane manual activities, such as report generation, mail functionality and object archival using Python scripting. Show less

  • Manager

    Jan 2024 - now

  • Deputy Manager

    Dec 2022 - Jan 2024

  • Senior Consultant

    Nov 2021 - Dec 2022