Mahesh .

• 7 years of IT Experience with well acquainted in performing as MicroStrategy Architect and Administrator using Microstrategy tool Suite with Strong Domain Knowledge of Communication, Financial (Bank and Insurance), Healthcare, Retail. • Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, Microstrategy Web, MicroStrategy Narrowcast Server and OLAP Services Environment. • Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using Microstrategy. • Extensively worked in creating and integrating Microstrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups). • Experience in Microstrategy Architect, Office, Narrowcast, User security & management, Object Manager & designing reports (grid, drilldown, ad hoc, OLAP cube) and dashboards in Microstrategy 7.3/8.0.1/8.1.1 & Microstrategy 9. • In-depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Security and deployment, FACT and Dimensional tables, Logical and Physical data modeling. • Experience in Microstrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation, migration and testing. • Extensively worked on delivering reports and business intelligence solutions on the web using Microstrategy Narrowcast Server. • Experience in data extraction and transformation (ETL) using Informatics Power Center, exposure to Clients interaction, user- requirement analysis and user support. • Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle 10g /9i/8i, DB2, TERADATA V2R6.0, SQL Server 2003/2008. • Involved with the Full Life Cycle Development of project using Object Manager, Integrity Manager and Command Manager. • Performance monitoring, System optimization and tuning experience in Multiple BI applications. Proficient in setting up the Metadata Repository, Configuring the Intelligence Server, creating user groups, security filters, roles and privileges. • Worked along with MicroStrategy Knowledge Base to troubleshoot complex Report related issues. • Excellent problem solving skills with strong technical background and good interpersonal skills. • Quick learner and excellent team player, ability to meet deadlines and work under pressure. • Proficient in SQL Command, Joins, Metadata, creating Simple Metrics, Compound Metrics, applying Transformation, using Prompts, Filters. BI Tools Microstrategy10/9.x/8.x/7.x (Administrator, Architect, Desktop, Web, Intelligence Server, Narrowcast Server, Report Services and OLAP Services) , SAP Business Objects XI 3.1 Databases Oracle 10g,9i,8i and SQL Server (2005/2008), IBM DB2, MS Access 2000 and Teradata V2R4.1,V2R6.0, Netezza 4.0 Data Modeling Microsoft Visio, Erwin 4.5 Supporting Tools MS Project, SQL Navigator, Adobe Flash, Flex, SSH Client, Reflection X ETL Tool SSIS Languages C, Java, SQL, PL/SQL, Transact SQL, UNIX shell scripting. Web HTML, DHTML, XML, XSL, JSP, JavaScript, Microsoft Front Page, Excel OS Windows XP/2003/2000,UNIX and Linux