PROFESSIONAL SUMMARY:

• 12 Years of experience in Administration, Design, Development, Testing MicroStrategy and Apache Spark application and MicroStrategy based business intelligence reporting systems for Telecom, Banking, Financial Services, Healthcare providers and Payment Processing.
• Proficient in 11,10.X/9.X/8.X Product Suite (including OLAP Services, Administration, Web Universal, Dynamic Dashboards/Report Services).
• MicroStrategy Installation and maintenance on clustered environment on windows, UNIX and Linux environments.
• Experience in MicroStrategy Developer role functions such as developing Reports, Documents, Dashboards & other underlying Application objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, and Searches & Templates).
• Experience in setting up drill paths using Custom Drill Maps, Hierarchies path setup and managing Project Drill Map.
• Experience in MicroStrategy Administrator functions such as designing Security Roles, Security Filters, User Groups, setting up Custom Authentication for MicroStrategy Web.
• Experience in using advanced techniques such as URL API, AutoText, HTML Container along with Javascript coding, hidden selectors, etc.
• Experience in MicroStrategy Web Customization using Web Customization Editor for making layout changes and creating plug - in for Prompt Answers, External Security Module, Toolbar customization, Portal customization.
• Experience in determining system level parameters such as Governing Settings, User Session management, Job Management, Cache management, Job Prioritization settings, Performance Tuning using VLDB settings
• Experience in using data warehouses hosted in Oracle, Netezza, Teradata, SQL Server
• Managed and lead a team of DW&BI developers
• Mostly worked in Onsite and Offshore Model.
• Experience in handling BI projects involving high data volume & complexity.
• Self-Motivated, innovative problem solver with a strong customer focus

SKILL:

MicroStrategy 11/10.x/9.x, Tableau

Desktop, Intelligence Server, Web Server, Mobile Server

Administration, Architect and Development

Dashboards, Visual Insight and Data Mart reports

Performance Tuning

Apache Tomcat, IIS, WebLogic and JBOSS

Windows, Linux RHEL, Unix

System Manager, Command Manager, Integrity Manager and Object Manager

Unix Shell Scripting

WORK HISTORY:

MicroStrategy Administrator

Confidential, Charlotte, NC

Responsibilities:

• Managed user security through security roles, security filters and assigned them to groups to meet requirements.
• Automated data load tasks using system manager workflows.
• License administration across all environments using License Manager Tool.
• Automated admin activities using command manager scripts.
• Administration of System Manager, Command Manager, Integrity Manager and Object Manager.
• Develop Linux batch scripts and also managed existing scripts.
• Upgraded Microstrategy platform from v10.4 to v11.
• Performed major upgradation from end to end on Linux environment.
• Involved in procuring necessary hardware and software for upgradation.
• Microstrategy Installation and configuration of I-server, web server and mobile server on clustered environment.
• Created metadata and statistics tables for MicroStrategy project on oracle sever.
• Deployment of MicroStrategy objects across different environments.
• Configured Platform Analytics and HyperCard's.
• Created several enterprise manager statistics report on usage of environment.
• Monitoring Teradata view for MicroStrategy queries.
• Environment: MicroStrategy v11.1, SQL Server, Oracle, Teradata, RHEL, JIRA and Service Now.

MicroStrategy Architect

Confidential, Plano, TX

Responsibilities:

