Juan David Carrillo Email & Phone Number

Panama

Panama City, Panamá, Panama

Supporting the development and implementation of OneStream solutions, the role involves designing, developing, deploying, testing, monitoring, and training to ensure OneStream solutions meet business requirements and streamline user experiences.

Panama City, Panamá, Panama

• Led the OneStream implementation to automate Corporate FP&A processes, designing and building OneStream's analytical cubes, writing VB .NET business rules, and creating components, such as Data Sources, Transformation Rules, Workflows, Cube Views, and Dashboards. • Integrated Power BI with OneStream, designing a dashboard that replaced over 500 Excel files distributed to various areas of the organization. Built interfaces to extract data from OneStream using a REST API. Built Power BI's relational model and DAX measures, with an innovative approach linking the properties of dashboard components such as text, color, filters, navigation links, etc., to DAX measures to make it dynamic and scalable.• Lead a team that act as a business-oriented technology partner, translating business needs into solutions to drive value creation by automating FP&A processes.

Panama

• Developed an application to capture and consolidate in real time the annual expenses budget at a corporate level with approx. 400 users in 10 countries, replacing more than 500 Excel files that were manually replicated and distributed to different areas of the organization. The implementation involved redesigning the process by integrating native Excel functions, Visual Basic programming, and designing a SQL Server database.• Led the selection process of a platform that allowed the company to automate FP&A processes and maximize the team’s contribution from a strategic standpoint.• Designed and built the corporate transfer pricing tool using Excel and Power Query.

Panama

• Standardize and optimize financial processes to deploy a financial shared services team serving Mexico, Middle Americas, and Peru.• Monitor performance indicators, highlighting trends and analyzing causes of unexpected variance.• Analyze current and past trends in key performance indicators including all areas of revenue, cost of sales, expenses, and capital expenditures.

Panama

• Build financial reports for the sale of Quala’s personal, oral, and home care business to Unilever.• Oversee the corporate annual budgeting process, developing tools that optimize the process.

Colombia

• Collaborate with the IT department to develop OPX, a platform designed to optimize client's portfolios with an optimal return-risk ratio. In addition, currency markets strategy and advisory.

Colombia

Provide support in processes such as liquidity risk management, market risk, financial compliance and credit risk that involve understanding valuation of financial assets.

Bachelor Of Science - Bs, Industrial Engineering, 4.09 / 5.00

Bachelor Of Arts - Ba, Economics, 4.09 / 5.00