We provide IT Staff Augmentation Services!

Bi Consultant Resume

IrvinE

SUMMARY

  • An IT professional with good knowledge on all phases of product/software development life cycles. A distinguished analytical thinker with the ability to bridge technology and business goals to provide productive solutions. Looking for a position where my knowledge and skills are used till extent to provide solutions.
  • 5 years of rich experience in Business Intelligence reporting using MicroStrategy, Tableau and Excel
  • Strong knowledge on creation of schema objects like Attributes, Facts, Hierarchies, Transformations and Logical Tables.
  • Expertise in Transaction reports, basic and Advanced Metrics (level, Conditional, Compound, Non - Aggregate, Transformation). Involved in Store procedure implementations.
  • Experience in configuration of VLDB properties at different levels to customize SQL generation and to maintain performance optimization.
  • Experienced in MicroStrategy Pass through Functions like Apply Simple, Apply Comparison etc.
  • Designed interactive and Dynamic Dashboards using Report Services objects like Heat map, Time Series, Gauges Widgets and Grid/Graph combinations.
  • Experience in Designing/Developing Ad-hoc Reports by using object prompts.
  • Defect fixing during the SIT and UAT phase.
  • Ability to work and handle multiple projects simultaneously.
  • Experience in integrating the application using Edit links and URL API
  • Have good experience in creation of package using Object Manager
  • Broad experience in Query Optimization and performance tuning of SQL queries to enhance performance.
  • Quick learner and good performer both in the team and independent job environments with proven ability to manage the project while meeting challenging deadlines with utmost client satisfaction.
  • Extensive involvement in supervision and training new joiners in the team.
  • Excellent Troubleshooting Skills, Client Interaction and Project Coordination with a strong technical background.

PROFESSIONAL EXPERIENCE

Confidential, Irvine

BI Consultant

Responsibilities:

  • Responsible for all administrative deliveries on the Microstrategy Environment which consists of 30 servers and 6000 users.
  • 3 years of installing, upgrading and maintenance of MSTR application with 40 members team in support and development.
  • Very hands on code migration using packages, manual and automation approaches.
  • Monitoring the system performance and Capacity planning by using Enterprise Manager reports.
  • Implemented robust security model while dealing competitors information in a single environment by using connection mapping, security filters and ACL’s.
  • Datamart reports set-up for bulk data requests out of warehouse to share the workload of overburdened ETL environment.
  • Distributing reports to business users via email, file by using Report Distribution services and Narrowcast services.
  • Audit checks on user profiles in compliance with licensing requirements, working with Microstrategy to get additional license when in need.
  • Reporting Issues with Microstrategy by working Microstrategy Technical support.
  • Attended no of WAR Room meetings for all major P1 Issues.
  • Database Instance creation, maintenance during life cycle of the project.
  • Troubleshooting the issues with Microstrategy application, Warehouse data and ETL Processes.
  • Effectively worked on providing a scalable solution where new sources and more data can be added efficiently over time.
  • Expertise in using MSTR Pass Through functions like Apply simple, Apply Comparison and Apply Aggregate to achieve the specifications.
  • Resolved Data quality issues promptly.
  • Created Schema Objects like Attributes, Facts, Transformations, Hierarchies, Logical Tables
  • Worked on creation of different Objects by using the OLAP Services like derived, view filters, sub totals.
  • Involved in integration and consolidation of data from multiple sources such that those data can be analyzed, and reported on, alongside and against each other in a meaningful way
  • Worked on Designing and development of Datasets, Enterprise Dynamic Dashboards and Score cards as per Business User requirements.
  • Worked with DB DBA team to improve the report performance.
  • Responsible for configuration of VLDB Properties to optimize SQL Generation of Microstrategy Reports to achieve benchmark performance.
  • Co-ordinated with ETL team to solve the data issues.
  • Created the Check list for reports format testing
  • Created Migration Documents to move to objects to different Environments.
  • Captured changes to key data over time for accurate analysis and reporting during the unit testing.
  • Involved in Optimizing the high Performance of Reporting, Data Access and High Performance of Data Acquisition (ETL).

Confidential - Santa Ana, CA

BI Consultant

Responsibilities:

  • Worked on multiple End to End Projects
  • Responsible for all administrative deliveries on the Microstrategy Environment
  • Distributing reports to business users via email, file by using Report Distribution services and Narrowcast services.
  • Audit checks on user profiles in compliance with licensing requirements, working with Microstrategy to get additional license when in need.
  • Reporting Issues with Microstrategy by working Microstrategy Technical support.
  • Attended no of WAR Room meetings for all major P1 Issues.
  • Database Instance creation, maintenance during life cycle of the project.
  • Troubleshooting the issues with Microstrategy application, Warehouse data and ETL Processes.
  • Developed Cubes, Schedules and subscriptions
  • Created Documents, dossiers and Dashboards for Rebates project
  • Managed backend SQL tables
  • Defined Accounts, balance sheet grouping in SSMS
  • Support to QA and DA teams
  • Unit testing
  • Creation of MicroStrategy public objects like metrics, filters, prompts, templates etc.
  • Creation of Grid & Graph Reports. Implemented drill functionality on the reports using Drill Maps. Extensively worked on creation of documents and dashboards
  • Worked with Subject Matter Experts to understand the business requirements,
  • Discussed report/dashboard requirements in detail with BI (MicroStrategy) team and Onshore Business Analyst
  • Designed and helped team to build report objects in MSTR required for report/dashboard development
  • Deeply involved on defect fixing during the SIT and UAT phase. Involved in all Modules to meet the deadlines of the project
  • To create public objects like filters, metrics, prompts.
  • To formatting documents dashboards as per the requirement.
  • Working on technical design document.
  • Defect fixing

Hire Now