Customer Accounts Construction Engineering

Lance Gutierrez

***** ********* ***, ******, ** *0138 303-***-****

*****.*********@*****.***

Objective

To obtain a challenging position in a company that is growing and allows me to utilize my past experiences.

Professional Experience:

FCI Sand Operations – Oil and Gas 2025 to present

Process credit applications.

Evaluate and monitor financial health and payment risk of customers.

Create and maintain customer profiles and site accounts in internal systems.

Receive and process customer purchase orders and contract documents.

Generate and distribute timely and compliant invoices, including through customer specified platforms.

Work with operations and dispatch to confirm all products are billed and invoiced correctly and promptly.

Monitor aging reports and manage DSO to meet company targets.

Manage factoring of customer payments.

Manage company payroll.

Process credit memos and account adjustments.

Investigate and resolve payment discrepancies in collaboration with internal stakeholders.

Maintain accurate records of customer communications and payment history.

Ensure compliance with customer policies, accounting standards and industry regulations.

Generate sales and AR reports for internal stakeholders and customer accounts.

State of Colorado – Colorado Department of Transportation CDOT

DEPARTMENT OF ACCOUNTING AND FINANCE DAF 2024-2025

Perform analysis, reconciliation, and verification of allocations for Construction Engineering (CE) and Indirect (IND) posting; identify and correct any discrepancies;

Provide management with trends, projections, and potential surplus and shortfall information necessary to make ongoing decisions about CE/IND;

Compile, analyze, and create the indirect cost rates on a yearly basis for approval by the Federal Highway Administration (FHWA) using SAP software.

Provide and fulfill any ad hoc CE/IND analysis and reporting requests;

Support accounting month-end close activities and quarterly/year end processes.

Communication Professional and effective communication with frontline teams and customers.

Create, update, and maintain the dashboards related to CE/IND analysis;

Conduct financial analysis and present to leadership.

Create invoices by creating files and importing into QuickBooks Pro and sending out to the customer via email or customer portal.

Invoice and Expense reconciliation of Federal Billing.

Prepare comprehensive reports on QA activities, audit results, and performance metrics, maintaining accurate records for ongoing analysis

Use Excel macros or other similar editing techniques on crime data to analyze, format, simplify, and present findings.

Conducts various statistical and financial reports, as assigned. Gathers analysis and creates reports.

Respond to inquiries related to CE/IND and train others on the processes related to CE/IND;

Monitor and review the daily error log associated with the CE/IND allocation process; research cause of discrepancies and determine if there is a systematic error or other change to correct the error;

Create the appropriate financial entries and ensure they are posted to correct the noted CE/IND allocation process failures;

Analyze other project-related functions including developing, testing, and implementing other financial data analyses and reports;

Troubleshoot data feed issues and resolve billing discrepancies

Verify and confirm that retainage is recorded properly; prepare, at a minimum, the quarterly reconciliation between the Trans*Port retainage records, SAP liability account, and the Project subledger expenditures;

Analyze and interpret monthly financial performance, including commentary on variances to budget and monthly trends

Proficiency in mapping current business processes and identifying opportunities for process improvements or automation.

Respond and educate staff on the use of retainage accounts, how they function and steps to perform any necessary actions to properly record and release retainage;

Acknowledge receipt of any escrow request received from project staff; process the necessary financial transactions within SAP to record the escrow; track and monitor any funds that have been escrowed and ensure their proper disposition;

Record securities in Site Manager subsystem, maintain excel worksheet with securities balances by contractor and verify securities balances with escrow agents;

Serve as a back-up to all positions within the Projects & Grants Accounting section; train with staff to obtain a thorough understanding of the project’s bids/awards and closeout duties, federal aid billing duties, CPE/Local Agency invoice duties, and grant duties;

Assist with extracting data from SAP for auditors and other federal inquiries;

Assist with year-end functions that include verifying project accruals for accuracy and completeness;

Denver International Airport - City & County of Denver

SENIOR INTERNAL AUDITOR 2023 – 2024

Participate in identifying the project scope, key milestones and establishing project completion schedules.

Project Management.

Ensures organization is compliant with all rules and regulations

Present project plan to Audit and Business Leadership.

Conduct regular audits of manual reviews to ensure adherence to fraud prevention policies and standards.

Analyze incident data to identify root causes of customer issues, recurring problems, and areas for process improvement

Perform planning activities required in the conduct of audits; perform thorough inquiry, research and data analysis, assess risks, suggest activities to be examined, and the extent of examination.

Develop and apply appropriate audit procedures to the areas reviewed to ensure that key controls are tested and all significant risks are addressed.

Analyze results from queries and scripts, prepare reports, analyze the results and provide suggestions to the causes of trends and outliers.

Provides management with transparent, key financial data, trend information monthly as well as additional ad-hoc analysis.

Identify trends, patterns, and anomalies in operational data to understand financial, churn and/or experience impacts to incidents

Research and resolve discrepancies related to supplier orders, pricing, and deliveries.

Mapping current business processes and identifying opportunities for process improvements or automation.

Examine records, documents, methods, policies, costs, and other factors to determine if functional areas are conducting operations in accordance with established rules, policies, procedures, and regulatory requirements.

Prepare comprehensive reports on QA activities, audit results, and performance metrics, maintaining accurate records for ongoing analysis

