We provide IT Staff Augmentation Services!

Sr. Mstr Developer Resume

CA

SUMMARY

  • Over 6+ years of Experience in Microstrategy, well versed and Experienced in Business Intelligence (BI)Project Development and Implementation using Microstrategy10.x/9.x/8.x Product Suites including Microstrategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligent Server etc.
  • Extensively worked in generating and implementing advanced MicroStrategy Reports by creating projects, attributes, hierarchies, facts, metrics, filters, Scoreboard, Dashboard and templates using MicroStrategy Architect, MicroStrategy Agent.
  • Experience in Data modeling, analytics, Mockups/Wireframes design, reporting & dashboards in MicroStrategy.
  • Involved in troubleshooting Microstrategy Web Reports, optimizing the SQL using the VLDBProperties.
  • Migration and up gradation from MicroStrategy 8 to Micro Strategy 9.
  • Expertise in Developing Application Objects (Filters, Prompts, Metrics, Custom groups,Consolidations, Drill Maps, Templates, Searches) to develop Documents and Reports.
  • Strong Knowledge in Dimensional, Data Modeling (Star Schema, Snow - Flake Schema), DataArchitecture, Business and Data Analysis.
  • Experienced working wif Data Modelers to translate business rules/requirements intoconceptual/logical dimensional models and worked wif complex De-normalized and normalized data models.
  • Expertise in Visualizations such as Google Maps, ESRI Maps, Image Layouts, Heat Maps, Micro Charts and Time Series.
  • Experience in Performance Optimization of MSTR Reports, using Intelligent Cubes for betterperformance and to reduce the load on Database.
  • Very proficient in working wif large Databases in Oracle, DB2, Teradata, Netezza and SQL Server
  • Strong SQL skills related to information retrieval and analysis. Exposure to Client Interaction, Userrequirement Analysis and Support.
  • Experience in SQL coding, ability to understand and write complex SQL using Stored Procedures, Joins, Views, Triggers and Indexing strategies.
  • Had working experience in data modelling using Erwin data modeler tool.
  • Supported various testing phases Unit testing, Performance Testing and UAT.
  • Capable of translating complex business needs into technical solutions.
  • Excellent Communication, Interpersonal, Analytical skills and Strong ability to perform as part of the team.

TECHNICAL SKILLS

BI TOOLS: MicroStrategy Desktop 10.2/9.4.1/9.3.1/9. x/8.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligent Server, MicroStrategy Narrow Cast Server, Distribution Services, Integrity Manager, Enterprise Manager, Project Source Manager, Connectivity Wizard, Object Manager, SSRS, Tableau

DATA MODELING TOOLS: Erwin data modeler.

DATABASES: Oracle 11g/10g/9i/8i, MS SQL server 2000/2005/2008/2012, MS Access, TeradataV14/V13, DB2, Netezza, UDB V9.7/9.5, Big data.

OPERATING SYSTEM: Window Server 2000/2003/2008, Unix, Linux

Query Tools: SQL server management studio, AQT, Aginity, Win SQL,SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, CA

SR. MSTR Developer

Responsibilities:

  • Designed the Microstratergy Project schema/Architecture and involved in suggesting changes to the Logical Data Model as per the Business rules and implementing the same in the Microstratergy Project Schema.
  • Responsible for documenting the Functional & Technical Design documents. Responsible for complete Functional Analysis and Data Warehouse for regular Releases and Projects, which requires frequent interaction wif the Business Users.
  • Created and modified attributes, facts, hierarchies and transformation objects as part of the development work for a project.
  • Created reports using Prompts, Filters, Advanced filters, Custom Groups and Consolidations.
  • Confirmed that proper relationships are established between the attributes to restrict any improper SQL query joins.
  • Ensured that the Logical size of the tables are properly set to facilitate the selection of the right tables by SQL engine for a given query.
  • Created complex reports using free form SQL.
  • Good in creating workflows using system manager and automating them.
  • Developed Dashboards that provide users a highly graphical, summary view of key metrics.
  • Had good experience in creating Transaction services Dashboards.
  • Created Dashboards in both the interactive and flash mode.
  • Used several widgets for Dashboard reporting.
  • Created advanced panel selectors and inserted them in a grid view.
  • Tested all the reports by running queries against the warehouse-using SQL Developer.
  • Played a key role in User Acceptance testing of the reports.
  • Worked wif data analysts also.
  • Extensively used Distribution Services to deliver reports directly to business users through Email & History List.
  • Extensively worked on MicroStrategy Web and MicroStrategy Mobile configurations
  • Customized web interface using SDK.
  • Provided support to consultants, Technical Support engineers in creating and troubleshooting Microstrategy SDK customizations.
  • Used Report Services to generate Documents for exporting to Excel & PDF.

Environment: s:MicroStrategy 10.2(Administrator, Architect, Desktop, Web, Intelligence Server, Mobile, Command Manager, Microstrategy SDK, Object Manager, System Manager), Oracle.

Confidential, WI

Microstrategy Developer/Architect

