john d. tatom
Schaumburg, IL **193
Residence: 847-***-****
abmftj@r.postjobfree.com
Qualifications Summary
Analyst with an MBA from a top-tier business school, Indiana University's
Kelley School of Business. Strengths include conducting research and
analysis, data interpretation, problem solving, and data coordination and
organization. Works well individually and contributes effectively to team
goals. Always strive to understand and exceed expectations.
PROFESSIONAL EXPERIENCE
UNITED STATIONERS SUPPLY CO., Deerfield, IL, 2006 to 2009
Wholesale distributor of office products, furniture and other goods with
annual sales of plus $8 billion.
Sales Project Analyst
Delivered over eighty monthly reports and multiple ad hoc requests in
support of national account clients with sales exceeding $1 billion
annually.
. Produced accurate, detailed data reports per the requestor's
specifications resulting in better understanding of account behavior thus
enabling better customer service moving forward.
. Created complex Excel model for capturing freight billing, resulting in
monthly average billings of $5 to $10 thousand dollars.
. Applied business knowledge to complete reports and projects used to
determine pricing, credits and rebates thus directly impacting company's
bottom line by maintaining margins, reducing credits and increasing
rebates paid.
. Transitioned reporting from legacy software application (Focus) to newer
Oracle application (Hyperion) resulting in greater efficiency in report
writing.
focused health solutions, Deerfield, IL, 2004 to 2006
Chronic disease management firm serving Fortune 500 companies such as
Toyota in a $1.2 billion industry that continues to grow as companies look
for ways to cut employee medical costs.
Data Analyst
Accountable for the retention of a portfolio of existing clients and
assessing prospective clients through medical claims data collection,
analysis and report writing.
. Managed and lead quarterly reporting and financial savings analysis as
required by contractual agreements. Reports were well received and often
cited as reason client opted to retain Focused Health Solutions as their
chronic disease management provider.
. Assessed prospective client medical claims data in response to sales
staff request for service proposals; data analysis and written reports
frequently resulted in the addition of new clients seeking to engage firm
as their chronic disease management provider.
John Tatom Page 2
Residence: 847-***-****
abmftj@r.postjobfree.com
Peoples energy services, Chicago, IL, 2003 to 2004
Natural gas and electric service provider to Chicago area private
residences and businesses.
Pricing Analyst
Responsible for service bids for electrical service product offerings.
. Handled hundreds of weekly bid requests for service in a timely, prompt,
efficient manner resulting in significant growth of customer base for
electrical services.
. Maintained and organized data for various internal and regulatory reports
thus keeping firm in compliance with laws regulating the sale of
electricity in Illinois.
. Performed special projects as assigned - testing of software upgrades
resulting in quicker turnaround of electrical bids going out to
prospective customers.
boise office solutions / now OFFICEMAX, Naperville, IL, 2000 to 2003
The number three office products retailer in North America with yearly
sales exceeding $9 billion.
Sales / Marketing Analyst
Developed and maintained sales, credit and rebate reporting for a large and
diverse group of clients. Worked closely with field sales staff to provide
pricing data, analysis and reports for new customer bids and for sustaining
existing customer relationships.
. Managed and improved vendor rebate process resulting in a $1.1 million
annual increase in rebates paid to company. Documented process, trained
and mentored accounting staff on process and transferred rebate
responsibility to accounting group over a period of several months.
. Built an Excel based sales promotion pricing tool for field sales staff
as part sales incentive contest. Tool was put into use and resulted in
new accounts and additional revenue for company.
. Wrote ad hoc reports providing pricing information and analytical support
to account teams thus winning new business accounts including McDonald's.
Additional Experience
Roles include Research Analyst (1997- 1999) at Information Resources Inc.
and Contractor (1996) at Ameritech Corporation. The Pampered Chef (2010)
as a Sales and Promotions Analyst.
computer skills
. Oracle's Hyperion Business Analysis Tools - Cognos ReportNet, Discover
. Mainframe, Data Warehouse
. MS Office Skills - Excel, Access, Power Point, Word, Outlook
EDUCATION
Six Sigma Greenbelt Training - Chicago Deming Assn. - Six Sigma Masters
Program, Naperville, IL, 2009
MBA, Business Administration, Indiana University, Bloomington, IN, 1996
BS, Liberal Arts / Biology, Northern Illinois University, Dekalb, IL, 1980