Data Warehouse Analyst

New Zealand

10-15 years experience

Birthday:

Nationality:
Colombian

41215509

University education

Timeframe
Degree / faculty / university
Study areas

2018-052019-05

completed

Postgraduate Diploma (PGD)
Information & Communication Technologies (post-graduate)

, New Zealand

  • Document_Study_011.jpg
  • Document_Study_012.jpg

2011-082012-12

completed

Postgraduate Diploma (PGD)
Information & Communication Technologies (post-graduate)

, Colombia
  • Major: Business Intelligence

Business Intelligence
Datamining
Data Analytics

  • Document_Study_021.pdf

2001-022006-12

completed

Bachelor of Computer Science
Systems Engineering

, Colombia
  • Major: System Engineering

  • Document_Study_031.pdf

Professional experience

Timeframe
Occupation / company
Tasks

2018-08Till now

BI & Data Analyst

, New Zealand
References are available upon request

- Analysis, design, developing and deployment of reports, KPI's & dashboards in Microsoft Power BI.
- Gathering and documenting requirements with internal customers and translate into insight to enable better business decision making.
- Identify, understand and analyze data from different sources to derive insights and turn data into actionable information for business consumption.
- Liaise across business units & stakeholder groups to understand key business requirements; provide optimal analytical outputs to meet their needs.
- Use analytics and data visualization to present information, telling stories, narratives and elevate insights for business consumption
- Create queries and store procedures the get information updated and assuring data quality.
- Analysis and design of Datawarehouse using Microsoft BI stack(SSIS,SSAS,SSRS).
- Transform data into insight and meaningful analytics and visualizations.
- Creation of ETL's in SSIS to download information from Microsoft Dynamics 365.
- Extracting, validating and maintain data from a wide range of sources such as SQL Server, Microsoft Dynamics 365, WEB API, excel, web-pages, Microsoft Azure.

2015-072017-08

Business Intelligence Analyst

, Colombia
References are available upon request

- Leading the Enterprise Data warehouse design and architecture.
- Supporting the EIS Information Design, Modelling, Analysis, Presentation and Reporting Capability
- Design and development ETL´s, reports, cubes and Dashboard, data mining projects and machine learning with R and Python.
- Controlling project progress, schedules, resource allocation.
- Troubleshooting issues and recommending and implementing improvements to Datawarehouse
- Deliver insights and analytics to both internal and external stakeholders
- Handle BD Oracle 10 g, Oracle Warehouse builder, Repository browser and Oracle Business Intelligence Enterprise Edition, data quality.
- Resource Monitoring, Evaluation, and Quality Assurance.
- Design reports and dashboard with Tableau, Power BI & OBIEE.
- Work with the Architecture team to develop the overall design of data including logical models, enterprise models, and data marts.
- Design and development of dashboards and reports based, which meet the customer's requirements. - Liaising between business users and design and architecture team.

2013-042015-03

Business Intelligence Consultant

, Colombia
References are available upon request

- Business Intelligence Leader for Datawarehouse projects and data mining.
- Analysis business requirements and use available data to identify possible areas of improvement.
- Requirements elicitation and documentation using functional and technical requirement documents.
- Design and develop mining projects descriptive and predictive data to generate new knowledge.
- Design and development ETLs, reports, cubes and Dashboard with Microsoft BI Stack
- Provide support and reports for the wider business.
- Troubleshooting issues and recommending and implementing improvements to Datawarehouse.
- Business Intelligence consultant to ICBF, GEL, URT, TIGO and BBVA proyects.
- Implementation of Information policy across the Data Warehouse environment.
- Using SQL Server Business Intelligence 2008 R2- 2012 , Pentaho BI Suite, Pentaho Report Designer, Pentaho Schema Workbench, Pentaho Data Integration, Oracle 10g.

2010-012013-03

Business Intelligence Consultant

, Colombia
References are available upon request

Leading the Data warehouse design and architecture for the customers
- Supporting the EIS Information Design, Modelling, Analysis, Presentation and Reporting Capability
- Implementation of Information policy across the Data Warehouse environment
- Provide solutions for all Business Intelligence requirements of the business.
- Design and development ETL, reports, cubes, dashboard.
- Manage Microsoft, SSRS, SSIS, SSAS, SQL Server and PowerBI tools, Power view, Power pivot
- Use SQL Server Business Intelligence 2008 R2, 2012, Cognos 8.3, Pentaho, OWB
- Interpretation and presentation of reporting and other metrics
- Optimizing the efficiency and effectiveness of BI and DW solutions

2009-082011-05

Business Intelligence Analyst

, Colombia
References are available upon request

- Survey, analysis, validation and specification requirements for customer Telmex
- Maintenance and analysis Onyx CRM applications, management of SQL Server.
- Functional and non-functional testing desktop applications and web for Telmex
- Liaising between business users, collecting and analyzing requirements for BI reporting.
- Managing SQL Server 2005 database and Oracle databases, test scripts
- Design data warehouse, Datamart, cubes, dashboard, and reports with Pentaho for
- Customer Carrefour Colombia
- Using IBM Cognos 8 suite for development of static and analytical reports with
- Handle Report Studio, design cubes with Analysis Studio, Query Studio and Event Studio

2008-042009-06

Data Analyst

, Colombia
References are available upon request

Create and design reports in Microsoft Reporting Services.
- Developing applications using Microsoft Visual Studio .Net 2003 and ASP.net.
- Survey, analysis, and design of customer requirements.
- Design use cases, test cases, process diagrams.
- Managing SQL Server 2000 databases, and Microsoft Access 2005.
- Using the RUP methodology for software development projects

2007-032008-02

Data Analyst

, Colombia
References are available upon request

Survey and analysis of information according to the needs and requirements of the external client (Bancolombia, Citibank, BCSC, Colpatria).
- Perform process modeling according to parameters or requirements of internal / external customer.
- Define and coordinate the implementation of operational, functional and integration tests for verifying compliance with entry requirements.
- Develop documentation process support entering production projects or changes.
- Design use cases, test cases, test scripts, process diagrams.

Training and development

Timeframe
Degree / institute
Content

Further training

2014-07-022014-11-02

completed

Certification 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

, Colombia

Certification 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

  • Document_Education_021.pdf

Further training

2014-01-022014-07-02

completed

Certification 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

, Colombia

Implementing a Data Warehouse with Microsoft SQL Server 2012

  • Document_Education_011.pdf

Further training

2010-07-012010-10-25

completed

IBM Certified Solution Designer

, Colombia

IBM Certified Solution Designer using RUP methodology.

  • Document_Education_031.pdf

Language ability

Language
Level
Exam / certificate
English
Fluent (C1)

Certificate of examination in level C1

Spanish
Mother tongue

Other skills

Key professional skills
Driver licenses
Interests, hobbies, personal

Drive and determination to exceed set targets.
Great desire to learn, enthusiastic and motivated.
Analysis and problem solving, always ready to find solutions and take new challenges.
Passionate to work with data and analytics.
Willing to giving the extra mile every time.
Ability to leverage and maintain strong business relationships.
Hard Worker, highly committed and a self-starter.

  • Automobile

Start recruiting