We provide IT Staff Augmentation Services!

Sr. Microstrategy Consultant Resume

SUMMARY

  • Over 7+ years of IT experience in software development, designing and implementing Web based and stand alone software application with major focus on Data Warehousing and Database Applications .
  • 6+ Years of experience on MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy 8.X/9.x/10 product suites including MicroStrategy Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Distribution Services, MicroStrategy Administrator, MicroStrategy Intelligence Server and MicroStrategy Architect, Visual Insights & Mobile.
  • Very proficient in working with large Databases like DB2, Oracle, and Teradata.
  • Extensive experience working with End Users, Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
  • Expertise in Creating Schema Objects and Application Objects.
  • Expertise in using Pass - Through Expressions like Apply Simple and Apply Comparison.
  • Expertise in Creating Documents from multiple Datasets from Intelligent Cubes, Grids and graphs.
  • Expertise in Developing Reports by using Free Form SQL Queries in MicroStrategy Desktop.
  • Expertise in creating dashboards and Scorecards.
  • Expertise in Defining MicroStrategy Narrow cast Server objects like Service, Schedule, Subscription set and Information Objects.
  • Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of Database Flexibility, Caching, Security and Scalability Issues suited for Oracle, Teradata, DB2 and involved in troubleshooting Micro Strategy Web reports
  • Expertise in using MicroStrategy enterprise manager to know user’s typical actions and system usage.
  • Experience in various software development life cycle (SDLC) methodologies including Waterfall and Agile Methodologies.
  • Expertise in working the data modelers and ETL teams in designing the physical and logical schema.
  • Specialized in developing stored procedures/functions, packages and database triggers using Oracle SQL and PL/SQL.
  • Good Experience in onsite and offshore management & ensuring project deliverables from offshore and onsite team members on time.
  • Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.

TECHNICAL SKILLS

BI Tools: MicroStrategy 8.x/9.X/10.X Architect, Desktop, Developer, Web, Object ManagerNarrowcast Server, Distribution services, SDK, Command Manager & Enterprise Manager, Integrity Manager, Transactional Services, Visual Insights

Data Modeling: MS Visio, Erwin 4.x/7.x

RDBMS: Oracle 11g/10g/9i/8i, IBM DB2, Teradata, Netezza, CDW, PDW

Languages: SQL, PL/SQL, HTML, XML

OS: MS Windows NT/2003/XP/ME/95/98, Solaris, Linux

Methodologies: Data Modeling - Logical / Physical / Dimensional, Star / Snowflake

Others: HTML 4.0, DHTML, XML, VB Script, VBA, MS Office, Macromedia FireworksMacromedia Flash, Toad, Visual Studio 2013

PROFESSIONAL EXPERIENCE

Confidential

Sr. MicroStrategy Consultant

Responsibilities:

  • Worked on the business projects based on Standards. Created baseline standard documents which directly helped organizations baseline group to improve their quality of service.
  • Worked on administering web and desktop users by providing access based on reports access and location.
  • Worked on Schema layer including attributes, facts, Hierarchies, Transformations based on the requirements.
  • Created Security Filters to be assigned to restrict external user report data levels.
  • Worked on tidal a third party tool for job runs based on the ETL load process in the database.
  • Extensively worked in developing report objects including Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Created different level of filters to render data based on the user requirements.
  • Designed report components, Templates and objects to generate reports in grid and graph mode.
  • Created default prompt selections for the report to save execution time and performance.
  • Designed dynamic dashboards by presenting them in visually intuitive, quick interactive grids and graphs.
  • Created dashboards using different types of selections, dropdowns and filters.
  • Created dashboards with dynamic data by including Panels, Panel Selectors and Tabs.
  • Worked on analytical and governing settings for performance tuning of reports and dashboards.
  • Worked on creating Report Service documents using multiple Grids and Graphs based on the report requirements.
  • Performed Upgrade of MicroStrategy software from v10.2 to v10.4
  • Worked on distribution services to schedule report delivery based on time and event based subscriptions.
  • Documented test plans and provided feature/functionality/usage scenarios for the Managers.
  • Validated the SQL query, prompt ordering, security filters, export/print functionality and drilling options on reports and dashboards.
  • Involved in dashboard design and reports development based on business requirements.
  • Worked on mobile app compilations for IPads using Xcode.
  • Created Free-Form SQL reports based on the business and user requirements.
  • Designed dashboards in PDF and flash modes using report documents.

