MicroStrategy Architect

Summary

*+ years of experience in MicroStrategy Suite (MicroStrategy Intelligence Server, MicroStrategy Architect, Desktop, Web, Narrowcast Server, Object Manager).

Good experience in other BI tools like QlikView v12, QlikSense v3, Tableau v9, Business Objects, Hyperion, SSRS.

Good experience on migration reports from Business Objects, Hyperion, Tableau and SSRS to MicroStrategy.

Experience in working with the full project life cycle development process, involving analysis, design, development, implementation, and testing phases.

Extensive knowledge of Data Warehousing concepts, RDBMS and multi-dimensional schema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases

Experience in migrating objects between Development, Testing and Production environments.

Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance

Total 3 years of Team lead experience with Onshore/Offshore in Project Development Cycle.

Good knowledge in integrating MicroStrategy with Third Party Single Sign on tools.

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 Services objects like Heat Maps, Map Widgets, Panels, Selectors, Grouping and Grid/Graph combinations.

Good experience with MicroStrategy Visual Insight Reports.

Experience in integrating Google maps with MicroStrategy Dashboards using Google Maps Plug-in integrating with SDK.

Good Experience in MicroStrategy Web Customizations and advanced reporting.

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, and consolidations.

Good experience in MicroStrategy Report services documents and dashboards

Knowledge in Narrowcasts, Distribution services and Mobile dashboard development.

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 Oracle, Teradata and SQL Server.

Good knowledge on PL/SQL Queries.

Expertise in Dimensional data modeling of De normalized schemas and normalized schemas.

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.

Renaming panels, change their border, and format its font and individual background colors of the title bar.

Created Drilling path and implement those into reports such that user can Drill across different System and User hierarchies.

Responsible for documenting the Functional & Technical Design documents. Responsible for completing Functional Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects, which requires frequent interaction with the Business Users.

Experience in handling the upgrade of MicroStrategy Environment from 9.2 to 9.3.

Excellent communication and interpersonal skills with user and client interaction experience.

Ability to work in multiple projects simultaneously and independently as well as in a team environment.

Education

Bachelor of Engineering, Jawaharlal Nehru Technological University, Hyderabad, India.

Certifications

MicroStrategy Certified Project Designer v 9.3.1

SQL Server Reporting Services (SSRS) – Wells Fargo internal

QlikView Developer – Wells Fargo internal

Technical skills

Operating System : Win (2003/NT/XP/VISTA/7), UNIX/Linux

Reporting Tools : MicroStrategy, Business Objects, Tableau, MSBI, Qlik Sense, QlikView Desktop, SSRS, Hyperion

ETL : Informatica, Data stage

Methodologies : Agile and Waterfall

RDBMS : Oracle 10g/9i/8i, Teradata 12.0, IBM DB2 8.0, SQL Server

Professional Experience

Wells Fargo – NC/ USA Jan 2017 – Till Date

MicroStrategy Lead/Architect

Project: Counterparty Risk System (CoRS) Reporting

Wells Fargo is an American international banking and financial services holding company headquartered in San Francisco, California, with "hub quarters" throughout the country. It is the world's second-largest bank by market capitalization and the third largest bank in the U.S. by assets. Wells Fargo is the second-largest bank in deposits, home mortgage servicing, and debit cards.

Role & Responsibilities:

Led a team of four developers to design and build project.

Managed development cycle in on shore off shore model. Conducted training for both technical and business users.

Engaged clients for the reporting requirements and converted business requirements into technical requirements.

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: data pivoting, page by, sorting, totals, thresholds, etc.

Creating the test cases for each report and cross verifying the end results.

Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.

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 the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Train users on how to efficiently develop simple reports and visual insights through MicroStrategy Web.

Providing knowledge to Users both in MSTR Desktop and Web.

Environment: MicroStrategy 10.4, SSRS, Ab Initio, SQL Server

Toys R Us – NJ/ USA Oct 2016 – Dec 2016

MicroStrategy Architect/Developer

Project: Inventory Flow Dashboard

Toys R Us, Inc. is the world’s leading dedicated toy and baby products retailer, offering a differentiated shopping experience through its family of brands. Merchandise is sold in 866 Toys R Us and Babies R Us stores in the United States, Puerto Rico and Guam, and in more than 750 international stores and more than 245 licensed stores in 37 countries and jurisdictions.

