Summary

• Over 7 years of IT experience specific to Data Warehousing and Micro Strategy design and development
• Having experience working in both Waterfall and Agile projects
• Having good experience in designing reports using OLAP tool MicroStrategy 8.x/9.x
• Having onsite exposure for gathering functional requirements of the client.
• Having experience in preparing functional specification documents and high level design documents
• Having experience in preparing complexity definitions, project estimates, project plans and handling daily scrum calls / weekly status calls.
• Having experience in working for Proof of Concept POC assignments.
• Have good experience in creating sample dashboards for prototype in quick turnaround time for project proposals to showcase DW capability and BI advantages
• Worked Extensively on MicroStrategy Enterprise Reporting Services in creating the Documents and Dashboards for Enterprise users
• Extensive knowledge in using MicroStrategy Product Suite 9.x/8.x MicroStrategy Intelligence Server, MicroStrategy Desktop, Architect, Report Services and Web .
• Experienced in Schema design and creating Schema objects Hierarchies, Attributes and Facts, Transformations , mapping them to relational structures, user requirement analysis and metadata management.
• Proficient in creating MicroStrategy Reports by following business rules, best practices and design methodologies.
• Worked on all kinds of Data models Star Schema/ De-normalized modeling, Snowflake/ Normalized Modeling using Fact and Dimension tables.
• Extensively worked on report generation and report manipulation. Created different analysis reports, ad hoc and what if analysis reports using MicroStrategy Desktop.
• Experience in creating Documents and Dashboards that can provide an insight analysis on the business for senior management.
• Experience in development of Enterprise Dashboards, distributing dashboards and ipad mobile dashboards to business users
• Involved in Unit Testing and User Acceptance Testing.
• Capable of translating complex business needs to technical solutions.
• Capable of handling workshops and training sessions.
• Excellent working attitude with strong analytical, communication skills and the ability to work independently as well as in a team.

TECHNICAL EXPERIENCE:

PROFESSIONAL EXPERIENCE:

RELEVANT EXPERIENCE:

Description:

Confidential Sales and Marketing subsidiary of Confidential and is responsible for the distribution, marketing, sales and service of Confidential vehicles in the

Responsibilities:

• MicroStrategy architecture environment setup enhancement to facilitate stable production go-live environment.
• Understand existing MicroStrategy architecture, environment setup and perform root cause analysis for production environment failure.
• Perform load balancing tests for web mobile interface to ensure environment stability.
• Upgrade MicroStrategy environment from 9.3 to 9.4.1
• Design and development of web iPad compatible management tactical dashboards for sales subject area.
• Development of dashboards using MicroStrategy Visual Insights flash based widgets.
• Unit testing of reports and dashboards
• Creating and migrating packages across development/test/production environments using MicroStrategy object manager.
• Configuring MicroStrategy mobile server to establish connectivity for mobile/iPad users.
• User group creation and administrate access, privilege security.
• Support UAT and production go-live.
• Co-ordinate with project teams during development and post production phases.
• Provide effort and complexity estimates for project planning and management.

Description:

Confidential provides information infrastructure, storage solutions and services that help companies innovate with information to make a difference in the world. HDS offers a single, virtualized platform for all data structured and unstructured to help organizations store, manage, search and protect their information and big data in the data center and the cloud.

Responsibilities:

• Sprint planning based upon reporting requirements
• MicroStrategy architecture design and enhance project schema layer considering various parameters like cube based reporting, performance tuning, cube size and ad-hoc reporting
• Closely work with end users and business analyst from client place for requirement gathering
• Interact with data analyst and data modeler for feasibility analysis and technical design template of deliverables.
• Provide complexity and effort estimates during sprint planning
• Perform detailed impact analysis for enhancement request.
• Creation and enhancement of MicroStrategy schema objects.
• Design and development of reports and dashboards.
• Unit testing and integration testing for reports and dashboards
• Post deployment, supporting UAT phase of project
• Task allocation and technical support to development team.
• Handle daily scrum meetings using Rally tool
• Work with admin team for row level security implementation, user group creation and user access.
• Support release management team during project migrations.
• Support QA team during functional testing and data testing.
• Knowledge share with support team when required.

Description:

The Confidential is the largest drug retailing chain in the Confidential . They serveConfidential online pharmacy needs for prescriptions, health wellness products, health information, and photo services

Responsibilities:

• Mainly involved in requirement gathering and MicroStrategy Reports development.
• Effectively communicated with business users in understanding the business requirements during requirement gathering phase.
• Coordinated with Architect in providing inputs from MicroStrategy Perspective.
• Created business process documents and play back documents during requirement gathering.
• Conducted workshops with the functional team team size 11 during requirement gathering.
• Involved in creating dimension definitions and KPI's.
• Involved in MicroStrategy architecture design.
• Responsible for creation of Schema Objects- Attributes, facts and Hierarchies
• Involved in creation of Public Objects- Metrics, Filters, prompts, consolidations and reports
• Involved in applying visual alerts and auto-scheduling of reports using MSTR WEB
• Responsible for High Level Validation of MicroStrategy reports.
• Involved as a team member in creation of business case presentation.
• Involved in estimation tasks, complexity definitions and resource management tasks.
• Conducted training session on MicroStrategy for end user training
• Handled Weekly status calls coordinating with onsite and offshore team.
• Communicated effectively as single point of contact at onsite clients place from MicroStrategy perspective

Responsibilities:

• Mainly involved in Data analysis and MicroStrategy Reports development.
• Involved as team member for business process analysis
• Involved in creation of Schema Objects- Attributes, facts and Hierarchies
• Involved in creation of Public Objects- Metrics, Filters, prompts, consolidations and reports
• Involved in creation of Dashboard.
• Involved in applying visual alerts and auto-scheduling of reports using MSTR WEB
• Involved in performance tuning tasks.
• Responsible for Unit testing and Integration testing of MicroStrategy reports.
• Responsible for High Level Validation of MicroStrategy reports and dashboard.
• Created web-application end user manual for developed MicroStrategy reports and dashboard.
• Involved as a team member in creation of business case presentation.
• Involved in estimation tasks, complexity definitions and resource management tasks.

Description:

The objective of this project was to supply effective and timely information to the Retail Managers and Senior Executives for making decisions regarding effective pricing strategies and to optimize the efficiencies throughout the value chain. Implementation of this project has result in extensive communication of requirements throughout the value chain and resulted in a phenomenal decrease in lead time of Financial Analysis from over 60 man hours every week to less than 20 minutes.C S Wholesale Grocers Inc has a well-established MicroStrategy reporting environment with separate development, Quality Assurance and production systems in place. The reporting environment is based on MicroStrategy 8.1.2. The primary means of report delivery to the end users is MicroStrategy web.

Responsibilities:

• Mainly involved in MicroStrategy Report development.
• Involved in creation and implementation of MicroStrategy reports by creating schema objects and public objects.
• Extensively involved in developing Public Objects Metrics, Filters, and Reports etc. to give decision-makers a handy tool to choose the criteria for reports and view information in different perspectives.
• Extensively involved in creation of complex attributes, metrics, filters, prompts, consolidations, custom groups, transformations.
• Created complex compound metrics at different dimensionalities to count the Items sold at different store levels.
• Involved in development of documents and dashboards using MicroStrategy reporting Services
• Design, development and testing of defined reports.
• Creating and saving of different reports in different forms of view in MicroStrategy.
• Used standard testing techniques to test the data before deploying the reports to users.