Manager Project

Anil Mallavarapu

Sr.MicroStrategy Consultant

*********.*@*****.***

Phone: 704-***-****

Professional Summary:

. Around 8 years of experience in the field of Information Technology

with a wide-spectrum of experience in Relational Database, OLAP,

Design and Development.

. Good understanding and sound knowledge in the concepts of Data

Modeling, Data Warehouse and Data Marts.

. Strong experience in Microstrategy tool Suite (Administration,

Architect, Desktop, Web, Narrowcast Server).

. Extensively worked in creating and integrating Microstrategy reports

and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates,

Consolidations and Custom Groups) with the data warehouse.

. Very Strong experience on working with Dashboards, Scorecards and

Report services suite.

. Strong exposure to Microstrategy Architecture responsibilities.

. Performed various Microstrategy Administration tasks like Installing,

configuring, monitoring and tuning the Microstrategy components.

. Setting up of user accounts and privileges, migration of objects from

different environments, and performance monitoring of the

Microstrategy tool.

. Experience in developing Delivery Reports using MicroStrategy

Narrowcast Server.

. Experience in Oracle 10g/9i, Teradata, SQL and MySQL.

. Efficient in Optimizing, Debugging and testing SQL queries.

. Have good knowledge and experience in Software Quality Assurance

tested the web based applications and database applications.

. Hands on experience in writing Test Plans and Test Cases for testing

team.

. Strong experience in client interaction and understanding business

application, business data flow and data relations from them.

. Experience in user training and creation of accurate documentation.

. Ability to work in multiple projects simultaneously and independently

as well as in a team environment

. Efficient in leading a team of size greater than 5 and able to work in

multiple projects simultaneously (independently/in a team

environment).

. Good Inter Personal skills, team player and self-starter.

Technical Strengths

Business Intelligence: MicroStrategy 9.0.0 / 8.x [Administration,

Architect, Desktop,

Web, Narrowcast Server, Report

Services, Object Manager,

Command Manager and Enterprise Manager]

ETL Tools: Informatica.

Data Modeling: Toad for Oracle 9.1, Erwin 4.x/7.x

Web Servers: IIS6 [Internet Information Services]

RDBMS: Oracle 10g/9i, IBM DB2, Teradata, SQL Server

Languages: SQL, PL/SQL, Java, C++, HTML, XML, CML, Shell Scripting.

Operating Systems: MS Windows NT/2000/XP/ME/95/98, UNIX.

Professional Experience:

Project: Synergy BI Jan'10 - Till

date

Eisai Pharmaceuticals, NJ

Sr.MicroStrategy Developer

Description:

The main purpose of the Synergy BI project is to create

Dashboards based upon the marketed products of EISAI. These dashboards help

to analyze the market share of the EISAI's consolidated brands and products

across different channels.

Responsibilities:

. Worked closely with business to understand and prioritize goals and

information needs.

. Extensively worked in designing and developing Flashy Interactive

Scorecards and Dashboards according to Business Requirements.

. Created sales/trend-based Dashboards using Stacks and Panels.

. Excelled in using Widgets for Flash reports.

. Worked heavily on Performance tuning to reduce the run time of

Microstrategy reports drastically.

. Assisted Administration team during the project migrations to various

environments using the Microstrategy Object Manager.

. Designed and created reports using Attributes, Facts, Metrics,

Filters, Consolidations, Custom groups and Prompts.

. Using the the Microstrategy Excel, created, delivered the embedded

dashboards to the end-users.

. Collaborated with the Application Development team and other cross

functional teams to solve product and customer issues.

Environment: Microstrategy 9.0.0 Product Suite (Administrator, Architect,

Desktop, Narrowcast Server, Web), Oracle 9i, SQL Server, Informatica.

Project: CREDO BI Apr'09

- Jan'10

Credo Mobile, San Francisco, CA

Sr.MicroStrategy Architect/Developer/Administrator

Responsibilities:

. Worked closely with the end users and internal business analysts for

data requirements gathering, design, prioritized business goals and

information needs.

. Participated in review, sign-off and communication of all changes or

modifications to specification documents

. As an Architect created Attributes, Facts, Transformations and defined

the Attribute relationships.

. Took the roles of the Administrator during project migrations to

various environments, configured the Project level and I-Server

settings and setting up of user accounts and privileges to meet the

needs of the users.

. Designed and created reports using Attributes, Facts, Metrics,

Filters, Consolidations, Custom groups and Prompts.

. Extensively worked in designing and developing Flashy Interactive

Scorecards and Dashboards according to Business Requirements.

. Worked heavily on Performance tuning to reduce the run time of

Microstrategy reports drastically by changing the VLDB properties,

reducing the number of sql passes, additional index creation etc.,

. Developed, Tested and Implemented Narrowcast server objects like

Information Objects, Schedules, and Subscription sets (static and

dynamic) necessary for the generation of Narrowcast Services.

. Assisted in delivering personalized content [via emails/files] to the

subscribers using MicroStrategy Narrowcast Server.

. Assisted the DBA's and the ETL architects to design and create Tables

