Post Job Free

Resume

Sign in

Project Manager Sql Server

Location:
Gilroy, CA, 95020
Posted:
October 29, 2010

Contact this candidate

Resume:

DOUGLAS N MCCOWN

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

Gilroy, California. 95020

Cell 408-***-****

E-Mail – abig0n@r.postjobfree.com

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.



Contact this candidate