Ronan Mencias Email & Phone Number

Boca Raton, Florida, United States

Florida

Delivered a Power BI Pilot migrating Oracle BI to Power BI for a Global Manufacturing Company (Toshiba International Corp.) - Conducted Landscape Assessment, identifying key improvement areas. - Managed project from inception to completion, ensuring timely delivery and stakeholder satisfaction. - Reduced Hardware and Licensing Cost by 90%. - Designed and developed Power BI solutions for Bookings, Billings and Backlog enhancing data visualization capabilities - Delivered 50+… Show more Delivered a Power BI Pilot migrating Oracle BI to Power BI for a Global Manufacturing Company (Toshiba International Corp.) - Conducted Landscape Assessment, identifying key improvement areas. - Managed project from inception to completion, ensuring timely delivery and stakeholder satisfaction. - Reduced Hardware and Licensing Cost by 90%. - Designed and developed Power BI solutions for Bookings, Billings and Backlog enhancing data visualization capabilities - Delivered 50+ metrics, including CYTD, PYTD, FYTD, and PFYTD, facilitating better business decisions. - Trained Key 50+ Business Users and IT on Power BI Self Service reporting use and methodology achieving 100% Adoption - Managed cut-over tests and hypercare, ensuring smooth transitions and minimal disruptions. Data Architect for a Global Life Sciences Company (Novartis) for their US Transparency Project (Sunshine Act) - Architected the analytics data model on Snowflake ensuring accurate Data for Sunshine Reporting to the US Government - Built multiple data integration notebooks in Databricks using Python. - Lead Managed File Integration Workstream - Lead Qlik WorkstreamBusiness Intelligence Operations Manager (Novartis) for a Global Pharmaceuticals Company - Managed a team of 10+ in Data Operations, coordinated integrations with external providers, and internal teams, resulting in improved data accuracy and compliance. - Improve the Data Integration Process for External Providers resulting in the improvement of Data Onboarding from 3-6 months to 3-4 weeks. - Successfully Managed the Migration of 20+ Managed File Transfers from IBM MFT to Axway MFT which resulted in reduced cost and reduced external coordination.Business Intelligence Business Intelligence and Data Analytics practitioner: - Delivered solutions, assessments, and roadmaps that promote a data-driven culture. - Supported business development and customer engagements. Show less

Leads Data Analytics for the Marketing DepartmentLed data-related initiatives, including insights, metrics, and reporting, driving marketing programs.Improved data asset utilization, creation, and consolidation, enriching customer information for predictive modelsBridged the gap between business strategy and IT solutions, enabling effective transformation.Collaborated with the Executive Team to leverage data assets for improved decision-making.Partnered… Show more Leads Data Analytics for the Marketing DepartmentLed data-related initiatives, including insights, metrics, and reporting, driving marketing programs.Improved data asset utilization, creation, and consolidation, enriching customer information for predictive modelsBridged the gap between business strategy and IT solutions, enabling effective transformation.Collaborated with the Executive Team to leverage data assets for improved decision-making.Partnered with IT for defect/enhancement/solutions requests, tool evaluation, requirements identification, scoping, timelines, implementation, and testing, ensuring solution design meets business needs and drives successful implementation.Served as the Business Technology Owner and Subject Matter Expert on Marketing Technology Tools, Data Metrics, Analytics, and Customer Data.Recognized for Innovation, Analytics, Customer Service and ProactivenessDelivered: - Marketing Datamart, enhancing data management capabilities. - Customer Segmentation, improving targeting and personalization. - Used MS Power BI to deliver the following: * Campaign Performance Dashboard/Reports improving campaign performance comparisons for different time periods * Customer Life Cycle Dashboards/Reports, providing insights into customer journeys * Executive Marketing Dashboard/Reports, aiding strategic decision-making. - Enriched customer data through data appends from outside sources, improving data accuracy - Analyzed customer behavior, campaign performance, and sales, informing marketing strategies. - Delivered Sales and Marketing metrics and KPIs, including Sales, Average Order Value, Sales/Buyer, Gross Profit, Gross Margin, Units/Customer, Response%, ReOrder%, Cost per Click, Cost per Unit, Emails Opened, Emails Clicked, Customer Lifetime Value, Cost of Goods sold, etc., enhancing performance tracking.Evaluated predictive model performance, ensuring accuracy and effectiveness. Show less

