Data Desktop
Resume:
Priyanka
*************@*****.***
Summary:
* ***** ** ********** ** Data warehousing, Data Modeling using MicroStrategy Platform, Business Intelligence systems, OLAP environments and tools.
Strong experience using MicroStrategy 9.x/10.x/11.x Suite Intelligence Server, Administrator, Architect, Desktop, Web, Business Objects 5.x Web intelligence and Desk, Tableau Desktop and reader.
Worked with MicroStrategy Architect to build Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
Created Transformations Table based, Formula based for using in comparative reports like sales of various products this year to last year, year to date and month to date.
Creating Logical views in MicroStrategy to support the new requirements.
Managed schema development changes/enhancements effectively. Extensively worked in creating Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
Worked on Various Complex Data models involving both Star and Snowflake schema.
Worked with the Business Analysts and involved in gathering Business requirements and determining the appropriate facts, attributes and metrics from the same and documented them.
Guided the business users by creating prototypes for the Dashboards and Scorecards.
Involved in Analysis, Design, Development and Implementation of Business Intelligence and Maintaining Applications using MicroStrategy DSS Tool suite.
Worked extensively on MicroStrategy Desktop, Administrator, Intelligence Server and Web.
Worked closely with MicroStrategy Narrowcast Server applications.
Provided complex Reports in MicroStrategy Desktop and MicroStrategy Web using Templates, Filters, Prompts, Consolidations and Custom Groups.
Extensively worked on the intelligent cubes and created reports out of it.
Developed Reports, Flash dashboards and Interactive documents extensively from Desktop and Web.
Experience in Visual Insight Services.
Involved in creating Custom Documents in MicroStrategy to combine the Data sets of multiple reports and created Custom Dashboards and Scorecards using Report Services.
Extensively worked on the Object Manger to move the Objects between different Environments.
Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, and Performance monitoring.
Tuned the reports to enhance performance and reduce the running time.
Expertise in calling reports by passing parameters through Edit links and hyperlinks in reports and dashboards.
Very proficient in working with large Databases like Oracle, Teradata and SQL Server.
SKILLS:
OLAP/ Business Intelligence/Reporting Tools: MicroStrategy Desktop 9.2.1, 9.0.x, 8.x, 7.5; MicroStrategy Architect; MicroStrategy Web; MicroStrategy Intelligence Server; MicroStrategy Narrowcast Server; MicroStrategy OLAP Services; MicroStrategy Object Manager; MicroStrategy Mobile.
Databases: SQL Server, Oracle, Teradata.
Programming Languages: C/C++, PL/SQL.
Others: MS Office Suite, MS Project.
Operating Systems: Windows, Unix/LINUX.
PROFESSIONAL EXPERIENCE:
Project: PRR (Portfolio Review Rating) April 2019 – Till Date
Company: Virtusa Corporation
Client: Citi Bank, Tampa, FL
Role: Sr. MicroStrategy Developer
The Portfolio Risk Review Capability will enable Citi to perform portfolio monitoring and analysis for Citi’s Wholesale and Retail portfolios. This capability requires timely and accurate transaction or loan level data, including relevant client and risk metric data. The timing of these capabilities, on a BAU basis, will range from intraday to monthly or quarterly depending on the requirement. However, each of these capabilities may require execution on an ad-hoc basis.
Responsibilities:
Involved in the documentation of technical specifications of the Project.
Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
Created different Project Sources for different environments like production, testing and development.
Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
Created Ad-hoc reports by gathering specific requirements from the different users.
Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
Created Subscription sets, documents, publications and services for delivery of reports through Narrowcast.
Validated end user requirements using MicroStrategy tools.
Created Question Objects for Personalized execution.
Extensively involved in Troubleshooting of Narrowcast services delivery.
Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
Worked with end users along with Business Analysts to build reports and dynamic dashboards.
Worked with the DBA on issues of database performance and security.
Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
Involved extensively in the overall lifecycle of the Data Warehouse integration project.
Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, Information objects.
Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that user.
Worked on the excel formatting, macros and templates of the documents which are used in different services.
Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
Involved extensively in the overall life cycle of the Data Warehouse integration project.
Project: KMA Dealer Master, HMA Genesis July 2014 – Jan 2018
Company: Steplabs IT Solutions Pvt Ltd
Role: MicroStrategy Developer
The objective of the KMA Dashboard is to consolidate data from multiple data sources into a centralized data warehouse and provide a means where users can easily access summarized information when needed to answer questions. Web and mobile intuitive dashboards in MicroStrategy will help user to access data quickly and in a timely manner.
The overview of HMA Genesis project is to provide access to Genesis data through
MicroStrategy. Currently, EDW data gets a batch feed of the Hyundai data from various sources and now it will be enhanced by adding more columns to the existing layout to include the Genesis data. The data will be accessed by all users
Responsibilities:
Involved in Data Modeling and Data Warehousing Using Multi-Dimensional Model, Star and Snowflake Schemas.
Identified and defined Facts, Attributes, Hierarchies and Relationships.
Running Scripts for building Metadata and define the lookup and facts tables for use in the MicroStrategy Agent.
Using MicroStrategy Agent (Templates, Filters, Metrics) to generate advanced reports in grid, graph, and SQL mode, consisting of data analysis by combining a template with filters. The end users were able to generate ad hoc report by drilling up, down, within and across dimension or anywhere.
Enterprise manager was used to validate the data presented in the desktop.
Various queries were written for optimization, exploited the indexing
With SQL Server 2000 different features were used like user-defined functions, enhancements to triggers, cascading constraint capabilities, indexed views and view enhancements, updateable union views called distributed partitioned views, support for collations, extensions to property definitions, new built-in functions.
Developed PL/SQL Business Functions, which were used with MicroStrategy Reports.
Created MicroStrategy Filters, Prompts, Drill Maps, Transformations, Documents, Facts, Attributes, Hierarchies etc. for Developing Project.
Creating complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality and conditional, generating Data Marts with per and post SQL for the Data Mart Tables.
Creating all possible Metrics for users to build there owns reports on Web by creating their own Templates and filters and use the available Metrics.
Using Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
Designed and developed Web Reports and worked in MicroStrategy Web Customization
Caching Reports in the Intelligence Server daily, enabling user to run the report immediately.
Created users, roles & privileges in the MicroStrategy Environment.
EDUCATION
Bachelors from Jawaharlal Nehru Technological University, Kakinada, India.
Contact this candidate