We provide IT Staff Augmentation Services!

Sr. Associate / Microstrategy Admin Resume

Thousand Oaks, CA

SUMMARY:

  • Over 11+ Years of IT experience and well acquainted in performing the MicroStrategy Architect, MicroStrategy Developer and MicroStrategy Administrator roles.
  • Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Admin.
  • Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Facts, Metrics, Filters, Prompts, Custom Groups and Consolidations) with the data warehouse.
  • Experience in creation of Report Service Documents, VI, Scorecards and Dashboards which help in better understanding of business trends.
  • Worked on developing Dynamic Dashboards using various Widgets, Panel Stacks, Selectors and Edit Links.
  • Worked on setting up the security credentials at object level and implemented security credentials using Connection Mapping.
  • Good understanding and Designing of fundamental data warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data Marts, Fact and Dimensional tables, Logical and Physical data modeling.
  • Experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy 10.x/9.x/8.x versions Oracle 10g/9i/8i and SQL Server.
  • Good SQL Skills related to information retrieval and analysis. Exposure to Clients Interaction, user - requirement analysis and user support.
  • Involved with all the stages of Life Cycle Development of the data warehouse project.
  • Good problem solving skills with strong technical background and good interpersonal skills.
  • Involved in creation of Test Cases for the MicroStrategy Web and Desktop functionality testing.
  • Managing schema objects and application objects across the project by using Object Manager.
  • Experience in Installation and Configuration of MicroStrategy I-Server for Development and QA environment (Windows and Linux).
  • Worked on configuration of Enterprise Manager, Metadata.
  • Worked briefly in Cognos reporting tool.
  • Quick learner and excellent team player, ability to meet deadlines and work under pressure.
  • Worked on Agile Methodology by following Scrum Process for fast track development for day to day work status and set the goal for the time period.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 10.x/9.x/8.x (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Enterprise Manager, Cognos 8

Databases: MS SQL Server 2005/2000, Oracle 9i/10g, MS Access, Netezza, Sybase IQ

PROFESSIONAL EXPERIENCE:

Confidential,Thousand Oaks,CA

Sr. Associate / MicroStrategy Admin

Responsibilities:
  • Initial analysis, routing and response to service calls related to BI, MicroStrategy.
  • Incident and defect resolution.
  • Technical support for data fixes as required by the business for MicroStrategy Applications.
  • Business consulting i.e., business support for queries on MicroStrategy.
  • System Administration i.e., supports in completing activities which includes integration Informatica and MicroStrategy.
  • Coordination with the Client core team and business units as required for requirements, solution, testing and training.
  • Upgrade MicroStrategy Platform.
  • Experience in Cloud Management.

Confidential,Fountain Valley,CA

Sr. Associate

Responsibilities:
  • Requirement Gathering and documenting in terms of BRD
  • Design and Co-ordinate the developmental activates with offshore
  • Review Code objects and Technical Documents
  • Help users for UAT
  • Support to IT team for Object Migration
  • Hyper care/Warranty support

Confidential,Fountain Valley,CA

Sr. Associate

Responsibilities:
  • Requirement Gathering and documenting in terms of BRD
  • Design and Co-ordinate the developmental activates with offshore
  • Review Code objects and Technical Documents
  • Help users for UAT
  • Support to IT team for Object Migration
  • Hyper care/Warranty support

Confidential,Fountain Valley,CA

Sr. Associate

Responsibilities:
  • Support the development team in resolving the technical issues.
  • Review Technical Documents
  • Help users for UAT
  • Support to IT team for Object Migration

Confidential,Las Vegas,NV

BI Lead

Responsibilities:
  • Respond and Provide Resolution to the Issues according to their Priority.
  • Act on the Ad-hoc queries from the Business Users.
  • Development work such as Enhancements, providing new set of Operational reports directly from Transactional DB or new reports from Data Warehouse on BI projects.
  • As an Architect and as an Admin to Manage the Project Objects.
  • Promotion/Migration of Objects to various Environments (Dev - QA - Prod).
  • Coordinating on Enhancements by taking the requirements from Business and imparting the solution to the offshore team to complete the work.
  • Review the work done by the team, making sure to Document everything at all the required phases of Software Engineering Lifecycle.
  • Handling of 4 MicroStrategy Projects and providing Production support to them.

Confidential,Las Vegas,NV

BI Lead

Responsibilities:
  • Worked in the technical team of BI along with DBA, ETL teams and Business Users to define the scope and requirement of the project and provide the right solution.
  • Contributed in drafting Functional Specifications for Reporting Team with the help of Business Requirement Documents (BRD) and worked along with Data Modelling Team and ETL Team in defining and managing the data across the project.
  • As part of creation of Functional Specs, Mock up for the dashboard were made for end user approval considering the standardize template defined by the company.
  • Worked on Technical Specification for each of the Dashboard and documenting the same for the Team.
  • Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis
  • Provided feedback/reports on system usage and potential bottleneck using Enterprise Manager and other tools
  • Worked with Release Management and Production Support team on the Object Migration process
  • Worked on Project Duplication to create various projects across various Environments for System Testing (ST), User Acceptance Test (UAT) Post Development.
  • Worked with BA/Functional Testing team in writing Test Cases and Reviewing them across board
  • Helped in data quality issue in finding and helping to resolve some of the data discrepancy on the source system and ETL process.
  • Provided Job-Aids to the users on various reports by providing the Data Flow using various Selectors and worked on Distribution Services to automate the reports for large group of user.
  • Created advanced metrics, filters, custom groups and reports (including Freeform SQL reports) with VLDB properties.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies.

Confidential

Sr. BI Developer

Responsibilities:
  • Involved in Reports Upgrade from Cognos 7.x to Cognos 8.x
  • Worked on preparing various Versions of Documents on reports moved from Older Version to Newer Version.
  • Helped in coming out of entire Migration Document.
  • Creation of reports in Newer Version when the report fails to run from Older to Newer Version.
  • Testing of all the reports, comparing data to match with Older Version reports to Newer Version reports.
  • Support for UAT and provide feedback to the clients.

Confidential

Sr. MicroStrategy Developer

Responsibilities:
  • Created the Technical Specification for the reports for offshore developers to build the reports using the public object.
  • Involved in Data Validation and Data Quality by running the SQL against the Data Warehouse.
  • Worked as team with DBA, ETL, Business Users and QA for performance tuning of the reports and meet the requirement.
  • Involved in scrum meetings for fast track development for day to day work status and set the goal for the time period.
  • Worked on Project Planning, Estimation and Preparing test cases for functional test phase for QA team.
  • Interacting with SDK team for Web Customization to have the standard look and feel of web pages.
  • Created Schema Objects like facts, attributes, hierarchies and Application objects like reports, filters, metrics and templates using MicroStrategy Desktop to meet report requirements
  • Created advanced metrics, filters, prompts, custom groups and reports with VLDB properties.
  • Created ad-hoc reports by drilling up, down, within and across Hierarchies.
  • Created different reports like Tabular, Cross tab, Master detail, Graphs using different reporting features like Slice and Dice, Drill-down, Prompts, filters, and Alerts.
  • Extensively used filters, templates, consolidations and custom groups and VLDB Properties to generate reports for business analysis using MicroStrategy 8i.
  • Design, Develop, Test and Implement MicroStrategy reports.
  • Worked with back end Database Administrators to provide requirements for necessary back end tables
  • Installed and Configured the MicroStrategy I-Server for Development and QA environment (Windows and Linux).
  • Configuration of Enterprise Manager, Metadata and Job monitoring.
  • Monitoring and Ensuring of Project Progress and Preparation of User documents, Release Notes, Status Reports, Issue Logs and escalating to different groups.

Confidential

Sr. MicroStrategy Developer

Responsibilities:
  • Involved in interacting with users and gathering the requirement and analyzed the needs of the business user.
  • Gathered and documented business requirement and making mock up reports in Microstrategy Excel by understanding the clients reporting requirement.
  • Worked with data modeler to identify Entity Relationship attributes and tables.
  • Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture,Business and Data Analysis
  • Created Schema Objects (facts, attributes, hierarchies) and application objects (filters, prompts, metrics, reports)
  • Created project plans for development of MicroStrategy projects.
  • Created Relationship tables to avoid Many-Many relationship between parent and child attributes.
  • Involved in creation of Aggregate tables to improve performance of reports.
  • Created various Reporting Graphs based on user requirements.
  • Involved in using Intelligent Cubes to have High performance In-Memory, faster reporting for more people.
  • Involved in scrum meetings for fast track development for day to day work status and set the goal for the time period.
  • Setup the security credentials at object level and implemented security credentials using Connection Mapping.
  • Actively involved in walkthroughs and meetings with Business team to discuss related issues and review of the Objects and reports.

Confidential

MicroStrategy Developer

Responsibilities:
  • Involved in Logical Data Model (LDM), Physical Data Model (PDM).
  • Involved in Extraction, Transformation and Loading (ETL) the data to the OLAP system.
  • Creation of Schema Objects - Facts and related Metrics (Simple and Compound Metrics).
  • Development of Reports and HTML Documents.
  • Unit testing, Bug fixing and worked on the Documents related to Test Cases.

Hire Now