Omar Valadez Lopez Email & Phone Number

Miami, Florida

RESPONSIBILITIESSenior Data & Analytics architect and mentor of the development team.Responsible and Administrator for the Analytics platforms (Tableau, Snowflake AWS, Alteryx, SAP BOE, etc.) with administrator role, enterprise strategy and innovation implementation.Visualization solutions for NCLH (3 cruise lines): I developed the most complex and impact dashboards and reports.I leaded the Analytics Cloud implementation, creating data & analytics solutions near to real time. As data & analytics architect I implemented a cloud model with high data volume, providing high performance improvement (from 72 hours processing time in the old model to provide more functionality a few minutes with a new Cloud enhanced solution). Defining enterprise analytics governance, server settings, front end strategy and visualization guidelines, security roles, OKTA, etc.As a Data & Analytics Architect I stabilized the Tableau's platform recovered it from a critical state. I integrated data & analytics tools in a complex ecosystem focused in high productivity, cost reduction and creating user’s confidence until get a successful data driven organization.We delivered of advanced analytics solutions with predictive implementation of the most important strategic, financial and operational KPIs. My dashboards had been key in the consolidation of the BI department at the top levels of the organization. My job made impact with a transformation of the most relevant department.TOOLSCloud & On-Premise: Snowflake, AWS, Oracle, Microsoft, Data Factory, Azure, Python, SQL Server, PostgreSQL, Databricks, Delta Lake, Lakehouse. Tableau and Alteryx: Administrator, enterprise strategy, platform performance, Sr developer, predictive analytics with R. DBT.SAP: HANA, Business Objects administrator and developer, platform performance, storytelling dashboards with predictive analysis and real-time visualizations, Web Intelligence, Explorer, SAP HANA, S/4 HANA, SAP MDM. Prefect, SAFe, Funnel.

RESPONSIBILITIES Principal data & analytics architect, most important financial project BW on HANA for Coca Cola Latin America. I designed BW on HANA model and led a development team of one of the largest (in volume of data) HANA implementations worldwide.I designed and developed financial dashboards, led solutions for many countries. SAP awarded me for HANA performance accomplished.ACCOMPLISHMENTS My job performance has been awarded and project certified by SAP as the best design & performance using BW on HANA: 11 billion of records.TOOLSSAP HANA. SAP Business Objects, Tableau, Qlik, Power BI. SAP BW on HANA: Design complex model with KPI in real time and tuning BW for optimal performance of BOE results.

Principal Architect Data & Analytics for Latin AmericaResponsible of front and back end for 13 countries in Latin America.I designed and developed storytelling dashboards with ROI action item.D&A Quality manager for Latin America (BW & BO), led large implementations. Data & Analytics architect manager of project leaders.BOE implementation platform and administration, performance improvement and sizing, direct contact with vendors.Global architect for D&A commercial solution in multiple continents.Built governance: best practices, methodology, QA, process improvement.Administrator of D&A platforms and Databases (Oracle & SQL Server).SAP Integrator, SQL Server, Oracle, legacy systems and other data sources.Project Leader and mentor for developers and outsourcing management.Creation and implementation of storytelling dashboard methodology.Led Front End developments of over 300 dashboard and reports.Developer senior of the most complex and important reports/dashboards.Back End - Implementing analytical complex models with global settings.Enabling and enhancements BI extractors modules: HCM, FI, COMMERCIALProject management of global teams: Sustain, BASIS, Security and portal.TOOLSDashboards, SAP BW, BEx, Tableau, QlikView, QlikSense, BOE, WebIntelligence, Explorer, Design Studio, BPS, Netweaver, PI.

Responsibilities• Implementation of SAP Netweaver Business Intelligence (SAP BI) integration FI/CO, Management of Materials (MM), Sales and Distribution (SD), Human Capital Management (HCM).• Interaction with the client.• Analysis of the requirements of the user.• Construction and validation of the operation of querys and reports of the company.• Development, maintenance and improvements of the reports, process chains, cubes.• Integral test of the cubes of modules FI/CO, SD, MM, AP, AR, IC, PP, IM.• Configuration of the extractors and enhancements for modules FI/CO, SD, MM, HCM, PUR, IM.• Activation of Business Content and adjustments.• Implementation and configuration of SAP BW.Skills UsedSAP BW (BEx Query Designer, BEx Analyzer, Web Application Designer), SEM, Enterprise Portals (EP), Netweaver, Xcelsius, WebIntelligence, XI, BPS.

Responsibilities •Person in charge (Servers, Databases, Web Application Server). •Consultant of optimization of business processes and administration of DWH. •Infrastructure, datawarehouse modeling and design•Responsible for the platform of Intel-Microsoft applications (servers, database, Components, Telecommunications, Management team of developers, implementation methodology) •Construction and management of corporate portals, ASP,. NET, Java, SOA, Netweaver. Net connector, XI •Implementation and configuration of SAP BW, CO, FI, MM, HR, ABAP•Oracle DBA SQL Server •Portal Certification “Security of the information”. •Managing the development team following methodology, introducing changes and version control, restoration in case of contingency, development-oriented services and customer satisfaction •Development of applications for mobile devices through Datawarehouse and OLAP •Manager of infrastructure with high availability, development of applications of mission critiques, leader of simultaneous projects, consultant of process optimization of business and person in charge of the applications of mission criticizes in SQLServer. Accomplishments •Manager DataWareHouse to stabilize a crisis of lost services. •Reconstruction of DataWareHouse to overcome problems of space in disc. •Recovery of platform in a crisis (Server, Databases and Web Application Server), •Implementation of SAP BI Skills Used Databases: DBA Oracle, SQLServer Operative Systems: Windows Server, Unix Programming Languages: SAP R/3 (FI/CO, SD, MM, HR, SRM y PP), SAP BW (BEx Query Designer, BEx Analyzer, Web Application Designer), SEM, Enterprise Portals (EP), BPS, SOA, WebServices, XI. Visual Studio, .Net, ASP Oracle (WarehouseBuilder, OBIEE, ODI, Essbase), Cognos, SQL Server (Analisys Services) Methodologies:UML, PMI Networks:WAN, Intranet, 3G

Bachelor Of Science - Bs, Computer Science

Bachelor Of Science - Bs, Electrical, Electronics And Communications Engineering