You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Malt Strategy
Resources
Bilal HaniffBH

Bilal Haniff

Technical Business Analyst, Data Modeller

€880/day
Amsterdam, NL
15+ years

Average response time: 1 hour

About Bilal

Bilal is a solutions and results oriented freelance IT professional with 27+ years of significant and progressive IT experience in analysing, designing, developing, testing and delivering business critical enterprise applications in the Banking, Insurance, Government, Telecom and Retail sectors. I am accomplished and fluent multilingual communicator (English and Dutch) with strong investigative, technical, problem-solving and decision-making skills, combined with a pragmatic approach and sound business acumen. His functional and technical knowledge allows him to fulfil a variety of different roles within project teams, and provide an effective interface between business and technical functions, thereby bridging the gap between the business and IT.
Banking and Financial Services
Digital and IT Services
Telecommunications
Insurance

  • English

    Native or bilingual

  • Dutch

    Fluent

Can work on-site
Amsterdam (up to 50km)

Experience

  • BNG Bank,
    Lead Senior Technical Business Analyst, Data Modeler (Risk and Finance)
    June 2022 - Today (4 years)
    The Hague, Netherlands
    • Elicit functional and non-functional requirements from the business and IT stakeholders, including
    • Analysed and mapped data requirements for regulatory reporting e.g.: FINREP, COREP, DGS, AnaCredit
    • Lead Data Modeler: Conceptual, Logical, Physical and Dimensional Data Modelling with a team of 3 data modelers.
    • Designed and implemented Model Driven Development by extracting and delivering metadata from the data model, in order to automate the ETL processes.
    • Setup Data Management/Governance processes (BCBS239/PERDARR) to bring logical data model elements under governance in Collibra. Involved in designing the horizontal and vertical lineage solution.
    • Designed and implemented the Way of Working for the Business Analysts, including the Definition of Ready.
    • Designed the Acceptance Test framework and execution of acceptance test. Developed a test framework in Python to facilitate and automate the Acceptance Test process.
    • Designed the migration strategy from the legacy Datawarehouse to Databricks
    • Designed and documented several report mockups that were later built in Power BI
    • Backlog management in Azure DevOps. Created epics, feature and stories and prioritized them with the product owner. Worked in a scrum agile team and participated in the scrum ceremonies (stand ups, reviews, retros)
    • Introduced and implemented the KANBAN WoW to the teams, which significantly reduced operational waste and improved development.
    • Tool selection: Evaluate Microsoft Fabric vs Azure Databricks. Selection of Data Modeling tool. Selection of DQ monitoring tool. Liaising with vendors.
    • Design Functional and technical solutions (API integrations to and from the Data Platform). Designed the solution for the Databricks implementation, conform the medallion architecture.
    •
  • ABN AMRO Bank N.V.
    Senior Technical Business Analyst / Solution Designer
    BANKING AND INSURANCE
    October 2020 - June 2022 (1 year and 8 months)
    Amsterdam, Netherlands
    Primarily responsible for the gathering, analysing and documenting of data requirements (mortgages, consumer credit, financial markets) for Liquidity Risk, Interest Rate Risk and Funds Transfer Pricing reports. Also responsible for gathering requirements and designing a new solution on the Azure cloud platform. As a T-shaped individual, he has helped the team with Development, Testing and release coordination, in addition to his normal Business Analysis tasks.

    Environment: Azure Cloud, Azure Databricks, Azure SQL, SQL Server, Erwin Data Modeller, Python, SAS, Delta Lake, Azure Data Factory, QRM, Pyspark

     Elicit functional and non-requirements from the business and IT stakeholders. Documented and prioritized requirements were thereafter used to design the new data pipeline.
     Analysis and design of data requirements, including defining business terms in order to be incorporated into Finance and Risk lexicon
     Datamodelling (logical and physical) in Erwin Data Modeller.
     Designed the Data lineage solution, required for PERDARR/BCBS239 compliancy (Principles for Effective Risk Data Aggregation and Risk Reporting).
     Setup Data Management/Governance such as Data lineage, Data Quality checks, Master Data Management etc.
     Setup a documentation framework in Confluence, in order to centralise project documentation, and to document functional specifications in a standardized way.
     Responsible for the coordination and design of the new data pipeline on the Azure platform (Azure Data Factory, Azure SQL and Databricks). Setup a cross-team, multi-discipline workgroup and designed and documented the new solution. Executed PoC’s and defined acceptance criteria for Azure Databricks, Delta Lake, Informatica MDM, Azure Synapse and Power BI.
     Designed the Data Quality Checks, Process Monitoring and Reconciliation frameworks.
     Developed Python and complex SQL scripts on the Databricks and SQL Server.
     Perform acceptance testing
    Microsoft Azure Azure Databricks
  • ING
    Senior Technical Business Analyst
    BANKING AND INSURANCE
    April 2018 - October 2020 (2 years and 6 months)
    Amsterdam, Netherlands
    Responsible for the analysis and design of new requirements related to the loading, validating, cleaning and transforming of Risk data delivered by ING sources to the Credit Risk Datawarehouse. As a T-shaped individual, he has helped the team with Development, Testing and release coordination, in addition to his normal Business Analyst tasks. The team is distributed between India and Amsterdam.

    Environment: Sybase, Oracle, Unix, MQ, MS-TFS, Azure DEVOPS, Service Now

     Elicit requirements from various stakeholders and designing the relevant solution.
     Analysis and design of functional and non-functional requirements and the documentation thereof. Documents are delivered to internal/external stakeholders as well as the regulator (ECB/DNB).
     Data modelling in IBM Data Architect and Oracle Data Modeller. Member of the Data Modelling team. Designed the process to change the Credit Risk Data Model.
     Performing impact analysis and investigations on calculation differences for RWA, EAD, LGD and IFRS9 provisions.
     Introduced Behaviour Driven Development and guided the team towards more collaborative development, resulting in improved performance
     Backlog prioritization and grooming with the Product Owner.
     Support the onboarding of new data sources.
     Analyse and resolve production issues during the monthly production runs.
     Planning and coordination of releases to Acceptance, Production Acceptance Test and Production.
     Mentoring all team members (BA, DEV and Test), improving team performance.
     SCRUM Master of the team.
Check out Bilal's experience

Recommendations

Be the first to recommend Bilal

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Signup to reveal

Education

  • Bachelor's Degree, Computer/Information Technology Administration and Management
    University of South Africa/Universiteit van Suid-Afrika
    1999
    Bachelor's Degree, Computer/Information Technology Administration and Management
  • High School, Accounting and Computer Science
    Reservoir Hills Secondary
    1993
    High School, Accounting and Computer Science

Skill set (9)

Business analysis
SQL
Microsoft Excel
Databricks
Python
Requirements Engineer
Solution Design
Microsoft Azure
Azure Databricks

Categories