Summary of Qualifications

over 20 years experience including more than 15 years specializing in the design, development and implementation of business intelligence solutions.

During his career he has held positions ranging from DBA to developer to technical architect to project lead to corporate director. Ken brings expert level skills to all areas of a project including: requirements gathering, data architecture, database design and front-end implementation. Moreover, Ken is a dedicated problem solver with demonstrated abilities for both understanding and explaining issues from business as well as technical perspectives and, his project successes are characterized by a hands-on motivational leadership style.

Professional Experience

Confidential

Technical Lead Developer

Primary Responsibilities:

• Spearheading project to implement MicroStrategy Visual Insights and
• Self-Service Analytics Internationally.
• Uplift of MicroStrategy 9.01 to 9.41
• Analyzing other Visual Insight Tools to meet specific business needs. Networking Visualizations
• Creating Reports, Dashboards, and Visual Insights using MicroStrategy as the reporting tool.

Key Technologies:

MicroStrategy 9.41 Desktop, Architect, Intelligence Server, Report Services, Dashboards, Delivery Services, and Narrowcast, Web Visual Insights, and Desktop Visual Insights.

Netezza, Oracle, and Teradata

Informatica

Confidential

Sr. Business Intelligence Analyst

Primary Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds.
• Analyze all Data and Build all MicroStrategy Schema Objects
• Build reports and Dashboards to provide Business Users with Analytics.
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

MicroStrategy 9.30 Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast

SQL Server

Confidential

Architect

Primary Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds delivered on Mobile IPads..
• Analyze all Data and Build all MicroStrategy Schema Objects
• Build reports and design Mobile Dashboards to provide Business Users with Analytics.
• In the Architect role I built out a new datasets of and create new
• Reports and Dashboards using MicroStrategy as the reporting tool and Mobile delivery.

Key Technologies:

MicroStrategy 9.30 Desktop, Architect, Intelligence Server, Report Services, Dashboards, Mobile, and Narrowcast

Oracle and SQL Server

Confidential

Architect

Primary Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds.
• Analyze all Data and Build all MicroStrategy Schema Objects
• Build reports and Dashboards to provide Business Users with Analytics.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new datasets of and create new
• Reports and Dashboards using MicroStrategy as the reporting tool.

Key Technologies:

MicroStrategy 9.30 Desktop, Architect, Intelligence Server, Report Services, Dashboards, Mobile, and Narrowcast

Oracle and SQL Server

Confidential

Architect

Primary Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds.
• Build reports and Dashboards to provide Business Users with Analytics.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new datasets of and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

MicroStrategy 9.02 Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast

DB2 and Teradata Database

Confidential

Lead Developer

Primary Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds.
• Build reports and Dashboards to provide Business Users with Analytics.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new set of and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

MicroStrategy 9.02 Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast

SQL Server and Teradata Database

Confidential

Senior Architect / Lead Report Developer

New Warehouse based on Sybase backend

Primary Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds.
• Build reports and Dashboards to replace and enhance current manual Excel spreadsheets.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new set of data and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

MicroStrategy 9.02 Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast

Sybase Database

Confidential

Senior Architect / Lead Report Developer

Review current on-going projects for Best Practices.

Primary Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds.
• Build reports and Dashboards to replace and enhance current manual Excel spreadsheets.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new set of data from upgraded Siebel System and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

MicroStrategy 9.02 Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast

DB2 Database

Confidential

Acting Senior Architect

Review current on-going projects for Best Practices.

Primary Responsibilities:

• Collected reporting requirements from the business users based on the existing and new data sources.
• Review existing projects and evaluate current Schema to add new data sources.
• Architected a new set of data sources and added them to the current project. Created new Reports, Dashboards, and Scorecards using both IBM Cognos tool and MicroStrategy.

Key Technologies:

MicroStrategy 9.02 Desktop, Architect, Intelligence Server, Report Services, Narrowcast

IBM Cognos

Teradata Database

Confidential

Acting Senior MicroStrategy Architect

Review current on-going RDM projects for Best Practices.

Primary Responsibilities:

• Interviewed the business users and the current project personnel to draw up a project plan for the Architectural changes requested and outlined the steps to implement them.
• Review existing projects as MicroStrategy Architect and evaluate consolidating Dimensions and removing Duplicates.
• Interpret MicroStrategy Integration Manager results to pinpoint Reports that need to be changed for new consolidated data structures I have Architected and created.
• Documented all changes and created a roadmap to the data for both before the changes and after the Architect changes for future reference.

Key Technologies:

• MicroStrategy 8.11 Desktop, Architect, Intelligence Server, Report Services, Narrowcast
• MicroStrategy 9 Integration Manager
• Teradata Database

Confidential

• Review project and reporting request from business users and delivering them using multiple methods.
• Develop Microstrategy Office to PowerPoint reports that dynamically update for 2 key clients.

Primary Responsibilities:

• Review existing projects and meet with clients to develop reporting package
• Create MicroStrategy Office PowerPoint Decks with over 60 reports that will now automatically update.

Lead MicroStrategy Developer

Key Technologies:

• MicroStrategy 8.02 Microstrategy Office, Intelligence Server, Desktop, Report Services, Narrowcast
• MicroStrategy 8.1 Microstrategy Office, Intelligence Server, Desktop, Report Services
• Microsoft PowerPoint 2003

Confidential

• Survey Design of Projects with an eye toward Best Business Practices.
• Report Services Document Construction for Global Treasury Division.

Primary Responsibilities:

• Review Project Architecture, Data Implementation, and Existing Reporting
• Created MicroStrategy Dashboards to represent the 2 highest levels of the Treasury hierarchy. Upon acceptance the reports were opened up to all levels of the Treasury Sales hierarchy. The Desktops that I created with Banks of America were included in Microstrategy Regional Meetings with the Managing Director of the Treasury Division presenting them across the country.

