We provide IT Staff Augmentation Services!

Sr. Microstrategy Analyst Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Around 8 years of total IT experience in software development, designing and implementing Web based and Stand alone software application with major focus on Data Warehousing and Database Applications.
  • Extensive experience on MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy 6.X/7.X/8.X, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
  • Experience in Performance Monitoring & Tuning for Oracle 9.x and MicroStrategy 8.X.
  • Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the datawarehouse.
  • Very strong in developing Proactive Delivery Reports and implementing business intelligence solutions on the web using MicroStrategy Narrowcast Server.
  • Expert in Creating MicroStrategy Reports, Generic cubes and implementing MicroStrategy projects.
  • Extensive work experience with Ad hoc reporting and standard reporting environment.
  • Strong hands on experience using TERADATA utilities ( SQL, FastLoad, MultiLoad, OleLoad, FastExport, Queryman / SQL Assistant, etc) and Unix Korn Shell scripting
  • Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
  • Experience in designing ETL process for Data warehousing using ETL tools Informatica PowerCenter and PowerMart 4.6/4.7/5.0
  • Experience in Designing and Modeling the Data for Data Warehouse using the different Data Modeling Tools Erwin 4.1.4, Rational Rose and have experience in UML as well.
  • Strong knowledge and understanding of SQL and ability to write SQL queries
  • Proficient in Analysis, Design and Development of applications using ORACLE, SQL Server, Teradata and MS Access as Backend and VB 5.0/6.0, Developer 2000 as a Front end.
  • Well - Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.
  • Have good knowledge and experience in Software Quality Assurance tested the web based applications and database application. Hands on experience in writing test Plans and test cases for testing team
  • Excellent Analytical, Programming, Written and Verbal Communication Skills. Aptitude for problem solving and making critical decisions on a short time frame.

TECHNICAL SKILLS:

Data Modeling: ERWIN Platinum 4.1.4 OLAP Tools MicroStrategy Suite 6.X/7.X/8.X, Administrator Object ManagerCommand Manager, Enterprise Manager, Intelligence ServerMicroStrategy Architect, Web Narrowcast Server Services, SchedulingSubscription Portal, User Personalization, Business Objects 5.1/4.x/3.x, Ab-Initio 2.8 .

OS: WINDOWS 95/98/NT/2000, U NIX & MAC 7.x

ETL TOOLS: Informatica (PowerMart1.5/1.6/5.1, PowerCenter 1.5/1.6/4.5/5.1 )

Databases: Oracle 7.x/8.0/9.x, MS SQL Server 6.5, Db2, MS Access 97/2000 Teradata V2R6 & Sybase.

IDE Tools: Visual Basic 5.0/6.0, Power Builder & Developer 2000.

Other: Crystal Reports 8.5, Brio query and Data reports.

Reporting Tools: Internet skills HTML, DHTML, XML, ASP 2.0/3.0, JavaScript 1.3 and VBScript

Langages: COBOL, C, Java, SQL, PL/SQL, T-SQL, UML

Web & Application: IIS 5.0/6.0, SMTP, Apache 1.3, BEA Web Logic 6.1

PROFESSIONAL EXPERIENCE:

Confidential

Sr. MicroStrategy Analyst

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.
  • Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
  • Created source and target definitions, mappings and transformation rules.
  • Transferred the data from a combination of different input files to Oracle using Informatica Power mart.
  • Identify Source tables and columns required to create a MicroStrategy project , which references Oracle data warehouse
  • Created and scheduled many sequential and concurrent batches to group the sessions to tune at the same time.
  • Generated SQL Loader scripts and Shell scripts for automated daily load processes.
  • 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: MicroStrategy 8.1.2, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy SDK, Crystal Reports, Informatica Power Center, TOAD, Oracle 10, Solaris

Confidential, Wood Cliff Lake, NJ

Senior MicroStrategy Analyst

Environment: Microstrategy 8.1.1, Administrator, Architect, Desktop, Web, Report Services Documents, Office, Narrowcast Server, Teradata

