SUMMARY:

• Around 7+ years of experience in MicroStrategy 9.x/8.x.x and 7.x using MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, Microstrategy Web, MicroStrategy Administrator, MicroStrategy Report Services, Microstrategy Object Manager, Microstrategy Command Manager, Microstrategy Integrity Manger, MicroStrategy Dashboards and MicroStrategy Narrowcast Server and Microstrategy SDK.
• Attended few sessions by Microstrategy that describes the new features in Microstrategy 10.
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008, SSIS and SSRS 2008
• Expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies, Functions and operators
• Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates, Documents, Custom groups and Consolidations)
• Implemented proactive delivery reports and implemented the business intelligence solutions using MicroStrategy Narrowcast Server.
• Extensive experience in development of SQL Queries, Stored Procedures and Triggers.
• Experience in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Involved at all stages of the data warehousing project; setting up the schema and architecture, developing reports, security and deploying to end users. Strong familiarity with the Extraction Transformation and Loading (ETL) process.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
• Experience in MicroStrategy Web SDK for Authentication and GUI/Functional customizations.
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
• Created complex Reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
• Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Developed Query for generating drill down reports in Cognos Reports.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 9.x/8.x/7.x (Desktop, Architect, Web, Intelligence Server, Narrowcast Server, Object Manager).Microsoft OLAP Manager, Microsoft SQL Server Analysis Services, Business Objects, Microsoft Excel.

Relational Database: ORACLE 11g/10g/9i/8i, Teradata V2R4.1, SQL Server 6.5/7/2000, IBM DB2, MS Access 2000

Tools: and Packages

SQL Server Management studio, Toad, Profiler, Microsoft Visual StudioLanguages

SQL, PL/SQL, JavaScript, CSS, HTML, XML

Operating Systems: Windows 2000/2003, 2008 Server, Windows 95/98/2000/XP/7, UNIX, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

Microstrategy Architect/Developer

Responsibilities:

• Created dashboards collecting requirements from various directors of business, BA s and worked with database team.
• Created Schema Objects, Multi-level Dimensional metrics for inventory reports and dashboards for business.
• Worked on performance tuning of long running reports and optimized query using VLDB properties.
• Used Hints to reduce time based on the query plan.
• Worked on solving production issues.
• Worked in enhancing the performance of previous dashboards by decreasing the run time, datasets and redundancy.
• Used Object Manager for migrations between environments (DEV, VAL, PROD) .
• Hands on experience defining security filters, migration lists needed for migrations and documented all the migrations.
• Worked extensively on finance and inventory dashboards.
• Performed data migration using tools and between different heterogeneous systems and SQL Server.
• Created time-triggered schedules as per business requirements and aided business users.
• Created derived metrics from existing metrics (managed objects) and made them useful on the dashboard to decrease run time.
• Created many Freeform SQL reports and Adhoc reports for business users to view historical data.
• Used HTML/CSS contents on dashboards for attractive user interface.
• Worked with Microstrategy Support team to resolve issues for the business
• Created Metrics, prompts, Filters, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompts using MicroStrategy desktop for report development.
• Worked along with Microstrategy Knowledge Base to troubleshoot some Report.
• Combined a couple of dashboards with help of measures and made sure all the required information is present and thus decreased the number of datasets and dashboards
• Involved in customization of MSTR web dashboards.
• Involved in back end development of Oracle PL/SQL objects for report creation.

Environment: Microstrategy 9.4.1, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Provider, Oracle 11g.

Confidential, Dallas, TX

Sr. Microstrategy Developer

Responsibilities:

• Created various dashboards in interactive, flash mode for multiple projects collecting requirements from the team.
• Made changes to existing dashboards to meet user requirements and enhanced the performance of these dashboards.
• Built intelligent cubes and scheduled them accordingly for better performance of dashboards that were dependent on these cubes.
• Built dashboards that were visually appealing in flash mode.
• Developed requirement documents that were needed for reporting using Microstrategy which included various definitions and granularity level.
• Worked close with the database team to understand the data warehouse such that it helps during the creation of reports and dashboards.
• Worked on creating Microstrategy data model after gathering all the requirements.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and adhoc reports.
• Worked extensively on customizing and optimizing the query performance of reports for various users using MicroStrategy features like VLDB property and changing database properties like adding indexes, creating aggregate tables and partition strategies.
• Worked in executing SQL queries when there were errors in reports and tried to resolve the data gaps.
• Worked close with teams in SQL server integration and efficient with SSIS functionalities..
• Developed a couple of reports using Tableau and used the multi visualization feature it provides in report building.
• Involved in Performance tuning of SQL for long running reports
• Built various schema objects like attributes, facts and developed metrics, filters, prompts used for reports.

