LORANT LIPCSEI

PERSONAL DETAILS

Passport : EU E-mail : lorant.lipcsei@gmail.comNationality : Hungarian Mobile : 078 3171 9114Post Code : London, WC2H 7ASLinkedIn : http://uk.linkedin.com/in/lorantlipcsei

EDUCATION & QUALIFICATIONS

2003 MSc in Technical Informatics BUTE, Budapest, Hungary

2015 SAS advanced analytics, data mining and reporting SuIT, Budapest, Hungary2006 Modelling with Rational Software Modeler T-Mobile, Budapest, Hungary

 PROFILE

A Software Developer with 10+ year’s commercial experience concentrating primarily with PL/SQL, T-SQL, C++, Visual Basic 6, VBA, database migration and performance tuning. Worked for large banking, finance and insurance as well as telecommunications companies, participated in several projects with team sizes between 5 and 150 members in parallel with day to day development. Possesses expertise across the full software development lifecycle from design to deployment management.

Easily identifies and implements opportunities for improvement and cost reducing development process automation. Adaptive and disciplined professional who aims to deliver quality solutions within strict deadlines.

Seeks contract work being immediately available for both interviews and starts for most locations within London, having recently arrived from Hungary.

 SKILL SUMMARY:Languages: C, C++, Visual Basic, VBA (Access, Excel, Word), Unix Shell Scripting,

Windows batch scripting, Perl, ProC, XML, Centura, Prolog, Pascal.

Databases: Oracle 7 - 12, Sybase 12 / 15, MS Access, KDB+

Database objects/Ref: PL/SQL, T-SQL.

Software/Desktop: Kondor Risk Management System 2.6 / 3.2, Microsoft Visual Studio 6 - 10, Centura Team Developer 2.1, Rational Software Modeler, Rational ClearQuest, Rational ClearCase, PL/SQL Developer, SQL Navigator, Toad, Microsoft Office, Tortoise SVN, MS SourceSafe.

Operating systems: Windows 7, XP, 2000, NT, 98, 95, HP UX, Solaris, Tru64 Unix.

Network Connectivity: ODBC.

Methodologies: Agile, Waterfall, Object Oriented Development.

REFERENCES AVAILABLE ON REQUEST; RECOMMENDATIONS AVAILABLE VIA LINKEDIN

Page 1 of 4

LORANT LIPCSEI

EMPLOYMENT HISTORY

Dec 2014 – April 2015 SuIT solutions Ltd., HungarySuIT Solutions Ltd. is a software development company providing complex IT solutions for financial institutions.

Oracle Database DeveloperEmployed to develop the OPUS business management system for Allianz Hungary. The system uses a lean client, where the full business logic and the services called by the user interface as well as the approx. 10000 data tables are stored in an Oracle database. The main part of the work was done on the business logic, data structure modification and writing test scripts.

Responsible for: Developed and maintained business processes and services in PL/SQL using PL/SQL Developer

and SQL Navigator Created test scripts for services in PL/SQL Performed build and database refresh automation using Unix shell scripting Interacted with business users throughout the development process to create technical

specifications based on business requirements Tortoise SVN was used for version control in the development, which ran according to the agile

methodology, with approximately 3 week long sprints Worked in a team of 20 members including Developers, Managers and OPUS end users

Achievements: Successfully delivered all assigned tasks in every sprint on time despite the frequent specification

changes and working against tight deadlines Identified several existing inconsistencies and errors in services, which will reduce the number of end

user issues in the future

Skills Snapshot:Oracle 11g / 12c, PL/SQL, PL/SQL Developer, SQL Navigator, Unix shell scripting, Microsoft Office, Tortoise SVN, Windows 7, HP UX.

Jun 2014 – Nov 2014 Synergon Information Systems, HungarySynergon Information Systems is one of Hungary’s biggest IT solutions providers and a supplier for the industrial, insurance, financial, telecommunications industries as well as the public sector.

Software DeveloperDeveloped a fully comprehensive software and hardware inventory management system for MVM Hungarian Electricity Ltd. The goal of the project was to build a system that can register thousands of IT devices the company was using and the connections between them in a hierarchical structure.

Responsible for: Developed, maintained and optimised stored procedures in PL/SQL using Oracle PL/SQL Developer

and TOAD, the source code was stored in MS SourceSafe Performed data migration from old MS Access databases to the new Oracle database through ODBC Designed the structure of the Oracle database using Rational Software Modeler Involved in GUI design and development in Visual Basic 6 using Microsoft Visual Studio 6 Developed reports using VBA for Excel Automated build using Unix shell scripting and Windows batch scripting Created the software specification based on end user requirements Worked in a team of 8 members including Designers, Developers and Testers

Achievements: Proposed and implemented a hierarchical registration structure which enabled component level

registration of the devices, making device acquisition more cost effective Introduced a build automation method which was used in later projects reducing the amount of manual

work and the frequency of errors

Page 2 of 4

LORANT LIPCSEISkills Snapshot:Oracle 11g, PL/SQL, PL/SQL Developer, Toad, MS Access, ODBC, Visual Basic, VBA for Excel, Unix shell scripting, Windows batch scripting, Microsoft Visual Studio 6, MS SourceSafe, Rational Software Modeler, Microsoft Office, Windows 7, XP, Solaris.

Nov 2012 – May 2014 CIB Bank, HungaryCIB Bank is a member of the Intesa Sanpaolo Group, and the fourth largest bank in Hungary according to its balance sheet total.

Software DeveloperWorked in CIB Treasury IT and performed a range of tasks related to Kondor Trade and Risk Management System. Involved in two projects with full responsibility for the design, development, deployment planning and deployment management of all the Sybase database related tasks.

