SUMMARY:

• Strong experience in the MicroStrategy 9.x/8.x and MicroStrategy Product Suite including MicroStrategy Intelligence Server, Administrator, Architect, Desktop, OLAP Services, Web, Mobile, Report Services, Object Manager, Distribution Services, Integrity Manager and Narrowcast Server.
• Extensive working knowledge of Micro strategy desktop. Created and modified MicroStrategy Schema objects (including Attributes, Facts, Hierarchies, Transformations), MicroStrategy Application Objects (including Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups) and Configuration Objects (including project, users, user groups, security filter).
• Expertise in creating complex reports in MicroStrategy Desktop using features like Templates, Filters, Prompts, Consolidations and Custom Groups and integrating Microstrategy reports and Designing Reports (grid, freeform, drilldown, ad hoc, OLAP cube).
• Expertise in creating Dashboards with multiple layouts using Selectors, Panels, Panel Stacks, Widgets. Designed interactive and visually stunning Dashboards using Report Services Objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations.
• Good understanding of intelligent cubes and Visual insights, and good knowledge in Analysis, design and construction of the metadata.
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy and optimization of SQL performance of the reports using the VLDB properties.
• Used Object Manager to migrate Objects from Development to Testing and to Production environment.
• Performed various MicroStrategy Administration tasks like installing, configuring, monitoring and tuning the MicroStrategy components as well as creating users, groups, security roles and setting up project access facilities.
• Experience in executing all phases of Software Development Life Cycle from Requirement Analysis to User Acceptance Testing. Additional experience includes facilitating design, testing and migration between environments.
• Very good understanding of the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables, Logical and Physical data modeling. Good knowledge of Star and Snowflake schemas.
• Good understanding of basic principles of different database management systems including Oracle, SQL Server, DB2, Teradata with respect to Enterprise Data Warehouses.
• Good understanding of RDBMS concepts and experience in Database development using SQL, PL/SQL, Stored Procedures, Stored Functions, Packages, and Triggers.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations.

TECHNICAL SKILLS:

BI Tools: MicroStrategy Desktop 9.x/8.x, MicroStrategy Architect, MicroStrategy Web MicroStrategy Intelligence Server, Administrator, Report Services, Command Manager, Object manager

OLAP Tools: Microsoft SSAS 2008, SSRS 2008, Crystal Reports

RDBMS: Oracle 11g/10g/9i, MS Access, MS SQL Server 2012,2008,2005, Teradata 12/V2R6, MySQL, IBM DB2, IBM Netezza

Operating Systems: Microsoft Windows 8/7/XP/NT, MS Windows Server 2008, UNIX, Linux

Other Tools & S/W: Informatica PowerCenter, TOAD, MS Project, MS Office

Data Modeling Tools: MS Visio, ERwin, ER/Studio, UML

Languages/Internet Tools: SQL, PL/SQL, Java, HTML, DHTML, XML

PROFESSIONAL EXPERIENCE:

MicroStrategy Consultant

Confidential, Irvine, CA.

Responsibilities:

• Involved in implementing a phase of large multi - phase project mainly focused on business reporting on orders processed through web site (Web Ordering).
• Extensively worked in defining, segmenting and prioritization of KPIs and Metrics to monitor sales performance along different dimensions.
• Created standard filters, reports as filters, prompts, metrics, Intelligent Cubes, reports based on Intelligent Cubes, documents, dashboards, derived metrics, calculated fields, KPI metrics, advanced thresholds, quick thresholds, filters based on pass-through functions and data marts as part of the development in QA and Development environments.
• Created metrics and KPIs with different level dimensionality, condition and transformations for user and business specific reporting needs and validated with SQL against DWH
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Designed and created Report Services Documents and customized them to reflect the Company's logos and color palette.
• Designed and developed dynamic dashboards with multiple layouts containing panel stacks, panels, grids and graphs on Flash and DHTML on web.
• Thoroughly tested Dimension and Fact tables for inconsistencies in relationships and suggested corrective measures.
• Suggested and implemented changes to the schema objects by careful analysis of SQL generated by Microstrategy to eliminate unwanted joins between tables.
• Introduced dedicated facts to the schema to produce results efficiently especially in count metrics.
• Designed, Developed and Validated Weekly Performance Snapshots and Consolidated Reports comparing Web Ordering to other types of ordering including Mobile Ordering and Traditional in-store ordering.
• Involved in designing and development of Executive Dashboards comprised of KPIs and Graphs to reflect Year-to-Date business performance.
• Designed Weekly Performance Snapshots and Executive Dashboards for iPad.

Environment: MicroStrategy 9.3.1 (Architect, Desktop, Web, Mobile), Windows 7, IBM Netezza

MicroStrategy Consultant

Confidential, Detroit, MI.

Responsibilities:

