Manuel Rey Seneres

***** ******* ******, *** *****, CA 92129

Cell: 858-***-**** Res: 858-***-****

ad08h5@r.postjobfree.com

Summary Of Qualifications

Finance professional with 15+ years of strong financial and accounting experience. Knowledgeable in corporate finance, experience within the various industries.

Worked with the following Software Platforms

Salesforce, Sharepoint, Oracle v11i, Blackbaud - Financial Edge, SAP 4.6C, MAS90-200, AS400, JD Edwards, Qucikbooks, Costpoint, Word, WP 3.0-5.0, VisiCalc, Excel 4.0-2010, Lotus 2.1-5.0, FileMaker Pro. 2.0,Paradox, PowerPoint 3.0, Peoplesoft, UNIX, Front Page and Microsoft Office XP./ 365.

Professional Experience

Lead A/R Accountant – Key Accounts

CV Sciences.com

10070 Barnes Canyon Rd., Suite 100

San Diego, CA 92121

Apr 22 2019 – Present

At a growing, local start-up biotech company - CVSciences.com which produces and distributes Cannabis-based derivative (CBD) oil products primarily used for preventive health/wellness relief against mental or physical trauma and/or long-term conditions of anxiety. Within the Treasury Accounting group, I process all incoming checks, wires, ACH’s from customers such as small storefronts, resellers to large retail conglomerate chains like Albertsons/Safeway/Haggens and other retail locations throughout the US/Hawaii. Also, assist in partial or full refunds of credit card purchases due to retail discounts, undelivered or damaged goods, customer dissatisfaction, chargebacks, legal or financial hardship. Communicate daily with CFO, Controller, Lead Accountant, AP/AR Supervisor/staff, Marketing, Sales, Ops and Logistics. Expert in Excel macros, vlookups, sum ifs. Microsoft Access developer familiar with macros, forms, queries, SQL etc. Expert user of Dataload automated load scripts between Excel, Oracle and SAP platforms.

Staff Accountant (Temporary)

Intuit

San Diego, CA 92129

Sep 2018 – April 19 2019

Worked as a contractor for the AR department (7 months + extension). Responsible for key accounts like Office Depot, various banks, Walmart etc. Called, provided financing and sent collection letters. Heavy use of Excel, Word, Oracle and SAP. Worked directly with AR Manager, Sr Accountant(s) and staff members.

Data Administrator

Macquarie Equipment Trading

11440 West Bernardo Court, Suite 102

San Diego CA 92127 USA

T +1-858-***-**** Ops Manager - Jennifer Manzke

Feb 14 2018 – May 11, 2018 (Contract)

Macquarie Group Limited (/məˈkwɔːri/) is a global investment banking and diversified financial services group, providing banking, financial advisory and investment and funds management services to institutional, corporate and retail clients and counterparties around the world. Headquartered in Sydney, Macquarie is the largest Australian investment bank and the top ranked mergers and acquisitions advisor in Australia. Macquarie employs more than 14,000 staff in more than 70 office locations across 28 countries and has more than $A450 billion in assets under management.

Data Entry and Data Base Administration

Contract

To provide primarily support to the Mobility business and work under the direction of the Operations Manager. Very strong Excel skills, comfortable with systems and input, and follow up with personnel within the group and eventually customers and vendors. Sapphire, the primary data management system used by the business, is proprietary but is based on Salesforce.com so familiarity with Salesforce would be valuable.

Essential job functions:

Solid data entry skills with high level of accuracy

Regularly validate thousands of smartphone asset data points prior to uploading into the system.

Track incoming and outgoing smartphone assets and keep system updated (inventory control)

Build and run reports, ensuring data accuracy

Process and monitor incoming and outgoing shipments including the creation of shipping documents such as packing lists, commercial invoices, regulatory labeling, etc.

Potential growth opportunity into a position with customer interaction

Data Analyst

Sony Electronics

16535 Via Esprilo

San Diego, CA 92127

Oct 20 2017 – Jan 19, 2018 (Contract)

