H Home  
 E Contact  
 p Print  

1 Previous Experience

Advanced Solutions (a DXC Technology Company) & PBC Solutions, Victoria, BC, Canada
Maximus BC Health, Victoria, BC, Canada
May 2023 - Jun 2025
Nov 2016 - May 2023
‹
Role: Senior Developer / Contractor
Client: Ministry of Health, Victoria, BC
Duties:
  • Application and database development for enterprise projects. Primary developer for LDAP access and authentication. Coordinated with Oracle Support on advanced database issues
  • Led enterprise BI reporting development. Defined BIP and APEX standards
  • On-call production support and incident resolution for a province-wide health system as the sole developer on rotation
  • Deployment Manager responsible for defining deployment plans, managing release windows and aligning cross-functional resources across the enterprise
Projects:
  • Engineered and maintained multi-language ETL pipelines and batch applications, automating cross-platform data integration, file transfers and scheduled data processing
  • Performed complex data mining and extraction, often involving highly nested queries (20+ levels), across operational and data warehouse environments
  • Validated full-stack application pipelines via developer-led end-to-end testing. Designed test data models and executed deep validation across API, security and boundary conditions to ensure front-end, middle-tier and database integrity
Tools: SQL, PL/SQL, BI Publisher, Oracle APEX, ORDS, Oracle OID, Shell, Python, Perl, Java, Oracle Data Integrator, PowerDesigner, Postman, SoapUI, cURL, JMeter, Git, BitBucket, StarTeam, Bamboo, Jenkins, OpenShift, Microsoft Copilot, Jira, ServiceNow
Maximus Canada - DeltaWare Division, Charlottetown, PEI (Remote), Canada
Jun 2022 - Oct 2022
‹
Role: Part-time OBIEE DBA / Contractor
Client: Nova Scotia Power, Halifax, NS (remote)
Duties:
  • The only OBIEE DBA on site
  • Responsible for the administration of BI components (ODI, DB, OBIEE)
  • Installation of Oracle PSU patches
  • Day to day DBA activities
Tools: SQL, Oracle Data Integrator, OBIEE, WebLogic, PuTTY, Confluence, MS Teams, Cisco VPN, ServiceNow, Confluence
Fujitsu Consulting, Victoria, BC, Canada
Jun 2014 - Nov 2016
‹
Role: Senior Developer / Conversion Specialist / Contractor
Client: Ministry of Education, Victoria, BC
  • Primary conversion and data remediation specialist for Aspen Student Information System, adopted by BC Ministry of Education (MyEducation BC)
  • In charge of converting data from all legacy systems to the new one for the whole province. Responsible for technical implementation and primary resource for running the conversion
  • Developed code in SQL and Java. Target environment: SQL Server and J2EE; legacy environments: MySQL, Oracle
Tools: SQL, Java, T-SQL, PL/SQL, SQL Server, MySQL, Oracle, MS SQL Server Management Studio, MySQL Workbench, SQL Developer, SQL*Plus, Eclipse, Notepad++, SVN, Cygwin
Fujitsu Consulting, Victoria, BC, Canada
Nov 2013 - Apr 2014
‹
Role: Senior Developer / Contractor
Client: Corporate Accounting Services, Ministry of Technology, Innovation and Citizens' Services, Victoria, BC
  • CAS EBS R12 Upgrade project
  • Primarily modified the existing Data Warehouse; also worked on Oracle E-Business Suite reports and performed upgrade-related tasks such as peer review or system testing
Tools: Oracle (11g), PL/SQL, Toad, SQL*Plus, Oracle Reports, Designer, SharePoint
Ragged Edge Community Network, Port McNeill, BC, Canada
2013
‹
Role: Technical Advisor / Contractor
  • Analyzed and documented the existing CRM application based on PHP, MySQL and Shell (ETL) with focus on future redesign
  • Limited customer support
Tools: PHP, MySQL, Shell (LAMP)
Freelancer / Self-employed, Victoria, BC, Canada; Torre del Mar, Spain
2003 - Present
‹
Role: Independent Contractor / Consultant / Sole Proprietor / Principal
Client: IT Freelancer, denisklein.com, Binary Milestone Technology Inc.
  • Designed and developed small business ETL and CRM applications based on Python, SQL, LibreOffice Base, PHP and JEE. Also used DeepSeek, Claude and ChatGPT for coding
  • Developed specialized data mining algorithms
  • Built personal and commercial websites with a capability to engage the visitors
  • IT Support for the general public. Handling various IT needs - reinstalling operational systems, configuring routers, firewalls, printers, installing commercial software, restoring data, introducing backup solutions and so on
Tools: Python, HTML, CSS, Javascript, jQuery, LibreOffice Base, PHP, Java/JEE (6), EJB, JPA, Hibernate, JSF, JSP, Servlets, MBeans, JTA, JMS, WSDL, JAX-WS, JAX-RS, Oracle, MySQL, SQL, PL/SQL, XML, JSON, GlassFish, Tomcat, Apache, Ant, Maven, Eclipse, NetBeans, SQL*Plus, cURL, VirtualBox, yEd, DeepSeek, Claude, ChatGPT
BC Registries and Online Services, official government register for corporations, names and personal properties, Victoria, Canada
2004 - 2010,
2011
‹
Role: Senior Developer / Contractor
Duties:
  • Sole database developer for the client, who is in the business of keeping database records
  • Customer support; data mining and data warehousing for the BSAs and the management
