Marcelo Sanchez

Work experience

• BI Contractor Jan 2024 - Present
  Datawarehouse, Azure, Report Dev | JAJMSK Pty Ltd

  Freelance BI consultant, focus on work (Datawarehouse Dev, ETL, DEVOPS using Azure and GITHUB Integration, Microsoft Fabric, PBI, HTML, CSS, SQL Dev,migrating DBs from OnPremise to Azure SQL Manage Instance, ETL and Reporting works.
• Data and Reporting Specialist Jan 2022 - Dec 2023
  Sales Datawarehouse and Reports Dev | Helloword Travel Limited

  Led the company and analytics team, providing technical leadership and serve as a catalyst in the migration and adoption of Microsoft BI Suite; to migrate and develop sales data warehouse and dashboard/reports.

  • Facilitate migration DBs from SQL 2012 to SQL 2019
  • ETL development to build ingest data from various system.
  • Conducted analysis of existing business data that are use as report's slicers and proposed better solution of managing it, utilizing SQL Server MDS to improve data governance and integration for reporting purpose.
  • Development of reports and dashboard providing more visibility to business stakeholders; keeping track of KPI metrics for sales and products; gaining a clearer, measurable understanding of their goals and targets;the new batch of reports had make improvements with regards to their sales strategies and make data-driven decisions to maximize revenue generation.

  Skills: SQL 2019, Azure, SSIS, ADF, SQL Master Data Service, Power BI, Reporting Services

• Senior Business Intelligence Developer - Contract May 2021 - Nov 2021
  Reports Dev and Testing | Bridgestone Mining Australia

  Hired as a consultant to look into the current reporting tools, capacity and how to adapt and use. Development and testing of batch of tyre reports used in the mining sites.

  • Analyzed current reporting system and data management being used by Solution Development Team. Provided analysis and solution documentation regarding current tool limitation and strategies solution to improve data management and reporting.

  • Created test plans; formulated various test cases and facilitated test execution for batch of reports used by Tyre Maintenance Departments.

  • Development of reports and dashboard for Tyre's Maintenance and Wheels Departments.

  Skills: SQL Server 2017, SQL Server Master Data Services, SSIS, PBI and Reporting Services

• Business Intelligence Developer Aug 2010 - Mar 2021
  Datawarehouse Dev and Maintenance | Rexel Holdings Australia

  Led several projects (datawarehouse and reports upgrade from SQL 2008 to SQL 2017, Price Sensitivity / Fact Customer Analytics, Branch Sales Analysis, Branch Finance Scorecard, Digital Branch incentives program supporting marketing campaign.

  • Involved in analysis and development of new DW /BI initiatives raised in monthly steering committees; includes minor and major enhancement such as additional business process.

  • Development of reports and dashboard for Finance, Marketing and Business Branch

  • Development of new fact tables and ETL for Datawarehouse Growth

  • Improved team process by documenting process and scope owned by the BI Team, set-up a BI Team site and Data Volt using Sharepoint where collective ideas and documents can be shared across team and departments; providing long term benefits.

  • Provide secondary support on Dynamics 365 CRM for Sales. Sales and Opportunities extract and reporting.

  • Monthly, Quarterly, Yearly BI Roster Tasks, DBs Backup and Maintenance

  Skills: SQL Server 2017, SQL Server Master Data Services, Sharepoint, SSIS, PBI, Reporting Services, Powershell, Power Automate, Microsoft CRM. Dimensional Modelling using Kimbal Methodology and BIML Framework for SSIS Dev

• Business Intelligence Developer - Contract Jun 2010 - Aug 2010
  Web Interface Design and DBs Reports Dev | Infomedia | Sydney

  Hired as a consultant to analyse and design a report web page to be integrated to the company's online site. Perform database performance and tuning.

  Skills: SQL Server, Microsoft Visio

• Business Intelligence Consultant and Developer May 2008 - Mar 2010
  Consulting and Dev | Eclipse (UXC) | Sydney

  Hired as consultant to do a project scoping, business analysis and development work with regards to data warehousing and reports dev out of ERP (Microsoft Dymanics Products).

  • Provided analysis and solution documentation regarding creation of out-of-the-box reporting solution for Dynamics 365 Finance (AX)and Busines Central (NAV).

  • Sharepoint Development build site contents and document library and list.

  • Development of reports and dashboard for UXC clients

  Skills: SQL Server, Sharepoint, MS BI Tools (SSAS, SSIS, SSRS)

• Business Intelligence Developer 2006 - Apr 2008
  Datawarehouse and Reporting | AVANADE | Manila Philippines

  Provided support and development to on-shore project counterpart in Johannesburg, South Africa and Sydney Australia with regards to implementing MS BI solutions.

  • DBs migration from SQL 2000 to SQL 2005

  • ETL and report development.

  • Prepare work unit packages which include: source code, documentation, unit test data/plans, debugging, and evaluating test results against expected results.

  • Development of reports for Avanade clients.

  Skills: SQL Server 2005, MS BI Tools (SSAS, SSIS, SSRS)

• Software Engineer / QA Engineer 2003 - 2006
  Project Engineer Support and DBA | Accenture| Manila Philippines

  Provided support to project engineers in the implementation of continous improvement for dev work and testing. DBA work in Software Engineering Team.

  Skills: SQL Server,Data Transformation Service (DTS),Software Engineering Tools and Methodology

• Application Developer 1999 - 2003
  Payroll and Human Resource Systems, DBA | Comfac | Manila Philippines

  • Maintained company's payroll and HRIS system. DBA work, Development of application for internal use e.g HRIS System

  Skills: Crystal Reports, Visual Basic