Viveka Reddy

acpmi0@r.postjobfree.com

732-***-**** Extn: 102

Summary of Qualifications

. Over 8+ years of IT experience in gathering requirements,

documentation, developing, designing, testing, implementing, and

deploying BI Solutions.

. Over 5 years of extensive experience utilizing the MicroStrategy Suite

(MicroStrategy Desktop, MicroStrategy Intelligence Server,

MicroStrategy Narrowcast Server, MicroStrategy Architect,

MicroStrategy Web, MicroStrategy OLAP services and MicroStrategy

Distributed Services).

. Designing Data Marts using different multi-dimensional modeling

techniques such as Star Schema and Snowflake Schema, Fact and

Dimensional tables, Logical and Physical data modeling.

. Extensively worked on Geo-Maps in projecting the performance analysis

in terms of revenue and sales all across United States. For example,

in one of my project in Autotrader, I used the concept of Geo Maps to

project the user with the flexible analysis capabilities. In which

state or city a particular Dealer is performing good in terms of sales

and which region falls low in inventory and many things. Even the user

has the flexibility to drill to a particular dealership and compare

the results with the nearby competitor.

. Experience in working with data modelers to translate business

rules/requirements into conceptual/logical dimensional models and

worked with complex de-normalized and normalized data models.

. Expertise in working on both Direct Project Source (Two-Tier) and

Server Project source (Three-Tier).

. Well versed in designing the reporting applications according to BRD,

SRS and TDS.

. Good experience in schema objects (Facts, Attributes, Hierarchies, and

Transformations).

. Expertise in developing Application Objects (filters, prompts,

metrics, Custom Groups, Consolidations, DrillMaps, Templates,

Searches), developed Reports, Documents and Dashboards .

. Good experience with pass-through Expressions like Apply Simple and

Apply Comparison to develop complex Filters and Transformations.

. Extensively worked in creating and integrating MicroStrategy objects

(Reports, Attributes, Filters, Metrics, Facts, Prompts, Custom Groups

and consolidations) with the data warehouse.

. Expertise in developing Reports by using Freeform SQL Queries and

Logical Views in MicroStrategy Desktop.

. Expertise in creating dashboard reports in an Interactive and Flash

Mode by using Selector, Sliders and Widgets to view personalized

reports based on user requirements.

. Expertise in fine tuning of the MicroStrategy reports using Data Mart

Reports, Partition Mappings, Aggregate Tables and Intelligent Cubes.

. Good knowledge in using administration tools like System Monitor,

System Administration, User Manager, Object Manager and Command

Manager.

. Experience in code optimization and performance tuning of database

queries both in MicroStrategy environment and in database.

. Experience in problem solving and delivering practical solutions.

. Responsible for MSTR On-Call Support on Rotation Basis.

. Proven ability to work under pressure, prioritize and meet deadlines.

Open to dynamic work environment and ability to work collaboratively

with business analysts, testers, developers and other team members in

the overall enhancement of software product quality

. Excellent communication skills, Self-starter, good team player,

enthusiastic, innovative and challenge oriented.

Technical Summary:

Business Intelligence MicroStrategy 9.3/9.2.1/9.0.2/8.1.2/8.1.1/8.0.2

(MicroStrategy Desktop, Web, Intelligence Server, OLAP

Services, Report Services, Narrowcast Server, Command

Manager, Administration), Business Objects XIR2/6.5,Cognos

8.4.1,SSIS,SSRS,SSAS, Framework Manager, Query Studio,

Report Studio, MicroStrategy Mobile Application for iPad

and iPhone

SAS Tools SAS V9.1, SAS/BASE, SAS/MACROS, SAS/STAT,

SAS/GRAPH, SAS/ SQL, SAS/ACCESS, SAS/ODS

ETL Informatica 8.6.1/8.1/7.x/ 6.x, Oracle warehouse

Builder 10.2, DataStage 7.5.2

Operating systems Windows 95/98/2000, Windows XP, UNIX, DOS,

Mainframes

Data bases Oracle 10g/9i/8i, SAP, MS SQL Server

2000/2005, Netezza 5.0, DB2 7.0, Teradata 13/12/11.

Office Tools MS Word, Excel/VBA, Access, PowerPoint

Educational Summary

Bachelor Science, Jawaharlal Nehru Technological University, Hyderabad,

