Senior Oracle Developer

Sidney Voltaire F. Esteban

Email: add7d2@r.postjobfree.com

Cell: 848-***-****

Summary:

Currently working as a Senior Oracle Consultant for Con Edison in New York, NY and previously worked as a Senior Oracle Developer and EDI Specialist/Developer for a software company also in New York, NY that develops software applications for the apparel and retail industries.

25+ years’ experience in Oracle. This includes working as an Oracle Developer, Developer/Production DBA, Database Modeler, EDI Developer and Business Unit Head/Project Manager.

Experienced in the business of retail, apparel, insurance, education, human resource, manufacturing, automotive services, inventory and accounting to name a few.

Expertise includes designing and re-designing custom applications with vast experience in Oracle PL/SQL (more than 25 years), Oracle Application Development tools (i.e. Oracle Developer Forms, Oracle Developer Reports, Oracle Developer Procedure Builder, SQL*Loader, etc), Oracle databases, and other Oracle tools for different versions; and good experience and understanding of EDI in the retail, apparel and sales environment.

Working experience in full development life cycle, project management, database designer (logical and physical), and systems analyst with high level of expertise in designing/re-designing, developing and maintaining a vast number of systems in different type of businesses.

Good knowledge and experience in creating conceptual modeling, logical modeling, dimensional modeling and data mapping using Sybase Power Designer (S-Designor).

More than 10 years’ experience as an Oracle database Administrator (DBA). Knowledge and experience in writing UNIX scripts with working experience in installing and upgrading of Oracle database; and using Mercator (EDI tool).

Technical Skills:

Operating System: Windows NT/2000/98/95, HP Unix, Sun Solaris

Database: Oracle Database Enterprise 11g and below, MS Access

Oracle Tools: SQL*Plus, PL/SQL, Oracle Developer 2000, Oracle Developer Forms 11g and below, Oracle Developer Reports 11g and below, Oracle Enterprise Manager (OEM), Oracle SQL*Loader

Case Tools (Data Modeling): Powerdesigner Data Architecture, S-Designor, Oracle Designer

Other Tools: Mercator (EDI), TOAD, Crystal Reports, Coldfusion, Constellar Hub, PVCS Version Manager, Action Request System (Remedy User), Niku Time, Groupwise 5, Shell scripts

Client/Server Applications Developed: A2000 Apparel/Retail System, Retail Application Management System (RAMS), AAA Paystation System, AAA Inquiry and Recommendation System, Integrated Insurance Brokerage System v1.0, Integrated School System v1.0, Alesayi Information System, Internal Revenue Administrative System

Web Applications Developed: AAA Driving Improvement Program, AAA Travel Brochure System

Applications Supported: A2000 Apparel/Retail System, Auto Club System (ACS), Oracle Peoplesoft, GERS Retail System, Music Merchandise System (MMS), Marketing, PCS

Other Applications: TBS Metasolv, Clarify, Infovista / Vista Mart

Professional Experience:

Con Edison, New York, NY Jan 2012 – Present

Senior Oracle Consultant

The primary/senior Oracle person in the group, I am responsible for designing, coding and maintaining in-house developed Oracle applications.

Responsible for guiding and supervising Oracle developers and designers in our group and give technical advise to other groups within the company.

As an Oracle consultant currently responsible for maintaining and enhancing 'LOT' (Layout Tracking System) which is an in-house software developed in Oracle forms and reports and utilizing PL/SQL running on an Oracle database.

Responsible for creating interfaces between 'LOT' and Work Management software created by CGI.

Design, coded and maintaining the ‘Special Project Group’ and ‘Gas Work Tracker’ applications.

Responsible in upgrading and enhancing the performance of all Oracle database and applications.

I am also requested by my vendor to interview and evaluate Oracle technical professionals that they would send to their clients.

GCS Computers, New York, NY Jan 2007 – Dec 2011

Senior Oracle Developer & EDI Specialist/Developer

