.Net Developer Management Data Programmer Software

Michael Phillips

email: ********@*******.*** cell: 647-***-**** and 613-***-****

Highlights of Skills and Qualifications:

15+ years Application and Database Programming and Design 15+ years Object Orientated Programming 10 + years programming with VB, FoxPro and VFP10+ years experience programming with ASP.NET and VB .NET9+ programming with JSP, Java, JavaScript, MSSQL, Oracle5+ years programming with C#5+ years lead programmer, mentoring less seasoned programmers through SDLC

Capabilities:Able to handle multiple assignments at onceExpert in application design and developmentProven track record of accepting challenges and meet deadlines

Certifications:

Sun Certified Java Programmer 5.0, Web Component Developer 5.0

Security Clearance

Secret Level II

Professional Experience:

Client: Ontario Ministry of Community and Social Services, Toronto, ON

Role: Senior Programmer Analyst

Start/End Date: January 2012 – May 2012

Working on a team consulting with the team architect for logical and physical design documents and working with the developers and business analysts to develop a Windows Forms WCF Services 3-tier application for a Data Exchange solution used by two Government Departments and one third party adjudicator. The programming is done using VB .NET and third party controls with a MSSQL 2008R2 database.

Develop a UI to enable automation of processing records retrieved from the uploaded data and developing the stored procedures to be used with the file processing for determining record status. The design and development work involves mapping between two separate systems for bi-directional flow of data to enable database synchronization for the two Government Departments and the third party adjudicator as well as providing sets of data, each fitting a profile, from the one data set uploaded used to enable automation of tasks related to establishing a records' status.Participated in meetings providing architectural and technical expertise, guidelines and critiques Provided coaching for and assisted other programmers with .NET and Visual StudioMade modifications to existing code and GUI to conform the application to meet accessibility guidelines Converted Crystal Reports to SSRS using the Business Intelligence Development Studio. The conversion required upgrading stored procedures and data mapping for fields and code values.Provided the Detailed Design Documents for Functional Design Documents

Environment: VB.NET 4.0, C# 4.0, ADO.NET 3.5, UML, XML, WCF, Visual Studio .NET 2010, SQL SERVER 2008R2, SSRS and Crystal Reports, Team Foundation Server

Client: Durham Childrens Aid Society

Role: Senior Programmer Analyst

Start/End Date: June 2011 – September 2011

Worked as a Senior Programmer Analyst providing development and support for an application developed using ASP and VB .Net with a with a MSSQL 2008R2 database with Visual Studio .NET 2010. The project was built on top of legacy C# libraries and used Telerik Radcontrols for ASP .NET AJAX.

Meeting with Users to gather information used when fixing application issues and for use when I needed to manually update their database. Writing custom Server Side and Front End Code for a data driven an ASP .NET Web Content Management Application The application I maintained code for was a data-driven content management system used in day-to-day operations by the workers at the Durham Childrens Aid Society for their case management. Using ASP, created and implemented Server Side Includes for use with an existing framework to provide the ability to reclaim deleted records from an archive database and for automating the work flow of the caseworkers by creating emails, documentation and new records when the case worker approved or disapproved a file.Using ASP, I created and maintained code for data driven Tree Views and for an application menu. I worked with enhancing accessibility and performance for existing Tree Views, Menus and breadcrumbsWrote custom server side code for use with a custom Object Orientated Content Management system which required expert programming skills for working with dynamic content and control flow.Enhanced existing search functionality using JavaScript and Server Side code. The search function was used in the base form class and the coding skills required expert knowledge of Object Orientated programming, working with control flow statements and data types.Debugged the menu navigation for issues related to Accessibility and JAWS.This enterprise class relational database design had various automated tasks, such as column and trigger generation, built in which required advanced T-SQL programming skills. Designed and tested triggers, stored procedures and functions for this very involved system to accommodate a request for implementing an automated work flow into the existing software for when a Case Worker needed to close and transfer their file to another division. Resolved issues with SSRS related to data, database design and as well using the report designer to correct issues. Resolved issues with the front end related to Javascript and HTML.

Environment: Telerik, ASP.NET 3.5, VB.NET 3.5, C# 3.5,ADO.NET 3.5, HTML, Java Script, XML, Ajax, JQuery, Visual Studio .NET 2010, SQL SERVER 2008R2, SSRS and Crystal Reports,Team Foundation Server

Client: Elections Canada, Ottawa ON

Role: Senior Programmer Analyst/Team Lead

Start/End Date: September 2008 – May 2011

Worked in the Special Voting Rules division supporting a legacy enterprise class relational FoxPro 2.6 system and all other FoxPro products. This role required interaction with other IT departments and Elections Canada officers as the legacy product was very dependent on resources external to FoxPro.

