We provide IT Staff Augmentation Services!

Microstrategy Solution Architect Resume

New, JerseY

SUMMARY:

­­­­­­­­­­­­­­­­­­­­­­­­

  • Total of 13+ years’ experience in Functional & Technical Consulting of Microstrategy solutions, Business Analysis, software testing, with major focus on Business Intelligence tools.
  • Created and integrated MicroStrategy Dashboards, Reports and Objects like Attributes, Facts, Filters, Metrics, Prompts, Custom Groups, Consolidations, and Transformations with data warehouse to enable clients to assess their services against data assets to increase profitability and manage risks by reducing the operational costs.
  • Successfully upgraded all MicroStrategy Intelligence Server 7 projects to MicroStrategy 8 Intelligence Server projects using the MicroStrategy 8 Project Upgrade Wizard. Excellent at translating business objectives and strategies into innovative, interactive design
  • Deep dive knowledge in different types of data modeling, like - star schema modeling, snowflake modeling
  • Participated as a team member in ETL functions and supported data extraction, transformations, dashboards, and loading processing in a corporate-wide-ETL solution using INFORMATICA
  • Worked on Sql Server v12, Oracle 8i/9i, Teradata 7.1 databases Installed and Configured Intelligent Server and Narrowcast Server to schedule execute and deliver reports using various delivery methods

SKILL:

Professional Expertise: Project Coordinator, BI Solution Architect, MicroStrategy Architect & Developer, Business Analyst, Logical Data Modeller, Data Analyst, Report SQL Tester

BI Tools: MicroStrategy 7.5.x,8.0.1,8.1.1,9.x.x,10.x.x, Cognos 8.0, Tableau 10.4 v

Scrum Tools: JIRA 5.0,

Database Languages: SQL Server 2012,2008, Oracle 10x,9x, Teradata 10x, Access, Excel

Database Tools: TOAD 6.5, Teradata SQL Assistant 7.1, SQL Plus Loader, ORACLE 9i, 10g, MS ACCESS, TERADATA v12

Desktop Tools: Microsoft office Tools, Flash

Programming Languages: JavaScript, SQL, HTML, XML, .NET

Operating Systems: Windows 200x/9x/NT, Unix

Verticals-Domain: Retail, Insurance, Automobile, Banking, Healthcare

Testing Tools: Win runner 8.1, Load Runner 6.5, Quality Center 9.1, QTP 8.1

EXPERIENCE:

MicroStrategy Solution Architect

Confidential, New Jersey

Environment: Microstrategy 10x, SQL Server 2012, Windows 2000/2003.

Responsibilities:

  • Worked closely with clients to understand the dashboard requirements.
  • Created Logical data model based on the Mockups sent by the client
  • Developed Attributes, Facts, Tables, Hierarchies as an Architect
  • Created complex Metrics, Advanced Filters and other public objects as required.
  • Successfully created user friendly Dashboards prototypes as per their requirement
  • Helped team members in creating dashboards assigned to them
  • Provided unique ideas for creating performance based dashboards.
  • Unit tested dashboards and datasets
  • Created tables in SQL server 2008 to make loading of data easy
  • Created complex queries to automate load into critical tables
  • Unit tested data as once load was complete
  • Discussion on critical issues and complexities in daily meetings on enhancements and upgrades

Microstrategy Architect

Confidential, North Carolina

Environment: Microstrategy 9x, 10x, SQL Server 2008, Windows 2000/2003.

Responsibilities:

  • Architect developer
  • Created Star and Snowflake schema/Logical Model as per BRD.
  • Developed derived, implicit Attributes, Facts, Tables, Hierarchies as an Architect
  • Developed prototype dashboards for IRI and IRO team as per business requirements
  • Helped team Members in creating dashboards assigned to them
  • Successfully created Complex Dashboards with smart controls which enabled user to easily view data at various levels and enabled complex URL API functionality
  • Provided unique ideas for creating performance based dashboards.
  • Created estimation document to help business know the duration for creating schema and public objects.
  • Created Metrics, Filters and other public objects as required.
  • Unit tested dashboards and datasets
  • Guided a of team of 5 members to Load, Map, cleanse data from text and excel files in critical tables
  • Worked closely with clients to understand the data load requirements.
  • Created a DFD diagram to better understand the flow from File capture to loading the data in the data warehouse
  • Created complex queries in SQL server 2008 to make loading of data easy
  • Created complex queries to automate load into critical tables
  • Unit tested data as once load was complete
  • Discussion on critical issues and complexities if any in team meetings

