Andre Christopher Avanessian Email & Phone Number

New York, Ny, Us

Advanced to a new role within the Omnicom Agencies network to support General Motors and ExxonMobil focusing on strategic analytics initiatives• Designed an analytics onboarding roadmap for new client to ensure no disruption to clients existing key analytics report delivery• Lead onshore/offshore data science and analytics teams in data validation of client data sources in Azure Databricks and report development in MS PowerBI, Tableau, Looker Studio, and other dashboarding tools

Woodland Hills, California, Us

Joined KERN as the Analytics department head reporting directly to the company President, navigated a company merger within a few months on the job, successfully integrating two competing analytics teams. Supported AT&T, DirecTV, Blue Cross of Idaho and other client accounts.• Successfully integrated two distinct analytics teams expanding from 8 to 20+ employees as part of an agency merger while maintaining a record attrition rate of ~10%.• Set analytics department vision, key initiatives, configure staff plans, hire, coach, and reallocate resources accordingly.• Implemented Agile/Scrum project management methodologies and tools which improved quality, throughput, and executive leadership visibility into data & analytics deliverables.• Lead analytics enablement team in scaling best practice tagging & tracking methodologies for analytics measurement across google campaign manager 360, google analytics, and related marketing platforms resulting in a 25% efficiency gain.• Successfully secured over $700,000 in incremental business with a Fortune 100 telecom company, demonstrating a deep understanding of their needs and pain points.• Oversee the creation of standardized datasets and data visualization dashboards in Tableau to provide scalable, quicker turn reporting to client and enable deeper actionable analytics work.• Supported multi-million dollar new business pitches by highlighting agency data & analytics capabilities.

Beverly Hills, California, Us

Worked with newly established Data Engineering team on initial build out of Snowflake and Google Big Query Data warehouses to enable Analytics function. Partnered with EVP of Data Tech & Analytics to establish relationships across the company’s various business unit executives to address their strategic analytics initiatives.• Led and mentored analytics team responsible for data collection, reporting and analysis of the digital properties, products, platforms, and programs associated with Billboard, The Hollywood Reporter, VIBE, MRC Entertainment, Dick Clark Productions, etc.• Created executive level Tableau dashboards highlighting top ad revenue generating content across digital properties and social networks.• Developed an internal proprietary KPI to gauge content performance.• Provide direction to data engineering team on data ingestion and reporting optimized table creation across social, video, and web analytics platforms such as Facebook, Twitter, Instagram, Youtube, Google Analytics, Brightcove, etc.• Leverage Snowflake, Google BigQuery data warehouses and UiPath to design and execute data automation solutions.

Los Angeles, Ca, Us

Modernized the Analytics team function, moving from massive Excel files to a proper Amazon PostgreSQL Database which reduced human error and report generation times, while increasing analytics capabilities. This solution was scaled across all major clients (Kia Motors USA, Hyundai Motors USA, Heineken USA) which resulted in a role transition that set me as the head of the new Data & Enterprise Analytics function reporting directly to the company SVP of Analytics.• Led the creation of the Data & Enterprise Analytics Department and serve as the department head providing scalable data solutions to support analytics efforts across all automotive clients.• Architected an Amazon Web Services PostgreSQL data warehouse with daily ETL processes to ingest and harmonize data from various media platforms including Google DoubleClick Campaign Manager, Facebook, Twitter, VisualIQ, etc.• Directed Data & Enterprise Analytics team in data warehousing, ETL, automation, and advanced analytics efforts using a combination of tools such as Talend, pgAdmin, UiPath, MS PowerBI, and Alteryx.

Los Angeles, Ca, Us

• Led analytics team in creation and presentation of performance analytics insights PowerPoint decks to senior client leadership.• Architected monthly reporting encompassing TV, Paid Search, Digital Display, Digital Video, and Social Media advertising efforts across 40 regional automotive dealership groups.• Conducted brand perception sentiment analysis for automotive client through R programming of consumer response data from several Google 360 surveys.

Houston, Texas, Us

Reporting to the VP of Marketing & E-Commerce, was the first analytics hire within the marketing department after an unsuccessful attempt to offshore all analytics processes. Provided oversight to offshore analytics team to curb costly mistakes made for several months prior to my joining the company.• Identified over $10,000 in wasted marketing spend and rectified erroneous data to ensure customer data accuracy for use in targeted marketing campaigns.• Led a team of offshore analysts and data scientists to drive marketing channel reporting and spend recommendations.• Ran predictive models using R programming to score and target customers for A/B and multivariate testing of responsiveness to marketing campaigns and assess end of campaign ROI.• Served as subject matter expert on CRM and Magento ecommerce SQL databases and drive data integrations across analytics and business intelligence systems.• Provided external vendor direction and guidance on ecommerce KPI dashboard creation in Tableau.

