Professional Summary:

Highly-skilled professional with 26 years of experience in Business Systems Analyst, Enterprise Data Warehouse Architecture and design using ETL Data Integration, Data Quality, Master Data Management, Statistical Visualization and Analytical Reports and Data Modeling in client server and cloud web-based environments for Healthcare, Pharmaceutical, Finance, Retails, CRM, HR and Utility.

Education:

Ph.D. in Computer Science from Kensington University, Los Angeles, CA.

Masters in Engineering from Military Technical University and Artillery Institute of Cairo.

Bachelor in Artillery Science from Military University of Cairo.

Key Qualifications:

12+ years Health manage care experience working with internal and external partners building end-to-end solutions.

Experience in technology domains, cloud computing, integration, databases, data mining, machine learning and AI.

Experience and understanding of trends concerning health insurance, provider relationships and regulatory issues.

Experience using EDI X12, HL7 and HIPAA 834, 835, 837IPD, 820, 270, 271, 276, 277, 278, NCPDP, FHIR transactions.

Managed pharmacy and MDM (pharmacy, medical, claims, membership, providers and ICD9/10, CPT, DRUG codes).

Managed Measurement and Analytics (M&A) with Medicaid and Medicare Programs, IHC, HCC and CMS regulatory.

Experienced working with Data Integration, Master Data Management, Data Governance and Data Quality tools.

Experience creating visual analytical reports using SASBI, Cognos, BO, Tableau, OBIEE, QlikView and MicroStrategy.

Utilized informatica data quality, Entity360, data lineage, business glossary, business analytics and data governance.

Used informatica MDM Hub Tool’s Data Stewards to manage and view data lineage in each base record if necessary.

Managed and supported EDW staff and technical resources (onsite and offshore) on time with high quality delivery.

Enterprise Data Leadership Skills/Experiences:

1) Data Warehouse:

Hands on using Informatica Platform (PC, IDQ, MDM, E360 and Cloud), Reltio, ODI, Talend, SnapLogic and Ab Initio.

Utilized data management and stewardship using Collibra tools as an enterprise-oriented data governance platform.

Hands on experience using Erwin and ER/Studio modeling tool creating Logical, Physical and Cubes Data Models.

Experienced working with DB(s), (Oracle, Teradata, DB2, MSSQL, Netezza, SFDC, AWS, RDS, Snowflake and NetSuite).

Gathered business requirement, created and applied rules to maps, Data Quality Solutions and Created dashboards.

Gathered manufacture master supplier 360 application data user’s requirements in Informatica MDM environment.

Created business-friendly user interface displays an enterprise-level dashboard as well as 360-degree supplier views.

2) Business Analysis:

Hands on experience using statistical programming languages (R, Python, SAS, R studio, Data Miner and Big Data).

Created complex statistical visual analytical reports using R, SASBI, MicroStrategy, BO, OBIEE, Cognos and Tableau

TriZetto Facets and QNXT Certified Technical and Business training using BizTalk and EDI mapping to QNXT tables.

Worked across several project's life cycle, implementation-using Jira for Agile, Waterfall and Scrum methodologies.

Skilled in Salesforce SaaS CRM applications and functionality (Opportunity, Sales, Services, Marketing, and PO).

Healthcare and Pharma Industry experience, Drug Discovery, Clinical Trials, medical and familiarity with IoT devices.

Work Experience:

Genentech Sep 2019 to Mar 2020

MDM Enterprise Architect

Responsibilities: Manage enterprise life science Healthcare and Pharmaceutical global data integrations (HCO and HCP). Manage source data conversion to JSON format, standardization and quality and prioritizing business entities data.

Manage business requirements, perform analysis identifying Data Quality and Mastering Data and managing data.

Manage search and potential matching data and change requests (DCR) and RDM following business requirements.

Manage tenant elastic-search metadata model configuration, integration, creating match and data survivorship rules.

Provided technical support service to global clients and business partner users solving problems and issues as needs.

Environment: Linux, Oracle, SnowFlake, Informatica, Reltio, SnapLogic, workday, Jira, Tableau, AWS, GCP and Python.

DvSum. Feb 2019 to Apr 2019

Technical Enterprise Architect/Product Manager

Responsibilities: Manage ERP/CRM retail system provide solutions, data quality and create statistical visualized reports.

