Glen Dignard

1804-77 Howard Street
Toronto, Ontario M4X1J9 /
416-619-7658

Goal-oriented software developer with over 10 years experience in building client-server and Oracle solutions who prides in delivering quality results in challenging fast-paced environments. Innovative problem solver able to see issues from both a technical and business point of view.

SKILLS

  • Database

• Design, Model, ETL, Data Warehousing

• Performance tuning, explain plans, indexes, security roles/privileges

• Tables, views, packages, stored procedures, triggers

• Oracle6i-10G, PL/SQL, SQL, SQL*Plus, SQL Scripts, SQL*Loader, Export and Import

• Microsoft SQL Server 6.0-2000, Access 2.0-2000

  • Programming Techniques / Languages

• Complete Software Development Life Cycle, Estimating/Requirements/Design/Code/Test/Deploy

• Object Oriented Programming - Multilayer development

• Visual Basic 6.0 back end component/DLL development, front end development

• Web development in ASP, VB Script, HTML, Java Script, and PHP

• Source code control with Visual Source Safe and PVCS

• Unix Korn Shell scripting, Windows Batch Scripting, Perl scripting

  • Operating Systems/ Hardware/Networking

• MS DOS, Unix, Linux, Windows 3.1/98/2000/XP/7, Windows NT 4.0/2000

• Installation, troubleshooting and configuring

• Cisco CCNA knowledge, network hardware, protocols, TCP/IP, OSI architecture

PROFESSIONAL EXPERIENCE

Stratos Global - An Inmarsat Company, St. John's, Newfoundland
Senior Developer (4/2006 - 7/2010)
• Develop and maintain processes to collect satellite call data records from satellite stations by ftp and load data into a production database for a Global Telecommunications company.
• Perform cleansing on loaded data, preparing and loading it into the billing database
• Create system requirements from business requirements
• Design and write Oracle PL/SQL packages to integrate data from separate applications.
• Analyzing and rewriting existing processes and SQL to improve performance and stability.
• Delivering quality solutions under tight time lines and high pressure.
• Utilized: Oracle9i-10G, SQL Scripts, PL/SQL, SQL, SQL*Plus, SQL*Loader, PVCS,
MS Windows 2000/XP, batch scripting, Toad, Perl
Keane, Halifax, Nova Scotia
Data Warehouse Programmer (9/2003 - 4/2006)
• Develop and maintain business processes for a financial data warehouse to load financing and sales data from separate sources into a financial data warehouse.
• Provide production support monitoring of financial systems by normal day-to-day and on-call support.
• Analyze and create requirements based on user requests.
• Develop scripts and packages to perform database selects, loads, insert/updates, extracts, data cleansing.
• Perform DDL for table/view creations/drops/alters.
• Performance enhancements via table indexing and analyzing, SQL rewrites
• Developed and document to CMMI Level 5 standards.
• Utilized: Oracle8i, SQL Scripts, Unix Shell Scripts, PL/SQL, SQL, SQL*Plus, SQL*Loader,
PVCS, Unix, MS Windows 2000, Microstrategy 7, Toad, Caliber, Test Director
Ernst and Young, Lyndhurst, New Jersey
Quality Assurance Analyst (6/2003 - 9/2003)
• Quality Assurance team member analyzing requirements and design specifications of Ernst and Young’s Financial Management Application.
• Verified application performed calculations and formatting as expected producing accurate financial reports.
• Utilized: Oracle, SQL*Plus, Lotus Notes Domino Reports, Microsoft Excel.
Atlantic Craft Trade Show, World Trade Center, Halifax, Nova Scotia
Freelance Developer (8/2002 - 8/2002)
• Analyzed existing trade show registration program to update the application’s database, application, and reports to meet new requirements of the trade show.
• Discussed requirements and tested the application remotely via telephone and email and packaged into a set-up program
• Utilized: Visual Basic5.0-6.0, Microsoft Access 95-97, Crystal Reports 5.0-7.0
Telepix Digital Imaging, St. John's, Newfoundland
Web Developer – Research and Development (11/2000 - 4/2002)
• Designed and developed COM objects for the back-end of a multilayer distributed E-commerce enabled photo management and ordering web application which can instantly generate a customizable web solution for a digital imaging client.
• Developed front-end ASP pages that accesses Visual Basic COM objects for interaction with the database and file storage.
• Designed and developed an administration web site for the application.
• Analyzed the application’s current and future use and designed the best methods and technologies to make this application fully generic and customizable while maintaining optimal performance and scalability.
• Utilized: Visual Basic 6.0, COM, Visual Studio Environment, ASP, JavaScript, IIS
DP Solutions Inc., Grand Falls - Windsor, Newfoundland
Programmer/Analyst – DCOM (1/2000 - 11/2000)
• Developed Visual Basic COM objects for the middle and end tier of a distributed equipment maintenance application in a Visual Studio development environment.
• Designed and developed SQL Server and Oracle back end database tables, stored procedures, and triggers.
• Utilized: DCOM, Visual Basic, Visual Studio, SQL Server, Oracle 7, PL/SQL
Cooperative Work Term III
Newfoundland and Labrador Credit Union, St. John's, Newfoundland
Employee Evaluation System Developer (6/1998 - 8/1998)
• Developed an Employee Evaluation System for the Department of Human Resources to manage employee performance and salary reviews.
• Discussed with the users of the application the functional requirements and generated business requirements and finished application.
• Utilized Microsoft Access 97
Cooperative Work Term II
Department of Canadian Heritage, Halifax, Nova Scotia
Database Application Developer (9/1997 - 12/1997)
• Developed a SQL Server database to store and maintain MP's and Companies mailing addresses
• Developed a web interface to manage data, create automated mailing lists and administer front end web.
• Utilized: Microsoft SQL Server 6.0, Microsoft Access 97
Cooperative Work Term I
Department of Canadian Heritage, Halifax, Nova Scotia
Database Application Developer (1/1997 - 4/1997)
• Developed an MS Access Grants and Contributions Management Database and a Political Member Database for the Atlantic Region.
• Utilized: Microsoft Access 97

EDUCATION

Bachelor of Computer Science
Memorial University of Newfoundland (1993-1996), St. John's, Newfoundland
Technical University of Nova Scotia (1996-1999), Halifax, Nova Scotia / 1999
Post Baccalaureate Diploma in Information Technology
Memorial University of Newfoundland Continuing Studies, St. John's, Newfoundland / 2003