Rachael E Mcclellan

Rachael E Mcclellan Email and Phone Number

Revenue Assurance Analyst II @ Lumen Technologies
Colorado Springs, CO, US
Rachael E Mcclellan's Location
Colorado Springs, Colorado, United States, United States
Rachael E Mcclellan's Contact Details

Rachael E Mcclellan work email

Rachael E Mcclellan personal email

Rachael E Mcclellan phone numbers

About Rachael E Mcclellan

Experienced business research analyst with 15 years related work experience. Proven ability in retrieval and entry of specialized client information to improve internal reporting tools and systems. A strong aptitude for learning computer applications quickly and efficiently. Deals well in group situations but also able to be individually motivated. Excels at dealing with abstraction and thinking of new approaches while looking for future consequences Expertise includes strong customer service skills; built stronger relationships with other agencies. • Computer processing skills to include database management (Oracle, Hyperion/Brio, Siebel, SQL and custom applications).•Microsoft Office Suite (Word Excel, PowerPoint, and Outlook). • Strong aptitude for learning computer applications quickly. • SEC EDGAR System, OneSource, Corporate Affiliates, Dun & Bradstreet, Corporate Websites

Rachael E Mcclellan's Current Company Details
Lumen Technologies

Lumen Technologies

View
Revenue Assurance Analyst II
Colorado Springs, CO, US
Website:
lumen.com
Rachael E Mcclellan Work Experience Details
  • Lumen Technologies
    Revenue Assurance Analyst Ii
    Lumen Technologies
    Colorado Springs, Co, Us
  • Lumen Technologies
    Revenue Assurance Analyst Ii
    Lumen Technologies Apr 2014 - Present
    Colorado Springs, Colorado, United States
    • Audit and evaluate customer’s invoices, contracts, and orders to ensure revenue (ETL) is billed appropriately• Research services, related orders, MSAs and any amendments to provide an Early Term Liability Estimate • Extract data from contract management, provisioning and billing systems for analysis • 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 ETL • Accurately interpret standard and non-standard contracts
  • Brooksource
    Early Term Liability Analyst
    Brooksource Jun 2013 - Apr 2014
    • Audit and evaluate customer’s invoices, contracts, and orders to ensure revenue (ETL) is billed appropriately• Research services, related orders, MSAs and any amendments to provide an Early Term Liability Estimate • Extract data from contract management, provisioning and billing systems for analysis • 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 ETL • Accurately interpret standard and non-standard contracts
  • Brooksource
    Early Term Liability Analyst
    Brooksource Jun 2013 - Apr 2014
  • Visa
    Dispute Analyst
    Visa Sep 2012 - Feb 2013
    Greater Denver Area
    • Classified disputes and determined which category they belonged with regard to Visa Inc and corresponding Banks policies and procedures. • Applied relevant laws and regulations to create cases, issue credit and resolve cases when applicable. • Created letters to notify cardholders of the status of the dispute.
  • Accounts Payable| Research | Data Entry | Oracle | Hyperion/Brio | Siebel
    Research Analyst
    Accounts Payable| Research | Data Entry | Oracle | Hyperion/Brio | Siebel 2011 - Oct 2012
    Accounts Payable| Research | Data Entry | Oracle | Hyperion/Brio | Siebel
    These are skills, programs, systems that I have familiarity with working in as an end user. I am also proficient with Microsoft Office Suite.
  • Probuild Holdings
    Master Data Coordinator
    Probuild Holdings Feb 2012 - Mar 2012
    Greater Denver Area
    • Data clean up and accuracy for project to merge multiple systems into a single system.• Verified product information via company website/direct contact with manufactures• Created spreadsheets with formulas to make data easier to mass load
  • Mercer
    Research Analyst
    Mercer 2009 - 2011
    Louisville, Kentucky Area
    • Researched and analyzed corporate structure of global family trees and corrected errors in internal database and maintained internal client database to reflect accurate corporate family tree information/structure• Assisted in establishing procedures and protocols to reduce duplicate clients and coding by 75%• Corrected family tree linkage/structure for over 60% of all client trees that generated over $100,000 in revenue• Created spreadsheet and reports in Excel using Pivot, VLOOKUP, HLOOKUP, Concatenate, graphs and formulas• Created queries using Hyperion/Brio and updated existing queries when applicable• Co-created a Wiki Page to document policies/procedures created with regard to duplicate coding, Family tree research and requesting updates from Dun and Bradstreet to update family tree linkage and company profiles• Attended and created reports for weekly staff conferences to provide management and with data and reports dealing with SLA’s , cleanup, products we used and services we provided • Monitored the global markets and followed market trends to update internal database when necessary • Updated, researched and maintained 80% accuracy on the Corporate Family Tree information/structure
  • Mercer
    Accounts Payable
    Mercer 2007 - 2009
    Louisville, Kentucky Area
    • Ensure compliance with all SOX and internal audit guidelines for setting up/maintaining global vendors in Oracle 11i.• Verification of Vendor information vial various sources (e-mail, internet, fax and phone)• Created new clients in Oracle, new paysites and maintained data accuracy with existing vendors (data entry)• 1099 maintenance• Reviewed invoices to insure correct documentation and approvals
  • Mercer
    Global Client Maintenance
    Mercer Oct 2005 - Oct 2007
    Louisville, Kentucky Area
    • Maintain data integrity of client databases• Verification of global clients names, addresses, D&B number (DUNS Number and corporate family tree linkage)• Primary liaison between Client Mangers and D&B representatives, regarding corporate family tree structure and company profile information (WebCAS - Mercer invoicing system and Siebel - Mercer marketing system)
  • Ymca Of Greater Louisville
    Site Director And Camp Director School Age Child Care
    Ymca Of Greater Louisville 2002 - 2005
    Louisville, Kentucky Area
    • Managed programs and supervised a staff of 4 to 12• Maintained accurate bookkeeping of payments made on a weekly basis for over 60 children.• Resolved conflicts among children by supporting their emotional and social development, encouraging understanding of others and positive self concepts.• Researched other childcare facilities and cultures and developed new activities • Communicated with children’s parents or guardians about daily activities, behaviors and related issues. • Served on the following committees: Curriculum, Staff Appreciation and Togetherness/Building Stronger Relationships.
  • Ymca Of Greater Louisville
    Group Counselor
    Ymca Of Greater Louisville 2001 - 2002
    Louisville, Kentucky Area
    • Maintained a safe play/learning environment. • Researched and developed group curriculum/activities (art, science, physical, math etc.)

