Financial Analyst Sales

Jasbir Bansal

Pleasanton, CA

Cell: 312-***-****

Email: **********@*****.***

QUALIFICATIONS SUMMARY

Senior Financial Analyst with multiple industry experience including Financial Services, Pharma, Healthcare, and Food Manufacturing.

Financial Planning and Analysis

Budget preparation and forecast planning

Management reporting and accounting operations

Month end close and account reconciliations

Advanced MS Excel skills

Access Database skills

SAP End user testing

PROFESSIONAL EXPERIENCE

November 2015 - Financial Analyst

August 2016 Bank of the West (Contract) San Francisco, CA

November to April 2016 worked on one of the largest projects undertaken by Bank of the West.

From May to August 2016 worked in CCAR (Comprehensive Capital Analysis and Review) Finance department, and also in the Digital Channels business unit, responsible for training the new hire on contract and invoicing processes.

Enhanced the accruals reporting process by creating pivot tables allowing the monthly accruals journals to be prepared more efficiently. The pivot tables also served as a tool from which other reports could be produced

Designed an Excel spreadsheet for 17 work streams and approximately 350 resources to track actual hours by leveraging internal Time Management tool against forecast hours in order to gain insights into financial variances and control costs

Produced a training manual for Project Managers on how to use time management tool for adding resources and approving timesheets for their resources

Created a spreadsheet to record all invoices received and track payments and number of days outstanding

Successfully reduced 80% of all outstanding invoices

Implemented a process to track SOWs, POs and invoices to provide management a quick and consolidated view of expenses, vendor relationships and funds availability

Uploaded Statements of Work (SOW) to create Purchase Orders and review invoices for payment

Prepared the Capital Expense Binder for CCAR and IHC (Intermediate Holding Company)

Ensured operating expenses were correctly classified and looked for opportunities to capitalize assets. Evaluated Opex costs for re-classification to Capex costs

March 2015 - Financial Analyst

May 2015 Wolters Kluwer (Contract) Riverwoods, IL

Prepared budget templates for business units to complete and return for review by management

Checked purchase requisitions to ensure costs were in line with budget and appropriate levels of approvals were in place

Checked and updated Open Purchase Order report for review by business units

Updated Software tracker for management to review and track asset purchases

October 2013 - Financial Analyst (contract)

Dec 2014 Tate and Lyle, Bulk Ingredients (Contract) Hoffman Estate, IL

Prepared analysis for two plants to report the manufacturing and operating costs and compare actuals to budget

Produced customized monthly sales reports to analyze sales volume, margin and net sales and calculate sales commissions

Produced a monthly report requested by the US Government; documented the process as it involved gathering a large amount of data from numerous internal sources

Participated in SAP user acceptance testing and liaised with IT to discuss how business requirements could be implemented to support the reporting needs of the department

Delivered all ad hoc requests from management to provide accurate and timely reports

April 2013 - Merchandising Analyst (contract)

July 2013 United Stationers, Merchandising Operations Dept. (Contract) Deerfield, IL

Updated vendor contracts and ran weekly reports to capture any changes to the contracts; checked debit notes in database

May 2011 - Senior Financial Analyst, FP&A

December 2011 CDW, FP&A (Contract) Vernon Hills, IL

Prepared monthly and quarterly management reports for ten business units with explanations of variances

Developed annual operating plans and forecasts for payroll, headcount and SG&A to upload on to Hyperion

Coordinated monthly close; prepared journal entries; produced financial statements

Updated financial models with current actuals and future estimates

Worked closely with key internal customers and cross functional teams to obtain relevant information

February 2008 - Senior Financial Analyst, Health Systems

March 2010 Cardinal Health, Health Systems McGaw Park, IL

Managed the GPO Admin Fee accruals and reporting for $108M in fees and $18.5B in sales

Calculated monthly admin fee accruals for approximately 200 contracts relating to Group Purchasing Organizations

Balance Sheet reconciliations for 24 general ledger accounts for 6 GPOs.

Investigated GPO admin fee variances to provide explanations to each business unit

Prepared the Quarterly Adjustment journal and uploaded on to SAP

Compiled the Quarterly Fee Trend report and Admin Fees Rolling 12 months report for Management review

Created cost center reports to provide Sales team with user friendly data to aid in their decision making process

Ad hoc analysis and reports

October 2005 - Financial Analyst

January 2008 Acco Brands Corporation, Viscom Lincolnshire, IL

Responsible for preparing and analyzing financial reporting for $260M strategic business unit

Prepared and reviewed annual budgets for each cost center

Reconciled balance sheet accounts

Published monthly Financial Book for management reporting

Prepared daily sales reports for management review

Prepared P&L and Inventory spreadsheets to load on to Hyperion for consolidation.

Developed and maintained spreadsheets to calculate customer rebates based on sales

Performed monthly, quarterly and year-end close

Assisted external auditors by reviewing internal controls to comply with Sarbanes-Oxley (SOX)

March 2004 - Financial Analyst

August 2004 EDS, Treasury Hillingdon, UK

Responsible for reconciling 250 intercompany loan accounts, liaising with US operations to ensure minimum variances

September 2001 - Financial Analyst, R & D Finance Mar 2003 – Mar 2004

March 2004 GLAXOSMITHKLINE PLC Greenford, UK

Responsible for producing monthly management reports, monitoring cost centers and account codes.

Financial Analyst - Shared Financial Services Sept 2001 – Mar 2003

GLAXOSMITHKLINE PLC

Responsible for the UK and Overseas Inter Company accounts. Streamlined the process to make it more efficient and timely.

Education / Certifications

Lean Six Sigma Certified to White Belt status

Association of Accounting Technicians (AAT)

Microsoft Office Advanced Excel Certification

Association of Certified Chartered Accountants (ACCA)

BA (HONS) Fine Art / History of Art, Minor Psychology

Systems Experience

Multiple ERP Systems (SAP, Oracle, PeopleSoft)

Accounting and HR Tools (CPRS, Citrix, Innotas)

MS Excel, Word and Access

Database (Business Objects, Hyperion, Essbase)

Contact this candidate