Lead MicroStrategy Developer

Key Technologies:

MicroStrategy 8.02 Intelligence Server, Desktop, Report Services, Narrowcast

Confidential

• Data Architecture
• Integration of New Data Sources.

Primary Responsibilities:

• System Integration of New Data Sources
• Lead MicroStrategy Developer
• Lead MicroStrategy Architect

Key Technologies:

MicroStrategy 8.021 Intelligence Server, Desktop, Report Services, Narrowcast, Architect

Confidential

• Led implementation of Retail Pharmacy Chains business intelligence solution.
• The solution allowed analysis of drug efficiency across client and non-client pharmacies with data sourced from multiple prescriber and patient data stores.
• Solution included a 1TB data warehouse with over 2000 users.

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning
• Lead Narrowcaster Developer

Key Technologies:

MicroStrategy 8.02 Intelligence Server, Desktop, Narrowcast

Oracle 10g

Oracle Designer - ERWin

• Led development for Marketing Science Department QC effort
• Worked closely with key business users to develop reports in MicroStrategy to support the quality control of Verispan patient data
• Solution included a 1TB data warehouse.

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Key Technologies:

• MicroStrategy 8.01 Intelligence Server, Desktop, Narrowcast
• Oracle 10g
• Oracle Designer - ERWin

• Leader of team to design and build a new data warehouse on Oracle 10g that created Verispan's first opportunity to combine their prescription data with patient and hospital diagnosis data.
• The reports allowed sales force management to target areas of significant opportunities where qualifying brands were under utilized.
• Solution included a 1 TB data warehouse with over 300 users.

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 8.0 Intelligence Server, Desktop, Web
• Oracle 10g
• Oracle Designer - ERWin

• Designed a new data warehouse to focus on market research analytics and project management.
• The product was used by Verispan client companies to research total unique patient counts by brand using market basket analysis reports
• Solution included a 1 TB data warehouse with over 300 users.

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 8.0 Intelligence Server, Desktop, Web
• Oracle 9i
• Oracle Designer - ERWin

• Lead Developer in the design and reporting teams for warehouse.
• Developed reports at Zip Code and MSA levels to assist Verispan client companies in planning media buying activities for the purpose of recruiting patients for clinical trials.
• Solution included a 1 TB data warehouse with over 300 users.

Primary Responsibilities:

Lead Project Architect

• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 7.0 Intelligence Server, Desktop, Web
• Oracle 9i
• Oracle Designer - ERWin

• Led the design teams for a data warehouse to allow reporting by the Oncology, Respiratory, Cardiovascular, and Neuroscience business units.
• Delivered reports to District Managers at the territory level for the purpose of analyzing Territory Rep performance.

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 8.1 Intelligence Server, Desktop, Narrowcast, Web
• Oracle 10g
• Oracle Designer - ERWin

Confidential

Allergan, Inc-

• Led JAD sessions to determine business rules and practice requirements for reporting and design to analyze retail pharmacy information in combination with other managed care and hospital data sources.
• Reports enabled the Large Account Managers to target and to realize sales data changes by Manager.

Primary Responsibilities:

• Project Manager
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 6.0 Intelligence Server, Desktop, Web
• Oracle 9i
• Oracle Designer - ERWin

• Created reporting package to allow district, regional and home office sales managers to view sales activity and pinpoint sales opportunities.
• Integrated call management data from Seibel call system.

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 6.0 Intelligence Server, Desktop, Web
• Oracle 9i
• Oracle Designer - ERWin

Center for Disease Control Public Health Surveillance -

• Lead developer on a warehouse that tracked prescription trends at national, MSA, and Zip Code levels enabling the CDC to spot trends that could indicate the beginning of a disease outbreak.
• Application tracked large purchases of particular brands that could be a leading indication of a Homeland Security problem.
• An example of this type analysis would be large purchases of Cipro the brand name drug used to treat Anthrax.

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 6.5 Intelligence Server, Desktop, Web
• Oracle 9i
• Oracle Designer - ERWin

Confidential

Amgen-

• Worked with client for initial data base schema, reporting, implementation, and training.
• Architected a star schema for the Oncology Marketing Business Unit. Warehouse combined internal, IMS prescription, wholesale, prescriber and managed care data with integrated Seibel Prescriber Call Data.
• First time the client had a total view of business using the various internal and external syndicated data sources

Primary Responsibilities:

• Lead Project Architect
• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 6.5 Intelligence Server, Desktop, Web
• Oracle 9i
• Oracle Designer - ERWin

Sepracor Pharmaceutical-

• Architected a schema design for the purpose of analyzing sales data captured by the Sales Logix territory management system in combination with IMS prescription data
• The reports were automatically exported to multiple worksheets in Excel that contained macros to reformat data.
• One of the custom reports was a Weekly Activity Report which showed the hours spent actively calling on Physicians and the corresponding increase or decrease of prescription dollar activity.

Primary Responsibilities:

Lead Project Architect

• Lead MicroStrategy Developer
• Performance / Aggregate Tuning

Technologies:

• MicroStrategy 5.5 Intelligence Server, Desktop
• Microsoft Excel
• Oracle 9i
• Oracle Designer - ERWin

Technical Skills

• Operating Systems
• Microsoft Windows 2000 Advanced Server, NT 4.0, Win 95/98
• RDBMS
• Oracle 9i, 8i, 8
• SQL Server
• DB2
• OLAP Client Tools
• Member MicroStrategy Beta Test Team
• MicroStrategy 8, 7i, 7.0, 6.0, 5.0
• Development
• Data Modeling: ERWin
• Visual Basic