MONMOHAN MOZUMDER

As a PL/SQL and ODI (Oracle Data Integrator) developer, have a strong understanding of database design, SQL, and programming concepts. Have good knowledge in PL/SQL programming, have knowledge in writing SQL queries, experience using ODI for ETL processes, familiarity with Oracle database administration, the ability to design optimized data models, effective communication and

problem-solving skills, and a willingness to continuously learn and adapt to new technologies and trends.

• ZONE (AMERICA) - UTS,CURACAO 2021-2022
• ZONE (AMERICA) - VTR,CHILLE 2022-2023
• ZONE(AMERICA) - CWP,PANAMA 2022-2024

Oracle Cloud Infrastructure Foundations 2021 Certified Associate(https://brm-certification.oracle.com

/pls/apex/f?p=1111:6:115968877309290::NO:::)

Oracle Database 12c: SQL Fundamentals(GREAT LEARNING)

Project

FSI Data model (Financial Service Model), OMFDM (Oracle Manufacturing Data Model)

Region-America Domain-Retail

Duration-2021-2022 Role-Pl SQL AND ODI Developer

Major Responsibilities· New Interface development using JDBC from source to stage & stage to foundation for new tables· Monitor data loads & need to check data quality· Support to fix/develop any UAT issues· Scheduling jobs· Create packages/load plans for newly created interfaces· Code migration between Dev, UAT, and Production instances· Need to manage ODI instance (tool restarts)· Manage documentation technical/user manuals for handover

Project

BRM Analytics Implementation

Region-Chile Domain-Telecom

Duration-2022-2023 Role- Pl SQL AND ODI Developer

Major Responsibilities· New Interface development using JDBC from source to stage & stage to foundation for new tables· Monitor data loads & need to check data quality· Support to fix/develop any UAT issues· Scheduling jobs· Create packages/load plans for newly created interfaces· Code migration between Dev, UAT, and Production instances· Need to manage ODI instance (tool restarts)· Manage documentation technical/user manuals for handover· Creating and modifying (based on business needs) ODI mappings· Creating and modifying packages, procedures, etc. using ODI using source tables to implement ORACLE BRM connector for VTR.

Project

Source ETL Development

Region- Panama Domain - Telecom

Duration- 2022-2023 Role - ODI Developer

Major responsibilities - Collaborating with business analysts to understand the data integration requirements and objectives for ETL processes , Designing the overall ETL architecture, data mappings, transformations, and workflows in ODI based on the requirements, Extracting data from various source systems such as databases and flat files using ODI interfaces , Loading the transformed data into the target systems by configuring ODI to connect to the target systems, defining the loading logic, and ensuring the data integrity and consistency during the loading process , Conducting thorough testing of the ETL processes to ensure the accuracy, completeness, and reliability of the data integration, Documenting the ETL processes, data mappings, transformations, workflows, and configurations for future reference, maintenance, and knowledge sharing purposes

Project

ETL Development & Support

Region- Panama Domain - Telecom

Duration- 2023-till now Role - Pl SQL AND ODI Developer

Major responsibilities - Collaborating with business analysts to understand the data integration requirements and objectives for ETL processes. Extracting data from various source systems such as databases and flat files using ODI interfaces. Providing support for ETL error.