SUMMARY:

• 9 years of industry experience in implementing all phases of the System Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Client - Server, Multi-tier, Web, Data Modeling and Data Warehousing/OLAP Applications.
• 5+ years of strong experience using MicroStrategy Suite (Intelligence Server, Architect, Desktop, OLAP Provider, Web, Narrowcast Server, Report Services).
• Involved in gathering Business requirements and determining the appropriate facts, attributes and metrics.
• Worked as a MicroStrategy Architect in creating various Schema objects with MicroStrategy Desktop like simple and compound Facts and Attributes, Fact extensions and Hierarchies.
• Designed and developed many complex Reports in MicroStrategy Desktop and MicroStrategy Web using Templates, Filters, Prompts, Consolidations and Custom Groups.
• Experience with converting Cognos and SAP reports and dashboards to MicroStrategy reporting
• Creating complex reports involving, MTD/YTD transformations, Rolling Month Filters, Dynamic Dates, Ranking functionality, Variances, Relationship filters etc.
• Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Gauges, Widgets and Grid/Graph combinations.
• Experience as a MicroStrategy Administrator in creating Users, security roles and tuning the VLDB Properties for better performance. Used Object Manager and Project Mover to move the Objects.
• Designed and developed Dynamic Dashboards using various selectors and widgets like time series slider etc
• In-depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data marts, Security and deploymen t, FACT and Dimensional tables, Logical and Physical data modeling
• Good understanding of RDBMS concepts and expert in Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages, and triggers.
• Experience with Data modeling using Erwin for Dimensional Modeling (Star, Snowflake schemas) and Entity-Relationship Modeling.
• Very Strong Experience in MicroStrategy Report Services, Experience in developing Dashboard & Mobile Reports and dashboards.
• Used Report Cache Sharing and Data Mart reports to enhance the Report response time.
• Ability to work with little or no guidance, lead projects, and motivate team members
• Excellent analytic and conceptual skills to solve complex issues and implement new ideas.
• Learn very rapidly and can critically evaluate and apply the results to adapt across multiple projects, teams and environment.
• Created ad-hoc reports, Designed and created new schema objects and modified existing schema objects for evolving reporting needs.
• Created various Schema objects with MicroStrategy Desktop like simple and Compound Metrics, Fact Extensions and Hierarchies, etc.
• System Optimization, performance monitoring and tuning experience in MicroStrategy Business Intelligence environment using MicroStrategy Enterprise Manager.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 9.4.1, 9.3.1, 9.2.1, 9.0, 8.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, and MicroStrategy Narrowcast Server, OLAP Manager, Microsoft Excel, Cognos, Business Objects

RDBMS: Oracle 11g/10g/9i, Teradata V2R5/V2R6/12, SQL Server 2005/2012, IBM DB2, Sybase and MS Access

Operating Systems: Windows XP/7/8, UNIX, LINUX and MS DOS.

Database Tools: Razor sql, SQL*Loader, Toad 10, 11.0, 12.0 and SQL Navigator

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

MicroStrategy Administrator

Responsibilities:

• Developed and maintained the reporting solutions for the release and deployment between enterprise environments -QA and production migrations of Micro Strategy objects 
• Involved in troubleshooting Micro Strategy Web Reports, optimizing the SQL using the VLDB Properties.
• Enhanced existing dashboards and scorecards using KPIs and enabling drill functionality.
• Performed installing, configuring, and administering MicroStrategy Intelligence Server, Web Server, and Mobile Server.  
• Incident tickets involved server outages, project accessibility issues, website outages, metadata/schema updates. 
• Applied Teradata Application Utilities and Teradata SQL. Also Fine-tuned SQL using Teradata. 
• Performed backend testing by executing SQL Queries 
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets. 
• Set up new installation of MSTR 9.2.1 & 9.3.1 and integration with Oracle, Teradata. 
• Involved in extraction of data from different Sources like SQL Server, Oracle, Flat Files into Teradata Global Repository Database, using Informatica 
• BI Architect responsible for implementing E2E reporting / Visual Insights solutions with Microstrategy & QlikView.  

Environment: MicroStrategy 10.x (Architect, Intelligence server, Web, Web Universal, Desktop), Report Services, Teradata, SQL Server, Windows Server 8. QlikView.

Confidential, Pittsburgh, PA

Sr. MicroStrategy Consultant

Responsibilities:

