PROFESSIONAL EXPERIENCE

Schneider Electric, Schaumburg, IL October 15 - Current

Financial Analyst

Preparing and analyzing month-end, quarterly, and annual costing and forecasting for the IT function

Building the forecast for all on-going projects, helping the project managers in preparing the project financial plan

Using SAP ERP to retrieve the cost related actual data, and comparing with forecast

Developing an efficient reporting process to confirm and report monthly results, forecast projections, and alignment of project activity

Developing annual budget for several domains, utilized "Plan view" to track overall budget for each domain.

Exercising SAS Costing chargeback tool for intercompany monthly accrual transaction and final invoicing

Applying judgment within defined practices and procedures to recommend appropriate course of action and preparing the business feedback based on financial analysis

collaborating with IT management/project owners/stakeholders to provide complete financial support of projects

Assisting in month-end activities whenever needed

Heavy use of excel (V-lookup, pivot tables) for reports, very good command of SAP Controlling module

Achievement: Complete a new role, there was no forecast process to begin with, started from scratch. Very quick learner who is able to manage multi-billion projects

Astronics Armstrong Aerospace, Itasca, IL February 15 - October 15

Financial Analyst

Analyzed profitability of multi-years projects of different verticals such as NRE-ENG, Cert-Eng, TPED, and MFG

Worked with different project managers to advise the financial status of projects, made suggestions accordingly

Managed all financial aspects of projects from beginning to end

Examined the proposal/quotes for estimated man-hours and sub-contractor’s costs

Calculated WIP, Variances, & Warranty reserves.

Performed variance analysis between actual and estimated, I held myself responsible if it was huge unfavorable variance

worked on implementing different methods of revenue recognition with controller

Reconciled balance sheets accounts, reclassified and prepared some journal entries

Reconciled P/L thoroughly for each of the project in details

Worked with vendors in negotiating the billing rate/terms

Interacted with production department for work in process orders, analyzed cost analysis to find out the material variance

worked on payroll reclassification every month as costs needed to be assigned to specific projects

Performed many tasks of month-end closing procedure and finished closing procedure in 5 working days.

Analyzed 2013-2014 closed projects to calculate profit margin average. It really helped us to revise our rates and margin

Prepared reports for each department managers, performed analysis on their over budget and/or under budget.

Responsible for many month-end activities such as royalty calculation, reconciliation, revenue recognition, WIP, warranty reserves, projects profitability.

Prepared PowerPoint presentation for executives on weekly basis- presentation included summary of new bookings, cash-flow, weekly revenue, comparison between targeted and actual numbers

Achievement: Started work in very challenging time when smaller company (Armstrong) was being bought by public company (Astronics). Company went through many changes including accounting ERP within first 6 months as it became publicly traded. I was actively involved in organizing & changing existing work processes.

Robert Half/Fresenius-Kabi, Chicago, IL November 14 - January 15

Cost Accountant/SAP

Calculated WIP, Variances, COGI errors, and Settle the orders by using SAP Transaction codes.

Performed variance analysis between actual and forecast budgets

Created high level excel reports by using different functionality such as v look-ups, macros, pivot tables and graphs

Reconciled balance sheets accounts, reclassified and prepared some journal entries

Set up prepaid amortization schedule for 2014 and 2015 and recurring entries in SAP

Calculated absorption, and bad batches value

Created PPV summary

Interacted with production department for work in process orders, analyzed cost analysis to find out the material variance

Prepared payroll reclassification every month as there were temp workers in organization and needed the default cost center to be manually changed

Performed many tasks of month-end closing procedure and finished closing procedure in 5 working days.

Calculated daily added value for fill and pack units and asked for the comments from production when it's unfavorable

Audited 2014 fiscal year for prepaid amortization schedule. Audit helped us to amortize prepaid service for prior months as they were missed.

Prepared cost center reports for each department managers, performed analysis on their over budget and/or under budget.

Achievement: Walked into very challenging environment at the end of month and jumped into closing activities. Quickly learned all the areas without any training

Promet Source, Chicago, IL July 14-October 14

Accountant/Finance Manager

Responsible for Accounting, Finance, HR on-boarding process, and General Administrator

Managed complete payroll including 401K benefits and Insurance for full time employees, independent contractors, and international branches.

A/R - handled the complete invoicing for fixed fee contracts, Time & Material contracts, and retainer's support contracts.

Reviewed the P&L, Budget, A/P, A/R aging, and Cash-flow report weekly with CEO and took appropriate actions such as collection, and cutting cost on certain category

