Basic Info

George Shams

More than 15 years

Cairo Governorate, Egypt

Bachelor's Degree

Experienced

Work Experience

MSC SENIOR ANALYST at Wunderman

Experience Details

MSC SENIOR ANALYST

Operations/Management

Experienced (Non-Manager)

• 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


Company Details

Wunderman (multinational)

Cairo, Egypt

101-500 employees

Marketing and Advertising

http://www.wunderman-me.com/

Sep 2009 to Jul 2015 (5 years 10 months)
SENIOR DATABASE ADMINISTRATOR / SENIOR APPLICATION DEVELOPER at PrimaSoft

Experience Details

SENIOR DATABASE ADMINISTRATOR / SENIOR APPLICATION DEVELOPER

IT/Software Development

Experienced (Non-Manager)

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


Company Details

PrimaSoft

Cairo, Egypt

51-100 employees

Computer Software

N/A

Jun 2008 to Sep 2009 (1 year 3 months)
SENIOR DATABASE ADMINISTRATOR (Part-Time / Freelancer) at Synergy Professional Services

Experience Details

SENIOR DATABASE ADMINISTRATOR (Part-Time / Freelancer)

IT/Software Development

Experienced (Non-Manager)

SENIOR DATABASE ADMINISTRATOR (Part-Time / Freelancer)
• Mapped and built database maintenance plan for Juhayna SAP system, which enhanced the reporting System by 70%.
• Supported Suez Cement in creating log shipping process over SAP.
• Sustained the security and integrity of data and examined database efficiency.

 Key Projects
• Juhayna SAP system: Accomplished 70% improvement in reporting system; mapped and built database maintenance plan.
• Suez Cement: Played an integral role in developing log shipping process over SAP.


Company Details

Synergy Professional Services (multinational)

caior, Egypt

101-500 employees

Information Technology Services

http://www.globalknowledge.com.eg/

Jun 2008 to Sep 2008 (3 months)
SOFTWARE TEAM LEADER at Solutions 'System Development Technology'.

Experience Details

SOFTWARE TEAM LEADER

IT/Software Development

Manager

SOFTWARE TEAM LEADER
• Analyzed customer requirements to create fundamental architecture of software program as well as directing all staff involved in the project.
• Mentored new or lower-level staff and trained them to positively meet the objectives within the timeframe.


Key Projects
• Women Development Organization Loaning System
• Helal Akhder Hospital Clinics workflow system.
• Egycare for medical Insurance
• Demerdash NICU.



More Details:
• Analyze-Design-Develop-Implement Different Systems Required according to customer's needs and requests.
• Analyze/Study company’s systems and validate them with market requests.
• Design/Implement different extra add-ons modules to be added to the current versions.
• Validate study the current DB for the working on projects.
• Migration of the DB environment, to enable validity of the current systems with different DB engines.
• Training Support team members to be familiar with the state of the arts technology.


Company Details

Solutions 'System Development Technology'.

Cairo, Egypt

11-50 employees

Computer Software

N/A

Sep 2007 to May 2008 (8 months)
SENIOR DATABASE ADMINISTRATOR / BUSINESS ANALYST at British American Tobacco (BAT)

Experience Details

SENIOR DATABASE ADMINISTRATOR / BUSINESS ANALYST

IT/Software Development

Experienced (Non-Manager)

SENIOR DATABASE ADMINISTRATOR / BUSINESS ANALYST
• Spearheaded industry best practice enhancements via implementation of ITIL methods.
• Boosted the production by designing various system interfaces to integrate the work & departments.
• Standardized business processes between marketing, trade, finance and supply chain.
• Designed various system interfaces to integrate the work and departments for added cost control, seamless collaboration and production gains.

 Key Projects/Achievements
