Schlagwörter
Skills
DATABASE DEVELOPMENT ENVIRONMENT SUMMARY:
Oracle RDBMS ver. 8, 9 AIX/Solaris/Windows NT OS;
E-Business Suite 11i (Oracle Applications): GL, AP, AR, PO, GMI, GML, GMF, APM, SYSADMIN;
PL/SQL, Oracle Reports, Discoverer, Oracle Forms, SQL Loader;
Oracle RDB, VMS OS;
Promix/Renaissance: GL, AP, AR, POP, IC, PP, MRP, SYS.
EDUCATION:
1986-1992
Full time studies at the Faculty of Mathematics, Computer Science and Mechanics, University of Warsaw in the field of Applied Mathematics. Master thesis on \"Computer methods for intraocular foreign body localization\"
PROFESSIONAL TRAINING (ORACLE POLAND):
“Oracle RDB Administration”
“Designing applications with Oracle Forms”
“Oracle Financials and General Ledger training”
OTHER SKILLS:
Languages: English (the best), French, German, Russian.
Driving licence.
PROFESSIONAL BACKGROUND:
2007 May-Dec Telecash Germany (Finance/Telecommunication) E-Business Suite 11i PL/SQL developer.
Custom lease and telecommunication transactions billing procedure in Order Management module, custom faxing solution for purchase orders, supplier\'s data import from flat files, PL/SQL installation scripts and data verification programs, program\'s performance optimalisation, SQL queries\' tuning.
2006 Nov-Dec Hochtief Germany E-Business Suite 11i Discoverer developer.
Reports in Service module enabling migration from SAP to Oracle EBS.
2003-2006 Frito Lay Poland; E-Business Suite 11i (Oracle Applications) system’s freelance developer.
Creation of majority of the system\'s user extensions. Data transfer from Promix database. Discoverer folders configuration. User defined reports in Report Builder and Discoverer. Interfaces with other database systems using PL/SQL API. Text file transfer procedures (see appendices). All user extensions documentation. Troubleshooting diagnostics.
2001-2003 Frito Lay Poland (potato chips producer); ERP system’s freelance developer.
Subject: Development and support of Promix – Renaissance submodules (Oracle RDB database).
Tasks: System’s analysis and modification in order to implement new functionality of MRP.
Interface allowing online export of static data and online import of inventory documents from an external warehouse control system. The interface created documents in IC, SOP and POP modules. The interface worked not interrupted for over one year. SQL procedures and triggers.
Oracle database structure and PL/SQL procedures for a budget control and planning application interfaced with Promix.
2000 Biznet Poland (software company) author of an application for management of an advertising agency and of a webform definition repository accessed by an internet browser (WebDb alike). The system built in Oracle 8/Solaris environment, consists of Java program run on a web server that used PL/SQL module and database definition repository for dynamically generated HTML application forms.
1999 Hortex (fruit and vegetable processing) system consultant. Support of implementation of the Oracle Financials (Sun Solaris operating system, Oracle RDBMS ver. 8 database server)
Subject: data migration from multiple legacy systems used in the company’s plants, Oracle systems’ testing.
Tasks: data transfer procedure, data cleansing and unification procedures (using PL/SQL and SQL Loader), testing of E-Business Suite (Oracle Applications) installation (Forms ver. 6).
1998 (Jul, Aug) Debitel Belgium/France (GSM telecommunication); Gembase consultant.
Subject: report building in Gembase for the Jupiter billing system and solving post-migration problems.
Tasks: several customers/cards/packages/calls/billing/data mining reports, horizontally expandable report library procedure; Gembase consulting.
1996-1998 Wedel/Pepsico (chocolate, biscuits, potato chips factories); senior project analyst and project manager.
Subject: support and development (the whole process: design, programming and implementation) in Gembase of \"Promix - Renaissance\" (ERP system by Ross Systems for VMS operating system and Oracle RDB database server).
Projects and implementations: Electronic Fund Transfer payments in the Accounts Payable module (a link to Citibank); dual reporting method meeting Polish and American law requirements, user defined reports in the General Ledger Module; new warehouse routines in the Purchase Order Processing Module; material requirement planning implementation and reports; data transfers between the database and text files; various reports and data conversion programs, application support/debugging.
1994-1996 MacroSoft Ltd (software house) Programmer/analyst. Standard Programs Dept..
Subject: database systems for small and middle size enterprises in Macrobase for DOS.
Projects: creation of several programs: e.g. for inventory and financial control, for evidence of bank\'s employees\' training; development of standard programs for company management; implementations of standard programs for individual orders.
Oracle RDBMS ver. 8, 9 AIX/Solaris/Windows NT OS;
E-Business Suite 11i (Oracle Applications): GL, AP, AR, PO, GMI, GML, GMF, APM, SYSADMIN;
PL/SQL, Oracle Reports, Discoverer, Oracle Forms, SQL Loader;
Oracle RDB, VMS OS;
Promix/Renaissance: GL, AP, AR, POP, IC, PP, MRP, SYS.
EDUCATION:
1986-1992
Full time studies at the Faculty of Mathematics, Computer Science and Mechanics, University of Warsaw in the field of Applied Mathematics. Master thesis on \"Computer methods for intraocular foreign body localization\"
PROFESSIONAL TRAINING (ORACLE POLAND):
“Oracle RDB Administration”
“Designing applications with Oracle Forms”
“Oracle Financials and General Ledger training”
OTHER SKILLS:
Languages: English (the best), French, German, Russian.
Driving licence.
PROFESSIONAL BACKGROUND:
2007 May-Dec Telecash Germany (Finance/Telecommunication) E-Business Suite 11i PL/SQL developer.
Custom lease and telecommunication transactions billing procedure in Order Management module, custom faxing solution for purchase orders, supplier\'s data import from flat files, PL/SQL installation scripts and data verification programs, program\'s performance optimalisation, SQL queries\' tuning.
2006 Nov-Dec Hochtief Germany E-Business Suite 11i Discoverer developer.
Reports in Service module enabling migration from SAP to Oracle EBS.
2003-2006 Frito Lay Poland; E-Business Suite 11i (Oracle Applications) system’s freelance developer.
Creation of majority of the system\'s user extensions. Data transfer from Promix database. Discoverer folders configuration. User defined reports in Report Builder and Discoverer. Interfaces with other database systems using PL/SQL API. Text file transfer procedures (see appendices). All user extensions documentation. Troubleshooting diagnostics.
2001-2003 Frito Lay Poland (potato chips producer); ERP system’s freelance developer.
Subject: Development and support of Promix – Renaissance submodules (Oracle RDB database).
Tasks: System’s analysis and modification in order to implement new functionality of MRP.
Interface allowing online export of static data and online import of inventory documents from an external warehouse control system. The interface created documents in IC, SOP and POP modules. The interface worked not interrupted for over one year. SQL procedures and triggers.
Oracle database structure and PL/SQL procedures for a budget control and planning application interfaced with Promix.
2000 Biznet Poland (software company) author of an application for management of an advertising agency and of a webform definition repository accessed by an internet browser (WebDb alike). The system built in Oracle 8/Solaris environment, consists of Java program run on a web server that used PL/SQL module and database definition repository for dynamically generated HTML application forms.
1999 Hortex (fruit and vegetable processing) system consultant. Support of implementation of the Oracle Financials (Sun Solaris operating system, Oracle RDBMS ver. 8 database server)
Subject: data migration from multiple legacy systems used in the company’s plants, Oracle systems’ testing.
Tasks: data transfer procedure, data cleansing and unification procedures (using PL/SQL and SQL Loader), testing of E-Business Suite (Oracle Applications) installation (Forms ver. 6).
1998 (Jul, Aug) Debitel Belgium/France (GSM telecommunication); Gembase consultant.
Subject: report building in Gembase for the Jupiter billing system and solving post-migration problems.
Tasks: several customers/cards/packages/calls/billing/data mining reports, horizontally expandable report library procedure; Gembase consulting.
1996-1998 Wedel/Pepsico (chocolate, biscuits, potato chips factories); senior project analyst and project manager.
Subject: support and development (the whole process: design, programming and implementation) in Gembase of \"Promix - Renaissance\" (ERP system by Ross Systems for VMS operating system and Oracle RDB database server).
Projects and implementations: Electronic Fund Transfer payments in the Accounts Payable module (a link to Citibank); dual reporting method meeting Polish and American law requirements, user defined reports in the General Ledger Module; new warehouse routines in the Purchase Order Processing Module; material requirement planning implementation and reports; data transfers between the database and text files; various reports and data conversion programs, application support/debugging.
1994-1996 MacroSoft Ltd (software house) Programmer/analyst. Standard Programs Dept..
Subject: database systems for small and middle size enterprises in Macrobase for DOS.
Projects: creation of several programs: e.g. for inventory and financial control, for evidence of bank\'s employees\' training; development of standard programs for company management; implementations of standard programs for individual orders.
Projekthistorie
Per email.
Reisebereitschaft
Verfügbar in den Ländern
Deutschland, Österreich und Schweiz
Verfuegbar ab März 2008.