Environment: MicroStrategy 9.4.1, MicroStrategy Web, Microstrategy Intelligence Server, Microstrategy Object Manager, Windows XP.

Confidential, San Francisco, CA

MicroStrategy Architect

Responsibilities:

• Involved in meetings with Business team to discuss related issues and review of the Objects and reports.
• Documented all the baseline projects based on Visa Standards and created baseline standard documents
• Developed Schema Objects including attributes, facts, Hierarchies, Transformations.
• Extensively worked in developing Public objects including Metrics, Derived metrics, Compound metrics and Filters.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Designed report components, Templates and Filters to generate reports in grid and graph mode.
• Proficient in the use of majority of the SSIS transformations, Containers, Tasks, migration of data from various source DB’s like Sybase, MSSQL, Access, Excel, Flat File to SQL Server 2008, package configurations.
• Creation and Management of Logins, Users, Schemas and Permissions, Automation of SSIS package execution using SQL Server Agent Jobs, Database Backups and Restoration.
• Created Security Filters to be assigned to restrict the access of the Users.
• Extensively worked on creating Report Service documents using multiple Grids and Graphs.
• Extensively worked on creation of Dynamic Dashboards.
• Created Dashboards with Multiple Panels, Panel Selectors and Tabs.
• Used analytical and governing settings in VLDB properties to tune the SQL.
• Co-ordinated test plans and provided feature/functionality/usage scenarios for the Managers.
• Unit tested report layouts, validated the SQL query, prompt ordering & defaults, security filters, export/print functionality and drilling options.

Environment: MicroStrategy 9.0.2/8.1.1, Desktop Reports, Web Intelligence Reports, Administration, Dash Boards, Oracle 10g.

Confidential, Green bay, WI

MicroStrategy Developer

Responsibilities:

• Involved in the meetings with business users to discuss and finalize the requirements and design of the reports.
• Worked with the Data Modelers for creating the dimensional model based on the requirements.
• Designed, developed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Extensively created filters, facts, Consolidations, Transformations and Custom Groups.
• MicroStrategy Desktop to generate reports for the Business analysis.
• Created ad-hoc reports by drilling up, down, within and across dimensions.
• Created transformational metrics to compare monthly, quarterly and annual analysis.
• Created Dynamic Sourcing reports using intelligent cubes to boost the Dashboard Performance.
• Created Metrics, Filters, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompts using MicroStrategy for report development.
• Unit tested the reports developed by the report developers.
• Created documents for naming standards.
• Worked on Portal Integration by implementing Single Sign On using MicroStrategy Web SDK.
• Used Enterprise Manager to see the performance of reports and how different objects were being used by various users
• Organized training classes for in-house associates.
• Provided post production support to end-users.

Environment: MicroStrategy 9/8.1.1,Desktop Reports, Web Intelligence Reports, Administration, Dash Boards, Erwin, UNIX, Toad,Teradata V2R5, Oracle 10g, Windows 2000, MicroStrategy Web SDK.

Confidential, Columbus OH

BI Developer

Responsibilities:

• Identify Source tables and columns required to create a MicroStrategy project.
• Configured reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Created Metrics and filters for the reports.
• Employed MicroStrategy Desktop in designing the MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Proactively created report formats and delivered personalized messages from the Data warehouse through MicroStrategy Narrowcast Server to a wide range of users.
• 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.
• Used SDK for web customization.
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports.
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Created source and target definitions, mappings and transformation rules.
• Identify Source tables and columns required to create a MicroStrategy project, which references TeraData data warehouse
• Provided Data Access to executives, managers (Casual users) and Business Analysts (Power Users).
• Worked as a link between Business and Technical groups.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• Written complex stored procedures and triggers and optimized for maximum performance.

Environment: Microstratagy 8.0.2, MicroStrategy Agent, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Sever, MicroStrategy SDK, SQL Server 2005, Microsoft Business Intelligence Development Studio.

Confidential

SQL Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements & data specifications
• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Involved in logical modeling and physical modeling of the database.
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Implemented the business logic and processing of the payment by developing stored procedures and scripts.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Created complicated reports including sub-reports, graphical reports, formula based and well formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created Objects using different Business Objects functionalities like prompt in the process of designing the universes.
• Created Alerts in various reports according to user requirement.
• Used Broadcast Agent to schedule the reports depending on the user profile.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined Conditions to use in Business Objects.
• Involved in designing Business Objects Universes, Queries, and Reports.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.

Environment: Import Wizard, Repository, MS SQL Server 2000 Enterprise Edition, MS Access 2000, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, Crystal Reports 9.0.