Rachael E Mcclellan Email & Phone Number

Colorado Springs, CO, US

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

• 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

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

These are skills, programs, systems that I have familiarity with working in as an end user. I am also proficient with Microsoft Office Suite.

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

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

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

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)

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.

Louisville, Kentucky Area

• Maintained a safe play/learning environment.
• Researched and developed group curriculum/activities (art, science, physical, math etc.)

Honors

Activities and Societies: • Beta Club • Marching/Concert Band • Varsity Basketball • Varsity Softball

Environmental Studies

Activities and Societies: • Varsity Basketball

Environmental Studies

Activities and Societies: • Garrick Players

Business Management