Guy Fouche

Current

• Senior Data Warehouse Architect at BlueCross BlueShield of Texas
• Lead Author, Accelerated VB 2008 & Accelerated VB 2005 at Apress

Past

• Senior Data Warehouse Developer at United Samsco
• Senior Data Warehouse Architect at American College of Emergency Physicians
• Senior Data Warehouse Architect at Capital One Auto Finance

• Senior Developer at Solectron
• Senior Developer at Zales
• Senior Developer at Sabre
• Principal Consultant at NIMS Associates
• Senior Developer at Richardson Independent School District
• Senior Developer at Resident Data
• Technical Reviewer (part-time) at WROX Press
• Trainer (part-time) at Maxim Group
• Technical Lead at Nortel Networks
• Senior Developer at 1st Plus Financial
• Technical Lead at Texas Instruments
• Lead Developer at Texas Instruments
• Systems Analyst at Burlington Northern Santa Fe Railway
• Trainer (part-time) at Analysts International
• System Developer at Burlington Northern Santa Fe Railway

see less...

15 more...

Education

• Drake University

Recommended

35 people have recommended Guy

Connections

285 connections

Industry

Computer Software

Websites

• My Photography

Guy Fouche’s Summary

Brainbench Certified Internet Professional (BCIP)
* Web Developer – Server-side
* Web Developer – Client-side
* Web Designer – Graphic Design

Brainbench Industry Certifications
* Telecommunications Industry Knowledge
* Automotive Industry Knowledge

Brainbench Technology Certifications
* On-Line Analytical Processing (OLAP)
* Visual Basic (VB)
* Visual Basic Script (VBS)
* Active Server Pages (ASP)
* HTML
* FrontPage
* Photoshop
* Windows OS

Guy Fouche’s Specialties:

Industries Served
* Financial Services
* Telecommunications
* Luxury Goods & Jewelry
* Airlines/Aviation
* Information Technology and Services
* Primary/Secondary Education
* Real Estate
* Semiconductors
* Transportation/Trucking/Railroad

Guy Fouche’s Experience

• Senior Data Warehouse Architect

  BlueCross BlueShield of Texas

  (Non-Profit; 10,001 or more employees; Insurance industry)

  September 2006 — Present (3 years 3 months)

  I contributed to or was responsible for the following activities:
  
  •Analysis, development and implementation of inquiry data mart. This data mart provides BCBS with the ability to gauge inquiry key performance indicators throughout the organization.
  •Analysis, development and implementation of inquiry cube. This multi-dimensional data store allows BCBS to review & analyze inquiry cycle-time and customer advocate performance at all levels throughout the organization.
  •This decision support system provides goal versus actual performance reporting to call center supervisors and upper management. This feedback mechanism provides the knowledge needed for goals to be reviewed, negotiated and revised by business process owners.
  
  •These efforts used SQL Server 2005, SQL Server Analysis Services and SQL Server Reporting Services.

• Lead Author, Accelerated VB 2008 & Accelerated VB 2005

  Apress

  (Privately Held; 1001-5000 employees; Writing and Editing industry)

  August 2006 — Present (3 years 4 months)

  I contributed to or was responsible for the following activities:
  
  •Creation of topic discussions, code examples and code discussions. This title is aimed at intermediate to advanced Visual Basic, as well as experienced object-oriented developers.
  •Managed title discussions and examples through entire publishing life-cycle. This includes working directly with the Program Manager, Technical Reviewers, Copy Editors and the Senior Editor.
  
  •These efforts used Visual Basic 2008, Visual Basic 2005, the .NET 2.0, .NET 3.0 & 3.5 Frameworks.

