Manager Administrator

Asif Virani

Phone: 972-***-****

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

Summary

. Over 7+ years of strong experience using MicroStrategy Suite

(Architect, Desktop, Web, Narrowcast Server, Report Services).

. Strong IT experience in Data warehousing, Data architecture, Data

modeling, Decision Support Systems, using MicroStrategy Platform,

Informatica, SQL Server DTS and ERwin for over 7 years.

. Involved in Analysis, Design, Development and implementation of

Business Intelligence and Maintaining Applications using MicroStrategy

Tool suite.

. Worked extensively on MicroStrategy Desktop, Administrator,

Intelligence Server, and Web and Report Services.

. Hands on experience and conceptually sound in the creation and

application of Data Warehouses, Datamarts, Star and Snow flake Schema

modeling, Physical and Logical data modeling, creation of Fact and

Dimension tables, Extraction Transformation and Loading (ETL)

processes and other OLTP and OLAP related tasks.

. Experienced in Full Life Cycle (SDLC) development of software

applications. Good knowledge of understanding business logic and

converting functional requirements to technical requirements. Thorough

knowledge of multiple RDBMS & ODBC concepts

. Extensively worked in creating and integrating MicroStrategy reports

(Interactive reports, Dashboards, Data Marts) and objects (Attributes,

Filters, Metrics, Facts, Prompts and Hierarchies) with the

Datawarehouse.

. Extensive experience in dealing with a variety of Relational Databases

like Teradata, Oracle, DB2, and SQL server.

. Expert in Database development skills using SQL, SQL*LOADER, PL/SQL,

Stored Procedures, Stored functions.

. Expertise creating complex Reports in MicroStrategy Desktop using

features like Templates, Custom groups and Consolidations.

. Pro-active involvement in continuous performance tuning & improvements

for existing OLAP systems.

. Excellent communication and interpersonal skills.

. Ability to work independently and good team player.

TECHNICAL SKILLS:

BI Tools MicroStrategy Desktop 9.x/8.x/7.x, MicroStrategy

Architect, MicroStrategy Web, MicroStrategy Intelligence

Server, Administrator, Report Services, Command Manager,

Object manager

RDBMS Oracle 8i/9i/10g, MS Access, MS SQL Server 2005/2000,

Teradata 12/V2R6, MySQL.

Languages SQL, PL/SQL, Unix shell scripting, C, C++, VB, ASP, HTML,

XML

ETL Informatica 5.1, Data Junction, SQL Loader, DataStage

OLAP Tools MS SQL Analysis Services, DB2 OLAP Crystal Reports

Operating Windows XP/2000/98/NT, UNIX, Linux

Systems

Other Tools & TOAD, MS Project

S/w

Professional Experience:

OptumHealth, Dallas, TX

Nov 12 - Till Date

MicroStrategy Consultant

Responsibilities:

. Recruited, Built and Managed the off shore team of 5 members.

. Reported directly to the Senior Manager for EDW and Business

Reporting.

. Designed and perfected the reporting requirement documents and the

tracker logs to track and assign the work packets until they get

completed /resolved.

. Was responsible for assigning the work packets to the offshore team

and for the delivery of the same.

. Troubleshooted the production issues as they came in and assigned them

to the appropriate team members.

. Created complex reports using MicroStrategy and MS Excel.

. Used Report Services to create complex reports as per the requirements

including Interactive and WYSIWYG reports.

. Was involved in adapting the new merchandise hierarchy and bridging

the old and the new worlds as per the requirement.

. Created Schema objects like Attributes, facts and hierarchies and

Public Objects like, prompts, filters, reports, documents and

dashboards.

. Deployed different kind of reports to Dashboards and Documents on Web.

. Created and validated the reports in MicroStrategy that were

originally in other reporting tools.

. Used Microstrategy Administrator to create users, user groups,

security roles, web groups and assigning privileges to them.

. Used Object Manager to deploy the objects developed in Development to

UAT and Production.

. Used Project Merge to update Production with the development.

. Used Distribution Services to schedule reports.

. Used Command Manager to run scripts for user creations, group

creations and privileges for the groups created.

. Involved in creating a lot of documentations like technical Specs,

Report Specs, etc.

Environment: MicroStrategy 9.0.2(Administrator, Desktop, Architect, Object

Manager, Web), DB2, Informatica, Html, Windows XP, Oracle 10g.

Kinetic Concepts, Inc., San Antonio, TX

Aug 11 - Oct 12

MicroStrategy Consultant

Responsibilities:

. Involved in interacting with the users and gathering the requirements,

and analyzed the needs of the end users.

. Developed logical and physical data model by defining strategy for

Star Schema with Fact and Dimension tables with Detail, Summary, Look-

up Tables, Indexes and Views.

. Extensively involved in data modeling to create attribute

relationships.

. Developed new reports and converted existing reports for the business

line to satisfy the specifications using MicroStrategy Desktop and

MicroStrategy web.

. Created Facts, Attributes and Hierarchies using the MicroStrategy

Architect.

. Developed various Metrics, Filters, Consolidations, Custom Groups and

Prompts to give decision makers a handy tool to choose the criteria

for reports and view information from different perspectives.

. Involved in customization of MicroStrategy Web.

. Involved in designing Templates to generate reports in grid and graph

mode and used filters with Auto prompt feature to give the end-user a

choice of different filtering criteria each time they run the report

along with different custom groups.

. Involved in creating various Transformations to analyze different

metric values in 'this year to last year' using MicroStrategy

Architect.

. Extensively worked on Documents by adding additional functionalities

using XSL sheets to create more personalized documents with images,

hyperlinks and other report objects.

