Sales Analyst

Mark H. Lov

**** ***** ******* *****

Mount Prospect, Illinois 60056

Home: 847-***-****

Cell: 847-***-****

Email: *****@*****.***

SUMMARY

Highly motivated business professional with twelve years of work experience

in information technology and finance positions. Analytical logic based

individual valued by multiple managers and internal customers for

commitment of tasks/projects. Recognized areas of strength include the

followings: SAP FI/CO module, Business Objects, BrioQuery and Cognos BI

support, website and database development, business and root cause

analysis, financial reporting and modeling, budgeting, forecasting and

month-end processes.

WORK EXPERIENCE

Allstate Insurance Company, Northbrook, Illinois

June 2010 - July 2010

Senior Financial Analyst/Contractor (Contract/Temporary Assignment)

. Prepared month-end and quarter-end GAAP reporting for Allstate

Investments

. Utilized Access and MicroStategy databases to create queries to summarize

large amounts of data

Banco Popular North America, Inc., Rosemont, Illinois

January 2010 - June 2010

Financial Systems Analyst/Contractor (Contract/Temporary Assignment)

. Utilized Cognos BI software to load and consolidate monthly Profit & Loss

statement and Balance Sheet

. Summarized and reported business metrics for monthly reporting process

. Created reports for third party incentive processing, including fund

transfer pricing, balance sheet and income statement data loads

. Assisted and participated in external vendor meetings and act as liaison

between Finance and IT departments

Beam Global Spirits & Wine, Deerfield, IL

September 2009 - January 2010

Senior Financial Analyst/Contractor (Contract/Temporary Assignment)

. Utilized SAP to track expenses for Maker's Mark Marketing and Field Sales

to ensure spending is within budget plan

. Redirected $200K in budget for the Sales Department to invest in other

spending program that benefited the company

. Utilized EssBase to develop, maintain, and analyze monthly Brand Review

presentations for management

. Provided financial reporting and analysis for Maker's Mark Marketing

Brand on related project budget spending

Discover Financial Services, Riverwoods, IL

September 2008 - April 2009

Consultant/Contractor, Diners Club International (Contract/Temporary

Assignment)

. Provided administration and operation of GlobalNet web-based reporting

system for 250+ worldwide users

. Developed Executive Dashboard for Senior Management and prepared Business

Information Reports (BIR) by Franchises worldwide

. Prepared monthly financial reports and provided analytical commentaries

of Franchises profit before taxes

. Identified data defects and gaps, followed up with customers on data

issues, monitoring franchise compliances with reporting requirements and

resolving problems

. Documented requirements for Business Technology (BT) as well as

interfaced and developed relationships with BT community

Takeda Pharmaceuticals North America, Inc., Deerfield, Illinois

December 2007 - August 2008

Senior Financial Systems Analyst

. Provided full support of SAP FI/CO module for the Finance organization

such as maintaining master data, configure realignment of Cost Centers,

General Ledger Accounting, Profit Center Accounting, Fixed Assets, Chart

of Accounts, Internal Orders, Consolidations

. Provided end-user support of ImageNow Software including administration,

user setup, troubleshoot issues from users

. Served as liaison between Information Technology and Finance organization

to resolve trouble tickets and systems issues

. Documented step-by-step SAP and other systems procedures for the business

to utilize

. Facilitated meetings among Finance Leadership to prioritize systems-

related projects and communicated to IT business partner

. Identified and resolved discrepancies in actual transactions in SAP

versus plan and informed Accounting to initiate correcting entries

Accomplishments: Received two commitment awards - Fixed Assets project for

the Tax Department and implementation of ImageNow Software for the Accounts

Payable Department.

W.W. Grainger, Inc., Lake Forest, Illinois

August 2003 - November 2007

Information Analyst, Enterprise Information Management (October 2006 -

November 2007)

. Prepared and analyzed monthly metrics to track Enterprise systems

performances

. Developed and maintained Enterprise Information and Records Management

intranet websites

. Provided InSight database administration such as support for new users,

troubleshooting, and maintenance

. Utilized BackOffice to generate ad-hoc reports to support other areas of

the business

Accomplishment: Developed first-ever online Virtual Museum of company's

rich history