Project Lead

Confidential, Nashville, Tennessee

Environment: Microstrategy 9.3.1, SQL Server 2008, Windows 2000/2003.

Responsibilities:

  • Data Analyst & Tech Lead
  • Created & Published huge Intelligent Cubes and unit tested all column data through subscriptions
  • Created reports and dashboards from SSAS MDX cubes and I cube and provided statistics information regarding performance.
  • Imported SSAS cubes into Microstrategy as MDX cubes and created reports. Established Connection to SSAS environment through XMLA configured msmdpump.dll file which acts as a interface to SSAS.
  • Developed prototype dashboards for sales and marketing division as per business requirements
  • Created Complex Dashboards with smart controls which enabled user to easily view data at various levels
  • Integrated Command manager utility with C#.NET to create a user-friendly windows application for Microstrategy administration purpose
  • Resolved Defects tickets as per the priority and severity.
  • Provided unique ideas for creating performance based dashboards.
  • Created Metrics, Filters and other public objects as required.
  • Unit tested dashboards and datasets
  • Guided a of team of 6 members to Load, Map, cleanse data from text and excel files in critical tables
  • Worked closely with clients to understand the data load requirements.
  • Created a DFD diagram to better understand the flow from File capture to loading the data in the data warehouse
  • Created complex queries in SQL server 2008 to make loading of data easy
  • Created procedures to automate load into critical tables
  • Unit tested data as once load was complete
  • Created a initial score card to let stake holders know about the initial status before file load
  • Created final scorecards to let stakes know regarding the final out come after the load
  • Discussion on critical issues and complexities if any in team meetings

Project Lead

Confidential

Environment: MicroStrategy Desktop 9.0, MicroStrategy Intelligence Server 9.0, Windows 2000/2003, Oracle 10g.

Responsibilities:

  • Project Architect
  • Worked closely at client location with DM & PM to understand the project requirements and meet activity timelines.
  • Initiated discussions with assigned leads to understand the overall progress of the project and resolve any technical issues.
  • Worked as a pyramid lead for the project.
  • Initiated team meetings whenever required to resolve any discrepancies between team members
  • Interacted with stakeholders to understand the requirement documents.
  • Interacted with database designers to help them create logical views
  • Participated & created HLD document as per my role.
  • Created Microstrategy Schema Detail design document
  • Created Attributes, Facts as required in Microstrategy Architect
  • Provided guidance to report designers to create report Mockups
  • Involved in discussions to resolve complex infrastructure issues
  • Worked extensively to provide valuable inputs to ease out tricky OLTP issues related to the project
  • Instrumental in creating security groups for the project as required.
  • Worked with developers as a mentor to help them create reports.
  • Smoke tested entire schema objects to check the application Flow.
  • Initial level UAT testing with BA to understand the report flow.

MicroStrategy Lead

Confidential, Boston, MA

Environment: MicroStrategy Desktop 9.0, MicroStrategy Intelligence Server 9.0, MicroStrategy Web 9.0, Narrowcast Administrator 9.0, Teradata 7.1, Teradata SQL Assistant, Unix, Windows 2000/2003.

Responsibilities:

  • Worked onsite with stakeholders to design requirement document and Technical design document.
  • Advised DM to hire resources to meet the expectations of the project. Involved in the hiring of resources.
  • Initiated team meetings whenever required to resolve any discrepancies between team members.
  • Planned out all the different phases of the project
  • Regularly interacted with Data Analysts after completion of created reports for final validation.
  • Assisted report designers in tuning reports for optimum performance
  • Formatted existing reports as per requirements as part of the enhancements
  • Worked simultaneously with QA team to help them resolve and understand tricky issues with SQL queries.
  • Worked with QA team to suggest better ways to test and provided solutions regarding objects with multiple issues.
  • Assisted report designers in creating public objects such as Filters, Metrics, Prompts effectively as per the specifications.
  • Organized status meetings to update regarding report development and contributed in resolving issues whenever required.
  • Helped designers while Unit testing all objects and reports created as per the Iterations.
  • Help create unit test document to have a record of all the tested objects.
  • Provided knowledge transfer to QA team on Micro strategy whenever required.
  • Project was successfully implemented in production after migrations in Dev>QA>Prod.
  • Worked on Installation and Configuration of Cognos 8.4.1v.
  • Attended programs on Teradata 8.0 Architecture.
  • Attended sessions provided by our BA Analyst on LM- Specific Insurance domain.
  • Worked on creating white papers for Insurance solutions in BI for Trianz.
  • Researched on Capacity resource planning project which needed Microstrategy as its interface and educated senior managers on it.
  • Involved in creating a power point presentation on CRP wrt to Teradata database which educated us in Microstrategy Subsystems.
  • Provided an overview to senior managers on PMIT project.
  • Gave a presentation on newly introduced Cloud concepts and overview on Microstrategy Cloud.

