Financial Analyst Data Science

KETAL VYAS

973-***-**** *****@***.*** Somerset, NJ 08873

https://github.com/ketalvyas/

SUMMARY OF Possessing many years of experience as a financial analyst/accountant/data

QUALIFICATIONS analyst in various types of firms in different industries. Executed such tasks as analysis of past trends, financial modeling, budgeting, forecasting, variance analysis, account reconciliation, data science, managing data integrity, and performing tax returns, respectively. Worked with MS Excel as well as MS Access, SQL Server, SAP, Python, Tableau, respectively. Knowledgeable in US GAAP standards. Hoping to secure a senior level role in accounting, finance, tax, or analysis using my skills.

SOFTWARE Word; Excel; Access; Hyperion Essbase; PowerPoint; Visio; SAP; SharePoint; VBA; MS Outlook; Google Docs; SQL Server 2008; UltraTax; Toad 12.6; Python; Tableau; Power BI; Salesforce; Jira; Google Sheets

CERTIFICATION Passed All Four Sections of Certified Public Accounting Exam (CPA Exam)

EDUCATION Certificate in Project Management, NJIT

Master of Science, Taxation, Rutgers University

Master of Science, Accounting, DeVry University

Master of Business Administration, Finance, DeVry University

Certificate of Data Science, Rutgers University

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

PSM-I (Scrum Management)

EXPERIENCE Various Temping Engagements While Seeking F/T or Long-Term Employment NY, NJ

1996-Present

Operations Analyst-Sodexo, LLC at Merck Pharmaceuticals-: 2023-2025

Part of PDM (Preventive Maintenance) Group of Plant Operations.

Processed oil samples for shipment to third party in Florida after verifying plant building origin in SAP.

Utilized SAP and internal application: MEDS to keep track of new infrared issues of plant equipment.

Kept tabs on lubrication samples that were generated.

Created weekly summarized PowerPoint decks of internal plant KPI’s.

Generated charts and dashboards in Power BI of various issues by floor and building on the manufacturing plant.

Analyst-Sumitomo Mitsui Finance & Leasing-New York, NY: 2022-2023

Generated management reports on delinquency to Tokyo.

Generated several monthly reports in Excel using V-lookups and other formulas on monthly basis.

Created documentation with graphs on how such reports are generated.

Ran downloads of current data through Salesforce.

Automated tasks of tabulation and consolidation with Excel VBA.

Analyzed ELFAONLINE.ORG data regarding credit industry-wise vs. internally for KPI’s.

Generated dashboards regarding equipment leasing and financing of borrowing firms in Tableau.

Analyst-Wells Fargo-Summit, NJ: 2021

Created solutions regarding CAR (Credit Analysis and Reporting) and ERA (Enterprise Risk Aggregation).

Performed data science using such tools as Python and Jupyter.

Conducted planning sessions and meetings with team staff for project planning and analysis.

Updated tasks and other issues in Jira.

Communicated project status and related updates to all engineering team staff.

Mapped various systems to different FRY-14Q-related schedules and reports.

Coordinated with project team staff for project scope and completion of assignments within timelines

Used Power BI to show graphs of data.

Business Analyst-Everest Reinsurance-Liberty Corner, NJ: 2019-2021

Created business analysis-related deliverables for ALAE (Allowance for Loss Adjusted Expenses) and Garage Keepers Liability and how macro-economic factors would affect these projects.

Created User Stories and Tasks for above two projects and broke them down into smaller sprints according to SCRUM methodology for ALAE including Include, Exclude, Reimburse, Flat-Fee, and Pro-Rata Daily and Monthly, respectively.

Created Acceptance Criteria for ALAE and Garage Keepers Liability.

Queried policy and claims-related data in SQL section of WINS accounting system.

Performed analysis of discrepancies in claim-related periodic data with SQL downloads into Excel using pivot tables and other data-related features.

Uploaded all work and kept track using Jira.

Ran algorithms in Python and used Tableau to visualize data.

Business Analyst-Sterling National Bank-Montebello, NY: 2018-2019

Assisted in CECL Reporting of Loan Portfolio