Business Process Analyst, Branch Services (February 2005 - September 2006)

. Interacted with internal business partners to gather requirements and

wrote queries to help implement the functionality of SAP BW

. Provided weekly Price Compliance reports to management and the field to

reduce gross profit gap - this initiative helped achieving a $15MM year-

end cost saving

. Prepared and analyzed monthly Perfect Order measures to track Branch

Services performances

. Provided Senior Management monthly commentaries supporting Order Accuracy

and Invoice Accuracy measures

. Interacted with the Point of First Contact Team to understand business

insights

. Utilized MS Access, Business Objects and SAP Business Warehouse system to

analyze and establish metrics

. Prepared BW Query Specifications and created queries in development

. Developed annual sales goal setting and provided monthly goal adjustments

for over 400 branches

Accomplishment: Helped saved the company $15MM as a result of being part

of a cross functional team project called Price Overrides.

Database Sales Analyst, Parts Division (August 2003 - January 2005)

. Wrote reports that included analysis, comprehensive charts, narrative

with viewpoints of marketing campaign results

. Supported Sales, Marketing, and Product Management Departments with ad

hoc and monthly reporting

. Utilized Brio Query & Business Objects to generate monthly reporting and

project requests for Senior Leadership

. Provided database analysis of customers and suppliers that were driving

monthly sales performance

. Developed and executed production extracts and maintained user-friendly

interactive sales tools for field sales

. Reviewed data integrity, advised and recommended decision makers on

results of information

Caremark, Inc., Northbrook, Illinois January

2001 - April 2003

Financial Analyst, Specialty Pharmacy Services Finance

. Prepared daily sales report for all Specialty and Hemophilia business

revenue, SGP, and orders shipped

. Prepared monthly reporting package for all Specialty pharmacies and

answered all inquiries concerning reports

. Implemented first-ever monthly sales reporting package for Specialty

sales forces

. Utilized SAP G/L Systems for month-end close process and researched

variances on monthly expense analysis

. Analyzed monthly actual, budget, forecast expenses for accuracy and

provided variances explanation

. Utilized Hyperion software to load and consolidate revenue, cost of goods

sold, orders which impact P&L statement

Accomplishment: Received manager's award for implementing first-ever

reporting package for Specialty Pharmacy Sales Force.

Automatic Data Processing, Inc., Elk Grove Village, Illinois

July 2000 - December 2000

Financial Analyst, National Accounting Department

. Prepared monthly variance analysis by comparing actual-to-plan and actual-

to-forecast in various business units

. Performed monthly financial closing and determine explanation for

favorable/unfavorable variances

. Responsible in preparation of monthly close and forecast package for

management

. Interacted with departmental management regarding hiring, termination,

and salaries for forecasting purposes

. Utilized EssBase for forecast modeling and Oracle G/L Systems for payable

invoices and general ledger posting

Scott Foresman, Glenview, Illinois

September 1998 - July 2000

Financial Analyst, Finance Department / Business Analyst, Sales

Administration Department

. Prepared daily sales report including backorders and open orders by

region through the use of Actuate Viewer system

. Analyzed year-to-date actual and budget to explain favorable/unfavorable

variances to VP Finance

. Utilized SAP general ledger and Hyperion software systems for month-end

close, and prepare monthly expense reports

. Developed trended revenue forecasts, annual budgets and quarterly

forecast

Bank of America, Chicago, Illinois January

1997 - August 1998

Collateral Analyst, Asset-Based Lending Department

. Performed collateral analysis and determined eligible borrowing base on

assigned portfolios

. Analyzed borrower's collateral performance, standard credit memorandums,

historical trends, industry changes

. Interacted with clients, portfolio officers, relationship managers, and

field examiners regarding clients' collateral

EDUCATION

DePaul University, Chicago, Illinois

Bachelor of Science - Finance, 1996

COMPUTER SKILLS

SAP FICO Module, SAP Business Warehouse, Brio Query, Business Objects,

GlobalNet, CATS Reflections, Hyperion Enterprise, Hyperion Retrieve,

ImageNow, EssBase, Oracle G/L Systems, InSight Application, Actuate,

Microsoft Access, Word, Excel, FrontPage, PowerPoint, Visio, Automated

Financial System.

Contact this candidate