Designed and built several SQL query reports within BigQuery (Google Analytics cloud DB) for a Consumer 360 project. Nespresso had a requirement to extract details of customer activities on the eCommerce Platform from Google Analytics to gain insight into their online behaviours and link the data to customer shopping patterns extracted from Nespresso ERP system within the Customer Knowledge Repository. Designed and built six CRM reports (SAP BO WEBI) for Nespresso CRM Insights team… Show more Designed and built several SQL query reports within BigQuery (Google Analytics cloud DB) for a Consumer 360 project. Nespresso had a requirement to extract details of customer activities on the eCommerce Platform from Google Analytics to gain insight into their online behaviours and link the data to customer shopping patterns extracted from Nespresso ERP system within the Customer Knowledge Repository. Designed and built six CRM reports (SAP BO WEBI) for Nespresso CRM Insights team, focusing on Active/Passive consumer insights and churn analysis. Designed and built two B2B reports analyzing customer behaviours related to payments and invoices. The second report focused on Customer Data Quality within Nespresso ERP System. Managed development and testing phase of an external adapter developed by SAP for SAP HANA SDI. The adapter provides direct connectivity to the BigQuery DB. This will allow for a fully automated data flow. Show less

Designed global SAP BO Universe (Business Layer) of Nespresso’s ERP system utilizing Oracle 11. The solution is currently used by B2B, B2C & CRM teams.Designed and built architecture and report to analyse the digital performance of Nestlé brands. The report automatically pulls in data from the key social media platforms (Facebook, Twitter, Instagram and Google Analytics). It also analyses Nestlé's main competitors and their digital activity. Designed and built Corporate Media… Show more Designed global SAP BO Universe (Business Layer) of Nespresso’s ERP system utilizing Oracle 11. The solution is currently used by B2B, B2C & CRM teams.Designed and built architecture and report to analyse the digital performance of Nestlé brands. The report automatically pulls in data from the key social media platforms (Facebook, Twitter, Instagram and Google Analytics). It also analyses Nestlé's main competitors and their digital activity. Designed and built Corporate Media Relations digital dashboard (SAP Design Studio) focused on consumers interactions on social platforms (Facebook, Twitter, YouTube) and Nestlé Corporate websites (Google Analytics).Designed and implemented Architecture and Dashboard (SAP Design Studio) of MTM (Metrics That Matter) to understand precisely the business impact of each digital campaign (Facebook, Instagram, Twitter, YouTube, Google Analytics, and Google AdWords). The Metrics that Matter dashboard aims at simplifying the analysis and optimization of marketing campaign budget.Built several Digital dashboards for the Digital Acceleration Team showing social digital analysis and geo-analysis of consumer feedback. Designed and built business layer (SAP BO Universe) for the Consumer Feedback - Product Defect Tracking tool (CF-PDT). This solution provides access to multi-Market views of consumer feedback of Nestle products and brands collected by Consumer Engagement Services (ENGAGE, Conso+, Connect and Legacy systems). Built around 25 reports which analyse consumer reactions and communications, focusing on negative feedback elimination. Designed and built global CRM reporting data model – CCID (Consumer Centric Information Database). Responsible for building several CRM reports including a Consumer Pulse report, one of top 20 global reports, based on usage. Provided training for various business users. Show less

Designed and built Architecture and Front-end of many mobile (SAP BO WEBI MOBILE) applications including Global Market Head Dashboard which analyses Zones/Markets/Brands finance performance. The solution won the second prize at the Nestlé CIO awards.

The UBS bank needed a dashboard, which would have helped in the analysis of the Real Estates: number of employees, nearest cataclysms: like earthquakes, volcano eruptions, tsunami around the buildings, etc.Responsible for:• Business requirements gathering• Development of MIS (Management Information System) queries based on SAP BW• Design and development of the Geo/Real Estate dashboards in SAP Dashboard Design (Xcelsius) and GMap (Centigon).• Coordination and… Show more The UBS bank needed a dashboard, which would have helped in the analysis of the Real Estates: number of employees, nearest cataclysms: like earthquakes, volcano eruptions, tsunami around the buildings, etc.Responsible for:• Business requirements gathering• Development of MIS (Management Information System) queries based on SAP BW• Design and development of the Geo/Real Estate dashboards in SAP Dashboard Design (Xcelsius) and GMap (Centigon).• Coordination and management of the 2 offshore groups of developers: London, Bangalore.• Training for the Business Users and Stakeholders Show less

