Digital Microstrategy Developer/consultant Resume
SUMMARY:
- 7+ years of experience in Information Technology, experience with Data Warehousing Reporting Tool MicroStrategy using Desktop, Web, Intelligence Server, and Report Services.
- Extensively worked in creating and integrating Reports and Objects in MicroStrategy (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) in the data warehouse.
- Experience including technical support, troubleshooting, report design and monitoring of system usage.
- Created Dynamic Dashboards showing organizations yearly performance and analyzed the sales, revenue, profits using various graphs and widget
- Experience in designing mock up reports for client demos
- Extensive work experience in designing Data Marts using different multi - dimensional modeling techniques such as Star Schema and Snowflake Schema for FACT and Dimensional tables that includes Logical and Physical data modeling.
- Involved in Data architectural designing and database integration, data warehousing.
- Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
- Involved in Trouble Shooting, Performance tuning of reports and resolving with in Business Objects Enterprise and Reports.
- Worked on all phases of data warehouse development lifecycle, from gathering requirements to design, development, testing, deployment, and support.
- Implemented features like Integrated Query reporting and powerful iterative analysis were provided to the end users through MicroStrategy Desktop and Web
- Experience in performance tuning SQL queries by providing hints, obtaining explain Plan, analyzing tables and adding indices.
- Extensive MicroStrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider, Data Mart and Web BI Suits and Reporting Tools.
- Experience in Sending Weekly and Monthly Status Reports to Client/Higher Management. Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills
- Excellent problem solving skills with a strong technical background and good inter personal skills.
TECHNICAL SKILLS:
Reporting Tools: MicroStrategy 10.2,10,9.4.1, 9, 9.2, 9.2.1, 8.0, 8.1 (Desktop, Architect, Web, Intelligence server)
Databases: MS Access, Teradata, MS SQL Server, Mobile SQL server
Operating Systems: Windows XP, Windows vista, Windows 7
Office Tools: MS Word, Excel, MS Visio, MS Project, MS Outlook, MicroStrategy Office
Dashboard and Widgets: MicroStrategy Dashboard
PROFESSIONAL SUMMARY:
Confidential
Digital MicroStrategy Developer/Consultant
Responsibilities:
- Responsible for all MicroStrategy Architecture/Development.
- Verified the logical schema for existing dimensions, worked with ETL Team for new tables, columns.
- Created schema objects such as Attributes, Facts and Hierarchies and worked on relationship between attributes.
- Architected and Developed composite solutions involving users access reports
- Created various reports which are part of dashboard having different interactive widgets that are accessed by top level executives.
- For complex reporting needs, worked extensively on creating Metrics, Filters, consolidations
- Resolved Cross joins in the SQL's by modifying the attribute definitions to generate the accurate results.
- Leveraged MicroStrategy OLAP services to develop reports, which use the functionality of the intelligent cubes and Derived Metrics.
- Created security filters and other report objects, drilling, defined hierarchies.
- Develop Standard as well as Ad-Hoc Reports based on the user need, the end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
- Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
- Coordinated with the team members in order to update the progress of the development.
- Scheduled meeting with the clients and the development team and reporting to the project manager.
- Worked on creating the Visual Insights including the various widgets and demonstrated to the business users.
- Tested all the reports by running queries against the warehouse and also compared those queries with the MicroStrategy SQL engine generated queries.
- Worked on support measure for the other related projects and responsible for re-architecting required changes and checking the report results.
- Created documents using panels, panel stacks, sections, grids, graphs and widgets.
- Tuned the reports by taking advantages of VLDB properties and complex report filters.
- Worked with DBA's in identifying the long running queries of daily reports data and enhanced the performance by indexing, data distribution, and monitoring other activity on box.
- Used the Object Manager to move the objects from Development to QA and to Production environment in MicroStrategy.
- Collaborating with business partners to provide technical report assistance.
Environment: MicroStrategy 10.2, Desktop, Intelligence Server, Web, Administration, SQL Server, Window10, My SOL Workbench, Red shift
Confidential, Washington, DC
MicroStrategy Developer
Responsibilities:
- Created Reports and Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Experienced the latest version of MicroStrategy 10.2, 9.0.1 & above .
- Developed Public Objects like filters, prompts, metrics, templates, consolidations, etc.
- Experienced in using Schema Objects to create reports.
- Worked on Data Warehousing and RDBMS concepts.
- Created view and tables to generate clean SQL for reports
- Tested reports and Dashboards in different environments to ensure the functionality and results.
- Coordinated with team in order to deliver the product on scheduled time.
- Actively participated in the data modelling and given suggestions in formulizing the table structure.
- Worked with databases like Teradata for testing and validation of data and to create reports.
- Experienced in promotion of Objects to different environments.
- Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
- Performed testing of all reports for the final deployment.
- Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
- Created template reports using advanced prompts like object prompts, expression prompts, filters.
- Designed the Micro Strategy Architectural and Developers Documents for the Projects.
Environment: MicroStrategy 10.2, 9.4.1, Desktop, Intelligence Server, Web, Administration, SQL Server, Window XP, Pl-SQL, Tera Data
Confidential, New York, NY
MicroStrategy Developer
Responsibilities:
- Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
- Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
- Created multiple flash and dynamic dashboards using Intelligence Cube and Documents
- Data blending implemented on EMPI databases and generated interactive dashboards.
- Created adhoc reports to users by connecting various data sources.
- Handled admin activities granting access, managing extracts and Installations.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Designed the data architecture and Involved extensively in Database Performance tuning
- Migrating Project objects using Object Manager and comparing different environments using Integrity Manager of MicroStrategy
- Help Data Analysts to create reports for Analysis using Cubes, Documents and Dashboards
- Published Workbooks by creating user filters so that only appropriate teams can view it.
- Analyzed the source data and handled efficiently by modifying the data types.
- Generated context filters and used performance actions while handling huge volume of data.
- Coordinating with IT and Business in the planning, design, development, and deployment of New Dashboards and Reports and mapping of data from Data warehouse as per requirements
- Upgrading MicroStrategy versions, applying hotfix
- Extensively worked in developing Public objects including Metrics, Derived metrics, Compound metrics and Filters for complex reports.
- Generated dashboards for sales with forecast and lines.
- User Java Script API to customize the views, selects, filters, date and time.
- Generated dashboards with combination charts for clear understanding.
Environment: MicroStrategy 9.4.1, 9.0, Intelligence Server, Web, Administration, Greenplum, pgAdmin 8.3.1, SQL Server 2005 and 2012, PL-SQL
Confidential, Secaucus, NJ
MicroStrategy Administrator
Responsibilities:
- Worked on three different projects starting from creating the fact tables and dimension tables till the creation of the Report service document.
- Administered two MicroStrategy Development systems and one production system. Responsibilities included schema design, creating new users, assigning security model standards, performing object migration/report publication, tuning server settings, tuning SQL, and scheduling weekly maintenance tasks on the metadata.
- Worked one-on-one with business users in developing report requirements, specifications and design.
- Created the transformation tables and developed schema and public objects on top of them to include in the reports which can compare as Is Vs as Was
- Created Report Service Documents for HR and Finance Projects.
- Used Advanced Prompts, Non- Aggregate Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports
- Experience in Mobile SDK to customize mobile application like rebranding, integration with google maps.
- Involved in creating the Technical Documentation for Developers and Check lists for the users for the MicroStrategy Project.
- Involved with Business analyst and Client for requirement gathering.
- Developed reports for the pricing data warehouse which compared business pricing strategies to local competitors. Reporting included category management, executive summaries and price difference.
- Responsible for Administration tasks include creating users and applying access to projects, creating/ duplicating the projects and migrating objects from development environment.
- Created dash boards which evaluates and compares data for Current and Prior months, quarters, years and made available in Interactive mode, Flash mode and PDF mode.
- Received appreciations from Business users for creating Dashboards looks and feel like their sample reports.
Environment: MicroStrategy 9.2.1 (Administrator, Desktop, Architect, Web, Narrowcast Server, Object Manager, Enterprise Manager, Office, Report Services), Teradata, Windows NT
Confidential
MicroStrategy Developer
Responsibilities:
- Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
- Created MicroStrategy Schema objects basically data architecture sand Application objects using MicroStrategy Desktop and Architect.
- Creating Pivot charts and KPI Reports using MS Excel and Lookup functions.
- Developed Customized and Ad-hoc reports in Grid & Graph mode using Templates, Metrics, Filters, Custom Groups, Consolidations and Transformations - The end-users were able to generate Ad-hoc Report by Drilling up, down, within and across dimension or anywhere.
- Execute periodic - weekly & monthly standard reports consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
- Moved Objects from one environment to other.
- Creation of Interactive Dashboards in reports & utilized the new features to convert the dashboards into Flash mode.
- Created Complex Metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
- Tracking enhancement projects to ensure the project delivery on time.
- Effectively manage Changes through Change management process.
- Created Summary and Drill down reports for various attributes based on their hierarchies.
- Efficiently handle and Manage production support activities through Incident Management.
- Project Metrics collection and reporting to senior management.
- Used free form SQL editor for complex report creation.
- Weekly status review with client.
- Identify potential development opportunities and propose innovative solutions.
- Making sure that always sticking with the SLA (Service Level Agreements) commitments and producing SLA report to client and management.
Environment: MicroStrategy 9.2.1, MicroStrategy Desktop, MicroStrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Informatica, Oracle 9i, Oracle SQL Developer, Teradata SQL, Windows XP/2000.
Confidential
MicroStrategy BI Developer/Analyst
Responsibilities:
- Analysis and Design and development of ERP Bolt-on’s for sourcing, demand and retail management
- Coordination and resolution of production issues with support team
- Design and development of BI applications for retail business using MicroStrategy. Development of new reports and metrics for inventory management, retail store operations, pricing, markdowns etc. I had worked on the following projects.
- Regular vs Markdown analysis by department (This report provides analysis to company planning executives for Retail Sales and Inventory, Unit Sales and Inventory and Margin Dollars.)
- Lucky Specialty planning dashboard (This dashboard provide the analysis at Style level).
- Hourly Flash Sales Dashboard (this Dashboard provide the Hourly Unaudited/audited sales and transaction KPIs).
- Worked as a MicroStrategy analyst for the financial Users to support various reporting needs for the business.
- Involved in gathering business requirements and documenting specifications.
- Created the Metadata & Statistic tables for MicroStrategy projects.
- Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
- Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
- Extensively worked on Report Services to create performance dashboard reporting.
- Created drill maps for end users to drill down and recover data.
- Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
- (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
- Involved in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
- Worked on Enterprise manager to generate reports in enterprise manager
- Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services).