William G. Urankar
**** ******** **** ( South Euclid, OH 44121 216-***-**** (
ablxdr@r.postjobfree.com
CAREER OBJECTIVE
Seeking an analyst or accountant position to support the financial and
technical needs of a
proven growth organization. Performing financial reporting, general
accounting duties, and data system improvements. Capable of adding value
to a business by adapting financial software to specific needs.
SYSTEMS / SKILLS
QuickBooks Pro 2008, MS Great Plains, Fixed Assets, MS Excel (Vista( 2000)
Extensive use of MS Excel, MS Access, MS Word, and MS Outlook
Excel functions: Data imports & exports, charts & graphs, creating formulas
PLATFORMS: Windows Vista & XP/2000, SQL-base platform, AS/400
EDUCATION and CERTIFICATIONS
Bachelors of Science in Business Administration, Major in Accounting,
Xavier University, Cincinnati, OH
Database Management Courses taken in Graduate Studies at John Carroll
University
PROFESSIONAL EXPERIENCE
COMPLETE DATA CORPORATION, Shaker Heights, OH Feb. 2008 _ May, 2009
Staff Accountant/ Payroll Administrator/ Tech Support
. Setting-up three divisions of Complete Data Corp. in QuickBooks Pro
2008 accounting software.
Customizing the Charts of Accounts, entering expenses in QB relating to
each respective account.
. Processing Accounts Payable for vendors & tax regulatory agencies, and
remitting on a timely basis.
Supporting all accounting functions of the Development & LLC divisions,
along with President's personal account. Preparing P & L
statements and the financial data needed to produce Tax returns.
. Performing all payroll functions as the Payroll Administrator of
Complete Data. The set-up of company payroll tax
accounts, and processing of payroll for employees paid on a bi-weekly
basis.
Releasing payments to software developers who produce code to create
Complete Law software.
INDEPENDENT CONSULTANT
QUICKBOOKS PRO SUPPORT Small Business / Cleveland, OH Jan. 2006 - Dec.
2007
. Providing QuickBooks Pro accounting support for several small business
practices. Extensive use of Accounts
Payable, Receivables, General Ledger, and financial reporting rollouts.
. Proficient with the Premier QB Pro edition offering advanced report
detail and functionality.
THISTLEDOWN RACETRACK / NESCO, Independence, OH
2005
Accounts Payable and Tax Analyst
. Preparing Daily operational reports reflecting all Live and Simulcast
race wagering.
. Recording all respective payments, by using the Accounts Payable module
of
MS Great Plains software used to create checks, and remit on a timely
and accurate basis.
. Preparing tax returns relating to the tax liability owed to the State
of Ohio Tax Department
and fees due to the Ohio State Racing Commission.
. Use of Trackbase data to download all daily racing information needed
to prepare reports.
MORELAND COURTS CONDOMINIUMS, Cleveland, OH 2003
Accountant
. Setting-up QuickBooks Pro accounting software along with the Chart of
Accounts and the
General Ledger with guidance from the General Manager of Moreland
Courts for MCCA.
. Formatting MCCA's annual budget for FY 2003, and customizing reports
using MS Excel.
William G. Urankar
PREMIER RESTAURANT MGMT. CO. LLC, Cleveland, OH 2000 - 2001
Franchisee of the KFC Corporation
Fixed Assets Accountant
. Processing fixed asset additions for 61 franchise locations in Ohio
and Florida.
. Entering all fixed asset additions to reflect book value, asset
category, and useful life of the asset.
. Maintaining Premier's fixed assets database consisting of more than
10,000 acquired assets.
. Preparing the Capital Expenditures report in Excel to reflect capital
additions/ franchise expenses.
. Preparing journal entries to record depreciation expense for 61
franchises on a monthly basis.
. Processing accounts payable for each KFC franchise leaseholder on a
monthly basis.
. Performing month and year-end closing procedures, assembling all
monthly financial statements
for Corporate staff and Regional Managers: Balance Sheet, Profit &
Loss, and Franchise summaries.
MAGNUS EQUIPMENT, Willoughby, OH 1999 - 2000
Systems Accountant
. Processing accounts receivable, creating aging schedules (invoices in
a 30-60-90 days aging format),
and making business-to-business collection calls to arrange payments on
past due accounts. Issuing billing statements on a monthly basis to
customers with outstanding balances.
. Posting daily cash receipts and bank deposits; recording general
journal entries in the ledger.
. Loading laptop systems with MS Office Suite, financial applications,
and upgrading data files
to enable proper use in new software versions. Performing daily back-
ups on network servers.
MASTER BUILDERS, INC., Beachwood, OH 1999
Budget Analyst
. Preparing financial reports in the budgeting department using SAP R/3
(CO-module).
. Summarizing monthly and quarterly budget totals of product line data
at the division level
of Master Builders. Report reflects variance levels between actual
and budgeted production.
. Using reporting tools in SAP to export the data needed to produce
financial reports in MS Excel.
KEY CORPORATION, Cleveland, OH 1997 - 1998
Business Analyst
. Performing quality assurance testing of a Point-of-Sale system at Key
Bank, Branch Systems Testing.
. Research and document systems findings with the use of Lotus Notes, MS
Word, and a POS system.
Technical Skills Summary
William G. Urankar
ablxdr@r.postjobfree.com
3818 Fairoaks Road
South Euclid, Oh 44121
Software applications: Maintaining a Fixed Assets database on a SQL-base
platform
Extensive use of MS Excel > 12 yrs. including Data conversions
Using functions: Data imports & exports, sorting & filtering data
data conversions, creating formulas,
Use of MS Access > 5 yrs. creating tables and running queries
Use of an AS/400 platform, Quiz reports, Laptop systems
Proficiency with PC's, desktop, and database concepts:
o Providing Tier-1 Help Desk support relating to DSL connections towards
new customer installations with Windstream Communications, an Internet
service provider. Supporting customers and resolving issues
relating to Broadband internet connection & DSL service.
Extensive use of MS Excel to assemble critical data relating to the
priority of call backs. Jan. 2008
Windstream Communications
o Performing a General Ledger accounting conversion at BP Oil Inc. (Corp
HQ), Pipeline Accounting
Division, converting 30,000 data records to a new financial rollout.
Downloading data from a mainframe platform to the PC level.
Importing all data records to MS Excel, creating spreadsheets to
convert data to a new accounting file format. - Data
Conversion completed prior to BP Oil's migration to Oracle-based
financials.
o Maintaining Premier's fixed assets database of > 10,000 acquired assets
on a SQL-base platform for 61 KFC franchises. Running queries to
produce the financial data needed to generate monthly capital summary
reports used to reflect book and tax valuation.
Sept. 2000- April, 2001
Premier Restaurant Mgmt. Co.
o Supporting a systems upgrade to Windows XP Professional by installing
desktop and laptop systems at BASF Chemical Co. in Beachwood. Adding 60
new Dell computer systems, along with desktop imaging before operation at
the end-user level. Dec. 2007
BASF Chemical Company
o Employed as a Sales Representative of Hewlett-Packard and Olympus product
lines. Providing sales information and demonstrating product features of
HP PhotoSmart printers and Olympus digital cameras on a seasonal basis
in retail settings.
Providing HP Gift Cards to facilitate sales of HP Printers and
accessories.
November, 2006- Dec. 2007
Action Link LLC