Miguel Reyes

OVERVIEW

Miguel Reyes is a BI developer with over 10 years of extensive experience architecting, designing and developing enterprise business intelligence solutions. Miguel is a Data Warehousing professional specializing in Microsoft BI, SAP BI and Cognos with an excellent combination of business and technology skills. Miguel has obtained Microsoft certificates in SQL and SAP BI. He holds a Master of Science degree in Computer Information Systems from EAN University (US Equivalency of a Bachelor Degree in Computer Information Systems from the University of Miami)

TECHNICAL EXPERIENCE

Data Platform and BI

SQL Server 2012, 2008 R2, 2008, 2005, 2000, and 7.0, Windows Azure SQL Database, Integration Services, Reporting Services, Analysis Services, Master Data Services, Data Quality Services, MS Access, MS Excel, PowerPivot, Power View, Excel Services, Access Services.

Operating Systems

MS Windows, Windows Azure.

Languages

C#, ASP.NET, HTML5, Razor, T-SQL, MDX, XML, HTML, ABAP, Dataflex, Power Builder Ver. 4 & 5.

ERP Packages

Data Warehousing

Collaboration

SAP R/3 ECC 6.0, JDE Edwards Oneworld, Oneworld Xe.

SSIS, SSRS, SSAS,BW 3.5, 7.X, BO XI 3.X, BO 4.0, COGNOS 7, 8, Hyperion

SharePoint 2010 and 2013

EDUCATION / CERTIFICATIONS

Master of Science in Computer Information Systems, EAN University, Colombia Jan 2003 – Dec 2004

Specialist in Computer Information Systems with Honors

Bachelor of Science in Computer Science, Jorge Tadeo Lozano University, Colombia Jan 1991 - Dec 1996

SQL Server Certificates:

Microsoft Certified Professional in SQL Server 2012 Querying 70-461 Jan 2015

Microsoft Certified Professional (Administering Microsoft SQL Server 2012 Databases) Apr-2015

BI Certificates:

SAP Global Certification BW #S0005016831 Aug 2008

PROFESSIONAL EXPERIENCE

BDO., Mississauga, ON Jul 2014 – Present

Business Intelligence Consultant

Lead analysis, architecture, design and development of data warehouse and business intelligence solutions.

Perform work as a BI Consultant on Microsoft BI Platform (SSIS, SSAS, SSRS) OLAP cube design, ETL data integrations, dashboards and reports.

Collaborate in the creation/enhancement of data structures such as Data Marts and Cubes to facilitate project goals.

Collaborate with client DW/BI/Reporting team to standardize reporting implementations across a variety of contexts in different companies.

Design and develop ETL processes using MS SQL Server 2008 SSIS and other related tools/technologies

Projects include:

Bayshore Health Care Present

Using SQL Server, SSAS, SSRS, SSIS

Designed and developed the DW solution for reporting for Manulife, a division of Bayshore; implemented new data models and applied several of table structure, view, function and stored procedure changes.

Bayshore Health Care

Using SQL Server, SSAS, SSRS, Performance Point

Enhanced SSAS cubes design by implementing complex calculations based on the new requirements

Development of custom MDX scripts, views, functions and stored procedures for reports and dashboards.

Developed and Implemented several key Dashboards that display performance monitoring measures for visits, QMR, Surveys, Continuity of care. The dashboards also contain pages to view performance by department, area, business line, service, discipline, client and employee and by quarter, month, and week enabling end-users to make filter selections.

Holt Renfrew

Using SQL Server 2012, .Net, C#

Work as Developer on ASP.NET MVC web applications.

Developed some modifications to the HRL.SKU module.

Bayshore Health Care

Using SQL Server, SSIS, SSAS, SSRS

Development of custom scripts, views, functions and stored procedures for reports and dashboards.

Developed 21 key reports and dashboards for Biogen, a division of Bayshore.

