Juan Carlos Castillo López
Coordinador Mis at Bradescard México- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Ingles -
Topline Score
Bio
Credentials
-
EF SET Certificate - English Level
EF Standard English Test (EF SET)Jan, 2023- Oct, 2024 -
Conviértete en experto en Excel 2016
LinkedInFeb, 2019- Oct, 2024 -
Excel 2016 VBA esencial
LinkedInFeb, 2019- Oct, 2024 -
Excel 2016: Fórmulas y funciones
LinkedInFeb, 2019- Oct, 2024 -
Excel 2016: Validación de datos
LinkedInFeb, 2019- Oct, 2024 -
Excel 2016 avanzado: Técnicas de formato
LinkedInJan, 2019- Oct, 2024 -
Excel 2016 práctico: 25 aplicaciones básicas con tablas dinámicas
LinkedInJan, 2019- Oct, 2024 -
Excel 2016: Análisis y gestión de datos
LinkedInJan, 2019- Oct, 2024 -
Excel 2016: Gráficos y presentación de datos
LinkedInJan, 2019- Oct, 2024 -
Excel 2016: Tablas dinámicas
LinkedInJan, 2019- Oct, 2024 -
Excel 2016 esencial
LinkedInDec, 2018- Oct, 2024
Experience
-
Bradescard México
-
Mexico
-
Financial Services
-
200 - 300 Employee
-
Coordinador Mis
-
Sep 2023 - Present
-
-
Coordinador MIS credito y riesgo
-
Aug 2023 - Oct 2023
-
-
-
HP
-
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
-
-
-
GrandVision BV
-
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.
-
-
-
Citibanamex
-
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
-
-
-
Credit Suisse
-
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.
-
-
-
BBVA en México
-
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 -
Bedu
Fullstack/Python, fullstack development -
Universidad Tecnológica de México
computer systems engineer, Computer systems