Summary

• 6+ years of strong experience in Business Intelligence in designing and implementing Web based and Stand alone software application with major focus on Data Warehousing and Database Applications.
• 5 years of extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.i/7.5/8.0/8.1/9.0/9.0.1, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
• Expertise in Desktop creating and integrating Microstrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations
• Worked extensively on VLDB Properties for performance tuning.
• Extensively worked on creating Dynamic Dashboards with multi layout and used custom Widgets built on flex for specialized dashboard.
• Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations.
• Strong Data modeling (Logical and Physical) experience with high proficiency in using ERwin for Dimensional Modeling (Star, Snowflake schemas) and Entity-Relationship Modeling.
• Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• Extensive knowledge of SQL,PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2005/2008

Eduaction – Bachelor of Mechanical Engineering

SKILL SET:
OLAP Tools : Microstrategy, Business Objects, MS Analysis Services, Informatica
Databases : Oracle 8i/9i/10g,Teradata,Netizza MS SQL Server 6.5, Db2 and MS Access 
Tools : Toad, Erwin
Operating Systems : Windows NT 4.0 /NT Server/2000/XP Pro/2003 Server, Unix
Languages : Visual Basic 6, C, SQL/PLSQL

Confidential, Grand Rapids, MI Oct’10 – Till date 
Sr. MicroStrategy Developer

Responsibilities:

• Involved in the documentation of technical specifications of the Sales and Inventory Project.
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Created different Project Sources for different environments like production, testing and development.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, Information objects.
• Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that particular user.
• Worked on the excel formatting, macros and templates of the documents which are used in different services.
• Exported data from Teradata using Fast Export utility.
• Experience in using Teradata utilities such as Fastload, Multiload and Fast Export.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.0/9.0.1 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Teradata, Narrowcast Server, Oracle 9i, Informatica power center 6.2, Toad and Windows XP Professional.

Confidential, Grand Rapids Nov’09 – Sep’10 
Sr. MicroStrategy Developer

Responsibilities:

• Involved in design/development life cycle including gathering requirements ,user interaction and report design and development
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
• Created report services documents for guest count and Sales analysis.
• Developed a web course and took several classes to train the end users to efficiently use MSTR.
• Created several data marts using MSTR for different tools to access large datasets.
• Involved in Upgrade of MicroStrategy environment from 8.1 to 9
• Created Subscription sets, documents, publications and services for delivery of reports through Narrowcast.
• Validated end user requirements using Microstrategy tools.
• Created Question Objects for Personalized execution.
• Extensively involved in Troubleshooting of Narrowcast services delivery.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
• Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Worked with the DBA on issues of database performance and security.
• Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
• Involved extensively in the overall lifecycle of the Data Warehouse integration project

Environment: MicroStrategy 9/8.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), SQL Assistant, SQL Server, Oracle 10g

Confidential, Ann Arbor, MI Mar’08 – Oct ’09
Microstrategy Consultant

Responsibilities:

• Responsible for gathering and refining business requirements from the Business users.
• Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies
• Responsible for creating Metrics, Filters, Custom Groups, Prompts using Microstrategy Desktop
• Configured the Narrowcast Server for the Microstrategy Environment
• Used the Narrowcast Administrator for administering users.
• Created the Publications, Information Objects & Services in the Narrowcast application
• Created Users, roles & privileges in the Microstrategy Environment using the Administrator
• Responsible for maintaining I server.
• Troubleshooting inconsistencies in the Metadata using ScanMD
• Used the Object Manager to migrate objects to different environments.
• Worked on cost containment dashboard project for executive users to see penetration, discounts and performance.
• Worked on Internet Dashboard project which points to operating system for real time analysis report on claim process.
• Heavily worked with the end users to finalize the Dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Involved in Testing and Data validation of Reports
• Involved in End-User training, Support and Maintenance.
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment
• Very good in using the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary.
• Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, week to year and effectively used them with the metrics.
• Optimized Query Performance by using VLDB settings
• Involved in Business Intelligence tool Product Evaluation
• Worked on standardizing Microstrategy environment
• Responsible for Job Monitoring and maintaining the cache on the I Server

