Objective

Oracle or SQL Server ****/**** SQL programmer, database administration and data analyst.

My work includes business intelligence, data transformation from multiple sources, and creating reports and dashboards to track metrics and key performance indicators (KPIs).

Technical Skills

Programming languages:

SQL, PL/SQL, T-SQL, MDX, C++, PHP, Java, JavaScript, jQuery, HTML5, CSS3, XML

Databases:

Oracle 9i, SQL Server 2012, PostgreSQL, MySQL, MS Access.

Business Intelligence Tools:

Pentaho BI Server, Pentaho Metadata Editor, Pentaho Data Integration (kettle), JRubik (Desktop Olap Viewer), Pentaho Report Designer, SSIS, SSAS, SSRS, Crystal Reports.

Other Tools:

Oracle Application Express, TOAD, Eclipse, NetBeans, Erwin, dc.js.

Frameworks:

ExtJs, Bootstrap.

Education

Bachelor in Software Engineering. University of Computer Science, Havana Cuba (2007).

Currently enrolled at The Academy of South Florida for Microsoft Developer Certification classes in MCSD App Builder and MCSA SQL Server 2012/2014.

Professional Experience

May 2013 - March 2016

KNB Consulting (Quito, Ecuador)

BI Developer & Analyst

Created data warehouses through extraction, transformation and loading data using Pentaho Data Integration (Kettle).

Developed OLAP Cubes and complex multi-dimensional expression (MDX) queries to interact with the cubes by Mondrian Pentaho Analysis Services.

Designed and created of reports with the key performance indicators (KPIs) identified in each project to make the analytical results available for decision makers. (Pentaho Report Designer).

Created dashboards as a data visualization tool to display the current status of metrics and key performance indicators (KPIs) of each project using Pentaho Dashboard (CDE).

Created dashboards interactive using a JavaScript library (dc.js).

Developed complex queries (MDX, SQL, T-SQL).

SQL Server 2012, Integration Services, Analysis Services and Reporting Services.

September 2007 - April 2013

DESOFT (Las Tunas, Cuba)

SQL Programmer/DBA & BI Analyst

Designed relational and dimensional database models.

Development support (PL/SQL, T-SQL, Stored Procedures, Functions, Views, Indexes, and Triggers).

Created database jobs and security policies.

Backup and recovery for Oracle and SQL Server databases.

Planned and developed websites using ExtJs, and Oracle database (PL/SQL).

Designed and deployed analytics reports using Crystal Reports, SSRS and Pentaho Report Designer.

References

Available upon request.

Contact this candidate