Responsible for identifying and resolving design issues with the data-centric application and for the design and development all FoxPro solutions related to this legacy product. One of the tasks completed involved automating the generation of voter campaign contact lists which required testing, designing and developing a database driven solution using triggers, stored procedures and functions to be integrated into their existing enterprise class relational database.

Worked as the lead programmer for the Special Voting Rules departmentPerformed modifications to, and fixed bugs, for the enterprise class relational FoxPro 2.6 systemDeveloped and tested new applications for administration of the FoxPro 2.6 system, user authentication and voter contact. The administration application allowed the Elections Canada staff to automate the conversion of external resources for import into or integration with FoxPro and to perform other tasks such as ad-hoc queries. The user authentication application allowed administrator’s easier management of Legacy system users and the voter contact system, built for the desktop using FoxPro, allowed administrators to conduct automated voter contact campaigns for letter, email and phone call contacts. This application was also built using both VB Script and Java Server Tags to demonstrate a web prototype.Worked with J2EE, XML, ANT, Oracle PL/SQL and UML designing, developing and implementing a Letter Generator and Campaign module, using the Eclipse IDE and third party controls, for the system that replaced the legacy system.Installed and trained users on Nexus, Hudson, Maven and SVN (continuous integration)Provided instructions and coaching for programming with FoxPro, .Net and JavaUsing ASP, created a web application, using custom controls and the model-view-presenter pattern, for consolidating sign on to web sites, Breadcrumb and Menu navigation with XML. This data driven application was used for administering authorization to resources and web sites. The application acted as a single sign on point and collected data related to transactions and database activity, from one or more applications, for use with reports and an alert prompt-response system.Developed websites and applications using UML, ASP .NET with VB .NET and C# with Visual Studio .NET 2008 and 2010 and MSSQL 2008. The websites were related to Voter Contact, Sport League Statistics and a Medical Clinic.Using ASP .NET, built administrator and developer tools, using server side code, which included applications and modules used to generate code and configuration files, parse XML and CSV files, generate PDF files and Excel Reports, manage Voter Contact lists, edit Letters, upload resources and update web content.

Environment: ASP.NET 3.5, VB.NET 3.5, C#.NET 3.5, ADO.NET 3.5, HTML, Java script, Silver Light 3.0 and 4.0, XML, UML, J2EE, Visual Studio .NET 2008 and 2010, SQL SERVER 2008, SSRS, and SSIS, MySQL 5.0,MS Access, FoxPro, Nexus, Hudson, Maven, SVN

Client: Maxwell Paper, Belleville ON

Role: Programmer Analyst

Start/End Date: March 2008 – August 2008

Worked with Windows Services, XML Web Services, UML, VB, ASP.NET, MSSQL 7.0 and 2005 and other web languages and technologies to deliver both desktop and web applications. These new applications improved processes related to the tracking of a nationwide equipment inventory for various clients (two major clients were Payment Tech and TD Canada Trust), and the automation of reporting for tracking the various types of service calls received in delivering on site technical support for the equipment. Worked with a team that was orientated towards providing data services and asset tracking.

Worked as the lead programmer developing desktop and web applicationsDesigned, developed and tested a Database Application built using stored procedures, functions and views that was used for tracking and measuring the performance of services provided by field technicians as well as collecting data used with Metric EvaluationsDesigned and developed a data warehouse and two transactional databases using MSSQL 2008 to be used as an enterprise class relational database that was able to permit migration of MSSQL 2005, 2000 and SQL 7.0 data in order to allow for the upgrade and conglomeration of their databasesDeveloped and tested an application generator, a user authentication and menu generation system, a prompt management system and an enterprise class relational data warehouse ASP .NET with VB .NET and MSSQL 2008 using Visual Studio .NET 2003 and 2005. The applications worked together to collect the data required for metric evaluation of the day to day operationsDesigned, developed, tested and implemented a WAN solution for a system that used XML document retrieval and validation as well database updates and inserts of information relating to the major clients customersDesigned and developed desktop applications to assist with data administrationThe alert prompt system was designed to automate the delivery of messages related to the state of data in the database. This system responded to settings created by users that would notify them of a data situation based on either a single occurrence, a number of occurrences, or a number of occurrences over a date range or a period of timePrototypes for the alert prompt system and the user authentication systems were built using VB ScriptDesigned and developed reports for SQL Server Reporting ServicesProvided coaching for and mentored other programmers with .NET and Visual StudioProvided the historical data required for metric evaluation

Environment: ASP.NET 2.0, VB.NET 2.0, ADO.NET, HTML, Java script, XML, UML, Visual Studio .NET 2003 and 2005, MSSQL 2005, 2008 and 7.0, SSRS, SSIS

