Shaleen Shivhare

Phone: +1-813-***-****

Email: adcibx@r.postjobfree.com

LinkedIn: www.linkedin.com/in/shaleenthegreat

Summary

Profile

MicroStrategy Certified Analyst (MCA) – Version 10.2, MicroStrategy Certified Dashboard and Mobile Designer (CDMD) – Version 9.4.1 & 10.2, MicroStrategy Certified Report Developer

(CRD) – Version 9.4.1.

Overall 9+ years of relevant experience in MicroStrategy.

Having experience in working on MicroStrategy9.0.1, MicroStrategy9.0.2, MicroStrategy9.2.0, MicroStrategy9.2.1m MicroStrategy 9.3.X, MicroStrategy 9.4.1, MicroStrategy 10.2, MicroStrategy 10.11 and MicroStrategy 11 versions.

Had extensively worked on MicroStrategy Intelligent Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Office, MicroStrategy Architecture (Object Manager, Enterprise Manager, and Integrity Manager), MicroStrategy Reporting Suite, MicroStrategy Report Services, and MicroStrategy OLAP Services, MicroStrategy Mobile, MicroStrategy Command Manager, MicroStrategy Distribution Services, MicroStrategy Multisource Option

& MicroStrategy Health Centre.

Experienced on multiple BI tools and technologies i.e. MicroStrategy 10.11, Tableau 10.5, Microsoft Power BI 2.76, QlikView 12.10, Spotfire 7.14 and SAP Business Objects 4.3.

Good working knowledge in the Database Sybase IQ, DB2, TEREDATA and Oracle.

Excellent capability to explore, learn and understand newer business domains and technology.

Primary KRAs

Working as a Senior MicroStrategy Consultant for the client “HCA” at Client Side for multiple projects.

Worked as a Senior MicroStrategy Architect and Senior MicroStrategy Lead for the client “Citibank” at Client Side for multiple projects.

Worked as a Senior MicroStrategy Developer and MicroStrategy Administrator for the client “HONDA Europe”.

Functional knowledge on Manufacturing, Retail, Distribution and Logistics, Supply Chain Management & Banking and Financial Services.

Created POC (Proof of Concept) for the existing and new customers on Spark, Hadoop, Cloudera and Arcadia.

Having experience in working on Tableau, QlikView & Spotfire as well. Worked for COE (Center of Excellence) in Tableau and QlikView. Created POC (Proof of Concept) for the existing and new customers. Key Skills

• MicroStrategy

• Tableau

• Power BI

• Data Analytics

• Data Visualization

• Business Intelligence

• Big Data

• Data warehousing

• ETL

• Databases

• Business Analysis

• Data Modelling

• Spark

• Hadoop

• Cloudera

• Arcadia

• MongoDB

Technical Skills

LANGUAGES: C, C++

RDBMS: MongoDB • Sybase IQ • SQL • PL/SQL • Oracle • TERADATA • DB2 NETWORKING: Computer Networks • Data Communication OPERATING SYSTEM: UNIX • Windows • DOS

APPLICATIONS: M.S. Office • Open Office

BIG DATA: Spark • Hadoop • Cloudera • Arcadia

TOOLS: MicroStrategy 10.11 • Tableau 10.5 • Microsoft Power BI 2.76 • QlikView 12.10 • Spotfire 7.14, Abinitio • SAP Business Objects 4.3 • INFORMATICA 10 • Flex TRAINING UNDERGONE: DWBI

CERTIFICATIONS: MicroStrategy Certified Analyst (MCA) • MicroStrategy Certified Dashboard and Mobile Designer (CDMD) • MicroStrategy Certified Report Developer (CRD) Professional Experience

Senior Consultant Jan ‘20 - Present

Atos Syntel, Nashville, USA

Working as a Senior BI Consultant for the client “HCA Healthcare” at Client Side for multiple projects.

Working as a Senior BI consultant having experience of multiple BI technologies (MicroStrategy 10.11, Tableau 10.5, Microsoft Power BI 2.76, QlikView 12.10, Spotfire 7.14 and SAP Business Objects 4.3) & Data warehousing concepts and handing multiple projects simultaneously.

Working with Client directly to get the requirement and providing end to end delivery.

Having multiple certifications on BI tools.

Leading and managing multiple projects for HCA (Hospital Corporation of America) applications.

Working as a senior MicroStrategy Architect and providing technical solutions to the team.

Managing as onshore lead coordinator and working on onshore offshore model to deliver the solutions to the Client on time.

Project Lead Jan ‘16 - Jan ‘20

L&T Infotech, Tampa, USA

Working as a Senior MicroStrategy Lead and Senior MicroStrategy Administrator for the client “Citibank” at Client Side for multiple projects.

Working as a BI consultant having experience of multiple BI technologies & Data warehousing concepts and handing multiple projects simultaneously.

Working with Client directly to get the requirement and providing end to end delivery.

Having multiple certifications on BI tools.

Leading and managing multiple projects in CFO insight application.

Working as a MicroStrategy Architect and providing technical solutions to the team.

Managing as onshore lead coordinator and working on onshore offshore model to deliver the solutions to the Client on time.

