Text version
KEYWORD SUMMARY
Application Developer. Systems Analyst. Client-Server Architecture. Client-Server Design. Oracle. Oracle Applications. Data Warehousing. SQL. MS SQL Server 2000. UNIX. HTML. ASP. C++. JavaScript. Perl. CGI. Visual Basic. Photoshop. Deadline Driven. BS Degree. Business Administration, Computer Information Systems. Cal State Hayward.
QUALIFICATIONS SUMMARY
Over seven years of experience with the analysis, design, development, testing and implementation of software applications using
Oracle. Proficient in designing and developing web applications using Active Server Pages, JavaScript, Visual Basic,
HTML and Perl/CGI. Possess excellent communication and inter-personal skills.
TECHNICAL SKILLS
Programming: SQL, SQL*Plus v3.1/3.3, PL/SQL v2.1/2.3, UNIX shell programming, HTML v4, ASP v3.0, Perl v5.6/CGI, Visual Basic v6.0, C++, JavaScript, PHP
Tools: Developer/2000 Forms 4.5, Oracle Reports v2.5/2.0, SQL*Forms v2.3, SQL*Loader v7.1, SQL*ReportWriter v1.1, TOAD, ActiveState Komodo, CodeWarrior, Multi-Edit
RDBMS: Oracle 7.1, 7.3, 8i, MS SQL Server 2000
Applications: Oracle Applications 10.4/10.5/10.7 (PO,AP,AR,OE,INV,BOM,MRP,AOL), Dreamweaver 4.0, Adobe Photoshop 6.0 & 7.0, Adobe PageMaker 6.5, MS-Access, MS Office, MS Publisher 2000, Silverrun-RDM 2.6 (Data Modeling), Brio 5.0, Essbase 5.0, GQL, ASK MANMAN/MFG, Quadralay WebWorks 7.0, Adobe Acrobat/Distiller
OS: Sun Solaris, DEC VAX/VMS, HP/UX, PC and Mac Clients
PROFESSIONAL EXPERIENCE
Independent Contractor 1/06 – present
Programmer
CCI, Novato, CA 4/04 - 4/05
Web Application Developer
- Developed static and dynamic custom web sites for CCI clients using Perl, HTML and JavaScript on MS SQL Server 2000.
- Database interaction: wrote queries and analyzed query plans using SQL Query Analyzer, administered SQL Servers using Enterprise Manager.
- Helped maintain database and programming standards.
Autodesk, San Rafael, CA 6/02 - 3/04
Consultant, Web Development - Location Services Technical Publications
- Wrote Perl scripts to automate the task of populating hundreds of documents with dynamic HTML.
- Worked with Tools manager to redesign existing website; analyzed requirements for persistence of user options and implemented cookie-based solution.
- Analyzed requirements for searching across documents, identified solution, and developed JavaScript code to implement in production website.
- Wrote JavaScript code to implement dynamic HTML, force frames, and create collapsible menus.
- Worked with technical writers to convert FrameMaker documents to HTML, perform production edits of results, and index documents for searching.
- Customized WebWorks Publisher templates for single-source generation of technical documentation.
Quantum Corporation, Milpitas, CA 12/98 - 1/00
Consultant - Point of Sale Project
- Helped design and manage an Oracle Forms 4.5 client/server application that captured distributor sales and inventory ("POS"). Worked with one other developer for 3 months then became lead developer.
- Created two new versions of POS using Oracle Forms 4.5 and Unix shell scripts: one version for foreign currency conversions and Y2K compliancy, and another for distributor gross margins, both of which consolidated number of applications used and streamlined work flow of employees worldwide.
- Provided application support to users in US, Europe, and Asia Pacific that required use of Brio and Essbase.
- Identified problems in code and made code fixes to production environment using Oracle Forms 4.5, Oracle Reports 2.5, Unix shell scripts and cron jobs.
Cisco Systems, Inc., San Jose, CA 9/98 - 12/98
Consultant - Data Warehousing and i2 Project
- Designed model and wrote PL/SQL package for new trade-in/discount model. New model retrieved "discounts" from sales order adjustments in the Oracle Applications. Worked with users and GQL designers to phase out old discount model and implement new one.
- Worked on a team to implement i2 Demand Planner. Responsible for providing the team with data files that were needed from Cisco's Data Warehouse; this involved creating tables and writing the algorithms necessary to populate these tables, and working out any roll-up issues.
Quantum Corporation, Milpitas, CA 10/97 - 9/98
Consultant - Data Warehousing
- Wrote PL/SQL scripts to acquire, replicate, transform and manage data from Oracle Applications v10.7 (previously 10.4) into data warehouse that provided executives with the crucial information necessary for decision support.
- Worked closely with users and Data Modeler to analyze business requirements for a "flash" balance sheet, then successfully developed and implemented it using PL/SQL, converting the labor intensive task of producing the preliminary monthly balance sheet from a 4-day to a 2-hour process.
- Modified and designed reports using Oracle Reports v2.5, as needed.
Specialized Bicycle Components, Morgan Hill, CA 4/96 - 10/97
Programmer/Analyst
- Performed design, development/revision and implementation of Oracle reports using v2.5 for Oracle Applications v10.5 (production system).
- Maintained system by working with Oracle -- log TAR's.
- Provided Oracle support for Manufacturing and Purchasing staff.
- Assisted users in writing MS Access queries and reports.
- Used SQL*Loader & MS Access for uploads of item & customer data.
- Tested and evaluated Oracle Applications v10.7.
- Worked with Purchasing and Manufacturing groups to map out business processes and Oracle functions.
- Created process indicators to measure critical areas of the process.
Roche Bioscience (formerly Syntex), Palo Alto, CA 8/95 - 3/96
Consultant (Frontier Technology, Inc.)
- Programmer/Analyst on $10M client/server, GUI pharmaceutical application. Worked with users locally and internationally in the analysis, design and development of reports that met the stringent and diverse requirements of manufacturing under GMP.
- Developed reports using Oracle Reports v2.0.
- Developed and modified reports using SQL*ReportWriter v.1.1.
- Wrote technical specifications for reports.
Syntex Corporation, Palo Alto, CA 8/93 - 7/95
Programmer/Analyst
- Developed new reports and modified existing reports using SQL*ReportWriter v1.1.
- Assisted with the software testing efforts in preparation for user acceptance test phases by writing test scripts and unit/system testing (GLP compliant). On assignment in Scotland to lead software acceptance testing.
- Handled a technical hotline providing timely service on phone and at user site for 160 users.
EDUCATION
- Perl Programmer Certificate & HTML Web Content Developer Certificate, Santa Rosa Junior College, Santa Rosa, 2002
- BS, Business Administration, Computer Information Systems option, California State University, Hayward, 1993
TRAINING
1994 - 1997 Oracle Education:
Introduction to Oracle
Oracle7 for Application Developers
Develop Applications using Database Procedures (Oracle 7)
Develop Complex Queries: Advanced SQL & SQL*Plus
Develop Reports using Oracle Reports v2.0
Introduction to Oracle Manufacturing
Oracle Purchasing 10SC
Oracle Purchasing (SmartClient)
Oracle MRP/Planning
Oracle Alert (SmartClient)
SQL Tuning
1993 - 1997 Other:
Introduction to UNIX
Advanced UNIX: Shell Programming
APICS Fundamentals
Getting Productive with Omnis7