Management Sales Representative

Summary:

I have strong global experience in General accounting, Financial Analysis and Data analysis and possess a CPA. Expertise includes solid understanding and application of GAAP Accounting principles, month end closing (I/S & B/S), accrual accounting, account analysis, comparative financial statements, management charts and Executive reporting.

Skills and tools: ERP - SAP FI CO, Oracle financials; PeopleSoft; Advance Excel like V-Look ups, Pivot tables and Macros; MS Access, Hyperion BRIO, MS SQL; MS SharePoint; Visio; Tableau (version 10.1)

Professional Experience

Energizer Personal Care: Shelton, CT (Manufacturers - Schick, Playtex, Banana boat etc.)

Senior Accountant: April 2015 to Nov 2016 (contract)

•Forecasting and Historical reports using Advanced Excel like Vlookup, Pivot table, Macros etc. Ad hoc reports; Month end journal entries; Monthly reports and depreciation, roll forward by individual plants; Ad hoc reports; Monthly CIP budget reports to the management.

•Monthly reconciliations using SAP; Interpret data for balance sheet review. Spending reports

•Work with the internal and external Auditors ( Pwc), Ernst Young on Tax compliance;

• GAAP required reports for external reporting team; SOX documentation for internal audit

•Work with engineers, plant controllers on timely capitalization of asset under construction (CIP) Handle capital budgets for $75M+; Internal controls and policies to comply with GAAP

•Develop data using MS Access. Change management for Data migration to SAP

•Maintain fixed assets schedule in SAP including asset creation, transfers and retirements

for assets around $700M; Monthly Intercompany balances with Europe, Asia and Canada.

Sikorsky: Stratford, CT (Manufacturer of Commercial and Military Aircrafts)

Data Analyst: December 2012 to August 2014 (contract)

•Developed data using MS Access, Hyperion BRIO, Advance Excel, VBA SQL and SAP

•Performed queries for regular and ad hoc reports, cost analysis, man power etc., using SAP

•Charts and reports to the management using advanced excel techniques by center, model.

•Product wise comparative statements, reports and charts to present to the management.

•Weekly and monthly metrics to the management to help with decision making.

•Forecasting and projections of man power requirements by location and by program.

•Management resource planning, budgeting and month end reports to management.

Thor Specialties: Shelton, CT (Manufacturer of biocides, flame retardants & chemicals)

Financial Analyst: August 2012 to December 2012 (contract)

•Provided the management with various comparative revenue and expense reports by customer, geographical area, sales representative, products and other options.

•Analyzed financial statements by month; evaluate data and advice management of any changes or corrections to be made.

•Maintained fixed assets accounts and depreciation schedules and accounts.

•Created budget schedule for various departments and projected income statement and balance sheet for the next year.

•Created financial modeling reports.

United Illuminating Co: Orange, CT (Transmission & distribution of electricity, natural gas)

Financial Analyst: December 2011 to June 2012 (contract)

•Fixed issues and paid over $3M to various suppliers on overdue, disputed, overbilled invoices.

•Effectively communicated with various suppliers to resolve disputes and negotiate payments.

•Worked on transition from PeopleSoft to SAP; Trained employees on SAP AP module.

•Identified and resolved issues with suppliers of Southern CT Gas to expedite payment.

•Acted as a catalyst to process improvements in purchasing and accounts payable by removing backlog and making timely payments to suppliers.

Center Plate: Bridgeport, CT (Entertainment industry – premier concerts and sports)

Finance Specialist: December 2009 to March 2011

•Payroll accounting for around 100 to 125 employees; handled weekly payroll independently.

•Accounts payable; Made timely payments to different Vendors after verification

•Journal entries; Month end close; Maintain prepaid and payable ledgers; account reconciliations; monthly accruals

•Maintained Union dues file. Interpreted data; Maintained payroll database in MS Access

•Handled employee relations and workmen’s compensation; maintain employee Payroll files

United Healthcare: Trumbull, CT (Major health care provider for businesses)

Accountant: June 2008 to July 2009

•Prepared quarterly financial statements (Balance sheet, Income statement, Statement of cash flows, statement of retained earnings) by legal entity, for different states; revenue of $300M to $500M, using ORACLE financials and oracle ADI

•Ensured the accuracy of the financial information provided to the state. Review monthly and quarterly financial reports and statements for completeness and compliance with GAAP.

•Prepared and submitted Management Discussion and Analysis to the states from

•Improved the manual process of financial statement preparation to one that was virtually automated. This considerably reduced the time and effort involved.

•Monthly accrual expense, routine re-class entries using ORACLE financials and reports.

•Detailed aging of claims reserves and claims paid. Prepared aging schedule for receivable

.

Greenwood Publishing Group: Westport, CT (Publisher of books for schools and colleges)

Staff Accountant: March 2006 to May 2008

•Daily reconciliation of cash and sales ledger. Posted daily cash transactions

•Prepared journal entries. Maintained ledgers of certain balance sheet accounts like prepaid expense deferred revenue and receivable; Intercompany balances confirmation

•Involved in month end closing for allocation of expenses, revenue recognition, accrual of expenses, bad debts, amortization, etc.; Prepared monthly aging reports

•Maintained (SOX) Sarbanes-Oxley controls for Journal entries and General Ledger Accounts, decided proper handling of financial transactions and maintained chart of accounts

•Interacted with different department heads and consultants regarding budget and accruals Monthly profitability statements by product line and expense analysis by department

•Monthly Bank Reconciliation and Reconciliation of Royalty Data-Base to General Ledger

Software/Applications

Advance MS Excel, MS Access, Power point, Visio, SQL, Tableau

SAP FICO, Oracle, Hyperion, People soft;

Education

Passed CPA Exam American Institute of Certified Public Accountants

ICWA of India Cost and Management Accountant (Equivalent of CMA)

BS in Accounting & Business University of Madras

Additional

Active member of a voluntary organization that conducts periodic health fair for the uninsured and distributes food for the needy through the evergreen network.

US Citizen.

Contact this candidate