• Senior Data Warehouse Developer

  United Samsco

  (Privately Held; 501-1000 employees; Retail industry)

  June 2006 — August 2006 (3 months)

  I contributed to or was responsible for the following activities:
  
  •Analysis, development and implementation of contractor/employee data mart. This data mart provides individual, store and district productivity, as well as payroll reconciliation and schedule monitoring.
  •Analysis, development and implementation of Bay Survey. This tool is initially used to capture bay setup during store openings. During the lifetime of the bay, product mix changes, inventories and placement are continually monitored.
  •Analysis, development and implementation of corporate metrics reporting. This included HR, sales and customer satisfaction metrics.
  
  •These efforts used SQL Server 2005, SQL Server Reporting Services, SQL Server Integration Services and Visual Basic .NET.

• Senior Data Warehouse Architect

  American College of Emergency Physicians

  (Non-Profit; 1001-5000 employees; Education Management industry)

  March 2006 — June 2006 (4 months)

  I contributed to or was responsible for the following activities:
  
  •Analysis, development and implementation of Membership data mart. This data mart provides ACEP with business-defined dashboard, as well as ad-hoc reporting.
  •Analysis, development and implementation of reporting portal for individual chapters. These chapter-defined reports allow for the tracking and management of individual member titles, specialties, affiliations and other pertinent data.
  •Training of ACEP IT personnel. This training included Reporting Services, Report Manager, Report creation and delivery.
  
  •These efforts used SQL Server 2005, SQL Server Reporting Services & SQL Server Integration Services.

• Senior Data Warehouse Architect

  Capital One Auto Finance

  (Public Company; 5001-10,000 employees; Financial Services industry)

  March 2004 — March 2006 (2 years 1 month)

  I contributed to or was responsible for the following activities:
  • Analysis, development and implementation of Charge-off methodology. These processes provide COAF with the ability to predict, track, review & analyze losses, recoveries and redemptions of deficient accounts.
  • Analysis, development and implementation of General Ledger data exchange between COAF and Capital One Finance (COF). This exchange provides Capital One with branch loss, recovery and redemption transactions from COAF directly into the COF general ledger.
  • Analysis, development and implementation of finance cube. This multi-dimensional data store allows COAF to review & analyze losses, recoveries and redemptions of deficient accounts. This decision support system drives the determination of charge-off expense and loan reserve inventories on an ongoing basis.
  • These efforts used SQL Server 2000, SQL Server Analysis Services, XMLSpy, XML & Visual Studio.NET

• Senior Developer

  Solectron

  (Public Company; 1001-5000 employees; Telecommunications industry)

  December 2001 — March 2004 (2 years 4 months)

  I contributed to or was responsible for the following activities:
  • Analysis, development and implementation of Wireless Carrier / Manufacturer billing engines for cellular telephone repair centers. These engines provide Solectron with the following functionality: Split billing, Dual billing, In and Out of Warranty billing, as well as billing backup feeds to Manufacturer claims systems.
  • Analysis, development and beta implementation of cell phone WIP Disposition system. This system uses multi-dimensional data stores to provide near real-time tracking of cellular phones throughout the repair & refurbishment processes. When fully implemented, this system will provide Solectron the ability to measure and assess their performance in the following key areas: Turn around time (TAT), Station performance & Capacity planning.
  • These efforts used SQL Server 2000, SQL Server Analysis Services, MS Access, Cognos Transformer, Cognos PowerPlay, XML & Visual Studio.NET

• Senior Developer

  Zales

  (Public Company; 1001-5000 employees; Luxury Goods & Jewelry industry)

  July 2001 — December 2001 (6 months)

  I contributed to or was responsible for the following activities:
  • Analysis, development and implementation of user and data tier functionality for Zales.com as a member of their Christmas Readiness Team
  • Analysis, development and implementation of cross-browser client functionality, thus ensuring a consistent user experience with all Version 4x and higher browsers.
  • This effort used Visual InterDev, IIS, HTML, JavaScript, ASP, Visual Basic, XML, XSL, SQL Server & ADO

• Senior Developer

  Sabre

  (Public Company; 10,001 or more employees; Airlines/Aviation industry)

  March 2001 — July 2001 (5 months)

  I contributed to or was responsible for the following activities:
  • Analysis and reengineering of Human Resource (HR) functions, including current state, future state, and gap analysis
  • Development of Intranet repository for delivery of all analyses, final process documentation, and HR policies. This effort used Visual InterDev, IIS, HTML, JavaScript, ASP, SQL Server & ADO.
  • Facilitation of business process discovery sessions which included business process stakeholders and various vendor groups

