TIBERIU LACZKO

***-**** ******* ****

Ottawa ON K1J 8K4 Canada

Home: +1-613-***-****

Cell: +1-613-***-****

e-mail: abqaal@r.postjobfree.com

OBJECTIVE

To secure a position as Software Developer

SUMMARYA creative thinker with excellent analytical skills, strong work ethics and over 18 years of experience as a Software Consultant in the government, financial, wealth management, insurance, health care, pension administration and retail sectors. 12 years of experience with SQL: Oracle SQL, PL/SQL, packages, stored procedures, triggers, views, Transact – SQL, T-SQL, Sybase SQLOver 14 years of experience implementing IT systems, translating business requirements into systems design and specifications, developing technical specifications for systems development, design and implementation of software7 years of experience programming in Powerbuilder (GUI programming, database and embedded SQL programming, datawindow programming, Powerscript programming,

Powerbuilder Foundation Class libraries)4 years of experience using Java, J2EE, HTML, XML, Application ServersSun Certified Programmer for the Java 2 Platform – Toronto / Canada, 20024 years experience using the C languageExposure to all aspects of software development lifecycle (SDLC)

TECHNICAL EXPERIENCE

Languages: ORACLE SQL and PL/SQL, ‘Powerscript’ (Powerbuilder with Powersoft Foundation Classes), JAVA, J2EE, RMI, Swing, C, C++, XML, UML, HTML, ‘Transact SQL’ (including stored procedures), T-SQL, Unix Korn Shell, ‘PC Assembler’ and ‘Pascal’

Construction Tools: Powerbuilder (6.5 - 12.5), Sun JAVA Compiler, Forte, Microsoft Visual ‘C’ and ‘C++’ Compiler, MS Visual Basic, Tandem TNS C compiler, Microsoft Macro Assembler, Borland Turbo Assembler and Turbo Pascal, Watcom ‘C’ and ‘C++’ Compiler, Norton Utilities, Nu-Mega Debugging Tools

Application Servers: BEA Weblogic, SUN Application Server

Middleware: MQ Series, IBM WebSphere MQ

Database Products: ORACLE 7.3, 8i, 9i, 10g, 11i, SQL Navigator, TOAD, PL/SQL Developer, DB Visualizer, Microsoft SQL Server 7, 8, 2000 and 2008, Sybase RDBMS, ERWin

Computers: IBM PC and compatible, SUN Sparc, Tandem Non-Stop

Operating systems: Windows 7, NT, 2000, 95, 98, UNIX, SUN OS, Solaris, Linux, Tandem TNS Guardian, Novell Netware, DOS

Office Products: MS Word, Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Dissertation Project for MSc. in Comp. Science Degree Sept 2010 – July 2012Tiberiu has developed, in his spare time, a client-server application using Sybase Powerbuilder, PFC and Oracle 10g. This is a functional prototype of a 2-tier client-server application used in the Health Care Industry, to keep track of patient’s medical records, including medical tests and procedures. It also allows storage of images, documents and video recordings, pertaining to a patient’s medical history, in an Oracle database, for later retrieval.

Technical environment: Sybase Powerbuilder 12.5, PFC, Oracle database 10g, Oracle SQL and PL/SQL, Oracle SQL Developer, Oracle triggers.

Studies May 2012 – July 2012Preparations for the final exams and dissertation towards Master of Science in Computer Science (started MSc. in Computer Science studies in Sept. 2010, and completed studies in July 2012)

IBM / Department of National Defence, Ottawa Jan 2012 – April 2012

Oracle / Java Consultant with IBMDeveloped stored procedures, triggers, views, packages, scripts in Oracle PL/SQL and SQLParticipated in database modeling for storage of XML schemas and XML elements, into an Oracle databaseImplemented data model into actual database objectsDeveloped diagrams, analyzed problemsHelped to determine which software product to use for T4 / T4A / RL 1 tax slip reprint functionality, and incorporated software into the solution to generate PDF documents, from database content stored in XML format

Technical environment: XML, Oracle SQL and PL/SQL, Oracle, Toad, PL/PDF, PDF

Self-Employed April 2011 – Jan 2012

IBM / Elections Canada, Ottawa June 2007 – March 2011

Consultant with IBMPerformed code development and maintenance for Oracle PL/SQL packages, stored procedures and functions.Performed code development, maintenance and support for several existing Powerbuilder applications, which use the Powerbuilder Foundation Class libraries, and are connected to various Oracle and Sybase RDBMS database systems.The client-server applications belonged to two main business groups: Address Management, and Register of Electors

Technical environment: Oracle SQL and PL/SQL, SQL Loader, Oracle 10g, Toad, Powerbuilder 10.2

AVALOQ Evolution AG, Zurich May 2006 – February 2007

