Senior BI/DWH Consultant

Luxembourg

Profile attachments

Query PerformanceAgile MethodologyData AnalysisAtlassian JiraBankingBash ShellBusiness IntelligenceBig DataApache ImpalaExtract Transform Load (ETL)IBM InfoSphere DataStageOracle ExadataApache HadoopApache HivePython (Programming Language)

Senior Business Intelligence - Data Analyst Consultant
DWH/ETL Expert
Large experience in the Banking sector
ODI / Data Stage / SSIS / Power-BI / Big-Data

Experience

Professional experience10+ years

Freelancer since2010

Languages

EnglishFluentFrenchGoodItalianNative speaker

Project history

Senior Business Intelligence Consultant, Oracle & Datawarehouse Expert

BIL

Banking & Financial Services

250-500 team member

MAIN DUTIES AND RESPONSIBILITIES:
- Data Warehousing
- Data Integration layer
- Data modelling
- Data Analysis & Reporting

TECHNOLOGIES:
- T24, Oracle ExaCC, Oracle Data Integrator (ODI), PL/SQL, Git, Jenkins, XL Deploy, Flyway, TWSz, Jira, Omniracker, OpenAudit, HP ALM, PuTTY, CVS

Senior Business Intelligence Consultant

ARHS Developments

Internet & IT

MAIN DUTIES AND RESPONSIBILITIES:
- Data Integration layer with IBM DataStage
- Data modelling on SAP Sybase ASE Database and Oracle Database 12c Enterprise Edition
- Designing ETL (Extraction, Transformation, Load) processes

PROJECT : Bespoke Banking Applications – European Investment Bank
- Analysis, design, development and enhancing / debugging maintenance of the integration layer in
compliance with the requirements from the EIB business users
- Ensure the availability of the daily ETL chains / workflows feeding two in-house applications
(Liquidity Planning and Loans Monitoring Suite, dedicated to loans having payback in arrears)
- Scheduling and monitoring the integration processes, performance analysis on scheduled jobs
- Configuring massive parallel jobs in order to process large datasets over satisfactory timings
- Adjust the configuration set-up according to the needs of multiple simultaneous test sessions
- Data analysis and reporting, design and modelling on SAP PowerDesigner
- Impact analysis on the AS-IS and non-regression tests following changes in the upstream apps
- Workload estimation for incoming Change Requests and technical tasks
- Development / maintenance of Stored Procedure / SQL scripts on Sybase / Oracle DB servers

TECHNOLOGIES:
- SAP PowerDesigner, SAP Sybase, Oracle 12c, SqlDbx, DataStage 11.3, Jira

Senior Business Intelligence / DWH Consultant

NTT DATA

Internet & IT

MAIN DUTIES AND RESPONSIBILITIES:
- Data Warehouse development on ORACLE Database with custom PL/SQL code
- Data Warehouse analysis, development and functional / technical documentation editing

PROJECT: Decision Support System – DWH Vodafone
- Analysis, development and enhancing / debugging maintenance of DWH Vodafone in compliance
with the business requirements collected in single package projects
- Gathering business requirements, defining functional specifications and documentation
- SQL scripts implementation and related versioning in the remote CVS server
- Installation kits provided along with technical / architectural documentation
- Test planning, Editing test book and test reports (System test, UAT, VIT, O2O, E2E)
- Monitoring DWH processes and time / performance analysis of the scheduled jobs

TECHNOLOGIES:
- Oracle DB Exadata 12c, Toad for Oracle, Unix, Win SCP, CVS

IT Analyst / Business Intelligence Consultant

Internet & IT

MAIN DUTIES AND RESPONSIBILITIES:
- Data Warehouse development / Big Data
- Functional Analysis, Data Analysis and Reporting
- Data Integration, IBM DataStage development

PROJECT 1 - IFRS9 – STE04 - Unicredit Group
- Simulation applying the to-be IFRS9 financial reporting standards to historical data
- Comparison in the scenario of replacing the current as-is I.A.S. 39 accounting standards
- Stress test post A.Q.R. and dispatching quarterly short term data collection to the ECB

PROJECT 2 - Reporting Simplification DWH Findomestic – BNP Paribas
PROJECT DESCRIPTION:
- Reporting system redesign with a peculiar focus on the creation of a new Data Warehouse dedicated to consumer loan procedures
- Tests and comparisons against the existing data model with the tool Teradata Studio Express

PROJECT 3 - Payment System Hub + Log Analysis - Banca Intesa Sanpaolo
- Creating Hadoop clusters both on premises and on cloud, defining master/slave nodes features
- Building the data repository as NO-SQL metastore through the SQL like language Hive
- Data feeding from Oracle DB source through Sqoop and from Windows Server through Flume
- Query modeling in Impala in order to run high performing analysis from the FE tool Pentaho
- Interaction with the key/value store HBase. XML files development for the job scheduler Oozie

PROJECT 4 - Asset Quality Review (A.Q.R.) - Unicredit Group
- Asset Quality Review is a project issued by ECB as feedback against the lack of transparency and awareness of the risks in the banking system
- Implementation of the ETL flows loading the six target tapes

PROJECT 5 - Data Warehouse 2013 Rollouts CNH Industrial – Fiat Group
- Central CNH Data Warehouse integration with the data hailing from the markets Argentina, India and Russia, each one of them managed through different source transactional systems
- Definition of new interfaces between the source systems and ETL processes
- Data and metadata flow testing
- Jobs scheduling through the IBM Tivoli engine

PROJECT 6 - DWH ISD&O – Vodafone Group
- Application Maintenance of the DWH for ISD&O - Value Added Services dptmt, later on FD&Co
- Operating, enhancing and debugging management service. Technical analysis. Documentation
- Back-end development, data integration and jobs scheduling through the ETL tool DataStage

TECHNOLOGIES:
-SQL Server 2012, SSIS , SSRS, Visual Studio, T-SQL, Power BI, Teradata DB, Teradata Studio Express, IBM DataStage, Open Studio, QlikView 12, Hadoop, Cloudera, Python, Hue, Hive, Impala, Sqoop, HBase, Oozie, AWS EC2, SQL Server 2012, Management Studio, Transact-SQL, PowerShell, Oracle DB, Toad for Oracle, Shell Unix, Win SCP, MicroStrategy, VBS

Contact form

You need to be logged in to use the contact form.