Manage business requirements; perform analysis Data Quality Solutions using DvSum data Management tools.

Create summarized and detailed statistical visualize analytical reports utilizing Tableau visualized environment.

Gathered manufacture master supplier 360 application data user’s requirements in Retail MDM environment.

Environment: Linux, Oracle, ODI, PC, IDQ, MDM, Tableau, Snowflake, AWS, SAS BI, OBIEE, Java, Python and Big Data.

MATRIX/BOTW. Sep 2018 to Jan 2019

Senior Enterprise Architect

Responsibilities: Manage Bank’s financial data quality solution, profiling, applying rules and creating CRM dashboard.

Manage business requirements, perform analysis identifying DataFlux and Data Quality Solutions using IDQ analyst.

Define and perform Data Profiling, Data discovery, Data cleansing and applying business rules to Banking EDW.

Create summarized and detailed statistical visualize analytical and financial reports utilizing Tableau environment.

Environment: Linux, Oracle, SFDC, BO, Informatica, IDQ, MDM, Entity360, Collibra, Tableau, AWS, Java and Big Data.

Infosys Limited; Plano, TX. Feb 2017 to Feb 2018

Principal Enterprise Architect

Responsibilities: Manage and architecture CRM investment financial Enterprise Data Management solutions (MDM).

Architect and design financial MDM 10.2 and PIM environments in premise and cloud databases and Salesforce.

Administrate and provide production support for B2B integration IDQ, PC, IDD, AVOS and MDM 10.2 environment.

Utilized cloud data warehouse using AWS EC2, S3, RDS, MS SQL and SFDC creating integrated process Data Factory.

Gathered manufacture master supplier 360 application data user’s requirements in Informatica MDM environment.

Environment: Linux, MS SQL, Teradata, SFDC, SnowFlake, Oracle, BO, IDQ, MDM 360, SAS, AWS, Java and Big Data.

Encores/Fitbit; San Francisco, CA. Jun 2016 to Sep 2016

Data Enterprise Architect Consultant

Responsibilities: Managing CRM global manufacture CRM distribute system using IICS, SFDC, Big Data, NetSuite and Host Analytics creating statistical visualized reports.

Lead global Manufacture distributed cloud CRM design using Informatica Cloud, SFDC, NetSuite and Host Analytics.

Lead CRM Analytics retail reports development in cloud environment using BO, Tableau, SAS BI and Host Analytics.

Environment: Linux, NetSuite, MSSQL, SFDC, BO, SSIS, Informatica, SnapLogic, PowerBI, SAS, AWS, SnowFlake and Java.

InfoLume L.L.C./BNP Paribas Bank; Jersey City, NJ. Jul 2015 to Oct 2015

Data Architect Consultant/PM

Responsibilities: Manage Bank’s financial data quality solution, profiling, applying rules and creating CRM dashboard.

Utilized PC and IDQ 9.x analyst and developer creating Maps, Maples, Transformations, Sessions and Workflows.

Led possesses functional and technical skills in the Data Governance and Master Data Management subjects.

Managed ETL processes using Informatica, control tables, error logging, auditing, data quality and business rules.

Utilized manual data testing and management using MapReduce, Hive and Pig scripts in Big data environment.

Created SAS data sets, macros, developing statistical analysis and created financial analytical visualized report.

Environment: LINUX, Oracle, SnowFlake, Teradata, MSSQL, SnapLogic, BO, Collibra, IDQ, SAS, SFDC, Java and PowerBI.

Informatica Corp. Aug 2014 to Feb 2015

Senior IPS DQ Consultant

Responsibilities: Provide enterprise data quality and managing data quality issues create profiling, rules and scorecards.

Managed business requirements, perform analysis identifying Data Quality Solutions using MDM and IDQ tools.

Utilized Informatica PowerCenter 9.x developer; created Maps, Maples, Transformations, Sessions and Workflows.

Utilized Informatica BDE Maps, Transformations, Sessions, WF in Hadoop and DIG data distributed environment.

Applied business rules as required to Data Cleansing, DataFlux, Data Quality Solutions and Created dashboard.

Utilized IDQ profiling structured/unstructured data, creating business rules, comment, IDD, Tags and scorecards.

Hands-on experience utilizing IDQ, IDD, IMM toolsets, data exceptions, Hive session logs and error handling.

