Somak Mondal
Kolkata
Summary
• Certified Azure Data Engineer with expertise in ETL processes using SSIS and Azure Data Factory, MS
Fabric enhancing data integration and automation capabilities.
• Proven 10+ years of proficiency in ERP, CRM & FSM products, including extensive experience with
multiple platforms such as BaaN4, Infor LN, Infor CRM, and IFS FSM.
• Proficient in Baan 4GL Programming, 3GL Programming, DAL, DAL 2, AFS, DLL, User Exit, and
customization of sessions and reports across Finance, Distribution, and Manufacturing modules of
BaaN/LN.
• Valuable contributions in requirements understanding, mapping, development, integration, code reviews,
and reporting, demonstrating a strong ability to translate business needs into technical solutions.
• Expertise in formulating data conversion and migration strategies, showcasing skills in automating data
migration processes using SSIS.
• In-depth business process knowledge across Heavy Engineering, Auto Manufacturing, and Textile
industries, providing a comprehensive understanding of industry-specific requirements.
• Outstanding communication skills, coupled with a systematic approach, enabling effective collaboration
and the ability to thrive independently or as a valuable team member in a dynamic, fast-paced
environment.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Azure Data Engineer
MACE
03.2024 - Current
- Monitored and resolved daily batch job issues to ensure smooth operations.
- Developed SSIS packages to import timecard data efficiently.
- Configured and deployed solutions onto MS Fabric for enhanced data management.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
Data Engineer
STC
01.2020 - 04.2022
- Custom Schema Design, Integration Specification Document Creation, XML Map, Message Routing Rules Configuration – Led the design and implementation of custom schemas and integration specifications, including XML mapping and message routing rules. This ensured seamless data exchange between internal systems and external applications, optimizing data flow and integration across platforms.
- Developed Oracle Packages for Order Creation, Appointment Slot, Manage Fault, Inbound Integration Call Log, and Reusable Utility Package – Designed and developed Oracle packages to streamline key business processes, including order creation, appointment scheduling, fault management, and inbound integration call logging. Additionally, created reusable utility packages to enhance modularity and maintainability across various systems.
- Developed Oracle Package to Fetch Data from External DB via DB Link – Created a robust Oracle package to enable data retrieval from external databases via database links, facilitating smooth and efficient data integration across different environments, improving data accessibility, and supporting critical business operations.
Data Engineer
TOYOTA MOTOR CORPORATION
05.2018 - 09.2019
- Development of packages using the SSIS tool – Designed and implemented complex data integration solutions using SQL Server Integration Services (SSIS), including the creation of Master and Transaction data packages for efficient data flow management, transformation, and loading across multiple systems.
- Development of ADF, SSIS packages, and stored procedures for different modules – Engineered and optimized Azure Data Factory (ADF) pipelines, SSIS packages, and T-SQL stored procedures for diverse business modules, ensuring seamless data movement, transformation, and automation while adhering to best practices for performance and scalability.
Data Engineer
Armstrong Fluid Technology
09.2017 - 03.2018
- Development of custom reports on Distribution (Sales & Purchase), Finance, and Common modules – Designed and delivered customized reports across distribution modules, including sales and purchase, as well as finance and common areas, ensuring data accuracy, consistency, and enhanced visibility for informed decision-making.
- Code migration from Baan4 to Infor LN FP10 – Led the migration of legacy code from Baan4 to Infor LN FP10, ensuring minimal downtime, compatibility, and improved system performance while adhering to industry best practices for code refactoring and data integrity.
- Workflow design – Freight Approval Process and Reporting – Developed and implemented a comprehensive Freight Approval Process workflow, including automated reporting capabilities, to streamline approval cycles, reduce manual intervention, and enhance process transparency.
- Salary Approval Process Design – Engineered a Salary Approval Process workflow with integrated reporting, ensuring accurate validation, improved efficiency, and compliance with organizational policies for payroll approvals.
ERP Technical Consultant
Ferrari N.V.
02.2016 - 08.2017
- Customized Standard Invoice and Purchase Order (PO) for Subsidiaries – Designed and implemented tailored versions of standard invoices and purchase orders for multiple subsidiaries, aligning with regional compliance requirements and enhancing clarity in financial documentation across business units.
- Automated Financial Transaction Upload from .csv Files – Developed and deployed an automated solution for bulk financial transaction uploads using .csv files, significantly reducing manual data entry errors, improving processing efficiency, and ensuring data accuracy in financial records.
- Developed Custom Purchase Order Requisition Functionality – Engineered a custom Purchase Order Requisition system, optimizing procurement workflows with enhanced validation checks, approval mechanisms, and reporting features, leading to improved transparency and control over purchasing activities.
ERP Technical Consultant
Tata Steel Ltd. Growth Shop (TGS)
09.2015 - 01.2016
- Multi-Level BOM Report Development – Designed and developed a comprehensive Multi-Level Bill of Materials (BOM) report, providing detailed insights into component hierarchies and material requirements, improving production planning and inventory control.
- Automation of Financial Entry Generation – Engineered an automated solution for generating financial entries, streamlining the recording of financial transactions, minimizing manual intervention, and ensuring compliance with accounting standards and accuracy in financial reporting.
- Module Development for DAL, MMT, and AFS – Developed and deployed customized modules for DAL, MMT, and AFS, enhancing system capabilities with tailored functionalities, data integration improvements, and optimized process workflows for diverse business operations.
ERP Technical Consultant
Aernnova Aerospace SA
03.2014 - 08.2015
- Production Order Wise Thermal Measurement Process – Designed and implemented a thermal measurement process for production orders, ensuring accurate tracking of temperature data throughout the manufacturing process, thereby improving quality control and compliance with industry standards.
- New Report Development in Purchase, Sales, and Invoicing Process – Developed and deployed custom reports for the purchase, sales, and invoicing processes, enabling real-time monitoring of transactions, improving data accuracy, and providing actionable insights for decision-making and process optimization.
Skills
- Azure Data Factory
- MS SSIS
- Azure Databricks
- Synapse Analytics
- Oracle/SQL Server SQL
- PL/SQL
- Baan 4GL scripting
- Infor LN Customization
- ETL development
Technology and tools
MS SSIS, Azure Data Factory, Azure Databricks, Synapse Analytics, Baan 4GL scripting, Infor LN Customization, Oracle/SQL Server SQL, PL/SQL, Oracle11g/12c, SQL Server 2008, SQL Server 2012, SQL Server 2016, Eclipse, MS Visual Studio, VS Code, PL/SQL Developer, Oracle SQL Developer, SVN, Git, Harvest, Winscp
Certification
Microsoft Certified: Azure Data Engineer Associate
Timeline
Azure Data Engineer
MACE
03.2024 - Current
Data Engineer
STC
01.2020 - 04.2022
Data Engineer
TOYOTA MOTOR CORPORATION
05.2018 - 09.2019
Data Engineer
Armstrong Fluid Technology
09.2017 - 03.2018
ERP Technical Consultant
Ferrari N.V.
02.2016 - 08.2017
ERP Technical Consultant
Tata Steel Ltd. Growth Shop (TGS)
09.2015 - 01.2016
ERP Technical Consultant
Aernnova Aerospace SA
03.2014 - 08.2015
Similar Profiles
Aaron McNamaraAaron McNamara
Sales Assistant at MaceSales Assistant at Mace
Maria-Madalina RoatisMaria-Madalina Roatis
Assistant Recruitment Manager at MaceAssistant Recruitment Manager at Mace
Hasan KhanHasan Khan
Head of Talent Acquisition, APAC at MaceHead of Talent Acquisition, APAC at Mace