Summary:

• Over seven (7) years of extensive experience in IT industry in the areas of analysis, design, development in client server environment. With focus on Data warehousing, Data modeling, using MicroStrategy Platform.
• 5 years of strong experience using MicroStrategy Suite (Intelligence Server, Desktop, Narrowcast server, Web,).
• Extensive experiences in Data warehouse design, data modeling, data analysis, project co-ordination, data quality, and design and development of client/server systems.
• Expertise in understanding of OLAP/ROLAP Star Schema modeling, Snowflake modeling, Fact Lookup and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Interacted with the Business Users to understand the Business flow and the operations of the Source (OLTP) systems.
• Responsible for interacting with business analysts and business users to identify information needs and business requirements for data analysis
• Efficiently provided Business Intelligence Solution using MicroStrategy Reporting Suite which Includes Desktop, Web, Intelligence server, Architect, Reporting services, NarrowCast Server, Administrator, Enterprise Manager, Object Manager, Integrity Manager & Tools.
• Experience in Architecture process creating Schema objects with MicroStrategy Desktop like simple and compound Facts, Attributes, Fact extensions, Hierarchies, Transformations.
• Specialized in designing Report Service Documents and Dashboards with multiple datasets.
• Created Dynamic Dashboard Visualizations using features like Panel Stacks, Selectors and Widgets like Time Series Slider, Interactive Bubble Chart, Thermometer etc.
• Extensively worked in creating and integrating MicroStrategy reports, and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, and Custom Groups).
• Good knowledge in implementing and maintaining Dashboards and Scorecard Reports on the web.
• Good Understanding of Intelligent cubes and Data mart design.
• Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, Performance Monitoring, Assigning Privileges and Job Monitoring.
• Experience in working with MicroStrategy Security model including Users, Groups, Security Roles and Security filters
• Created complex reports in MicroStrategy Desktop using features like Templates, Transformations, Consolidations and Custom groups.
• Created various Schema objects with MicroStrategy Desktop like simple and Compound Metrics, Fact Extensions and Hierarchies, etc.
• Excellent Knowledge in Data modeling, Logical/Physical model & ER-Diagrams
• Worked with heterogeneous data sources like Oracle, SQL Server 2005, Essbase, Sybase flat files, XML files, DB2 files.
• Extensive experience in the field of Data Warehousing, Data Modeling, Business Intelligence and ETL Applications.
• Ability to test backend applications by writing SQL, PL/SQL and Unix Shell Scripting
• Strong experience with client interaction, understanding business applications, business data flow and data relations
• Good communication skills with strong ability to interact with end-users, customers, and team members

Technical Skills:

• OLAP/BI Tools: Micro Strategey 9.0/8.1.1 /8.0/7.5/7.x (Desktop, Architect, Web, Agent, Intelligence server) Business Objects 5.1, Cognos 8, Crystal reports, OBIEE 10.3.4.1.
• ETL Tools: Informatica (Power Center/ Power Mart) Client Tools (Repository Mgr, Designer, Server Mgr and Informatica Server), Informatica, SSIS, Talend RTX 4.1.
• Testing Tools: Quick test Professional 10.0, Quality Center 10.0, Test Director 8.0.
• Bug Reporting tools: Test Director/Quality Center, Rational Clear Quest ETL: Informatica7.1 , Abinitio 12.5, DataStage 8. Operating Systems: UNIX, Linux, Windows
• Languages: C, C++, Java (JDK 1.2/1.3), JSP, Servlets. Databases: Oracle 7.3/8i/9i/10g (SQL, PL/SQL), Sybase, MS-SQLServer, MS-Access, DB2. GUI: VB 6.0/5.0, ASP.NET, VB.NET, C#, Dev 2000.
• Web: ASP 2.0/3.0, HTML, XML, DHTML, and Web Sphere
  Scripting Languages: VBScript, JavaScript, TSL, Shell Scripts (UNIX)

Educational qualification

• Bachelors of Engineering in Computer science.

Professional Experience

Confidential , Richmond, VA.
April 11 - Present.
MicroStrategy Developer

