SUMMARY

• 7 Years of IT experience in performing as a MicroStrategy Developer, MicroStrategy Architect, MicroStrategy Administrator, BI Reporting and Business Intelligence solutions.
• Good knowledge in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.
• Experience in Architecture process creating Schema objects with MicroStrategy Desktop like simple and compound Facts, Attributes, Fact extensions, Hierarchies, Transformations.
• Worked on performance tuning of various MicroStrategy Reports in MicroStrategy Desktop by tuning the VLDB properties and by various design techniques.
• Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, Performance Monitoring, Assigning Privileges and Job Monitoring.
• Experience in working with MicroStrategy Security model including Users, Groups, Security Roles and Security filters.
• Configured Integrity Manger and Object Manager.
• Adept in Dash Boarding and Documents, worked extensively on panel stacks, widgets, and customized the web.
• Installed and configured Intelligent Server and Narrowcast Server to Schedule, Execute and Deliver Reports using various delivery methods like file and emails.
• Good Understanding of Intelligent cubes OLAP, MOLAP, Multi Dimensional Models and Data mart design.
• Familiar with Data Management Systems - SQL Server 2000/2005/2008, Oracle 9i/10g
• Experience in translating business requirements into logical dimensional models.
• Extensive back ground and knowledge of Stored Procedures, Triggers, Functions, and Transact SQL.
• Created Test Reports, Involved in the Analysis, Design and Development phases. Designed all the Master and Master - detail templates
• Handled responsibilities including Requirement analysis, Client interaction, Specs allotment.
• Self-starter and quick learner with proven analytical, technical, and communication skills. Very resourceful in problem solving.
• My professional interests include project management; systems integration, design and development, usability and information architecture for websites and database applications.

TECHNICAL SKILLS

BI Tools: MicroStrategy 9/8.x/7.x, Desktop, Web, Architect, Narrowcast Server, Object Manager, Project Merge, Integrity Manager, Dashboards and scorecards. Query Builder and Command Manager: (Used Saved Scripts commonly used like purging caches, checking the active users, connecting and disconnecting from database instances)

Data Modeling: Microsoft Visio 2000/2003/2007, ERwin

ETL Tools: Informatica Power Center 8/9 (Knowledge in creating a Repository Folder, Source, Target and Mapping)

DBMS: Oracle 11g/10g, DB2, MS SQL Server 2000/2005/2008, Microsoft Access 2003/2007, Netezza 5.0/6.0, Teradata 13/14.

Management Tools: Microsoft Project 2003/2007

Web Technologies: Microsoft Expression Web 2.0/3.0, Adobe Dreamweaver CS4, Swish 2.0 (Flash)

Programming Languages: SQL, HTML, DHTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

MicroStrategy Consultant

Responsibilities:

• Participated in BI team meetings to discuss the user requirements.
• Reviewed of the requirement specifications and preparation of documents.
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Extensively worked and developed Attribute, Metrics, Report Templates, Filters, Prompts to give Decision makers a handy tool to choose the criteria for reports and view information in different perspectives.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards.
• Worked in conjunction with other developers and collaborate on design, code, and issue resolutions.
• Performed unit and integration testing.
• Delivered development tasks while meeting tight deadlines and resolved bugs/break fixes.
• Customized existing Reports/Custom Groups and Schema Objects whenever required.
• Used Advanced Prompts, Conditional, Transformation metrics and Level metrics for creating complex reports.
• Have a very good knowledge of all the features of MicroStrategy 9.4.1 (MicroStrategy Visualization; MicroStrategy Dash boarding; MicroStrategy Reporting).
• Involved in the business processes for understanding, developing, and finalizing the data requirements.
• Tuned and configured existing projects, reports and metrics through VLDB properties.
• Performed system checks like licensing, functionality, managing user privileges of the system.
• Added new users to groups and assigning them security privileges.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Worked efficiently both in a team environment and alone and unsupervised.
• Experience in Project Documentation, performance tuning and production support for major releases.
• Mentored business staff so that they can achieve self-service using the developed MicroStrategy platform components.
• Ability to thrive in a fast-paced and changing environment.

Environment: MicroStrategy 9.4.1 HF4, Oracle 11G, Informatica 9.5

Confidential, West Chester, PA

MicroStrategy Consultant

Responsibilities:

• Participated in BI team meetings to discuss the user requirements.
• Review of the requirement specifications and preparation of documents.
• Extensively worked and developed Attribute, Metrics, Report Templates, Filters, Prompts to give Decision makers a handy tool to choose the criteria for reports and view information in different perspectives.
• Worked in conjunction with other developers and collaborate on design, code, and issue resolutions.
• Performed unit and integration testing.
• Delivered development tasks while meeting tight deadlines and resolved bugs/break fixes.
• Customized existing Reports/Custom Groups and Schema Objects whenever required.
• Used Advanced Prompts, Conditional, Transformation metrics and Level metrics for creating complex reports.
• Have a very good knowledge of all the features of MicroStrategy 9.4.1 (MicroStrategy Visualization; MicroStrategy Dash boarding; MicroStrategy Reporting).
• Involved in the business processes for understanding, developing, and finalizing the data requirements.
• Tuned and configured existing projects, reports and metrics through VLDB properties.
• Performed system checks like licensing, functionality, managing user privileges of the system.
• Added new users to groups and assigning them security privileges.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Worked efficiently both in a team environment and alone and unsupervised.
• Experience in Project Documentation, performance tuning and production support for major releases.
• Mentored business staff so that they can achieve self-service using the developed MicroStrategy platform components.
• Ability to thrive in a fast-paced and changing environment.

