Oracle Developer

Qualifications for the Oracle, PLSQL Developer

Working as an Oracle developer - I am doing Oracle development since 1987 (30 years). Gathered requirements, modeled the data (using Oracle Designer, Erwin, Toad and Oracle Sql Developer), created the databases (DDL), implemented, and developed applications on top of these databases to insert, modify or delete the data. I build data warehouses for Honeywell starting 1994 (engineering test data, financial data, repair tracking data, aeronautical data). I am familiar with all phases of a data warehouse, including the reporting and data mining and analysis.

Develop PL/SQL Programs – The PL/SQL as Oracle preferred language was released in 1989 and I am using this ever since (28 years). As the language increased it’s capabilities over the years I used it more and more for all sorts of jobs. I used it to develop stored procedures, packages and functions, table triggers, in Oracle Forms & Libraries and in Oracle Reports. I also used PL/SQL to extract data from Oracle databases and format data at user request (Excel, XML, text files).

Designing and Modeling databases – I worked as the data modeler for all the applications I developed at Honeywell. Worked on gathering requirements from the user community, conducted data modeling sessions involving users in defining the data they wanted to handle and defining the entity relationships. Converting their requirements in relational models (using Oracle Designer, Erwin, Toad or Oracle SQL Developer), converted them in physical models and build the database.

Co-ordinate with DBA in deploying new database software - I always had to work with the DBA in deploying the new versions of the database, the new stored packages, procedures, database triggers, etc..

I was exposed to UNIX as a developer

I have very good communication and interpersonal skills.

Best regards,

Serghei

SUMMARY

Dedicated professional with extensive and diversified experience in data modeling, database and application design and development using ORACLE RDBMS, Oracle Designer and Oracle Developer (Forms, Reports). Excellent teaching skills. Excellent communication and interpersonal skills. Tenacious, energetic, excellent team player. Experienced in project management (PMP certified).

EMPLOYMENT OVERVIEW

January 2016 – Present - contract with CNA Warranty Corporation – Scottsdale

Participating in upgrading the current system for car extended warranties by analyzing requirements for new projects, designing and developing new these projects as well as supporting the production system to eliminate software bugs and implement new requirements. Used Oracle PL/Sql to develop stored packages and procedures, develop Oracle Forms and Oracle Reports. Database version was 10g and upgrading to 11g. All work was done in teams, and no piece of software was delivered without having contribution for at least 2 team members.

The application was deployed through the WEB. Resolved a lot of production complaints by analyzing the current code and modifying it to comply with users’ requests.

May 2013 – December 2015 - contract with Arizona Department of Health Services

Converting old applications from MS Access and COBOL into Oracle. Performing data modeling, database design and database implementation. Developing Oracle database triggers and stored packages, procedures and functions.

November 2010 – April 2013 - contract with CNA Warranty Corporation –Scottsdale, Arizona

Participating in upgrading the current system for car extended warranties by analyzing requirements for new projects, designing and developing new these projects as well as supporting the production system to eliminate software bugs and implement new requirements. Used Oracle PL/Sql to develop stored packages and procedures, develop Oracle Forms and Oracle Reports. Database version was 10g and upgrading to 11g. All work was done in teams, and no piece of software was delivered without having contribution for at least 2 team members.

The application was deployed through the WEB.

February 1987 – December 2010 – full time employee at HONEYWELL AEROSPACE, Phoenix, AZ

Team leader for developing Oracle applications using Oracle database (up to 10g), Oracle Forms and Oracle reports. Performed in all phases of the project – collect requirements, data modeling, application design, application development, implementation and maintenance. Also, conducted Oracle training for the IT department. Developed documentation – requirements documents, technical specifications, design documents, training materials. Conducted user training for the developed applications.

Major project (in descending time order):

-Avionics Test Database for ORION Project (used XML to exchange data with customers)

-Airport Facility Data

-Airport Mapping Database

-Aeronautical Database and FMS (Flight Management System) Databases

-Reliability Data Collection & Reporting System

-Aftermarket (Repair & Overhaul) Data Warehouse