Headquartered in Wayne, NJ, Toys R Us, Inc. employs approximately 66,000 employees worldwide. The company is committed to serving its communities as a caring and reputable neighbor through programs dedicated to keeping kids safe and helping them in times of need.

Role & 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: data pivoting, page by, sorting, totals, thresholds, etc.

Creating the test cases for each report and cross verifying the end results.

Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.

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 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, Tableau 8, Informatica, Aster

CMS – Maryland/ USA June 2016 – Oct 2016

MicroStrategy Architect/Developer

Project: Performance Management System

The Centers for Medicare & Medicaid Services, CMS, is part of the Department of Health and Human Services (HHS). Also, previously known as the Health Care Financing Administration (HCFA), is a federal agency within the United States Department of Health and Human Services (HHS) that administers the Medicare program and works in partnership with state governments to administer Medicaid, the State Children's Health Insurance Program (SCHIP), and health insurance portability standards. In addition to these programs, CMS has other responsibilities, including the administrative simplification standards from the Health Insurance Portability and Accountability Act of 1996 (HIPAA), quality standards in long-term care facilities (more commonly referred to as nursing homes) through its survey and certification process, clinical laboratory quality standards under the Clinical Laboratory Improvement Amendments, and oversight of HealthCare.gov.

Role & 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: data pivoting, page by, sorting, totals, thresholds, etc.

Creating the test cases for each report and cross verifying the end results.

Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.

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 the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Environment: MicroStrategy 10.1, Informatica, Oracle 9i

Gate Gourmet – VA/USA, 8 months Oct 2015- Jun 2016

MicroStrategy Admin/Developer/Architect

Project: Global Catering Reporting System

Gate Gourmet is the world’s largest independent provider of airline catering and provisioning services. Gate Gourmet provides about 250 million meals a year to more than 250 customers at about 120 airport locations around the globe. Gate Gourmet was founded in 1992 from Swissair catering. In the 1990s, as part of the Sair Group of companies, Gate Gourmet grew through acquisitions, including the flight kitchens of Aero-Chef, SAS, Varig and British Airways.

Role & 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: data 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 integrating dashboards with SDK.

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 the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Responsible in upgrade of MicroStrategy version from 9.2 to 9.3.

Providing knowledge to Users both in MSTR Desktop and Web.

Environment: MicroStrategy 9.4.1, 10.1, Business Objects, QlikView, Informatica, Oracle 9i

Metavante Corporation – NY/USA, 9 Months Oct 2014- Sept 2015

MicroStrategy Admin/Developer/Architect

Project: Medi Bank Insurance

Metavante is redefining banking and payment technologies to financial services firms and businesses worldwide. Metavante products and services drive account processing for deposit, loan and trust systems, image-based and conventional check processing, electronic funds transfer etc., Metavante Corporation has a well-established MicroStrategy reporting environment with separate development, Quality Assurance and production systems in place.

Role & 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: data pivoting, page by, sorting, totals, thresholds, etc.

Creating the test cases for each report and cross verifying the end results.

Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.

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 the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Environment: Micro Strategy 9.4.1, MSBI, Data Stage, SQL Server 2005

Grid Point - VA/USA, 18 Months April 2013- Sept 2014

Lead MicroStrategy Admin/Architect/Developer

Project: Project Tracking– Energy Manager Reporting

The Grid Point Energy Management System (EMS) is a complete hardware, software, and services solution that deliver the granular visibility, actionable analysis, and intelligent control capabilities to manage the customer facility’s energy endpoints, from HVAC and lighting, to refrigerators and more. The project goal and financial reports helps the end user to visualize how a project is performing relative to the set goal. This depicts how actual usage and cumulative energy savings compare to the baseline and goal in graphical and tabular format.

Role & 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: data pivoting, page by, sorting, totals, thresholds, etc.

Creating the test cases for each report and cross verifying the end results.

Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.

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 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: Micro Strategy 9.3.1, DataStage, SQL Server 2008

Nielsen – Dallas/USA, 24 Months April 2011 - March 2013

Sr. MicroStrategy Developer

Project: Cell Counter

