SUMMARY:

• About 7+ years of professional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Data Modeling, and Data Architecture.
• About 7 years of experience using Microstrategy Suite (Intelligence Server, Administrator, Architect, Desktop, Web, Narrowcast Server, Mobile Server, Distribution Services, Multisource, Web SDK, Mobile SDK, Command Manager, Object Manager, Integrity Manager, Dashboards and Visual Insights).
• Experience in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data warehouse.
• Extensively worked on Web SDK and involved in advanced customizations.
• Designed and Developed complex reports in Microstrategy Desktop using features like

  Templates, Filters, Prompts, drill maps, Consolidations and Custom groups.

• Extensively worked on delivering reports and business intelligence solutions on the web using Microstrategy Narrowcast Server.
• Participated in designing of Multidimensional Modeling in Microstrategy, regulating Star and Snowflake Schemas.
• Worked on UI customizations using web SDK.
• Very good experience with web based applications using ASP, HTML, DHTML, and XML.
• Extensive experience in dealing with a variety of Databases like Teradata, Oracle, DB2, and SQL server.
• Expert in Database development skills using SQL, T - SQL, PL/SQL, Stored Procedures, Functions and Triggers.
• Excellent communication, interpersonal and organizational skills.
• riented with excellent management skills and proven strength in problem solving, coordination and analysis.

TECHNICAL SKILLS:

Reporting Tools: Microstrategy 10, 9.3/9.x/ 8.1/8.0/7.5/7 i/7x, MS OLAP Services

Data Modeling: ERwin, Case Studio, ER Studio, Rational Rose, Microsoft Visio

Languages: C, C++

Databases: Oracle 10g/9i/8i, SQL Server 2012/2008/2005/2000/7.0/6.5, DB2 UDB, Informix, Teradata V2R5/R4/R3/R2, MS Access

Web Technologies: HTML, XML, Java Script

Operating Systems: Windows 2012/8/7/XP/2K/NT/98/95, Linux

WORK EXPERIENCE:

Confidential

Sr. Microstrategy Analyst/ Developer

Responsibilities:

• Responsible for end to end Attribution product.
• Responsible for the complete Architecture and Data modeling for Attribution product.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports.
• Configured Metrics, Attributes and Filters for each Report.
• Used Microstrategy functions such as Apply Simple, Apply Comparison in the metric calculations and used in different reports.
• Created Objects like Object Prompts, Documents & Reports.
• Created Customized Auto Styles to allow reports in Microstrategy Desktop and MicrostrategyWebto apply customized formats.
• As per business requirement, Designed developed and maintained Microstrategy based reports.
• Naming convention standardization across multiple projects for an enterprise level strategy.
• Production support, trouble-shooting and fixing of reports was done in record time
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Microstrategy Desktop.
• Created many dashboards and report builders to meet the user requirements.
• Used theVLDBproperties forperformance tuningandSQL optimization.
• Extensively used Object Manager to move objects from Dev to Test & Production Environment.
• Responsible for managing many consultants in different time locations.
• Responsible for the up and running of the application with clustered I-servers and Web servers.
• Created the road plan for the upgrade form 9.3.1 to 9.4 and then to 9.5 and later now 10.
• Implemented the Enterprise Manager to monitor the User and System usage analysis.
• Played a Solution Architect for e-mail project to get the Microstrategy working on Vertica.
• Created Single Sign On and External Security Module for the website.
• Implemented ESM using the ping and Trusted authentication.
• Created automatic User creation on login using Task Admin and SDK.
• Worked closely with ETL people on data analysis.

Environment: Microstrategy 10 9.3.1/9.4/9.5, SQL Server 2008/2012, Microsoft Excel 2010, Teradata

Confidential, Atlanta, GA

Sr. Microstrategy Analyst/Developer

Responsibilities:

• Worked on Mobile APP for Global Real Estate Business Intelligence for C level executives.
• Involved from initial stages of the project.
• Worked with business users to collect all the information.
• Worked with a team of more than 15 people working from different time zones.
• Worked with data modelers to implement ragged hierarchy.
• Done an extensive data analysis and involved in data model design for MicroStrategy.
• Brought in all the tables needed and created the schema needed.
• Developed the Schema objects attributes, facts, hierarchies and logical tables
• Created all the necessary Metrics, filters, prompts and reports.
• Developed Dashboards, Scorecards and operationalreports by usingReport services.
• Used URL API to answer the prompts automatically based on the user selection.
• Used prevMsgID and selector Mode key words in the URL to pass the prompt answers and retain the user selection throughout the APP navigation.
• Solved many critical issues and worked extensively with the MicroStrategy support team and logged many cases and short comings of the tool.
• Created visually rich dashboards for the Executives using map widget.
• Cached reports and created Intelligent Cubes where ever necessary to improve the performance of the APP.
• Used information windows to display the detail data on the IPAD.
• Maintained the project in three different environments.
• Used Swipe mechanism on the IPAD to navigate between the panels.

