William D.

William D. Email and Phone Number

Managing Partner and Business Intelligence Solutions Architect - MicroStrategy, Power BI , Tableau @ Philadelphia, PA, US
Philadelphia, PA, US
William D.'s Location
Greater Philadelphia, United States, United States
William D.'s Contact Details

William D. personal email

n/a

William D. phone numbers

About William D.

As a Managing Partner / Business Intelligence Solutions Architect, I provide BI solutions to various industries using MicroStrategy, Power BI, and Tableau platforms. I have 20+ years of IT BI experience, with 20+ years of MicroStrategy experience, and I have worked as a technical lead, advisor, data engineer, and data modeler for multiple fortune 500 companies.My mission is to transform data assets into powerful analytical solutions that yield significant benefits for organizations by making smarter decisions, reducing costs, and increasing sales. I have extensive experience in deploying and developing BI solutions for large BI deployments in finance, retail, pharmaceuticals, banking, government, and housing sectors. I have a comprehensive logical data warehouse modeling knowledge for optimal BI implementations, and I have developed custom VBA/Excel applications using the MicroStrategy SDK.

William D.'s Current Company Details
Business Intelligence Consulting Group

Business Intelligence Consulting Group

Managing Partner and Business Intelligence Solutions Architect - MicroStrategy, Power BI , Tableau
Philadelphia, PA, US
William D. Work Experience Details
  • Business Intelligence Consulting Group
    Managing Partner And Business Intelligence Solutions Architect - Microstrategy, Power Bi , Tableau
    Business Intelligence Consulting Group
    Philadelphia, Pa, Us
  • Business Intelligence Consulting Group
    Managing Partner / Business Intelligence Solutions Architect - Microstrategy, Power Bi , Tableau
    Business Intelligence Consulting Group May 2011 - Present
    - Focused on developing Business Intelligence Reporting (MicroStrategy, Power BI, Tableau) solutions including BI application architecture, system architecture, Data Modeling, Data Warehouse, Technical Lead, project management, analysis, requirements gathering, development, quality assurance, application implementation, and user education. - Serve as a technical point of contact on customer engagements and provide BI solutions.- Responsible for architecting and developing Business Intelligence solutions in accordance with Enterprise Standards.- Provide Business Solutions to the MicroStrategy platform using Snowflake, Netezza, SQL Server, Teradata, AWS RedShift databases.- Excels in MicroStrategy database architecture and very experienced managing teams and facilitating solution development for large projects across a range of functional areas- Create MicroStrategy Schema objects and Application objects, Attributes, Facts, Logical Tables, Transformation objects, Transactional reports, Filters, Users, Security Groups, Security Filters, ACL, database connection Instances, Dashboards, Dossiers.- Build a Data Strategy to Support Business Initiatives, to identify Data Capabilities, to Assess Data Condition and to Create a Roadmap- Communicate findings successfully through narrative-driven Dashboards and data visualizations for client(s) executives and business decision makers.- Resilient BI Solutions Architect, administrator in Unix or Windows environments- Experience on all versions of MicroStrategy software since version 4.1 thru all versions 11.1 lastest version- Experience with Netezza, Teradata, SQL Server, Oracle, AWS Reshift, SQL Azure Database , Snowflake- Push Data lake files into Microstrategy using Python REST API- Manage all aspects of the development, enhancement, support of the MicroStrategy Products, Integration, Capacity Planning, Tuning, Implementation, Strategy, and Migration from Windows to UNIX of BI Applications
  • Microstrategy
    Senior Microstrategy Consultant
    Microstrategy Apr 2007 - May 2011
    Tysons Corner, Va, Us
    - Work as Chief Architect, Lead Architect, Senior Architect, Technical Advisor, Data Architect, Data Modeler, Senior Consultant for multiple strategic accounts - Upgrade all Microstrategy products in Unix and Windows environments, - Leadership role in development and operation of MicroStrategy-based Lead Reporting for multiple clients: BBVA Compass Bank, PHI - PEPCO, NAVAIR, Scholastics, QVC. USPS, AstraZeneca, Verizon, Smithfield Foods, Bank of America, Autotrader, The Advisory Board - Hewlett-Packard Consulting, Charming Shoppes, R.H. Donnelley, Cingular Wireless- Migrate MicroStrategy from Windows to UNIX- Set up Microstrategy administration/ Security in Windows and Unix environments- Help Consulting Services to grow their accounts for major strategic accounts- Help Consulting Services grow their revenue - Help multiple contracts to be extended multiple times- Work as as MicroStrategy Solution architect- Facilitate the extension of multiple consultants at a Sr. consultant levels- Work with clients to provide a better solution to the Strategy client- Provide MicroStrategy's best practice solutions for the MSTR Architecture- Key player in providing conceptual and analytical resolutions for the UNIX POC Implementation- Appraise the current Architecture and recommend strategy solutions- Evaluate the current Data Warehouse and recommended MSTR solutions- Assess current client's problems and recommend solutions- Integrate MicroStrategy with SAP DW- Tune Microstrategy I-server, Web Server, Narrowcast- Responsible for architecting the Microstrategy systems-- Responsible for implementing data, object and functional security.- Experience implementing software upgrades in a highly predictable manner
  • Astrazeneca
    Senior Microstrategy Architect
    Astrazeneca Feb 2005 - Feb 2007
    Cambridge, Cambridgeshire, Gb
    - Responsible for managing all aspects of the development, enhancement, and support of the MicroStrategy project deliverables- Analyzed existing analytical requirements relative Sales Prescriber Warehouse (SPW) reports- Developed VBA/Excel programs based upon Design Documents- Captured customer technical requirements and conveys the results to the team to derive an acceptable solution.- Developed custom MicroStrategy reports and use MicroStrategy Narrowcast delivery to them in Excel- Created custom MicroStrategy Narrowcast VBA/Excel applications for the project deliverables- Developed VBA/Excel applications using the MicroStrategy SDK
  • Spencer Gifts, Egg Harbor Township , Nj
    Senior Microstrategy System Architect
    Spencer Gifts, Egg Harbor Township , Nj Mar 2004 - Feb 2005
    Egg Harbor Township, Nj, Us
    - Responsible for migrating all DB2 reports to Microstrategy- Responsible for supporting the existing data warehouse, data collection, and reporting systems- Leadership role in development and operation of MicroStrategy-based Lead Reporting system- Responsible for mentoring the development of MicroStrategy expertise in the team- Responsible for the coding, testing, debugging, and continued maintenance and support of MicroStrategy products
  • Merck Pharmaceuticals, Blue Bell, Pa
    Senior Business Intelligence Architect
    Merck Pharmaceuticals, Blue Bell, Pa Nov 2003 - Mar 2004
    - Responsible for the Analysis, design, programming, integration and implementation of the Metric Application - Create the functional Requirement Specifications for the Metrics Application- Created a metrics database that is capable of supporting batch and continuous data flow (CDF) studies- Provided summary reports at a country and protocol level to show the status of the studies in the Clinical Trial System - Worked closely with Project Data Managers to define the drug trial application inputs and outputs- Developed user interface to generate Clinical Data Trial reports
  • Memorial Sloan-Kettering Cancer Center, New York, N.Y.
    Senior Enterprise Management Specialist
    Memorial Sloan-Kettering Cancer Center, New York, N.Y. Oct 1999 - Feb 2003
    - Responsible for recommending and implementing new technologies to solve business problems (analysis, design, programming, integration and implementation)- Responsible for the availability of all hospital clinical and non-clinical systems, Network Devices and Applications- Lead Developer for Enterprise solutions using Visual Basic, EXCEL / VBA, and simple UNIX shell programming, and Structure Query Language - Lead role in the recommendation and implementation of the Biometrics NT logon Proof-of-Concept (POC) solution- Evaluated MicroStrategy 7.i Business Intelligence suite
  • Panasonic Broadcast &Television Systems Company, Secaucus, Nj
    Systems Analyst/ Senior Microstrategy Architect
    Panasonic Broadcast &Television Systems Company, Secaucus, Nj Mar 1998 - Oct 1999
    Newark, Nj, Us
    - Responsible for supporting and administrating the Business Intelligence MicroStrategy PBTS Data Warehouse- Participated in all phases of the System Development Life Cycle (SDLC), including business requirements gathering and definition, design, development, testing and deployment- Assisted DSS-Users with strategic plans by surveying areas for opportunities to increase productivity- Provided technical support for the MicroStrategy PBTS Data Warehouse Infrastructure- Responsible for developing and administrating web based MicroStrategy applications- Worked closely with the business users to define an intuitive interface that supports the users' information needs- Developed Visual Basic / VBA Excel programs to customize complex DSS reports from MicroStrategy
  • Federal Reserve Bank Of New York, New York, Ny
    Operations Support Analyst / System Architect
    Federal Reserve Bank Of New York, New York, Ny Feb 1995 - 1998
    Washington, Dc, Us
    - Analyzed, designed databases and application programs using FOXPRO, VISUAL FOXPRO and VISUAL BASIC- Assisted in the development and support of application environments throughout their lifecycle- Developed software test plans and performed user acceptance testing for the Central Bank Services Function- Analyzed business situations to provide automation plans that improve the efficiency of the Bank's daily operations- Developed, enhanced and supported the Central Bank Services Function’s PC and VAX applications

