Sign in

Senior ETL BI Engineer

Canoga park, CA, 91304
November 11, 2009

Contact this candidate


Mahmoud Rawy

Cell 818-***-**** – Home 818-***-****


• Results-oriented IT professional with hands on experience, excellent attention to details, a passion for owning and producing top-quality deliverables and disciplined to meet deadlines and commitments.

• Architect and designed data warehouse using Erwin data modeling tools and BI reporting solutions.

• Experience includes project management and leading development of custom packaged solutions primarily for Healthcare, Telecom, Financial Services and Retail in Data Warehousing environments.

• Extensively using Informatica powercenter 8.6 designer; created Maps and various Transformations.

• Extensively used Informatica Repository Manager to assign users, groups, folders privilege and roles.

• Profound knowledge and strong experience using Base SAS, SAS/MACRO, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/CONNECT, SAS Enterprise in Windows and UNIX environments.

• Skilled in SAS Programming, creating SAS Data Sets, Macro Facility, design data modeling, using PROCs, Producing Reports, Validating Reports, SAS Formats, Storing and Managing Data in SAS Files.

• Hands on experience using BI reporting tools Cognos BI, MicroStrategy, Crystal report XI and Xcelsius.

• Extensively used Cognos BI reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, grouping, Graphs, Breaks and parameter based reports.

• Communicate technical information to technical, non-technical and senior management end users.

• Pro-active, work well under pressures as part of a team and independently; Bi-lingual English / Arabic.


• Databases: Oracle 10g, MS SQL server, DB2 and Teradata.

• Software: Informatica powercenter, Erwin, EDI, Business Objects, Cognos BI, Microstrategy, C, Perl, Base SAS, SAS/MACRO, SAS/Connect, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/Access, SAS Enterprise, SAS Web Report Studio, SAS Information Map Studio, Lotus Notes, Toad, VB, SQL, PL/SQL, VBscript, SPSS, Java, Remedy, FTP, XML, COBOL, Mercury tools and UNIX scripting.

• Hardware / Operating Systems: Various MS Windows, NOVELL, AS400, OS390 and UNIX.


Kforce, Burbank, CA. Oct 2009 – Nov 2009

Senior BI Developer - Consultant.

Responsible for managing Cognos BI financial and retails management reporting systems and data marts.

• Utilize data warehousing and Business intelligence best practice to enhance data validations, accuracy and performance for Cognos Report and Query Studios environment to develop, to extract required information from different fact and dimension tables and to create list, crosstab and analytical reports.

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

Senior Programmer Analyst - Lead.

Responsible for managing and supporting Medical Management (MDM) members and claims systems.

• Gathered user requirements for the reporting work, documented requirements and performed analysis.

• Administered and managed Informatica Powercenter environment users, groups and folder privileges.

• Monitored informatica workflow data process loads, optimized and improved session’s performance.

• Maintained Medical management (MDM) processing Inbound and Outbound data loads applications.

• Enhanced data model query subjects in the Cognos Framework manager by selecting the required query items, creating complex calculation model elements (attributes) and fact measures.

• Used Cognos Report Studio and developed complex queries to extract the required information .

• Imported SAS datasets from SAS Management Console to SAS Map Studio and Build Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports.

• Extensively involved in ETL testing, created Unit, regressions test plans and test data scenarios.

Environment: Oracle 10g, MS SQL, DB2, SAS Enterprise, EDI, Informatica 8.6, Perl, XML, Remedy, Business Objects, Cognos BI, Microstrategy, Fogligth, Lotus Notes, Windows, Novell, UNIX and AS400.

Covansys, Los Angeles, CA. Dec 2006 – Dec 2007

Sr. BI Data Architect/Project Manager

Responsible for architecting and designing Enterprise Data Warehouse and Business Intelligence solution.

• Gathered business requirement, conducted systems analysis and created technical design document.

• Designed Enterprise Data Warehouses (EDW) for Pharmaceutical healthcare solution client and financial institute (banking) utilizing Top/Down (Inmon) and Bottom/Up (Kimball) approaches.

• Developed and maintained informatica powercenter objects (maps, transformations and sessions).

• Enhanced data model query subjects in the Cognos Framework manager by selecting the required query items, creating complex calculation model elements (attributes) and fact measures.

• Used Cognos BI Query studio and Report Studio and created complex business required reports.

• Created and developed (ER, logical and physical) modules and star schema using Erwin modeling tool.

• Generated data analysis and statistical reports using SAS/BASE, SAS/Macros, SAS/Graphs and SAS/Reports.

• Used SAS Web Report Studio using Information maps, create filters, graphs, and customize reports.

Environment: Oracle, SQL Server, Toad, Erwin, Informatica PowerCenter 7.x, DB2, PL/SQL, OWB, UNIX, SAS Enterprise, SAS 9, Visio, Crystal Reports XI, Cognos BI, Microstrategy and Mercury testing tools.

Alltel/CDI Business Solution, Bellevue, WA. Jan 2005 - Sep 2006

SQA/Project Lead