Environment: Microstrategy 9.3, Sql Server 2008, IPAD, Microsoft Excel 2007

Confidential, Middletown, CT

Microstrategy Developer

Responsibilities:

• Worked with Business Analyst to understand the Requirements.
• Created many bridge tables to sync the data between different schemas.
• Brought all the views and tables into the Warehouse Catalog.
• Architected the schema needed for the reports.
• Created all the Metrics, filters, Custom groups, drill maps.
• Built many level Metrics, Compound Metrics and Conditional Metrics to satisfy the reporting requirements.
• Created many filters, custom groups needed for the analysis.
• Built the MicroStrategy schema to work between the environments on a relational schema.
• Built complex reports querying the relational data tables from three different environments.
• Create many Transformations to compare the data between the years.
• Created all the reports needed for the users.
• Created a report services document for user interactivity.
• Trained users with different capabilities of Microstrategy tool.
• Created Command Manager Script to schedule the reports hourly on the Event day.
• Built many reports to export to Excel and PDF formats.
• Fine tuned the reports for performance
• Created email subscriptions to deliver the reports.
• Created Event based Schedule to trigger the reports before the game time.

Environment: MicroStrategy 9.2, Sql Server 2008, Microsoft Excel 2012

Confidential, Grand Rapids, MI

Microstrategy Developer

Responsibilities:

• Worked on different projects Pricing Scorecard, Vendor Performance, Black Friday Reporting, Promotions
• Gathering the Business Requirements.
• Developed the data model for Promotions project.
• Work with data modelers for required data.
• Architect the MicroStrategy Schema Objects.
• Creating and/or enhancing report objects, metrics, filters and prompts.
• Designing and building grids, graphs, scorecards, standard reports and dashboards.
• Validating report results against requirement deliverables for accuracy.
• Troubleshooting and analyzing data issues within reports.
• Collaborating with business partners to provide technical report assistance
• Following and enhancing MicroStrategy standards and best practices across the team.
• Worked on Price reporting to provide improved analytics and competitive intelligence
• Enhanced the existing reporting to use the new competitive shopping system data and the new PMM product hierarchy
• Process the data and provide the Pricing Coordinators with the required information.
• Worked with Data Modeling and Data Warehousing Using Multi Dimensional Model, Star and Snow Flake Schemas.
• Designed and implemented MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.
• Created transformations using Transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web.
• Database design employed highly complex data transformations including Slowly Changing Dimensions and a series of Stored Procedures, which made performance tuning and efficient mapping highly critical.
• Used Report cache sharing and Data mart reports to enhance the Report response time.
• Wrote command Manager Script to create large number of Users and apply Security Roles accordingly.

Environment: MicroStrategy 9.0.2, Teradata 12.0.3, SQL Server 2008, DB2, Windows XP Professional 2002, Microsoft Excel 2007.

Confidential

Program Analyst

Responsibilities:

• Gathered requirements from the business users for MicroStrategy Reports.
• Prepared report specification documents.
• Created MicroStrategy Attribute Facts and public objects.
• Created Reports according to the business requirements.
• Created summary tables in Teradata.
• Used report services to create documents.
• Created Various Prompts like Element Prompt, Value Prompt and Object Prompts to allow the end users to enter their own criteria.
• Worked on the performance tuning of the MicroStrategy reports this included designing the summary tables, creating indexes.
• Deployed custom widgets into MicroStrategy web and created Dynamic Enterprise Dashboards.
• Used Compound Metrics, Custom Groups, and Consolidations to create reports to meet complex business needs.
• Extensively used Object Manager to move objects from Dev to Test & Production Environment.
• Did performance tuning on Narrowcast Server by re-adjusting the segment size, priority, Execution time out and the scheduled time accordingly for each Service.
• Created Various Prompts like Element Prompt, Value Prompt and Object Prompts to allow the end users to enter their own criteria.
• Worked on the performance tuning of the MicroStrategy reports.

Environment: Microstrategy 8.1/8.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter), Informatica, VB, Microsoft EXCEL Teradata V2R5, HTML.