Sat Daya Khalsa Email & Phone Number

Los Angeles, Ca, Us

New York, Ny, Us

* Built out partner facing analytics product powered by models using denormalized, incrementally loaded tables flowing into Sigma* Stood up/maintain Airflow (via GCP Cloud Composer) instance ensuring data is flowing into partner analytics product at the conclusion of every CloudSQL -> BigQuery GCP ETL job* Maintain and augment Kimball dimensional modeling for in house data visualizations. A particular emphasis on Kimball modeling best practices and dbt macros for clean, minimal code* Stand up new infrastructure (GCP Projects, BigQuery instances, Airflow Cloud Composer) using Terraform* Inbound and reverse ETL pipelines using Fivetran, webhooks, Hightouch* Own SaaS vendor relationship negotiations and contract negotiations

New York, Ny, Us

Senior engineer on team building out Kimball dimensional modeling pipeline using Fivetran/Bigquery/dbt/Tableaudbt specialist, ensuring the data warehouse product was aligning with dbt best practices and getting the most out of the productSet up CI/CD testing jobs for pull requests

San Francisco, California, Us

* Managing, augmenting, and refining the dbt/Redshift Kimball dimensional model* Snowflake implementation project planning* Inbound and reverse ETL pipelines using Fivetran, webhooks, Hightouch* Managing and optimizing Looker visualization infrastructure

Los Angeles, California, Us

• Rebuilding Snowflake data model implementing dbt jinja syntaxing, packages, documentation, and testing• Refining and adding ETL pipelines using Fivetran and webhooks• Building out Looker visualizations and underlying LookML models

Culver City, California, Us

Carson, California, Us

Built machine learning forecasting workflow for aftermarket brake company selling 60k sku’s across 1,200 customers.• Built SQL Server data mart storing all historical shipped data, metadata, and forecasts• Building dbt workflow to efficiently manage data transformations inside the data warehouse• Built out a time series machine learning process in AWS Sagemaker/Forecast utilizing convolutional neural networks, Prophet, and ARIMA.• Built multiple dashboards/views in PowerBI for SIOP for executive, sales, and operation teams respectively• KPI/metrics development• Established monthly meeting rhythm with sales, operations, and c-suite reviewing results, forecasts, expectations to gain consensus.• Used SQL Server and Python for data ingestion, forecast adjustments, and transformations.

Chicago, Il, Us

First dedicated demand planner for Think! branded protein bars generating $150MM in annual gross revenue• Replaced an inefficient legacy forecasting system with a cross-functional, comprehensive S&OP process• Optimized backend Oracle SQL tables and remapped the forecasting hierarchy and in the JDA forecasting tool, transforming it from useless to highly functional• Substantially improved forecast bias/MAPE metrics, transforming the Think! brand from last to first in forecast accuracy across the GPN portfolio• Diminished excess and obsolete inventory

Anoka, Minnesota, Us

Demand Planner & Analyst:• Walmart US, CN, UK• Raskullz branded kids helmets• Licensed kids helmets• Manage forecasts for over 5,000 sku’s in the Logility forecasting tool• Build and maintain department specific S&OP dashboards & reports• Cross functional work with sales and marketing to determine SKU rationalization• Data mapping and implementation of the Logility forecasting tool• Forecast and plan for promotional sales• Lead the licensed forecasting process by modeling future quarters based on demand expectations, reviewing projections with sales managers, obtaining approval from management, and submitting to the licensor

Anoka, Minnesota, Us

• Built and maintained weekly sales reports, scorecards, and dashboards synthesizing a variety of KPI’s for review by management in multiple departments• Cross functional liaison between finance, sales, and operations• Led the licensed forecasting process by modeling future quarters based on demand expectations, reviewing projections with sales managers, obtaining approval from management, and submitting to the licensor• Profitability reporting during monthly close

Anoka, Minnesota, Us

• Coordinated EDI orders from customers and generated pick orders within ERP to initiate distribution • Oversaw inventory allocations for a substantial order file• Analyzed inventory to provide available-to-sell reports, determined distressed inventory, and planned for healthy inventory levels• Created weekly reports incorporating POS sales, inventory position, forecasting, etc• Utilized a wide variety of MS Excel functions such as VLookups, pivot tables, nested if functions, charts, etc. to generate inventory analyses for management action• Analyzed sales trends, history, and anticipated inventory position to create projection models• Reviewed analyses with management for input highlighting inventory challenges• Master data creation, including item number assignment, UPC generation, DataSync

Teach weekly yoga class.

Served as Research Associate administering about $20 million in worldwide writer royalties annually.• Researched, analyzed and calculated writer credits on more than 10,000 non-WGA covered projects to pay non-members foreign levy royalties worldwide • Created, organized and maintained an Access database of over 3,000 non-WGA covered projects to facilitate future payments to writers• Employed various research and database investigative methods to identify and locate 5,000 non-guild writers in nearly 20 countries worldwide to ensure global royalty compliance