SUMMARY:

15+ years of experience in system architecture, MicroStrategy, technical advisory, project management, analysis, requirements gathering, BI application architecture and development, quality assurance, application implementation, and user education. William excels in MicroStrategy database architecture, and is very experienced with managing teams and facilitating solution development for large projects across a range of functional areas. Excellent problem solving, written and verbal communication skills.

TECHNICAL SKILLS:

• MicroStrategy
• Oracle
• Teradata
• SQL Server
• Netezza
• Unix
• Government
• Finance
• Retail
• Healthcare
• Pharmaceuticals

FUNCTIONAL EXPERTISE:

• Database Architecture
• Technical Advisory
• MicroStrategy Development

ENGAGEMENT HISTORY:

Confidential, Iconnectiv, NJ

MicroStrategy Architect

Responsibilities:

• Appraised current Microstrategy Architecture
• Provided Microstrategy strategy solutions
• Analyzed Business requirements, and Developed MicroStrategy Solutions
• Provided guidance to the Microstrategy Architects and Developers
• Provided MicroStrategy’s best practices
• Reviewed and advised changes to the Data Warehouse Model
• Developed highly complex Dashboards
• Developed a POC Transaction services Reports
• Re - architect Microstrategy schema and fixed current data model issues
• Upgraded MicroStrategy 9.4.1 to MicroStrategy 10
• Installed and configured Microstrategy I-servers and Web Servers in Linux
• Train Microstrategy lead and Microstrategy developers

Confidential, WI

Technical Advisor

Responsibilities:

• Appraised current Teradata Architecture and recommend strategy solutions
• Provided guidance to the Microstrategy Architects
• Provided MicroStrategy’s best practices for Teradata
• Recommend Aggregate Join Indexes (AJI), to optimized MicroStrategy queries
• Reviewed and advised changes to the Data Warehouse model in the Teradata
• Reviewed current Teradata / Microstrategy queries
• Optimized Microstrategy setting for Teradata

Confidential, PA

Technical Advisor

Responsibilities:

• Appraised current Netezza Architecture and recommend strategy solutions
• Provided guidance to the Microstrategy Architects provided user support and solved productions issues
• Provided MicroStrategy’s best practice solutions for Netezza
• Reviewed and advised changes to the data model for Netezza / MicroStrategy
• Developed highly complex Dashboards and reports

• Developed a POC Transaction services Application using Microstrategy Services
• Developed their Region, District, store enterprise Dashboard in web and Mobile
• Key player in providing conceptual and analytical resolutions for the Data Model Implementation

Confidential, PA

Sr. Principal MicroStrategy consultant and Technical Lead Architect

Responsibilities:

• Providing MicroStrategy’ s best practice solutions for the MSTR Architecture
• Participated in the entire project life cycle; including requirements gathering, design, development, testing, deployment, and ongoing support of the MSTR BI solutions
• Reviewed and advised changes to the data model
• Appraised current Architecture and recommended strategy solutions
• Troubleshoot their MicroStrategy environment
• Installed and Configured the MicroStrategy I-servers and Web servers

Confidential, Coat Factory, NJ

Sr. Principal MicroStrategy consultant and Technical Lead Architect

Responsibilities:

• Provided Microstrategy / Netezza solutions to their current performance issued
• Appraised the current MSTR architecture problems and recommend strategy solutions
• Optimized the MSTR application using the MSTR Performing Techniques
• Appraised current Netezza problems and recommended MicroStrategy solutions
• Provided MicroStrategy’s best practice solutions for the MSTR Architecture
• Worked on the MicroStrategy upgrade
• Configured MSTR I-severs, MSTR Web Servers on UNIX servers

Confidential, LA

Technical Advisor /Team Lead

Responsibilities:

• Provided MicroStrategy best practices for the Schumacher DW
• Reviewed and advised changes to the data model
• Troubleshoot their MicroStrategy environment
• Fixed reports that are returning errant data due to cross-joins
• Fixed the MicroStrategy Schema

Confidential, PA

MicroStrategy Technical Advisor and Team Architect Lead

Responsibilities:

• Confidential contract was extended multiple times
• Key player in providing conceptual and analytical resolutions for the Data Model Implementation
• Provided Microstrategy / Netezza best practices
• Appraised the current Architecture and recommending strategy solutions
• Performed full range of project management activities by contributing to the development of project plans, estimating work, and task scheduling
• Set up the MicroStrategy SDK environment for the Developers
• Integrated Intelligence Server with LDAP to allow authentication via LDAP accounts
• Providing MicroStrategy’ s best practice solutions for the MSTR Architecture

Confidential, PA

Sr. Principal MicroStrategy consultant and Technical Lead Architect

Responsibilities:

• Created Retail dashboards for the CEO
• Key player in providing conceptual and analytical resolutions for the Data Model Implementation
• Participated in the entire project life cycle; including requirements gathering, design, development, testing, deployment, and ongoing support of the MSTR BI solutions
• Appraised the current MSTR architecture problems and recommend strategy solution
• Defined the MSTR Security Strategy
• Optimized the MSTR application using the MSTR Performing Techniques

Confidential, AL

Technical Advisor /Team Lead

Responsibilities:

• Confidential contract was extended multiple times
• Facilitated the extension of a Lead consultant and a Sr. consultant
• Worked with Confidential Spain and Confidential Mexico to provide a better solution to the Strategy client
• Provided MicroStrategy’s best practice solutions for the MSTR Architecture
• Key player in providing conceptual and analytical resolutions for the UNIX POC Implementation

Confidential, NJ

Technical Advisor

Responsibilities:

• Appraised current SAP Architecture and recommended BI MSTR strategy solutions
• Installed and configured SAP drivers
• Configured SAP connectivity to the MSTR BI
• Successfully connected to SAP BW and created reports against the SAP BW
• Provided guidance to report against the SAP BW using MSTR BI

Confidential, DE

MicroStrategy Architect and Technical Advisor

Responsibilities:

• Performed data model analysis against current dash-boarding requirements and made recommendations for changes to existing model
• Responsible for managing all aspects of the development, enhancement, and support of the MicroStrategy project deliverables Market
• Developed MicroStrategy reports for the Sales and Marketing Data Warehouse
• Analyzed existing analytical requirements relative Sales Prescriber Warehouse (SPW) and SMaRT reports
• Worked closely with business and project leaders to finalize requirements for project deliverables
• Provided MicroStrategy’s best practice solutions for the POC Universal
• Key player in providing conceptual and analytical resolutions for the UNIX and Upgrade Migration
• Developed key relations and produced more than expected as soon as possible with produced higher customer satisfaction
• Appraised current Architecture and recommended strategy solutions
• Appraised AZ’s 32 bit and 64 bit UNIX Architecture
• Provided a 64 bit UNIX Installed and configuration Cook Book
• Set up the MicroStrategy test environment