As a senior Oracle developer, responsible for maintaining, supporting and enhancing ‘A2000’. ‘A2000’ is client server and web base software for the apparel and retail industries. The software is originally coded using Developer 2000 and Oracle Forms and Reports 6i and PL/SQL.

Enhanced the performance of PL/SQL codes used in forms and reports. With over 100 clients, it is the major software that the company sells.

As a senior EDI specialist/developer, responsible for maintaining and enhancing all EDI related functionality within A2000. Re-designing and performance tuning of the Oracle database are some of my main responsibilities within the company.

Evaluated APEX (Oracle Application Express) as a tool to convert 'A2000' from Oracle forms.

Liz Claiborne, USA Mar 2005 – Jan 2007

Senior Oracle Developer (IS Retail Group)

As a member of the IS Retail Group, main responsibility was to support and enhance the ‘Retail Application Management System’ (RAMS).

Key member in converting RAMS from a client server application to a web base application using Oracle Forms and Reports 6i and 10g.

Enhanced RAMS to handle multi-currency for our Europe branches.

Re-designed and performance tuning of the Oracle database are some of my main responsibilities within the company.

Systemax (Global Company), USA Mar 2003 – Mar 2005

Oracle Programmer

Developed codes in receiving and transmitting EDI (Electronic Data Interchange) data from and to customers or vendors.

Functioned as Oracle DBA/Programmer and EDI Coordinator/Developer.

Used Mercator version 6.5 for EDI.

Monitored day to day EDI processes.

Evaluated and tune existing EDI processes.

Created new EDI programs as the need arises.

Maintained several Oracle databases version 8.1.7.3.0 in Sun Solaris environment.

As an Oracle DBA/Programmer, altered database objects (tables, views, indexes, constraints, etc.) upon request or as the need arise.

Created database procedure, functions and packages.

Evaluated and fine-tuned existing SQL/PLSQL codes.

Created interfaces between Profit Center Software (PCS) and our client’s Legacy system using Mercator and PL/SQL. This includes designing and creating the DML scripts for the staging process. Maintaining oracle base applications using Oracle Developer Tools (SQL*Plus, SQL*Loader, PL/SQL, Oracle Developer Forms 4.5/6i, Oracle Developer Reports 2.5/6i, Oracle Developer Procedure Builder, etc.).

Geneva Consulting Group, Inc., The WIZ, NJ Jun 2002 – Aug 2002

Oracle Consultant

Created and updated custom reports using SQL*Plus, PL/SQL and UNIX shell scripts for GERS Retail System in UNIX environment.

Functions include creating business requirements document to be approved by the business user prior to coding; coding the report and perform unit / stress testing; creating technical specifications document for production; creating PRB (Production Review Board) document for approval; creating User document; and creating Help Desk documents.

Aside from supporting GERS, supported their Music Merchandise System (MMS). Created report using Crystal Reports.

Quest Consulting, Radianz, NJ Apr 2002 – May 2002

Oracle QA Consultant

Headed the QA team in testing the ODS (Operational Data Source) System, which is an integration of their TBS Metasolv, Clarify and Infovista / Vista Mart into one Oracle system. ODS system resides on a Solaris OS and Oracle version 8.1.7. They have developed web applications as part of the ODS system.

My responsibilities included developing a test plan; defining the test cases for the test plan; test schedule; and unit/stress testing on the database and the applications. I also have to make sure that all coding was using the company’s coding standard.

Finalized all the documentation such as QA test results, User’s Manual, and Installation Manual.

Created PL/SQL scripts to generate and load test data.

RCG Information Technology (RCG IT), USA Jul 1998 – Jan 2002

AAA Auto Club of New York, NY Aug 1999 – Jan 2002

Oracle Consultant

Installed Oracle 8/8i on Windows NT/2000 / HP UNIX and wrote shell scripts for database backup.

