Warsaw, Mazowieckie, Poland
For couple of years I’ve been working (and trying to fill the gap) between IT and business, mostly by creating reporting tools for managing staff. I know BI (Business Intelligence) software as well as wide range of DBs including most popular vendors. I’m familiar with full lifecycle of a project-from business requirements analysis to final release stage. I understand (and enjoy) specifics of working for multinational companies where different cultures, providers and needs meet.
• ARM/EMIR/SFTR reporting systems re-development&design, bug-fixing&maintenance, which ends up with sending/receiving tons of XML files to KDPW (The Central Securities Depository of Poland) • Tools/technologies involved: Informatica PowerCenter, Oracle SQL Developer, Oracle Exadata, SourceTree+BitBucket+SonarQube+JIRA+Confluence+TeamCity (maybe?)
• Designing the structure of new BI solution (SAP HANA DB+SAP BO) for all Ericsson spare parts warehouses • Business analysis of reports in scope for other developers (data sources/layout/queries definition) • Report development, calculation views preparation • Developing ETL flows between source DBs and main data warehouse • Tools/technologies involved: SAP Power Designer, SAP BO Suite, SAP HANA Data Services Designer, SAP HANA XS, SAP HANA Studio, Oracle SQL Developer, SourceTree+BitBucket+JIRA+Confluence
• reporting current telecom infrastructure parameters basing on data from systems offered by client, KPI changes according to given algorithms • designing, developing and testing new ETL flows, system integration, ad-hoc MSSQL database administration • on-site consultation concerning BI solution offered by the company, cost&leadtime estimation of parts of the projects regarding BI • Tools/technologies involved: SAP BusinessObjects Platform, Oracle SQL Developer, SQL Server Management Studio+SSIS+SSAS+MS SQL DB, SourceTree+BitBucket
• developing of ETL flow processes between bank systems (data migration and Raffeisen-Polbank client porfolio) • bugfixing, technical test support • minor optimalisation of created data flows • cooperation with business, consultation, test results revision, verification of business requirements in terms of capabilities and how to implement them • post migration reporting-short term BI project • Technologies used: ODI (Oracle Data Integrator), Oracle DB 11g, Oracle SQL Developer, Tortoise SVN (version control), HP Quality Center (quality control and tests)
• Reporting of current sales in the shops, automation of the reporting process, further development of reporting tools • Support for analytics team and CFO of the group, ad hoc reports • Integration of data flow between cash systems, local DWH, warehouse system, BI tools • Creation, implementation and support of program used as automatic ordering tool for shops and category managers in company • Technologies used: VBA, T-SQL, MS-SQL (including SSIS, SSRS and SSAS), OLAP cubes, C#, WinForms/WPF, ASP.NET recently
• migration of correspondence from old to new archivisation system • changes/updates in the website (registration system for election experts) • Technologies used: PHP/MySQL/JavaScript/SQL/MS SQL 2008