• Worked with business requirements analysts/subject matter experts to identify and understand requirements and produce the report design specification and estimates for the project.
• Created logical data model, recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
• Optimized the SQL performance of the reports using the VLDB properties in MicroStrategy like indexing temp tables, etc. Reduced cost of the SQL and improved the performance of longer running queries by setting appropriate VLDB properties.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for Oracle 11g and SQL hints.
• Generated MicroStrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Created advanced reports which include Advanced Prompts (Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).
• Created dynamic dashboards and scorecards to highlight KPI's and trends in market and added interactivity to visual insights. Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Created Narrowcast Server services for sending reports in PDF/ Excel formats via email to a large group of users.
• Implemented Time Based Schedules especially to generate reports to highlight performance related issues occurred during past weeks and Event Based Schedules to get triggered on after specific events.
• Performed troubleshooting on MicroStrategy Prompts, Filters, Templates, Consolidations and Custom Group objects in an enterprise data warehouse team environment.
• Used pass-through functions (apply simple and apply comp) in attributes and filters definitions and used Advanced Prompts, Conditional, Transformation metrics and Level Metrics in reports.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment, especially between Development, Testing and Production
• Developed and implemented Security Roles, User Groups and Privileges and Object Security for the developers and End users and facilitated project access accordingly.

Environment: MicroStrategy 9.3 (Administrator, Architect, Desktop, Web, Object Manager, Enterprise Manager, Distribution Services), Windows 7, MS SQL Server 2008/2012, Oracle11g

MicroStrategy Consultant

Confidential, Atlanta, GA.

Responsibilities:

• Involved in the design/development life cycle including gathering requirements from key stakeholders to understand business requirements and expectations in order to design and develop the logical and physical data models.
• Interacted with users from different functional teams when gathering requirements for developing the reports, dashboards and Key Performance Index corporate dashboards extending the contribution to overall life cycle of the business Intelligence project.
• Created new Project and project sources and worked on getting tables from the data warehouse into the MicroStrategy environment using the Warehouse Catalog.
• Analyzed logical data models, identified required data warehouse tables and columns, mapped the columns to the MicroStrategy project by creating schema objects like Attributes, Facts, Transformations, Hierarchies and Relationships and public objects.
• Used Explain plans to analyze the SQL's generated by MicroStrategy to identify the areas for performance improvement and worked with the respective teams in finding resolution.
• Fine tuned VLDB properties at different levels to increase the query performance and changed the cashing options to reduce report generation durations. Also worked with the DBA to create additional indexes in tables, resolve temporary table issues and create summary tables required.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end users were able to generate ad-hoc report by drilling up, down, within and across dimensions.
• Created transformations using transformations by tables for YTD (Year to date), and MTD (Month to date) for Time Series Analysis.
• Created Complex Reports as per Business requirements using Non-Aggregatable Metrics, Level metrics and Advanced Filters.
• Developed Scorecards and Dashboards that provide users an appealing graphical visualization of data sliced and diced along different dimensions with summary view of key metrics.
• Created services in MicroStrategy Narrowcast server using static and dynamic subscription sets.
• Extensively worked in delivering reports through MicroStrategy Office. Delivered formatted and conditional formatted reports through MicroStrategy Office.
• Involved with users to test the functionality of the reports and check for data discrepancies by comparing the data from the reports to the data extracted from querying the database.
• Created reports in Enterprise Manger to collect user statistics, these statistics were used to understand the load on the intelligent server.
• Introduced Prompts and Filters in reports to improve on-the-fly customizations in data visualization.
• Performed Administration tasks like User Creation, Creating Security roles, Access Control Lists (ACL).
• Users were given the project access mainly by using the existing Active Directory Access Control Lists.

Environment: MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Web Server, Object Manager, Office Distribution Services), MS SQL Server 2008, MS Analysis Server 2008, Windows Server 2008 Active Directory, Toad 9.7

Microstrategy Consultant

Confidential - Columbus, OH.

Responsibilities:

• Responsible for deploying a fully functional MicroStrategy environment with three tiers, enforced with proper user security while meeting performance specifications.
• Participated in the collection of initial business requirements, refining the requirements, finalizing them and documenting the specifications.
• Created reports with advanced features like Advanced Prompts (Filter Definition Prompts, Hierarchy Prompts, Level Prompt, Object Prompt, and Value Prompt) and Advanced Filters (Attribute Qualification, Set Qualification and Advanced Qualification Filters).
• Developed Reports with Data Drilling capabilities across multiple Dimensions using Desktop and Web. Reporting process was supported by Graphs and Alerts.
• Worked with ETL developers and got involved in data extraction and transformation (ETL) using Informatica tools.
• Analyzed logical data models, identified data warehouse tables and columns and mapped the columns to the Microstrategy project by creating public objects.
• Communicated with Microtrategy Technical Support Team to resolve complex configuration and report related issues and used MicroStrategy Knowledge Base extensively to search for complex problems.
• Upgraded MicroStrategy products suite from version 9.0.1 to version 9.1.2.
• Worked on the development of Dashboard reports for the Key performance Indicators for the top management through Microstrategy Report Services.
• Created users, security roles and user groups and configured the project access facilities depending on the roles.
• Created ad-hoc reports with built-in capabilities to perform drilling up, down, and across the dimensions.
• Designed and developed dynamic dashboards with multiple layouts containing grid graphs, panels, selectors, widgets, and gauges on Flash and DHTML on web.
• Additional admin responsibilities included performing weekly object migration, project duplication, maintaining schema consistency, troubleshooting issues identified in test or production environment by various teams.
• Fine-tuned VLDB settings at various levels to utilize the Teradata specific query optimizations better. These settings significantly improved the query performances of long running queries and queries that generate intermediate tales.

