Application Architect

John R. Villani

Oracle Application Architect

**** ********* ** ****: 973-***-****

Bridgewater, NJ 08807 Email: **********@***.***

OBJECTIVE

Seeking a position to apply my extensive experience in all phases of computer software development that support managing complex projects and improving business processes.

PROFILE

Highly motivated, technically minded, accomplished IT professional with a broad range of languages, operating systems, database systems. Skilled at working as a member of a team or completing individual projects. Working knowledge in both Agile and waterfall development processes.

SKILLS SUMMARY

Oracle R12

Quality Center creating test scripts

Informatica

PL/SQL

Quality Assurance Testing

Virtual Storage Safe

Database Performance Tuning

Migrating Legacy Data

COBOL

Requirements Gathering

Production Support

CICS

Functional and Technical Designing

Coding in several languages

DB2

PROFESSIONAL EXPERIENCE

Ricoh Americas Corporation - West Caldwell, NJ 09/2016 - 09/2017

Oracle Application Architect

Reduced free customer supply ordering in half by redesigning and coding the allowed order quantity algorithm in Mobile App and Oracle Web front end system.

Performed performance tuning fixes on several modules in the service contract subsystem.

Completed Oracle Field Service Cloud on-line training, then learned how the system was implemented at Ricoh.

Performed Oracle Lease Finance Module training and started working on implementation.

Worked with developers through estimation, design and coding of small system enhancements.

Ricoh Americas Corporation - West Caldwell, NJ 11/2005 - 07/2015

Senior Analyst

Functional IT role in an Oracle 11i environment: Led requirement gathering meetings, wrote requirement documents, reviewed functional and technical designs, created test plans using Quality Center, executed QA testing, monitored defect resolution, oversaw UAT testing, validated production migration.

Subject matter expert in Oracle Service Contract, Install Base and Counter modules.

Data analysis and ad-hoc report creation using PL/SQL with Toad.

Involved in numerous Agile software development life cycle projects for minor system enhancements.

Created test cases and performed testing for an App developed on iPhone and Android.

Redesigned and performed testing on an IVR voice recognition call-in system.

Worked closely with process team to ensure the feasibility of proposed system changes match the business requirements.

Computer Horizons Corporation - Mountain Lakes, NJ 11/1988 - 11/2005

Consultant/ IT Programmer Analyst

Assigned at Ricoh Americas Corporation - West Caldwell, NJ

Data conversion/migration: Mapped data from mainframe legacy system to Oracle. Coded and tested Informatica conversion programs to migrate legacy data.

Worked on IBM Mainframe utilizing COBOL, DB2 and CICS home grown systems. Maintained enhancements and was subject matter expert for Order Processing, Inventory Control, Purchasing, Billing, AR, Master File Maintenance applications.

Implemented a credit card authorization process directly into the order entry module as well as the settlement/acknowledgement process into the billing module.

Responsible for requirement, code and database design, coding, testing, production migration for countless system changes.

Additional responsibilities were production support, performance improvements, data fixes, and problem solving.

Minor modifications on smaller client server applications in Power Builder and Sybase/Omni.

Automated the creating contract data files and transferring to parent company in Japan utilizing HULFT.

Wrote conversion programs for data from HP3000 Image database to IBM mainframe in a DB2 database. Also involved in the conversion of the application programs from the HP to the IBM mainframe.

Maintained system enhancements on several applications on the HP3000 platform.

Cosmair, Inc. - Piscataway, NJ 05/1983 - 11/1988

Programmer Analyst

Maintained code for a manufacturing, inventory, distribution system on HP3000.

Performed application support duties.

R. Shriver Associates – Mountain Lakes, NJ 11/1980 – 05/1983

Programmer

Modified standard applications for client specific needs.

Installed applications at client sites.

EDUCATION

Fairleigh Dickenson University - Florham Park, NJ

B.A. in Mathematics with a concentration in Computer Science.

Contact this candidate