Designed the logical and physical database model (database design) for client/server applications namely Paystation System, Inquiry and Recommendation System; and web applications namely Driving Improvement Program and Travel Brochures System respectively using Powerdesigner Data Architecture.

Involved in the full development cycle of all the applications.

Developed the back-end components and created oracle packages, procedures, functions, and triggers for the above-mentioned client/server and web applications using PL/SQL.

The client/server applications were developed using Oracle Developer Tools (SQL*Plus, SQL*Loader, PL/SQL, Oracle Developer Forms 4.5/6i, Oracle Developer Reports 2.5/6i, Oracle Developer Procedure Builder, etc.) and the web applications were developed using Coldfusion, PL/SQL and Crystal Report.

Driving Improvement Program was re-designed and converted from an MS Access version.

Aside from developing the above-mentioned applications, I also maintained them.

Defined the data source definitions on their Coldfusion servers, documented all the applications and defined the Oracle standards for their MIS department.

Analyzed and evaluated the companies Auto Club System (ACS) to create smaller Oracle and web applications linked to ACS.

Functioned both as developer and production DBA for all their Oracle applications. Working knowledge in Toad, Coldfusion and Crystal Reports.

Pennsylvania Medical Center, PA Mar 1999 – Mar 1999

Oracle Database Administrator / Developer

Analyzed the relational schema of their EMTRAC System and re-designed the system. The system was installed in Oracle 8 under Windows NT.

Developed the back-end components and created oracle packages, procedures, functions, and triggers for the system using SQL*Plus and PL/SQL.

Created the tablespaces, users, and system’s objects (tables, views, and constraints).

Keyspan Energy, NY Jul 1998 – Nov 1998

Oracle Database Administrator

Monitored and maintained the Oracle databases ver 7.3 under HP UNIX.

Developed reports using PL/SQL. Part of the team that formulated the company’s Oracle standards.

Asian Business Solutions Inc. (ABSI), Philippines Jul 1997 – Jul 1998

Business Unit Head / Project Manager

Responsible for the quality and timely completion of specific assigned projects.

Responsible for project management, systems analysis and design database administration, systems administration, and 4GL programming of specific assigned projects.

Responsible for the business performance of specific assigned projects.

Responsible for supervising a group of systems analyst/programmers.

Designated as the database technical support and DBA for ABSI technical staff and assist in the business development activities of the company.

Responsible for investigations of the system in order to understand requirements from a theoretical point of view, the strengths and weakness for any existing system ad to arrive at an acceptable solution.

Responsible for designing the system to identify the input and output requirements of the system in order to define the menus, forms and reports specifications, define all the tables and fields needed by the system and its relationships, and define all the systems functional requirements.

Responsible for creating the required menus and creating the required on-line and report calling forms using Oracle Developer Forms ver 4.5 and creating the required reports using Oracle Developer Reports Ver 2.5.

Responsible for creating Oracle stored procedures, functions and packages using SQL*Plus and PL/SQL.

Responsible for testing the system to ensure that all the components of the system work together to meet the defined requirements. This includes entering test data to check the field validations, program functions, program interfaces and system integration.

Responsible for preparing user’s manual, to guide the users of the system, and technical documentation, for reference for maintenance and future modifications.

Responsible for preparing the necessary installation diskettes to install the system.

Responsible for user’s training upon request by the user.

Responsible for systems maintenance such as systems change and additional requirements.

LBP Insurance Brokerage Inc., Philippines

Oracle Project Manager / Database Administrator

Analyzed and optimized company’s Insurance Brokerage System. Using Powerdesigner Data Architect, the system was reversed engineered.

Created the primary keys, foreign keys, constraints, and index and computed the initial sizes of the objects. Backup the system; re-install Oracle and their Insurance Brokerage System.

Monitored their database and enhanced most of their programs and reports.

Integrated Data Solutions (IDS), KSA Mar 1993 – May 1997

Oracle Consultant / Systems Analyst / Programmer

