George Mansour Shams

Owner and Co FounderFreelance / Project

• Job Details:Owner and co-founder of SIC for information consultancy, Data Analysis , ERP Application

MSC SENIOR ANALYSTFull Time

• Job Details:• Managing cross-functional synergy; leading 30 team members across Egypt, Gulf, South Africa and France to confirm uncompromising consistency in deliverables. • Prioritizing continuous improvement in analytic techniques/processes to fulfill operational Objectives, decision-making and strategic marketing actions. • Securing fulfillment of business and functional priorities by: • Orchestrate \Maintaining accountability for MSC Cairo as well as being EMEA Infra lead • Serving as database lead for the UAT of the new global marketing execution database • Developing and updating all spreadsheets enabling statistic collection/analysis of information Pertaining to engagement, invoicing and personnel • Cultivate improved processes and techniques related to MSC, to meet required expectations and business requirements. KEY ACHIEVEMENTS • Substantially hoarded and sustained contracts worth $500k in France through re built gap analysis, retrained team for operation rules & process and custom SQL scripts to match the French subsidiary requirements and business objects. • Successfully oversaw French “TechDays” campaign for 3 years, 2.5 million participant and budgeted around 1.5M Euros. • Thoroughly launched Global Marketing Execution Database for MEA, via data platform that enabled centralized campaign targeting/execution of the Worldwide Marketing universe. • Successfully Created\Developed\ Deployed 25 global reports, that statistically represent the centers global operational performance. More Details:  FY10 • Geographical team leader for WECA, Gulf, Saudi. • MSC Cairo Infra lead. • Responsible about all the non GMO tools(Create- test-Deploy and maintain) • SharePoint • Request forms • MTTA • Social forward • Email cleansing • SharePoint clean tool • Designed & developed some local Tools to facilitate the work process. • Post Processing auto matching ETL tool for MEA • DMC ETL tool for MEA  FY11 • Geographical team leader for WECA & South Africa • Subject matter Expert for online profiling Service • MSC Cairo Infra lead. • MSC Cairo DB Lead for the UAT of the new Global marketing Execution Database • Training the MSC team to SQL syntax and querying • Training the team on how to use the GMED tools. • Giving full support to the team, by making the tool Documentation, different scripts to be used, preparing some external resources as a guide, output some lookup sheets to facilitate the service execution.  FY12 • Service Account Manager for France, WECA & South Africa. • Subject matter Expert for online profiling Service. • MSC Cairo Infra lead. • Building the GAP analysis for the process of France sub & MSC Workflow • Developing the new process for MSC to be able to meet the French subsidiary expectation and business needs.  FY13 • Service Account Manager for France, WECA • Work with MSC clients/Subs to help them understand MSC service • Offerings provide database, digital and marketing consultation on how those services can be used to optimize campaigns. • Gather requirements as to what data and or application issues the team faces that need to be resolved with MSC’s technical counterparts. • Responsible for all work done for his client/subsidiary within the MSC to meet client SLAs. • Work closely with MSC team to ensure that the requirements of every project submitted for execution are clear and achievable. • Prepare written analysis and present findings to internal and external clients. • Contribute to project planning and scheduling. • Attendance, completion, and participation in new GMP tool deployments, updates, and trainings as required. • MSC Cairo Infra lead.  FY14 • Service Operation Planner for France, WECA • MSC Cairo Infra lead. • Participated in the UAT\Implementation of the Global Services Gateway GSG, for Microsoft Centers world wide  FY15 • EMEA Infra Lead –member of Global Business Support team- • Work in a global marketing environment, • Perform system analysis and technology design. • Responsible for reviewing the operating systems, testing system adequacy • Developing new Windows-based applications to support and optimize the business unit's operations. • Use computer hardware and software, solve complex problems, and discuss system improvement options with peers and management. • Responsible marinating Global Tools • Responsible about designing\Creating Global reporting • Manage multiple projects. • follow up with different Dev.\Support teams to be updated with the current status of new\Running tools development struts, bugs reporting\resolving • Participate in the UAT of global tools to make sure it meets requirements and design principles

SENIOR DATABASE ADMINISTRATOR / SENIOR APPLICATION DEVELOPERFull Time

• Job Details:SENIOR DATABASE ADMINISTRATOR / SENIOR APPLICATION DEVELOPER • Established detailed program specification through discussion with clients and broke it down to simplest elements and translated this logic into a programming language. • Spearheaded development tasks to drive innovation and scalability in line with best industry practices. • Designed and developed complex application systems using advanced technology platforms. • Monitored performance and managed parameters to provide fast responses to front-end users, installed and tested new versions of DBMS.  Key Projects: • Heliopolis company for housing and development, • Egyptian Meteorological Authority. More details: • Transform data into relevant information, to decision makers to positively impact the business. • Delivering appropriate data & Information for different departments to achieve their objectives. • Administrate Different DB implemented according to customer's requests. • Operate security techniques on the DB, to insure max. DB efficiency and security. • Monitoring DB behaviors and maintain its working efficiency. • Perform regular DB backup, checking, maintenance plans. • Applying DB corrections to ensure the data compatibility with the DB. • Write, update, and maintain software packages to handle specific jobs. • Performing Unit testing on all features developed. • Raise appropriate queries when in doubt regarding system specifications. • Write documentation of program development and inserting comments in the coded instructions so others can understand the program. • Share the knowledge with the project team • Correct errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced. • Set operational specifications and formulate and analyze software requirements