Environment: Oracle, SFDC, Teradata, MS SQL, DB2, Netezza, BO, Informatica, DQ, DataFlux, Java, VM and UNIX.

Q Analyst; San Francisco, CA. Aug 2012 to Feb 2014

Senior Enterprise Architect /Tech Lead

Responsibilities: Managing and support managed care data issues within EDW creating ACO XML file using IPC.

Led Vender's development team using Agile and Scrum master methodology for cross functional teams using Jira.

Architected accountable care organization (ACO) provider and members Medicaid and Medicare Programs data.

Managed Facets regression testing to the new version Ver. 5.01 and environments object performance and reports.

Manages all aspects of the HEDIS reporting process and direct reporting of measures to the state partners.

Environment: Oracle, ODI, Teradata, MS SQL, Netezza, BO, Togaf, Informatica, SAS BI, TriZetto FACETS and LINUX.

P & S Tech Solutions Inc.; Foster City, CA. Apr 2012 to Jul 2012

Senior Enterprise Architect

Responsibilities: Managing data related quality issues within the Data Warehouse and data model’s environment.

Designed and developed logical, physical data models, and metadata objects migrating enterprise architecture.

Created complex and reusable macros and SAS data sets, analysis and created financial graphical analytical report

Environment: Oracle, ODI, Teradata, MS SQL, BO, SFDC, Informatica, AWS, SAS BI, MicroStrategy and LINUX.

Mentis Systems; Bellevue, WA. Feb 2012 to Mar 2012

Enterprise Data/ETL Consultant

Responsibilities: Managing data analysis and identify data related issues within the Data Warehouse environment.

Architected and utilized Informatica PC creating Maps, Mapplets, Transformations, Sessions and Workflows.

Created complex reusable macros and SAS data sets, DataFlux, analysis and generated financial graphical report.

Environment: MF COBOL, MS SQL 2008, DB2, SSIS, Informatica PowerCenter 8.5, SAS BI, Windows and UNIX.

Idaho Power Company; Boise, ID. Jun 2011 to Oct 2011

Enterprise Data Architect

Responsibilities: Managing and architecting Utility meter's data and map it into EDW, Big Data metering system.

Gathered business requirement, performed analysis, creating enterprise architecting processes and documentation

Design and lead EDW ETL mapping design, data modeling, managing data quality into Utility EDW system.

Managing support EDW team of technical resources (on-site and off-shore) and ensure project delivery.

Created datasets using SAS, DataFlux and Graphs creating statistical descriptive reports for business research.

Environment: MS SQL, Oracle, Hadoop, Big Data, DB2, Informatica, Erwin, SAS, DataFlux, TOGAF, SAP, BO and QC.

San Francisco Health Plan; San Francisco, CA. Mar 2010 to Apr 2011

Sr. Data Analyst/PM

Responsibilities: Managing HIPAA transactions, analytics, Medical, Healthy worker, CCA and Medicare Federal program.

Led and managed HIPAA 834, 820, 837 IPD transactions using EDI x12 data mapper, integration to BizTalk to QNXT.

Manages all aspects of the HEDIS reporting process and direct reporting of measures to the state partners.

Created datasets using SAS/STAT and Graphs creating encounter statistical and descriptive reports for business.

Environment: MS SQL, SAS, EDI, Big Data, Pervasive, SAS, SSIS, QNXT, TOGAF, COGNOS, BO, HIPAA and UNIX.

KFORCE; Burbank, CA. Sep 2009 to Feb 2010

Enterprise Architect/Sr. BI Consultant

Responsibilities: Managed financial data models using Cognos Framework manager to create dimensions and measures.

Created datasets using SAS/STAT and Graphs creating statistical descriptive business reports as required.

Created sales, marketing monthly, quarterly and annually financial analytical reports using Oracle BI Suite.

Environment: Oracle, Teradata, MS SQL, Sybase, SAS, Informatica, SSIS, Perl, BO, Cognos, UNIX and Windows.

Health Net Inc.; Woodland Hills, CA. Jan 2008 to Jun 2009

Sr. Data Analyst/Lead

Responsibilities: Managing and maintaining managed care Medical, Healthy worker, CCA and Medicare Federal program

Utilized Informatica 8.6 designer; created Maps, Maples, Transformations, Sessions and Workflows objects.

Involved in Software Development Life Cycle (SDLC) of the application, requirement gathering, design and analysis.

