SUMMARY

• About 8 years of experience in full life cycle as a MicroStrategy professional, that includes requirement gathering, analysis, design/architecture, implementation, testing and maintenance.
• Expertise in using MicroStrategy 9.x/8.x/7.x/6.x product suites including MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Office, MicroStrategy Object Manager.
• Expertise in MicroStrategy Business Intelligence Architecture and very good understanding of Data Warehouse Architecture and Designing.
• Confer with business and technical partners, perform data analysis and data profiling, identify data quality issues, and develop Metadata Model.
• Serve as a subject matter expert and participate in design reviews.
• Immense working knowledge of Direct Project Source (Two - Tier) and Server Project source (Three-Tier).
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Experienced in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
• Expertise in Analysis, design and construction of teh metadata within Architect.
• Worked to large extent in creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Expertise in Developing User Objects (filters, prompts, metrics, Custom Groups, Consolidations, Searches) to develop Documents and reports.
• Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Expertise in Creating Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Expertise in creating Hyper Links in Documents and Drill Reports.
• Expertise in using My Preferences applicable to Specific Project and Desktop Preferences Applicable all Projects of Desktop.
• Expertise in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Expertise in creating dashboard Reports to view personalized reports based on user requirements.
• Experience in implementing row level security within teh Metadata, Involved in creating Managed AD HOC Report for End Users.
• Strong knowledge in Reporting and Analyzing data with Intelligent Cubes & Dynamic Sourcing I Cubes.
• Fine tuning of teh MicroStrategy reports using Data mart Reports, Partition Mappings and Aggregate tables, VLDB SQL Query Optimization Techniques.
• Expertise in Defining MicroStrategy Narrow cast Server objects like Service, Schedule, Subscription set and Information Objects.
• Experience in developing test cases and test plans for system testing and involved in unit testing and UAT extensively.
• Experience in change management, problem solving, team coordination and mentoring team members.

TECHNICAL SKILLS

Business Intelligence: Microstrategy 9.x/8.x/7.x (Microstrategy Desktop, Microstrategy Web, Microstrategy Intelligence Server, Microstrategy Narrowcast Server), MSTR Office Add-in, Enterprise Manager, Object Manager

Databases: MS-SQL Server, MySQL, Oracle 10g/9i, Teradata, MS-Access.

ETL Tools: SSIS, Informatica 8.x/7.x/6.x, Oracle Warehouse Builder 10.2.

Languages: SQL, PL/SQL.

Web Programming: HTML, DHTML, XML, XAML, CSS, Java Script

Other Tools: ERWIN, Quality Center, SharePoint, Remedy

PROFESSIONAL EXPERIENCE

Confidential, AR

Sr.DHS Consultant

Responsibilities:

• Participated in teh end user meetings to obtain teh business requirements for creating reports.
• Understand and document business processes, data entities, data producers and consumers and teh data dependencies between various departments.
• Validate teh Issues being raised in teh UAT (user acceptance test) and address them as Change request or true defects within teh code·
• Make sure teh SLA’s (Service Level Agreement) for teh report available are met.
• Prepared functional and technical specification documents for reports.
• Involved in up gradation from MicroStrategy 8.1.2 to MicroStrategy 9.x.
• Responsible for Analysis, design and build of teh metadata.
• Architected and performed teh report development for teh MicroStrategy projects by creating schema objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Templates.
• Used Metrics (simple, nested, compound and derived), Level metric, Conditional metric, Transformation metric, advanced filters, advanced prompts, advanced report designs and drill maps for creating complex reports.
• Created reports with various object prompts to generate various ad-hoc reports.
• Created Transformations (Table based and expression based) for YTD (year to date), MTD (Month to date), WTD (week to date) analysis.
• Involved in migration of reports to Testing and Production Environments Using Object Manager.
• Analyzed system usage and user sessions using Enterprise Manager.
• Reduced teh time taken for teh reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Developed Documents and dashboard for visualization and for understanding teh business trends.
• Created schedules and maintained delivers through MicroStrategy Narrowcast server.
• Involved in Dimensional Modeling of database for enhancing projects and aggregated views after business enhancements.
• Unit testing and data validation (QA) of teh reports.
• System testing and end-to-end testing for Reporting Phase of teh project.
• Involved in validation of daily loads with ETL Team.
• Responsible for using teh MSTR Office Add-In to display reports within MS Office Product for Management review
• Provided day-to-day Production Support to resolve technical issues.

Environment: MicroStrategy 8x/9x (Desktop, Web, Object Manager, Enterprise Manager), MicroStrategy Narrowcast Server, Distribution Services, Office Plug In, Oracle 10g, DB2, Quality Center, Remedy, Informatica, Windows, MS Office.

