We provide IT Staff Augmentation Services!

Sr. Microstrategy Developer Resume

3.00/5 (Submit Your Rating)

Grand Rapids, MI

Summary

  • 6+ years of strong experience in Business Intelligence in designing and implementing Web based and Stand alone software application with major focus on Data Warehousing and Database Applications.
  • 5 years of extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.i/7.5/8.0/8.1/9.0/9.0.1, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
  • Expertise in Desktop creating and integrating Microstrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
  • Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations
  • Worked extensively on VLDB Properties for performance tuning.
  • Extensively worked on creating Dynamic Dashboards with multi layout and used custom Widgets built on flex for specialized dashboard.
  • Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations.
  • Strong Data modeling (Logical and Physical) experience with high proficiency in using ERwin for Dimensional Modeling (Star, Snowflake schemas) and Entity-Relationship Modeling.
  • Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
  • Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
  • Extensive knowledge of SQL,PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2005/2008

Eduaction – Bachelor of Mechanical Engineering

SKILL SET:
OLAP Tools : Microstrategy, Business Objects, MS Analysis Services, Informatica
Databases : Oracle 8i/9i/10g,Teradata,Netizza MS SQL Server 6.5, Db2 and MS Access 
Tools : Toad, Erwin
Operating Systems : Windows NT 4.0 /NT Server/2000/XP Pro/2003 Server, Unix
Languages : Visual Basic 6, C, SQL/PLSQL

Confidential, Grand Rapids, MI Oct’10 – Till date 
Sr. MicroStrategy Developer

Responsibilities:

  • Involved in the documentation of technical specifications of the Sales and Inventory Project.
  • Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
  • Created different Project Sources for different environments like production, testing and development.
  • Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
  • Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
  • Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
  • Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
  • Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
  • Created Ad-hoc reports by gathering specific requirements from the different users.
  • Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
  • Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
  • Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
  • Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, Information objects.
  • Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that particular user.
  • Worked on the excel formatting, macros and templates of the documents which are used in different services.
  • Exported data from Teradata using Fast Export utility.
  • Experience in using Teradata utilities such as Fastload, Multiload and Fast Export.
  • Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
  • Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.0/9.0.1 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Teradata, Narrowcast Server, Oracle 9i, Informatica power center 6.2, Toad and Windows XP Professional.

Confidential, Grand Rapids Nov’09 – Sep’10 
Sr. MicroStrategy Developer

Responsibilities:

  • Involved in design/development life cycle including gathering requirements ,user interaction and report design and development
  • Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
  • Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
  • Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
  • Created report services documents for guest count and Sales analysis.
  • Developed a web course and took several classes to train the end users to efficiently use MSTR.
  • Created several data marts using MSTR for different tools to access large datasets.
  • Involved in Upgrade of MicroStrategy environment from 8.1 to 9
  • Created Subscription sets, documents, publications and services for delivery of reports through Narrowcast.
  • Validated end user requirements using Microstrategy tools.
  • Created Question Objects for Personalized execution.
  • Extensively involved in Troubleshooting of Narrowcast services delivery.
  • Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
  • Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
  • Worked with end users along with Business Analysts to build reports and dynamic dashboards.
  • Worked with the DBA on issues of database performance and security.
  • Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
  • Involved extensively in the overall lifecycle of the Data Warehouse integration project

Environment: MicroStrategy 9/8.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), SQL Assistant, SQL Server, Oracle 10g

Confidential, Ann Arbor, MI Mar’08 – Oct ’09
Microstrategy Consultant

Responsibilities:

  • Responsible for gathering and refining business requirements from the Business users.
  • Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies
  • Responsible for creating Metrics, Filters, Custom Groups, Prompts using Microstrategy Desktop
  • Configured the Narrowcast Server for the Microstrategy Environment
  • Used the Narrowcast Administrator for administering users.
  • Created the Publications, Information Objects & Services in the Narrowcast application
  • Created Users, roles & privileges in the Microstrategy Environment using the Administrator
  • Responsible for maintaining I server.
  • Troubleshooting inconsistencies in the Metadata using ScanMD
  • Used the Object Manager to migrate objects to different environments.
  • Worked on cost containment dashboard project for executive users to see penetration, discounts and performance.
  • Worked on Internet Dashboard project which points to operating system for real time analysis report on claim process.
  • Heavily worked with the end users to finalize the Dashboard layouts and also worked on fine detail formatting for a desired look and feel.
  • Involved in Testing and Data validation of Reports
  • Involved in End-User training, Support and Maintenance.
  • Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment
  • Very good in using the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary.
  • Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, week to year and effectively used them with the metrics.
  • Optimized Query Performance by using VLDB settings
  • Involved in Business Intelligence tool Product Evaluation
  • Worked on standardizing Microstrategy environment
  • Responsible for Job Monitoring and maintaining the cache on the I Server

