SUMMARY

• Over 6.0 years of professional experience in Software Development Life Cycle (SDLC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• Strong experience using MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, MDX Adapter/Office, OLAP Provider, Web, Report Services, Narrowcast Server, Administration), Intelligence Cube.
• Efficiently provided Business Intelligence Solution using MicroStrategy suite which includes MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Web, MicroStrategy Desktop etc.
• Hands on experience using MicroStrategy tools like MicroStrategy Architect, and MicroStrategy Administrator, Command Manger, Object Manger, Integrity Manager etc.
• Used MicroStrategy tools like Object Manager and Project merge to compare projects and migrate the objects/projects between two Environments.
• Created and modified MicroStrategy Schema objects (such as Attributes, Facts, hierarchies etc.), Public Objects (such as Reports, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc) and Configuration Objects (such as project, user, security filter etc.) using MicroStrategy desktop.
• Extensively created MicroStrategy Dashboards & Score Cards which includes features of Adobe Flash version like Radio Buttons, Fish Eye, Slider, Widgets and selectors.
• Specialized in designing Report Service Documents with multiple datasets.
• Knowledge on E/R Modeling, Logical Data Modeling and Data Warehousing concepts.
• Strong in developing Proactive Delivery Reports and implementing business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Experience in development of business use cases, business plans, project plans, streamlining operations and developing training modules.
• Implemented features like Integrated Query reporting and powerful iterative analysis were provided to the end users through MicroStrategy Desktop and Web.
• Expertise in Creating Dashboard applications and Scoreboard.
• System Optimization, performance monitoring and tuning experience in MicroStrategy Business Intelligence environment using MicroStrategy Enterprise Manager.
• Experience in Performance tuning of reports using SQL hints, VLDB properties in MicroStrategy.
• Good experience in Performance tuning of reports directly on the database by creating Indexes on the specific columns in database and creating partition tables to retrieve data faster from the database.
• Good experience in debugging SQL Code.
• Good experience in bug resolutions.
• Hands on experience in WYSIWYG reports.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Excellent Analytical, communication, decision - making and interpersonal skills with result oriented dedication towards goals.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.

TECHNICAL SKILLS

DSS/BI Tools: MicroStrategy 9.2.1/9.0/9.0.1/8.1. x/7.5/7i/7.x (Administrator, Agent, Web Architect, Narrowcast, Report services); Cognos, Business Objects 5.0/4.1

Databases: Sybase IQ, Netezza NPS 4.6.2, Oracle 10g, 9i/8.0/7.x, Teradata V2R6/V2R5, MSSQL Server 2000 & 2005, MS Access 7.0

Applications: Microsoft Office Suites 98-2007 and Office XP Suite (MS Word, Outlook, Excel, PowerPoint, Visio)

Programming: SQL, PL/SQL, SQL Plus, UNIX Shell Scripting, XML, C, C++

Operating Systems: Windows 95/98/00/NT/XP, UNIX, Linux (RHEL 4.1/3.1), IBM AIX 4.2/4.3

Project Documentation: Business Requirement Document, Functional Requirement Document, Business Process Flow, Analyze Documents, Design Documents, Test Cases Document &Project Performance Reports

PROFESSIONAL EXPERIENCEConfidential, AZ

MicroStrategy Developer/Architect

Responsibilities:

• Gathered and analyzed business requirements from clients and end users. Worked promptly in getting functional specs sign off.
• Experience in developing mock ups and prototypes of reports.
• Responsible for developing reports to satisfy the business requirements..
• Worked closely with power users in MicroStrategy to help resolve their data needs and reporting needs.
• Responsible for monitoring the reports through subscriptions and maintenance of daily schedules dependent on subscriptions.
• Worked closely with data modeling and ETL teams to develop the data model.
• Used Microstratgey Desktop to build Schema objects, Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Involved in creating Document from multiple Datasets likeMap Application Diagram, Grid and graph.
• Worked on Performance tuning of reports directly on the database by creating Indexes on the specific columns in database and creating partition tables to retrieve data faster from the database
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Created Transformations for using in comparative reports like revenue this year to last year.
• Used Quality Center to perform Unit testing & SIT of the reports.
• Created interactive dashboards using the selectors like radio buttons, check boxes, panels, slider, button bar etc.
• Good experience in bug resolutions.
• Worked extensively on customizing and optimizing the query performance of reports for various users using MicroStrategy features like VLDB property and changing database properties like adding indexes, creating aggregate tables and partition strategies.
• Scheduled reports through the Microstratgey Distribution services to deliver a wide range of personalized information to users through email.
• Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Developed reports for Microstratgey Web users.
• Trained users on usage of Microstratgey web platform and also running a few adhoc reports.

Environment: MicroStrategy 9.2.1 HF3 (Architect, Desktop), Windows 2003, Sybase IQ, Informatica, SharePoint, Erwin.

Confidential, NE

MicroStrategy Developer/Architect

Responsibilities:

• Participated in Business requirements meetings to gather the data requirements for the project.
• Based on the requirements, designed staging databases for POLICY, CLAIMS and BILLINGS systems depending on the Source systems.
• Created Project Plan for the Project covering all aspects of the life cycle.
• Created Business Requirement documents and Technical specification documents for all the operational systems.
• Designed and created dimensional and fact tables required for the MSTR reporting according to the reporting requirements.
• Experience in developing mock ups and prototypes of reports
• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Created User Access Review Reports across the application to ensure the security of the application.
• Created views in database and Logical tables in Microstrategy to reduce the no of passes in SQL.
• Extensively used Netezza database analytical functions like running sum, lead & lag to create reports necessary for the business.
• Developed the UAT Plan for the BI- Reporting system.
• Provided User support for the entire group of reports involved in the project.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Tested all the reports by running queries against the warehouse-using DB Visualizer. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Reduced the run time for the reports by monitoring the VLDB properties like star join, query and sub query optimizations for Netezza and SQL hints.
• Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis for CASH CONTROL Reports.
• Designed Dashboards in 9.0 summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents. These were especially useful for the client in making critical decisions.
• Created complex metrics with levels of dimensionality based on the business rules.
• Used features like Hyperlinks, drilling and advanced metric calculations in creating reports with dynamic Dash boarding using MSTR 9.0.
• Extensively used the latest version of flash 9.0 Dash boarding to provide Report services.
• Clear understanding of procedures for grouping and sorting records in a MicroStrategy report services documents.
• Used advanced properties of report services like creating hyperlinks, drilling, using datasets, advanced metric calculation and so on.

Environment: MicroStrategy 9.0.1/9.0.2 (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MDX Adapter), Netezza NPS 4.6.2, Talend 4.0, Informatica 8.6, Erwin, Quality Center

Confidential, CA

MicroStrategy Developer/Architect

Responsibilities:

• Participated in Business requirements meetings to gather the Microstrategy requirements for the project.
• Created Project Plan for the Project covering all aspects of the life cycle.
• Designed and created dimensional and fact tables required for the MSTR reporting in DWH.
• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Created User guide for the whole project which includes the total no of reports, how to run reports and answer prompts.
• Provided User support for the entire group of reports involved in the project.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Tested all the reports by running queries against the warehouse-using PL/SQL developer. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Reduced the run time for the reports by monitoring the VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Redesigned the DATA MODEL from star schema to snow flake schema using ERWIN Technology.
• Designed Dashboards in 9.0 summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents. These were especially useful for the client in making critical decisions.
• Created interactive dashboards using the new selectors in 9.0 like radio buttons, check boxes, panels, slider, button bar etc.
• Created simple and complex metrics based on the business rule calculation.
• Used features like Hyperlinks, drilling and advanced metric calculations in creating reports with dynamic Dash boarding using MSTR 9.0.
• Extensively used the latest version of flash 9.0 Dash boarding to provide Report services.
• Extensively used Report services for creating dashboards.

Environment: MicroStrategy 9.0 (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Windows 2003, SQL Server 2005, Informatica, SharePoint, Erwin.

Confidential, NJ

MicroStratgey Developer

Responsibilities:

• Designed and Developed Customized Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Used the Microsoft windows performance monitors to supplement Administration monitors in MicroStrategy intelligence server.
• Created the default startup mode for MicroStrategy intelligent server, listed and defined the multiple methods for manually starting and stopping MicroStrategy Intelligent server.
• Designed, Developed and altered html Document objects placing multiple reports on it in Grid as well as Graph View applying XSL and XML formatting for each in the process of automating IT Dashboard reports.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Reduced the run time for the reports by monitoring the VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Configured MicroStrategy logins with LDAP accounts.
• Played a key role in User Acceptance Testing of the reports.
• Used MicroStrategy Narrowcast Server to monitor the business data and alert the users to unexpected exceptions and trends.
• Designed Dashboards in 8.1.1 summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents. These were especially useful for the client in making critical decisions.
• Created interactive dashboards using the new selectors in 8.1.1 like radio buttons, check boxes, panels, slider, button bar etc.
• Clearly understanding the procedures for grouping and sorting records in a MicroStrategy report service documents.
• Used features like Hyperlinks, drilling and advanced metric calculations in creating reports with dynamic Dash boarding using MSTR 8.1.1
• Extensively used the latest version of flash 8.1.1 Dash boarding to provide Report services.
• Extensively used Report services for creating dashboards.

Environment: MicroStratgey 8.1.2/9.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter), Oracle 10g, TOAD 9.5, Informatica 8.1.1, XSL, HTML, ERWIN, Visio.

Confidential, NJ

Microstratgey Developer

Responsibilities:

• Involved in the business interaction with the users and gathered the reports that needed to be exist in the Project.
• Involved in Database meetings and also worked closely with business users in framing the Scope Document.
• Responsible for testing the reports by writing down SQL queries.
• Created ETL technical Specification documents which are used for developing Data warehouse Schema.
• Created the technical specification for the reports for the user acceptance.
• Used MicroStrategy Architect to create Facts, Attributes, Relationships and Hierarchies.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Used MicroStrategy Web to generate Advanced Reports.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Worked on the performance tuning of the MicroStrategy reports.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Hands on experience on designing and developing dashboards and score cards using the version 8.1.1.
• Created Report Service Documents for HR and Finance Projects using Adobe Flash introduced in the latest MicroStrategy version 8.1.1.
• Created custom dash boarding using widgets like time series sliders in 8.1.1 Abode Flash version.
• Created dash boards which evaluates and compares data for Current and Prior months, quarters, years and made available in Interactive mode, Flash mode and PDF mode.
• Got appreciations from Business users for creating Dashboards looks and feel like their sample reports.
• Worked extensively on dynamic dashboards and scorecards using Report Services with illustrative pie-charts and graphs for different Business requirements.
• Used MicroStrategy Administrator for accurate information regarding system usage and performance.
• Designed database schemas for OLAP warehouse databases.
• Created/enhanced catalogs and set user profiles to grant user permissions for querying.
• Validated end user report requests using SQL and MicroStrategy tools.

Environment: MicroStrategy 8.1.1 Administrator, Desktop, Architect, Web, Intelligence Server, Administrator, Object Manager, Narrowcast Sever, Informatica 8.1.1, Oracle 9i, DB2, Access

Confidential, NJ

MicroStrategy Developer

Responsibilities:

• Involved in Gathering Business Requirements from users by understanding the Source System (OLTP) and Interacting with the users.
• Involved in and provided solutions for complex Time Dimension related issues and analysis.
• Involved in Data Modeling and Data Warehousing Using Multi Dimensional Model, Star and Snow Flake Schemas.
• Worked with the source systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements.
• Created the requirements Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment.
• ETL plans and data validation, Developing and executing SQL scripts to test data between source and target.
• Generated and implemented Microstrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Created Reports using complex Filters and Compound Metrics and Prompts.
• Enabled MicroStrategy User accounts with client’s LDAP authentication.
• Used Advanced Prompts, Non-Aggregatable Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Played a key role in User Acceptance Testing of the reports.
• Involved in troubleshooting Microstrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Involved in troubleshooting all the administrative tasks like report scheduling, setting up MSTR projects and working on access issues.
• Created dashboards using 8.1.1 version.
• Extensively used Sliders, widgets and radio buttons in 8.1.1 Dashboards.
• Extensively used Narrowcast Server for personalized Report distribution.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations.

Environment: MicroStrategy 8.0.3/ 8.1.0/8.1.1 (Architect, Intelligent Server, Web, Narrowcast Server, Desktop), Teradata, Informatica 8.1

Confidential, TX

DWH/BI Consultant

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Created the Technical Specification Documents for the reports for the acceptance.
• Created Dashboard and Scoreboard reports.
• Created complex metrics with different level dimensionality, condition and transformations for user and business specific reporting needs.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for Business analysis.
• Participate in daily status and monthly planning meetings.
• Duplicate Projects, Merge Projects and Users, Execute and Create scripts to various administrative tasks by using command manager, Object manager, Project Merge and User Merge wizard.
• Monitor Server Usage by Enterprise Manager.
• Performance tuning MicroStrategy Intelligence server depending on the workload.
• Performance tuning of SQL for long running reports.
• Highly used XML formatting to create advanced Score Cards.
• Migration of Narrowcast server objects from development to production.
• Create users in Microstrategy and grant required access for projects.
• 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.
• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Developed Freeform SQL Reports, Standard reports and Dashboard reports.
• Used report services for various banded report to satisfy the printing requirements of the user.
• Performing QA and production migrations of MicroStrategy objects between development, maintenance and production environments using Object Manager and Project Duplication process.

Environment: MicroStrategy 8.0.3 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Teradata V2R5, Oracle 9i, TOAD 7.2, Informatica, IBM DB2, XSL, HTML

Confidential

Report Developer/Analyst

Responsibilities:

• Designed, developed and managed a supply-chain data warehouse and DS System implemented on MicroStrategy intelligence Server/Web and DB2.
• Developed a 3-tier client/server product in the corporation for use by the merchandising department to access a relational Oracle database in a multidimensional way (ROLAP) using MicroStrategy’s DSS tool suite of products in a heterogeneous networked environment.
• Used Microstrategy Narrowcast Server to provide self-subscription capabilities and to deliver personalized content to the subscribers. Involved in installation and configuration of the Narrowcast Server and perform various tasks to have the subscription and other features to work.
• Re-engineered a hierarchical merchant planning system Confidential the corporate level to implement the project.
• Used the functional document to design application logical and the physical design using PL/SQL.
• Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
• Heavily involved in the development methodology, database design, data modeling, audit and process control including feeder systems, stage, fact and dimension tables.
• Responsible for data integration/migration from various legacy systems into a Data Warehouse environment.

Environment: MicroStrategy 8.0 DSS tool suite, Oracle 8/8i, DB2 UDB, IBM AIX, Windows NT/2000, Data stage XE, Erwin 4.0, MicroStrategy Narrowcast Server 7.1