• Principal Consultant

  NIMS Associates

  (Privately Held; 201-500 employees; Information Technology and Services industry)

  April 2000 — March 2001 (1 year )

  I contributed to or was responsible for the following activities:
  • Assessment of prospective client current system, analysis and design of future system needs, and contribution to end sales proposal
  • Design and creation of development lab which supported all development and testing activities, as well as acting as a central repository for all project artifacts
  • Leadership of remote development staff to deliver Business-to-Consumer shopping applications using the Microsoft suite of development products and servers
  • Development of NIMS Methodology, using Essential Set and the Rational Unified Process. I was a core member of this team
  • Development and delivery of ‘OOA&D with UML’ courseware to NIMS’ and client development staffs, using UML & Rational Rose

• Senior Developer

  Richardson Independent School District

  (Educational Institution; 5001-10,000 employees; Primary/Secondary Education industry)

  August 1999 — March 2000 (8 months)

  I contributed to or was responsible for the following activities:
  • Delivery of data mart and OLAP tool to RISD’s Student Performance & Program Evaluation department
  • Requirements gathering & specification creation
  • Interfacing between Student Evaluation group and development team
  • Logical database design & implementation using Oracle & ER/Win
  • Design, creation and implementation of multidimensional databases using the Cognos Suite of tools

• Senior Developer

  Resident Data

  (Privately Held; 51-200 employees; Real Estate industry)

  July 1999 — December 1999 (6 months)

  I was responsible for the following activities:
  • Delivery of credit request and criminal record components to development group for inclusion in their residential credit response system using VB, COM, SQL Server & ADO.
  • Analysis of Equifax credit reporting systems
  • Analysis of BTI criminal reporting systems

• Technical Reviewer (part-time)

  WROX Press

  (Public Company; 1001-5000 employees; Information Technology and Services industry)

  January 1997 — December 1999 (3 years )

  I was responsible for the following activities:
  • Ensured correctness, function and readability of WROX Press’s titles, using VB, Access and SQL Server
  
  I have contributed to their Professional VB6 Databases, VB6 Win32 API Tutorial, Beginning VB6 and VB6 GUI Design titles.

• Trainer (part-time)

  Maxim Group

  (Public Company; 5001-10,000 employees; Information Technology and Services industry)

  January 1999 — July 1999 (7 months)

  Developed and implemented the following courses for Maxim consultants:
  • Beginning Visual Basic – (students built a simple text editor)
  • Intermediate Visual Basic – (students built simple GUI to Access database)

• Technical Lead

  Nortel Networks

  (Public Company; 10,001 or more employees; Telecommunications industry)

  November 1997 — July 1999 (1 year 9 months)

  I contributed to or was responsible for the following activities:
  • Delivered data mart and OLAP tool to Nortel’s Worldwide Marketing Group using Visual Basic, JavaScript, HTML, ASP and Visual InterDev
  • Requirements gathering and specification creation with users worldwide
  • Formation / leadership of user groups
  • Interfacing between marketing and development team
  • Design, creation and implementation of multidimensional databases using the Cognos Suite of tools and SQL Server
  • Facilitating Nortel / vendor OLAP summit and tool evaluation
  • Served as OLAP subject matter expert to other wireless groups

• Senior Developer

  1st Plus Financial

  (Public Company; 1001-5000 employees; Real Estate industry)

  May 1997 — October 1997 (6 months)

  I contributed to or was responsible for the following activities:
  • Delivered data mart and query/reporting tool to FPF’s finance department using Visual Basic, Crystal Reports & SQL Server
  • Gathering and documenting business and end-user requirements
  • Creating specifications and delivering to development team
  • N-Tier development including user, business and data services using Visual Basic