India

Professional Summary

Meijer, Grand Rapids, MI

10/13 - Till Date

MicroStrategy Consultant

Working on several Pricing, Promotion and Finance projects in Business

Capability Improvement group focused on generating daily reports on Retail

Sales and Prices compared to its competitors.

. Created Complex reports and dashboards for Pricing Analytics Team with

the drill down methodology in all options.

. Involved in developing MicroStrategy Dynamic Dashboards in the Flash

Mode using several controls and widgets like micro charts, time series

slider, fish eye, radio boxes, Gauges.

. Enhanced existing dashboards and scorecards using KPIs and enabling

drill functionality.

. Implement OLAP functionality within report service documents to

enhance performance.

. Created mockup versions of dashboards and presented to the stake

holders to make sure it was effective on usability perspective.

. Tested and validated all the reports by running queries against the

warehouse. Also compared those queries with the MicroStrategy SQL

engine generated queries.

. Built and optimized intelligent cubes for the Visual Insights Tool in

MSTR 9.2.1 by configuring working memory set, working memory and VLDB

properties.

. Created customized Custom Groups with complex filters and Relationship

filters.

. Created Metrics, Prompts, Filters, Custom Groups and Transformations

for the report development.

. Extensively used report services to create dashboards to create

summary level reports using multiple datasets.

. Reduced the time taken for the reports to run by taking advantages of

VLDB properties like star join, query and sub query optimizations.

. Fixed Defects and performed upgrades for existing projects.

. Ensured proper relationships were established between the attributes

to avoid any improper SQL query joins.

. Worked extensively with the compliance officer to finalize the

dashboard layouts and also worked on fine detail formatting for a

desired look and feel.

. Created logical views in MicroStrategy for complex report creations

situations.

. Designed and developed several Intelligent Cubes and its incremental

refresh design, defining incremental refresh rules, Cube maintenance

and support etc.

. Planning and Design Narrowcast development

- Service development

- Debugging service failure

- Automation of event based service execution

- Narrowcast Design and test case document

Environment: MicroStrategy Suit 9.3.1, Narrowcast Server, Teradata

V2R12/13, Teradata SQL Assistant 12, Windows 8.

Autotrader.com, Atlanta, GA

03/13 - 09/13

Sr. MicroStrategy Consultant

Project: Kelly Blue Book

AutoTrader.com, created in 1997 and headquartered in Atlanta, GA, is the

Internet's leading auto classifieds marketplace and consumer information

Web site. AutoTrader.com aggregates in a single location more than three

million vehicle listings from 40,000 dealers and 250,000 private owners,

which provide the largest selection of vehicles attracting more than 13

million qualified buyers each month.

. Interacted with the Business Analysts and Enterprise users.

. Architecting the schema objects Attributes, Facts, Hierarchies.

. Worked on Geographical maps this allows users to drill to their own

respective regions and other types of graphical representation of data

(heat maps).

. Worked on advanced visualizations like interactive heat maps and

bubble charts and grid of graphs.

. Heatmap advanced data analysis widget allows a user to look at the

data in 2 dimensions. One is the size of the heatmap bar, which

depicts the relative size of the metric data. Second metric, gives the

color to the data. We can design a heatmap to show these kind of

analysis, when a user wants to see the data in size and colors.

. Development of Data Models (physical/logical) using Erwin tool as KBB

data and reporting requirements are completely different from the

existing scenario.

. Extensively giving mock-ups to the Enterprise user to better

understand the reporting analysis and also making their life easier.

. Development interactive dashboards and scorecards for high level

management.

. Designed the configuration objects Filters, Base Metrics, Derived

Metrics, Templates and Reports.

. Involved in changing the existing Sales Organization Hierarchy, which

is required to be modified as underlying data were reorganized.

. Analyzed the best way of approaching towards the reporting with

minimum amount of maintenance effort, QA work and also giving the

flexibility to the users to pick and choose whatever data they like

from different key tables.

. Assisted the team in integrating the current project with new

Enterprise analytics.

. Optimized query performance by updating VLDB (very large database)

properties and by modifying cache behavior.

. Worked on SDK (Software development Kit) environment to enables easy

customization and integration of the MicroStrategy BI platform with

enterprise business applications

. Optimized query performance by updating VLDB properties at project

level and report level.

. Customized the drilling options specific to the reports using drill

