We provide IT Staff Augmentation Services!

Senoir Microstrategy Consultant Resume

Austin, TX

SUMMARY:

  • Nine years of consultant experience in Enterprise Data Warehousing and MicroStrategy Business Intelligence implementation and administration in the industry verticals of Retail, Pharmaceutical, Financial and Media.
  • Expert knowledge and working experience of MicroStrategy tools including MicroStrategy Architect, Desktop, Dashboard, Office, Object Manager, Command Manager, Mobile BI, Enterprise Manager, Narrowcast, Visual Insight, Web SDK and Visualization SDK using Flash. Worked on MicroStrategy version 7.5.x, 8.x, 9.0.1, 9.0.2, 9.2.1, 9.3.0. Hands on experience with MicroStrategy version upgrade, user training and team mentoring.
  • Strong problem solving capability and excellent communication skills, ability to adapt to new working environments and build solid working relationships with co - workers and other business users.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 7.x/8.x/9.x.

ETL: Informatica Power Center 9/8.6.

RDBMS: SQL Server 2005/2008, Oracle 10g/11g, Teradata.

Operating System: Windows, Linux.

Statistical Software: SAS (Base, Procedures, SQL, Macro, Stat), Minitab, R, S-PLUS, SPSS.

Other Tools: Visio, Erwin, SalesForce, Tableau, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Senoir MicroStrategy Consultant

  • Interacted with business users in gathering the requirements and analysis needs.
  • Created and modified projects, attributes, consolidations, custom groups, prompts, filter objects, and metrics in MicroStrategy
  • Used MicroStrategy report services in creating dashboards, production reports, operational reports and business reports. Automated reports delivery via Emails, net worked printers and shared servers using distribution services based on user requirements.
  • Created Integrity Manager test cases and resolved data integrity discrepancies and report SQL between projects.
  • Used Object Manager to create update packages
  • Used Command Manager to create configuration objects and assigning privileges to users and groups and managed distribution service subscriptions.
  • Collaborated with DBA to redesign data warehouse data model in order to support new requirements
  • Cooperated with data team to generate sample data in Dev environment and developed dashboard for demo purpose. Report data validation and update issue log.
  • Wrote manual and trained data analysts on how to use MSTR web.
  • Environment: MicroStrategy 9.2.1/9.3.0, Informatica 9.1, Teradata.

Confidential, Austin, TX

Senior MicroStrategy Architect

  • Involved in the design and development of data warehouse data models, which were optimized for efficient reporting.
  • MicroStrategy 9.3.0 Installation.
  • As a MicroStrategy Architect, collaborated with other team members in gathering reporting requirements and preparing functional and technical design documents to facilitate data warehouse schema design and MicroStrategy schema mapping. designed and developed MicroStrategy logical data model which included identifying and creating numerous MicroStrategy attributes, hierarchies, facts, metrics, filters, prompts, drill maps, custom groups, consolidations, auto styles, search objects, transformations and templates using MicroStrategy Desktop and Web.
  • Cooperated with data team to generate sample data in Dev environment and developed dashboard for demo purpose.
  • Used MicroStrategy report services in creating dashboards, production reports, operational reports and business reports.
  • Environment: MicroStrategy 9.3.0, Informatica 9.1, SQL server 2008.

Confidential, Bridgeport, PA

Senior MicroStrategy Consultant

  • As a MicroStrategy Architect, collaborated with other team members in gathering reporting requirements and preparing functional and technical design documents to facilitate data warehouse schema design and MicroStrategy schema mapping.
  • Collaborated with ETL team in data cleansing, data model design and ETL process flow Design. Involved in building complex relationship mappings, performing multi-table lookups, and several other transformations using Informatica Power Center 9. Data modeling involved handling ragged and recursive hierarchies and slowly changing dimension complexities.
  • Led a team of MicroStrategy developers in report development and testing. Setup the test environment for the testing team and helped fixing the bugs. The project development involved extensive use of OLAP services (view filter, report objects, derived elements, dynamic sourcing), Report Services, Intelligence Cube based reports and dashboards. Dashboard development utilized interactive selectors, grid/graph, panel stacks, multiple tabs for linking reports in different projects, allowing drilling from high level dashboards and scorecards to detailed reports. Used Web SDK to customize web interface with client’s logo and enable single sign on in MicroStrategy.
  • Coordinated with an offshore testing team in preparing test plan documents and suggested better data model and modified existing schemas to improve the overall performance processes. Led the Development Support Services (DSS) team in adopting the MicroStrategy best practices.
  • Cooperated with data team to generate sample data in Dev environment for demo purpose.
  • Environment: MicroStrategy 9.2.1, Informatica 9.1, Oracle11g.

Confidential, Exton, PA