Nielsen is the world’s premier global marketing and advertising research company, with leading market positions in marketing and consumer information, mobile measurement, television and other media measurement, online intelligence, trade shows and related properties.

The scope of this project is to estimate the location of the cell sites for LTE, EVDO and HSPA carriers for various 3G/4G technologies in a market based on the extensive drive collection conducted as part of the syndicated benchmarking product. Here the data is collected from various markets throughout the country by conducting drive tests. The Cell Counter reports are generated for all the drives (drive ID’s) for each market that are delivered to clients.

Role & 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: data pivoting, page by, sorting, totals, thresholds, etc.

Monitoring the reports and doing the performance tuning.

Creating the test cases for each report and cross verifying the end results.

Extensively created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.

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: Micro Strategy 9.3.1, QlikView, Informatica, SQL Server 2008

Maxis – KL/Malaysia, 9 Months July 2010-March 2011

MicroStrategy Developer

Project: Neo Reporting

Maxis are the first mobile communication company in Malaysia which is headquartered at Kuala Lumpur. It was established in the year 1993 and their mobile services are provided more than 13.95 million subscribers across Asia-pacific. This is also the Malaysia’s biggest integrated communications service in Malaysia. Maxis were the first to launch high-speed networks in Malaysia including 3G, 3.5G, 3.5G+ and the first to conclude LTE (Long Term Evolution) trials.

Role & 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 objects.

Responsible for designing the Reports as per the user requirement.

Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.

Monitoring the scheduled reports and doing the performance tuning.

Creating the test cases for each report and cross verifying the outputs.

Extensively created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other tools.

Responsible for the Creation of Schedules and Subscriptions for Report deliveries to emails using MSTR Desktop and MSTR Web.

Responsible for sending reports to the user using MSTR Office and also worked in creating the URLs to generate the Reports to Mobile/iPad using Mobile Configuration in Web.

Administering on User Manager, enabling/disabling the User in Standard and LDAP Authentications.

Responsible for the Creating Users and User Groups under LDAP Authentication mode and assigning the projects and security roles.

Modifying the privileges to the users for the projects like enabling/disabling POWER USERS and other Standard User privileges.

Responsible for the Creating the necessary documents like URS, UTR’s UAT’s and other documents.

Supporting the existing projects and enhancing the reports on requirement.

Manipulating reports, documents and detail analysis of complete business with special attention to Key Performance Indicators.

Providing knowledge to Users both in MSTR Desktop and Web.

Played major roles like Administrator/Architect/Developer in MSTR Desktop

Environment: Micro Strategy 9.2.1, QlikView, Data stage 7.5.2, Oracle 9i

The Home Depot – TCS/ USA, India, 30 Months Jan 2008 –June 2010

MicroStrategy Developer

Project: Hyperion Retirement Off

The Home Depot is the world’s largest home improvement specialty retailer, values and rewards dedicated knowledgeable and experienced professionals. It operates over 2,200 retail stores in all 50 states.

The Home Depot's stock is traded on the New York Stock Exchange (NYSE: HD) and is included in the Dow Jones industrial average and Standard & Poor's 500 index. The Home Depot developed strategic product alliances directly with industry-leading manufacturers to deliver the most exclusive assortments to customers.

Role & Responsibilities:

Understanding and validating business requirement and data warehouse schema and do logical data modeling for MicroStrategy.

Doing report design and development as per the requirement specification.

Creating reports, documents and detail analysis of complete business with special attention to Key Performance Indicators.

Created schema objects like attributes, facts and logical tables using MicroStrategy Architect rights

Created public objects like Metrics, Filters, prompts, custom groups and consolidations using MicroStrategy developer rights

Created Dashboards extensively using the Panel stacks, selectors and many more functional tools.

Join in daily standup meetings with Project manager, business analyst, ETL team, data molders, testing team to discuss the user requirements and status updates.

Supporting the Project team in SIT and UAT testing.

Worked in a Scrum Agile process with two week iterations delivering documents/report and dashboard at each iteration.

Working closely with ETL team for collecting data and testing team for resolving defects.

Environment: MicroStrategy 9, Hyperion 9, Crystal Reports, IBMDB2, Teradata, SQL Server

Contact this candidate