Cesar Valenzuela Email & Phone Number

Mountain View, California, Us

San Francisco, Ca, Us

• Created data products and/or solutions to improve data delivery, quality, and development productivity for data analysts, product analysts, data scientists, and engineering. Worked closely with the customer and engineering team to define, create/fund prototypes/proposals, and deliver features within a set timeline. • Managed the evolution of the following products: Data Watermark Service (DWS) coordinated ETL through various scheduling tools (in-house, Fivetrans, Airflow) resulting in zero data issues due to running when source data is not ready to be consumed; SqAirflow - customized Airflow integrated with DWS increasing orchestration implementation and data delivery; SquareWave - low code ETL orchestration which allowed users to productionalize ETLs within 25% of the prior methodology; MetricWatcher - allow users to write SQL and configure data quality checks based on trend deviations; Eventstream2 - allow users to create events in applications which flows directly into specific log tables. Proposed and managed the integration of vendor tools: Anomalo - leveraging machine learning and low code to improve data quality to detect data issues due to changing usage patterns or business focus; and SelectStar - data lineage solution to understand the complexity of data production in a decentralized environment.

San Francisco, Ca, Us

• Developed, refined, and optimized the delivery payments analytics (Pentagon), subscriptions analytics, feeds, eventstream, product data sets, and Snowflake cost/usage chargebacks.Created the infrastructure, processes, tools, and applications to improve data delivery, data quality, and operations within the data development community. Improved data reliability and quality through use of a rudimentary data watermarking service that delivered data consistently by 9AM (from an inconsistent 36 hours). Eliminated data quality issues due to running ETLs before data was ready to be consumed for the Square data community. Introduced and implemented Airflow with modifications to run when data was ready to improve the delivery times of data. • Provided training, migration guidelines, and managed migration. Managed the migration from Hive to Vertica, and in house scheduling to Airflow (SqAirflow). Managed the decentralized data community migration (100+ teams and 1500+ users) of ETL and data from Vertica to Snowflake, and eventstream (logging to one topic) to eventstream2 (logging to multiple topics). • Created a data migration strategy for a highly coupled data warehouse (decentralized data teams were free to create their own tables from other teams) that allowed users to migrate code and data independent of upstream and downstream dependencies.

Sunnyvale, Ca, Us

• DWH Roadmap, Team, and End User Projects – Worked with engineering, product managers, and decision sciences to define the projects and timelines needed for their specific areas. Managed and lead a team from four to thirteen engineers and contractors for the following analytical projects: Keynote Analytics (site speed), Ad Sales (Double Click), marketing email campaign, Verisign (Finance reconciliation), OMS (order management system), LinkedIn Research Network analysis, waterfall reports (Business and engagement), commissions reporting, UTC conversion, Marketo reporting (email reporting), Hourly page Track (real time tracking), AppWorx upgrades, Direct Ads (internal Ad serving platform), and Sunset gap analysis of sandbox reporting (Old reporting to new DW).• Operations, Maintenance, and Enhancements – Manage on-call and escalations. Responsible for the executive report and intraday reporting delivery as well as assuring data quality for all subject areas. Continuously improved SLA data delivery from 12 pm down to 4 am. Successful scaled up the operations team to handle day to day operations. Migrated and re-located Teradata systems.• Platform and Infrastructure – Designed the architecture to scale through the design of a common set of libraries and components to extract data from external systems, loading and transforming data in the DWH platform through running SQL, Bteq, and hadoop. Managed a team to migrate the server platform from solaris to linux. (AppWorx, Informatica, hadoop, SQL, 3rd party interfaces, MicroStrategy). Evolved system from database sandbox to Teradata platform.

Sunnyvale, Ca, Us

• First Gen Data Warehouse – Created properly designed Oracle data warehouse with single source of truth for engagement and business metrics. Increased data quality through coordination of data production. Designed, created, and implemented dimension, facts, aggregates from new user requirements and existing solutions that were implemented in scratch tables and excel macros.•Oracle Financials Data Solutions – Source Analysis of Internal application, Determine Business Rules, Designed Architecture for SOX isolation, validation, and Implementation.• ETL platform, tools and scheduling Foundation – Implemented AppWorx, performed tool evaluation, installed system and software, migrated from KETL. Result: Data availability and data quality increased due running jobs in the correct sequence and only when data was created in prior steps. Prior to this, jobs were assumed to be finished at a particular time.• Provided technical product management – determined requirements, approach, and scope with project teams and stakeholders• DWH data center migration. Managed a cross functional team from operations, system operation, and Data Services to migrate the Data Services platform.• Teradata migration. Managed the technical team to migrate all ETL over 500 scripts, 20 servers, 1000 tables, and 1000 users. Created technical migration strategy. Trained engineering to adopt new technology.

