We provide IT Staff Augmentation Services!

Sr Microstrategy Architect. Resume

Wood Cliff Lake, NJ

SUMMARY:

  • Around 12 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 7.X/8.X/9.X/10.X/11, Distribution Services, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
  • Experience in Performance Monitoring & Tuning for YellowBrick, BIG DATA, Netezza, DB2, Oracle 10.x and MicroStrategy 7.X/8.X/9.X/10.X.
  • Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
  • 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
  • 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:

MicroStrategy Certified: OLAP Tools MicroStrategy Suite 7.X/8.X/9.X/10.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

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: Big Data, Netezza, DB2, Oracle 7.x/8.0/9.x/10.X, MS SQL Server

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

Other: Tableu, 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 Architect.

Responsibilities:

  • Currently supporting the migration of Netezza database to Yellowbrick database and validate all the reports.
  • Currently working on upgrading MSTR version v10.4 to V11.
  • Interacted with Business Analysts, Business Users and Managers for g athering, analyzing, documenting business requirements, and functional requirements and data specifications .
  • Created Functional Requirement Document (FRD) and technical specifications for creating reports.
  • Involved in installation and configuration of MicroStrategy 10.4.
  • Involved in creation of Aggregate tables to improve performance of reports.
  • Used MicroStrategy Architect to create Facts, Attributes, Relationships, Dimensions and Hierarchies.
  • Involved in creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the MicroStrategy objects necessary for the deliverable.
  • Created transformational metrics (Volume and Counts) to compare monthly, quarterly and annual sales .
  • Extensively worked in developing Metrics, Derived Metrics, Compound Metrics and Filters for complex reports.
  • Creating advanced Metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
  • Involved in troubleshooting MicroStrategy Reports, optimizing SQL using the VLDB Properties.
  • Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
  • Created Dashboards in both the interactive & flash mode for Executive Mangers and Directors using Report Services.
  • Extensively worked on creating Report Services documents using multiple grids and graphs.
  • Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies .
  • Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
  • Involved in the creation of Adhoc and static Reports.
  • Involved in security setup and maintenance at all levels within the MicroStrategy tool.
  • Involved in optimization of code and tuning queries for performance.
  • Involved in managing and migrating objects across multiple environments using Object manager.
  • Involved in analyzing BI usage patterns and developed performance tuning strategies to deliver the highest BI satisfaction using Enterprise manager.
  • Involved in creating Security filters to end users to access data based on their privileges.
  • Provided post production support to end-users.

Environment: Netezza, DB2, Microstrategy 10.4 Product Suite (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Web, Distribution Services), Fusion Charts, Oracle 10 for MSTR Metadata, Windows NT.

Confidential

MicroStrategy Architect.

Responsibilities:

  • Interacted with Business Analysts, Business Users and Managers for g athering, analyzing, documenting business requirements, and functional requirements and data specifications .
  • Created Functional Requirement Document (FRD) and technical specifications for creating reports.
  • Involved in installation and configuration of MicroStrategy 9.0.1.
  • Created Star schema to develop the data mart in the data warehouse.
  • Involved in creation of Aggregate tables to improve performance of reports.
  • Used MicroStrategy Architect to create Facts, Attributes, Relationships, Dimensions and Hierarchies.
  • Involved in creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the MicroStrategy objects necessary for the deliverable.
  • Created transformational metrics (Sales, Sales Target, Market Share, and Growth) to compare monthly, quarterly and annual sales .
  • Extensively worked in developing Metrics, Derived Metrics, Compound Metrics and Filters for complex reports.
  • Creating advanced Metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
  • Involved in troubleshooting MicroStrategy Reports, optimizing SQL using the VLDB Properties.
  • Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
  • Created Dashboards in both the interactive & flash mode for Executive Mangers and Directors using Report Services.
  • Extensively worked on creating Report Services documents using multiple grids and graphs.
  • Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies .
  • Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
  • Involved in the creation of Adhoc and static Reports.
  • Involved in security setup and maintenance at all levels within the MicroStrategy tool.
  • Involved in partitioning the tables, indexes and management of the schema objects.
  • Involved in optimization of code and tuning queries for performance.
  • Involved in managing and migrating objects across multiple environments using Object manager.
  • Involved in analyzing BI usage patterns and developed performance tuning strategies to deliver the highest BI satisfaction using Enterprise manager.
  • Involved in creating Security filters to end users to access data based on their privileges.
  • Provided post production support to end-users.

Environment: Oracle 10, Microstrategy 9.0.1 Product Suite (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Web, Distribution Services), SAS, Windows NT.

Confidential, Wood Cliff Lake, NJ

Sr. Microstrategy Report Developer

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.

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

Confidential

Senior MicroStrategy Lead Consultant

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

Hire Now