Diane Lopez Email & Phone Number

California, United States

Stanford, Ca, Us

Project Team Lead and Developer• Led team of developers to develop several applications in an Apache/Tomcat, Java/Struts/Spring/Hibernate, Oracle and Linux environment. Development was done using Eclipse and used Git as the source repository. Applications included, APSU, application consisting of about 15 forms to gather information from new incoming students, Advisor Case Management, Student Course Application and Assignment, Student Grant Funding, Advisor Assignment, Faculty Senate Voting that included the HARE algorithm for election processing and other smaller applications.• Member of team that converted in-house written Advisor Case Management system to Salesforce. • Developed and maintained reports and data extracts written in Oracle BI and Oracle Reports.Data Engineer, Database Administrator and Server Administrator• Responsible for all database table design, creation and management for organization. Maintained the ER Diagrams in Erwin and Oracle Data modeler.• Maintained ETL processes used to populate local databases using PL/SQL, Perl, PHP, Webservices, and other scripting tools. • Designed and created data warehouse used to house data used for all VPUE’s internally written applications and for VPUE’s reporting needs. Data comes from multiple sources included PeopleSoft, Webservices, SAS products and VPUE applications.• Installed and setup web and database systems using Oracle Application Server, Apache/Tomcat and Oracle.• Performed all Oracle DBA and Linux Administrator tasks. Including setting up of an Oracle Standby database. Responsible for setting up entire server room.Management• Managed staff supporting all IT related infrastructure for the VPUE department of over 200 employees. Including all in-house written applications, desktop support, website development and support, server administration, and local network support.• Produced and managed budgets to support all IT infrastructure and purchases for VPUE

Herndon, Virginia, Us

• Wrote Oracle 7 Database Administration Course. • Technical editor and advisor of several Oracle courses for U.S. and International training.• Instructed Oracle courses presented in the U.S., U.K. and Canada.

Santa Clara, Ca, Us

• Lead team of developers to outsource the company's PeopleSoft payroll system to an outside service provider. • Wrote various SQR programs to perform payroll and HR related task.• Wrote technical requirements and specifications for numerous data interfaces to be used by vendors and service providers.• Performed routine DBA and database maintenance including tuning, space management and backups.• Installed and configured Apache Web Server on an HP Unix system.• Managed Unix and Oracle Security on HP Unix System• Wrote routines to split the company's Employee Service Organization's call tracking system into two for the Agilent/Hewlett-Packard company split.• Worked with the Oracle Application Server and developed test applications to determine feasibility of implementation for the department.• Wrote Web Application using PERL, Java, JavaScript, HTML and DBI to manage security request for the call tracking system. This system including email notifications and Unix and Oracle Security Functions.• Wrote various PERL DBI and SQL routines to perform Oracle Database monitoring and performance activities.• Worked with Clients to resolve issues regarding the call center applications.• Performed various programming activities to help with the company's acquisitions, divestitures and voluntary severance programs.• Helped trained new staff members on the system and Unix/Oracle features.

Palo Alto, Ca, Us

• Performed routine Database maintenance including tuning, space management and backups.• Wrote Capital Expenditure Request for many hardware and software requirements.• Designed and developed Tape management system in Access.• Performed Unix Administration functions.• Managed client server and web document management system in Documentum/Oracle. This included day to day operations and upgrades of both Documentum and Oracle. Performed the migration of the system from a Sun Sparc 20 to a Sun Enterprise 3000 computer. • Wrote many Unix and Oracle utilities and monitoring routines in Perl and implemented on over 30 servers.• Purchased and installed Keyboard/Video/Monitor system that reduced the computer room needs from over 50 keyboards and monitors down to 4.• Performed installation of Oracle 7 and Oracle 8 databases and Oracle Application Server (Web Server)• Designed and worked with team to implement Department's Web Site.• Performed updates to the Remedy Help Desk System. Worked with developers and vendors to resolve system problems.• Managed and trained staff on small Access projects, Visual Basic, SQL and PL/SQL.

• Worked with team consisting of a project manager, lead engineer, 3 team engineers and myself, (Database Engineer) to design a patient claim system for a large insurance company. This involved working directly with the outside clients in order to get the information needed to design the system. The database portion was designed using Erwin.• Wrote project proposals, project plans and associated documents to win development contracts from outside companies.• Worked as Lead Engineer on upgrades to a Diabetes Patient Management system for the Mayo Clinic. The system was written in C++/Visual Basic and Sybase.• Managed MS SQL Server, Sybase SQL Server and Oracle Databases on NT platforms.• Wrote Object Oriented Visual Basic code to perform loading of time into time keeping system using Access. Crystal Reports was used to create reports for viewing the data.

• Customized MRP system written in Oracle Forms for customers’ needs for Plastic Extrusion Division.• Trained staff in Oracle's Pro*Cobol syntax.• Implemented batch programs written in Pro*Cobol for the MRP system.• Designed reports in Oracle Reports and Crystal Reports.• Maintained and upgraded batch scripts used for production batch run written in Perl.• Performed Oracle database maintenance.

• Team lead for Check Draft Reconciliation System (CDRS). This involved working with director level employees and development staff to determine needs for the system.• Created new forms and enhanced existing forms for the CDRS system in Developer 2000 (Oracle Forms 4.5).• Wrote and taught Oracle 4.5 course.• Worked with bank employees and the CDRS team to implement OCR reading capabilities into the system. This involved creating extract files in C to send to the bank and custom written PostScript code to print the bills from a Unix system.• Designed and modified tables in Designer 2000 for new features and enhancements to the existing features in the CDRS system. Wrote extensive stored PL/SQL packages, procedures and functions in order to best support the requirements of the CDRS system.• Member of the companies Database Team to help direct the companies database activities.

Rosemead, Ca, Us

Worked in roles as Software Engineer, Database Administrator, Server Administrator and Data Engineer • Worked as an I.T. professional at both the company’s headquarters in Rosemead, Ca and at the tightly regulated San Onofre Nuclear Plant in San Clemente, Ca. • Software loading utilities, file conversions and DLL creation using C/C++.• Design and development of Oracle Object space estimator system creating an annual savings of approximately $100,000 per year written in PL/SQL and PowerBuilder.• Worked as PowerBuilder and Oracle mentor for other staff members.• Used various design packages including S-Designer, Erwin and Case to Design tables for various applications.• Performed Day-to-Day management of Oracle 6 and Oracle 7 database on UNIX and Novell Systems.• Hardware support of several Sequent Unix machines.• Provide technical support for Web, Client Server, UNIX, and Oracle applications.• LAN implementation and administration for Novell and IBM Server networks• Support of Novell Network consisting of approximately 80 servers and 2,000 users.• Wrote interface to retrieve data from VSAM files and DB2 to Oracle using C with Sybase Open Server Gateway, Sybase DBLIB, and Oracle Pro C.• Graphical User Interface design and development for Windows and OS/2.• Design, development, and maintenance of CSP and COBOL based applications for CICS and TSO using DB2 and VSAM for Financial Department.• Performed application-based database task in DB2.• Creation of address management system using Visual Basic, Enfin/2, and Sybase SQL Server for Law Department• Implementation of document management system.• MS SQL server Database administration and support.

Atlanta, Georgia, Us

• Worked with clients to implement database conversion using PL/SQL scripts and stored procedures, ultimately reducing processing by 8 hours.• Development of Windows based Customer Support application using Oracle 7 and PowerBuilder for manufacturing company.• Prototype and implementation of Management Information System to allow ad hoc querying against Oracle database using PowerBuilder.• Used S-Designer and Erwin to design tables for Customer Support Application.