San Jose, Ca, Us

Architect innovative solutions that meet the eBay Marketplace Information Management and Delivery needs with respect to functionality, performance, scalability, and reliability, realistic implementation schedules and adherence to architectural goals and principles. • As Joint Application Design lead - ensures technical designs are evaluated to consensus and approval as a core member of eBay’s cross-functional architecture design group. • Designs Data Warehouse solutions for specific use cases that provide frameworks, interfaces and services that can be extended and reused for future requirements. • Mentors Information Management and Delivery development team members on architecture topics (e.g., Ab Initio, Scheduling, shopping.com.).

San Jose, Ca, Us

Responsible for project delivery, data quality, system uptime, service level agreement delivery, and team development.• Managed and developed a team for Analytical Data Mart Development and Delivery• Managed the migration of the Oracle data marts to TeradataData Warehouse Architecture and Infrastructure• Continuously improving the system to ensure accurate, reliable, scalable, and maintainable systems. Redefined the development process. Lead the adoption for a common definition for data flow, process flow, PDLC. Lead the adoption of the standards and guidelines• Implemented best practices for software development to increase productivity and data quality though tool adoption of ClearCase and ClearQuest. • Lead the adoption of AppWorx and restartability architecture for scheduling to allow easy of monitoring and recovery.

San Jose, Ca, Us

As technical lead, gather requirements, architected, created, developed, and analytical data models for business analysis. Performed a variety of roles such as Business Analyst, Architect, System Integrator, Technical Lead, Development (Back-End and Front End), on-call support, and operations. Created and Implemented the Customer Data Mart InfrastructureCreated and Implemented SASImplemented Clickstream Analysis via Omniture

Defined the strategy for gathering and organizing of data for access, exploration, and analysis in an e-commerce environment. Prioritized development efforts and planned for team growth.• Collaborated with merchandising, engineering, business development, finance, and operations to define strategies and requirements for OLAP, decision support systems, data warehousing, data marts, data gathering and data mining. • Evaluated analytical software packages and integration options • Translated requirements into data warehouse solutions with engineering team. • Re-designed the reporting architecture to stabilize the reporting system to provide near real time reporting of data using Oracle replication. • Designed and implemented Data Warehouse processes to create data marts for click stream analysis. Optimized database, user query, and batch performance.• Implemented reports and data marts to provide analysis on merchandising, offers, operations, finance and click stream data.

Defined the scope, schedule, and resources needed to meet the objectives of the Information Warehouse re-architecture project. SAP Business Information Warehouse (BW) Project Manager.• Managed an eight person team and coordinated and collaborated the effort with SAP Basis, DBA, Unix System Administrators, and the business community. • Designed the business specifications for the implementation of SAP BW as well as defined the hardware specifications and database structures.Information Warehouse – Integrated Service Management Project Manager. • Designed and implemented the front-end and back-end structures for the Service Contracts and Education Services subject area. • Supervised four programmers for the development of the systems and coordinated with other groups to provide the needed data and resources.

Technical lead: gather requirements, created, developed, and designed analytical data models for business analysis. Trained and provided support to over 800 users on Data Warehouse usage.• The Decision Support System is used in operational planning to track bookings, backlogs, shipments, internal inventories, and channel inventories. • Trained and supervised four contract programmers for the development of the system.• Performed data analysis and modeling on SAP data. • Created analytical structures to allow ease of analysis by various business groups.• Designed and implemented an EIS to track daily the current state of Revenue, bookings, Shipments, and Backlog for upper management.• Improved the EIS service levels by 50% through query, program, and process optimization

Bethesda, Md, Us

Developed project management and operational reports for the missile and satellite divisions.• Designed, integrated, and implemented a Product Management Systems and OLAP Summary Database for forecasting, and integrated cost and scheduling analysis by business operation. This system allowed users to identify $10 million in cost reductions. • Developed a report generation and scheduler system for automated report generation.• Report analysis, conversion, creation, enhancements, and process improvements.