Resume

Project Manager Sql Server

Location:

Calgary, AB, Canada

Posted:

July 13, 2023

Contact this candidate

Resume:

PROFESSIONAL PROFILE

LES POLLARD

*** ***** ***** **

CALGARY, ALBERTA

T2Z 4V8

403-***-****

Email: adyaf4@r.postjobfree.com

Summary:

•Thirty-three years of information technology experience.

•Application development, support and maintenance.

•Excellent report writing and interface building skills.

•Experienced with database design concepts, data organization and storage.

•Good communication skills.

•Solid experience with Visual Studio.Net (C#, ASP, VB), Visual Basic, MS Access, SQL Server, Oracle, PSQL/TSQL, Power Builder, and Crystal Reports combined with good accounting, production and business knowledge.

•Excellent experience with Business and Systems Analysis, able to work with Management, Business personnel, SME’s and third-party vendors to provide a cost effective and beneficial solution.

•Experienced with project research, development, testing, deployment, management, user training and post-production support.

04/04

SKILLS MATRIX

General Skills

Last Used

Yrs Experience

Quick Learner with the ability to learn and master any new system

Current

Full understanding of DLC

Current

Application Developer

Current

Database Analyst/Developer

Current

Systems Analyst

Current

Business Analyst

Current

General Programmer

Current

Reports Specialist

Current

Project Manager

Current

Network Consultant

2000

Team Lead

2021

Requirements Gathering

2021

Hardware Consultant

2011

Application Consultant

Current

Application Development

Last Used

Yrs Experience

Microsoft Visual Studio .Net 2003/2005/2008/2010/2012/2019

Current

Microsoft Visual Studio V6

Current

Visual Basic V4, 5, 6.0 .Net and .Net 2003/2005/2008/2012/2019

Current

C# .Net 2003/2005/2008/2012/2019

Current

SQL Server Tools 18

Current

MOSS / SharePoint

Current

TeamCity V9.1.3

Current

GIT V8.5.13

Current

Kofax (Ascent Capture) V8.0

2014

IBM FileNet V5

2014

Java, Java Script and Java addins

Current

Microsoft Access V2.0, 97, 2000, 2003, 2007 and 2010

Current

Microsoft Visual Fox Pro 4, 6, 7 and 8

2014

Borland Delphi

2004

ASP/ASPX/HTML

Current

COM/DCOM

Current

Power Builder V3, 4 and 8

2002

Crystal Reports / Reporting Service V6, 7, 8, 8.5, 9, .Net, XI, 2008

2015

Business Object Enterprise V2.0 and V3.0

Current

PL/SQL Developer V5.01, V6.01, V19

Current

Quest Software Toad 7.4.0.3, 9.0.1.8

Current

Database Development

Last Used

Yrs Experience

Microsoft SQL Server V 6.0, 6.5, 7, 2000, 2005, 2008, 18 – SSIS/SSRS

Current

Microsoft Azure/Azure SQL

Current

Oracle V 8.01, 9.02, 10, 11 and 12

Current

Oracle BRM

2019

Sybase V5, 7, 8 and 12

2015

MYSQL

2010

Microsoft Access V2.0, 97, 2000, 2003, 2007 and 2010

Current

ETL

Current

Informatica

2019

VAX.VMX

2002

Development Methodology

Last Used

Yrs Experience

Agile

Current

Scrum

Current

Waterfall

Current

Desktop Environments

Last Used

Yrs Experience

Windows 10, 7.0, XP Professional, 2000, NT 4 Workstation, 98, 95

Current

MAC Desktop V 5 through 8

2001

Server / Network Software

Last Used

Yrs Experience

Window 2000/8 Advance Server, NT4 Server

Current

Red Hat Linux RHEL 6,7

2016

Desktop / Server Hardware

Last Used

Yrs Experience

PC Servers – 1 to 4 processors

Current

Network Hardware and Protocol (TCP/IP, IPX/SPX, VIP, NetBeui, Appletalk)

Current

PC Desktop

Current

Macintosh Desktop

2001

Desktop Hardware assembly and trouble shooting

Current

Miscellaneous

Last Used

Yrs Experience

Network/Cyber Security

Current

Data Migration

Current

End User Application training

Current

Application/Technical Documentation and Standardization Manuals

Current

Data Entry

2002

PROFESSIONAL EXPERIENCE

Client: Infosat Communications – Billing Database Administrator

Sep 2021 – Mar 2022

Billing Database Administrator

As a Billing Database Administrator, I am responsible for the maintenance and enhancement of the MS SQL Server. I am involved in the day to day activities of the EngageIP Billing system and responsible for all Administrative activities within EngageIP. I am responsible for execution and reporting for Month End and Year End. Assist with the management of Great Plains accounting and am responsible for the database management of this system. I am involved in software support and licence renewals. Am responsible for setting up and maintaining new and future servers, laptops and desktops.

Environment: Windows 10, MS SQL 8/15, SSRS, EngageIP, Great Plains, MS Office 365.

Development Methodology Used: Agile, Scrum

Client: Trillium Advisory Group –Data Architect

Apr 2021 – Jul 2021

Data Architect IT/IM

As a Data Architect I was responsible for creation of internal IT/IM policies to be enforced at Trillium Advisory Group. I advised on the necessity of I2007 compliancy. Setup and developed a Microsoft Azure SQL Server to speedup the development of the Microsoft Power BI reporting. Planned and executed the migration of data from Microsoft online SharePoint over to Microsoft Azure File Service.

Environment: Windows 10, MS SQL 19, SSIS, MS Azure SQL, MS Azure File Service, SQL Developer 19, SharePoint

MS Power BI.

Development Methodology Used: Agile, Scrum

Client: eWorld Enterprise Solutions –Systems Analyst

Apr 2019 – Jan 2021

Systems Analyst on DOE and DHS Project

As a Systems Analyst I worked on the DOE (Department of Education) PayX project providing MS Sql and Oracle related database support. Provided mentoring, training and assistance to junior developer on SQL stored procedures, scripts and function. Also provided expertise on data relations, conversion, processing and validation. Work on and provided full documentation of the process and procedures involved.

As a Systems Analyst/Business Analyst/Team Lead/Developer I work on the DHS (Department of Health Services) data conversion (ETL) project for the BES project. Provided support on Data conversion from two existing Adabas products over to a single Oracle based target projects. Data was translated, cleansed, and profiled to remove erroneous data and aged data (ETL). Responsibilities include creation of cleansing scripts, conversion scripts, target database scripts and target database migration scripts. Work on and provided full documentation of the process and procedures involved. The application API and backed are developed in Java utilising Spring and Spring boot over an Oracle or D2 database. Work was performed remotely and independent of management interaction.

Environment: Windows 10, Visual Studio .Net 2019, C#.Net 2019, .Net Core 4.5, Oracle 11 and 12, EDQ, MS SQL 18,

SSIS, MS Azure, SQL Developer 19.1.0.1., SharePoint, JIRA, Confluence, GitHub, Java, Python, Ruby,

Spring, Springboot.

Development Methodology Used: Agile, Scrum

Team Size: 3

Client: Shaw Communications –Senior Developer/Team Lead

Oct 2016 – Oct 2018

CDC Development and Support / CBS Support/ BRM/ HCM/ ERP

•As a CDC Developer, responsible for systems analysis and development of Web Based API Data Services using C#/VB/ASP .Net 2010 and 2012. Also responsible for systems analysis and development of Web Based report to access these Data Services. Also responsible for supporting all applications that draw data from the CDC application and to provide support for the main CBS order entry application. Responsible for all updates to the CDC Reconciliation process and assist in CDC enhancements. Responsible for updates and maintenance to the automated meta data drive rebuild system developed in Oracle script to rebuild the entire CDC schema from scratch and repopulate the data. I performed enhancement to the SSIS package used to transfer data from CBS, A VMS/RMS data store to CDC, an Oracle 11G system. All compiling and deployment of the .Net applications was performed through the use of TeamCity V9.1.3. NUnit was used for automated unit testing. Oracle database was hosted on a Linux server. Was responsible for working with this server to ensure file transfers of exported data outbound from the server and for the Oracle and Linux optimization. Responsible for updating and maintaining all documentation for the CDC and CDC Reporting system.

•As a BRM Developer, responsible for development and enhancement of Oracle 11G based PL/SQL packages, procedures and views to support the BRM module. Support is provide using Toad or SQL Developer as the development tool.

•As a TVSC (TeleVision Service Catalog) Technical (Team) Lead, responsible for the team lead, systems analysis and maintenance of the Netcracker developed, Oracle 11G base data catalog. This included inputting of corrected/new data, preparation of data migration exports, trouble shooting of data issues, management and assignment of Service Now tickets to team members and testing of system enhancements.

•As a VIP Developer for both HCM and ERP, responsible for the system analysis enhancement and business processes, development of Pro C/ Oracle PL SQL based processes for enhancements of automated data integration into the VIP Payroll module, interfacing with third party products and general data transfers. This includes conversion of timesheet data into VIP payroll transaction for automated payroll processing.

•Involved with the security of external access to the Shaw network through VPN. Standardizing practices for external data communication through external facing webservices and how to secure these from Cyber attacks.

Environment: Windows 7/10, Visual Studio .Net 2010/2012, C#.Net 2010/2012, ASP.Net 2010/2012,

VB.Net 2010/2012, .Net Core 4.5 .Net MicroServices, Oracle 11G, MS SQL 2008/2010 SSIS, SQL Developer 11.2.0.2, Toad for Oracle 9.0.1.8, TeamCity V9.1.3, GIT V8.5.13, NUnit, Informatica, Red Hat Linux 6/7, Service Now, VIP 7G/8G, Pro C, Java, Springboot.

Development Methodology Used: Agile, Scrum

Team Size: 4

Client: CBU Chevron/Eagle Technologies

Mar 2016 – Sep 2016

B & E Support

As part of the B & E Support team at CBU Chevron I was responsible for the support, maintenance and upgrade of VIP 6G HR module and data. All Upgrades via DLGL TEC implementation and in house testing. Along with support for the in house developed HROS suite of web application to supplement the VIP application. I also heavily involved in the migration of documents and data from the eDocs 11 application over to the Documentum and SharePoint application. I was responsible for the design and delivery of the CMP Validation application to allow user to verify the Data used.

Environment: Windows 7, Visual Studio .Net 2010, C#.Net 2010, ASP.Net 2010, Oracle 11G, VIP 6G, MS SQL 2010, SQL Developer 11.2.0.2, Toad for Oracle 9.0.1.8, TFS, Red Hat Linux 6/7 eDocs 11, Documentum, SharePoint, Remedy.

Development Methodology Used: Agile, Scrum

Client: Shaw Communications – CDC/CBS Development and Support/Sierra Systems

Nov 2013 – Jan 2016

CDC Development and Support / CBS Support

As a CDC Developer, responsible for systems analysis and development of Web Based API Data Services using C#/VB/ASP .Net 2010 and 2012. Also responsible for systems analysis and development of Web Based report to access these Data Services. Also responsible for supporting all applications that draw data from the CDC application and to provide support for the main CBS order entry application. Responsible for all updates to the CDC Reconciliation process and assist in CDC enhancements. Responsible for updates and maintenance to the automated meta data drive rebuild system developed in Oracle script to rebuild the entire CDC schema from scratch and repopulate the data. I performed enhancement to the SSIS package used to transfer data from CBS, A VMS/RMS data store to CDC, an Oracle 11G system. All compiling and deployment of the .Net applications was performed through the use of TeamCity V9.1.3. NUnit was used for automated unit testing. Oracle database was hosted on a Linux server. Was responsible for working with this server to ensure file transfers of exported data outbound from the server and for the Oracle and Linux optimization.

Environment: Windows 7, Visual Studio .Net 2010/2012, C#.Net 2010/2012, ASP.Net 2010/2012, VB.Net

2010/2012, Oracle 11G, MS SQL 2008/2010 SSIS, SQL Developer 11.2.0.2, Toad for Oracle 9.0.1.8, TeamCity V9.1.3, GIT V8.5.13, NUnit, Informatica, Red Hat Linux 6/7.

Development Methodology Used: Agile, Scrum

Client: Canadian Pacific Railway – Pensions Administration/RIS – Sierra Systems

July 2006 – Dec 2013

Report Developer / HRIS BA / Pension Team Lead / Pension BA / Pensions Project Manager

•As a Crystal Reports developer I was in charge of creating, updating and maintaining Crystal Reports drawing data from an Oracle Database system. These reports were of three classifications, those that were ran locally through in internal application written in Visual Basic 6.0, VB script and VB.net, those that were integrating in to the VIP application externally and those that were run through Business Objects Enterprise server V2.0 and V3.0. I was also responsible for Data integrity testing against the database before any reports were placed into production. These reports were used to produce Contact Letters, Safety 7 Claims, WCB, OHS, Pension Statements and Pension Statistics for both DB and DC pension benefits. The Oracle database was hosted on a Linux server. Was responsible for working with this server to ensure file transfers of import and exported data from the server, for the Oracle and Linux optimization and for upgrades to the Oracle database to support the VIP application. Also involved in migration of reports from Crystal over to SSRS over an MS SQL 2005 platform. Also worked on Data migration from VIP over to SAP with the retirement of the VIP application and migration of custom reporting over to the SAP BOBJ module using Crystal, Xcelsius and BO/BI

•As Pensions Project Manager/Team Lead I was responsible for managing all projects related to the Pensions portion of the VIP Application and any internal Pensions initiatives. I was responsible for tracking all costs and expenditures involved with the projects and responsible for monitoring the external companies work. I was responsible for projecting and calculating the budgets for the current and coming year, evaluating the burn rate of these budgets and informing the Pensions Project Working Committee of any discrepancies and unusual activity. Budgets for this ranged from $250,000 through to $2,000,000.

As Pensions Business/Systems Analyst I was responsible for preparing business opportunity, operational and government mandated requirement specification for changes, corrections and enhancement required by the business. These requirement documents were used by third party vendors to make the required changes to their applications. Also worked on projects to migrate the reporting standards from Crystal 8.5 to Crystal 11 and Oracle 9.0i to 10G.

•As an HRIS Business/Systems Analyst I was responsible for preparing business opportunity, operational and requirement specification for changes, corrections and enhancement required by the business outside of the Pension Department, Safety & Claims, WCB and OHS. This included software update, software support Oracle BRM and business use of a MOSS/SharePoint document management system using Kofax (Ascent) Capture to scan in the physical documents. Integrate IBM FileNet and FileNet API into the SharePoint service to provide enterprise level access to the scanned documents. Translation of data from paper or electronic sources.

•Involved in the ETL process for moving data from VIP over to SAP. This was achieved through a series of SQL scripts to extract the data into csv flat files for conversion into SAP.

•Involved with the security of external access to the CP Rail network through VPN. Standardizing practices for external data communication through external facing webservices and FTP service and how to secure these from Cyber/Hacking attacks

Environment: Windows 7/2000/XP, Crystal Reports 8.5/XI, Crystal Report Service 8.5/XI msi, Visual Studio .Net 2003/2005/2007, Visual Basic V6.0, VB.Net 2003/2005/2007, C#.Net 2003/2005/2007, ASP.Net 2003/2005/2007, Oracle 9.0i/10G, Oracle BRM, MS SQL 2000/2005 SSIS/SSRS, MOSS, SharePoint, Kofax (Ascent) Capture V8.0, IBM FileNet 5, Toad 7.4.0.3 / 9.0.1.8, Microsoft Access 2003(V10)/2010, SAP, VIP 6G/7G, Pro C, Business Object Enterprise V2.0/3.0, HP WinRunner, Red Hat Linux 6.

Development Methodology Used: Agile, Scrum, Waterfall

Team Size: 4 - 8

Client: ATB Financial/Inteqna

Mar 2005 – July 2006

Applications/Web Developer

•As an Applications/Web developer I was responsible for the design, development and delivery of a Web Base Reporting Service to replace an existing Microsoft Access 2000 standalone application. The project was developed as a VB.Net/C#.Net/ASPX Web Application Launching SSRS, 2005, Crystal Report 8.5 and Crystal Report XI external report. The Web Based front end communicated to a SQL Server 2000 Database through the use of SQLConnect and ADO.Net. I was also involved in the migration of a standalone Microsoft Access 2000 application over to an SQL Server 2000 Database design and was involved in resolving some of the speed and data integrity issue with this migration. I was also involved in Data Streaming between a remote DB2 Server and SQL 2000 for reporting purposes. Crystal Reports was used to extract financial data for accounting and statistical analysis.

Environment: Windows 2000, VB.Net 2003/2005, C#.Net 2003/2005, Visual Studio.Net 2003/2005, ASPX, ADO.Net, .Net V1.1/V2.0, Crystal Reports 8.5/XI, Crystal Report Service 8.5/XI msi, SQL Server 2000/2005, SSRS, Microsoft Access 2000(V9), Visual Source Safe, Java V1.1/2.0, XML, DB2, Visio 2000.

Development Methodology Used: Agile, Scrum, Waterfall

Client: Acrodex/LPCI

Feb 2005 – Mar 2005

Applications Developer

•As an Applications Developer I was responsible with the upgrading and addition to ad existing Petroleum Tank Management system written Visual FoxPro 8.0. The original project was written in Visual FoxPro V3.0 and required a complete migration into the new development environment and several forms and report were required for new functionality. I was responsible for requirement research, design, development and deployment.

Environment: Windows XP, VB.Net 2003, Visual Studio.Net 2003, Visual FoxPro 8.0, Visual Source Safe.

Development Methodology Used: Waterfall

Client: Elk Valley Coal Corp./LPCI

Oct 2004 – Jan 2005

Crystal Reports Developer

As a Crystal Reports specialist, I was in charge of the re-development of several reports from Crystal V8 and Crystal .Net into Crystal V9. The report were scattered across several projects and I was responsible for standardizing the report style, method of access, data access methods used and integration into VB6 and VB.Net applications. I was responsible for the creation of standardized modules for use in either VB6 or VB.Net to launch and view an internal Crystal Report. These modules are now to be used in all current project and any new projects to be developed.

Environment: Windows2000, VB.Net, Visual Studio.Net, VB 6, ASP, ASPX, Crystal Reports 8/9/.Net, Crystal Report Server, Crystal 9.0 Enterprise, Oracle 8.0/9.0i, Toad 7.4, Visual Source Safe.

Development Methodology Used: Waterfall

Client: Jencess Software & Technologies, Inc./LPCI

Aug 2004 – Sept 2004

Project Manager/Application Developer

As a Project Manager I was involved in the planning and design of software migration from Delphi 6.5, using a CodeBase/Advantage Data Engine to C#.Net, Visual Studio.Net over an SQL 2000/MSDE 2000 data engine. I was also involved in consultations on the existing C#.Net based online suite of products.

Environment: Windows XP/2000, C#.Net, Visual Studio.Net, Crystal Reports 9/.Net, MS SQL2000, Delphi 6.5, Rapid Reports, CodeBase, Advantage Data Engine, Visio 2000.

Development Methodology Used: Waterfall

Client: Alta Steel/ATP

Nov 2003 – Jul 2004

Application Developer

Completing and enhancing an existing Visual FoxPro V6 application. The application is used to track usage and existing inventory for scrap steel. It involves a fully automated scaling and movement process. Was to receive transition of this application from the previous developer, this was not provided. Developed a complete understanding of the application and business requirements with out supervision and delivered the finished product on time.

Environment: Windows/XP/98, Visual FoxPro 6.0, SQL Server 2000/7.0, Novell Netware.

Development Methodology Used: Waterfall

Client: R B Williams Industrial Supplies /Si Systems

Nov 2003 – Nov 2003

Crystal Reports Specialist

Responsible for the design of several reports using Crystal Reports.Net in an ASP.Net environment. These reports were integrated into internal software for internal reporting use.

Environment: Windows/XP, Crystal Reports.Net, SQL Server 2000, Windows 2000 Advanced Server.

Development Methodology Used: Waterfall

Client: Harrison Muirhead/Si Systems

Nov 2003 – Nov 2003

Crystal Reports Specialist

Designed several reports using Crystal Reports Version 8.5. These reports were integrated into existing applications for internal use.

Environment: Windows/XP, Crystal Reports 8.5, Crystal Reports Service, SQL Server 2000, Windows 2000 Advanced Server, Borland Delphi V 7.

Development Methodology Used: Waterfall

Client: Bell West/ATP

Oct 2003 – Oct 2003

Application Developer

Responsible for development of a MS Access XP application to track the completion of the SuperNet project. Application was designed to integrate external and internal information to produce the required reports.

Environment: Windows 2000, MS Access XP, SQL Server 2000, Windows 2000 Advanced Server.

Development Methodology Used: Waterfall

Client: C-TECH Energy/RHI Consulting

July 2003 – Oct 2003

Application Developer

Responsible for research, development, implementation and end user training of the Pro-Rod database application. Pro-Rod is an Inventory tracking and control system designed specifically for the Down Well Rod industry. The Application tracked the purchase, processing and distribution of raw materials through to the finished invoiced product. The application was implemented in Edmonton and Calgary.

Environment: Windows 2000, Visual Basic 6, .Net 2003, Crystal Reports 8.5 .Net, COM/DCOM, MYSQL, Progress SQL, SQL Server 2000, Sybase Adaptive SQL Anywhere V7.0 and Sybase 12, VPN Internet Service.

Development Methodology Used: Waterfall

Client: APA Alberta Pension Administration /Ajilon

Feb 2003 – July 2003

Crystal Report Specialist

Responsible for development and distribution of reports on the APEX project. Developed Crystal Report in Version 8.5 and all associated Tables, Views and program integration with Oracle PL/SQL Developer 5.01 and Oracle 8.1 for both defined and undefined benefits.

Environment: Windows 2000, PL/SQL, Developer 5.01, Oracle 8.01, 9.01, Crystal Reports 8.5, Windows 2000 Advanced Server.

Development Methodology Used: Waterfall

Client: CCD Canadian Courseware Development/Si Systems

Dec 2002 – Jan 2003

Crystal Report / ASP Specialist

Responsible for development and distribution of reports for several products. All products were Web based using ASP to launch the reports designed with Crystal Reports 8.5 and 9.0. Each project used a variety of database engines including Oracle and MS SQL.

Environment: Windows 2000, Crystal Reports 8.5/9, Crystal Reports Service, ASP, HTML, SQL 2000, Oracle 8.01, Progress SQL, Internet Information Service.

Development Methodology Used: Waterfall

Client: TSC Technologies Systems Corporation/Si Systems

Jul 2002 – Oct 2002

Power Builder Programmer / Database Specialist

Assisted in completing a Job Cost Accounting package using Power Builder 8.02 and Sybase Adaptive SQL Anywhere 8.0 Server. Responsible for Application/Server enhancements and additional features.

Environment: Windows 2000, Powerbuilder 8.02, Sybase Adaptive SQL Anywhere 8.0, Sybase 10,11,12, windows 2000 Advanced Server.

Development Methodology Used: Waterfall

Client: Sensor Environmental Services Inc./ATP

Oct 2001 – Apr 2002

MS Access Programmer

Designed and developed a replacement program for 15 Lotus/Excel spreadsheets. This program was designed using MS Access 2000. The program replaced the current spreadsheet template used in the Lab for data reporting. It was intended to integrate this program with the upcoming Oracle Database within 2 years.

Environment: Windows 2000, MS Access 2000, Windows 2000 Advanced Server, VAX.VMS.

Development Methodology Used: Waterfall

Client: Harrison Muirhead/Si Systems

June 2001 – July 2001

Crystal Reports Specialist

Responsible for the design of several reports using Crystal Reports Version 8.5. The reports were integrated into the existing applications.

Environment: Windows 2000, Crystal Reports 8.5, SQL Server 2000, Oracle 8.01, Windows 2000 Advanced Server, Borland Delphi V6/7.

Development Methodology Used: Waterfall

Client: DMR Consulting/CTC

Jan 2001 – Feb 2001

Crystal Reports Specialist

Responsible for the design, development and implementation of reports using Crystal Report

Version 8. These reports were integrated into the Mortgage Management program developed by DMR. Involved in the integration of each of the programmer’s module into the finished product.

Environment: Windows 2000, Crystal Reports 8.0, Visual Basic 6, SQL Server 2000, Windows 2000 Advanced Server, Citrix, Visual Source Safe.

Development Methodology Used: Waterfall

Client: Department of National Defense

InfoMagnetics Technologies Corporation

Feb 1993 – Jan 2004

Computer Programmer/Specialist/Team Lead/Project Manager

Responsible for the systems analysis, process research, design, development and implementation of several nationally used applications for the Department of National Defense. Additional responsibilities included end user training, Programmer training, Network consulting and administration and Data migration.

CFEMS (Canadian Force Engineering and Management System)

1993 - 2003

A multi-user work order, cost tracking system. This application tracks the costs of doing business for the Construction Engineering section of the Department of National defense. Tracked in the application are Personnel wages, Contract service, Inter-Departmental services and Personnel entitlements. This application is also used to split and report the costs shared with multiple Allies on Canadian Training bases. This application has gone through several revisions and a name change. From V4.X a centralized SQL Server deployment and upgrade method was employed removing the necessity of visiting each base to perform a deployment or upgrade. Worked on the following Versions. CFEMS V 6.x included migrating data from Oracle 8.01, SQL Anywhere 5.0, Excel spreadsheets, MS Access 97.

CFEMS V7.X, Windows 2000, Visual Basic.Net, Crystal Reports.Net, ASP.Net, ADO.Net, SQL Server 2000, DTS, Windows 2000 Advanced Server, Visual Source Safe, Visio 2000. Acted as Team Lead/Developer

CFEMS V6.X, Windows 2000, Visual Basic 6, APEX Tools, Crystal Reports 8.5, Crystal Reports Service, COM/DC, SQL Server 6.5, DTS, Windows 2000 Advanced Server, Oracle 8.01, SQL Anywhere, Excel, MS Access 97, Visual Source Safe, Visio 98. Acted as Developer/End User Support

CFEMS V5.X, Windows/95, MS Access 97, Powerbuilder V5, Windows 2000 Advanced Server, Novell 4.01, Banyan Vines 6.0, Oracle 8.01. Drew data from MS Access 97 and SQL Server 6.5. Acted as Team Lead/Developer/ETL Specialist

CFEMS V4.X, Windows 95, MS Access 2.0, Powerbuilder V4, SQL Server 6.5/6.0, Sybase SQL Anywhere V5, Sybase 6, Novel 4.01, Banyan Vines 6.0. Acted as Team Lead/Developer

AFEMS V3.X, Windows 95, MS Access 2.0, Powerbuilder V3/4, SQL Server 6.0, Sybase SQL Anywhere V5, Sybase 6, Novel 4.01, Banyan Vines 6.0, Acted as Project Manager/Developer

AFEMS V2.X, DOS Windows 3.11 Workgroup, Clipper, Xbase, Novell. 3.11. Acted as Project Manager/Developer

AFEMS V1.X, MS DOS, FoxPro 2.0, 2.5, Xbase, Novell 3.11, set up network. Acted as Project Manager/Developer

Development Methodology Used: Waterfall

Team Size: 4 - 12

R3A (Realty Asset Accrual Accounting)

2000 – 2003

A multi- user asset accounting system; this application tracked the cost of acquisition of Realty Assets, their cost depreciation over a given time period, cost of enhancements and disposal of the assets. The application was designed to interface with several DND standard applications including CFEMS, RAIS, Aladdin and FMAS. Worked on two versions.

Environment: Windows 2000, Visual Basic 6, APEX Tools, Crystal Reports 8.5, COM/DCOM, SQL Server 6.5, Windows 2000 Advanced Server, Oracle 8.01, Excel, MS Access 97.

Development Methodology Used: Waterfall

FCEPRJ (Force Construction Engineering Projects)

1999 – 2003

•Worked on an application which tracked the location and cost of Construction Engineering drafting department projects. Costs are track by personnel time and Contracted services. It was designed to interface with the CFEMS database and share relevant information.

Environment: Windows 2000, Visual Basic 6, APEX Tools, Crystal Reports 8.5, COM/DCOM, SQL Server 6.5, DTS, Windows 2000 Advanced Server, MS Access 97.

Development Methodology Used: Waterfall

CESS (Construction Engineering Supply Section)

1997 – 1998

•Participated on an application which tracked the location of supply stock, the cost of acquiring these supply stocks and the usage and cost of standing equipment; interfaced with the CFEMS Database.

Environment: Windows/95, MS Access 97, Novell 4.01, Banyan Vines

Contact this candidate