Upgrade Post project
AC

Alessandro Cambursano

not available until 01/01/2025

Last update: 13.06.2024

Senior BI/DWH Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Full Professional) | French (Limited professional) | Italian (Native or Bilingual)

Keywords

Query Performance Agile Methodology Data Analysis JIRA Banking Services Bash Shell Business Intelligence Big Data Cloudera Impala Extract Transform Load (ETL) + 22 more keywords

Attachments

CV-ACA-OracleBIExpert-Jan24_270324.pdf

Skills

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


 

Project history

01/2022 - 12/2023
Senior Business Intelligence Consultant, Oracle & Datawarehouse Expert
BIL (Banks and financial services, 250-500 employees)
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
01/2018 - 01/2021
Senior Business Intelligence Consultant
ARHS Developments (Internet and Information Technology)
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
09/2015 - 12/2017
Senior Business Intelligence / DWH Consultant
NTT DATA (Internet and Information Technology)
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
04/2011 - 09/2015
IT Analyst / Business Intelligence Consultant
REPLY (Internet and Information Technology)
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

Local Availability

Only available in these countries: Luxembourg
Profileimage by Alessandro Cambursano Senior BI/DWH Consultant from Senior BI/DWH Consultant
Register