William D. Skills

Data Warehousing Business Intelligence Data Modeling Microstrategy Dashboard Databases Sdlc Enterprise Software Integration Business Analysis Unix Business Intelligence Tools Etl Software Development Life Cycle Performance Tuning Enterprise Architecture Requirements Analysis Olap Sql Db2 Data Migration Data Integration Windows Visual Basic Unix Shell Scripting Data Warehouse Architecture Architectures Dashboards Requirements Gathering Dimensional Modeling Informatica

William D. Education Details

  • Stevens Institute Of Technology, Hoboken, Nj
    Stevens Institute Of Technology, Hoboken, Nj
    Information Management
  • Microstrategy / Microsoft
    Microstrategy / Microsoft
  • Rutgers University - Newark
    Rutgers University - Newark
    Information Systems

Frequently Asked Questions about William D.

What company does William D. work for?

William D. works for Business Intelligence Consulting Group

What is William D.'s role at the current company?

William D.'s current role is Managing Partner and Business Intelligence Solutions Architect - MicroStrategy, Power BI , Tableau.

What is William D.'s email address?

William D.'s email address is wi****@****rck.com

What is William D.'s direct phone number?

William D.'s direct phone number is 888-537*****

What schools did William D. attend?

William D. attended Stevens Institute Of Technology, Hoboken, Nj, Microstrategy / Microsoft, Rutgers University - Newark.

What skills is William D. known for?

William D. has skills like Data Warehousing, Business Intelligence, Data Modeling, Microstrategy, Dashboard, Databases, Sdlc, Enterprise Software, Integration, Business Analysis, Unix, Business Intelligence Tools.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.