Eric Erba

•Extract source data from a variety of systems: o Clickstream data from Google Analytics. o User demographics, event reservations and sales from Umbraco Web Content Management. o Email campaign statistics from MailChimp. • Transform and normalize data sources in Excel, Access (SQL queries) and SQL Server. • Create derived attributes to existing dimensions by adding calculated fields with Access queries, T-SQL, Excel functions and DAX formulas. • Substantial development of measures with DAX formulas in

• Design, create, and maintain a WordPress blogging website. • Research, sign up, and become familiar with relevant affiliate programs rules and specifications. • Market website through social media sites with daily postings and interactions with readers. • Gather affiliate media and news content to be processed and posted on a monthly basis. • Maintain content library of photos, videos, and documents by using Aperture for image storing. Remaining media is archived according to campaign status. • Cons

Captured and edited video content in standard and high definition. Responsible for making editing decisions based on client’s marketing objectives and industry business requirements. All content sound and color corrected in Final Cut Pro to meet quality standards. Created motion graphics for promotional trailers, title sequences and DVD menus. DVD authoring. Music loops and sound effects editing. Content encoded into various distribution formats including Windows Media, QuickTime and Flash.

• Coordinated the production of Continuing Medical Education (CME) Videos. • Created and maintained production schedules. • Contracted crew and reserved location space for production. • Confirmed physicians’ (cast) participation in the production. • Coordinated the reservation of flights, ground transport and hotels for cast and crew. • Coordinated the creation of CME websites by contracting and managing graphic artists and web administrators. • Met Accreditation Council for Continuing Medical Education (AC

• Created DVD menus and authored trailer reels on DVD showcasing the company’s movie library. Trailer reels were used in major film markets like Marche Du Film in Cannes and the American Film Market. • Edited trailers to meet Video-On-Demand Green Band standards by removing nudity, excessive violence and other objectionable language and content. • Encoded promotional video content in Windows Media and QuickTime formats for social media distribution. • Coordinated the delivery of media acquired for distribu