Analyst, Analytics, MS Excel, SQL

Experience:

Internet Brands, Inc Business Analyst (05/2017 - Pesent)

Manage call lead revenue reporting on weekly basis and at month’s end as well as make adjustments to maintain the report’s functionality.

Manage client information to ensure proper routing of call leads in routing software (Marchex)

Manage site KPI dashboards for multiple sites, acquiring data from multiple sources and making it available for team members on a weekly and monthly basis; used Continuous Data Protection to preserve records.

Perform ad hoc analysis of site Traffic, banner ad performance, and call lead volume using Google Analytics, Google Ad Manager, and MS Excel for various digital marketing purposes.

Use Google Ad Manager(Similar to Triblio) to perform analysis and manage ads in rotation for digital marketing campaigns.

Work cross-functionally with sales and account management teams providing analytics to cater to clients.

Planned and executed call routing consolidation and migration project saving the company time and money.

Handle Reporting for site backlog of technical issues for a newly acquired site using MS Excel and Salesforce.

Coordinate with New York office to set up tableau access for team members using Zendesk.

Handled cost-benefit analysis for AdSense campaigns

Conduct load Research analysis for banner ad campaigns

Greenwood Hall, Inc. Analyst (10/2015 – 02/2017)

Compiled, sorted, formatted files for and constructed company Data Room.

Handled various sensitive and confidential matters for Human Resources Department.

(Onboarding, Insurance Documentation, Employment Verification, Pay Increases, Employee benefits, Disciplinary Records, etc.)

Processed deposited and kept records of revenue checks as well as recorded and mailed out vendor checks.

Reconciled credit card statements for Company Controller.

Handled Expensify reports for CEO, CFO, and Executive Coordinator.

SP+ Corp. Marketing Representative (08/2013 - 10/2015)

Compiled an e-mail list using Microsoft excel and other software for the corporate database.

Worked to increase company’s presence in the LAX vicinity using social media

Drafted online business descriptions for each of the company’s Locations.

Assisted in the testing of a new tracking system for airport shuttles.

Conducted surveys for regarding customer service.

Coordinated and executed direct mail campaign for 15,000 perspective clients.

Compiled and prepared ad hoc reports for budgeting and operational use in MS Excel.

Attended meetings dealing with operational issues and how to remedy problems.

Initial point of contact between the business and customer contacting us through our support e-mail address.

Education:

BBA from Baylor University

Double-Major: Finance and Management Information Systems (MIS)

Certifications:

SQL - Udemy

References:

Available upon request

Willing to relocate

Contact this candidate