Entry Representative Data Analyst

Jason Stromfors

* ****** **.

Pawtucket, RI *****

Phone: 401-***-****

E-mail: **********@*****.***

WORK EXPERIENCE

Table Talk Pies Dec. 2022 – Present

Sr. Pricing Analyst

Table Talk Pies is a Massachusetts based pie manufacturer that runs many top grocery chains’ pie programs across the United States.

Build the cost structure of making a pie (material, processing, packaging and freight costs), then account for appreciation, desired margin and any deductions to determine price to provide to potential new business in the bid process

Formulate weekly dashboard to provide to leadership on the state of business historically, currently and in the future

Enhanced existing pricing model used in establishing pricing for existing and potential new business acquisitions

NextEra Energy Aug. 2022 – Nov. 2022

Sr. Digital Analyst (contract)

Nextera Energy is the world’s largest utility company based in Juno Beach, Fl., focusing on sustainable and reusable energy in the form of solar and wind turbines.

Build and provide reports on social media feedback (Facebook) and email campaigns

Expand current reporting capabilities in a new department utilizing Power BI, Sprinklr and Adobe Analytics

Present findings to departmental leads

BJ’s Wholesale Club, Inc. Feb. 2012 – June 2022

Sr. Digital Analyst

BJ’s Wholesale Club is a wholesale retail club chain with 210 + brick-and-mortar stores on the East coast and strong digital presence offering members discounted prices on wide assortment of retail products.

Developed, coded, and delivered buyer, internal departmental and cross-executive level operational/sales reporting

Utilized Cognos, Tableau, SQL, and Google Analytics in creating automated operational/sales reporting

Provided various analytical reports mostly surrounding week-over-week/ month-over-month and year-over year comps

Tracked site traffic/sales via Google Analytics to determine effectiveness of marketing efforts

Worked with IT department on develop back-end Tableau packages / data marts for digital reporting purposes

Troubleshooted any data issues accessing back-end systems flowing into Tableau packages

Provided inter-departmental ad hoc reporting

Worked independently across multiple departments

Adecco Staffing Aug. 2011 – December 2011

Contractor / Data Analyst

Adecco is a staffing company placing consultants into their clients’ workplace to work on various IT / marketing projects.

PartyLite International

Consolidating data into centralized CRM system

Working with vendor and internal departments to set up marketing and sales reporting environment

Creating standard reports to reflect campaign and sales results

Establishing target audiences for marketing campaigns

Educating departments on best practices in utilizing the new CRM system

Sapphire Technologies LLC Nov. 2010 - March 2011

Contractor / Data Analyst

Sapphire Technologies is an IT contracting firm that does outplacement for marketing/IT professionals.

Putnam Investments

Aided in creating reporting environment for organization’s marketing and sales department

Created customized marketing and sales reports utilizing Business Objects and Cognos reporting tools

Worked with internal departments and “crm” vendor in automating a full-circle marketing to sales process

Translated internal marketing/sales reporting requirements to “crm” vendor actionable specs

Advantage Technical Resourcing

Contractor / Data Analyst

EMC Corporation

April 2010 - June 2010

Worked a two month contract helping to roll out a proprietary customer marketing system

Built various automated reports to be utilized by the marketing and sales teams

The Kraft Group/New England Patriots, Foxboro, MA Sept. 2005 – Jan. 2010

Sr. Database Marketing Analyst

Although hired under the New England Patriots business entity, the role included working for all other business entities under The Kraft Group.

•Developed requirements for selection of outsourced database vendor and managed the transition

•Managed all facets of customer database marketing system including coordinating with vendor to ensure database is functional at all times, and handle all troubleshooting efforts

•Was project lead on development of centralized CRM system that incorporated nine different data sources

•75% of responsibilities included analysis of the database and report creation

•Developed reports using CRM system for monthly, tracking, and revenue analysis reports to analyze how their marketing campaigns impacted revenue to determine future marketing strategies

