MARK WAKEFIELD
Castro Valley, CA
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