SUMMARY

• Result - oriented and innovative technology leader specialized in data analytic and data management, with a successful track record of building database, data warehouse, business intelligence, analytic, and reporting solutions that empower companies to harness their data assets and improve monetization.
• Broad knowledge and perspective in data pipeline, data collection, data management, data engineering, reporting, predictive analytics, recommendation engines, and data product development.
• Expertise with creating insightful executive dashboards and reports to support initiatives, such as A/B testing, user acquisition, user LTV optimization, user retention, revenue forecasting, Ad frequency cap, user segmentation, and Ad algorithm optimizations.
• Extensive knowledge with helping business develops and standardizes key performance measurement (KPIs) in alignment with the business strategy and objectives.
• Deep understand of analytical and transactional databases with Big Data and traditional databases.
• Analytical minded individual with experience cultivate and establish a data-driven company culture.
• Excellent management and leadership skills with the ability to establish rapport, build teams, foster relationships, and effectively communicate across different organizations.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Head of Data Analytics

Responsibilities:

• Manage teams of Data Engineers and Analysts responsible for the Data Warehouse, data pipeline (ETL), self-service Business Intelligence platform, and all data analytic and reporting related efforts.
• Architect and build the new data and analytics infrastructures to empower the business to grow.
• Create insightful executive dashboards and reports to supportnew and existing initiatives, such as A/B testing, user LTVoptimization,user retention, revenue forecasting, new game launch revenue forecasting,Ad frequency optimization, user segmentation, geo and game genre based Ad algorithms.
• Define and implement Data and BI tools needed to support a data-driven decision making culture.
• Oversee for the Data department road map, project priority, headcount, employee and departmental performance goals, resource allocation, and budget planning.
• Collaborate with Sales, Marketing, Finance, Engineering and Product management teams to develop and standardize company-wide KPIs, dashboards and business metrics.

Confidential, San Francisco, CA

Data Warehouse Architect

Responsibilities:

• Collaborated with business and technology cross-functional teams to implemented analytic and reporting features that enables business users and decision makers to make better decisions.
• Re-architected the Confidential ’ Enterprise Data Warehouse and BI Reporting Platforms.
• Architected the real-time data platform to enable real-time email and website personalization.
• Collaborated with management team and business groups to understand the evolving business needs, and priorities and plan accordingly to rollout new and improved Data Warehouse features.
• Establish and document database standards, capacity planning and security policies.
• Created scripts to automate all areas of DW monitor, maintenance, backup & administration.
• Created prototype of new BI and Reporting platform using Microstrategy.
• Mentored and provided technical guidance to junior team members.

Confidential, San Francisco, CA

Business Intelligence Manager

Responsibilities:

• Managed a team of 5 Data Analysts that oversees the health of Confidential ’s production data.
• Designed and developed Data Quality reports and dashboards to ensure production data maintained the highest level of data integrity and consistency.
• Created and maintained the Data Quality Data Mart and related ETL processes.
• Collaborated with cross function teams to resolve any data inconsistency issues, and communicated progress and plan of action to the senior management team.
• Mentored team members, and provide guidance and vision to the team.
• Documented solutions and procedures for resolving each data inconsistency issues.

Confidential, San Mateo, CA

Manager, BI Solutions

Responsibilities:

• Led a team of BI engineers and software developers to support the proprietary SaaS BI platform.
• Proactively managed project timelines, prioritized project tasks, and resources allocation.
• Architected the new automated template based Data Warehousing and ETL platform.
• Established coding standards to improve the development and deployment processes.
• Worked closely with the Customer Success Team to provide technical documents and support for product demos to ensure successful engagement of potential clients.

Confidential, San Jose, CA

Staff Software Engineer, Technical Lea

Responsibilities:

• Created Data Mart (Oracle) to support the dashboard reporting and data analysis.
• Designed and developed custom ETL and summarization processes.
• Managed the Actuate reporting system and ERP (Clarity) web application.
• Developed Web Service application using C# .NET to share data with other applications.
• Mentor junior staffs on all aspects of database, system, and application development.

Confidential, San Francisco, CA

Sr. Database Administrator

Responsibilities:

• Responsible for managing the mission critical (24/7) lead generation databases and multi-terabyte data warehouse (EDW) in an Oracle 9i and Redhat Linux environment.
• Designed and developed in-house data pipeline (ETL) and summarization process to support a near real-time (5 minutes delay) web reporting application using sql, pl/sql and shell script.
• Developed replication scripts to synchronize with non-production databases.
• Advance query tuning utilizing explain plan, sql trace, tkprof and statspack.
• Involved in all aspects of Oracle database administration, including installation, capacity planning, security, monitoring, tuning, replication, hot standby database, and backup (RMAN).
• Architected and implemented the reporting infrastructure to help the Yahoo Platinum streaming team with revenue forecasting, user retention and engagement analysis, and daily/monthly reports.
• Developed ETL process using UNIX Shell script, Perl DBI, SQL*Loader and PL/SQL to handle the data extraction, transformation and loading of data to the Data Mart.
• Created dashboards using Microstrategy and automated reports using PL/SQL and Shell script.
• Performed various data analysis to help improve the user acquisition strategy and user experience.
• Developed automated ETL process to import data from Teradata DW and Oracle production db to the reporting Data Mart (MSSQL) utilizing DTS packages and Stored Procedures.
• Created a reporting application for users to run easily access data using MS Access & Visual Basic.
• Performed complex data analysis using Transact-SQL, PL/SQL, MS Access, and Business Objects.

TECHNICAL SKILLS

DBMS: Hadoop, Vertica, AWS RedShift and EMR, HBase, MongoDB, Postgres, MySQL, Oracle 7x/8x/9i/10g, SQL Server 6.5/7.0/2000X, NCR Teradata and MS Access

Languages: Python, R, Spark, SQL, Hive, Pig, PL/SQL, Transact SQL, Linux Shell Script, PHP, Perl, C#, C++, Java Script, DOS, VB, SAS and HTML

BI/DW/ETL: Pentaho Data Integration and BI suite, Actuate, Microstrategy, Tableau, Business Objects, Crystal Report, MS SSIS + SSAS + SSRS, iNetSoft, ERWin and Visio

OS & Web Servers: Linux, BSD UNIX, Windows Server 200X, Solaris, IIS, Tomcat and Apache

Applications: Toad, Squirrel, DBeaver, MySQL Workbench, SQL*Plus, SQL*Loader, Oracle Import/Export, TKPROF, Profiler, Query Analyzer, DB Artisan, Veritas Backup, Teradata (BTEQ, FastLoad, FastExport, MultiLoad, Queryman), WINDDI, Visual Studio, CVS, SVN, FTP and Telnet

Certifications: Oracle OCP DBA Exam 1 Introduction to SQL