Eduardo Chavez Email & Phone Number

Sunnyvale, Ca, Us

- BI and Data Architecture Design - Azure Data Factory - Airflow - Databricks - PySpark - Creating infrastructure for Machine Learning, NLP, LLM and GenAI projects- Advanced SQL- Data Modeling- Working with multiple data sources including Blob Storage, ADLS-gen2, RestAPI, Hadoop, Spark, etc.

Mountain View, Ca, Us

• Performed Data architecture of financial data structures derived from General Ledgers and Subledgers (expenses, allocations, revenue, actuals, forecast, budget).• SAP S/4 HANA tables and business processes analysis.• SQL for data analysis, design, testing and prototyping.• Use of Google Cloud Platform (GCP), BigQuery, Cloud Composer for pipeline execution analysis, Dataflow for monitoring ETL.• Analysis of ETL written in Python code.• Conversion of Oracle ERP data marts into SAP Business Warehouse.• Analysis of legacy Oracle Analytics Cloud reports and dashboards.• Meeting with stakeholders to gather requirements, negotiate new projects and establish agreements.• Using GCP tools analyzed and converted SAP transactional data into Data Lake (Google Cloud Storage) and Data Warehouse (BigQuery) for Finance Corporate data.• Extensive SQL development to create views and testing data pipelines.• Looker for Semantic Layer development and Data Studio for Data Visualization.• ETL/ELT Development.• Using HTML, CSS, JS and D3.js created visualization demos to present organization documentation.• Data Recon between major databases for SOX compliance, automated testing and traceability.• Extensive analysis, documentation and design of Concur expenses data marts, travel data, internal events, operational expenses, etc.

Mountain View, Ca, Us

- Analysis of hardware and health monitoring over Google Gemini Super Clusters.- Performed Data Analysis of various data sources including Log files with millions of Petabytes as well as Databases- Created ETL Pipelines using Python and SQL- BigQuery and other GCP Databases- Orchestration of workflows using GCP Airflow and other GCP tools.- Analytics of Hardware Quality.- Creation of Dashboards using GCP Data Studio.- Unnesting multilayer JSON entries from logs, databases and RestAPI using recursiveness and other techniques. - Met with multidisciplinary stakeholder groups and communicated insights and results. Including Directors, VPs, Hardware engineers, Quality engineers, etc.- Angular.JS to prototype custom ad-hoc dashboard interfaces.

Minneapolis And St. Paul, Minnesota, Us

• Drove the improvements and innovations in the Enterprise Data and Analytics team through the SAFe Agile framework.• Developed a rapid prototyping strategy to deliver enterprise reports and streamline the creation of the Data Warehouse.• Planned and designed a short- and long-term technology road map to advance the Data Analytics Platform.• Delivered Executive Dashboards to top management and Payroll Accounting, Space Analysis, HR Analytics and Expenses Management data marts to main business customers.• Lead the upgrade of OBIEE 12c to Oracle Analytics Server (OAS) and POC of Oracle Analytics Cloud (OAC).• Performed the administration of Business Intelligence and Analytics servers such OBIEE, OAS, Tableau, Looker, Qlik, and Apache Spark. Among the tasks were, installation, cluster configuration, hardware selection and upgrading.• Built multiple enterprise-wide data pipelines using Informatica, Rest API, SQL, and Python.• Served as the Subject Matter Expert for Business Intelligence at the University, creating and maintaining enterprise OBIEE development standards.• Lead cross departmental (OHR, ASR, Finance) OBIEE developer group, including meeting leadership and feature release coordination.• Trained architectural and coding standards to team members to ensure cross-functional skills in the organization.• Pioneered the implementation of Advanced Analytics such Machine Learning and Data Mining techniques to explore patterns and create statistical models (Stack Classifier to predict employee resignation) using Python and libraries such Tensorflow, ScikitLearn, R and Microsoft PowerBI.• Prototyped a tool agnostic semantic layer using Django and Rest API.• Implemented Performance tuning and cache management of databases such Oracle and SQL Server.• Developed a monitoring strategy using Autosys, Splunk and Shell Scripting.• Responsible of the creation of an Enterprise Data Dictionary merging metadata from IDERA ER Studio and OBIEE RPD.

Minneapolis And St. Paul, Minnesota, Us

