Mahmoud Hussein Rawy

ad3thf@r.postjobfree.com

(***) *** - 8677

Brentwood, CA. 94513

Professional Summary:

** ***** ** *********** ******* experience in data modeling, data quality, data analytics, data engineering concepts, database designs, system components, architecture, internal processes on premises and cloud (AWS, GCP and Azure) in many LOBs (Utility, Telecom, Finance, Retails, CRM, Healthcare, Pharmacy, Life Science and HR), DevOps and automation. Education:

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

Master in engineering, Military Technical University of Cairo.

Bachelor in science, Egyptian Military Academy of Cairo. Key Qualifications:

30 years of experience, utilizing and supporting Utility, Telecom, Finance, Retails, CRM and HR systems on premise and cloud.

Utilized Micro Focus COBOL, C subprograms including embedded sql codes to support utility billing and HR systems.

Experience in data modernization technology, cloud computing, data integration, data quality, MDM, data mining, ML and AI.

Experience managed health care HIPAA EDI X12 (834, 835, 837 (IPD), 820, 276, 277, 278, NCPDP, HL7 and FHIR) transactions.

Designed and supported managed care (membership, providers, claims, payers and pharmacy) ICD9/ ICD 10, CPT, DRUG codes).

Managed healthcare analytics reports (Medicaid and Medicare, IHC, HCC, ACO, HEDIS) implement HIPAA and CMS regulations.

Trizetto Certified Product (Facets and QNXT) Associate training configuration using BizTalk and onboarding backend data objects

Experience creating visualize analytical reports using SAS Viya, Cognos, BO, Tableau, OBIEE, PowerBI and MicroStrategy.

Managed DevOps and supported EDW technical resource project team (onsite and offshore) on time with high quality delivery. Enterprise Data Leadership Skills/Experiences:

1) Data Warehouse:

Certified Intelligent Data Management Cloud (IDMC) 2022 Champion Boot camp training for Partners by Informatica Corp.

Utilized Informatica IDMC Platform (IDQ, IDD, MDM, IICS, Axon, EDC and Marketplace), Reltio, ODI, Jitterbit, SAP and Talend.

Utilized data management and stewardship using Axon, EDC and Marketplace enterprise modernize data governance platform.

Utilized Erwin and ER/Studio, Excel and power design modeling tool established, Logical, Physical and Cubes Data Models.

Utilized on Premises and Cloud DB (Oracle, Teradata, PostgreSQL, MSSQL, Salesforces, SAP, AWS, RDS, Snowflake and NetSuite)

Provided technical oversight to development and implementation team based on existing and new architectures changes. 2) Business Analysis:

Certified Cognizant TriZetto Facets and QNXT Technical and Business training using BizTalk and mapping to table’s data objects.

Created complex statistical visual analytical reports using R, SASBI, MicroStrategy, BO, OBIEE, Cognos and Tableau for LOB(s).

Utilized Salesforce data models CRM platform managing (customer accounts, sales and Marketing) and HCM Workday’s apps.

Healthcare and global Pharmaceutical Industry experience manufacture, drugs data discovery, Clinical, sales and marketing. Work Experience:

COGNIZANT Jul 2021 to Jun 2023

Senior Manager (Architect).

Responsibilities: Managed and designed enterprise life science Manufacture, Healthcare and Pharmaceutical global (HCO, HCP, Oncology, Sales and Marketing) data objects and files on premises and AWS cloud environments, create business analytical reports.

Managed and mastered life science HCO, HCP, Workday, SFDC and IQVIA environments data objects performance and reports.

Managed and supported data modernization platform SDLC on premises and cloud environments supporting analytical reports.

Defined data discovery, profiling, cleansing, standardization and applying business rules on premises and cloud environments.

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

Ensures agile and scrum projects align with the program's objectives by thoroughly understanding the business segment's issues

Supported wireless telecom billing systems using Micro Focus COBOL, C subprograms including embedded sql codes.

Design and create pharmaceutical customer segmentation, territory alignment, DDD visualize analytical reports using SAS. Environment: Linux, Oracle, SFDC, IDMC, MF COBOL, Reltio, Facets, SAS Viya, Teradata, Tableau, AWS, PostgreSQL, Java, and BD. HHS Aug 2020 to Jun 2021

IT Specialist.

Failed grants TOP security clearance process.

W3Global/Genentech Sep 2019 to Mar 2020

MDM Tech. Lead Consultant.