Client: Self Employed Web Developer, Ottawa and Belleville ON

Role: Programmer Analyst

Start/End Date: September 2005 – March 2008

Worked with Windows Services, XML Web Services, UML, VB, ASP.NET, MSSQL and MySQL. Provided programming services for small companies. Researched and evaluated technologies related to automating office procedures and internet presence. Designed, developed and tested desktop and web applicationsWorked as a freelance web designer providing software development and IT services to small companiesCreated software used for an Alert Prompt Response module, a Content Management System, a User Authentication and Resource Authorization module and for Web Site management, navigation and code generation

Client: eQube, Calgary, AB

Role: Programmer Analyst

Start/End Date: June 2006 – May 2007

Worked on a team providing support for a enterprise software solution used by the lottery corporations of British Columbia, Alberta and Ontario provinces for the operation of the Bingo Halls and the Lottery Corporation’s central management.

Maintained and developed WinSock servers written in Visual Basic and Visual FoxProProvided various DBA services for enterprise class relational databases used by the Lottery CommissionTested, maintained and developed client-server and WAN applications written in Visual FoxPro and ASP.NET with VB .NET using Visual Studio .NET 2003 and 2005Designed and debugged an ASP .NET front end for the Lottery Gaming Commission existing website page, within the CLF standards, used for displaying the status of replication between the Commission and the Bingo HallsDeveloped and maintained enterprise class relational MSSQL databases, debugging existing stored procedures and functions as well as designing and adding new stored procedures, functions, tables and views for MSSQL 2000 and 2005 databases. Assigned the task to modify and/or fix an existing data driven report used for inventory, financial or customer trackingPerformed occasional database-related duties for MSSQL 2000 and 2005 Replication (Push and Pull), Data Purging stored procedures, SQL, migrating databases and/or softwarePerformed upgrade of the MSSQL 2005 databases to MSSQL 2008 which required re-coding procedures related to replicationDesigned and developed reports for Crystal Reports and SQL Server Reporting Services Evaluated and tested a web services project and the Microsoft Team Foundation ServerProvided coaching for and lead other programmers on work related to database replication and object orientated programmingDeveloped design specifications for overseas contract programmers using UML and Technical Writing

Environment: Visual Basic, Visual FoxPro, Visual Studio .NET 2003 and 2005, MSSQL 2005 and 2008, SSRS, SSIS, ASP .NET 2.0, Team Foundation Server. UML, VB .NET 2.0, TCP/IP

Client: Atom Solutions, Kemptville ON

Role: Programmer Analyst

Start/End Date: July 2004 – January 2005

Provided IT services as a System Programmer and Database Analyst. Worked with an Automated Management Software solution (J2EE and Oracle) developed for the purpose of tracking and reporting on work place absence events. Software development took place using the T2M (Java) framework, Oracle 8i, Eclipse 3.0 and Tomcat 5.0 using the UNIX RedHat Enterprise Edition 3.0 platform. The project source was protected by a CVS repository and built using the ANT build process. Defects were tracked using the TestTrack Pro bug tracking software. Development took place using the RUP software design methodology. The product was built using the J2EE framework designed for the Unix platform, incorporating the Jakarta Struts development framework. The product, an Integrated Disability Management (IDM) system, was designed around Absence Management and FMLA rules.

I was required to act as both a Programmer Analyst and a DBA for this enterprise class relational database and Java Framework system.

Prepared high and low level technical requirement documents, ER diagrams and unit tests while performing technical writing, database administration, database tuning, software development, testing and debugging.

Environment: HTML, Java Script, XML, UML, J2EE, Oracle

Client: Lewis Bridges & DuPont, Ottawa, ON

Role: Programmer Analyst

Start/End Date: July 2002 – October 2003

The Ottawa Company Lewis Bridges & DuPont (LBD), a supplier of Consular Services in the Ottawa region, required upgrading of existing applications, design and implementations of new applications for their growing company. Requirements included the development of a WAN application using the Internet and desktop software to interact with QuickBooks 2002. Developed an enterprise class relational database and web application using MySQL as the backend that would allow LBD interaction with their clients over the Internet. Applications used for automating daily tasks were created using Visual FoxPro and Visual Basic. The job required expertise in converting existing applications and developing new applications using Java (J2EE), JSP, ASP and ASP .NET.

Automate manual operations of a small office into a custom client server and web applicationDesigned, developed, tested, documented and implemented a client server application used to track documents, integrate with QuickBooks, provide reports and labels and assist in customer contact for providing services related to visas and document attestationDeveloped, designed, documented and implemented the company’s website and a web application used to provide email estimates and instructions for services selectedThe web application communicated with QuickBooks and the client server application using XML over a WAN

