Learn Data Skills
Beta
Miguel Angel Sanchez

Miguel Angel Sanchez

Data Engineer

Cineplex

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Analytical maestro, orchestrating symphonies of insights with precision.

My Work

Take a look at my latest work.

course

Introduction to Functions in Python

course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Cineplex | Nov 2021 - Feb 2023

Data Engineer

• Analyze, design, and build Modern data solutions using Azure PaaS service to support visualization of data. Understand the current Production state of the application and determine the impact of new implementation on existing business processes. • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) • Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backward. • Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the SQL Activity. • Hands-on experience in developing SQL Scripts for automation purposes. • Created Build and Release for multiple projects (modules) in a production environment using Visual Studio Team Services (SSDT).
Show More

Cineplex | Nov 2018 - Nov 2021

Data Warehouse and Business Intelligence Developer

Reporting Services, for developing interactive dashboards, data visualizations, balanced scorecards, and self-service BI solutions. • Designing data models including customized business dimensions, facts and measures to support scorecard, and self-service reporting needs. • Building a data pipeline to enable data integration from disparate large data sources. Drive collection of new data, and refinement of existing 20 • Ensuring consistent use of information architecture standards. • Establishing controls to ensure BI tools are presenting accurate and timely information. • Translating user requirements into technical architecture vision and implementation plan. • Researching and recommend new tools and technologies. • Coordinate and support development efforts of technical and corporate staff with SQL tuning efforts as well as ongoing application implementation, support and upgrades. • Supporting production issues and maintenance as necessary. • Getting as a benefic Improving performance and time response of the reports. • Improving availability information updated for the reports high demanding. • Scheduled automatic refresh and scheduling refresh in power bi service. Writing calculated columns, Measures query’s in power bi desktop to show good data analysis techniques. • Participating in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Grupo Coomeva | Apr 2015 - Dec 2016

Business Intelligence Analyst

• Evaluating, interpreting, and analyzing data and business processes • Ensuring the appropriate construction of basic information for implementing BI projects. • Providing analytical support and expertise when compiling and reporting information. • Ensuring the quality of the requirements about data and information, applying procedures to control the integrity thereof. • Designing database to the highest level of scalability and performance. • Designing BI process. • Data Discovery, Data Mapping: Discovering data elements and their mapping to the indicators calculations • Cube Designing: Designing new dimensions, measures, hierarchies in Cube for new indicators • Developing code to load data for new indicators • ETL Development • Designing Dashboards in SSRS and Performance Point • Dashboards designing validation. • Designing, implementing and debugging processes on extraction, transformation and loading of data.

ASINE | Sep 2012 - Apr 2015

Business Intelligence Consultant

processes to previous telephone plant were connected in Nortel. This project called contact center integration. The project was extracting all data and metrics related to the operation and agents, this information was stored in an Informix database, then, we analyzed them. • Participated in requirements meetings and data mapping sessions to understand business needs. Documented requirements in business requirements Documents (BRD). • Designed and Developed schema data models. • Worked on all phases of data warehouse development life cycle, from gathering requirements, implementation, testing, training and support. • Interviewed Business Users of the DWH and Business Analytics to understand and troubleshoot the existing bottlenecks and problem areas. • Designed and developed ETL SSIS package to facilitate incremental load process. • Developed complex SQL queries using stored procedures, common table expression (CTEs), temporary table to support and SSRS Reports. • Provided continued maintenance and development of bug fixes for the existing reports.

Intergrupo | Mar 2011 - Aug 2012

Business Intelligence Developer

N/A

ILLUSTRATO S.A | Nov 2009 - Jan 2011

Web Developer

Analyzing, design and develop a web application in order to analyze market prices in real time. Develop of Web Application with C #, Develop of BI solutions using BI tools of Microsoft like SQL Server, Integration Services, Reporting Services and Analysis Services 2008.

My Education

Take a look at my formal education

Santiago de Cali University

About Me

Miguel Angel Sanchez

Miguel Angel hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free