SUMMARY:

• More than 7 years 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).
• Experience Data Profiling and creating insightful visualizations using Tableau and QlikView.
• MicroStrategy certified Project Designer, Report Developer, and Document Developer.
• Sound knowledge and experience in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.
• Good understanding of End to End BI/DW Development and Operations Life Cycle including ETL Design and Development .
• 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.
• Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, Performance Monitoring, Assigning Privileges and Job Monitoring.
• Created security roles, schedules, subscriptions, Users, and Groups with their desired privileges as per the requirements.
• 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.
• Experienced in implementing business logic using objects like tables, views, Cursors, complex stored procedures, roles, triggers and constraints using Data Definition Language (DDL) and Data Manipulation Language (DML) concepts.
• Extensive experience in writing SQL scripts to validate the database systems and for backend database testing.
• Experience rebranding the MicroStrategy app in Android and iOS environments using Mobile SDK.
• 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: MicroStrategy 9.x/10.x, QlikView 10.x/11.2, Tableau 9/10

Operating system: Windows Server 2008/12, Linux, Unix, Mac OS X

Programming languages: SQL, PL/SQL, C, C++

Data modeling: Erwin, MS VISIO, and TOAD

Databases: MS SQL Server 2008/12/16, Oracle 10, Teradata, MySQL

ETL: SSIS and Alteryx

Other: Microsoft Outlook

PROFESSIONAL EXPERIENCE:

Confidential, WASHINGTON, D.C

Sr. 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.
• 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.
• Create Drilling 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 Prod environments.
• 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 to deliver documents and dashboards to End users.

Confidential, WASHINGTON, D.C

MicroStrategy Admin / Developer

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 SSRS, OBIEE, WEB FOCUS reports to MicroStrategy reports
• 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.
• Extensively worked creating Visual Insights Dashboards in 9.4.1 and 10.2, 10.3
• 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, 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.
• Designed easy-to-use Prompts in customized UI by using Web SDK first got necessary report data which would be used to generate Prompt answers, then classified the Prompts and implemented each type with a separate Prompt UI.
• Obtained report and report-runs from MicroStrategy SDK History List by using Web SDK, and displayed them on user web page, implemented relevant functionality.
• 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 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 services.
• 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.

Confidential, OHIO

MicroStrategy Architect / ETL 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.
• Responsible for Administration, upgrade and support MicroStrategy Web, Office, and Intelligence Server and Narrowcast environments.
• 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.
• Involved in creation of Consolidation and Custom groups to group elements of attributes based on Filter conditions.
• Created Visual Insight Dashboards, dynamic Widget dashboards for Sales and Marketing to concentrate on Technology and Services and users on different technologies, Mobile Dashboards on Geographical Data and Voice Usage of the customers and leakage dashboards
• Developed Mobile Dashboards for business users, where Sales people can see the sell and no products that customers bought and their product purchase trend (forecasting).
• Created different kinds of documents using different controls, selectors, sliders, Links and widgets to view in different kinds of modes like DHTML, Flash mode. Worked on different document modes like design, editable mode and interactive modes.
• Worked Document Caches and Intelligent Cube reports to Improve Dashboard Performance.
• 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.1 Suggested 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.
• 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

BI Developer/ Database Analyst

Responsibilities:

• Involved in Analysis, Design, Development, Testing and Maintenance. Applied Normalization concepts in the new database design. Created Tables, Views, Stored Procedures, Triggers and generated DDL and DML scripts.
• Performance tuning of SQL queries, checking the most expensive queries using Explain Plan. Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links.
• Used hyperlinks in oracle reports to further drill down or to get the report output file in a different format.
• Experience in debugging and error handling using oracle defined exceptions and user defined exceptions. Documented business rules, functional and technical designs, test cases, and user guides.
• Implemented Data Mining in MicroStrategy by creating Training Metrics using various techniques like Time Series Analysis, Cluster Analysis, Regression etc. for sales and revenue forecasting.
• Implemented BCG Matrix (Boston Consulting Group Matrix) in MicroStrategy to find Relative Market Share Vs Growth using Interactive Bubble Chart Widget and Different Selectors.
• Designed and customized reports in development and production phases to supply the business with improved flexibility and functionality.
• Extensively used Narrowcast Server in various phases of Report generation namely Self-Subscription portal, Profile Management, Web, Proactive Information Delivery, Content Management and Personalization.
• Tuned reports performance using VLDB properties and Other Design Techniques.
• Created Database objects like views to improve performance of the reports. Created Free-Form SQL reports for short-term reports, ad-hoc requests that are not supported by existing schema model.
• Involved in Migration of MicroStrategy from Version 8.x to Version 9. Involved in Administration of Database, Data Warehouse and MicroStrategy.

Confidential

Database Developer / Test 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.
• Work closely with PMO, IT Developers, DBA and business to understand upcoming changes in order to complete no harm Regression Testing to existing critical production functionality.
• Log defects and Change request discovered/suggested through the Regression testing
• 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.
• Created complex stored procedure, views, triggers, table and other SQL joins. Maintained data integrity by performing validation checks.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database.
• Identified the database tables for defining queries to generate reports for analysis data using SSRS
• 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, Ad-hoc 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.