Created use case and activity diagrams of workflow that consisted of various sources of loan information that would feed into main database: Impairment Studio. Exposed to such source systems as ABL(Asset Based Lending), CBR(Letters of Credit), INF (Equipment Finance Loans), LN (Signature), NVA (NovaCS Factoring), WL (Warehouse Lending), TMP (Payroll Finance), LIQ (LoanIQ), MCC (McCracken), DMI (Residential Loans), and ADV (Advantage Portfolio), respectively.

Involved in frequent JAD sessions to administer further IT improvements to Impairment Studio that houses all the named systems above. Sessions were done in Montebello as well as Manhattan and other locations on Long Island.

Analyzed monthly data validation and errors of various fields in above mentioned source systems by creating Excel spreadsheets and PowerPoint decks on which source systems had least/most errors per month in such fields as NAICS Code, Interest Rate Floor, Original Loan Amount, and Risk Rating, respectively to name a few.

Utilized SQL Server by running queries to find errors in Loan Trial Balance table to help rectify them so that bank has latest correct data for greater granularity and audit compliance.

Aided in giving Moody’s Investment Service, the outside consulting firm, in navigating the CECL process on a weekly basis.

Co-ordinated cross-county meetings in Montebello, Yonkers, and two offices in Long Island on a fortnightly basis among stakeholders on CECL Reporting project to administer progress.

Business Analyst-UBS Americas (Wealth Management Division)-Weehawken, NJ: 2017-2018

Created both data sourcing and functional controls according to CCAR and BCBS 239 Principles for credit risk.

Wrote Data sourcing controls whose purpose was to match similar bucket names with different feed names.

Wrote functional controls that consisted of functional and threshold controls that were conditional based that either the control objective was either met or failed/red flagged given certain buckets. Functional controls consisted of Collateral Pool, Mortgage Rating, Mortgage PD, LGD, Guarantor, Lombard, Credit Limit, and Exposure, respectively. Threshold controls usually dealt with periodic controls such as monthly and yearly and dealt with within a 2% threshold of difference.

Located bucket names for all of the above controls in Toad 12.6 RDBMS by running SQL queries.

Also, utilized Enterprise Architect 12.1 to locate bucket names germane to controls within the WM data model.

Conducted JAD (“Joint Application Development”) sessions with other BA’s that were based in Mumbai, London, and Krakow, respectively.

Co-ordinated Master List of all controls in the pipeline off of SharePoint as per quarterly release.

All types of controls mentioned above were to be placed in different sections in Zeus Control Tool (“ZCT”) by BCBS Principle viz. Accuracy, Consistency, and Completeness. ZCT enabled authorized users to look at different internals of UBS as it pertained to credit risk.

Data Analyst-Colgate-Palmolive-Piscataway, NJ: 2016-2017

Assisted in the migration of Lotus Notes data into SAP

Stored such tables as “Active Materials”, ‘Significant Risk Assessments”, and “Audited Material-Providing Countries”, respectively in SAP.

Executed test scripts in Google Docs Spreadsheets of Risk Assessment tab

in SAP, to check if materials are of satisfactory quality across such sbu’s as Colgate Toothpaste, Ajax Cleaning Products, and Hill’s Pet Food, respectively in different regions from Latin America to Asia Pacific.

Compared complete list of global suppliers from Notes to see that all have been accounted for in SAP.

Generated “C”-level management reports showing suppliers that are in danger of being suspending business with.

Created financial models of various analytical procedures such as working capital and cash flow.

Data Analyst-Johnson & Johnson Healthcare Services-Piscataway, NJ: 2016

Assisted in updating Informatica Master Data Management (MDM) database of caregivers across the country for large pharmaceutical firm’s Accelerant and Ethicon subsidiaries, respectively.

Updated large spreadsheets of several thousand rows by Johnson & Johnson subsidiary of correct ENT name, location, unique identifier, etc. to make sure company’s MDM database file mirrors spreadsheet data.

Performed ad-hoc analysis of ENT providers by either hospital or medical office type, location, years of practice, etc. in Excel.

Analyst-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 three separate company files: U.S., Switzerland, and Singapore, respectively to report to partners in Switzerland according to US GAAP and IFRS.

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.

