We provide IT Staff Augmentation Services!

Microstrategy Architect/ Developer Resume

Charlotte, NC

PROFESSIONAL SUMMARY:

  • 8 years of full life cycle experience as a MicroStrategy professional that includes requirement gathering, analysis, design/architecture, implementation, testing and maintenance.
  • Created dynamic MicroStrategy Mobile dashboards using mobile applications for iPhone and iPad.
  • Effective usage of Visual Insight, a feature of MicroStrategy to do on - the-fly analysis for business users.
  • Expertise in using MicroStrategy 10.x/9.x/8.x product suites including MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Office, MicroStrategy Object Manager.
  • Created complex application architectures and populated an application host/ configuration matrices with appropriate strategies, timelines and cost information to increase cost efficiency and effectiveness.
  • Confer with business and technical partners, perform data analysis and data profiling, identify data quality issues, and develop Metadata Model.
  • Worked with product development teams and senior designers on complex projects to develop architectural requirements to ensure client satisfaction with product.
  • Serve as a subject matter expert and participate in design reviews.
  • Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
  • Experienced in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
  • Worked to large extent in creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
  • Expertise in Developing User Objects (filters, prompts, metrics, Custom Groups, Consolidations, Searches) to develop Documents and reports.
  • Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
  • Expertise in creating dashboard Reports to view personalized reports based on user requirements.
  • Experience in implementing row level security within the Metadata, Involved in creating Managed AD HOC Report for End Users.
  • Strong knowledge in Reporting and Analyzing data with Intelligent Cubes & Dynamic Sourcing I Cubes.
  • Fine tuning of the MicroStrategy reports using Datamart Reports, Partition Mappings and Aggregate tables, VLDB SQL Query Optimization Techniques.
  • Expertise in Defining MicroStrategy Narrow cast Server objects like Service, Schedule, Subscription set and Information Objects.
  • Experience in developing test cases and test plans for system testing and involved in unit testing and UAT extensively.
  • Experience in change management, problem solving, team coordination and mentoring team members.
  • Used different types of widgets like micro charts, Gauge, Heat maps, Water fall and used different type of graphs like line, bar, pie, combination graphs for both Mobile and web dashboards.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 10.6/10.x/9.x/8.x (MicroStrategy Developer, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server), MSTR Office Add-in, Enterprise Manager, Object Manager, Tableau, Cognos, Power BI

Databases: MS-SQL Server 2016/2012/2008, MySQL, Oracle 11g/9i, Teradata, MS-Access.

ETL Tools: SSIS, Informatica Power center 9.x/8.x, Oracle Warehouse Builder 10.2

Languages: SQL, PL/SQL JAVASCRIPT, TSQL

Web Programming: HTML, DHTML, XML, XAML, CSS, Java Script

Project Management Tools: JIRA 7.x/6.x, Workfront

Other Tools: ERWIN, Quality Center, SharePoint, RUP methodology, MS Office 2016, MS Visio & Project 2016

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MicroStrategy Architect/ Developer

Responsibilities:

  • Participated in Daily JAD Sessions to prioritize production issues in reporting and work toward finding the root-cause of the problem and provide a solution.
  • Created Mockup/framework in Excel and worked on developing a pilot dashboard in Visual Insight for reporting the business requirements.
  • Developed solutions to problems in Coding Compliance work stream
  • Involved in the meetings with users to know more about the requirements and understanding the business requirements
  • Created Schema objects (attributes, facts, Transformations) and Created Application Objects (Reports, Filters, Prompts, Metrics) to meet the business requirements
  • Used Prompts, filters, Conditional, Transformation metrics and Level Metrics for creating complex reports.
  • Designed reports, which are the focus and goal of business intelligence. Created documents, which contain group of reports and developed Dynamic Dashboards, which is summarization of Key performance indicators (KPI).
  • Interacted with Offshore counterparts to complete the work on time for meeting the client goals.
  • Created consolidations to group the attribute elements in the reports according to the requirement.
  • Created packages using Object Manager to deploy code to Quality Assurance region once the code has been approved in Dev region
  • Created different Transformations to get the last year’s actual transactions, week to day, week to period, week to quarter and week to year and effectively used them with the Metrics.
  • Created Intelligence cubes for best performance of dashboards and created reports against to intelligence cubes.
  • Created Dashboards for web version as well as for mobile Ipad version.
  • Created Mobile and Web Dashboards with different reports. Used different type of selectors such as drop down, radio buttons, link bar, slider, button bar and Fish style.
  • Used Panel stacks for different views and created panel selectors for the panels.
  • Worked and configured MicroStrategy Mobile App to see dashboards in the project. Used different options available like swiping the panels, information window, Docked selector.

