Previous Job
MicroStrategy Architect
Ref No.: 16-00189
Location: Wilmington, Delaware
Start Date: 12/19/2016
Title: MicroStrategy Architect
Location: Wilmington DE
Duration: Long-term
  • The MicroStrategy Architect/Developer is responsible for the working implementation of features, through software development, design and testing as part of the delivery teams, performed in accordance with the SDLC process.
  • Understand the requirements and Must understand the concept of
  • Experience working with MicroStrategy Developer
  • Experience with Report Services
  • Experience with Rolling Metrics,
  • Experience with VLDB Properties
  • Work on Tuning reports with convert them into Logical Data Model/Hierarchies Slowly Changing Dimensions and should know how to architect them in Microstrategy.
  • Capturing reporting on Current and Historical Data. Transformations. reports. Documents (Dashboards).
  • Nested Metrics, Relationship Filters, etc.. (multi-pass sql, hints, etc) Performance issues.
MicroStrategy Administration
  • Experience with Narrowcast Server( nice to have).
  • Should be able to create Static and Dynamic Subscription sets. position does not need to do any administration work but good to know concepts)
  • Experience with Upgrades, regression testing, etc..
  • Experience with setting up Narrowcast Server.
  • Experience with Object Manager Experience with Intelligence Server / Web Server administration.
  • Experience with Security roles, Security Filters, User management, Access Control Lists, etc..
  • Experience with Enterprise Manager
  • Good Oracle SQL writing skills
  • Good Oracle SQL tuning skills
  • Database Skills
  • Support accomplishing the shared BTG goals.
  • Assume ownership of various initiatives across Solution Delivery and/or BTG as agreed with team or tech lead for complete and successful delivery.
  • Provide functional expertise within his/her skills to assist delivery team members, foster collaboration.
  • Work closely and maintain ongoing communications with project lead, project sponsor, business analyst and technical leads.
  • Provide issue response and root cause analysis on Unicenter and Quality Center tickets as assigned by team lead tech lead or project lead.
  • Escalate issues on a timely basis to team lead, tech lead, and project lead.
  • Communicate incoming work requests to team lead when requested to work on unplanned items.
  • Responsible to work only on tasks assigned by team lead or tech Form
  • Report over or under allocation to the team lead, forecast work remaining, identify and communicate variance to plan.
  • If colleague is a contractor he/she should request approval prior working overtime.
  • Report progress, delays and risks on assigned activities to project lead.
  • Provide feedback on lessons learned and retrospective meetings.
  • Raise awareness when existing code, systems or processes do not meet current quality expectations and standards.
  • Initiate User Account/Hardware/Software requests needed to perform the assigned tasks.
  • Ensure proper Timesheet submittal by the agreed SLA, every week, reflecting actual hours worked on any projects or assignments. Development
  • Develop code, configuration files, build scripts, schemas or other artifacts associated by the features, QC and UC tickets, as assigned by team or tech lead.
  • Maintain code and all related artifacts in source control; perform code merges and resolve conflicts as defined by development process, update documentation and automated tests.
  • Develop unit tests for new code created; modify existing unit tests for altered functionality.
  • Develop system integration test to verify the code running in its functional environment.
  • Work with the project lead, tech lead and team lead to schedule features into Releases.
  • Create implementation plans and Change Management Requests as assigned by team lead or tech lead.
  • Maintain accurate feature status in Quality Center during development by the agreed SLA.
  • Verify build and deployment completeness of the features owned in the QA environment before making it Testing Ready in Quality Center.
  • Design o Analyze the feature requirements as presented by the business analyst and the delivery team, in context of the overall project feature set and existing implementation. Translate requirements to technical concepts.
  • Help business analyst to refine and enhance initial requirements.
  • Contribute to logical/physical data models, class diagrams, activity diagrams, sequence diagrams and UI prototypes.
  • Responsible for organizing code review and obtaining sign-up on the code he/she delivered.
  • Provide follow-ups and resolution to the issues raised on design and code reviews. o
  • Perform peer reviews on code and design as requested.
  • Perform additional design tasks as assigned by team or tech lead.
  • Responsible for documentation and audit artifacts as defined in SDLC and published standards.
  • Provide documentation as appropriate to the Component Owner.
  • Complete documentation in time with the release schedule and SLA agreed with team, tech or project lead.
  • Testing o Test all code, content, build and unit test changes in the lowest environments first, if such environments exist.
  • Develop Unit, Functional and System Integration (SIT) test plans.
  • Execute and document Unit, Functional and SIT tests.
  • Assist QA and production testing and deployment; assume ownership of the feature until passes successful Production Verification Test.