William D. Email & Phone Number

Philadelphia, Pa, Us

- 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

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

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

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

- 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

- 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

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

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

Master Of Science, Information Management

Education record

Bachelor Of Arts, Information Systems