Company:
Advantage Software Factory - www.asf.ro
|
Septemer
2002 - present |
| Title: Oracle
DBA & Developer |
| |
|
|
Project participation
|
|
| Client:
BCR Romania - www.bcr.ro |
(Consultant for Oracle Romania) |
| Type of Application:
SIBCOR v.2 - Core Banking System |
| Operating Systems:
Windows 2000 |
|
| Programming
Languages: Oracle SQL & PL/SQL 8.1.7, Forms 6i, Reports
6i |
| Database: Oracle
9.0.2 |
|
| Software Tools:
Oracle 9i Designer, Oracle CDM, Oracle PJM, EZSQL |
| Network/Communications:
TCP/IP |
|
| Responsibilities
& Achievements: |
|
| |
» Technical review and validate the entity-relationship model created
by BCR team using Oracle9i Designer |
| |
» Support and solutions proposal for Oracle9i Designer to correct
possible errors in entity-relationship model and function hierarchy model |
| |
» Oracle9i Designer advices, best practices and guidance for end users |
| |
» Build Repository based reports to verify data design standards |
| |
|
|
| Client:
ASF - www.asf.ro |
|
Type of Application:
ASF Financials - Oracle Financials
Implementation(AP,AR,GL,CE,FA) |
| Operating Systems:
Red Hat Linux |
|
| Database: Oracle 8i Enterprise Server |
|
| ERP: Oracle
Applications 11.5.8 |
|
| Software Tools:
EZSQL, TOAD |
|
| Network/Communications:
TCP/IP |
|
| Responsibilities
& Achievements: |
|
| |
» Installed, configured and applied patches to Oracle Applications
11.5.8 |
| |
» Converted to MRC |
| |
» Implemented Backup strategy using Shell Scripts |
| |
» Maintained database integrity |
| |
» Performed database monitoring and tuning |
| |
|
|
| Client:
ING Romania - www.ingromania.ro |
|
| Type of Application: DBA Services |
| Operating Systems:
Windows 2000 Advanced Server |
Database: Oracle 9i Enterprise Server, Real Application Clusters,
Connection Manager |
| Software Tools:
EZSQL, TOAD |
|
| Network/Communications:
TCP/IP |
|
| Responsibilities
& Achievements: |
|
| |
» Review of current Oracle RAC installation |
| |
» Configure networking for RAC (load-balancing, failover) |
| |
» Configure Connection Manager (connection concentration, access
control, failover) |
| |
» Implementing Backup and Recovery strategy |
| |
» Tested Recovery Scenarious |
| |
|
|
| Client:
Mobifon S.A. - www.connex.ro |
September
2001 - Mars 2003 |
| Type of Application:
CONNEX Logistics - Oracle Applications Implementation(PO,INV,OM,IStore,Oracle Projects) |
| Operating Systems:
Windows NT, Sun Solaris |
|
| Programming
Languages: Oracle SQL & PL/SQL 8.1.7, Forms 6i, Reports
6i |
| Database: Oracle
8.1.7 EE |
|
| ERP: Oracle
Applications 11.5.7, 11.5.8 |
|
| Software Tools:
EZSQL, TOAD |
|
| Network/Communications:
TCP/IP |
|
| Responsibilities
& Achievements: |
|
| |
» Analysed, designed, developed and integrated custom and legal reports
to Oracle Applications |
| |
» Added custom functionalities according business rules to Oracle
Applications |
| |
» Implemented custom notifications for Istore Module |
| |
» Build custom functions (for Project Status Inquiry) and reports for
Oracle Projects Module |
| |
|
|
| Company:
Siveco Romania - www.siveco.ro |
June 2002
- August 2002 |
| Title: Senior
Oracle Developer |
|
| |
|
|
| Project participation |
|
| Client:
Aerostar Bacau - www.aerostar.ro |
June 2000
- August 2002 |
| Type
of Applications: Production planning&management |
| Operating Systems:
Windows NT |
| Programming
Languages: Oracle SQL & PL/SQL, Oracle Developer 6i, Oracle
Designer, Oracle Reports 6i |
| Database: Oracle
8i Server |
| Software Tools:
Ezsql, Toad |
| Network/Communications:
TCP/IP |
| Worked as a
member of 5 team in a project of production planning and management
for an aircraft company(client: Aerostar Bacau). Responsibilities: |
| |
» Data
Modeling |
| |
» Database
Design |
| |
» Used
Oracle Designer to generate forms |
| |
» Developed
stored procedures and triggers |
| |
» Reports
development |
| |
|
|
| Company:
Romanian Data Soft - www.rds.ro |
January
2000 - May 2001 |
| Title: Oracle
Developer |
|
| |
|
|
| Project participation |
|
| Client:
Sofrecom, Paris, France - www.sofrecom.fr |
June 2001
- January 2002 |
| Type
of Applications: GNetwork - Phone network devices
management |
| Operating Systems:
HP Unix, Windows NT |
| Programming
Languages: Oracle SQL & PL/SQL 8.1.7, Pro*C/C++, Forms 6i, Reports,
Import/Export, SQL*Loader |
| Database: Oracle
8.1.7 EE |
| Software Tools:
Ezsql, Toad |
| Network/Communications:
TCP/IP |
| GNetwork -
project focused on phone network management. Part of a very
complex application of clients and phone network management
(Girafe), the standard version was developed for France Telecom
and was customized to be used in other countries like South
Africa, Maroc, Indonesia; included 600 tables, 800 screens,
300 reports and managed over 20 millions records. The project
consisted in migration of the GNetwork module from Oracle 7,
Developer 2000, character mode to Oracle 8.1.7, Forms 6i, Report6i,
that involved the migration of all database objects (tables,
indexes, views, stored procedures, functions, packages), forms
and reports. |
| Responsibilities: |
| |
» Participated
in designing of the new schema using normalization technique,
created tables, enforcing integrity constraints, indexes, views |
| |
» Migrated
programs treatment: correction of compilation, display and functional
errors |
| |
» Developed
new forms, reports, stored procedures and packages |
| |
» Integrated
the new developed programs in the main application |
| |
» Responsible
for data migration(from ASCII files into buffer tables using
SQL*Loader-optimized the process to minimize the load time) |
| |
» Developed
Pro*C programs for loaded data treatment to ensure consistency
and validity |
| |
|
|
| Client:
Louvre Museum, Paris, France - www.louvre.fr |
April
2001 - May 2001 |
| Type
of Applications: Auditorium - Information and cultural
manifestations planning and management |
| Operating Systems:
RedHat Linux 6.2, Windows NT 4.0 |
| Programming
Languages: Oracle SQL & PL/SQL 7.3, Delphi 5 |
| Database: Oracle
7.3.4 EE |
| Software Tools:
EZSQL, TOAD VI, SourceSafe |
| Network/Communications:
TCP/IP |
| Worked as a
member of 3-strong team in a project of information and cultural
manifestations planning and management, focused on automatic
distribution of manifestations, user interface and generating
reports. |
| Responsibilities: |
| |
» Wrote
the business functions and the detail analysis. Implemented
database schema for module usage |
| |
» Implemented
database schema for module usage |
| |
» Wrote
PL/SQL stored procedure, triggers and packages to implement
application logic and entity relationships |
| |
» Debugged
PL/SQL procedures, tested the module, error handled, and integrated
the module in the system |
| |
» Handled
DBA jobs for the development database: |
| |
Installed and configured
software: server, tools, applications - monitored, tuned,
sized, backup, analyze, defrag
|
| |
Created
user profiles, enrolled/dropped users, granted privileges to
the database |
| |
|
|
| Client:
Louvre Museum, Paris, France - www.louvre.fr |
January
2001 - Mars 2001 |
| Type
of Applications: - Security staff payments planning and
management |
| Operating Systems:
RedHat Linux 6.2, Windows NT 4.0 |
| Programming
Languages: Oracle SQL & PL/SQL 7.3, Delphi 5 |
| Database: Oracle
7.3.4 EE |
| Software Tools:
EZSQL, TOAD VI, SourceSafe |
| Network/Communications:
TCP/IP |
| Worked as a
member of 3-strong team in complex project of security staff
payments planning and management, focused on database processing
engine and Delphi development. |
| Responsibilities: |
| |
» Designed
and implemented database schema on Oracle 7.3.4 server |
| |
» Designed
and developed application main engine (SQL and PL/SQL): automatic
calculation of payments for security members, various reports
by different criteria, automatic planning of future payments
for security staff relying on archived payments; the archived
data tables had between 5.000 and 2.000.000 records |
| |
» Created
application logic and business functions; wrote detail analysis
documentation |
| |
» Handled
DBA jobs for the development database: |
| |
User
management, Space management and Security management
|
| |
Creating
of Logical and Physical objects in the database |
| |
Designing
and implementing Backup and Recovery strategy |
| |
Fine
tuning the queries for optimum response time |
| |
|
|
| Company:
Tronic East Europe |
July 2000
- January 2001 |
| Title: Junior
Oracle Developer |
|
| |
|
|
| Type
of Applications: Customizing applications based on card access |
| Operating Systems:
Windows 2000 |
| Programming
Languages: Oracle SQL & PL/SQL 8, Developer 6i |
| Database: Oracle
8 EE |
| Software Tools:
Ezsql, Toad, AMC Designer |
| Network/Communications:
TCP/IP |
| Worked in a
strong 12 members team on projects focused on customising applications
based on card access |
| Responsibilities: |
| |
» Designed
and maintained the database |
| |
» Developed
stored procedures, packages and triggers |
| |
» Created
forms for data input, account transactions |
| |
» Developed
financial reports and graphics using Reports and Graphics 6i |
| |
|
|
| Company:
QSP - www.qsp-systems.com |
May -
July 2000 |
| Title: Junior
Developer |
|
| |
|
|
| Type
of Applications: Applications based on medical field |
| Operating Systems:
Windows NT 4.0 |
| Programming
Languages: Oracle SQL & PL/SQL, SQL Windows Centura |
| Database: Oracle
7 |
| Software Tools:
Ezsql, Toad, AMC Designer |
| Network/Communications:
TCP/IP |
| Worked as a
member of 10 team in projects focused on medical field, for
the management of doctors, patients, treatments, medical products,
suppliers and orders. Participated in analysis and development
of different versions for programs used in France hospitals |
| Responsibilities: |
| |
» Developed
user interfaces for data inserting, modifying, deleting and
consulting |
| |
» Created
stored procedures, packages and triggers to implement application
logic |
| |
» Designed
and developed a module for interactive construction of SQL queries
used for dynamic reports |
| |
|
|
