Skip Navigation LinksSolutions-&-Projects

​​​​​​​


applicationdesigndevelopment.jpg
managedservices.jpg

 

​​​In projects over the years, this consulting practice can be seen with strategically collaborating with clients to drive the business where I have been responsible for assisting managers and teams in defining, positioning, designing and presenting a range of I.T. solutions. I believe in interacting on a regular basis with senior management and stakeholders through an Agile process, applying exceptional leadership skills in managing expectations, mitigating risk and removal of any roadblocks. When consulting, I have been asked to develop proposals which define client expectations with product and services requirements necessary to achieve company/team objectives as well engineering and development with a `hands-on` approach. Furthermore, my consulting can work with the different departments and teams to manage time and expectations. While working with the Project Management there is a focus to ensure that services are implemented and delivered as scoped and required. With experience in assessing opportunities and performing necessary due-diligence around technical, operations and financial impacts, I bring a broad knowledge of I.T .solutions and professional services. There is a focus to develop interpersonal and leadership skills while being highly self-directed where needed. I am highly adaptable in taking initiative when in need, with an emphasis on effectively liaising with all levels of management while working as a team member. As a professional member of business communities like the Vancouver Board of Trade and working as a I.T. Professional for nearly 10 years, I bring excellent communication skills and required acumen. With working in so many sectors, dealing with different team dynamics, there is a focus on analytical and decision making skills. With this I bring strong process management skills (creation and change management as well as engagement) to obtain strategies with emphasis on the execution of goals​.

​​

Here are some of my larger full lifecycle projects over the years

TECHNOLOGY

DESCRIPTION

BUSINESS CASE

​​

​MS Excel using VBA, SQL and C#.Net with SQL SERVER

​Designed an EXCEL, VBA code with a C#.Net Forms project. This information system for keeping track of Statistics based on Complaints from outside sources about company Operations. Also updated SQL Server from MS Excel.

​This project kept statistics on issues relating to plant operations and is checked by city officials regularly.

​​ ASP.Net using C#.Net and SQL SERVER, XML

​Designed a windows application which maintains information which integrates MS Access, SQL Server 2005 (back end) with ASP.Net and VB.Net (front-end) and a application in C#.Net (2nd part of the front end). This ASP.Net front end had a MS SQL and MS Access backend. It was done through Top-Down engineering.

​ This project kept track of ongoing production plant activities with running totals, averages, minimum and maximum totals and many other features

​Label software customized using DB4, network label printers, factory computer work stations, SQL Server ​

​Worked on a Team of 5 where my responsibilty for Information Systems Analysis and Design and Database Analysis using MS Excel, some MS SQL scripting(not for implementation) and a label making software package called LabelView Gold(uses DB4). I am also responsible forunderstanding and drawing diagrams using the Unified Model Language (Workflow, E-R, Use Case etc) to go with my SQL engineering if needed in all my projects

​This project is used to print labels using a software package which communicates with a printing machine. All labels are regulated to government standards for industrial packages sent overseas and within Canada.

​ ASP.Net with C#.Net, Sharepoint, SQL Server, XML

​Designed and developed an ASP.Net front end to link with a previous SQL Server 2000 database using C#.Net to report work details (hours, manager, department, etc)..Used stored procedures in SQL Server, then wrote C# code with embedded SQL strings to call different tables to draw information on to an ASP.Net page.

​To report work details such as hours, manager, department and so forth for each employee so managers would have access to that information.

​ ASP.Net with C#.Net with a Calendar ToolPart, SQL Server, Sharepoint sites, AD GroupPolicyfor single sign on and user loggingy. XML 

​Designed and developed the Business Management System website for the Quality department. The site layout was designed by a team member where I made it dynamic but putting in a calendar and customizing their 12 or so SharePoint sites using SharePoint Designer 2007 and the SharePoint Administration portal. The Calendar was a dynamic tool which had the details of where work details were posted. Setup the BI portion with the AD and, the database portion worked had MS reports built using .NET and Oracle 10g tools.


​Designed and developed the Business Management System website for the Quality department.


​The calendar was in MS Excel but I used a web browser window on a C#.Net windows forms application for to Naviagate to the MS Excel spreadsheet. This windows forms application which I created from scratch, there was an Update button which updated SQL Server tables.At the same time, a report was generated where it could be exported to MS Excel or Adobe (PDF).

​So that employees can update information to MS Excel which they were already using and to make use ot publishing data onto Adobe files

​ ASP.Net with C#.Net with a Calendar ToolPart, SQL Server, Sharepoint sites, AD GroupPolicyfor single sign on and user logging, XML

​Designed and developed a website for new hires. All departments would log on with their regular network/windows logons and this application would use windows authentication to give them access to their “new employee” forms. There were 6 departments, and many users. The departments where windows user groups and the user were from each group – this was in my ASP.net/C#.Net code – to look for the user to valid which forms they had rights to use. Each form was linked to SQL Server  – the entered data was written to the appropriate tables in this SQL Server Database. The a report was generated – this report was able to be exported to MS Excel and Adobe (PDF). Setup the BI portion with the AD and, the database portion worked had MS reports built using .NET and Oracle 10g tools.


​To let hiring and current staff information readily available.

Linux Korn Shell, UML Documentation, Agile development, FTP, COBOL 

​Designed and developed 3 Korn Shell Scripts. Korn Shell scripts read from Top to Bottom and this was a problem because there were several functions which needed to be called in a loop where transactions could could place. At that point I broke this script (which was orginally a windows batch script) and broke it down into several small mini scripts. These mini scripts called Cobol Programs and had return codes. Based on return code, I made the scripts find files which needed to be processed, then based on return code, it went to a different script. This loop continued until there were no more files to found which could be processed. 

​Processing files using Linux/Putty scripting to make transactions fast to work within this infrustructure. 

​ ASP.Net with C#.Net, Sharepoint, SQL Serve, XML

​- Developed a company wide SharePoint Solution which took on a WebPage-WebPart solution with reports and data presented on many pages as well as the functionality to adding, removing and updating data to change database tables and reporting pages without ever directly accessing any of those BI tools after they were set up

-This site was Active Directory integrated without SharePoint permissions but Windows Logon Network user permissions.

- Setup the BI portion with the AD and, the database portion worked had MS reports built using .NET and Oracle 10g tools.

-created a tracking file so IT could see what the user is doing, what time they're doing and who they are 

-Utilized Client meetings to meet the needs of the client and at the same time, suggested ways to use the technologies at hand to best fit the long term goals of the organization

-Provided support with InfoPath 2007-2010 (beta), XML​

​Portal site linking all departments