Marisol Lopez Email & Phone Number

Orlando, Fl, Us

Cheyenne, Wyoming, Us

OneStream - Financial Close & Reporting PracticeRCM - Account Reconciliations

Miami, Florida, Us

Directed the company's Oracle Hyperion EPM/OBIEE platform development, ensuring production environment stability and SOX compliance of the financial planning applications and reports. Led a team of architects, developers, analysts, and consultants providing the delivery and continuous improvement of multiple applications including user support in 30 countries. As product manager / product owner of EPM/OBIEE product suite, defined product strategy, roadmaps, architectural design overview and prioritize team’s work and resource allocation in alignment with stakeholders’ requirements and priorities. Translated customer needs into user stories and criteria, grooming the product backlog and prioritized stories based on criticality, goals and roadmap. Contributed with reports, dashboards and application development, design and architecture recommendations, quality assurance and testing of all of our projects. Key Contributions: • Operational development and support to 35 Hyperion Planning applications for budgeting, forecasting, long range plan LRP, cash flow and OpEx/CapEx tracking with 100% SOX ITGC compliance. • End-to-end delivery and performance optimization of a self-service Hyperion Essbase application for data analysis, allowing users to get secured financial data using Tableau, OBIEE, Power BI and Hyperion Financial Reporting. • UI / UX continuous improvement of Sales dashboards for a mobile friendly customer experience, integrating data from the Oracle EPM suite and the enterprise data warehouse (Snowflake). • Oracle Cloud EPM vs OneStream software upgrade/migration detailed technical and gap analysis and vendor selection. • Executed several IT strategic initiatives as part of a 2-year $100M corporate efficiency project, providing weekly SLA reporting to the CFO and CIO regarding project health, issues, and risk management.

Miami, Florida, Us

As Reporting Lead and EPM Subject Matter Expert SME, provided functional and technical expertise during a 3-year multi-million-dollar company wide project covering: Hyperion software upgrade, financial planning business process improvements and system implementation. - Developed a global reporting solution using OBIEE dashboards, Hyperion Financial Reporting and Excel Smart View reports integrating operational, sales, academics, HR, and financial data sources. - Delivered report analysis, design, development, maintenance, performance optimization, automatic distribution setup, user support and training. - Ensured data integrity in the financial reporting application performing data quality checks and data cleansing efforts as needed. - Collaborated with business partners from FP&A, Investor Relationships, Tax, Treasury, Sales and Procurement departments, leading requirements analysis, UAT, workshops and training sessions.

Miami, Florida, Us

Architected and developed a reporting solution for executive leadership and regional managers to monitor and benchmark the operational performance of 4 Shared Services Centers in Latin America and Europe providing Finance and HR functions to 10 countries: - Defined, implemented, and monitored over 30 metrics measuring the efficiency of the Procure to Pay P2P and Record to Report R2R processes, enabling the Shared Services Centers to implement a KPI - driven service management model with guaranteed Service Level Agreement SLA compliance - Used SQL to transform, cleanse, and prepare Procurement, Accounts Payable AP and Travel & Expenses T&E Peoplesoft’s data for consolidation and reporting using Essbase, Financial Reporting, and led the rollout of 6 multi-language QlikView dashboards. - Generated monthly management reports with summarized and detailed data identifying areas of opportunity and trend analysis to support recommendations for action to optimize business processes and increase customer satisfaction.

Miami, Florida, Us

Collaborated with Corporate Finance, Accounting, Human Resources HR and IT departments on several initiatives to improve data quality of global decentralized HRIS and financial systems in preparation for the company’s IPO: - Supported the data cleansing strategy of multiple general ledgers developing uniform definitions and best practices. - Designed and developed a solution for data reconciliation and reporting using MS Access database, an Essbase cube a set of Hyperion Financial Reporting / Smart view reports which provided fast and reliable complex data validations of multiple charts of accounts. - Built multiple application and reporting prototypes to support complex data analyses and identify accuracy gaps of Corporate’s consolidated data - Improved the mapping and data validation efficiency of a worldwide global PeopleSoft ERP implementation and data conversion of 270 Business Units in 32 countries over 4 years.

Barcelona, Barcelona, Es

Developer / Project manager delivering technical solutions for pharmaceutical, beverage, food, retail, higher education, entertainment, and manufacturing industries in 5 countries using Oracle Hyperion EPM products: - Documented business requirements, current - future state processes and fit-gap analyses for the implementation and improvement of inventory, sales, and financial multi-currency Hyperion Planning applications. - Developed cost allocations business rules, web forms and reports used for budgeting, forecasting, 5-year long range plan (LRP), cash flow, operational and capital expenditure tracking. - Designed and developed highly formatted reports and dashboards using Financial Reporting and Web Analysis. - Collaborated with cross-functional teams communicating complex technical information, adjusting the language to meet the needs of different clients during user training and making sure their needs were clearly understood and documented. - Developed project plans, monitored progress and provided regular updates to stakeholders. - Led UAT sessions, provided end user training, 24x7 technical support and troubleshooting.

Atlanta, Ga, Us

Delivered a set of highly formatted Hyperion Financial Reports for sales and profitability analysis of Oxxo's 20,000+ convenience stores. Reports were fully optimized to manage a large volume of data and complex calculations with minimal performance impact.

Ciudad De Mexico, Distrito Federal, Mx

Delivered a set of highly formatted Hyperion Financial Reports to measure profitability by product lines. Reports were fully optimized to manage a large volume of data and complex calculations with minimal performance impact.

New York, New York, Us

Delivered in under 4 months their first ever set of financial dashboards for the CentAm regional CFO, with key performance indicators KPIs to measure the profitability and sales performance of the Central America countries using Web Analysis. Responsible for project management, analysis, design, implementation and user training.

Bs, Computer Software Engineering

Msc, Computer Science