May 2016 – Jun 2019 · 3 yrs 1 mo · Los Gatos, CA

• As a Senior Analytics Engineer in the Finance vertical, I lead the Partner Revenue Share function. I drive impact using both data engineering and data analytics competencies across a data stack which includes PySpark, SparkSQL, Hive, Pig, Python, Presto, Amazon Redshift, Snowflake, Tableau and Microstrategy.
• I build data models, data pipelines and analytics data marts for:
• Revenue and Partner Programs, calculating key revenue metrics that drive month close and quarter end processes for Finance. Source of truth for all revenue metrics communicated across internal business functions including E-staff, FP&A as well as external partners. Data sets are SOX complaint due to high impact, high visibility and brand sensitivity
• Business Development and Partner Marketing, helping drive insights and analytics for data driven contract negotiations, campaign and launch performance measurements and other data driven business decisions
• Membership analytics to calculate key metrics like acquisition, churn, cost etc. and support for A/B testing analytics.
• I build cohesive analytics products and visualizations including:
• Tableau dashboards as a self service tool for Finance to automate month close and quarter close processes. One stop shop to highlight trends, anomalies, drilldowns, reconcilations with alternate sources for all major KPIs.
• SOX reporting for Finance, internal and external auditors.

May 2008 – Apr 2016 · 7 yrs 11 mos · Sunnyvale, CA

• Designed and implemented ETL for UAD (Unified Advertising Datamart) to converge and conform display advertising data from 6 separate ad platforms. Made UAD the source of truth for Revenue reporting for Wall Street, executive and operational level data analysis.
• Took ownership, led the data analysis, design and implementation for expansion of PRYME (a critical tool for Yahoo Pricing and Yield Management function) from the US to all global markets.
• Designed and implemented migration of ETL from Oracle datamart to Hadoop clusters.
• Identified and implemented solutions for optimization of ETL code on Hadoop clusters.
• Drove data quality initiative by creating aggressive functional and regression test suites to validate ETL on Oracle datamart and Hadoop clusters
• Enhanced test automation framework to accept test cases written in Oracle PL/SQL and PigUnit.
• Added support for test data generation, running tests in local or Hadoop cluster mode and running a job suite.
• Mentored junior members of the team in design, implementation and testing strategies.

Jul 2005 – Apr 2008 · 2 yrs 9 mos · New York, New York

• Wore multiple hats during my tenure - Software developer, Support Analyst, Global Release manager and Junior Business Analyst.
• Creation of customizable automated trade booking solutions to improve trader efficiency
• Business analysis for new features and enhancements. UAT testing ownership.
• Ownership of all support related issues and resolutions for the Repo trading desk
• Proactive monitoring of live trade queues and speedy resolutions to production issues to reduce "fail costs" on trades.
• Solutions to monitor and improve performance of system infrastructure including Solaris application servers, Sybase database servers.
• Ownership of code deployment globally and maintenance of source code in CVS.