Responsibilities:

  • Gathering reporting and analytics requirements from the Sales and Marketing team for the data warehouse.
  • Analyzed the Sales Reporting Data Warehouse .
  • Created scope documentation for the static and ad-hoc reporting environment.
  • Creation of Database instance in Microstrategy.
  • Creating User and User groups using Microstrategy Administrator.
  • Creation of user groups in Microstrategy using User Manager.
  • Migration of the projects from Dev to QA and then to Prod Environment using Object Manager
  • Created Subscription sets, documents, publications and Personalized Services in process of configuring the Narrowcast application
  • Created Facts, Attributes, Transformations, Hierarchies using Microstrategy 8.1.1 Architect
  • Created advanced metrics, filters, consolidations and Custom groups using Microstrategy 8.1.1 Desktop.
  • Participated in requirements gathering for Enterprise Dynamic Dashboards for executives and created using Microstrategy 8.1.1 Report services.
  • Design and development of static and ad-hoc reports using Microstrategy 8.1.1 Desktop.
  • Validated end user report requests using Teradata SQL Assistant.
  • Participated in performance tuning of the MicroStrategy reports by analyzing the sql .
  • Power user training through Microstrategy Web.
  • Created Excel dashboards using Microstrategy Office tool.
  • Performed Power User training using Microstrategy Web and Desktop.
  • Participated in user acceptance testing phases at different levels of the project.

Confidential, Phoenix, AZ

Senior MicroStrategy Analyst

Environment: MicroStrategy 8.1 Administrator, Architect, Desktop, Web, Report Services Documents, Narrowcast Server, Oracle 10i, TOAD 8.0.

Responsibilities:

  • Participated in the design/development life cycle process including gathering requirements, user interaction and report design and development along with the ETL team
  • Identifying and documenting all the Source tables and columns required to create project in MicroStrategy
  • Participated in the meetings for Proof of Concept with Natezza.
  • Used Web Customization upgrade utility tool in Microstrategy SDK.
  • Adding required tables to the project using Data Warehouse Catalog
  • Created Facts, Attributes, Hierarchies and Transformations using Microstrategy 8.1 Architect
  • Created Advanced Metrics, Filters, Prompts, Reports and Dashboards using MicroStrategy Desktop 8.1
  • Created Enterprise Dynamic Dashboards using Microstrategy 8.1
  • Created complex Micro Strategy Documents involving Grids and Graphs
  • Created/Modified Users, User groups and Database Instances using Microstrategy Administrator
  • Created complex Data marts and enhancing the query performance by creating indexes
  • Tuned the VLDB properties to enhance the performance of the reports at project level and report level
  • Power User training using Microstrategy Web and support with the Microstrategy Objects and best practices in Reporting
  • Participated in the meetings for Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse
  • Interacting with business users during the UAT process

Confidential, Columbus, OH

Senior MicroStrategy Consultant

Environment: MicroStrategy 8.0.2 Architect, Desktop, Web, Report Services Documents, Teradata v2r6, SQL Queryman 7.1.

Responsibilities:

  • Meetings with business users to discuss system and reporting requirements and provided recommendations.
  • Preparation of Functional Build Documentation
  • Data modeling, logical database design, system architecture during all project implementation phases
  • Created Facts, Attributes, Hierarchies and Transformations using Microstrategy 8.0.2 Architect
  • Design and development of numerous static and ad-hoc reports using Microstrategy 8.0.2 Desktop, Web and Report Services
  • Creating User groups using Microstrategy Administrator.
  • Creating Database Instances for Development and Testing Environments in TeraData using Database Instance Manager.
  • Providing plan for testing team and participated in Unit Testing
  • End user training and power user support and answering user's technical questions
  • Successful migration of the project from Development to QA and the Production Environment using Object Manager
  • Extraction, Transformation and Load was performed using Data Stage to build the data warehouse

Confidential, Los Angeles, CA

Senior MicroStrategy Developer

