Summary:

. Eight years of IT experience in software development, designing and

implementing with major focus on Business Intelligence Tools, ETL and

Database Applications.

. Over 7 years of strong experience in MicroStrategy 9.x/8.x/7.x,

MicroStrategy Desktop, Microstrategy Report Services, MicroStrategy

Web, MicroStrategy Intelligence server, MicroStrategy Narrowcast

server, Microstrategy Enterprise Manager

. Experience working with the full life cycle development process, which

includes analysis, design, development and testing.

. Knowledgeable in business functionality for developing

multidimensional modeling (Data Modeling).

. Delivered reports in Desktop and Web and via Narrowcast Server to

multiple users

. Strong Proficiency in Microstrategy connectivity with DB2, Oracle, SQL

Server & Teradata.

. Extensive Microstrategy development hands on experience with Desktop,

Architect, Intelligence Server, Report Services, Enterprise Reporting,

OLAP provider, Data Mart and Web components.

. Analysis of Data with documentation on scope of data sources, existing

KPI's, scope of historical analysis and data granularity required

. Experience in Schema design and creating Schema objects using Star and

Snowflake (Hierarchies, Attributes and Facts, Transformations).

. Excellent experience in Microstrategy Report development, Report

testing, Report tuning, Ad-hoc, scheduling report delivery and

Alerts..

. Extensive experience on all types of Microstrategy Filters, Prompts,

Templates, Metrics, Consolidation and Custom Groups.

. Experience with Microstrategy Web customization with XML/XSL etc.

. Experience in using Project Merge, Object Manager, and Enterprise

Manager.

. Exposure to ETL methodology for supporting Data Extraction,

Transformations and Loading processing in a corporate wide ETL

solution using Informatica.

. Excellent experience configuring VLDB properties to fine-tune reports.

. Exceptional ability to quickly master new concepts and capable of

working in group as well as independently with excellent communication

skills.

. Experience working in a structured, multi-person development

environment.

. Experience training non-technical users and providing customer

support.

Education: Bachelor of Computer Science

Technical Skills

Business Microstrategy 7/8 /8.1/ 9.0, Business Objects,

Intelligence Crystal Reports, Informatica 5.0,OBIEE

Data Modeling ERWIN, UML, ER diagrams, Microsoft Visio

DB Programming SQL, PL/SQL, OLAP queries, MS SQL, DB2

Databases Oracle 8i/9i, MySQL, DB2, Ms Access, Teradata,

Sybase,V2R5

Scripting Unix shell script, VB script, Java Script

Web Programming ASP 3.0/4.0, ASP, PHP, Cold Fusion, XML, XML

Schema, CSS, HTML, DHTML, XHTML.

Front End / GUI VB 5.0/6.0, Developer 2000, TOAD.

Operating System WINDOWS 9x/2000/NT/XP, MS-DOS, UNIX, VMS & MAC,

Mainframe

Professional Experience:

Nationwide Insurance, Dublin, Ohio

Mar2010-Till date

Microstarategy Developer

Responsibilities:

. Worked with business team, Agent Gateway marketing (AGM), Exclusive

Agents to increase the customer opportunities and prospects like Auto

Premium Change, On Your Side Reviews, ReQuote and Winback.

. Understand the business requirements, update design documents,

Involved in weekly meetings. Worked cohesively with business and

technical teams to fulfill their requirements.

. Followed waterfall methodology, supported business user for training

materials, UAT testing & support, follow up the weekly meetings.

. Created and Updated Id design document which contains all the detailed

information of internal and external reports in summary and detailed

level

. Well coordinated with the ETL (Informatica) team and data modeling

team to build reporting database according to our requirements.

. Conducted weekly design session meetings, business review meetings

discussed the business flow, scheduled work plans to meet the

deadlines.

. Designed Documents, Templates, created Filters and generated

MicroStrategy Reports in grid and graph mode.

. Performed Administration tasks, like User Creation, Session Handling,

Creating Security roles for reports and dash boards according to the

levels of security.