• Created complex MicroStrategy mobile dashboards for iPhone and iPad using Time Series, Microcharts, and Heat Map widgets.
• Created a daily billing report for the partners.
• Worked with the business team to open the issues in the reports and also worked with the technical team to fix all the issues.
• Created the Baseline data by using standard reports to compare and validate the internal reports.
• Created internal reports which are main sources of all the external reports.
• Created Attributes, Metrics, Prompts and filters
• Worked with the team to create mock ups
• Created Design document which contains all the detailed information of internal and external reports in summary and detailed level.
• Successfully finished checking the high level test conditions to get more information about the data.
• Well-coordinated with the ETL (Informatica) team and data modeling team to build reporting database according to our requirements.
• Created dynamic dashboards in web for the end users.
• Worked cohesively with business and technical teams to fulfill their requirements.
• Uploaded all the test cases of internal and external reports into Quality Center for UAT and validated all of these by providing the necessary documentation.
• Maintained all the defects in Quality center and successfully solved all the defects.

Environment: MicroStrategy 9.3.1 (Architect, Desktop, Web, Mobile), Sql Server 2010, WinSQL

Confidential, Houston, TX

MicroStrategy Consultant

Responsibilities:

• Obtained the requirement specifications from the Business Analysts for corporate work place project.
• Interacted with the business users to build the sample report layouts.
• Created users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
• Developed Facts, Attributes, and Hierarchies using respective editors.
• Worked extensively on creating Metrics and Compound Metrics, Filters, Custom Groups and Consolidations.
• Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode.
• Designed and Developed Dynamic Dashboards using various selectors and widgets like time series slider etc
• Involved in upgrading the MicroStrategy 9.2.1 to 9.3.1. Also tested all the reports and dashboards in the new version.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the filter.
• Resolved Many to Many relationships between the attributes and identified the one to one and one to many relationship between the attributes.
• Provided end user training for the MicroStrategy Web users.
• Involved in creating users in MicroStrategy Desktop for testing the reports on web.
• Created the Metadata & Statistic tables for the MicroStrategy projects on an Oracle database.
• Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.
• Performed Gap Analysis between the Production and Development Environment for migrating objects between the two places.

Environment: MicroStrategy 9.2.1m & 9.3.1 (Administrator, Architect, Desktop, Object Manager, Enterprise Manager), SQL Server 2008, Informatica

Confidential, Richfield, MN

MicroStrategy Consultant

Responsibilities:

• Created the Metadata & Statistic tables for the MicroStrategy projects on an Oracle database.
• Created new users, roles, privileges, shared folders, access controls Lists using security roles as a MicroStrategy administrator.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Filters, Custom Groups and Consolidations.
• Tested all the reports by running queries against the warehouse using Query man. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
• Designed and Developed Templates, Filters, Metrics, and OLAP Reports using MicroStrategy 9.0.1.
• Used several new controls for Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in 9.0.1.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Extensively worked on Dashboards using Report Services and also migrated documents to 9.2.1
• Upgraded the MicroStrategy Projects from MicroStrategy 9.0.1 to 9.2.1.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization
• Configured the Enterprise Manager for statistical reporting purposes.
• Provided access to the Data-warehouse to a much larger audience by using Narrowcast Server.

Environment: MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Web Analyst, Web Professional, Enterprise Manager), Oracle 10g, Teradata, Windows, Toad, SQL*plus

Confidential, Kansas City, MO

MicroStrategy Consultant

Responsibilities:

• Involved in the complete Life cycle of the Project.
• Participated in the end user meetings to obtain the business requirements for creating reports.
• Involved in the data analysis.
• Used the Project Creation Wizard to create Facts and Attributes and used the respective editors to enhance them.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes
• Created Advanced Reports in grid mode and graph mode using MicroStrategy Desktop.
• Worked extensively in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders and access controls Lists.
• Worked with the end users to create Enterprise Performance Summary Dashboards.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Created Customized Hierarchy for Drill Maps.
• Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
• Used Report cache sharing and Data mart reports to enhance the Report response time.

Environment: MicroStrategy 9.0.1/8.1. (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Oracle 9i, 10g, SQL Server, Informatica

Confidential, Commerce, CA

Jr. Micro Strategy Developer

Responsibilities:

• Worked closely with Business Analysts and Financial Analysts to know the requirements.
• Involved in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Micro strategy objects necessary for the deliverable, Analyzing and designing a prototype of documents and dashboards final output.
• Improved the report performance using VLDB Properties at all levels, Created different kind of Dashboards in both the interactive & flash mode.
• Created Ad-hoc reports by drilling up, down, within and across Hierarchies, Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Migrated the project into Testing and Production environments using Project Duplication Wizard.
• Involved in the creation of Static Reports and Ad hoc Reports, Applied My Preferences to make changes at Project Level and Desktop Preferences to make changes for all Projects of Desktop, Involved in optimization of code and tuning queries for performance.
• Created and configured database for development and production environments
• Developed stored procedures and database triggers using PL/SQL.
• Database and log backups & restoration, backup strategies, scheduling the backups. Backing up System & User Databases and restoring them when necessary.
• Monitor & tune SQL scripts. Creating upgrade scripts for production Database and support.

Environment: MicroStrategy 8.1.2 (Desktop, Architect, Web Analyst, Web Professional), Oracle, Windows, Erwin.