Timely report development according to business requirements using Web Intelligence Rich Client/Desktop Intelligence (Business Objects 5.1.5 and SAP BO XI R3.1 ). Designing and developing universes. Rebuilding and upgrading existing reports in Freehand SQL queries (Oracle 10). Gathering reporting requirements from internal departments. Preparing reports for the future implementation of the Xcelsius 2008 (BIWS).

The goal of this project is to find a potential performance issues and to check if everything is set correctly on SAP BO XI and SAP BO 4.0.As the External Technical Specialist I am involved in:- Doing Due diligence of the current state of the SAP BO XI R3.1 SP3/SAP BO 4.0 environments. - Understanding, analyzing of the all installations (CCM), configurations (CMC), settings (CMC), security of the server, clusters and Tomcat. - Auditing the universes (Designer/Info… Show more The goal of this project is to find a potential performance issues and to check if everything is set correctly on SAP BO XI and SAP BO 4.0.As the External Technical Specialist I am involved in:- Doing Due diligence of the current state of the SAP BO XI R3.1 SP3/SAP BO 4.0 environments. - Understanding, analyzing of the all installations (CCM), configurations (CMC), settings (CMC), security of the server, clusters and Tomcat. - Auditing the universes (Designer/Info Design Tool), connections (Designer Info Design Tool), dashboards/KPIs (Xcelsius 2008/SAP Dashboard Designer) and checking if they were created using best practices.- Advising BO Team how to solve issues and how to improve performance on the servers and users site.- Making suggestions and recommendation of the future state.As the result of the due diligence findings will be detailed document. Document will also contain strategy of the software and hardware upgrades, best practices procedures of creating backups, schedules and optimized universes. Show less

The goal of ZFS is to be among top Insurance Companies in the world. This can be achieved based on important KPI’s identified and to be presented in Executive Dashboard in Xcelsius 2008 SP4. This Dashboard supportsDrilldown capability and What-if scenarios. Dashboard is populated using multiple data sources (SAP BW Cubes, Queries, IBM DB2 and Flat Files). Integration of SAP BW system and SAP BO R3.1 is maintained using SAP Integration Kit. Dashboard is designed as an… Show more The goal of ZFS is to be among top Insurance Companies in the world. This can be achieved based on important KPI’s identified and to be presented in Executive Dashboard in Xcelsius 2008 SP4. This Dashboard supportsDrilldown capability and What-if scenarios. Dashboard is populated using multiple data sources (SAP BW Cubes, Queries, IBM DB2 and Flat Files). Integration of SAP BW system and SAP BO R3.1 is maintained using SAP Integration Kit. Dashboard is designed as an online solution using QaAWS/BIWS (BI Web Services), SAP BW Connection/Cundus Connector (external Add-on).As a Lead developer I was:- Involved in Due diligence.- Conducting JAD and requirements gathering workshops, knowledge transfers, etc.- Involved in With Business team to understand, analyze, record requirements and provide a solution for Design Dashboard, Webi Reports, and Universes.- Developing best practice of: Dashboard/What-If (Xcelsius), Universes (Designer) Webi AD Hoc Reports (Webi/Rich Client).- Involved in designing Conceptual Data Model, Writing HLD (High Level Design) and other documents.- Involved in preparing presentations and giving demo to the business. - Ensuring full QA and backwards compatibility of dashboards and reports solutions. Show less

Design of: universes, reports, dashboards on SAP BO Enterprise XI R2/R3.1 based on different modules of thePLANVIEW Enterprise with the use of: Designer, Xcelsius, Web Intelligence, And Web Intelligence Rich Client. Building new and changing existing universes based on the current report needs. Designing and participating in report development.

Configuring LDAP authentication and JDBC authorization in Pentaho BI 3.8. Analysing Repository of JDEdwards and Pentaho BI. Designing and implementing ETL processes based on current framework (Pentaho Data Integration) responsible for mapping permissions and access control list model from JDE to Pentaho BI. Writing documentation.

Provide billable consulting support to achieve account objectives and production success (product installation and implementation, enhancement, integration, or audit to meet customer business requirements, Understanding of core Business Intelligence (BI)/data warehousing technology: RDBMS such as SQL Server, Oracle, DB2 and Teradata, Web, Client/ Server, and OLAP (Cognos, Business Objects, MicroStrategy). Prepare and make offers, do the analysis of the projects.

Work as a member of Tech Support Team of SAP Business Objects XI R3.1. Creating groups, users, privileges. Creating lists of objects and create new Jobs with content from source-system in LCM (LifeCycle Manager). Migrating content source-system into target-system. Generating BIAR files. Testing various packages of installations.

Design of: universes, reports, dashboards on SAP BO Enterprise XI R3.1 SP2 with the use of: Designer, Xcelsius, Live Office, Web Intelligence, Web Intelligence Rich Client . Design of the new data warehouse of different data sets. Troubleshoot and support end users. Model and design data by Oracle SQL Developer Data Modeler. Building new and changing existing universes based on the current report needs. Writing views in Oracle. Designing and participating in report development. Writing scripts… Show more Design of: universes, reports, dashboards on SAP BO Enterprise XI R3.1 SP2 with the use of: Designer, Xcelsius, Live Office, Web Intelligence, Web Intelligence Rich Client . Design of the new data warehouse of different data sets. Troubleshoot and support end users. Model and design data by Oracle SQL Developer Data Modeler. Building new and changing existing universes based on the current report needs. Writing views in Oracle. Designing and participating in report development. Writing scripts in PHP. Show less

Timely reporting development according to business requirements using Web Intelligence Rich Client in Client MI (Management Information) division; Ensuring consistency of reporting specifications and filters; Developing filters for general use by analysts; Gathering reporting requirements from internal clients; Preparing and developing Publications; Participating in discussions about reporting requirements; Supporting operational production of monthly reporting; Providing tools to support data… Show more Timely reporting development according to business requirements using Web Intelligence Rich Client in Client MI (Management Information) division; Ensuring consistency of reporting specifications and filters; Developing filters for general use by analysts; Gathering reporting requirements from internal clients; Preparing and developing Publications; Participating in discussions about reporting requirements; Supporting operational production of monthly reporting; Providing tools to support data quality control checks during month end close; Reconciliating of data from various reporting environments; First line support regarding reporting issues for analysts within the team; Data processing activities; Resolution of issues with IT tools; Involvement in various migration and development projects Show less

Design of: universes, reports, dashboards on SAP BO Enterprise XI R3.1 SP2 with the use of: Designer, Xcelsius, Live Office, Web Intelligence, Web Intelligence Rich Client . Design of the new data warehouse of different data sets. Troubleshoot and support end users. Model and design data by Oracle SQL Developer Data Modeler.

Installation and configuration of Xcelsius 2008 Enterprise SP1/SP2/SP3 and Live Office on new environments. Design universes (each unv for each KPI on Teradata), implementation of an online/offline complex Dashboards (Xcelsius Enterprise 2008) and Web Intelligence Reporting BusinessObjects on SAP BO Enterprise XI R2 SP3. Design new Add-on plugin with write back functionality to the database for Xcelsius.The first stage of this project was to convince Business Dep. to use Xcelsius… Show more Installation and configuration of Xcelsius 2008 Enterprise SP1/SP2/SP3 and Live Office on new environments. Design universes (each unv for each KPI on Teradata), implementation of an online/offline complex Dashboards (Xcelsius Enterprise 2008) and Web Intelligence Reporting BusinessObjects on SAP BO Enterprise XI R2 SP3. Design new Add-on plugin with write back functionality to the database for Xcelsius.The first stage of this project was to convince Business Dep. to use Xcelsius instead of Dashboard Builder and Performance Management. After the trial and professional presentation, Business Dep. gave „green light” to continue the project with Xcelsius which was more accurate in such environment. Project consists of 50 complex KPIs. Show less

Installation and configuration of SAP BO XI R3.1 with the use of IBM AIX 5.3, Oracle, BusinessObjects JAVA SDK, MS Active Directory.

Design and modify: complex universes (300 tables each based on Oracle 10g); advanced reports and macros using SAP BO Desktop Intelligence on SAP BO Enterprise XI R2

Implementation of 20 Dashboards (SAP Business Objects Dashboard Builder); analysis, goals, metrics, strategy maps using SAP BO Enterprise Performance Management; universes (Teradata); Web Intelligence Reports on SAP BO XI R2 SP3.

Supporting MicroStrategy Business Intelligence product suite and underlying technologies focusing on cases related to the Server. Finding creative and sophisticated solutions to problems reported while using MicroStrategy product suite through analytical talent and strong troubleshooting abilities. Prioritizing and communicating product defects and enhancements to development teams. Strong knowledge of: Oracle, SQL; ETL process, Olap technology

Provide complex and challenging support for MicroStrategy’s Business Intelligence product suite and its underlying technologies. Develop strong relationships with MicroStrategy customers and partners through daily interactions during customer project development and production system maintenance. Working in a strong team environment to provide unparalleled support to customers in a wide variety of industries. Contribute to research and growth of the MicroStrategy Knowledge Base by creating… Show more Provide complex and challenging support for MicroStrategy’s Business Intelligence product suite and its underlying technologies. Develop strong relationships with MicroStrategy customers and partners through daily interactions during customer project development and production system maintenance. Working in a strong team environment to provide unparalleled support to customers in a wide variety of industries. Contribute to research and growth of the MicroStrategy Knowledge Base by creating customer-facing documentation of all technical solutions and product documentation. Show less

Verifying basic configuration and activity of network devices (modems, switches, routers, wireless access points) and LAN network’s servers. Monitoring LAN networks (ca. 3400 hotel facilities). Ensuring any issues not resolved are brought to the attention of Network Operations or the Team Manager. Should the need arise working as a NOC Specialist. Assist Tier 1 Support Agents with all calls that involve difficult troubleshooting (customers). Act as an escalation point of contact to resolve… Show more Verifying basic configuration and activity of network devices (modems, switches, routers, wireless access points) and LAN network’s servers. Monitoring LAN networks (ca. 3400 hotel facilities). Ensuring any issues not resolved are brought to the attention of Network Operations or the Team Manager. Should the need arise working as a NOC Specialist. Assist Tier 1 Support Agents with all calls that involve difficult troubleshooting (customers). Act as an escalation point of contact to resolve outstanding issues. Verifying Tier 1 Support Agents are following proper policies and procedures set by the Call Center management. Work in conjunction with Network Operation Center and Team Manager to ensure policies are fulfilled and issues/resolutions be forwarded to their appropriate departments. Implementing new suggestions for improving support processes in the call-center. Show less

Maintaining knowledge of new technologies; troubleshooting guest connections from both the hotel network side and the PC side; problem resolution involves: diagnosing the customer needs, conducting research to find correct solutions and confirming that the customers are able to access their required services or applications; Working on customer technical issues that are moderately difficult, requiring judgment in resolving issues or in making recommendations for solutions

Designing and implementing complex hardware/software components, tools and utilities required for operations, maintenance and control of systems; coordinating with users to determine requirements; making complex modifications to existing hardware/software to fit specialized needs and configurations; maintaining program libraries and technical documentation

Writing computer programme in php - interfacebetween RCR system and Zetafax, basing on given specification; currently used by Citibank Handlowy

Improvement of the layout and graphic make-up of the Web page - eshop.

Web designing, meeting with clients; carrying on correspondence with clients and gaining new clients (eager to buy a new flat); preparing documents; architecting, designing and implementing network solutions; installation and management of lan/wi-fi nets and hardware/software support; advertisements and presentations designer; technical supporter