We provide IT Staff Augmentation Services!

Sr. Microstrategy Consultant Resume

Seattle, WA

SUMMARY:

  • Over 7 years of IT experience - Implementation of Microstrategy Suite, Reporting services,OLAP environments and tools, along with strong analytical skills.
  • Over 6 years’ experience with PL/SQL and oracle tools.
  • Experience in MicroStrategy tool Suite with MicroStrategy Intelligence Server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, Microstrategy scematic modelling, MicroStrategy OLAP Provider, MicroStrategy Web services, Microstrategy Narrowcast Server, Microstrategy SDK.
  • Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
  • Implemented proactive delivery reports and implemented the business intelligence solutions using MicroStrategy Narrowcast Server.
  • Extensive Experience in creation of Dashboards which helps in better understanding of the Business trends.
  • Extensive work experience with Ad hoc reporting using SQL queries and standard reporting environment.
  • Experience in Designing Data Marts using different multi-dimensional modeling techniques such as Star Schema and Snowflake Schema, FACT and Dimensional tables, Logical and Physical data modeling.
  • System Optimization, performance monitoring and tuning experience in the BI application.
  • Exposure to client interaction, user-requirement analysis and User support.
  • Team player with good interpersonal and communication skills and the ability to work in a team environment.
  • Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy 9.2.1/9.0.1/8.1.1/8.0.1 (Administrator, Desktop, Web, Architect), Intelligent Server, Narrowcast Server, SSRS.

ETL Tools: Informatica 9.0/8.1/7.1 (Power Center, Power Mart), SSIS.

Databases: DB2 UDB, SAP ABAP

Programming Languages: C, C++, PL/SQL.

Web Technologies: HTML, XML, CSS.

Applications: MS Office (Access, Word, Excel, Visio), Rational Rose.

Operating Systems: Mac OS X 10.8/10.7/10.6, Windows 7/Vista/XP/NT/98/95, MS-DOS, LINUX.

Certigication: Six Sigma Green BeltTrained in SAP ABAP in Siemens

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. MicroStrategy Consultant

Responsibilities:

  • Designed Microstrategy Mobile dashboards.
  • Used Narrowcast server for customized mail to be sent to the merchants on daily basis.
  • Created subtotal, metrics for the different dimensionality.
  • Analyze the SQL and perform tuning of the report.
  • Worked on FFSQL ( FreeForm SQL) Reports, to check the performance of the report.
  • Worked on database like Teradata, DB2. Worked with Hadoop data too.
  • Designed Retail related dashboards with different Level metrics and threshold levels and view for daily view, weekly and monthly.
  • Designed Dashboards using Microstrategy web services and creating multiple panel stacks, selectors and filters.
  • Created various Monthly Dynamic Dashboard documents for the decision makers with multiple panel stacks, selectors and customized widgets.
  • Validating the SQL reports by performance testing them.
  • Using MicroStrategy Web Services for System Reliability Checks
  • Created Intelligent Cubes and good understanding in data mart design.
  • Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
  • Deployed MSTR Dashboard in third party portal.
  • Deployed various Visualization widgets in 10.3
  • Upgraded from 9.5 to 10.3 Version

Environment: MicroStrategy Desktop 10.3/9.5.1, MicroStrategy Web Services, MicroStrategy Intelligence Server, Oracle SQL Server, DB2, Teradata and Hive, Tableau 9.

Confidential, Irvine CA

Sr. MicroStrategy Consultant

Responsibilities:

  • Understanding the requirement and identify the complexity of the report
  • Created FFSQL ( FreeForm SQL) Reports.
  • Created subtotal, metrics for the different dimensionality.
  • Analyze the SQL and perform tuning of the report.
  • Export the document to excel sheet.
  • Designed Retail related dashboards with different Level metrics and threshold levels.
  • Designed Dashboards using Microstrategy web services and creating multiple panel stacks, selectors and filters.
  • Using Microstrategy web services scheduled the dashboards to be sent through email, exported them to excel sheets ad HTML.
  • Created various Monthly Dynamic Dashboard documents for the decision makers with multiple panel stacks, selectors and customized widgets.
  • Validating the SQL reports by performance testing them.
  • Using MicroStrategy Web Services for System Reliability Checks
  • Created Intelligent Cubes and good understanding in data mart design.
  • Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.

