• Comprehensive knowledge in Data Warehousing and Business Intelligence • Strong involvement working with SQL Server 2008 R2/2012 (SSIS, SSAS, SSRS) • Extensive experience in data/performance analysis and reporting systems • Solid design and development understanding of Informatica (ETL) • Several years of experience as an Information Technology Professional • Excellent interpersonal and communication skills • Master of Business Administration Degree in Technology Management • Firm programming background in Visual Basic

Business Intelligence Consultant @ • Develop a new SSAS Cube to support analysis/reporting for the "New Market Strategy - Fair & Fast Loans" initiative • Create Reports (delivered through SSIS and SSRS/SharePoint) for the "New Market Strategy - Cheque Cashing" initiative From July 2014 to Present (1 year 6 months) IT Consultant @ • Software Installation and Updates • Hardware Upgrades • Desktop and Laptop Repairs • Virus Removal • Web Site Creation and Maintenance • Data Recovery From September 2006 to Present (9 years 4 months) Database Consultant @ • Analyze existing and new data sources to correctly map the required fields and information making all the necessary changes (Data Types, Length, Indexes, Temporary Tables, etc.) • Update UBC - Building Operations' MS Access Databases (i.e. Queries, Forms, Macros, Tables, VBA Modules, etc.) to include a series of new data sources (PeopleSoft Views) • Integrate existing data from HR Legacy System (FME) with the new data from PeopleSoft (HRMS and FMS) to enable the MS Access Databases (2003-2010) to preserve its current business and reporting functionality From June 2013 to June 2014 (1 year 1 month) Senior Business Analyst (Finance – Corporate Reporting) @ • Support the daily operation of the Financial Data Mart in a timely and complete manner • End to end design and testing of personnel and time data feeds from SAP and SAP BW, and manual flat files to the Financial Data Mart • Develop a new HR Cube (OLAP) including operational expenses and staff count information to support cost centre reporting • Create web-based reports using SQL Server Reporting Services (SSRS) through SharePoint • Design and development of the ETL automated solution using Informatica • Create a Microsoft Access application to prepare the international personnel data feeds for the Financial Data Mart, gathering information from different data sources (Oracle, Flat Files) • Work closely with end users to document business rules and requirements applying them in the technical requirements ensuring the deliverables were produced accordingly From November 2010 to April 2013 (2 years 6 months) Database Consultant @ • Installation and Configuration of a new MS SQL Server 2008 R2 environment • Transfer current database (MS SQL Server 2000) to the new MS SQL Server 2008 R2 environment • Performance tests of the new SQL Server 2008 R2 environment • Analysis of tables and indexes for performance enhancements From May 2011 to September 2011 (5 months) Database Consultant @ • Develop new and/or modify existing SQL statements (MySQL) to improve their e-commerce web application performance and functionality • Database maintenance, administration and performance analysis (DBA) on MySQL platform • Enhance their e-commerce web application (PHP) From September 2006 to June 2011 (4 years 10 months) Senior Business Analyst (Human Resources – Workforce Information) @ • Create a personnel and business unit scorecard with several levels and depth of analytical information (Attendance, Churn, Spans & Layers, Cost Centre Reporting, HR Analytics) • Design, administration and maintenance (DBA) of the Human Resources Data Mart. • Work closely with developers and business partners to understand requirements and provide the necessary deliverables in a timely and accurate manner • Design, administration and maintenance of the Workforce Information Intranet Portal backend (SQL Server 2000-2008, Windows 2003-2008 Server) • Migrate HR Analytics measures/applications from Access to SQL Server • Develop a Credit Services Call Centre scorecard with numerous metrics, gathering information from different data sources (EDW (DB2), Oracle, Flat Files, etc.) • Assist with web-based reports using ColdFusion From October 2000 to October 2010 (10 years 1 month) Database Consultant @ Support Serebra's Database Management System (MS SQL Server), specifically in the Corporate and E-Commerce areas with the following tasks: • Query Analysis • Data Structure • Database Schema / Organization From August 2004 to July 2007 (3 years) Developer (Consultant) @ • Update the Data Centre – Community Collection Program (CCP) application by optimizing outdated functionality (i.e. DAO to ADO) and adding new modules using Visual Basic and Access 2000 • Work closely with users to understand their needs and requirements and provide the necessary functionality • Create new and enhanced existing reports using Crystal Reports From September 2000 to December 2000 (4 months)

Master of Business Administration in Technology Management, Master of Business Administration @ University of Phoenix – Vancouver Campus From 2001 to 2003 Electronic In Computer Science Engineer, Computer Science @ Industrial Technical Education Centre (CETI) From 1991 to 1996 Antonio Dorantes is skilled in: Microsoft SQL Server, SSIS 2008, SSAS 2008, SSRS 2008, Data Warehousing, Business Intelligence, Business Analysis, Communication Skills, Systems Analysis, Interpersonal Skill, Information Technology Professional, Computer Network Operations, MBA, Technology Management, Informatica (ETL)