Ability to effectively and efficiently translate user asks in to reporting specifications.

First Quantum Minerals Ltd, CAYELI

Using SQL Server, Advance Analytics, Excel

Prepared Data migration from existing ORS system to AA system

Set up the source for new KPI’s

Barrick Gold Corporation

Using SQL Server, SSIS, SSRS, SSAS

Modified existing ETL process to add new KPIs to the official reports

Set up the source for the new KPIs

Modified stored procedures and updated business calculations such as Forecast

CEM Benchmarking, Toronto, ON Jan 2013 – Jun 2014

SQL Server Senior Developer

Database Design for CEM Benchmarking’s CRM system.

Performed a database migration from Access to SQL 2012.

Developed stored procedures, views, functions, user-defined types (CRM Business Logic)

Built, deployed and published the company key reports using SSRS, SSAS, and .NET

Build and maintained Database Documentation.

Halton Region, Oakville, ON Jan 2012 – Jun 2012

Newcomer's Portal Consultant

Volunteer in the design and development of a portal website for newcomers to Halton.

ICMS INDUSTRIAL CLEANING & MAINTENANCE SERVICES INC, Oakville, ON Sep 2011 – Dec 2011

System Analyst

Responsible for evaluating system specifications to fulfill business requirements. Developed interfaces to feed and integrate Quick-books and Excel. Responsible for a Stabilization System and for architecting all technological aspects involved in the BI related areas.

Colsubsidio, Bogotá, Colombia

BW-BO Administrator-Developer May 2008 – Jul 2011

Lead and implemented successfully three full life cycle projects. Select Projects: Updated & performed migration for the client’s data warehouse installations from SAP BW 3.5 to 7.0. Redesign and optimization of the Data Warehouse to improve capturing sales and retail information.

Extensively worked on the Administrative Worbench for configuring, scheduling and monitoring functions.

Contolled, monitored and updated all data retrieval processes.

Archiving and cleaning the warehouse data, continued improvement of Data Warehouse, Performance and Tuning.

Created roles, users, groups, assing permissions in BO and authorizations in BW.

Configured Basic Cubes and ODS Objects to upload the data from R/3 and flat files.

Data extraction process from SAP R/3, Non SAP and Expertise in LIS, Lo Cockpit and Generic Extaction.

Generated reports using SAP BEx Analyzer. Leveraged the Browser in building queries and saving in workbooks (excel sheet) and created custom queries using Calculated and Restricted key figures, structures, exceptions, and conditions.

Responsible for install and deployment of the BO platform.

Extended and activated Business Content.

Created Process chains for Master data and transaction data loads.

Perfomed the tuning at the Data Target level to improve Data load and Query performance.

Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).

CSI Ltda, Bogotá, Colombia

JDE Edwards Consultant. Mar 2008 – Apr 2008

Migrated the database ERP (JDE Edwards) from DB2 to SQL Server 2005 in the multinational pharmaceutical company SANOFI AVENTIS. Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Managed data migration program.

Designed SSIS packages to migrate the data from DB2 to the ETL tier.

Biofilm S.A., Bogotá,, Colombia

IT Coordinator Sep 1997 – Jan 2008

Data Warehouse Leader (Cognos), Migration of Cognos from series 7 to 8. Used Crystal Reports.

Coordinator, technical leader, specifications and development of new projects.

Upgraded SQL server 7 to SQL server 2000. Upgraded SQL server 2000 to SQL Server 2005.

PowerBuilder Developer, DBA, Sql Server 2000, 2005 Developer.

Technical Leader and responsible for the ERP implementation to JDE Edwards.

Responsible for the following reporting modules and applications:

oCustomers, orders, prices, budget, profitability matrix, daily operations report, invoicing, warehousing international, sales statistics, official reports, portfolio and accounting in JD Edwards.

Developed the interfaces feeding Hyperion from JDE for consolidation of financial statements

Contact this candidate