SUMMARY:

• Senior Solution/Data Architect with 22 years IT experience, strategic planner and a team lead with a proven expertise in management, design, development and deployment of data solutions including: operational transactional systems, ODS, Data Integration, Data Mining, Data Quality, Data Warehouse, bus architecture, and multidimensional OLAP cubes, reporting and Business Intelligence, Cloud computing and Big data analytics
• Extensive experience in the planning, architecture, design, development, administration, and production support of relational database, ETL, BI architecture, data warehousing, DSS and OLAP database systems, Zachman and TOGAF enterprise architectures, SOA, multi - tier client server architecture, IBM & Teradata financial services industry data model, Azure, Big data utilizing Lambda architecture (Batch, Serving and Speed layers) & using tools such as (HDFS/Map Reduce, Cassandra, Apache Thrift ) for modeling storing and computing data
• Strong Financial analysis skills, specialized in Private Wealth, Mutual funds, Trading, Market data, Banking & Technology standards, P&C Insurance, Mortgage insurance and regulatory reporting rules and regulations, strong knowledge of financial & technology standards
• Proven technical lead expertise, managed multiple tasks and responsibilities in high-pressure environments; experienced in leading teams on different projects simultaneously through complex, project critical phases, including version upgrade, and business rules change implementation in the critical phases such as pilot and post-release project phases. Project plan estimation, and people and resources allocation
• Strong programming background utilizing different languages, tools, and databases: .Net, JavaScript, VBScript, FileNet, XML, HTML/DHTML, ASP, SQL, PL/SQL, C++, Delphi, Visual Basic, MS Access, and Informix SQL/4GL, Oracle, DB2, SQL Server, SSIS, SSRS, SSAS; IBM InfoSphere Datastage/Information Analyzer, IGC, Cognos, AWS, NoSQL

PROFESSIONAL EXPERIENCE:

Enterprise Data Architect / Consultant

Confidential

Responsibilities:

• Managed all data architecture requirements on an enterprise level, like security and data classification, metadata, data and MDM, as well as data quality and operations requirements
• Created all required artifacts like architecture overview and details document, key architecture decisions and business requirements assessment document
• Created required enterprise conceptual and logical data models, and recommended solutions that’s considered the basis for design and project estimates
• As a member of the EA review board team, it’s a part of my job to review the data projects in the pipeline, so as to assess its impact on the overall enterprise architecture, and provide my recommendations
• Supported the overall enterprise technology roadmap and planning along with other IT Architects and business units, along with outlining the organization data roadmap in specific, in order to discuss it with decision makers

Technical Environment: Micro strategy, IBM InfoSphere 11.5 platform & tools ( Datastage, Quality Stage, Information Analyzer, IGC),MDM, SSIS,ESB, Middleware,Erwin,DB2,Teradata,AWS,Rational System Architect, Onbase, Guidewire

Enterprise Data/Solution Architect /Technical Lead Consultant

Confidential

Responsibilities:

• Provided all required solution architecture components details and documentation, including application, technology, physical and security components, to handle data feeds from different back office applications to/from IRESS trading platform
• Designed and developed the required ETL platform to get different clients source data onboard, including source and target data analysis, market data analysis, designing and developing staging area, ETL functionalities and required SSIS packages for a complete automation
• Full coordination with IRESS global to make sure we are aligned to the enterprise architecture practice, including EA KDDs, Information flows, logical and conceptual data architecture.

Enterprise Solution Architect / Technical Lead Consultant

Confidential

Responsibilities:

• Worked the different risk domains business teams, along with the data governance team to define critical data elements, DQ rules, along with all DQ dimensions, rules meta data and reporting requirements
• Outlined the data governance roadmap, then provided the required presentations, POCs and architecture artifacts to decision makers, in order to get required approvals
• Supported the Data governance team in defining and creating Data quality rules within Information Analyzer, and linking it to business glossary
• Created the application, technology, physical and security views along with the solution architecture document details
• Designed the different interfaces with source systems, IBM financial data model EDW, applications and the BI presentation layer
• Designed the required dimensional data model, and worked the Congo's BI team to develop required enterprise analytics, by utilizing Cogno's BI components
• Worked the IBM team in an engagement to asses Data governance, SDLC, IBM information server foundation tools, and meta data management
• Led the POC (Architecture & Design) for utilizing Hadoop (HDFS) & MapReduce as recommended tool for batch processing and integration with the data quality platform
• Provided Big data/Cloud technology roadmap and planning, for utilizing current market trends and assessing impact on current core business units within the enterprise
• Coordinated with the Enterprise architecture committee to make sure all our architecture artifacts meet the committee requirements

Technical Environment: Cognos 10, IBM InfoSphere 9.1 & 11.3 platform & tools including Datastage, Information Analyzer, Stewardship center, Information Governance Dashboard, Business Glossary, data quality exception console, Blueprint Director & FastTrack, Autosys scheduler, Connect Direct, IGC, DB2 v10.1, AIX 7.1, Erwin

Senior Data Architect / Consultant

Confidential

Responsibilities:

• Designed and modeled the ETL solution for the Data feed project, which requires several business areas like Fixed Income, Stock Borrow and Lending and General Ledger, to provide current and accurate feeds, from multiple internal and external systems like Dataphile, Loanet and PeopleSoft to multiple destinations
• Designed and modeled the dimensional schema required for the Data hub project, desperate data sources and extensive data mapping have been utilized to support all business reporting and data requirements
• The Kimball methodology and tools like the Bus matrix have been applied in logical modeling and representing the core business processes and associated dimensionality
• Presented and provided required architecture artifacts (conceptual and logical models) to nontechnical and technical teams to explore new market trends through POCs physical implementation
• Led the Canadian physical implementation of Data Warehouse (Data Hub) including end to end ETL lifecycle (Scheduling, extraction, exceptions, transformations) and loading into physicalized dimensional model. Followed by loading de normalized data from facts and dimensions into required data cubes by the business.

Technical Environment: Oracle10g, IBMInfoSphere Datastage/Information Analyzer, MS SQL 2008, SSIS, Windows 2003/2008, VISIO Professionals, PL/SQL

Senior IT/Solution Architect / Consultant

Confidential

Responsibilities:

• Completed an overall technology roadmap after performing an overall assessment of the company IT current architecture, framework and tools, vendors and service providers then provided recommended feedback to decision makers in order to get required budget approvals
• Analyzed current IT market trends to determine potential impact on target/ future IT projects and the company IT strategic planning
• Provided the required artifacts, POCs, reports and documentation to our business partners (PWC, Manulife, Filogix) to get required approvals for our IT projects
• Involved in either creating or discussing IT projects architecture decisions KDDs, as well as vendors and tools selections RFPs, and maintaining both technical and business relationship with our vendors and service providers
• Established the company data governance policies, and ensured that applicable standards and best practices are developed and implemented
• Led the architecture, design and development of all data interfaces between the subsystems, like Client/Broker management, Broker compensation, premium collection/Refunds with RBC, Filenet workflows and packages like AURA (Underwriting), Epicor (Accounting), Thunderhead (Document creation), Claim Vantage (Claims)
• Involved in detailed business requirements specification, solution and data architecture, created conceptual and user-friendly schematic diagrams to discuss with the business, and logical and physical architecture diagrams for technical team to build different insurance subsystems
• Worked with the Benesure/Manulife different line of business, SMEs and external partners, utilizing different BI analysis tools to scope, design then led the development of an analytics and reporting solution including data collection from operational layer databases, ETL using SSIS, relational data mart, SSAS cubes, and dashboard/scorecards /KPI’s to support business initiatives and strategic objectives

Technical Environment: MS SQL 2005/2008, SSAS, SSRS, SSIS, Windows 2003/2008, ASP.NET, VMware, VSTS/DB Pro, ERWin, XML, MDX, Filenet, Thunderhead

Senior IT Architect, Consultant

Confidential

Responsibilities:

• Applied data structure model analysis on legacy system along with complete data assessment on data quality, issues, licensing costs and reporting
• Applied data cleansing techniques directly at source data along with data cleansing through external means
• Identified gaps in design and completed data mapping from source to target system
• Designed an overall conversion process to convert data into structure required by target system
• Designed and led the development of staging area required for conversion, utilized Microsoft SQL server 2008 migration assistant for Oracle v4.2 along with SSIS 2008
• Created all types of reconciliation reports required through and after conversion
• Converted Oracle report scripts with embedded UNIX and DB2 code, to its equivalent SQL server scripts

Technical Environment: MS SQL 2008, SSIS, Windows 2003/2008, DB2, VMware, Microsoft SQL server 2008 migration assistant, Oracle Database 10g, PL/SQL,Linux

Manager, Business Information Systems

Confidential

Responsibilities:

• Regularly meet with SME’s, business leaders and executives to identify pain points and in corporate feedback, discuss the IT strategy and how it can meet the organization objectives through recommended tools and new technologies
• Document, present Key IT Architecture solutions blueprints, data flows decisions to different stakeholders in a business friendly and efficient way
• Efficiently managed and set priorities /deliverables for the IT team through different migration/development projects within the organization
• Led the company data governance efforts, and ensured that applicable standards /best practices are developed and implemented
• Managed relationship with IT partners/vendors and third-party infrastructure providers
• Provided full support in Solution/Data Architecture, analysis and development lifecycle
• Worked with business in developing business requirements and supporting technical specifications
• Provided guidance and direction to the IT staff and manage daily workloads and priorities
• Evaluated and recommended new technologies where appropriate
• Managed (“Gatekeeper”) of the production environment (data, applications, coding), documented change management & version control of this environment

Senior System/Data Analyst

Confidential

Responsibilities:

• Performed System Analysis, Design, Programming and created technical program specifications for different applications that support client’s retirement plans
• Developed, tuned and maintained SQL-based application programs; recommended design changes and query improvement to existing SQL database infrastructure and applications
• Designed, developed and maintained different Filenet workflow custom applications like redemption workflow
• Developed different web-based utilities for calculating fees, uploading remittances, manage Compensations and systematic payments
• Developed programs that import/export XML files to/from SQL financial DB with FundServ network and CRA using industry standards
• Developed different financial reports and statements for plan sponsors and members

Technical Environment: FileNet, XML, ASP, .Net, HTML/DHTML, Adobe Designer, Visual basic, JavaScript running on MS SQL Server 2000 under windows 2000

Software Developer/Analyst

Confidential

Responsibilities:

• Designed and implemented an Internet/Intranet with the following subsystems: Human Resources system, Sales, Business Development & Portals based on Oracle9i or MS Access or SQL Server Databases and IIS web server on NT platform.
• Developed an Interface with the ADP payroll system that imports and exports data.
• Designed and implemented a full web interface invoicing system that creates, manages and prints invoices; calculates taxes; and sends invoices by Email.
• Coded the stored procedures and triggers required for the Hospital for Sick Children’s Genetics Disease Database

Technical Environment: ASP.NET, HTML/DHTML, Java Applets, VBScript, JavaScript, PLSQL, CSS, ActiveX & MS SQL Server 2000 under windows 2000

Database Analyst/Programmer

Confidential

Responsibilities:

• Member of a consultant team used to establish the Analysis, Design and Coding phases for different sectors of the company.
• Methodologies were used by our teamwork including tools and matrices for Analysis and Design phases such as well-designed Questionnaires, DFD, FDD, ERD, HIPO, Action Diagrams, Event description forms, Security forms
• Used CASE tools for documentation, prototyping and diagramming
• Coded various modules of the Sales and QC systems using Visual Basic on client server architecture and an Oracle 8i Database

Software Engineer /Officer

Confidential

Responsibilities:

• Designed/Developed database applications for various departments of the Egyptian Armed Forces, such as Officer’s affairs, Inventory, Sales and a system for the general library for the Egyptian Army using Visual Basic/Delphi, PLSQL under WIN95/Windows NT Operating Systems and an Paradox/Oracle 8i backend Databases