Reconciled and posted all the activities for the bank accounts and credit cards as part of the month-end process

Maintained the client database in QuickBooks, Red mine, and Sales force

Reconciled the general ledger accounts including AP, AR on weekly basis

Performed an actual to budget variance analysis

Implemented the forecast process for all the ongoing projects

Performed an inventory reconciliations and assisted in implementing related financial controls

Created and reclassified journal entries for billing and payroll.

Deposited and posted payments utilizing QuickBooks. monitored bank accounts and credit cards on daily basis

Followed up with Employees and contractors as it relates to time entry and expense report

Communicated audit findings by preparing a final report, discussed findings with auditor

Achievement:

Reduced collection debt by more than 45% which improved the cash flow.

SAI Investments LLC, California and Alaska March 12 - April 14

Accountant / Inventory Manager

Managed all aspects of Accounting and Inventory related area, including financial reporting, month-end, quarter-end & year-end close, fixed assets, long-term liabilities, payroll, A/P, and A/R.

Presented financials to controller on monthly and quarterly basis and work collaboratively with the controller to make any further P&L or Balance sheet adjustments.

Handled proprietary inventory management systems for accurate tracking of purchases, stock-control, and production costs. Utilized the software to manage inventory to sales forecasts. Created SQL queries to build customized reports.

Prepared, reviewed, and distributed payroll to more than 200 hourly employees’ bi-monthly. Prepared trend analysis of total labor cost while also analyzing labor cost margin.

Created quarterly Sales tax reports, quarterly contribution wage report, 941, W2, W3, and 1099. Upon completion of the reports, distribute to employees, IRS, Social security administration, and State.

Monitored A/P and A/R process for all company G/L transactions through utilization of QuickBooks and Excel. Established an efficient reconciliation process which uncovered numerous vendor payment errors.

Supervised four accounting and inventory assistants. Hired and trained all four staff members and conduct performance evaluations for all staff.

Reviewed, audited and managed high risk client relations and bad debt process. Work collaboratively with legal counsel, financial institutions, accounting staff, and State of Alaska to resolve issues.

Reviewed and verified various financial records of last two years, assisted in identifying various risks and errors in accounts

Audited and tested Journals, purchase orders, invoices, payroll, bad debts, and business credit card accounts

Tested and made recommendations to improve the audit program to the development of risk-based audit plans

Performed physical counts of Cash, and Inventory (high value diamonds/gem stones)

Achievement:

Increased sales by 20% and reduced collection debt by more than 50%

Detail audit resulted in finding few very high value missing diamonds and unreported revenue by sales person

Abbott Labs (Cyberthink), North Chicago, IL September 11 - February 12

SAP FICO Consultant

Upgraded SAP version from R/3 4.7C to ECC 6.0. Experienced in ASAP methodology and Fit GAP analysis.

Customized, configured and Implemented SAP FI/CO GL, AP, AR and controlling (cost center accounting) modules. Set up New GL accounts in chart of accounts and new company code. Worked with sales and purchasing consultants to design a global vendor /customer master record structure.

Asset accounting defined chart of depreciation, various depreciation areas, and depreciation keys required, asset classes, number ranges, revaluation settings.

Chehar Corporation, Aurora, IL June 09 - September 11

QuickBooks Bookkeeper

Provided daily management & leadership to the Cash Applications Group, ensuring that the staff is adhering to store policies.

Prepared payroll for more than 200 hourly employees bi-weekly.

Bridge Personnel Services (AHFS), Hoffman Estates, IL September 08 - June 09

Collector

Kept track of accounts that are overdue and attempt to collect payment on them.

Located and notified customers of delinquent accounts, usually over the telephone, but sometimes by letter. Find out the reason of delay in payment in order to assist better.

Notated the account accurately including amount, date and payment method

“Skip Tracing” works needs to be done when customers move without giving address, such as checking credit reports, Honda service dept. (dealership), post office, contacting references, or insurance company.

Educated customers about their options such as changing due date, an extension, making only interest payment, or how they can avoid credit bureau mark.

EDUCATION

Bachelor of Science in Finance, Northern Illinois University, DeKalb, IL August 2008

TECHNICAL SKILLS

SAP FICO (Configuration & Implementation), QuickBooks, Payroll, Collection, Credit analysis, SQL database, Microsoft Office Suite: Word, Advanced Excel (Macros, Pivot tables, V-Lookups), Outlook, and PowerPoint

Contact this candidate