Jeremy Brown

I’m a Business Intelligence (BI), Data Analytics, and Enterprise reporting architect and developer.  I have 23 years of experience within information technology, and 20 years in Business Intelligence as a MicroStrategy expert.  Architecting, designing, developing, testing, and implementing web and mobile solutions for dozens of companies worldwide.  Current on the latest version of MicroStrategy, and certified in v9 and 10.  Some of the companies I’ve implemented MicroStrategy, data warehouse, and analytics solutions for include Coca-Cola, The Home Depot, Merck Pharmaceuticals, Kindred Healthcare (Gentiva), BBVA Compass Bank, AT&T, Otter Products, Neiman Marcus, Macy’s Inc., AllianceBernStein, AutoTrade, and many more.  I have 20 years of experience with data warehouses, various database technologies, strong SQL skills, and an analytical mindset.

KEY SKILLS

• Twenty-three years of experience across many industries in Technology.  They include Automotive, Banking, Call Center, Financial Services, Healthcare, Insurance, Retail, Services, and Telecommunications, and more
• Twenty years of experience as a MicroStrategy expert  installing and monitoring un-clustered and clustered MicroStrategy environments. Architecting schema objects used by the MicroStrategy SQL engine to create optimal SQL. There are times when VLDB property settings at the report and project level are required, and database indexes or views are necessary for performance tuning
• Architected, developed, unit tested, researched and resolved issues that occurred during UAT, performance tested, implemented, installed, upgraded, administered, performance tuned both MicroStrategy objects, data warehouse issues, created and monitored system workflows, report, documents, and intelligent cube caches.  Modified Intelligence, web, mobile, narrowcast, and  library settings when issues arose
• Configure the MicroStrategy metadata, statistics, and history list databases.  Install and setup Enterprise Manager within the project level settings, and schedule jobs to load the statistics data into the statistics database repository.  Configure the history list database to be used for cache reports, documents, or dossiers for future viewing
• Certified MicroStrategy Architect, Platform Administrator, Project Designer, Report Developer, Enterprise Mobility Developer, Advanced Analytics, Performance Tuning, Document
• Created MicroStrategy packages using Object Manager for both administration and project changes to move objects between environments.  Always create an undo package in case the modified objects require a roll-back
• Developed and supported dozens of MicroStrategy projects from requirements to post deployment support
• Design and support data warehouses, data marts, and data lakes using various database platforms
• Data mapped dozens of source systems extracted data columns to the ETL staging tables where the transformation logic occurs, to the data warehouse fact and dimension tables and columns, and finally the schema objects in MicroStrategy that reference the data warehouse tables and columns, or views and columns
• Strong SQL skills used to validate the data displayed on reports, report services documents, dossiers, and many web-based or mobile applications developed in MicroStrategy.  Verify data in MicroStrategy against a data warehouse, data mart, or data lakes
• Performed research on data and reporting solutions using the Microsoft Azure cloud.  Provided recommendations SaaS tools within Azure.  Clients that already have ETL processes in Microsoft SSIS could continue to use those processes in Azure.  Data Factory is another SaaS tool within Azure that can be used to load data nightly and even near real-time throughout the day.  Provided recommendations on reporting tool software.  Recommended that for each tool such as PowerBI, Tableau, MicroStrategy, QlikView, Incorta, etc., they list the pros and cons for each reporting tool, in order to choose the best tool for their organization 
• Lead the discovery and requirements gathering for dozens of projects and web-based and phone and tablet mobile applications
• Estimated dozens of projects and applications scope, time, budget, and resources.  Led initiatives to keep the projects on track.  Change requests were always agreed upon via a new work order
• Solutions Architect, Technical Leader, Mentor, and Manager, leading projects using agile and waterfall methodologies across all phases of the SDLC
•  Knowledge and some experience with other reporting tools, such as Tableau, PowerBI, and Incorta.  Used Jira, Confluence, Slack, SharePoint, Microsoft Office 365, MAC OS tools

PROFESSIONAL ACHIEVEMENTS

• Architected, designed, developed, tested, and deployed an award winning MicroStrategy iPad application for The Coca-Cola Company’s McDonald’s Division. The iPad reduces the time creating manual reports 100%.  This allowed the MCOMs to breeze though semi-annual reporting updates with each franchisee in under 20 minutes versus a few hours.  It allowed for MCOMs to spend more time selling versus spending 20 hours or more each week gathering data and creating presentations for each franchisee in their district.  The paper bases reporting only allowed for specific KPIs.  The new MicroStrategy iPad application provided all of the data currently presented, and  provided and much more functionality never viewed before such as core brands and beverages trend analysis MoM and YOY.   Key KPI’s comparing their restaurants in to other restaurants they franchised.  Also comparing their restaurants to others within their district, region, and at the national level. The Coca-Cola Company McDonald’s iPad application won best-in-class mobile application at the MicroStrategy World Convention in 2013
• Lead Solutions Architect for a new MicroStrategy iPad application for AllianceBernStein. During the discovery and requirements gathering phase I documented 900 hundred requirements.  Some key features of the mobile application included complex write-back functionality to Salesforce and Salesforce data sourced back into the mobile application near real-time. The AllianceBernstein solution won best-in-class mobile application at the MicroStrategy World Convention in 2020. In addition, it received an award at Dreamforce 2020, which is Salesforce’s annual convention

Bachelor’s of Science - Business with management information systems concentration from

Liberty University, Virginia from August 1996 - Graduated in May 2000