Provided technical support to business users and solving day-to-day service problems and issues as needs.

Environment: Oracle, Teradata, Hadoop, Big Data, MS SQL, DB2, SAS, EDI, Informatica, Perl, Remedy and BO

Covansys; Los Angeles, CA. Dec 2006 to Dec 2007

Senior Enterprise Architect/PM

Responsibilities: Architecting, managing, designing EDW and BI solution and managing On/Off-Shore resources.

Designed Pfizer pharmaceutical Enterprise Data Warehouses utilizing Bottom/Up (Kimball) EDW's design approach.

Managed, collecting and analyzed physician Drug trails data and clinic survey input data into DataMart systems.

Created and enhanced SAS datasets, SAS code for Clinical study listings reports and Clinical regulatory submission.

Environment: Oracle, Teradata, SQL Server, Erwin, Informatica, UNIX, SAS BI, Visio, BO, Cognos, and Java.

Alltel; Bellevue, WA. Jan 2005 to Oct 2006

Enterprise Data Architect/SQA

Responsibilities: Managing Telecommunication wireless CRM service system and business reports.

Architected and maintained wireless Enterprise Data Warehouse utilizing (Kimball) Bottom/Up approach.

Maintained Telecommunication billing systems and create billing cycles descriptive and analytics reports.

Created SAS descriptive statistical programs to generate wireless billing cycle's cross-reference reports.

Environment: Oracle, TOAD, Informatica, EDI, MS SQL, SAS, Erwin, SSIS, Java, VBScript, Java, PCVS and UNIX.

Cairo Higher Institute for Computing and Mgt; Cairo, Egypt Oct 2003 to Dec 2004

Enterprise Data Architect/Sr. PM

Responsibilities: Manage and architect Student administration system development, documentation and code migration

Designed and created (ER diagram, logical and physical) dimension models using Erwin data modeling.

Created datasets using SAS/STAT and SAS/Graphs to create statistical descriptive business reports.

Environment: SQL Server, ORACLE, DB2, SAS 9, Crystal Reports, C, MS Project, Windows and UNIX.

New York State; Albany, NY. Sep 2002 to Sep 2003

Enterprise Data Architect/Project Lead

Responsibilities: Design, maintain and managing Medicare and Medicaid (837 IPD) claims systems reports.

Created and developed HIPAA 837 IPD HHS State claim applications, reports and using HL7 and EDI X12 transactions.

Created and developed Medicare and Medicaid daily and monthly status (claims and payment) reports.

Created datasets and developed statistical analytical reports using SAS/STAT, SAS/Macro and graphs.

Severn Trent Systems/AJILON; Houston, TX. May 2001 to Jul 2002

SQA/Project Lead

Responsibilities: Managed utilities (PW&E) systems (Billing, Metering, Payments, Rates, Services provision and reports).

Designed and created (ER diagram, logical and physical) dimension models using Erwin data modeling.

Created datasets and required billing cycle statistical and listing reports using SAS, Macros and Graphs.

CCA; Calabasas, CA. Jan 1999 to Apr 2001

Senior P/A - PM

Responsibilities: Managed retails and Institution pharmacy systems, pricing adjudication, inventory and EMR reports.

Managed EDI data maps and interfaces using HL7, ANSII X12 for HIPAA compliance requirement

Created SAS datasets, developed descriptive statistical reports using SAS/STAT, SAS/Macro and EMR reports.

EDS/AON; Los Angeles, CA. Aug 1997 to Dec 1998

Senior P/A

Responsibilities: Managed Telecommunications CRM converting legacy billing system data to new client server system.

Converted EBCDEC cycles billing systems to ASCII data objects creating billing cycle’s descriptive analytical reports.

Maintained called C subprograms to extract data using embedded SQL queries and PL/SQL functions and packages.

Coopers & Lybrand's L.L.P; San Francisco, CA. Jan 1992 to Jul 1997

Senior P/A - Project Manager

Responsibilities: Maintaining and managing HR advisory pension, funds, Loans/mortgage, payroll and billing system.

Managed and design retirement pension and benefits calculator, investment, & financial, Loans and payroll services.

Designed and developed commercial loans/mortgage applications, maintained interest, amortization's and reports.

Created SAS datasets, SAS/GRAPH for inclusion Clinical trials study data, created reports and regulatory submission.

Contact this candidate