|
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. JavaScript. Perl. CGI. Visual Basic. Photoshop. Deadline Driven. BS Degree. Business Administration, Computer Information Systems. Cal State Hayward. US Citizen. QUALIFICATIONS SUMMARY
Proficient in designing and developing web applications using Active Server Pages (ASP), JavaScript, HTML and Perl/CGI. Over seven years of experience with the analysis, design, development, testing and implementation of software applications using Oracle. Possess excellent communication and interpersonal skills.
TECHNICAL SKILLS
Programming: SQL, SQL*Plus v3.1/3.3, PL/SQL v2.1/2.3, UNIX shell programming, HTML, CSS, ASP, Perl v5.6/CGI, Visual Basic v6.0, 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, EditPlus
RDBMS: Oracle 7.1, 7.3, 8i, MySql, MS SQL Server 2000, MS Windows Server 2003 & 2005 Applications: Oracle Applications 10.4/10.5/10.7 (PO,AP,AR,OE,INV,BOM,MRP,AOL), Adobe Photoshop 6.0, 7.0 & CS3, 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, Adobe Flash CS3, Adobe Dreamweaver 4.0 & CS3, Adobe Fireworks CS3, Joomla 1.0 & 1.5, Joomla CMS Extensions: Database Query (DBQ), Logos Query Manager (LQM)
OS: Sun Solaris, DEC VAX/VMS, HP/UX, PC and Mac Clients PROFESSIONAL EXPERIENCE Independent Contractor 1/06 – present Programmer
* Working as a contractor for Archer Web Solutions (www.archerwebsolutions.com), providing web programming within Joomla framework, and database architecture using phpMyAdmin/MySql to the following clients: www.jodekinternational.com, www.buzzconnect.com.
* Working as a contractor for MarketLive (http://www.marketlive.com) since 10/06 doing backend programming: database, asp.net, portals on MS Server 2003.
* Worked as a contractor for Berger&Fries (www.bergerandfries.com), providing web programming & maintenance, database consultation, image editing, and IT services to the following clients: www.marininstitute.org, www.alcoholpolicymd.com, http://mbergerart.com, www.manikajewelry.com, www.mollielawson.com, www.playfairmarin.org, www.westviewschool.com
* Websites created independently:
o http://www.sageinteractive.com/
o http://www.lynnlott.com/
o http://www.larrypottsmusic.com/
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
* Modify PDF's using Adobe Acrobat and Distiller
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
|
