Juan Carlos Castillo López

Coordinador Mis at Bradescard México
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Guadalajara, Jalisco, Mexico, MX
Languages
  • Ingles -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • EF SET Certificate - English Level
    EF Standard English Test (EF SET)
    Jan, 2023
    - Oct, 2024
  • Conviértete en experto en Excel 2016
    LinkedIn
    Feb, 2019
    - Oct, 2024
  • Excel 2016 VBA esencial
    LinkedIn
    Feb, 2019
    - Oct, 2024
  • Excel 2016: Fórmulas y funciones
    LinkedIn
    Feb, 2019
    - Oct, 2024
  • Excel 2016: Validación de datos
    LinkedIn
    Feb, 2019
    - Oct, 2024
  • Excel 2016 avanzado: Técnicas de formato
    LinkedIn
    Jan, 2019
    - Oct, 2024
  • Excel 2016 práctico: 25 aplicaciones básicas con tablas dinámicas
    LinkedIn
    Jan, 2019
    - Oct, 2024
  • Excel 2016: Análisis y gestión de datos
    LinkedIn
    Jan, 2019
    - Oct, 2024
  • Excel 2016: Gráficos y presentación de datos
    LinkedIn
    Jan, 2019
    - Oct, 2024
  • Excel 2016: Tablas dinámicas
    LinkedIn
    Jan, 2019
    - Oct, 2024
  • Excel 2016 esencial
    LinkedIn
    Dec, 2018
    - Oct, 2024

Experience

    • Mexico
    • Financial Services
    • 200 - 300 Employee
    • Coordinador Mis
      • Sep 2023 - Present

    • Coordinador MIS credito y riesgo
      • Aug 2023 - Oct 2023

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Desarrollador de Visual Basic
      • Aug 2021 - Nov 2022

      Process optimization and creation of interfaces for the SAP system Analyze the current processes in the company and propose solutions or improvements to get better results. Create processes that improve the tasks of the area using Microsoft tools like Power automate, Power BI, and VBA codification. Create interfaces to work with SAP systems and Microsoft Dynamics Extract information from SQL tables and transform it to files to feed SAP system Process optimization and creation of interfaces for the SAP system Analyze the current processes in the company and propose solutions or improvements to get better results. Create processes that improve the tasks of the area using Microsoft tools like Power automate, Power BI, and VBA codification. Create interfaces to work with SAP systems and Microsoft Dynamics Extract information from SQL tables and transform it to files to feed SAP system

    • Netherlands
    • Retail
    • 400 - 500 Employee
    • VBA programmer. specialist in automation processes and Data analyst
      • Jan 2019 - Oct 2021

      Analyze current information management procedures in the Finance Area and propose improvements to them. Build and deploy Power BI Reports to use them Nation Wide. Develop and implement the proposed solutions for process and task automation. Analyze current information management procedures in the Finance Area and propose improvements to them. Build and deploy Power BI Reports to use them Nation Wide. Develop and implement the proposed solutions for process and task automation.

    • Banking
    • 700 & Above Employee
    • Sports and Culture Specialist
      • Oct 2016 - Sep 2018

      Manage the annual budget of thirty million Mexican pesos.Generate gender metric reports from sub-management levelsAnalyze and determine the amounts per activity according to the budget.Receive and attend internal control audits annually.Define and manage the annual calendar of events and activities at the national level.Planning, logistics and execution of BAU events.Negotiate with suppliers based on a quarterly activity plan.Generate purchase orders for suppliers.Verify and validate monthly billing against services granted for payment release.Generate monthly metrics for possible budget re-allocation. Show less

    • Diversity Specialist
      • Oct 2014 - Sep 2016

      Specialist in charge of budget management for the area (10 million MXN per year)Specialist in charge of generating gender metrics at the National level.Responsible for the generation of purchase orders, review and payment of invoices to suppliersInternal social media managerResponsible for logistics and implementation of events in the area

    • Learning And Development Specialist
      • Mar 2012 - Sep 2014

      Generate training control and monitoring files using files generated by the bank's systems as a source of informationGenerate self-service report files for Divisional ManagersGenerate manager training monitoring files at the national levelSend informative and follow-up emails by division and market

    • Switzerland
    • Banking
    • 700 & Above Employee
    • Analyst
      • Jul 2008 - Oct 2011

      Monitor, improve and migrate the systems used to send information (systems based on C #, XML, Oracle, SQL, UNIX) Conduct the necessary tests of either hardware or software to support the documentation conducted Verify the send of information, and forwarding of trades (bonds, swaps) Activate servers remotely, check databases, send backup files, run scripts. Monitor, improve and migrate the systems used to send information (systems based on C #, XML, Oracle, SQL, UNIX) Conduct the necessary tests of either hardware or software to support the documentation conducted Verify the send of information, and forwarding of trades (bonds, swaps) Activate servers remotely, check databases, send backup files, run scripts.

    • Mexico
    • Financial Services
    • 700 & Above Employee
    • Analyst programmer
      • Feb 2005 - Jun 2008

      Oracle Database optimization and administration. Develop, implement, and maintain distributed systems created in Visual Basic 6. Manage, mount, and connect portfolio management systems (external system programmed in VB6). Corrective maintenance and troubleshooting of portfolio management systems. Develop updates for existing systems to solve new requirements. Oracle Database optimization and administration. Develop, implement, and maintain distributed systems created in Visual Basic 6. Manage, mount, and connect portfolio management systems (external system programmed in VB6). Corrective maintenance and troubleshooting of portfolio management systems. Develop updates for existing systems to solve new requirements.

Education

  • Universidad Tecnológica de México
    Master in Analytics and Business Intelligence, Information technology
    2021 - 2022
  • Bedu
    Fullstack/Python, fullstack development
    2019 - 2019
  • Universidad Tecnológica de México
    computer systems engineer, Computer systems
    2000 - 2005

Community

You need to have a working account to view this content. Click here to join now