. Created documents, filters, metrics, attributes, prompts, custom

groups dash boards.

. Developed reports involving compound metrics containing prompted

filters, relationship filters.

. Worked with back end Database Administrators to provide requirements

for necessary back end tables. Created & updated Views, stored

procedures in Teradata Database.

. Worked with the business team to open the issues in the reports and

also worked with the technical team to fix all the issues.

. Used analytical and governing settings in VLDB properties to tune the

SQL and for calculating the metrics in dealing with the nulls and

zeroes.

. Tested report layouts, validated the SQL query, prompt ordering,

prompt defaults, security filters, export/print functionality and

drilling options

. Test & validated the reports and dashboards from Prod to QA. Supported

& fixed issues for Unit testing, Incremental testing and System

testing.

. Migrated Attributes, Metrics, Custom Groups, Grids from Dev to QA and

QA to Prod by using Object Manager.

. Standardized the production environment by creating release notes for

Schema and Public Objects. Provided technical support, user training,

user documentation, and technical documentation.

. Production supports including troubleshooting reports, views used in

the reports and coordination with the ETL team for quick resolution

of issuses

. Adept at managing projects through entire systems development life

cycle, including creating timely thorough status reports and leading

status meetings

Environment: MicroStrategy 9, MicroStrategy Desktop 9.x, MicroStrategy Web

9.x, MicroStrategy Intelligence Server 9.x, Informatica Power Center 8.1,

Teradata, Windows XP Professional.

AT&T Middletown, NJ

Apr2009 - Feb2010

MicroStrategy Architect/Admin

Responsibilities:

. Created documents for technical and business specifications based on

requirements for the Marketing department.

. Managed projects through entire Systems Development Life Cycle,

including creating timely thorough status reports and leading status

meetings.

. Created logical data models to recognize source tables and columns, to

build Microstrategy Schema objects including Attributes, Facts,

Hierarchies and Relationships necessary to

create MicroStrategy project.

. Took part in full data warehousing application lifecycle starting from

creating logical and physical data model, to implement and test ETL

processes in Teardata production environment.

. Developed Flash Dashboards in MicroStrategy 9 using Widgets and

Selectors for summary level reporting

. Performed Administration tasks, like User Creation, Session Handling,

Creating Security roles, Analyzing Report performance, administered

all aspects of web, Intelligence server and Narrowcast Server.

. Created joins and relationship according to the data model Schema.

. Worked with back end Database Administrators to provide requirements

for necessary back end tables. Created stored procedures, views and

triggers using Teradata Queryman.

. Identify and modified source tables and columns in the warehouse

required to create the MicroStrategy project. Studied and modified the

attributes, facts and hierarchies based on the requirement. Used

MicroStrategy Desktop for creating various application objects.

. Tested report layouts, validated the SQL query, prompt ordering prompt

defaults, security filters, export/print functionality and drilling

options like simple and advanced.

. Installed Microstrategy BI tool on the server and configure the system

for architecting the data model into Microstrategy environment.

. Extensively worked in developing Metrics (Dimensional metrics,

Compound metrics), Filters, Custom groups and Consolidations for

complex reports.

. Extensively used MicroStrategy administration tools include

MicroStrategy Command Manager, MicroStrategy Enterprise Manager, and

MicroStrategy Object Manager, Job Monitor.

. Designed Templates and Filters to generate reports in grid and graph

mode. Auto prompt filter feature gave end-user a choice of different

filtering criteria each time they run the report.

. Used Transformations for comparative reports like claims this year to

last year (year to date and month to date).

. Proactively created report formats and delivered personalized messages

from the BI platform through MicroStrategy Narrowcast Server to a wide

range of users.

. Involved in various back end ETL development tasks and Production

Support.

. Conducted meetings to gather user/business requirements and also

carried out quality reviews with the Users and created documentation

for the same.

Environment: MicroStrategy 8.1/9, MicroStrategy Desktop 8.x, MicroStrategy

Web 8.x, MicroStrategy Intelligence Server 8.x, Microstrategy Narrowcast

