We provide IT Staff Augmentation Services!

Sr. Microstrategy Architect And Admin Resume

Chevy Chase, MD

PROFESSIONAL SUMMARY:

  • 10+ years of IT experience working with databases and Over 10+ years’ experience in data modeling, designing and architecting data warehouses and business intelligence applications for the Pharmaceutical, Financial, Retail and Telecom industries.
  • 10 years’ experience using MicroStrategy 9.x/8.x/7.x, and other Data Warehousing tools such as Informatica and Data Stage
  • Worked on upgrading the MicroStrategy project created in Micro Strategy version 7.x to version 9.x
  • Very good experience in RDBMS such as Oracle, Teradata, DB2, SQL Server
  • Experience in operating systems such as UNIX, AIX, HP - UX, and Windows NT/2000/ 98/95.
  • Well versed with the MicroStrategy product suite namely MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Mobile, MicroStrategy Dashboards and MicroStrategy Narrowcast Server
  • Full life cycle implementation experience encompasses Business Requirements definition, Data Analysis, Data Warehouse Architecture, Deployment, Logical and Physical Data Modeling, Gap Analysis, Data Conversion, Validation, Testing Methodologies (unit, integration, stress, and bug tracking and fixing), Designing and Developing ETL modules, Building various types of Operational Data Stores (ODS), Documentation, Production Migration, Post Implementation Support, Assessment and Enhancement and Refinements for various Business Intelligence Applications
  • Handled historical data using Slowly Changing Dimensions and also handled Many to Many Relationships effectively without any compromise of performance.
  • Worked on Clustering the Microstrategy environments for Load Balancing.
  • Strong SQL skills, including use of nested table expressions, unions, multi-table joins, scalar functions, derived columns
  • Sound working knowledge of 2-Tier client/server architecture and N-Tier architecture
  • Very good experience in working with very large databases on Oracle, Teradata, SQL Server with Micro strategy Suite
  • Expert in Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages, and triggers
  • Demonstrated ability to work effectively with all levels of staff, customers and other IT personnel
  • Capable of translating complex business needs into technical solutions (i.e. ability to understand the users' requirements)
  • Worked on Workday reports (Cloud Based Systems). Experienced in extracting data from Workday environment using web services and loading it to database using SSIS Packages.
  • Worked on Taleo reports (Cloud Based Systems).
  • Worked with Data Science team in Microstrategy connecting to Hadoop.

WORK EXPERIENCE:

Confidential, Chevy Chase, MD

Sr. MicroStrategy Architect and Admin

Responsibilities:

  • Involved in the complete Life cycle of the CFQ Project.
  • Participated in the end user meetings to obtain the business requirements for creating reports.
  • Converted the Access system into Microstrategy.
  • Created Facts, Attributes, Hierarchy’s, Transformations and Custom Groups.
  • Handling the Administrative tasks in perspective to MicroStrategy.
  • Handling Migrations using packages. Using Integrity Manager for taking base lines before and after Migrations.
  • Working with DBA’s to take backup’s for restoring Metadata.
  • Maintaining Cube Caches and Report Caches.
  • Maintaining the Schedules, both email and file using batch ID.
  • Handled historical data using Slowly Changing Dimensions and also handled Many to Many Relationships effectively without any compromise of performance.
  • 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 lookup tables, Aggregate Tables, Views as necessary for the Cash for Quotes Project. Collected stats and indexes for the best performance.
  • Created cubes and built Visual Insights and Dashboards for the project.
  • Planned the Migration across the environments and deploying it successfully.
  • Handled issues raised in JIRA and resolve them on time to help users continue their Analysis.
  • Implemented ragged Hierarchy. Created the Employee Tree.
  • Handling Ad hoc Requests.
  • Experience with PS Query Tool. Created queries and scheduled them in the PS Query.
  • Working on Workday reports (Cloud Based Systems). Created reports in Workday and delivered to users using schedules.
  • Created integrations to extract data from Workday and built SSIS packages to load the data into DataMart. Created Microstrategy Architecture later and built reports on top of it.
  • Worked Data Science teams to create reports for quick analysis in the MicroStrategy environment connected to Hadoop.

Environment: MicroStrategy Desktop 9.4.1, MicroStrategy Web, SQL Server 2012, Windows Servers.

Confidential, Columbus, OH

Sr. MicroStrategy Architect and Admin

Responsibilities:

  • Involved in the complete Life Cycle of the project.
  • Interacted with the data modeling team for the Logical and Physical model design.
  • Involved in designing the Conceptual model.
  • Involved in creating the Aggregate tables considering both the Technical Feasibility and Business Feasibility to improve reports performance.
  • Handling the Administrative tasks in perspective to MicroStrategy.
  • Handling Migrations using regular Migrations. Using Integrity Manager for taking base lines before and after Migrations.
  • Working with DBA’s to take backup’s for restoring Metadata.
  • Used Source as SAP BW and worked on the requirements with ETL Team.
  • Created lookup tables, Aggregate Tables for the Customer and Brands data.
  • Involved in Creating Views in Teradata to be in sync with the tables in SAP BW to make the Project successful.
  • Designed the schema in MicroStrategy Desktop based on the business requirements.
  • Created Attributes, Facts, Dimensional Hierarchies and all the public objects like Metrics, Custom groups, prompts and filters.
  • Created Hierarchical prompts, nested prompts, object prompts.
  • Created Cubes to assist the quick analysis for the Demand and Deployment Team. In turn reduced a large amount of load on the MicroStrategy and Database.
  • Experienced in performance tuning of the reports and the environment.
  • Implemented the Dimensional Model in MicroStrategy for the performance tuning of the Cube and reports as a parallel architecture to meet the needs of the large amount of data requirement.
  • Setup Mobile environment and setup connections for IPhone and IPad.
  • Worked with windows team for proxy server setup for secure login for Mobile platform.
  • Worked on District Manager Mobile Dashboards for Better, quick and best Analysis of store performance.
  • Migrated Narrowcast Services to Distribution Services.
  • Created customized Custom Groups with complex filters and Relationship filters.
  • Created Complex reports for analysis (like Market Basket analysis) with custom groups, Transformations and complex filters.
  • Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both MicroStrategy Desktop and MicroStrategy Web.
  • Created Ad-hoc reports with dynamic prompt answers for the end users to generate.
  • Worked with the MicroStrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues
  • Used the VLDB properties for performance tuning and SQL optimization.
  • Created Transformations like Last Month to This Month and also created the required transformation tables.
  • Experience in analysis the explain plans of SQL and analyzing the indexes in the process of tuning the reports.
  • Experienced in monitoring the MicroStrategy Queue using Teradata tool view point.
  • Implemented Multi Sourcing for District Manager Dashboard requirement.
  • Worked with Teradata DBA team to improve the report performance.
  • Performed the ETL, UAT and System tests on the warehouse tables and the reports.
  • Handled HP ticketing service for support.

Environment: MicroStrategy 9.0.1/9.2.(Desktop, Administrator, Architect, Intelligence Server, Web), MicroStrategy, Object Manager, Teradata, SQL Server, Windows.

Confidential, Mcelhattan, PA

Sr. MicroStrategy Architect

Responsibilities:

  • Gathered and documented business requirements and also designed user friendly templates for the business partners to communicate any further enhancements needed.
  • Implemented a 3-tier reporting architecture with MicroStrategy Intelligence Server with star schema to fit reporting, query and business analysis requirements.
  • Designed, developed and architected a MicroStrategy projects that accesses Health Care Sales, Retail Sales, Sales VP, Sales Ambassadors and sales rep information and generates reports for the sales operations department Built Logical Views in MicroStrategy 8.0 to combine warehouse tables at runtime during report execution.
  • Developed in a conformed dimension framework to eliminate expensive redundancy and rework.
  • Developed schema objects (facts, attributes, hierarchies, transformations) using MicroStrategy Architect.
  • Developed highly prompted report builder for flexible but controlled ad-hoc reporting. Set up user friendly web options such as hierarchical browsing, since 90% of the end users access the tool through MicroStrategy Web
  • Created transformations (table based, formula based) for use in comparative reports such as store brand sales this year to last year (year to date and month to date) to monitor trends. Created advanced filters, advanced prompts, advanced report designs and drill maps.
  • Implemented security for different users to view reports for their regions using security filters.
  • Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
  • Worked with ETL teams to extract data from source systems to target system.
  • Used SQL Server 2005 extensively to test and debug MicroStrategy reports as well as the accuracy and consistency of Informatica jobs

Environment: MicroStrategy Desktop 8i, MicroStrategy Web, Informatica 7.1.1, Sql Server 2005, Windows 2000/NT, Datastage.

Confidential, NJ

Sr. MicroStrategy Architect and Admin

Responsibilities:

  • Involved in the complete Life cycle of the Project.
  • Participated in the end user meetings to obtain the business requirements for creating reports.
  • 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.
  • Involved in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, access controls lists.
  • Involved in 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 ad-hoc report by drilling up, down, within and across dimension or anywhere.
  • Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
  • Worked along with MicroStrategy Knowledge Base to troubleshoot some Report related issues.
  • Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment.
  • Extensively used MicroStrategy Report Services to generate Report Documents.
  • Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services.
  • Used conditional formatting feature to project trends for product sales and to enhance grid and graphs in documents.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.

Environment: MicroStrategy9.0.1(Desktop, Administrator, Architect, Intelligence Server, Web, Agent), MicroStrategy, Informatica, Object Manager, Teradata V2R5, SQL Server, Windows, Actuate e.Report Designer Professional 6, Oracle10g, Erwin, Informatica 6.2, MS SQL Server, DTS, Teradata, Windows

Confidential, Fairfax, Virginia

Sr. MicroStrategy Architect/Admin

Responsibilities:

  • Identified source tables and columns required to create MicroStrategy project
  • Involved in analysis, design and construction of the Metadata
  • Coordinated with the DBA for table creation, loading data and other administrative activities
  • Designed and developed logical data model for MicroStrategy reporting environment
  • Designed Dashboards in 8.1 using the new selectors radio buttons, check boxes, panels, slider and button bar etc. summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents
  • Created a Database instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project
  • Extensively used Command Manager to create schema objects in bulk
  • Extensively used Integrity Manager to test reports when upgraded
  • Generated the technical Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment
  • Implemented the MicroStrategy projects by creating Public & Schema objects like facts, attributes, hierarchies, reports, filters, metrics and templates in MicroStrategy Desktop
  • Improved the performance of the reports by changing VLDB properties
  • Developed different transformations which help business users to compare present data with previous years data in reports
  • Extensively used MicroStrategy Report Services to generate Report Documents
  • Implemented Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports
  • Applied best customization practices which can improve system performance and make application easier to maintain and upgrade to later versions of MicroStrategy Web
  • Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied
  • Performed Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable
  • Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services
  • Actively participated in developing Report Delivery Schedules
  • Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets

Environment: MicroStrategy9,8.1/8.0.3 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata V2R6.1.1, SQL Server 2005, Windows XP, Erwin

Confidential

MicroStrategy Developer

Responsibilities:

  • Met with business users for requirements gathering
  • Worked with the Data Modelers for creating the dimensional model based on the requirements
  • Involved in Analysis, design and construction of the metadata
  • Architected the projects and created schema objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, prompts, Consolidations, Custom Groups, Drill maps and Templates
  • Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports
  • Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports
  • Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric
  • Involved in migration of Business Objects documents to Micro Strategy documents.
  • Created services using subscription sets, schedules, Information objects
  • Involved in setting Result caches, Object Caches at Intelligence server to improve performance of the report
  • Involved in Micro Strategy Intelligence Server performance monitoring, creating log files and managing cache expiry times
  • Managing schema objects and application objects across the project by using Object Manager.
  • All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager
  • Experienced in ETL Administration responsibilities for the Enterprise Data Group using the Informatica tool
  • Responsible for Translates technical specifications into efficient ETL scripts in a Teradata environment
  • Set-up a training lab with 12 Systems. This was done to since there were users of varying levels of knowledge about Micro Strategy. Advanced users used the desktop version while other used the web
  • Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries)
  • Involved extensively in Database Performance tuning

Environment: Micro Strategy 7.0, Narrowcast Server, Intelligence Server, Web, Administration, Informatica 7,SQL Server 2000,T-SQL, Teradata V2R3, Unix, XML, Windows NT

Hire Now