Harish

E-mail: ac0wwl@r.postjobfree.com

Phone: +1-913-***-****

EXPERIENCE SUMMARY

8+ Years of strong experience in Business Intelligence (BI) and Data Warehousing Project development and implementation using MicroStrategy 10.x/9.x product suites including MicroStrategy Desktop, Web, Architect, Administrator, OLAP Services, Intelligence Server, Narrowcast server etc.

Expertise in creating and integrating MicroStrategy reports, objects like Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups and generic cubes.

Delivered reports in Desktop, Web via Narrowcast Server to multiple users.

Extensive experience in Installing, Configuring and Using MicroStrategy tool Suite (MicroStrategy Intelligence server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services and MicroStrategy Distribution Services).

Adapt in Dashboard and Documents, worked extensively on panel stacks, widgets, and customized the web.

Having 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

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

Experience in designing ETL process for Data warehousing using ETL tools and had strong SQL skills

Experience in MicroStrategy connectivity with various databases such as oracle, Teradata, MS Access, and SQL server

Experience with MicroStrategy SDK to make changes in MicroStrategy Web interface

Developed Various SQL Server Reporting Services (SSRS) reports which are used to track agent performance.

Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production worked in the MicroStrategy mobile suite and was an active member in Unit testing and Integration testing and had experience working with SSIS and SSAS.

Worked on creating dynamic Dashboards with multi layout and used custom widgets and created visual insight built on flex for specialized dashboard in MicroStrategy Web.

Proficient in data modeling using ER model and Multidimensional model, good knowledge in Star schema and Snowflake schema.

Strong experience in developing SQL, views, triggers and other components on databases such as SQL server.

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

Expertise in creating interactive Dashboard, Scorecards and Documents based on user requirements.

Intensive experience and exposure to all aspects of MicroStrategy application such as Administration, Architecting and mostly in Development.

Ability to quickly master new concepts and capable of working in-group as well as independently.

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, SSIS, SSRS

Languages

SQL, PL / SQL, C, Java, XML, HTML, CSS, Java script

Databases

MS Access, MS SQL Server, Teradata, Oracle

Operating Systems

Windows, UNIX, Linux

Data Warehousing Concepts

Dimensional modeling, Dimensional Data modeling,

Physical and logical Modeling, Star & Snow-flake Schemas

Professional Experience:

Client: T-Mobile, Seattle WA Nov 2015 to present

Role: MicroStrategy Developer

Project: Financial reporting and Analytics

Description: T-Mobile was a German holding company for Deutsche Telekom AG's mobile communications subsidiaries. Globally, T-Mobile International's subsidiaries had a combined total of approximately 230 million subscribers

Responsibilities:

Involved in Requirements gathering by interacting with the Business Users.

Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.

Generated MicroStrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.

Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.

Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.

Create Complex BI Views by writing the SQL in Teradata and execute them in all environments.

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

Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.

Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.

In Web, created new and updated old customizations using SDK.

Extensively created MicroStrategy Report Services Documents, Dashboards and involved in MicroStrategy Mobile SDK development.

Configured Very Large Database (VLDB) Properties at different levels (report, metric, project and database Instance) for optimization.

Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.

Installed and Configured Intelligent Server and Distribution Services to schedule, execute and deliver reports

Environment: MicroStrategy 10.x/9.x (Developer, Architect, Administrator, Web, Object Manager, Command Manager, Narrowcast Server), Visual Insights, Teradata, SQL Server, windows, MS Excel

Client: Chevron Corporation, Houston, TX Aug 2014 to Nov 2015

Role: MicroStrategy Developer

Description: Chevron Corporation is an American multinational energy corporation. One of the successor companies of Standard Oil, it is headquartered in San Ramon, California, and active in more than 180 countries.

Responsibilities:

Participated in the end user meetings to obtain the business for creating reports.

Identified and defined Facts, Attributes, Hierarchies and Relationships.

Generated and implemented MicroStrategy reports by creating projects, Attributes, hierarchies, metrics, filters, and templates using MicroStrategy Architect.

Designed the logical data model from the technical design documents and translating to a physical database design optimization and functional testing of the constructed database.

Created Complex Compound Metrics at different dimensionalities to count the Items sold at different store levels.

Created Filters to validate the test plan conditions for the reports and per the business requirements.

Created Custom Groups for the Vendor contact types and Competitive Pricing.

