Andrew Wetmore Email & Phone Number

San Francisco Bay Area

San Francisco Bay Area

San Francisco Bay Area

Support and development for internal invoicing system.• Worked with an international team for nine months to prepare for a major salesforce.com data migration.• Wrote multiple stored procedures for SQL Server 2000 to transform order data from one storage model to another.• Performed analysis to find data anomalies in preparation for stricter data controls. Sole support of a custom MS Access application to process sales orders data into invoices.

Sole support of a custom MS Access application to process sales orders data into invoices.• Enhanced the system to meet user requirements and keep up with changes to integratred systems.• Documented processes to ease transition to replacement processes in integrated systems.• Migrated application from Access 2003 to 2007.

Worked in IT Development on the Siebel CRM system. This system was integral to the operations of most departments at Inovis, used for Customer Support, IT HelpDesk, Sales Lifecycle support, and Billing.• Configured repository objects through Siebel Tools (views, applets, business components, joins, workflows, etc.).• Developed eScript modules to visually highlight when service requests are opened against accounts with delinquent maintenance agreements.• Developed business services to update system data including monthly billing updates and one-time updates to master data.• Developed workflows to send automated emails and text messages to support personnel when high severity issues are opened.• Developed an integration to customer software using Email Response and workflows to auto-generate service requests.• Developed a report in Actuate used by client services organization to forecast and manage billable activities; this was integrated to a JDE financial system for automated billing.• Produced process documentation.

Worked in IT Development on the Vantive CRM system at QRS through its acquisition by Inovis in October 2004; then lead support programmer for both Inovis’ existing Vantive system and the acquired QRS system. These systems were integral to the operations of most departments at QRS and Inovis, used for Customer Support, IT HelpDesk, Sales Lifecycle support, and Billing.• Designed and developed a web interface to allow customers to enter and monitor cases. o Designed the architecture that all other programmers used for various support pages. o Developed the web interface in JSP using Vantive API. o Created SQL Server stored procedures for background operations.• Modified existing Vantive forms and tables.• Designed and developed custom tables, front-end screens, and menu entries.• Developed triggers to tables for real-time interface to an external system.• Used Windows NT scheduled tasks, DOS batch files, and the SQL Server BCP utility to create export files for financial systems.• Engaged in requirements gathering, coding, testing, deployment, end-user training, and support.• Extensive experience developing in SQL Server, including designing and creating tables, views, and stored procedures.

Collaborated on a charge calculation and invoice generation system that processed transaction data from internal company products and the IBM Global Network.• Engaged in the full project development life cycle, from requirements gathering through deployment including analysis, functional and technical design, coding, testing, and user training.• Commended as Employee of the Quarter, Fall 1995, for successful development and implementation of the system.• System offered generic and individual rates, complex discounts, detail and summary reports, and produced invoices to be mailed to customers.• Maintained the system through company growth, improving the process, adding and removing product inputs, and resolving issues.• Created regular and ad hoc reports using PRF and Excel.

Responsible for the following major projects to modify the POETS floor trading system of PSE options:• Improved the trading time and sales audit trail display and maintenance functions to more accurately depict the trading day.• Altered the external order routing interface to permit automatic order cancellation, and return a confirmation transmission for the same.• Expanded the external quote data feed to allow for the monitoring of options prices nationwide.• Modified the external order routing interface to accept three new user firms.• On call as primary support for Options Systems processing, both CICS on-line and nightly batch reporting.Prior projects include:• Created the CICS interface for the capture of trades executed automatically on the trading floor system.• Created an in-house billing system to capture necessary charge data, including automated trading charges, to produce final invoices for customer billing.• Replaced the options trading charges calculation in order to expand the automation of trading charges, to improve fee waiver capability, to add detailed totals by charge type, and to create reports of revenue by option product.• Created real-time CICS and nightly batch extracts of trading information for member firms.

• Supported the CICS options trade recording system.• Learned CICS and VSAM as a requisite of the job.

• Member of on-site technical support team providing 24-hour support Monday morning through Saturday morning.• Undertook special projects to merge independently developed systems: o Consolidated execution JCL, procs, and programs into single libraries. o Renamed datasets to a single consistent standard.

• Documentation librarian.• Tape librarian / report distribution.