Muhammad Moiz Ahmed, Data Vault, Python3, AWS, Databricks, SQLDBM, DBt

Location: Berlin, Germany

Can work on-site at your office in

and around Berlin (up to 50km)
and around Berlin (up to 50km)
and around Hannover (up to 50km)
and around Hamburg (up to 50km)
and around Frankfurt am Main (up to 50km)
and around Köln (up to 50km)
and around Düsseldorf (up to 50km)
and around Essen (up to 50km)
and around Nürnberg (up to 50km)

Freelancer code of conduct signed

Read the Malt code of conduct

Verified email

2009Reputation

9Bronze

13Silver

1Gold

Check out languages spoken by Muhammad Moiz

Cloud Engineer & Architect

Agatha Frydrych

Backend Java Software Engineer

Baptiste Duhen

Fullstack developer

Amed Hamou

Senior Lead Developer

Audrey Champion

Web developer

Signup to reveal

Top skills

Additional skills (119)

Check out Muhammad Moiz's expertise

Check out Muhammad Moiz's full description

IT (Cloud Engineering and Architecture) and Data (Data Engineering, Data Analysis, and Data Leadership roles)

I can help companies looking for Project Management and Cloud Engineering and Architecture, as well as Data Manager roles for data collection and processing pipelines / methods in AWS and Databricks, Python and Terraform / Terraspace. I can consult on implementing a Standardized data lake in S3, implement Transfer Family building block for Secure File Transfer with Lambda function, which helps in data collection from various On-Premise solutions such as SAP BOXI SFTP with SHA256 Fingerprint or On-Prem Linux servers, as well as Company heterogeneous data sources from Sharepoint programmatically via Graph API and Python pipeline. I am proficient when it comes to designing or implementing pipelines with Databricks, or look after Infrastructure (Cronjobs, Airflow jobs, AWS Subnets, IAM roles etc.) and documenting Architecture in use in and around AWS (including On-Prem resources), Firewall Network flows etc.. I have also setup and maintained Redshift clusters for large data processing needs, which are then exposed via Power BI Gateway data sources, for consumption in Power BI.

Thanks in advance, Best regards, Moiz.

Chemieindustrie
Project Data Manager
CHEMICAL
April 2022 - Today (3 years and 3 months)
Berlin, Germany
consulting my clients from Chemical Industry in AWS Cloud adoption, Data Management, Infrastructure Architecture and Documentation, maintaining a robust Data Platform. This includes consolidated Data Reportings (Power BI), various team Communications, task plannings, and maintaining presence in various Sprint Planning and Tech Demo

Management tasks include
• communication with Cyber Security teams / Group Admins
• 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 requests

Consulting, 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 block
implementation with Lamdba function for custom authentication.
• IAM Roles, IAM Policies
consultation on implementation of IAM Policies for fine grain access to S3 data, and cross-account access
• Redshift Setup
cluster setup and Admin tasks
consulted on use of Redshift, Distribution Keys, Sort Keys and Copy Commands.
• Liquibase

Architecture 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 OIDC

Databricks Tasks include
• Implementation of Unity Catalog via Terraform
• Delta Table creation
• Databricks Workflows
• Databricks Python Notebooks
• use cases include:
data Cleanup activities
public data (ELWIS, PEGELONLINE WSV, DWD)

Data Transfer, Archiving and Monitoring Tasks
• Shell / SFTP scripts
• BOXI exports over SFTP (Transfer Family)
AWS Project Management Data Management AWS S3 S3 AWS Transfer Family AWS Subnets IT-Architektur Databricks Python3 SAP BI Redshift AWS Lambda AWS EC2 SFTP IAM Microsoft Graph-API Liquibase security groups Power BI Power BI Gateway Terraform
IT-Dienstleister einer Versicherungs Gruppe
Data Vault Modeler
DIGITAL & IT
February 2022 - September 2024 (2 years and 8 months)
München, Germany
Engaged 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.
SQLDBM dbt PostgreSQL Azure Synapse GitHub Informatica Axon Informatica Data Governance Data Modeling Data Vault Data Standards Data Mapping Mapping Guideline Facultative Reinsurance Insurance Reinsurance 3NF
Versicherungswesen Finanzdienstleistungen
Data Vault Integration Layer Developer
BANKING & INSURANCE
October 2021 - January 2022 (4 months)
München, Germany
Engaged 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
Agile Softwareentwicklung Data Vault SQL-Developer Oracle DB Tosca Eclipse Jenkins GitHub SAFe IFRS IFRS17 US-GAAP

