William N.-Senior/Lead Business Analyst & AI Workflow Consultant | Requirements Engineering | BI | Workflow Automation | Claude Code
Check rate
Experience
Power BI Solutions Architect/Engineer & AI Consultant
AVERDUNG GmbH
- Redesign of the company's BI infrastructure: replacement of a fragmented landscape of manually maintained Excel solutions and CSV imports with a centralized Power BI environment featuring a unified data model as the company-wide single source of truth
- Consolidation of previously isolated reporting logic into a central semantic model – eliminating redundant files, manual data transfers, and inconsistent metrics between departments
- Forecasting & planning: Design and implementation of company-wide liquidity planning in Power BI – from business logic to a fully automated, data-source-driven planning model replacing the previous manual Excel process; enables rolling forecasts and continuously up-to-date cash flow transparency for management
- Optimization of existing Power BI dashboards in terms of performance, structure, and analytical value using an AI-native approach
- Analysis and improvement of the data model, including data quality analyses, data cleansing, and consistent modeling using star schema, DAX, and Power Query
- Incident & anomaly analysis: Identification, investigation, and explanation of data anomalies, including root-cause analysis and concrete recommendations for action
- AI solution architecture: Connecting Business Central and Power BI to LangDock via MCP (Model Context Protocol) for AI-supported data usage
- Creation of a historical data layer as a basis for trend and time-series analyses
- AI-supported automation: Design and development of AI skills, agents, loops, and processes for the automated analysis and interpretation of reports
- Automated reporting workflow: Setup of scheduled, automated email distribution of AI-generated analyses and recommendations to stakeholders
- Gathering and documentation of business requirements and coordination with business departments and IT as part of requirements engineering / product owner activities
- Breaking down overall requirements into clearly defined work packages and tasks
- Definition, prioritization, and management of milestones throughout the entire project lifecycle
Tools: POWER BI, M365, Copilot Studio, MIRO, Microsoft Business Central, Microsoft Fabric, Claude AI, ChatGPT, LangDock, MS VS Code
Senior Business Analyst/Requirements Engineer
Finanzen.Net/Finanzen.Zero
- Analysis of complex business processes and end-to-end user journeys in digital product and platform environments
- Gathering, structuring, and prioritization of business and technical requirements (Functional / Non-Functional Requirements)
- Translating business goals into actionable requirements, user stories, and acceptance criteria
- Conducting stakeholder interviews, workshops, and reviews with business departments, IT, UX, and management
- Creation and maintenance of requirements artifacts (BRD, FRD, user stories, process models, decision papers)
- Ensuring consistency between business needs, technical implementation, and product vision
- Close collaboration with development teams to clarify business questions during implementation
- Support with impact analyses (A/B tests), change requests, and scope management
- Quality assurance of implemented requirements, including acceptance criteria and business tests (change validation)
- Advising on the further development of product strategy and roadmap structure
- Prioritization of backlog items according to business value
- Definition and refinement of product goals, KPIs, MVP definition, and other success metrics
- Evaluation of new features, tools, and initiatives from a user and business perspective
- Moderation between business, product, and technology to support decision-making
- Support with go-to-market considerations and product positioning
- Sparring partner for product and stakeholder decisions at management level
- AI-supported development: Generation and development of comparison and calculator applications with AI coding assistants (Claude Code, ChatGPT/Codex) and transition into production use
- Dashboard creation, data modeling, BI report administration, and data analysis using Power BI
Tools: POWER BI, MS Fabric, M365, MS Copilot Studio, FIGMA, MIRO, JIRA, Confluence, Claude AI, ChatGPT, Google Analytics, MS VS Code
AI Automation Consultant
Horvath & Partner GmbH
- AI process automation: Conducting business analysis to automate event registration (Evalanche ↔ Marini ↔ Dynamics 365 with Power Automate & MS Copilot)
- Design of an end-to-end process (current/target state) to reduce manual data maintenance
- Definition of data mappings and JSON API specifications for system integration
- Development of Power Automate workflows for data synchronization, triggers, and campaign logic
- Implementation of automated email sequences (confirmations, reminders, follow-ups)
- Ensuring data quality through validation rules and guardrails
- Change validation (E2E/UAT): Conducting tests and validating data consistency (E2E, UAT)
- Interface between business and IT, translating requirements into technical solutions
- AI agent design: Analysis of ongoing customer projects (objectives, scope, pain points, maturity level)
- Derivation of suitable follow-up solutions based on defined solution clusters
- Structured justification of the business value of each cross-selling recommendation
- Development of a rule-based decision-making and prioritization model
- Creation of clearly worded, sales-oriented arguments (trusted advisor logic)
- Development of reusable templates, meta-prompts, and decision logic
- Quality assurance regarding consistency, relevance, and feasibility
- Close coordination with project management, sales, and management
- Dynamics CRM triggers and email automation via the Follow-Up Solutions
Tools: Copilot Studio, Microsoft 365, Power Automate, Marini, Evalanche, Microsoft Dynamics 365 Sales, MS Copilot Studio, M365, Power Automate
AI Consultant & Data/Business Analysis
ErschaffeDichNeu Ltd.
- Optimization of the product setup by implementing efficient product duplication processes in the e-commerce system
- Automated subscription management to increase operational efficiency and reduce manual effort throughout the product lifecycle
- Ensuring system integrity through the correct linking and synchronization of e-commerce product lists and associated payment subscriptions
- Analysis, debugging, and technical implementation to correctly retrieve relevant subscription data from Stripe within Make automations despite initial connection issues
- Successful setup of automated subscription lifecycle management (especially cancellation processes) by ensuring smooth data flows between Make and the Stripe API
- Responsibility for critical messaging systems (Twilio/WhatsApp/Salesforce) regarding stability, functionality, and compliance (including template approvals)
- Incident handling: Comprehensive error analysis to identify and resolve the cause of a long-running communication outage (since August)
- Successful restoration of bidirectional WhatsApp communication through technical reintegration and reconfiguration of the interface
- Implementation of system adjustments, including phone number migration and setup of new Twilio services
- Systematic and analytical error diagnosis (missing aggregation logic, data import errors, or system duplications)
- Reporting & documentation
- Data quality analysis of source data, imported data, and report data
- Financial data analysis & modeling (correction and dynamization of the calculation logic for cash flow, run rate, and net profit estimation)
- Testing
Tools: Make.com, Stripe, Slack, Loom, Twilio, WhatsApp, Salesforce, Zoho Analytics, Quickbooks
Product Owner Frontend
German Bank
- Frontend Lead Business Analyst for implementing the Payback/Cashback function in the banking app
- Creation and structuring of user stories, including acceptance criteria (functional and non-functional criteria, edge cases, error cases, etc.)
- Design and modeling of processes (chargeback, return, payout, system communication, etc.)
- API coordination and alignment
- Stakeholder management with IT, business departments, legal, developers, and backend teams
- Roadmapping, backlog management, release planning
- Testing and documentation
- Requirements management and requirements analysis
- Coordination and business/technical alignment with business, system, and data teams
- Tools: Confluence, JIRA, Figma, Miro, draw.io, PO-Editor, Postman
Business Consultant & Market Analyst
OCOTEN Engineering
- Project management and stakeholder management
- Market entry analysis for electric scooters in SEA (sourcing and sales)
- Creation of a KPI dashboard for company management (HR and financial data)
- Creation of a modular tool to quantify a market entry ranking
- Pricing and scenario analysis
- Tools: MS Office, Power BI, Microsoft Fabric
BI Consultant (Data & Business Analyst & BI Developer)
Otto Klumpp GmbH
- Project and stakeholder management for QlikSense in cooperation with Studicon
- Data modeling
- Dashboard creation and visualization
- Data analysis (HR, sales, financial, and production data)
- Data administration and management for QlikSense
- End-user coaching
- Requirements gathering
- Tools: Oracle SQL Developer, QlikSense, ABAS, Microsoft SQL, BAPTECH, PROSES
Lecturer
DATASMART POINT
- Teaching and training in AI and machine learning
- Power BI training
- Training in business analytics and data analytics
- Statistics training
- Training in data interfaces and data collection
- Training in databases (SQL and NoSQL)
- Data analysis and visualization with Python and Excel
- Tools: Power BI, Microsoft Fabric, Excel, Python, Postgres, SQLite
Data Coach / Data Analyst
Hanseatic Statistics
- Coaching and supporting students and professors with statistical data analyses
- Scripting data analyses
- Code review
- Designing statistical studies
- Interpreting statistical results
- Supporting clients from the fields of medicine, business, psychology, and social sciences
- Tools: R, SPSS Statistics, Jamovi, JASP, Python
Management Consultant
Growth Levers Consulting GmbH / Growth Levers VN
- Market research and market analysis for Babynation/MATIDA
- Rollout of an e-contract system (Viettel)
- Supporting and recruiting partners and freelancers
- Establishing an accounting structure and guidelines
- Competitor analysis
- Business case analysis
- Translation and intercultural consulting
- Networking in Vietnam’s tech and medical hubs
- Planning, organizing, and administering the establishment of a Vietnamese entity
- Tools: MS Office, Google Office/Analytics, Facebook Ads, Power BI
Senior/Lead Business & Data Analyst
Deutsche Kreditbank AG
- Lead Business Analyst for deposit guarantee reporting and data migration
- Data enrichment of the access layer for deposit guarantee reports
- Lead Business Analyst for integrating securities data from WP-Dynamic into Abacus
- Preparing HGB and IFRS reports for securities from WP-Dynamic
- Lead Business Analyst for the recovery process (Valuation Data Set)
- Development of SQL reports based on Own-Funds Exposure
- Implementation and support during the transformation of Abacus reporting
- Data mapping and analysis of various source systems into the DWH
- Financial and business analysis of requirements for implementation
- Debugging, functional and technical testing of implementations
- Advising the Finance Tech team on solutions in finance, regulatory matters and reporting
- Migration of accounting data to BayernLB's SAP accounting system (Lead Business Analyst)
- Lead for digital process solutions in finance
- Development of a Python script to detect and report incorrect postings
- Automated data analysis and reporting of new account notifications
- Project organization, user stories, case analysis, stakeholder analysis
- Stakeholder management as well as functional and technical coordination with business, system and data teams
- Testing and documentation
- Tools: Oracle, Ab Initio BRE, OSPlus, Access, Oracle SQL Developer, MS Power BI, SAP Power Designer, MicroStrategy, RStudio, WP-Dynamics, WP-Bilanz, JIRA, Confluence, Microsoft Visual Studio Code, Python
Associate - Financial Services (Risk Banking/Trading & Treasury)
KPMG
- Mapping and analysis of input data from various source systems for simulating NII and Delta-NII (DZ Bank)
- Development of an SQL-based data quality framework for the IRRBB database
- Functional testing of technical implementation projects and data migrations
- Development of SQL reporting macros and dashboards, as well as training for users
- Support in designing and implementing an Economic Risk Capital Model for mortgage loans (bootstrapping and Monte Carlo simulation) (Commerzbank AG)
- Creation of an automated document overview structure
- Data analysis, plausibility checks and evaluation of LCR effects from the Abacus system (Commerzbank AG)
- Tools: MS Office, Oracle SQL Developer, Squirrel, Notepad++, JIRA, Tableau, Murex, VBA, MS Power BI
International Strategy Consultant
Dreberis GmbH
- Market entry projects for infrastructure, water and wastewater management, education, Industry 4.0 and Smart City in Eastern Europe
- Market research and market analysis
- Project documentation
- Management consulting on the regulations of individual target countries
- Coordination of business trips abroad and meetings with potential partner companies
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance, Professional Services, Education, Information Technology, Energy, and Retail.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Finance, Project Management, Quality Assurance, Accounting, and Information Technology.
Summary
AI Consultant and Senior Business Analyst with nearly 7 years of experience in business and data analysis, business intelligence, requirements engineering, and process automation – with an AI/ML focus since 2023 and hands-on experience in paid GenAI, LLM, and AI automation projects for clients since 2025. I design AI solution architectures (LangDock, Microsoft Copilot Studio, MCP, Power Automate, n8n, Make.com), build LLM-powered knowledge and analytics solutions based on enterprise data, develop AI agents and AI-generated applications, and automate business end-to-end processes – from requirements gathering to production operations, including testing, change validation, and guardrails. Professional background: Banking & Finance, regulatory requirements, controlling, and digital products.
Skills
Ai & Automation: Genai & Llms · Rag / Knowledge Solutions · Ai Agents & Skills · Ai-Assisted Application Development (Claude Code, Chatgpt/Codex) · Prompt & Context Engineering · Mcp · Langdock · Ms Copilot Studio · Power Automate · N8n · Make.Com
Business Analysis & Product Ownership: Requirements Engineering · User Stories & Acceptance Criteria · Brd / Frd · Process Modeling · Stakeholder Management · Backlog & Roadmapping · Agile (Scrum/Kanban) · Jira/Confluence
Data & Bi: Power Bi (Pl-300) · Dax & Power Query · Sql · Microsoft Fabric · Microsoft 365 · Data Modeling · Data Quality & Root-Cause Analysis · Forecasting & Planning · Python · R
Oracle Sql Developer
Eikon Reuters
Squirrel Sql
Osplus
Morning Star Direct
Sap Powerdesigner
Msci Esg-Manager
Ab Initio (Bre+Mhub)
Qliksense
Sap Dw Cloud
Gitbash/Github
Sapbw4/Hana
Anaconda
Spyder Ide
Jupyter Notebook
Pyspark
Tableau
Rstudio
Pycharm
Microsoft Vs Code
Wp-Dynamic
Mongodb
Microsoft Sql Server
Redshift (Amazon)
Openai
Chatgpt
Microsoft Copilot
Big Query (Google)
Dbt
Miro
Figma
Excel
Power Pivot
Nosql
Qlik-Scripting
Languages
Education
Vilnius Universitetas
Master – Erasmus Program, Erasmus Program – “Strategic Business Management & Finance” · Strategic Business Management & Finance
Brandenburg University of Technology Cottbus-Senftenberg
Master of Science, M.Sc. in Business Administration – Specialization: “Investment & Finance” and “Market-Oriented · Business Administration
Universita Politecnica delle Marche
Bachelor – Erasmus Program, Erasmus Program – “International Business & Communication” · International Business & Communication
Certifications & licenses
AI Application Certificate
Neurawork
AI Leadership Certificate
TÜV
Stock Market License (BHV)
BHV
Claude Code Certificates
Fundamentals of Online Marketing
Real Estate Agent (IHK)
IHK
Certificate of Intercultural Competence
Statistics
Experience
Global experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
William is based in Berlin, Germany and can operate in on-site, hybrid, and remote work models.
William speaks the following languages: German (Native), English (Advanced), Vietnamese (Advanced), Spanish (Intermediate), French (Intermediate), Italian (Intermediate).
William has at least 7 years of experience. During this time, William has worked in at least 13 different roles and for 13 different companies. The average length of individual experience is 1 year and 7 months. Note that William may not have shared all experience and actually has more experience.
Based on recent experience, William would be well-suited for roles such as: Power BI Solutions Architect/Engineer & AI Consultant, Senior Business Analyst/Requirements Engineer, AI Automation Consultant.
William's most recent position is Power BI Solutions Architect/Engineer & AI Consultant at AVERDUNG GmbH.
In recent years, William has worked for AVERDUNG GmbH, Finanzen.Net/Finanzen.Zero, Horvath & Partner GmbH, ErschaffeDichNeu Ltd., and German Bank.
William is most experienced in industries like Banking and Finance, Professional Services, and Education. William also has some experience in Information Technology, Retail, and Manufacturing.
William is most experienced in business areas like Business Intelligence, Finance, and Project Management. William also has some experience in Quality Assurance, Accounting, and Information Technology.
William has recently worked in industries like Banking and Finance, Professional Services, and Education.
William has recently worked in business areas like Business Intelligence, Quality Assurance, and Finance.
William attended Vilnius Universitetas for Strategic Business Management & Finance.
William has 8 certificates. Among them, these include: AI Application Certificate, AI Leadership Certificate, and Stock Market License (BHV).
William is immediately available full-time for suitable projects.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 27 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
Ronald F.
Tungi D.
Marco S.
Alexander P.
Chris W.
Eduard V.
Wolfgang O.
Kerstin B.
Chrisabel P.
Stephan S.
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Power BI Solutions Architect/Engineer & AI Consultant
Mario T.
Simon S.
Bernd S.
Petru K.
Stefan M.
Kay M.
Simona T.
Philipp G.
Jonathan S.
Daryoosh D.
Nearby freelancers
Professionals working in or nearby Berlin, Germany
Paul K.
Stefan O.
Sascha B.
Greta S.
Andreas R.
Silvia B.
Dmitry P.
Martin H.
Jelena K.
Christian P.