Environment: MicroStrategy 9.4.1, Netezza 6.0, Informatica 9.5, IBM AIX 7.1

Confidential, Baltimore, MD

MicroStrategy Consultant

Responsibilities:

• Participated in BI team meetings to discuss the user requirements.
• Determining the source table and columns required to make a Microstrategy Schema Objects.
• Provided expertise in architecting MicroStrategy metadata and schema objects whenever required.
• Worked on Low Level Design and Requirement Specification Documents.
• Extensively worked and developed Metrics, Templates, Filters to give Decision makers a handy tool to choose the criteria for reports and view information in different perspectives.
• Worked with MicroStrategy Architects Editor to map the attributes based on the data model.
• Have a very good knowledge of all the features of MicroStrategy 8.x, 9.x.
• Used Level metrics for satisfying aggregations on reports.
• Involved in the business processes for understanding, developing, and finalizing the data requirements.
• Assisted in functional and system testing of integrated reporting applications, Dashboards, Promotes and ensures appropriate use of the MicroStrategy tool
• Tuned and configured existing projects, reports and metrics through VLDB properties.
• Performed system checks like licensing, functionality, managing user privileges of the system.
• Added new users to groups and assigning them security privileges.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.

Environment: MicroStrategy 9.2.1, Teradata 13/14, Informatica 9.0.1.

Confidential, West Chester, PA

MicroStrategy Consultant

Responsibilities:

• Participated in BI team meetings to discuss the user requirements.
• Review of the requirement specifications and preparation of documents.
• Experience importing Warehouse tables, Facts, Hierarchies, Attributes, Metrics, filters, Prompts, Hierarchy elements, consolidations and Custom Groups.
• Worked on Advanced MicroStrategy Reporting techniques such as Interactive Dashboards, Visualization techniques.
• Developed documentation required to support the development life-cycle of the MicroStrategy reporting project.
• Used Advanced Prompts, Conditional, Transformation metrics and Level metrics for creating complex reports.
• Involved in the business processes for understanding, developing, and finalizing the data requirements.
• Tuned and configured existing projects, reports and metrics through VLDB properties.
• Performed system checks like licensing, functionality, managing user privileges of the system.
• Added new users to groups and assigning them security privileges.
• Worked with the MicroStrategy Administration team to ensure successful promotion of objects in various environments.
• Assists in testing and validation of the MicroStrategy environment during the server upgrade process

Environment: Netezza 5.0, MicroStrategy Desktop 9.2.1, Informatica 9.0.1, IBM AIX

Confidential, MD

MicroStrategy Developer

Responsibilities:

• Developed new reports and modified existing reports for the business line to satisfy the specifications.
• Created Ad hoc reports.
• Assisted in creation of schema objects like attributes and Hierarchies.
• Have a very good knowledge of all the features of MicroStrategy 8.x, 9.x.
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Have a very good knowledge of all the features of MicroStrategy 9.x.
• Tuned and configured existing projects, reports and metrics through VLDB properties.
• Performed system checks like licensing, functionality, managing user privileges of the system.
• Added new users to groups and assigning them security privileges.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Created reports with various Object prompts to generate various Ad hoc reports.
• Took help of MicroStrategy Knowledgebase to troubleshoot some Report related issues.
• Developed Attribute filter prompts to give end users a choice of different filtering criteria each time they run the report.
• Created Report Templates for consistency in the look and feel of the reports
• Created Hierarchies for providing drill down options for the end-user through MicroStrategy Web.

Environment: MicroStrategy Architect, MicroStrategy Desktop 9/8, MicroStrategy Web 9/8, Oracle 11g, Informatica Designer 8.x, Solaris

Confidential

SQL Developer/ MicroStrategy Developer

Responsibilities:

• Participated inBI team meetings to discuss the user requirements based on the current system.
• Prepared theSystem AnalysisandGap Analysisdocuments.
• Prepared theMapping Documentdetermining the source table and columns required to make to replicate the current systems and the required MicroStrategy Schema Objects.
• Worked onLow Level DesignandRequirement Specification Documents.
• Extensively worked and developed Metrics, Templates, Filters to give Decision makers a handy tool to choose the criteria for reports and view information in different perspectives.
• Worked with MicroStrategy Architect Editor to map the attributes based on the data model and setup the parent-child relationship accordingly in MicroStrategy.
• Assisted in testing and validation of the MicroStrategy environment during the server upgrade process.
• Assisted the company withmigratingfromMSSQLServer2000toSQL Server 200564-bit Edition.

Environment: MicroStrategy 8.x, Informatica 8.1, Linux Solaris,SQL Server 2000/2005