SUMMARY

• 10+ years of total IT experience and Technical proficiency in the Data Warehousing involving Business Requirements Analysis, Application Design, Development, testing and documentation.
• Around 6.5+ years of Comprehensive working Knowledge with MicroStrategy Suite (Desktop, Architect, Web, OLAP Services Environment).
• Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy.
• Involved in Migration of project from Microstrategy to Tibco Spotfire.
• As part of migration I have created useful visualizations to make the analysis easy and fruitful to the users using Tibco Spotfire.
• Extensively worked in creating MicroStrategy Public and Schema Objects (Attributes, Facts, Hierarchies, Relationships, Metrics, Filters, Prompts, Templates, Consolidation and Custom Groups etc)
• Experience in Microstrategy Architect, Object Manager, Development - designing and dashboards in MicroStrategy.
• In-depth understanding of fundamental data warehousing concepts such as Star and Snowflake Schemas, Fact and Dimensional tables, Logical and Physical data modeling.
• Experience in Microstrategy schema & application layer, report analysis & report services design, development, implementation, migration and testing.
• Exposure to Clients interaction, user- requirement analysis and user support.
• Involved in ETL team to develop detailed project plans, transformation specifications and data mappings based on requirements.
• Extensive knowledge on SQL and very proficient in working with databases (RDBMS) like Oracle, TERADATA, SQL Server.
• Involved in Full Life Cycle Development of MicroStrategy Project.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• I am a Quick learner and excellent team player, ability to meet deadlines and willing to take challenges works under pressure.
• Around 3.5 years of experience in developing .net applications. Worked on .net frame work (2.0) and SQL SERVER databases.

TECHNICAL SKILLS

BI Tools: MicroStrategy9.x/8.x ( Architect, Desktop, Web, Intelligence Server, Report Services and OLAP Services), Tibco Spotfire 7.0

Databases: Teradata 14, V2R6.0 Oracle 10g, 9i, SQL Server (2005/2008),, and Microsoft Access.

Data Modeling: Microsoft Visio

Supporting Tools: MS Project, SQL Navigator, SQL Assistant, Adobe Flash

Web: HTML, DHTML, XML, XSL. ASP.NET, ADO.NET

OS: Windows XP/2003/2000, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential

Microstrategy Architect

Responsibilities:

• Analyze the Business requirement document to understand the Business requirements.
• Created Attributes and Facts for the new requirements.
• Developed Reports and the report objects like metrics, filters and others as per the requirement.
• Created Dashboards to showcase it to the customers
• Prepared Report playback documents.

Confidential

Microstrategy Technical Architect

Responsibilities:

• Analyze the Business requirement document to understand the Business requirements.
• Involved in Migration of project from Microstrategy to Tibco Spotfire.
• As part of migration I have created useful visualizations to make the analysis easy and fruitful to the users using Tibco Spotfire.
• Involved in creating database tables and views for the enhancement purpose and utilized them in Microstrategy as per the requirement needs.
• Created Attributes and Facts for the new requirements.
• Worked on Support activities for the Microstrategy Perspective and resolved the tickets for the user.
• For reporting needs, worked extensively on creating Metrics, Filters, consolidations and custom groups.
• Migrated newly created objects from Dev. to test environment with the help of object manager.
• Created filters and other report objects, drilling, defined hierarchies.
• Develop Standard as well as Ad-Hoc Reports based on the user need, the end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the reports.
• Tested all the reports by running queries against the warehouse using SQL Assistant tool. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Used the Object Manager to move the objects from Development to QA and to Production environment in MicroStrategy.
• Prepared Mapping document to identify easily the Attributes and facts which needs to use for corresponding developed reports.
• Resolved critical issues and made the application works during the business hours for users.
• Update the ticketing tool with the status of the change.
• Support end users in helping to create their own reports.
• Responsible in checking with ETL team for data availability and cleared the data issues if any.
• Has a significant role in managing the time estimates and coordination with different teams in the project.
• Prepared Unit test cases and done the testing for developed reports.

Environment: MicroStrategy 9.4.1 Architect, Desktop, Web, Report Service Documents, Tibco Spotfire 7.0, OLAP Services, Teradata.

Confidential

Microstrategy Architect

Responsibilities:

• Analyze the Business requirement document to understand the Business requirements.
• Prepared the Logical design document for creating the Schema objects.
• Created Schema objects like Attributes, Facts for the report development using MicroStrategy Desktop according to the Design document.
• Prepared Mapping document for the development team to identify the Attributes and facts which needs to use them for corresponding developed reports.
• Created User hierarchies and hierarchy prompts based on it.
• Helped in creating the report design document for the report developers to create their reports.
• Responsible in checking with ETL team for data availability and cleared the data issues.
• Developed reports which include Advanced Prompts, Conditional, Transformation metrics and Level Metrics as per the User requirement.
• Prepared Unit test cases and done the testing for developed reports.

