Developer Sap

MIGUEL REYES

Oakville, ON L*K*C*; 905-***-**** ff9fko@r.postjobfree.com Page: 1/2

SAP BW Certified Consultant

BUSINESS INTELLIGENCE, DATA WAREHOUSE, SAP BW-BO, COGNOS

HIGHLIGHTS OF QUALIFICATIONS

• Data Warehousing professional specializing in SAP BI with excellent combination of business and technology skills.

• Over 10 years experience as an IT professional with 7 years working as BI Developer, technical implementation and project management roles

• Extensive experience working on implementation and production support projects in SAP BI 7.X, BW 3.5, Cognos 7 & 8, BO.

• Implemented 3 Full Life cycles as a BI Expert using ASAP methodology.

• Strong experience as Solutions Architect providing leadership in architecting solutions that support the Client’s needs .

• Microsoft SQL DBA and Developer.

• Proactive and self starter with the great leadership ability.

CERTIFICATIONS

• SAP HANA 1.0 2012

• SAP BusinessObjects for SAP XI. 3.0 2009

• SAP Global Certification BW Certificate # S0005016831 2008

• SAP BI - Enterprise Data Warehousing 2008

• SAP BI - Reporting & Query Design 2008

• SAP BI - Advanced Enterprise Data Warehousing & Reporting 2008

• SAP BI - Integrated Planning 2008

• Programming a Microsoft SQL Server 2000 Database 2005

• Impromptu, PowerPlay (COGNOS) 2003

• OneWorld JDEdwars Architecture and CNC 1999

• OneWorld JDEdwars Inventory Management 1999

• OneWorld JDEdwars Sales Orders Management 1999

PROFESIONAL EXPERIENCE

Newcomer's Portal Consultant

Halton Region (Canada) Jan 2012 – Jun 2012

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

Systems Analyst Sept 2011 – Dic 2011

ICMS INDUSTRIAL CLEANING & MAINTENANCE SERVICES INC. (Canada)

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

BW-BO Administrator-Developer.

COLSUBSIDIO. (Colombia) May 2008 – Jul 2011

Is a nonprofit company, joint venture between the government and the private sector, which offers services as credit, health, education, housing, recreation, culture, tourism, and retail.

www.colsubsidio.com

MIGUEL REYES

Oakville, ON L6K3C5; 905-***-**** ff9fko@r.postjobfree.com Page: 2/2

Successfully implemented 3 full life cycle implementation. Redesigned and optimized Warehouse Data; sales information of retail business, education, health, credit, housing and collection. Extensively worked on the Administrative Workbench for configuring, scheduling and monitoring functions. Controlled, monitored and updated all data retrieval processes. Archiving and cleaning the warehouse data, continued improvement of the data warehouse, performance and tuning, BO Xcelsius Developer, with the following additional responsibilities:

• Created roles, users, groups, assign 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 Extraction.

• Generated reports using Bex Analyzer/ Browser in building queries and saving in workbooks (Excel sheet) and Created custom queries using Calculated and Restricted key figures, Structures, Exceptions, Conditions.

• Created Process chains for Master data and transaction data loads.

• Modified Update rules, Transferred rules, Updated routine, transferring routine as per client requirement.

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

• Extensive experience in extraction of Non-SAP systems (via Flat file) and Design of an automatic process to extract data from flat files stored at Application server with Unix.

• Designed and developed executive dashboards with Xcelsius, Expert in APD

JDE Edwards Consultant.

CSI LTDA. (Colombia) March 2008 – April 2008

Migrated the database ERP (JDE Edwards) from DB2 to SQL Server 2005 in the multinational pharmaceutical company SANOFI AVENTIS.

IT Coordinator

BIOFILM S.A. (Colombia) September 1997 – January 2008

The largest exporter of BOPP films in Latin America. BIOFILM’s first production facility is located in Cartagena, Colombia, where today there are three modern production lines.

http://www.biofilm.com.co/biofilm_en/

Data Warehouse Leader (Cognos), Migration Cognos from series 7 to 8, Crystal Reports, Coordinator, technical leader, specifications and development of new projects, personally responsible for the following reporting modules and applications:

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

Information Transfer from the ERP database to Hyperion for consolidation of financial statements.

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

EDUCATION

• Bachelor of Computer Science and Systems Engineer, Jorge Tadeo Lozano University 1996

• MBA in Computer Information System, EAN University 2004

Contact this candidate