SUMMARY

• 7+ years of IT experience in Implementation of Microstrategy Suite, Reporting services, OLAP environments and tools, along with strong analytical skills.
• Experienced in MicroStrategy Desktop/Developer, MicroStrategy Architect, MicroStrategy Administration, MicroStrategy Advanced report development and MicroStrategy Intelligence Server.
• Strong working knowledge of MicroStrategy Intelligence Server, MicroStrategy Desktop and MicroStrategy Web in developing the system as well as in maintaining it at the enterprise level as a MicroStrategy Administrator.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions
• Extensively worked on creating and integrating MicroStrategy reports, and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.).
• Created various Schema objects with MicroStrategy Desktop like simple and Compound Metrics, Fact Extensions and Hierarchies, etc.
• Experience training non - technical users and providing customer support.
• Experience in creation of Dashboards which helps in better understanding of the Business trends.
• Set up the initial metadata by creating Schema Objects and Application Objects.
• Designed and deployed customized reports and Documents into MicroStrategy web
• Good understanding of MicroStrategy Metadata tables.
• Expertise in using the Erwin and ER Studio data modeling tools.
• Experience working withAd-hoc reporting.
• Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Exposure to client interaction, user-requirement analysis and User support.
• Quick learner, ability to work in groups or alone, ability to work on tight schedules.
• Excellent team player with good analytical, communication and interpersonal skills.

TECHNICAL SKILLS

OLAP Tools: MicroStrategy 9.x/8.x/7.x (Administrator, Desktop, Web, Architect), Intelligent Server, Narrowcast Server, SSRS

Programming: C, PL/SQL, Java Script.

Web Technologies: HTML, XML, CSS

Data Modeling: ER Studio 8/7.x, Erwin Data Modeler, MS Visio

Databases: Oracle8i/9i, SQL Server, Teradata.

Applications: MS Office (Access, Word, Excel), Rational Rose

Operating Systems: Mac OS X 10.8/10.7/10.6 , Windows 7/Vista/XP/NT/98/95, MS-DOS, LINUX

PROFESSIONAL EXPERIENCE

Senior Microstrategy Developer

Confidential, Seattle, WA

Responsibilities:

• Installation of Microstrategy Desktop and creating a Microstrategy project.
• Create Attributes, Facts and relationship between attributes using Microstrategy Architect.
• Used Warehouse catalog to import tables and Created Logical Tables.
• Generated and implemented Microstrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using Microstrategy Architect.
• Advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters were used in developing complex reports.
• Transferred the objects from one environment to another environment using administrator tools like Project Merge and Object Manager.
• Created relationship between attributes and also defined Drill Hierarchies.
• Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
• Created reports using complex filters and compound metrics and prompts.
• Creating reports from intelligent cubes, Datamart Reports.
• Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enable Dynamic Sourcing for specific cubes.
• Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
• Involved in creating security filters to end users to access data based on their privileges.
• Created services using Subscription sets, Schedules, and Information Objects.
• Designed and developed the Dynamic dashboards.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.

Environment: Microstrategy 9.2.1, Report Services, Microstrategy Desktop, Microstrategy Web, Mobile, Microstrategy Dashboards, Oracle 9.1, Oracle 10G, SQL, MS-Excel, Toad.

Senior Microstrategy Developer

Confidential, Amarillo, TX

Responsibilities:

• Worked with business analysts to baseline the reporting requirements.
• Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI Layer.
• Worked with data architects on data needed for testing the reports and dashboards.
• Extensively worked with Microstrategy architect to develop schema objects such as attribute, facts, hierarchies, consolidations and transformations etc.
• Extensively used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups.
• Createddrill mapsfor end users to drill down and recover data.
• Extensively worked with Microstrategy Intelligence Server, MicroStrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Designed and Developed Microstrategy Dashboards using customized Widgets.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
• Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for the desired look and feel.

Environment: Microstrategy 9.0.2 (Administrator, Architect, Desktop, Web), Teradata V2R5, SQL, Windows XP, MicroStrategy Dashboard.

Microstrategy Developer

Confidential, MA

Responsibilities:

• Developed and Analyzed Application Objects (Metrics, Reports, Filters, Documents, Prompts) using the MicroStrategy Desktop and MicroStrategy Web interfaces.
• Expertise in creating logical data models by recognizing the source tables and columns, to build Attributes Facts, Hierarchies and Relationships that are necessary to create a MicroStrategy project.
• Developed multiple complex reports using Derived metrics, Compound metrics and Filter in a metric to meet the requirements.
• Created new Facts, Attributes and attribute form expressions and Hierarchies as needed in the project.
• Developed Transformations (table based, formula based) to be used for comparative analysis like claims this year to last year (year to date and month to date).
• Extensively created Custom groups and Consolidations to meet the requirements.
• Optimized the Intelligence Server for better performance.
• Created Dynamic dashboards with visual insight to improve marketing by product, customer, geographic and promotion analysis.
• Hands on experience in Performance Tuning of the tool and also modifying VLDB properties to achieve maximum performance.
• Used Narrowcast Server to create various Services, Information Objects, Imported Objects and Static Subscriptions and used ETL sync mechanism to send reports based on data load completion.
• Created narrowcast services to email /send to a directory either report service documents in PDF or excel files

Environment: MicroStrategy Desktop 8.1.1, MicroStrategy Intelligence Server, MicroStrategy Web

Microstrategy Developer

Confidential, Norwalk, CT

Responsibilities:

• Creating Views in the database and Logical Views in the MicroStrategy.
• Extensively worked with MicroStrategy Desktop.
• Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
• Worked on creating MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Developed, implemented and maintained unit tests for applications.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Tuning of the MicroStrategy Reports using Data Mart Reports, Aggregatable Tables, and Intelligent Cubes.
• Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enable Dynamic Sourcing for specific cubes.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Expertise on Partition Mapping concept in Microstrategywhich will improve the performance.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
• Expertise in developing the dashboards and having goodknowledge in using widgets and all components of dashboards.
• Proficient in creating the Drill and User Hierarchies.
• Having knowledge in developing the Expression and Table based Transformations.
• Expertise in creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.

Environment: Microstrategy 9.01 (Administrator, Architect, Desktop, Narrowcast Server) MicroStrategy Narrowcast server, Windows XP, MicroStrategy Dashboard

MicroStrategy Developer

Confidential

Responsibilities:

• Developed most of the Schema Objects such as the Tables, Facts, Attributes, Hierarchies and Transformations.
• Involved in development of the Public Objects such as Filters, Prompts, Metrics, Templates, Drill maps necessary for producing the Client Reports and Scorecards.
• Extensively worked on building all the Scorecards and Dashboards using MicroStrategy Report Services.
• Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment.
• Used MicroStrategy Report Services to generate Report Documents.
• Taking regular backups of the Production Metadata in SQL Server Database.
• Created advanced grid reports, consisting of data analysis by combining a template with filters.
• The end-users were able to generate an ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Responsible for the listing up of Object Manager sheets and worked closely with the COE during code migrations from Development to UAT and from UAT to Production.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services.
• Played major role in MicroStrategy Desktop, Web and Narrowcast Server configurations.
• Extensively worked to develop Free Form SQL reports for transactional analysis requirements.
• Extracted and analyzed data from the database using SQL to troubleshoot reports as needed using MicroStrategy ODBC Test tools.
• Solely and successfully developed the data model (snowflake) for one of the internal project using Erwin.

Environment: MicroStrategy 7.1.0/8.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Oracle, Toad, Windows NT.

Microstrategy Developer

Confidential

Responsibilities:

• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Create connection maps to map users to different homogeneous databases or table spaces in a single project to direct end users against production and power users against development database.
• Designed, Developed and altered HTML document objects by placing multiple reports on it in Grid as well as Graph View applying XSL formatting for each in the process of automating IT Dashboard reports.
• Installed and configured complete MicroStrategy product suite on Prod, Dev and RE&I Lab environments.
• Personalize the end user experience at report runtime by providing flexibility with reusable prompts/report parameters
• Actively involved in the Implementation of Novell LDAP authentication for MicroStrategy Products.
• Extensively used Object Manager, Project Merge and User Merge utilities to manage MicroStrategy Tier 1/ High Impact applications and objects.
• Responsible for creating the MicroStrategy DB instances, DB connections, DB logins and ODBC DSNs.
• Actively involved in the full life cycle of Migration process from MicroStrategy v7.2.3 to MicroStrategy V7.5.1
• Actively participated in the proof of concept for the MicroSrategy v8.01 upgrade.

Environment: MicroStrategy tool suit 7.2.3/7.5.1/8.0 , MicroStrategy Office 7.5.1,Windows 2000