Sophia C. Email & Phone Number

Boston, Ma, Us

Wilmington, De, Us

Boston, Ma, Us

I worked closely with engineering teams to tackle business impactful problems from improving data streaming technology for software developers, to building unified resource identifies and solving the pain points for data users to utilize cloud resources. I worked with a wide range of user personas and functions with distinct needs, touched on almost an entire chain of data products from collection, processing to analytics and modeling.

Boston, Ma, Us

I led a team of data engineers in the Product Pricing function. Over the 1.5 years I was there, we migrated/processed billions of data from on-premises SQL storage to AWS cloud storage through Snowflake pipelines enabling quality and efficient reporting for multiple property and casualty products.

Boston, Ma, Us

I built many features and functions for the web portal of Manage My Account to empower users to self serve online and actively contributed to multiple product feature decision and roadmap construction.

Boston, Ma, Us

I was accountable for the data tracking implementation for the marketing department, built hundreds of pixel tracking to collect data and boost data visibility to form a data lake and enable advanced data modeling.

I spearheaded multiple online and offline campaigns to explore potential direct partnership/buyer in North America and lead a team of 3 people to build an online platform to digitize the trades

Waltham, Ma, Us

I lead a team to enhance multiple products' go-to-market and pricing strategies through data analytics and modeling.

Boston, Ma, Us

•Lead sophisticated tests on Facebook ads and internal product features from strategic business level to granular technical level •Conduct campaign analysis to support teams of a variety of functions to size the market opportunities, help accounts reach KPI goals, troubleshoot data discrepancy issues•Work in SQL and Hadoop to analyze audience behaviors across hundreds of countries and demographic segments•Identify product gaps and initiate projects to meet business needs, create product protocol •Lead projects to enhance and promote Nanigans’ API, joined calls with clients to discuss benefits and implementation, troubleshoot errors, assist team members to build API into the product•Write scripts in Unix and build automated reports to perform ETL, build database and create dashboard•Prospect individuals for multiple functions, assist in hiring and training new team members, conduct analytics training sessions facing internal and external audience

Chelmsford, Ma, Us

•Lead and independent analyst and campaign manager accountable for a pharmaceutical account’s performance•Led data analysis and data modeling through SAS and SQL for clients at different strategic stages and in a variety of industries, such as automobile, pharmaceutical, and retail to improve marketing performance•Employed methods ranging from standard Linear Regression Analysis, ANOVA, Decision Tree, A/B Testing, Segmentation, Clustering to Hart-Hanks’ Market Opportunity Analysis, ROI Analysis, Best-Customer Analysis, Path-to-High Value Analysis to evaluate campaign performance and predict spend•Developed over 20 weekly or monthly Excel reports and PowerPoint decks to present actionable insights •Provided clients strategic consultancy in addition to assistance with data issues and technical questions

Marlborough, Ma, Us

- Designed, developed and managed an independent daily radio program to report recent cultural news- Interviewed countless people as a journalist and on-air host, maintained a column on a weekly newspaper to market and broaden the reach of the program- Co-hosted a travel program on TV on an ad-hoc basis

Master Of Library & Information Science - Mlis, Management Information Systems, General

Certificate Program, Business Analytics

Master'S, Integrated Marketing Communication

Bachelor'S, Journalism And Communication; Minor In Computer Science