Server, ERWIN 4.0, TOAD 7.0, Informatica Power Center 5.1, Teradata V2R5,

Oracle 11i, Windows XP.

Wells Fargo, San Francisco, CA

May2008 - Mar2009 Microstrategy Architect/developer

Responsibilities:

. Worked on requirements gathering from the clients and estimation of

efforts including analysis of existing system and analysis of data.

. Designed and developed the environment to generate reports.

Extensively worked on Logical Data Modeling, Installing and setting up

of Microstrategy Intelligence server and Web servers. Involved

in Clustering of servers. Developed DTS packages to populate SQL

Server warehouse and Oracle databases.

. Created Microstrategy Schema objects and Application objects using

Microstrategy Desktop and Architect.

. Installed Microstrategy BI tool on the server and configure the system

for architecting the data model into Microstrategy environment.

. Involved in Design and Development of OLAP data Models and worked on

ROLAP data Models for Querying / Reporting the data

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

for the report development.

. Created Complex metrics, Nested Filters, Nested Prompts Custom Drill

Maps, Templates for Graphs and Templates for Drilled reports

. Created ad-hoc reports in Grid & Graph mode consisting of data

analysis by combining a template with filters using MicroStrategy

desktop and web.

. Used apply functions like apply simple to meet the report requirements

wherever necessary.

. Extensively used report services to create dashboards to create

summary level reports using multiple datasets.

. Used analytical and governing settings in VLDB properties to tune the

SQL and metrics involving nulls and zeroes.

. Extensively worked on Dashboards and have utilized the new features to

convert the dashboards into Flash mode.

. Used several new controls for dashboards like time series slider,

radio buttons and dropdown menus for the Flash version of the

dashboards.

. Used several widgets for Dashboard like Funnel, Gauge, Heat maps for

reporting.

. 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.

. Created advanced grid reports, consisting of data analysis by

combining a template with filters. The end-users were able to generate

ad-hoc report by drilling up, down, within and across dimension or

anywhere.

. Provided access to the Data Warehouse to a much larger audience by

using Narrowcast Server. The reports and Information have been

personalized as per the user requirements

. Performing all the administration tasks like Monitoring and Analyzing

the system usage and managing the projects. And using the Command

Manager to purge the caches on database loads.

. Used free form SQL editor for complex report creation to get the data

from the Data warehouse

. Fixed Defects and performed upgrades for existing projects.

Environment: Microstrategy 8.1(Administrator, Architect, Desktop,

Narrowcast sever, Object Manager), Oracle 9i, Informatica 6.2, Windows XP

Professional.

AstraZeneca Pharmaceuticals, Wilmington, DE

Apr2007- Mar2008 MicroStrategy Developer/Architect

Responsibilities:

. Designed Components, Templates, created Filters and generated

MicroStrategy Reports in grid and graph mode.

. Understand the business and data model and warehouse tables. Created

the Microstrategy project and built attributes and facts based on the

data model of the solutions architect.

. Created logical data models, recognized source tables and columns, and

built Schema objects, Application objects necessary for creation of a

MicroStrategy project

. Administered all database objects, including tables, clusters,

indexes, views, Sequences packages and procedures. Used Ab-Initio to

develop database repository for back-end access to database engines.

. Developed Microstrategy project design and reports. Refined reporting

business requirements. Created necessary objects to meet report

requirements.

. Created and maintained attributes, metrics, filters, prompts and

reports. Maintained security for all users. Created database views and

performed quality assurance for all reports. Performed technical

problem solving and troubleshooting. Coordinated and

deployed Microstrategy report changes to the Production environment.

. Coded the Design Specific template and developed the Ab-Initio graphs

needed in preparation for design of the interfaces.

. Designed the Schema, finalized naming and coding standards throughout

project life cycle.

. Ensured data is uniformly distributed across all amps using Hash

Functions for better performance of the queries. Designed ETL process

to extract data from SQL server2000 and SAS to Teradata and performing

