|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
Grant Macewan College.
SAP training material
May 2004 – August 2004
2
Creation of training material to use SAP R/3 in the Supply Chain Management program. Enhancement and revision of material currently utilized. Creation of a website to assist the training of students on SAP
Collaborated in the development of instructional material for the teaching of SAP in the college. As part of this project, prepared the lab practices for the modules of Materials Management and Warehouse Management. Revised and enhanced the lab practices in Procurement, Production Planning, Manufacturing, Customer order management, and Human Resources that the college uses to introduce SAP to the students. Prepared PowerPoint presentations summarizing the functionality of the modules Material Management and Warehouse Management.
Utilizing Macromedia Dreamweaver MX 2004 developed a website focused in the use of SAP in the college. The website includes extensive information in SAP and in the sample company used by SAP for training purposes.
SAP R/3, Macromedia Dreamweaver MX 2004, PowerPoint, FrontPage, Word, and Visio 2003.
|
|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
EDS
SFS (Student Finance System)
June 2001 – October 2002
12
System designed to collect information from student loan applicants. It is a .NET application developed utilizing ASP.NET and Visual Basic.NET. Use Cases were compiled to gather the user’s requirements. UML diagrams were developed to model the system (Use Case, Class and Sequence diagrams). The programming of the system was developed based in the designed models, making frequent updates during the development process. During the testing phase, Unit Testing was made to make sure each independent piece of code worked properly. Other tests were realized such as Integration Tests to prove that all units were working together, and Load Tests utilizing Microsoft .NET tools. Finally during the implementation phase QA people developed testing scenarios base in the elaborated Use Cases.
Participated in the development of the application using Visual Basic .NET and ASP.NET. Participated in the creation of Use Case documents during the requirements definition phase of the project. Based on this documentation, collaborated in the creation of use case diagrams, and activity diagrams using UML notation. Also participated in the creation of the data dictionary, data mapping to legacy databases, and data model for the system.
Visual Basic .NET, ASP.NET, IIS, Visio, and HTML.
|
|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
EDS
EST (Employment Support technology)
November 1999 – October 2000
5
Internet application designed to manage the province’s resources assigned to people with disabilities. The technology employed was Microsoft DNA with a three-tier component-based architecture. The front end was implemented using HTML and JavaScript, the middle tier using Active Server Pages and COM objects, and the back end using Microsoft SQL Server. To make the application independent of the utilized database, SQL was implemented through Stored-Procedures accessed from COM objects. The business logic was implemented using Visual Basic 6.0. The design of the system was made using Rational Rose 98 with UML notation. Use Cases were implemented to document the different scenarios, and class diagrams and sequence diagrams to design different objects needed
Participated in the analysis, design and development of the application.
ASP, Visual Basic, Microsoft SQL server, Rational Rose, HTML, JavaScript
|
|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
EDS
Service Request System
July 1999 – October 1999
3
The system was developed using the Powerbuilder Foundation Class (PFC), and it is utilized to control work done during the maintenance and enhancement of computer applications.
Led the analysis, design, and development of the system.
Powerbuilder 6.5, Microsoft SQL server, Windows NT 4.0
|
|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
EDS
Control Management Report.
March 1999 – July 1999
3
System that stores and controls the reports generated by several applications.
Led the development of the application. Developed the business requirements and functional specifications to convert this system from MS Access to PowerBuilder, and co-ordinated the creation of reports by other developers.
PowerBuilder 6.5, Microsoft SQL server, Windows NT 4.0.
|
|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
EDS
August 1998 – December 1999
25
System that controls welfare applicants in Ontario. It is installed in more than 1000 workstations across the province.
Participated in the development of enhancements and analysis of code to integrate this application with other systems and to make it Y2K compliant. Collaborated in the upgrade of the application to PowerBuilder 6.5.
PowerBuilder 6.5, Microsoft SQL server, Windows NT 4.0.
|
|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
Philip Services Corporation.
MRIS 5.2.
February 1999 – July 1999.
4.
Update and enhancements to MRIS, a system that tracks information related with the process of metal scrap in 17 locations across the USA and Canada. The system is installed in 17 file servers, being accesses by almost 300 users. It uses 5 different SQL-Anywhere databases, which are running in 3 different Database Serves. It is a complex installation running with no down time. As part of the project, 2 different databases where combined into a new design; extensive use of SQL scripts were necessary to accomplish this task.
Implemented the changes necessary to the application. Helped to deploy the application and new databases across the network system. Prepared the application’s installation utilities, procedure manuals and guidelines for the help-desk personnel. Developed the SQL to make the merge of databases.
|
|
Company:
Project
Duration:
Team size:
Description:
Contribution:
Software:
|
Dofasco Inc.
Manage Pricing and Trade Monitoring system.
October 1997 – December 1997.
4.
Part of a commercialization system named LRP. The system was designed to manage and control the trade of steel and generate quotes according to costs, competitor prices, customer’s agreements, and U.S. anti-dumping regulations. The Object Model was developed utilizing Rational Rose with UML notation. A working prototype in PowerBuilder was developed to get feedback and support from the user community.
Contributed to define the object-oriented model and developed the working prototype in PowerBuilder 5.0.
|
|
Duration:
Team size:
Description:
Contribution
Software:
|
Elsag Bailey (Canada) Inc.
SemTracker -Contacts Module.
July 1007 – September 1997.
4.
The Contacts Module is part of a bigger commercial system called SemTracker designed to keep information generated during the production of paper in paper mills. The module is utilized across the system each time a client’s representative is needed. It has a Microsoft Outlook style with its business rules implemented in PowerBuilder NVOs. The SemTracker system is based in the PowerBuilder Foundation Class library, and it is DBMS and language independent.
Developed the application according to specifications. Collaborated with other developers to define the communication among the different modules of the system with this particular module.
|
|
Duration:
Team size:
Description:
Contribution
Software:
|
Elsag Bailey (Canada) Corp.
Semtrim.
May 1997 – August 1997.
4.
System designed to get the best trim of paper rolls in paper mills. The system also controls and classifies the product according many factors, such as quality, use, thickness Etc. The system was developed to be part of a bigger commercial system called SemTracker. It is a regular PowerBuilder MDI application accessing a Microsoft Access database and utilizing DLLs developed in C++.
Finished the development of the first Beta version of this product.
|
|
Duration:
Team size:
Description:
Contribution
Software:
|
April 1997 – May 1997
2.
System designed to browse and search thousand of reports generated during the production of paper. Those reports are related with the quality of each roll of paper produced in paper mills. The system has a Windows-explorer style interface and was developed utilizing PowerBuilder 5.0, Tree-views controls and datastores.
|
|
Duration:
Team size:
Description:
Contribution:
Software:
|
Integration of the Sybase databases OEI and USL-Financials.
April 1996 – May 1996
2.
As part of a data-warehouse project, two main databases were integrated: OEI (Order-Entry-Invoicing) and USL-Financials. An exhaustive analysis was made to determine how equivalent tables in both systems should be updated, during the normal operation of both systems.
Developed the Triggers necessary to keep both databases updated. Intense testing was necessary to make sure USL-Financials received valid information.
|
|
Duration:
Team size:
Description:
Contribution:
Software:
|
Nutraceutical Corporation.
Update of the Sybase database “NutraMine”.
May 1996 – June 1996
1
As part of a data-warehouse project, a new marketing database was designed to be accessed by end-users using PowerSoft Infomaker. This database is populated from production databases and its tables (around 20) have information already summarized, classified and easy to be accessed by the company’s executives.
Developed the stored procedures utilized daily by the DBA to move information to the Marketing database.
|
|
Duration:
Team size:
Description:
Contribution:
Software:
|
Nutraceutical Corporation.
“Call Reports” System.
July 1996 – September 1996
2.
System utilized by the sales department to keep control of the almost 80,000 marketing calls made to customers and prospects during the year.
PowerBuilder 5.0, Sybase 11, Transact SQL, NT 3.51, Windows 95.
|
|
Duration:
Team size:
Description:
Contribution:
Software:
|
Nutraceutical Corporation.
Integration of the software GoldMine to the company’s Data-warehouse.
August 1996 – September 1996
1.
As part of a Data Warehouse project, the Paradox-based system GoldMine was integrated to the Sybase databases. Goldmine is a commercial product utilized to manage prospects.
Developed a PowerBuilder application to update the production databases with information contained in Goldmine.
|
|
Duration:
Team size:
Description:
Contribution:
Software:
|
October 1996 – December 1996.
1.
The system maintains statistics and commissions about a promotion called “Special of today”, a marketing plan where the company reduces the price of some products just one day. The application was characterized by the extensive use of crosstab reports populated by stored procedures.
|
|
Duration:
Team size:
Description:
Contribution:
Software:
|
September 1996 – December 1996.
1
To maintain information about direct surveys made to customers across the USA. The system keeps control of the mix of brand names that retail stores have during the year. Intense surveys are made by sales representatives nationwide during the year to get data for this system.
|