Environment: Oracle10g, SQL server, Informatica, MicroStrategy 8.0.2(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Toad 8.6.1

Confidential, Hercules, CA Nov’07 – Feb’08 
Senior MicroStrategy Developer

Responsibilities:

  • Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
  • Generated status reports after performing thorough research in order to discuss the issues related to Warehouse tables, Zeroes/Nulls, missing columns and naming conventions etc.
  • Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
  • Used project merge wizard and user merge wizard to merge projects and merging users & groups in Object Manager.
  • Created Transformations (table based, formula based) for using in comparative reports like sales of various pharmaceutical products this year to last year (year to date and month to date).
  • Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment.
  • Converted existing interactive reports with prompts to non-prompted reports for Narrow casting.
  • Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
  • Exported data from Teradata using Fast Export utility.
  • Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.
  • Involved in creating user groups and security filters for users and assign privileges.

Environment: MicroStrategy 8.0.3/8.1(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata V2R6, Teradata SQL Assistant, SQL Server, Brio. Cognos, Crystal Reports, Oracle 10g, Informatica

Confidential, Scottsdale, AZ Jan’07 – Oct ’07 
MicroStrategy Report Developer/ Quality Analyst

Responsibilities:

  • Created users, roles & privileges in the Microstrategy Environment
  • Collected business requirements from users by understanding the Source System (OLTP) and interacting with the users
  • Responsible for maintaining the Intelligence Server including the Metadata repositories for different environments
  • Was responsible for troubleshooting the I Server issues.
  • Responsible for setting the Microstrategy Environment for any Proto type projects
  • Responsible for scheduling the user jobs, creating schedules for both Web & Narrowcast modules
  • Performed complete production support for the Microstrategy Environment, maintaining I server, weekly reboots of the I server etc
  • Responsible for maintaining the Microstrategy Web Servers
  • Configured the Intelligence Server settings, setting up the DSN Connections
  • Extensively used Object Manager to migrate objects from DEV to QA & Production
  • Was responsible for setting up the Narrowcast Server environment, configuring the execution engine etc
  • Was responsible for Job Monitoring and maintaining the cache on the I Server

Environment: Microstrategy7.5/8.0 (Desktop, Administrator, Intelligence Server, Web), Informatica5.0, SQLServer2000, Teradata V2R5,Windows NT 4.0

Confidential, Los Angeles, CA Aug’06 - Dec’07
Microstrategy Consultant

Responsibilities:

  • Involved in Data Modeling and Data Warehousing Using Multi Dimensional Model, Star and Snow Flake Schemas.
  • Identified and defined Facts, Attributes, Hierarchies and Relationships.
  • Running Scripts for building Metadata and define the lookup and facts tables for use in the MicroStrategy Agent.
  • Using MicroStrategy Agent (Templates, Filters, Metrics) to generate advanced reports in grid, graph, and SQL mode, 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 dimension or anywhere.
  • Enterprise manager was used to validate the data presented in the desktop.
  • Various queries were written for optimization, exploited the indexing
  • With SQL Server 2000 different features were used like user-defined functions, enhancements to triggers, cascading constraint capabilities, indexed views and view enhancements, updateable union views called distributed partitioned views, support for collations, extensions to property definitions, new built-in functions.
  • Developed PL/SQL Business Functions, which were used with MicroStrategy Reports.
  • Created MicroStrategy Filters, Prompts, Drill Maps, Transformations, Documents, Facts, Attributes, Hierarchies etc. for Developing Project.
  • Creating complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality and conditional, generating Data Marts with per and post SQL for the Data Mart Tables.
  • Creating all possible Metrics for users to build there owns reports on Web by creating there own Templates and filters and use the available Metrics.
  • Using Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
  • Designed and developed Web Reports and worked in MicroStrategy Web Customization
  • Caching Reports in the Intelligence Server daily, enabling user to run the report immediately.

Environment: MicroStrategy 7.2.1/7.5 (Desktop, Administrator, Intelligence Server, Web), MicroStrategy Architect 7.2.1, SQL Server 2000, ODBC Driver 8i, Windows NT 4.0.

We'd love your feedback!