Environment: MicroStrategy 10.6/10.x, MS SQL Server, Teradata, Oracle 10G, Microsoft SSIS, DB2, Quality Center, Remedy, HP Quality Center, JIRA.

Confidential, Fort Worth, TX

MicroStrategy Architect/ Developer

Responsibilities:

  • Involved in the meetings with users to know more about the requirements and understanding the business requirements
  • Created Schema objects (attributes, facts, Transformations) and Created Application Objects (Reports, Filters, Prompts, Metrics)
  • Used Prompts, filters, Conditional, Transformation metrics and Level Metrics for creating complex reports.
  • Designed reports, which are the focus and goal of business intelligence. Created documents, which contain group of reports and developed Dynamic Dashboards, which is summarization of Key performance indicators (KPI).
  • Created consolidations to group the attribute elements in the report s according to the requirement.
  • Created Intelligence cubes for best performance of dashboards and created reports against to intelligence cubes.
  • Created Dashboards for web version as well as for mobile Ipad version.
  • Created Mobile and Web Dashboards with different reports. Used different type of selectors such as drop down, radio buttons, link bar, slider, button bar and Fish style.
  • Used Panel stacks for different views and created panel selectors for the panels.
  • Worked and configured MicroStrategy Mobile App to see dashboards in the project. Used different options available like swiping the panels, information window, Docked selector, thresholds for Ipad.

Environment: MicroStrategy 10.x, MS SQL Server DB, Oracle 10G, Microsoft SSIS, DB2, Quality Center, HP Quality Center, WorkFront.

Confidential, Westlake, TX

MicroStrategy Architect/ Developer

Responsibilities:

  • Defined and approved application standards and specifications; providing oversight for definition of product content to ensure that appropriate parties are kept informed of client and company requirements and policies.
  • Developed and maintained data dictionary.
  • Worked with other developer in the BI reporting Space on delegating the task.
  • Generated advanced reports in Grid, Graph, and SQL mode, consisting of data analysis by combining a template with filters using MicroStrategy Desktop and Web.
  • Created MicroStrategy Objects Metrics, Filters, Prompts, Templates, Consolidations, Transformations, and Custom Groups using MicroStrategy Desktop.
  • Used MicroStrategy Web to offer interactive reporting to end users through a web browser.
  • Created services using Subscription sets, Schedules, and Information Objects.
  • Worked in designing and developing Interactive Scorecards and Dashboards according to Business requirement.
  • Performed Testing for applications such as ERP, Finance, Coding Compliance and CDM App Store by using Integrity Manager.
  • Customized the drilling options specific to the reports, using drill map editor to give access to more detailed and supplemental information.
  • Created Star Schema to develop the data mart in the data warehouse.
  • Involved in Database Performance Tuning.
  • Created various types of reports such as Drill Reports, Cross Tab Reports, Standard Reports, and Master Detailed Reports, using different reporting features like Slice and Dice, Drill Down, Prompts, Filters, Alerts, Sorts and Breaks.

Environment: MicroStrategy 9.3.1, Oracle 10G, Teradata, DB2, Informatica Power center, HP Quality Center.

Confidential, St Louis, MO

MicroStrategy Architect/ Developer

