We provide IT Staff Augmentation Services!

Microstrategy Sr. Architect/ Developer Resume

2.00/5 (Submit Your Rating)

Washington, DC

SUMMARY

  • Over 6+ Years of strong IT Experience in Business Intelligence (BI), ETL and Data Warehousing Project Development and Implementation using MicroStrategy 10.x/9.x/8.x product suites including Administrator, Intelligence Server, Architect, Desktop Designer, Security Administration, MicroStrategy Web Administration, Object Manager, Command Manager Integrity Manager, Report Services, Enterprise Manager, Narrowcast Server and Dashboards.
  • Certified in MicroStrategy Advanced Analytics Reporting - 10.412
  • Used a variety of other technologies, including Informatica, and self-taught Tableau & Spot fire.
  • Expertise with entire Software Development Life Cycle (SDLC) which includes requirement gathering and analysis, Design and Development, Implementation, Testing, Deployment, Production support and Maintenance, Built and Release management.
  • Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation, Custom Groups and Intelligent cubes) with the d Confidential warehouse.
  • Extensively worked on Dashboard components including Widgets, panels, selectors& layouts for a dashboard implementation, Report tuning, Report testing, Ad-hoc, Mobile and Business Users in various OLAP services in MicroStrategy.
  • Expert in creation of Report Service Documents, Scorecards and Dashboards which helps in better understanding of business trends.
  • Good understanding of intelligent cubes and Visual insights, and good knowledge in Analysis, design and construction of the metad Confidential .
  • Excellent knowledge of fundamental d Confidential warehousing concepts like dimensional modeling d Confidential mart modeling, star and snow flake schemas.
  • Strong experience in MicroStrategy connectivity with several d Confidential bases such as Oracle, SQL Server, Terad Confidential, Netezza, MS Access.
  • Exposure in SDK design, development, implementation.
  • Experience in connecting d Confidential warehouses directly to the MicroStrategy Cloud Platform via VPN and also Uploading a backup of d Confidential warehouse d Confidential to MicroStrategy D Confidential Warehouse Services servers.
  • Experience inMicroStrategyschema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation and testing.
  • Experience in various Performance Tuning methods such as Aggregate Tables, Caching, VLDB settings, Partition Mapping and Creation of indexes on tables. Worked extensively on MicroStrategy mobile for IPad & iPhone on design, architecture and mobile administration.

TECHNICAL SKILLS

BI Tools: MicroStrategy Desktop, Architect, Web, Intelligence server, Administrator, Report Services, Command manager, SSRS, Tableau Desktop,Spot fire Server

ETL Tools: Microsoft SQL Server Integration Services, Informatica, Fast Loads, Multi Loads

Languages: C, C++, Java, PL/SQL and Objective-C.

Supporting Tools: MS Project, SQL Navigator, TOAD, and Adobe Flash

OLAP Tools: MicroStrategy, Oracle server.

Technologies: Servlets, Struts, Hibernate, Spring, Log4j, Web services using SOAP and RESTful, XML, JDBC, JSP and JDBC, Spring 4.x, Hibernate, JSP, MVC, Struts, Servlets, jQuery, AJAX.

D Confidential bases: Oracle11g/10g/9i, My SQL Server, Terad Confidential 13.x/V2R6, Netezza, Sybase.

IDE: Eclipse, Intellij, Notepad++, Visual Studio, Spring Tool Suite and RAD.

PROFESSIONAL EXPERIENCE

MicroStrategy Sr. Architect/ Developer

Confidential - Washington, DC

Responsibilities:

  • Responsible for the Creation of Project source and projects.
  • Responsible for the Creation of Schema Objects like Tables, Attributes, Facts, Hierarchies and Public objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups & Consolidations and other public objects.
  • Responsible for designing the Reports as per the user requirement.
  • Report manipulations using various options like: d Confidential pivoting, page by, sorting, totals, thresholds, etc.
  • Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
  • Responsible for creating Transactional Service Reports.
  • Responsible in testing the reports/dashboards before moving to other environments.
  • Responsible for moving the projects from one environment to another environment (using Object Manager)
  • Integrated the MicroStrategy reports access with third party applications.
  • Responsible for d Confidential validation using sql queries across the d Confidential base to validate reports d Confidential .
  • Document the unit test case results at both report level and d Confidential base (sql queries)
  • Responsible for the Creating the necessary documents like URS, UTR's UAT's and other documents.
  • Providing knowledge to Users both in MSTR Desktop and Web.

Environment: MicroStrategy 10.4, Ab-Initio, Big D Confidential, DB2

Confidential - McLean, VA

MicroStrategy Developer

Responsibilities:

  • Involved in the meetings with business users to discuss and finalize the requirements and user stories. Worked with credit desk risk managers and gathered reporting requirements.
  • Involved in Dimensional D Confidential Modeling (Star Schema) D Confidential Architecture, Business and D Confidential Analysis (customer and financial reports)
  • Involved in Creation of Schema Objects (Attributes, Facts, Hierarchies and Transformations) from Warehouse C Confidential log and also involved in Creation of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Drill Maps) regarding in generation to customer and financial reporting.
  • Involved in Setting VLDB Properties at Report, metric and d Confidential base instance Levels to manage joins, metric calculations and query optimizations.
  • Involved in creation of Consolidation and Custom groups to group elements of attributes based on Filter conditions.
  • Expertise in using pass through functions like Apply Simple and Apply Comparison.
  • Created different kinds of dashboards and documents using different controls, selectors, sliders, Links and widgets to view in different kinds of modes like DHTML, Flash mode. Worked on different document modes like design, editable mode and interactive modes.
  • Involved in Creation of simple metric, compound metric, derived Metric, filter metric and Transformation metric to meet end user requirements.
  • Supported end user Ad-hoc request. Responsible for troubleshooting report d Confidential .
  • Created Ad-hoc reports by drilling up, down and across Hierarchies.
  • Involved in partitioning the tables, indexes and management of the schema objects.
  • Involved in optimization of code and tuning queries for performance.
  • Involved In testing of reports and queries by test cases and test plans.