Environment: JSP, ASP, ASP.NET 1.1, VB.NET 1.0, HTML, UML, Java script, MySQL, MS Access, FoxPro

Client: The Client Server Factory, Toronto, ON

Role: Programmer Analyst

Start/End Date: June 1999 – April 2001

This was a three-month contract to develop a enterprise class relational FoxPro database application, which led to a successful employment relationship with this outsource software development company. Working with a variety of clients, I performed Software Programming, Technical Writing, User Training, Internet Design Analysis, and Database Design services.

Upgraded and revised a FoxPro 2.6 database application for an Insurance Company based in Bermuda. Led a team of three Programmers who performed maintenance on the existing system as well as analysis, development and testing of the upgraded application used for the company's day-to-day insurance operations For an insurance company, I designed, developed, tested and documented a reporting system. Wrote programs for converting and migrating their enterprise class relational database to MSSQL or Oracle Database.For the City of Brampton, I developed and provided training for various applications and databases to enhance City Government services provision via Public Web site Administration Modules, Online Timesheet Reporting, Project Management/Accounting, and Bug Reporting SystemsDeveloped, designed, documented and implemented an application used by the City’s business development department. Developed stored procedures and functions for use with their existing enterprise solution. The WAN application was comprised of an enterprise class relational SQL 7.0 database, a client server application and a module of a web application built using VB ScriptDeveloped, designed, documented and implemented the City’s website and created a Web Administrator application used for maintaining the site’s navigation

Environment: Visual Basic, ASP, HTML, UML, Java script, Oracle, SQL Server 7, FoxPro

Client: DND, Ottawa, ON

Project: Inventory Rationalization and Reduction Project (Canadian Forces Supply System)

Role: Programmer Analyst

Start/End Date: November 1997 – December 1998

The objective of this project was to develop automated timely reporting on the status of the 1.4 million records of the CFSS as well as mentoring a team of two Commissioned Officers, three Non-Commissioned Officers and two civilians. This data was to be delivered to 175+ Supply Managers and/or Life Cycle Managers providing details about inventory items while the rationalization and disposal of excess/surplus inventory was in process. Additionally, the system summarized data for inventory change reporting. This was a very large and challenging organizational task that was critically dependant on person-to-person communication.

Designed custom software to modernize the reporting system to distribute information used by CF staff with the inventory reduction programAutomated the procedures for the main report as well as a number of other smaller reports and gather information used to develop customized solutions for the people involved in this inventory rationalization projectResponsible for all implementation, training, support and documentation of the software deliveredTrained users such as Warrant Officers and Sergeants on smaller applications Designed, developed, documented and implemented smaller applications and programs which assisted in sending and receiving batches of data that were used by supply managers for reporting on the CFSS inventoryProvided DBA services to other departments which involved migrating and converting data retrieved from enterprise class relational databasesWorked with the data team responsible for mainframe data to ensure the data correctness for the project and to capture custom data for client server applications I worked with

Environment: Visual Basic, MS Access, FoxPro 2.6, Oracle

Client: Innovision Consulting, Ottawa, ON

Role: Programmer

Start/End Date: June 1996 – October 1997

Innovision provides I.T. consulting services to a variety of Military and Government Departments. As an Application and Database Programmer, I developed in FoxPro language versions -2.x to VFP 5.0. Tasks included: product documentation and creating on-line help systems, product development, user training, system testing, data modelling and technical writing.

Installed and tested software at CFB Gagetown and provided user training for a system for tracking and reporting technical problems for a new helicopter squadron. Participated in the follow up reporting and technical supportParticipated in the full SDLC for a enterprise class relational DND Database application, working with two Chemistry Scientists, that when populated with records for chemicals, products and their components would rank the products in the database against each other and/or a set baseline for a health/safety/environmental and overall rating. Involved the design and development of classes used for the Chemistry Scientists objected orientated client server application Acted as the sole programmer responsible for the Chemistry Scientists application maintenance and any change requestsProvided testing and debugging for a enterprise class relational database application using VBA which was used by the Unemployment Insurance Appeals Court for their day-to-day operation Produced technical manuals and user manuals using my technical writing and desktop publishing skills

Environment: Visual Basic, Access, FoxPro, Crystal Reports

Education and Professional Development

2012 HTML5 Training

2011 AJAX and JQuery Training

2010 C#, XML and Web Service training

2009 Design Pattern and UML Training

Sun Certified Web Component Developer training

2008 Sun Certified Web Component Developer training

Sun Certified Java Programmer 5.0 training

2002 PRAXIS Ottawa

Oracle Enterprise Application Developer Course

1996 PRAXIS Ottawa

Advanced Object Orientated Programming and Database Design

1994 CGA Student Ontario

Financial Accounting, 3rd Level CGA Ontario Student Complete

Contact this candidate