Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Andres Idelfonso Avila Hernandez

Data Analytics Manager

Andres Idelfonso Avila Hernandez
36 years old
Monterrey (66354) Mexico
Professional Status
Employed
Available
About Me
Finance and Data Science professional with a strategic mindset and very passionate about technology and innovation. With a 360 degrees of experience from finance to IT, involving areas such as valuations, strategic planning, and data analytics. International experience developing a deploying project in Brazil, India, and China. Currently working as Data Analytics Manager getting the best insights in the music industry to understand our audience, forecast sales, and increase our market share and e-commerce footprint.
Resume created on DoYouBuzz
Experiences
  • Head of sales management providing analysis, insights and visualizations to measure RGM (Revenue Growth Management) to end up with accurate forecasting and planning by channel, partner, and key projects.
  • Lead End to End dashboarding (Domo, MicroStrategy, Power BI, and Google Data Studio). Delivering “storytelling” and insights as well as data pipelines.
  • Designs and developments to cluster, regressions, U shape analysis, A/B testing, ETL, and Data wrangling. On SQL and Python.
  • Head of profitability by project retrieving, analyzing, and publishing financial numbers by artist and project; to oversees sales, A&R, and marketing expenses.
  • Leverage stored data inside the cloud (GCP) by developing new reports to track the effectiveness of Marketing Campaign Return (MCR). Royalties, Costs and EBITDA impacts. Implementing workflows and data pipelines to keep the reporting updated.
  • Lead regional data training for new hires in SQL, Financial analysis, pipeline construction, e-commerce, data minning, and KPI developments.
  • Data wrangling in SQL to get an SST "Single Source of Truth", data pipelines management to transform raw data into functional tables and datasets.
  • Project management to develop new tools that enhance our already stored data as well as the new inbounded. With strong communication inside the company collaborating with all levels, regions, and C-suite to understand the needs and deliver the best solution. Focused to meet deadlines and surpass expectations.
  • Managing unstructured and physical data sources to lead quarter results presentation for C-suite.
  • Increase collaboration within the business units to achieve corporate´s goals. Merging the data pipelines in a single corporate source.
  • Successfully published 2017 annual report of results to Mexican Stock Exchange (BMV).
  • Energetic co-working with finance and chemistry division to improve the process and reduce inaccurate data, ending up with a dataset in Excel and Access.
  • Developed and enhance data pipelines collaborating with IT as a result, we got the first dashboards in HR, Finance, and Operations getting insights that were automatically updated and web published in the intranet.
  • Enhance internal matrices used on annual bonus calculation.
  • Cost savings strategies for 120M MXP inside electrical cogeneration and caustic soda businesses.
  • Successfully develop a methodology for controlling global procurement projects. Results showed in Lumira and Tableau platforms.
  • Accomplished financial stretch by following up and leading global projects advisory. With monthly follow-up.
  • Establish a new methodology based on demand planning for procurement’s annual budget inside HFM and SAP.
  • Global deployment of the financial model based on Excel for new business. Enhancing outputs out of the model with a more accurate quotations.
  • Global management of a workshop to improve financial and commercial processes for Mexico, US, Germany, Brazil, and China. Improving global coworking and knowledge share within all the territories.
  • Reach solid results and analysis of prices productivities impact forecast. That ends up in a better commercial budget and business plan.
  • Counseling based on financial analysis for new businesses.
  • Initial deployment and standardization for financial reports run in Oracle BI.
  • On site finance controller in Beijing, China.
  • Development of executive monthly reports for top management gathered automatically from Oracle BI suite as well as its mobile app.
  • Started Oracle BI dashboards used to show financial KPIs to board of directors.
  • Accomplished strong analysis for full platform forecasts.
  • Enhance financial evaluation process for capital investments.
  • Accomplished global internal and external audits without incidences.
  • Develop and deployment of global cost standard methodology.
  • Increase productivity by developing a global financial model in Excel.
Education

Monterrey Institute of Technology and Higher Education

Master Data Science & BI

IEBS

October 2019 to August 2020
Data Science & BI

BA Finance

ITESM

August 2007 to June 2013
Bachelor Adminsitration focus in corporate finance, financial analysis, IS analysis, market and portfolio.
Skills

Software

  • Microsoft Excel
  • Microsoft PowerPoint
  • Hyperion
  • Power BI
  • SAP ERP
  • Python
  • Google Analytics
  • Microstrategy
  • SQL
  • Tableu
  • Lumira
Languages
  • English
    Fluent
  • German
    Beginner