. Involved in configuring the Intelligence Server and pointing the

database instances in both development and production environments.

. Involved in implementing optimization techniques to enhance the

performance of queries dynamically generated by MicroStrategy by

interacting with DBAs and designers.

. Worked with Repository Manager to create and administer the Metadata

Repository by creating new users and assigning them their privileges.

. Involved in modeling and populating the business rules using mappings

into Repository for Metadata Management.

. Worked with Administrator in installation process of the MicroStrategy

Tool Suite.

. As an administrator created users, Duplicated projects, Involved in

Migration of projects.

. Used the Object Manager to move the objects from Development to

Production Environment in Microstrategy.

. Executed MicroStrategy configuration commands in text using Command

manager.

. Involved in performing various analysis using the MicroStrategy

Desktop.

Environment: MicroStrategy 8.1/8.0/9.0 (Administrator, Desktop, Narrowcast

Server, Object Manager, Enterprise Manager, MDX Adapter) Oracle 10g,Unix.

Guess, Inc., Los Angeles, CA

Oct 09 - Jul 11

MicroStrategy Consultant

Responsibilities:

. Involved in gathering business requirements and documenting

specifications.

. For complex reporting needs, worked extensively on creating Metrics

and Compound Metrics, Filters, Custom Groups and Consolidations.

. Developed Scorecards and Dashboards that provide users a highly

graphical, summary view of key metrics.

. Used the Object Manager to move the objects from Development to

Production Environment in MicroStrategy.

. Involved in troubleshooting MicroStrategy Web Reports, optimizing the

SQL using the VLDB Properties.

. Customized the MicroStrategy web interface and the Intelligence Server

settings for the project.

. Created new users, roles, privileges, shared folders; access controls

lists using security roles as a MicroStrategy Administrator.

. Tested all the reports by running queries against the warehouse using

Query manager. Also compared those queries with the MicroStrategy SQL

engine generated queries.

. Developed PDF documents containing 5 components grid reports and save-

to file Report services with personalized page execution.

. Created MicroStrategy schema and public objects such as Conditional,

Transformational, Compound Metrics, Filters, Filter Prompts, Object

Prompts, Templates, and Reports for the generation of canned, ad-hoc

reports.

. Duplication of objects was done through the Object manager.

. Built and generated advanced reports in grid, graph mode using

MicroStrategy Desktop.

Environment: MicroStrategy 8i, (Administrator, Architect, Desktop, Object

Manager) Teradata V2R4, ORACLE 10g

Meijer, Grand Rapids, MI

Jun 07 - Sep 09

Microstrategy Consultant

Responsibilities:

. Understanding of source system and interacting with users to get the

report requirements.

. Worked with the source systems to have a clear understanding of the

data flow and interacted with the users to collect the business

requirements.

. Created the requirements Documentation for the Microstrategy projects

and also documented the Microstrategy Environment.

. Designed the Microstrategy Architectural Documents for the Projects.

. Created Reports using complex Filters and Compound Metrics and

Prompts.

. Used Advanced Prompts, Non-Aggregatable Metrics, Conditional,

Transformation metrics and Level Metrics for creating complex reports.

. Used Customer, Product, Payment, Geographic and Time dimensions and

generated reports like forecasting.

. Created several base formulas (mathematical expressions) using

existing facts in MicroStrategy Agent that can be re-used to build any

number of metrics.

. Customized reports, Documents and deployed them to MicroStrategy web.

. Database design employed highly complex data transformations including

Slowly Changing Dimensions and a series of Stored Procedures, which

made performance tuning and efficient mapping highly critical.

. Generated advanced reports in grid, graph and SQL mode, consisting of

data analysis by combining a template with filters, using

MicroStrategy Desktop and Web.

. Created Data Mart Tables using Complex Filters and Compound Metrics.

. Created all possible Metrics, for enabling the end users to generate

customized reports by creating their own Templates and Filters.

. Created Transformations (table based, formula based) for using in

comparative reports like sales this year to last year (year to date

and month to date).

. Administrating MicroStrategy Intelligence Server and Web.

. Used Informatica 5.0 as an ETL tool to extract data from source

systems to Target system.

. Have good experience in Repositories, like maintaining versions of

repositories, managing users and upgrading repositories.

. Have good experience in understanding & creating source and target

definitions, Mappings, Transformations and working with Sessions.

. Reconcile purchase data daily so customers could run reports daily

instead of at month end.

Environment: MicroStrategy 7.2.3- Desktop, Administrator, Intelligence

Server, Web, MicroStrategy Object Manager, Informatica 5.0, DB2, Windows

2000.

IMS Health, Collegeville, PA

Aug 06 - May 07

ETL Developer

Responsibilities:

. Generated reports from Excel to Business objects and vice versa.

. Generated reports from various data providers.

. Tested data fetched in Business objects against open SQL result sets.

. Created reports in cross tab,master detail format and transformed

them in 2-D,3-D column,line,area and pie charts for graphical

analysis

. Responsible for scheduling and batch processing of Business objects

and reports various formats PDF, rich text format (RTF) using the

Business objects prower center .

. Formatted the reports as per the user's requirements using all the

facilities in Business objects like slice and dice, drill down,

@functions and formulae to analyze the data.

. Generated the reports for the web users using the Web Intelligence

Info View.

. Reports were created using the Business objects Power play Reporter

modules Support.

. Tested the changed components under new environment.

. Handled ad-hoc user queries and providing status reports to

management.

Environment: Informatica 6.0, BUSINESS OBJECTS, Crystal Reports, Oracle 7.3

and UNIX Shell Scripting.

Contact this candidate