PROFESSIONAL SUMMARY:

• 8+ years of progressive IT experience in implementing Business Intelligence Solutions leveraging expertise in Data Warehousing and Data Modeling using MicroStrategy Platform.
• 6+ years of strong experience using MicroStrategy Suite (Intelligence Server, Desktop, Narrowcast Server, Web).
• Extensively worked on creating and integrating MicroStrategy Objects like Attributes, Facts, Metrics, Filters, Prompts, Templates, Consolidations and Custom Groups.
• Proficient in creating reports using MicroStrategy Desktop with optimal usage of key features like Advanced Filters, Prompts, Custom Groups and Consolidations.
• Proficient in building complex traditional dashboards on desktop and Visual insights dashboards on web.
• Worked on Stored Procedures and Functions in SQL and constructed complex SQL queries.
• Participated in Full Life Cycle Development of Data warehousing projects - Project Planning, Business Requirement Analysis, Data Analysis, Logical and Physical Database Design, Setting up warehouse physical schema and architecture, developing reports, security and deploying to end users.
• Extensive experience in modeling and developing logical/physical data models using entity-relationship modeling tools like ERwin.
• Strong understanding of Data Warehousing concepts such as dimensional modeling, star, snowflake and starflake schemas, Datamarts, Fact and Dimension tables identification.
• Optimizing report generation with respect to Very Large Databses (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for SQL Server, Oracle, Teradata and DB2.

WORK EXPERIENCE:

Confidential, Concord, CA

MicroStrategy Architect

Responsibilities:

• Understood the source system, involved in gathering requirements and actively participated in the meetings with system analysts, data architects, ETL and MicroStrategy team meetings to follow proper procedures towards development environment.
• Created Schema Objects such as Attributes, Facts, Hierarchies, and Transformations etc.
• Created Cubes, Reports, Visual Insights (VI) dashboards.
• Created Public Objects like Metrics, Filters, Templates, and Prompts condition for reports in MicroStrategy Desktop.
• Created and maintain the Monthly data Loads and automated them in SAS.
• Created Freeform SQL reports/cubes.
• Used VLDB properties to tune SQL.
• Involved in creation of Dynamic Dashboards for top level management to view overall business performance and find tremendous value in viewing timely, visually intuitive snapshots of strategic financial and operational data in flash using widgets and dhtml using visual insights and report service documents.
• Migrated reports from Excel to MicroStrategy.

Environment: MicroStrategy 10.5, Teradata, Windows 7.

Confidential, Dallas, TX

Sr. MicroStrategy Consultant

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.
• Involved in Microstrategy upgrade to version 10.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy.
• Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users.
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
• Used Information windows extensively on iPad based dashboards for better interactivity and navigation.
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using I-cubes improved performance of the RS documents significantly.
• Used MicroStrategy Distribution Manager for automation of reports that saved many man hours every day and helped departments focus on data analysis instead of data generation. This helped in accuracy and integrity of data presentation.
• Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like ApplySimple, Apply Comparison to overcome complex logic in creating objects
• Widely used VLDB properties to set default criteria at project level and also at individual report levels to overcome performance issues.
• Also tuned ODBC driver to improve data transfer rates between database and MicroStrategy servers located at different physical locations.
• Also worked as ETL support contact supporting Informatica mappings to load data into data warehouse.
• Experience working in various environments with change management, defect tracking and status reporting processes

Environment: Microstrategy 10.x/9.4.1 (Desktop, Web, Architect, Administration, MSTR Tools), Oracle 11g, SQL Server 2012, Windows 2008, Linux.

Environment: MicroStrategy 9.3, SQL Server.

Confidential, Cupertino, CA

MicroStrategy Architect

Responsibilities:

• Worked closely with advertising team and gathering requirements from i-Ad business team.
• Created documentation on business Requirement.
• Created MicroStrategy schema objects and application objects by creating facts, attributes, hierarchies, reports, cubes, filters, metrics and templates using MicroStrategy desktop.
• Extensively worked in developing Public objects including Metrics, Derivedmetrics, Compound metrics and Filters for complex reports.
• Worked on admin tasks like creating users and giving access to them.
• Worked on Integrity manager .Reports, Dashboards and SQL code is tested using Integrity Manager.
• Maintained the Daily reports. Python Script is used to invoke the Dashboards though Narrow Caste server.
• Worked on Free form Sqls and created HTML Dashboards .Created the HTML Subscription for the HTML Dashboard.
• Designed a document with 30 layouts and created Narrowcast Subscription, where it will load into Shared Portal as a PDF file.
• Worked on Visualization dashboards.
• Connected to Hadoop DB with Hive (sql engine).And created Free form Sql reports.
• Moved objects from different environments(Object Manager).
• Designed Interactive dashboards to i-Ad business users.
• Involved in scrum meetings.

Environment: MicroStrategy 9.0.2, MSTR 9.3, Desktop, Web, Oracle.

Confidential, San Francisco

MicroStrategy Developer

Responsibilities:

• Developed MicroStrategy Schema objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including security filters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator, Set analysis, What-if analysis, Data-mining, Data mart reports.etc.).
• Created very complex reports eg: Market-Basket Analysis involving interactive web and Window’s interface.
• Created User requirement document for realizing MicroStrategy objects to be integrated in the report.
• Created logical data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the project.
• Create the design document; personalize the reports as per user requirements, which included customizing and formatting.
• Configure reports, Scorecards and Dashboards for end users in Desktop and MicroStrategy Web.
• 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 created and used Custom groups and Consolidations.
• Partnering with our business clients to understand the business analysis to be performed and subsequent required reports

Environment: MicroStrategy Desktop 9.0.1, Oracle 10g

Confidential, Fremont CA

MicroStrategy Developer

Responsibilities:

• Implemented Drill Down/up functionality in various reports.
• Extensively used filters, facts, Consolidations, Transformations and Custom Groups to generate reports for Business analysis.
• Created MicroStrategy Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop
• Tuned the VLDB properties to enhance the performance of the reports at project level and report level.
• Responsible for Writing SQL queries and designed Freeform SQL reports in MicroStrategy.
• Created different Project Sources for different environments like production, testing and development.
• Handle the queries regarding XML and troubleshoot the complex technical XML problems.
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements.
• Strong Knowledge in creating Reports scalable to large volumes of data and pass the stress and performance testing.
• Actively Involved in testing the MicroStrategy Objects and Reports in Different MicroStrategy Environments 9.0

Environment: MicroStrategy 9.2.1, Teradata.

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

• Involved in Analysis, Design, and Development and Testing phases.
• Analyzed the business requirements from the given specifications.
• Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL.
• Maintenance of the various database objects, tables/views/stored procedures.
• Used the maintenance Plan for SQL Server databases to recreate indexes and statistics.
• Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed and developed complex SSRS reports.
• Create ad hoc complex management reports as required.
• Design and develop reports using SQL server reporting services
• Created and scheduled jobs and alerts
• Analysis and trouble-shooting of defects.

Environment: SQL Server 2005 Enterprise Edition, Access 2003, T-SQL, MS-Excel, Query Analyzer, Crystal Reports.