Luis Palacios

MBA | Data Analyst | Financial Planning
St. Clair College. Ontario, Canada
Univ Andres Bello (UNAB), Chile
Univ Diego Portales (UDP), Chile

Biography

I am an experienced professional in Data and Financial Planning Analysis roles within large and fast-paced corporations. Financial planning specialist trained in BI development, data analysis, and large experience in financial reporting. Postgraduate diploma in Data Analytics for Business at St. Clair College (ON, Canada), MBA UEM-UNAB (Chile-Spain), Finance Bachelor Degree UNAB (Chile) and Computer Science Engineer at UDP (Chile)

I have person with a natural passion for learning new data tools and processes.
Experienced in data analysis, data visualization and KPI/metrics visualization, with knowledge in Python, R, SQL, Tableau, Power BI, and large experience in QlikView and Qlik Sense.
Aside from that, knowledge of Oracle Hyperion Planning, HFM and SmartView tools for advanced reporting and pulling data.

I am an enthusiastic business partner and passionate about the highest quality of work and positive environments. Creative solutions architect with real-time problem-solving flexibility. Proven ability to learn quickly and adapt to new situations.

On this site I keep updated my resume, as well you can reach my LinkedIn.

Awards and Recognition

Laureate Collaboration Award.
2016. Global recognition conferred among all network financial teams. This Award was given for my contributions and share all my findings with my colleagues and other regional teams
SECC - Integrity Award
2024. “Integrity” award at SECC, recognizing my hard work, dedication, and commitment to excellence. I was conferred after 9 months only at SECC as a Data Specialist – Department Coordinator.

Education

Computer Science & Management Control Engineer
2004. Universidad Diego Portales (UDP). Santiago.
Chile
PMP Project Management | Diploma
2009. Universidad Diego Portales (UDP). Santiago.
Chile
Bachelor Business Administration
2013. Universidad Andres Bello (UNAB). Santiago.
Chile
MBA, Master Business Administration
2020. Univ. Andres Bello (UNAB) | Univ. Europea de Madrid (UEM). Santiago-Madrid
Chile - Spain
Data Analytics for Business | Postgraduate Diploma
2023. St. Clair College. Windsor, Ontario.
Canada

Skills

MS Excel / MS Access
Performing data analysis, including PowerQuery. Ability to provide analysis and operational insights
SQL
Relational databases, data integration. Ensuring the integrity of the data
Python
Analyzing data to provide key insights and solve business challenges. Extract, integrate and analyze multiple disparate data sources from a variety of systems, such as structured and unstructured data.Mine data to uncover patterns and to identify business trends and new opportunities for using analytics
R
Explore data, apply statistics functions
HFM
Hyperion Financial Management. Consolidate and report financial results, meet global regulatory requirements, reduce the cost of compliance, and deliver confidence in the numbers
Hyperion Planning
Collection of data and financial consolidation. Data entry, analysis, and reporting, including personalizing data entry forms
Smartview
Experienced skills for reporting and querys. Design worksheets in Microsoft Excel to enter, format, analyze, and report on data
Tableau
Creating understandable visualizations of the extracted data and identifying patterns and insights from data analysis
Power BI
Including modeling with DAX, designing and mapping data models to shift raw data into meaningful insights, utilizing Power BI to build interactive and visually appealing dashboards and reports, and embedding Power BI content.
QlikView | Qlik Sense
Transforming large amounts of data in ways that are universally understandable or easy to interpret and spot patterns, trends and correlations. Build reports and dashboards with the help of Qlik and other reporting tools

Courses & Seminaries

