MARK WAKEFIELD

**** *** ***** **

Castro Valley, CA

650-***-****

SUMMARY OF QUALIFICATIONS

Experience and demonstrated ability in the following areas: business intelligence, reporting, data analysis, data visualization and policy and procedure development.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

BI: Business Objects, Tableau, Cognos Impromptu, Crystal Reports, Crystal Enterprise, Hyperion, Oracle Reports, Xcelcius 2008, WEBI, Logi, MS Office

Databases: Oracle, SQL Server, Sybase, MySQL and Access

PROFESSIONAL EXPERIENCE

Spectrum Technologies, Santa Clara, CA 12/15-3/16

Report Developer

Fix bugs in existing WEBI and Crystal Reports for Callidus clients

Modified tables in data warehouse to meet reporting needs

Worked with management team to refine report requirements

David Corp, San Francisco, CA

Reporting Engineer 4/14-11/15

Develop reports and universes using Business Objects Crystal Reports, WEBI, & SSRS

Interact with clients to determine report requirements or to fix bugs

Create views and stored procedures in SQL Server

Create analytics from healthcare databases(ex.CPT, ICD9 & ICD10codes, providers)

Develop dashboards using Logi

Healthcare Information Management, Walnut Creek, Ca 9/13-3/14

Data Analyst

Create reports and dashboards from healthcare database using Tableau desktop

Develop and distribute analytics to mobile devices

Modified database schema for use as data source for dashboards

Set up new data connections

NetApp, Santa Clara, CA 3/13-8/13

Report Developer

Fix bugs in existing Crystal Reports for Callidus upgrade

Create publications in BO CMC for automated report distribution

Develop 2 new reports to track bookings

Work with end users to refine report functionality

Flywheel.com, Redwood City, CA 5/12-3/13

Data Analyst

Troubleshoot existing application reports to determine cause of incorrect results

Examine SQL Server database for inconsistencies or lack of data

Create Crystal Reports for management highlighting mobile app results

Assist in data warehouse design to facilitate increased reporting capabilities and to improve data accuracy

Developed KPI’s with senior management

Genentech, South San Francisco, CA 11/10-3/12

Business Intelligence Analyst

Created Crystal Reports and WEBI reports for new GPRS application

Troubleshoot application/database issues which relate to reports

Work with validation team to correct bugs and formatting issues

Interact with international users to define report functionality

Worked with developers to modify data warehouse design to encompass missing functionality

Design BO universe for ad-hoc registration reports

Openwave Systems, Redwood Shores, CA 04/10-11/10

Business Intelligence Analyst

Created new and modified existing Business Objects Universes

Created WEBI reports for sales demo environment

Migrating Business Objects XI v3 to new server; trouble-shooting existing issues

Callidus Software; San Jose, CA 01/10-03/10

Sales Engineer

Created Crystal Reports for multi-tenant Oracle db used for sales demos

Created/modified WEBI reports for demos

Created Xcelcius dashboards for client presentations

CSE Insurance Group; SF, CA 05/09-12/09

Investments Analyst

Determined current statutory deposit requirements, which resulted in recovery of $2.2 million dollars

Forecasted potential losses in acquisition portfolio by credit rating and maturity for 20 years

Automated reconciliation reports from outside data sources(Sunguard)

Reconciled Solomon General Ledger to external Investment system

Arthrocare; Sunnyvale, CA 04/05-09/08

Sales Operations Analyst - FTE

Upgraded hardware and Crystal software and performed report migration to new DW platform

Supported Sales Ops with daily and weekly reports used for commission payments

Fulfilled all ad-hoc reporting requests and trouble-shooting existing reports

Supported Hyperion reporting by creating new reports and modifying OLAP cube

Assisted in ERP migration from MFG/PRO to SAP; upgraded to Business Objects XI R2

Independent Consultant – 11/97- 03/05

Clients: VISA, National Semiconductor, Clorox, Salesforce.com, City of San Leandro, Imany.com, Skystream Networks

Completed Contracts:

Hired to troubleshoot existing Crystal Reports for Network start-up

Created reports and presented demo to investors and potential clients on report functionality for new software start-up. Modified existing marketing reports

Created HR reports for multi-national semiconductor company

Designed and automated reports to track project management reporting for multi-national financial services company

Created data views and stored procedures to support HR report creation for the City of San Leandro

Report migration(Cognos) to support database upgrade for multi-national bank

Designed interactive web-based reports for bleach manufacturer

For CRM company, created custom financial reports for revenue recognition and also performance reports for call center

Implemented MAS 90 accounting system and created customized financials for software firm. Also served as Controller

Implemented Visual Financial software for ceramic manufacturer and also created custom reports for finance and manufacturing

Implemented Lawson Financial software for telecommunications company and created customized reports

Implemented Lawson Financials for 5 different companies under one name. Created consolidations and custom reports along with Access db for travel and expense reporting. Documented work flows and tech requirements for conversion

The Good Guys; Brisbane, CA 07/1995 – 10/1997

Financial Analyst (FTE)

Provided ad-hoc reporting from data warehouse using Crystal Reports 6.0 for sales/marketing team

Developed Access database to produce revenue forecasts for co-op advertising programs

Prepared annual budgets for purchases and advertising revenue

Calculated and journalized actual monthly revenue

Implemented new software system

Chubb Sovereign Life Insurance Co.; Santa Barbara, CA 03/1994 – 06/1995

Accounts Payable Supervisor (FTE)

Supervised and evaluated a staff of four

Managed monthly payables of $1M

Closed monthly general ledgers

Olympia & York; Toronto, Canada 10/1991 – 09/1993

Property Manager (FTE)

Full management responsibility for all leasing and property management functions for two 14-story condominium complexes

In charge of receivables, maintenance, rental agreements, and tenant selection

Mission Industries; Santa Barbara, CA 12/1984 – 06/1991

Operations Analyst (FTE) 12/1988 – 06/1991

Developed fiscal operating budgets for 42 plants and 15 non-operating accounting entities

Led conversion team on plant acquisitions

Developed policies and procedures for the Sales Department

Accounts Payable Supervisor (FTE) 10/1987 – 12/1988

Managed payables exceeding $1M monthly

Supervised a staff of six

Internal Auditor (FTE) 12/1984 – 10/1987

Administered audits and investigations in 42 plants located in five states

Prepared detailed financial and operational audit examinations, investigations, and inventory reports

EDUCATION

BS, Business/Finance -- San Diego State University, San Diego, CA

Contact this candidate