George A. Ramirez Email & Phone Number

Chicago, Il, Us

Lake Zurich, Illinois, United States

Schaumburg, Illinois, United States

• Collaborated with Account Managers and Data Engineers on various stored data requiring ETL to provide data sets and reports for Client report fulfillment. Utilized Excel, Tableau, Cognos, Power BI, and Adobe applications for report generation.• Utilized VBA and Power Query (M Language Code) and improved report generation productivity.• Maintained patient confidentiality and functioned within the guidelines of HIPAA.

Mt Prospect & Lincolnshire, Il

• Carrier cost & deal pricing management. Worked with Carriers within the Americas. Driver of savings through contract re-negotiations with Carriers.• Created ad-hoc profitability analysis reports of customer’s existing and forecasted services associated with special pricing requests for management business decision making.• Created process to gather Sales Force data intelligence to review price quotes in order to fortify competitive price requests from network carriers.• Updated pricing and commercial terms on customer agreements archived on Sharepoint.• Successfully developed needed data sets and visuals for business intelligence of largest revenue generating carrier service to review service products profitability by product by customer. Tools used included Excel VBA, Oracle SQL, Power Query (M language), and Power Pivot (DAX). The data intelligence gave the added feature to internally audit company’s largest carrier billing data for invoice assurance.• Developed needed QuickBooks invoice item entry methodology, for company’s unique service product naming convention to create data sets of product revenue (recognized, accrued, deferred) and cost of goods for uploading to the Global Financial BI system.• Annually accomplished gathering Financial Statement data information of U.S. service entities to assist Global Controller on Global Financial Statements.• Managed accounting staff and accounting books of North America service entities. Supervised A/R, A/P, PO & vendor invoice matching, Payroll, and Asset Management including R&D Capitalization. Performed Treasury transactions.• Assisted Parent Company’s Senior Accountant with data information for consolidated U.S. tax returns.• Performed document preparation for liaising with external auditors.• Collaborated with IT SAP team to successfully convert from QuickBooks to SAP ERP system.• Managed Human Resource, 401K, & payroll of North America service entities.

Lincolnshire, Il

• Company Treasurer and an interest owner of this successful startup.• Successfully developed invoice data set requirements for uploading into Quickbooks within 30 days from business start. This included Quickbooks multi-state taxing preparation for proper sales tax processing on invoices.• Worked with all aspects of financial accounting, Financial Statements, A/R, A/P, PO & vendor invoice matching, Payroll, and Asset Management. Completed all treasury transactions and managed accounting staff as company grew.• Annually accomplished all preparatory data documentation to external accounting firm for direct tax purposes.• Managed indirect tax for multiple state filings, Universal Service Fees, and other regulatory fee compliance.

Lincolnshire, Il

• Progressed through various mergers and acquisitions from Motorola, ARDIS Company, Motient Corporation, Geologic Solutions, to XATA Corporation.• Evolved from Operator/Programmer to Managing the Operations Data Service Center with a 7x24x365 staff.• Built custom software event log monitoring applications for Operations Data Service Center utilizing Visual Basic for Applications. Application monitored event logs of production traffic, connections, and custom routing applications. Application improved monitoring capability by large magnitude and created ease for trouble ticket entering.• Developed MS Access application for customer host connectivity information, utilizing front end & back end to secure back end and provide login security. Improved client host tracking information 100%.• Developed and expanded Remedy BMC fields for trouble ticket entry to gather proper categorized metrics of customer issues per service industry. Improved metric reporting tenfold.• Managed services issues to resolution.

Bsee

Professional Accounting Certificate