Manager Sales

Arun Kumar Rajan, GA CPA

*** ********* ***, ********, ** - 30060

(Home) 770-***-****, 770-***-**** (Mob) 404-***-****

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

OBJECTIVE:

• A systems savvy Senior Accountant/Analyst (licensed GA CPA) looking for an Accounting or Finance

Managerial position that will utilize both technical accounting and varied system skills where 6-7

years of experience will help to be a major impact player in driving organization’s financial goals.

SKILLS SUMMARY:

• Strong varied technical accounting skill set – General Ledger, Financial Analysis, Revenue

Recognition, Financial Reporting, Fixed Assets, Treasury, Project Accounting, Internal Audit from

manufacturing, healthcare, financial services, software, security & nuclear industries

• International work experience

• Strong software skills – experience and education

• Process automation initiatives through MS Excel and Access

PROFESSIONAL EXPERIENCE:

Crif Corporation, Atlanta, GA (08/2010 to present)

A large Italian banking & financial services software solutions and credit reporting company. $275 million

revenue. 1,000 employees. Reporting to International Accounting Manager.

SENIOR ACCOUNTANT

• Responsible for the full cycle accounting and monthly financial close for a business unit – General

Ledger, Financial Reporting, Financial Analysis, Accounts Payable, Accounts Receivable, travel

expense re-imbursements and bank reconciliations using SAP.

• Make sure that software revenue recognition is according to US GAAP – SOP 97 rules:

o Assess whether 100% VSOE is complete for all software elements.

o Make sure the customer invoices and revenue recognition is according to the financial terms

of customer agreements.

o Make sure the recognition rule differences between “transfer of software” and “ASP” is

reflected in the customer invoices and relevant revenue and deferred G/L accounts.

o Prepare a detailed reconciliation of different revenue streams, revenue amortization and

deferred revenue ending liability categorized by customer record.

o Perform a monthly revenue analysis for each revenue stream and identify any deferred

adjustments if necessary.

• Provide analytical support (revenue and expense forecasts) to the Controller during annual budget

preparation.

• Provide detailed revenue analysis to the Controller during monthly review of financial statements.

• Provide financial support to the Sales & Marketing team, BU Controller & other operational

personnel.

• Prepare schedules & backup data to external auditors during their field testing (including revenue,

disbursements, fixed assets and receipts) operations.

• Participate in continuous improvement initiatives of accounting department procedures in order to

exceed service expectations from internal and external customers.

• Develop strong working relationships with customers and vendors from a finance perspective.

Infinitum, Atlanta, GA (03/2007 to 08/2010)

Consulting company specializing in finance and information systems. $2.5million revenue. 20 employees

SENIOR ACCOUNTING ANALYST

Clients served:

• Niscayah USA, Duluth, GA (US division of Swedish Commercial Security solutions provider.

$85million revenue, 700 employees)

• Greg Erbs CPA, Cumming, GA (CPA firm that offers financial, tax preparation, human resource and

consulting services to small businesses)

• Kobelco Construction Machinery America, Calhoun, GA (Manufacturer of large construction

equipment, majority-owned subsidiary of CNH. $50million revenue. 150 employees.)

Page 1 of 4

Arun Kumar Rajan

• Crane Nuclear, Kennesaw, GA (Division of Crane Co, Leading provider of valve refurbishment

services and diagnostic testing equipment for domestic and international nuclear power plants.

$32million revenue, 80 employees.)

• Lasercraft, Norcross, GA (UK owned manufacturer and distributor of red light camera and speed

enforcement systems. $12million revenue, 115 employees.)

Duties:

• General Ledger

o Responsible for all the standard monthly journals, balance sheet reconciliations (AP, AR,

Inventory, Cash, Fixed Assets, Payroll Liabilities, 401K Liabilities, Commissions,

Prepayments, WIP, Other AP Accruals, Inter-company Receivable/Payable, Capital Vehicle

Lease, Goodwill on acquisition, Insurance Liabilities, Deferred Revenue) and inter-company

tie-out with domestic and international sister entities.