Defining project scope, estimation, planning and execution.

Worked closely with the end users and internal business analysts for data requirements gathering, design, prioritized business goals and information needs.

Creating mock ups.

Designing the reporting data model.

Development of dashboards. All work focused on presentation of data in more intuitive, discernible formats for objective use. Used MicroStrategy Desktop/Developer to build attributes, hierarchy, metrics, other Schema Objects, filters, consolidations, transformations and custom groups, and prompts to generated reports meeting the Business needs.

Worked on creating MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an Enterprise Data Warehouse team environment.

Created/modified interactive Dynamic Dashboards and Scorecards for different users with drill down capabilities.

Worked with the analytical bypass functions/pass through expressions like Apply Simple and Apply Comparison whenever needed.

Worked extensively on Performance tuning to reduce the run time of MicroStrategy reports drastically by changing the VLDB properties, reducing the number of SQL passes, additional index creation etc.

Building proof of concepts(POC) for certain new features asked by the clients

Designing the schema layer or semantic layer for MSTR reporting.

Designing, implementation, testing and delivery of reports and dynamic dashboards solutions.

Created Test cases as a part of Unit Testing of the generated Reports.

Worked on POC for 10.11 upgrade and conducted a roadmap exercise for upgrade.

Creation of documents like Report design Document, Solution Specification.

Hands on experience on Database (PL/SQL queries).

Hands-on development/maintenance experience in Micro strategy 9.4, Knowledge/Experience on enterprise portal integration, mobile integration, write back to source data based on analysis by business users, alerts via mail, mobile based on pre-defined events

Good conceptual knowledge and working experience on meta data creation (framework models/universe etc.), creating report specifications, integration test planning & testing, unit test planning & testing, UAT & implementation support