Huntington Beach, California, Us

Initially joined as a Sr. Analyst but was quickly promoted to Manager reporting to the VP of the newly established Business Intelligence & Analytics group where I delivered on key department initiatives supporting sales, finance, and call center operations teams. Developed a projected sales KPI viewable by each salesperson to further motivate their efforts to earn commission against sales goals. • Created business intelligence reports in Tableau and established an effective Tableau implementation strategy that resulted in rapid adoption from approximately 20 users to over 2000 users.• Automated the enterprise sales production report resulting in a 99% decrease in report creation time (100 hrs to 1 hr per month).• Led a team of Business Analysts to create enterprise level automated reporting solutions for executives and key stakeholders.• Developed executive level sales reporting and served as subject matter expert for the organizations policy management system.• Served as reporting, database, and project management liaison with a key external vendor.

Playa Vista, Ca, Us

• Used analytical techniques to recommend optimal pricing strategies and lead volume projections to maximize revenue while maintaining client satisfaction• Investigated client and network wide performance trends to identify key performance inputs to manipulate in order to optimize lead quality and monetization efforts• Created data visualizations and automated reporting in Microstrategy Visual Insight• Worked closely with sales team on high value accounts totaling approximately $2MM in monthly revenue by providing data insights and recommendations to clients

Santa Monica, Ca, Us

• Created automated reporting in Tableau to support Data Operations, Analytics & Reporting, and Product Analytics• Developed an interactive intranet web portal which served as a centralized repository of reporting across multiple reporting platforms for easy access by Product Managers• Played a lead role in developing data visualizations for our new dealer performance reporting tool• Leveraged experience with HTML and CSS to create IPad friendly dealer performance reporting• Designed a dealer diagnostic checklist which identified several actionable key performance metrics• Provided sales and conversion data insights for Marketing and Public Relations departments• Reported on various website impressions and A/B test results• Prepared detailed dealer retention reports which resulted in saving approximately $80,500 in monthly revenues• Used SQL queries and data manipulation in Excel to prove dealer performance and ROI • Performed data analysis of dealer key performance metrics to provide supporting data for the launch of a new sales product• Improved standard dealer performance report excel template to allow for greater flexibility, ease of use, and reduced manual entry through advanced Excel functions and SQL/Netezza database integration • Assisted in training Sales Managers and other sales personnel

Los Angeles, California, Us

• Analyze metrics and initiate key decisions to optimize lead performance while controlling spend for over 650 automotive dealers (approx. $400k monthly budget)• Played an integral role in establishing business requirements and worked closely with product and engineering to automate the lead performance management system• Created Excel Macros to automate monthly lead data scrubbing which reduced human errors, resulting in decreased lead traffic acquisition costs• Conducted an in depth analysis of client cancellation data and provided recommendations to improve processes to better serve and retain clients • Spearheaded a significant system fix which increased lead attribution for roughly 20% of our entire active portfolio of automotive dealers• Responsible for fulfilling new and change advertising orders as well as generating custom reports for automotive dealers on database via SQL• Redesigned Excel workbooks for both operations and reporting using advanced excel functions and macros to increase efficiency and effectiveness• Assisted in training and supervising new employees

Irvine, Ca, Us

• Created a data dictionary to display definitions, logic, and structure of a company wide loan servicing database• Designed an E-R diagram to graphically represent the structure and relationships within the database• Prepared an SQL server report for our database data dictionary using SQL queries to serve as a reference document• Reconciled GL fixed asset balances of 1325 fixed asset items valued at $ 1.2MM to actual IT inventory lists through advanced lookup functions in Excel• Assisted in the development of a mortgage insurance tracking system by collecting end user requirements, designing a graphical user interface in Excel, and coordinating with the IT development team for programming and deployment

Rosemead, Ca, Us

• Created Excel charts and graphs summarizing business unit Occupational Safety & Health Administration (OSHA) recordable injuries to be further investigated by a consulting firm• Developed a training feedback form allowing employees and managers to gauge the value added from attending training sessions• Established performance metrics to measure progress towards fulfilling department goals• Identified best practices in performance reports to increase effectiveness and assisted in the implementation of the improved reports to senior management• Assisted in the development of a business unit level business continuity plan

Dallas, Tx, Us

• Analyzed and converted the financial statements of various companies into the Bank’s specific format in order to assess a customer’s financial standing• Interpreted forbearance agreements and other loan documents in order to process loan extensions• Prepared detailed loan accrual history Excel spreadsheets tracking all loan payments, interest rate changes, interest amounts accrued, and outstanding balances• Examined daily DDA account overdrafts, determined fee charges, and responded to customer inquiries

Certificate, Business Intelligence: Techniques For Decision Making

Mba, Finance

Bachelor Of Arts (B.A.), Economics / Minor In Computer Information Systems