Resume for Brian Schalme

Manitoba Aviation Council

Winnipeg MB

MAC is an industry umbrella group dedicated to promoting the development of aviation in Manitoba. Mr. Schalme worked with MAC to revise their website to present a more polished, professional image. He recommended a process whereby MAC staff could update the website themselves. To arrive at this recommendation, Mr. Schalme examined the various web development tools available; he also evaluated Content Management Systems. His recommendation took into account the budget available to him and the skill competencies of MAC staff.

 

Critical Success Factors:

• Simplified the process of adding and updating pages by using server-side scripting - PHP.
• Performed updates promptly.

 

Outcomes:

• A consistent look and feel to the website that gives a very professional appearance using XHTML.

 

Kenna Group

Winnipeg MB

Kenna Group, a Winnipeg-based marketing analysis firm, called upon Mr. Schalme to help them reduce their extensive project backlog, and to introduce and mentor their Data Analytics staff on J2EE best practices. He developed several web sites using JavaServer Pages (JSP), Servlets, and JDBC technologies running inside Apache Tomcat, which Kenna Group used for their clients and for their marketing campaigns. Mr. Schalme worked closely with the Database Administrator to develop data models and complex SQL queries.

 

Critical Success Factors:

• Achieving project milestones under very tight time constraints.
• Successfully managing multiple projects and deadlines.

 

Outcomes:

• Reduced project backlog, enabling Kenna Group to meet their commitments to their clients.
• Greater knowledge of J2EE best practices by Kenna Group's Data Analytics staff.
• Introduced the Struts framework into a major application.
• Introduced a POJO persistence model, similar to Hibernate.

 

Manitoba Liquor Control Commission

Winnipeg MB

MLCC has called upon Mr. Schalme to provide his systems integration skills to the ERP project. He analyzed the current and new business flows, and developed software modifications to deal with the data flowing to & from the JD Edwards OneWorld Xe (JDE) system. In particular, he made programming changes to MLCC's online order entry Java applet (ATLAS) that would allow for the seamless integration of Legacy data and JDE data. Another project involved disabling the Legacy system's Excise processing, since that functionality was to be replaced by an off-the-shelf package. Recently, MLCC asked Mr. Schalme to perform a last-minute update to the Liquor Industry Information System so it could accept sales and inventory data from JDE.

 

Critical Success Factors:

• The ability to integrate these three systems into JDE with minimal effort, since their projected life is to be one year.
• Acceleration of the project timeline to meet the milestones established in the ERP project.

 

Outcomes:

• A sound knowledge of MLCC''s business processes.
• Solutions that seamlessly integrated with the Legacy and the JDE systems. The solutions Mr. Schalme developed did not care where the data came from; they were able to exchange information with no manual intervention.
• Accelerated project timelines.

 

Airspeed Consulting

Winnipeg MB

Implemented a Linux-based firewall to the Airspeed Consulting network. Analyzed security requirements, evaluated competing products and technologies, and implemented a solution.

 

Critical Success Factors:

• Implementing a solution that was low cost, yet robust to guard against threats.

 

Outcomes:

• A second layer of defense to protect the network from external threats.
• Enhanced security for client's websites.

 

Health Sciences Centre

Winnipeg MB

Documented the current business processes and the technical infrastructure related to the Doctor's On Call Scheduling system and the paging system. Identified redundant business processes. Presented findings and recommendations to HSC directors and to the Winnipeg Regional Health Authority. Recommended business process changes that would reduce errors, improve patient care, and reduce costs.

Deliverables:

• A feasibility report that documented the business processes and technical infrastructure that comprised the Doctor's On Call Scheduling system and the paging system

   

Outcomes:

• Identified redundant processes.
• Provided cost estimates to reduce these redundant processes.

 

Pauwels Canada Inc.

Winnipeg MB

Worked with Pauwels' IT staff to modify their Labour Reporting system and their Indented Bill of Materials report to reflect changing business rules.

Deliverables:

• Accurate allocation of Regular Time, Overtime and Double Time consistent with Pauwels' business rules.
• Correct reporting of user-defined fields on the Shop Single-Level and Indented Bill of Material reports.

 

Critical Success Factors:

• A full order of magnitude improvement in the response time of the Employee Time Detail Report, resulting in a measurable productivity gain with the Human Resources staff.

 

Outcomes:

• A measurable gain in productivity by the Human Resources staff, resulting from optimized code and the reduced need for entering adjustment entries.
• Improved productivity on the shop floor, since all the information is on one report.

 

Manitoba Family Services & Housing

Winnipeg MB

Developed a Java reporting engine to replace the functions of a Report Execution System written in Report Workbench, and a Report Distribution System written using PowerBuilder. This was Family Services & Housing's first foray into Java. Analyzed the document flow to produce a solution that met the business needs of the department. A key constraint of this project was to use the Crystal Reports 8.5 runtime engine to generate the reports previously produced by Reeport Workbench.

 

Critical Success Factors:

• Deal with two different MS Word export DLLs that gave different formatting results.
• Extract Compressed MS Word documents from a 'text' column in Sybase ASE 12.5.
• Given that Crystal Reports did not integrate very well with Java at that time, Mr. Schalme used his system integration skills to develop a report execution and distribution system that utilized a combination of Java, Visual Basic .NET, and PowerBuilder. This system has continued to run smoothly to this day with no problems.