We provide IT Staff Augmentation Services!

Microstrategy Developer Resume

2.00 Rating

Dallas, TX

SUMMARY:

  • Over 6+ years of strong experience in design, development and implementation of Business Intelligence Solutions, Client/Server, Internet/Intranet and Web based applications that includes over 4+ years of expertise in Data Warehousing and Reporting applications.
  • Solid experience in business requirements analysis, development, testing. Business Intelligence applications.
  • Extensive experience in developing Business Intelligence applications for cross - functional teams on multiple projects and across multiple environments using MicroStrategy
  • Knowledge of Data Warehousing concepts, Dimensional, Logical and Physical data modeling, Star and Snow Flake Schemas, Slowly Changing Dimensions and ROLAP/MOLAP.
  • Expertise in building MicroStrategy Business Intelligence Projects and creating Schema and Application Objects like Attributes, Facts, Hierarchies, Filters, Metrics, Prompts, Reports, Documents, dynamic Dashboards for day-to-day fact-based decision making and ad-hoc analysis.
  • 5+ years of experience in developing SQL on databases such as Oracle, SQL Server.
  • Good working knowledge of Extraction, Transformation, and Loading of data from different sources using ETL tools such as Informatica, Oracle Warehouse Builder.
  • Working familiarity with full Software Development Life Cycle (SDLC) using various development methodologies like Agile

SKILL:

Business Intelligence: MicroStrategy 9/8.1.2 (MicroStrategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Narrowcast Server.

Languages: C, SQL

Operating Systems: MS-DOS, Windows 98/NT/2000/XP/VISTA/7.

Web Technologies: MS Front Page, HTML.

Databases: Oracle 10g/9i, SQL Server 2005

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Microstrategy Developer

Responsibilities:

  • Analyzed the business requirements identifying the requirements reviewing and communicating with business.
  • Worked with Data Architect in Designing the Data Model.
  • Installation of Microstrategy Desktop and creating a Microstrategy project.
  • Creating Attributes, Facts and relationship between attributes using Microstrategy Architect.
  • Importing tables using Warehouse catalog and Creating Logical Tables.
  • Generated and implemented Microstrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using Microstrategy Architect.
  • Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
  • Analyzed and developed the new objects in Dev environment and after testing the objects and reports migrated to Production Environment
  • Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
  • Defining Drill Hierarchies and creating relationship between attributes.
  • Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
  • Created reports using complex filters and compound metrics and prompts.
  • Creating reports from intelligent cubes, Datamart Reports.
  • Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
  • Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
  • Involved in creating security filters to end users to access data based on their privileges.
  • Created services using Subscription sets, Schedules, and Information Objects.
  • Designed and developed the Dynamic dashboards.
  • Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
  • Extensively used report services to create dashboards to create summary level reports using multiple datasets.
  • Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.

Environment: Microstrategy 9.2.1, Report Services, Microstrategy Desktop, Microstrategy Web, Mobile, Microstrategy Dashboards, MS-Excel, Toad, Oracle 10g.

Confidential, New York, NY

Microstrategy Consultant

Responsibilities:

  • Worked with business analysts to baseline the reporting requirements.
  • Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer.
  • Worked with data architects on data needed for testing the reports and dashboards.
  • Extensively worked with Microstrategy architect to develop schema objects such as, attribute, facts, hierarchies, consolidations and transformations etc.
  • Extensively used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups etc.
  • Createddrill mapsfor end users to drill down and recover data.
  • Extensively worked with Microstrategy Intelligence Server, MicroStrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.
  • Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • Took part in design and development of Data marts and integrating them with Data warehouse.
  • Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
  • Designed and DevelopedMicrostrategy Dashboards using customized Widgets.
  • Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
  • Extensively used report services to create dashboards to create summary level reports using multiple datasets.
  • Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
  • Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
  • Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.

Environment: Microstrategy 9.0.2 (Administrator, Architect, Desktop, Web), Windows XP, MicroStrategy Dashboard, Oracle 10g, Toad for Oracle.

Confidential, Stamford, CT

Microstrategy Developer

Responsibilities:

  • Involved in gathering business requirements and documenting specifications.
  • Creating Views in the database and Logical Views in the MicroStrategy.
  • Extensively worked with MicroStrategy Desktop. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
  • Worked on creating MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
  • Developed, implemented and maintained unit tests for applications.
  • Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
  • Tuning of the MicroStrategy Reports using Data Mart Reports, Aggregatable Tables and Intelligent Cubes.
  • Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
  • Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
  • Expertise on Partition Mapping concept in Microstrategywhich will improve the performance.
  • Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
  • Expertise in developing the dashboards and having goodknowledge in using widgets and all components of dashboards.
  • Expertise in using the Architect in desktop.
  • Proficient in creating the Drill and User Hierarchies.
  • Having knowledge in developing the Expression and Table based Transformations.
  • Expertise in creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
  • Expertise in Monitoring the Jobs, Caches and Intelligent Cube
  • Having good knowledge in Creating Database Instances.

Environment: Microstrategy 9.01 (Administrator, Architect, Desktop, Narrowcast Server) MicroStrategy Narrowcast server, Windows XP, MicroStrategy Dashboard

Confidential, Dallas, TX

MicroStrategy Developer

Responsibilities:

  • Worked as a MicroStrategy developer for the users to support various reporting needs for the business.
  • Involved in gathering business requirements and documenting specifications.
  • Created the Metadata & Statistic tables for MicroStrategy projects.
  • Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
  • Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
  • Extensively worked on Report Services to create performance dashboard reporting.
  • Createddrill mapsfor end users to drill down and recover data.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Report Services), Oracle.

Confidential

Business Intelligence Analyst

Responsibilities:

  • Worked as a MicroStrategy analyst for the financial Users to support various reporting needs for the business.
  • Involved in gathering business requirements and documenting specifications.
  • Created the Metadata & Statistic tables for MicroStrategy projects.
  • Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
  • Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
  • Extensively worked on Report Services to create performance dashboard reporting.
  • Createddrill mapsfor end users to drill down and recover data.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
  • Involved in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
  • Worked on Enterprise manager to generate reports in enterprise manager
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services).

We'd love your feedback!