• DRP: Significantly created Disaster Recovery Plan for BAT Trade system, to switch to backup network and servers in case of disasters; resulted on allowing operations and sales transactions as well as running variety of reports. It was succeeded by 95%.
• Rerouting: Successfully managed customers routing updates projects to equiliberly distribute customers on all routes geographically balanced according to the sales effectiveness
• Reporting Server: Successfully launched\Deployed\Published OLAP reporting server with 50 different reports that serves different cross functional department.
• RCS: Project key point between BAT and Different technical GIS suppliers to provide the required mapping technology to be able to represent our info through GIS systems.



More Details:
 Database Administrator
• Administration/Maintenance of the Trade System Database
• Act as Trade System (Route Power 32) Key Player.
• Leading the IT business support team to give high performance service.
• Trade system automation.
• Maintaining the Trade System Cycle Business Procedures.
• Maintenance of HHC Hardware & software.
• Data coordination between Marketing, Trade, Finance & Supply Chain “Factory /Warehouses” Departments in Business Processes.
 Senior Database Administrator
• 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 the whole system sides. (Database, reporting, Work Procedures, Hardware, Servers).
• Posting/Monitoring/Supporting Data Exported from trade system to the SAP System.
 Business Analyst
• Analyze/Study different department requests/cases to provide different solutions.
• Design/Implement Different Programs/System Interfaces to make the working systems integrated together and achieve business requirements.
• Retail Consumer Census –RCS- Project coordination between different embedded departments and the Supplier.
• Act as The IT Key Person in the RCS Project.
• Training and Development of IT (Local/Region)/Employees Trainees before/After joining our Teams.


Company Details

British American Tobacco (BAT) (multinational)

Cairo, Egypt

501-1000 employees

FMCG

http://www.bat.com/

Jul 2005 to Aug 2007 (2 years 1 month)
SENIOR APPLICATION DEVELOPER at BBS International

Experience Details

SENIOR APPLICATION DEVELOPER

IT/Software Development

Experienced (Non-Manager)

SENIOR APPLICATION DEVELOPER
• Participated actively in development and review of WinPOS (Point of Sale) and deliver accurate solutions based on business needs.
• Met functional specifications and user requirements; supported development and reviewed of WinPOS (Point of Sale)
• Evaluated effectiveness/efficiency of existing systems to identify areas of improvement and initiate enhancement measures.

Key Projects\Achievements:
• Successfully deployed the VPN data transformation through a virtual WAN for EDS pharma and PACHI
• Successfully developed the Desktop Integrated Supply Chain Organizer system for EXXON Mobile.
• Building different reports for other clients HC, AKSA, NDC, minatel.

More Details:
• Development & customization of the WinPOS (Point Of Sale) according to business requirements (Hardware controlling ‘printers, Customer Displayers, Cash Drawers, etc……..).
• Site-Head office connection solution using a VPN (Virtual Private Network), where bi-directional data transfer is done between Site & head office.
• Development & maintenance of the (Brokerage-GDR).

Customers
• EDS ‘Egyptian Drug Stores’ CARE Pharmacy Series.
• PACHI chocolate and souvenirs
• DISCO (Desktop Integrated Supply Chain Organizer) for Exxon Mobile Company.
• Brokerage-GDR Systems for HC Brokerage (S.A.E)
• AKSA textile Company
• NDC ‘National Drilling Company’.


Company Details

BBS International

Cairo, Egypt

11-50 employees

Computer Software

N/A

Oct 2003 to Jun 2005 (1 year 8 months)
APPLICATION DEVELOPER at Solutions 'System Development Technology'.

Experience Details

APPLICATION DEVELOPER

IT/Software Development

Entry Level

APPLICATION DEVELOPER
• Spearheaded the comprehensive application development cycle:
o Process, life cycle, creation of software to complete a computer task or program


Key Projects\Achievements:
• Cairo Chamber of Commerce: Seamlessly customized software for workflow automation (including HR, Finance, Stock control, Purchasing, Collection and Licensing)
• Helal Akhder Hospital: Seamlessly Customized ERP package for HR, Collection Dept workflow automation.


