We provide IT Staff Augmentation Services!

Senior Microstrategy Architect And Reporting Lead Consultant Resume

4.00/5 (Submit Your Rating)

Sunnyvale, CaliforniA

SUMMARY:

  • Manager, Business Intelligence |Business Intelligence Leader | VP, Business Intelligence | Director, Business Intelligence
  • MicroStrategy 7.2 - 10.4 | Business Objects XI R3 | Oracle 7 - 11g | SQL, SQL Plus, PL/SQL | SQL Server | Personal Computers, Intel Servers | LINUX | iPhone, iPad, Android
  • MicroStrategy Reporting Lead | MicroStrategy Mobile Lead | Senior Consultant, Business Intelligence Architect | MicroStrategy Custom Training Creator | Data Warehouse, Data Mart Creator | Streamlined Oracle Administration | Optimized Oracle Databases by 40% | Improved ETL Success by 35% | Improved ETL Time by 62%

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, California

Senior MicroStrategy Architect and Reporting Lead Consultant

Responsibilities:

  • Acted as client liaison to support ad-hoc demonstrations and interactive design sessions with client on 4 projects.
  • Led a team of 1 onshore and 3 offshore MicroStrategy developers.
  • Acted as a part analyst, developer, and lead working with clients extensively on 4 projects.
  • Created 12,000 supporting metadata objects, reports, and dashboards using the latest version of MicroStrategy.

Confidential, New York,

Senior Mobile Business Intelligence Consultant

Responsibilities:

  • Ensured that the use of business intelligence applications enhanced business decision-making capabilities with 3 mobile applications.
  • Familiar with a variety of the field's concepts, practices, and procedures. Relied on extensive experience and judgment to plan and accomplish goals with 3 mobile applications.
  • A wide degree of creativity and latitude was expected when creating 10 to 20 graphic images.
  • Performed a variety of tasks; fixed 5 to 10 bugs.

Confidential, Parsippany, New Jersey

Manager, Business Intelligence Development

Responsibilities:

  • Managed a team of 3 to 4 MicroStrategy Developers and subsequent development of applications, dashboards, reports, and tools to enable the operational teams to interpret an opportunity, identify a problem or understand more about a business scenario.
  • Was also responsible for the team’s development pipeline as well as holding each developer accountable to timelines, budget, deliverables and high standards. Quality improved 50%.
  • This unique position is responsible for mentoring and developing the BI Team of 20 with regards to functional capabilities and training on new features of the MicroStrategy toolset.
  • Worked closely with the Enterprise Data Architecture team and Database Administrators as an integral contributor to the model that promotes a service based, centralized solution that correlates multiple KPI’s and exposes through a single point of access for 25 to 50 projects.

Confidential, Rye Brook, New York

Senior Consultant, Business Intelligence Architect

Responsibilities:

  • Responsible for leading the strategic design and maintenance of business intelligence applications.
  • Identifies, researches, and resolves technical problems.
  • Familiar with a variety of the field's concepts, practices, and procedures.
  • Relies on extensive experience and judgment to plan and accomplish goals.
  • Leads and directs the work of others.
  • Obtained MicroStrategy 9 Certified Project Designer (CPD), Certified Report Developer (CRD), Certified Document Developer (CDD), MicroStrategy Certified Developer (MCD), MicroStrategy Certified Engines Specialist (CES), the MicroStrategy Certified Platform Administrator (CPA), and MicroStrategy Certified Engineering Principal (MCEP) certifications.

Confidential, Southborough, Massachusetts

Responsibilities:

  • Created a MicroStrategy Mobile iPad executive dashboard based on Revenue, Gross Margin, Backorder, Booking and Shipping, and Cost Center subject areas.
  • The subject areas included a variety of key performance indicators represented by simple to advanced visualizations.
  • Performance objectives were achieved by implementing MicroStrategy Intelligent Cubes.
  • Mentored staff on dashboard creation, iPad implementation, and iCube implementation.

Confidential, Waltham, Massachusetts

