Microstrategy Architect/Devloper

Pratibha Singh

MOBILE: +1-980-***-****

adbnv1@r.postjobfree.com

Summary:

Over 9 years of IT experience with strong expertise in using MicroStrategy Tool Suite as Senior Microstrategy consultant including Architecting, Reporting, Dashboarding and Administration.

Extensive experience with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Office and MicroStrategy Narrowcast Server,Microstrategy Visualization.

Participated in the Software Development life-cycle of the data warehousing and Business Intelligence project.

Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy 10.x/9.x/8.x versions.

Expert in Designing Data Marts using different multi-dimensional modelling techniques such as Star Schema and Snowflake Schema, FACT and Dimensional tables, Logical and Physical data modelling.

In-depth knowledge of data warehousing concepts such as entity relational modelling, dimensional modelling, star and snowflake schemas, modelling data marts, front room architecture, back room architecture, security and deployment.

Strong expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies, Functions and operators.

Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates, Documents, Custom groups and Consolidations).

Expert in creation of Report Service Documents, Scorecards and Dashboards which helps in better understanding of business trends.

Sound knowledge of 2-Tier Client/Server Architecture and N-Tire Architecture.

Strong knowledge of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.

Proven troubleshooting capabilities in MicroStrategy Desktop.

Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for different databases.

Worked extensively on Netezza, Oracle, Teradata, DB2, and SQL Server with Micro strategy Suite.

Handled Slowly Changing dimensions in a Data warehouse depending on the changes in business dimensions.

Expertise in test planning and testing methodology for Quality Assurance validation of MicroStrategy configuration, reports and other output.

Excellent problem solving skills with strong technical background and good interpersonal skills.

Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Performed the role of team member/developer dedicatedly. This dedication and never say die attitude with lot of spontaneity and flexibility comes to me naturally at work.

Education

Completed MS in Information technology from University of North Carolina at Charlotte (UNCC) with GPA 4.0 in the year 2015.

Completed Bachelor of Engineering (Computer Science) from Rajiv Gandhi Proudyogiki Vishwavidyalaya (RGPV) in the year 2006.

Professional Experience:

Bank of America, NC July 2015 – Mar 2019

Senior MicroStrategy Architect

Responsibilities:

Working as a MicroStrategy Architect and developer in reporting team and support Saber 2 build out initiative.

Design and develop interactive reports based on the Actuate reports.

Analyzed complex SQLs and converted into MicroStrategy reports.

Work with Business analyst on understanding user’s requirements and interpret their needs into reports.

Involved in MicroStrategy Architect work, which includes Schema development.

Created MicroStrategy reports/documents compatible to excel and PDF.

Created freeform reports with Multi-source options.

Optimize MicroStrategy reports based on VLDB properties.

Involved in Migration of MicroStrategy projects and objects from Development to Testing environment.

Provided suggestions to other teammates in case of difficult design and data issues.

Involved in code review and testing of reports in terms of data and design.

Created Visualizations based on users requirements.

Working in Agile methodology.

Environments: MicroStrategy 10.1.1 (Desktop, Web), Netezza, Teradata, Oracle 11g, SQL Developer.

CITI, NC Nov 2014 – June 2015

MicroStrategy Consultant

Responsibilities:

Worked as a MicroStrategy consultant in a team of five to design and develop the MSTR reports /dashboard for the CITI clients.

Effectively involved in creation and testing of Schema and application objects using MicroStrategy Developer and Architect.

Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both MicroStrategy Desktop and MicroStrategy Web.

Developed reports enabling Data Drilling across multiple Dimensions using Desktop and Web.

Used several Widgets and controls to Design and Develop Dashboards in Flash like all graph types, Heat maps, Gauge, Time slider, Fish Eye etc.

Involved in managing Migration of MicroStrategy projects and objects from Development to Testing environment.

Performed Design & Code reviews Unit testing and data validation of MicroStrategy reports.

Environments: MicroStrategy 9.4.1 (Desktop, Web), Object Manager, Oracle 11g, SQL Developer.

RadioShack, India Feb 2012 – Aug 2012

MicroStrategy Consultant

Responsibilities:

Involves in Front End data modelling defined for the system.

Handled all the stages of the project like Requirement gathering, Design, Construction, Testing and implementation.

Develop reports and dashboards as per the requirements to meet functional and non-functional specifications in MicroStrategy 9.3.1

Worked on Performance Tuning of the MicroStrategy reports after implementation.

Effectively involved in creation and testing of Schema and application objects.

Created Attributes, Facts, hierarchies, Transformations and application objects including advanced metrics.

Created complex reports for Analysis with Transformations, Custom Groups and Filters using pass through Expressions.

Used Apply Functions like Apply Simple & Apply comparison to meet the report requirements wherever necessary.

Tested all reports by running queries against the warehouse using Teradata SQL Assistant and compared them with MicroStrategy SQL engine generated queries.

Involved in Report delivery and project management activities as per the organization standard policy and adhere Client process.

Environments: MicroStrategy 9.3.1 (Desktop, Architect, Web), MicroStrategy Mobile, Object Manager, Teradata SQL Assistant, Windows 98/2000/XP

Belk Inc., NC Nov 2011 - Jan 2012

MicroStrategy Consultant

Responsibilities:

Involved in analyzing business requirements and understand the technical and functional requirements and provide estimations for application enhancements.

Interacted with end users to have a clear understanding of their needs involving

Implemented Security capabilities by creating security filters and associated with Specific User Groups.

Troubleshoot and resolve data quality, technical, and performance related issues within reports and metrics within MicroStrategy.

