Big Data Architect, remediated ETL performance problems in their Cloudera Hadoop Data Lake. Identified long running queries, diagnosed, performed SQL coding changes, and generated performance improvement statistics.

MicroStrategy Architect, converted the CRO Enterprise Reporting, Mandate & Scale Level Dashboard to use MicroStrategy Dossiers and access a Cloudera Hadoop.

Combined data from three Surety Bond Insurance Systems and create a SQL Server Data Mart. Used best practices for data modeling and ETL. Created MicroStrategy architecture, standard reports, dashboards, and setup self-service in an enterprise environment.

Worked with data engineers to create a schema and applicable objects to build and support dynamic reports and data visualizations in MicroStrategy.

remediated ETL performance problems in their Cloudera Hadoop Data Lake.Identified long running queries, diagnosed, performed SQL coding changes, and generated performanceimprovement statistics.

Used best practices for data modeling and ETL. Created MicroStrategy architecture, standard reports,dashboards, and setup self-service in an enterprise environment.

Leverage mybackground in SQL, database, and data warehouse concepts.

based on Revenue, Gross Margin, Backorder,Booking and Shipping, and Cost Center subject areas.

Recommend to the MicroStrategy Administrator an analysis of three change management techniquesunder consideration for streamlining their growing 9.2.1 environment due to limited staff.Project… Compose two custom MicroStrategy Web training classes to be administered by Brandeis staff,Consumer or End User and Creator or Power User Training.Project…Compose a Custom MicroStrategy Object Manager Training based on the previousMicroStrategy Change Management Recommendation assignment.

Completed this very aggressive, shorttimeline project before the deadline and under budget.Project…Troubleshoot MicroStrategy hierarchy architecture flaws correcting many errant grid reports.Identified and corrected 3 attributes causing inefficient query generation and inaccurate results.Project…Developed MicroStrategy sales and marketing dashboard, consisting of 30 pages.

Project… Perform analysis and design for migrating the semi-manual Excel Indication of Interest (IOI)Messaging statistical reporting system to MicroStrategy.Project… Perform analysis, design, and POC for migrating the semi-manual Excel Connections Reportingstatistical system to MicroStrategy.

Cut prep time from 2 weeks to instantly available at month end.Project…Sales Performance Report Book Automation: Converted a 15 tab, 55 reports, 39 graphs Excelspreadsheet to MicroStrategy. The task consisted of creating some very complex Report ServicesDocument structures to meet the clients formatting needs.

(IBM AIX, MS Access Data Conversion (IBM AIX, ACROS Organics Quote andOrder Application, Fisher Chemical Quote and Order Application.