Achim G.-Senior Business Analyst
Check rate
Experience
Senior Business Analyst
VP Bank AG
- Business analysis in the Group Controlling department (methodology: Scrum)
- Preparation of a professional structure tree for cash flows
- Development of professional definitions and requirements for cash flows
- Business analysis of net new money, new loans, new custody money, new money from third-party banks and product turnover in Avaloq
- Conducting regular stakeholder workshops with the Group Controlling team’s subject matter experts
- Functional analysis with the Avaloq core banking system
- Avaloq test parameterization of Classes/ClassIf at BP, position, container and asset level
- Technical workshops with Avaloq specialists
- Data mapping with Avaloq
- Description of business models for Group Controlling and functional models for Avaloq IT specialists
- Obtaining and documenting business approvals
- Documentation of business requirements in SAP CALM
- Test case creation in SAP CALM
- Conducting the Weekly Metis Business Table (stakeholder engagement)
- Participation and reporting in Metis project meetings and stand-ups
Project Manager
Bank Frick AG
- Development of a concept and preparation of a concept document including presentation and management summary
- Management proposal to the Executive Board for the implementation phase
- Capture, analysis and graphical representation of requirements and the current situation relating to contracts and components
- Identification of possible adjustments in Cobol, SQL and RPG
- Detailed breakdown of expected project costs (OPEX) and investments (CAPEX)
- Preparation of a detailed project plan
- Definition of the release process (number of release cycles per year)
- Detailed design of the technical architecture for 24/7 availability and zero-downtime patching
- Planning, moderation and participation in workshops and meetings in Miro
- Presentation of project results in terms of their impacts, deteriorations and improvements on the business side
- Authorization concept (Need-2-Know) with user groups, roles and access rights
- Preparation of an action catalogue with options, grouped by business organization, including costs and impacts per option
Lead Business Functional Analyst Data and Analytics CTB
Deutsche Bank Luxembourg
- Business analysis and data analysis services for AML (methodology: Scrum)
- Data analysis services for EMEA covering AML, AFC, transaction monitoring, compliance, KYC, regulatory reporting and risk reporting
- Analysis of fact and dimension data as well as metadata (XML, JSON)
- Mapping of RDM DWH and CCO datamart requirements to the data source of the Avaloq core banking system
- Test case creation and development of expected results in Avaloq
- Test data selection with Avaloq and Oracle SQL
- Requirements engineering for the Avaloq core banking system
- Test documentation and defect registration in Jira
- Monitoring and installation support for the Regional Datamart Team
- Unix change requests and service request lifecycle in ServiceNow
Business Analyst
BNP Paribas Luxembourg
- Business analysis and business testing UAT for the LHS Global BCM TA project (methodology: Scrum)
- Migration of SWIFT, sFTP and CFT reporting from Luxembourg to Paris
- Analysis of TA reporting processes (Temenos Multifonds, eStars) and SWIFT message routing
- Workshops with BCM, Application Support and IT
- Configuration of HP ALM Quality Center
- Test case creation and development of expected results
- Test data selection with SQL and test data creation for Multifonds order processes
- Test execution, test documentation and defect registration
- Design and automation of daily test status reporting
Business Analyst
Nord/LB Norddeutsche Landesbank Hannover
- Business analysis of the SPOT data model DWH (methodology: Scrum)
- Analysis of banking requirements in credit, collateral, bank management, regulatory reporting, market data and reporting
- Functional analysis of all layers of the SPoT DWH and SAP FSDP (CDM/PDM) with PowerDesigner
- Collaboration with DataStage developers in Scrum sprints
- Consulting on test portfolio design and support for development and business tests
- Data mapping with descriptive SQL statements
- Analysis of MDE errors and development of proposed solutions
- Data mapping from Murex, WM DATEN, OBS and others to the SAP FSDP data model (market data, risk, ESG)
Business Analyst
Baader Bank AG
- Further development of regulatory reporting (methodology: Scrum)
- Error analysis in the transaction reporting tool and documentation in the backlog and Jira
- Creation of an error log and correction of errors in accordance with Article 26, Article 27, RTS
- Creation of requirements analyses, epics, stories, features and tasks
- Development of new functionalities for the regulatory reporting GUI prototype
- Interviews with stakeholders from the Regulatory Reporting department
- Creation of a recommendation for handling errors in the reporting environment (ESG)
- Code review of the regulatory reporting tool with regard to regulatory requirements (MiFIR, MiFID II, FCA, SIX, OeKB, CSDR, SFTR, LCR, CRR)
- Creation of detailed documentation of changes and test cases
Business Engineer
ZKB Zürcher Kantonalbank
- Senior regulatory projects in investment business (methodology: Scrum/Kanban/SAFe)
- Analysis of regulatory business requirements for AIA (AEOI), FATCA and QI for ZKB-Connect
- Preparation and facilitation of workshops to gather requirements and define acceptance criteria
- Organization and moderation of kick-off meetings with all stakeholders
- Creation of requirements and detailed specifications, epics, user stories and features
- Execution of the acceptance process with all stakeholders
- Design of business and technical solution proposals, sketches, user interaction design and user flows
- Creation and execution of test cases (X-Ray), including defect management in Jira
- Creation of training materials and user documentation
Business Analyst
DekaBank S.A.
- Further development projects in custody business (methodology: Scrum)
- CI/CD pipeline for DWH objects, interfaces and datamarts
- Derivation of business requirements from MiFIR, EMIR, AEOI (AIA), GDPR (DSVGO) and ESMA AI reports in accordance with Article 9 CSDR
- Transaction reporting on IBM-DB2
- Definition of business processes and gathering of complete requirements
- Project status reporting with HP ALM
- Product backlog management, sprint execution and release management
- Stakeholder management and maintenance of the stakeholder list
- Change management and prioritization of requirements
- Reporting for quality and risk management
- Test automation with VBA SendKeys scripts for DOLL and PM1e
Project Manager
European Stability Mechanism
- Interface between users and developers
- Preparation of the preliminary study and creation of the ESM Project Charter
- AS-IS situation analysis using data sources Murex, Bloomberg and Access
- Dashboard visualization with VBA Excel and PowerPoint
- Specification of system requirements and system architecture
- Definition of operational business processes and transformation into system requirements
- Creation of a cross-functional framework business concept
- Creation of business concepts for liquidity and risk management
- Preparation of procurement planning, RFI documentation and preliminary selection of RFP suppliers
- Drafting of the project plan for solution implementation and strategic reporting
- Organization of project meetings, project status reporting and SharePoint administration
Business Analyst
HSBC INKA
- «Reporting Innovations» projects (methodology: Scrum)
- Migration concept for INKA e-reporting
- Creation of UX mockups and technical descriptions of XML structures
- Management of the product backlog and sprint backlog
- Development of the configuration concept for AIM-Bloomberg
- Organizational transition concept for KAGB implementation
- Definition of the test strategy and creation of test concepts
- Organization of periodic stakeholder meetings
- Defect management and test status reporting with Cognos reports
Business Analyst
DekaBank S.A.
- Customer onboarding and customer output projects (methodology: Waterfall, ITIL)
- Analysis of migration concept for LBBW Luxembourg and VM Bank International
- Requirements analysis for Olympic customer output, tax and year-end mandatory mailings
- Calculation of portfolio holdings and securities settlements for individual securities
- Technical prototype with SQL on IBM-DB2 and simulation of SWIFT messages
- SCRUM implementation of «New Output Tool» with microservices and web frontend
- Load and performance tests with VBA SendKeys
- Defect management with Bugzilla and partial automation via VBA Access and Cognos
Business Analyst
BNP Paribas Securities Services
- Central multi-region DWH project (methodology: CMMI)
- Concept phase, correction and detailing of functional specifications
- Stakeholder management and coordination with international suppliers
- Data basis for Multifonds FA mapping and XML schema configuration
- Test laboratory setup, test case recording, test execution and status monitoring
- Test status reporting with HP Quality Center
- Execution of mass tests in 3-shift operation
- Daily videoconference training for external developers and testers in Chennai
- Documentation of user manuals and Multifonds training materials
Business Analyst
ING Investment Management
- Multifonds business processes project (methodology: CMMI, Prince2)
- Preparation of preliminary study for mortgage-backed securities
- Functional specification, configuration and implementation concept
- Preparation of interdependencies matrix and release planning
- User training and operations and maintenance organization
- Creation of test concept for ABS/MBS trading lifecycle and UML modeling
- Test data criteria catalogue and test case documentation
- Defect management with Mercury Test Director
Business Analyst
UBS Fund Services S.A.
- Tax reporting and regulatory reporting for funds (methodology: ITIL)
- Preparation of functional specifications for CRS, FATCA and investment funds in DE, AT, CH
- Preparation of reporting based on GP3 Global Portfolio Sungard, Reuters and Bloomberg
- Reporting for financial supervisory authorities and central banks (EZB, BCL, OeKB, BaFin, FMA, MFSA, FINMA, FSA, HKMA, CSSF)
- Support for business departments during GP3 acceptance testing
Business Analyst
IQ Solutions S.à.r.l.
- Regulatory and tax topics (Solvency Regulation, fund taxes, GroMiKV, BVI, DPG)
- Analysis of MIG21 interface changes
- Refinement of functional specifications and interface descriptions
- Creation and execution of test cases with Multifonds FA upgrade
- Tax data mapping for GTS application (Microsoft DB)
- Creation of configuration concept and definition of test environments
- Test status reporting and defect management with HP Quality Tester and CoolTester
- Documentation of test case execution
Business Analyst
Citigroup International Ltd
- Business Requirements Documents and stakeholder meetings in English
- Release management and first-/second-level support for Multifonds TA/FA (Oracle DB)
- Prototype development of an investment restrictions database (Access VBA)
- Data mapping (MFFA, Bloomberg API, MSCI Index, benchmark, rating tables)
- System migration MIG21 and Transfer Agency Reporting MFTA
- Data delivery to Euroclear Fundsettle, Clearstream Vestima and SWIFT Migration
- UAT test execution with Mercury Test Director
Transfer Agent
Union Investment Asset Management AG
- Maintenance of master data in Multifonds TA at Attrax S.A.
- KYC checks and system parametrization of distribution fee agreements
- Support for fund price and exchange rate interfaces
- Execution of custody account transfers
- Development of STP custody holdings provision, distribution statistics and reports using Oracle ODBC, MS Access VBA, MS Query SQL and Excel
- Fund registration procedures for UCITS, FCP, SIF, SICAV, SICAF
- Daily control of holdings and sight deposit accounts, AML and NAV consistency checks
- Reporting of active investment limit breaches to regulatory authorities
- NAV valuation of funds of funds and migration from Excel to MFFA software
- Booking of unit transactions, capital movements and corporate actions
- Preparation of reporting for general meetings and periodic fund price publication
- Support for auditors
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Quality Assurance, Project Management, Finance, and Operations.
Summary
My knowledge includes business analysis, requirements management, requirements engineering, project management, change and test management, test execution, parameterization and software programming, mainly for core banking and financial systems (Avaloq, Olympic, SimCorp Dimension, Multifonds, GP3, PM1, SAP) in project roles as BA, BE, PM, PO and QA. More than two decades of operational experience and expertise in the financial industry and IT form my foundation. I supported international banks, private financial institutions and government financial institutions of the EU at various locations. My range of professional expertise includes financial management, investment fund administration, custodian banking, treasury, credit, risk management, controlling, regulatory reporting, audit, compliance, sustainable development (UN PRI, UN PRB, SDG, ESG), sustainability management and sustainable finance. My characteristic values are a structured way of working, systematic problem-solving, professionalism, integrity, trustworthiness, reliability, punctuality, a positive attitude, sound judgment, resilience under stress, proactivity, pragmatism, efficiency, positive thinking, empathy and the ability to work in a team.
Skills
Programming
- Sql (Oracle, Db2, Microsoft)
- Vba (Excel And Access)
Methodology
- Sdlc
- Cmmi
- Itil
- Pmbok
- Waterfall
- Prince2
- Hermes
- Agile
- Safe
- Scrum
- Bpmn 2.0
- Istqb
- Babok
- Ux
Operating Systems
- Ibm-As400
- Windows 10
- Unix
- Mac Osx 10.11
- Linux
Software
- Avaloq
- Olympic (A03)
- Powerdesigner
- Sap Datasphere
- Sap Calm
- Sap Fsdp (Cdm|Pdm)
- Miro
- Jira
- Confluence
- Bitbucket
- Servicenow
- Zkb-Connect
- Pm1e
- Kuno
- Ors
- Tukan
- Doll
- Murex
- Simcorp Dimensions
- Multifonds Fa
- Multifonds Ta
- Multifonds Infocenter (Fa/Ta)
- Sungard Gp3
- Mig21
- Financekit
- Charles River
- Engageone
- Sap Saas
- Docbridge
- Businessobjects
- Toad
- Squirrel
- Adonis
- Ms Visio
- Bugzilla
- Micro Focus Alm Octane
- Hp Alm
- Hp Open View
- Hp Quality Center
- Hp Quality Tester
- Mercury Test-Director
- Cooltester
- Db2
- Oracle
- Query Builder
- Tableau
- Cognos
- Report Builder
- Crystal Reports
- Informatica
- Sql-Plus*
- Pl Sql-Developer
- Actuate
- Wm Daten
- Bloomberg (+Excel Addin)
- Reuters (+Excel Addin)
- Telekurs
- Wvs
- Ms Project
- Cosofin
- Swift
- Xml
- Adobe Creative Suite
- Grammarly
- Zotero
- Zoom
- Lotus Notes
- Office-365-Office-Suite Enterprise Edition
- Word
- Excel
- Powerpoint
- Access
- Ms Query
- Power Query
- Microsoft Teams
- Sharepoint
- Exchange
- Skype
- Onedrive
- Onenote.
Languages
Education
Economics
SRH
Bachelor of Arts in Sustainability Management, focus on ESG sustainable finance · Sustainability Management · Berlin, Germany
Pôle Universitaire Euclide
MBA Sustainable Development · Sustainable Development · Serrekunda, Gambia
Certifications & licenses
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
Achim speaks the following languages: German (Native), English (Advanced), French (Advanced), Luxembourgish (Advanced).
Achim has at least 25 years of experience. During this time, Achim has worked in at least 6 different roles and for 16 different companies. The average length of individual experience is 2 years and 6 months. Note that Achim may not have shared all experience and actually has more experience.
Based on recent experience, Achim would be well-suited for roles such as: Senior Business Analyst, Project Manager, Lead Business Functional Analyst Data and Analytics CTB.
Achim's most recent position is Senior Business Analyst at VP Bank AG.
In recent years, Achim has worked for VP Bank AG, Bank Frick AG, Deutsche Bank Luxembourg, BNP Paribas Luxembourg, and Nord/LB Norddeutsche Landesbank Hannover.
Achim is most experienced in industries like Banking and Finance.
Achim is most experienced in business areas like Information Technology, Business Intelligence, and Quality Assurance. Achim also has some experience in Project Management, Finance, and Operations.
Achim has recently worked in industries like Banking and Finance.
Achim has recently worked in business areas like Information Technology, Business Intelligence, and Finance.
Achim holds a Master in Sustainable Development from Pôle Universitaire Euclide, a Bachelor in Sustainability Management from SRH and a Bachelor in Economics from Hochschule für Wirtschaft und Umwelt Nürtingen.
Achim has 5 certificates. Among them, these include: Operational Aspects of Sustainable Finance (Advanced), Sustainable Finance (Foundation), and ISTQB.
Achim is immediately available for suitable projects.
Similar freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Senior Business Analyst
