09/06/2022 updated

LA
100 % available

Developer Power BI / Architect DWH-BI, Developer Power BI / Architect DWH-BI, Developer / Architect

MADRID, Spain
Spain
MADRID, Spain
Spain

Profile attachments

CV - LUIS ARROYO

HTMLJava (Programming Language)JavaScriptMicrosoft WindowsAtlassian JiraMicrosoft AzureCustomer Relationship ManagementCloud ComputingDatabasesComputer Telephony IntegrationData IntegrationData IntegrityExtract Transform Load (ETL)Data MartData ModelingData WarehousingEnterprise JavaBeansVisual C++ (Programming Language)Java Platform Enterprise Edition (J2EE)IBM Cognos Business IntelligenceJava ServletJavaserver PagesMultiDimensional EXpressionsMicrosoft VisioMicrosoft SQL ServersMicroStrategyOnline Analytical ProcessingModel View Controller (MVC)Online Transaction ProcessingOracle DatabasesPentaho Data IntegrationQuery OptimizationMicrosoft Power BIApplication DataPL-SQLSQL DatabasesSQL Server Reporting ServicesSQL Server Integration ServicesSQL Server Analysis ServicesTransact-SQLWeb ServicesExtensible Markup Language (XML)Distributed Temperature Sensing (DTS)Azure Data FactoryTest ScriptsBackendVba Programming LanguageToad (Software)Front End Software DevelopmentTurbines
Power BI, DWH, Azure cloud, SSAS, databases, SQL Server 2016, T-SQL, SQL Server Azure, Azure, ETL, SSIS / Azure Data Factory, DataMart, SSIS, JIRA, SQL Server 2014, SSIS packages, SSRS, SQL, MDX, test scripts, database, SQL Server 2008 R2, data integrity, TSQL, data model, Visio, PL/SQL, Oracle 10g, OLAP, Cognos, Integrator, PL / SQL, Portico, SQL Server 2005, SSRS ETL, Oracle 9i, SQL Server 2000, ETL PL/SQL, J2EE, JSP, Java, HTML, XML, Pentaho, Data Integration, Fact, Kettle, application data, CLOB, Oracle 8i, servlet, JavaScript, Velocity, Turbine, OLTP, CRM, MVC, FrontEnd, EJB, SQL SERVER, Data Warehouse, Suite SQL Server 2000, DTS (ETL), Query Hints and Query, Cubes, Query Optimizer, BackEnd, DTS, T, WebServices, Visual Basic and Visual C++, call flow, ICM, Windows NT 4, Windows 2000, Visual C++, Visual Basic, CTI, Windows NT 4.0, Microsoft SQL Server 2000, 2005, 2008,2012, MicroStrategy 7.0, Cognos 8.0, PLSQL Developer, Toad, Datawarehouse, Kimball, Inmon technology

Experience

Professional experience10+ years

Languages

EnglishGoodSpanishNative speaker

Project history

Developer Leader Business Intelligence solutions

Cliente Telefónica en AVANZIT.; DELAWARE S.L
also working with BRM ABACUS to rectify AMENA bills.
Environment: J2EE, servlet, JSP, JavaScript, Velocity, Turbine.
* DataBase : ORACLE 9i, PL/SQL.
* Bussiness Process: Rectify Bills, Dashboards and KPI about month Bills.
* Customer : AMENA

Developer Leader

CYSTELCOM SISTEMAS S.A.
* Developing Web CRM solutions using J2EE like MVC in the FrontEnd and SQL Server 2000 in the
BackEnd.
* Envieronments: J2EE, SERVLET, JSP, JAVASCRIPT, EJB.
* DataBase: SQL SERVER 2000.
* Bussiness Process: Managing Clients and Contacts Company
* Customer: COCA-COLA

* Developer Leader Data Warehouse Suite SQL Server 2000 like Backend and Dashboards with
Reporting Services like FrontEnd.
* DataBases: SQL SERVER 2000. DTS (ETL), T-SQL, Query Hints and Query
Optimizer
* Bussiness Process: Customer Management, Sales Management, Contact
Management, Sales Analysis, Dashboard and KPI about sales.
Customer : BROADNET
* Developing Leader Data Warehouse and OLAP solutions using Cubes, MDX and SQL Server 2000
* Environments: Reporting Services,
* DataBases: SQL SERVER 2000. DTS (ETL), T-SQL, Query Optimizer
* Bussiness Process (DataMarts): Custom Management, Sales Managements, Contact
Management, Selling Analisis, Dashboard and KPI for Sales Bussiness, Funnel Analisis
Sales.
* Customer : ATENTO