Environment: Oracle10g, SQL server, Informatica, MicroStrategy 8.0.2(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Toad 8.6.1

Confidential, Hercules, CA Nov’07 – Feb’08 
Senior MicroStrategy Developer

Responsibilities:

• Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
• Generated status reports after performing thorough research in order to discuss the issues related to Warehouse tables, Zeroes/Nulls, missing columns and naming conventions etc.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Used project merge wizard and user merge wizard to merge projects and merging users & groups in Object Manager.
• Created Transformations (table based, formula based) for using in comparative reports like sales of various pharmaceutical products this year to last year (year to date and month to date).
• Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment.
• Converted existing interactive reports with prompts to non-prompted reports for Narrow casting.
• Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Exported data from Teradata using Fast Export utility.
• Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.
• Involved in creating user groups and security filters for users and assign privileges.

Environment: MicroStrategy 8.0.3/8.1(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata V2R6, Teradata SQL Assistant, SQL Server, Brio. Cognos, Crystal Reports, Oracle 10g, Informatica

Confidential, Scottsdale, AZ Jan’07 – Oct ’07 
MicroStrategy Report Developer/ Quality Analyst

Responsibilities:

• Created users, roles & privileges in the Microstrategy Environment
• Collected business requirements from users by understanding the Source System (OLTP) and interacting with the users
• Responsible for maintaining the Intelligence Server including the Metadata repositories for different environments
• Was responsible for troubleshooting the I Server issues.
• Responsible for setting the Microstrategy Environment for any Proto type projects
• Responsible for scheduling the user jobs, creating schedules for both Web & Narrowcast modules
• Performed complete production support for the Microstrategy Environment, maintaining I server, weekly reboots of the I server etc
• Responsible for maintaining the Microstrategy Web Servers
• Configured the Intelligence Server settings, setting up the DSN Connections
• Extensively used Object Manager to migrate objects from DEV to QA & Production
• Was responsible for setting up the Narrowcast Server environment, configuring the execution engine etc
• Was responsible for Job Monitoring and maintaining the cache on the I Server

Environment: Microstrategy7.5/8.0 (Desktop, Administrator, Intelligence Server, Web), Informatica5.0, SQLServer2000, Teradata V2R5,Windows NT 4.0

Confidential, Los Angeles, CA Aug’06 - Dec’07
Microstrategy Consultant

Responsibilities:

• Involved in Data Modeling and Data Warehousing Using Multi Dimensional Model, Star and Snow Flake Schemas.
• Identified and defined Facts, Attributes, Hierarchies and Relationships.
• Running Scripts for building Metadata and define the lookup and facts tables for use in the MicroStrategy Agent.
• Using MicroStrategy Agent (Templates, Filters, Metrics) to generate advanced reports in grid, graph, and SQL mode, consisting of data analysis by combining a template with filters. The end users were able to generate ad hoc report by drilling up, down, within and across dimension or anywhere.
• Enterprise manager was used to validate the data presented in the desktop.
• Various queries were written for optimization, exploited the indexing
• With SQL Server 2000 different features were used like user-defined functions, enhancements to triggers, cascading constraint capabilities, indexed views and view enhancements, updateable union views called distributed partitioned views, support for collations, extensions to property definitions, new built-in functions.
• Developed PL/SQL Business Functions, which were used with MicroStrategy Reports.
• Created MicroStrategy Filters, Prompts, Drill Maps, Transformations, Documents, Facts, Attributes, Hierarchies etc. for Developing Project.
• Creating complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality and conditional, generating Data Marts with per and post SQL for the Data Mart Tables.
• Creating all possible Metrics for users to build there owns reports on Web by creating there own Templates and filters and use the available Metrics.
• Using Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
• Designed and developed Web Reports and worked in MicroStrategy Web Customization
• Caching Reports in the Intelligence Server daily, enabling user to run the report immediately.

Environment: MicroStrategy 7.2.1/7.5 (Desktop, Administrator, Intelligence Server, Web), MicroStrategy Architect 7.2.1, SQL Server 2000, ODBC Driver 8i, Windows NT 4.0.