Project Manager Sales

Clara Carter

Walnut creek, ca

831-***-**** **********@*****.***

Technical Summary:

Microcomputer: WindowsNT, Windows, UNIX

Programming Languages: SQL (12+ years), Brio.Report [Hyperion

SQR] v3.5 to System 9 (12+ years), PL/SQL (4+

years), Javascript (6 mo), COBOL, COBOL II, C

Applications: SQL*Plus (7+ years), Brio.Report Builder [Hyperion

SQR] (12+ years), Brio.Explorer [Hyperion

Interactive] (6 year), Brio.Portal 6.0 (7 mo),

Reportmart (1 year), Hyperion Server v8 & 9 (3

years), Crystal Reports (1 year), Hyperion

Financial Reporting (1 year), Hyperion Web

Analysis (1 year), ISQL, Toad, Erwin, MS Access,

Excel, MSWord

Database Management: Oracle 7-9 (3 years each), Informix (6mo),

Sybase (3 years), DB2 (2 years), Essbase (1

year), MS SQL Server

Skills: Product Demonstrations and Presentations, Database

Programming, ETL, Data Marts, OLAP, Data

Modeling, Data Warehouse, Training, Project

Management

Education:

B.S. Computer Information Systems, DeVry Institute of Technology

(1987)

Employment History:

Wells Fargo Bank (10/09 - Present Short Contract)

Consultant - Business Analyst

As a Business Analyst responsible for finding gaps in existing

reporting process, analyzing and identifying new processes.

Documenting functional requirements for developing and implementing

a new reporting process. Updating existing Brio Intelligence v8-9

(Interactive) with new data sources and streamlining reporting

procedure. Converting Excel spreadsheet and MS Access reports into

Hyperion Interactive v9 reports by creating requirments, developing,

testing and implenting.

Disney Studios (8/08 - 1/09)

Consultant - SQR Programmer

Responsible for updating the Residual System with the latest contract

residual payments recently negotiated. Document and understand

current residual process and program. Incorporate new media residual

payments into existing program. Test new process with old and new

data. Programming in Hyperion SQR 8.3.1 and Sybase 12.5.1 stored

procedures. Using DB Artisan and QVT for unix.

Centive, Lowell, MA (1/08 - 8/08)

Solutions Consultant

Provide product expertise and appropriate technical support to assist

the sales team through all stages of the sales process. Helped

maximize sales revenue by developing and presenting complex product

solutions to customers. Other responsibilities include assist and

create need analysis and RFP/RFI responses. Develop and maintain

customer relationships through out and beyond sales process.

. SaaS Solution

. Customer facing demonstrations

Oracle (Hyperion Solutions), Santa Clara, CA (3/04 - 1/08)

Senior Solutions Consultant

Provide business expertise, product expertise and appropriate

technical support to assist the sales team through all stages of the

sales process. I was responsible for the maximization of sales

revenue by developing and presenting innovative product solutions

for customers. Develop complex prototype solutions for customers,

participate and assist in proof-of-concepts, assist and create need

analysis and RFP/RFI responses when needed. Perform under pressure

and tight time constraints, all while maintaining a positive

attitude in front of the prospect. I was responsible for all BI

