Open to opportunities

Sonika Sharma

@sonikasharma1

Data Science Engineer at Merck integrating Adobe Workfront marketing data into a Databricks medallion architecture and AWS Redshift.

United States

Message

At Merck, I’m integrating marketing data from Adobe Workfront into a Databricks medallion architecture and AWS Redshift, designing target data models and mapping relationships across source platforms.

I’ve also engineered data pipelines on GCP and built a Python document-processing pipeline with AWS Textract and Rekognition to support content and campaign tagging. At Merck, I developed a brand color analyzer using OpenCV and Scikit-learn.

Earlier, at JPMorgan Chase & Co., I developed ARIMA forecasts for subpoena volume and automated reporting. At Common Threads, I analyzed child nutrition and survey data and co-authored peer-reviewed publications.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Science Engineer

Current

Merck Inc.

Apr 2022 - Present (4 years 6 months)

Leading integration of marketing data from Adobe Workfront into Databricks medallion architecture and AWS Redshift, designing data models and schemas. Partnering with Microsoft and Salesforce to evaluate platforms and align roadmaps.

Databricks AWS RedShift Adobe Workfront GitHub Co Pilot VSCode Gemini Enterprise AI Salesforce Data Cloud CRM Analytics GCP Data Modeling ETL Data Integration

Data Science Engineer

Merck Inc.

Mar 2019 - Mar 2022 (3 years)

Engineered scalable data pipelines on GCP integrating digital engagement and campaign data. Built document processing pipeline using AWS Textract and Rekognition and developed brand color analyzer using OpenCV and Scikit-learn.

GCP BigQuery Cloud Functions Pub Sub Cloud Storage AWS Amazon Rekognition Python OpenCV scikit learn K Nearest Neighbors Google Analytics 4 Campaign Manager 360 (DCM)LiveRamp TradeDesk OneTrust CCPA GDPR

Business and Data Mining Analyst

JPMorgan Chase & Co.

Jan 2017 - Feb 2019 (2 years 1 month)

Built and maintained Tableau productivity dashboards for subpoena processing team. Developed ARIMA time-series forecasting models to predict subpoena volume and integrated forecasts into workforce planning.

Tableau SAS Control M ARIMA Time series Forecasting MS Access KPI Reporting Data Extraction

Statistical Data Analyst

Common Threads

Jul 2015 - Dec 2016 (1 year 5 months)

Led statistical analysis of child nutrition program and survey data using SAS to evaluate program effectiveness. Built Tableau dashboards and performed demographic segmentation to inform expansion strategy.

SAS PROC UNIVARIATE SAS (PROC LOGISTIC)PROC POWER Tableau Statistical Analysis Demographic Targeting