Company Details

Solutions 'System Development Technology'.

Cairo, Egypt

11-50 employees

Computer Software

N/A

Oct 2002 to Sep 2003 (11 months)

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.
• Recognition for improvements to SDL Dashboard.
• Appreciation for reactivity, reliability and effectiveness.
• Appreciation for support in event creation.
• Thank You credit for IT Support.


Key Projects:
• Heliopolis company for housing and development,
• Egyptian Meteorological Authority.



Key Projects
• Juhayna SAP system: Accomplished 70% improvement in reporting system; mapped and built database maintenance plan.
• Suez Cement: Played an integral role in developing log shipping process over SAP.



Key Projects
• Women Development Organization Loaning System
• Helal Akhder Hospital Clinics workflow system.
• Egycare for medical Insurance
• Demerdash NICU.



Key Projects/Achievements
• DRP: Significantly created Disaster Recovery Plan for BAT Trade system, to switch to backup network and servers in case of disasters; resulted on allowing operations and sales transactions as well as running variety of reports. It was succeeded by 95%.
• Rerouting: Successfully managed customers routing updates projects to equiliberly distribute customers on all routes geographically balanced according to the sales effectiveness
• Reporting Server: Successfully launched\Deployed\Published OLAP reporting server with 50 different reports that serves different cross functional department.
• RCS: Project key point between BAT and Different technical GIS suppliers to provide the required mapping technology to be able to represent our info through GIS systems.



Key Projects\Achievements:
• Successfully deployed the VPN data transformation through a virtual WAN for EDS pharma and PACHI
• Successfully developed the Desktop Integrated Supply Chain Organizer system for EXXON Mobile.
• Building different reports for other clients HC, AKSA, NDC, minatel.



Key Projects\Achievements:
• Cairo Chamber of Commerce: Seamlessly customized software for workflow automation (including HR, Finance, Stock control, Purchasing, Collection and Licensing)
• Helal Akhder Hospital: Seamlessly Customized ERP package for HR, Collection Dept workflow automation.



Recognition for improvements to SDL Dashboard. Appreciation for reactivity, reliability and effectiveness. Appreciation for support in event creation. Thank You credit for IT Support.

Education

College Diploma in Big Data and Data Science

Education Details

College Diploma

Big Data and Data Science

Nile University (NU), Egypt

B / Very Good / 75 - 85%

- Introduction to Big Data and

- Advanced Big data Analytics

Nile University (NU)
2015 - 2016
Technical Diploma in Systems And Software Development

Education Details

Technical Diploma

Systems And Software Development

Information Technology Institute (ITI), Egypt

B / Very Good / 75 - 85%