Sony is the fifth-largest television manufacturer in the world after Samsung Electronics, LG Electronics, TCL and Hisense. Sony was ranked 105th on the 2017 list of Fortune Global 500.

* Created weekly reports to drive operational behavior, some KPI type reporting. i.e.; Turnaround time.

* Tracked volumes, Repeat exchange or repair, Survey analytics, Return of TV analytics

* Expert in organizing raw data using Excel formulas (pivots, if/then, filters and macros), charts, graphs, ability to provide detailed reporting using SAP and MS Access (joins, queries, formulas, macros, forms and reports) to organize data.

* Work directly with the IT Manager ad Data Coordinator in the TV Analytics division.

Billing Specialist

Verizon Telematics Inc. thru Ampcus

San Diego, CA 92121

Oct 31 2016 – Oct 1 2017 (12 month Contract)

Process and post all invoices, returns and credit memos to be generated within the guidelines that each revenue stream and invoice type requires in a timely and accurate manner.

Report on status of monthly service invoices, activations, deactivations and returned goods.

Send proper billing related documents such as invoices, returns credit memos, and letters on a timely basis.

Ensure that all transactions run through the Sales tax engine (Avatax)

Customer Support: Perform account reconciliations. Properly utilize the systems to receive, document, respond and report any issues, questions, disputes, requests. Provide effective communications to other departments and applicable personnel, and return to their requests. Work with both internal and external customers to resolve any issues, questions, disputes and requests related to Pricing, Billing, Revenue Recognition and Document Management. Work to resolve any customer issues promptly and fairly.