map editor to give access to more detailed and supplemental

information.

. Assisted the team in identifying the errors in the underlying data.

. Customized reports using Custom Groups and Consolidations.

. Designed Compound metrics and Complex filters and Time filters.

. Developed various Prompts supporting end users to interactively choose

different filtering criterion.

. Configured Data Marts in MicroStrategy Desktop to update tables in

database.

. Performed optimizations using Report Data Options.

. Used MicroStrategy Web to offer interactive reporting to the end users

through a web browser

. Extensively used MicroStrategy Web to enable users to run-predefined

sales and inventory reports for building their own customized reports.

. Unit tested the reports developed by the other developers.

Environment: MicroStrategy 9.3,9.2.1, Architect, Web Intelligence, SDK,

Teradata13,Object Manager, Integrity manager, Configuration Wizard,

Informatica 9, Report Studio 8,Netezza 5.0, Windows NT and UNIX.

McGraw Hill (CTB).Monterey, CA

03/12 - 03/13

Sr. MicroStrategy Consultant

. Co-ordinate meetings with clients and business users to discuss and

understand requirements.

. Discussion with data modelers to understand data modeling of existing

schema.

. Worked with client to gather requirements and prepared technical

specifications documents.

. Responsible for the preparation and presentation of proto-type reports

to end users and get acceptance to develop reports.

. Building schema objects: Highly involved in building schema objects in

MSTR with Teradata as the backend. I was involved in Architecture

meeting where we discussed the schematic layer (tables and views) and

discussed the better way to address the schema in MSTR. Teradata,

being a robust tool allows a MSTR architect to build schema in such a

way that supports the all features of Teradata. Building schema in

MSTR with Teradata as backend is similar to building schema with any

other DB tool, except Teradata has its own data fetching capabilities

with its unique data processing units.

. Expertise in using Apply simple Function in Attributes and Metrics to

make manipulations to values.

. Responsible in developing of public objects (Filters, Prompts,

Metrics, Consolidations, Custom Groups, Templates and Reports) on top

of Schema Objects

. Responsible for the creation of metrics like Compound metric, Derived

Metric, Filter Metric and Transformation metric to generate more

complex MicroStrategy reports in an efficient way.

. Worked on Geographical maps which allows users to drill to their own

respective regions

. Creation of logical views and Freeform SQL Reports.

. Synthesize and translate Business data needs into creative

visualizations in Tableau

. Used Apply Simple and Apply Comparison functions to develop Advanced

Filters and Transformations

. Creation of reports at Aggregate Level as well as Detail Level Tables

to retrieve data in an efficient way.

. Setting of VLDB Properties to improve performance of reports as well

as passing hints to the SQL queries.

. Creating Dense Rank function metric at report level to generate

sequence numbers for PDE Transactions.

. Highly involved in developing dashboard reports in MicroStrategy by

combining multiple reports in Cognos by using selectors.

. moving the objects between two projects and two different environments

by using Object Manager and resolve conflicts between environments by

using conflicts resolution window

. Creation of Users/User Groups and assigning appropriate privileges

through User Manager in Administration.

Environment: MicroStrategy9.2,9.0.1, Architect, Web Intelligence, Object

Manager, Cognos8.4.1 Framework Manager, Query Studio, Report Studio,

Informatica8.6.1, Teradata 13, DB2 8.x/9.1, Oracle 10GR2, SAP, SQL, PL/

SQL, Windows NT and UNIX.

GE Health Care, Edison, NJ

06/11 - 02/12

Sr. MicroStrategy Consultant

. Interacted with the Business Analysts and Enterprise users designing

ad-hoc reports.

. Architected the schema objects Attributes, Compound Attributes,

Facts, Hierarchies.

. Development of Data Models (physical/logical) using Erwin tool.

. Designed the configuration objects Filters, Base Metrics, Derived

Metrics, Templates and Reports.

. Changing the existing Sales Organization Hierarchy, which is

required to be modified as underlying data were reorganized?

. Extensive use of Location Intelligence Components (LIC), mainly in

building geographical queries and geographic drilldown.

. Worked on Geographical maps and heat maps this gives the flexibility

to look at the business at different levels of regions.

. Assisted the team in integrating the current project with new

Customer inventory analytics.

. Extensively created Documents, Publications and Services and

