SUMMARY

• 7 plus years of extensive experience in the field of Information Technology with Data Warehousing, Data Architecture, Data Modeling, Business Intelligence and ETL Applications.
• Extensive Working Experience with MicroStrategy 7.x/8.x/9.x, 10, Micro Strategy Desktop, MicroStrategy Visual insight, MicroStrategy mobile, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Architect.
• Created different types of objects attributes, metrics, filters, prompts, Custom Groups, Consolidation & also created security model for all users.
• Involved in all phases of System Development Life Cycle (SDLC) including Business Requirements Gathering, Analysis, Design, Development, Testing, and Implementation of Data Modeling, Data Warehousing, Business intelligence and OLAP Applications using MicroStrategy.
• Involved in Tuning MicroStrategy reports for best SQL performance and efficiency.
• Understanding the existing BI environment, translating into new environment requirements and planning tasks to meet those requirements.
• Created ad - hoc reports, Designed and created new schema objects and modified existing schema objects for evolving reporting needs.
• Created various Schema objects with MicroStrategy Desktop like simple and Compound Metrics, Fact Extensions and Hierarchies, etc.
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• In-depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data marts, Secu rity and deployment, FACT and Dimensional tables, Logical and Physical data modeling.
• Worked on Transaction services and Configured Transaction
• Involved in performance tuning & improvements for existing OLAP systems.
• Very Strong Experience in MicroStrategy Report Services, Experience in developing Dashboard & Mobile Reports and dashboards. .
• Validating data returned in all reports, provide a detailed analysis of data, and identify data quality issues.
• System Optimization, performance monitoring and tuning experience in MicroStrategy Business Intelligence environment using MicroStrategy Enterprise Manager.
• Document new development, procedures, or test plans as needed
• Worked on waterfall and Agile software development life cycle process to data development projects
• Well conversant with current MicroStrategy products and tools and have means to solve any issues by reaching out to MicroStrategy Support and Forums.
• Excellent communication skills with ability to work independently as well as collaboratively in team environment to contribute problem-solving strategies. At ease in interacting with people at all levels, able to work under pressure.
• Hands on experience working on Tableau Suite (9.X/8.x/7.x) (Desktop, Server, Reader, Online, Public)
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams .
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms

TECHNICAL SKILLS

Business Intelligence: MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Narrowcast Server, Business Objects and Tableau

Databases: Oracle 8i/9i/10g, MS Access, MS SQL Server, Teradata, MySQL

Programming Languages: SQL, PL/SQL, Java, UNIX shell scripting, C, C++

Operating System: Windows, Linux, Unix

ETL Tools: DataStage, Informatica

Email Clients: Microsoft Outlook, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential

Sr. Microstrategy Consultant

Responsibilities:

• Effectively Tuned Microstrategy implementation for greater performance based on recommendations from internal testing.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Created the Report Specification document and had it signed of, after suggesting some useful alterations.
• Worked on Transaction services, have configured Transaction Report on Microstrategy Web.
• Created a transaction-enabled document or dashboard that inserts new data&colon
• Involved in and provided solutions for complex Time Dimension related issues and analysis.
• Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model .
• Generated and implemented Microstrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Microstrategy Desktop and Architect.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes .
• Created Complex filters with advanced qualifications involving the 'Apply' functions .
• Created Customized Hierarchy for Drill Maps.
• Created Transformations for using in comparative reports from this year to last year.
• Used Conditional formatting to personalize documents as per user perspective
• Used the Object Manager to move the objects from Development to Production Environment in Microstrategy. .
• Responsible for maintaining the Intelligence Server including the Metadata repositories for different environments.
• Extensively worked on Report Services to create performance dashboard reporting .
• Worked along with Microstrategy Knowledge Base to troubleshoot some Report related issues.
• Played a key role in User Acceptance Testing of the reports.

Confidential

Sr. Microstrategy Consultant

Responsibilities:

• Responsible for MicroStrategy and all its services, clustering, installation and configuration in a Windows platform.
• Provided administration and implementation support for various tools in MicroStrategy including MicroStrategy Developer, MicroStrategy web, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Intelligence Server, MicroStrategy OLAP Services, MicroStrategy Distribution Services, MicroStrategy Analytics, MicroStrategy Transaction Services, and MicroStrategy iCubes.
• Planning and applying patches, upgrading MicroStrategy from one version to another.
• Security setup, project maintenance, developing standards, practices, documentation, backups, migration of MicroStrategy projects and objects.
• Worked on MicroStrategy schema objects, application objects and configuration objects.
• Worked with various MicroStrategy Reporting Suite tools such as MicroStrategy Developer, MicroStrategy web, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Intelligence Server, MicroStrategy OLAP Services, MicroStrategy Distribution Services, MicroStrategy Analytics, MicroStrategy Transaction Services, MicroStrategy iCubes
• Worked on error analysis, performance tuning, and validation and testing of reports, dashboards on Micro Strategy platform.
• Worked on mapping data elements to MicroStrategy objects, implementing security model-User, Object and Data security.
• Understanding Existing Schema Design and helped SAP BO team to build Schema.
• Created Schedules and Subscriptions-Email, File, History List.
• Worked on Oracle 11g, Oracle 12c, and SQL Server with a clear understanding of relational database models.
• Analyzed business processes and fixed problems in order to effectively develop technical solutions to the requirements.
• Effectively communicated and provided solutions for issues, with both business and technical teams.
• Worked in a high paced environment.
• Worked on analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirements.
• Fixed Reports, Documents and Dashboards issues to get exact data.
• Maintained all necessary MicroStrategy tool updates and/or vendor patches and own deployment planning and coordination of changes with impacted areas.
• Provided access and maintained all users by creating user groups and maintained security.
• Responsible for documenting the Functional & Technical Design documents.
• Worked with the users, understood the requirements and designed Dashboards and Reports accordingly.
• Fixed issues with Intelligent Cubes and populated exact Data into Reports.
• Created Attributes, Metrics on Facts, Filters, Prompts as per the Business requirement.
• Worked on Set up of Enterprise Manager on Server and maintained it.
• Provided access to users and created Security Roles and Group assignment.