Mo Lahlou

About Mo Lahlou

Senior Software Architect (Database Administrator, Software Development, Data Modeling)* Oracle Certified Professional (Application Developer and DBA), SQL Server DBA with more than 18 years experience in application development and database administration in multiple RDBMS “Relational Database Management System” (Oracle, SQL Server, Netezza), Relational and Multidimensional analysis, Datawarehousing, design (Snowflake and Star Schemas)* ETL tools (Informatica and SQL Server Integration Services Package SSIS)* Experienced in full life cycle development from requirement gathering, process analysis, data modeling, database design, GUI design, application development, performance tuning, testing, and report writing utilizing both Oracle and Microsoft environments.* Experienced with SOA and WebServices* Key strengths include relational database design, web enabled & client server application development, and excellent technical and functional expertise in data warehousing.* Experienced with Oracle Retail RMS implementation* Experienced with BI tools: BusinessObjects, Microstrategy, SQL Server Analysis Services).* Experienced with and interfaced with Student Information System: Chancery SMS, PowerSchool, GradeSpeed, Exceed, CareerCruising, SchoolNet.* Data Conversion between SQL Server 2005/2008/2012 tables, flat files and other possible data sources using SSIS and Transact-SQL and informatica Mapping* Responsible to create comprehensive direction and integration of the architectural building blocks across the district platform, supporting technical team of Microstrategy developers, Informatica ETL and provide leadership across BI architecture.* Assisted in Delivering Dashboards to Superintendent using BI QlikView* Participate and help setup organization-wide guidelines and standards for the BI platform* Manage a high availability SQL Server 2005/2008 Cluster

Experience

1. Sr Software Architect

   Medixsoft, Inc

   Feb 2009 — Present

   Implemented a datawarehouse for the client Dallas Independent School District: 1. Data Conversion between SQL Server 2005/2008 tables, flat files and other possible data sources using SSIS and Transact-SQL and informatica Mapping2. Data Mapping3. Responsible to create comprehensive direction and integration of the architectural building blocks across the district platform, supporting technical team of Microstrategy developers, Informatica ETL and provide leadership across BI architecture.4. Participate and help setup organization-wide guidelines and standards for the BI platform5. Responsible for delivering business values to customers by architecting effective information systems solutions that addresses the customer’s business problems, needs and opportunities, in a manner consistent with BI Strategic and business goals6. Manage a high availability SQL Server 2005/2008 Cluster7. Meet with the functional Staff and getting the data requirements.8. Interface with Eduphoria: SchoolObjects Aware for benchmarking. It will produce instant results, visual browsing, student forms, and integration with forethought teachers will have a single place for planning and assessment.9. Dual Special Ed interface from the student System to Exceed/Encore Special Ed system10. The new Superintendent, Cabinet, Executive Director Dashboards using QlikView Technology11. Parent Portal implementation / Automation of Pin Generation for Parent to pick up12. Creating environment necessary for PEIMS submission from both Oracle System and the student system: Advanced Reporting Toolkit (ART)14. Counselor Dashboard: Counselors enter information such as Parent Letter, College Fair, Military,Trade School, Number of Scholarships Applied, and Total Scholarship Amount Offered and so on. We have updated the refresh cycle between the Counselor Tracking form and the Counselor Tracking 3R dashboards. The inserts / updates to the Tracking form are now in synch with the Dashboards.

Education

• Oklahoma City University

  Master of Science (M.S.), Computer Science

  1991 — 1993

• National Institute of Statistics and Applied Economics - Morocco

  Bachelor's degree, Computer Science

  1986 — 1990

Skills

• Microstrategy
• Software Solution Architecture
• Oracle Applications
• Oracle E-Business Suite
• Software Development
• Etl
• Objective-C
• Business Objects
• Enterprise Architecture
• Data Warehousing
• .net Compact Framework
• Databases
• Discover
• Cocoa
• Sql
• Asp.net
• Iphone Application Development
• Microsoft Sql Server
• T-Sql
• Xml
• Database Design
• Software Project Management
• Business Objects Data Integrator
• School Systems
• C# 4.0
• Ssas 2008
• Sdlc
• Solution Architecture
• Oracle
• Requirements Analysis
• Oracle Retail
• Soa
• Web Services
• Business Intelligence
• Requirements Gathering
• Photoshop
• Exceed
• Oracle Certified Dba
• Mobile Web Design
• Oracle Pro*C