Iohan Alevato

Conduct analysis of source systems and business process data. Design and develop reporting solutions for customer and financial products management. Drive the improvement of data flow within the bank’s infrastructure. Design and develop reporting solutions using MicroStrategy. MicroStrategy schema definition, design, implementation and maintenance. Experience with PostgreSQL, SQL Server, and HIVE. Develop advanced SQL queries, views, and procedures.

- Lead multiple and complex projects to solve business problems using data analytics. - Coordinate implementation of the ETL jobs in Informatica PowerCenter, data modelling for Teradata, Microsoft SQL Server and Oracle databases and MicroStrategy dashboards. - Provide end-to-end project management and develop detailed project plans to track progress. - Deliver consultancy for Business Intelligence solutions and coach junior coworkers.

- Technical expert, responsible for designing DW/BI/analytical solutions end-to-end. - Data modelling, primarily designing dimensional data models (star/snowflake schemas). - Experience with IBM DataStage (ETL tool), Teradata and DB2 (databases), Control-M (scheduling tool), bash shell scripting. - Responsible for gathering requirements, build and delivery technical solutions. - Guide and mentor development team in driving innovation and applying best practice in the implementation of BI solutions.

- Short Term Assignment in the United Kingdom. - Management and coordination of regulatory and compliance related new and ongoing projects. - Responsible for facilitating business workshops to reach consensus on business requirements. - Lead offshore teams of analysts and developers to ensure business needs are met.

- Analysis and development of health insurance systems. - Solid experience of software development in Delphi and .net C# MVC (+ HTML, JavaScript, jQuery, CSS). - Experience with Microsoft SQL Server and Sybase databases, developing SQL queries, procedures and triggers. - Process analysis and ERP development for Windows and web environments.