One of the biggest software company using and distributing Oracle RDBMS and Oracle Developer Tools (SQL*Plus, PL/SQL, Oracle Developer Forms, Oracle Developer Reports, SQL*Menu, CDE, and Designer/Developer 2000). The official distributor of Enterprise Management Information System (EMIS/2000) in the Middle East Region. The Official distributor of ULTIMA (Hospital Information System) which can be linked to EMIS/2000.

Responsibilities:

Responsible for investigations of the system in order to understand requirements from a theoretical point of view, the strengths and weakness for any existing system and to arrive at an acceptable solution.

Responsible for designing the system to identify the input and output requirements of the system in order to define the menus, forms and reports specifications, define all tables and fields needed by the system and its relationships, and define all the systems functional requirements.

Responsible for customizing Enterprise Management Information System (EMIS/2000) in using Oracle Developer Forms Ver4.5 for menus and on-line forms and Oracle Developer Reports Ver 2.5 for reports and other Developer/2000 tools.

Responsible for creating the required menus using SQL*Menu Ver 5.0.11.9.4, creating the required on-line and report using Oracle Developer Reports ver 1.1.13.2.3.

Responsible for creating Oracle stored procedures, functions and packages using SQL*Plus and PL/SQL.

Responsible for testing the system to ensure that all the components of the system work together to meet the defined requirements. This includes entering test data to check the field validations, program functions, program interfaces and system integration.

Responsible for preparing the necessary installation diskettes to install the system.

Responsible for user’s training upon request by the user.

Responsible for systems maintenance such as systems change and additional requirements.

Zuhair Fayez & Associates, KSA

Oracle Systems Analyst / Programmer

Prepared data to test to the Accounts Payable, Fixed Assets, General Ledger and Personnel & Payroll systems. Prepared the user’s manual for the Accounts Payable, Fixed Assets, General Ledger and Personnel & Payroll Systems. One of two people who defined the ESC commands in the printdef.dat to create the necessary print drivers for the Epson LQ 870/1170, Citizen, HP3 Laser and OTC printers. This includes creating the necessary tables and forms to automatically connect to a local or remote printer and printing the reports passing the correct desk type and desk format.

Omar K. Alesayi, KSA

Oracle Consultant

Attended meetings with the customer to determine the requirements of the system that is an on-line, multi-company and bilingual system. One of the key persons to design and create the systems proposal for the General Setup, Inventory, Pricing, Database, Sales Order & Invoicing, Accounts Receivable, Sales Analysis, Purchasing, Accounts Payable, Customs Clearance, Fixed Assets, General Ledger, Product Costing, Manufacturing and Personnel and Payroll systems based on the system requirements gathered.

Designed the tables needed using S-Designer. The one of two people who successfully made the necessary programs and procedures to line form passing variables defined in the calling form to the on-line form when everyone else said it was impossible.

Created the security programs and procedures to be able to define multiple internal users corresponding menu choice is either enabled or disabled. This includes defining an encrypted password for each internal user and a system defined super user. The user password is stored in a database can only be change by the user who knows the password. Created all the necessary menus and 30% of all the on-lines forms and reports except for the General Setup, Accounts Receivable, Purchasing, Custom Clearance, Accounts Payable and Product Costing/Manufacturing in which was 95% involved with. Created the system’s technical manuals.

Created user’s manual and conducted user’s training for the General Setup and Design of the System and Accounts Receivable, Purchasing, Accounts Payable, and Product Costing/Manufacturing System.

Created all the installation diskettes for all the systems including any updates done on the system. This includes creating the tables and installing the on-line programs upon request of the customer. Maintained the necessary backup of the source codes of the different systems.

Created the programs to do the Quantity and cost corrections for the Inventory system and updating all the related tables in together systems like accounts receivable and sales order & invoicing, product costing & manufacturing for all the branches the systems are installed in the Kingdom.

Conducted technical support of all the systems upon request of the customer.