Check out Muhammad Moiz's experience

(2 ratings)

Quality
Respects deadlines
Communication

Check out Muhammad Moiz's project reviews

Reyhan-Couche-Tard Deutschland GmbH & Co. KG

10/10/2024

Data Management: Mohammad MOIZ AHMED has demonstrated outstanding skills in the area of data management. He has efficiently organised and updated our data management systems, resulting in a significant improvement in data integrity and accessibility. His structured and methodical approach has enabled us to optimise data management and accelerate processes.

Cloud Administration (AWS): Mohammad MOIZ AHMED demonstrated a strong understanding and technical expertise in cloud administration. He implemented effective strategies to secure and manage our cloud infrastructure. As a result of his efforts, system downtime was minimised and overall operational efficiency increased.

Communication and Teamwork: Mohammad MOIZ AHMED has proven to be an excellent communicator, working effectively with internal teams and external partners. His ability to communicate complex technical information clearly and concisely has greatly improved knowledge sharing and collaboration within the team.

Problem Solving: Mohammad MOIZ AHMED demonstrated exceptional problem-solving skills. He proactively identified potential pain points and developed innovative solutions to address them. His analytical thinking and proactive approach helped to overcome technical challenges quickly and efficiently.

Reyhan-Couche-Tard Deutschland GmbH & Co. KG

10/10/2024

Data Management: Mohammad MOIZ AHMED has demonstrated outstanding skills in the area of data management. He has efficiently organised and updated our data management systems, resulting in a significant improvement in data integrity and accessibility. His structured and methodical approach has enabled us to optimise data management and accelerate processes.

Cloud Administration (AWS): Mohammad MOIZ AHMED demonstrated a strong understanding and technical expertise in cloud administration. He implemented effective strategies to secure and manage our cloud infrastructure. As a result of his efforts, system downtime was minimised and overall operational efficiency increased.
Communication and Teamwork: Mohammad MOIZ AHMED has proven to be an excellent communicator, working effectively with internal teams and external partners. His ability to communicate complex technical information clearly and concisely has greatly improved knowledge sharing and collaboration within the team.

Problem Solving: Mohammad MOIZ AHMED demonstrated exceptional problem-solving skills. He proactively identified potential pain points and developed innovative solutions to address them. His analytical thinking and proactive approach helped to overcome technical challenges quickly and efficiently.

Check out Muhammad Moiz's recommendations

Sefana Boucherit and 1 other person have recommended Muhammad Moiz

Oleksandr Erm

Crosslend GmbH

08/01/2021

I was leading a software development team at Crosslend GmbH when I had a pleasure to work with Muhammad Moiz Ahmed. We were frequently working together as software teams and data teams are always close.

He bears deep knowledge of data handling and data analytics techniques. Analytics tools that he has built have driven business decisions for years to come. His team was a gold standard when it came to the quality of data provided. Do you need the right data for your task? He has it.

Personally, it was a pleasure working with him. He is kind of person you can have a well-argued discussion with on many topics inside or outside of his primary skill set.

I'm looking forward to work on more projects with him.

Muhammad Moiz's certifications are only visible to Malt Community members

Certified Data Vault 2.0 Practitioner
Datavaultalliance
https://www.credential.net/887b44c9-ff4a-420e-8616-b4567b3d0e58
Data Vault Data Modeling
dbt Fundamentals
dbt Labs
https://credentials.getdbt.com/9ead8c74-746f-471c-a33a-57a5f4df5211
Data Engineering dbt
SqlDBM Fundamentals
SqlDBM
https://academy.sqldbm.com/certificates/hdl37owvhf
Data Modeling SqlDBM