Experience

Ozeol.com

• Tunisia
• International Trade and Development
• 400 - 500 Employee

• Business Analyst

  • Jun 2022 - Nov 2023

  Bogotá, Distrito Capital, Colombia Develop a system of information to generate accurate information for the search process, created companies, and identified merchandise lots with the potential to purchase, in three different zones, North America (EEUU and Canada), Brasil and Latam, applying ETL process, Extract, transform (Power Query) and load information in an Access Platform allowing the integration all of the information. Achievements: Through the tool development, created a Dashboard in excel that updated… Show more Develop a system of information to generate accurate information for the search process, created companies, and identified merchandise lots with the potential to purchase, in three different zones, North America (EEUU and Canada), Brasil and Latam, applying ETL process, Extract, transform (Power Query) and load information in an Access Platform allowing the integration all of the information. Achievements: Through the tool development, created a Dashboard in excel that updated periodically to review the productive process and Prospectors’ performance (employees) through KPI. Using the system information update active and inactive employees (100 actives, 203 inactive), calculate salaries in COP and Euros, load personal information, and control biometrical entrance and exit. Develop a Dashboard for the Turnover of Prospectors (employees), due to the highest personal rotation in the company and its resignation reason. Show less



Neopsicología Colombia SAS

• Financial Advisor

  • Sep 2020 - Dec 2021

  Bogotá, Distrito Capital, Colombia Lead the accounting update process according to the financial supports and historical income statements: Prepare and reconstruct financial statements in World Office: Responsible of financial analysis and recommendations: Preparation of accounting taxes for the DIAN and presentation of financial statements. Achievements: Accounting update according to the historical income statements since 2017. Creation of the financial statements presentation which allowed an adequate… Show more Lead the accounting update process according to the financial supports and historical income statements: Prepare and reconstruct financial statements in World Office: Responsible of financial analysis and recommendations: Preparation of accounting taxes for the DIAN and presentation of financial statements. Achievements: Accounting update according to the historical income statements since 2017. Creation of the financial statements presentation which allowed an adequate decision-making. Show less



ERU - Empresa de Renovación y Desarrollo Urbano de Bogotá

• Colombia
• Government Administration
• 1 - 100 Employee

• Social Management Office Advisor

  • Feb 2019 - Jun 2020

  Bogotá, Distrito Capital, Colombia Develop an IT system using Access platform for the Plan Parcial San Bernardo and the Plan Parcial Voto Nacional-La Estanzuela: Design Excel Dashboard to control financial compensation settlements: Information supervision and standardization generated by the social management office. Achievements: Draft the control mechanisms for the information generated in the field (San Bernardo Neighborhood), with indicators and query formats at the headquarters on Calle 100 and the San Juan de… Show more Develop an IT system using Access platform for the Plan Parcial San Bernardo and the Plan Parcial Voto Nacional-La Estanzuela: Design Excel Dashboard to control financial compensation settlements: Information supervision and standardization generated by the social management office. Achievements: Draft the control mechanisms for the information generated in the field (San Bernardo Neighborhood), with indicators and query formats at the headquarters on Calle 100 and the San Juan de Dios Hospital in realtime. Lead the unification of data from the social management office and the property management of the Plan Parcial San Bernardo’s real-time consultation. Through the tool development, classification, control, and monitoring of the financial compensation settlements for each property and each social unit were verified and guaranteed. Show less



J&J Empresarial S.A.S

• Brazil
• Accounting

• Accounting and Financial Advisor

  • Feb 2015 - Feb 2019

  Bogotá D.C., Colombia Bank reconciliations, Cash flow preparation, Generation of periodic financial statements of the companies with improvement proposals: Budgeting and scenario modeling in Excel. Achievements: Parametrization for the accounting updated information for different clients. Lead the construction of reports and templates for the periodic and monthly delivery of financial statements to companies. Lead the construction of financial management reports for timely decision… Show more Bank reconciliations, Cash flow preparation, Generation of periodic financial statements of the companies with improvement proposals: Budgeting and scenario modeling in Excel. Achievements: Parametrization for the accounting updated information for different clients. Lead the construction of reports and templates for the periodic and monthly delivery of financial statements to companies. Lead the construction of financial management reports for timely decision making. Develop a cost information and inventory management system in Plecarton de Colombia SAS. Show less



Public Vs. Private Mental Accounts: Experimental Evidence from Savings Groups in Colombia

• Research Assistant

  • Mar 2013 - Jun 2014

  Bogotá, Distrito Capital, Colombia Organize and manage the collection of information and processing the data obtained in the field work: Generate reports with the results obtained in the study: Develop the databases in Access: Manage and execute studie’s budget. Achievements: I led the research in the departments of Bolivar, Boyaca, Choco and Cundinamarca with the established schedule and budget. I developed a capture system with the requirement to meet the quality indices of the research.



Pécora Ltda

• IT Systems Designer

  • Dec 2008 - Mar 2011

  Bogotá, Distrito Capital, Colombia Planning and developing the inventory control of spare parts and raw materials, management of quality and efficiency management indicators, customer service for non-conforming products, supplier management and development of the integrated production system: Verification of the production process in real-time through the information systematization. Achievements: Development of the integrated production system using Access platform, generating information entry points in the… Show more Planning and developing the inventory control of spare parts and raw materials, management of quality and efficiency management indicators, customer service for non-conforming products, supplier management and development of the integrated production system: Verification of the production process in real-time through the information systematization. Achievements: Development of the integrated production system using Access platform, generating information entry points in the warehouse, washing, programming, and planning in real-time. Tool designing for inventories control and management of raw material. Raw material costing module implementation. Generate a real-time information system to quantify units in the manufacturing production process. Decrease in data processing time for the preparation of payroll and production control. Salary control tool generated, with a piece-rate payment method. Show less