Sales Financial

Hemant Nayyar

**** **** ***** ***, **** ***

Chicago IL 60612 USA

Ph 801-***-****

************@*****.***

SUMMARY

Superior analytical skills and experience with improving profit through

detailed transactional and workflow analysis. This is collaborated

effectively with business managers of different departments to resolve

variance and refine forecasts. Excellent communication skills with

expertise in the following areas:

. Financial Modeling

. Budgeting & Planning

. Inventory Management

. Revenue Forecasting

. Trends Analysis

. Proficient in Excel (V-lookup, H-Lookup, Macro, Pivot tables)

EXPERIENCE

Tribune Company Chicago, IL

Sr. Financial Analyst 2010-2011

. Created consolidated financial models and system of performance

metrics; streamlining multiple pre-existing models into a dashboard tool

for the purposes of identifying and quantifying issues relating to various

supply chain and distribution inefficiencies

. Conducted trends analysis and revenue/expense forecasts for several

departments, working closely with senior management to provide executive-

level decision making support through reporting of operational and

financial results

. Presented results and provided my recommendations for optimizing

processes, increasing cost efficiencies, and improving workflows within

corporate M&D by introducing new reporting and due diligence concepts

Sr. Financial Consultant Chicago, IL

(ULDQS Inc, Utilities Inc, Wolters Kluwer)

2008-2010

. Utilized SQL to reconcile G/L balances and resolve variances during

system conversion from People soft to JD Edwards.

. Designed a flow chart for policy and procedures to successfully

reduce the month-end process from 20th day to 6th business day.

. Implemented AP policy to reduce redundancy of duplicate payment by

20%.

. Prepared annual financial report schedules for 45 entities adhering

to the SEC guidelines.

. Implemented Account Receivable tests in compliance with SOX.

Univision Communication

Chicago, IL

Accounting Manager 2006-2008

. Assisted in annual budget exceeding $20 million and forecast models

on a departmental, business segment, and consolidated basis working with

functional department head and senior management.

. Assisted in monthly closing by preparing accurate accounting entries

in compliance with SOx and internal audit recommendations.

. consolidated the financial statements of four radio stations into one

complete financial statement.

. Resolved accounting system issues by overseeing successful transfer

from Great Plains system to Oracle accounting system as a special project.

. Prepared appropriate weekly pacing analysis sales report comparing

current weekly revenue with actual budget and analyzing trend with prior

years.

. Analyzed and interpreted monthly variance trends between budgets,

actual and prior results in developing projections and forecasts.

. Trained new employees to administer the accounts payable and order

entry functions.

. Conducted ad hoc strategic analyses of business performance as part

of business development process.

Fat Pipe Networks Salt Lake City, UT

Sr. Financial Analyst 2003-2006

. Managed financial budget of $15M for Finance, R and D, Human

Resources, and Legal IT groups and provided financial reporting and

analysis to Senior Directors.

. Built and maintained Excel-based financial models, including income

statements, balance sheets, cash flow statements, and discount cash flow

analysis.

. Analyzed financial results to determine accuracy and completeness of

information, financial forecasting, and planning to support short-term,

and long-term strategic plan.

. Conducted cost benefits analysis to determine inventory overhead,

resulting in 35% reduction of capital expenditure.

. Created NPV, IRR, discount cash flow, and ROI models for evaluating

financial implications of new products and investments, and provided

recommendations to Senior Directors.

. Responsible for calculating monthly-deferred income, monthly sales

commission report, monthly and quarterly royalty reports.

. Provided financial support and analysis to marketing and sales areas

for strategic business decision and cost saving initiatives.

XO Communication Salt Lake City, UT

Senior Accountant 2000-2003

. Responsible for preparing and auditing journal entries during monthly

closing process, and reconciliation of general ledger accounts.

. As a team leader of 10 AP associates, responsible for mentoring,

coaching, and implementing procedures to reduce duplicates by 20%.

. Conducted monthly vendor reconciliation.

. Managed vendor issues concerning billing and customer related issues.

EDUCATION

University of Utah David Eccles School of Business 1995-2000

Salt Lake City, UT

Bachelor of Science in Finance

Currently in process for sitting for the CPA Exam

Office Tools MS Word, MS PowerPoint, MS Excel,

MS Project

Accounting Tools and Software Oracle financial, Great Plain

software, Microsoft Dynamics,

MYOB Premier Accounting, Crystal

reports, Hyperion, Marketron,

Operating Systems Windows 98/2000/XP

Databases MS Access, SQL Server 2000 and

Oracle 9i/8

Contact this candidate