• Technical Lead

  Texas Instruments

  (Public Company; 10,001 or more employees; Semiconductors industry)

  August 1996 — April 1997 (9 months)

  I contributed to or was responsible for the following development activities:
  • Delivery of Worldwide Sales Opportunity Tracking system using Visual Basic, Oracle & ER/Win
  • Rapid Application Development (RAD) & Joint Application Development (JAD)
  • Business process flow analysis & design using Visio
  • Staged prototyping using the Spiral methodology
  • Risk identification & management
  • Source code management using Source Safe
  • Training of management & end users throughout TI’s sales offices
  • Mentoring of 3 junior developers
  • Serving as GUI subject matter expert to other development groups

• Lead Developer

  Texas Instruments

  (Public Company; 10,001 or more employees; Semiconductors industry)

  March 1996 — August 1996 (6 months)

  I contributed to or was responsible for the following activities:
  • Delivery of Worldwide Product Change Notification system using Visual Basic
  • Electronic Document Management (EDM) using Saros
  • Work flow analysis & automation using Visual Basic & InConcert
  • Database design, construction & implementation using Oracle & ER/Win

• Systems Analyst

  Burlington Northern Santa Fe Railway

  (Public Company; 10,001 or more employees; Transportation/Trucking/Railroad industry)

  June 1995 — February 1996 (9 months)

  I contributed to or was responsible for the following development activities:
  • Analyzing & designing new corporate Maintenance of Way Payroll System
  • Analyzing system & user requirements
  • Analyzing & designing object model using the Fusion methodology
  • Analyzing & designing logical database model using Oracle

• Trainer (part-time)

  Analysts International

  (Public Company; 1001-5000 employees; Information Technology and Services industry)

  January 1995 — June 1995 (6 months)

  I developed and implemented MS Windows course for AiC employees.

• System Developer

  Burlington Northern Santa Fe Railway

  (Public Company; 10,001 or more employees; Transportation/Trucking/Railroad industry)

  July 1992 — June 1995 (3 years )

  I contributed to or was responsible for the following development activities:
  • Delivered a Field Labor and Production Reporting System using Visual Basic and Oracle
  • Joint Application Development (JAD)
  • Business analysis, with System Engineering and Maintenance Scheduling
  • Developing user and business services using Visual Basic and Oracle
  • Developing and delivering training to BNSF system gangs in the field

Guy Fouche’s Education

• Drake University

  Music , Jazz Performance & Composition , August 1979 — May 1983

  Activities and Societies:

  Jazz Ensemble, Orchestra, Brass Choir

Additional Information

Guy Fouche’s Websites:

• My Photography

Guy Fouche’s Interests:

Music, Music Composition, Trumpet, Photography

Guy Fouche’s Groups:

•    PartnerPoint - An Online Community of Microsoft Partners
•    On Startups - The Community For Entrepreneurs
•    Business Intelligence Group
•    Consultants Network
•    Drake University Alumni (2,000+)
•    Business Intelligence & Analytics Group
•    Microsoft Business Intelligence
•    Game Developers
•    SQLServerCentral
•    CAPITAL ONE CONNECTIONS
•    Global Analytics Network (+5K analytic professionals)
•    Data Warehousing Professionals Group
•    Linkin Visual Basic Developers
•    Edina High School Alumni
•    Trumpet Players
•    LINQ
•    Music Composer Network & Directory
•    TekSystems Alumni
•    International Trumpet Guild
•    SoundX
•    PartnerPoint - SMB for Microsoft Partners

Guy Fouche’s Honors:

LinkedIn – 29 professional recommendations
BlueCross BlueShield – 'Kudos' award for individual contribution
NIMS Associates – ‘NIMS Thanks’ award for individual contribution
Maxim Group – Consultant of the Year
Nortel Networks – ‘Spot’ award for individual contribution
Texas Instruments – ‘Stretch target’ award for individual contribution

Guy Fouche’s Contact Settings

Interested In:

• career opportunities
• consulting offers
• new ventures
• expertise requests
• business deals
• reference requests
• getting back in touch