We provide IT Staff Augmentation Services!

Sr. Microstrategy Developer Resume

SUMMARY:

  • 7+ years of strong experience in Business Intelligence in designing and implementing Web based and Standalone software application with major focus on Data Warehousing and Database Applications.
  • 5 years of extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.i/ 7.5/8.0/8.1/9.0/9.0.1 , Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
  • Expertise in Desktop creating and integrating MicroStrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
  • Extensively worked on designing schema and creating Facts, Attributes, Hierarchies and Transformations
  • Worked extensively on VLDB Properties for performance tuning.
  • Extensively worked on creating Dynamic Dashboards with multi layout and used custom Widgets built on flex for specialized dashboard.
  • Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations.
  • Strong Data modelling (Logical and Physical) experience with high proficiency in using ERwin for Dimensional Modelling (Star, Snowflake schemas) and Entity - Relationship Modelling.
  • Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
  • Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
  • Extensive knowledge of SQL, PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2005/2008

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy, Business Objects, MS Analysis Services, Informatica

Databases: Oracle 8i/9i/10g, Teradata, Netezza MS SQL Server 6.5, Db2 and MS Access

Tools: Toad, Erwin

Operating Systems: Windows NT 4.0 /NT Server/2000/XP Pro/2003 Server, Unix

Languages: Visual Basic 6, C, SQL/PLSQL

WORK EXPERIENCE:

Confidential

Sr. MicroStrategy Developer

Responsibilities:

  • Involved in the documentation of technical specifications of the Sales and Inventory Project.
  • Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
  • Created different Project Sources for different environments like production, testing and development.
  • Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
  • Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
  • Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
  • Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
  • Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
  • Created Ad-hoc reports by gathering specific requirements from the different users.
  • Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
  • Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
  • Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
  • Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, Information objects.
  • Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that particular user.
  • Worked on the excel formatting, macros and templates of the documents which are used in different services.
  • Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
  • Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.0/9.0.1 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Narrowcast Server, Oracle 9i, Informatica power center 6.2, Toad and Windows XP Professional.

Confidential, Ann Arbor,MI

MicroStrategy Developer/Architect

Responsibilities:

  • Involved in upgrading MicroStrategy projects 7.3 to 8.0.
  • Communicated with business for gathering information’s, designing, developing, administrating and maintaining MicroStrategy based reporting applications.
  • Involved in performance enhancement and tuning of Microstrategy projects for better performance, accurate SQL and report.
  • Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Microstrategy Desktop.
  • Customization of reports for creating various invoices and forms for decision makers by using XML and XSLT Style sheets.
  • Creating corporate level Dashboards for senior level managers in Flash and Interactive modes using different kinds of Widgets & Selectors.
  • Created user profiles, managed privileges and access of users of various groups using MicroStrategy Administrator.
  • Involved in various Narrowcast task like creating Documents, service designs, subscription, administration and scheduling.
  • Created Enterprise Manager Reports for checking various analysis including Object Dependency, Cache Management Reporting, User Session and User Group analysis.

Environment: MicroStrategy 7.3/8 (Desktop, Administrator, Architect, Intelligence Server, Narrowcast Server, Web, Office), XML, XSL, XSLT, Oracle 9i, SQL Server2005, MS Office, Windows 2000.

Confidential, Fremont, CA

MicroStrategy Consultant

Responsibilities:

  • Responsible for gathering and refining business requirements from the Business users.
  • Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies
  • Responsible for creating Metrics, Filters, Custom Groups, Prompts using Microstrategy Desktop
  • Configured the Narrowcast Server for the Microstrategy Environment
  • Used the Narrowcast Administrator for administering users.
  • Created the Publications, Information Objects & Services in the Narrowcast application
  • Created Users, roles & privileges in the Microstrategy Environment using the Administrator
  • Responsible for maintaining I server.
  • Troubleshooting inconsistencies in the Metadata using ScanMD
  • Used the Object Manager to migrate objects to different environments.
  • Worked on cost containment dashboard project for executive users to see penetration, discounts and performance.
  • Worked on Internet Dashboard project which points to operating system for real time analysis report on claim process.
  • Heavily worked with the end users to finalize the Dashboard layouts and also worked on fine detail formatting for a desired look and feel.
  • Involved in Testing and Data validation of Reports
  • Involved in End-User training, Support and Maintenance.
  • Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment
  • Very good in using the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary.
  • Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, week to year and effectively used them with the metrics.
  • Optimized Query Performance by using VLDB settings
  • Involved in Business Intelligence tool Product Evaluation
  • Worked on standardizing Microstrategy environment
  • Responsible for Job Monitoring and maintaining the cache on the I Server

Environment: Oracle10g, SQL server, Informatica, MicroStrategy 8.0.2(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Toad 8.6.1

Confidential, Boise, ID

Senior MicroStrategy Developer

Responsibilities:

  • Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
  • Generated status reports after performing thorough research in order to discuss the issues related to Warehouse tables, Zeroes/Nulls, missing columns and naming conventions etc.
  • Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
  • Used project merge wizard and user merge wizard to merge projects and merging users & groups in Object Manager.
  • Created Transformations (table based, formula based) for using in comparative reports like sales of various pharmaceutical products this year to last year (year to date and month to date).
  • Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment.
  • Converted existing interactive reports with prompts to non-prompted reports for Narrow casting.
  • Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
  • Exported data from Teradata using Fast Export utility.
  • Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.
  • Involved in creating user groups and security filters for users and assign privileges.

Environment: MicroStrategy 8.0.3/8.1(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata V2R6, Teradata SQL Assistant, SQL Server, Brio. Cognos, Crystal Reports, Oracle 10g, Informatica

Confidential

Software Developer

Responsibilities:

  • Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program
  • Physical Implementation of database into SQL Server 2000 using T-SQL.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Created complex stored procedures and functions to support efficient data storage and manipulation
  • Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database
  • Data migration (import & export -- BCP) from Text to SQL Server
  • Generated ad-hoc reports using MS-Access and Crystal Reports
  • Coordinated post-implementation events such as testing

Environment: SQL Server 2000, T-SQL, Excel, Access, Crystal Reports 9.0 and Windows NT

Hire Now