Responsibilities:

  • The MicroStrategy Administrator requested an extensive analysis of three change management techniques they were considering streamlining their growing 9.2.1 environment due to limited staff. Shortcuts, Hybrid, and Without Shortcuts. Outlined the different strategies for managing user access to MicroStrategy Objects and the associated workflows needed to carry out typical tasks in the context of each strategy for their environment. The Hybrid approach was the most efficient for the administrator.
  • Composed two custom MicroStrategy Web training classes that are administered by Brandeis staff, Consumer or End User and Creator or Power User Training. The custom training cost 50% less than directly from MicroStrategy. The Consumer Training consisted of Getting Started, Executing Reports & Documents, Manipulating an Executed Report, and Other Interactions with a Report. The Creator Training consisted of Attributes and Hierarchies, Modifying Existing Reports, Creating Existing Reports, Ad Hoc Analysis Using Visual Insight, and working with Custom Groups, Filters, and Prompts.
  • Based on the previous MicroStrategy Change Management Recommendation assignment, composed “MicroStrategy Object Manager Recommendations for Confidential ”. The custom training cost 50% less than directly from MicroStrategy. This document summarizes The Application Lifecycle, MicroStrategy’s Methodology, Overview of Object Manager and different strategies for using Object Manager to duplicate projects or propagate objects from a single origin project to additional projects.

Confidential, Norwalk, Connecticut

Responsibilities:

  • Led a team of 3 junior to senior MicroStrategy resources from analysis through implementation. Completed this very aggressive, short timeline project before deadline and under budget.
  • Identified and corrected 5 MicroStrategy hierarchy architecture flaws correcting many errant grid reports. Identified and corrected 3 attributes causing inefficient query generation and inaccurate results.
  • Provided expertise in the development of MicroStrategy Dashboards, functionality, designed and quoted effort for the new version(s) of the Sales and Marketing dashboard consisting of 30 pages.

Confidential, New York

Responsibilities:

  • Architected the solution from the analysis, MicroStrategy multi-fact POC, logical design, conformed dimension database design, database implementation, ETL design, and MicroStrategy design through MicroStrategy implementation enabling enhanced analysis and insight for customers to increase customer base and volume by 10%.
  • Indication of Interest (IOI) Messaging System Reporting Migration: Performed analysis and design for migrating the semi-manual Excel statistical reporting to MicroStrategy enabling enhanced analysis and insight to increase customer base and volume by 10%.
  • Connections Reporting Migration: Performed analysis, design, and POC for migrating the semi-manual Excel statistical reporting to MicroStrategy enabling enhanced analysis and insight to increase customer base and volume by 10%.

Confidential, White Plains, New York

Responsibilities:

  • Sellers Performance Report Book Automation: Converted a 10-tab, 15 report Excel spreadsheet to MicroStrategy 8 Report Services Document. It took the SME about a week or two to manually create the entire report. Completely automated the process by creating this report in MicroStrategy Web. This resulted in savings of multiple staff weeks as now the report is available the instant the books are closed at the end of the month.
  • Sales Performance Report Book Automation: Converted a 15 tab, 55 reports, 39 graphs Excel spreadsheet to MicroStrategy 8 Report Services Document. Originally this report was put together manually by a subject matter expert by running queries directly against the warehouse. Once again completely automated the process by creating this report in MicroStrategy Web. The conversion involved evaluating the client’s current MicroStrategy implementation and adding more attributes and metrics as needed for the report. The task consisted of creating some very complex Report Services Document structures to meet the client’s formatting needs.

Confidential, Parsippany, New Jersey

Business Intelligence Analyst

Responsibilities:

  • Improved data load success rate from 60% to 95%, a 35% improvement, by implementing configuration changes and introducing daily maintenance.
  • Reduced data load time from 13 hrs. to 5 hrs., a 62% improvement, by upgrading hardware, O/S, Ascential DataStage, MicroStrategy, and additional configuration changes.

We'd love your feedback!