Responsibilities: Managed and designed enterprise life science Manufacture, Healthcare and Pharmaceutical global (HCO, HCP, Oncology, Sales and Marketing) data objects and files on premises and GCP cloud environments, create business analytical reports.

Managed and mastered life science HCO, HCP, Workday, SFDC and IQVIA environments data objects performance and reports.

Managed and supported data modernization platform SDLC on premises and cloud environments supporting analytical reports.

Defined data discovery, profiling, cleansing, standardization and applying business rules on premises and cloud environments.

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

Design and create pharm. manufacture segmentation, territory alignment, DDD visualize analytical reports using SAS Viya. Environment: Linux, Oracle, SnowFlake, Informatica IICS, PowerBI, Reltio, SnapLogic, SFDC, Workday, Jira, Tableau, AWS and GCP. DvSum. Feb 2019 to Apr 2019

Technical Product Manager

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

Managed business requirements; perform analysis Data Quality Solutions using Profisee MDM and DvSum tools.

Created summarized and detailed statistical visualize analytical reports utilizing Tableau visualized environment. Environment: Linux, Oracle, ODI, PC, IDQ, PowerBI, Tableau, Snowflake, AWS, SAS BI, OBIEE, Java, Python and Big Data. MATRIX/BOTW. Sep 2018 to Jan 2019

Senior Data Quality Consultant

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

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

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

Led possesses functional and technical skills in the Data Governance and Master Data Management subjects. Environment: Linux, Oracle, SFDC, BO, Informatica IICS, IDQ, MDM, Entity360, Snowflake, Collibra, Tableau, AWS, Java, and Big Data. Infosys Limited; Plano, TX. Feb 2017 to Feb 2018

Principal Enterprise (MDM) Architect

Responsibilities: Managed and designed CRM investment financial Enterprise Data Management solutions (MDM).

Managed and supported production environment using informatica integration IDQ, PC, IDD, AVOS and MDM 10.2 hub.

Created IMS Xponent data SAS data sets, statistical analysis and created analytical visualized statistical reports utilizing Tableau. Environment: Linux, MS SQL, Teradata, SFDC, SnowFlake, SnapLogic, BO, IICS, IDQ, MDM, E360, SAS, AWS, Java, and Big Data. Encores/Fitbit; San Francisco, CA. Jun 2016 to Sep 2016 Data Architect Consultant/PM

Responsibilities: Managed CRM global CRM distribution system using IICS, SFDC, Big Data, NetSuite, and Host Analytics 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, IICS, SnapLogic, PowerBI, Teradata, 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: Managed 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.

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

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

Created SAS data sets, macros, developing statistical analysis and created financial analytical visualized report. Environment: LINUX, Oracle, SnowFlake, Teradata, MSSQL, SnapLogic, BO, Collibra, IICS, IDQ, SAS, SFDC, Java and PowerBI. Informatica Corp. Aug 2014 to Feb 2015

Senior IPS DQ Consultant

Responsibilities: Managed enterprise data quality and manage data quality issues create profiling, rules, and scorecards.

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

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

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

Managed CRM global manufacture CRM distribute system and create descriptive and analytical statistical visualized reports.

Utilized 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/BCSC; San Francisco, CA. Aug 2012 to Feb 2014 Senior Tech Lead

Responsibilities: Managed daily MCO and professional managed care data issues members, providers, claims and payments.

Designed Federal (ACO) provider and members Medicaid and Medicare descriptive and analytical statistical visualized reports.

Supported healthcare claim billing systems using Micro Focus COBOL, C subprograms including embedded sql codes.

Managed Facets upgrading to the latest version and environments regression testing and created performance release reports.

Created IMS Xponent data SAS data sets, statistical analysis and created analytical visualized statistical reports utilizing SAS BI. Environment: Oracle, ODI, Teradata, MS SQL, Netezza, BO, Togaf, Informatica, SAS BI, TriZetto FACETS, MF COBOL, C and LINUX. P & S Tech Solutions Inc.; Foster City, CA. Apr 2012 to Jul 2012 Enterprise Data Architect/Senior ETL Architect

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

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 Mentis Systems; Bellevue, WA. Feb 2012 to Mar 2012 Enterprise Data/ETL Consultant

Responsibilities: Managed ERP telecomm and retail system provide solutions, data quality and create statistical visualized reports.

Designed and utilized Informatica PC creating Maps, Mapplets, Transformations, Sessions, and Workflows performance. Idaho Power Company; Boise, ID. Jun 2011 to Oct 2011 Enterprise Data Architect/PM

