Cesar Valenzuela

Cesar Valenzuela Email and Phone Number

Product Manager @ Square | Data Product Development
Cesar Valenzuela's Location
San Francisco, California, United States, United States
Cesar Valenzuela's Contact Details
About Cesar Valenzuela

I am a data product manager with over 25 years of experience in building data platforms and data warehouses in start-up and fast-growing companies. I have a Project and Program Management certification from the University of California Extension, Santa Cruz, and I specialize in data warehouse architecture, data warehouse, business intelligence, software development, and analytical data marts.In my most recent role at Square, I created data products and solutions to improve data delivery, quality, and development productivity for data analysts, product analysts, data scientists, and engineering. I worked closely with the customer and engineering team to define, create, and deliver features within a set timeline. I managed the evolution of several data products, such as Data Watermark Service, SqAirflow, and SquareWave, that increased data quality, reliability, orchestration, and accessibility. I also developed, refined, and optimized the delivery of various analytics, such as payments, subscriptions, feeds, and product data sets. I enabled data-driven decision making and insights for the company and its stakeholders.

Cesar Valenzuela's Current Company Details

Product Manager @ Square | Data Product Development
Cesar Valenzuela Work Experience Details
  • Treasure Data
    Lead Product Manager
    Treasure Data Apr 2024 - Jun 2024
    Mountain View, California, Us
  • Square
    Product Manager
    Square Aug 2017 - Aug 2022
    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.
  • Square
    Data Engineering Technical Lead
    Square Sep 2014 - Aug 2017
    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.
  • Linkedin
    Data Warehouse Manager
    Linkedin Oct 2010 - Sep 2014
    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.
  • Linkedin
    Staff Software Warehouse Engineer
    Linkedin Mar 2008 - Sep 2014
    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.
  • Ebay
    Staff Dw Software Architect
    Ebay 2005 - Mar 2008
    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.).
  • Ebay
    Analytical Data Mart Manager
    Ebay 2003 - 2005
    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.
  • Ebay
    Staff Software Engineer
    Ebay 2001 - 2003
    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
  • Mercata, Inc
    Business Intelligence Manager
    Mercata, Inc 1999 - 2001
    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.
  • Bay Networks
    Data Warehouse Project Manager
    Bay Networks 1997 - 1999
    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.
  • Bay Networks
    Senior Information Warehouse Engineer
    Bay Networks 1995 - 1997
    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
  • Lockheed Missiles And Space
    Senior Data Systems Programmer
    Lockheed Missiles And Space 1992 - 1995
    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.

Cesar Valenzuela Skills

Data Warehousing Business Intelligence Etl Databases Data Warehouse Architecture Sql Teradata Big Data Data Quality Hadoop Analytics Unix Data Migration Integration Data Integration Data Modeling Software Development Product Management Informatica Performance Tuning Unix Shell Scripting E Commerce Oracle Data Analysis Web Analytics Data Mining Rest Microstrategy Olap Distributed Systems Management Project Management .net Scalability Java Saas Appworx Requirements Analysis Database Design Shell Scripting Agile Methodologies Linux Strategy Apache Pig Business Process Architectures Tableau Data Architecture Hive Mapreduce

Cesar Valenzuela Education Details

  • De La Salle University
    De La Salle University
    Computer Science

Frequently Asked Questions about Cesar Valenzuela

What is Cesar Valenzuela's role at the current company?

Cesar Valenzuela's current role is Product Manager @ Square | Data Product Development.

What is Cesar Valenzuela's email address?

Cesar Valenzuela's email address is cv****@****din.com

What is Cesar Valenzuela's direct phone number?

Cesar Valenzuela's direct phone number is +141537*****

What schools did Cesar Valenzuela attend?

Cesar Valenzuela attended De La Salle University.

What skills is Cesar Valenzuela known for?

Cesar Valenzuela has skills like Data Warehousing, Business Intelligence, Etl, Databases, Data Warehouse Architecture, Sql, Teradata, Big Data, Data Quality, Hadoop, Analytics, Unix.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.