Justin Leu Email & Phone Number

I help companies build analytics and business intelligence solutions using modern BI methodologies. Bootstrap your business intelligence effort and data capabilities with 15+ years of experience in the industry. Recent clients include Cisco, United Healthcare, Quantcast, Herman Miller and Spotify. Learn more at www.klardata.com

San Francisco, California, US

• Led development of food analytics solutions and provided insight into the meals being served to 40,000+ employees in 160+ cafes globally.
• Developed BI solutions using Tableau, Amazon Redshift, and SQL. Created dashboards that provided insight into top health risks (by demographics, location) to provide healthy menu alternatives and influence food menu.
• Managed Tableau Server environment and external website visible to Google Food executives.
• Delivered PHI data in accordance to HIPAA regulation to Google and it’s third party health analytics vendors.
• Provided data requirements to engineering to improve existing data infrastructure and modified ETL scripts.

San Francisco, California, US

• Building out Eventbrite's data warehousing infrastructure/business intelligence capabilities.
• Responsible for integrating external data sources into new hadoop data warehouse and ad-hoc reporting clusters.
• Built out new Hadoop data mart using Hive/Impala and Oozie coordinator to support Analytics and high data volume queries.
• Created new python ETL pipelines and manage data flow through production and reporting environments.
• Implemented end-to-end solutions to support the business. I collaborate cross-functionally with business groups to build out KPIs/metrics and work with the engineering team to create new supporting data structures.
• Democratized Tableau across the company by acting as Tableau Administrator and provide assistance to team members on best approach to dashboard solutions.Technologies include: Python, API, MySQL, Cloudera Hadoop.

Chicago, Illinois, US

• Spearhead numerous business intelligence and reporting efforts in the Digital Channels group (mobile banking, online banking, sales) and provide technical expertise to functional groups for ad-hoc reporting and analysis.
• Manage the governance and definition of data analytics and reporting requirements (scoping, sizing, requirements, design, metadata, semantic layer) for digital data mart and marketing/campaign analytics.
• Perform funnel conversion analysis and goal setting for online account opening and provide business intelligence solutions which capture both online web analytics and offline transactional data.
• Collaborate with BIDW team, IT managers and vendors to integrate existing disparate data sources into the digital data mart in order to streamline data across the enterprise and enrich data for reporting and.
• Work closely with product managers and VPs to gather requirements for metrics/KPIs.

San Francisco, California, US

• Supported worldwide sales team at Meraki and ensured data integrity within salesforce CRM and other internal systems.
• Implemented plans for assessing the quality of new sources of data and improved overall database quality through the leads and bookings process.
• Acted as Salesforce.com system administrator and maintained user base, transferred territories, and managed movement of lead/opportunity/account data.
• Automated operational reporting/inventory planning and data loading proceses used for ad-hoc data analysis.

Worldwide, OO

• Worked on large projects at Fortune 500 companies focusing on project management, business intelligence/data warehousing, & reporting and provided guidance to client stakeholders.
• Acted as primary point of contact to gather requirements and consolidate data sources
• Led back-end SQL development and database management on SQL Server/.NET for a collections-tracking system used for monitoring and reporting.
• Created numerous stored procedures, triggers, and T-SQL scripts on SQL Server.
• Spearheaded data conversion/migration efforts between disparate systems.
• Managed contractors through data cleanup and ad-hoc data analysis.

Santa Clara, California, US

• Spent significant time analyzing customer data, developing data-centric solutions via reporting and custom built frameworks, and providing recommendations to business stakeholders.
• Worked cross-functionally with client subject matter experts from various departments (marketing, IT, legal, customer care).
• Identified data discrepancies and under billing errors on a revenue assurance project.
• Performed data analysis across customers, products, business units, and regions using a myriad of technologies (SQL Server, Oracle, Teradata, MySQL).
• Documented process workflows and performed gap analysis / root cause analysis.
• Led internal process improvement initiative to automate reporting and data flow tasks.

El Segundo, CA, US

Margin optimization and revenue analysis effort to check for billing accuracy on the entire DIRECTV subscriber base.

Aliso Viejo, CA, US

Performed functional and regression testing on the database application management tool, TOAD on SQL Server, Oracle, and DB2 platforms.