Khader Mohammed

Sr Etl Bi Consultant @Bayer

Responsibilities:\\\\n\\\\n• Worked on putting together Design Documents and mapping data to help other SSIS developers build software that meets business needs.\\\\n• Develop SSIS packages to extract, transform, and load (ETL) data between the ERP system and various other systems or databases.\\\\n•Implement necessary data transformations and business rules within the SSIS packages to align the data with the ERP system\'s requirements.\\\\n• Made a configuration table so that the SSIS design could be scaled up.\\\\n• Used SSIS and SQL to generate Excel reports related to ERP.\\\\n• Collaborate with ERP functional consultants, technical teams, and stakeholders to understand the ERP system\'s data requirements and integration needs.\\\\n• Create and maintain technical documentation for the SSIS packages, data integration processes, and integration specifications.\\\\n• Used SQL to do complex aggregations.\\\\n• Tracked down and fixed a problem with the Microsoft Access Database Engine that affected the whole enterprise when working with Excel in SSIS.\\\\n• Used SSRS to generate basic reports.\\\\n• Wrote ORACLE PL/SQL procedures and made ORACLE PL/SQL packages based on what was needed.\\\\n• Worked on a very complicated SSIS package that took input from a Flat File and required hundreds of validations of the input data to separate out the records with errors.\\\\n• Worked with Erwin Data Modeler tool for Data Warehousing and Data Modeling.\\\\n• Used the programs JIRA and Confluence.\\\\n• Worked on putting together the documents for Manual and Pipelined deployment.\\\\n• Used GitHub a lot while working in an Agile environment.\\\\n\\\\n\\\\nEnvironnent: SQL Server, SSIS, Oracle DB, SQL, PL/SQL, ERP.\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n