Responsibilities:

• Creation of new users, roles, privileges, shared folders, access controls Lists using security roles in MicroStrategy.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc.
• Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, Custom Groups and Consolidations for complex reports.
• Upgraded the MicroStrategy Projects from MicroStrategy 8.0.3 to 9.x.
• Performed the administration tasks like tuning, Caching, specifying Query Governing Thresholds, and Report optimization.
• Provided access to the Datawarehouse to a much larger audience by using Narrowcast Server. The report delivery has been personalized as per user requirements.
• Created complex metrics forcing dimensionality and conditionality.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.
• Developed Multidimensional Model Logical Model by studying the source systems and business requirements.
• Used Report Cache Sharing and Data Mart reports to enhance the Report response time.
• Created Complex reports for Analysis with Transformations, Custom groups and complex filters.
• Created Complex filters with advanced qualifications involving the 'Apply' functions.
• Use Object Manager/Project Merge to manage change management for MicroStrategy objects across different environments (DEV, QA, UAT and PROD).
• Administering the business users in the portal based on the requirements. Participated in Enhancements meeting to distinguish between bugs and enhancements.
• Working closely with the ETL Team in the troubleshooting the data issues

Environment: MicroStrategy 9.x, MicroStrategy Intelligence Server, Informatica, Dimensional Data- Model. SQL*plus, Erwin 5.0, oracle10g, Toad, SQL Developer

Client: Confidential, Woonsocket, RI.
Nov 10 - April 11.
Role: MicroStrategy Consultant.

Responsibilities:

• Participated in the end user meetings to obtain thebusiness requirementsfor creating the reports.
• Implemented different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• DevelopedMicroStrategySchema objectsandApplication objectssuch as; Attributes, Facts, Metrics, Consolidations, Custom Groups, Transformations and Hierarchies.
• Extensively usedMicroStrategyReport Servicesto generate Report Documents.
• Designed an efficientBI Dashboardfor the Company Executives, through an efficient use of MicroStrategyReport Services.
• Created all possibleMetrics, for enabling the end users to generate customized reports by creating their ownTemplatesandFilters.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Worked on report services documents to create graphs as per user objective.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Created narrowcast services to email /send to a directory either report service documents in PDF or excel files. The grid reports were also narrowcast in excel format.
• Participated in review, sign off and communication of all changes or modifications.
• Performing QA and production migrations of MicroStrategy objects between development, UAT and production environments by using Object Manager/Project Mirage Wizard.
• Managing the offshore team and assigning them tasks.

Environment:MicroStrategy8.1.2 (Desktop, Intelligence Server, Web Server, Narrowcast Server, Object Manager/Project Mirage Wizard) Toad for Oracle 9.7.2, Oracle 10g database.

Confidential, Wilmington, DE.
Nov 09 - Oct 10
Sr. MicroStrategy Developer /Architect.

Responsibilities:

• Worked with client to gather requirements and prepared technical specifications Documents.
• Involved in design of proto type of reports based on requirements.
• Communicate offshore working team to explain client requirements and develop reports.
• Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis
• Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.
• Responsible for keeping team members on track toward completing the terms of goals.
• Involved in installation and configuration of MicroStrategy 8.1.1.
• Creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, reports) needed to create the MicroStrategy objects necessary for the deliverable.
• Architected the projects and created all the necessary schema, application and configuration objects.
• Creating advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Involved in creating Security filters to end users to access data Based on their privileges.
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Involved in creation of Datamart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Set-up the narrowcast environment and created services using subscription sets, schedules, Information objects.
• Creating Dash Board Reports to view personalized reports based on user requirements.
• Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Involved in customization of Grids and Graphs by using SDK.
• Involved in migration of Schema Objects (facts, attributes, hierarchies, Transformations), Application Objects (filters, prompts, metrics, consolidation, custom groups), user groups from 8.0.2 to 8.1.1.
• Involved in partitioning the tables, indexes and management of the schema objects.
• Involved in optimization of code and tuning queries for performance.
• Involved in tuning the application Queries using Explain Plan.
• Create a test plan, perform unit test and send the test plan along with the files generated for QA.
• Provided post production support to end-users.

