Client/Server Tools: Java, VB.NET, C++/C#, PHP, PERL
Mainframe Tools: SAS, COBOL II, CICS, JCL, TSO
Databases: MS SQL Server, MySQL, Oracle, DBII, ESSBASE, MS OLAP Services, MS Access, and VSAM
Other tools: SQL, ADO.NET, ODBC, OLE DB, MS Office
Operating Systems: Windows 2000/2003 Server, Windows 98/2000/XP, IBM Mainframe 3090, Linux, and Unix.
Suivant sont les experiences professionnelles du Directeur de ITSG, Mr Bouallam Mohamed ayant requit une experience de plus de 20 ans aux Etats Unis dans le domaine d'informatique.
2004-2007: Director & Enterprise Solution Architect at Information Technologies Solutions Group, Marrakech, Morocco.
Manage an IT Consulting Company in Marrakech, Morocco. Provide complete solutions for IT customers in Morocco and abroad.
2000-2003: Solution Architect at Computer Task Group Company, Atlanta, Georgia.
Design solution architectures utilizing Object Modelling Tools and UML. The
Deliverables for each solution consist of Use Cases Diagrams, Activity Diagrams,
Sequence Diagrams, Class Diagrams, State Diagrams, User Interface Model, Logical Data Model, Component Diagrams, Deployment Diagrams, and Test Scripts.
Some of the solutions designed are:
Blue Cross Blue Shield’s Application Recombination Module: Design, development, and testing of a module that splits an application into multiple applications depending on deductible amounts. Some of the technologies used include XML/XSL, Java, and MS SQL 2000 Server.
ABB Automotive System: The solution consisted of multiple Portals customized to fit the needs of different groups of users. Some of the technologies used include XML/XSL, VB, COM, ASP 2.0, and MS SQL 2000 Server.
BP Oil Movement system: The solution consisted of multiple Portals customized to fit the needs of different groups of users. Some of the technologies used include XML/XSL, Oracles 8i, and Oracle Application Server.
1999-2000: E-Commerce Consultant at Computer Task Group Company.
1996-1999: Senior Systems Analyst at Bank of America, Jacksonville, Florida.
Designed and developed a Web Tracking System for the business Access Tools department in Bank of America. The solution consisted of over 16 ASP pages dynamically linked to a dozen of MS SQL Server 7.0 tables using OLE DB technology.
A Visual Basic COM Object was created to interface with ESSBASE multidimensional databases. Also installed and administered both Windows 2000 and Internet Information Server 2000.
Lead a technical team in designing and developing 7 multi-dimensional databases using ESSBASE 5.2. Generated Web enabled views and reports with Wired for OLAP 4.0 and MS Excel Addin . Setup training classes for different departmental users.
Lead a team of 5 in merging a Data Warehouse Household Information using PC/SAS, mainframe SAS, JCL, SQL, DBII. The project consisted of over 30 programs.
Designed and developed over 50 Web-Enable reports using mainframe and PC SAS, SQL, DBII Utilities, HTML, and VBScript for the Dealer Financial Services
Leasing department of Barnett Bank.
1988-1996 : Senior Programmer Analyst at Western Michigan University, Kalamazoo, Michigan.
Designed and developed a Client/Server application for Western Michigan University . The application consisted of multiple interfaces to the University’s Student Financial System. The major tools used were Visual Basic, and SQL.
Designed and developed an Interlibrary Loan System, at WMU, consisting of over35 CICS interfaces using COBOL II, VSAM, and JCL. The system enable over 50 consortium libraries in the South Western Michigan region to exchange books and other materials among themselves.
Data conversion for the Financial Aid Department. The project consisted of extracting data from an old FA system and converting it to fit the new system’s requirement using SAS, DBII.
Generated a variety of different reports for the Financial Aid and library departments using SAS.
Data Extraction, Transformation, and Load of library Patrons using C++ and SQL.
1984-1988 : Computer Operator at Western Geophysical Company , Houston, Texas.
Operated and monitored IBM Mainframes 3080, 3090. Scheduled and ran jobs.
Fixed JCL errors.