Environment: MicroStrategy 9.3 Intelligence Server, Desktop, Web, Architect, OLAP Services, SQL Server 2005

Confidential

Technical Lead / Functional Analyst

Responsibilities:

• Analyze the Business requirement document and prepare the functional document for the same.
• Identified and Created Schema objects like Attributes, Facts for the report development using MicroStrategy Desktop.
• Prepared Requirement playback documents.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Used conditional formatting feature to enhance grid and graphs in documents.
• Responsible for creating Metrics, Filters, Custom Groups & Consolidations, Compound metrics, Prompts, Transformations using MicroStrategy Desktop and Web.
• Analyze the database tables and views for the upstream data.
• Validate the data with querying the database tables.
• Used MSTR Web to generate the ad hoc reports.
• Developed Documents and Transformed reports by optimizing Query Performance using VLDB settings.
• Performed Unit testing and Validating, resolving data issues processes and efforts of the results to meet functional requirements.
• UAT Support for the end users
• Prepared and present the transition KT document for users to understand the application.

Confidential

Microstrategy Developer

Responsibilities:

• Experienced in large-scale, high availability, end to end MicroStrategy Business Intelligence application development through user interaction to gather business requirements.
• Prepared Documentation and User Guides to identify the various Attributes, Facts, Metrics and multiple Grid & Graph Report objects embedded in HTML Documents needed by business users.
• Created documents with both Grids and graphs as per user requirements.
• Identified and Created Schema objects like Attributes, Facts for the report development using MicroStrategy Desktop.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Used conditional formatting feature to enhance grid and graphs in documents.
• Responsible for creating Metrics, Filters, Custom Groups & Consolidations, Compound metrics, Prompts, Transformations using MicroStrategy Desktop and Web.
• Created Complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality.
• Developed Documents and Transformed reports by optimizing Query Performance using VLDB settings.
• Provided access to MicroStrategy platform from Microsoft Excel (Non-MicroStrategy Interface) by using MicroStrategy Office.
• Performed Unit testing and Validating, resolving data issues processes and efforts of the results to meet functional requirements.
• Assisted in rollout, maintenance and support for project end users and ongoing admin functions.

Environment: MicroStrategy 9.1 Intelligence Server, Desktop, Web, Report Service Documents, Narrowcast Server, OLAP Services, Teradata.

Confidential, Overland Park, KS

Programmer Analyst (Microstrategy Developer)

Responsibilities:

• Involved in full life cycle development of Business Intelligence System.
• Involved in implementation of Microstrategy Reporting Suite including web and narrowcast server.
• Created Attributes, Facts, Advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters according to the business needs.
• Communicated with the business, Data Modeling team and ETL team in various levels for the stabilization of the reports.
• Implemented drill functionality on the reports using Drill Maps.
• Provided access to MicroStrategy platform from Microsoft Excel (Non-MicroStrategy Interface) by using MicroStrategy Office
• Involved in developing reports through Micro Strategy Desktop.
• Writing BTEQ Scripts to load data into Dimension tables with the hierarchy.
• Extensive hands-on experience working on Microstrategy Web Universal.
• Developed Reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Graphs and Alerts were used to support the Reporting process.
• Actively participated in developing the work flow for creation of report and report services by using the logical model built in consideration with the business requirement.
• Provided level of effort (LOE) estimates for new project work, enhancements and fixes.
• Developed Custom (composite) controls and user controls for reusability.
• Extensively used Obout suite for grid view, calendar controls and for combo boxes.

Environment: Visual Studio .NET 2005, Microstrategy Desktop 8.0/8.1.x, Narrowcast server, Erwin 7.x, Teradata v2r6, Windows XP.

Confidential

.NET Developer

Responsibilities:

• Gathering and Analyzing business requirements for my module from stake holders.
• Extensively used MS-Visio to draw the Use case diagrams, Sequential Diagram and Class diagrams Developed Business logics and customer service messages for the application.
• Used .Net Validation controls for client side validation.
• Developed Custom (composite) controls and user controls for reusability.
• Extensively used Obout suite for grid view, calendar controls and for combo boxes.
• Used ADO.NET extensively for data retrieving, querying, storing and manipulating
• Developed Stored Procedures using SQL Server 2005.
• Developed complex T-SQL code for data retrieval.

Environment: Visual Studio .NET 2005, Web Services, C#, ASP.NET, ADO.NET, HTML, XML, AJAX, XSL, JavaScript, CSS, MS SQL, VSS.