Data Analysis in Excel | February 2022
DataCamp. Build real world Excel skills and outputs
PDF
Database Design | February 2022
DataCamp. Design Databases in SQL
PDF
Relational Databases in SQL | March 2022
DataCamp. Build and create the most efficient ways of storing data into relational databases
PDF
Dashboards in Tableau | April 2022
DataCamp. Data-driven, impacting on business performance with Tableau dashboards
PDF
Data manipulation in Pandas (Python) | April 2022
DataCamp. Import and clean data, calculate statistics, and create visualizations with pandas.
PDF
Foundations of probability in R | May 2022
DataCamp. Concepts of random variables, distributions, and conditioning in R. Statistics applied into real case problems
PDF
Inference for Categorical Data in R | July 2022
DataCamp. Leverage statistical techniques for working with categorical data
PDF
Inference for Numerical Data in R | July 2022
DataCamp. Appling techniques for performing statistical inference on numerical data in R
PDF
Intermediate Python | April 2022
DataCamp. Data science skills by creating visualizations using Matplotlib and manipulating
PDF
Intermediate SQL Queries | February 2022
DataCamp. Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL
PDF
Intro Numpy | March 2022
DataCamp. skills in NumPy by learning how to create, sort, filter, and update arrays using NYC’s tree census
PDF
Intermediate Python | April 2022
DataCamp. manipulating
PDF
Introduction to Python | March 2022
DataCamp. Master the basics of data analysis with Python. Introducing the Python interface and explore popular packages
PDF
Sampling in R | May 2022
DataCamp. Master sampling to get more accurate statistics with less data.
PDF
Supervised learning with scikit-learn | April 2022
DataCamp. Machine learning skills with scikit-learn in Python. Use real-world datasets in this interactive course and learn how to make powerful predictions
PDF
Understanding cloud computing | February 2022
DataCamp. A non-coding introduction to cloud computing, covering key concepts, terminology, and tools.
PDF
Artificial Intelligence (AI) Concepts in Python | April 2022
DataCamp. Learn the fundamentals behind AI and Machine Learning.
PDF
Analyzing Data in Tableau | April 2022
DataCamp. Tableau skills up a notch with advanced analytics and visualizations
PDF
AWS cloud concepts | February 2022
DataCamp. Fundamentals of cloud computing with AWS.
PDF
Budgeting with Machine Learning in Python | July 2022
DataCamp. Build models and automatically classify items in a school budget
PDF

Scrum The Basics | November 2022
LinkedIn. How to manage your projects and measure how they're faring, and set manageable improvement goals.
PDF
Project Management Simplified | November 2022
LinkedIn. Plan a project, manage resources, monitor progress, and deliver your project on time and on budget
PDF
Requirements Elicitation and Analysis | October 2022
LinkedIn. Different ways of gathering requirements—such as brainstorming, observation, and workshops—before moving on to analysis techniques such as context diagrams, user stories, and decision tables.
PDF
Python Quick Start | April 2022
LinkedIn. Learn the basics you need to become proficient in Python, and decide if it’s the right language for your projects.
PDF
AI in Business Essential | February 2022
LinkedIn. Optimization and AI. Using data to make optimized decisions. Building a basic AI algorithm. Opportunities for AI in marketing and product pricing. Where AI doesn't work
PDF
Artificial Intelligence for Students | February 2022
LinkedIn. The basics of what you need to know to get started using artificial intelligence
PDF
Building Chatbots Using Google Dialogflow | April 2022
LinkedIn. Introduces Google Dialogflow and shows how this ecosystem can be used to build chatbots for a variety of business applications
PDF
Agile Foundations | November 2022
LinkedIn. Values and principles covered in the agile manifesto, as well as how to enhance communication with user stories and cross-functional teams. Discover how to respond to change the agile way, explore popular agile frameworks, and learn about the common roles on an agile team. Help boost your team's agility and productivity
PDF
Microsoft Project 2019 | November 2022
LinkedIn. Project 2019 and components such as work tasks, summary tasks, milestones, recurring tasks, and different types of resources
PDF
Python for Data Science | January 2023
LinkedIn. Techniques to clean, reformat, transform, and describe raw data; generate visualizations; remove outliers; perform simple data analysis; and generate interactive graphs using the Plotly library
PDF
Power BI Data Modeling with DAX | June 2023
LinkedIn. Work with DAX aggregate functions, add calculated columns, create measures, and work with DAX logical and filter functions
PDF
SQL Data Reporting and Analysis | July 2023
LinkedIn. Writing SQL queries for data reporting and analysis using built-in SQL functions to format or calculate results. Perform complex queries, such as joining data together from different database tables
PDF
Qlik Sense Analyze Data | June 2023
LinkedIn. Create and manipulate a variety of data visualizations, from bar charts to histogram charts; create PivotTables and reports; sort and filter data; and combine your app's sheets with objects, text, and images to create a story that clearly conveys your message.
PDF
Discover data analysis | May 2024
Microsoft. This training is about to explore the journey of a data analyst and learn how a data analyst tells a story with data. Includes exploring the different roles in data and learn the different tasks of a data analyst.
PDF
Get data in Power BI | May 2024
Microsoft. Retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. Also improving the performance while retrieving data.
PDF
Clean, transform, and load data in Power BI | May 2024
Microsoft. This training teachs how to simplify a complicated model, change data types, rename objects, and pivot data. Also learn how to profile columns so that you know which columns have the valuable data for a deeper analytics.
PDF
Design a semantic model in Power BI | Jun 2024
Microsoft. With Power BI, building a complex semantic model, loading tables of data flowing in from multiple transactional systems. In this subject, the student will learn about the terminology and implementation of star schemas, which are one technique to simplify a semantic model. Also, discover why selecting the appropriate level of data granularity is critical to the functionality and efficiency of your Power BI reports. Lastly, you discover how to use your Power BI semantic models to increase performance. .
PDF