Learn Data Skills
Beta
Luis Perez

Luis Perez

Senior Data Analyst

Awin

Technologies

My Portfolio Highlights

My New Track

Understanding Data Topics

My New Course

Introduction to Python

My New Track

Understanding Data Topics

Data explorer, uncovering insights in the digital wilderness.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to ChatGPT

course

Introduction to Python

course

Introduction to SQL

DataCamp Course Completion

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

Courses

Introduction to Python
Introduction to SQL
Introduction to ChatGPT
Understanding Data Science

My Work Experience

Where I've interned and worked during my career.

Awin | May 2019 - Present

Senior Data Analyst

Leading global data projects across the organization supporting different global departments (Finance, HR, Sales,…) to translate data into valuable and comprehensible insights. • Developed and maintained Tableau dashboards and reports to support business objectives. • Perform exploratory data analysis (EDA) to uncover patterns, trends, and insights within the data. • Transforming data through SQL queries to blend meaningful insights from various data sources and data warehouses • Data Communication and Collaboration: Collaborate with cross-functional teams to understand their data needs and provide relevant insights through Tableau visualizations. Present findings to non-technical stakeholders in a clear and understandable manner, making complex data concepts accessible. • Used agile work methods to promote collaboration, adaptability and flexibility in project delivery • Training and Mentoring: Provide guidance and mentorship to junior analysts or developers, helping them improve their skills in data analysis and Tableau usage. Conduct training sessions or workshops to educate colleagues on using Tableau effectively. • Continuous Learning: Stay updated with the latest trends and best practices in data visualization, analytics, and Tableau features to bring innovative solutions to the team. Environment: Tableau Desktop, Tableau Server, Power BI Desktop, MS Excel, SQL Server, Databricks, Agile, JIRA
Show More

Awin | Oct 2016 - May 2019

Tableau / Data Analyst

Within Business Intelligence team, responsible to coordinate the new BI environment across the organization. • Using Tableau and SQL, design and create interactive and visually appealing Tableau dashboards and reports that provide actionable insights to stakeholders • Created Users, User Groups and Projects through Tableau server and assigned roles and permissions for Tableau Users. • Utilize Tableau's features to display complex data in a comprehensible manner, using various visualization types (e.g., bar charts, line graphs, heat maps, scatter plots, etc.). • Implement interactive filters, parameters, and actions within dashboards to allow users to explore data dynamically. • Ensure that dashboards are responsive and accessible across different devices and screen sizes • Advanced Visualization Techniques: Incorporate advanced visualization techniques such as treemaps, box plots and animated visualizations to enhance data storytelling. • Data Integration and Transformation: Work with SQL databases, data warehouses, and data lakes to retrieve and transform data for analysis and visualization. Develop ETL (Databricks) processes to clean, reshape, and aggregate data for reporting purposes. • Converted 60+ reports from Excel to Tableau & PBI for the different departments of the Group • Experience with Published Tableau workbooks (.TWB) from Tableau desktop to Tableau Server and with Tableau data Extract (.TDE). • Documentation: Document data sources, methodologies, and assumptions used in analyses to ensure transparency and reproducibility. Environment: Tableau Desktop, Tableau Server, Power BI Desktop, MS Excel, SQL Server, Databricks, Agile, JIRA

BASF | Jan 2011 - Oct 2016

Data Analyst

Within Credit Risk Management leading and participating in different BI global projects. Responsible of the Credit Risk reporting package for Southern Europe • Extract data from SAP systems and related databases using tools like SAP Business Warehouse (BW), SAP HANA, or other relevant SAP modules. • Ensure data privacy and compliance with relevant regulations (such as GDPR) when handling sensitive data within the SAP environment. • Optimize data retrieval and processing within SAP systems to ensure efficient and responsive performance of reports and queries. • Developed MIS dashboards in Excel, PBI and Tableau for different teams within Credit Risk & AP • Investigate data discrepancies and inconsistencies within the SAP environment, identifying the root causes and proposing solutions. • Automation of internal processes within the collection department. This has resulted in a 60% reduction in processing time, a 30% decrease in DSO (Days Sales Outstanding), and an increase in IC (Contact Indicators) Environment: SAP (CO/FI/BW), Tableau Desktop, Power BI Desktop, MS Excel, Access, Power Point

Universal Pictures | Feb 2008 - Dec 2010

Credit Controller / Reporting Expert

Managing the credit and collections processes while also providing accurate and timely financial reporting related to credit and collections activities. • Evaluate creditworthiness of new and existing customers, utilizing credit scoring models, financial statements, and other relevant information. • Set credit limits and terms for customers in alignment with company policies and risk tolerance. • Monitor accounts receivable aging reports to identify overdue accounts and initiate collection efforts. • Communicate with customers to resolve payment discrepancies, negotiate payment plans, and facilitate timely payment. • Generate regular financial reports related to accounts receivable, collections, and credit metrics. • Reduced accounts receivables by 50% through implementation of new billing and collection procedures

My Education

Take a look at my formal education

Bachelor’s in Business and Management in FinanceComplutense, Madrid | 2005
Higher-level diploma in International Business in International TradeIESCE, Madrid | 2002

Powered by

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