Financial Data Internal Auditor

Lance Gutierrez

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

ad5v0p@r.postjobfree.com

Objective

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

Professional Experience:

Denver International Airport - City & County of Denver

SENIOR INTERNAL AUDITOR 2023 – Present

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

Present project plan to Audit and Business Leadership.

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.

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

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.

Run data queries from large data sources and provide financial data needed for key components of Internal Audit.

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.

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.

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.

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.

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

SQL

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