Robert Rea Email & Phone Number

Ladera Ranch, Ca, Us

Irvine, California, Us

Allergan Data Labs is on a mission to transform the medical aesthetics business at Allergan Aesthetics, an AbbVie company (NYSE: ABBV), one of the largest pharmaceutical companies in the world. Allergan Aesthetics brands include Botox, CoolSculpting, Juvederm and more.Business Intelligence SpecialistJan 2024 - CurrentSenior Data Analyst Mar 2021 - Jan 2024- Construct sophisticated SQL queries, develop views/tables, and oversee MDM/report data integrity within Snowflake- Design interactive dashboards and comprehensive reports utilizing Tableau and Microsoft Excel- Facilitate technical, business case, and team compatibility interviews- Coordinate meetings with diverse, cross-functional teams across various geographical locations- Generate and sustain Confluence documentation pages, along with the creation of instructional video tutorials

Costa Mesa , Ca, Us

Ultra is a company dedicated to creating innovative, authentic mobile communication experiences for people around the globe. We offer communication plans that break down barriers and allow our customers to easily and affordably connect with their communities – no matter where they may be.- Streamlined the production and distribution of regular reports to management and clients, utilizing SQL, VBA, and Python- Developed and upheld weekly scorecards, conducting detailed analysis on any irregularities- Set monthly and quarterly objectives for individual sales team members as well as clients- Collaborated with engineering team to pinpoint and rectify inconsistencies across reporting platforms- Formulated SQL reporting models to handle plan and tier-oriented commission payments- Constructed engaging reports and dashboards using Looker, Tableau, and Salesforce

Tulsa, Ok, Us

American Advisors Group (AAG) is the top lender in the American reverse mortgage industry, licensed to operate in 48 states. The company provides government-insured Home Equity Conversion Mortgage (HECM) loans and has 81 geographical areas approved for business by HUD.- Authored SQL queries linking data from multiple applications, ensuring comprehensive tracking of leads from initial contact to conversion in the sales funnel- Established procedures and reports to track the costs associated with launching and sustaining advertising campaigns- Engaged with managers across all departments to comprehend their reporting requirements, providing data-backed analysis- Engineered SSRS and Tableau dashboards to cater to the distinct needs of various departments

Adaptive Medias, Inc. (OTCQB: ADTM) is a leading provider of mobile video delivery and monetization solutions for publishers, content producers and advertisers. The company’s comprehensive mobile video technology platform, Media Graph, facilitates the delivery of integrated, engaging video content and impactful ad units across all screens and devices. - Designed and executed SQL-based reporting models that collected, processed, and relayed data to both internal and external stakeholders- Enhanced pre-existing models to incorporate new scenarios and features in line with requests from the business development and account management teams- Managed the computation of daily revenue and month-end reporting for the organization as a whole- Conducted analysis of the impact of marketing campaigns on user engagement metrics including CTR, VTR, and new accounts- Routinely conducted data mining and developed queries to address inquiries originating from all departments- Crafted Python applications to automate routine tasks, such as collecting third-party data from diverse sources and delivering daily reports to external clients- Oversaw and provided training to numerous employees on SQL and Microsoft Excel best practices and methodologies- Boosted the visibility of the company's performance by developing refreshable Excel dashboards using SQL and VBA, allowing for seamless transition from high-level to detailed views of requested data

OneScreen is a digital video company that empowers publishers, producers, and advertisers with a network to discover opportunities, a platform to manage operations, a marketplace to transact business, and services to enhance strategies. Our technologies and solutions are shaping the new digital video economy, where audiences are watching everywhere. We have been recognized as a fast growing company by Inc 500, a forerunner in industry innovation by The Stevie Awards, and a great place to work by The Orange County Business Journal.- Transitioned the company's reporting system from a Microsoft Excel-based framework to a SQL-based one, achieving a 75% reduction in time expended on daily revenue reporting updates- Devised and instituted an Extract, Transform, Load (ETL) reporting procedure, drastically reducing time taken for month-end reporting- Collaborated with the technology team to conceptualize a scalable, normalized reporting flow- Boosted operational efficiency by designing Microsoft Excel workbooks for frequently produced reports, enabling co-workers to refresh these with new and updated data- Generated daily ad-hoc reports customized to the specific needs of co-workers and clients by writing SQL queries across various tables- Audited data to ensure its completeness and accuracy for daily updates and month-end reporting- Engaged directly with the CEO to explore revenue opportunities and trends with current and potential clients- Oversaw all elements of integrating new advertising agencies into the daily reporting procedure