We provide IT Staff Augmentation Services!

Business Intelligence/microstrategy Consultant Resume

SUMMARY

  • A creative, results driven, customer focused Business Intelligence professional with work experience on several BI tools such as MicroStrategy, Power BI, Business Objects, Crystal Reports and Tableau.
  • 10 years of experience in IT industry covering Development, Analysis, Design, Testing and System Maintenance of Business Intelligence based applications and hands on experience on RDBMS, Web Technologies and Client Server applications.
  • Experienced in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows 2010/2008/2003.
  • Diversified experience in implementation of Business Intelligence solutions within Retail, Sales and Marketing, Health Care and Energy domains.
  • Extensive experience in Data Analytics and Business Intelligence products: MicroStrategy 2020/10.11 /10.6 , SAP BO BI 4.0, Business Objects XI 3.1/XIR2, Tableau 10.4, PowerBI, Teradata with Strong SQL and PL/SQL skills.
  • Experienced in interacting with Business Analysts, Data Architects and ETL developers to analyze the business process and transforming them into technical requirement documents for building reports.
  • Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation, Custom Groups and Intelligent cubes) with the data warehouse.
  • Expertise in developing highly Visual MicroStrategy Web and Mobile Documents, Dashboards (Dossiers), Visual Insights and Tableau Dashboards to support a large user base.
  • Experience in MicroStrategy Administration including design and setting up of new users, roles, privileges, data and application security.
  • Expertise creating Executive dashboards for the higher management showing summary metrics for the Key performance Indicators (KPI’s).
  • Strong experience in Slowly Changing Dimensions (SCD) Mappings of type I, II and III.
  • Experience with Amazon Web Services infrastructure - as-a-service for MicroStrategy and familiarity with Amazon's cloud infrastructure including EC2, S3 and Redshift.
  • Experience in various Performance Tuning methods such as Aggregate Tables, Caching, VLDB settings, Partition Mapping and Creation of indexes on tables.
  • Articulate with excellent communication and leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Business Intelligence: MicroStrategy 2020/2019/10.11/10.6 , MicroStrategy WorkStation, Developer, Office, Command Manager, Object Manager, Tableau 10.4,SAP BO BI 4.0, Business Objects XI 3.1/XIR2, Crystal Reports 2008/ XI/10/9, Crystal Xcelsius 2008/4.5, Live Office, Import Wizard, Launchpad, Universe Design Tool (UDT), Information Design Tool (IDT)

ETL Tools: Informatica 9.0/ 8.x/7.x, SAP BW 7.0/3.5, Data Stage V7.x

Data Modeling: Erwin 9.6/7.3, Oracle Designer

Databases: Oracle 12c/11g/10g, Teradata 14.1, MS SQL Server 2014/2012/2008 , AWS Redshift

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence/MicroStrategy Consultant

Responsibilities:

  • Gather reporting requirements and specifications from the business and perform gap analysis.
  • Involve in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
  • Installed, configured, managed, and executed upgrades of MicroStrategy 10+ environment including major/minor/patch releases on Linux platforms.
  • Governed the MicroStrategy environment and continuously optimize the environment via governing settings, VLDB settings and other Mechanisms.
  • Proactively monitored and maintained the stability of the environment by leveraging MicroStrategy monitoring tools, Platform analytics, AWS CloudWatch, Enterprise Manger Reports and other system monitoring tools.
  • Experience with Amazon Web Services infrastructure-as-a-service for MicroStrategy and familiarity with Amazon's cloud infrastructure including EC2, S3 and Redshift.
  • Managed schema development changes/enhancements effectively. Extensively worked in creating Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
  • Performed user administration, including creation of users and groups, removing inactive users and conducting license audits to ensure adherence to licensing requirements.
  • Worked on creating the Cubes and used the Dynamic Sourcing functionality in them to automatically route the relevant reports to use the dynamic sourcing option.
  • Created Complex Dashboards, Visual Insight, and mobile Dashboards on Microstrategy or Tableau tools based upon requirement.
  • Created daily, weekly, and monthly analytics reports and dashboards combining data from multiple data sources using Tableau and MicroStrategy.
  • Blended data from multiple databases into one report by selecting primary key from each database for data validation using SQL Joins, Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data while using Tableau.
  • Provided self-help guides, delivered end-user training documents, and created MicroStrategy training materials which help in Self-service for end users.
  • Used Integrity Manager extensively for Unit testing and to determine how specific changes in the project environment affect the reports and documents in that project.
  • Worked closely with MicroStrategy Technical support team and professional services and serve as SME covering MicroStrategy Architecture and administration.

