Harish

ac0y9q@r.postjobfree.com

717-***-****

Experience

Around 3 years of experience in the Data Warehouse concepts and in design, development and the implementation of applications in the BI using MicroStrategy 10.x/9.x product suites including MicroStrategy Desktop, Web, Architect, Administrator, OLAP Services, Intelligence Server, Narrowcast Server etc.

Experience in creating complex and comprehensive reports using Custom Groups, Consolidation, Prompts, Filters, Metrics and Drill Maps

Experience in creating dynamic Dashboard, Scorecards and Documents based on user requirements.

Experience in creating Intelligent Cubes which is optimized for reducing total database time, job load.

Having good Knowledge on Object Manager and Command manager.

Experience in using Pass-Through functions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.

Experience in MicroStrategy OLAP Services such as view filter and derived metrics, Ad-hoc reports.

Worked Closely with SDK Developer in Finding Issue on CSS files and Suggested Code Modification required.

Worked on creating and managing Narrowcast Server to send multiple files and documents in one single attempt to the business users.

Very strong in Microstrategy connectivity with various databases such as Oracle, Teradata, MS Access, SQL Server.

Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.

Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi-dimensional data model analysis using OLAP, Physical and Logical data modeling

Experienced administrative capabilities, Project Setup (Installing, Configuring, Managing and Controlling) and Project Lifecycle Management.

Involved in all phases of System Development Life Cycle (SDLC) including Business Requirements Gathering, Analysis, Design, Development, Testing, and Implementation of Data Modeling, Data Warehousing, Business intelligence and OLAP Applications using Microstrategy

Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.

Attending weekly client meetings to understand and recommend the business solutions and update of status to the client on a weekly basis

Education: Master’s in Computer Science from University of Central Missouri, USA

Bachelor’s in Computer Science from JNTU University, India

Technical Skills:

BI Tools

MicroStrategy Desktop, Architect, Web, Intelligence Server, Administrator, Report Services, Command Manager, Object manager

OLAP Tools

MicroStrategy

ETL Tools

Microsoft SQL Server Integration Services, Informatica

Languages

SQL, C, C++, Java, XML, HTML, CSS, Java Script

Databases

MS Access, MS SQL Server, Teradata, My SQL

Operating Systems

Windows, UNIX, Linux

Data Warehouse Concepts

Dimensional modeling, Dimensional Data modeling,

Physical and logical Modeling, Star & Snow-flake Schemas

Work Experience

T-Mobile, Seattle WA

Role: MicroStrategy Developer

Dec 2016 – May 2017

Responsibilities:

Involved in the meetings with business users to discuss and finalize the requirements and design of the reports.

Involved in Creation of Schema Objects (Attributes, Facts, Hierarchies and Transformations) from Warehouse Catalog.

Involved in Creation of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Drill Maps) on Top of Schema Objects.

Involved in Setting of VLDB Properties at Report, metric and database instance Levels to manage joins, metric calculations and query optimizations.

Involved in creation of Consolidation and Custom groups to group elements of attributes based on Filter conditions.

Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server & Distribution servers.

Expertise in working with very large databases like Oracle, SQL Server, Teradata with MicroStrategy

Performance tuning and troubleshooting, UI customization using SDK, system administration and Production support.

Experience in using pass through functions like Apply Simple and Apply Comparison.

Created different kinds of Dashboards and documents using different controls, selectors, sliders, Links and widgets to view in different kinds of modes like DHTML, Flash mode. Worked on different document modes like design, editable mode and interactive modes.

Involved in Creation of Simple metric, Compound metric, Derived Metric, Filter Metric and Transformation metric to meet end user Requirements.

Created Ad-hoc reports by drilling up, down and across Hierarchies.

Involved in partitioning the tables, indexes and management of the schema objects.

Involved In testing of reports and Queries by test cases and test plans.

Environment: MicroStrategy 10.x, Desktop Reports, Web Intelligence Reports, OLAP Services, Architect, Dashboards, Intelligent Cubes, Narrowcast serve, SQL Server, HTML, Windows, Linux

GGK Technologies, India

Role: MicroStrategy Developer

June 2014 – Dec 2015

Responsibilities:

Implemented advanced MicroStrategy Reports concepts by creating metrics, filters, Custom groups and templates using MicroStrategy Desktop.

Extensively used report services for creating enterprise Dashboards summary level documents with grids & graph combinations.

Created complex reports for analysis with Transformations, Custom Groups and Complex Filters.

Developed different prompts to give business users a choice to filter the data each time they run the reports.

Used Narrowcast Server for scheduling of reports and documents and exported MicroStrategy reports in Excel Format.

Extensively used Integrity Manager to test reports

Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties

Create Attributes, Facts for different MicroStrategy projects.

Identified the Facts, Attributes that goes in the Dashboard and documented the Technical specification.

Insert as many panels as needed within a panel stack.

Environment: MicroStrategy 9.x (Desktop, Administrator, Web), MicroStrategy Distribution Services, MicroStrategy Narrowcast Server, Object Manager, Enterprise Manager, Command manager, SQL Server, MS Excel, Windows

Radiant Info Systems, India

Role: SQL BI Developer

Sep 2013 – May 2014

Responsibilities:

Actively involved in Production support of the MicroStrategy BI application(MSTR Desktop, Web and Mobile)

Involved in Packages creations and Packages migration using object manager.

Activity involved in running the I-Cube refresh scripts in Linux server level once after the ETL data load completes.

Actively involved in creating the Events, Schedules, Subscriptions and Scheduling administrative tasks.

Involved in design/development life cycle (SDLC) including gathering requirements, user interaction and report design and development.

Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.

Created advanced objects like Derived Metrics, Compound Metrics, level metrics, date transformations, custom groups.

Tested all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.

Validated end user requirements using MicroStrategy tools.

Migration of Reports across multiple environments like DEV, QA and Production.

Migrated Excel reports to Interactive MicroStrategy Dashboards.

Some experience with data warehouse using ETL tools like Informatica

Environment: MicroStrategy 9.x (Desktop, Administrator, Web), MicroStrategy Distribution Services, Object Manager, Command manager, SQL Server, Informatica, Windows, MS Excel

Contact this candidate