Glen Dignard Email & Phone Number

Toronto, Canada Area

• Designing and developing Oracle PL/SQL scripts in an Oracle 11G data warehouse used to hold confidential health information. Support data loading for a wide range of health applications and reporting systems.• Develop requirements and work with stake holders directly providing quality service.• Use ticketing and approvals to support the entire development for request for changes and incidents, approvals and supporting ticketing process.• Tools: Oracle 11G, SQL Scripts, PL/SQL packages/procedures, SQL Developer, Windows 7 , ITIL incident management service processes, JIRA

Toronto On

Contractor (IQ Hunt) at Guarantee Company of North America, Toronto, OntarioData Warehouse ETL Developer (11/2013 – 05/2014)• Created tables and triggers in an Oracle 11G data warehouse used to hold insurance related information on policies and claims. • Developed Oracle 11G SQL scripts, PL/SQL ETL packages/procedures in SQL Developer to extract the insurance policy and claims data from multiple Oracle sources into the data warehouse by a regular batch process which transforms the data into warehouse format.• Analysis and updating mapping documents, remapping data and table changes to maintain consistency between multiple designs, changing scope.• Tools: Oracle 11G, SQL Scripts, PL/SQL packages/procedures, SQL Developer, Windows 7

Toronto, Ontario

• Maintained and enhanced a project management monitoring/tracking application built in Microsoft Access 97 with a back-end in Oracle 9i. Created tables, views, triggers, packages, stored procedures, performance tuning. • Developed an automated migration ETL process in Oracle PL/SQL in Toad to synchronize data in separate Oracle databases to eliminate re-entry of data and improve data consistency. Built a front end GUI in Microsoft Access 97 providing users the ability to select, reject or update mappings while importing data and interfacing with the Oracle processes.• Met with internal clients to understand business requirements and generate estimates, build system requirements to design and code applications. Deployed updates to production database and application.• Enhanced and created new Microsoft Access 97 and Excel 2000 Macros/reports to assist project managers with the constantly evolving company business model.• Developed SQL ETL scripts in Toad to process data weekly from Human resources to calculate resource usage to date and update the data in the Oracle database to allow visibility for managers to see how many hours of work and who has been working on a project at any given time. • Provided excellent customer service to internal clients, assisting with setup, training, installation, training, troubleshooting and configuring.• Tools: Oracle 9i, SQL Scripts, PL/SQL, Toad, Microsoft Access 97, Microsoft Excel, Windows XP

St. John'S, Newfoundland

• Developed SQL*Loader parameter files and SQL scripts to collect satellite call records from satellite stations by FTP and load into a production database for a Telecommunications company. • Performed cleansing on loaded Oracle data, preparing and loading it into the Oracle billing database.• Developed Oracle PL/SQL packages in Toad to perform data migration and integrate data from separate customer management applications. Used PVCS for revision control.• Analyzed/rewrote existing processes and SQL improving performance and stability. Most notably improving a package that has taken up to three days to run, often failing and requiring manual updates. By using explain plans and Oracle SQL Tuning adviser, applying indexes and rewriting it into a dynamic package was able to develop a program which no longer needed frequent updates and ran successfully in under 3 hours.• Developed Perl scripts to connect to an Oracle database to retrieve parameters of sites to connect to, then connect and download and load data, recording and emailing any resulting failures and successes.• Evolved business requirements into system requirements, design documents, test plans to design, code, test applications. • Tools: Oracle 9i, Oracle 10G, SQL Scripts, PL/SQL, SQL, SQL*Plus, SQL*Loader, PVCS, Windows 2000/XP, batch scripting, Toad, Perl

Halifax, Nova Scotia

• Analyzed and created requirements based on user requests to develop and maintain business processes for a financial data warehouse to load financing and sales data from separate sources. • Provided production support monitoring of financial management systems by normal day-to-day and on-call support.• Developed SQL and Korn Shell scripts and packages to perform database insert/updates, extracts, data cleansing. Scripts were executed through Unix and SQL*Plus.• Develop stored procedures and packages in Toad to perform transformations of data once loaded in the warehouse.• Created SQL*Loader parameter files and SQL scripts to load data into an Oracle 8i database.• Exported and imported tables with Oracle Export and Import.• Perform DDL for table/view creations/drops/alters, performance tuning, explain plans, table indexing, constraints.• Evolved business requirements into system requirements, design documents, test plans to design, code, test applications. Developed and document to CMMI Level 5 standards. • Interacted with Caliber for requirements management and Test Director for creating test plans and results.• Tools: Oracle 8i, SQL Scripts, UNIX Korn Shell scripts, PL/SQL, SQL, SQL*Plus, Oracle Export/Import, SQL Import, PVCS, UNIX, Windows 2000, Microstrategy 7, Toad, Caliber, Test Director

St. John'S, Nl

• Designed and developed Visual Basic 6.0 COM objects for the middle tier of a multilayer distributed E-commerce enabled photo management and ordering web application which can quickly generate a customizable web solution for a digital imaging client.• Developed web HTML and ASP pages that access Visual Basic COM objects for interaction with the database and file storage. Utilized JavaScript for user input/interaction. • Created SQL Server 2000 tables and T-SQL procedures for back-end database. • Designed and developed an administration ASP 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. • Tools: Visual Basic 6.0, COM, Visual Studio Environment, ASP, JavaScript, IIS, Microsoft SQL Server 2000, Windows 2000

Grand Falls - Windsor, Newfoundland

• Developed Visual Basic 6.0 Object Oriented DCOM components for the middle and end tier of a distributed equipment maintenance application in a Visual Studio development environment using Visual Source safe for revision control.• Designed and developed SQL Server 2000 and Oracle 6i back end database tables, views, PL/SQL stored procedures, packages, and triggers.• Tools: DCOM, Visual Basic, Visual Studio, SQL Server, Oracle 6i, PL/SQL, Visual SourceSafe, Microsoft SQL Server, Windows 2000

Bachelor'S Degree, Computer Science

Bachelor'S Degree (Year 1 To 3), Computer Science

Post Baccalaureate Program, Information Technology