Environment: MicroStrategy 10.4/ 10.2 /9.4.1 , Developer, Architect, Administrator, Reports, OLAP Services, Dashboards, Intelligent Cubes, Visual Insights, Terad Confidential .

MicroStrategy Developer

Confidential - NY

Responsibilities:

  • Used TIBCO Spotfire to analyze and obtain insights into large d Confidential sets.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Created visually compelling interactive reports and dashboards.
  • Found the right balance between manipulating d Confidential using Spotfire versus using a programming language.
  • Possess SQL and programming knowledge to deal with d Confidential transformations and translations.
  • Designed Practical D Confidential Visualizations, Charts, Dashboards, Prototypes and Demos, published it in Spotfire for Analytical Projects and D Confidential Visualization Community.
  • Creating d Confidential sources, parameter information links, joins, filters in information designer for fetching d Confidential in to Spotfire as per the business needs.
  • Designed and implemented real-time monitoring Dashboards for TIBCO Spotfire Server and Visualization Community.
  • Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Environment: TIBCO Spotfire, Spotfire Web Player, JIRA, Oracle, SQL, HTML, Python, Unix.

MicroStrategy Developer

Confidential - Whippany, NJ

Responsibilities:

  • Lead transition process from Confidential to Infosys for MicroStrategy. Created Ad-hoc reports by gathering specific requirements from the different business units (Oncology, Radiology, WHC, etc.)
  • Interacted with users from different functional teams across the organization in gathering requirements for developing Sales dashboard and Performance Index Healthcare dashboards
  • Worked closely with Offshore Admin team in building Attributes, facts, Hierarchies across different BU's
  • Built various MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
  • Created report services documents for IC (Incentive Compensation) records and Sales analysis.
  • Worked on the Excel formatting, macros and templates of the documents which are used in different services.
  • Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
  • Extensive Testing and D Confidential validation of Reports before delivering it as Business takes important decisions on d Confidential we provide.
  • Used Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary
  • Experience in using Terad Confidential utilities such as Fast load, Multiload and Fast Export.
  • Developed complex dashboards in Tableau as a part of MDM-Tableau uplift project from scratch.
  • Gathered requirements from different stake holders from MDM team to develop 30 dashboards across multiple Business Units.
  • Created status reports and used Jira for tracking the issues and D Confidential Service Request(DSR's) from Business users.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), Terad Confidential

MicroStrategy Developer

Confidential

Responsibilities:

  • Worked as a MicroStrategy analyst for the financial Users to support various reporting needs for the business.
  • Created Metad Confidential & Statistic tables for MicroStrategy projects.
  • Involved in Conversion of Corporate D Confidential Model into a Warehouse Star and Snowflake Model.
  • Involved in normalizing the d Confidential from source systems by identifying columns in the table, which came in as fully De-normalized flat file.
  • Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
  • Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect.
  • Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc.
  • Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, Custom Groups and Consolidations for complex reports.
  • Extensively worked on Report Services to create performance dashboard reporting.
  • Created drill maps for end users to drill down and recover d Confidential .
  • Created Aggregate Tables, Control Tables and Staging tables in Terad Confidential . (Meta) D Confidential standardization, naming convention standardization across multiple projects for an enterprise level strategy.
  • Involved in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
  • Worked on Enterprise manager to generate reports in enterprise manager
  • Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), Terad Confidential, SQL2000.

Java Developer

Confidential

Responsibilities:

  • Deployed WAR applications in Web Logic.
  • Involved in prototyping, proof of concept, design, Interface Implementation, testing and maintenance.
  • Created use case diagrams, sequence diagrams, and preliminary class diagrams for the system using UML/Rational Rose.
  • Designed and developed the persistence tier using Hibernate framework.
  • Designed and developed front view components using JSP and HTML.
  • Developed re-usable utility classes in core java for validation which are used across all modules.
  • Developed UI navigation using Spring MVC architecture. (JSP, JSF, tiles, JSTL, Custom Tags).
  • Created JSF components for presentation layer.
  • Used JNDI to support transparent access to distributed components, directories and services
  • Used Core Spring for Dependency Injection of various component layers.
  • Used SOA REST (JAX-RS) web services to provide/consume the Web services from/to down-stream systems.
  • Deployed and tested the application with web server Tomcat, WebSphere.
  • Developed Interactive web pages using AJAX and JavaScript.
  • Worked on Report Module, generating PDF/ CSV according to template.
  • Configured and tested the application with d Confidential base server MySQL.
  • Developed various objects using java and HTML and DHTML to maintain well-structured GUI and to interact with Controllers to get d Confidential from MySQL d Confidential base.
  • Involved in developing various reusable Helper and Utility classes using Core Java, which are being used across all the modules of the application.
  • Used the built tools Maven and ANT for clubbing all source files and web content in to war files.
  • Helped in d Confidential base design and tuning.
  • Created stored procedures, Views in the D Confidential base.

Environment: Core Java (Multithreading, Collections), JSP, JSTL, Servlets, Spring, MySQL, XML, HTML, Java Script, AJAX, SOAP, JDBC, Shell Scripting, JUnit, log4j, JMS, Apache Tomcat, WebSphere.

We'd love your feedback!