Luciana Piña Gutiérrez

Strategic EPM & OneStream Leadership

• OneStream Transformation: Spearheaded the end-to-end implementation and migration of OneStream (v7.4.2 to v9.2), architecting the system for consolidation and profitability,, metadata management, developing advanced creation of Business Rules (VB.Net), Cube Views, and dynamic Dashboards to enhance executive decision-making and complex financial reporting.
• Oracle EPM Architecture: Directed the configuration and deployment of Oracle EPM Suite (HFM, HPCM, and Planning v11.x), optimizing dimensions, business rules, and custom MaxL Calc scripts to enhance system performance.
• Financial Planning & Analysis (FP&A): Engineered advanced FP&A solutions incorporating leading practices for P&L, Balance Sheet, and Cash Flow forecasting, driver-based planning, and rolling forecasts.

System Engineering & Operational Excellence

• BI & Data Visualization: Developed high-impact executive dashboards and KPI tracking models using Power BI, Tableau, and SAP Business Intelligence, connecting disparate sources for real-time visibility.
• ETL & Data Integrity: Orchestrated complex data integration and conversion activities using Oracle Data Integrator (ODI), ensuring seamless data flow between SAP ERP and EPM environments.
• Governance & Documentation: Authored comprehensive project deliverables, including technical design documents (TDD), requirement specifications, test protocols, and administrative guides for end-user training.

Technical Ecosystem:

• EPM/CPM: OneStream, Oracle HFM, HPCM, Hyperion Planning, Essbase.
• Analytics: Power BI, Tableau, SAP BI, Oracle BI, SmartView.
• Data/ETL: SQL Server, Oracle DB, ODI (Oracle Data Integrator).
• Programming: .NET (Visual Studio), MaxL, Calc Scripts.

Lead Software Developer | Big Bola 2010 – 2014

• Software Project Management: Led the end-to-end development lifecycle for critical business systems, including Inventory Management and POS Restaurant Ordering modules.
• Product Innovation: Spearheaded the design and implementation of Bingo Express, a pioneering electronic gaming solution that modernized the casino’s digital offerings.
• ERP Integration: Managed the customization and maintenance of the Kepler ERP system to streamline financial and operational workflows.
• Full-Stack Development: Developed scalable applications using Visual Studio .NET, ensuring high availability for real-time gaming and hospitality environments.
• Data Architecture & Analytics: Optimized database performance across SQL Server and MySQL; delivered automated operational insights via Crystal Reports.

Senior Developer | RR Donnelley

• System Development: Engineered and optimized enterprise software solutions using .NET and Java to manage core business functions including Invoicing, Production, and Inventory.
• ERP Integration: Developed and maintained critical interfaces between custom software and JD Edwards (JDE), ensuring data integrity and seamless cross-platform communication.
• Business Intelligence: Designed and deployed complex operational reports using Crystal Reports, providing stakeholders with actionable insights into production and stock levels.
• Database Management: Architected and managed relational database schemas in Oracle and SQL Server, focusing on query performance and high-volume transaction processing.
• Lifecycle Management: Utilized Visual Studio .NET for the full software development life cycle (SDLC), from requirements gathering to system deployment.

Software Developer | IS1

• Developed and maintained enterprise-level applications using .NET and UNIX shell scripting to automate backend processes.
• Managed and optimized relational databases across Oracle, MySQL, SQL Server (Microsoft), and Progress environments.
• Designed and deployed complex business reports using Crystal Reports and managed ETL workflows with Ascential DataStage.
• Provided technical development and support for MFG/PRO ERP systems.