MicroStrategy Architect

Confidential, New York

Environment: MicroStrategy Desktop 8.0.2, MicroStrategy Intelligence Server 8.0.2, MicroStrategy Web 8.0.2, Narrowcast Administrator 8.0.2, Teradata 7.1, Teradata SQL Assistant, Oracle 9i, Unix, Windows 2000/NT

Responsibilities:

  • Technical Lead - BI Applications (MicroStrategy)
  • Responsible for creating Attributes, Facts, Metrics, Filters, Custom Groups, Prompts using M icroStrategy Desktop and Web
  • Involved in troubleshooting MicroStrategy prompts, filters, templates, consolidations, and custom group objects in an enterprise data warehouse team environment.
  • Communicated resolutions to client and closed tickets added that information in a excel tracker on a regular basis
  • Ran Queries against MicroStrategy in Toad to check for issues with reports in Desktop and web
  • Optimized Query Performance by using VLDB settings
  • Created and replaced views according to user requirements and also to resolve any complicated cross joins in the Microstrategy reports
  • Modified complex graph reports in Microstrategy desktop to meet client requirements
  • Conducted a urgent SLA presentation as asked by Manager
  • Ran DML commands with different variations to check and verify data in data warehouse
  • Fine tuned Teradata queries for optimum performance of MicroStrategy reports
  • Worked simultaneously with QA team to help them resolve and understand tricky issues with SQL queries.
  • Worked with QA team to suggest better ways to test and provided solutions regarding objects with multiple issues
  • Created unit test document to have a record of all the tested objects.
  • Provided knowledge transfer to QA team on Micro strategy whenever required and helped them resolved issues.
  • Tuned reports for optimum performance
  • Formatted existing reports as per requirements as part of the enhancements
  • Worked simultaneously with QA team to help them resolve and understand tricky issues with SQL queries.
  • Worked with QA team to suggest better ways to test and provided solutions regarding objects with multiple issues.
  • Attended weekly status meetings to update regarding report development and contributed in resolving issues whenever required.
  • Unit tested all objects and reports created as per the Iterations.
  • Created unit test document to have a record of all the tested objects.
  • Provided knowledge transfer to QA team on Micro strategy whenever required.
  • Project was successfully implemented in production after migrations in Dev > QA>Prod.

Microstrategy Lead

Confidential, SALT LAKE CITY, UTAH

Environment: MicroStrategy Desktop 8.0.2, MicroStrategy Intelligence Server 8.0.2, MicroStrategy Web 8.0.2, Narrowcast Administrator 8.0.2, Teradata 7.1, Teradata SQL Assistant, Oracle 9i, Unix, Windows 2000/NT

Responsibilities:

  • Senior MicroStrategy Lead
  • Responsible for creating Attributes, Facts, Metrics, Filters, Custom Groups, Prompts using M icroStrategy Desktop and Web
  • Involved in troubleshooting MicroStrategy prompts, filters, templates, consolidations, and custom group objects in an enterprise data warehouse team environment.
  • Communicated resolutions to client and closed tickets added that information in a excel tracker on a regular basis
  • Ran Queries against MicroStrategy in Toad to check for issues with reports in Desktop and web
  • Optimized Query Performance by using VLDB settings
  • Created and replaced views according to user requirements and also to resolve any complicated cross joins in the Microstrategy reports
  • Modified complex graph reports in Microstrategy desktop to meet client requirements
  • Conducted a urgent SLA presentation as asked by Manager
  • Ran DML commands with different variations to check and verify data in data warehouse
  • Fine tuned Teradata queries for optimum performance of MicroStrategy reports
  • Worked simultaneously with QA team to help them resolve and understand tricky issues with SQL queries.
  • Worked with QA team to suggest better ways to test and provided solutions regarding objects with multiple issues
  • Created unit test document to have a record of all the tested objects.
  • Provided knowledge transfer to QA team on Micro strategy whenever required and helped them resolved issues.
  • Tuned reports for optimum performance
  • Formatted existing reports as per requirements as part of the enhancements
  • Worked simultaneously with QA team to help them resolve and understand tricky issues with SQL queries.
  • Worked with QA team to suggest better ways to test and provided solutions regarding objects with multiple issues.
  • Attended weekly status meetings to update regarding report development and contributed in resolving issues whenever required.
  • Unit tested all objects and reports created as per the Iterations.
  • Created unit test document to have a record of all the tested objects.
  • Provided knowledge transfer to QA team on Micro strategy whenever required.
  • Project was successfully implemented in production after migrations in Dev QA Prod.