Projects:
  • Behind a number of projects and modules, ranging from technical (such as ETL data migration between incompatible data sources, or sending emails from a database) to client specific (such as dissolving corporations). Many projects (like those listed above) designed from scratch. Both Agile and Scrum methodologies have been used, depending on the project
  • Responsible for all reports, implemented on various platforms. Report generation and handling have to meet strict legal requirements. Responsible for overall design and implementation
  • Managed design and execution of batch processes and data synchronization in non-legacy DB
Tools: Oracle (9i - 11g), DB2, SQL, PL/SQL, SQL Developer, DBVisualizer, Toad, Java, XML, XSLT, JasperReports, Oracle Reports, Jreport, Fop/Xalan, SVN, CVS, PuTTY, VPN, Core FTP, SQL Loader, Windows Virtual PC, MS Visio, MS Windows, Linux, Shell
IBM Canada Inc., Victoria, BC, Canada
2003 - 2004
‹
Role: Application Developer / Contractor
Client: Ministry of Health, Victoria, BC
  • Joined a team of IBM consultants working for the Ministry of Health; used Agile methodology to develop a new online application for keeping track of patients with heart conditions
  • Responsible for all report and graph outputs based on Oracle products. Role included design, database logic (views, procedures), implementation and testing (full life cycle development)
Tools: Oracle 8i, SQL, PL/SQL, SQL*Plus, Toad, Oracle Reports, Oracle Graphics, PuTTY, MS Windows, Linux
ENextenso, Vancouver, BC, Canada
2002
‹
Role: Application Developer / Contractor
  • Designed and developed new, and enhanced existing business applications (including related tables, queries, forms and reports) built on a MS Access database
  • Designed ETL data export / import process between new and existing applications
Tools: MS Access, VB, SQL
La Rosa Studio, Vancouver, BC, Canada
2002
‹
Role: Technical Advisor / Contractor
  • Analyzed and designed a data migration process for a web portal serving a number of websites
Tools: Java, JSP, Servlets, HTML
TELUS Enterprise Solutions (formerly Daedalian eSolutions), Toronto, ON, Canada
2000 - 2001
‹
Role: Database and Web Developer / Consultant
Client: PC Ontario Fund, fundraising division of the Ontario PC Party
(governing political party in Ontario at that time), Toronto, ON
Duties:
  • Designed, programmed and implemented new applications built on Oracle database using Oracle Developer Suite, ASP and VB in CRM environment
  • Customer support for the client
Projects:
  • Order Entry project: Responsible for creation and development of an entire project. Designed and programmed forms, web screens and reports for all the aspects of entering, manipulating and processing orders (donations; a main source of income) within PC Ontario Fund
  • Cornerstone Club application (Cornerstone Club is an association of VIP members within the Ontario PC Party): Redesigned the existing application. Redefined the club membership rules due to the redesign. Modified the existing data into a new table design (ETL), generated new data from a secondary source. Created all administration related forms and reports
Tools: Oracle 8i, Oracle Forms, Oracle Reports, SQL, PL/SQL, Toad, SQL*Plus, SQL Loader, ASP, VBScript, HTML, Javascript, CSS, IIS 5, MS SourceSafe, VB, Visual InterDev 6, SQL Server, Crystal Reports
Computer Methods International Corporation, Toronto, ON, Canada
1997 - 1999
‹
Role: Application Developer / Consultant
Duties:
  • Developed financial software (GL, AP, AR, JC, FA, Payroll and others) using Oracle products (Forms, Reports, PL/SQL)
  • Customer support for clients in Canada, USA and Slovakia
Projects:
  • Developer 2000 Conversion: Led a team of on-site programmers converting all company business applications into new Oracle Developer 2000 suite
  • Slovak Telekom (Deutsche Telekom), a major telecommunication company in Slovakia: Worked 6 months on the client site in Slovakia. Responsible for all the outputs from implemented financial modules (GL, AP, AR, JC) - including reports and form queries. Provided customer support for implemented applications
  • Timesheet Subsystem: Designed and programmed an on-site application for evidence and export of employee timesheets from a company department of 50 employees abroad. Responsible for the design, implementation (ETL) and generation of all related outputs
  • Payroll Application: Responsible for the creation and maintenance of all reports, including related launch forms, views and stored database objects (triggers, procedures, functions)
Tools: Oracle (7 - 8i), SQL, PL/SQL, Oracle Forms, Oracle Reports, SQL*Plus, Designer 2000, JDeveloper, Toad, SQL Loader, PVCS, MS SourceSafe
OLÚ RCH Sanatorium, Nový Smokovec, Slovakia
1995 - 1997
‹
Role: Programmer / Analyst / Systems Support
Duties:
  • Designed and programmed custom applications using C/C++ and MS FoxPro
  • Data and software maintenance for designated sanatorium departments
  • Provided guidance and training to sanatorium staff in custom software (such as financial and administration applications as well as programs for operating specific medical devices)
Projects:
  • Medical Insurance: Designed and programmed a credit rating application for one medical department to enter and store all performed medical procedures. Generated industry-standard export files (ETL) and reports for medical insurance companies
  • Maintenance Department: Designed and programmed applications related to the maintenance of the sanatorium
  • Library: Coded an application for keeping track of all the books in the sanatorium library
Tools: Borland C++, FoxPro, DOS Batch
© 2026  Denis Klein
Site Map   |   Top