* Developer Leader for Web CRM J2EE like FrontEnd and SQL Server 2000 like BackEnd.
* Environments: J2EE, servlet, JSP, JavaScript.
* DataBases: SQL SERVER 2000. DTS (ETL),T-SQL, Query Optimizer
* Bussiness Process: Custom Management, Sales Managements, Contact Management, Selling
Analysis, Dashboard and KPI for Sales Bussiness, Funnel Analisis Sales.
* Customer : HISPATEC


* Developer Leader Web CTI develops using J2EE like FrontEnd and SQL Server 2000 like
BackEnd.
* Environments: J2EE, servlet, JSP, JavaScript, WebServices
* DataBase: SQL SERVER 2000. DTS (ETL),T-SQL, Query Optimizer
* Bussiness Process: Custom Management, Sales Managements, Contact Management, Selling
Analysis, Dashboard and KPI for Sales Bussiness, Funnel Analisis Sales. Phone
Integration in Web. (CTI)
* Custom : TELECYL


Managing the flow of incoming and outgoing calls and developing exchange programs Visual Basic
and Visual C++ to monitor the call flow of the Call Center.Entornos: ICM, Windows NT 4.0,
Windows 2000.
* Custom : AMENA

Managed the flow of incoming and outgoing calls and developing exchange programs Visual C++
and Visual Basic to monitor call flow and call center telephony solutions integrated PC (CTI).
Entornos: ICM, CTI, Windows NT 4.0, Windows 2000.
* Custom : JAZZTEL

Developer Power BI / Architect DWH-BI

Dashboards deployment with KPIS client about farm sector with Power BI/DAX/Power Query
Design Architecture Multidimensional DataMart/Develop Tabular SSAS Model
Creation of Multidimensional databases with SQL Server 2016.
Creating threads of charge with T-SQL on SQL Server Azure.
Implement and develop ETL process with SSIS.
Power BI Dashboards in Direct Query for client Codere
Power BI Reporting Services Dashboards for client Codere.

Developer Power BI / Architect DWH-BI

Microsoft Iberica
Dashboards deployment with KPIS client about farm sector with Power BI/DAX/Power Query
Design Architecture Multidimensional DataMart/Develop Tabular SSAS Model
Creation of Multidimensional databases with SQL Server Azure.
Creating threads of charge with T-SQL on SQL Server Azure.
Power BI Dashboards in Direct Query for Vall Companys
Power BI Dashboards in Import for Correos Telecom
DWH and BI tasks advice on the client.

Developer / Architect

DWH-BI
Dashboards deployment with KPIS client about telecom sector with Power BI.
Design Architecture DataMart Multidimensional applicative JIRA.
Creation of Multidimensional databases with SQL Server 2014.
Creating threads of charge with T-SQL on SQL Server 2014.
Creating SSIS packages
Rectification of obsolete user reports with Power BI.
Helps decision-making on the DWH architecture to perform.
DWH and BI tasks advice on the client.

Functional Analyst

Ibermática
sector:
* Process optimization ETL fact and dimension tables with T-SQL.
* SCD Design tables.
* Optimizing queries, query hints.
* Operational Analysis and MultiDimensional Business.
* Creation and Implementation of multidimensional models
* Creating SSAS Multidimensional models
* Optimization dimensional models with SSAS.
* Aggregation design.
* Creating large MOLAP cubes.
* Creating user requests directly.
* Process design ETL process with SSIS
* Creating Reports and Dashboards with SSRS, using SQL, Store Procedures and MDX
queries.
* Responsible for gathering requirements from the client, creating test scripts,
conducting user acceptance testing, implementing the design, and providing
database support of the entire application performing roles developer, tester,
and analyst at various times on the project.
* Successfully implemented process improvements including an application deployment
strategy by overseeing all production releases and ensuring they are properly
packaged, supported, coordinated, and documented.
* Stabilized SQL Server 2008 R2 test environment by providing DBA-related support:
coordinating and implementing schema alterations, maintaining security,
monitoring data integrity, and implementing batch processes.
* Accurately converted production data from legacy systems with detailed
documentation. Accomplished this milestone by designing staging tables and stored
procedures using TSQL to collect data and relationships from multiple legacy
systems and platforms.
* Successfully incorporated standardized database modifications to the data model
for over 400 tables utilizing Visio.
* Accomplished 100% audit pass rate for the Mutua Madrileña act section 404 by
successfully constructing and implementing controls for change management,
production and security.

ETL Datawarehouse Developer

Customer Mutua Madrileña; ATK; Customer AON SPAIN
PL/SQL for the ETL and Oracle 10g for Relational and Multidimensional Model, Fact Tables and SCD
Dimension Tables.

OLAP Cubes with Cognos.
Front End and Dashboards with Cognos


Customer Telefónica España.
Customer AON SPAIN

Contact form

Log in to get in touch

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

Sign upLog in