Extract large datasets from data warehouses for business use and analysis.

Ensure contract with company is in compliance with rules, regulations and internal policies.

Proven ability to identify root causes and develop long-term solutions that support business objectives.

Analyze and interpret financial and operating results, including investigating variances and making recommendations on corrective actions.

Create reports to monitor key metrics, interpret results, and seek out areas of concern and opportunity.

Identify and implement innovative strategies and projects.

Interprets complex data analyses by applying findings to contextual settings.

Prepare clear and well-organized audit work papers that appropriately document the work performed, including lines of inquiry, testing procedures, analysis summaries, recommendations, and audit comments.

Business requirements for projects and RFP review.

T-Mobile

REVENUE ASSURANCE 2014 - 2023

Contributed to creating daily audits designed to detect revenue stream issues and billing inaccuracies. The audit process developed has directly contributed to the identification of revenue leakage in the amount of $75 million dollars from 2014-2023. Contributed to the financial analytics reporting, traffic reports, and QA audits to ensure the accuracy and continuity of the revenue stream. The reporting consists of a daily dashboard that reports daily trending of revenue, traffic volume, rating errors, and incident tickets that were opened to address issues found and under investigation.

Utilize SQL and data mining skills to identify trends.

Conducts financial research, analyzes financial performance against objectives and determines financial trending and root cause analysis for discrepancies.

Worked with internal and external audit teams to ensure new audit processes implemented are compliant within Sarbanes-Oxley control requirements by way of quarterly reviews with corporate audit and external audit teams.

Data analysis through spreadsheets, with a deep understanding of key performance indicators (KPIs) and metrics.

Identify trends, patterns, and anomalies in operational data to understand financial, churn and/or experience impacts to incidents

Identifying billing issues, estimating revenue impact, determining and escalating issue status, and resolving billing issues through ticketing process.

Develop dashboards for leadership and internal teams to help manage and improve their processes.

Continue to develop new processes to improve performance.

Extract, load and transform data from multiple tables necessary for statistical and financial reporting.

Responsible for project review of new products being developed and system design changes that may impact the revenue stream.

Partner with internal and external operations groups including network operations, platform operations, table management, product management, and external billing vendors to identify root cause and issue resolution for issues identified during audits. Responsible for gauging customer and/or revenue impact and to escalate as needed.

Conducted internal financial audits within agreed timelines.

Generating reports summarizing business, financial data.

Supports the improvement of financial performance using trending analysis.

Sprint Corporation

WIRELESS BILLING OPERATIONS - ACCOUNTS PAYABLE 2006-2014

Administration fee and custom reporting support.

Managing accounts payable using accounting software and other programs.

Handling accounts payable for separate entities and vendors and payment calculations and disbursement.

Ensuring bills and payroll are paid in a timely and accurate manner while adhering to departmental procedures.

Complex custom contractual obligations catering to large scale customer needs.

Created scalable repeatable solutions enabling support necessary to partner with high profile, profitable enterprise and government customers.

Analyzing and preparing Billing Invoices.

Information Technology Applications.

Processing transactions and performing accounting duties such as account maintenance, recording entries and reconciling books of accounts

Responsible for Special Customer Arrangement (SCA) Reporting.

Manual Invoicing.

Adhoc Reporting.

Project Management of workflow processes and procedures.

Project Manager and support for billing related Projects.

Interpretation of contracts per wireless and wireline customers.

Provides support for third party vendors.

Nextel Communications

CASH RECEIPTS RESEARCH 2000-2006

Audit, analysis, and reconciliation of customer accounts.

Direct communication with internal and external customers.

Balancing posted transactions and identifying posting errors.

Account Receivable and Payable procedures.

Evaluation process.

Silglo, Inc.

RESTAURANT MANAGEMENT 1998-2000

Full staff management; scheduling, new employee hires

Inventory management/Loss prevention

Quality assurance management

Denver Health Authority

PATIENT ACCOUNTS 1997-1998

Account reconciliation

Research customer payment processing

Cash posting and lockbox procedures

National Jewish Center for Immunology and Respiratory Research

PATIENT ACCOUNTS 1995-1997

Lockbox processing

Customer service

Billing liaison

Deposit preparation

Account Reconciliation.

Education:

Metropolitan State College of Denver

Bachelor of Science: Business Management 2005

Skills

Microsoft Excel- Extensive use of pivot tables, advance filters, functions, macros, lookups.

Financial Systems

Invoicing

Tableau

Transaction Pro

Fast Weigh

QuickBooks Pro

SQL

Internal Audit software Ideagen

Google Sheets

Connecteam – Customer payroll

SAP Software - Accounting

Power BI

Reporting

Dashboards

Workday

Trend Analysis.

ThoughtSpot

Snow Flake

Microsoft Applications.

Reference Tables

Customer Service

Account reconciliation, posting, root cause analysis and research.

Account audit.

Check processing, cash control, and lockbox procedures

Scheduling, ordering/purchasing, vendor relations, inventory tracking and analysis, and cost control

Payroll Knowledge and loss prevention

Accomplishments:

Employee of the month April 2005-Nextel Communications

Employee of the month May 2014-Sprint

Employee of the month April 2015-Sprint

NLP Next Leaders Program 2017

Employee of the month July 1996-National Jewish Center for Immunology and Respiratory Research

T-Mobile mentor program.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate