DOUGLAS N MCCOWN
Gilroy, California. 95020
Cell 408-***-****
E-Mail – *******@*******.***
JOB OBJECTIVE
To increase the overall effectiveness of the business enterprise by integrating strategic philosophies of the organization, cost-effective
information technology vision, and the day-to-day systems execution while simultaneously delivering the competitive advantage
expected/required in today’s real-time business world. I seek to fully utilize my expertise in creating information from structured,
disciplined management of data.
EMPLOYMENT HISTORY
03/10 Sr. Analyst, Business Intelligence
05/10 Verigy LTD, Cupertino, California.
Responsibilities/Achievements
- Solutions Manager for Enterprise OBIEE & OBIA(BI Apps) Project Kick-Off.
- BI Multi Vendor Analysis & Pricing Scenarios.
- OBIA Product Breakdown & Analysis.
- Integration Analysis for Oracle CRM OD to Oracle EBS and/or OBIA.
- Hyperion IR Roadmap Planning
10/09 Project Manager, Business Intelligence
12/09 BIS Consulting Inc. Alviso, California.
Responsibilities/Achievements
- Management of Issues and Requests for Enterprise OBIEE BI Dashboards.
- Project Management of Multiple BI Enhancements.
- Lead Role for importing Siebel Sales Forecast data into OBIEE dashboards.
08/06 Senior Manager, Business Intelligence, Corporate Information Technology Group
01/09 Align Technology Inc. Santa Clara, California.
Responsibilities/Achievements:
- Strategic/Roadmap Planning for Enterprise BI.
- Lead proponent for Enterprise Data Model, Data Quality, and Cross Application Impact Analysis.
- Regular participant in the Global Applications management team activities (budget/headcount planning, project
governance & integration to roadmap, leadership reviews, etc.)
- Implementation of a 5 product semi standardized key metrics system that enables product GM’s the ability for the first
time to measure the effectiveness & ROI of product pilots.
- Daily administration, supervision, & career development of 3 full-time staff as well as coordination of 5 offshore & 1
onshore development/support staff (India).
- Execution of next generation ETL, ODS, Data Warehouse Architecture.
- Responsible for regular Marketing external 3rd party data feeds.
- Completion of 8 major Sales Reporting releases in support of 140 US Sales Reps, Mgrs, Directors, & VP.
- Responsible for incorporating the SDLC/Release Team methodology into all projects.
- Tracking/monitoring/scheduling of over 100 regular enhancements.
Significant Achievements:
- Implementation of Sales/New Product Development/Mgt Metrics Data Mart.
- Rollout of OBIEE (Oracle BI Enterprise Edition - Siebel Analytics) tool.
- Initiated a complete re-architecture of the Salesforce.com data loading process. Results: Loading time reduced from 17
hours to 3.5. Daily loading accuracy increased from <70% to 99.5%+.
- Completion of over 40 Sales reports that represent the Sales Operations portfolio (Pipeline Mgt, Compensation, Qtr/Yr
Revenue Target Tracking, Mgt Key Indicators Dashboard, Discount & Cancellation Tracking, and President’s Club
Tracking).
- Participant in improvement of 38 step Sales Territory & Target Setting process involving multiple systems.
Application Development Toolset:
- Microsoft SQL Server 2005 (Database).
- Microsoft SQL Server 2005 Integration Services (ETL)
- Microsoft SQL Server 2005 Reporting & Analysis Services.
- Microsoft Sharepoint (Portal).
- Sesame Software – Relational Junction SFDC Integration.
- Oracle BI Enterprise Edition Application Server (OBIEE).
08/04 Senior Manager, Business Intelligence, Corporate Information Technology
08/06 Flextronics International. San Jose, California.
Responsibilities/Achievements:
- Daily administration, supervision, & career development of 14 full-time staff - 7 (San Jose,Ca), 3 (Brazil) & 1
(Malaysia) Developers, as well as 3 Support staff (Mexico).
- Participant in the Weekly Applications Metrics Portfolio Presentation.
- Technical support to the Global Procurement organization. ETL, ODS, Data Warehouse (85 global ERP data feeds).
- Responsible for regular external customer data feeds per business contractual requirements.
- Completion of 7 major global application rollouts as well as over 50 regular ODS/Data Mart/OLAP enhancements.
- Responsible for incorporating the SDLC/Release Team methodology into all projects/teams.
- BI Tool Analysis. Objective analysis of 5 major BI Tools in preparation for Cognos upgrade/replacement.
- Development & Implementation of a workflow-based end-user request tracking system. Each phase of the SDLC
tracked with statistics (past due commitments etc.) available to IT and business users via portal.
- Strategic/Roadmap Planning for Enterprise BI. Evaluation of open middle-tier data management as a way to minimize
the data mart explosion and management costs.
- Cognos license management of over 2000 users.
Significant Achievement:
- Initiated a complete re-architecture of the Oracle 9i data loading process utilizing partitioning. Results: Loading time
reduced from 29 hours to 15, system utilization from 95% to 45%, and an overall user response time reduction of 27%.
Executive focus point (Asia Region performance) improved by 59%. ROI achieved in less than 5 months.
Application Development Toolset:
- Oracle 9i & SQL Server Database.
- Oracle 9i Application Server (Apache).
- Oracle Warehouse Builder.
- Cognos Version 7 (Impromptu, IWR, PowerPlay, Upfront Portal, etc.).
- Microsoft SQL Server Reporting & Analysis Services.
- Microsoft Sharepoint (evaluation).
05/99 Business Systems & Applications Manager, Information Technology
08/04 Abbott Laboratories Inc/Hospira Inc, Hospital Products Division. Morgan Hill, California.
Responsibilities/Achievements:
- Daily administration, supervision, & career development of 5 - 6 full-time IT staff as well as contract staff.
- Complete departmental capital justification, budgeting, and merit planning.
- IT Member of the site Validation Review Board ensuring systems and process compliance with the Validation Master
Plan, FDA regulations, and Corporate guidelines.
- Leader of the 2003 Team of the Year (Validation & Upgrade of National Field Service Department Laptops).
- Business Impact Analysis / Disaster Recovery Plan for site.
- Permanent member of Strategic Business Planning Team (Customer Satisfaction).
- Leader of Level 1 team (INET / FGS) – Creation of IT/Business Process linked with Corporate IT.
- Participated in implementing the formal Systems Development Life Cycle initiative.
- Member of Division/Corporate $70M SAP Business Case Team & Cross-Divisional MES Standards Team.
- Reduced IT Applications backlog from 103 projects to 13 via improved processes & less headcount.
- Successful Customer Support Improvements (Users Group, Request Status via Intranet).
- Successful Budget Management – $200,000 under budget via internal process improvements.
- Demonstrated zero downtime on major system upgrade of HW/SW as well as applications & data migration.
- MRPII Application Support & Enhancements (450+ multi-site users).
- FDA Validation & ISO9000 audit quality documentation & security control.
- Completion of annual offsite Disaster Recovery simulation & Security Re-Certification.
- FDA 21 CFR Part 11 (E-Sig & Records) HPD team member, Inventory, Gap Analysis, & Remediation Planning.
- AS/400 System Replacement, Y2K H/W & S/W analysis, & full Y2K rollover testing.
- Intranet & e-Commerce web site technical support.
- Oracle (8 & 9) & SQL Server Database & Application Support.
Application Development:
- AS/400 Data3 (MRP) and In-House Application Customizations.
- NT based Client Server Employee Training System Technical Sub-Team Leader.
- Electronic Document Management Steering Team member.
- System consulting, Oracle DBA, and Application Support for Honeywell/POMS & Visiprise SCE MES’s.
- KBM (MRP) System Upgrade Evaluation Project.
- E-Commerce (InterShop/Sybase/iPlanet) Disaster Recovery.
- WebSphere Application Server/JSP Implementation Planning.
11/96 Applications Manager/Data Warehouse Project Manager, Information Services
05/99 Western Digital Corporation, Hard Disk Media Division. Santa Clara, California.
Responsibilities:
- Daily administration, supervision, & career development of 4 IT staff, 3-4 Oracle consultants, and 2 CIM staff.
- Complete justification, budgeting, & project management of $1.8 million real-time HP Unix/Oracle data warehouse
system that delivered consolidated factory analytical data via a state-of-the-art ROLAP (2nd & 3rd tier) architecture to
almost every functional department within the facility via a standard web-based interface.
- Generation of 50 - 75 custom MES queries/reports in support of daily manufacturing & engineering operations.
- Complete MES system support including Hardware & Software upgrades and performance tuning.
- Hands on MES process modeling and new product introduction.
- IS department ISO9001 Process & Documentation Team Member.
- Oracle database consulting to various groups including CIM department.
- Sr. Technical Consultant in Kaizen Computer Integrated Manufacturing design & architecture planning.
- Lead role in MES to CIM interface design requirements and transaction benchmarking.
- Y2K H/W & S/W analysis & planning for all major server platforms (IBM, HP, Compaq).
- Integration of advanced statistical analysis (SAS) with OLAP Web server.
- Responsible for selection of next generation Manufacturing Execution System.
02/96 Manufacturing Systems Engineer, Information Systems
11/96 Headway Technologies Inc Wafer/Slider Manufacture. Milpitas, California.
Responsibilities:
- Complete Camstar MESA implementation in the slider pilot manufacturing facility.
- Developed & implemented online Training movies for shop-floor MES learning.
- Developed senior management Executive Information System (dashboard/data mart) displaying 20 factory metrics.
12/90 Business Systems Manager, Information Systems
02/96 Western Digital Corporation Hard Disk Media Division. Santa Clara, California.
Responsibilities:
- MES system implementation planning, set-up, & upgrades including hardware, software, & cabling.
- Daily system maintenance including backups, DASD mgt & security.
- End user needs analysis including reports, file downloads, yields & defect queries, & access-time improvements.
- AS/400 Token Ring/DEC VAX Ethernet/TCP/IP LAN analysis.
- CPI STEERING COMITTEE member, WIPTRACK team leader/mentor, & MFG CYCLE TIME team member.
- Statistical Process Control software evaluation, purchase, & completion of training.
TECHNICAL KNOWLEDGE
Computer Associates Data3/KBM MRP System, Camstar Systems MESA MES Mfg software, MicroStrategy DSS Server & DSS Web,
AS/400 Operations, Query, Client Access, C.L., Security, RPG400, IBM Performance Mgt, Windows XP & Vista, MS Project, MS
Office, WRQ Reflection, McAfee Helpdesk, HelpStar Helpdesk, Salesforce.com, Sesame Software Relational Junction for SFDC, Visio,
IBM AS/400 DataPropagator, Oracle Database & Oracle Transparent Gateway. MS SQL Server 2005.
EDUCATION & TRAINING
OBIEE (Oracle BI Extended Edition) Building Repositories – 2008
OBIEE (Oracle BI Extended Edition) Reports and Dashboards – 2008
Microsoft SQL Server 2005 Integration Services Intense – 2007
Visiprise SCE (Manufacturing Execution System) System Administration – 2004
Presentation Skills for Leaders – 2003
FDA 21 CFR Part 11 Training., SAP Bootcamp Training – 2002
Abbott Laboratories Leadership for Managers Series, Microsoft SQL Server 7.0 Systems Administration – 2000
Western Digital Management and Leadership Effectiveness, MicroStrategy DSS Server & DSS Web Administration – 1998
Western Digital Project Management for Technical Managers – 1997
IBM AS/400 Interactive Program Design, RPG/400 Interactive Programming Workshop, Relational DB Design & Coding – 1988
Bachelor of Science in Business Administration – March 1985
Central Washington University, Ellensburg, Washington
Major – Management Science Minor – Data Processing
REFERENCES
References available upon request.