Management Administrative Assistant

Lead Business Systems Analyst

Reporting / Leadership / Systems Development and Integration / Training

Expertise in reporting, data analysis, and innovative problem solving with

systems to provide upper management accurate control metrics. Broad

knowledge of data warehousing and relational database design to support and

maintain reports for sales and management. Effective motivator and

developer of team members. Detail oriented in research, testing, and

systems implementation.

. Business Objects Universe Design and reporting

. Business Functions Translation for Developers

. Application Development Life Cycle

. Effective in Training and Team Building

. Process Streamlining

[pic]

Professional Experience

City of Seattle, Seattle, WA 2007 - 2009

Business Objects Consultant through Ciber, Inc.

Assist Department of Planning and Development in deployment of Business

Objects XI R2 and upgrade to 3.1, which includes creating universes for

several subject areas, replacing ~275 Crystal Reports with Web Intelligence

reports to enhance functionality, and managing rights/permissions of groups

and folders through the Central Management Console. Collaborate with the

subject matter experts to determine data elements and report design, and

data mart team to insure data integrity as well as sound, scalable,

normalized schemes. Data mining to thoroughly validate accurate data

elements, aggregation, and report results.

Washington Mutual, Seattle, WA 2001 - 2006

Senior Portfolio Analyst/Trader (2005 - 2006)

Manage technical support and reporting for the Pipeline Systems and

Reporting group for home loans. Core team member in design,

implementation, and maintenance for pricing variance logic, database,

websites, and all reports. Operational Desk Intelligence reports include:

All Pricing Variance Reports, Trend Pricing Variance Reports, and Special

Rate Lock Notification Reports. Thorough downstream testing for loan

origination system releases.

. Innovated concept and design increasing report accuracy by 20%,

creating subsidy reporting, and identifying additional pricing

variances.

. Streamlined and documented reporting processes that improved

turnaround time from 7 to 3 days, ensured SOX and OTS compliance, and

allowed team to triage requests increasing productivity.

. Created trend reporting that allows senior management to strategically

plan and control pricing variances to secure consistency and

improvement throughout the bank.

. Partnered with upstream and downstream teams to implement PPCA

interactive website delivering centralized data and action venues.

. Developed a workflow system that took team goals and aligned them with

corporate goals ensuring delivery that supported corporate

initiatives.

Business Systems Analyst Senior (2004 - 2005)

Technical support, maintenance, and integration of the Pricing Variance

Report system with multiple data sources. Developed Access database

applications to accurately report, track and query mortgage data. Major

contributor in translating business requirements into web-based

application.

. Collaborated on application development using Rational Unified Process

(RUP) to create a website that eliminated a cumbersome manual process

increasing "real time use" and provided automated reports accessible

from remote locations.

. Selected as team representative during internal audit.

Business Systems Analyst (2003 - 2004)

Participated in the design and development of the Pricing Variance Report

system from data warehouse tables to the Business Objects universe and

reports. Developed ad hoc and operational reporting for senior management.

Designed operational database applications, streamlined processes, and

contributed to systems integration. Built Access database applications to

accurately report, track and query mortgage data.

. Received Kudos Award - employee recognition, 2003.

. Built a reporting system that identified initial pricing error rate of

40% allowing management to set in motion corrective action.

. Deployed Business Objects reporting universe standardizing and

automating reports.

. Designed Access database application streamlining parameter exception

pricing for mortgages.

Portfolio Analyst/Trader (2001 - 2003)

Created database applications in Access for tracking mortgage data.

Developed and maintained numerous relational database applications in

Access utilizing and reporting from data warehouse.

. Streamlined queries/data extract processes that increased productivity

and processing time.

. Implemented macros, VBA, and linked tables increasing processing

speed, accuracy, and standardization.

Amazon.com, Seattle, WA 1999 - 2001

Database Intern

Assisted implementation of Performance Management application (SABA).

Created operational reports using Crystal Reports 8, updated employee

status, helped remote locations troubleshoot installation of drivers, ODBC

connections, and gave general software and technical assistance for new

users.

. Designed and implemented tracking databases that automated manual

processes for all 7 distribution centers.

. Created database for standard operating procedures allowing

efficiencies to be built in and access to be readily available for

trainers.

. Trained users on new database reducing time for ramp up at

implementation.

Belltown Corporation, Seattle, WA 1998 - 1999

Accounting Assistant

Accurate reconciliation of bank statements, vendor statements, daily sales,

and invoices to computer records using QuickBooks Pro. Input payroll and

verified accuracy before disbursement.

Edmonds Community College, Edmonds, WA 1994 - 1998

Administrative Assistant

Accurate monthly reconciliation of 20 campus budgets. Monitored budget

reports, invoices, and labor reports for discrepancies. Supervised and

instructed new student employees in office policies and procedures.

. Initiated research to resolve discrepancies in budgets saving grant

money and improving accuracy.

. Designed spreadsheet programs for budgets to preventing discrepancies

and data loss.

. Created databases for conference attendees developing information for

marketing and fundraising.

Pacific Chamber Ballet, Edmonds, WA 1998 - 2001

Ballet Instructor

Instructed Intermediate and Advance levels of Ballet, ran rehearsals,

evaluated auditions for solos, assisted in production of annual Nutcracker

and year end performances as well as serving on Board of Directors for

school.

Northshore Children's Ballet School, Bothell, WA 1987 - 1997

Ballet Instructor

Instructed all levels of Ballet, co-designed curriculum and class schedule,

ran rehearsals, created original choreography for annual concerts performed

by 60 - 100 children.

[pic]

Education and Professional Development

Bachelor of Arts, Business Administration-IS concentration, University of

Washington, Seattle, WA

Associate of Arts and Science; Associate of Technical Arts-Accounting;

Accounting Certificate;

Medical Secretary Certificate, Edmonds Community College, Edmonds, WA

Our Inclusive Workplace

Communication Styles

Teamwork for Professionals

Exploring Change for Team Leaders

Setting Expectations and Delegating Effectively

Technical Skills

Languages: Visual Basic 6.0, VBA, Java using Visual Caf , SQL

Hardware: PCs/Servers, HP printers, scanners and other peripherals

Software/Systems: Business Objects XI R2 and 3.1 Universe Designer, Web

Intelligence reports, Desktop Intelligence reports, and Central

Management Console; Crystal Reports 8; Toad for Oracle 8.5; PL/SQL

Developer; Oracle 8.0 (Saba software); Microsoft Office 2007; Visio;

HTML, FTP Software, QuickBooks Pro

Contact this candidate