We provide IT Staff Augmentation Services!

Microstrategy Developer Resume

2.00 Rating

San Mateo, CA

SUMMARY

  • AWS Cloud Solution Architect Associate (current) with MSTR certs (expired)
  • 10+ years of experience in MicroStrategy Suite (Desktop/Architect, Web/SDK/Narrowcast, & System/Integrity/Enterprise/Object/Operations Manager)
  • Good experience with other tools like Tableau and Power BI
  • Experience in working with the full project life cycle development process, involving analysis, design, development, implementation and testing phases
  • Experience in migrating objects between Development, Testing and Production environments.
  • Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance.
  • Design, developing, deploying, maintaining and integrating complex Microstrategy reports, dashboards, scorecards, freeform SQL reports, objects (Attributes, Logical Views, Filters, Metrics, Transformations, Hierarchies, Drill maps, Facts and Prompts).
  • Extensive experience in designing and developing interactive Dynamic Dashboards using Report Service Objects like Panels, Selectors, Grouping and Grid/Graph combinations.
  • Good experience with Microstrategy Visual Insight reports.
  • Experienced in using Project Merge, Object Manager and Enterprise Manager.
  • Proficient in designing reports through Microstrategy Desktop with optimal usage of key features like Advanced filters, Filters, Prompts, Transformations, Custom Groups, Consolidations.
  • Good experience in Microstrategy Report Service Documents and Dashboards.
  • Good experience in Narrowcast Server and Distribution Services.
  • Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the Cube Services.
  • Used VLDB Properties such as Joins, Query Optimization, Metrics (Null check and Zero check), Select/Insert and Tables.
  • Worked with large databases like Teradata, Oracle.
  • Capable of translating complex business needs into technical solutions (i.e. ability to understand the users’ requirements).
  • Created Analytic based selectors’ grid/graphs that control other grid/graphs through a panel stack, inserting as many panels as needed within a panel stack.
  • Ability to work in multiple projects simultaneously and independently as well as in a team environment.
  • Good knowledge and understanding on data warehouse concepts.
  • Front End Development (JS/CSS/HTML) with D3.js visualizations package experience

TECHNICAL SKILLS

Reporting Tools: MicroStrategy 8.x/9.x/10.x/11/2019, Tableau 10.x, Power BI 2.x

Operating Systems: Windows & Linux Servers

Data warehouse: Teradata, Oracle, SQL Server, MySQL

Data Modelling Tools: Erwin

Cloud: AWS, Azure, Google

Dev Ops: Docker, Serverless + API Gateway

Front End: HTML, CSS, JS, Bootstrap, React/Redux

Web Server Scripting: Unix, PHP, Python

PROFESSIONAL EXPERIENCE

Confidential, San Mateo, CA

MicroStrategy Developer

Responsibilities:

  • Attend meetings to monitor progress of development team upgrade tasks and help drive the process by developing testing requirements
  • Research and test new features of the version 2019 platform and compare the environment from previous sandbox upgrade to v 11.0
  • Conduct regression testing of features from previous versions and assess the new features in upgrade version in view of business requirements fulfillment
  • Assess alternative solutions to business requirements with scope risk

Environment: Windows Server 2016, MicroStrategy 10.x/11/2019, Hadoop & DB2

Confidential, Folsom, CA

MicroStrategy Developer

