High School Analyst

Chad H. Smathers

740-***-**** ● **********@*******.*** ● 522 E. Main St., Hebron, Ohio 43025

Technical Reporting Developer / Business Analyst/Data Analyst

Skilled, dynamic IT Professional is seeking new challenges using my previous experience in Business

Analysis or Technical Reporting. The majority of my experience comes from creating reports and

developing strategies in order to raise productivity.

Education

1997- Bachelors of Arts in History and Political Science (double major)

Bowling Green State University, Bowling Green, Ohio

2013(estimate)- Currently working toward a Bachelor of Science in Computer Science

at Franklin University, Columbus, Ohio

Training/Technical Experience

Crystal Reports versions 9 through 2008 - advanced reporting design and techniques. (8 years

experience)

Business Objects Enterprise XI R2 – deployment, application administration, and user

administration

Business Objects XI R2 Universe Design

Business Objects Web and Desktop Intelligence (XI R2 & R3) – design and report techniques

Business Objects Dashboard Design (XI R2)

Crystal Xcelsius

Experience in SQL Commands for Crystal Reports and in SQL Analysis

Experience in designing and implementing SQL Queries for reporting purposes

Remedy Ticket Tracking Systems

Currently studying project management principles and processes to eventually get PMP

certification

The McGraw Hill Institute Business Analysis Certification – includes Business Analysis,

Communication, Finance Analysis, and Presentation training

SDI Help Desk Analyst Certification

Work History:

Business Intelligence Analyst, DSW Inc, April 2009 to May 2009

(Consultant position via Softworld Inc)

Converted a complex multi level, multi query store sales report from the Microstrategy

Reporting tool to Crystal Reports 2008 from Teradata Databases.

Report displayed four levels of sales metrics (day, week to date, month to date, year to date) by

Chain, Region, District, and Store

Used multiple techniques of pulling data via multiple queries from a Universe and multiple

SQL Command queries

Faithfully duplicated exact formatting from old report

Chad H. Smathers Page 2

Work History continued:

The McGraw-Hill Companies, January 1999- November 2008

Business Analyst, McGraw-Hill Corporate, May 2004 - November 2008

Gathered required information for requested reports, built reports based on those requests, and

provided analysis on those reports.

Developed foundation and procedures for enterprise reporting for McGraw-Hill Global

Operations and Infrastructure

Designed, delivered, and maintained business reporting of key performance indicators for

McGraw-Hill Global Operations and Infrastructure and their outsourcing partners.

Managed a team of 2 other consultants in day to day enterprise reporting operations and

development.

As a result of my teams reporting on outsourcing performance, these reports saved the company

over $200,000+ monthly.

Deployed and administered an instance of Business Objects XI R2

Set up Crystal Reports Database Access standards and procedures for company access to

primary ticket tracking database

Gained experience in the use of SharePoint and Access.

Help Desk Analyst, McGraw-Hill Corporate, January 2003 - May 2004

Provided remote technical support for McGraw-Hill Corporate functions which included using

Active Directory for password resets and account maintenance, VPN Remote Client assistance,

Windows XP and Mac Operating System Support, preliminary PC hardware support,

LAN/WAN network troubleshooting, Corporate Application password resets, Accounts Payable

account assistance.

Established regular reporting and metrics for the help desk

Help Desk Analyst, McGraw Hill Education, March 2001- January 2003

Provided remote and direct technical support for the Midwest locations of the McGraw-Hill

Education segment Applications and PC Support which included password resets on various

systems, and support for IMDS, OPIM, and Oracle applications.

Computer Operator, McGraw-Hill Education, January 1999- March 2001

Maintained and troubleshot key McGraw-Hill Education Mainframe systems, and printed and

distributed daily reports and labels for the warehouse.

Instructor, Advanced Learning Labs, May 1998 - September 1998

Taught operating systems and office applications to government and corporate users.

Computer Lab Technician, Blanchester High School, September 1997 - May 1998

Maintained and monitored usage of high school computer lab, and assisted students and staff

with computer issues and applications.

Contact this candidate