products (Hyperion Interactive Reporting, SQR and Essbase plus

Oracle's OBIEE).

. 2005, 2006 and 2007 President Club participant

. Trained on Demo 2 Win concepts

Stanford University, Stanford, CA (8/02 - 3/04)

Software Developer, Business

Project leader for the Pinnacle application focused on enterprise

reporting. Responsibilities include the entire software development

life cycle from analysis and requirements gathering through to

implementation and post production support. Successfully planned,

developed and managed design, coding, testing and implementation of

web-based reports for Pinnacle application users. Ability to

consistently balance long term objectives with near term

requirements to effectively meet customer needs. Highly proficient

at designing and developing Oracle datamart views for adhoc and

business intelligent reporting, stored procedures, triggers and SQL

statements. Worked with several other internal departments to

define and resolve client issues and needs. Strong commitment to

quality results by taking initiative to discover and resolve system

issues early in the development process. Served as primary

interface to key third party and managed to reduce operating costs

by 60%.

Exp Systems, Inc., Menlo Park, CA (10/00 - 3/01)

Enterprise Reporting Engineer

Achieved the department and company goals through design,

development, and maintenance of enterprise reports and reporting

system. By reviewing and understanding data model, both OLTP and

Data Warehouse and reviewing report requirements, developed and

deployed data marts and reports for a reporting system. Developed

complex reports using Brio.Report 6.0 (SQR), Brio Query/Explorer and

Oracle 8 PL/SQL. Created complex queries and tuned both the SQL and

report process.

eTime Capital, Inc., Sunnyvale, CA (2/00 - 10/00)

Senior Reporting Engineer

Managed five team members, under the project manager, for the

development and deployment of web-based reporting system. Personally

navigated the team through evaluation of business requirements,

analysis, and specification reviews. Handled time estimates for each

report, assigned resources, trained or acted as knowledge base for

resources, and reported project status for my team. By reviewing and

understanding data models with Toad software on an Oracle Database

and reviewing report requirements, developed and deployed reports

for a web based reporting system using Brio.Report 6.0 (SQR) for

Brio Portal (5.x and 6.x). Created complex queries and tuned both

the Oracle SQL and report process.

Carter Consulting, CA (10/98 - 2/00)

Consultant - BI Programmer

Facilitated management of projects by working with client in

understanding and collecting business requirements, determine

project scope, estimate effort, assign resources, and ongoing status

reporting to the client. Generated results by data modeling,

database creation, writing specifications, reviewing with clients,

and spearheading design and development of the software, and oversee

testing. Used Brio.Report v3.5-9 (SQR) and Brio Intelligence v6-9

(Interactive) with Oracle databases and Oracle PL/SQL procedures to

meet customer requirements and needs.

Consulting Clients:

Rainmaker Systems, Inc., Scotts Valley, CA (6/99 - 2/00)

Consultant-Enterprise Reporting Specialist

Unysis/Norwest Financial, Des Moines, IA (1/99 - 4/99)

Consultant-SQR Programmer

Skyway Freight, Watsonville, CA (10/98 - 1/99)

Consultant-Oracle Programmer

EcoAnalysis, Ojai, CA (9/96 - 10/98)

Programmer Analyst/SQR Report Specialist

Responsible for a wide range of applications including environmental

analysis systems and laboratory information management systems.

Analyzed and learned each clients Oracle databases, worked with

clients to determine report layout specifications, developed SQR

and/or Crystal Reports against Oracle databases; on occasion

creating oracle stored procedures, and tested and delivered

software.

The Filoli Information Systems, Palo Alto, CA (1996)

SQA Engineer

Responsible for identifying, validating and verifying code

deficiencies (bugs) using a VI based bug reporting system (DDTS).

Responsible for business case testing against the application as

versions are released. Responsible for Identifying, collating and

quantify test cases and conditions in order to functionally test the

application. Assist in verifying data conversions to new database

schema when necessary using in-house SQR programs.

UCO/Lick Observatory, UCSC, Santa Cruz, CA (1993 - 1996)

Programmer Analyst II

Extracted Observatory data (business, Telescope Scheduling,

financial, etc.) from our databases (Sybase & Oracle) for in-house

use in normal reports, and for public use by formatting data in HTML

for Netscape on the World Wide Web. Responsibilities included

design, coding and implementation of special report generator

programs in SQR and Sybase. Successfully designed, wrote, and

tested user interfaces to convert business offices' large

administrative database application. Database was converted from

DTR32 within the VMS environment to Sybase within the SunOS

environment using SQL code. Major activities included: Creation of

trigger functions to manipulate data within the databases. Wrote

queries to generate accounting ledgers and associated forms using

Sybase and SQR. Created audit trail logging for changes in the

databases. Developed courses and training manuals for training and

supporting users. Quality assurance and pilot tester for UCSC

developed tools. Created new tables and associated reports.

GTE California, Thousand Oaks, CA (1990 - 1992)

Programmer

Analyzed, wrote detail specifications, designed, coded, tested, and

implemented COBOL II/DB2 programs for personnel systems. Worked

with project leaders and end users to ensure accurate application

needs. Provided support for production jobs. Major activities

included: Organization of system presentations. Provided estimated

hours and completion dates. New code and maintenance in COBOL II

using DB2 databases. DB2 performance tuning using EXPLAIN. Call and

Link sub-program modules. Created and maintained JCL. Provided

documentation for operations, programs, and users.

American Mobile Systems, Chatsworth, CA (1990)

Programmer-PC/LAN Administrator

Responsible for maintaining Dbase, C, and COBOL II/DB2 programs and

associated files used to create invoices from raw data collected

from telecommunication repeaters. Interface with users to enhance

and update the invoice programs and supporting data files. Support

users in the day-to-day operations, assist in PC, File Server, and

LAN related problems. Analyze and implement solutions to problems

caused by programs or data files.

Convergent Dealership Systems, Northridge, CA (1989 - 1990)

System Support Specialist

Assist customers and internal personnel with solutions to operational

and system problems on the Oakleaf mini computers that supported

General Motors automobile dealerships. Troubleshoot software and

hardware to determine communication problems for dealerships. Test

new products to ensure customer specifications and standards.

Recent Classes:

Demo 2 Win (2005) Data Warehousing Design

and Concepts (2/02)

Dreamweaver (2003) Relational Database

Design (1/02)

Visual Basic 6.0 (1/02) HTML (Fall 2000)

Introduction to MS SQL Server (4/02 - 6/02) Oracle Develop

PL/SQL Program Units (9/98)

Contact this candidate