Environment: MicroStrategy 11.2/10.11/10.6 , MicroStrategy Office, Command Manager, Object Manager, AWS Redshift 1.010393, MS SQL Server 2012/2014, PL SQL, CA Erwin 9.6, ER Studio, Jenkins, GitHub, Jira.

Confidential, Columbus, Ohio

Business Intelligence/MicroStrategy Consultant

Responsibilities:

  • Solicited Requirements, designed wireframes and developed prototypes and evaluated/modified MicroStrategy documents and Visual Insights dashboards to be more user friendly for data analysis.
  • Perform Data Profiling of the source systems using advanced SQL queries against the databases to understand the data patterns in the source systems and identify the data elements (tables, attributes) that satisfy the business reporting requirements.
  • Worked with Subject Matter Experts of Various line of businesses to gain strong understanding of GuideWire and ensure data required for enterprise reporting are captured in GuideWire ClaimCenter.
  • Worked on building a Self-service BI area for claims transformation users. This Self-service BI area will enable users to create their own reports and Dossiers.
  • Managed schema development changes/enhancements effectively. Extensively worked in creating Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
  • Designed and developed several dashboards, canned and Adhoc reports containing several elements such as attributes, metrics, prompts, shortcuts, filters, and search objects.
  • Created advanced grid reports, 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 dimensions.
  • Actively worked with team members for the development of technical and functional requirements leveraging multiple artifacts and documentation throughout an iterative, Agile development lifecycle. Worked in an agile environment with 3 week high-velocity sprints, fix the bugs.
  • Heavily involved in modifying existing SQL reports generated from replication database pulled directly from legacy claims system and recreated SQL reports using GuideWire ClaimCenter fields and reviewed with business for UAT.
  • Work with scrum team leads (Dev and QA), collaborating with cross-teams to finalize project plans, provide estimates during Agile iteration planning.
  • Trained business and power users on functionality of reports & dashboards for On-Demand Reporting Project.

Environment: MicroStrategy 10.11/10.6, MicroStrategy Office, Command Manager, Object Manager, Netezza, MS SQL Server 2012/2014, PL SQL, CA Erwin 9.6, ER Studio, Aginity WorkBench, SQL Server Management Studio.

Confidential

Sr. Business Intelligence Analyst

Responsibilities:

  • Assessed and cultivated long-term strategic goals for BI development.
  • Involved in all steps of Software Development Life Cycle (SDLC). Gathered report requirements from the users, preparing draft specifications, generating new reports.
  • Interacted with business users to understand their requirements and thereby was actively involved in gathering, analyzing and documenting functional requirements and data specifications to generate the reports.
  • Architected the projects and created schema objects like Attributes, Facts, Hierarchies and Transformations. Also created Public Objects like Metrics, Filters, Prompts, Drill Maps and Custom Groups.
  • Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
  • Created Intelligent Cubes and built several large Enterprise reports using the intelligent cubes to improve performance and user experience.
  • Involved in Setting VLDB Properties at Report, metric and database instance Levels to manage joins, metric calculations and query optimizations.
  • Experience in using pass through functions like Apply Simple and Apply Comparison.
  • Worked on setting up Cache updates, result caches and object caches at Intelligence Server to improve performance of the report.
  • Designed and developed several prototypes of dashboards (Mobile and Desktop) using MicroStrategy, which would give ability to the users to drill down to various levels of hierarchy.
  • Developed several Level metrics in the reports and grids to avoid multiple datasets while building Dashboards, Visual Insights and MicroStrategy Documents. Also, extensively used MicroStrategy Office Excel plug-in to retrieve data to excel and built several pivot tables to meet various reporting and user requirements.
  • Used Command manager scripts to maintain intelligent servers, users’ access and trigger events to run scheduled reports.

Hire Now