Environment: MicroStrategy 10.2/10.4, Desktop Reports, Web Reports, Architect, Distribution Services, Administration, Dash Boards, Object Manager, MicroStrategy Web, Enterprise Manager, Narrowcast Server, Windows XP, SDK, Excel, SQL Server2003/2008, SQL, Oracle, SSRS 2012, Visual Insights

Confidential, WI

Sr. MicroStrategy Consultant

Responsibilities:

  • Documented all the baseline projects based on Standards. Created baseline standard documents which directly helped organizations baseline group to improve their quality of service and It also helped to resolve the tickets faster and efficient way.
  • Worked on MicroStrategy Architect by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Developer.
  • Worked with Data modelers and respective members in designing the physical and logical models
  • Developed process to migrate objects, reports and documents within different environments.
  • Extensively worked in monitoring projects tasks like jobs, schedules, subscriptions, sessions, cache using administration.
  • Created Security Filters to restrict information and provide row level data access to the end Users.
  • Created dynamic dashboards and Visual Insights with Multiple Panels, Panel Selectors and Tabs.
  • Worked extensively on report development using metrics, filters, prompts, consolidations and custom groups.
  • Improved report performance using VLDB settings at project and report levels.
  • Implemented SSO in MicroStrategy developer and web using windows authentication.
  • Configured different IIS features on MicroStrategy web server to integrate SSO functionality.
  • Worked on integrating LDAP server with MicroStrategy developer.
  • Worked on configuring enterprise manager to log project level statistics and improve the performance of the system.
  • Created schedules to refresh intelligent cubes on a daily basis when the ETL process triggers.
  • Worked on project configuration and intelligence server configuration to fine tune MicroStrategy application.
  • Used Object Manger to migrate objects across different environments
  • Worked on end user access using ACL’s in MicroStrategy developer.
  • Designed test plans and provided functionality, usage scenarios to the business.
  • Worked on MicroStrategy software version upgrades based on availability.

Environment: MicroStrategy 10.0/10.2, Developer Reports, Web Reports, Architect, Distribution Services, Administration, Object Manager, Enterprise Manager, Operations Manager, Command Manager, MicroStrategy Web, Windows 2012R2, SDK, Excel, SQL Server2005/2008, IBM DB2.

Confidential

Sr. MicroStrategy Consultant

Responsibilities:

  • Worked on the business projects based on Standards. Created baseline standard documents which directly helped organizations baseline group to improve their quality of service.
  • Worked with business users and respective members in designing physical and logical models.
  • Worked on administering web users by providing access based on reports access and location.
  • Worked on Schema layer including attributes, facts, Hierarchies, Transformations based on the requirements.
  • Created Security Filters to be assigned to restrict external user report data levels.
  • Worked on SDK module to create custom notifications on web server.
  • Extensively worked in developing report objects including Metrics, Derived metrics, Compound metrics and Filters for complex reports.
  • Created different level of filters to render data based on the user requirements.
  • Designed report components, Templates and objects to generate reports in grid and graph mode.
  • Created default prompt selections for the report to save execution time and performance.
  • Designed dynamic dashboards by presenting them in visually intuitive, quick interactive grids and graphs.
  • Created dashboards using different types of selections, dropdowns and filters.
  • Created dashboards with dynamic data by including Panels, Panel Selectors and Tabs.
  • Worked on analytical and governing settings for performance tuning of reports and documents.
  • Worked on creating Report Service documents using multiple Grids and Graphs based on the report requirements.
  • Documented test plans and provided feature/functionality/usage scenarios for the Managers.
  • Validated the SQL query, prompt ordering prompt defaults, security filters, export/print functionality and drilling options on reports and dashboards.
  • Involved in dashboard design and reports development based on business requirements.
  • Created Free-Form SQL reports based on the business and user requirements.
  • Designed dashboards in PDF and flash modes using report documents.

Environment: MicroStrategy 9.0/9.3/9.4.1/10 Desktop Reports, Web Reports, Architect, Distribution Services, Administration, Dash Boards, MicroStrategy Web, Windows XP, SDK, Excel, SQL Server2003/2008, SQL, Oracle, SSRS 2012, Visual Insights

Hire Now