Confidential, AR

Sr. MicroStrategy Consultant

Responsibilities:

• Worked with business users to gather requirements, document SRS, TDS and Report mockups.
• Validate teh Issues being raised in teh UAT (user acceptance test) and address them as Change request or true defects within teh code.
• Develop and maintain data dictionary.
• Work with other developer in teh BI reporting Space on delegating teh task.
• Help Project manager, Solution Architect, Business System Analyst on status report from teh BI Space.
• Generated advanced reports in Grid, Graph, and SQL mode, consisting of data analysis by combining a template with filters usingMicroStrategy Desktop and Web.
• CreatedMicroStrategy Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups usingMicroStrategy Desktop.
• UsedMicrostrategy Web to offer interactive reporting to end users through a web browser.
• Created services using Subscription sets, Schedules, and Information Objects.
• Worked in designing and developing Interactive Scorecards and Dashboards according to Business requirements.
• Created different Transformations to get teh last year’s actual transactions, week to day, week to period, week to quarter and week to year and effectively used them with teh Metrics.
• Customized teh drilling options specific to teh reports, using drill map editor to give access to more detailed and supplemental information.
• Created Star Schema to develop teh data mart in teh data warehouse.
• Involved in Database Performance Tuning.
• Created various types of reports such as Drill Reports, Cross Tab Reports, Standard Reports, and Master Detailed Reports, using different reporting features like Slice and Dice, Drill Down, Prompts, Filters, Alerts, Sorts and Breaks.
• Upgraded teh MicroStrategy Projects from MicroStrategy 8.0.2 to 8.1.1.

Environment: SSIS, MicroStrategy 8.1.1, Windows NT/2000, Oracle 10G, SQL Server, DB2, Quality Center, Remedy.

Confidential, Pittsburgh, PA.

Sr.MicroStrategy Dashboard Developer

Responsibilities:

• Identify Source tables and columns required to create a MicroStrategy project.
• Architected teh schema objects such as Attributes, Compound Attributes, Facts, and Hierarchies.
• Designed teh application objects Filters, Base Formulas, Metrics, Derived Metrics, Compound Metrics, Templates and Reports.
• Created Dashboard, Scorecard and operational reports by using MicroStrategy Report services.
• Worked on teh Flash functionality of teh Microstrategy to generate interactive Dashboards.
• Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents. These were especially useful for teh insurance companies in making critical decisions regarding policies.
• Created interactive dashboards using teh new selectors in 8.1 like radio buttons, check boxes, panels, slider, button bar etc.
• Developed Custom Reports with a host of ad hoc features including drilling, pivoting and data slicing.
• Created Prototype Dashboards and Presented to teh user group for User Acceptance.
• Created transformations using transformations by tables for YTD, MTD and WTD analysis.
• Interacted with teh Business Users in Confidential ’s Sporting Goods Inc., and gatheird requirements for Dashboards.
• Identified teh Facts and Attributes that goes in teh Dashboard and documented teh Technical specification.
• Created Prompts to give teh end users teh required power to define teh report definition at teh run time.
• Created Hierarchies for providing drill down options for teh end-user through Web.
• Implemented Drill Maps on several reports to access data at different levels.
• Configured Data Marts in MicroStrategy Desktop to update tables in database.
• Created Narrowcast Services to deliver reports to End User.
• Headed as MicroStrategy Technical Lead for a MicroStrategy environment and Production Support team.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Proactively created report formats and delivered personalized messages from teh BI platform through MicroStrategy Narrowcast Server.
• Verify and Validate teh Up gradation process of MicroStrategy Projects from MicroStrategy 7i to 7.5.0 and 8.0.2 to 8.1.0.

Environment: MicroStrategy 8.0, Desktop, Architect, MicroStrategy Intelligence Server, Narrow Cast Server, Report Editor, Report Services, Configuration Wizard, Warehouse Catalog, Oracle 10g,SQL Server 2005, Informatica, Lotus Notes

Confidential, Des Moines, IA.

MicroStrategy Developer.

Responsibilities:

