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