Responsibilities:

  • Perform administrative tasks including implementation (install software, setup new project) and maintenance (manage database instances, cubes, caching and security privileges for new users)
  • Architect solutions (build schema objects and devise creative solutions for join scenarios to remove cross joins and provide correct data)
  • Work with stakeholders to define reports and dashboards, build dashboards and reports with documents dashboards and visual insight uploads/cubes
  • Majorly involved in understanding the data model from scratch required to generate the reports.
  • Analyzing the existing Excel based reports and transforming them to Microstrategy reports.
  • Created Dashboards with interactive views, trends, ad - hoc reporting and drill-downs.
  • Extensively designed, developed and tested reports and dashboards using best practices for Microstrategy Report Development.
  • Involved in writing complete SQLs required for reporting based on requirement.
  • Hands on writing complex calculations and using the same logic in different ways.
  • Developed dashboards that provide clear visualizations of various industry specific KPIs.
  • End to end experience in designing and deploying the dashboards in Microstrategy.
  • Closely working with stakeholders in gathring project requirements.
  • Closely working with existing devlopers and project lead to understand the application functionality.
  • Generated context filters and used performance actions while handling huge volumes of data.
  • Experience in modifying existing reports and dashboards and analyzing it to develop better visualizations with more detail.
  • Ability to work quickly and under tight delivery deadlines with focus on detail.
  • Working under Agile methodology to deliver the changes to business

Environment: Windows Server 2012, MicroStrategy 10.x, Oracle 9i, SQL Server 2014

Confidential, Universal City, CA

MicroStrategy Developer

Responsibilities:

  • MicroStrategy developer and architect - develop solutions to fulfill Order-to-Cash requirements for Salable Materials order processing and finance operations
  • Build reports, dashboards, presentations, and ad-hoc studies for various internal and external technical and business teams
  • Refactor material sales mobile dashboard to improve performance, change look and feel of user interface
  • Assist in handling production support tickets for Narrowcast Services (edit users of dynamic subscription lists, edit schedules)
  • Involved in identifying the business requirements and translating them into logical design
  • Presented the logical data model to the business and incorporated their suggestions
  • Created a physical data model based on logical design
  • Developed macros in Teradata to load the data from base tables to Businesslayer tables
  • Worked under Agile methodology to deliver the changes to business

Environment: Windows Server 2012, MicroStrategy 9.x/10.x, Teradata 13, Oracle 9i

Confidential, Phoenix, AZ

MicroStrategy Developer

Responsibilities:

  • Lead on and offshore MSTR and other BI tool consultant resources (10 Reporting, ETL, and QA)
  • Develop produce reports, dashboards, presentations, and ad-hoc studies for various internal and external technical and business teams
  • Build MSTR metadata model to enable enhanced reporting of relational database structure for marketing campaign effectiveness analytics
  • Develop dashboard for gauging real-time effectiveness of click-through rates and other metrics associated to social media advertising
  • Manage reporting architecture through a transition from a single marketing channel interface to a multiple marketing channel interface as well as from DB2 to Netezza database platforms
  • Develop reporting capabilities to include new dimensionality associated to the enhanced MSTR metadata model
  • Debug existing reporting applications to meet business requirements and technical specifications
  • Develop architecture documentation surrounding the build plan and associated steps
  • Provide sizing & scope estimates for the projects associated to metadata architectures for enhanced marketing campaign level effectiveness analytics
  • Assist developers in troubleshooting Tableau reports
  • Involved in identifying the gaps and and business reporting requirements and translating them into database requirements.
  • Set up new folder structures, User groups and security filters
  • Developed schema objects needed for report development needs
  • Ensured Row Level Security at database level to access single Timezone data at any point of time
  • Ensured there shouldn’t be data duplication because of various Timezones
  • Worked under Agile methodology to deliver the changes to business

Environment: Windows Server 2008/2012, MicroStrategy 9.x, Tableau 9.x, Netezza, DB2, Oracle 9i

Confidential, Walnut Creek, CA

Tech Lead (.NET Build Manager)

Responsibilities:

  • Manage SDLC Build & Release to QA environment of VB.NET code for OPUS (mortgage originations & tracking) proprietary software application
  • Debug configuration runtime as well as compile time errors related to XML, IIS and VB.NET codes
  • QA business functionality of the application (smoketests) related to HP Quality Center defects
  • Track and develop communications around related application functionality and status of defects
  • Provide guidance to offshore developers related to business functionality and code fixes; participate in code review and design process

Environment: Windows Server 2012, Visual Basic.NET TFS, SQL Server 2012

Confidential, Moffett Field, CA