o Assist in resolving complex reconciliation issues in areas of revenue recognition, sales & use

tax and fixed assets.

o Balance tie out and data validation between HFM and AS400 Global/Great Plains & FRx.

o Active participant of month-end close periods (financial statement preparation, review &

analysis and reporting) ranging from two to five days.

o Identify GL code maintenance issues and communicate with IT.

• Financial Reporting

o Prepare monthly, quarterly and yearly financial reporting packages from Hyperion

Enterprise, Retrieve and HFM using HPVAL function to extract data from Hyperion into

Excel.

o Prepare/Update supporting schedules and collate financial and non-financial metrics

information from various data sources.

o Modify reports in FRx, Cognos BI and Hyperion Retrieve for internal management reporting.

o Assist in validation of SQL/ Cognos BI financial reports created by IT by researching data

samples.

o Participate in financial reporting decisions to ensure compliance with US GAAP ( recognize

revenue vs deferral, expense vs capitalize, balance sheet classification decisions etc.

• Fixed Assets

o Record fixed asset additions, updates and retirements in Great Plains, Asset Keeper & FAS.

o Prepare Fixed Asset roll forwards and reconciliations.

o Perform annual fixed assets audit.

o Perform Project cost & CAPEX tracking.

• Financial Planning & Analysis

o Assist Accounting Manager/Controller/VP Finance in month-end financial analysis process.

Assist in variance analysis of P&L - actual versus budget and prior period.

Perform gross margin/contribution analysis for a division and explain

inconsistencies.

Answer questions from operational management regarding their division financials.

Prepare ad hoc analyses and schedules for monthly management financials review

in MS Excel by extracting data from various sources (such as accounting sub ledger

modules, BI reporting software etc).

o Assist Controller/VP Finance in budgeting/forecasting process.

Assist in preparation of quarterly and 15 month financial forecast.

Prepare analyses and schedules to justify budget numbers and assumptions.

Update budget/forecast work paper templates using automated data extraction

techniques in Excel.

Categorize budget/forecast numbers by product line based on projected business

scenarios.

o Assist in the preparation of monthly balanced scorecard and KPI’s for executive

management review.

o Assist in project accounting analysis.

• Internal Audit

o Verify accuracy of payroll changes made in People Soft.

o Monitor shipping cutoff and periodic inventory cycle counts.

Page 2 of 4

Arun Kumar Rajan

o Annual update of Sarbanes-Oxley narratives and Internal Control Assessments.

o Review sales & bookings data for accuracy.

• Code invoices for Accounts Payable.

• Prepare schedules for annual/interim external audit and answer auditors’ questions.

• Inventory – monitor inventory acquisitions by operations from a financial perspective.

• Serve as backup for Payroll function.

• Prepare Annual Personal Property Tax Return.

• Prepare Annual Royalty calculation.

Accomplishments:

• Modified financial reporting package using OFFSET and VLOOKUP functions to streamline the data

extraction process resulting in time savings.

• Enhanced the template for depreciation forecasting using DATE based Excel formulae.

• Rewrote and improved detailed procedure documentation for the Accountant responsibilities –

month-end related, weekly and yearly.

• Created a new template for balance sheet reconciliations to make it easier to resolve discrepancies.

• Successfully researched and cleared old reconciling items in the 401K balance sheet liability

accounts.

• Created a process to reconcile sales tax between general ledger and external tax software resulting

in a better understanding of the discrepancies, liaised with IT in order to create a manual adjustment

file to ensure better compliance.

• Successfully researched and cleared outstanding post-acquisition opening payroll balances resulting

in a $20,000 credit to the Income Statement.

• Used Excel Macros & VBA to standardize data capture of branch level contract portfolio sales and

order data and consolidation to the region/area level.

Goodman Fielder, Auckland, New Zealand (08/2005 to 01/2007)

Second largest public fresh and convenience food manufacturing and distribution company in Australia &

New Zealand. Approximately $US1billion revenue, 3,000 employees. Reported to the Dairy Financial

Accounting Manager.

STAFF ACCOUNTANT

• Treasury – Prepare daily, weekly and 3 month cash flow forecasts (both inflow and outflow), monthly

foreign currency payments forecasts and perform daily cash management for Dairy and Baking

divisions.

• Financial Analysis - Prepare inventory and other ad-hoc financial analyses and reports for senior

management.

• General Ledger – Prepare monthly journals, selected balance sheet (Other AP Accrual, General

Suspense, Prepayments, Intercompany) and bank (including foreign currency) reconciliations,

actively participate in financial statement review and research.

• Tax – Provide information for calculation of provisional corporate tax, consolidate sales tax and fringe

benefit tax returns.

• Answer queries from Accounts Payable, Accounts Receivable and Payroll.

• Assist in yearly/interim external audit.

Accomplishments:

• Streamlined the process for daily cash flow and foreign currency payments forecasting resulting in a

daily non-adverse cash position and minimal exposure to foreign exchange risk respectively.

• Successfully completed the GL mapping project related to the SAP implementation project resulting

in smooth transition from old to new GL codes.

• Created a process to perform an inter-company receivable and revenue reconciliation.

• Successfully completed the invoice separation (freight, vehicle lease, gas card and cell phone

invoices) project related to business restructure to ensure expense allocation to the appropriate legal

entity using VLOOKUP and TEXT (MID & SEARCH) based functions.

North Shore Hospital, Auckland, New Zealand (02/2004 to 08/2005)

Public secondary healthcare provider in North Auckland. 293 beds, 1,000 employees. Reported to the

Finance

Manager within hospital management.

JUNIOR FINANCIAL ANALYST

Page 3 of 4

Arun Kumar Rajan

• Financial Planning and Analysis – analyze financial statements (actual versus budget/forecast and

prior periods), prepare ad hoc financial schedules; assist in budgeting and forecasting, perform

financial review along with nursing managers.

• Balance Sheet Accounting – Maintain and account for the continued medical education (CME)

provision and Work Related Expense (WRE) balance and create A/R invoice requests.

• General Ledger – Prepare the standard monthly journals and selected balance sheet reconciliations

(Other AR Accrual, Other AP Accrual, CME/WRE provision, Prepayments).

• Management Reporting - Assist in the preparation of monthly Health Advisory Council report.

Accomplishments:

• Spearheaded the design of a MS Access database application (table, form, query and report design):

o To create time savings within the nursing bureau division from process automation

o To create a reporting tool for clinical managers.

o To easily extract financial data for the cost charge out purposes.

• Assisted in the creation of a management reporting schedule using a complicated MS Excel formula

(Nested IF) to facilitate effective variance commentary.

• Created a system to maintain and account for the continued medical education (CME) provision

balance resulting in effective monitoring of allowance limits.

• Successfully identified “red flags” in budget excel templates resulting in appropriate allocation of

monthly payroll costs.

EDUCATION:

• MS Finance (part time) Program in Georgia State University (January 2011 till present)

• Georgia CPA License (2010)

• BS – Accounting & Finance (2002) (GPA 3.5) (University Of Auckland, New

Zealand)

• BS - Computer Science & Information Systems (2002) (GPA 3.5) (University Of Auckland, New

Zealand)

TECHNICAL SKILLS:

• MS Office Suite (Word, Excel – VLOOKUPS, PIVOT TABLES, Nested IFs, Text formulas –

MID/LEFT/RIGHT/SEARCH/LEN/TRIM, Text to Columns, DATE, OFFSET, modifying macros using

VBA, charts/graphs; Access – Table & relationships, Queries/Filters, Reports, Forms, PowerPoint,

Outlook

• Accounting software - Oracle, SAP, Great Plains, QAD, AS400 (BPCS, GLOBAL, Friedman & E-

PARTS); Peachtree, MYOB (similar to QuickBooks), Asset Keeper, FAS, PeopleSoft HR

• Financial Reporting software - FRx, Cognos BI, Hyperion Enterprise, Hyperion Financial

Management, Hyperion Retrieve, FFARS (Customized based on VB .Net), Upstream

Page 4 of 4

Arun Kumar Rajan

Contact this candidate