Mahesh Sonavane

Role :

MicroStrategy Report Developer
MicroStrategy Administration

Responsibilities :

1. MicroStrategy System administration and monitoring, Creating and troubleshooting of Configuration Objects using configuration managers, creating and troubleshooting of users and users groups using user manager, setting up the transmitters and receivers using device manager
2. Upgrading the MicroStratgey System from 9.4.1 to 10.2 on both Windows and Linux machine.
3. Infrastructure and environment setup for the business intelligence systems on both Windows and Linux machine.
4. Automation of MicroStrategy administrative activities to improve the productivity
5. Directly working with MicroStrategy Vendor for resolving the issues faced during Development and Administration
6. Worked on almost all of the products of MicroStrategy - System Manager, Integrity Manager, Object Manager, Distribution Services, MicroStrategy Mobile, Command Manager etc.
7. Setting up the Enterprise Manager on MicroStrategy 10.2
8. Configuring and Using Operations Manager
9. Configuring and using MicroStrategy Web
10. Implementing clustering on the Linux machine for MicroStrategy
11. Setting up the Big Data Engine for the Hadoop connectivity
12. Configuring and using R integration with the Microstrategy

Role:

MicroStrategy Report Developer
MicroStrategy Administration

Responsibilities:

1. Creating I-cubes, dashboards, complex ad-hoc reports, pass-through expressions, transformations and other advanced MSTR functions
2. Microstategy Schema Design
3. Working with different Databases, VLDB Settings, SQL optimization techniques
4. In Memory ‘Cubes’ Implementation experience
5. MicroStrategy System administration and monitoring, Creating and troubleshooting of Configuration Objects using Configuration Managers, Creating and troubleshooting of Users and Users Groups using User Manager, Setting up the Transmitters and Receivers using Device Manager
6. Automation of MicroStrategy administrative activities to improve the productivity
7. Setting up the Enterprise Manager on MicroStrategy 9.4.1
8. Implemening clustering on the Linux machine for MicroStrategy
9. Portal Integration of MicroStrategy Web using MicroStrategy SDK.
10. Automating the object promoting from Development to UAT and Production environment.
11. Used MicroStrategy Server API to set the Microstrategy project configuration settings.
12. Writing command manager procedures to automate the MicroStrategy Project creation

Role :

MicroStrategy Report Developer
MicroStrategy Administration
Informatica Developer
Data warehouse Developer

Responsibilities:

1. Creating I-cubes, dashboards, complex ad-hoc reports, pass-through expressions, transformations and other advanced MSTR functions
2. Microstategy Schema Design
4. Working with different Databases, VLDB Settings, SQL optimization techniques
5. In Memory ‘Cubes’ Implementation experience
6. End to end knowledge of business intelligence and data warehousing architectures
7. Coordinating with the clients to analyze their requirements and to resolve their queries
8. Involved in analysis on client’s business work flow and their data impact on data warehouse (data analysis)
9. Design and Build the Semantic Layer Views in Teradata.
10. Unit testing of reports.
11. Issue resolution (UAT and SIT issues), troubleshooting and helping team members.
12. Creating Design documents that is considered as baseline in the project.
13. MicroStrategy Tools used - (Architect, Desktop/Developer, Web, OLAP Services, Configuration Wizard, Object Manager, Integrity Manager)
14. Creating Security Filters, granting ACLs at object level and User level privileges for security purpose.
15. Worked on FFSQL report.
16. Writing UNIX shell scripts to bring files from remote server, process the file as per the business requirements.
17. Build, Test and Deployment of source to source ans source to target Informatica mappings.