Senior Analyst

Confidential, Southfield, Michigan

Environment: MicroStrategy 8.0.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Report Services, Oracle 9i, HTML & DHTML, Win NT

Responsibilities:

  • Senior Analyst
  • Translating business objectives and strategies into innovative, interactive design
  • Exceptional attention to detail in requirements gathering, user observations, user tests and design
  • Present visual specifications including concept diagrams, mockups, screenplay, personas and Use Cases diagrams
  • Ability to examine a problem from various angles and develop appropriate solutions that successfully balance business goals, user needs, and technology constraints
  • Upgraded MSTR from version 8.0.1 to Version 8.1.1 and configured the Intelligence, Narrowcast, Subscription Portal Servers
  • Create new reports in MicroStrategy desktop
  • Create Report filters in the Narrow cast server
  • Deploy Reports it in Pre-prod for UAT
  • Deploy Report-filters in Pre-prod for UAT
  • Deploy Reports, Report-Filters to Prod
  • Enhancement to the existing reports and report filters
  • Reports and Report filters issue resolution
  • Clarifications thru net meeting, calls, chats, e-mails on new and existing reports, report-filters issues
  • Role of business analyst and collect requirements
  • Interact with representatives from US, GM Canada, Brazil, and Mexico to gather business requirements for MicroStrategy reports, report creation/modification, and informal testing
  • Processing ad-hoc data requests
  • Provide support during continuous improvement investigations such as Run Time improvements for MicroStrategy reports
  • Maintain document with detailed information on each report (MicroStrategy Narrowcast Service)
  • Maintain process on how to move MicroStrategy reporting changes to production
  • Create list of financial system assigned keys for each new report request based on financial account requirements supplied by customer
  • Create preproduction UAT IDs for business customers testing new reports
  • Coordinate and move approved MicroStrategy reporting additions/changes to production
  • Import updated Excel templates into MicroStrategy Narrowcast at request of business customer
  • Maintain Security Administration of MicroStrategy desktop IDs (create, delete, disable) based on requests from the Business Customer
  • Track MicroStrategy Report requests and status
  • Maintain document to track FACTS MicroStrategy reporting changes moved to production
  • E-mail notifications: Send notification to business and IS&S customers of MicroStrategy reporting changes moved to production. Provide email with impact of data change to business customer upon request
  • Disable/Enable Narrowcast Services in production at request of business customer
  • Create Miscellaneous ad-hoc requests for data
  • Run Scan MD/MD Doctor MicroStrategy utilities against MicroStrategy Metadata monthly in check mode only
  • Run SQL against MicroStrategy Metadata to check for issue with ID authorization and to check for duplicate MicroStrategy IDs
  • Provide Level 3 support for MicroStrategy reporting issues
  • Log and track reporting support cases with MicroStrategy
  • Duplicate MicroStrategy project and services to development/preproduction environment as needed
  • Provide consulting on use of MicroStrategy desktop tool to business customers

Sr Associate

Confidential

Environment: MicroStrategy 8.0/7.5 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter), Report Services, XSL, Java, Oracle 9i, Informatica Power Center 4.5/5.1, Power Mart 5.1, IBM DB2, HTML & DHTML, Win NT

Responsibilities:

  • MicroStrategy Report Developer
  • Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards
  • Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, Custom Groups and Consolidations for complex reports
  • Customized the MicroStrategy web interface and the Intelligence Server settings for the project
  • Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy
  • Configured the Enterprise Manager for statistical reporting purposes
  • Created and configured the Narrowcast system
  • Extensively used Narrowcast Server for personalized Report distribution
  • Involved in troubleshooting MicroStrategy Web Reports
  • Was involved in upgrade of MicroStrategy from 7.5 to 8.0
  • Performed the administration tasks like tuning, caching, and report optimization

Hire Now