We provide IT Staff Augmentation Services!

Microstrategy Developer Resume

TampA

SUMMARY:

  • 8+ years of experience in Information Technology that includes Design, Development, Implementation and Support.
  • More than seven years of experience with Microstrategy working with Desktop, Architect and Web.
  • Microstrategy Certified Project Designer/Report Developer.
  • Working experience in many industrial sectors like Financial, Retail.
  • Strong troubleshooting capabilities in Microstrategy Desktop.
  • Extensively worked on Schema Design creating Attributes, Facts, Hierarchies and Transformations.
  • Experience in developing public objects like Metrics, Advanced Metrics, Filters, Advanced Filters, Prompts, Custom Groups, and Consolidations as per the user requirements.
  • Strong skills with various Microstrategy administration tools (Narrowcast Manager, Command Manager and Systems Manager)
  • Experience in full Software Development Life Cycle (SDLC).
  • Experience in working with various type of SCDs.
  • Involved in dimensional modeling of Databases for data warehouse using Erwin and desiging different schema models(Star & Snow Flake).
  • Very good knowledge in Informatica.
  • Strong skills of working with databases like Oracle, SQL Server and Teradata
  • Extensive experience in development of SQL Queries, Stored Procedures and Triggers.
  • Excellent analytical, communication and problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Windows 7, Windows Server 2012, MS - DOS and UNIX.

OLAP: Micro Strategy 10.4.0 (Intelligence Server, Desktop, Web, NarrowCast Server), Business Objects 5.1.4 (Designer, Business Object, Supervisor, Web Intelligence).

Tools: Computer Associate’s ERWIN 3.5.2/4.1,MS Project, MS Excel, MS Word, MS PowerPoint, Visio, SQL*Loader, SharePoint, Documentum.

ETL Informatica: Power Center and Accentual Data Stage

Languages: PL/SQL, SQL and Visual Basic

RDBMS: Oracle 12g, Teradata, MS SQL Server and MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Tampa

Microstrategy Developer

Responsibilities:

  • Analyzed the reporting requirements and created various mockup dashboards.
  • Created various report services and Dashboard documents using freeform SQL to achieve the desired output.
  • Involved in migrating objects across different environments.
  • Created cases and scenarios based on business and functional requirements.
  • Performed thorough testing of Microstrategy Reports against the Database using manual.

Confidential, New York

Microstrategy Developer

Responsibilities:

  • Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
  • Built and Demonstrated various visualizations via mockup walk through sessions.
  • Trained business users on self-service reporting capabilities that helps to leverage existing datasets for regional or department or team specific reporting needs.
  • Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Analyzed various existing Business Objects reports and replicated the same in MicroStrategy.
  • Created various report services and Dashboard documents.
  • Designed and developed Dashboards for interactive analyses using widgets and selectors.
  • Extensively worked on the intelligent cubes.
  • Involved in migrating objects across different environments.
  • Created cases and scenarios based on business and functional requirements.
  • Performed thorough testing of MicroStrategy Reports against the Database using manual and Integrity Manager.

Confidential, Tampa, Florida.

Microstrategy Developer.

Responsibilities:

  • Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
  • Created technical and functional specifications, including relational database design, using business and system use cases and Visio diagrams.
  • Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, administered all aspects of web and intelligence server and Narrowcast Server.
  • Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments
  • Customized Microstrategy web using SDK.
  • Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.
  • Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
  • Automated and improved existing manual processes. Optimizing the server platforms using Caching and Scheduling.
  • Involved in Microstrategy Production upgrade activities.
  • Worked with back end Database Administrators to provide requirements for necessary back end tables.
  • Extensively worked in both Ad-hoc and Standard Reporting Environments and Involved in creating Reports scalable to large volumes of data. Managed projects through entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.

Environment: Microstrategy 9.4.0/ (Desktop, Administrator, Web), Microstrategy Intelligence Server 9.4.0, Microstrategy Narrowcast Server 9.2/8.1.2, Oracle 11g, Windows 7.

Confidential, White Plains, New York.

Microstrategy Architect/Developer.

Responsibilities:

  • Involved in gathering of business requirements.
  • Involved in design of the project logical model.
  • Architected schema objects such as attributes, facts and transformations.
  • Created various MicroStrategy objects such as Metrics (simple and compound), Filters, Prompts, Custom Groups, Consolidations, etc.
  • Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
  • Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.
  • Writing BAT file to call Command manager to execute Service.
  • Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
  • Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
  • Micro strategy IServer Tuning for performance.
  • Created various event based Schedules.
  • Deploying Flash Widgets on Servers and Uploading the New ones from Support site.
  • Created reports with various object prompts to generate various Ad hoc reports.
  • Worked with Erwin in designing the schema for database views.
  • Created many Materialized views in Oracle which act as Mart tables.
  • Created various Report Services Documents for SPG and SVO Activity with various transformation metrics to report on Monthly, YTD and Trailing 12 month’s period.
  • Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
  • Created various Narrowcast reports, subscriptions and schedules.
  • Created Informatica Mappings for Monthly data load from FTP site to the Data warehouse.
  • Involved in Microstrategy version 9.0 product evaluation.

Environment: Microstrategy 9.0/8.1.2 (Desktop, Administrator, Web), Microstrategy Intelligence Server 8.1.2, Microstrategy Narrowcast Server 8.1.2, Oracle 10g, Windows XP.

Hire Now