Healthy Environments and Consumer Safety Branch (HECSB)Tasked with: Conversion of the Air Quality Benefits Assessment Tool (AQBAT Version 3) from English to French. A very complex application based on Excel 2010, VBA and @RISK add-in. This is a follow up to the previous work on AQBAT where I translated AQBAT version 2 from English to French in 2014.

Retired: Enjoying some time off, while still doing what I love: Helping businesses with custom made software solutions.Ottawa: Helping a friend: www.eltaher.org web site upgrade and improvement (PHP, MYSQL, CSS, Javascript) Ottawa: Improve own School Bus dispatch application developed in Windev 18 and HFSQL (like MYSQL).Algiers: Helped a gas station develop an Access application to print checks with spelled out amounts in French.

Called upon to solve a situation at Canadian Foundation for Innovation. Through a contract with Cistel Technology Inc. and as related in the following: " ... For the past few weeks we have been having daily database crashes of our REX/TREX system. You may recall that REX/TREX is the MS Access based tool our Programs team uses to manage the expert reviewer invitation process. It is critical to their business so this is an extremely troublesome issue.When it does crash, Our technical… Show more Called upon to solve a situation at Canadian Foundation for Innovation. Through a contract with Cistel Technology Inc. and as related in the following: " ... For the past few weeks we have been having daily database crashes of our REX/TREX system. You may recall that REX/TREX is the MS Access based tool our Programs team uses to manage the expert reviewer invitation process. It is critical to their business so this is an extremely troublesome issue.When it does crash, Our technical person runs the compact/repair option in Access and that fixes it temporarily.We wondered if you had an MS Access expert who could help us troubleshoot the issue and help us address the problem. We don’t know why this all of a sudden started occurring or how to figure out why it is happening.”Ghalizss Solution: Transfer existing functionality to SQL server backend by building an SQL server Database version for REX and several tools to adjust both front end code, queries and data to tackle compatibility issues. Also, proposed normalization, and implemented dsnless connection, user login and some administration features. Show less

Sponsored by the Directorate of Supply Chain Operations (DSCO), NSP supports this initiative by conducting stocktaking and stock verification at warehouses across Canada. This enables smart procurement by increasing data integrity and stock accuracy resulting in better procurement decisions.DSCO requires the design of databases to capture data for inventory management in support of NSP. The work will require designing, creating and populating databases to analyze data and present it to… Show more Sponsored by the Directorate of Supply Chain Operations (DSCO), NSP supports this initiative by conducting stocktaking and stock verification at warehouses across Canada. This enables smart procurement by increasing data integrity and stock accuracy resulting in better procurement decisions.DSCO requires the design of databases to capture data for inventory management in support of NSP. The work will require designing, creating and populating databases to analyze data and present it to stakeholders.The environment and tools used are: Microsoft (MS) Access databases; and Defence Resource Management Information System (DRMIS). Show less

Sr. Database Analyst (As Inround Innovations Inc. Contractor)• Help manage the “Carling Campus Move Project” carried out by the DND. This is a highly multidisciplinary project where there is a daily interaction with accommodation planners, IT planners, as well as telephony, material and workspace management people or departments. • Engage daily in Extraction Transformation and Load (ETL) from data sources like (HRMS, PERMIS, DRMIS and GAL). • Design, develop and implement an SQL… Show more Sr. Database Analyst (As Inround Innovations Inc. Contractor)• Help manage the “Carling Campus Move Project” carried out by the DND. This is a highly multidisciplinary project where there is a daily interaction with accommodation planners, IT planners, as well as telephony, material and workspace management people or departments. • Engage daily in Extraction Transformation and Load (ETL) from data sources like (HRMS, PERMIS, DRMIS and GAL). • Design, develop and implement an SQL database with dsn-less link to a variety of very specialized Access 2010 / 2013 VBA tools using forms with hundreds of objects linked data for geo-mapping purpose (FPAT and MPAT), connecting several data sources Outlook Gal directory, Excel for upload and for reporting.• The tools are version controlled through the SQL server database using file conversion to byte arrays and a push pull mechanism.• Use transaction SQL technique in manipulating updates and modifications to data in interconnected tables. Show less

Migration of an Access 2003 to 2010 Database from SQL server 2000 to 2008 platform. The tasks include maintenance, removing incompatibilities and bugs, implementing a thorough test on the test platform and the final migration. The database consists of two components, a client where all the functionalities are built on Access VBA code, and the data component of SQL tables (residing on SQL server) which are linked to the client.

Healthy Environments and Consumer Safety Branch (HECSB)Tasked with: Conversion of the Air Quality Benefits Assessment Tool (AQBAT) from English to French. A very complex application based on Excel 2010, VBA and @RISK add-in.

IT support level-IIDuties included: Web site updates, Portal Updates, support of other applicationsTools used: SharePoint 2010, Dreamweaver 8, WordPress 3.x.x, Desktop central 8, Service Desk Plus, etc ...Languages: ASP, ASP.NET, XML, XLT, Access 2007 (VBA)

Built an Intranet to consolidate all record keeping activities of the company and imported all existing excel archives. Built a windows application interface to manage specialized pulsation simulation tools and render their graphics results for a variety of test cases.Built several other tools to help Dewco engineers in their daily operation needs.Tools used: Dreamweaver Cs3,4, PHP, MYSQL, Visual Studio 2005, 2008 (VB.NET), Access 2003, 2007, WEBDEV15, WEBDEV 15 Server, HyperFileSql