Rana Hany Ashour

Digital Marketing AnalystFull Time

• Job Details:• Work on performance marketing planning and execution using cutting edge marketing, data and analytics technologies • Monitor market trends, research consumer markets and competitors’ activities to identify opportunities and key issues • Report using social media tools/applications, qualitative and quantitative content analysis of all digital channels’ performance, design and strategy • Microsoft Excel skills, understanding and applying Excel formula, working with Pivot Tables etc. • Tools utilized for reporting and engagement performance presentations: Crowd Tangle, Twitter Analytics, Google Analytics, YouTube Analytics, Tableau, Microsoft Excel/Power point) • Lead creative sessions for project kick offs and provide new/fresh ideas to support marketing activities and campaigns • Guide and organize campaign productions from concept to execution • Coordinate between business development team and client to ensure execution excellence of social media campaign developments

Data Management Specialist (CRM) , Sales Force EffectivnessFull Time

• Job Details:• Oversee and monitor sales and visit entries in the sales system for each month and quarter – as required - while maintaining the historical data for sales achievements. • Daily Visits report by Checking Visits On CRM system and make Daily Report • Visits Frequency Make conclusion. select Physicians with high potential from potentiality sheet and look to their frequency from frequency sheet • Products calls by Creating Monthly Report for Products calls & Make conclusions • Manager's Visits regular report to CRM and analysis reports for Managers visits by Collecting Marinating and updating complete and then analyze data within required time frame within 1st week of each month. • Writing Memos and letters upon request • Collect complete data from medical reps & Coding new physicians and firms to CRM (PULPO) and correct any data entry errors. • Maintaining the Documentation system as soft and hard copies • Update any new data added to CRM (PULPO) for sales Team and link them with their areas & also Update Structure on CRM PULPO and follow up with managers with any inquiry • Build Convertor Sheet for Sales data to be uploaded to any system. • UCP Weekly Sales Stock + History Analysis • Update Customers Segmentation for All Areas through Potentiality Sheet. • Exporting sales reports and revising it to be sent to direct manager or as required. • Prepare the Weekly visits report including the sales system In and Out – as required displaying visits for each medical representative, preparing a conclusion for medical representative performance to be sent to managers.. • Determining medical reps problems in sending daily visits reports