Paul Sheffron

**-** **** ******

Apartment *D

Long Island City, NY 11106

917-***-****

ac5133@r.postjobfree.com

Objective

A key Business Intelligence and Data Analytics position involving media, consumer research and/or marketing, requiring data gathering and harmonization, reporting, database development and design and statistical analysis with opportunities for project management. Strong desire to increase proficiency with enterprise level data warehousing.

Functional summary

Over twenty-five years of experience in an analyst/consulting environment involving many survey, data collection and statistical analysis projects, using a variety of hardware and software platforms. Particular experience using SQL Server, SPSS, Microsoft Access and Excel including application development using VBA within the Office platform as well as data visualization dashboards using tools such as Tableau. Experience in project management, team building, training and supervision of staff. A very strong emphasis on client service and quality control with an extremely professional approach to all aspects.

Employment/ Qualifications

2006 – 2017 HAVAS Media New York, N.Y.

VP, Director of Database Analytics, Competitive Analyst

Business Insights and Intelligence Group

Developed and managed databases and analysis for U.S. and global client teams. Heavy usage of SQL Server, MS Access and Excel. Directed Competitive Intelligence projects for major clients and new business pitches. Responsible for creation and harmonization of multiple data sources for modeling projects. Developed in-house turnkey desktop database applications for internal competitive intelligence team and delivered custom monthly extracts from SQL to other team members, using syndicated data sources such as Kantar, Nielsen, SQAD and NetCosts. Leveraged available syndicated consumer demographic and behavioral data such as IPSOS, MRI and Simmons to develop a consumer profiling tool capable of producing an extensive PowerPoint deck in seconds for any demographic segment creatable. Trained digital analytics colleagues on database technique and developed several custom desktop database applications for monthly reporting of digital campaign performance. I have proven that I can develop solutions to data problems where others cannot, and I understand how to use data effectively and with validity.

2002 – 2006 GuideStar Research New York, N.Y.

Database Manager/Research Analyst

Developed and managed databases for annual global client and employee satisfaction surveys of Fortune 100 client. Oversaw sensitive global email questionnaire campaigns in multiple languages. Managed response rates, reminders, incentives, and data quality control. Prepared results for analysis, including sample weighting and preparation of reports for client deliverables. Heavy usage of SQL Server, MS Access, Excel and SPSS to prepare data sets for online reporting engines including a scorecard production system for client CRMs.

1997 – 2001 Jupiter Media Metrix New York, N.Y.

Director of Data Services, Data Research and Insights Group

Managed executive surveys and assisted in the development of AdSpend, one of the very first efforts to measure digital display advertising expenditures.

1993 – 1997 Price Waterhouse, LLP New York, N.Y.

Senior Consultant, Law Firm and Law Department Consulting Group

1991 – 1993 Ernst and Young, LLP New York, N.Y.

Manager of Information Services, Legal Consulting Group

Education

BA Degree State University of New York at Albany