MicroStrategy Developer

Responsibilities:

  • Data Modeling for the Supercomputing facility (NAS) simulations regarding space flight and other physics related theoretical and practical batteries / tests / simulations
  • Work with Business Intelligence executives to coordinate ad-hoc studies and produce presentations
  • Prototyping a Data Warehouse design for MSTR reporting to facilitate inclusion of different aspects of NAS simulations
  • Consulting the research center regarding solution architecture in the Business Intelligence space
  • Involved in identifying new business reporting requirements and translating them into database requirements
  • Identified the existing reporting needs and ensure that they all delivered in the new business layer
  • Discussed the new model with various business users and ensured that all their requirements are met in the new model
  • Created a new project in MicroStrategy as per the new business layer
  • Created new folder structures, User groups and security filters
  • Developed schema objects needed for report development needs
  • Ensured all reporting standards are met
  • Developed Intelligent Cubes as part of optimizing the load on Data warehouse and support faster data retrieval
  • Worked under Agile methodology to deliver the changes to business

Environment: RHEL 7, MicroStrategy 9.x, Oracle 9i

Confidential, San Francisco, CA

MicroStrategy Developer

Responsibilities:

  • Consult the Bank on its MicroStrategy Architecture - Translate semantic and physical layers into logical models for integration into MSTR Reporting (Teradata)
  • Worked with the end users to gather requirements, generate design documents, develop, and support BI applications developed using MicroStrategy.
  • Created / updated MicroStrategy schema, dashboards, and reports per requirements
  • Install, configure and upgrade MicroStrategy servers (Intelligence Server, Narrowcast, Web, Mobile, etc)
  • Played key role in understaing the reports in Business Objects and identifying the business logic
  • Mapped business objects understandings in Microstrategy requirements
  • Developed a reporting schema based on the understanding
  • Developed and proposed the data model for new business layer
  • Set up new project for this purpose and developed new schema from scratch
  • Designed and deployed security access in MicroStrategy
  • Ensured all reporting standards are met
  • Developed RSD’s as per the user requirements

Environment: Windows Server 2008, MicroStrategy 9.x, Teradata 13

Confidential, Dublin, CA

MicroStrategy Developer

Responsibilities:

  • Lead a team of 4 MSTR reporting consultants
  • Implement Summary Mart Project as Administrator and upgrade server environment from 9.0.2 to 9.2.1
  • Worked with the end users to gather requirements, generate design documents, develop, and support BI applications developed using MicroStrategy.
  • Created / updated MicroStrategy schema, dashboards, and reports per requirements
  • Install, configure and upgrade MicroStrategy servers (Intelligence Server, Narrowcast, Web, Mobile, etc)

Environment: Windows Server 2008, MicroStrategy 9.x, Oracle 9i

Confidential, San Francisco, CA

MicroStrategy Developer

Responsibilities:

  • Implemented MicroStrategy BI platform, MicroStrategy Enterprise Manager, and MicroStrategy Narrowcast Server applications. Assist IT personnel with troubleshooting, development, and knowledge transfer regarding the MicroStrategy toolset.
  • Managed full development lifecycle implementation involving many different levels of user groups. Management functions include facilitating crossfunctional teams of developers, analysts, and users to create fully-functional MicroStrategy projects. Other functions included managing user expectations, user scope, and project deliverables to ensure project success.
  • Served as an administrator in a production environment that included ensuring availability, performance, and change control to provide seamless usage for the users.
  • Worked with the end users to gather requirements, generate design documents, develop, and support BI applications developed using MicroStrategy.
  • Created / updated MicroStrategy schema, dashboards, and reports per requirements
  • Install, configure and upgrade MicroStrategy servers (Intelligence Server, Narrowcast, Web, Mobile, etc)
  • Develop Narrowcast Services and automate delivery of jobs through Command Manager scripts (Unix)

Environment: Windows Server 2008, MicroStrategy 9.x, Oracle 9i, SQL Server 2008

We'd love your feedback!