Business Intelligence/BI Analyst Resume

SUMMARY

Over twelve years of full life cycle of experience in design and development of BI Stack.
Proficient with Power BI and Power BI Services
Proficient creating Dashboards with Power BI and SSRS
Proficient in Administering and developing SQL Server Reporting Services SSRS
Proficient with Microsoft SSIS, SSRS, and SSAS
Proficient with Business Intelligence Semantic Model Tabular Model and Dimensional Model (Star Schema and Snowflake Schema) base on Ralph Kimball architecture
Proficient building Data Mining to discover patterns and trends that exist in the data for forecasting analysis
Proficient with Analytics: Salesforce Einstein Analytics EA
Excellent organization and teaching skills
Fully bi - lingual (English / Spanish)

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence/BI Analyst

Responsibilities:

Creating dashboards with SSRS
Creating Dashboard projects using Microsoft Power BI Service on the cloud, and Power BI Desktop
Develop complex SSIS package getting data from an ODS data base to a data mart.
Adding, Improving, and Maintaining Data Marts (Data Warehouse)
Creating, Migrating, and Improve OLA Cube to SQL Server 2008 and 2012
Troubleshooting and monitoring query performance for SSRS
Reorganize structure of SSRS Server
Creating multiples POC projects with Office 365 Power BI
Monitoring jobs executions on the Development Server,
Database backups

Confidential

Microsoft Business Intelligence Architect/Developer

Responsibilities:

Creating Dashboard projects using Microsoft Power BI
Building Reports and Dashboard using Reporting Services
Leading a team to build different Microsoft BI projects (Data Marts, SSIS ETL, OLAP cubes) for Sales and Marketing using SSIS, SSAS and SSRS, also implementing some model for PowerPivot for Excel 2010 and Excel 2013 for a group of Business Analyst.
Designing/Developing Data Mining to discover patterns and trends that exist in the data for forecasting analysis
Designing and Building Tabular Model projects using Business Intelligence Semantic Model with PowerView and SharePoint 2010
Provide mentoring and guidance to build Microsoft BI applications to others team members
Supervise and manage the relationship and communication between BI developers and business users scheduling meetings and getting feedbacks
Developing Data mart using SSIS, building OLAP Cubes SSAS base on Ralph Kimball (Star Schema) and Snowflake Schema architecture using SQL Server 2008 R2 and SQL Server 2012
Building PowerPivot dashboard and reports using different sources.
Creating technical and +user-friendly cube documentation using Microsoft Visio and Microsoft Word
Helping to maintain and adding functionalities to SharePoint 2010 site.
Administering, leading building and deploying large scale of SQL Server Reporting Services 2008 R2

Confidential

BI SQL Developer/Reports

Responsibilities:

Administering, lead in building and deploying large scale SQL Server Reporting services 2005 and 2008 that included more than 1200 reports for Merchandising, Marketing, Finance, Inventory, Sales, and Accounting at different levels (Executive, Divisional, Merchandising, Regional and Stores).
Creation of SSIS packages for consolidation and reporting.
Creating Microsoft Analysis Services Cubes (SSAS) 2008 for reporting purposes
Responsible for the technical documentation and user manual documentation.