Harshil Gandhi

Senior Consultant InfoCepts

Chennai, India
Email Id : harshil.gandhi@gmail.com
Contact No. : +91 78712 78912


Business Intelligence Tools

  • 100%

Expertise in MicroStrategy 9.x.x, MicroStrategy 8.1.x, MicroStrategy Mobile plus Knowledge of SAP Business Objects, OBIEE, ROAMBI, Jasper and QlikView

Data Modeling

  • 90%

Star and Snow Flake Schemas

ETL Tools

  • 90%

SQL Server Integration Services


  • 90%

SQL Server 2005, IBM DB2, Oracle 9i and 11g, Teradata and Netezza

Programming Language

  • 90%

PL SQL, Shell Scripting

Development Tools

  • 90%


Quality Assurance Tools

  • 100%

JIRA, Bugzilla

Project Management Tools/Practice

  • 90%

Confluence, Agile Scrum

Release Management Tools

  • 90%

BMC Remedy, Tortoise SVN


  • 90%

Shell and MicroStrategy command manager scripts

Operating System

  • 100%

Windows, Linux and MAC

Technical blog

http://www.yellowbinbi.com is a technical blog about Business Intelligence, databases, and related technologies, most specifically Yellowfin.


Indian citizen

Spoken Languages

  • English: fluent
Other Interests

    • Travelling
    • Reading


  • More than 6.5. years of thorough knowledge and experience in using MicroStrategy Business Intelligence Product Suite (MicroStrategy Intelligence Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Integrity Manager, MicroStrategy Office, Visual Insight, Mobile Development and MicroStrategy Administration on windows and Linux box)
  • Expertise in MicroStrategy migration and MicroStrategy Upgrade projects with step by step approach to ensure stability of production environment; Starting from proposal, planning, user communication and training, team coordination, complete testing, backup/restoration and back out strategy
  • Experience and exposure in other Business Intelligence, Data Warehousing technologies and services like Tableau, OBIEE, SQL and SSIS
  • Knowledge of SAP Business Objects with Hand on experience of migration of Business Object to MicroStrategy
  • Effective on client management onsite for building trusted relation, leading initiatives, providing critical solutions, technology advise and managing work with offshore associate
  • Expertise in working with senior Technology and Business Stakeholders and creating POVs/POCs/Demos on technology solutions
  • Knowledge sharing with client associate and production support team, created extensive documentation around support, bug fixing and troubleshooting for project and production support team
  • Effective in Agile/SDLC methodology, strong focus on timely delivery of the quality work with the help of burn down chart and other project monitoring tools
  • Created project estimations, solution and design documentation, operational guidelines and production handover documentation
  • Worked with stakeholders, different team, compliance officer, service managers and production team for production readiness and transition for go live
  • Process oriented and experienced in onsite-offshore project delivery, using agile methodology and best practices
  • Experience in Project management of small, Large and distributed team
  • Full Life-cycle Business Intelligence (BI) and Data Warehousing project experience, starting with requirements analysis, proof-of-concepts, design, development, testing, deployment and administration
  • Sound knowledge of Data warehousing methodologies and Dimensional Modeling like Star and Snowflake schema
  • Domain knowledge of Banking and Finance specific to financial market, Equity, Collateral, Trade Life Cycle, operational and client related reporting
  • Strong Analytical Skills and Business Analysis Experience. A good Team Player with excellent written, verbal, and interpersonal skillsProcess oriented and experienced in onsite-offshore project delivery, using agile methodology and best practices
Work History

Oct 2012 –
Dec 2014

Global Bank, Singapore, China

MicroStrategy Architect/Lead, Team size: 4

