Oscar Alejandro M. Profile

EXPLORE

0.0

(0 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$50 USD / hour

aarberg,

switzerland

$50 USD / hour

It's currently 11:57 PM here

Joined March 24, 2017

0 Recommendations

Oscar Alejandro M.

@oscarvalerock

0.0

(0 reviews)

0.0

$50 USD / hour

aarberg,

switzerland

$50 USD / hour

N/A

Jobs Completed

N/A

On Budget

N/A

On Time

N/A

Repeat Hire Rate

Business Intelligence and Productivity Consultant

My passion is to help organizations to tell stories based on their data. I believe that everyone can perform and benefit from data analysis through business intelligence, and even further, tell a compelling and engaging story. My core competencies include Power BI + Excel + Office 365 Suite integration, KPI analysis, dashboard design, data visualization. What I can do: - Create stunning dashboards in Power BI and Excel. - Train power users in the organization on Power BI and Excel. - Automate data retrieval process. - Power BI, Power Query, Power Pivot, DAX. - KPI analysis YoY, YTD, MoM, etc. Integrity has been the cornerstone of my professional development. Results driven, customer-centric, analytical and focused professional with broad experience in finance, management, data analysis, processes redesign, and people development.

See all Excel Experts in Switzerland

Contact Oscar Alejandro M. about your job

Portfolio

This is a short video about the capabilities of Power BI and Cortana integration.

This integration is useful to get instant access to the business questions without the need of opening the Power BI report or the Power Bi service.

With this integration you can retrieve immediately, updated data from you Power BI reports, whenever is most needed.

https://youtu.be/fXd-8C3EEYg

Power BI Cortana Integration

Treasury department's core is safeguarding cash, which is one of the business' core KPIs.

The goal of this report is to keep the upper management updated with the latest banking information.

We have created this report which follows on two indicators: Cash and Debt.

Cash: can be visualized per company, country, currency, all of this translated to USD equivalent using a daily FX rate.

Debt: maturity date and general loan information are readily available at any time.

https://app.powerbi.com/view?r=eyJrIjoiYTUwNTFmMzYtOTIwNi00NmNlLWEwZGMtMjE5ZTE5NWQ2ZGQ0IiwidCI6ImE4NDQwMDNmLTAxMmMtNDUxZS1iZWJiLWRhNGMwZjg0YzgyZCIsImMiOjR9

Power BI - Cash Balance Dashboard

Analysis of the development from Ronaldo and Messi (can be used for any player).

https://app.powerbi.com/view?r=eyJrIjoiMjkxYTNkNzMtMjBmMi00ZmEwLTk2YzQtZGVlZDU2YzkxODlhIiwidCI6ImE4NDQwMDNmLTAxMmMtNDUxZS1iZWJiLWRhNGMwZjg0YzgyZCIsImMiOjR9

Power BI - Ronaldo and Messi

Report created with Power BI which pulls data from the World Bank, this was based on a 2006 Hans Rosling's TED talk.

The report's explanation is narrated using "Read Aloud," the office 365 functionality which allows you to listen to your documents.

https://www.youtube.com/watch?v=Ma9urmCy7EE

https://app.powerbi.com/view?r=eyJrIjoiM2QxZDk1NTctY2Y2ZC00YmI5LWFmYzUtZmFkMjg0M2RkNWI4IiwidCI6ImE4NDQwMDNmLTAxMmMtNDUxZS1iZWJiLWRhNGMwZjg0YzgyZCIsImMiOjR9

Power BI - World Bank API & Read Aloud

Power BI Cortana Integration

Power BI - Cash Balance Dashboard

Power BI - Ronaldo and Messi

Power BI - World Bank API & Read Aloud

Reviews

Changes saved

No reviews to see here!

Experience

Accurity BI Consulting

Jul 2018 - Present

A self-started project focused on Power BI, Excel and Office 365 Suite and productivity training.

Rassini SAB de CV

Jan 2016 - Jul 2018 (2 years, 6 months)

Negotiation of +100 MUSD of credit lines (factoring, short, rev. and long-term loans, committed facilities, LC) Automation of Cash reporting for four countries, and over 70 bank accounts. Implementation of live reporting dashboards and Business Intelligence Reports

ABB Mexico

Jan 2012 - Jan 2016 (4 years)

Redesign and simplification of banking structure, yearly savings of 500 KMXN. Designed a secure, robust and functional e-banking structure for our 20 different accounts and bank services within five different banking systems. Financing Activities: Supply chain finance (20 MUSD line), 30 MUSD project finance with 2 MMXN savings in interest & commissions.