Lina Hernández Email and Phone Number

- Coordinated finance and IT teams with diverse skillsets and distributed geographically* across multiple financial solutions' implementations- Coordinated the automation and integration of financial data collection and consolidation of 25 entities with different ERP or profitability systems- Maintained a clear direction and completed stage goals of the solution in a flat structure under management changes and M&A- Leading the implementation & in-house development of the solution under continuous challenges such as business restructuring, budget and technology constraints- Transformed & created new regional reporting business processes, also improved the regional markets' reporting processes and data quality of their sources of information - Carried out data cleansing and data analysis, set the direction for the future development of the tool- User advocate & user experience analyst from Financial planning and analysis, Finance business partners, Insights, Supply chain planning and Marketing & strategy teams- Bug analysis and collaboration with IT on test plans in Azure DevOps, completed the solution automation and connectivity milestones*Comprising Czech Republic, Slovakia, Germany, Austria, Italy, Netherlands, Poland, Hungary, Romania, EMEA&A, UK&I and Asia.

Financial Reporting - Coordinator and support in consolidation and financial reporting of the regional hub to the parent company and external auditing - Commercial analysis: consolidation and profitability reporting of group's sold volumes- Inter-company custodian and arbitrate- Support in ad-hoc financial and volumes analysis to other business areas- Reconciliation of regional financial data sources SAP-BW and HFM- Set up regional reporting submission processes via Microsoft SharePoint- Active role in data analysis and data interpretation- Active role in process simplification & troubleshootingBusiness Administration Support of Oracle HFM & in-house Profitability Tool solution- Gathering, reconciling, reporting and maintaining financial data in HFM- Business technical admin support and custodian of HFM- Created and delivered technical and training support to HFM business users- Business requirements gathering & implementation of a Profitability Tool solution- Connected data dashboards with Microsoft Power BI

- Business Intelligence Glossary project – designed and rolled out a JIRA project and workflow for contribution to the global enterprise business glossary- Liaising with sales, finance and technical stakeholders – monitoring business requirements and ensuring correct implementation in QlikView dashboards and reports- Improved incident investigation and diagnostic workflow on a ‘follow the sun’ approach, teams located in the US, APAC and EMEA- QlikView Management Console and report monitoring - 1st level support - dashboard performance monitoring – 1st level user experience troubleshooting and testing - user account administration

- Transitioning of applications' support from Frankfurt and London to the Shared Service Center in Prague- Leadership and project management support with stakeholders and IT teams located in London, Frankfurt, New York, Singapore, and Prague- Successful knowledge capture from support experts – documenting in Confluence and providing knowledge transfer among the Prague Front Office team - Improved investigation and diagnostic skills – improving and monitoring application user experience, following the ITIL guidelines- Use of Bloomberg and BBG TOMS functionality to support traders and sales users - Excelling at providing first and second-tier functional and technical support on trading platforms to traders, sales, operations, and finance teams.

- Consolidation of monthly financial packs from subsidiaries (T.V stations).- Data validation against company’s data warehouse - actuals and forecasting- Net Investment in Programming and Amortization reporting- Automating and standardizing management reports- Support finance team in integrating OLAP reporting tools with Hyperion Financial Management (HFM) and Anaplan

- Daily sales reporting and sales analysis- Management and analysis of stock levels according to best-seller reports- Competition and benchmark monitoring via internet and media research- Nurturing customer relationships and organizing local in-store promotion events- Retail training standardization across stores

- Application customer support- Customer advocate- User experience testing- Account setup and support

- Financial Statement Analysis- Business planning and market analysis- Macroeconomic and bench-marking analysis, and regulatory research of the energy sector in Latin America

- Business Planning documentation of non-profit organizations- Fundraising market research locally and in Latin America- Management of fundraising and collaborative partnerships- Financial statement analysis