SUMMARY:

• Over 6 plus Years of professional experience in design, development, testing, implementation and maintenance in data warehousing environment.
• Involved in overall technical design and implementation of Business Intelligence solutions including MicroStrategy Schema Model, Data Warehouse semantic model and other BI/DWH technology platforms and delivery strategies.
• Collaborated with stakeholders to understand business needs and come up with solutions that used MicroStrategy reporting solution. Documented business requirements created wireframes and mockups to get business alignment.
• Interacted with multiple retail business departments including Buying, Inventory Planning, Marketing, Store Leadership, Finance and Creative.
• Developed suite of MicroStrategy dashboards that were rendered using Visual insights which enabled self - service visualization. Build numerous intelligent cubes that feed the dashboard.
• Migrated legacy reports and dashboards into MicroStrategy by re-architecting the and associated other reports objects to equivalent MicroStrategy objects leveraging powerful MSTR functionalities such as Attributes, Prompt, Filters, Consolidation and Custom groups.
• Served as the first point of contact for incoming data requests and systems questions from business users
• Worked and 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.
• Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.
• Good knowledge and experience in all aspects of Software Development Life Cycle (SDLC).
• Good knowledge and experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy.
• Well versed in installation, configuration and Project creation and tuning of MicroStrategy Business Intelligence.
• Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server& Distribution servers.
• Used MicroStrategy Object manager to migrate the objects/projects between Development and production servers.
• Very good understanding of Data Warehouse Architecture and Designing.
• Good understanding of intelligent cubes and Visual insights, and good knowledge in Analysis, design and construction of the metadata.
• Building of Six Sigma score cards to complement a full range of KPI rich dynamic Dashboards.
• Employed MicroStrategy Desktop in designing 3-tier and 4-tier MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• Generated and implemented MicroStrategy reports by creating projects, Dashboards, Attributes, Hierarchies, Metrics, Filters, and Templates.
• Configured reports for end users in MicroStrategy Desktop and MicroStrategy Web.
• Created User Groups and assigned privileges based on end-user roles using MicroStrategy Administrator.
• Worked on performance tuning techniques, tuning report SQL via schema object manipulations, I Server, I Cubes tuning.
• Analyzed and upgraded MicroStrategy from one version to another and applying the Hotfixes for that particular release.
• Implemented Microstrategy object migrations between environments and aligned with internal processes and toolsets.
• Worked in moving the objects from the staging server to production server by using the object manager.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 10.4/10.2/9.2.1/9.01/8.1.2/8.1.1/8.0.2/7. x (Micro Strategy Desktop, Web Intelligence Server, OLAP Services, Report Services, Command Manager, Administration), OBIEE

Data Modeling: ER diagrams, Microsoft Visio

DB Programming: SQL, PL/SQL, OLAP queries, MS SQL, DB2

Web Technologies: Web Analytics, SEO, Google Analytics

ETL Tools: Informatica 8.0/7.1

Project Management: System Development Life Cycle, UML, RUP, Visio, Project

Databases: MS Access, Oracle 10g/9i/8i/8.x, SQL Server 7/2000/2003, DB2, Teradata and Microsoft Sql

Operating systems: Windows 95/98, Windows NT 4.0, Windows 2000/XP

MS: Office 2007, Microsoft Word, Excel, Power Point, Outlook

PROFESSIONAL EXPERIENCE:

Confidential - San Jose, CA

Sr. MicroStrategy Developer

Responsibilities:

• Interacted with Subject Matter Experts (SME), Information and Integration Architects to get required information for report design processes and implemented optimization techniques to enhance performance of the MicroStrategy platform
• Created manual test cases and Performed Integrity Testing for all the reports.
• Performed backend testing by executing SQL Queries.
• Responsible for gathering requirements from Business User and creating mockups.
• As per business requirement, designed developed and maintained MicroStrategy based reports.
• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
• Design and deploy complex scorecards and dynamic dashboards covering key performance indicators by using different widgets trough MicroStrategy Desktop and Web.
• 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, Data Cloud, Heat Map etc.
• Created custom drill maps as required in reports for drill through functionality.
• Provided proactive Production support for MicroStrategy and other BI/Analytics applications by resolution of issues in a timely manner.
• Implemented MicroStrategy Integrity Manager to monitor the metadata object changes across all the development environments.
• Modifying the privileges to the users for the projects like enabling/disabling POWER USERS and other Standard User privileges.
• Supporting the existing projects and enhancing the reports on requirement.
• Providing knowledge to Users both in MSTR Desktop and Web.
• Worked with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Created Application Objects like Metrics, Filters, Prompts and Reports using Microstrategy Desktop.
• Created Intelligent Cubes, Intelligence cube reports, View Filters and Derived Metrics.
• Created transformations using Transformations by tables and expressions for Time Series Analysis.
• Created Schema Objects like Facts, Attributes and Hierarchies in Microstrategy Architect.
• Involved in troubleshooting Microstrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Used the Object Manager to move the objects from Development to Staging and Staging to Production Environment.

Environment:: MicroStrategy 10.2/10.4 (Desktop, Administrator, Web), MicroStrategy Architect, MicroStrategy Intelligence Server, Microstrategy Narrowcast Server, Microstrategy Object Manager, Microstrategy Command Manager, Microstrategy Integrity Manager, DB2, Oracle, Windows, TOAD for DB2 4.7

Confidential - Dallas, TX

BI- Microstrategy Consultant

Responsibilities:

• Created Dashboards using Flash and DHTML wizards like Time Slider, Interactive Stacked Graph, Interactive Bubble Graph, Heat Map and Microcharts.
• Created Stored Procedures to support reports.
• Involved in Performance tuning of SQL for long running reports.
• Created Dashboard for Corporate Financial Forecasting
• Provide production support of MicroStrategy reporting application.
• Create users in MicroStrategy and grant required access for projects.
• Involved in troubleshooting Microstrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Involved in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Designed Interactive Dashboards in Micro Strategy Web to assess company’s performance and monitored the overall goals of the business.
• Create/prepare monthly summary reports on market basket activity, highlighting product gaps.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Micro Strategy Desktop and Micro Strategy web.
• Involved in customization of Micro Strategy Web Dashboards.
• Involved in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Involved in creating various transformations to analyze different metric values in this year to last year using Micro Strategy Architect.
• Extensively worked on Documents by adding additional functionalities using XSL sheets to create more personalized documents with images, hyperlinks and other report objects.
• Involved in configuring the Intelligence Server and pointing the database instances in both development and production environments.
• Worked with Administrator in installation process of the Micro Strategy Tool Suite.
• Designed mappings and the logic to migrate data from Legacy source system to the target Database.
• Worked with Informatica tool suit for data Extraction, Transformation and Loading into the warehouse database from Oracle databases.

Environment: MicroStrategy 9, MicroStrategy Desktop 9.x, MicroStrategy Web 9.x, MicroStrategy Intelligence Server 9.x, Informatica Power Center 8.1, Teradata, Windows XP Professional.

Confidential

Responsibilities:

• Work in collaboration with Professors, gathering data from the papers. Assist with data consolidation and organizing the data in SPSS. Import the excel data into Database and process it to reporting.
• SPSS statistics helped to address entire analytical process from data collection to analysis, reporting and deployment. Performs faster. more accurate data preparation and validation.
• We can estimate missing data, so we can write more valid conclusions.
• Worked on SPSS Software and wrote a research article regarding organ donation.

Confidential

Microstrategy Consultant

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• Involved in business requirements analysis and documentation.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Created mapping documents to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results.
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database .
• Created SQL Jobs to schedule SSIS Packages in SQL Server Agent.
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Scheduled the SSIS packages to run at different intervals to load the data.
• Created Reports and Dashboards in MicroStrategy.
• Created different kind of Dashboards like Sales Dashboard, Forecast Dashboard and Write Back Dashboard.
• Unit Testing and QA for ETL and MicroStrategy Reporting.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Managing schema objects and application objects across the project by using Object Manager.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Involved in the creation of Data Mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.

Environment: MicroStrategy Desktop 8.0.0, SSIS, ETL, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.