Responsibilities:

  • Involved in gathering business requirements and documenting specifications.
  • Functional Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects.
  • Created Advanced Dashboards wif panel stacks, complicated grids and graphs, customized widgets (Time Series Slider, ESRI Maps, Graph Matrix) both in flash and interactive modes
  • Created and modified attributes, facts, hierarchies and transformation objects as part of the development work for a project.
  • Created complex reports using advanced objects like transformational metrics, advanced filters, advanced metrics
  • Heavily worked on testing and validating the data and involved in optimizing SQL, troubleshooting reports using VLDB properties
  • Set up schedules for various Reporting Objects, Cache clearing and Intelligent Cube refresh.
  • Created subscriptions for Delivery of reports using Distribution Services
  • Providing support for the production issues and QA.
  • Created multi-layered Dynamic Enterprise Dashboards using panels, panel selectors, and widgets like Time Series Slider, Heat Map, Map & Gauge and grids/graphs using multiple datasets.
  • Creation of Intelligent cubes and schedule full refresh and incremental refresh.
  • Created complex reports using free form SQL.
  • Experience in customer requirement gathering, Requirement analysis, Design and Development of complex and Interactive Dashboards.
  • Expertise in Microstratergy Architecture involving certain of schema objects such as attributes, facts, user Hierarchies and Transformations and advanced schema design involving logical views, role attributes, and advanced hierarchies.
  • Migrated objects from DEV to QA by creating packages through Object manager.
  • Synchronizing the Schedules.
  • Worked wif Erwin in designing the schema for database views.
  • Worked on the Data marts and Data Warehouse.
  • Installing and Configuring MicroStrategy suite including MicroStrategy Desktop, Intelligence Server, Web/Mobile, and Narrowcast Server on Windows and Linux Environments.
  • Installing of Database Driver in Server.
  • Monitoring the Services and Backups.

Environment: MicroStrategy 9.4.1 (Administrator, Architect, Desktop, Web, Mobile, Object Manager, EnterpriseManager), Oracle, Erwin, Big data(Hadoop).

Confidential, Raleigh, NC.

Microstrategy Developer

Responsibilities:

  • Generated and implemented schema objects and Application Objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
  • Using advanced objects like transformational metrics, advanced filters, advanced metrics created complex reports.
  • Created ad-hoc reports by drilling up, down, wifin and across Hierarchies.
  • Documents are generated using Report Services.
  • Created multi-layered Dynamic Enterprise Dashboards using panels, panel selectors, and widgets like Time Series Slider, Heat Map, Map & Gauge and grids/graphs using multiple datasets.
  • To hide objects from showing up on the Documents/Dashboards Conditional Formatting is used.
  • Created Intelligent Cubes based on the ad-hoc requests to initiate Self-Serve reporting.
  • Created complex reports using Free Form SQL.
  • Experience in design & development of Report Service Documents (Web and Mobile), Visual Insights Dashboards wif multiple datasets.
  • Worked on the analysis of data.
  • Involved in streamlining the MicroStrategy Development process.
  • Managed the Metadata associated wif the ETL processes used to populate the Data Warehouse.
  • Extensively worked on MicroStrategy Web and MicroStrategy Mobile configurations
  • Involved in Proof of Concept testing, User and business development proposals.
  • Anchor proof of concept for Big Data (Hadoop) & Salesforce integration wif Microstrategy.

Environment: MicroStrategy 9.3.0/9.0.0 (Desktop, Architect, Mobile, Administrator, Web, OLAP), Teradata V13, Windows Server 2008 R2, Big data(Hadoop).

Confidential

Microstrategy Developer

Responsibilities:

  • Defined Facts, Attributes, Hierarchies and Relationships.
  • Involved in managing objects between different environments by using object manager.
  • Generated Metrics, Prompts, Filters, Custom Groups and Consolidations for the report development.
  • Creation of Intelligent cubes and sharing to reduce the database load and decreasing the report execution by using the Cube Services.
  • Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
  • Developed reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Graphs and Alerts were used to support the Reporting process.
  • Created advanced panel selectors and inserted them in a grid view.
  • Extensively used report services to create Dynamic Dashboards using panel stacks, selectors, and widgets in flash mode.
  • Created Advanced Dashboards wif panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.
  • Has used several new controls for Dashboards like time series slider, radio buttons, and drop down menus.
  • For Dashboard reporting used Several Widgets.
  • Created subscriptions for Delivery of reports using Distribution Services.
  • Worked on the testing and validating the data and Involved in SQL troubleshooting reports using VLDB properties.
  • Fixed defects and performed upgrades for existing projects.
  • Created subscriptions for Delivery of reports using Distribution Services.

Environment: MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Object Manager), Netezza, Informatica 8.6, Windows XP Professional 2003.

Confidential

Jr. BI Developer

Responsibilities:

  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction wif the data warehouse architect on the development of logical data models.
  • Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
  • Developed and maintained a combined data store for reporting purposes.
  • Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
  • Tested the reports and fixed bugs in the stored procedures.
  • Managed the Metadata associated wif the ETL processes used to populate the Data Warehouse.
  • Used complex expressions to calculate, group, filter, parameterize, and format the contents of the report.
  • Involved in the analysis, design, development, testing, deployment and user of analytical and transactional reporting system.
  • Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
  • Tuned SQL queries using execution plans for better performance.
  • Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
  • Used Query for ad hoc Reports and Users design Custom Queries.
  • Analyzed reports and fixed bugs in stored procedures.
  • Documented and prepared project status report updates and audit reports

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP

Hire Now