Karim Mikhail Email and Phone Number

Member of the One Firm Analytics team that supports both Human Capital and Finance reporting needs.Partners with functional and stakeholder groups to evaluate, assess and assist in the implementation of new reporting activities to the various groups.Assists with ad hoc data requests and questions that arise through tickets around reporting questions/issues through Service Now.Automate Processes and reports through Alteryx and Tableau.Perform exploratory data analysis of new data sources and rapidly prototype datasets.Data modeling to use in a wide array of analytics and BI products.Conducted requirements gathering sessions to gather business requirements and was involved in documentation of business requirement. Conduct design sessions with stakeholders to understand the design and layout concept. Create activity diagram and data flow diagrams for the process and helped in identifying the use cases as per requirement. Closely interacted with the technical team and made sure that all requirements are met.

Responsible for supporting BI projects and initiatives on behalf of clients across the company, including Gift Registry, Big Ticket, Store Fulfillment, Vendor Fulfillment, and Merchandising areas.Assisting, documenting, and communicating results from BI projects to management and senior management.Supporting analytics research and consultation. Creating and refreshing analyses to support unique customer, client, and MCCS projects.Representing business clients and generating business requirements for technical teams to create new data sets and sources.Creating new reports and dashboards to sustain or complete project iterations; providing insight and feedback to management regarding key client/project performance and trends.Contributing ideas for enhancements to reporting to help drive sales within the department.

Creating, updating, and maintaining large-scale data products to help answer varying questions about the business.Perform exploratory data analysis of new data sources and rapidly prototype datasets.Conducted requirements gathering sessions to gather business requirements and was involved in documentation of business requirement. Conducted design sessions with stakeholders to understand the design and layout concept. Creating, updating, and maintaining large-scale data products to help answer varying questions about the business.Perform exploratory data analysis of new data sources and rapidly prototype datasets in partnership with business analysts.Model data for use in a wide array of analytics and BI products.Write custom SQL statements to pull data from a variety of databases including MS SQL Server, DB2, and Hive, Write multiple SQL queries for modifying records (insert, update & delete) in the backend database, performed JOINS on multiple-tables for data extraction. Deployment of Business KPI’s in fully dynamic dashboards. Update and maintain existing datasets and reports.Validate dataset and report accuracy.Present findings to senior level management.

Tableau-Conducts weekly audit- maintenance and skills auditTableau -Reports verification and Agent tracesCreate agent groups and access levels to CMS skillsMacys Portal-Facilitate file movement to partner center/work together with L&D in files access and verificationMacys Portal-Maintain user access and tools/web parts creationMacys Portal-Work together with Portal Admin for access levels and reporting needsReports-Responsible for streamlining current reportsDaily reports/requests due to different business needs and LOBsReports-Maintain and Modify specific reports for each LOB (Phones, Backline Stats, Rosters, Line Requirements)Billing Adjustments, SCC and Live Chat Productivity, Accuracy, Function, TAT, PPH, Survey, and Audit Portal ReportsReports-Right now (Oracle) Productivity and Incident ReportsOffshore technical calls participation and serve as liaison between Partner Center and MST Follow up on systemic outages and call drops with Solutions/MST/SecuritySystem Security check report (quarterly)Verify accuracy on Partners rosters

Maintain regular contact and visit existing and potential clients to ensure current and new business is developed.seek out, evaluate and develop new business opportunities through organic growth/new product development to maximize revenues.Regularly review and monitor competitive Travel Market and identify new leads to ensure that sales opportunities are maximized.Monitor sales figures and report on a weekly, monthly and quarterly basis.provide Agent support and information on any new developments, sales tools, marketing opportunities, trend information.Examine the short and long term development of the product throughout the marketplace, in order to identify new business/acquisition opportunities.understand the budget and work within those constraints, update the budget tracker and perform regular and accurate forecasting.Initiates and coordinates development of action plans to penetrate new marketsAssists in the development and implementation of marketing plans as neededProvides timely, accurate, competitive pricing on all completed prospect applications submitted for pricing and approval, while striving to maintain maximum profit marginCreates and conducts proposal presentations and RFP responsesAssists Account Executives in preparation of proposals and presentations. Controls expenses to meet budget guidelines. Adheres to all company policies, procedures and business ethics codes and ensures that they are communicated and implemented within the team.

Develop and publish the Company’s website (www.amexfranchise.com).Develop a marketing plan for Egypt based on company strategies and targets.Ensure a clear branding, promotion and communication concept for products and services.Plan customer based events.Analyze and drive improvement of customer feedback from the website.Prepare media plan for advertising in local (regional) trade press, newspapers, publications.Monitoring the traffic and headcount of users logging to the website.Analyse and communicate traffic reports to the Board.

Marketing Specialist and Quality control (November 2008 to June 2010)IT Coordinator Develop a marketing plan for Cairo region based on company strategies and targets.Ensure a clear branding, promotion and communication concept for products and services.Analysis of LCAG current product and portfolio within the region, based on sales, profits and soft facts.Plan customer based eventAnalyze and drive improvement of customer feedbackPrepare media plan in coordination with head office, coordinate press releases, interviews, etc.Advertising in local (regional) trade press, news papers, publications.External/ internal communication ( Staff newsletters, inter/intranet publications, etc)Monitoring of all relevant quality and process key performance indicator in Cairo region.Analyse and communicate quality reports to the region.Export Supervisor and IT coordinator (January 2008 to October 2008)Worked as night Supervisor on duty to supervise export and import.Maintain Work process and guarantee workflow.Effective allocation of man power into shifts thought planning issuing duty rosters.Staff development thought annually performed appraisals and employee discussions.Performance reportingCargo Agent logistics and IT coordinator ( November 2004 to December 2007)

Assembling PC’s & Servers.Customer support and service call.Troubleshooting (PC’s & Laptop’s)Troubleshooting networks in more than a companyInstalling and troubleshooting ISDN modems.Installing and maintaining ISA proxy server.Administrating network and maintaining PCs in the French cultural centre and the French counsel. Installing wireless network in several sites.Participated in Green Plaza market show as company rep. (2003).Participated in D-link workshop as an ISDN representative.

Administering a network of 30 stations (PCs & Macs).Maintaining PC’s & Macs.Troubleshooting (PC’s & Laptop’s).