Kept track of all the source codes that need modification whenever minor or major changes are done to all the systems. This includes creating batch programs to update all the necessary tables due to the changes requested.

Bureau of Internal Revenue (BIR), Philippines

Project Team Leader / Senior Systems Analyst Nov 1990 – Mar 1993

Computer Operator / Programmer Oct 1989 – Oct 1990

Responsible for investigations of the system in order to understand requirements from a theoretical point of view, the strengths and weakness for any existing system and to arrive at an acceptable solution.

Responsible for designing the system to identify the input and output requirements of the system in order to define the menus, forms and reports specifications, define all the tables and fields needed by the system an its relationships, and define all the systems functional requirements.

Responsible for testing the system to ensure that all the components of the system work together to meet the defined requirements. This includes entering test data to check the field validations, program functions, program interfaces and system integration.

Responsible for preparing user’s manual, to guide the users of the system, and technical documentation, for reference for maintenance and future modifications.

Responsible for preparing the necessary installation diskettes to install the system.

Responsible for user’s training upon request by the user.

Responsible for systems maintenance such as systems change and additional requirements.

New Personnel Information System (NPIS)

Functioned as a project team leader and senior systems analyst with three (3) oracle programmers and eight (8) data encoders of the PMO_ITPCC of the bureau of Internal Revenue in charge of developing systems request from different offices under the administrative service of the bureau.

Conducted initial interviews, created and proposed the general design and detail design of the system, responsible for the implementation of the system and conducted user’s training and support.

Plantilla System

Functioned as a Systems Analyst, Systems Administrator, Systems Maintenance Officer and Programmer of the Plantilla System in the Personnel Division, which was developed in Foxbase/Foxplus.

Carbonell Corporate Group, Philippines Apr 1987 – Apr 1988

Computer Operator / Programmer

Responsibilities:

• Responsible for creating programs using DBIII in monitoring the stocks available in the company.

• Encoded all the necessary information into the system.

• Prepared memos and letter using WordStar 4.0 and worksheets and graphs using Lotus 123.

Education:

MS in Computer Science Units, Ateneo de Manila, Philippines

Bachelor of Science Major in Biology, University of Santo Tomas, Philippines

Licensed ‘Insurance Life’ Agent

Training Conducted:

Oracle Developer Forms v3.0 / Oracle Developer Reports v1.1, Integrated Data Solutions, 1997

Oracle Developer Foundation and Oracle Developer Forms v4.5, Integrated Data Solutions, 1996

Basic XENIX/UNIX Operations Course, Bureau of Internal Revenue, 1992

Xenix/UNIX Systems Administrators Course, Bureau of Internal Revenue, 1992

Training Attended:

Hub Technical Overview / Developer v2.2.x and higher, Constellar Corporation, 1999

eMIS2000 Training, ESI Technologies, 1997

Oracle Developer Foundation and Oracle Developer Forms v4.5, Oracle Saudi Arabia, 1996

Oracle Developer Reports v2.0 (CDE tool), Oracle Saudi Arabia, 1995

Systems Development Standards Developers’ Guide, Bureau of Internal Revenue-PMO-ITPCC, 1992

Fundamentals of UNIX Operating System], Fujitsu Philippines, Inc., 1992

Integrating Databases, Unix Users Group, 1992

SQL*Plus; Oracle Developer Forms; Oracle Developer Reports; PL/SQL in Oracle, MCC Associates, Inc., 1991

Structured Systems Analysis and Design Workshop, Institute of Advanced Computer Technology, 1990

End User and Systems Administrator Training for SCO XENIX Operating System, MCL Distributors, Inc., 1990

Micro Computer Preventive Maintenance and Basic Troubleshooting Technique, Development Academy of the Philippines, 1990

DOS, Wordstar; Lotus 123, SM Equicom Computer Services, Inc,.

Turbo Pascal Programming, International Center for Computer Studies, 1987

Dbase III Programming, Institute of Advanced Computer Technology, 1987

Contact this candidate