Microstrategy

Prasanna KK.

Summary:

A Skilled professional with 8 Years 5 Months of rich experience in handling software projects encompassing onsite &

•

offsite planning, proposal, implementation, integration, testing and maintenance for large web applications & software

using diverse technologies; Domain knowledge in Banking and financial, Manufacturing, Automobile,

Telecommunication and Retail Domain..

Strong experience using MicroStrategy Business intelligence Suite 9.x/8.x ( Intelligence Server, Administrator,

•

Architect, Desktop, Web, Visual Insight, OLAP Services, Report Services, Dashboard, Distribution Services,

Narrowcast Server, Microstrategy Office, Object Manager, Enterprise Manager, Command Manager and Integrity

Manager).

Experience in designing the logical model by creating Schema objects (attributes, facts, hierarchies, transformations

•

and logical views) using the data warehouse

Experience in creating Applications objects like filters, metrics, prompts, reports, report services documents,

•

templates.

Experience in using OLAP Services like View filters, derived elements, derived metrics, Intelligent Cubes and

•

published I cubes using Incremental fetch functionality for specific periods.

Expertise in creating Dynamic Enterprise Dashboards using selectors, widgets and drill links.

•

Expert at Planning, analysis, design and development of complex reports and scorecards for several business units.

•

Through knowledge Dimensional Modeling like Star schema and Snowflake schema.

•

Experience in designing, developing, debugging and enhancing reports by following business rules using

•

MicroStrategy desktop and MicroStrategy web.

Worked on MicroStrategy administration including intelligence server administration, configuration of memory

•

settings, performance monitoring and VLDB settings.

Experience in creating complex filters with advanced qualifications involving the by pass functions.

•

Experience in creating time series transformations like YTD, MTD, LY, PY etc. using Transformations.

•

Experienced in working with different databases like Oracle, DB2 and SQL Server.

•

Experience in writing and troubleshooting SQL for report development as well as testing.

•

Extensive knowledge in end to end development of software products from requirement analysis to system study,

•

designing, coding testing, de bugging, documentation and implementation.

Skilled in coordinating with the Business Groups, End User’s to gather requirements and analyzing the business

•

process, implement the business application and making necessary changes to Application objects and Schema

objects.

Experience in Creating Visual insight dashboards in Microstrategy Web.

•

Excellent communication, interpersonal and management skills.

•

Team oriented, self motivated and a disciplined individual.

•

Experience in designing data visualizations using Tableau.

•

Certifications:

MicroStrategy Certified Report Developer(MCRD) from MicroStrategy University on July 2012

MicroStrategy Certified Project Designer(MCPD) from MicroStrategy University on Aril 2014

SQL Fundamentals I : 1Z0 051 Oracle Database 11g from Oracle University on April 2013

Education:

Master of Business Administration (M.B.A).

Bachelor of Engineering (B.E).

TECHNICAL SKILLS:

MicroStrategy 9.4.1,9.3.1,9.3,9.2.1, 9.0.1, 8.1(Intelligence Server, Administrator,

Architect, Desktop, Web, Visual Insight, OLAP Services, Report Services,

Dashboard, Distribution Services, Narrowcast Server, Microstrategy Office, Mobile,

OLAP Tools

Object Manager, Enterprise Manager, Command Manager and Integrity Manager),

Tableau and Business Objects

Informatica, SSIS and DataStage basics.

ETL Tools

Oracle 11g/10g/9i/8i, SQL, MS SQL Server 2008/2005, DB2, MS Access, Mongo

Databases

DB. BIG Data Hadoop (Cloudera manager, Hue, Hive, PIG and Impala).

Data Modeling Erwin 4.1/3.5, MS Visio

Windows (8/7/XP/2003 Server/2000), UNIX (Red Hat Linux, AIX, Solaris, HP UX).

OS

MS Office, Visual Source Safe (VSS), Source Of Site (SOS), Total Quality

Management System (TQMS), Digital Workflow, Star team, Manage Now, Info man,

Tools

VM Ware, VPN, TOAD for Oracle, Putty, X Manager, VNC and mRemote .

PROFESSIONAL EXPERIENCE:

Fanatics, Inc. Jacksonville, FL. May 2014 Present

MicroStrategy BI Consultant

Environment: Microstrategy 9.4.1(Desktop, Web, Architect, Administration, MSTR Tools), Big Data Hadoop, Cloudera

manager, Hue, Hive and Impala, Oracle 11g, Windows 2008.

Responsibilities:

Installed Microstrategy Intelligent server and Web server on different windows 2008 servers. Configured I server,

•

project source and project with Metadata and Big data Hadoop using 32 bit Hive ODBC Connect (Cloudera) and Hive

0.11 database component.

Configured web with Intelligence server in Web Administration.

•

Created configuration objects like DB Instance, users and Groups.

•

Involved in requirement gathering, Analyze and understand the business requirements for report and dashboard

•

development.

Developed Schema objects like Attributes, Facts, Transformation, tables and logical views.

•

Developed OLAP Services like View filters, derived elements, derived metrics, Intelligent Cubes and published I cubes

