SUMMARY:

• Strong experience in MicroStrategy design, development of multi - tier client/server applications and Web applications. Skills include expertise with Business Intelligence (MicroStrategy) implementation and development, Web development, Relational database management systems, data modeling and Microsoft Technologies.core competencies
• MicroStrategy Administration MicroStrategy Installation MicroStrategy Development MicroStrategy Command Manger/Integrity Manager MicroStrategy Dashboards MicroStrategy Visual Insight Mobile BI Data Analysis/ Visualization Data Modeling ERWIN Gap Analysis
• Agile and Waterfall Methodologies Resource Management Change Management
• Time Estimation Task Identification Scope Management Stakeholder Communication Business Systems Functionality and Technicality Business Process Improvement Fluent SQL Business Process Re-engineering Sharepoint Quality Center SQL Server Oracle Requirements Gathering Data Modeling Production Support Performance Tuning Business Intelligence Best Practices

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy 10/9.4.1 (Administrator, Architect, Intelligence Server, Desktop, Narrowcast)

RDBMS: SQL Server 2008/2012, MS Access, DB2

Languages: SQL

Statistics: SPSS, SAS

PROFESSIONAL EXPERIENCE:

Confidential

MicroStrategy Consultant and Requirements Analyst

Responsibilities:

• Analyzed and gathered business requirements from business and technical teams.
• Made a complete end-to-end assessment of an existing MicroStrategy Project and designed long term plan to convert project for new database and SQL Server.
• Assisted ETL team with the design and troubleshooting of reporting database tables, including testing and editing of stored procedures for derived tables.
• Repointed existing MicroStrategy project from existing database on decommissioned server, to new server with a SQL server database.
• Updated project schema and all schema objects.
• Recreated filters, reports and dashboards according to the new database structure and new reporting requirements.
• Extensive MicroStrategy administration work maintaining and implementing project settings, ACLS, permissions and managed MicroStrategy user list.
• Managed migration of objects from old project to new project.
• Identified LOE (Level of Effort) for business requirements and created development schedules.
• Essential involvement with User Acceptance Testing of the reports & dashboards - participated in one - on-one calls and meeting with business user to plan, support and explain reporting activities, development and functionality.
• Performed extensive data quality/integrity research to identity and rectify existing and potential issues
• Performed production support responding to user issues and updating item status with issue tracking software.

Confidential

Responsibilities:

• Identified LOE (Level of Effort) for business requirements and created development schedules.
• Analyzed and gathered business requirements from business and technical teams.
• Extensive knowledge on MicroStrategy Desktop, Administrator, Intelligence Server, and Web.
• Designed complex Reports in MicroStrategy Desktop and MicroStrategy Web using Templates, Filters, Prompts, Consolidations and Custom Groups.
• Perform MicroStrategy demos with various stakeholders to identify their reporting needs
• Create attributes, advanced metrics, filters, grid reports for business users
• Develop Intelligent Cubes for report performance and ad-hoc reporting
• Optimize SQL for faster retrieval of data
• Worked with business and technical team members to develop concise and flexible dashboards.
• Analyzed and parsed data for appropriate use in mobile dashboards
• Point of Contact for all mobile reporting
• Responsible for testing and evaluating mobile devices for MicroStrategy Applications and reporting.
• Essential involvement with User Acceptance Testing of the reports & dashboards - participated in one - on-one calls and meeting with business user to plan, support and explain reporting activities, development and functionality.
• Developed icons and images to be deployed in mobile dashboards
• Performed extensive data quality/integrity research to identity and rectify existing and potential issues

Confidential

Responsibilities:

• Analyzed and gathered reporting requirements for Quarterly and interim release.
• Worked closely with business users to implement and support a wide variety of reporting solutions.
• Organized and administered object migrations across environments from development to production.
• Completed reporting requirements analysis to meet business needs
• Installation of MicroStrategy platform for reporting
• Development of Data model, Schema Objects and design for Application objects in MicroStrategy
• Full lifecycle development of MicroStrategy reports grids, dashboards
• Performed MicroStrategy project duplication and Object Migration to maintain multiple environments
• Created MicroStrategy user groups and Security roles with appropriate privileges
• Point of contact for all MicroStrategy Reporting questions
• Performed unit and regression testing of code; managed and prioritized defects
• Design Reporting tables in NLR for Registration, Attestation & Payment information
• Develop Standard and Operational reports on HITECH program performance
• Develop ad-hoc reports to give users flexibility to build aggregate reports
• Develop grid reports with drilling capability to analyze data
• Develop reports for Help Desk Reporting for EHR Incentive Program
• Work with CMS stakeholders on creating mockups and finalizing requirements
• Perform MicroStrategy demos with various stakeholders to identify their reporting needs
• Write Detailed System Requirements for reporting requirements
• Review all development initiatives as per CMS standards
• 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
• Introduced and developed data mining into reporting for the project
• Essential involvement with User Acceptance Testing of the reports & dashboards - participated in one - on-one calls and meeting with business user to plan, support and explain reporting activities, development and functionality.
• Performed extensive production support for users of reports. Also performed extensive data quality/integrity research to identity and rectify existing and potential issues
• Analyzed specialized security requirement and developed custom Report Services documents to provide appropriate users access to selected reports according to user role.
• Developed materialized views for reporting to improve report performance
• Created and maintained test data and user IDs for testing and verification of security filter and role access.
• Assisted with production support and defect management.