Microstrategy Developer Resume
Dallas, TX
SUMMARY:
- Over 6+ years of strong experience in design, development and implementation of Business Intelligence Solutions, Client/Server, Internet/Intranet and Web based applications that includes over 4+ years of expertise in Data Warehousing and Reporting applications.
- Solid experience in business requirements analysis, development, testing. Business Intelligence applications.
- Extensive experience in developing Business Intelligence applications for cross - functional teams on multiple projects and across multiple environments using MicroStrategy
- Knowledge of Data Warehousing concepts, Dimensional, Logical and Physical data modeling, Star and Snow Flake Schemas, Slowly Changing Dimensions and ROLAP/MOLAP.
- Expertise in building MicroStrategy Business Intelligence Projects and creating Schema and Application Objects like Attributes, Facts, Hierarchies, Filters, Metrics, Prompts, Reports, Documents, dynamic Dashboards for day-to-day fact-based decision making and ad-hoc analysis.
- 5+ years of experience in developing SQL on databases such as Oracle, SQL Server.
- Good working knowledge of Extraction, Transformation, and Loading of data from different sources using ETL tools such as Informatica, Oracle Warehouse Builder.
- Working familiarity with full Software Development Life Cycle (SDLC) using various development methodologies like Agile
SKILL:
Business Intelligence: MicroStrategy 9/8.1.2 (MicroStrategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Narrowcast Server.
Languages: C, SQL
Operating Systems: MS-DOS, Windows 98/NT/2000/XP/VISTA/7.
Web Technologies: MS Front Page, HTML.
Databases: Oracle 10g/9i, SQL Server 2005
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Microstrategy Developer
Responsibilities:
- Analyzed the business requirements identifying the requirements reviewing and communicating with business.
- Worked with Data Architect in Designing the Data Model.
- Installation of Microstrategy Desktop and creating a Microstrategy project.
- Creating Attributes, Facts and relationship between attributes using Microstrategy Architect.
- Importing tables using Warehouse catalog and Creating Logical Tables.
- Generated and implemented Microstrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using Microstrategy Architect.
- Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
- Analyzed and developed the new objects in Dev environment and after testing the objects and reports migrated to Production Environment
- Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
- Defining Drill Hierarchies and creating relationship between attributes.
- Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
- Created reports using complex filters and compound metrics and prompts.
- Creating reports from intelligent cubes, Datamart Reports.
- Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
- Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
- Involved in creating security filters to end users to access data based on their privileges.
- Created services using Subscription sets, Schedules, and Information Objects.
- Designed and developed the Dynamic dashboards.
- Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
- Extensively used report services to create dashboards to create summary level reports using multiple datasets.
- Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
Environment: Microstrategy 9.2.1, Report Services, Microstrategy Desktop, Microstrategy Web, Mobile, Microstrategy Dashboards, MS-Excel, Toad, Oracle 10g.
Confidential, New York, NY
Microstrategy Consultant
Responsibilities:
- Worked with business analysts to baseline the reporting requirements.
- Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer.
- Worked with data architects on data needed for testing the reports and dashboards.
- Extensively worked with Microstrategy architect to develop schema objects such as, attribute, facts, hierarchies, consolidations and transformations etc.
- Extensively used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups etc.
- Createddrill mapsfor end users to drill down and recover data.
- Extensively worked with Microstrategy Intelligence Server, MicroStrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.
- Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
- Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
- Took part in design and development of Data marts and integrating them with Data warehouse.
- Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
- Designed and DevelopedMicrostrategy Dashboards using customized Widgets.
- Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
- Extensively used report services to create dashboards to create summary level reports using multiple datasets.
- Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
- Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
- Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
Environment: Microstrategy 9.0.2 (Administrator, Architect, Desktop, Web), Windows XP, MicroStrategy Dashboard, Oracle 10g, Toad for Oracle.
Confidential, Stamford, CT
Microstrategy Developer
Responsibilities:
- Involved in gathering business requirements and documenting specifications.
- Creating Views in the database and Logical Views in the MicroStrategy.
- Extensively worked with MicroStrategy Desktop. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
- Worked on creating MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
- Developed, implemented and maintained unit tests for applications.
- Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
- Tuning of the MicroStrategy Reports using Data Mart Reports, Aggregatable Tables and Intelligent Cubes.
- Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
- Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
- Expertise on Partition Mapping concept in Microstrategywhich will improve the performance.
- Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
- Expertise in developing the dashboards and having goodknowledge in using widgets and all components of dashboards.
- Expertise in using the Architect in desktop.
- Proficient in creating the Drill and User Hierarchies.
- Having knowledge in developing the Expression and Table based Transformations.
- Expertise in creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
- Expertise in Monitoring the Jobs, Caches and Intelligent Cube
- Having good knowledge in Creating Database Instances.
Environment: Microstrategy 9.01 (Administrator, Architect, Desktop, Narrowcast Server) MicroStrategy Narrowcast server, Windows XP, MicroStrategy Dashboard
Confidential, Dallas, TX
MicroStrategy Developer
Responsibilities:
- Worked as a MicroStrategy developer for the 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.
- Createddrill mapsfor 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.
- Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Report Services), Oracle.
Confidential
Business Intelligence Analyst
Responsibilities:
- 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.
- Createddrill mapsfor 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).