Sales Data

J ulie McStowe

** **** ******, **** *******, MA *2032

508-***-**** • *****.*******@*****.***

Professional Profile

Detail-Oriented Analyst with a reputation for creating automated solutions, juggling multiple tasks, and

meeting deadlines. Broad industry experience includes Manufacturing, Online Media, Healthcare, and

Finance.

Skills

Word, Excel, Access, Minitab, Oracle BI Discoverer, Monarch, DART, Hitbox, Cognos Impromptu

Experience

Hollingsworth & Vose, East Walpole, MA (June 2007 – Current)

Operations Analyst

• Designed and maintained all technical aspects of the Sales, Inventory & Operations Planning process

(SIOP). Built a new Operations database, created automated functionality to streamline

supply/demand process, and in parallel developed a long term balanced capacity plan for 33

machines in 13 global manufacturing facilities

• Executed monthly SIOP cycle, collaborating with Account Managers and Supply Planners on forecast

changes, in order to provide the Senior Lead Team with detailed analysis of capacity issues

• Created a solution for producing a product-level revenue forecast for over 1500 grades, accounting

for nearly $500M in annual sales

• Developed detailed reports for finished goods inventory that helped achieve a 30% reduction or $10M

in inventory

• Implemented an automated process for reporting Raw Material and Energy Spending to drive Cost

vs. Price Squeeze Analysis

• Participated in the Lean Kaizen Event as a Subject Matter Expert for designing a Standard Business

process for the Customer Master Database, effectively improving field accuracy from 25% to 99.6%

• Prepare monthly reports for Finance and Operations to track metrics such as Net Sales, Profitability,

Customer Complaints, Mill Safety, and overall Machine Performance and Efficiency

• Identify data issues in item/recipes and implement solutions to remedy those issues

• Process Owner of Data Governance for our Global Process Standardization Project

• Excel and Access Mentor for Corporate as well as US manufacturing locations

• Recipient of Presidential Award in 2008 for creating SIOP business process capability

TechTarget, Needham, MA (November 2004 - March 2007)

Senior Inventory Analyst

• Managed online inventory of banners, e-newsletters, and white papers across our entire network of

30+ websites

• Utilized a combination of DART and revenue management strategies to predict available inventory,

minimize under-delivery, and maximize revenue

• Analyzed current and historical online ad delivery and traffic patterns on an ongoing basis to identify

inventory trends to ensure campaigns could meet their target number of impressions

• Acted as primary liaison with Sales to approve contracts from an inventory perspective and provided

alternative solutions as needed

• Worked closely with internal departments to determine future inventory needs and to resolve under-

delivering campaigns

EG&G, Cambridge, MA (January 2004 – October 2004)

Data Analyst

• Reviewed FAA lease documents to extract applicable data elements

• Populated, revised, and maintained the FAA lease information management system

• Performed quality control on lease documents using data queries

Tyco Healthcare, Mansfield, MA (June 2003 – January 2004)

Compliance Auditor

• Led the statistical effort of the Operations Six Sigma Project

• Developed a Minitab program to automate statistical analysis on sales, effectively streamlining the

audit process and leading to the quick discovery of customers who were selling supplies not allowed

by contract

• Analyzed buying patterns between medical supply dealers and their end customers to identify trends

and deviations

• Verified that sales data from audit results matched distributor submitted data

Energy Services Group, Pembroke, MA (July 2002 – June 2003)

Production Data Analyst

• Responsible for processing daily production data to and from our clients and trading partners

• Communicated with clients to resolve production data issues and to assist with their requests and

inquires

• Analyzed and tracked data processing errors resulting from invalid client data

Fidelity Investments, Marlboro, MA (February 2001 – June 2002)

Data Analyst

• Updated data retriever tools for critical client information including benefits and withdrawals

• Extracted information from financial files and electronic sources to provide data quality solutions to

clients

• Researched and audited monetary discrepancies as part of ongoing analysis of Defined Benefit plans

• Analyzed data sources to determine error patterns

• Assisted with the preparation of ad hoc benefit calculations

Education and Certifications

• Boston University, May 1999

• B.A. in Pure and Applied Mathematics, Magna Cum Laude

• Recipient of the Elmer B. Mode Memorial Prize for Statistics

• Certificate of Completion: SQL Programming Skills

Keywords

Analyst, Math, Statistics, Excel, Access, MS Windows Office Suite, Reporting, Data Mining, SQL

Contact this candidate