SUMMARY:

• 10+ years of experience in a lead role of data specialist (data architecture, data modeling, data integration, data warehousing) by using UML concepts.
• 5 years of experience in Enterprise Architecture (alignment of Information Systems with business objectives and processes)
• 5+ years of experience in fields of Business Intelligence and analytics
• 4 Years experience as Information system manager
• 5+ years experiences in Databases Administration
• 4+ years as lecturer in Information system management and business Intelligence in business school
• Good knowledge of data manipulation based on XML, JSON formats, and API (Web services) good knowledge of tools for data analysis such as R, Python and SAS
• Experience in Big data environments
• Experience in Business strategy
• Enterprise Architecture certified - TOGAF 9
• Project management certified - PRINCE2 in Computer Engineering and Business Administration
• Problem Solving and skills of wide range and critical thinking to choose proper techniques, tools,

TECHNICAL SKILLS:

Data Modeling: Sparx Enterprise architect, Open model Sphere, Dia, MS Visio

Data manipulation and exchange: JSON, XML, HTTP(s), Web services

Project Management: MS Project, OpenPPM Data analysis, Data Science and Business Analytics: R, Python, SAS

Data warehouse and Business Intelligence: Microsoft (SSIS, SSRS, SSAS), Oracle BI, Pentaho ETL, Talend ETL, Informatica Power Center, Power BI

B ig data: Hadoop cloudera (Spark, MapReduce, Hdfs, Hbase, Hive, Pig)

Programing languages: SQL, PL/SQL, T-SQL, Java, Visual Basic

Databases: ORACLE (11g, 12c), MS SQLSERVER (2012, 2014,2016,2017), INFORMIX, My SQL, Mongo DB

WORK EXPERIENCE:

Lead Consultant - Analytics & BI

Confidential

Responsibilities:

• Data integration, Data Analysis for helping decision makers to understand business and take well-informed decisions.
• Analytics, datamining, machine learning based on tools such as: R, SAS, Python.
• Develop Dashboards with (Power BI, Oracle BI, Pentaho Analytic)

Lead Consultant - Data Architecture and BI

Confidential

Responsibilities:

• Focussed on Enterprise data architecture and Business Intelligence in order to help executive team to make informed decision. Main responsibilities included business investigation, Identifying business needs, identifying IT opportunities, build Data warehouse architecture and developing dashboards.

Lead Consultant - Data Architecture and BI

Confidential

Responsibilities:

• Developed practices of Enterprise data architecture, Business Intelligence, and data governance.

Data Conversion Systems Analyst/Lead Architect

Confidential

Responsibilities:

• Data Conversion Architect in the process of Extract-Transform-Load(ETL) of data related to pension plan system from legacy system to new software for new clients
• Authored Data Conversion Strategy, Conversion Architecture and Data Conversion Technical specifications. I also have ultimate responsibility for the conversion strategy, analysis, development and implementation of data conversion of the pension system.
• Provided goals, leadership and direction to a dedicated conversion team of analysts and developers.
• Generated documents for ETL using Visio, SharePoint.
• Used Microsoft SSIS, Pentaho for data integration.
• Worked extensively on data modeling, data mining, data warehousing and Business Intelligence.
• Used Microsoft (SSRS and SSAS) as well as Pentaho for business intelligence.
• Using Microsoft Visio for documents and Sharepoint for documents for ETL,
• Understand, document, validate and analyze requirements by working closely with stakeholders in order to build a system that match the business needs.

Enterprise Architect / Lead Consultant

Confidential

Responsibilities:

• Developed Business Architecture (Vision, Mission, Strategies, Operations Structure, Processes)
• Developed Information Technology Architecture ( IT Strategies, Score Cards, Operation Structure, Data Mining)
• Designed frames of Decision Support System (DSS) and Business Intelligence (BI)
• Developed Data Architecture
• Authorized requirements, documented requirements, analyzed requirements with stakeholders to figure out business

Senior Business System Analyst / Lead

Confidential

Responsibilities:

• Analyzed business requirements and translated them into technical solutions.
• Worked with others business and systems analysts to determine and documented solution requirements.
• Worked as an analyst within the different stages of System Development Life Cycle from project definition to sustainment of various projects.
• Designed business architecture, software architecture and technology architecture
• Participated iterative development using model-based processes
• Produced project artifices with XML and UML
• Understand, document, validate and analyze requirements by working closely with stakeholders in order to develop information system that will be in line with the overall business strategy.
• Prepared time estimates for assigned projects and tasks.
• Prepared regular project status reports indicating project deliverables, possible risk and issues, time-lines and anticipated effort
• Ensured appropriate project communication occurs to all parties involved during the project.
• Consulted on technical capabilities and recommended solutions to enable solving business needs and solution problems.
• Upgraded existing software as the user organization’s needs change
• Gathering of business requirements and documentation of requirements as it related to improvements of IS and Business Processes.
• Tested software to ensure the code is correct, fixing ('debugging') errors where they occur, and rerunning and rechecking the program until it produces the correct results
• Worked with trainers and technical writers to develop user support materials
• Completed applications development by coordinating requirements, schedules, and activities; contributing to team meetings; troubleshooting development and production problems across multiple environments and operating platforms.
• Supported customers with technical issues and manage complaints to ensure effective resolutions.
• Developed test plans for assigned components and ensured components are thoroughly tested prior to be deployed to quality assurance and production.
• Wrote software specifications, reviewed designs with business analysts, peers, and management, and developed software solutions according to specifications
• Played the role of project manager in some projects to improve business processes.
• Worked in the various stages of System Development Life Cycle
• Managed a team of 5 people on two remote sites

IS/IT Manager

Confidential

Responsibilities:

• Optimization and maintenance of ERP applications running on ORACLE database (Account payable, Account receivable, Fixed Asset,Payroll, Purchasing, Sales)
• Define IT strategies and tools to support the organization’s strategies and objectives
• Management of IT resource investment, use, and allocation practices to align with the organization’s strategies and objectives
• Management of IT Budget
• Contract management practices to ensure that they support the organization’s strategies and objectives
• Risk management practices to ensure that the organization’s IT are properly secured
• Systems and infrastructure Lifecycle management
• Managed a team of 6 people

Senior Database Analyst / Administrator

Confidential

Responsibilities:

• Designed Database architecture
• Installed and upgraded Oracle server and application tools
• Allocated system storage and planned future storage requirements for the database system
• Modified the database structure, as necessary, from information given by application developers
• Controlled and monitored user access to the database
• Monitored and optimized the performance of the database
• Planned for backup recovery for database information
• Backed up and restored the database
• Developed tools to optimize, analyses data for reporting by using (SQL/PLSQL, Oracle Discover
• Developed tools to maintain High availability of Database
• Indentified potential security risks of databases and defined strategies and actions plan of mitigation
• Migrated Informix databases to Oracle databases
• Installed and configured MySQL database, SQLServer database

Programmer Analyst

Confidential

Responsibilities:

• Developed modules in Visual Basic (VB) to improve business processes and user ‘s experience
• Tested new functionalities of business applications before installing in the production environment
• Designed and developed Score cards by using MS access.
• Develop reports by Crystal Reports
• Maintained ERP by fixing issues raised by users
• Developed tools of reporting with VB (macros) to facilitate decision making of managers
• Updated of software documentation for each change in the system
• Participated on several projects related to the data architecture.
• Wrote scripts on SQL/PLSQL to verify the consistency and reliability of data in the Databases
• Trained of end users on new modules
• Developed tools to optimize, analyse data by using (SQL/PLSQL, Oracle Discover)
• As a team lead for some projects, I designed work packages and managed product delivery