•

using Incremental fetch functionality for specific periods.

Check the CPU usage of the ICube query before publishing it.

•

Created Visual Insight Dashboards in web using I cubes and I cube reports as a dataset and also Import Data

•

functionality.

Developed metrics Public Objects like Metrics, Filters, prompts, reports and dashboards.

•

Implemented drill down, drill up and drill to template functionality in various reports.

•

Designed Prompts and Filters to generate reports in grid and graph mode.

•

Created prompted filter feature to give end user a choice of different filtering criteria each time they run the report.

•

Analyzed the SQL generated by MicroStrategy reports to improve the performance of the reports.

•

Worked with business users to create SQL scripts for data extracts.

•

Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week

•

to date) analysis.

Configured enterprise manager to collect statistical data related to different projects.

•

Cached the reports in the intelligence server to improve the performance of the large reports.

•

Created dashboards using report services to design summary level reports using multiple datasets.

•

Leveraged intelligent cube functionality to reduce dashboard and report response times.

•

Documented the schema design and report specifications for reference.

•

Iridium Satellite LLC, McLean, VA March 2013 April 2014

MicroStrategy Consultant

Environment: Microstrategy 9.3.1(Desktop, Web, Architect, Administration, Narrowcast server, Object Manager, Integrity

Manager), Informatica 9.6, Oracle 11g, Windows 7

Responsibilities:

Involved in gathering the user requirement, reporting requirements and prepare the requirement specifications

•

document. This involved interaction with the business users and understanding the current reporting system.

Understanding the Iridium Database and adding required Database tables through warehouse catalog and Creation of

schema objects like facts, Attributes, transformations and public objects like metrics, filters, prompts, Custom groups,

Consolidations and reports.

Designed reports based on Iridium services like Prepaid, Post paid, equipment, paging, Roaming, Handsets, E

•

Vouchers, Voice Usage, data Usage etc. for Commercial and Department of Deference(DOD) and also Designed

Dashboards for individual service datasets.

Implemented the Narrowcast server system and created Information Objects, Subscriptions, schedules, Pre and Post

•

SQL of services to send personalized business intelligence information and report via email, web and wireless

devices. Worked as system administrator to Create and manage user account, monitor and maintain the Iridium

Narrowcast system and Application objects.

Designed OLAP services like Intelligence cubes for iridium services reports, Derived elements, Derived metrics and

•

View Filters for user reporting purpose. Implemented automatic scheduling to publish the Intelligence cubes after

every data loading.

Created objects list to migrate objects between Dev to UAT/UAT to prod.

•

Involved in objects Migration to production environment through OM and created packages for the migrations.

•

Tested the environments using Integrity manager though PVP and Single Project Integrity Tests.

•

Involved in implementing star and snowflake schema.

•

Worked on designing report services document and HTML documents as per the business requirements.

•

Performed MicroStrategy projects administration and application lifecycle management.

•

Major responsibilities included the MicroStrategy system administration and architect.

•

Created security roles, users and user groups. Assigned privileges to users and groups through security roles.

•

Used license manager to verify the license compliance information.

•

Involved in customizing the MicroStrategy web interface and the intelligence server settings for the project.

•

Developed drill maps including creating of custom hierarchies to achieve the functionality requested by users.

•

Involved in identifying data issues and need for data cleanup in the various source system databases.

•

General Motors Global Business Services (GM –GBS), Detroit, MI. May 2011 Feb 2013

MicroStrategy Report Developer/Administrator

Environment: 9.3.1,8.1.2,8.0.1,7.5.3(Desktop, Web, Architect,Administration, Narrowcastserver, Integrity Manager, DB Query

Tool ), Datastage,Oracle 11g, DB2,Windows 7,2003,2000 server.

Responsibilities:

Involved in Microstrategy Version upgradation from 7.5.3(2 I servers) and 8.0.1(one I server) to 9.3.1(form three

•

different Intelligence server environments of the Metadata databases to single I server environment).

Performed Functional testing, Administrative testing, Regression testing, performance testing and Integrity testing.

•

Helped the business users for End user testing.

Coordinated with business users to gather the new requirements and to solve the existing issues or improvements.

•

Worked with MicroStrategy architect to build hierarchies, attributes, facts and relationships between various

•

attributes and developed perfect logical models for reporting environment.

Configured the distribution services to deliver the reports to the users via email delivery and history list subscriptions.

•

Developed MicroStrategy objects metrics, filters, prompts, Custom groups Consolidations and templates necessary for

•

the development of the reports.

Developed Prompted Filters that gave user a choice of different filtering criteria each time they run the filter.

•

Created complex reports for analysis with transformations, custom groups and complex filters.

•

Generated advanced reports in grid, graph mode, consisting of data analysis by combining a template with filters.

•

Monitoring and Analysis of ticket trends, SLA adherence and provide solutions and suggestions for improvement.

•

Designed Configuration Objects like Users, Groups, security filters and setting up Security Role for the Project

•

Developed enhancements to the reports based on change requests.

•

