Kyara Rafferty Email & Phone Number

Nashville, Tennessee, United States

As a Senior Analytics Engineer at BMG, I collect and analyze data to support key business decisions and improve company operations.• Collaborate with cross-functional teams to understand their data needs and develop data-driven solutions using advanced data manipulation techniques with SQL, Python, VBA, Tableau, Excel, and LookML.• Build data models from relational database systems using SQL and dbt.• Design and implement automated solutions to streamline business processes and improve workflow efficiency. • Create comprehensive reports and dashboards using Excel, Looker, Tableau, and Google Data Studio to deliver actionable insights to stakeholders across the organization.• Document processes on Confluence and utilize Git for version control.

Nashville, Tennessee, United States

As a Senior Analyst, Data & Reporting at BMG, I specialized in leveraging data to drive business outcomes and improve operations. I led the successful implementation of several global royalty data projects involving large, complex sets of data.• Collaborating with cross-functional teams to develop and implement data solutions.• Utilizing advanced data visualization and reporting tools such as Looker, Tableau, Excel, and SQL to create custom reports, dashboards, and data visualizations.• Writing and developing code in VBA and LookML and utilizing version control tools such as BitBucket.• Developing and implementing automated data solutions to streamline financial processes and reduce human error.• Performing income analyses and adjustment calculations, and reconciling financial transactions with royalty accounting data.My efforts resulted in significant improvements in data quality, accuracy, and efficiency, leading to more efficient and effective data management and analysis.

Greater Nashville Area, Tn

As a Manager of Mechanical Licensing at BMG Rights Management, I led the strategic development and implementation of new processes and tools within the mechanical licensing department. This included: • Creating and monitoring key performance indicators (KPIs) to measure department performance and identify areas for improvement. • Utilizing SQL and PowerQuery to create and maintain custom reports.• Writing Excel automation scripts to standardize deliverables and establish the process for bulk licensing.• Managing projects, conducting research, obtaining licenses, collaborating with other departments, and providing training for team members. My efforts led to significant improvements in departmental performance and efficiency.

Nashville, Tn

As a Senior Administrator at Warner Music Group, I led a team of licensing administrators to ensure the accurate and timely setup of top-grossing releases and sensitive artists for payment and licensing. My responsibilities included:• Analyzing and interpreting artist contracts.• Liaising with the business affairs team to confirm legal rights and their application.• Negotiating mechanical and synchronization royalty rates, resulting in cost savings for the company.• Collaborating with cross-functional teams to answer various internal and external inquiries.• Utilizing Sharepoint to organize and track a schedule of releases.• Training new hires on proprietary databases and systems.• Fielding questions, managing ongoing employee training, and mentoring team members in professional development.• Acting as point-of-contact for department supply orders and storage file requests, and managing inventory of offsite files.Notably, I created a collaborative quick-reference handbook for team members, which established written documentation for workflow processes and improved efficiency.

Burbank, Ca

As a Publishing Administrator at Warner Music Group, I successfully secured, negotiated, drafted, and reviewed mechanical and digital licenses for a high volume of releases in a fast-paced, deadline-driven legal and financial department.• Analyzing, interpreting, and applying mechanical provisions in artist recording agreements. • Negotiating synch licenses and fees for broadcast, streaming, and download.• Researching copyrights to confirm splits, publisher credits, payee addresses, and vendor information.• Collaborating with the Business Affairs team and other departments to facilitate workflow and clarify complicated legal questions for various top-priority artists and releases.• Synthesizing information from multiple internal systems to ensure the accurate setup of products. • Creating contract data briefs and performing royalty calculations.• Acting as the point person for office supply orders and training new employees and temps on various internal systems.• Processing check requests for mechanical and sync advances. • Establishing working relationships with other labels, publishers, administrators, accountants, and attorneys.

North Hollywood, Ca

• Receptionist/Greeter for yoga and workshop clients and wellness patients• Take care of all client needs including check-in, mat rentals, account inquiries, and any purchases using the MindBody software platform• Create promotional flyers & posters for special workshops, classes, and events for the studio.• Answer phones, field questions, take messages, manage cash box• Light studio cleaning, restocking of supplies, etc.• Provide light and kindness to all who walk through the door!

Greater Los Angeles Area

• Acted as production assistant for Basketball Wives LA (Seasons 2 & 3), Basketball Wives (Season 5), and Hollywood Exes (Season 2). • Worked with field and talent coordinators to ensure cast members arrived safely and promptly to set. • Acted as research production assistant on Who Do You Think You Are.

Greater Los Angeles Area

• Managed and directed five incoming phone lines, scheduled conference calls, assisted with expense reports, and liaised with various vendors. • Hired and supervised interns, ordered and managed inventory of office supplies, and researched travel arrangements. • Provided administrative support to an office of sixteen employees in Los Angeles, collaborated on projects with employees in the New York and London offices. • Used expertise in Photoshop and email marketing to improve newsletters and concert invite blasts.

Hollywood, Ca

• Read scripts and put together stills for pitch presentations. • Assisted producers by obtaining and organizing releases, coordinating with production vendors, organizing crew invoices and expenses, and assisting on set. • Maintained contacts and calendar for executive producers, drafted correspondence, researched travel arrangements, and helped build social media presence and brand.

Nashville, Tn

Assisted producers with research, transcriptions, on-location shoots, tape labeling and organization, and writing show summaries for GAC’s “Headline Country”. Watched and took notes during show run-downs, kept time codes during host wraps, and provided administrative support to show producers.

Nashville, Tn

Covered phones, filed and organized paperwork, and provided administrative support. Designed and created copy for student and industry email marketing campaigns, attended and gave input at professional development strategy meetings, created graphics, produced and coordinated video content for various college initiatives.

A member of the Pipeline Project team. The Pipeline Project is an entertainment industry solutions think tank. http://belmontpipeline.tumblr.com

Helped create a system for digitizing and archiving production materials. Created a system for organizing production supplies inventory. Assisted with office organization, production errands, and acted as a PA on several music video shoots. Gained valuable on-set experience as well as experience in casting and location scouting.

New York, Ny

Assisted producers by transcribing tapes, conducting research, giving input, and performing time-sensitive production errands throughout NYC. Assisted Casting Director of “The Seven” by recruiting audience members and helping coordinate their arrival and experience on the show.

New York, Ny

Assisted show producers by conducting research, fact checking, organizing, and going on production-related runs. Served as a production assistant to field producers during studio and remote location shoots.

Designed posters, t-shirts, program books, credentials, and other graphics for annual conference. Participated in brainstorming and implementation of creative marketing and promotion. Developed a street team and designed its rewards system while overseeing members.

Updated social media for artists, filed and organized paperwork, prepared and logged packages for shipment. Helped with street team development, reaching out to venues for booking opportunities, and creative artist promotion.

Created and managed website for artist, including graphics. Designed contests and promotion tools for street team. Promoted local shows.

Master Of Science - Ms, Analytics

Bachelor Of Business Administration (B.B.A.), Music Business And Audio Video Production, 3.9, Magna Cum Laude

Activities and Societies: Alpha Chi Honor Society, Beta Gamma Sigma, Service Corps, Towering Traditions Leader, Belmont Showcase Series.

4.2

Activities and Societies: National Honor Society, International Thespian Society, Spanish Club (1st Place Level II Poetry Recitation.