Financial Analyst-Allergan-Rockaway, NJ: 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.

Accounting Analyst-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.

Bookkeeper-Tekno Products-Rutherford, NJ: 2013-2014

Mid-sized supplier of As-on-TV products to retailers.

Inputted and maintained bills in QuickBooks according to GAAP.

Managed factoring of receivables to third party on monthly basis.

Managed monthly track of related party transactions between owners.

Tax Accountant-Subhash Dani, CPA-Green Brook, NJ: 2012-2013

Boutique CPA firm in Central NJ.

Filed individual tax returns in UltraTax for 2011 and 2012 tax seasons.

Managed office expenses in Excel.

Financial Analyst-Pfizer, Inc.-Peapack, NJ: 2011-2012

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.

Financial Analyst-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 v-lookups 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.

Financial Analyst-Day Pitney-Florham Park, NJ: 2008

Large law firm with office in NJ and MA.

Updated Excel spreadsheets of lawyers by department of new billable hours worked.

Generated reports for Controller by various buckets.

Analyzed largest cost-drivers by division.

Performed financial modeling of forecasted staff costs.

Accountant-Hart Howerton-New York, NY: 2007

Architecture and design firm with offices in NY and CA.

Analyzed charges and performed project costing of mid-sized architecture design firm by project, man hours, and billable rates.

Created schedules from beginning to end of projects to calculate total costs.

Booked administrative costs by architect on weekly basis.

Analyst-Morgan Stanley-Brooklyn, NY: 2005-2006

Worked in Morgan Stanley’s IT support unit:

Performed analysis of past outstanding payables using pivot tables in Excel in order to ascertain what product and service charges the department incurred and the breakdown of such charges.

Calculated monthly cost accruals for long-term contracts showing cost breakdown by vendor allowing company to allocate set amounts periodically.

Updated spreadsheet on vendor payables to show what invoices remain outstanding and which ones were paid.

Updated Access tables of numerous business units’ IT inventory and uploaded into web server providing an uncomplicated, quarterly, inventory reference for management-reporting.

Financial Analyst- Deutsche Bank Global Processing Services -Totowa, NJ: 2005

Investigated past charges in SAP of monthly recurring expenses.

Addressed ad hoc requests by creating Excel spreadsheets.

Reviewed contracts according to Sox compliance and revenue recognition.

Financial Analyst-JP Morgan-New York, NY: 2003-2004

Helped find ways of saving money in expenditures of administrative nature such as printer usage, stationery expenses, and courier expenses. For example, made recommendations such as to save $150k per annum in courier expense and reduce printer machine expenses through analysis.

Investigated cell phones, pagers, and printers to see if still current in Excel via v-lookups.

Accountant-Related Capital-New York, NY: 2003

Manhattan-based property management firm

Reconciled balance sheet, income statement, cash flow, statement of retained earnings of two wholly-owned subsidiaries that were Amex-listed and presented such data on corporate intranet site.

Calculated beginning and ending values of collateralized debt obligations (CMO’s) that these subsidiaries held.

Accounting Officer-Standard Chartered Bank-New York, NY: 1998-2000

Full-time employee for emerging markets’ bank’s money transfer department.

Reconciled on monthly basis six cost centers consisting of money transfer sbu’s from budget, G/L actuals, a/p, and ADP payroll: noting variances.

Supported Excel-created application that was written in VBA that kept track of daily volumes of each of six cost centers.

Kept running log of forbidden nations and entities according to US Treasury’s OFAC division.

Supported disaster recovery off site in Jersey City, NJ by frequenting off site to make sure that site is being fortified.

Reported monthly budget and volume numbers to management committee in Singapore.

Created own desktop operating instructions (DOI’s) of weekly and monthly deliverables complete with illustrations, bold text, and easy-to-follow methods for other staff members to follow.

Gained greater knowledge of various methods of payments including Fed Wire, Swift, and Chips, respectively.

Accountant-Panalpina-Morristown, NJ: 1996-1997

Large Swiss freight-forwarder

Data entered 1000+ foreign payables in USD and non-USD in AS/400 accounting system on a weekly basis.

Performed analysis on U.S.-based small business customers using SAP.

Contact this candidate