Data-Warehouse-Analyst/in

• Hauptfach: Business Intelligence

Business Intelligence
Datamining
Data Analytics

• Hauptfach: System Engineering

- 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.

- 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.

- 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.

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

- 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

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

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.

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

Implementing a Data Warehouse with Microsoft SQL Server 2012

IBM Certified Solution Designer using RUP methodology.

Prüfungs-Zertifikat auf Niveau C1

–