Rose A. Rocha
Westland, MI *****
**********@*****.***
Professional Strengths
•Adaptable to fast pace and challenging work environments.
•Helpful to team members, by sharing information to create great work relationships.
•Prioritize assignments to meet all deadlines in a timely manner.
Professional Experience
Data Analyst Net2 Source at Siemens 3/2023 to 12/2023 Contract
•Researched, analyzed, consolidated and interpret data using statistical and data analytics methods to create information on business-relevant topics, e.g. market environment, operational process, and equipment performance etc.
•Acquired data from primary and secondary data sources and maintain data using Sharepoint and ERP accounting system.
•Operated and optimized pre-defined tools, maintain Excel spreadsheets and use VLOOKUP
•Created reports and communicated results to various internal and external stakeholders
Accounts Payable/Accounts Receivable Coordinator Accounting Principals 10/2018 to 2/2019 and
08/2019 to 9/2019
Weekly downloaded spreadsheet for Accounts Receivable monies to collect.
Contacted customers by Email and phone calls to obtain status of payments.
Collection focus on past due of amounts of $1,000 to 20,000.
Assisted in year-end vendor confirmations. Requested and reconciled statements from 40+ vendors.
Worked closely and communicated those results with Accounting to determine proper liabilities.
Managed daily Email including the “AP Inbox” email account to ensure statements, invoices, and checks are processed timely.
Daily updating bank deposit sheet using an SAP generated report
Preparing pdf invoices for weekly emailing to customers
Cash application using SAP for miscellaneous customers
Collection activities for customers with balances over 60 days
Responding to customer’s requests/questions regarding current and past due invoices
Researched pricing validity in order to collect from automotive customer
Accounts Payable Assistant Nachi Robotics 6/2017 to 4/2018 Contract
•Made job easier for coworker by coding General Ledger accounts to be posted to CMS. Expedited payment of Invoices by researching questionable purchase order line items.
•Process invoices daily for Accounts Payable (using the 3-way-match) for vendors and employees.
•Coded foreign monies to match USD based on currency tables.
Quality Analyst ZF TRW 5/2017 to 5/2017 Contract
•Utilized Vlookup and Pivot Tables to identify plants with defective or damaged parts.
•Downloaded data to Excel to show trends in plant sales.
Procurement Specialist Valassis 9/2016 to 11/2016 Contract
•Analyze Non-Disclosure Agreement for payment terms and renewal dates.
•Upload Fully Executed Contracts to the procurement system, daily for the buyers – assuring that Purchase Orders can be generated on SAP to purchase items.
•Contact suppliers to get countersignature on the IT and Indirect agreements, quotes and staffing agreements.
Order Follow Up Specialist DSSI 7/2015 to 6/2016 Contract
•Demonstrate ability to deliver faster and correct data to the suppliers and buyers by utilizing more features of Excel – Vlookup and Short cuts.
•Responsible for understanding and following all customer follow-up guidelines to ensure customer performance expectations are met. This includes but not limited to generation of monthly open order report, maintenance of the Chrysler Supplier Database
•Utilize SAP to make available automotive parts to plants and assign to cribs as directed by the plants for non-production usage.
Bakery Assistant Panera Bread 10/2012 to 9/2014
•Prepared bakery items for bakery which included bagels and soufflés.
•Decorated cookies and cupcakes. Inscribed cakes as needed.
•Set up bakery items for baking. Assembled breads, doughnuts, and bagels.
Accounts Receivable Specialist EDAG 6/2008 to 1/2010 Contract
•Successful collector of $8 Million dollars for onetime payment from Mexican customer.
•Collected past due amounts of $600 to $3,000on a weekly basis.
•Accurately enter cash receipts on a daily to include checks and credit card payments.
•As a strong team member- invoiced on a timely manner using: SAP, Peachtree and Excel.
Accounts Payable/Data Analyst Visteon 1/2005 to 5/2008 Contract
•Tracked inbound and outbound deliveries of parts to the automotive plants using SAP.
•Completed in time - daily error reports for plant shipments and customer releases.
•Used Vlookup and Pivot tables to monitor pricing for automotive parts to Plants, to get the best supplier rates.
•Efficiently did a 3- way -match of packing slip, purchase order and invoice to pay suppliers.
•Software- SAP SD and SAP MM, Excel 2003 VLOOKUP and PIVOT Tables.
EDUCATION & TRAINING
B.S., Mathematics, Wayne State University, MI
General Studies Schoolcraft College – Livonia, MI
Software Experience
Accounting Software 6 years SAP, 2 years Sharepoint, 7 years Excel and 7 years Word. Implementing Vlookup and Pivot Tables. Over five years in Accounts Payable, 3 years Accounts Receivable.