assisted the MicroStrategy Developer in creating Narrowcast objects.

. Assisted the team in identifying the errors in the underlying data.

. Customized reports using Custom Groups and Consolidations.

. Designed Compound metrics and Complex filters and Time filters.

. Developed various Prompts supporting end users to interactively

choose different filtering criterion.

. Configured Data Marts in MicroStrategy Desktop to update tables in

database.

. Optimized query performance by updating VLDB properties at project

level and report level.

. Performed optimizations using Report Data Options.

. Extensively used MicroStrategy Web to enable users to run-predefined

sales and inventory reports for building their own customized

reports.

Environment: MicroStrategy 9.0.2, Architect, Web Intelligence, Object

Manager, Integrity manager, Configuration Wizard, Informatica 9, Oracle

10GR2,Oracle Hyperion 11,Cognos Framework Manager 8, Report Studio 8,SQL,

PL/SQL, Windows NT and UNIX.

Bio Numerik Pharmaceuticals, San Antonio, TX

10/09

- 05/11

MicroStrategy Developer

. Worked with the business analyst and executives to understand

requirements for the Executive dashboard and designed the prototype.

. Collaborate with database architect and ETL developers to aid in the

design of efficient and robust data structures for reporting and

analysis.

. Architected the Schema for the project by creating facts, attributes,

and hierarchies.

. Created the application objects metrics, filters, Prompts and Reports

using MicroStrategy Desktop to meet report requirements.

. Created daily, monthly reports and dashboards for iPhone, iPad using

MicroStrategy mobile.

. Dashboard design--Utilized standard templates and added panels.

. Worked on advanced visualizations like interactive heat maps and

bubble charts and grid of graphs.

. OLAP services & Intelligent cube design for advanced analytics and

Trend analysis reporting.

. Developed the OLAP services by creating the cubes, view filters and

derived elements to improve the performance of the Executive

dashboards.

. Designed and built pixel perfect report service documents and

interactive Flash dashboards.

. Build the report builder interface for the Ad-hoc Analysis.

. Created transformations using Transformations by tables for YTD and

MTD for Time Series Analysis.

. Set up the distribution services for distributing the report output to

the different levels of users.

. Involved in troubleshooting MicroStrategy Web Reports, and optimizing

the SQL using the VLDB properties.

. Resolved the defects during the QA and UAT testing process.

. Having experience in leading team and possess excellent communication

and interpersonal skills, ability to quickly grasp new concepts, both

technical and business related and utilize as needed.

. Designed and develop VB.net application that utilized MicroStrategy

SDK to automated e-mail and multiple MicroStrategy attachments.

. Strong skills in Requirement gathering and study, Gap Analysis, Scope

Definition, Recommendations to Business Process Improvements,

Development of Procedures, Forms & Documentation, Effort Estimation,

Resource Planning, Project Tracking, UAT.

Environment: MicroStrategy 9.0.2,Architect, MicroStrategy SDK, Web

Intelligence, Object Manager, Cognos 8.4.1,Framework Manager, Query Studio,

Report Studio, Informatica 8.6.1, Teradata 12, DB2 8.x/9.1, Oracle

10GR2,SAP, SQL, PL/SQL, Windows NT and UNIX.

Center for Medicare & Medicaid Services (CMS), Baltimore, MD

01/09 - 09/09

MicroStrategy Consultant

Project: BI MicroStrategy Reporting System

. Co-ordinated meetings with clients and business users to discuss and

understand requirements.

. Discussion with data modelers to understand data modeling of existing

schema.

. Worked with client to gather requirements and prepared technical

specifications documents.

. Responsible for the preparation and presentation of proto-type reports

to end users and get acceptance to develop reports.

. JAD (Joint Application and Design) sessions and GAP analysis sessions

to understand existing reports and convert Cognos reports into

MicroStrategy by creating corresponding Attributes, Metrics, Filters

and Prompts.

. Migration of Cognos reports into MicroStrategy Reports.

. Designing of schema objects like Attributes, Facts, Hierarchies and

Transformations from data warehouse.

. Expertise in using Apply simple Function in Attributes and Metrics to

make manipulations to values.

. Responsible in developing of public objects (Filters, Prompts,

Metrics, Consolidations, Custom Groups, Templates and Reports) on top

of Schema Objects.

. Responsible for the creation of metrics like Compound metric, Derived

