Business Intelligence Data Warehousing Data Management/Integration

Ayman A. Hady

** **-***** *** ****** Street, Nasr City, Cairo, Egypt

+2-010-***-**** *****.*****@*****.***

Business Intelligence Architect and Manager

Highly Experienced BI Expert, Excellent Project and Team Leadership

A comprehensive background in providing information solutions, data management, business analytics, and decision support related services. Vast experience in enabling BI tactical and strategic roadmaps, business plans. Highly skilled in modelling and architecture, experienced in initiating and maintaining project plans, developing and delivering innovative analytical applications with different report types, dynamic and interactive dashboards. Powerful communicator with strong track record of building, leading and motivating cross-functional teams. Bilingual (English and Arabic)

CORE COMPETENCIES

Business Intelligence Data Warehousing Data Management/Integration and Quality Program/Project Management Business Analytics Big Data Strategy execution & delivery Predictive Analytics modeling & Implementation Strategic/Financial Planning Resource & Team Management Leadership Software/Solutions Architecture & advisory

IT SKILLS

Operating Systems: Windows Linux SUSE/Mandrake DOS UNIX Apple OS

Database: Microsoft Oracle IBM DB2 Former DB(s) for Mobile Devices PL/T-SQL MDX DMX DAS

BI, Data Warehousing & ETL Tools: Microsoft: SSAS, SSIS, SSRS, SharePoint PPS, & 3rd Parties Oracle: OBIEE 11g & Hyperion EPM SAP: Business Objects XI Enterprise 4.2, Web Intelligence XI, 4.2, SAP Crystal Server 2013, Predictive Analytics 2.0 IBM Cognos 3rd Parties: QlikView, Dundas, and Tableau Server(s) Neuro Solutions SPSS

Programming Languages: C #, VB .NET MS Visual Basic MS Visual C++ J2EE, J2ME, Beans, EJBs, Servlets

Markup/Scripting Languages: ASP, ASP.NET JSP Java Script & AJAX HTML, XHTML XML/A, XSL, XSD

Software Design/Development: MS Visual Studio MS Visio Rational Rose MS SharePoint, Commerce, ISA, Exchange, Appliance & Projects Server(s) IBM Web Sphere Application Server

Miscellaneous: MS Office MS Project Professional/Server Corel Draw Adobe Photoshop

PROFESSIONAL EXPERIENCE

Electrolux, Cairo, Egypt 2008 – Present

Global appliance manufacturer with multi-national operations.

Software Development Manager, Information & Technology Sector

Create and lead high performance teams focusing on fulfilling the spectrum of the organizations information needs, enabling the corporate business processes through reliable & efficient software development solutions and services.

Modeled and project managed 23+ projects of Enterprise Application/Data Integration, Master Data Management, and Data Quality Management between Oracle ERP E-Business Suite R12 different modules and other SAP ERP/Custom/Infrastructure solutions. Saved 3 million EGP on offshore development/consulting.

Planned and implemented BI/DW strategy, roadmap, solutions, cascaded standards enabling organization’s strategy. Managed BI modeling and architecture, designing end-to-end BI solutions using Microsoft BI platform, Oracle ERP E-Business Suite, SAP ERP, and various applications and interfaces with oversight of EDW, ETL, and advanced analytical models. Key Highlights:

-Saved up to 20 million EGP on offshore development

-Helped in saving up to 30m EGP monthly revenue in operations, 15m EGP annually in cost saving/improvements cross functionally. Lost opportunities decreased by 25 million EGP. Order Fulfillment rate increased 60%. Production/Schedule Performance increased 22 %

Founded and led the BI competency center, liaising with stakeholders in leveraging information delivery and observing with them the potential of knowledge discovery. Qualified information delivery and data integrity audits

-Executives involved personally to sponsor BI to cover their mission critical processes. Requests jumped from 30 increased by 250.

-Management grandfathered the BI as a strategic business driver, defined structured meetings based on the delivered certified reports, and collaborating with the analytical applications outcome (actionable information).

Managed Intranet project plan and architecture, designed SD/BI implementation processes integrated with MS Projects, Service Manager, Active Directory Server(s), IBM Maximo, and Oracle ERP, integrated with the BI layer, raising software department production by 45% and overall IT performance by 23%

LINKdotNET, Cairo, Egypt 2005 – 2008, 2000 – 2001

Leading MEA internet solutions and services provider.

Business Intelligence Technical Consultant

leveraging the organization’s technology landscape through introducing Business Intelligence solutions & services. Established the roadmap, implementation process; applied the architectural discipline, mentored and trained employees on new technologies, products, processes, procedures, and best practices while maintaining the technology roadmap.

Designed and developed end-to end BI solutions, including ETL, DW, Data Mining, UX design and Implementation. Conduct BI presales activities (solution proposals, pilots & demos). New product portfolio ROI is 14 Million EGP of revenue in the 3 years

Improved projects department utilization through establishing and managing organizational standards for all data management and manipulation activities. Solved complex DB design, development and performance issues, resulted in improving project teams’ utilization by 34%.

Designed and implemented complete end to end BI Solution for Bahraini Ministry of Industry & Commerce, a 5 million EGP project, delivering ad-hoc reports, scorecards and dashboards with collaborating facilities.

Designed & implemented a complete BI geospatial web portal for Egyptian Ministry Of Development.

Designed & implemented a complete Decision Support Solution for Egyptian Ministry Of Information & Technology

quTIP, Cairo, Egypt 2004 – 2005

A leading business mobility solutions provider.

Software Development Lead

Led the development in various BI and software development projects

Procter & Gamble’s Sales Fundamentals Database Tools for CEMEEA region, producing multi-platform application with data sync controlled through web-based backend application.

Planned, managed and shared in the implementation of Procter & Gamble’s Data Warehouse consolidation across European countries, maintaining data integrity & quality standards among all countries.

Developed Intel Reports, extended version an open source BI Portal, add-ins enhancements on charting, analysis, report collaboration and a security module. Product enhanced version generated 0.7 million EGP in earnings.

Researched and developed Inspection tool for the Oil & Gas sector that capitalizes on mobile technology and OLAP to automate, consolidate statistics sent smoothly to the head office for analysis.

Online Modern Solutions, Cairo, Egypt 2002 – 2004

An EMEA leading business solutions provider.

Senior Software Engineer

EDUCATION

Bachelor of Science, Computer Science, Modern Science & Arts University, Egypt, 2000.

IGCSE, Rajac Language School, Egypt, 1995.

CERTIFICATIONS

Microsoft Certified Application Developer Microsoft Certified Professional Certified TDWI Member

TDWI Certified Business Analytics Professional (ongoing)

PROFESSIONAL DEVELOPMENT COURSES

Performance Management Design Techniques for Dashboards & Scorecards Requirements Gathering for BI Systems Intermediate & Advanced Dimensional Modeling Advanced Data Modeling Techniques Return on Investment for Information Projects Big Data Analytics MS BI Platform & ProClarity Training Microsoft Partners Academy

PERSONAL DATA AND PREFERENCES

Personal Data: I am an Egyptian, single, male, born in November, 1977. Military service completed MAR, 2002

Travel: Traveled to several countries like US, UK, Italy, France, Spain, Austria, Slovakia, Greece, Malta & Saudi Arabia, Bahrain, China & Indonesia. I am capable of traveling upon request.

Contact this candidate