SUMMARY:

• 7+ years of experience in Information Technology, experience with Data Warehousing Reporting Tool MicroStrategy using Desktop, Web, Intelligence Server, and Report Services.
• Extensively worked in creating and integrating Reports and Objects in MicroStrategy (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) in the data warehouse.
• Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Created Dynamic Dashboards showing organizations yearly performance and analyzed the sales, revenue, profits using various graphs and widget
• Experience in designing mock up reports for client demos
• Extensive work experience in designing Data Marts using different multi - dimensional modeling techniques such as Star Schema and Snowflake Schema for FACT and Dimensional tables that includes Logical and Physical data modeling.
• Involved in Data architectural designing and database integration, data warehousing.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Involved in Trouble Shooting, Performance tuning of reports and resolving with in Business Objects Enterprise and Reports.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to design, development, testing, deployment, and support.
• Implemented features like Integrated Query reporting and powerful iterative analysis were provided to the end users through MicroStrategy Desktop and Web
• Experience in performance tuning SQL queries by providing hints, obtaining explain Plan, analyzing tables and adding indices.
• Extensive MicroStrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider, Data Mart and Web BI Suits and Reporting Tools.
• Experience in Sending Weekly and Monthly Status Reports to Client/Higher Management. Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills
• Excellent problem solving skills with a strong technical background and good inter personal skills.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 10.2,10,9.4.1, 9, 9.2, 9.2.1, 8.0, 8.1 (Desktop, Architect, Web, Intelligence server)

Databases: MS Access, Teradata, MS SQL Server, Mobile SQL server

Operating Systems: Windows XP, Windows vista, Windows 7

Office Tools: MS Word, Excel, MS Visio, MS Project, MS Outlook, MicroStrategy Office

Dashboard and Widgets: MicroStrategy Dashboard

PROFESSIONAL SUMMARY:

Confidential

Digital MicroStrategy Developer/Consultant

Responsibilities:

• Responsible for all MicroStrategy Architecture/Development.
• Verified the logical schema for existing dimensions, worked with ETL Team for new tables, columns.
• Created schema objects such as Attributes, Facts and Hierarchies and worked on relationship between attributes.
• Architected and Developed composite solutions involving users access reports
• Created various reports which are part of dashboard having different interactive widgets that are accessed by top level executives.
• For complex reporting needs, worked extensively on creating Metrics, Filters, consolidations
• Resolved Cross joins in the SQL's by modifying the attribute definitions to generate the accurate results.
• Leveraged MicroStrategy OLAP services to develop reports, which use the functionality of the intelligent cubes and Derived Metrics.
• Created security filters and other report objects, drilling, defined hierarchies.
• Develop Standard as well as Ad-Hoc Reports based on the user need, the end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Coordinated with the team members in order to update the progress of the development.
• Scheduled meeting with the clients and the development team and reporting to the project manager.
• Worked on creating the Visual Insights including the various widgets and demonstrated to the business users.
• Tested all the reports by running queries against the warehouse and also compared those queries with the MicroStrategy SQL engine generated queries.
• Worked on support measure for the other related projects and responsible for re-architecting required changes and checking the report results.
• Created documents using panels, panel stacks, sections, grids, graphs and widgets.
• Tuned the reports by taking advantages of VLDB properties and complex report filters.
• Worked with DBA's in identifying the long running queries of daily reports data and enhanced the performance by indexing, data distribution, and monitoring other activity on box.
• Used the Object Manager to move the objects from Development to QA and to Production environment in MicroStrategy.
• Collaborating with business partners to provide technical report assistance.

Environment: MicroStrategy 10.2, Desktop, Intelligence Server, Web, Administration, SQL Server, Window10, My SOL Workbench, Red shift

Confidential, Washington, DC

MicroStrategy Developer

Responsibilities:

• Created Reports and Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Experienced the latest version of MicroStrategy 10.2, 9.0.1 & above .
• Developed Public Objects like filters, prompts, metrics, templates, consolidations, etc.
• Experienced in using Schema Objects to create reports.
• Worked on Data Warehousing and RDBMS concepts.
• Created view and tables to generate clean SQL for reports
• Tested reports and Dashboards in different environments to ensure the functionality and results.
• Coordinated with team in order to deliver the product on scheduled time.
• Actively participated in the data modelling and given suggestions in formulizing the table structure.
• Worked with databases like Teradata for testing and validation of data and to create reports.
• Experienced in promotion of Objects to different environments.
• Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
• Performed testing of all reports for the final deployment.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Created template reports using advanced prompts like object prompts, expression prompts, filters.
• Designed the Micro Strategy Architectural and Developers Documents for the Projects.

Environment: MicroStrategy 10.2, 9.4.1, Desktop, Intelligence Server, Web, Administration, SQL Server, Window XP, Pl-SQL, Tera Data

Confidential, New York, NY

