Bi Consultant Resume
4.00/5 (Submit Your Rating)
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