SUMMARY:

• Over 7 years of IT experience, leveraging expertise in Data Warehousing, Data Modeling, ETL and BI (MicroStrategy) tools.
• Strong experience with full Software Development Life Cycle(SDLC) which includes Requirement Analysis, Design, Development, Implementation, Testing, Deployment, production Support and Maintenance, Built and Release management.
• Expertise in using MicroStrategy product suite which includes MicroStrategy Intelligence Server, MicroStrategy Desktop/Developer, Narrowcast Server, MicroStrategy Architect, Administrator, MicroStrategy Office, Web, Visual Insight, MicroStrategy Object Manager
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, Adhoc reports)
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments
• Used MicroStrategy Command Manager to run the automated scripts.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets)
• In depth technical background working with Databases like Oracle, SQL Server, Sybase, DB2
• Experience in Data modeling techniques like star and snowflake schemas using Erwin tool.
• Experience in Converting Legacy reports into MicroStrategy reports and working in offshore - onsite environment.
• Worked with Logical and physical modeling along with design and implementation.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Experience in coordinating with Database Management team, End users, Business Analysts in understanding their requirements, assisting and providing technical solution and knowledge.
• Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10.3/10.4/9. x/8.1.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight,, Narrowcast Server, Mobile, Integrity Manager, OLAP), Cognos 10 (Report Studio, Workspace Advanced)

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Databases: Oracle 11g/10g/9i, Teradata 13.x/V2R6, MS SQL Server, Sybase, Netezza

Programming: T SQL, PL/SQL, SQL Loader, SQL Plus, TSQL, C, C++, HTML

Operating Systems: Windows Servers, UNIX (Solaris, Linux)

Other Tools: Toad, SQL Assistant, PL/SQL Developer, MS Office, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

MicroStrategy Consultant

Responsibilities:

• Involved in gathering Business Requirements from users by understanding the Source System (OLTP) and Interacting with the users.
• Involved in the Data modeling for Business Process Specific Data Mart.
• Extensively worked in migrating WEB FOCUS reports to MicroStrategy reports
• Involved in software upgrade of MicroStrategy 10.1 to 10.9 platform
• Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise in development phase.
• Possesses excellent communication, documentation and organization skills with the ability to adapt to a new environment & meet stringent deadlines.
• Created subscriptions to email reports to various groups and individuals
• Served as a liaison between the development & business requirements teams and between development and QA teams.
• Created ad-hoc reports in grid and graph mode consisting of data analysis by combining a template with filters using MicroStrategy Desktop and web. And also created reports using complex Filters, Compound Metrics and Advanced Prompts.
• Created transformations (Table Based and Formula Based) for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Developed different Dynamic Dashboards and Scorecards and using MicroStrategy best practices as recommended by visual design experts, using selectors, widgets and multi-panels.
• Used Non-Aggregable Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Used Pass through functions and free form SQL editor to meet the requirements for complex reports.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Worked extensively and interacted with end users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Extensively used Narrowcast Server for Report distribution.
• Tested all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Supported business users with technical requirements and issues with tool.

Environment:: MicroStrategy 9.3/9.0/10.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata V2R6, Oracle 10g/11g, MS Office, XSL, HTML, Windows.

Confidential, louis MO

MicroStrategy Consultant

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets
• Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
• Used MicroStrategy Command Manager to create scripts for creating users, groups, setting user options and authentication modes, clearing caches, dropping connections, generating user lists etc
• Used MicroStrategy Distribution Manager, Narrowcast Server for automation of reports
• Worked with Database teams to create the database tables, materialized views required for reporting
• Involved in UAT Testing to validate the data using SQL queries against the data warehouse.
• Widely used VLDB properties at project level and also at individual report levels to overcome performance issues
• Used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects
• Involved in production support (24/7)
• Maintained a stable platform by proactively identifying and resolving any issues or bugs.

Environment:: MicroStrategy 10.3/10.0(Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Confidential, Warren, NJ

MicroStrategy Consultant

Responsibilities:

• Involved in the complete Life cycle of the Project
• Responsible for development and management of projects with primary focus on providing robust and scalable Business Intelligence solutions to various functions within company
• Worked closely with various business functions to find opportunities to build new business enhancing reports and to automate existing labor and time intensive critical reports.
• Designed and developed Dynamic Dashboards using various selectors and widgets
• Involved in duplicating the projects and configuring with new database instance. Created many small projects by setting up metadata layer and configuring the MicroStrategy Intelligence server
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator
• Designed Freeform SQL reports by directly querying against the data warehouse
• Extensively worked in both Ad-hoc and Standard Reporting Environments and involved in creating reports scalable to large volumes of data. Managed projects through entire Systems Development Life Cycle
• Created Complex filters, prompts, and metrics with advanced qualifications involving Apply Simple & Apply Comparison functions. Created smart metrics with custom subtotals
• Created MicroStrategy logical views wherever required as per reporting needs. Created user Hierarchies for Drill Maps
• Created Database tables and logical views required for MicroStrategy reporting needs.
• Responsible for Unit Testing of the reports
• Involved in migrating the objects from DEV to UAT/Prod using the Object Manager.
• Involved in software upgrade of MicroStrategy platform.

Environment:: MicroStrategy 9.5.1/9.4 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Confidential, Seattle, WA

MicroStrategy Consultant

Responsibilities:

• Worked with end users to gather requirements and prepared technical specification Documents.
• Understanding the reporting requirements and developed the reports and redesigned the legacy reports in MicroStrategy
• Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis
• Developed MicroStrategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Project objects like Subtotals
• Designed Reports, Documents and Dashboards using Desktop
• Created 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.
• Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, Totals, Outline Mode based upon the business user change request during UAT Testing.
• Validated end user report requests using SQL queries and MicroStrategy tools.
• Using Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in optimization of code and tuning queries for performance.
• Production Support has been provided for ongoing issues.

Environment:: MicroStrategy 9.4.1/9.3 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Confidential, Lincoln, RI

MicroStrategy Consultant

Responsibilities:

• Involved in gathering Business Requirements from users by understanding the Source System (OLTP) and Interacting with the users.
• Involved in the Data modeling for Business Process specific Data Mart.
• Created ad-hoc reports in grid and graph mode consisting of data analysis by combining a template with filters using MicroStrategy Desktop and web. And also created reports using complex Filters, Compound Metrics and Advanced Prompts.
• Created transformations (Table Based and Formula Based) for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Developed different Dynamic Dashboards and Scorecards and using MicroStrategy best practices as recommended by visual design experts, using selectors, widgets and multi-panels.
• Used Non-Aggregable Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Used Pass through functions and free form SQL editor to meet the requirements for complex reports.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Worked extensively and interacted with end users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Extensively used Narrowcast Server for Report distribution.
• Tested all the reports by running queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Supported business users with technical requirements and issues with tool.

Environment:: MicroStrategy 9.3/9.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata V2R6, Oracle 10g/11g, MS Office, XSL, HTML, Windows.

Confidential,

MicroStrategy Developer

Responsibilities:

• Started with gathering requirements from the users and documenting the specifications
• Created the Report Specification document and had it signed of, after suggesting some useful alterations
• Analyzed the source system data
• 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
• Created Complex Metrics forcing Dimensionality and Conditionality which are mainly used in Client scorecards, summary, detail level reports and trending related reports
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters
• Created Complex filters with advanced qualifications involving the ‘Apply’ functions
• Used MicroStrategy Narrowcast Server to monitor the business data and alert the users to unexpected exceptions and trends
• Created Report Service documents with both Grids and graphs as per user requirements
• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing
• 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 time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints
• Played a key role in User Acceptance Testing of the reports.

Environment: MicroStrategy 8.x.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Linux, Windows Server, SQL server, Oracle.