Manager Data

Priya K

Email:**********@*****.***

Cell: 214-***-****

Professional Summary

3+ years of experience within MicroStrategy suite 10.1/9x and MSTR Components (Intelligent Server, Administrator, Architect, Desktop, Web, Narrowcast server).

Extensive experience and knowledge within Data Warehouse includes: Dimensional Modeling, Star, Snowflake, Hybrid Schemas, Data Marts, OLAP, Fact and Dimension Tables.

Expertise in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, and Prompts) with the data warehouse.

Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.

Working experience with Tableau, OBIEE and Cognos migrations to MicroStrategy.

Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, and Prompts) with the data warehouse.

Developed reports related to Market Research & Analysis. Have also worked on reports for design & modeling of Supply Chain, Economic Analysis of Industrial Projects, Resource Planning, and Project Cost Estimation.

Solid experience in gathering data requirements, business rules to build large enterprise warehouses.

Active participation in design and implementation of physical and logical modeling of Data warehouse and Data marts.

Good experience in working with VLDB (Very Large Data Bases) on Oracle 8i/9i/10g, DB2, Teradata, and SQL Server with MicroStrategy Suite.

Expertise in developing Scorecards & Dynamic Dashboards and good experience in using Report Services.

Experience in developing Delivery Reports using MicroStrategy Narrowcast Server.

Good Knowledge in Object Manager, Enterprise Manager, Command Manager.

Experience in using VLDB properties for performance tuning and also worked with DBA in troubleshooting.

Good Experience in using SQL query analyzer for validation of report data

Experience in gathering report requirements, from the business users and translating Business needs into end-user Reports.

Have worked on Mobile applications (I pad and I phone) and Visual Insights.

Involved in Software Development Life Cycle (SDLC) process.

Excellent experience working with various business teams, Supported QA Manager for Preparation of Quality Plans, Review and Approval of Project plan and Project documents, Collection and Compliance of project metrics.

Ability to adjust to new and challenging situations with experience in handling.

Technical Strengths:

OLAP Tools: MicroStrategy 10.1/9X/8X (Architect, Desktop, Web, Narrowcast,

Object Manager, Enterprise Manager), Tableau 9.0.3, SSRS

ETL Tools: Informatica, SQL Server DTS

Data Modeling: Erwin 4.0/3.5.2

RDBMS: Oracle 11g/10g, Teradata 13.10, SQL Server.

Languages: SQL, PL/SQL, C, C++, VB Script, HTML, XML and DHTML

GUI: Developer 2000 (Forms, Graphics, Reports), Visual Basic 6.0.

Operating Systems: Windows NT/2000/XP/ME/95/98, UNIX

Professional Experience

Home Depot, Atlanta, GA May 14 – Till Date MicroStrategy Consultant

Roles and Responsibilities:

Involved in the installation of MicroStrategy suite and later involved in the version up gradations.

Worked on multiple projects like Project One, BI Enhancements, Vendor Reporting, Insighthd, Mobile Dashboards, and Merch Link Analytics serving different business teams, providing solutions for critical requirements.

Worked closely with business teams for better understanding of their needs and also the business processes.

Gathered requirements, analyzed, designed, coded and then implemented the solutions for Merchandizing and Store Ops applications.

Interacted with Data Architect in building Views and Table structures.

Created Relationship tables to avoid Many-Many relationships between parent and child attributes.

Suggested aggregate tables for improving performance of dashboards.

Architecture and Developed an application with multiple dashboards embedded that supports Single Sign-On through a SharePoint portal.

Designed and implemented History List and Email subscriptions for the Merchandising application.

Created attributes by understanding the complexity of data and created relationships, hierarchies among the attributes.

Extensively developed MicroStrategy Schema objects and Application objects.

Created dashboards and related reports for the Enterprise level applications built at Home Depot.

My Numbers application is implemented in more than 2000 stores, with around 30,000 Users.

Created Intelligent cubes for the better performance of the Dashboards

Implemented ACL’S for the dashboards to restrict 23 roles within the application to control the dashboards.

Implemented Adaptive metrics concept for the metrics to control the time transformation inside the metrics which can dynamically run through all the time slices required for the project.

Created complex and compound metrics to get the required result as per the business requirements.

Created complex time filters for the trend graphs to work dynamic with desired time period.

Extensively created packages to migrated objects from one environment to another by using object manager.

Created Base formulas & Templates as a best practice.

Implemented the Object prompts to pass attributes dynamically through the dashboards depending on the level of the user.

Created advanced level metrics, prompts and transformations for the project.

Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.

Created links on metrics to open up a new detailed reports when clicked on it.

Used apply functions to execute the database specific function in the metrics and filters.

Used sections in the report services documents to create related reports and printer-friendly documents.

Involved in Testing and Tuning of reports and dashboards.

Worked with offshore and onsite teams to validate the requirements and assure user acceptance, to determine the technical solutions for the applications.

Majorly assisted co-team members in finding the solutions for the critical requirements during the code development.

Trained business users on the major functionality of dashboards and reports.

Played a key role in supporting business users and end users to provide solutions on the major functional and data issues.

Environment: MicroStrategy Product Suite 9.4.1 (Desktop, Architect, Web, Object Manager, Narrowcast Server, Enterprise Manager, Integrity Manager, Command Manager, Mobile), Teradata 13.10, SQL Server 2008, DB2, Ab Initio, UNIX, HP Quality Center 10.0

IMS Health, Plymouth Meeting May 2011- Dec 2012

MicroStrategy Consultant

Roles & Responsibilities:

Interacted with Users to get the business needs.

Implemented Star Schema to fit reporting, query and business analysis requirements.

Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies, Transformations.

Responsible for creating Metrics, Filters, Custom Groups, Prompts using MicroStrategy Desktop and Web.

Involved in troubleshooting MicroStrategy prompts, filter, consolidations, and custom group objects in an enterprise data warehouse team environment.

Optimized Query Performance by using VLDB settings.

Participated in configuration of Narrowcast Server.

Developed XSL style sheets to match the corporate standards for reporting.

Environment: MicroStrategy 9.0.1 Product Suite (Architect, Desktop, Narrowcast Server, Object Manager, Web) Teradata, SQL server, Informatica, Windows XP.

Education:

Masters in computer science.

Contact this candidate