Environment: MicroStrategy 9.0.1 and 9.1.2 (Administrator, Architect, Desktop, Object Manager, Integrity Manager), Teradata V2R5, Informatica Power Center 8.1

Microstrategy Developer

Confidential - Wilmington, DE.

Responsibilities:

• Worked with the business analyst and stakeholders to understand requirements for report building and creating executive dashboards. Designed and built prototypes and refined them accordingly.
• Identified facts and dimensions, created hierarchies, relationships to develop a logical model.
• Designed and developed physical (dimensional) data model using star/snow flake methodologies using Erwin tool.
• Installing, Configuring of all Microstrategy products including Microstrategy Desktop, Administrator, Intelligence Server and Web Server.
• Created ODBC connections and made TCP/IP connections from web to connect to Microstrategy projects involving a 3-Tier Architecture with components comprising of Data warehouse, Metadata Repository and MicroStrategy Intelligence Server.
• Changed VLDB properties at different levels and Cache options to make the reports run faster.
• Created Microstrategy Schema objects including Facts, Attributes, Hierarchies and Transformations using MicroStrategy Architect in the metadata database to facilitate building Application objects.
• Created complex metrics with different level dimensionality, condition and transformations for user and business specific reporting needs.
• Generated advanced reports in Grid mode and Graph mode using MicroStrategy Desktop.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Narrowcast Server has been used in the various phases of Report generation namely Self-Subscription, Profile Management, Proactive Information Delivery and alerting, Content Management and Personalization.
• Trained end users on Microstrategy Web interface highlighting features like on-the-fly filters on reports, various user prompts and different drilling methods.

Environment: MicroStrategy 8.1.2 (Desktop, Web, Intelligent Server, Narrowcast Server), Oracle10 g, SQL Server 2008, Windows Server 2008, ERWin

Microstrategy Developer

Confidential, Hartford, CT

Responsibilities:

• Actively participated in requirement gathering process to collect requirements related to creation of reports and executive dashboards. Designed and built prototypes to demonstrate the look and feeling aspects of business reporting.
• Installed and configured MicroStrategy products including MicroStrategy Desktop, Administrator, Intelligence Server and Web Server.
• Worked with cross-functional teams to identify key measures and Key Performance Indicators to support business objectives and to improve decision making processes.
• Created Facts, Attributes, Transformations and Hierarchies to be used in reports and dashboards.
• Designed and created complex reports with Advanced Filters, Conditional, Transformation and Level Metrics.
• Ad-hoc reports were designed with Drilling Options (drill up, down and across).
• Designed Components, Templates, Filters to generate Reports in grid and graph mode.
• Used Prompts in Filters and Reports to enable the end-user to choose different filtering criteria each time the report is run.
• Created several Base Formulas based on available Facts and used them to create different Metrics.
• Included graphs and widgets in visually appealing Dynamic Dashboards showing Company's performance measurement indicators.
• Created different Project Sources for production, testing and development environments.
• Designed and created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.

Environment: MicroStrategy 8.1.0 (Desktop, Intelligence Server, Web and, Narrowcast Administrator), Oracle 10g, Windows 2000/NT

Microstrategy Developer

Confidential, El Dorado Hills, CA

Responsibilities:

• Interacted with business analysts, users and managers during the business requirement gathering phase to identify specific business reporting requirements.
• Created proof of concept prototype reports initially highlighting the capabilities of BI tool.
• Identified source tables and columns. Created Facts, Attributes and defined relationships between them and created Hierarchies.
• Designed and developed reports with metrics, prompts, filters, custom groups and transformations for the challenging report development.
• Extensive knowledge in creating Dynamic Enterprise Dashboards using different controls, attribute selectors, metric selectors, panel selectors, sliders, and widgets.
• Designed and created weekly and monthly summary reports providing timely business insights.
• Created Dashboards with dynamic features providing convenience of doing customized data analysis.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.

Environment: MicroStrategy 8.0.2 (Desktop, Intelligence Server, Web and, Narrowcast Administrator), Oracle 10g, Windows 2000/NT, ERWin

Database Developer

Confidential - Raleigh, NC

Responsibilities:

• Created Entity relationship diagrams(ER-Diagrams), function relationship diagrams, Dataflow Diagrams and enforced all referential integrity constraints.
• Designed and created Oracle database objects like Schemas, Tables, Indexes, Views, Triggers, Sequences, Users and Roles.
• Used SQL and PL/SQL to develop application level program units including stored procedures and custom functions.
• Designed and created user interface forms to interact with data.
• Generated daily, weekly, monthly reports as well as ad-hoc reports.
• Managed the security of the servers, creating the new logins and users, changing the roles of the users.

Environment: Oracle 9i, Oracle Forms and Reports 9i, Windows NT, Data Flow diagrams