PL/SQL DeveloperVarious tasks such as creating database users, schemas, access rights, rolesMigration of PL/SQL code, database objects (tables, views, triggers, schemas, packages, sequences etc), and table data, between various databases, using SQL / SQL*Plus, SQL Loader, and PL/SQL scripts.Extended functionality of the PL/SQL administration interface to an Oracle software configuration and management system, and created new reports using SQL, PL/SQL and SQL*Plus.

Technical environment: Oracle SQL and PL/SQL, SQL Loader, Oracle 10g, SQL Plus, Toad

Hospitals of Ontario Pension Plan, Toronto May 2005 – April 2006

Systems Analyst / Developer (full-time)Responsible for supporting the Oracle Financials 11i e-Business Suite (modules Accounts Payable, General Ledger, Cash Management). Responsible for modifying Oracle Reports for internal departments within the Company. Responsible for various DBA-tasks on Oracle and SQL Server 2000 high-availability databases, including data modeling, database design, backup/restore, security implementation, deployment, performance optimization, etc.Gathered user requirements by participating in JAD workshops and face-to-face meetings with end-users. Converted user requirements into written documentation and technical specifications.Implemented technical specifications into logical and physical data models, and implemented business rules into database stored procedures, triggers and constraints.Responsible for data analysis, data modeling (relational and dimensional) and coding of stored procedures and triggers in T-SQL on MS SQL Server RDBMS. Performed data modeling of dimensions which were used for joining against the fact table in a data warehouseDeveloped and optimized Stored Procedures in T-SQL for ETL / data conversion and transformation, from Cognos cubes and SQL Server RDBMS sources, into a data warehouse.

These Stored Procedures were used to generate and populate the fact table in the data warehouse.Responsible for maintaining several software applications.

Technical environment: Oracle SQL and PL/SQL, SQL Loader, Oracle Financials 11i, TOAD, SQL Navigator, PL/SQL Developer, Oracle Reports 6i, Transact SQL, MS SQL Server 2000, Oracle 9i, DB Visualizer, .NET

Munich Re-Insurance / M nchener R ckversicherung, Toronto July 2004 – Jan. 2005

Independent IT Consultant (contract)developed functionality in Oracle SQL and PL/SQL, for converting data from various clients’ formats, into company’s own internal format, for further processing of insurance transactions. The converted data was stored in an Oracle 9i Database.developed functionality for electronic processing of various insurance policy transactions, as per customer’s specifications.

Technical environment: SQL, PL/SQL with ORACLE 9i, PL/SQL Developer, SQL*Plus, SQL Loader

EDS Canada - Toronto Nov. 1998 – March 2004

Information Analyst / Senior Systems Analyst / Consultant (full-time)Worked on various projects for different clients, as a full-time consultant with EDS. Details below:

National Bank of Canada – Trading of Government Bonds July 2003-March 2004Tested user interface, business rules, validations, business transactions, posting of general ledger entries, system integration.Tested an application used for trading of Treasury Bills ( T-Bills, or Federal Government Bonds), and for keeping the book of records of those transactions. Tested the user interface, business rules, validations, business transactions, posting of general ledger entries in the ORACLE Database, and system integration of that application (black box and white box approach). Test cases and use cases were defined and modelled using UMLVerified accuracy of amounts, accrued interest, G/L entries for a variety of transactions

Technical environment: Java, UML, MVC, UNIX / Java batch processes, SQL, PL/SQL with ORACLE 8i, DB Visualizer, TOAD, SQL*Plus, Korn Shell Scripts, SUN Solaris, Rational Rose.

Ontario Government February 2003-July 2003Successfully implemented a data migration process in JAVA, from an ORACLE 8i Relational Database, into a PeopleSoft Application Server Environment, by analyzing data structures, developing and testing functionality and solving complex technical issues, which resulted in collection by EDS Canada of an outstanding payable of $170,000, from the client.

Technical environment: JAVA SDK, RMI, PeopleSoft JAVA Component Interface, JDBC, SQL, PL/SQL with ORACLE 8i, PL/SQL Developer, SQL*Plus, DB Visualizer.

Canadian Imperial Bank of Commerce - Internet Trading Applications June 2001-Feb 2003Developed, tested and delivered business transactions utilizing Java, J2EE, MVC, XML, SQL, as part of a web-based online securities trading application for CIBC. This enabled electronic processing of securities trading, for personal banking, securely over the Internet. The JAVA framework used to develop the application was conceptually similar to STRUTS.Java classes, test cases and use cases were defined and modelled using UML. Java objects were mapped to relational database entities.Java objects and transaction data were stored into a high-availability Oracle relational database.Developed a batch process utilising ORACLE SQL, PL/SQL and JAVA languages to generate a data mining report for management use.

Technical environment: JAVA SDK, J2EE, STRUTS, MVC, MQ Series, RMI, JDBC, BEA Weblogic, XML, UML, SQL, PL/SQL with ORACLE 8i, PL/SQL Developer, SQL*Plus, DB Visualizer, Rational Rose

