PROFESSIONAL SUMMARY

Analytical, highly organized, and results driven Business Analyst providing solutions to data challenges. Identify and implement efficient processes in order to save corporations resources and capital. Leader and collaborator recognized for achievements made in data analysis.

PROFESSIONAL EXPERIENCE

Zillow Group October 2015 – May 2016

Data Quality Control Specialist

Conducted quality control using advanced Excel tools, Access and SQL to ensure Zillow standards are met and data conversion instructions are followed resulting in faster processing time of future edition by 50%

Prepared and communicate quality control findings to management through data pattern recognition to enhance data quality by 67%

Analyzed 3rd party real estate data using data mining techniques in order to provide programmers and offshore vendors accurate instruction for converting the data into Zillow formats to maintain over 95% accuracy of the data

Collaborated with other analysts and computer developers to identify and create new data quality tools to reduce processing time of county tax roll files by 25% and reduce program costs

Minacs Marketing Solutions February 2015 – September 2015

Mazda North America Incentives Business Analyst

Increased accuracy of national and regional incentive programs created in Siebel CRM resulting in increased productivity of 50% by creating and documenting a master list current incentive programs and collaborating with team members

Developed and implemented a new reporting process for the Certified Pre Owned Vehicle incentive program resulting in 99% decrease in system errors and a cost savings of 5%

Utilized MS Visio to develop and document a visual of current processes to identify opportunities to enhance procedures in order to reduce program cost down for the service loaner vehicle program

Analyzed historical program cost of Auto Show incentives in order to identify more effective marketing strategies resulting in a projected sales increase of 10% and cost savings of 10%

Trilogy Automotive Inc. May 2014 - December 2014

Hyundai Motor America Lead Management Business Consultant

Maintained the lead management and sales dashboard by utilizing advanced SQL queries and MicroStrategy dashboards to illustrate real-time & historical performance resulting in improved deliverables of dealership metrics by 25%

Consulted the 800+ dealership network technical support solutions for their CRM and lead response inquires

Successfully sold over 20 Hyundai dealers to double their annual market spend allocation on Trilogy leads by providing management best practices strategies to maximize ROI

Established a data extraction and data mining process of the monthly lead-to-sales matches to drive accuracy to over 99% by utilizing SQL, Excel, Access and MicroStrategy

Conducted a multi-tier lead generation research project to compare the effectiveness of the Hyundai lead management program to other OEMs. Presented to the executive leadership the strengths and growth opportunities of the current program to improve the user interface for customers

Researched and developed a new social media platform for dealerships to implement resulting in higher brand awareness by following defined business requirements for Facebook and Twitter sites

CoreLogic January 2010 - May 2014

Senior Data Quality Analyst

Analyzed the tax rolls filed with the county assessor’s office for over 3000 U.S. counties by creating SQL queries to extract key elements in researching pertinent issues

Enhanced program logic by providing programmers technical solutions to data quality issues found in system files to increase quality of the data by 20%

Trained coworkers how to implement advanced Excel tools resulting in 50% greater productivity during the QC process

PROFESSIONAL EXPERIENCE (PROJECT WORK)

AMCI May 2010 - August 2011

Marketing Consultant

Conducted the research and published articles for the company's website comparing the attributes of various vehicles within their respective segments

Kelly Services July 2009 – January 2010

BUSINESS OPERATIONS ASSOCIATE

Created new Excel-based invoicing system to ensure all transactions were accurately

recorded driving efficiency by 50%

LifeCare Assurance March 2009 – July 2009

HRIS Analyst

Managed and implemented the data conversion project from Excel-based recording to the iVantage HRIS software suite to properly track and maintain records for over 350 employees

American Honda Motor Company September 2008 – November 2008

Customer Data Analyst Contractor

Monitored call center operations at American Honda using BI tools to ensure customer care representatives delivered over a 90% customer satisfaction rating

EDUCATION

Bachelor of Science, Arizona State University, Tempe, Arizona May 2008

Business Marketing

Entrepreneurship Certificate

Graduated Cum Laude

PROFESSIONAL AFFILIATIONS

Toastmasters International, Competent Communicator, Past Club Sergeant of Arms

American Marketing Association, Orange County

TECHNICAL EXPERTISE

MS Excel 2016

MS SQL Server 2014

MS Visio 2016

MS Access 2016

PostGre SQL

MicroStrategy

MS SharePoint

MS PowerPoint 2016

Siebel CRM

Contact this candidate