Sales Management

KETAL VYAS

***-* ****** ******

973-***-**** *****@***.*** Springfield, NJ 07081

CERTIFICATION Passed Certified Public Accounting Exam (CPA Exam)

EDUCATION MS Taxation, Rutgers University

MS Accounting, Devry University

Bachelor of Science, Business Administration/Marketing, Minor in French, New

York University;

SOFTWARE Word; Excel; Access; Hyperion Essbase; PowerPoint; Visio; SAP; Sharepoint; VBA; SQL Server 2008

EXPERIENCE Various Consulting Engagements NY, NJ

Consulted as an Accountant/Financial Analyst 2010-2016

Trascent Management Consulting-Readington, NJ: 2015-2016

Global partnership that engages in management consulting to multi-national corporations

Used QuickBooks to consolidate three years of data of two separate company files: Switzerland and Singapore to report to partners in Switzerland.

Created MS Access Database that kept track of different projects and their respective project managers, costs, durations, purchase orders, etc.

Engaged in ad-hoc Excel requests to compute employees’ expenses and uploading such into SharePoint.

Kept track of monthly phone/internet bills of employees: paying particular attention to data usage, long-distance calls, and number of phone lines through Concur.

Actavis-Rockaway, NJ: 2014-2015

Part of Consolidation Team on Actavis and Aptalis Merger

Performed Manual Rebates Reconciling: Making sure that drug information in company workbooks match Company Rebate Invoices as well as dollar amounts in SAP.

Updated homegrown MS-Access database of drug information of the above by corporate customer.

Created pdf files of above supporting documents by corporate customer.

Uploaded all supporting documents through Sharepoint.

Wyndham Worldwide Rental Properties Division-Parsippany, NJ: 2014

Performed bank reconciliation of 250 rental properties aka business units across US.

Included both night audits and bank deposits which included Amex, ACH, MC/VISA, and Discover receipts, respectively.

Pfizer-Peapack, NJ: 2011-2014

Created database of revenue by drug and ran queries in MS Access.

Updated macros in Excel for calculation of AR/AP and foreign exchange.

Created pricing models of various Single Oral Dose (SOD) drugs by market.

Forecasted sales revenue by country market, molecule, formulation, and strength.

Analyzed data of European and Asian markets by molecule, cogs, production margin, gross margin, discounts, and net revenue.

Investigated recurring charges in SAP accounting system.

Reconciled on monthly basis SOD and Animal Care Products (ACP) sbu’s from budget to G/L actuals, a/p, and ADP payroll: noting variances.

Drilled down to find granularity of data by province or region for sales by country in Hyperion Essbase.

Reported monthly budget and volume numbers to management committee in New York.

Dow Jones-Monmouth Junction, NJ: 2010-2011

Updated and calculated various cost breakdowns of IT consultants across 10 vice-presidents and their respective managers, by Capex/Opex percentages; monthly charge according to contract duration; and headcount according to time worked. Utilized complex formulas to compute and forecast detailed charges for consultants for whole and less than whole months. (Excel 2007)

Created ad-hoc reports using pivot tables and vlookups from the above for managers and PMO.

Queried IT resource-related data in SQL Server.

Maintained workbook package for the 10 vp’s +1 consolidate workbook, each containing respective breakdown of charges and consultants working under each vp.

These 11 workbooks contained budget vs. forecast expense of IT consultants or resources. Each vp reviewed his/her workbook while CIO reviewed all 11.

Contact this candidate