Environment: MicroStrategy Desktop 9.4.1, MicroStrategy Web Services, MicroStrategy Intelligence Server, Oracle SQL Server.

Confidential, CT

Sr. MicroStrategy Consultant

Responsibilities:

  • 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.
  • Developed user-defined BI applications, projects against the business model stored in repository using MicroStrategy Architect.
  • Developed Schema Objects (Facts, Attributes, Hierarchies and Transformations) using MicroStrategy Architect.
  • Developed basic and user-specified Metrics (level, conditional, compound).
  • Created Consolidations and Custom Groups as per the requirement.
  • Used Microstrategy functions such as ApplySimple and ApplyComparision in metric calculations.
  • Developed Filters (relationship, comparison) for complex reports.
  • Created Transformations for time-series analyses and Prompts in customer tuned reports.
  • Used Built-in advanced functions in conjunction with metrics.
  • Configured Very Large Database (VLDB) Properties at different levels (report, metric, project and database Instance).
  • Analysis made with MSFT SSAS Tabular for revenue analysis and Category analysis.
  • Created new user group and added new users to the group and assigned security privileges.
  • Extensively used MicroStrategy Desktop and Web to enable users to run pre-defined sales and inventory reports, build their own customized reports and download information into Excel spreadsheets.
  • Created drill maps for end users to drill down and recover data.
  • Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.
  • Created in implementation of single sign on authentication.
  • Created various Monthly Dynamic Dashboard documents for the decision makers with multiple panel stacks, selectors and customized widgets.
  • Implemented folder level security by creating security filters.
  • Implemented MicroStrategy Narrowcast Server to send personalized business intelligence information and reports.
  • 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.
  • Designed, Build the Dimensions, cubes with star schema usingSQL ServerAnalysis Services (SSAS)
  • With License Manager verified and updated licenses.
  • Provided technical support and training for user groups.
  • Worked closely with ETL teams in case of any issues with the ETL loads.
  • Worked along with MicroStrategy Knowledge Base to troubleshoot any Report related issues.
  • Upgradation of Microstrategy 8.1 version to Microstrategy 9.0 by keeping a backup of metadata, established connection to it.

Environment: MicroStrategy Desktop 8.1/9.0, MicroStrategy Web, MicroStrategy Intelligence Server, SQL Server 2005, Erwin Data Modeler 4.5, Informatica 8.1,Windows XP, UNIX.

Confidential, FL

MicroStrategy Consultant

Responsibilities:

  • Worked with power users from Finance department in gathering requirements and proposed solutions with new tools & technologies.
  • Understood the requirements and built the BI architecture to support all reporting needs.
  • Created various logical & physical data models to build the schema in MicroStrategy.
  • Created reports and dashboards on Client Profitability, Statement of Operations & Balance sheets.
  • Documented the standards to be followed for creating objects in MicroStrategy.
  • Completely involved in the lifecycle of the project from the beginning.
  • Created Public Objects such as Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and reports on top of the Schema Objects.
  • Created Simple metric, Compound metric, Derived Metric, Conditional Metric and Transformation metric to meet end user Requirements.
  • Created Dashboard Reports in interactive and Flash Mode by using Selector, Sliders and Widgets to view selected data.
  • Usage of Heat maps in dashboards in Microstrategy web which represent the category and revenue analysis.
  • Created Intelligent cubes to reduce the database load and decreasing the report execution by using the Cube Services.
  • Microstrategy SDK used in Excel Add ins.
  • Extensively worked on setting of VLDB properties at report and Metric Levels to tune the SQL and define Outer Joins between tables to get complete data from the required table and used different Query Optimization Settings Specific to database to improve performance of Query.
  • Moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window.
  • Participated in testing reports upgraded from 9.0.1 to 9.2.1.
  • Implemented testing strategy methods (unit, system, functional, integration, performance) also utilized MicroStrategy Integrity Manager.
  • Worked as production support for the business users.