•Responsible for data profile modeling using MS Access and Business Objects. This was done to export data to determine each departments core customer and analyze the data to define marketing strategies and prospects.

•Worked with internal departments on how best to utilize the centralized customer marketing system

•Advised departments on and created targeted lists for various marketing initiatives through the CRM application

•Set up and broadcasted all email communications

•Provided both standardized and customized analytical reports to internal departments based upon requests

•Held monthly meetings with department heads to keep all updated of best marketing practices, marketing trends, email stats and updates concerning the customer marketing system

Direct Alliance Corporation, Tempe, AZ July 2004 – Sept. 2005

Senior Database Marketing Analyst

Direct Alliance Corporation is a sales outsourcing firm that represents several Fortune 500 companies helping them build direct and channel relationships, as well as improving lifetime value of customers.

•Manage database marketing program for external client

•Handle communication between client and internal sales and marketing departments

•Designed and built SQL server marketing database for client to support online, direct mail and email marketing efforts

•Communicate daily with client on utilizing the marketing database for campaigns, customer segmentation and overall data mining

•Develop and distribute campaign and sales analysis reporting for both internal sales/marketing departments and client

•Produce live and daily call reporting for internal call center to track departmental metrics

•Provide and present monthly recency, frequency and monetary analysis giving the client a historical and present trending snapshot of their business

•Administer data processing into marketing database from various data sources

•Set up procedures and processes to insure data integrity is maintained for marketing database

•Work between internal departments, client and external vendors on any database marketing issues relating to the marketing database

•Generate quarterly database reports providing client with detailed status of data currently residing within the marketing database

BOSE CORPORATION, Framingham, MA May 2003 - June 2004

Database Marketing Analyst

Bose Corporation, a private company, manufactures the highest in quality sound systems for everything ranging from home entertainment, automotive, business solutions, to military applications.

•Coordinated all aspects of marketing report development, generation and distribution

Developed campaign response and consumer database analysis reports for cross-divisional departments to access via intranet

•Acted as liaison between Marketing and IT on proper access to databases and functionality of related query and analysis tools

•Worked with marketing executives, program managers, database analysts, marketing associates and associated media vendors to scope out reporting and analytical needs

•Transitioned existing Brio reporting environment to Business Objects reporting environment

Administered Marketing intranet site that provided a single source access to reports, analysis and market research

•Performed weekly audits to tie out data between the centralized consumer database and the multiple divisional databases that fed into it

•Analyzed divisional databases and made recommendations in data quality as they directly affect marketing programs

•Researched and presented data analysis findings and reports to senior executive staff

Cognos Corporation, Burlington, MA Jan. 2000 – Feb. 2003

Database Marketing Analyst

Cognos is a $550M global software company that is the forerunner of the competitive Business Intelligence market.

•Analyzed and measured global marketing campaigns and sales pipelines utilizing Cognos Powerplay / Impromptu reporting tools

•Built multidimensional analytical data models with Cognos Transformer to be used as reporting platforms

•Assisted internal clients in identifying and defining report requirements

•Developed marketing, sales, and database analysis reports for cross-departmental executive teams to track fiscal year goals

•Provided daily ad hoc reporting to North American marketing and sales departments

•Performed weekly analysis of Onyx database to determine status of data integrity for effective marketing

•Coordinated and conducted end user training on best practices use of Onyx database and Cognos reporting software

•Worked between IT, Marketing, and Sales departments to address database utilization issues

EDUCATION

The Pennsylvania State University University Park, PA Jan. 1994

B.A. in Economics

Minor: Business

COMPUTER SKILLS

Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, SQL, Tableau, Cognos, Business Objects, Brio, Onyx, Unica, Goldmine, Salesforce, Axciom Insight, Google Analytics, Adobe Analytics, Coremetrics, Business Intelligence, Data Analysis, Customer Segmentation, Data Mining, Sprinklr

Contact this candidate