About Muhammad
I am an independent IT Consultant, I offer consulting regarding Cloud Engineering and Infrastructure Architecture, Data Engineering, Data Management, Data Modeling, Data Vault 2.0, Business Analytics, MicroStrategy, Power BI, Databricks, Python and Cloud Application Development. I also specialise in SFTP Transfers between On-Prem and Cloud, external Partners and On-Prem scenarios, as well as with use of SAP BOXI SFTP in Cloud scenarios. I am also versed in use of/setting up Microsoft Azure AD Apps, Microsoft Identity Platform and Graph API use-cases.
German
Conversational
English
Native or bilingual
Remote only
Primarily works remotely
Experience
- Chemieindustrie/PetroindustrieProject Data ManagerDIGITAL AND ITApril 2022 - Today (4 years and 2 months)Berlin, Germanyconsulting my clients from Chemical Industry with Project Management, Data Management, Architecture, Documentation, Infrastructure Architecture, for their data initiatives in AWS. This includes various team Communications, task plannings, attending Sprint Planning and Tech DemosManagement tasks include• communication with Cyber Security teams / Group Administrators• incident management• service now based IT demands, and change requests• communication with Power BI Gateway Data Source creation teams• documentation and architecture diagrams• github team creation and member management• Databricks Github: Databricks Github App requestsConsulting, Research and Technical tasks include• Data Collection in S3 (Data Lake).conducted brainstorming sessions and exchanges, in deciding data categories, corresponding to company data classifications• Transfer Family building block with Lambda function.implementation of Transfer Family building blockimplementation with Lamdba function for custom authentication.• IAM Roles, IAM Policiesconsultation on implementation of IAM Policies for fine grain access to S3 data, and cross-account access• Redshift Setupcluster setup and Admin tasksconsulted on use of Redshift, Distribution Keys, Sort Keys and Copy Commands.• LiquibaseArchitecture topics include• Documentation of AWS Accounts• Subnets (/CIDR Blocks)• Network Firewall Flow openings/closings• AWS Resources and Cost Monitoring• Databricks: IAM credential passthrough with SCIM, meta-iam-role• IAM roles for Github AWS OIDCDatabricks Tasks include• Implementation of Unity Catalog via Terraform• Delta Table creation• Databricks Workflows• Databricks Python Notebooks• use cases include:data Cleanup activitiespublic data (ELWIS, PEGELONLINE WSV, DWD)redevelopment of older shell exports.Data Transfer, Archiving and Monitoring Tasks• Shell scripts• SFTP scripts• BOXI exports over SFTP (Transfer Family)
- einer Versicherungs GruppeIT-DienstleisterDIGITAL AND ITFebruary 2022 - September 2024 (2 years and 8 months)Munich, GermanyEngaged as a Data Vault 2.0 Modeler for Group implementation of Commercial Insurance PLC data collection efforts from various Operating Entities across various Geographical locations.As a Group Technology Data Modeler I have been actively engaged with Group Commercial business colleagues, experts and Architects, in carrying out following activities:• Updating and enhancing Group Commercial Common Global Ingestion Data Model (Data Vault 2.0).• Updating Data Standards for the Data Model.• Enhancing Global Definitions (Global Business Glossary)• Developing business Data Examples for Operating Entities.• Writing Mapping Guidelines.• Unifying CAT Risk Data Model into group Commercial DV 2.0 Data Model.• Participation in Enterprise Ontology clarification Workshops• Business examples and presentation slide decks for various Scopes in the model, Reinsurance (FAC/Treaty/Quota Share), Incident/Claim classifications, Policy and Object Terms (L&Ds), IIP (International Insurance Programs) to name a few• Data Mapping and Validation Example preparations, show-casing bi-directional mapping between group Commercial DV 2.0 Data Model and CAT Risk and Cyber 3NF Data Models.• Writing detailed Mapping Guideline for Data Deliveries into Group Commercial Common Ingestion DV2.0 Data Model.• Led solutioning in Data Model Workshops.• Unifying Claims Data Model into group Commercial DV 2.0 Data Model.• Participation in Workshops with Data Architects from other Business units.• Member of Community of Practitioners on Business Intelligence, Architecture and Data Modeling.Tools: SQLDBM, PostgresSQL, Azure Synapse Analytics Pool DB SQL, GitHub, Confluence, Axon (GBG), Sharepoint, Excel, Powerpoint.
- Insurance and Financial ServicesData Vault Integration Layer DeveloperOctober 2021 - January 2022 (3 months)Munich, GermanyEngaged as a Data Vault 2.0 developer for implementation of IFRS17 Account Standard requirements and adaptions, at an Insurance company in Munich. As an Integration Layer developer, I was mainly responsible for:• Overseeing operations in Integration Layer• Analysing and Developing new Raw Vault and Business Vault hubs, links and satellites• Ensuring relationships between entities loaded from different source systems.• Integrating new file based data source for Top Adjustments for month end closings.• Working with Effectivity Satellites• Met requirements for Ledger Specific postings (GAAP Codes) and Automated Reversals.• Provided Loading Templates for Premiums (Policy), Claims and Cash transactions.• Analysing Data Quality errors• Generating SQL packages and carrying out deployments.• Preparing Visual Data Vault Diagrams!• Documentation in Confluence• Exchanging with other IL Developers, Engineering Manager and Product Managers.• Raising Pull Requests in Github, and Merging them to Master (after a successful review).• Creating Test Cases in Tricentis TOSCA• Working in an agile 10 days Sprint basis, creating User Stories and allocating Story Points.• Participating in Feature Grooming sessions.• Using Jenkins to manage and schedule Runtime jobs Tools: SQL Developer, Oracle, GitHub, Tricentics TOSCA, Eclipse, Jenkins
Recommendations
Be the first to recommend Muhammad
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Bachelor of Science in Computer ScienceUniversity of Central Punjab, Lahore Pakistan2005
Certifications
- Certified Data Vault 2.0 PractitionerData Vault Alliance2018
- Oracle Certified Professional Database 11g AdministratorOracle2010