Achim Gschwend-Senior Business Analyst
Check rate
Experience
Senior Business Analyst
VP Bank AG
- Business analysis for the Group Controlling department (Methodology: Scrum)
- Creation of a business structure tree for cash flows
- Development of business definitions and requirements for cash flows
- Business analysis of net new money, new loans, custody net new money, third-party bank net new money, and product revenue in Avaloq
- Conducting regular stakeholder workshops with Group Controlling team specialists
- Functional analysis with the Avaloq core banking system
- Avaloq test parameterization of Classes/ClassIf at business process, position, container, and asset levels
- Technical workshops with Avaloq specialists
- Data mapping with Avaloq
- Describing business models for Group Controlling and functional models for Avaloq IT specialists
- Obtaining and documenting business approvals
- Documenting business requirements in SAP CALM
- Creating test cases in SAP CALM
- Running the weekly Metis Business Table (stakeholder engagement)
- Participating in and reporting at Metis project meetings and stand-ups
Project Manager
Bank Frick AG
- Developing and creating a concept document, including presentation and management summary
- A proposal for the implementation phase presented to the board
- Capturing, analyzing, and visually representing requirements and the current state of contracts and components
- Identifying possible adjustments in COBOL, SQL, and RPG
- Detailed breakdown of expected project costs (OPEX) and investments (CAPEX)
- Creating a detailed project plan
- Defining the release process (number of releases per year)
- Detailed design of the technical architecture for 24/7 availability and zero-downtime patching
- Planning, moderating, and participating in workshops and meetings in Miro
- Documenting project results in terms of impacts, drawbacks, and improvements for the business side
- Developing an authorization concept (need-to-know) with user groups, roles, and access rights
- Creating a catalog of actions with options, grouped by business area, including costs and impacts for each 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 requirements for RDM DWH and CCO datamart to the data source in the Avaloq core banking system
- Creating test cases and defining expected results in Avaloq
- Selecting test data with Avaloq and Oracle SQL
- Requirements engineering for the Avaloq core banking system
- Test documentation and defect logging in Jira
- Regional datamart team monitoring and installation support
- Handling Unix change requests and service request lifecycle in ServiceNow
Business Analyst
BNP Paribas Luxembourg
- Business analysis and UAT business testing 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
- Configuring HP ALM Quality Center
- Creating test cases and defining expected results
- Selecting test data with SQL and creating test data for Multifonds order processes
- Test execution, documentation, and defect logging
- Designing and automating the daily test status reporting
Business Analyst
Nord/LB Norddeutsche Landesbank Hannover
- Business analysis of the SPOT data warehouse model (Methodology: Scrum)
- Analyzing banking requirements in credit, collateral, bank controlling, regulatory reporting, market data, and reporting
- Functional analysis of all layers of the SPOT DWH and SAP FSDP (CDM/PDM) using PowerDesigner
- Collaborating with DataStage developers in Scrum sprints
- Advising on test portfolio design and supporting development and business tests
- Data mapping using descriptive SQL statements
- Analyzing MDE errors and developing solutions
- Data mapping from Murex, WM DATEN, OBS, etc. to the SAP data model FSDP (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
- Created an error log and fixed issues according to Article 26 and Article 27 RTS
- Prepared requirement analyses, epics, stories, features, and tasks
- Developed new features for the regulatory reporting GUI prototype
- Conducted interviews with stakeholders from the regulatory reporting team
- Provided recommendations for error handling in the reporting environment (ESG)
- Reviewed code of the reporting tool for regulatory compliance (MiFIR, MiFID II, FCA, SIX, OeKB, CSDR, SFTR, LCR, CRR)
- Produced detailed documentation of changes and created test cases
Business Engineer
ZKB Zürcher Kantonalbank
- Senior regulatory projects for asset management (methodology: Scrum/Kanban/SAFe)
- Analyzed regulatory requirements for AIA (AEOI), FATCA, and QI for ZKB-Connect
- Prepared and conducted workshops for requirements gathering and acceptance criteria
- Organized and led kick-off meetings with all stakeholders
- Created requirement and detailed specifications, epics, user stories, and features
- Managed the acceptance process with all stakeholders
- Designed business and technical solution proposals, sketches, user interaction designs, and user flows
- Created and executed test cases (X-Ray), including defect management in Jira
- Developed training materials and user documentation
Business Analyst
DekaBank S.A.
- Enhancement projects in the custody business (methodology: Scrum)
- CI/CD pipeline for DWH objects, interfaces, and datamarts
- Gathered functional requirements from MiFIR, EMIR, AEOI (AIA), GDPR, and ESMA AI reports according to Article 9 CSDR
- Transaction reporting on IBM DB2
- Defined business processes and collected complete requirements
- Managed project status reporting with HP ALM
- Led product backlog, performed sprints, and managed releases
- Conducted stakeholder management and maintained the stakeholder list
- Managed changes and prioritized requirements
- Provided reporting for quality and risk management
- Automated tests with VBA SendKeys scripts for DOLL and PM1e
Project Manager
European Stability Mechanism
- Acted as liaison between users and developers
- Wrote the feasibility study and created the ESM project charter
- Conducted AS-IS analysis using data from Murex, Bloomberg, and Access
- Created dashboard visualizations with VBA in Excel and PowerPoint
- Defined system requirements and system architecture
- Outlined operational business processes and converted them into system requirements
- Created a cross-departmental framework concept
- Developed technical concepts for liquidity and risk management
- Prepared procurement planning, RFI documents, and pre-selection of suppliers for RFP
- Drafted project plan for solution implementation and strategic reporting
- Organized project meetings, project status reporting, and managed SharePoint
Business Analyst
HSBC INKA
- Projects "Reporting Innovations" (methodology: Scrum)
- Developed migration concept for INKA e-reportings
- Created UX mockups and technical descriptions of XML structures
- Managed the product backlog and sprint backlog
- Developed the configuration concept for AIM-Bloomberg
- Developed the organizational transition concept for KAGB implementation
- Defined test strategy and created test concepts
- Organized periodic stakeholder meetings
- Managed defects and reported test status using Cognos reports
Business Analyst
DekaBank S.A.
- Customer onboarding and customer output projects (Methodology: Waterfall, ITIL)
- Migration concept analysis for LBBW Luxembourg and VM Bank International
- Requirements analysis for Olympic customer output, tax and year-end obligation dispatch
- Calculation of custody balances and individual securities settlements
- Technical prototype using 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 data warehouse project (Methodology: CMMI)
- Concept phase, correction and refinement of business specifications
- Stakeholder management and coordination with international vendors
- Data foundation for multi-fund FA mapping and XML schema configuration
- Test lab setup, test case documentation, test execution and status monitoring
- Test status reporting with HP Quality Center
- Execution of mass tests in a 24/7 operation
- Daily videoconference training for external developers and testers in Chennai
- Documentation of user manuals and multi-fund training materials
Business Analyst
ING Investment Management
- Multi-fund business processes project (Methodology: CMMI, Prince2)
- Feasibility study for mortgage-backed securities
- Business specification, configuration and implementation concept
- Creation of interdependency matrix and release planning
- User training and operations and maintenance organization
- Test concept creation for ABS/MBS trading lifecycle and UML modeling
- Test data criteria catalog and test case documentation
- Defect management with Mercury Test Director
Business Analyst
UBS Fund Services S.A.
- Tax reporting and regulatory fund reporting (Methodology: ITIL)
- Creation of business specifications for CRS, FATCA and investment funds in DE, AT, CH
- Reporting based on GP3 Global Portfolio Sungard, Reuters and Bloomberg
- Reporting for financial regulators and central banks (ECB, BCL, OeKB, BaFin, FMA, MFSA, FINMA, FSA, HKMA, CSSF)
- Support for business units during GP3 user 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 business specifications and interface descriptions
- Creation and execution of test cases for multi-fund 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 multi-fund 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 testing with Mercury Test Director
Transfer Agent
Union Investment Asset Management AG
- Master data maintenance for multi-fund TA at Attrax S.A.
- KYC checks and system parameterization of distribution fee agreements
- Maintenance of fund price and exchange rate interfaces
- Processing of securities account transfers
- Development of STP holdings provisioning, 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 holdings and cash account reconciliation, AML and NAV consistency checks
- Reporting of active investment limit breaches to regulatory authorities
- NAV valuation of umbrella funds and migration from Excel to MFFA software
- Booking of unit transactions, capital movements, and corporate actions
- Preparation of annual general meeting reporting and periodic fund price publications
- 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 skills include business analysis, requirements management, requirements engineering, project management, change and test management, test execution, parameterization and software programming mainly for core banking systems and financial systems (Avaloq, Olympic, SimCorp Dimension, Multifonds, GP3, PM1, SAP) in roles such as BA, BE, PM, PO and QA. Over two decades of hands-on experience and expertise in the financial industry and IT form my foundation. I have supported international banks, private financial institutions and EU public financial institutions at various locations. My professional knowledge covers financial management, investment fund management, 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 core values are structured work, systematic problem solving, professionalism, integrity, trustworthiness, reliability, punctuality, a positive attitude, sound judgment, stress resistance, proactivity, pragmatism, efficiency, positive thinking, empathy and teamwork.
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
Operational Aspects of Sustainable Finance (Advanced)
Chambre de Commerce Luxembourg
Sustainable Finance (Foundation)
Chambre de Commerce Luxembourg
ISTQB
ITIL
Prince2
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
What languages does Achim speak?
How many years of experience does Achim have?
What roles would Achim be best suited for?
What is Achim's latest experience?
What companies has Achim worked for in recent years?
Which industries is Achim most experienced in?
Which business areas is Achim most experienced in?
Which industries has Achim worked in recently?
Which business areas has Achim worked in recently?
What is Achim's education?
Does Achim have any certificates?
What is the availability of Achim?
What is the rate of Achim?
How to hire Achim?
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
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
