MAHMOUD RAWY
Tel [Send email to request phone number] 18.6377 Cell [Send email to request phone number] 74.4504
PROFESSIONAL SUMMARY
Results-oriented IT professional with extensive credentials and experience
directing critical information technology systems solutions in the healthcare,
Pharmaceutical, telecom, HR and financial environments.
Technologist with proven success in dimensional and relational data modeling
using Erwin; Informatica PowerCenter to create information technology solutions
that add values to the company 's bottom line.
o Strategic thinker with equal emphasis on tactical execution and common-sense
problem solving to deliver financial results, operational improvements, and
production/service enhancements.
o Excellent communicator, skilled in conveying complex technical information to
senior management.
o Hands on experience using Informatica PowerCenter, Business Intelligence and
SAS statistical tools.
o Pro-active, team builder and player, work well under pressures as part of a
team or independently.
o Led up to 25 IT professionals, including remote teams, in creating and
delivering business solutions.
KEY QUALIFICATIONS
Data Warehousing Dimensional/Relational Data Modeling Business
Intelligence Solutions
Account Management Change Management Needs Assessment & Process
Improvement
Project Management / Development Lifecycle System Analysis, Design &
Integration
Team Building, Training & Management Quality Assurance Statistical
Analysis
TECHNOLOGIES
Databases: Oracle 10g MS SQL Server DB2 Teradata
Software: Informatica PowerCenter 8.6 Erwin Business Objects
Cognos BI Microstrategy Perl C
VB SAS Enterprise Java XML Toad FTP Lotus Notes
Remedy MF COBOL Mercury tools
Hardware /OS: Various MS Windows NOVELL AS400 OS390 UNIX
RECENT EXPERIENCE
Health Net, Inc. Woodland Hills, CA. 2008-2009
Senior Programmer/Analyst - Lead
Responsible for supporting Healthcare Medical Management (MDM) payors and
providers data systems.
Maintained active relationships with business customers, gathered
requirements, conducted systems analysis and created technical design
documentations.
Extensively used Informatica designer developing and maintained various
mapping/mapplets and transformations like (Source Qualifier, Lookup, Expression,
Joiner, Aggregator, Router, Normalizer, Sequence Generator, Filter, Stored
Procedure, Update Strategy, XML etc )
Administrated and extensively used Informatica workflow manager configuring
session 's properties and used Informatica repository manager to assign users,
groups, folders, privileges and roles.
Analyzed Informatica maps data process loads to optimize and improve session
performance.
Extensively involved in ETL testing, created Unit, regressions test plans
and test data scenarios.
Managed and administrated development and production Medical Management
(MDM) environment.
Provided on-call support and monitored inbound members, groups and providers
data loads.
Environment Informatica Powercenter 8.6, DB2, Oracle 10g, SQL Server, DB2,
SAS Enterprise, Perl,
EDI, Remedy, Cognos BI, Business Objects, Mercury testing tools, Lotus Notes,
PlanView and UNIX.
Covansys Los Angeles, CA. 2006-2007
Senior BI Data Architect/Project Manager
Responsible for the design and the architecture of Enterprise Data Warehouse and
BI solution.
Gathered business requirements, conducted systems analysis and created tech.
design docs.
Experienced architecting of enterprise data warehouses (EDW) for clients in
the healthcare, finance, Pharmaceutical and telecom industries using Inmon and
Kimball approaches.
Architected enterprise Data warehouse specifications for Pharmaceutical and
Healthcare industry.
Extensively used Erwin to design Logical/Physical Data Models,
forward/reverse engineering, modeled the Data Warehousing Data marts using Star
Schema and published data model files.
Created ETL (Data Extraction, Transformation and Loading) mappings using
Informatica Designer to extract the data from multiple source systems to multiple
targets and flat files.
Environment Informatica, Oracle, SQL Server, DB2, Erwin, Cognos BI, Crystal
XI and SAS Enterprise.
Alltel/CDI Business Solutions Bellevue, WA. 2005-2006
Senior QA Lead
Responsible for managing telecomm wireless ETL production CRM service and
billing system.
Architected Enterprise Data Warehouses (EDW) using wireless data utilizing
(Kimball) approaches.
Created datasets and used SAS/STAT to create different statistical reports
and graphs as required.
Design Logical/Physical Data Models, forward/reverse engineering using Erwin
data modeling tool.
Created ETL mappings using Informatica Designer to extract the data from
multiple source systems.
Environment Informatica, Oracle, DB2, TOAD, Erwin, Citrix, Java, VBscript
and Mercury testing tools.
ADDITIONAL EXPERIENCE
Senior Project Manager / Cairo Higher Institute for Computing & Management
Egypt. (2003-2004)
Project Lead Medicare, Medicaid HIPAA Claims / The State of New York
Albany, NY. (2002-2003)
Senior QA Lead / Severn Trent Systems/Ajilon Houston, TX. (2001-2002)
Senior Programmer Analyst / CCA Calabasas, CA.(1999-2001)
Senior Programmer Analyst / EDS - AON Los Angeles, CA. (1997-1998)
Senior P/A - Project Lead / Coopers & Lybrands L.L.P San Francisco, CA
(1992-1997)
EDUCATION & PROFESSIONAL DEVELOPMENT
GRADUATE DEGREE, COMPUTER SCIENCE, Kensington University, LA, CA
MASTER OF ENGINEERING, Technical College and Artillery Institute, Cairo, Egypt
BACHELOR OF SCIENCE, ARTILLERY SCIENCE, Military, Cairo, Egypt
CERTIFICATIONS / PROFESSIONAL DEVELOPMENT
Member of the Project Management Institute (PMI).
Oracle Certified training (Complex Modules and Databases).
Computer training courses: Informatica Erwin Cognos BI
Business Objects SAP R/3 Novell CNE.
Credited computer languages classes, SF City College, UC Berkeley, and
Golden Gate University.
US Citizen |
