The migration project from MS BI Stack 2008 to 2018 – one of the largest Microsoft BI installation in Europe, changes of data centers and suppliers: from IBM to ATOS. 60+ different BI applications.

• responsible for coordinating the technical effort and fixing performance issues which were blocking the progress of the migration project
• providing expertise, proposals of solutions and IT-architecture changes in the area of Microsoft SQL Server / BI stack
• cooperation with 3rd party suppliers, prioritization and inspection of work results, planning their activities and setting expectations
• designing the technical approach to the critical part of the migration project
• cooperating with in-house and 3rd party architects
• identifying potential root causes and proposing resolution steps

Strategic Management Information System (Tier-1 criticality with storage and processes under external audits – Ernst&Young) gathering and reporting bank-wide FOREX related data. The output used for: the risk management according to BASEL II regulations. overall bank’s exposure on the FX market, sales distribution, tracking of the FX revenue, fulfilling requests from regulators: SNB, EU, LBMA etc.. The system is used globally with dedicated secure zone for Swiss Customers

• technically responsible and serving as a technical Point of Contact for the System
• leading the development cycle, coordinating end-to-end processes from requirements gathering to production implementations
• coordinating work and cooperating with 3rd party suppliers: HCL, EPAM, Accenture
• architecting and designing of IT solutions to address business requirements
• adjusting the System to changes in operating models, according to ITIL processes in ServiceNow
• preparing for the new migration with focus on critical steps and milestones, evaluating and proposing the Cloud design: IIS, SQL Server, SSAS, Microsoft BI Stack, Azure
• coordinating the technical effort for the MUREX integration
• requirements management, consulting and preparing technical specs for developers
• working with clients, providing liaison, ongoing communication, managing expectations
• recruiting new team members, know-how transfer

• coordinating the development cycle for a BI component of the System, cooperating with the management on end-to-end processes
• managing business requirements, consulting and preparing technical specifications for developers
• architecting of IT solutions
• coordinating work done by other 3rd party suppliers
• providing 3rd line level support / troubleshooting for the reporting solution (Oracle, SQL Server, SAP BO) and related windows applications

• gathering business requirements for the Transition to the new Datawarehouse / BI system
• proposing design solutions to meet business expectations
• Developing code / troubleshooting in PL/SQL
• Training of a new employee

• consulting technical specifications, providing expertise in OLAP  and related solutions, gathering business requirements/ analyzing business needs
• proposing and designing of reporting solutions
• developing and delivering reports ,PL/SQL code/ troubleshooting
• providing the technical support for reports in an in-house application
• cooperating with other 3rd party suppliers

Traveller Data Warehouse. The largest data warehouse and business intelligence system in the travel industry, based on Teradata, containing 50% + of worldwide flight bookings including the  passenger data.

• managing data warehouse projects for internal and external customers, projects usually in Agile methodology
• coordinating work of other developers, 3rd party suppliers: India, Poland, USA
• cooperating with other departments : USA, Germany
• proposing technical solutions, architectures
• verifying with business users if delivered solutions are in line with their expectations
• co-recruting new team members

SFA-CRM systems with dedicated BI solutions for FMCG companies: Agros, Wawel, Wilbo, etc.

• managing SFA-CRM and data warehouse projects for FMCG Companies, mainly in PMI methodology
• consulting technical specifications ; requirements gathering
• maintaining good relationships with Clients
• supervising work done by developers, writing system specifications for them, training a new Project Manager
• architecting olap and reporting solutions ; advising in database, olap performance tuning, maintaining and changing olap servers architecture
• productizing the business intelligence solution

• creating olap cubes – MS BI Stack, developing T-SQL in SQL Server
• maintaining and providing technical support for existing olap cubes – outsourcing for Comarch’s clients
• db performance tuning for transactional queries and for data warehouses’ tasks