Senior MicroStrategy Consultant

  • Responsible for all aspects of the development, enhancement, and support of the MicroStrategy project deliverables
  • Worked closely with business and project leads to finalize requirements for project deliverables
  • Cooperated with DBA to redesign data warehouse data model in order to support new requirements
  • Collaborated with the ETL team to design ETL process flow for entire DWH application and to develop mappings to load base tables and aggregate tables using Informatica Power Center.
  • Helped troubleshooting the connectivity issues between Informatica PowerCenter server and transactional/data warehouse databases
  • Designed schema objects including facts, attributes and views
  • Developed User Hierarchies for prompts and report drilling functionality
  • Created and modified projects, attributes, custom groups, filter objects, and metrics in MicroStrategy
  • Developed MicroStrategy reports and dashboards for the sales and marketing data warehouse
  • Upgraded MicroStrategy Suite from 8.x to 9.0.1 and resolved issues after upgrading
  • Created MicroStrategy Intelligence Cubes to enhance reporting performance using Cube Advisor
  • Developed custom MicroStrategy reports and used MicroStrategy Narrowcast to deliver report results to users in Excel
  • Environment: MicroStrategy 8.x/9.0.1, Informatica 8.6, Oracle11g.

Confidential, Boston, MA

MicroStrategy Architect/Administrator

  • As a MicroStrategy architect, designed and developed all the MicroStrategy objects (schema objects, application objects and configuration objects) using MicroStrategy Desktop and MicroStrategy Web.
  • Interacted with the end-users in understanding the reporting and analysis needs and developed business specifications. Served as a liaison between the business users and the data warehouse architecture team.
  • Utilized advanced reporting techniques such as compound metrics, advanced filtering, drill maps, transformations, custom groups, and consolidations etc., to develop reports and documents.
  • Performed performance tuning using VLDB properties in MicroStrategy and building indexes for major fact tables.
  • Used MicroStrategy report services in creating score cards, dashboards, production reports, operational reports and business reports.
  • As a MicroStrategy administrator, created and maintained the users and groups accounts and giving them privileges and controls on the project objects; used the administrator tools like Object Manager, Project Merger, Project Duplication and Command Manager in moving the projects/objects among different environments and in generating scripts for bulk operations.
  • Utilized MicroStrategy narrowcaster to create Narrowcast services, subscription sets and schedules in MicroStrategy Narrowcast Server.
  • Troubleshoot all the project related issues that included tool functionality, performance tuning, environment access issues.
  • Environment: MicroStrategy 8.1, Informatica 7/8.6, Oracle10g/11g

Confidential, Century City, CA

MicroStrategy Consultant

  • Interacted with business users extensively in gathering the requirements and analysis needs.
  • Involved in the design and development of data warehouse data models, which were optimized for efficient reporting.
  • As a MicroStrategy architect, designed and developed MicroStrategy logical data model which included identifying and creating numerous MicroStrategy attributes, hierarchies, facts, metrics, filters, prompts, drill maps, custom groups, consolidations, auto styles, search objects, transformations and templates using MicroStrategy Desktop and Web.
  • Extensively worked in developing complex reports and dashboards, and associated metrics and compound metrics.
  • Worked as MicroStrategy administrator to create the user groups/users and assign appropriate privileges and security roles. Responsible for maintenance of Security filters, User permissions, roles and Performance Issues and regular Monitoring of Job Monitor, User Connection Monitor, Schedule Monitor, Cache Monitors and Windows Performance Monitor.
  • Created and executed unit test cases while maintaining the documentation for each system.
  • Automated reports via Narrowcast and Report Services based on user requirements
  • Involved in MicroStrategy upgrade process from version 7.5.1 to 8.0
  • Actively involved in troubleshooting the project issues related to tool design, prompts, filters, grid display, graph and more in an enterprise data warehouse team environment.
  • Environment: MicroStrategy 7.5.1/8.0, Informatica 7, Oracle10g

Confidential, Westwood, CA

MicroStrategy Developer

  • Developed and maintained attributes, hierarchies, metrics (Simple and Compound), filters, prompts (Advanced) and templates using MicroStrategy Desktop
  • Created consolidations, custom groups, transformations, templates, advanced filters and drill maps to generate reports (standard and ad-hoc).
  • Created numerous reports and dashboards for sales and marketing with drill maps depending on user requirements.
  • Used Informatica to create ETL process to load target data warehouse from source data systems.
  • Created different transformations for loading the data into Netezza database e.g. source qualifier, joiner transformation, update strategy, lookup transformation, rank transformations, expressions, aggregator, sequence generator.
  • Environment: MicroStrategy 7.5, Informatica 7, Linux, Netezza.

Confidential

Data analyst Intern

  • Collected data (the disease level of Cercospora leaf spot) in the sugar beet field.
  • Analyzed data to compare disease resistance among different varieties for sugar beet variety selection. Examined and validated the statistical analysis result of tables and listings.
  • Introduced R to the Institute, wrote training manual and trained users.

Hire Now