Troubleshooted and resolved the issues related to Configuration, ACL Access, User Profiles, HTML XSLs files, Objects

•

issues.

Troubleshooted and resolved the Narrowcast server configuration issues while upgrading.

•

Re created all the NCS objects in new environment.

•

Generated advanced reports in grid, graph mode, consisting of data analysis by combining a template with filters.

•

AMEX Global Corporate cards and Travels (AMEX GCCT – SDM), New York, NY Sep 2010 to June2011

MicroStrategy Consultant.

Environment: Microstrategy 9.0.1 (Desktop, Web, Administration, Web administration, Command Manager, Narrowcast

Server), Oracle 10g, UNIX.

Responsibilities:

Involved in Job shadowing and Reverse shadowing for Amex reporting applications during KT.

•

Worked on Version migration and Object migration in to different environment.

•

Monitored the Narrowcast Jobs to post the subscription reports in to User web portals.

•

Prepared the daily, weekly status reports and weekly Change Management Request Notification reports.

•

Developed, Modified the Microstrategy Objects like Attributes, Metrics, Filters, prompts, Reports etc. as the Change

•

Management requests in Info man tool.

Worked with the DBA on issues of database performance and security.

•

Worked on administrative tasks like User Groups, Roles, Privileges, Security filters, Cache Management.

•

Involved in presenting demos to end users and training users in MicroStrategy Desktop and Web.

•

Used the VLDB properties for Performance tuning of the reports and significantly reduced the report run time. Also

•

used OLAP services like Derived metrics, View filters wherever necessary.

Monitored the Application availability for 24*7 through Keynote to reach the application availability for global Users.

•

Maintaining shift plans and trackers required for the smooth functioning of the project.

•

Solved tickets raised on the priority basis, with P1 being the 2nd top most priority and Monitoring and updating the

•

tickets in digital manage now.

General Motors, Detroit, MI. Aug 2008 to Sep 2010

MicroStrategy Developer/Administrator.

Environment: MicroStrategy 8.1 (Architect, Intelligent server, Web, Narrow cast Server, Desktop), SQL Server, Windows.

Responsibilities:

Interacted with Business Users, Subject Matter Experts and Business Analysts in gathering requirements and

translate them into report specifications for the MicroStrategy Platform.

• Undergone knowledge Transfer of applications, Job shadowing and reverse Job shadowing for all the application and

understood the environment.

• Involved in Monitoring of Narrowcast delivery schedules for sales notification letters, Error notification mails and

troubleshooted and fixed the issues related narrowcast server.

Installing the Microstrategy desktop and configuring the I server and project source for GM Business power

•

users.

Generated ACL list on every month end by using Command manager tool.

•

Monitoring and updating the tickets in digital workflow tool and resolved the tickets on priority basis.

•

• Designed Schema objects like Facts, Attributes and Application objects like Metrics, Filters, prompts and reports. and

Analysed the existing all object as per user change requests.

Involved Cache Clean up automation process after every data load to unload, load the projects and purge

•

the caches from I server.

Performed user license Compliance check up and license manager Audit report at first working days of the

•

every month. Health check ups of servers after server rebooted.

Involved Creation of Users, Groups and setting up Security Role for the Project and folders.

•

Designed Security Filters & Filters and assigned to users and user groups as per request.

•

Tuned the VLDB properties to enhance the performance of the reports at project level and report level.

•

Creating logical views in MicroStrategy to support the new requirements.

•

Migrated Schema and application objects between projects existing in different or same environments using Object

•

manager.

Created various user statistical reports from Enterprise manager to depict the usage and performance of reports, User

•

activity and Cache analysis.

Created Report services documents to personalize the reports as per user requirements, which included combination

•

of several sets of individual grid reports, customizing and formatting.

Microstratgy Inc., VA, USA. Sep 2006 Aug 2008

Software Engineer

Environment: Microstratgy – 9x/8x/7x (Desktop, Web, Architect, Administration, command Manger, object manager,

Narrowcast Server, Microstratgy Office, Mobile), Oracle, DB2.

Responsibilities:

• Used Microstrategy desktop to create Application Objects like Templates, Filters, Prompts, Metrics, reports.

• Used MicroStrategy Architect to create Schema objects like facts, Attributes, Transformations and Tables.

• Used the Microstrategy OLAP Services Features i.e. creating View Filter, Dynamic Aggregation, and derived metrics.

• Designed Microstrategy Administration for connectivity, user privileges, scheduling objects, monitoring, create security

Filters, grant ACLs at object level and User level privileges for security purpose.

• Used Microstrategy Integrity Manager to creating tests for reports testing like Single Project integrity test, PVP integrity

test and BVP integrity test.

• Clustering the Intelligence Server to balance the load and share caches.

• Worked with various Customer MD and Warehouses.

• Worked with MicroStrategy tools like ODBC test tool, Service Manager, Configuration wizard etc.

• Worked with MicroStrategy Narrowcast Server administrator main functionality: Configure a system, Create devices,

IOs, Publications, Documents, Services, and Subscribers

Contact this candidate