Project is to provide financial analytics and reports to the bank internal users and external compliance units on various banking platform such as Commission, Equity, Collateral, US/UK/HK based regulatory and Stock Exchange related reporting using MicroStrategy.


  • Creating proposals, solutions, execution plan and delivery milestones for new project in FMBI
  • Design complex solution and reports for Equity, Collateral, Capital Market, FX, Stock Exchange, Regulator, Compliance and Trade reporting
  • Perform end to end upgrade planning, testing, user training and production upgrade from 9.0.1 version to 9.4.1
  • Create thorough detailed solution documents, UAT/SIT test plan, Implementation plan, execution strategy, risk assessment, back out plan and Impact analysis for the release management, as production releases has to go through very critical checks in bank
  • Coordination and proactive follow-up with various technology/business team to meet the timeline on a highly distributed environment
  • Managed Dev, UAT and Production environment on MicroStrategy Intelligent Server Universal (Linux)
  • Providing consulting on overall system health and performance optimization at intelligence server, Project or tomcat configuration and report design/SQL optimization
  • Performed admin responsibilities such as object migration, Integrity manager test, code management using SVN, process automation using command manager and shell scripts, second line support to PSS
  • Created thorough plan for upgrade and performed regression testing for 11 projects
  • Perform many automation tasks using shell scripts such as parallel report execution in integration with control-m, automat restart of Intelligence server and Tomcat with feedback to PSS team, fully automated implementation in Production
  • Implemented various customization and LDAP authentication as ongoing enhancements.
  • Participated in user demo/education and design framework for BI strategy with senior SA

Jun 2012 –
Sep 2012

Global Gaming Company, SAP BO to MSTR Conversion

Role: MicroStrategy Consultant and Offshore Lead, Team Size: 12

Company is in gaming product development industry is recognized as a company with exceptional technological expertise for usage of the latest and cutting-edge software systems, innovative tools and technologies following best of the industry practices and implementations. We have worked as an external consultant to provide an exception value to their existing MSTR team.

After merger of two gaming giant higher management decided to keep one BI tool at an organization level, therefore all existing report in SAP BO needs to be converted to MSTR. My role was to manage 12 members’ offshore team and delivery of 61 complex operational RSD within 4 months of timeframe.


  • Created overall project planning and delivery milestone based on 4 Sprint of 15 reports each
  • Created overall project execution strategy for different phases: Development and QA process to be followed, sprint planning and deployment strategy
  • Detailed estimation of all the reports and first hand analysis to understanding the complexity of report and allocate the report accordingly to an associates
  • SAP Business Objects client component Installation and configuration
  • Analyzed .REP files in Desktop Intelligence for mapping, measures definition, tables join, level of calculation, sub totals, sort orders etc
  • Based on analysis produce the analogy for data model and Implementation of similar SQL and object definition in MicroStrategy
  • Implemented very complex reports and documents in MicroStrategy using level metric, custom subtotal and custom sorting
  • Used master dataset concept for efficient development in performance and object creation point of view
  • Assist associate in complex requirements, as some of the SAP capabilities needs to be implemented with workaround in MSTR
  • Continuous monitoring of progress and managing the burn down chart of each sprint to meet the timelines
  • Follow-up with onsite team on any data or requirement related changes in data model
  • Following best practices for implementation and naming conventions to enforce reusability of public objects as parallel teams were doing the development
  • Optimizing the report implementation to make sure the correct SQL are used to pull the data in reports
  • Document review and final QC before it delivers to onsite team for UAT
  • Assist an associates in MSTR Implementation and conduct regular training for data modeling and implementations related learning
  • Encourage team discussion to make use of each other’s learning and mentoring team members

Oct 2010 –
May 2012

US based Health Analytics Company

Role: MicroStrategy Consultant, Team Size: 8

Company is a healthcare analytics organization that provides innovative services that help healthcare industry solve a wide range of business challenges. Client include all the top 50 pharmaceutical / biopharmaceutical manufacturers, medical and surgical device manufacturers, retailers and manufacturers of consumer package goods, the federal government, financial institutions, media group, and the top healthcare organizations.