Document Mgt: Maintain documentation of any process to be in compliance (special pricing, bid desks, promo codes.

Audit and Compliance: Provide support on internal/external audit ensuring that controls and working effectively

Reporting: Proactively provide insightful reports and analysis.

Month End Close: Ensure that all steps of the close take place timely and accurately. Process all steps of revenue are accurately and timely processed including Hardware, Service, Data, Installations, etc.

Systems Maintenance: Help with any change, development, testing and implementation of any additional module/system/process. Setup and maintenance different areas in the billing related systems such as Customer setup, pricing, Promotional codes, Deferred Revenue, etc.

Collections: Documents all customer interactions and collection efforts in the appropriate Collections notes system in a timely manner. Resolves billing disputes

Marketing Assistant

Vanity Fair / Eagle Creek thru 24/7 Agency

May 18 2016 – May 25 2016 (Contract)

Key Responsibilities:

Transposed content from Word into Excel for product web uploads and catalog development

Used online content management tool to upload blog posts and press releases

Assisted with video conversion, tagging, and back-end web maintenance

Coordinated and assemble materials for promotional mailings, influencer seeding, and press needs

Social media outreach and product seeding

Prepped product for photo and video shoots

Conducted market research

Assisted with additional marketing projects as requested

Santa Barbara Tax Product Group (TPG), La Jolla, CA thru Tristaff

Jan 2016 – Mar 2016 (contract)

Responsible for treasury reporting, specifically involving collection of Advanced Fees.

Special projects included process improvement of daily/monthly/year-to-date reporting by development of Excel templates and training in the use of them to staff members of Finance.

Involved with Call Center to develop improved metric reporting.

Performed collection calls with Tax Preparers owing Advanced Fees used for opening storefronts, office equipment and tax software.

Heavy use of Excel spreadsheets using advanced functions.

Communicated with Controller, Director of Finance, Accounting Manager, IT and staff members of Finance department.

Accounting Administrator / M1 Accounting Analyst thru Apple One

Tandem Metal Products. San Diego, CA

Sep 8 2015 – Jan 8 2016 (5-month contract )

Managed / reconciled AMEX, Costco and Citibank credit card transactions related to purchases for gas, food, lodging, airline tickets, inventory goods (raw materials), office supplies etc. on a monthly basis for double-billing, errors, missing receipts etc.

Entered AP un-posted invoices, prepare AP vouchers after posting invoices, prepare weekly AR / AP check runs, update AP vendor accounts (major clients include: Qualcomm, General Atomics, and Teledyne), maintain paid check files by vendor, by alpha and invoice order to maintain AP accruals.

Maintained AR invoices in alpha and invoice order. Maintain AR Customer paid file by alpha and invoice order for AR aging report.

Maintained old, Unix-based system called Magnum to new, web-based accounting system called M1 in parallel.

Managed / categorized / organized files related to the balance sheet involving company assets: Office supplies, office equipment, rent, building upgrades, machine upgrades, computer hardware / software, telephone and related Toshiba system, repair and maintenance, all related to metal shop operations.

Project lead in creating SOP manual using Word for training owner on Contact management for Customers and Vendors, AP/AR/GL, bank reconciliation and inventory of M1 accounting system. Work directly with M1 Consultant and owner.

Clerical duties included scanning PO’s, schematics, emails and proper disposal / recycling of hard-copy documents. Communicated with customers and vendors for upkeep of latest resale certificate and Tax ID info.

Type 63wpm, 10 key by touch, and Excel (pivots, if-then, filters, sorts, and macros) / Access expert.(import, create tables, queries, forms, dashboards, custom reports and macros)

Clerical duties included scanning PO’s, drawing, contracts, emails and proper disposal / recycling of hard-copy documents.

Account Administration Analyst

Kaiser Permanente, San Diego, CA thru Rose International

Nov 17 2014 – Feb 23 2015 (contract)

Reported to 1 Mgr and 1 Lead in the Kaiser Permanent Connect (KPC) Registered Outside California (ROC) Group.

Provided analytical support for maintenance, upgrade and correction of records belonging to Subscribers located in Hawaii, Northwest (Oregon and Washington), Ohio, and Georgia.

Ensured data integrity between the Customer Maintenance (CM) system and KPC system.

Audited Subscriber requests to edit or update their Health Information and maintain confidentiality according to Health Information Portability Privacy Act (HIPPA) standards.

Daily use of Outlook, Lotus Notes, Internet Explorer and Kaiser health systems to audit Subscriber data on a daily basis.

Heavy use of pivot tables, filters, sorts, and v-lookup functions using Excel.

Data Analyst

Carefusion, San Diego, CA (Acquired by Becton & Dickinson) thru The Select Group

Jan 2015 – Mar 2015 (contract)

Reported to 2 Senior Business Analysts, Manager and Director of the Customer Advocacy Analytics Dept.

Provided analytical support to the Customer Advocacy Analytics team using SAP, Excel and Access.

Conducted complaint trending and analysis necessary to identify anomalies for requesters.

Worked closely with R&D, Engineering, Operations, and Management to conduct ad hoc data requests and in depth analysis of complaint and failure data.

I have expertise in analyzing unstructured data sets (Text Mining) and the ability to build custom queries to extract info.

Associate Sales Analyst

Life Technologies, Carlsbad, CA (Acquired by Thermal Fisher in 2014) thru Iconma

Oct 4 2013 – Jan 6 2014 (contract)

Provided data gathering, sales analysis and modeling to support the impact assessment and sales territory design budget and forecasting process for 2014 fiscal year.

Performed geographic and account specific modeling using corporate mapping software called Tactician (a predecessor to Salesforce.com), heavy Excel (pivot tables and filters), and Outook.

Solely documented 100-page online training user document for Tactician software, for North America involving Canada, Hawaii, Alaska and the United States.

Recruiter: The Select Group

La Jolla, CA 92122

Data Analyst

Main reporting tool was SAP 4.6 version. I provided analytical support to the Customer Advocacy Analytics team with the overall mission of conducting complaint trending and analysis necessary to meet our quality objectives. This includes working closely with R&D, Engineering, Operations, and Management to conduct ad hoc data requests and in depth analysis of complaint and failure data. This information is integrated into recurring management reviews for communication of key issues and escalations as required.

Created and manipulated Excel pivot tables and the ability to build macros to integrate data into excel workbooks.

Expert user of Access 2010 database functionality including building queries and macros, data importing and normalization, database updates from external flat file downloads from SAP system.

Performed Access database queries using the Access query wizard utilizing SQL scripting to generate updated data analysis using the parameters of the data requestor.

Expertise in analyzing unstructured data sets (Text Mining) and the ability to build sophisticated queries to extract specified information.

Ability to build charts and graphs that effectively communicate the desired analysis results.

Worked with 2 Senior Business Analysts, Manager and Director of the Customer Advocacy Analytics Dept.

Gained invaluable, technical background of heavily regulated medical device industry.

REMEC Defense Systems (acquired by COBHAM located in Britain)

San Diego, CA 92123

Sep 2012– Feb 2013

Quality Analyst

Worked directly with the Quality Assurance Manager to solely designing a Microsoft Access database.

The database would streamline the processes within the Receiving / Inspection areas of Cobham.

The main reporting tools were from 3 old / current systems (Maxcimdb (retired db), e-Checklist of 3,175 Excel files, SAP db) and converted all to 1 Microsoft Access db. Note: Inevitably, the Microsoft Access & SAP main systems will be replaced by an Oracle Enterprise System.

Communicated weekly with Quality Assurance (QA) – Directors, Managers, Supervisors, Engineers, Inspectors and support staff for Receiving / Inspection Department(s).

Demonstrated the database prototype’s progressive build using PowerPoint slides and projector training on a weekly basis. Fulfilled all items on Executive’s / Support wishlist.

Database involved creating tables, forms, queries, and custom reports.

Contract was completed successfully with full documentation, training and support of new Microsoft Access database replacing 3 different systems and original data transactions since 1993.

Del Mar Thoroughbred Club (DMTC)

Jul 2011 – Sep 2011

Staff Accountant (contract)

Worked directly with the Controller to perform daily /. Weekly update of AP, AR-Deferred Revenues, Allocating revenues and expenses, review taxes and other line costs before processing into main reporting tool, SAGE (MAS200) accounting system on a daily / weekly basis. Note: I did not have access to SAGE as a temp.

Downloaded online data into Excel and update / review / file away Management reports linked to this data. Correct daily errors for accuracy and reasonableness. Streamline Excel reports whenever possible.

Audited W2G daily bettor winner forms for tax accuracy.

Knowledgeable and use of pivot tables, macros, key functions, and spreadsheet

Updated daily Executive / Operational performance reports regarding Attendance, handles (wagers), revenues and expenses related to 7-week horse race season betting, food / beverage outlets, restaurants, weekly concerts, maintenance, and other operational costs. Heavy use of Excel involving linked formulas between multiple worksheets, if-then formulas, concatenate, max, min, middle, average, first, last, vlookup, hlookup, and simple macros for printing or sorting.

Communicated with all levels of Management (Directors, Managers, Staff, 3rd party vendors and suppliers).

Accountant Analyst

Cricket Communications, San Diego, CA (Business closing this Oct 2015 after buyout by AT&T)

Oct 2007-Apr 2011

Performed month-end tasks related to AP / CONCUR expense tracking software, PP&E, maintained A/R entries, updated cost allocations related to State licenses, and forecasted costs using Oracle v11i within the Fixed Asset Group.

Star Employee in 2010.

Coordinated, reviewed and ensured all journals entries were posted for month-end expenses,

Processed A/P accruals for specific balance sheet adjustments. (Network operations, customer care, sales & marketing, general & administrative) and corporate consolidation journal entries}.

Tracked all budgetary transfers throughout the year for appropriate cost allocations to specific line items on the general ledger, balance sheet and trial balance.

Education

Bachelor Degree

BS Business Administration Finance 1990 San Diego State University

Associate Degrees and Certificate

AS Computer Science - 2002 Miramar College

Certificate in Microsoft Access – 2002 Poway Adult School

Certificate in Oracle 11i – 2008 – Cricket University

3-week course of QuickBooks 2012 – www.sdce.edu

Certificate in SAP – 2015 – Illumina Internal Learning System (ILS)

Contact this candidate