MicroStrategy Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
• Created multiple flash and dynamic dashboards using Intelligence Cube and Documents
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created adhoc reports to users by connecting various data sources.
• Handled admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Designed the data architecture and Involved extensively in Database Performance tuning
• Migrating Project objects using Object Manager and comparing different environments using Integrity Manager of MicroStrategy
• Help Data Analysts to create reports for Analysis using Cubes, Documents and Dashboards
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the source data and handled efficiently by modifying the data types.
• Generated context filters and used performance actions while handling huge volume of data.
• Coordinating with IT and Business in the planning, design, development, and deployment of New Dashboards and Reports and mapping of data from Data warehouse as per requirements
• Upgrading MicroStrategy versions, applying hotfix
• Extensively worked in developing Public objects including Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Generated dashboards for sales with forecast and lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated dashboards with combination charts for clear understanding.

Environment: MicroStrategy 9.4.1, 9.0, Intelligence Server, Web, Administration, Greenplum, pgAdmin 8.3.1, SQL Server 2005 and 2012, PL-SQL

Confidential, Secaucus, NJ

MicroStrategy Administrator

Responsibilities:

• Worked on three different projects starting from creating the fact tables and dimension tables till the creation of the Report service document.
• Administered two MicroStrategy Development systems and one production system. Responsibilities included schema design, creating new users, assigning security model standards, performing object migration/report publication, tuning server settings, tuning SQL, and scheduling weekly maintenance tasks on the metadata.
• Worked one-on-one with business users in developing report requirements, specifications and design.
• Created the transformation tables and developed schema and public objects on top of them to include in the reports which can compare as Is Vs as Was
• Created Report Service Documents for HR and Finance Projects.
• Used Advanced Prompts, Non- Aggregate Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports
• Experience in Mobile SDK to customize mobile application like rebranding, integration with google maps.
• Involved in creating the Technical Documentation for Developers and Check lists for the users for the MicroStrategy Project.
• Involved with Business analyst and Client for requirement gathering.
• Developed reports for the pricing data warehouse which compared business pricing strategies to local competitors. Reporting included category management, executive summaries and price difference.
• Responsible for Administration tasks include creating users and applying access to projects, creating/ duplicating the projects and migrating objects from development environment.
• Created dash boards which evaluates and compares data for Current and Prior months, quarters, years and made available in Interactive mode, Flash mode and PDF mode.
• Received appreciations from Business users for creating Dashboards looks and feel like their sample reports.

Environment: MicroStrategy 9.2.1 (Administrator, Desktop, Architect, Web, Narrowcast Server, Object Manager, Enterprise Manager, Office, Report Services), Teradata, Windows NT

Confidential

MicroStrategy Developer

Responsibilities:

• Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
• Created MicroStrategy Schema objects basically data architecture sand Application objects using MicroStrategy Desktop and Architect.
• Creating Pivot charts and KPI Reports using MS Excel and Lookup functions.
• Developed Customized and Ad-hoc reports in Grid & Graph mode using Templates, Metrics, Filters, Custom Groups, Consolidations and Transformations - The end-users were able to generate Ad-hoc Report by Drilling up, down, within and across dimension or anywhere.
• Execute periodic - weekly & monthly standard reports consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Moved Objects from one environment to other.
• Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.
• Created Complex Metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
• Tracking enhancement projects to ensure the project delivery on time.
• Effectively manage Changes through Change management process.
• Created Summary and Drill down reports for various attributes based on their hierarchies.
• Efficiently handle and Manage production support activities through Incident Management.
• Project Metrics collection and reporting to senior management.
• Used free form SQL editor for complex report creation.
• Weekly status review with client.
• Identify potential development opportunities and propose innovative solutions.
• Making sure that always sticking with the SLA (Service Level Agreements) commitments and producing SLA report to client and management.

Environment: MicroStrategy 9.2.1, MicroStrategy Desktop, MicroStrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Informatica, Oracle 9i, Oracle SQL Developer, Teradata SQL, Windows XP/2000.

Confidential

MicroStrategy BI Developer/Analyst

Responsibilities:

• Analysis and Design and development of ERP Bolt-on’s for sourcing, demand and retail management
• Coordination and resolution of production issues with support team
• Design and development of BI applications for retail business using MicroStrategy. Development of new reports and metrics for inventory management, retail store operations, pricing, markdowns etc. I had worked on the following projects.
• Regular vs Markdown analysis by department (This report provides analysis to company planning executives for Retail Sales and Inventory, Unit Sales and Inventory and Margin Dollars.)
• Lucky Specialty planning dashboard (This dashboard provide the analysis at Style level).
• Hourly Flash Sales Dashboard (this Dashboard provide the Hourly Unaudited/audited sales and transaction KPIs).
• Worked as a MicroStrategy analyst for the financial Users to support various reporting needs for the business.
• Involved in gathering business requirements and documenting specifications.
• Created the Metadata & Statistic tables for MicroStrategy projects.
• Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
• Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
• Extensively worked on Report Services to create performance dashboard reporting.
• Created drill maps for end users to drill down and recover data.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
• Involved in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
• Worked on Enterprise manager to generate reports in enterprise manager
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services).