We provide IT Staff Augmentation Services!

Microstrategy Developer/consultant Resume

5.00/5 (Submit Your Rating)

Raleigh, NC

SUMMARY

  • 8+ years of experience in Business Intelligence, ETL and Data warehousing Technologies with expertise in MicroStrategy versions 8 and 9: Intelligence Server, Administrator, Architect, Desktop Designer, MicroStrategy Web Administration, Security Administration, Object Manager, Integrity Manager, Report Services, Dashboards, Enterprise Manager and Narrowcast Server.
  • Experienced in MicroStrategy Report Services, Dynamic Dashboards, Freeform SQL, Query Optimization, Project Schema, and MicroStrategy Server Administration.
  • Extensive experience with all areas of MicroStrategy including Architecture, Dashboard development, Administration, Web and Intelligence Server monitoring/diagnostic and resource optimization.
  • Well versed with MicroStrategy 9 functionality of dynamic dashboard development, Intelligent Cube OLAP Services and in schema object creation via the Graphical Architect using Multi - data source functionality.
  • Worked on various VLDB Settings/Properties for performance tuning of reports/dashboards.
  • Experience in creation of Dynamic Enterprise Dashboards, Scorecards (KPI’s) using nested panels, report hyperlinks, various Widgets and Selectors for better understanding of Business trends.
  • Implemented optimization techniques on different Dashboards and Document Objects using best practices recommended by MicroStrategy.
  • Expert in Creating MicroStrategy reports, generic cubes and implementing MicroStrategy projects.
  • Tuning of the MicroStrategy reports using Data Mart Reports, Aggregate tables and Intelligent Cubes.
  • Worked on Conditional Metrics, Level metrics and advanced prompts for creating advanced reports.
  • Knowledge on ER Diagramming, Dimension Modeling, Star Schema and Snowflake Schema.
  • Experience following structured software development methodologies - Agile approaches.
  • Experience with Business System Support and application support.
  • Participated in demo sessions and also had hands-on experience with MicroStrategy 10.1.
  • Good Team member with the ability to motivate & lead team members, self motivated when it comes to development and task delivery.

TECHNICAL SKILLS

Operating System: Win (2003/NT/XP/VISTA/7),UNIX/Linux

Reporting Tools: MicroStrategy, Business Objects, Tableau, MSBI, QlikView Desktop, Hyperion, Crystal Reports, Workday

ETL: Informatica, Datastage

Methodologies: Agile and Waterfall

RDBMS: Oracle 10g/9i/8i, Teradata 12.0, IBM DB2 8.0, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

MicroStrategy Developer/Consultant

Responsibilities:

  • Involved in gathering of business/user requirements.
  • Architected schema objects such as attributes, facts and transformations.
  • Worked with back end Database Administrators to provide requirements for necessary backend tables.
  • Worked extensively in MicroStrategy Administration like creation of new users, roles, privileges, shared folders, access controls lists.
  • Developed basic and user-specified Metrics (level, conditional, compound).
  • Created Consolidations and Custom Groups as per the requirement.
  • Used MicroStrategy functions such as Apply Simple and Apply Comparison in metric calculations.
  • Developed Filters (relationship, comparison) for complex reports.
  • Created drill maps for end users to drill down and recover data.
  • Created a Database Instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
  • Involved in testing of the entire project when Teradata is upgraded from V2.5 to V2.6.
  • Configured Very Large Database (VLDB) Properties at different levels.
  • Created Intelligent Cubes and performed sharing to reduce the database load and decreasing the report execution time by using the cube services.

Environment: MicroStrategy 9.4, Intelligent Server, Narrowcast Server, OLAP/MOLAP Services, MicroStrategy Desktop, MicroStrategy Web, IBM DB2, Teradata V2R5/V2R6, Windows XP, Informatica Power Center, SQL Server, ER-Win.

Confidential, Union, NJ

MicroStrategy Consultant