Rachael E Mcclellan Skills

Accounts Payable Microsoft Office Powerpoint Excel Oracle Hyperion Brio Query Outlook Internet Research Customer Service Data Entry Data Analysis Business Structures Research Company Research Onesource Dun And Bradstreet Siebel Telephone Skills Independence Critical Thinking Thinking Outside The Box Strategic Thinking Analytic Thinking Creative Problem Solving Music Abstraction Optimistic Accounts Receivable Report Development Brio Reports Googling Microsoft Excel

Rachael E Mcclellan Education Details

Frequently Asked Questions about Rachael E Mcclellan

What company does Rachael E Mcclellan work for?

Rachael E Mcclellan works for Lumen Technologies

What is Rachael E Mcclellan's role at the current company?

Rachael E Mcclellan's current role is Revenue Assurance Analyst II.

What is Rachael E Mcclellan's email address?

Rachael E Mcclellan's email address is ma****@****ail.com

What is Rachael E Mcclellan's direct phone number?

Rachael E Mcclellan's direct phone number is +172088*****

What schools did Rachael E Mcclellan attend?

Rachael E Mcclellan attended Ballard High School, Eckerd College, Lake Forest College, University Of Phoenix.

What skills is Rachael E Mcclellan known for?

Rachael E Mcclellan has skills like Accounts Payable, Microsoft Office, Powerpoint, Excel, Oracle, Hyperion, Brio Query, Outlook, Internet Research, Customer Service, Data Entry, Data Analysis.

Who are Rachael E Mcclellan's colleagues?

Rachael E Mcclellan's colleagues are David Bailey, Brian Young, Jeff Nyul, Ratna Pratap Bellamkonda, Stacey Planz, Arleigh Smith, Patrick Beck.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.