Herik Patel
Data Analyst | San Francisco, CA
Contact Me
Professional Summary
Experience
3.5+ years in marketing analytics and pharmaceutical data across U.S. consulting and healthcare domains
Expertise
Customer segmentation, churn modeling, workforce planning, and clinical data integration
Impact
Prepared 2M+ CDP records, analyzed 1.2M transactions preventing $250K loss, automated 600+ records
Current Role: Data Analyst at Epsilon
July 2025 – Present
01
Customer Data Platform
Extracted first-party customer data using SAS, preparing 2M+ records for campaign activation
02
Cross-Channel Mapping
Mapped user behavior via SQL, unifying 5 disparate data sources for compliant targeting
03
Campaign Visualization
Created Tableau dashboards presenting insights on 12 audience segments in weekly strategy sessions
04
ETL Pipeline Deployment
Built Python and AWS Glue pipelines, ingesting 7 partner feeds, reducing workload by 18 hours
Boston Consulting Group Experience
Data Scientist Intern | August 2023 – October 2023
1.2M
Transaction Records
Analyzed for telecom client churn investigation
18K
Customers Retained
At-risk customers saved through engagement strategies
$250K
Revenue Protected
Prevented leakage through compliance reporting
Engineered interactive Tableau dashboards and constructed predictive workforce planning models using Random Forest and Gradient Boosting across 7 business units.
CIPLA Pharmaceutical Analytics
Data Analyst | February 2021 – July 2023
Lab Data Analysis
Analyzed raw Electronic Lab Notebook data using SQL, standardizing 500+ experimental records for regulatory audits
Manufacturing Systems
Processed real-time MES parameters with MATLAB, flagging 120 batch anomalies to reduce rework cycles
Supply Chain Optimization
Visualized performance via Tableau, mapping stock movement across 30 facilities for dispatch planning
Early Career Foundation
Trinity Technolabs Intern | March 2020 – January 2021
1
Data Quality
Interpreted web usage logs using Python, resolving 450+ critical formatting errors before deployment
2
Campaign Analytics
Transformed marketing data in Excel, producing 12 streamlined weekly performance summaries
3
Dashboard Development
Built Tableau reporting dashboard, accelerating decision-making in 4 sprint planning reviews
Technical Skills Arsenal
Programming
Python (Pandas, NumPy, scikit-learn), R, SQL, Shell/Bash for data manipulation and analysis
Analytics & ML
Regression, Classification, Clustering, Time Series, A/B Testing, TensorFlow, PyTorch, NLP
Cloud & Engineering
AWS (S3, Redshift, Glue), Azure Synapse, ETL Pipelines, Data Warehousing, PostgreSQL
Visualization
Tableau, Power BI, Matplotlib, Seaborn, Excel Power Query for compelling data storytelling
Featured Projects
Real Estate Business Intelligence Dashboard
Built comprehensive BI solution analyzing 1.3M+ records from fleet and rental data. Applied clustering algorithms to identify Manhattan as top-yield area ($196.88 nightly). Forecasted post-2019 trends driving targeted marketing campaigns.
AI Interviewer Bot
Developed AI-driven interviewer agent using Langgraph, Streamlit, and Ollama. Features adaptive Q&A, rubric-based scoring, and automated transcript generation for personalized interview practice.
Education & Credentials
1
Master of Science in Data Science
University of the Pacific, San Francisco, CA | August 2023 – May 2025
2
Bachelor of Technology in Computer Engineering
LDRP Institute of Technology & Research, Gandhinagar, India | July 2019 – May 2023
Ready to Drive Data-Driven Success
Transforming complex data into actionable insights that deliver measurable business impact
3.5+
Years Experience
2M+
Records Processed
$250K
Loss Prevented
Made with