Gireesh Kumar Email & Phone Number

Luxembourg, Luxembourg

⦁ Managing the eGEB DWH and BI system which provides enterprise reporting to Clients and Internal Users with Internal and external resources,⦁ Leading and coordinating the new developments as well as business as usual activities on DWH and BI based on the priorities defined together with COO office,⦁ Initiating the improvements on DWH Architecture and design to make the system more optimized and performant,

Luxembourg

⦁ Leading the eGEB Migration project on DWH and BI front.Technologies used - DWH on MariaDB using SAP BODS ETL Tool and BI with Microstrategy 2020 for legacy system. Migrated to DWH on Google Cloud Platform using Datafusion, Composer Airflow and BigQuery. and BI on Microstrategy 2020,⦁ DWH Architecture and design,⦁ Initiating and maintaining the documentation on DWH and BI using Confluence.

Luxembourg

BI Consultant at European Commission, Luxembourg for DIGIT Directorate (Apr 2019 - April 2021)⦁ Data Extraction and Loading using SAP BODS. Data Extraction using AWS Glue in Cloud environment.⦁ Data Modelling and SAP BO Universe Design for Reporting.⦁ Report Development using SAP BO. Dashboard Development using AWS QuickSight.⦁ Unit and System Testing.BI Consultant at Banque Internationale a Luxembourg (BIL) for Data Transformation & Exposition Dept. (Oct 2018 - Mar 2019 )⦁ Data Extraction and Loading using SAP BODS handling Corporate Operational Data Store (CODS).⦁ Data Modelling and SAP BO Universe Design for Reporting.⦁ Unit and System Testing.⦁ Report Scheduling and support.BI Consultant at Cardif LuxVie(BNP Paribas Group) on a DWH and BI Reporting migration project. (Sept 2017 - Aug 2018)⦁ BI Data modelling.⦁ Replication of backend data into Staging Area.⦁ Populating DWH using SQL Server Integration Services. ⦁ Modelling Business Objects Universe for reporting

⦁Building completely new enterprise reporting system using Microstrategy and Cloudera Impala for a new application which includes setting up MSTR Intelligence Server, Webserver instance in tomcat application server in a linux environment.⦁Developing Reports and Dashboards for new service showing different KPIs based on Demographics and Offer management. ⦁ Worked as a team member and Scrum Master in a Scrum Agile Team following Safe Agile methodology handling developments for BI, ETL and Reporting interface. ⦁ Developing Schema Objects as well as Reports and Dashboards for the new service. ⦁ Architectural Design and documentation in Confluence page. ⦁ Migrating Reports and users from Legacy Reporting solution to new BI Enterprise Reporting system.

Luxembourg

⦁ Analysis of different Protocols around Mobile Network Signaling such as SS7.⦁ Modelling new Data marts for BI reporting including views which calculates QoS KPIs ⦁ Developing Schema Objects as well as Reports and Dashboards for new services. ⦁ Architectural Design and documentation in Confluence page. ⦁ Performance improvements - Performance Aggregates on DB level and also using Cube/Cache feature in Microstrategy. ⦁ Subscription Model for new Product Items (services) mapping with Microstrategy Object/User Security.

Luxembourg

⦁ Development of Microstrategy Schema and Application Objects like Attributes, Facts, Metrics, Reports and Dashboards. ⦁ Design and documentation of User Manual, Object Definition Guide, Release Management, Security Structure etc. ⦁ BI Data Modelling for the new services which were integrated to the system.⦁ Regression testing of the standard Reports using MicroStrategy integrity manager. ⦁ Procedure to clean up unused reports and retrigger failed subscriptions. ⦁ Performance improvements using VLDB Settings in Microstrategy. ⦁ Supporting and maintaining the system.

Luxembourg

⦁ Report Requirement feasibility and analysis4⦁ Development of Microstrategy Schema and Application Objects like Attributes, Facts, Metrics, Reports and Dashboards ⦁ Supporting and maintaining the system - Supporting DWH and Production issues on reports and dashboards. ⦁ Testing and validation of reports using SQL. Regression testing of the standard Reports using MicroStrategy integrity manager. ⦁ Release management

Luxembourg

⦁ Requirement Analysis⦁ Development of Microstrategy Schema and Application Objects like Attributes, Facts, Metrics, Reports and Dashboards ⦁ Supporting and maintaining the system ⦁ Performance monitoring of the reports in environment