Responsibilities:

  • Identified Source tables and columns required to create a MicroStrategy project.
  • Architected the schema objects such as Attributes, Compound Attributes, Facts, and Hierarchies.
  • Designed the application objects Filters, Base Formulas, Metrics, Derived Metrics, Compound Metrics, Templates and Reports.
  • Created Dashboard, Scorecard and operational reports by using MicroStrategy Report services.
  • Worked on the Flash functionality of the MicroStrategy to generate interactive Dashboards.
  • Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents. These were especially useful for the insurance companies in making critical decisions regarding policies.
  • Created interactive dashboards using the new widgets in MicroStrategy 9.2.1.
  • Developed Custom Reports with a host of ad hoc features including drilling, pivoting and data slicing.
  • Created Prototype Dashboards and Presented to the user group for User Acceptance.
  • Created transformations using transformations by tables for YTD, MTD and WTD analysis.
  • Interacted with the Business Users and gathered requirements for Dashboards.
  • Identified the Facts and Attributes that goes in the Dashboard and documented the Technical specification.
  • Created Prompts to give the end users the required power to define the report definition at the run time.
  • Created Hierarchies for providing drill down options for the end-user through Web.
  • Implemented Drill Maps on several reports to access data at different levels.
  • Configured Data Marts in MicroStrategy Desktop to update tables in database.
  • Created Narrowcast Services to deliver reports to End User.
  • Headed as MicroStrategy Technical Lead for a MicroStrategy environment and Production Support team.
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
  • Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server.

Environment: MicroStrategy 9.x ( Desktop, Architect, MicroStrategy Intelligence Server, Narrow Cast Server, Report Editor, Report Services), Warehouse Catalog, Oracle 10g,SQL Server 2005, Informatica Power Center, Lotus Notes

Confidential, Seattle, WA

MicroStrategy Architect/ Developer

Responsibilities:

  • Created the Metadata & Statistic tables for the MicroStrategy projects on a SQL Server database.
  • Created new users, roles, privileges, shared folders, access controls Lists using security roles as a MicroStrategy administrator.
  • For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Filters, Custom Groups and Consolidations.
  • Tested all the reports by running queries against the warehouse using Query man. Also compared those queries with the MicroStrategy SQL engine generated queries.
  • Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • Extensively worked on Dashboards using Report Services and also migrated documents to 9.0.1
  • Upgraded the MicroStrategy Projects from MicroStrategy 8.x to 9.0.1
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization
  • Configured the Enterprise Manager for statistical reporting purposes.
  • Provided access to the Data-warehouse to a much larger audience by using Narrowcast Server.
  • Added a couple of filters to reports as per changed requirements.
  • Made use of the Freeform SQL Functionality of MSI 8.0 to create a Scorecard Graph.

Environment: MicroStrategy 9.x (Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Teradata V2R6, SQL Server, Informatica Power Center, Eagle PACE

Confidential, Los Gatos, CA

Oracle PL/SQL Developer

Responsibilities:

  • Involved from beginning of the project, published charter for EDM (Enterprise Data Management) and Statement of Work (SOW) for DQM and MDM.
  • Assisted Project Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestone.
  • Instrumental in developing a score card for the DQM program to report the Current state of Quality Vs. future state.
  • Pro led source data in-order to understand the current state and statistics of numerous attributes that Russell consumes on a daily basis.
  • Instrumental in developing temporary solution for measuring current state of data quality by manually analyzing data using MS-Access for storing and generating reports.
  • Responsible for differentiating the data quality rules into different tiers to ensure that rules are prioritized during the implementation.
  • Developed PL/SQL packages, stored procedures, functions, triggers, SQL statements in Oracle 10G.
  • Unit tested PL/SQL procedures developed to ensure that the code works per data requirements.
  • Performed Source to target mapping to identify the source data that needs to be moved into the target tables.
  • Conducted work ow, process diagram and gap analyses to derive requirements for existing system enhancements.
  • Designed and created Data Quality baseline ow diagram, which includes error handing data ow through various internal and external data sources before reporting.
  • Observed Work ows and lineages from several sources to their respective targets for various applications across the enterprise.
  • Documented and discussed the changes that can be made with Project Manager, Application Support team for robust and streamlined ow of data.
  • Developed SharePoint site for holding metadata Created work ow by properly documenting all the tasks that a metadata admin should perform for consistent and proper maintenance of Metadata Admin Guide.

Environment: Oracle, Microsoft SSIS, SSRS, MS Office Suite, Windows 7 OS, Talend Data Profiling Tool, Data Quality Module from Talend, PL/SQL for Oracle.

Hire Now