Responsibilities:

  • Involved in the complete life cycle of the project from gathering business requirements, creating architecture for the business for Canned Reporting and Ad-Hoc reporting for Price Analysis reports.
  • Responsible for various administration tasks like user creation, Tuning, Caching, scheduling, Report optimization, creating groups and assigning ACL to users.
  • Provided leadership and direction for MicroStrategy portion of project using MicroStrategy, Teradata and Oracle.
  • Primary responsibility is to review, update and maintain MicroStrategy related system architecture to build a MicroStrategy suite of applications.
  • Transformed requirements into MicroStrategy solutions that efficiently enable expected application, reporting, and analytic capabilities to support the business and strategic initiatives of the enterprise.
  • Provided development of integrated MicroStrategy solutions, review and validation of existing reporting and new solutions to ensure continuous accuracy and front end ease-of-use.
  • Founded opportunities in the areas of user experience as well as innovative ways (R&D) to deliver powerful analytical insight.
  • Contributed to the review of test plans, test cases to ensure all requirements are covered and documents are thorough.
  • Deployed/migrated product in QA and production environment using Object Manager; served as the subject matter expert for systems in production - helping to ensure a stable, robust production environment
  • Trained QA Teams on work and usage of Integrity Manager and effective uses of Baselines for comparison.
  • Communicated across a diverse workforce to ensure work transitions effectively without interruption or incident.
  • Designed and developed database objects like tables, views and procedures in Oracle and Teradata environments.
  • Involved in Customer Support, Maintenance & Performance tuning of the project.
  • Demonstrated Complete MicroStrategy Suite (Reports, Dashboards and Report Builder) for end users.
  • Interacted with business users on regular basis to know requirements and provide technical assistance regarding problems and help with the tool.
  • Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.

Environment: MicroStrategy 9.3 (Desktop, Web, Administration), Integrity Manager, Command Manager, User Manager, Teradata 14, Teradata Studio Express, Teradata Client 13.10, Oracle 11g, Linux, Oracle SQL developer, Windows,Datastage.

Confidential, Keene, NH

MicroStrategy Developer

Responsibilities:

  • Extensive interaction with the Database experts to understand the Source System and efficient translation of technical data to Business terms through self-developed design templates.
  • Helped in translating the requirements of Dimensional and Relational Models and ran scripts for building metadata and defined the lookup and facts tables for application in the MicroStrategy Desktop, Web.
  • Interacted with the data management group related to the Physical Structure of the Data mart, for sizing the data mart and to add the data mart into the integrated data warehouse.
  • Developed a customized solution for exporting report data into Excel and Text from Actuate Report.
  • Created MicroStrategy schema and public objects for generating reports and used MicroStrategy desktop to build and generate the advanced reports in grid, graph mode.

Environment: MicroStrategy8.0/7.5.2,Desktop, Architect, Web, Intelligence Server, and Object Manager, Narrowcast Sever, PL/SQL, Teradata,IBM DB2, Oracle 8i, SQL loader.

Confidential

MicroStrategy/ Datastage Developer

Responsibilities:

  • Responsible for the Creation of Project source and projects.
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups & Consolidations and other objects.
  • Responsible for designing the Reports as per the user requirement.
  • Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
  • Monitoring the scheduled reports and doing the performance tuning.
  • Creating the test cases for each report and cross verifying the outputs.
  • Extensively created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other tools.
  • Responsible for the Creation of Schedules and Subscriptions for Report deliveries to emails using MSTR Desktop and MSTR Web.
  • Responsible for sending reports to the user using MSTR Office and also worked in creating the URLs to generate the Reports to Mobile/iPad using Mobile Configuration in Web.
  • Administering on User Manager, enabling/disabling the User in Standard and LDAP Authentications.
  • Responsible for the Creating Users and User Groups under LDAP Authentication mode and assigning the projects and security roles.
  • Modifying the privileges to the users for the projects like enabling/disabling POWER USERS and other Standard User privileges.
  • Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.
  • Supporting the existing projects and enhancing the reports on requirement.
  • Manipulating reports, documents and detail analysis of complete business with special attention to Key Performance Indicators.
  • Providing knowledge to Users both in MSTR Desktop and Web.
  • Played major roles like Administrator/Architect/Developer in MSTR Desktop

Environment: MicroStrategy 9.2.1, QlikView, Datastage 7.5.2, Oracle 9

Confidential

MicroStrategy/ Hyperion Developer

Responsibilities:

  • Understanding and validating business requirement and data warehouse schema and do logical data modeling for MicroStrategy.
  • Doing report design and development as per the requirement specification.
  • Creating reports, documents and detail analysis of complete business with special attention to Key Performance Indicators.
  • Created schema objects like attributes, facts and logical tables using MicroStrategy Architect rights
  • Created public objects like Metrics, Filters, prompts, custom groups and consolidations using MicroStrategy developer rights
  • Created Dashboards extensively using the Panel stacks, selectors and many more functional tools.
  • Join in daily standup meetings with Project manager, business analyst, ETL team, data molders, testing teamto discuss the user requirements and status updates.
  • Supporting the Project team in SIT and UAT testing.
  • Worked in a Scrum Agile process with two week iterations delivering documents/report and dashboard at each iteration.
  • Working closely with ETL team for collecting data and testing team for resolving defects.

Environment: MicroStrategy 9, Hyperion 9, Crystal Reports, IBM DB2, Teradata, SQL Server.

We'd love your feedback!