• Working with business partners I developed dimensional models for critical OLAP business needs.• Built data pipelines using ETL technologies such Informatica, SQL Server Integration Services, PL/SQL and Python.• Implemented Data Warehouse solutions for all enterprise systems, HR Analytics, Student Enrollment, Financial Data, and Research.• Lead the full administration of OBIEE environments, installation, troubleshooting, upgrading and configuration. • Developed OBIEE RPD code, primarily consisting of Business Intelligence content (star schemas, facts/dimensions).• Guided product teams through complex scenarios and problem resolution using SCRUM Agile methodology.• Gathered business requirements and prepared data lineage documentation.• Enhanced reports and dashboards with Data Visualization technology such as Tableau, D3.js, jQuery, JavaScript, and R.• Pioneered automation of our on-premise servers developing Shell Scripting for Automation of Server Tasks and REST Java for Metadata and File processing.

Austin, Texas, Us

• Business Intelligence (OBIEE) development, reporting, integration, solutions implementation, administration and monitoring• Data Warehousing under OBIEE Analytics (RPD Development) working mainly with Dimensional Modeling (OLAP Systems) as well as transforming data from Relational Model (OLTP Systems)• ETL / ELT developer in ODI and Informatica Power Center with DAC• PL/SQL Datafixes and procedures• Implementing Data Visualization techniques with D3.js libraries• Java and Python REST API creation to expose OBIEE SOAP web services• Led the designing, building, testing and implemention of web and mobile applications that need to scale to thousands of users, have rich user interfaces, integrate with Oracle applications, and have rich reporting capabilities, between web based applications to mobile development• Using several technologies, operative systems, development environments, programming languages and methodologies on a variety of projects for Oracle Top Executive departments and other areas related with Business Intelligence, SCM and ERP using Oracle APEX Framework

Dublin 2, Ie

• Data management• Data Mining• Designing and implementing the analysis that will identify all requirements related with people, processes and technology• Maintaining, adjusting and fixing applications, doing some preventive maintenance activities and giving assistance to the end user

Monterrey, Nuevo Leon, Mx

• Responsible for the company operative infrastructure that handles about 30 devices between WebServer, Database Servers and SMS Communication Gateway.• MySQL Databases and PHP Systems problem analysis and detection.• Administration of operative applications made by the company• Advanced Operative Systems Administration• Networks Support• Operation Support and Solution Designing.• Responsible of the office infrastructure: Networks, Telephony, Computer Equipment.

Mx

• Monitoring of SQL SERVER 2008 databases, regarding the fragmentation, logs and database files growth, automated jobs accomplishment, fulfillment of security and rules, memory, cpu, and storage usage as well as query performance.• Providing the policies that concerned permissions and authentications in order to use databases.• I coordinated the activities related to maintenance of the database such as defragmentation and table indexing.• I was in charge of the Backup planning and Restore operations and created activities to automate processes. • Gave technical support to each server set on the seven centers across the state. Systems in charge of the digitalization of signals, content match modules and storage systems, based on Linux Gentoo, Windows Server and IBM (Xendata).

Guadalajara, Jalisco, Mx

I helped to conclude the implementation stage of the SDLC Lifecycle with testing and bug reporting of a system created by an external company called Emergys of Mexico based on Websphere of IBM.I administrated a server with Windows Server 2003 and I configured a Lotus Domino platform.I monitored, modified and backed up the database in DB2, as well as troubleshooting and errors definition.Using SQL language to perform certain queries the project manager needed.

Cd. De México, Distrito Federal, Mx

I created an information system that processes technical support orders for all the employees of the south of Sinaloa state (PHP, MySQL, AJAX, Flash, XML, CSS).SQL Server Database Administrator.I participated in all the stages of the software development lifecycle gathering information from the analysis of all the branches, inventories and user data, to its programming (incremental lifecycle, relational modeling).Database optimization for MySQL such as queries tuning, indexes selection and keys definition.

Master Of Science - Ms, Business Analytics

Data Mining And Data Visualization Training, Visualizing And Manipulating Data With R, Working With Data Mining And Network Analysis

Master Of Business Administration (Mba), Business Administration And Management, General

M.S, Information Technology Management

Certification, Advanced Project Management

Bs, Information Systems