to improve the performance of reports.

. Collaborated with the Application Development team and other cross

functional teams to solve product and customer issues.

. Involved in training the end users with Microstrategy Web reports.

Environment: Microstrategy 8.1.2 Product Suite (Administrator, Architect,

Desktop, Narrowcast Server, Web), Oracle 9i, SQL Server, Informatica.

Project: Financial & Retail Analytics Datawarehouse

Jun'08 - Feb'09

Disney Consumer Products & The Disney Store, Glendale, CA

Sr.MicroStrategy Architect/Developer/Administrator

Responsibilities:

. Worked closely with the end users and internal business analysts for

data requirements gathering, design, prioritized business goals and

information needs.

. Lead a team of size 6 by taking in-time technical decisions and

allocated resources to minimize cost, risk and delay of the whole

MicroStrategy environment.

. Excelled in setting up the whole Microstrategy environment from the

scratch. [ie starting from the I-Server installation till the project

roll-out to the users]

. As an Architect created Attributes, Facts, Transformations and defined

the Attribute relationships.

. Took the roles of the Administrator during project migrations to

various environments, configured the Project level and I-Server

settings and setting up of user accounts and privileges to meet the

needs of the users.

. Worked heavily on Performance tuning to reduce the run time of

Microstrategy reports drastically by changing the VLDB properties,

reducing the number of sql passes, additional index creation etc.,

. Using the the Microstrategy Excel, delivered the embedded reports to

the end-users.

. Involved in creating of the templates and design of the logical model.

. Programmed Unix Scripts to Enable/Disable the I-server and tigger the

events after the ETL data load happens.

. Provided the initial support after the project roll-out to the end

users in Production.

. Used the Enterprise Manager to create and produce statistic report to

optimize the Microstrategy system.

. Managed to be the point of contact for the whole Microstrartegy setup

during the Server upgradation and migration.

Environment: Microstrategy 8.1.2 Product Suite (Administrator, Architect,

Desktop, Object Manager, Enterprise Manager, Web), Oracle 9i, SQL Server,

Informatica.

Project: Global Investment/Corporate Banking Aug

'07 - Jun '08

Bank of America, Charlotte, NC

Sr.MicroStrategy Architect/Developer

Responsibilities:

. Worked closely with customers and other team members to understand and

prioritize business goals and information needs

. Involved in the Design Architecture of MicroStrategy Schema by

creating Attributes, Facts, Transformations and by defining the

Attribute relationships.

. Worked heavily on Performance tuning to reduce the run time of

Microstrategy reports drastically.

. Designed and created reports using Attributes, Facts, Metrics,

Filters, Consolidations, Custom groups and Prompts.

. Extensively worked in designing and developing Interactive Scorecards

and Dashboards according to Business Requirements.(Developed over 80

RSD's)

. Handled development of multiple projects at the same time.

. Used the Project documentation wizard for creating the Documentation

for various projects in the Development Phase.

Environment: Microstrategy 8.0.2 Product Suite (Administrator, Architect,

Desktop, Object Manager, Enterprise Manager, Web), Oracle 9i, Informatica.

Project: Student Lending Files to Finance, SunTrust Bank

Jan '06 - Aug '07

Richmond, VA

MicroStrategy Consultant

Responsibilities:

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

data flow and interacted with the users to collect the business

requirements.

. Used MicroStrategy Desktop to generate Advanced Reports, developed

Metrics and Filters for reporting.

. Worked on the performance tuning of the MicroStrategy reports after

implementation.

. Developed, Tested and Implemented Narrowcast server objects like

Documents and Schedules necessary for the generation of Narrowcast

Services.

. Assisting Business System Analysts in user training and creation of

accurate documentation.

. Trained and assisted the end users with Microstrategy Web reports.

Environment: Microstrategy 8.0.1 Product Suite, Teradata, Informatica,

Erwin.

Project: S&P [Sales and Profit] Analysis Curve

Oct '04 - Dec '05

Amway

Analyst Programmer

Responsibilities:

. Created various application objects necessary to support the project

requirements - Filters, Metrics, Templates, Custom Groups,

Consolidations, Prompts, Reports.

. Validated the report SQL to ensure that proper tables are being used.

. Extensively worked in designing a developing Report services, HTML

Documents according to Business Requirements.

. As a Report writer formatted the reports as per the client

requirements and updated the reports using the new developments.

Environment: Microstrategy 7.x Product Suite, Oracle 9i, Informatica

PowerCenter 6.5

Project: Venus Sales Information for 123mrp, UK Apr

'02 - Aug '04

Errand Technologies

Analyst Programmer

Responsibilities

. Interacted with the Business Stream Leads (Portfolio Managers,

Business Analysts, ETL Team) to understand the report

requirements and business rules to be applied.

. Created Report Templates for consistency in the look and feel of the

reports.

. Tuned universes for efficient query performance.

Environment: Business Objects 5.1.6, Designer, Supervisor, Business

Query.

Education:

. B S in Computer Science, 2002.[pic][pic]

Contact this candidate