Developed logical and physical data models for OLAP database applications.

Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.

Created Templates to maintain a standard interface for the reports.

Created Attributes, Prompts, Advanced Filters to obtain the Basket counts and used them along with the metrics at different dimensionalities

Developed reports enabling Data Drilling across multiple Dimensions using Desktop and Web.

Worked on Derived Elements by creating user-defined business (attribute) groups for comparison analysis.

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

Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.

Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.

Have used several Widgets for Dashboard reporting.

Heavily worked on testing and validating the data and also involved in optimizing SQL, troubleshooting reports using VLDB properties.

Fixed Defects and performed upgrades for existing projects.

Environment: MicroStrategy 9.x (Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata, Oracle, SQL Server, Windows, SQL Server

Client: Nationwide Bank, Columbus, OH Sep 2013 to Aug 2014

Role: MicroStrategy Developer

Description: Nationwide Bank provides financial services both directly, and through around 700 branches. Nationwide is a major provider of both mortgage loans and savings in the UK, as well as personal banking such as loans, credit cards, bank accounts and insurance products.

Responsibilities:

Extensively involved in Data modeling, ETL Mapping and Interaction with Business user to understand the raw requirement then converting into technical specification and then starting design and development process.

Develop MicroStrategy Schema Objects (facts, attributes, hierarchies, Transformations) and Application Objects (Reports, Documents, Filters, Prompts) for projects and final reports business stakeholders

Created e-mail services using Narrowcast Server to notify users about the file updates on web site.

Expertise in creating Procedures and Macros in Teradata, Oracle and in SQL Server

Gather new requirements from business stakeholders and plan, conduct, develop BRDs for development sizing on a new product

Coordinate with off-shore team to gather definitions of business requirements and back end process logic

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.

Responsible for co-coordinating with vendors and Finance, approve timesheets and expenses

Moving objects from Dev to other environments using Object manager

Take various measures for performance enhancement like aggregation techniques, OLAP Feature, Data mart and report caching.

Educate end users about MicroStrategy report functionality and different slice and dice can be produced from single report

Environment: MicroStrategy 9.x (Architect, Desktop, Object Manager, Enterprise Manager, Integrity Manager, Command Manager, Intelligence Server, Narrowcast server), MySQL, Teradata, SQL Server.

Client: Radiant Info Systems, India July 2011 to Aug 2013

Role: MicroStrategy Consultant

Responsibilities:

Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.

Created and maintained Business Documents for reporting and Coordinated with business users and report development team for all reporting changes.

Designed and developed different types of reports as per the requirements.

Developed Transformations (table based, formula based) to be used for comparative analysis like loans this year to last year (year to date and month to date).

Deployed MicroStrategy Desktop in designing the MicroStrategy projects. The business rules of the data warehouse were implemented into MicroStrategy Architecture.

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

Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.

Used MicroStrategy Web to offer interactive reporting to the end users through a web browser. Proactively created report formats and delivered personalized messages from the Data warehouse.

Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.

Worked extensively with Intelligent Cubes in developing the dashboards to increase the performance.

Designed Dashboards using selectors & widgets and summarized key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.

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.

Created Dynamic Subscriptions for users to be able to receive reports via email.

Worked with end users in solving the current financial Issues.

Extensively worked with end-users to resolve the issues faced during day-to-day activities.

Environment: MicroStrategy 9.x, MicroStrategy Narrowcast server, MySQL, SQL Server, MS Access, Excel

Client: GGK Technologies, India April 2009 to June 2011

Role: SQL BI Developer

Responsibilities:

Developed reports and cubes according to analyst defined specifications within the warehouse framework.

Involved in designing and implementing several forms for each module and Designed user interface screens.

System incorporates all the user-friendly functionality's like pop-ups, list boxes and other object oriented events.

Developed the user interface and menus using triggers, functions and procedures. Also took active part in testing.

Worked with MicroStrategy product suites including MicroStrategy Desktop, Web, OLAP Services, and Intelligence Server etc.

Constructed several Normalized database tables with different constraints to maintain integrity. Triggers were implemented on the tables to maintain validity check on the data.

Constructed several forms in Visual Basic to make it user friendly for the users to add, delete or update information.

Carried out detailed study of business, data analysis and configuring the materials management module to user specification.

Environment: Windows Server, SQL Server, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler

Contact this candidate