Environment: MicroStrategy 9.2.1/9.0.1 Desktop Reports, Web Intelligence Reports, OLAP Services, Architect, Narrowcast Server, Administration, Dashboards, Oracle 11g, SQL Server 2008, Windows.

Confidential, Norwalk, CT

MicroStrategy Consultant

Responsibilities:

  • Worked with business requirements analysts / subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
  • Created the Detail design documents and Technical Specification Documents based on Business requirement documents.
  • In Microstrategy Architect enhancing the BI platform and build data designing
  • To ensure The documents are accurate.
  • Design and developed MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
  • Created complex metrics with different level dimensionality condition and filters and transformations for user and business specific reporting needs.
  • Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
  • Worked extensively on creating Application Objects like Metrics (level, conditional etc), Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Developed filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
  • Created historical YTD and MTD filters and prompts specific to historical Projects.
  • Worked extensively on VLDB settings to reduce the number of SQL passes which in turn improve the query performance.
  • Developed number of historical, monthly and daily reports and report service documents.
  • Executed Performance tuning of SQL for long running reports.
  • Created Dashboards and Report service Documents for Sales summary, Productivity and Performance summary.
  • Used report services for various banded report to satisfy the printing requirements of the user.
  • Coordinated in moving the objects from Development to Production Environment in MicroStrategy by using Object Manager.
  • Troubleshooting MicroStrategy prompts, Filters, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
  • Configured Narrowcast server and various Narrowcast task like creating Documents, service designs, subscription, administration and scheduling.
  • Perform code review and unit, system, regression testing.
  • Prepared technical project related documentation.

Environment: MicroStrategy Architect 9.0.1, MicroStrategy Intelligence Server 9.0.1, MicroStrategy Web9.0.1., MicroStrategy Narrowcast Server 9.0.1, MicroStrategy OLAP Provider, Oracle 10g and UNIX, Informatica Power Center/ Power Mart 7.1/6.2.

Confidential

MicroStrategy Consultant

Responsibilities:

  • Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
  • Extensively used Pass-through (Apply Functions) expressions to pass special functions.
  • Create connection maps to map users to different homogeneous databases or table spaces in a single project to direct end users against production and power users against development database.
  • Designed, Developed and altered html document objects by placing multiple reports on it in Grid as well as Graph View applying XSL formatting for each in the process of automating IT Dashboard reports.
  • Project duplication within and in between different project sources of Prod, Dev and UAT environments.
  • Installed and configured complete MicroStrategy product suite on Prod, Dev and RE&I Lab environments.
  • Personalize the end user experience at report runtime by providing flexibility with reusable prompts/report parameters
  • Validate, Detect and Repair logical/physical inconsistencies and corruptions of MicroStrategy metadata by running ScanMD/MD Doctor utilities.
  • Actively involved in the Implementation of Novell LDAP authentication for MicroStrategy Products.
  • Extensively used Object Manager, Project Merge and User Merge utilities to manage MicroStrategy Tier 1/ High Impact applications and objects.
  • Responsible for creating the MicroStrategy DB instances, DB connections, DB logins and ODBC DSNs.
  • Actively participated in the proof of concept for the MicroSrategy v8.01 upgrade. As SAP Consultant ( 5 months )
  • Prepare TDS and unit test documents.
  • Develop / Modify RICEF objects using ABAP workbench
  • Created Vendor Performance Report that lists Vendor Name, Materials Supplied,
  • Planned & Actual Delivery Times.
  • Sales and Distribution status summary reports. The report provided sales summary region wise.

Environment: MicroStrategy tool suit 7.2.3/7.5.1/8.0, MicroStrategy Office 7.5.1, DB2 UDB V7.1/V8.1 for Unix/Windows, Teradata, Windows 2000/2003, Sun Solaris V9/V10, Altiris Client Management Suite V6.0. SAP ABAP.

Hire Now