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.