The two projects worked on are as follows:1. Kondor upgrade from version 2.6 to 3.2The project was focused on the upgrade of the Kondor system from version 2.6 to version 3.2, which included the upgrade of the Sybase Adaptive Server Enterprise from version 12 / 32 bit to version 15 / 64 bit. Responsibilities: Actualised and maintained Kondor’s customised business procedures in T-SQL ensuring that they

worked the same way in the upgraded system Developed an extension for the database structure analysing software called KIA by Thomson

Reuters to analyse the custom window calls in KDB+ as well Report structure analysis for the data warehousing team using T-SQL and VBA for Excel Planned and managed deployment using Unix shell scripting, Windows batch scripting and Perl Worked in a team of 30 members including Architects, Developers, Managers, Treasury Traders

2. ESMA EMIR reportingThis was the EMIR (European Market Infrastructure Regulation) project for ESMA (European Securities and Markets Authority). The project goal was to create a complete report package covering every operation made on deals in Kondor. Responsibilities: Developed a dynamic report handling environment in T-SQL and VBA for Excel (memory array

emulation, dynamic report table, view and index table creation automatically from the received XLS specification), which helped using an agile development methodology

Created the specified reports (some of them approx. 150 columns wide) based on ESMA – CIB business logic translation

Planned and managed deployment using Unix shell scripting and Windows batch scripting Worked in a team of 12 members including Developers, Managers and Treasury Traders

Achievements: Successfully delivered all assigned tasks on time achieving all goals and exceeding expectations

despite the frequent specification changes and working against tight, fixed deadlines Developed an extension for KIA that makes its database structure analysing ability complete, greatly

reducing the amount of additional support required for KIA Automated the major part of report creation making it faster and more reliable

Skills Snapshot: Sybase 12 / 15, T-SQL, VBA for Excel, KDB+, Kondor Risk Management System 2.6 / 3.2, Unix shell scripting, Perl, Windows batch scripting, Windows 7, XP, Solaris, Microsoft Office.

Mar 2000 – Sep 2012 T-Mobile, HungaryT-Mobile Hungary is the market leader mobile communications company in Hungary serving approximately 4 million customers.

Software DeveloperEmployed as a full stack developer to participate in all phases of development. Performed day to day development of the company’s own developed business management system and participated in several large projects in parallel.

Example projects worked on are as follows:

Page 3 of 4

LORANT LIPCSEI1. Day to Day Jazz DevelopmentPerformed several development tasks in all main modules of Jazz: customer management ( CRM ), sales subsystem (billing, invoices), general ledger, stock and inventory management, collection subsystem, services and tariffs, user and security management and the Webshop portal. Responsibilities: Developed and maintained business processes, reports and standalone jobs in PL/SQL Performance tuning on PL/SQL and ProC database jobs, reports and SQL queries Involved in database modelling using Rational Software Modeler Designed and developed the user interface in Visual Basic 6 and Centura Team Builder 2.1 Developed services on the application server layer in C / C++ using Visual Studio 6-10 Developed on Windows and Unix in parallel, using Unix shell scripting, Perl and Windows batch

scripting regularly Interacted with business users throughout the development process in order to create technical

specifications based on business requirements Used Rational ClearQuest for task registration, Rational ClearCase for version control, PL/SQL

Developer, SQL Navigator and TOAD for database related development Worked in a team of 60 members including Architects, Developers, Managers, Testers, Jazz end

users

2. SOA projectReorganisation of the Jazz application server and database functions into standardised services, in order to eliminate business logic redundancy in Jazz and in the external systems connected to it (Clarify, Siebel, SAP). Responsibilities: Developed customer management, invoicing and inventory handling related services in C++ Developed the user interface in Visual Basic 6 and Centura Team Builder 2.1 Worked in a team of 35 members including architects, developers, managers and Jazz end users

3. Telematrix projectTelematrix is a customised corporate fleet management portal for major business customers. It offers for example mobile fleet parameters customisation, virtual groups to enable group members to call each other at preferential rates. Responsibilities: Created the design of the customer database migration of Telematrix, based on several, differently

structured customer databases Complete development of the customer database migration of Telematrix in PL/SQL Worked in a team of 30 members including Designers, Developers, and Managers

4. Customer Debt CalculationCustomer debt calculation is an important daily database job on which many sales, billing and general ledger related business processes and database jobs were based on. Responsibilities: Re-structured the job by splitting it into two parts: one daily and one weekly job Performance optimisation of the included SQL queries and the PL/SQL logic Configured the job scheduling and the job dependency check system using Unix shell scripting Worked on the complete SDLC (design, development, testing) on individual basis

Achievements: Increased the performance of customer debt calculation by 300%, ensuring its daily on schedule finish

and reducing the load on Oracle database in a critical time range of the day Developed an automatic database synchronising module between Jazz and the Webshop, which

reduced the workload on Webshop administrators and made the synchronisation more reliable, thus greatly decreasing the amount of related customer complaints

Developed the biggest business object (invoice handling) for 1.5 years exclusively, created fully customisable standard invoice handling services, which reduced the invoice handling related development time for all the upcoming projects

Skills Snapshot: Oracle 7 - 11, PL/SQL, C, C++, Visual Basic, VBA ( Access, Excel, Word ), Unix shell scripting, Perl, Windows batch scripting, ProC, XML, Centura, PL/SQL Developer, SQL Navigator, Toad, Microsoft Visual Studio 6 - 10, Centura Team Developer 2.1, Rational Software Modeler, Rational ClearQuest, Rational ClearCase, MS Office, Windows 7, XP, 2000, NT, 98, 95, HP UX, Tru64 Unix.

Page 4 of 4