Metric, Filter Metric and Transformation metric to generate more

complex MicroStrategy reports in an efficient way.

. Creation of logical views and Freeform SQL Reports to translate

Freeform SQL Cognos Reports into MicroStrategy Reports.

. Used Heat Map widget to quickly grasp the state and impact of a large

number of variables at one time.

. Expertise in developing MicroStrategy reports by combining multiple

Cognos reports based on functionality and usability of reports.

. Used Apply Simple and Apply Comparison functions to develop Advanced

Filters and Transformations.

. Involved in creation of reports at Aggregate Level as well as Detail

Level Tables to retrieve data in an efficient way.

. Setting of VLDB Properties to improve performance of reports as well

as passing hints to the SQL queries.

. Creating Dense Rank function metric at report level to generate

sequence numbers for PDE Transactions.

. Expertise in developing dashboard reports in MicroStrategy by

combining multiple reports in Cognos by using selectors.

. Development of reports on Sap Cubes.

. Moving the objects between two projects and two different environments

by using Object Manager and resolve conflicts between environments by

using conflicts resolution window.

. Involved in creation of Users/User Groups and assigning appropriate

privileges through User Manager in Administration.

. Preparing Test Plans, Test Conditions for developed reports and

uploaded test conditions into the Quality Center and Pass those

conditions into the Test Lab.

Environment: MicroStrategy 9.0.2, Architect, Web Intelligence, Object

Manager, Cognos 8.4.1,Framework Manager, Query Studio, Report Studio,

Informatica 8.6.1, Teradata 12, DB2 8.x/9.1, Oracle 10GR2,SAP, SQL, PL/SQL,

Windows NT and UNIX.

Schering-Plough, Palo Alto, CA

05/08 - 12/08

SAS Developer

Project: ODW BI Reporting System - The main goal of the project in Acxiom

is to update the data in the database through appropriate SAS Routines like

SAS WPS to save and convert all the tables in database into .wpd files.

Validated the data in the meta-data and scheduled many SAS jobs on timely

basis to check the updates and to make sure all the data in the database is

getting updated without any errors. Also checking for the errors in the

already existing data in the database and correcting it with the accurate

values to make the complete re-designing of the database with all the error

free data.

. Reviewed and rebuild of automotive model ETL code.

. Reengineered several programs in order to efficiently score in

existing environment, and to provide the code base to migrate into

modeling services

. Worked with CMS Scheduler application to schedule jobs and run post

processes with the partitions.

. Quickly appended Syndicated models to Client files.

. Built routines to manage and update the field's meta-data.

. Made the 3rd party syndicated data organized and available for

analytical use.

. Re-designed database and participated in importation processes.

. Used shell scripting to schedule SAS jobs on UNIX environment.

. Used advanced macros to automate the SAS code.

. Used R SUBMIT feature to run jobs on a remote machine.

. Took part in creating Data Models for different level of test

validation based on the reports.

. Using SAS for extract, transfer and load ("ETL") methodology and

processes

. Interacting with Project Managers to understand reporting requirements

and translate into SAS code.

. Creating and maintaining database tables, web pages, also format,

edit, manipulate and merge large-scale datasets.

Environment: BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT, SAS/CONNECT,

SAS/Access, SAS/Graph, UNIX Shell, MS Excel, Windows7.

Convergys, Pune, India

01/06 - 04/08

Database Developer and Admin

. Carried out detailed study of business, data analysis and configured

the material management module to user specification.

. Developed and maintained logical schema, physical records and SQL

queries for ORACLE application.

. Tuned Oracle for performance improvement and resolved network

configuration and connectivity related problems.

. Created triggers and stored procedures based on the functionality.

. Located and corrected problems involving file operations, process

management, I/O operations and memory management for pre-compilers and

SQL*net modules.

. Involved in developing ER diagrams.

. Designed and implemented utilities which automated several DBA

functions.

. Developed the user interface and menus using triggers, functions and

procedures.

. Constructed several normalized database tables with different

constraints to maintain integrity.

. Established customer support tracking database.

. Represented the team in documenting and maintaining the changing

requirements, design review feedbacks and work discussions with the

client.

. Generated Reports and Charts using BO.

Environment: PL/SQL, Developer 2000, Oracle 9i, Windows XP, Business

Objects Enterprise 6.

Contact this candidate