SUMMARY:

• Over 8years of IT industry experience in implementing all phases of the System Development Life Cycle(SDLC), including Design, Development, Administration, Testing, and Implementation of Business Intelligence and Data Warehousing applications.
• Strong experience in MicroStrategy tool Suite (Report development, Intelligence Server, Architect, Desktop, Web, Mobile, and Narrowcast Server).
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Extensively worked on MicroStrategy Administration that includes Intelligence Server administration, configuration, and Performance tuning and Enterprise management.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, and Prompts,Templates, Consolidation and Custom Groups ) with the data warehouse.
• Hands on working Experience with MicroStrategy 10.X/9.x/8.x, MicroStrategy Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect.
• Involved in training Business Users on MicroStrategy OLAP Services and MicroStrategy Web (such as view filter, derived metrics etc.)
• System Optimization, performance monitoring and tuning experience in MicroStrategy environment.
• Hands on experience in Advanced MicroStrategy Reporting techniques such as InteractiveDashboards and Visualization techniques.
• Expertise in Analysis of business requirements and defining the top - level design and interfaces.
• Experienced in using MicroStrategy Object Manager to migrate the objects between Development, UAT and Production servers.
• Used MicroStrategy Command Manager to run the automated scripts.
• Exposure to ETL methodology for supporting Data Extraction, Transformations and Loading processing.
• Created variety of dashboards including Operational Analysis, Offer & Campaign Analysis, Sales Analysis, Executive Summary, Financial Summary & KPI Dashboards.
• Worked on UI customizations using web SDK.
• Rebranding the MicroStrategy app in Android and IOS environment using Mobile SDK.
• Hands on Experience in MicroStrategy Narrowcast Server & Distribution Services for delivering reports.
• Proficient with different data base systems like SQL Server, Teradata, Oracle, Netezza, PostgreSQL and DB2.
• Experienced in maintaining and creating database objects like tables, views, indexes, sequences, synonyms etc.
• Experienced in development of stored and application procedures, packages, database triggers and functions.
• Strong knowledge of Agile methodology including Sprint Review, Daily Standup, Sprint Plan, User Story Points and Code Review meetings.
• Self-motivated, dedicated and team player with excellent communication skills and curiosity to learn new technologies and can work with minimal supervision. At ease in interacting with people at all levels, able to work under pressure.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy9.x/10.x, QlikView

Database: Oracle, Teradata, MS SQL Server, Netezza and MySQL

Data Modeling: MS VISIOand TOAD

Programming Language: SQL, Unix shell scripting, C, C++

Operating System: Windows, Linux, Unix, Mac OS X

Other: Microsoft Outlook, QTP

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

MicroStrategy Consultant

Responsibilities:

• Analyzed the business model to understand the existing systems and business requirements.
• Communicated with the users, architects and business analysts to understand the requirements of dynamic dashboards and reports.
• Worked extensively in creating MicroStrategy Application Objects such as Compound Metrics, Level Metrics, complex Filters, Custom Groups, Consolidations, and nested Prompts.
• Created and modified attributes, facts, hierarchies and transformation objects as part of the development work for a project.Employed various schema modeling techniques like compound attributes, heterogeneous mapping, role attributes by aliasing the tables and other techniques.
• Ensured proper relationships were established between the attributes to avoid any improper SQL query joins.
• Ensured that the logical sizes of the tables were properly set to facilitate the selection of the right tables by SQL engine for a given query.
• Created Logical views in MicroStrategy for complex report creation scenarios.Used free form SQL editor for complex report creation.
• Used Pass through Functions like Apply Simple & Apply Comparison to meet the report requirements wherever necessary.
• Worked on performancetuning of reports, Dashboards and score cards. Configured Enterprise Manger and developed customized reports to depict the usage and Performance of reports, User activity and Cache analysis.
• Created Metrics, Prompts, Filters, and Custom Groups for the report development.
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.
• CreatedDrill paths and implemented those into reports so that user can Drill across different System and User hierarchies.
• Worked with MicroStrategy Object Manager to move objects among the Development, Test, and Prodenvironments.
• Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date). Extensively used Distribution Services of MicroStrategy 9 to deliver documents and dashboards to End users.

Confidential, Columbus, OH

MicroStrategy Admin/ Developer

Responsibilities:

• Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in Netezza environment.
• Extensively worked with MicroStrategy desktop in creating attributes, facts, metrics, hierarchies, transformations, hierarchies, custom groups, prompts to be used in generating reports according to the needs of business.
• Designed various kinds of reports like scorecards, dashboards, Operational reports and ADHOC reports. Developed complex SQL queries and involved in setting up VLDB properties for performance.
• Created dashboards in Interactive/Flash Mode by using multiple Panels, Selectors and dynamically passed multiple values from the selectors to the reports linked in Dashboard.
• Used Pass through Functions like Apply Simple & Apply Comparison to meet the report requirements wherever necessary.
• Involved in Offshore coordination, attend daily status meetings with offshore team. Very Strong Experience in MicroStrategy Report Services, Experience in developing Dashboard & Mobile Reports.Developed MicroStrategy Dynamic Dashboards in various modes and also worked extensively on widgets.
• Created Metadata Repository and Statistical tables, Configured Intelligence Server and upgraded projects using the Configuration Wizard.
• Worked on performancetuning of reports, Dashboards and score cards. Configured Enterprise Manger and developed customized reports to depict the usage and Performance of reports, User activity and Cache analysis. Created Metrics, Prompts, Filters, and Custom Groups for the report development.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting. Extracted and analyzed data from the database using SQL to troubleshoot reports as needed using MicroStrategy ODBC Test tools.
• Extensively used Report Services to generate Documents for exporting to Excel & PDF.Worked in Agile methodology including Sprint Review, Daily Standup, Sprint Plan and Code Review meetings.
• Created Intelligent Cubes to improve performance.
• Used Distribution Services for timely distribution of reports to users.Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, and access control lists.

Confidential, Raleigh, NC

MicroStrategy Developer

Responsibilities:

• Responsible for converting business specifications into technical specifications.Developed, Maintained, Enhanced, tested and leveraged the enterprise Reports based on clients’ needs.
• Designed and developed advanced grid reports, documents, Web & Mobile dashboard Applications for different clients.
• Created Dynamic Web, Mobile & Visual Insights Dashboards using features like Panel Stacks, Selectors, Information Windows and Widgets like Time Series Slider, Interactive Bubble Chart, Thermometer, ESRI Map, Data Cloud, Heat Map etc.
• Created Dynamic Dashboards showing Daily/Weekly/Monthly/Yearly performance metrics using various graphs and widgets. Created and modified MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, database instances, users, user groups, security role etc.) using MicroStrategy Developer and/or Web.
• Created complex metrics involving MTD/YTD Transformations and Level Dimensionality. Troubleshooting MicroStrategy objects like Attributes, Facts, Transformations, Metrics, Prompts, Filters, Templates, Consolidations, and Custom Group.
• Used the VLDB properties for performance tuning and SQL optimization.Created Free-Form SQL reports for short-term reports, ad-hoc requests that are not supported by existing schema model.
• Responsible for providing on time deliverable solutions to clients. Installed and configured all of MicroStrategy products including Intelligence Server, MicroStrategy Desktop, Object Manager, Command Manager, Web and MicroStrategy Narrowcast on Servers and mapping to Client machines.
• Configured Enterprise Manager 9.4.1Suggested Database Schematic Changes to Database Administrators to improve MicroStrategy repots performance.
• Created Ad-hoc reports by gathering specific requirements from the different users. Extensively involved in troubleshooting support and resolving all outstanding issues.
• Efficiently handle and Manage production support activities through Incident Management. Troubleshoot and tune MicroStrategy reports by analyzing the generated SQL to determine data issues such as double counting, hitting incorrect fact tables, joins and insufficient data.
• Unit tested report layouts, validated the SQL query, prompt ordering & defaults, security filters, export/print functionality and drilling options.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.
• Played a key role in User Acceptance Testing of the reports.Tested all the reports by running queries against the warehouse-using SQL Assistant.

Confidential

SQL Developer/ Testing Engineer

Responsibilities:

• Involved in meetings with the client to deliver an efficient system.
• Involved in Analysis, Design, Development, Testing and Maintenance.
• Applied Normalization concepts in the new database design.
• Created the Tables, Views, Stored Procedures, Triggers and generated DDL and DML scripts.
• Performance tuning of SQL queries, checking the most expensive queries using Explain Plan.
• Actively Involved to create SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Functions, User Defined Data-Types, Rules, And Defaults
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Actively involved in Understanding the requirement and identifying all possible scenarios in Test cases development.
• Participated in Smoke Testing, Functional Testing, Integration Testing, System Testing, Acceptance Testing, Adhoc Testing and Regression testing.
• Execution of manual test cases.
• Involved in identifying and prioritizing the Test Cases to be automated.
• Participated in Daily Stand Up Meeting and Sprint Retrospect Meetings.
• Hands on experience in HP QC for Defect Tracking.
• Responsible for Preparing Daily Status Reports.