• ITI Courses: (Sept 2001 – Ju

Diploma of Software Development (Windows Platform) Information Technology Institute (ITI)

Information Technology Institute (ITI)
2001 - 2002
BSC in Systems And Biomedical Engineering

Education Details

BSC

Systems And Biomedical Engineering

Cairo University, Egypt

C / Good / 65 - 75%

Bachelors of Systems & Biomedical Engineering Faculty of Engineering – Cairo University

Bachelors of Systems & Biomedical Engineering Faculty of Engineering – Cairo University

Cairo University
1996 - 2001
High School - Thanaweya Amma

High School Details

Thanaweya Amma

TLS

Egypt

1996

A / Excellent / 85 -100%

N/A

TLS
1996

Certifications

Certificate details

ITIL® Foundation certificate in IT Service Management

Apr 2015

85 out of 100

N/A

OF32455557/00143589

BCS

Registration number: OF32455557
Certificate number: 00143589

Certificate details

Diploma of Big Data and Data Science

Jun 2016

75 out of 100

N/A

N/A

Nile University

- Introduction to Big Data and

Certificate details

Project management Professional

Jun 2012

85 out of 100

N/A

N/A

Global Minds

N/A

TOEFL
Jul 2001

Certificate details

TOEFL

Jul 2001

273 out of 300

N/A

N/A

AMIDEAST

N/A

Training and Courses

Training/Course Details

Project Managment Proffesional

Jun 2013

Global Minds

N/A

Training/Course Details

ITI Foundation Module

Dec 2002

Information Technology Instiute

1. Foundation Module: Theoretical Practical Introduction to Database SQL lab Introduction to object Oriented C/C++ Introduction to Networks INTERNET - TCP/IP Introduction to Operating System Unix & Windows2000 Decision Making - Primer software development - Presentation Skills -

Training/Course Details

ITI- Focus Moduel - SSDP

Apr 2002

Information Technology Instiute

Web Courses Database Courses. HTML SQL 2000 IIS 5 Power Builder 7 XML/SOAP PL/SQL PLUS + ASP Oracle Forms I JAVA Script Oracle Forms II Programming Languages Operating Systems JAVA TCP-IP VB 6 Windows 2000 Server .NET Platform (VB .NET, ASP.NET …) Windows 2000 Advanced Server

Training/Course Details

Work Experinec - & Self Studies

Dec 2014

Work Experiences

• MS SQL 2000 • MS SQL 2005 • MS OLAP Analysis Manager • IBM - DB2 • Oracle Database Engine • Sybase DB (8,9) • Power Designer (9) • Power Builder (7,8,9,10,11) • I5 • RP32 System (BO & FO) • Norand Communication System • MS OCX, Active X components, DLL.

This profile is fresh!
Last update 6 days ago.

Jobseeker photo

Profile Skills and Keywords

APPLICATION DEVELOPERAdaptiveAnalyticalArabicBig DataBig Data And Data ScienceBritish American Tobacco (BAT)Business StrategyBusiness-orientedComputer LanguagesComputer SoftwareCreativeDATABASE ADMINISTRATIONData ScienceData StructuringDiploma Of Big Data And Data ScienceDriving One MS BrandERPEnglishFMCGField SupportFlexibilityFlexibleFrenchGlobal Bribery & Code Of EthicsGlobal Marketing Operations EssentialsHard WorkerIBM DB2ITIT ANALYSTITI Foundation ModuleITI- Focus Moduel - SSDPITIL CertifiedITIL Foundation Certificate In IT Service ManagementInformation Technology ServicesJAVAMANAGMENTMS OLAP Analysis ManagerMS SQLMSC SENIOR ANALYSTManagementMarketing And AdvertisingMicrosoftMind Your Global MannersOracle Database EnginePMP) Project Management ProfessionalPower BuilderPower DesignerPower PivotProject ManagementProject Management ProfessionalProject Managment ProffesionalReadingSAPSENIOR APPLICATION DEVELOPERSENIOR DATABASE ADMINISTRATOR (Part-Time / Freelancer)SENIOR DATABASE ADMINISTRATOR / BUSINESS ANALYSTSENIOR DATABASE ADMINISTRATOR / SENIOR APPLICATION DEVELOPERSOFTWARE TEAM LEADERSoftware DevelopmentSportsSybase DBSynergy Professional ServicesSystem Design & ProgrammingSystems And Biomedical EngineeringSystems And Software DevelopmentSystems IntegrationTOEFLTasting FoodTravelingTroubleshootingUnixVendor NegotiationsWatchig MoviesWindowsWork Experinec - & Self StudiesWunderman

Self-assesed Skills

Languages

Arabic

Arabic

: Fluent

: Fluent

: Fluent

: Fluent

English

English

: Advanced

: Advanced

: Advanced

: Advanced

French

French

: Beginner

: Beginner

: Intermediate

: Beginner

Tools and Technologies

Global Bribery & Code of Ethics

Global Bribery & Code of Ethics

: Expert

: Extreme - I love it!

:

5-7 years

Global Marketing Operations Essentials

Global Marketing Operations Essentials

