SUMMARY:

• Microstrategy Certified Developer (MCD) with over 8 years of professional experience in MicroStrategy Requirement Analysis, Data modeling and Design, MicroStrategy Architect, MicroStrategy Administration, MicroStrategy User configuration and management, MicroStrategy Analytics, MicroStrategy Development and Testing of reports, grids, graphs, dashboards, panels, panel stacks, Visual Analytics, Publishing MicroStrategy reports.
• Experienced in all phases of the System Development Life Cycle specializing in Business Intelligence, Data Warehousing, Data Architecture and Data Modeling.
• Participated in designing of Multidimensional Modeling in MicroStrategy, regulating Star and Snowflake Schemas.
• Experience with Data modeling using Erwin Studio for Dimensional Modeling (Star, Snowflake schemas).
• Strong experience in creating and integrating Micro Strategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data warehouse.
• Developed complex reports in MicroStrategy Desktop using features like templates, filters, prompts, consolidations and custom groups.
• Expert in creating custom dashboards in MicroStrategy Report Services to combine datasets from multiple sources.
• Extensively worked on various Pass - through functions like ApplySimple, ApplyAgg, ApplyComparison.
• Designed interactive and advanced visualizations of Dynamic Dashboards using MicroStrategy Report Services objects like Gauges, Dials, Widgets and Grid/Graph combinations.
• Performed multiple MicroStrategy upgrade for new versions and hot fixes, patches.
• Installed and configured Microstrategy Suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers. Also configured ODBC connections to databases in Microstrategy.
• Performed report troubleshooting, system optimization, performance monitoring and SQL tuning for various MicroStrategy implementations.
• Experience in MicroStrategy Object manager, Enterprise Manager, Integrity Manager and License Manager for administration and migration activities.
• Worked on MicroStrategy Administrator activities like creating Users, Security roles, Schedules, Subscriptions and writing Command Manager Scripts.
• Expertise in system administration in Windows and Linux environment for MicroStrategy system monitoring and restoration.
• Extensively worked on creating, publishing, scheduling and activating Intelligent cubes.
• Implemented proactive report delivery using MicroStrategy Narrowcast Server & Distribution Services to various devices like e-mail, file system & printers.
• Knowledge of SQL, PL/SQL, stored procedures, stored functions, packages, and triggers and worked on very large databases in DB2, Netezza 4x, Teradata, Oracle and SQL Server
• Expertise in modifying VLDB properties to improve the performance of reports generated.
• Extensively worked with business users on the UAT of MicroStrategy reports and data-marts.
• Configured Enterprise Manager and analyzed Enterprise Manager reports for better management of the MicroStrategy BI implementation.
• Exceptional analytical and problem solving skills. Good team player with the ability to communicate effectively at all levels of the implementation process to the management.

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy 10.x/9.x/8.x (Administrator, Architect, Intelligence Server, Desktop, Web, Distribution Services, Mobile

BI Tools: Tableau, Hadoop(HIVE)

Data Modeling: Erwin, Designer, Microsoft Visio

ETL Tools: Informatica (Power center, Power Mart), Data Stage, SSIS, Fast Loads.

RDBMS: Oracle, SQL Server, Sybase, MS Access, DB2, Teradata, Netezza

PROFESSIONAL EXPERIENCE:

MicroStrategy Architect.

Responsibilities:

• Designed and developed ACO and PV and reporting data model, data mining concepts, several grid, static and dynamic dashboard reports
• Created physical and logical tables to support Type-2 dimensions and Slowly-changing dimensions
• Developed detailed system specification documents for ACO and PV Programs
• Created MicroStrategy Schema objects, Application objects and Configuration objects like attributes, facts, prompts, metrics, filters, reports, dashboards, and Intelligent Cubes
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and filters for complex reports
• Used freeform SQL to create ad-hoc reports
• Created views on the warehouse tables and mapped them into MicroStrategy
• Created complex Metrics with advance qualifications involving the pass through functions like Applysimple and Applycomparison
• Develop MicroStrategy ad-hoc reports to give users flexibility to build aggregate reports
• Worked on creating dashboards using MicroStrategy Reporting Services and Visual Analytics (Visual Insight)
• Develop MicroStrategy grid reports with drilling capability to analyze data
• Designed and developed reports that will help to reach out to the healthcare providers to review detailed analytics on their claims and quality reporting
• Extensive use of dynamic dashboard and scorecard, MicroStrategy web (View, interactive, Editable and flash mode)
• Worked in optimizing SQL using VLDB properties like and Report Data Options to reduce the run time of the reports
• Created MicroStrategy Intelligent cubes against the warehouse tables to reduce the run time for reports
• Setup subscriptions and run subscriptions for reports created
• Enabled MicroStrategy Subscription feature to improve the performance and accessibility for users
• Performed the administration and maintenance tasks
• Led and supported the testing of MicroStrategy reports and coordinated Independent Validation & Verification (IV&V) processes with the customer and external stakeholders
• Tested all the reports by running independent queries against the warehouse. Also compared those queries with the MicroStrategy SQL engine generated queries
• Conducted data validation testing to ensure data quality
• Perform MicroStrategy demos with various stakeholders to identify their reporting needs
• Led the documentation team in preparing MicroStrategy System Design Documents, User Guide, which helped CMS users to use the BI reporting for their day-to-day needs
• Reviewed all development initiatives as per CMS standards
• Strong Knowledge in using best practices and best approaches in software development life cycle and utilization of data for best reporting methodologies
• Implemented a process change and revamped the strategy and architecture for a more robust QA and test strategy that included additions of white box testing, system integration testing, and performance and load testing strategies for tiered and end-to-end testing approaches and QA validation and audit methods
• Created Security Filters and limited the user access to a particular subject area
• Tuned VLDB properties and optimized SQL of long running reports which minimized the execution time from hours to minutes
• Proactively created report formats and delivered personalized messages from the Data warehouse through MicroStrategy Subscription Services to a wide range of users
• Worked with the Enterprise portal team in connecting MicroStrategy portals and MicroStrategy web
• Responsible for Production Support, supporting the users from different business groups
• Organized sessions for end users to train on how to create adhoc reports, exporting the reports to different formats and subscribing the reports to email via Distribution Services
• Identify LOE (Level of Effort) for each CR with detailed assumptions and overview of design implications
• Used SCRUM methodologies for agile development and participate in team-led solutions, reviewing peer's code for quality completeness.

Confidential

MicroStrategy Consultant

Responsibilities:

• Involved in installing, testing and Intelligence Server configuration for upgrading MicroStrategy reporting systems from MicroStrategy 8.1 to 9.2
• Coordinated directly with business users to gather new requirements and to resolve existing issues
• Analyzed requirements to identify gaps between technical design and requirements.
• Extensive use of dynamic dashboards and scorecards to innovatively report financial statements
• Developed Free-Form SQL reports to create reports that are not supported by existing schema model
• Created MicroStrategy Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop
• Created and implemented MicroStrategy reports by creating Custom Groups, Cubes, attributes, hierarchies, metrics, filters, and templates
• Extensively worked in developing Cubes, Reports, Metrics, Derived metrics, Compound metrics and Filters for complex reports
• Developed dashboards using edit links and external API’s
• Created various prompts to give end users a choice of different filtering criteria each time they run the report
• Worked with the portal team in connecting portals and MicroStrategy Web
• Extracted and analyzed data from the database using SQL to troubleshoot reports
• Used conditional formatting feature to project trends for product sales and to enhance grid and graphs in documents
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Created Dashboards for various business requirements using widgets like Micro Charts, Bubble Graph, and Heat Map
• Created Dashboards to personalize the reports as per user requirements, which involved using and editing several sets of individual grid reports
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report
• Created various types of reports like group by, ranking, fact comparison with past year, prompted report, consolidation reports
• Designed custom drill maps using drill map editor as required in the reports for drill through functionality
• Created Report Services documents using multiple Grids and Graphs
• Involved in tuning of VLDB properties to enhance performance of reports at project level as well as report level
• Interacted directly with users to help troubleshoot reports in web and increase greater report usability in the long run

Confidential, Kansas City, MO

MicroStrategy Consultant

Responsibilities:

• Analyzed existing systems and gathered requirements for business users, Reviewed and evaluated user needs
• Worked with source systems to understand data flow for MicroStrategy reports
• Gathered requirements from business users to build MicroStrategy attributes, metrics, filters and prompts
• Formulate metrics for enabling end users to generate customized reports
• Created MicroStrategy Schema objects, Application objects and Configuration objects like attributes, facts, prompts, metrics, filters, reports, dashboards, database instances and Intelligent Cubes
• Develop MicroStrategy grid reports with drilling capability to analyze data
• Created Reports using complex filters and compound metrics and prompts
• Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web
• Created various pass-through functions like apply simple, apply comparison and also case statements to support various business requirements
• Worked on creating dashboards using MicroStrategy Reporting Services and Visual Analytics (Visual Insight)
• Created various Monthly Dynamic Dashboard documents for decision makers with multiple panel stacks, selectors and customized widgets
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents
• Worked on Intelligent Cubes to provide performance for dashboards and reports
• Worked on the performance tuning of the MicroStrategy reports and dashboards using SQL optimization techniques
• Performed MicroStrategy administration and maintenance tasks
• Unit tested the reports and closely worked with QA team in developing test cases and scenarios
• Provided User support during project development & End user testing of reports
• Strong Knowledge in using best practices and best approaches in software development life cycle and utilization of data for best reporting methodologies
• Used MicroStrategy tools such Object Manager and Integrity Manager for migrating objects from across environments and performing regression testing on the reports
• Responsible for Production Support, supporting the users from different business groups
• Organized sessions for end users to train on how to create adhoc reports, exporting the reports to different formats and subscribing the reports to email via Distribution Services
• Work with Change Control Board (CCB) in identify Change requests (CR)
• Identify LOE (Level of Effort) for each CR with detailed assumptions and overview of design implications

Confidential

Saline MI QA/Tester

Responsibilities:

• Reviewed functional requirements and provided input on missing requirements as well as improved requirement clarification during requirement review meetings
• Gathered and analyzed data from files and researched to identify problems and resolve discrepancies.
• Participated in full SDLC of project and provided quality assurance testing for website applications.
• Tracked open issues and followed up to ensure timely processing of issues.
• Created and executed test cases and test scripts for different Medical devices that are used in the field currently.
• Executed test cases on various devices to validate the accuracy of the functionality of the software code built.
• Participated in various customer meeting for gathering inputs and functionality of the device to create plan for testing.

Environment: C, C++, Java, Windows 98/2000/XP/Vista/windows7