Responsibilities:

  • Involved in the business interaction with the users and gathered the reports that needed to be exist in the Project.
  • Created the technical specification for the reports for the user acceptance.
  • Used the Configuration Wizard to configure the Metadata Repository and Setup the Intelligence Server.
  • Used MicroStrategy Architect to create Facts, Attributes, Relationships and Hierarchies.
  • Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Used MicroStrategy Desktop to generate Advanced Reports.
  • Created Consolidations, Custom Groups and Prompts for the reports.
  • Worked on the performance tuning of the MicroStrategy reports.
  • Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
  • Used MicroStrategy Administrator for accurate information regarding system usage and performance.
  • Extraction, Transformation and Load was performed using Informatica PowerCenter to build the data warehouse .
  • Designed database schemas for OLAP warehouse databases.
  • Created/enhanced catalogs and set user profiles to grant user permissions for querying.
  • Validated end user report requests using SQL and MicroStrategy tools.
  • Used PL/SQL procedures in different places.
  • Created reports in HTML format for easy navigation of data from web browser.

Environment: : MicroStrategy 8.0 Administrator, Desktop, Architect, Web, Intelligence Server, Administrator and Object Manager, Narrowcast Sever, Informatica PowerCenter, Db2, Oracle 9i, Embarcadero Rapid SQL 7.3 , PL/SQL, Teradata, Windows XP Professional, Unix, SMTP, IIS, Erwin 4.1.4

Confidential, Denver, CO

Senior MicroStrategy Developer

Responsibilities:

  • Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
  • Created complex reports using MicroStrategy 7.5.2.
  • Created facts, dimensions, and attributes using Microstrategy Architect.
  • Created new users and groups and moved report objects under one user, using Object Manager.
  • Created metrics, filters, and templates for the reports.
  • Generated report for web-based query using MicroStrategy Web.
  • Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
  • Worked on the performance tuning of the MicroStrategy reports.
  • Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
  • Used MicroStrategy Administrator for accurate information regarding system usage and performance.
  • Extraction, Transformation and Load was performed using Informatica PowerCenter to build the data warehouse .
  • Designed database schemas for OLAP warehouse databases.
  • Created/enhanced catalogs and set user profiles to grant user permissions for querying.
  • Validated end user report requests using SQL and MicroStrategy tools.
  • Used PL/SQL procedures in different places.
  • Created reports in HTML format for easy navigation of data from web browser.

Environment: MicroStrategy 7.5/8.0 Administrator, Desktop, Architect, Web, Intelligence Server, Administrator and Object Manager, Narrowcast Sever, TOAD, Informatica PowerCenter, Oracle 9i, Teradata, SQL Server 2000, PL/SQL, Windows 2000 Server, Unix, SMTP, IIS, Erwin 4.1.4.

Confidential, Hercules, CA

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 FastExport utility.
  • Experience in using Teradata utilities such as Fastload, Multiload and FastExport.
  • 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 7.5.2, MicroStrategy Agent 7.5.2,MicroStrategy Intelligence Server7.5.2, MicroStrategy Web 7.5.2, MicroStrategy Narrowcast Server 7.5.2, MicroStrategy SDK 7.5.2, Teradata, SQL, FastLoad, MultiLoad, FastExport, TPump, Visual Explain , Crystal Reports, ERWIN 4.1.4, Db2, Oracle 8i, Windows 2000 Server, Toad 8.5.

Confidential, Atlanta, GA

MicroStrategy Consultant

Responsibilities:

  • Involved in the complete Life cycle of the Project.
  • Participated in the end user meetings to obtain the business requirements for creating reports.
  • Involved in the data analysis .
  • Used the Project Creation Wizard to create Facts and Attributes and used the respective editors to enhance them.
  • 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
  • Created Advanced Reports in grid mode and graph mode using MicroStrategy Desktop.
  • Worked extensively in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, access controls Lists.
  • Taking regular Back ups 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 ad-hoc report by drilling up, down, within and across dimension or anywhere.
  • Created Customized Hierarchy for Drill Maps .
  • Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
  • Used Report cache sharing and Data mart reports to enhance the Report response time.

Environment: MicroStrategy 7i (Desktop, Administrator, Intelligence Server, Web), MicroStrategy Architect 7i, MicroStrategy Agent 7i, MicroStrategy Object Manager 7i, Teradata V2R3, SQL Server, Windows NT

We'd love your feedback!