Strong knowledge of quality processes (SDLC, Review, Test, Configuration Management, Release Management, Defect Prevention

Should be able to interpret data models and usage of data modelling tools (ERWIN etc.)

Working knowledge on Sybase.

Gather business requirements, elicit technical requirements, prepare report specifications

Develop reports, cubes, dashboards, scorecards

Design, develop MSTR reports and integration with enterprise portals, mobile integration, write back to source data based on analysis by the business users, alerts via email, mobiles based on predefined events

Unit, Integration test the developed components

Promote components across dev, test and production environments

Provide UAT and Implementation support

Experience in working with Onsite Offshore team

Senior Software Engineer Feb ‘15 - Jan ‘16

L&T Infotech, Belfast, UK

Involved in Requirements gathering from Business Users.

Developed Facts, Attributes, and Hierarchies using respective editors. Designing and developing advanced grid reports, consisting of data analysis by combining a template with advanced Metric Objects.

Developed and customized Ad-hoc reports using Templates, Metrics, Filters, Auto Prompts, and Custom Groups.

Creating Report Services Documents out of existing reports and customized them to reflect the company’s logos and color palette. Created Dashboards which helps in better understanding of the Business trends.

Created reports with View Filters and Derived Metrics on a report for further analysis of report which reduced database load.

Created several Intelligence Cubes for reports to reduce the database load on data warehouse. Created Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Developed reports with View Filters and Derived Metrics for further analysis which reduced database load and improved respond time to end users.

Created various Security Filters to enforce security on the sensitive people data. Used Administrator tools like Project Merge and Object Manager to move the objects from one environment to another environment.

Transmitted reports and documents to various levels of users by using Delivery manager. Test the reports by running SQL statements against database in BD Query Tool.

Tuned reports performance by tweaking VLDB properties.

Involved in designing functional specification of reports based on requirements.

Analysed the business model to understand the Existing Systems and Business Requirements. Migrated Reports from Cogno’s to MicroStrategy.

Created MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop. Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.

Worked on development of Dashboards, Reports and Intelligent Cubes based on the technical and business specifications of the customer.

Tuned reports performance by tweaking VLDB properties.

Worked with Free-Form SQL reports to create reports that are not supported by existing schema model.

Created logical views for reports and documents. Created simple and complex report in MicroStrategy Desktop and web and provide Production support.

Created ad-hoc reports by drilling up, down, within and across Hierarchies. Involved in creating Security filters to end users to access data based on their privileges. Used Apply Simple and Apply Comparison functions to develop complex Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.

Created Administration Tasks like creating User Accounts, Assigning Privileges and applied Security Filters. Worked with Object Manager to move Objects and Packages between different environments.

Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Involved in meetings with business users to discuss and finalize the requirements and design of the reports. Create dynamic dashboard using Widget, Panels, Selectors, Graphs and Grid.

Participated in design of database architecture, ELT processes specifically usage of data loading features available in Sybase IQ.

Created on the fly dashboard by using visual insight

Worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.

Worked on the MSTR Narrowcast module to Schedules to have the reports delivered business users. Performed routine administrator tasks during absence of MicroStrategy administrator.

Created Users, Roles & Privileges using the MicroStrategy Desktop (Administrator).

Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.

Used custom widgets developed by SDK.

Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.

Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.

Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.

Worked with back end Database Administrators to provide requirements for necessary back end tables. Extensively worked in both Ad-hoc and Standard Reporting Environments and Involved in creating Reports scalable to large volumes of data.

Managed projects through entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.

Software Engineer Oct ‘13 - Jan ‘15

L&T Infotech, Mumbai, India

Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.

Developed Flash Dashboards in 9.3 using Widgets and Selectors for summary level reporting.

Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.

Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.

Created highly visual dashboard by using visual insight.

Created Complex filters with advanced qualifications involving the ‘Apply’ functions.

Developed various Adhoc and created Documents using Report Services Documents.

Knowledge in Developing Mobile Dashboards.

Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.

Imported data from excel and created intelligent cube and created reports, documents and dashboards from the cube

Create Drilling path and implement those into reports such that user can Drill across different System and User hierarchies. Create Intelligent Cube and use that in reports to decrease the workload on database.

Work on VLDB properties like query optimization to optimize the query.

Used Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report. Worked along with MicroStrategy Knowledge Base to troubleshoot some Report related issues.

Schedule and Deliver Reports to Business Users in Desktop and Web via Narrowcast Server.

Work with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.

Played a key role in User Acceptance Testing of the reports.

Collaborated with business partners to define requirements and reporting specifications and provide technical report assistance.

Conducted regular working sessions with the users to analyse their reporting needs and provide solutions for the same.

Created Attributes, Facts, Hierarchies and Relationship between various Attributes

Created application objects such as Metrics, Compound Metrics, Filters, Custom Groups, Consolidations, Templates, Auto Prompt Filters and OLAP Reports.

Designed and Developed Dashboards, Documents and Reports.

Assisted the users in their end user testing and resolved issues if any

Involved in creating user groups, security filters for users and assigning privileges to those groups.

Worked with analytical and governing settings in VLDB properties for performance tuning of reports.

Involved in design ETL Process based on the business.

Created schema objects like Attributes, facts by using MicroStrategy Desktop.

Created MicroStrategy reports based on existing reports in the project.

Created cubes to increase the performance of the report and Dashboards.

Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.

Created Dynamic Dashboards showing Company's yearly, Monthly and Quarterly performance using various graphs and widgets.

Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.

Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.

Validated end user requirements using MicroStrategy tools.

Worked on administrative tasks like creating User and User Groups, Roles, and Privileges.

Used the Object Manager to migrate objects to different environments.

Involved in End-User training, Support and Maintenance.

Involved in Testing and Data validation of Reports. Senior Software Engineer Nov ‘10 – Oct ‘13

iGATE Global Solutions Limited

Involved in design ETL Process based on the business.

Download and Install the MSTR tool on the server and established the connections.

Created schema objects like Attributes, facts by using MicroStrategy Desktop.

Created Applications Objects like Advanced Metric, Filters, Prompts, Custom Groups and Consolidations.

Created MicroStrategy reports, documents and dynamic dashboards based on the requirements.

Created cubes to increase the performance of the report and Dashboards.

Created the logical views as required.

Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.

Setup the Test environment and moved the objects from DEV to TEST by using object manager.

Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.

Validated end user requirements using MicroStrategy tools.

Worked on administrative tasks like creating User and User Groups, Roles, and Privileges.

Involved in Testing and Data validation of Reports.

Involved from initial stage of the project.

Worked with business users to collect all the information about requirement.

Determining the source table and columns needed to make a MicroStrategy project. Configuring reports needed by the end users through Developer and MicroStrategy web. Created metrics and filters in the process of making a report.

Changed the web theme by using web SDK plugins.

Created cubes to increase the performance of the report and Dashboards.

Worked with MicroStrategy Object Manager to move the objects among the environment.

Created web link for the dashboard with default prompt answers using HTML code.

Created reports based on multi sourcing.

Involved in Testing and Data validation of Reports and document and given production support.

Worked along with MicroStrategy Knowledge Base to troubleshoot any report related issues.

Worked closely with backend (database) team in case of any issues with data.

Trained testing team to work on the MicroStrategy web to test the reports.

Used the integrity manager to test the reports data.

Worked with Business Users and involved in gathering business requirements.

Participate in daily stand up and monthly planning meetings.

Used Warehouse catalog to import tables and Created Logical Tables.

Trouble shooting Many to Many relationships between the attributes and identified the one to one, one to many relationships between the attributes.

Designed and developed Report Templates, Filters, Metrics, and OLAP reports using MSTR 10.4.

Worked extensively in creating Metrics (Compound metrics, Level metrics & Conditional metrics), different Filters.

Used Time Series slider, Heat Map, Image layout, Interactive bubble graph and Micro charts widgets to create interactive dashboards.

Used Pass though functions like Apply Simple, Apply Aggregation & Apply Comparison. Education Technocrats Institute of Technology, Bhopal B.E. (IT) 2010

March 2020 Nashville, Tennessee, USA

Extra-Curricular

Head co-ordinator of all the state level cultural and technical events at my college TIT from 2006 to 2010 Secured 1st Rank in Quiz Competition in a state level event BIOS ‘09 – Necrise Awarded 2nd prize for a paper on 'Spin Electronics' presented in a state level event PLANET ENGINEERS '08- LNCT

Contact this candidate