Developer Leader Business Intelligence solutions
Cliente Telefónica en AVANZIT.; DELAWARE S.L
Keywords
Skills
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
Project history
01/2003
-
06/2021
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
Environment: J2EE, servlet, JSP, JavaScript, Velocity, Turbine.
* DataBase : ORACLE 9i, PL/SQL.
* Bussiness Process: Rectify Bills, Dashboards and KPI about month Bills.
* Customer : AMENA
07/1999
-
06/2021
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
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
07/2017
-
09/2018
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.
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.
05/2017
-
07/2017
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.
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.
06/2016
-
04/2017
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.
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.
08/2008
-
06/2016
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.
* 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.
03/2008
-
08/2008
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
Dimension Tables.
OLAP Cubes with Cognos.
Front End and Dashboards with Cognos
Customer Telefónica España.
Customer AON SPAIN
Local Availability
Only available in these countries:
Spain