Environment: MicroStrategy 9.0,Desktop Reports, Web Reports, Architect, Narrowcast Server, Administration, Dash Boards, Unix, Toad, VBA, SDK, Excel, Oracle 10g, Oracle10g r2, PL/SQL, Oracle Warehouse Builder 10gr2.

Confidential, Pleasanton, CA
Jan 08 - Sep 09.
MicroStrategy Architect/Administrator

Responsibilities:

• Understanding business requirements and dealing with the client.
• Creation of Project Design and Schema Objects in MicroStrategy Architect to meet proper joins requirement for the SQL generation.
• Analysis of the Dimensional Data-Modeling and suggesting changes in Data-Model to meet the reporting requirements.
• Designed and Developed Complex and large MicroStrategy Reports in MicroStrategy Desktop.
• Analysis of SQL generated by MicroStrategy.
• Troubleshooting and Performance tuning of the SQL using VLDB properties.
• Monitoring and ensuring of project progress and preparation of Status reports.
• Involved in creating and implementing MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Used advanced prompts, non-aggregatable, conditional, transformation metrics and level Metrics for creating complex reports for business analysis.
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Created several document objects to display multiple reports. Multiple report objects were embedded in the document objects, which included reports, graphs and some images.
• Transformations were used to perform time series analysis over various phases and also to calculate the variance and the growth percentage trends. Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc.
• Executed Unit and System Testing.
• Co-coordinated with ETL for proper integration and correctness of the data.

Environment:MicroStrategy 8 Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MSTR Narrowcast Server 8, Oracle 9i, Erwin, Data stage.

Confidential, Buffalo, NY
Sep 2007- Dec 2007
MicroStrategy Architect/Administrator

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Involved in Dimensional Modeling by selecting the business process, declaring the grain, and choosing the dimensions and facts.
• Generated reports to improve customer plans and for project placement analysis.
• Various reports were also developed to check promotion effectiveness, customer loyalty and customer lifetime value.
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Developed Schema Objects (Facts, Attributes, Hierarchies and Transformations) using MicroStrategy Architect.
• Delivered personalized reports from MicroStrategy project to subscribers using MicroStrategy Narrowcast Server.
• Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
• Worked with Microstrategy Distribution Services and Monitored systems usage.
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Installed Narrow cast server and assigned user, subscriber privileges and dynamic subscription.
• MicroStrategy IServer Tuning for performance.
• Created various event based Schedules.
• Installed, upgraded and managed MicroStrategy 7.x to 8.0 Intelligent and Web servers for development, test and production environments
• Performed basic stability testing of Intelligence server and updated projects.
• Performed system checks like licensing, functionality, managing user privileges of the system.
• Added new users to groups and assigning them security privileges.
• Deploying Flash Widgets on Servers and Uploading the New ones from Support site.

Environment: MicroStrategy Architect, MicroStrategy Desktop 8, MicroStrategy Web 8, Narrowcast Server, MicroStrategy Intelligence Server 8i, Oracle 10g/9i, Informatica Designer 8.1, Windows 2003 and UNIX.

Confidential, Hyderabad, India
Dec 03 to July '07
Data warehouse Developer

Responsibilities:

• InstallationSQL Server 2005 with the latest service packs.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Database capacity planning and space forecasting.
• Migrated Database fromSQL Server 2000 to 2005 by using side by side migration.
• Creating tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Actively worked on SQL XML and X-path queries.
• Wrote scripts to review object permissions in all databases.
• Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Extensively involved in designing theSSISpackages to export data of flat file source toSQL Serverdatabase.
• Designed, Build the Dimensions, cubes with star schema usingSQL ServerAnalysis Services (SSAS)
• Migrated DTS packages fromSQL Server 2000 to 2005 and scheduled their execution time.
• CreatedSSISpackages using Active X scripts and with Error Handling.
• Enhancing and deploying theSSISPackages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2005.

Environment: SQL server 2005/2000, Windows server 2003