: Expert

: Extreme - I love it!

:

5-7 years

Microsoft

Microsoft

: Expert

: Extreme - I love it!

:

More than 7 years

Windows

Windows

: Expert

: Extreme - I love it!

:

More than 7 years

ITIL Certified

ITIL Certified

: Advanced

: Extreme - I love it!

:

3-5 years

MS SQL

MS SQL

: Advanced

: Extreme - I love it!

:

More than 7 years

MS OLAP Analysis Manager

MS OLAP Analysis Manager

: Advanced

: Extreme - I love it!

:

5-7 years

Power Designer

Power Designer

: Advanced

: High

:

3-5 years

Power Builder

Power Builder

: Advanced

: High

:

5-7 years

TOEFL

TOEFL

: Advanced

: High

:

3-5 years

Driving One MS Brand

Driving One MS Brand

: Advanced

: Extreme - I love it!

:

5-7 years

Mind Your Global Manners

Mind Your Global Manners

: Advanced

: Extreme - I love it!

:

5-7 years

PMP) Project Management Professional

PMP) Project Management Professional

: Intermediate

: Extreme - I love it!

:

5-7 years

Oracle Database Engine

Oracle Database Engine

: Intermediate

: Extreme - I love it!

:

1-3 years

Sybase DB

Sybase DB

: Intermediate

: High

:

1-3 years

Power Pivot

Power Pivot

: Intermediate

: High

:

3-5 years

Unix

Unix

: Intermediate

: High

:

1-3 years

ERP

ERP

: Intermediate

: High

:

5-7 years

SAP

SAP

: Intermediate

: Extreme - I love it!

:

1-3 years

IBM – DB2

IBM – DB2

: Beginner

: High

:

1-3 years

JAVA

JAVA

: Beginner

: High

:

Less than 1 year

Fields of Expertise

ERP

ERP

: Advanced

: Extreme - I love it!

:

5-7 years

Software Development

Software Development

: Advanced

: Extreme - I love it!

:

5-7 years

DATABASE ADMINISTRATION

DATABASE ADMINISTRATION

: Advanced

: Extreme - I love it!

:

3-5 years

MANAGMENT

MANAGMENT

: Advanced

: Extreme - I love it!

:

More than 7 years

IT ANALYST

IT ANALYST

: Advanced

: Extreme - I love it!

:

5-7 years

Project Management

Project Management

: Advanced

: Extreme - I love it!

:

5-7 years

Troubleshooting

Troubleshooting

: Advanced

: Extreme - I love it!

:

More than 7 years

Data Structuring

Data Structuring

: Advanced

: Extreme - I love it!

:

More than 7 years

System Design & Programming

System Design & Programming

: Advanced

: Extreme - I love it!

:

More than 7 years

Computer Languages

Computer Languages

: Advanced

: Extreme - I love it!

:

5-7 years

Field Support

Field Support

: Advanced

: Extreme - I love it!

:

More than 7 years

Business Strategy

Business Strategy

: Advanced

: Extreme - I love it!

:

More than 7 years

Systems integration

Systems integration

: Advanced

: Extreme - I love it!

:

More than 7 years

Vendor Negotiations

Vendor Negotiations

: Advanced

: Extreme - I love it!

:

More than 7 years

Data Science

Data Science

: Beginner

: Extreme - I love it!

:

1-3 years

Big data

Big data

: Beginner

: High

:

Less than 1 year

Key Skills

Analytical, Business-oriented, Hard worker, Creative, Flexible / Adaptive

Online Presence

https://eg.linkedin.com/in/george-shams-itil®-07bba22https://www.facebook.com/george.shams/abouthttp://people.bayt.com/george-shams/

George is looking for new exciting career opportunities… Please share…

Get Your own Wuzzuf Profile Now !

Employer? If you're representing an organization or an enterprise, Signup here for FREE to see George's full profile and find more great talent and professionals to join your team.