Thomas Miglas Email & Phone Number

Beverly Hills, California, Us

• Partnered with marketing, strategy, data science, and business intelligence teams to attribute incorrect orders, with over $2 million in revenue impact. Corrections were made using multi-touch attribution Google Analytics data via BigQuery. • Collaborated with the email marketing team to plan, test and monitor a 6-month email frequency test of our weekly newsletter from once a week to twice a week, used a slow rollout to mitigate unsub rates.• Built DOMO datasets utilizing BigQuery at the local market level with state and national rollups.• Built Teradata and BigQuery datasets for company-wide dashboard.• Developed and standardized customer level engagement reporting for marketing and overall corporate needs.• Built and maintained data quality dashboards.

Atlanta, Ga, Us

• Produced countless deep dive and ad hoc data analyses by utilizing Hadoop big data through Hive and data from various sources such as Oracle, Vertica, and flat files.• Keenly reviewed the lift from user-generated content (UGC) on advertiser search engine optimization (SEO) direct to MIP (More Info Page) and click thru rate (CTR); discussed findings to product shareholders and the management.• Worked collaboratively with the data scientist to determine potential advertiser attributes to enhance lead conversation lift on the advertiser’s business profile page while communicating with marketing to provide messaging finding to sales representatives.• Took charge of auditing Google and Bing search engine marketing (SEM) invoiced clicks and comparing the differences between internal numbers and kept invoice.• Held responsibility in categorizing, investigating, and documenting numerous data irregularities while working with database analysts on applying fixes that corrected the anomalies.• Presented helpful insights regarding possible opportunities to improve website and application traffic through monthly deep dive analysis.• Collaborated with product and engineering teams in clarifying key performance indicator (KPI) which enumerated the impact of new product features and launches across all product platforms.• Achieved average saving of $162K a month through additional traffic quality logic to identify bad impressions and click from 10 traffic partners.

Atlanta, Ga, Us

• Imparted key insights to the upper management and product managers regarding deep dive analyses.• Expertly utilized HiveQL in extracting data from Hadoop to update and allocate weekly and monthly key performance indicator (KPI) reports.• Provided direct support to web and mobile application developers, as well as product managers in debugging website and mobile application tracking issues through HiveQL to query Hadoop.• Strategically developed SQL queries for post-reporting on web and mobile releases and A/B testing results.• Collaborated with the Quality Assurance (QA) Team to identify tracking or reporting irregularities prior to new website and application version releases.• Conducted weekly departmental training in Oracle/PLSQL, Microsoft SQL, and HiveQL.• Held accountability for segmenting visitors for A/B testing based on behavioral trends.• Assessed and verified data using Oracle/PLSQL, Microsoft SQL Server, Vertica SQL, TOAD, SQL Developer, HiveQL, Perl, and Excel.• Developed and presented insightful results regarding visitor interaction with company products to product development on a quarterly basis.• Produced Perl scripts to implement HiveQL queries that extracted daily data from Hadoop and attach it to tables for data analysis.

El Segundo, California, Us

• Formulated strategies regarding the effective use of Acxiom consumer overlay data to a more efficient segment of acquisition and retention sales initiatives.• Collaborated with the Telemarketing Sales Team in improving targeted call campaigns• Initiated standardized campaign tracking and response reports; prepared call lists to external vendors for various automated call blasts.

Charlotte, Nc, Us

• Managed all aspects of Mass Media Marketing reporting and analytics.• Aided in the launch of Microsites that coincide with related TV spots.• Worked with Marketing Managers and Internet Engineers to set-up tracking and reporting methodologies for newly developed Microsites.• Developed MS SQL code to improve reporting efficiencies across all marketing channels.• Created MS SQL jobs that checked the integrity of the MS SQL tables data.• Developed demographic and financial profiles of Mass Media port customers.• Communicated with external mass media marketing agencies to reconcile the company’s media spend.

El Segundo, Ca, Us

Ba, Economics

Transferred, Architecture