• Architected teh schema objects such as Attributes, Compound Attributes and Facts.
• Designed teh application objects advanced Filters, Base Formulas, Metrics, Derived Metrics, Compound metrics, Templates and Reports.
• Created Prompts to give teh end users teh required power to define teh report definition at teh run time.
• Created new users and groups and moved report objects under one user, using Object Manager.
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
• Created Dashboards in both teh interactive & flash mode for users who were teh various insurance companies.
• Extensively worked on Report Services to create performance dashboard reporting.
• Worked thoroughly on PL/SQL, Tables, Views, Synonyms, and Indexes.
• Responsible for setting teh Metadata for teh Microstrategy Projects, maintaining teh metadata servers, and maintaining teh Microstrategy Web server.
• Optimized teh performance of teh MicroStrategy platform by implementing suitable report design processes, and using VLDB Property.
• Created Hierarchies for providing drill down options for teh end-user through MicroStrategy Web.
• Based on data models, created MicroStrategy Schema Objects.
• Designed and Maintained Metadata using MicroStrategy Architect.
• Created Customized Hyperlink to do Drilling from Documents through MicroStrategy Web.
• Configured Data Marts in MicroStrategy Desktop to update tables in database.
• Configured teh Narrowcast Server by creating teh Subscription repository in SQL Server Database.
• Created Narrowcast Services to deliver reports to End User.
• Created teh Data mart reports based on specific requirements and running teh existing Data mart reports for weekly and monthly loads.
• Provided access to teh Data-warehouse to a much larger audience by using Narrowcast Server.
• Configured teh Enterprise Manager for statistical reporting purposes.
• Created and configured database for development and production environments in SQL Server.
• Distributed reports to teh merchandise planners, production support and teh sales, marketing and finance team by using Broadcaster.

Environment: MicroStrategy 8.0, ScanMD, Oracle 10G, SQL Server, Teradata, Informatica, Quality Center.

Confidential, Greenville, SC.

MicroStrategy Consultant

Responsibilities:

• Developed and maintained teh front-end repository including complex Metrics, Filters, Views and dimensions.
• Enhanced teh multidimensional view of teh report data by creating custom filters prompts, consolidation, custom group and drill paths. Auto prompt filter feature gave end-users a choice of different filtering criteria each time they run teh reports.
• Designed and Maintained Metadata using MicroStrategy DSS Architect.
• Integrated Database with Netezza, server and strong platforms in a purpose-built system.
• Worked on terabytes of data at higher performance levels, with database Netezza.
• Experience in developing ad hoc interfaces.
• Troubleshooting operational and data issues.
• Used MicroStrategy Report Services to customizing and formatting documents concerned with Operational Reports, Business Report and Managed Metrics Reports as per user.
• Involved in teh complete project life cycle of Publisher Data Mart.
• Testing changes and modification for reports.
• Provided relevant business insight such as using Statistical and Data Mining technique in examining product affinity and historic sale trends reporting analysis.
• Managed user Administration like creating new users, changing existing permissions of user, disabling users and establishing necessary security filters either at project/group/report level. DataReader, Dataset objects were used to store data in-memory and display teh data on teh User interface.

Environment: MicroStrategy 8, SQL Server 2005, Oracle 9i, Windows XP Professional, Quality Center, Informatica

Confidential, Dallas, TX.

MicroStrategy Consultant

Responsibilities:

• Modeled teh Metadata by applying dimensional modeling principles.
• Implemented a 3-tier reporting architecture using MicroStrategy Intelligence Server with star schema to fit reporting, query and business analysis requirements.
• Developed schema objects (facts, attributes, hierarchies, transformations).
• Created teh Metadata and Statistic tables for teh project on Oracle database.
• Implemented security for different users to view reports for their regions using security filters.
• Checked teh data from teh database for quality and integrity.
• Created all required public objects; Reports, metrics, filters, prompts.
• Implemented MicroStrategy application interfaces to send personalized business intelligence information and reports.
• Troubleshooting operational and data issues.
• Developed dashboards/ scorecards for quick and easy visualization.
• Designed Scorecards and Dashboards using MicroStrategy Report Services.
• Wrote PL/SQL scripts and loaders to load data to teh data warehouse.
• Analyzing and developing new objects in Test environment and after testing teh objects and reports, migration to Production Environment.
• Created queries to conduct market basket analyses that help plan display layouts.

Environment: MicroStrategy 7.5.0, DataStage 6.2, Teradata V2R5, Windows 2000/NT, PL/SQL, SQL, SQL*PLUS.

Confidential 

Jr.Oracle Developer

Responsibilities:

• Created database for production environment In Oracle.
• Designed and developed various types of forms, indexes and reports.
• Developed stored procedures and database triggers using PL/SQL.
• Developed Reporting and Trending like mean time trouble report by site and by Location and other regulatory reports of Customer Case Management.
• Written stored procedures, Functions and Package to implement business rules using SQL and PL/SQL.
• Customized and maintained several Forms and Reports.
• Developed database tables/views for designing teh database using primary keys and foreign keys.
• Responsible for extensive data validations, feeding of live data and user acceptance for each module.
• Written SQL scripts during implementation at teh client's place and trained teh end users.

Environment: Windows 2000/NT, PL/SQL, SQL, SQL*PLUS.