We work with Company as an extended team model of 8 member size on multiple project groups simultaneously. I lead a team of 2 members on Lilly dashboard development project; in addition I worked on multiple clients of the company for wide range of solutions using standard guidelines. I also participated in suggesting MSTR best practices.


  • Interacted with the users extensively, gathered the requirements, and analyzed the needs of the end users
  • Planed and estimated development efforts, timelines and prioritization across different BI projects within Healthcare product/client framework
  • Crated/analyzed data model for aggregated and non-aggregated data for the specific report requirements related to health analytics
  • Involved in analysis, design, and construction of the metadata, created schema objects like attributes, facts, hierarchies, transformations and public objects like metrics, prompts, consolidations, custom groups, drill maps, and templates.
  • Designed multilayered, self-contained dashboards that include full interactivity, visualization functionality, drill downs and data content
  • Provided data model design, build project from scratch including schema design and application objects development, query optimization and performance improvement using VLDB properties and iCube for following projects
    • Effient and Plavix: 2 dashboards and 13 reports for Effient and Plavix drug performance compression over a period of time
    • Sales Force Structure and Strategy (SFSS): 5 dashboards for pharmaceutical sales force performance analysis
    • Vaccine Dashboard: Vaccine A dashboard for vaccine analysis across diseases, geography and age group
    • Long Term Care (LTC): A dashboard for provider/prescriber analysis, developed iCube and sourced data from iCube to enhancement dashboard performance
    • Nutropin iPad app: Designed and developer Nutropin iPad app for Genotropin to provide drug analysis across US geography
    • Healthcare iPad app: Designed and developer Healthcare iPad app for MicroStrategy World presentation to showcase SDI healthcare capabilities, this project was based on LTC data source
  • Created change management request and perform impact analysis using Integrity manager before moving any changes to production
  • Coded command manager scripts to automate cube publish after data load every week
  • Mentoring and assisting team members for professional development and technology solutions

Jul 2009 –
Sep 2010

US based Toys and Baby product retail chain, Merchant Report Automation

Role: MicroStrategy Developer, Team Size: 4

Merchant Report Automation Project – Objective was to implement a suite of scorecards used by cross functional business teams to satisfy Monday AM business reporting requirements. Reduce the time spent on manually generating existing reports, Reduce risk of errors due to manual nature and improve consistency in meetings. Develop extremely complex 14 reports out of 70 for Merchandize and Finance team.


  • Understood the Business Requirements and development methodology and process
  • Created complex profit and loss reports which support analysis across 9 dimensions over 132 metrics
  • Created Report design document, System design document, and other artifacts for sign-off and code review
  • Process oriented development, followed all the standards and best practices
  • Report Functionality testing, Unit testing and bug fixing for the QA raised issues
  • Resolved performance issue – Improved the report performance by 83%

Feb 2010 –
Jun 2010

US based Telecomm Expanse Analytics Company, Post Production Support

Role: MicroStrategy Consultant, Team Size: 1

Company provides automated telecom expense management solutions for enterprises and government agencies. Overall solution automates an organization’s entire telecom lifecycle, including procurement, provisioning, inventory management, and invoice processing. Many of the world’s most-admired companies and government agencies choose our solution for their telecom expense management needs.


  • Managed development, sandbox and production environment on MicroStrategy Intelligent Server Universal (Linux)
  • Deployed product package on client site and setup the environment for MicroStrategy
  • Performed object migration across Dev-SB-PROD environment and deployment of code to SVN
  • Created MicroStrategy user and assigned appropriate security roles manually and using command manager scripts
  • Managed environment variable for SSO, daily job execution monitoring and failure support
  • Configured I-server and project governing settings for performance optimization
  • Recommended performance tuning changes using optimized SQL generation and relevant database improvements
  • Provided consulting on MicroStrategy licensing issue
  • Worked with MicroStrategy support for outstanding cases resolution for MSTR 8.1.1
  • Resolved outstanding issues on dashboard, RSD and report
  • Modified views, database settings or MicroStrategy objects for performance issue
  • Managed the code changes for each releases cycle using SVN
  • Worked on Issue tracking tool ‘JIRA’ and product management tool confluence

Jun 2008

Bachelor of Computer Engineering

Nagpur University

Computer engineering involves the design and application of computer hardware and computer software.


MCTS SQL Server 2008R2 Database Developer (70-433)

The MCTS: SQL Server 2008R2 Database Development certification is an industry recognized credential. The certification is proof of a person’s competence across a spectrum of skills including database logical and physical modeling, query writing, performance tuning and carrying day-to-day maintenance and troubleshooting of databases using SQL Server.