Government of Ontario January 2001-June 2001Enhanced, as per customer’s requirements, a 911 Ambulance Call Taking and Dispatch System,

a data communications package running on a Tandem mainframe, a PC-based gateway application to route 911 calls, and another PC - based client application to process 911 incoming callsParticipated in JAD sessions with subject-matter-experts and end-users, in order to capture business requirements and to perform data analysis and data mapping.

Technical environment: C language, Tandem TNS Guardian and DOS operating systems, Tandem TNS C Compiler, Microsoft C Compiler, PC and Tandem Hardware, X.25 protocol

Government of Ontario January 2001-January 2001Enhanced a client-server application used in the mining industry, by writing complex SQL and PL/SQL queries and stored procedures, used to generate reports from an ORACLE database

Technical environment: SQL, PL/SQL with ORACLE 7.3, PL/SQL Developer, SQL*Plus, SQL Navigator

Canadian Imperial Bank of Commerce September 2000-January 2001Wrote various stored procedures using complex queries in Oracle SQL and PL/SQL on an ORACLE 8i database.enhanced a Powerbuilder / Sybase client-server application used in the financial industry.

Technical environment: Powerbuilder, Sybase, SQL, PL/SQL with ORACLE 8i, PL/SQL Developer, SQL*Plus, SQL Navigator, Windows NT, Unix

Government of Ontario April 2000-September 2000maintained and enhanced various applications (data communications, 911 call gateway and client) written in the ‘C‘ programming language and running on different platforms and operating systems

Technical environment: C language, Tandem TNS Guardian and DOS operating systems, Tandem TNS C Compiler, Microsoft C Compiler, PC and Tandem Hardware

Ontario Municipal Employees Retirement System – OMERS November 1998-April 2000developed, tested and delivered, as part of a large team, business transactions in Powerbuilder and SQL, for the 3rd largest pension plan administrator in Canada.The new Powerbuilder client-server application enabled electronic processing of pension membership transactions, with increased speed, efficiency and reliability, versus the previous manual-processing mode

Technical environment: Powerbuilder 6.5, SQL, PL/SQL with ORACLE 7.3, SQL*Plus, SQL Navigator, Windows 95, Unix

Premis Systems Canada - Toronto June 1995 – Sept. 1998

Programmer – Analyst (full-time)

VARIOUS CLIENT-SERVER APPLICATIONS (several projects)Developed client-server applications for the retail industry, including Point of Sale (POS), Backoffice and Server modules, on various platforms (C, Powerbuilder, SQL).Designed, developed and tested the security profile and rules module of a Backoffice Application written in Powerbuilder, which allowed selective access to functionality, based on the user’s pre-defined security permissions, consistent with the user’s position in the organization’s hierarchy.Wrote various reports using Powerbuilder and Sybase SQL.Developed functionality to implement various business transactions performed in the retail industry, for POS, Backoffice and Server applications.

Technical environment: Windows NT, OS/2 and DOS operating systems, Powerbuilder 5.0, Sybase SQL Anywhere 5.5, MS SQL Server 6.5, Microsoft ‘C’, Vermont Views, B-TRIEVE

Ikarus Software – Vienna, Austria Sept. 1992 to Jan. 1995

Computer Programmer (full-time)

ANTI-VIRUS UTILITIES AND DATA SECURITY SYSTEMSmaintained and improved anti-virus software under DOS, Windows and Novell Netware platforms. effectively managed all aspects of software development. designed and developed a new data security software system for PC’s, using password access to data and encryption algorithms

Technical environment: DOS / Windows / Novell Netware Operating Systems, Microsoft Visual C / C++ compiler, Microsoft Macro Assembler, Borland Pascal Compiler.

EDUCATION & CERTIFICATIONSMaster of Science in Computer Science, Tibiscus University, Faculty of Applied Computer Science, Timisoara, Romania (Sept 2010 to July 2012)Bachelor of Computer Science, Tibiscus University, Faculty of Applied Computer Science, Timisoara, RomaniaInternational Business, Forum for International Trade Training, CanadaSun Certified Programmer for the Java 2 Platform, Toronto, Canada

Technical University, Faculty of Computers and Automation, Timisoara, RomaniaCertificate of Qualification as a Computer Programmer and Secondary Analyst

High School, Romania

PROFESSIONAL DEVELOPMENT

Courses: MS SQL Server Reporting Services, Oracle Financials 11i Functional Foundation, Report Building with Cognos Impromptu Series 7.3, Epicentric/Vignette and BEA Web Portal development, HTML, BEA WebLogic Server, Unix and Unix shell scripting, Application Servers (BEA WebLogic), XML, Java, Data Analysis for RDBMS, Data Modelling for RDBMS, Object-Oriented Analysis and Design, Object-Oriented Programming and Design, Oracle SQL tuning, Oracle SQL and PL/SQL, Powerbuilder

LANGUAGES English, Romanian, French and German

Contact this candidate