SUMMARY

• 8+ years of IT Experience with well acquainted in performing as MicroStrategy Developer, Architect and Administrator using MicroStrategy tool Suite with Strong Domain Knowledge of Telecommunication, Healthcare & Retail.
• Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Mobile, Enterprise Manager, Command Manager, Object Manager, Integrity Manager, Operations Manager, Systems Manager, MicroStrategy Narrowcast Server and OLAP Services Environment.
• Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy and exposure to Clients interaction, user - requirement analysis and user support.
• Experience in MicroStrategy Architect, User security & management, Object Manager & designing reports (grid, drilldown, ad hoc, OLAP cube) and dashboards in MicroStrategy 10.x/9.x/8.x Product Suite.
• 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.
• Experience in data extraction and transformation (ETL) using Informatics Power Center.
• Extensive knowledge on SQL/PLSQL and very proficient in working with databases -Oracle 12g/10g /9i/8i, Teradata V2R6.0, SQL Server 2003/2008/2012.
• Involved in Projects like Full Life Cycle Development of Data Warehousing, Project planning, business Requirement Analysis, and Logical Data Modeling, setting up Physical Schema, Data Marts, OLAP, Reporting and Security.
• 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. Excellent problem-solving skills with strong technical background and good interpersonal skills.

TECHNICAL SKILLS

BI Tools: MicroStrategy10.x/9.x/8.x (Architect, Developer, Administrator, Desktop, Web, Intelligence Server, Narrowcast Server Report Services and OLAP Services), SAP Business Objects XI 3.1

Databases: Oracle 12g/10g,9i,8i, MS SQL Server (2005/2008/2012 ), MS Access 2000, Teradata V2R4.1, V2R6.0

ETL Tool: Informatica

OS: Windows 10,7,8, XP/ 2007/2013/2016 Vista/10

PROFESSIONAL EXPERIENCE

Confidential

MicroStrategy Architect / Developer

Responsibilities:

• Worked extensively with Business Analyst on Agile Methodology to finalize the dashboard layouts and worked on fine detail formatting for a desired look and feel.
• Generated and implemented MicroStrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using MicroStrategy Architect .
• Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Created multiple reports connected to publish intelligent cubes to provide quick access of data and report execution.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies.
• Actively worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Coordinated in moving the objects from Development to Production Environment in MicroStrategy by using Object Manager.
• Analyzed legacy reports and understand the data flow, relations and business needs and recreated the reports in MicroStrategy.
• Created Summary and Drill down reports for various attributes based on their hierarchies.
• Worked on creating transaction services enabled document by linking Transaction Services report to a grid, or text fields in a panel stack for users to view and edit the business data.
• Created ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Responsible for monitoring the performance and stability of the software during performance test prior to going-live and after going-live continued to monitor as part of the post-production support.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Trained end users and power users on the functionality and usage of MicroStrategy Reports.
• Worked along with MicroStrategy Knowledge Base to troubleshoot complex Report related issues.
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Assisted Business System Analysts in user training and creation of accurate documentation.

Environment: MicroStrategy 10.11.0, Oracle 12g, Toad for Oracle, Windows 2016, MS Access 2016

Confidential

MicroStrategy Architect/ Developer

Responsibilities:

• Involved in gathering business requirement meetings and preparing BRD documents
• Utilized advanced components/features such as VLDB properties, I- cubes and Free Form SQL, consolidations, custom groups, advanced metrics, and relationship filters.
• Worked with ETL developers to define data mapping documents and Database design.
• Fixed data issues in operational and BI reports with a strategy to identify the error and fix them for the next run on the data issue identified and the ideal solution after the unit testing was provided to the quality assurance team.
• Created multiple reports connected to publish intelligent cubes to provide quick access of data and report execution.
• Created dashboards exclusively for mobile purposes using custom widgets like (bubble, gauge, Heat Maps etc.)
• Onsite training & demonstration for new business users and providing clarification to business users when and required.
• Offshore Coordination- Guiding and helping team in resolving complex production issues.
• Created advanced metrics and advanced prompts which were used for complex reports.
• Designed and developed MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Developer.
• Developed test cases/scenario and QA metric in support of test execution.

Environment: MicroStrategy 10.2/10.4.5 , MS SQL Server 2012, Windows 2013, Oracle 10g,9i,8i, MS Access 2013

Confidential

MicroStrategy Architect/ Developer/ Administrator

Responsibilities:

• Involved in gathering business requirement meetings and preparing BRD documents.
• Created Multi layout report services document with multiple panel stacks, selectors, information windows, Hyperlinks (Passing Prompt Parameters to destination report).
• Worked on Visual Insight dashboards which includes ESRI Maps and freeform definition reports for Transactional services reports allowing user to write back to the databases.
• Upgraded MicroStrategy environment from 10.2 to 10.4.5. Technical lead for the upgrade and the servers including I-servers, web servers, Narrowcast servers, Enterprise Manager, etc. Successful upgrade with zero issues.
• Developed Transactional report services documents using Free Form SQL definition reports
• Configuring and setting up Enterprise Manager for statistical Analysis and used Command Manager for bulk operations through creation of automating scripts.
• Worked extensively on migrating objects from Development to Production using Object Manager tool.
• Onsite training & demonstration for new business users and providing clarification to business users when and required.
• Offshore Coordination- Guiding and helping team in resolving complex production issues.
• Worked closely with other applications across the organization to analyze and support cost modelling processes through invoking JSON Web Service via restful web service and API interface.
• Worked on displaying real-time information from the web in the dashboard using HTML containers that allows users to render HTML code directly in the document.
• Execute periodic -- weekly & monthly standard reports consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Worked on configuring the Intelligence Server, creating user groups, security filters, roles, and privileges.
• Worked on Creating Security Roles, MicroStrategy User Groups and Users, assigning security roles to Users and Groups and involved in creating security filters to end users to access data based on their privileges.

Environment: MicroStrategy 10.2/10.4.5 , MS SQL Server 2012, Windows 2013, Teradata V2R4.1, V2R6.0 MS Access 2013