Hi, I am Bilesh Ganguly, a Technology Lead with over 9 years of experience in the IT industry, currently specializing in the Data Integration domain. Throughout my career, I have worked on a wide variety of projects and have gained proficiency in various tools such as SnapLogic, Salesforce, and Reltio.

I started my career as a Java developer, which helped me develop a solid understanding of the software development lifecycle. Over the years, I have honed my programming and debugging skills in Python, Java, and JavaScript.

I hold a Master's degree in Computer Science from St. Xavier's College, Kolkata, which has given me a strong foundation in software development principles.

I am passionate about technology and delivering high-quality solutions while staying up-to-date with the latest trends. I am always eager to collaborate with others and take on new challenges to help drive business success.

Design, develop and refine data integration solutions

My current responsibilities involve:

• Operational accountability for the existing technology footprint, consisting of various cloud applications, scripts, integrations, and reports
• Function as a senior member of an agile team and help drive consistent development practices
• Work with product owners and business users to determine and document project requirements
• Partner with the Project Manager, QA Lead, and Ops team to design solutions and release code
• Liaising with team members, management, and clients to ensure projects are completed as per standard
• Provide support and escalation for investigations and incident management

Previously, I have worked on building data integration solutions for the Reltio Cloud MDM Platform using SnapLogic iPaaS and creating tools for providing an additional layer of functionality to the Reltio Cloud MDM. Following are some of the highlights:

• Created loading pipelines for loading data into Reltio Cloud MDM from various source systems like MySQL, Oracle, and PostgreSQL
• Created extraction pipelines to extract data from Reltio to PostgreSQL
• Wrote and optimized SQL queries for fetching the data to be loaded
• Created an automatic configuration generation tool which is a command-line tool that, when provided with a data model, can generate a Reltio configuration against it
• Created an automated configuration testing framework to check if a Reltio configuration was created as per the provided business requirements
• Created Reltio configurations based on business requirements

Additionally, I have developed pipelines (in SnapLogic) that act as API leveraging ULTRA Tasks to serve relevant data from MDM to be consumed by various downstream systems and applications. Worked on a Python-based match engine that when configured for a certain implemented MDM system can intelligently merge a large number of potential matches by itself without any manual intervention.

Designed and developed platform-independent desktop applications using JavaFX.

My job responsibilities involved understanding client requirements and breaking down program specification into simpler elements and then translating that logic into code, designing (and creating) the schemas based on business requirements and then utilizing them in the application, installing the application(s) and conducting final testing. The applications that I worked on include:

• An ERP system that provides an integrated view of core business processes.
• A POS (Point Of Sale) system which is integrated with both online and offline ordering systems.
• An HRM system for managing payroll of daily wage workers.

As organizations and companies expand, they often adopt disparate software solutions and systems to meet their evolving needs. Over time, these numerous systems, which may not be inherently designed to work together, can end up with conflicting and sometimes outdated information. The primary goal in this scenario is to develop a Master Data Management (MDM) solution that serves as a centralized repository or the single source of truth. This centralized system will enable various applications and downstream systems to access accurate and up-to-date data.

To achieve this, our approach involved several key steps. Initially, we develop data schemas building upon our out-of-the-box industry-specific configurations that align with the specific business requirements, ensuring that the data structure fulfills the requirements. Following this, we configure the chosen master data management platform to align with these predefined schemas. Once the configuration is in place, we migrate data from legacy systems into the MDM and build integrations from upstream (source) systems to the MDM. Once the MDM is populated we analyze the data and implement matching and merging strategies into the MDM platform.

In addition to setting up the MDM, we focus on the crucial aspect of data integration and automation. We design and develop robust solutions for ingesting data into the MDM platform and extracting data from it. These data integration solutions ensure seamless flow and synchronization of data between the MDM system and other applications or systems within the organization, thereby supporting the overall data consistency and reliability across the enterprise.