• Worked on Card, Settlement and Auth & Capture Projects and created traditional grid reports, freeform SQL reports.
• Worked closely with business to gather requirements and Involved in prototype design for dashboards and reports based on requirements.
• Coordinate, mentor and provide architectural guidance to other MicroStrategy Developers.
• Created views, stored procedures and on top of that created freeform SQL reports.
• Worked on Gift Card Liability Dashboards.
• Implemented MicroStrategy Schema objects by creating facts, attributes, hierarchies using MicroStrategy Desktop and Architect.
• Extensively worked on creating Application Objects like Metrics and Compound metrics, Filters, Custom Groups and Consolidations for complex reports.
• Worked extensively on designing intelligent cubes and creating complex reports which are sourced from them.
• Designed dynamic dashboards with multiple layouts to support user specified requirements.
• Extensively worked on Designing & Developing complex Dynamic Dashboards using Panel Stacks, Selectors, Layouts and Widgets.
• Created Dashboards using various widgets like Micro charts, Time Series Slider, Heat map and Gauge.
• Created Report Service documents with Drilling using Hyperlinks and edit links to various detail reports and Dashboards.
• Developed Interactive dashboards using report service in different modes by using time slider and ESRI maps across various project environments.
• Using partition filters against Impala on HBase, able to see great improvement in performance.
• Used Distribution Services for personalized Report distribution.
• Involved in troubleshooting MicroStrategy Web reports, optimizing SQL using VLDB Settings.
• Involved in setting up demos to end users and stack holders.
• Created Transformations for using in comparative reports.
• Involved in Performance tuning of SQL queries.
• Environment MicroStrategy 10.1, Report Services document, Dashboards, Reports, Templates, Web SDK customization, Netezza, Eclipse, Rally, Confluence.

Sr. MicroStrategy Developer

Confidential, Plano, TX

Responsibilities:

• Worked with client to gather requirements and Involved in prototype design for dashboards and reports based on requirements.
• Designed MicroStrategy Project Schema/Architecture and involved in suggesting changes to Logical Data Model as per Business Requests and implementing same in MicroStrategy Project Schema.
• Involved in writing Functional & Technical Design documents.
• Responsible for complete Functional Analysis for all Data Marts and Data Warehouse for regular Releases and Projects, which requires frequent interaction with Business Users.
• Develop Facts, Attributes, Hierarchies, Dashboards, Reports, Metrics, Compound Metrics, Filter, Prompts, Consolidations and Custom Groups, Templates for Performance Management Reporting project.
• Develop Metrics, Compound Metrics, Filters, Templates, Consolidations, Auto Prompt Filters and OLAP Reports.
• Develop/enhance Report Service Documents such as Spend Overview, Tier Optimization, Market Share, Market Fragmentation, and New Items.
• Develop/update Transaction Details template set for template drilling.
• Creation of Intelligent cubes and sharing to reduce database load and decreasing report execution by using Cube Services.
• Used Intelligent Cube datasets to provide performance for dashboards.
• Involved in configuring Mobile server and consolidating existing datasets for Mobile dashboards.
• Performed testing for mobile dashboards using iPad.
• Interact with ETL team and Architect teams to build schema based on requirements signed off by user.
• Create schema objects in MicroStrategy Developer tool for reports and dashboards in MicroStrategy Web.
• Coordinate, mentor and provide architectural guidance to other MicroStrategy Developers.
• Design, develop and maintain User Administration program and Performance Analytics Web application.
• Provide production support for spend Sourcing Analytics.
• Involved in creating and maintaining user groups in MicroStrategy for different kinds of users.
• Migrating projects and objects between production and lower environments using Object Manager.
• Worked with DW team including Data Architect, ETL, DBA and MicroStrategy teams on accomplishing requirements of dashboards and accomplishing robust data architecture.
• Responsible for End User Training across four important Business Units at Alliance data, which includes both MicroStrategy Desktop and Web Interfaces Environment MicroStrategy 9.4.1, Report Services document, Dashboards, Reports, Templates, Web SDK, Prompt page customization, Teradata 13.10, Eclipse, Microsoft TFS for Agile Development.

Sr. MicroStrategy Developer

Confidential, Waltham, MA

Responsibilities:

• Upgrade environment to latest hotfix.
• Involved in upgrading whole platform (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server) to MicroStrategy 9.0 Hotfix 4 and MicroStrategy 9.3.
• Handling customization request such as changing MicroStrategy Web messages during data load and handling custom authentication requirements using MicroStrategy Web API.
• Using Enterprise Manager project to report system statistics such as Usage Report, Long running reports, Highly used project / report, etc.
• Coordinating with project team to Tune reports for best performance and minimum load to system.
• Coordinated with MicroStrategy Premium Support group to resolve server stability issues.
• Migrating projects and objects between production and lower environments using Object Manager.
• Reverse migration of objects from production environment to non-production environments for user created objects using Object Manager and Project Merge Wizard.
• Keeping environment in compliance with license using MicroStrategy License Manager Maintain folder level access and setup ACL for various public folders Environment MicroStrategy 9.3, Oracle 10g, Tomcat, Linux, Rally for Agile.