Created MicroStrategy report that will consist of macros that will push automatically to each user via email or to shared path.

Responsible for delivering the reports/Dashboard to production in timely manner without any bugs with supporting documents such as design documents, Unit test scripts, and executed test results.

Provided the technical support to the validation team during validation process.

Resolve the data or report issues by understanding the UNIX script and provided the solutions.

Environments: MicroStrategy 9.0.1 (Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast Server), Teradata, MS Office and Windows 98/2000/XP and UNIX

Trimble, India Nov 2010 - Oct 2011

Sr. MicroStrategy Developer

Responsibilities:

Lead project team and manage activities associated with project that were cross platforms, applications, and business lines. Coordinated all release activities between development support teams.

Involved in Requirement, Analysis and Design phases of the project.

Interacted with the data modelling team for the Logical and Physical model design.

Analysis of feasibility in converting Reports from SSRS to MicroStrategy.

Performed data analysis, data mapping, gap analysis and data integration from multiple sources and created Functional and Technical specifications for relevant teams.

Created project plan for the development, implementation and operation of the MicroStrategy system using Microsoft Project.

Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.

Created transformations (Table Based and Expression Based) for ITD (Inception to date), YTD (Year to date), QTD (Quarter to date), MTD (Month to date) and WTD (Week to date) analysis.

Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.

Developed and Implemented Security Roles, User Groups, Privileges and Object Security for developers and end Users.

Extensive implementation of User preference into MSTR reports from DB.

Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both MicroStrategy Desktop and MicroStrategy Web.

Worked with the MicroStrategy SDK technical team to troubleshoot the dynamic display of prompts in the web mode and other Report related issues for the vision link Portal.

Worked on Performance Tuning of the MicroStrategy reports after implementation.

Used the Object Manager to move the objects from Development to QA and to Production Environment in MicroStrategy.

Created views, stored procedure in SQL Server and assisted SQL server DBAs and SQL server Administrators in making changes in the Database as required for the MicroStrategy Environment.

Involved during UAT and System testing on the warehouse tables and the reports.

Involved in Report delivery and project management activities.

Environments: MicroStrategy 9.0.1 (Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast Server), SQL Server 2008, SSRS, Microsoft Project and Windows 98/2000/XP

EBay, WA May 2010 - Oct 2010

MicroStrategy Developer

Responsibilities:

Gathered and analyzed business requirements from clients and End-users.

Developed an extensive collection of interactive dashboards using MicroStrategy Report Services with the drill down capabilities.

Developed and Implemented Security Roles, User Groups, Privileges and Object Security for developers and end Users.

Developed schema objects (facts, attributes, hierarchies, tables) using MicroStrategy Architect.

Have used several new controls for Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in 9.x.

Involved in creating Base formulas and used them in multiple metrics and categorized those metrics to create complex metrics.

Used Apply Functions like Apply Simple & Apply Comparison to meet the report requirements wherever necessary.

Created Linked reports/documents for users to facilitate the export to excel property.

Environments: MicroStrategy 9.0.x (Desktop, Architect, Web), Teradata, Teradata SQL Assistant and Windows 98/2000/XP.

AstraZeneca, DE Mar 2009 - Apr 2010

MicroStrategy Developer

Responsibilities:

Work as an Onsite lead and guided the offshore team in critical issues and defined the approach solution.

Created the documents for all the stages of the project like Requirement gathering, Design, testing and implementation.

Architect the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies.

Created Metrics (Simple and Compound), Filters, Custom Groups and Consolidations.

Developed an extensive collection of interactive dashboards using MicroStrategy Report Services for distribution to executives and field sales teams.

Designed and Developed Reports with challenging requirements.

Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy.

Created Excel deliverables with the help of Pivot tables.

Created excel macros for the report formatting or customizations.

Configured the Intelligence Server and pointed the database instances in both development & Production environments.

Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.

Developed and Implemented Security Roles, User Groups, Privileges and Object Security for developers and end Users.

Used Integrity Manager to test backend SQL and to compare reports.

Involved in various Narrowcast task like creating Documents, service designs, subscription, administration and scheduling.

Developed and Implemented Event and Time-based Schedules.

Prepared test cases and assist client during unit and system testing.

Troubleshoot and resolved post-production issues as per the timeline.

Environments: Microstrategy 8.1.x (Desktop, Office, Web and Narrowcast Server), Object Manager, Integrity Manager, Oracle10g, Microsoft Excel, VBA and Windows 98/2000/XP

AstraZeneca, India Jan 2007 – Feb 2009

MicroStrategy Developer/Administrator

Responsibilities:

Involved in Administrating and Maintaining MicroStrategy Intelligent Server, Narrowcast Server and Web Server.

Involved in upgrading MicroStrategy projects 7.x to 8.x.

Created user profiles, managed privileges and access of users of various groups using MicroStrategy Administrator.

Created Enterprise Manager Reports for checking various analysis including Object Dependency, Cache Management Reporting, User Session and User Group analysis.

Configured the Intelligence Server and pointed the database instances in both development & Production environments.

Handled the role of Administrator for User Management.

Assisted during the object migrations to various environments using the MicroStrategy Object Manager.

Developed schema Objects and Application objects.

Created many Materialized views in Oracle which act as Mart tables.

Perform Daily Checks for Job Monitor, User sessions and Cache Monitor to keep the system stable.

Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.

Environments: MicroStrategy 7.x/ 8.x (Desktop, Office, Narrowcast Server, Intelligence Server, Enterprise Manager, MicroStrategy Administrator), Oracle10g, and Windows 98/2000/XP

Contact this candidate