data scrubbing, restructuring and consolidation for Web reporting.

. Created Batch processes using FastLoad, BTEQ, Unix Shell and Teradata

SQL to transfer cleanup and summarize data, Wrote Perl and Unix Shell

scripts. Automated transfer of data entry using Informatica Power

Center.

Environment: MicroStrategy 8.0/7x Desktop, Architect, MicroStrategy

Intelligence Server, Narrow Cast Server, Report Editor, Configuration

Wizard, ScanMD, FastLoad, MultiLoad, FastExport Visual Explain, OleLoad,

Queryman, DB2, Oracle 8i, Windows NT / 2000.Windows XP.

Albertsons Inc., Boise, ID

Jan2006 - Mar2007

Business Intelligence Consultant

Responsibilities:

. Worked as a Project Lead, Data Analyst and Microstrategy consultant to

the distribution accounting team.

. Identified and documented data source systems, data elements and KPIs

based on the key excel reports and discussions with the business lead

and users.

. Listed each data source element at its lowest grain, scope of data

sources and scope of historical analysis cross referenced to each

report.

. Converted existing interactive reports with prompts to non-prompted

reports for Narrowcast Server.

. Created data dictionary in the process required for the data modeling

and architecture efforts involved in creating the data mart in the

Enterprise Data Warehouse (EDW).

. Developed a Microstrategy project source and metadata using the

configuration wizard and the project source manager and created the

microstrategy project using the project creation assistant to develop

the schema objects using the existing physical model.

. Designed several metrics, filters, prompts, custom groups and

consolidation objects for the development of reports. Created reports

based on the requirements and data available using Microstrategy

Desktop.

. Assisted the Director of Distribution in creating the Leadership

reports for the project.

. Interacted with Subject Matter Experts (SME), Information and

Integration Architects to get required information for report design

processes and implemented optimization techniques to enhance

performance of the microstrategy platform.

Environment: MicroStrategy 7, MicroStrategy Desktop 7.x, MicroStrategy Web

7.x, MicroStrategy Intelligence Server 7.x, Microstrategy Narrowcast 7.x,

ERWIN 4.0, Decision Point/ Decision Cast 10.5.1, Informatica Power Center

5.1, Teradata V2R5, Oracle Financials, Windows XP.

Publix Super Markets, Inc Lakeland, FL Nov2004

- Dec2005 MicroStrategy Developer

Responsibilities:

. Designed and implemented MicroStrategy reports by creating projects,

attributes, hierarchies, metrics, filters and templates

. Developed MicroStrategy Schema objects, Application objects, Delivery

objects including Metrics, Metric properties (Dimensionality, Filter,

Transformation), Filter objects including security filters, Reports

(complex, Ad hoc, Parameter-driven, Personalized, indicator, Set

analysis, What-if analysis, Data-mining, Data mart reports, etc).

. Gathered requirements from management users for generation of reports in

Web and Desktop

. Created logical data models, recognized source tables and columns, and

built Attributes, Facts, drill-maps,Hierarchies and Relationships

necessary for creation of a MicroStrategy project

. Developed suitable Metrics (Derived metrics, Compound metrics),

Consolidations for complex reports

. Facilitated Business analysis by creating relevant reports by using

filters, custom groups, consolidations and transformations(table based,

formula based)

. Optimized the performance of the MicroStrategy platform by implementing

suitable report design processes, and SQL tuning

. Adept at managing projects through entire systems development life cycle,

including creating timely/thorough status reports and leading status

meetings

. Conducted unit and system-level testing for all reports and objects

. Standardized the production environment by creating release notes for

Schema and Public Objects

. Team member for the upgrade from 7.5.2 to 8.0.1

. Wrote test cases using Test Director for all reports being developed, and

tested

. Authored a MicroStrategy Help File/Manual and user guides for projects to

facilitate easy navigation

Environment: MicroStrategy7.2.3, 7.5, 8.01 (Architect, Intelligence server,

Web, Web Universal, Narrowcast server, Desktop), Report Services, Teradata

