PROFESSIONAL EXPERIENCE

Confidential, Denver, Colorado

Test Data IT Management

Responsibilities:

• Created unique testing scenarios for software and IT teams, specifically managing Portals teams
• Oversee test creation in billing systems CSG and ICOMS. Work with multiple IT and Telecom products
• Attend daily stand ups and weekly calls with Portals team to answer any issues on their test environments
• Work across multiple teams in the IT organization set up testing scenarios across multiple billers and platforms
• Participated in Agile SCRUM workshops to develop cross - functional solutions to problems with other IT teams
• Input data results and create reporting in Tableau for leadership, staying agile to adjust to their requests
• Audited credit card and internal banking transactions with our internal partners and continue the management of these funds and transactions.
• SaaS implementation experience on multiple platforms.
• Use Tableau and Excel formulas such as VLOOKUP, Pivot Tables, Data Model to present weekly reporting numbers

Confidential, Denver, Colorado

Management Consultant for Product Development and Analyst

Responsibilities:

• Developed and maintained a nationwide dashboard distributed to executive leadership
• Helped create processes and procedures for nationwide testing of a new product launch on IT product
• Analyzed data using Pivot Tables, VLOOKUP, Index Match in Excel to create dashboards
• Worked across multiple teams to prepare technical and operational support for local testing
• Conduct in market presentations with the marketing team on the program I helped developed and implement
• Lead telephone bridges working with cross functional IT teams and worked within JIRA to resolve issues
• Use forecasting tools to identify areas of emphasis in product troubleshooting for future testing
• Create weekly PowerPoint reports on the product launch’s status and send to key stakeholders

Confidential, Greenwood Village, Colorado

Data Analyst/Accountant

Responsibilities:

• Compile and calculate monthly subscriber counts and total balances for various network partners
• Generate reports for executive leadership in Tableau, bringing in multiple tables to generate Dashboards and trend reports
• Using data outputs from macros in Access, I would calculate the billing totals to send to AP.
• Design and implement unique reporting of the data to meet contractual and GAAP requirements
• Calculate and analyze International and Regional Sport Networks monthly payments, annualized in the millions.
• Analyze and read through contracts to get the framing for the dollar calculations necessary each month
• Solve complex Business Case projects using Access and Excel in concert with Oracle systems
• Take tables from Access output and input slices into Excel and run Pivot Tables and Vlookups to finalize data for executive reporting and account payables

Confidential, Broomfield, Colorado

Revenue Assurance Analyst II

Responsibilities:

• Assessed over $15 million in revenue liabilities through 2015
• Coordinated presentations and conference calls to discuss business resolutions with company executives
• Managed medium and large enterprise accounts, analyzing the financial liabilities of early disconnects
• Worked daily with Salesforce inputting information and modifying data and revenue projection models
• Developed custom databases on customer histories; writing Excel Macros and editing SharePoint
• Analyzed MSAs and Service Agreements Contracts to calculate amounts of lost revenue on broken contracts
• Partnered with European operations to create new ETL packages. Worked with various foreign currencies

Business Development Analyst

Responsibilities:

• Coordinate with Margin Assurance, Carrier Relations and Commercial Services Groups as needed to assess/validate third party liability. Proactively work with Sales, Account and Disconnect teams and customers to ensure accuracy of contracts and liability assessments.
• Audit and evaluate customer’s invoices, contracts, and orders to ensure revenue is billed appropriately and adequate margin is obtained. Accurately interpret standard and nonstandard contracts. Implement new audits and metrics as the business changes.
• Work with various stakeholders to communicate any disputes and ensure streamlined results
• Research contracts, MSAs, and any amendments redlining and pulling specific contract details to aid in calculating an Early Term Liability Estimate
• Collaborate with team members to develop best practices for EMEA ETL operations
• Worked with marketing teams to push new products and deliverables on ETL retention clients
• Work with Legal and Sales to find a cceptable margins on terminations while maintaining customer experience

Confidential, Greenwood Village, Colorado

Loan Servicer and Budget Analyst

Responsibilities:

• Perform financial analysis on commercial properties serviced under our care.
• Analysis includes debt coverage ratio, net operating income, rents, market analysis.
• Manage escrow payments for clients on insurance and taxes.
• Create reports using Access and Excel incorporating filters and pivot tables
• Work with CRM software and develop basic SQL knowledge and data base management
• Conduct insurance certifications reviews for managed properties, verifying policy conditions and coverage amounts with the lender's requirements
• Develop and maintain relationships with agents and borrowers; complete quarterly investor certification reviews
• Lead a project on data management, improving the efficiencies with our daily processes