Experience

Hunter Dickinson Inc.

• Canada
• Mining
• 1 - 100 Employee

• Business Intelligence - Advisor

  • Jan 2013 - Present

   Developed and maintained Business Intelligence systems using MS-SQL Server Services  Produced reports for Finance and IT departments under Reporting Services (SSRS)  Developed and maintained ETL solutions under Integration Services (SSIS)  Introduced Analysis Services (SSAS) using tabular model  Built Sharepoint sites to display Business Intelligence analysis  Consolidated data from multiple sources into Data Warehouses  Designed, maintained, monitored and secured databases in MS-SQL Server  Migrated databases to new versions of MS-SQL Server  Administered, maintained and migrated Sage 300 - ERP system (managing 50+ companies)  Designed dashboards, workflows, Infopath forms and lists in SharePoint  Customized and updated Crystal Reports files  Maintained data driven websites using ASP.Net, Java and VB.Net  Trained personnel in computer applications (MS-Excel, Directors Tracking and ERP system)  Wrote technical documentation for the IT department  Troubleshot MS-SQL servers, desktops and software Show less



Hartley & Marks Group

• Canada
• Consumer Goods
• 1 - 100 Employee

• Web and Systems Developer / Information Systems Specialist

  • May 2007 - Jan 2013

   Developed Business Intelligence Systems using MS-SQL Server 2008 and MS-Excel  Assisted in evaluating business intelligence systems (MS-SQL Server, Qlikview and Tableau)  Produced complex reports from multi-sources in Crystal Reports.  Developed desktop and web applications  Installed a basic multidimensional cube under SSAS  Developed multiuser secured database to facilitate the translation of product catalogs into five languages (English, French, Italian, German, Spanish)  Designed, maintained, monitored and secured databases in MS-SQL Server  Developed data-driven web application for recording employees hours  Migrated databases and SSIS packages from MS-SQL Server 2000 to 2008  Administered, maintained and migrated Sage 100 - ERP system (managing 10+ companies)  Worked closely with Finance, Marketing, Production and IT departments  Coordinated international projects for processing and exchanging data  Led interdepartmental teams in order to create computer applications  Trained personnel in computer applications (MS-Access, Masterlist, and ERP system)  Troubleshot MS-SQL servers, desktops and software Show less



BancodeMéxico

• Mexico
• Government Administration
• 700 & Above Employee

• Information Systems Assistant / Loan Officer

  • Sep 1985 - Sep 1997

   Designed and maintained clients and projects database  Developed Visual Basic computer applications  Prepared reports using Crystal Reports and MS-Excel  Trained personnel in computer applications (customers tracking system and MS-Access)  Monitored business indicators through statistical trends  Designed and maintained clients and projects database  Developed Visual Basic computer applications  Prepared reports using Crystal Reports and MS-Excel  Trained personnel in computer applications (customers tracking system and MS-Access)  Monitored business indicators through statistical trends