The work on these projects was done in teams (i.e. – The aeronautical database was developed using a 6 team members in Phoenix and up to 40 members in Bangalore India). We had daily meetings, all solutions were discussed and approved by the team and we have pair of developers working together on pieces of software. Over the years the methodology was improved and the name changed (CC, TQ, Six Sigma, DFSS) but always was insisting on clear goals, accountability to the team, team work, design validated by at least two people, code inspection, etc.

Most of the applications were deployed through the WEB.

August 1985 – January 1987 – Full time employee at Garret Engine Company (currently Honeywell) – Phoenix, AZ

Reliability Engineer: Performing various reliability analyses and failure forecasts on propulsion engines and auxiliary power units (APUs). Support reliability and maintainability department with all mainframe programming needs. Design and develop various databases (ORACLE based) and computer programs to manage reliability data. Establish new methods and write computer programs to perform field experience simulations.

1995 – 2010 Part Time Consulting with Capitol System Corporation – Phoenix, AZ

Participated in developing Oracle application (PL/Sql, Forms & Reports) for various companies in Phoenix, including work for AZ Department of Health, AZ Retirement System, AZ Attorney General. For Capitol Systems conducted training in data modeling, Oracle SQL and PL/Sql, Oracle Forms and Oracle Reports.

TECHNICAL RESEARCH & DESIGN INSTITUTE IN MINING INDUSTRY, Bucharest, Romania, Sr. Mathematician Analyst Programmer 1979 to 1984

Analyze complex problems in technical research and design for computerized solutions. Develop new mathematical algorithms, design, develop and implement computer systems. Interpret computer-simulated data for design. Supervise a team of engineers and technicians in gathering and preparing data for computer processing.

JUNIOR COLLEGE AND TECHNICAL SCHOOL, Timisoara, Romania,

Professor 1964 to 1979

Assistant director, organizing and supervising extra-curriculum activities for gifted students and after school activities, and performing various administrative duties. Manager of mathematics/physics department, coordinating a team of eight professors and establishing student curriculum. Professor, teaching Differential and Integral Calculus, Modern Algebra, Linear Programming, Matrix Algebra, Applied Mathematics, Introduction in Computer Sciences and Programming in FORTRAN.

EDUCATION

MS, Mathematics & Physics, University of Timisoara, Romania 1964

Postgraduate courses in Computer Sciences (major: Programming in FORTRAN) 1971

Partial completed a Ph.D. program in Mathematics (research and thesis completed) 1979

PMP - Project Management Professional

Passed PMI (Project Management Institute) examination 1996

Computer Sciences education and experience:

Database ORACLE (11g, 10g, 9i, v8, v7, v6 & v5) - Relational database design, database and application tuning

Tools Oracle Developer (Forms, Reports, Graphics, Procedure Builder)

SQL*PLUS, PL/SQL, Oracle Forms (3.0, 2.3 &2.0), Oracle Report Writer Performance tuning, Menus, 3GL connectivity (ProFortran)

Data Modeling Oracle Designer/2000 and ERwin

Operating Systems UNIX, Windows, Windows 95, MS-DOS, CDC NOS & NOS/VE, VAX VMS, IBM VM & MVS

Programming FORTRAN, PL1, COBOL, Basic, C, C++, Pascal, PROLOG, JAVA

Others Crystal Reports, SQR, Graphics (CALCOMP & DI3000), Dbase, Lotus123, WordPerfect, MS Access, FoxPro, MS Word, Excel, PowerPoint, MS Project, Primavera Project Planner and many other PC based applications.

OLAP COGNOS, Business Objects

Other training: Data Warehousing, Data Quality, Data Mining, Multidimensional Databases, Object Oriented Analysis and Design

TQ and TQL, Successful technical writing, AS Leadership Workshop

Six Sigma Green Belt and DFSS for Enabling IT certified

Personal

- Charter member of Data Warehousing Institute

- Member of Project Management Institute

- US Citizen since 1990; Married;

- Enjoy traveling, hiking and skiing.

References upon request

Contact this candidate