Responsibilities: Managed and supported utility wireless meter's data management systems and implemented business objectives.

Gathered analyzed and applied environment objects capacity planning and provided best solutions to business requirements.

Supported utility metering billing systems using Micro Focus COBOL, C subprograms including embedded sql codes.

Designed and modified object’s data (ER diagram, logical and physical) dimension models using Erwin data modeling.

Created datasets using SAS, DataFlux and Graphs creating statistical descriptive reports for business research. Environment: MS SQL, Oracle, C, Big Data, DB2, Informatica, Erwin, SAS, SFTP, MF COBOL, Data Flux, TOGAF, SAP, BO, and QC. San Francisco Health Plan; San Francisco, CA. Mar 2010 to Apr 2011 Sr. Data Analyst/PM

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

Managed HIPAA 834, 820, 837 (IPD) ANSI x12 transactions data daily loads using BizTalk and data mapper to data models QNXT.

Managed business companion guides standardization project and distributed to clearing houses, MCO(s) and affiliated clients

Supported healthcare claim billing systems using Micro Focus COBOL, C subprograms including embedded sql codes. KFORCE; Burbank, CA. Sep 2009 to Feb 2010

Enterprise Data 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 annual financial analytical reports using Oracle BI Suite. Health Net Inc.; Woodland Hills, CA. Jan 2008 to Jun 2009 Sr. Data Analyst/Lead

Responsibilities: Managed and maintained MCO managed care Medical, Healthy worker, CCA and Medicare Federal programs.

Managed and supported managed care information systems, data warehouse processing and created EMR reports.

Supported healthcare claim billing systems using Micro Focus COBOL, C subprograms including embedded sql codes. Covansys/Pfizer; Los Angeles, CA. Dec 2006 to Dec 2007 Enterprise Data Architect/PM

Responsibilities: Managed enterprise life science, Healthcare and Pharmaceutical global (HCO, HCP, Oncology, Sales and Marketing)

Managed and supported pharmacy information systems, data warehouse processing and created EMR reports.

Managed, translated and analyzed research and drug’s study trails data and clinic survey data into DataMart reporting systems. Alltel; Bellevue, WA. Jan 2005 to Oct 2006

Enterprise Data Architect/SQA

Responsibilities: Managed and supported Telecommunication wireless billing CRM service system and business analytical reports.

Supported wireless telecom billing systems using Micro Focus COBOL, C subprograms including embedded sql codes. Cairo Higher Institute for Computing and Mgt; Cairo, Egypt Oct 2003 to Dec 2004 Enterprise Data Architect/Sr. PM

Responsibilities: Managed and designed 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. New York State; Albany, NY. Sep 2002 to Sep 2003

Enterprise Data Architect/Project Lead

Responsibilities: Designed, maintained, and managed Medicare and Medicaid Hippa (837 IPD) MCO claims systems and reports.

Created and developed HIPAA 837 (IPD) HHS State MCO claim’s processing applications using HL7 and EDI X12 transactions.

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

Supported healthcare claim billing systems using Micro Focus COBOL, C subprograms including embedded sql codes. Severn Trent Utility Systems/AJILON; Houston, TX. May 2001 to Jul 2002 SQA/Project Lead

Responsibilities: Managed and supported utilities application’s management systems and implemented business objectives.

Supported utility metering billing systems using Micro Focus COBOL, C subprograms including embedded sql codes.

Managed utilities function’s systems (Billing, Metering, Payments, Rates, Services provision and analytical reports). 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 retails and Institutional pharmacy systems EDI data maps and interfaces using HL7, ANSI X12 for HIPAA compliance.

Managed and design retails prescription drugs dispensing and cost of estimated price and printing labels and EMR reports.

Supported in-house pharmacy systems using Micro Focus COBOL, C subprograms including embedded sql codes.

Managed institution floor dispensing prescription drugs and balance with update inventory stocks for drug restocking orders.

Created SAS datasets, developed descriptive and statistical analytical 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.

Supported Telecom billing systems using Micro Focus COBOL, C subprograms including embedded sql codes.

Maintained 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, amortizations, and reports.

Supported HR benefits calculator systems using Micro Focus COBOL, C subprograms including embedded sql codes.

Created SAS datasets, SAS/GRAPH for inclusion Clinical trials study phases data, created supported analytical reports.

Contact this candidate