Responsible for maintaining and managing telecommunication wireless CRM service system, production ETL billing cycle database integrated environment and business reports.

• Architected Enterprise Data Warehouses (EDW) using wireless data utilizing (Kimball) approaches.

• Designed maps and Transformation like (expression, lookup and filter) using Informatica Designer.

• Created and developed (logical and physical) and star schema modules using Erwin modeling tool.

• Exported the Universes to the Repository to make resources available to the users for ad-hoc reports.

• Created datasets and billing cycle statistical reports and graphs using SAS/STAT and SAS/Macros.

Environment: Oracle 10g, TOAD, Informatica 7.x, EDI, MS SQL, SAS 9, PL/SQL, SQL*Loader, Erwin, Citrix, Java, VBScript Mercury testing tools (WinRunner, LoadRunner and TD), UNIX and Windows.

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

Senior Project Manager

Responsible for architecting, managing development and documentation of integrated ETL and BI related activities, environmental specifications, ETL strategy, tool selection’s recommendation and code migration.

• Developed Maps and Transformations like (lookup, expression, filter and router) using Informatica.

• Created and developed Admin financial descriptive reports with graph using SAS/STAT and SAS/Macros.

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

New York State, Albany, NY. Sep 2002 - Sep 2003

Project Lead

Responsible for design and migrate Medicare and Medicaid HIPAA (837 IPD) claims systems and reports.

• Developed various Maps and Transformations like (expression and filter) using Informatica Designer.

• Provided In-house support to Electronic data exchange (EDI) translator and interfaces using HL7, X12

• Designed HIPAA (837 IPD) claims and payment process applications using HL7, X12 record formats.

• Created and developed daily Medicare and Medicaid claims descriptive analysis reports using Base/SAS.

Environment: ORACLE, Erwin, SAS, DB2, EDI, MF COBOL, C, JCL, Visio, MS Project, MS Office, Cognos, Informatica, Netexpress, OS/390,UNIX and WINDOWS.

Severn Trent Systems/Ajilon, Houston, TX. May 2001 - Jul 2002

SQA/Project Lead

Responsible for managing all modifications and testing utilities management systems, API and reports.

• Led and managed utilities (PW&E) systems (Billing, Metering, Payments, Rates, Services and reports).

• Designed (logical and physical) data modeling and created ER diagram (Star Schema) using Erwin.

• Tuned queries performance and created analytical financial reports using Reporting tools and API(s).

• Created datasets and developed performance statistical reports and graphs using SAS/STAT and SAS/Macros.

Environment: Oracle, Erwin, Crystal Reports, Java, SAS, C, PVCS, MF COBOL, FTP, MS Project, PVCS, Power Builder, Netexpres, MS Office, WinRunner, UNIX and Windows NT.

CCA, Los Angeles, CA. Jan 1999 – Apr 2001

Senior Data analyst/Project Lead

Responsible for managing and maintaining (laboratory, Radiology and Pharmacy) systems and interfaces.

• Maintained Clinical pharmacy management applications (Inpatient/Outpatient) prescription order entry process, dispensing, drug mixing calculation, online adjudication, clinical claims and billing, printing labels, MAR, drugs education sheets, inventory stock management and monitor.

• Created and designed various operational detailed and summarized reports using Crystal Reports.

• Developed (extract, transform and load) scripts to populate data marts and created reporting.

• Maintained data maps and interfaces using HL7, X12 protocols and Electronic data exchange (EDI).

• Re-engineer MAR report to laser printer with enhancement bolded formats instead of old line printer.

• Created datasets and developed descriptive inventory management reports using SAS/Macro and SAS/STAT.

Environment: Oracle, DB2, SQL Server, C, Erwin, Crystal Reports, SAS, Java, EDI, HL7, HIPAA and UNIX.

Additional Relative Experience

o Senior Data analyst, EDS, Los Angeles, CA.

Responsible for managing and maintaining backend Telecommunication’s databases billing applications.

• Created datasets and developed descriptive billing cycle reports using SAS/STAT, Graphs and SAS/Macros.

o Senior analyst/Project Lead, Coopers & Lybrand LLP, San Francisco, CA.

Responsible for managing and developing (Benefit Calculators, Loan and Payrolls) H. Resources Systems.

• Worked on Clinical Data Analysis Reports using SAS/base, Macros and Graphs for Clinical Trials Phases.

o Systems Analyst, ODIN Data Systems, San Francisco, CA.

• Created datasets and developed financial descriptive analysis reports using SAS/STAT and SAS/Macros.


• Advanced degree in Computer Science; Kensington University, Los Angeles, CA.

• PMI member.

• Credited computer languages classes (SF City College, UC Berkeley and Golden Gate University).

• Informatica, Erwin, Cognos BI, Crystal report XI R2, Xcelsius, Siebel SAP R/3 and Novell CNE.

• ORACLE Certified training (Develop complex modules and design Databases).

• Master of Engineering, Technical College and Artillery Institute of Egypt.

• Bachelor of Science, Military College of Egypt.

US Citizen.

Contact this candidate