KEYWORD SUMMARY

QUALIFICATIONS SUMMARY

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

• Working 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.mollielawson.com, www.playfairmarin.org.
• Created website for Lynn Lott (www.lynnlott.com) in 3/06, and currently maintaining as needed.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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