Sr. MicroStrategy Developer

Confidential, Phoenix, AZ

Responsibilities:

• Responsibility for creating new reports, metrics with other public and schema objects.
• Use Warehouse Catalog to bring in new Lookup and Fact tables.
• Develop new Attributes, Facts and Hierarchies.
• Update table mappings, relationships for existing Attributes and Fact mappings.
• Setup test accounts with various roles and access levels to be used in Integrity Manager.
• Develop Dashboards, Reports, Metrics, Filters, Prompts and other supporting application objects.
• Code development & Unit Testing.
• Responsibility for creating new reports, metrics with other public and schema objects.
• Creation of interactive dashboards on reports.
• Involved in Microstrategy Administration.
• PMR Production activates - Change requests, impact analysis and issue fixes.
• Involved in creating user stories Environment MicroStrategy 9.0.2, MicroStrategy Architect, Dashboards, Reports, Metrics, Filters, Prompts, Attributes, Facts, Object Manager, Integrity Manager, Confidential .
• DB2.

MicroStrategy Developer

Confidential, Phoenix, AZ

Responsibilities:

• Gather merchant reporting requirements and Architect new Lookup and Fact tables to bring in new Attributes and Facts into project.
• Use Warehouse Catalog to bring in new Lookup and Fact tables.
• Develop new Attributes, Facts and Hierarchies.
• Update table mappings, relationships for existing Attributes and Fact mappings.
• Setup test accounts with various roles and access levels to be used in Integrity Manager.
• Use Integrity Manager for any regression testing by SQL and Data comparison of existing reports after schema/table/relationship mappings changes.
• Develop Dashboards, Reports, Metrics, Filters, Prompts and other supporting application objects.
• Design new Security Roles and User Groups.
• Work with Portal team for integration and develop new Addons using MicroStrategy SDK for landing page Dashboard display requirements and Dashboard export requirements Environment MicroStrategy 9.0.2, MicroStrategy Architect, Dashboards, Reports, Metrics, Filters, Prompts, Attributes, Facts, Object Manager.

MicroStrategy Developer

Confidential, Phoenix, AZ

Responsibilities:

• Responsibility for creating new reports, metrics with other public and schema objects.
• Code development & Unit Testing.
• Responsibility for creating new reports, metrics with other public and schema objects.
• Creation of interactive dashboards on reports.
• Involved in Microstrategy Administration.
• Involved in creating user stories.
• Deploying changes using object manager.
• Sharing Support Responsibility for Estimation, IT, UAT & Deployment Environment MicroStrategy 9/8.1, Desktop, Architect, IntelligenceServer, MicroStrategy Web, Command Manager, Object Manager, Configuration Wizard, Project Mover, Scan MD, MD Doctor, MicroStrategy SDK for customization).

MicroStrategy Developer

Confidential, Phoenix, AZ

Responsibilities:

• Responsibility for creating the new reports, metrics with the other public and schema objects.
• Code development & Unit Testing.
• Responsibility for creating new reports, metrics with other public and schema objects.
• Creation of interactive dashboards on reports.
• Involved in Microstrategy Administration Environment MicroStrategy 9.0, Report Services document, Dashboards, Reports, Templates.

MicroStrategy Developer

Confidential, Detroit, MI

Responsibilities:

• Understanding user requirements and develop reports and its corresponding Confidential services.
• Involved in Microstrategy schema object, public objects creation and Confidential service creation.
• Creating users, Monitoring jobs, deploying changes using Object manager.
• Upgrade Microstrategy 8.0.1 to Microstrategy 8.0.3.
• Responsibility for creating new reports, metrics with other public and schema objects.
• Creation of interactive dashboards on reports.
• Code development & Unit Testing.
• Responsibility in Executing System Test Cases.
• Sharing Support Responsibility for Estimation, IT, UAT & Deployment Environment MicroStrategy 8.0.1, Report Services document, Dashboards, Reports, Oracle.