• Gathered requirements, analyzed, designed, developed, and delivered projects/enhancements/fixes for MS Power BI, SSRS, and SSAS Tabular• Coordinated with business partners to align team initiatives with the highest priority, ensuring strategic alignment.• Analyzed, designed, and delivered datamarts, enhancing data management and reporting capabilities.• Implemented policies and procedures, ensuring the stability of data-related initiatives.• Gathered requirements, performed… Show more • Gathered requirements, analyzed, designed, developed, and delivered projects/enhancements/fixes for MS Power BI, SSRS, and SSAS Tabular• Coordinated with business partners to align team initiatives with the highest priority, ensuring strategic alignment.• Analyzed, designed, and delivered datamarts, enhancing data management and reporting capabilities.• Implemented policies and procedures, ensuring the stability of data-related initiatives.• Gathered requirements, performed analysis, designed, developed, and managed BI projects, driving business intelligence improvements.• Developed datamarts, reports and dashboards, providing actionable insights.• Managed team allocation, assignments, and goals, optimizing resource utilization.• Provided a framework for testing Campaign Audience selection which improved data accuracy Show less

Fort Lauderdale

Managed a Team of BI Professionals responsible for:• Delivery of reporting projects/enhancements/fixes for Tableau, SSRS, MSBI, Hyperion BI and OBIEE• Support for Enterprises environments for Tableau, SSRS, OBIEE• Managed Team allocation, assignments and goals• Coordinates with Business Partners to align Team to the initiatives with the highest priorityImplemented Policies and Procedures that ensures stability of the below supported Enterprise Business Intelligence… Show more Managed a Team of BI Professionals responsible for:• Delivery of reporting projects/enhancements/fixes for Tableau, SSRS, MSBI, Hyperion BI and OBIEE• Support for Enterprises environments for Tableau, SSRS, OBIEE• Managed Team allocation, assignments and goals• Coordinates with Business Partners to align Team to the initiatives with the highest priorityImplemented Policies and Procedures that ensures stability of the below supported Enterprise Business Intelligence Applications: Tableau, SSRS, OBIEEDelivered an Enhanced Self-Service Reporting Framework that balanced business delivered reports/dashboards with Governance. • Defined, Identified, Customized Roles and Responsibilities • Built a strong partnership between Sales Operations, IT, BI Governance and Oversight• Delivered and Facilitated Discovery and Roles and Responsibilities Workshops• Chaired and Hosted/Facilitated Monthly Tableau Change Review Board Meeting Show less

Miami/Fort Lauderdale Area

Managed a Team of BI Professionals responsible for Delivery of Projects, Enhancements Fixes and System Stability on Oracle BI Enterprise Environments:• Delivered Performance Dashboards for Executive Management’s use during quarterly Executive Leadership meetings.• Delivered Executive Marketing Dashboards that measures Effectiveness of Marketing Programs• Delivered Marketing Product Download Dashboards that measures the download activity of Citrix Products• Delivered monthly… Show more Managed a Team of BI Professionals responsible for Delivery of Projects, Enhancements Fixes and System Stability on Oracle BI Enterprise Environments:• Delivered Performance Dashboards for Executive Management’s use during quarterly Executive Leadership meetings.• Delivered Executive Marketing Dashboards that measures Effectiveness of Marketing Programs• Delivered Marketing Product Download Dashboards that measures the download activity of Citrix Products• Delivered monthly projects/enhancements to the OBIEE Services DW, Reports and Dashboards including ability to measure effectiveness of the Services Organization through the capture and calculation of NPS from GEO to individuals, Call Metrics and Case Metrics.Upgraded Technical Environment and OBIEE from Version 10 (10.1.3.3.1) to OBIEE 11g (11.1.1.1.4) Show less

• Delivered a complete BI Solution to the Services Organization through the implementation of Siebel Analytics• Delivered DW, ETLs, Reports, Dashboards to support Analytical and Operational Reporting to the Services Organization (Call Metrics (Avaya), Case Metrics)• Delivered Monthly Project, Enhancements and Fixes• Provided a Self-Service tool to the Services Organization via OBIEE Answers• Abstracted a complex DW through the implementation and customization of the OBIEE… Show more • Delivered a complete BI Solution to the Services Organization through the implementation of Siebel Analytics• Delivered DW, ETLs, Reports, Dashboards to support Analytical and Operational Reporting to the Services Organization (Call Metrics (Avaya), Case Metrics)• Delivered Monthly Project, Enhancements and Fixes• Provided a Self-Service tool to the Services Organization via OBIEE Answers• Abstracted a complex DW through the implementation and customization of the OBIEE Meta-Layer Show less

IT Consulting, Project Management, Siebel CRM Impementation, Siebel Analytics Implementation, OBIEE Implementation, Custom Application Development