Analyst with experience in building Power BI and Tableau dashboards, running A/B tests and statistical hypothesis tests, and integrating multi-source commercial data for reporting and analysis. Skilled in Python, SQL, da…
Analyst with experience in building Power BI and Tableau dashboards, running A/B tests and statistical hypothesis tests, and integrating multi-source commercial data for reporting and analysis. Skilled in Python, SQL, data analysis, machine learning, ETL pipelines, and BI reporting, with project experience in campaign feature analysis and contractor project data analysis.
Experience
S
Intern
SAMODREI LLC, Virginia, USA·Accomac , Virginia , United States of America (USA)
Jun 2024 - Jul 2025 · 1 year
Built Power BI and Tableau dashboards monitoring regional market and business performance indicators (KPIs). Translated complex quantitative data into straightforward tables, charts, and briefings used directly by senior management for evidence-based decision-making. Designed and ran A/B tests and statistical hypothesis tests. Validated results through data quality checks. Identified behavioural inconsistencies across audience segments. Delivered factual summaries driving a 12% improvement in open rates within 60 days. Integrated multi-source commercial data (Google Ads, Facebook Ads, CRM) UTM parameter. Identified patterns and irregularities across channels that fed into a 15% ROI improvement. Delivered findings in structured analytical memos for senior partner review. Maintained and optimised CRM data pipelines across 50,000+ records using Python and SQL. Applied automation to streamline data retrieval, validation, and segmentation. Improved dataset reliability to 94%. Deployed VAPI-powered AI calling workflows for a US physician outreach programme. Analysed call transcripts using prompt engineering to surface product feedback and shape campaign strategy. Sourced and enriched data using Bright Data (LinkedIn API) to scrape supplementary records. Filled gaps in incomplete CRM data, improving record completeness by 20% and supporting more reliable downstream calling and outreach campaigns. Built and maintained automated ETL pipelines using Python and REST APIs. Integrated Google Ads, Meta Ads, and CRM data sources, improving data consistency and reducing reporting turnaround by 30%. Supported end user reporting by producing weekly Power BI and Excel dashboards tracking campaign KPIs. Provided guidance on report interpretation to enable data-backed operational decisions.
