John Melek

John Melek

$15/hr
Market & Data research/analysis
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
35 years old
Location:
Cairo, Cairo, Egypt
Experience:
5 years
John George Naguib EDUCATION Bachelor of Science, German University in Cairo ~ Sept. 2007 to June 2012 Major: Materials Engineering Thesis Project: Finite Element Analysis for Laminated Composite Materials Cumulative GPA: 2.08 (German system; stands for B) Ranked 6th High School / Thannaweya Amma, Patriarchal college (exe. Freres) ~ Sep 2005 to June 2007 Overall Grade: 91.2% WORK EXPERIENCE Social Media Research Analyst, Crowd Analyzer – CAI, Egypt ~ Nov. 2019 to Present. ✓ Create new Boolean queries with the highest quality to harvest data from the internet. ✓ Work on data accuracy and relevancy when needed. ✓ Design and move blank ideas or client requests to a documented research starting from communicating with research stakeholders, setting the right metrics, to delivering the research findings. ✓ Translate data into observations to findings to insights and lastly practical recommendations. ✓ Write reports in English or Arabic with the highest quality in data analyzed, the story told, and visualizations used. ✓ Communicate, align, and organize the projects with the product, marketing, or business departments. Marketing Solutions Analyst, Ignite Technologies Inc. – TX, United States ~ Nov. 2017 to Oct. 2019 ✓ Leveraging the company’s tools and software to analyze data, find useful insights, and help customers get a better understanding on their current place in the market, their business needs, and their keys to growth. ✓ Deep-diving into large datasets using SQL and Python to gain insight, maintain database quality, and complete customer ongoing requests. ✓ Building and maintaining models with AI technologies to support customers’ sales and marketing goals and efforts. ✓ Acquiring knowledge and experience in over 6 sales and marketing software solutions (e.g. Infer, Synoptos, FirstRain) as well as also training others on the platforms. ✓ Using CRM tools for data integration, analysis and insights (e.g. Marketo, Pardot, Hubspot, Salesforce) ✓ Delivering presentations and conclusions/discussion points to customers and senior leadership in order to drive key business decisions. ✓ Working on customer-specific problems and proactively finding causes, solutions, and opportunities for growth. ✓ Performing analyses for customer’s social media usage and performance as well as managing their UGC social campaigns. ✓ Daily experience using Zendesk, JIRA, GTM, Confluence to manage projects and virtual meetings and communication. Brand Specialist, Toolbox Marketing Consulting – Cairo, Egypt ~ July 2017 to Oct. 2017 1 ✓ Managing three main accounts (in the Real Estate, Electronic Accessories and Home Appliance markets), taking charge of the research, planning, development and execution of all their marketing activities. ✓ Coordinating and managing content and information among internal departments and external customers. ✓ Developing budget allocation, media planning, buying, and innovation strategies. ✓ Supporting customers in reaching brand consistency & growth, profitable sales, and consumer loyalty. ✓ Analyzing category and cluster marketing plans to align with customer’s brand strategy and achieving annual operating plan goals. ✓ Developing and executing brand management plans, using customer insight data to identify brandbuilding areas. ✓ Developing accountability structure for stakeholders. ✓ Maintaining and enhancing agency and partner relationships. ✓ Ensuring all brand communication is consistent with the company and brand positioning. ✓ Providing design and direction for collateral, web, product packaging, and other visual communications. ✓ Assisting in the development and refinement of uniform graphic standards and visual brand strategies. Account Executive, The Media Republic - Cairo, Egypt ~ Sept. 2016 to July 2017 ✓ Meeting and liaising with clients to discuss and identify their advertising needs. ✓ Understanding client’s brief and budget and working with team to create marketing campaigns that line up with those. ✓ Working with the account manager to formulate marketing strategies and brief and assist the media, creative and research teams. ✓ Liaising with and acting as the link between the suppliers and advertising agency and maintaining regular and effective communication with both. ✓ Negotiating with clients and agency staff about the details of campaigns. ✓ Presenting creative work to clients and ensuring that any modifications needed are executed correctly and on-time for client’s approval. ✓ Writing ongoing client reports. ✓ Handling budgets, managing campaign costs and invoicing clients. Market Research Analyst, Peugeot CDCM - Cairo, Egypt ~ Jun 2014 to Jan 2016 ✓ Building ongoing market research reports of the automotive market in Egypt (studying sales, after-sales services, and marketing activities) to identify Peugeot’s current position and performance in the Egyptian market. ✓ Analyzing findings and data collected using Excel and other tools to support in setting the sales plan and pricing strategy as well as enhancing/directing Peugeot’s positioning and future marketing activities. ✓ Coordinating among all departments in order to understand each team’s objectives to develop and deliver business plans annually to senior leadership. ✓ Leading an ongoing co-branding campaign with Bridgestone Egypt and ensuring all branding is implemented as planned. ✓ Co-planning and organizing events (e.g. Automech Formula, Peugeot’s sponsorship of Cairo Runners, Peugeot’s new car launch events, Test Drives, Summer events) and communicating and following-up with advertising agencies. ✓ Delivering multiple presentations to senior leadership of Peugeot Middle East + worldwide. ✓ Revising articles for Peugeot's PR and communicating with the Press. 2 Technical Office Manager, Metal Tube for Scaffolding and Form Working ~ Jun 2013 to Dec 2013 Production Line Engineer, Green Pack for Packaging - Cairo, Egypt ~ Jan 2013 to May 2013 Simulation & Modeling Engineer, National Research Center - Cairo, Egypt ~ Jul 2012 to Sept 2012 Customer Service Agent, Stream Global Services - Cairo, Egypt ~ Feb 2011 to Jun 2011 VOLUNTEER EXPERIENCE Co-organizer of Students' Union Elections, German University in Cairo ~ Oct 2012 Organizing and planning of the full independent Student Union Elections in the university where I also coplanned and organized the elections and took responsibility of managing a full team. Co-organizer of Students Bylaws Referendum, German University in Cairo ~ Sept. 2012 SOFTWARE/SYSTEM SKILLS ✓ Excellent knowledge of Microsoft Office (Word, Excel, PowerPoint) ✓ Daily experience using GTM, Zoom, Jira, Confluence, Crossover, Zendesk ✓ Significant experience using CRM tools (Marketo, Hubspot, Pardot, Eloqua, Salesforce) ✓ Professional knowledge of Javascript, HTML, CSS languages ✓ Intermediate knowledge/experience of Python, XML, SQL languages ✓ Great knowledge of AutoCAD, ProE, Abaqus, Ansys, CNC programming ✓ Fair knowledge of Sketch Up LANGUAGE SKILLS ✓ Arabic: Mother tongue ✓ English: Excellent/fluent speaking, reading & understanding ✓ French: Fair speaking, good reading & understanding ✓ German: Fair speaking, reading & understanding OTHER SKILLS ✓ Presentation - preparing, creating, and delivering ✓ Research & writing ✓ Acting ✓ Writing & Directing plays PROFILE Date of Birth: April 18, 1990 Place of Birth: Cairo, Egypt 3 Military Status: Exempted
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.