Sr. Microstrategy Analyst Resume
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