Technology Analyst - TCS IP
(2021-12)
- Consolidate the most relevant information fo the client in 3 different boards, which show the necessary information for each item, according to the information contained in its bases, making arrangements to obtain better KPI's for their statistics.
- All the relevant information of the university while their queries for the extraction of the same were improved.
- Create SQL views to populate Tableau dashboards, creation of measures to get more accuracy information.
- Support in SQL for information extraction to get all the data visualization, query enhancement and views development.
- Creation of views with Snowflake use databricks to obtain a better results and to populate the PBI dashboards.
Technology Analyst - INFOSYS IP
(2021-07 - 2021-11)
- Manage BP System.
- Support in Azure for information extraction.
- Creation of information boards for BP.
- Manage the databases that feed the dashboards. Design data structure, functional, component relationship, analyze data, fast growth and performance and high availability.
Coordinator BI - INVOLVE IP accounting consulting and software development
(2020-11 - 2021-07)
- Manage the income system, based in Querétaro (2 people under my command), and management of collections for CDMX properties. Payment of rents, leasing of properties, collection of maintenance and administration of properties, showing a dashboard on Power BI.
- Accounting support for bank reconciliations, developed in SAP accounting module, development and upload to the cloud (analytics) of the dashboard with balance sheet and financial charts.
- Analysis of information sent by users.
- System for control of the group's real estate (Database, control system and monitoring board in Power BI).
- Punctual monitoring of the balance sheet and income statement for the 26 group companies. Dashboards developed using Power BI.
- Budget analysis by area and expense monitoring (SQL database and SSRS).
Arquitecto de Soluciones Tecnológicas - FND Government Sector
(2018-07 - 2020-08)
- Analyze requirements and coordinate the technical team for the development of the applications requested by FND users, as well as organize the pertinent tests for the QA test.
- Manage the databases (SQL) that feed the core of the applications requested by the various areas of FND. Design the data structure, functional, component relationship, analyze data, rapid growth and performance and high availability.
- Software obfuscation, to avoid malware.
- Support with presentations for DETI, through the generation of dashboards in Power BI, optimal for the analysis of projects managed by the area.
Coordinador Control Financiero - Bancoppel, SA I.B.M.
(2008-01 - 2018-05)
Banking Sector
- Acquire and manage a server (SQL, PHP, VB) that will contain the financial information necessary to prepare budgets for expenses and fundraising and placement balances of the branches and the different segments of the bank, generate the income statement, budget control and management of expenses by management. Developing internal systems to carry out such applications and MIS systems.
- Migration from oracle databases to sql, using SSIS.
- Mining data to fill the Power BI dashboards, as well as the databases (SQL) that contained more than 20 million records.
- Generate a system for the objective evaluation of the bank, as well as the incentives to pay for the employees of the branches. Taking the entire train of development, from the initial requirements, to the implementation of this.
- Development of the system to control and measure the portability of payroll in SAP branches and the resulting dashboard load (cloud analytics).
Gerente de Banca de Gobierno - Banco Mercantil del Norte
(2004-01 - 2007-11)
Banking Sector
- Develop an information system (MIS) for the control and management of accounts and clients in the sector, which allowed managing the client portfolio of executives and controlling spending.
- Analyze the bank's financial and results statement, in charge of reaching the bank's profitability individually.
- Manage and change the type of accounts in banking and control of commissions
- Prepare presentations for the General Management, extracting information from the SQL server assigned to the bank, which was fed by the MIS system and show the results on a Power BI dashboard.
- Development of a system to add, cancel and change the gas station regime for the PEMEX client through the SAP system and development of control panels.