and Windows2000.

Steelcase, Grand Rapids, MI

Sep2003 - Oct 2004

Microstrategy Developer / Administrator

Responsibilities:

. Involved as a technical expert providing input to application design

regarding production tuning and administration requirements.

. Used Erwin to create a logical data model of the data warehouse for the

use of Microstrategy Developers.

. Involved in maintaining optimal performance of BI application,

performance monitoring, capacity planning, and tuning for multiple users.

. Building new projects to support new reporting schemas and provided user

level access to projects

. Involved in Managing migration of Microstrategy projects and objects from

Development to Testing and to production environment.

. Developed and maintained front-end repositories including metrics,

filters, views and dimensions.

. Involved in troubleshooting Microstrategy prompt, filter, template,

consolidations, and custom group objects in an enterprise data warehouse

team environment.

. Used Report Services to create comprehensive documents for ease of

analysis.

. Designed Custom drill maps using drill map editor as per the requirements

for drill through functionality.

. Used analytical and governing settings in VLDB properties to tune the SQL

and for calculating the metrics in dealing with the nulls and zeroes.

. Narrowcast Server was used in the various phases of Report delivery

namely Subscription Portal, Services and Personalization.

. Provided access to the Data Warehouse to a much larger audience by using

Narrowcast Server. The reports and Information have been personalized as

per the user requirements.

. Managed user subscriptions and preferences in Subscription Portal.

. Involved in Conversion of Corporate Data Model into a Warehouse Star and

Snowflake Model

. Involved in normalizing the data from source systems by identifying

columns in the table, which came in as fully De-normalized flat file.

. Used SDK for web customization.

. Worked with the administrator to monitor and fine tune SQL queries for

better performance of reports.

Environment : Microstrategy 7.5.3 (Later 8.0.1) (Desktop, Web,

Intelligent Server, Narrowcast Server, Oracle 9i, Informatica 7, ERWIN,

UNIX, Windows 2000, ER diagrams, Data Flow diagrams, TOAD.

UTstarcom, Alameda, CA

Oct2002 - Aug2003 ETL Developer

Responsibilities:

. Involved in Extraction, Transformation and Loading (ETL) processBuilt

Dimension Tables and Fact Tables based on the data warehouse design

. Written Triggers and Stored Procedures using T-SQL for Incremental

updates

. Participated in build of the Data Warehouse which includes the Design

of Data mart using Star Schema

. Designed Star Schema for faster effective Querying

. Created necessary repositories to handle the metadata in the ETL

process

. Created the Source and Target Definitions in Informatica Power Center

Designer

. Created Reusable Transformations and Mapplets to use in Multiple

Mappings

. Created Sessions and Batches using Server Manager for data movement

through Mappings

. Created various financial and forecasting reports as per the

requirements

. Provided end user training and Production System Support

Environment: Informatica 5.1, OBIEE, MS SQL Server 2000 and Windows NT

Canara Bank, INDIA

Mar 2002 - Sep2002

Software Developer

Responsibilities:

. Determined the SQL Server Installation. Installed SQL Server Management

tools using SQL Server Setup Program

. Physical Implementation of database into SQL Server 2000 using T-SQL.

. Worked on Client/Server tools like SQL Server Enterprise Manager and

Query Analyzer to administer SQL Server

. Created Database Maintenance Planner for the Performance of SQL Server,

which covers Database Integrity checks, Database Statistics update and

Re-indexing

. Created views to facilitate easy user interface implementation, and

triggers on them to facilitate consistent data entry into the database.

. Created complex stored procedures and functions to support efficient

data storage and manipulation

. Worked on DTS Package, DTS Import/Export for transferring data from

heterogeneous database

. Data migration (import & export - BCP) from Text to SQL Server

. Generated ad-hoc reports using MS-Access and Crystal Reports

. Coordinated post-implementation events such as testing

Environment: SQL Server 2000, T-SQL, Excel, Access, Crystal Reports 9.0 and

Windows NT

Contact this candidate