• Created use cases and requirements to convert 250 random, inconsistent sales slides into PROS Pricing Analytics, a multi-million dollar revenue Business Intelligence tool for pricing decisions.
• Consolidates client, market, and integration teams’ feedback to create the product roadmap.
• Leads dimensional modeling sessions for prospects and clients.
• Trains project managers on star schema dimensional modeling.
• Creates and leads product training for sales teams, sales support, and pricing consultants.
• Performed Pricing Strategy analysis for prospects.
• Product areas: Machinery rental, Chemicals, B2B Distribution, Health Care, Pharmaceuticals, Retail, Hotel Management.

• Led a 5-person team and managed the product that was responsible for all Business Intelligence reporting and built the data warehouse; contributed close to $3,000,000 in savings in 2003.
• Analyzed requirements and designed the data warehouse (Kimball Star Schema).
• Designed and created reports, cubes, and visualization dashboards using Cognos Impromptu, Cognos PowerPlay, Cognos Query, and Cognos Visualizer.
• Mentored Business Intelligence team in dimensional modeling, star schema warehouse design, and ETL techniques.
• Designed ETL rules and developed ETL requirements for the data warehouse.
• Developed and presented seminars on cross-cultural negotiations to many organizations.

• Technical lead for development of OLAP cubes and relational databases.
• Led a 3-person team and managed IT portion of strategic Exploration data visualization system.
• Business and technical lead for development of Business Intelligence front-ends.
• Managed BI projects ranging from 2 to 4-people teams, gathered and documented requirements, acted as change management gatekeeper, and coordinated application testing and rollout.
• Created visualizations with Spotfire, ProClarity, In3D, Excel, and 3D Charting Toolkit.
• Designed and developed applications with Microsoft Analysis Services, EssBase, Oracle Express, Kalido, and Business Objects.
• Led business development efforts offsite; I identified two other projects that could use IT resources and monitored their progress.
• Mentored other team members in Access, Excel, EssBase, and data visualization tools.
• Created and led team-building seminars.
• Product areas: Energy Exploration, Accounting, Retail Energy, Risk Analysis.

• Microsoft Access Technical Coordinator.
• Introduced EssBase into Shell Oil.
• Designed and developed Business Intelligence cubes and applications with EssBase.
• Product areas: Oil products - Marketing, Chemical.

• Performed data modeling and process analysis for financial systems.
• Migrated mainframe applications to client/server.
• Established Information Access Center of Excellence, promoting denormalization, data warehousing, RAD, OLAP, and information access as a competitive advantage.
• Product areas: Manufacturing, Training.

• Led projects for Shell PC Leasing and Corporate PC software standards.
• Led audit and analysis of PC software compliance.
• Implemented departmental Peer Evaluation process

• Designed, developed, and supported mainframe and PC decision support applications.
• Developed and presented computer training classes.
• Product areas: Chemical, Oil Products, HS&E, HR, Manufacturing, Marketing.

1983 - Present

CLH WAREs

Houston, TX

• Designs, develops, and supports database decision support applications.
• Develops and presents classes on database development, presentation skills, and team building.
• Developed a UML-RAD methodology for the development of database systems using object-oriented Rapid Application Development techniques.
• Developed and marketed products: data visualization, bookkeeping, word processing, DBMS.
• Product areas: Office management and CRM, patient tracking, city government services, genetic research, cable network programming, recruiting, education, legal document management.

• Datamart/front-end and database design articles. Access/Visual Basic/SQL Advisor, 2000-2002.
• Columnist of “Database-ics” for the Houston user group’s magazine, The Apple Barrel, 1990-1994.
• Columnist of “Toastmaster Tangents” for District 56’s newsletter, Forum 56, 1989-1992.

Technical summary (expert technologies in Bold)

• 4-time recipient of Shell Special Recognition Award.
• Toastmasters: Distinguished Division Governor; Able Toastmaster, co-founder of 5 clubs, led a 600-person organization.
• Business Volunteers for the Arts: Distinguished Volunteer Service Award.