SUMMARY

• 9 + years of IT experience in Business Intelligence(BI) Project Development and Implementation Using MicroStrategy 11.x/ 10.x/9.x/8.x Product Suites including MicroStrategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligence Server, MSTR Administration - version upgrade, User Management, Security Filters, Statistical analysis using Enterprise Manager. Tableau 10/9.x
• Experience in creating Dynamic Report Service documents ( RSD’s), Dossiers and Visual Insight Dashboards using D3 Visualizations and custom widgets (both Web and Mobile)
• Developed interactive Tableau visualizations after gathering Business Requirements, Interacting with the Users.
• Proficient in creating Advance dashboards and Visual Insights in both MicroStrategy and Tableau environment.
• Designed variety of dashboards using widgets/ Visualizations like scatter plot, Heat maps, tree maps, ESRI Maps ( Multi layer), gauges, bubble charts etc.
• Involved in Projects like Full Life Cycle Development of Data Warehousing, Project planning, business Requirement Analysis, Data Analysis, Logical Data Modeling, setting up Physical Schema, Data Marts, OLAP, Reporting and Security.
• Expertise in Working on Direct Project Source (Two-Tier) and Server Project Source (Three-Tier).
• Good Experience in Creating Schema Objects (Facts, Attributes, Hierarchies, and Transformations) to develop public Objects.
• 9+ years of experience in Data warehouse and OLAP applications.
• Experience in Hive/Pig and Hadoop Integration.
• 6+ years of experience working on agile and waterfall mythologies.
• Hadoop and Map reduce to MicroStrategy.
• Good Knowledge in Developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, Drill Maps, Templates, Searches) to develop Documents and Reports.
• Hands on Experience in Creating Documents from multiple Datasets like Grid and Graph.
• System Optimization, performance monitoring and tuning experience in Multiple BI applications.
• Fine Tuning of the MicroStrategy Reports using VLDB properties, Aggregable Tables and Intelligent Cubes.
• Proficient in using RDBMS Such as Oracle and Teradata.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Strong SQL Skills Related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Good multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good Communication, Interpersonal, Analytical skills and Strong ability to perform as Part of the team.

TECHNICAL SKILLS

Business Intelligence: MicroStrategy 2019/2020/10. x/9.x/8.x (MicroStrategy Architect, Web, Intelligence Server, OLAP Services, Report Services, Narrowcast Server, Command Manager, Administration, Object manager, Command Manager), Tableau 8.1/9/10.

ETL: Informatica

Languages: C, C++, SQL, PL/SQL,Hive

Operating Systems: MS-DOS, Windows 98/NT/2000/XP/VISTA/7, UNIX and LINUX.

Web Technologies: MS Front Page, HTML.

Databases: Teradata, Oracle 11g/12g, SQL Server 2012 R2, Oracle SQL Developer. Netezza, Amazon Redshift.

PROFESSIONAL EXPERIENCE

Senior MicroStrategy Architect

Confidential, Freehold, NJ

Responsibilities:

• Work with end users, scrum masters and business analysts in finalizing the use case, requirements for business metrics reporting needs
• Define project scope, estimate development effort, schedule and risks for the projects
• Develop critical reports, analyze data elements required and data model/flow changes in agile environment.
• Perform end to end unit and integration tests with high quality datasets to ensure functional accuracy and production quality data validation
• Facilitate end-user testing, deployment and training for wider user adoption
• Ensure production stability, SLA adherence through various changes implemented across systems
• Achieved >98% system uptime, >95% SLA adherence for report delivery
• Lead and involved complete SDLC from configuration, installation, automation to development.
• Served as MicroStrategy SME covering MicroStrategy Architecture, Administration and platform roadmap
• Governed MicroStrategy environment and continuously optimized the environment settings and VLDB settings
• Extensively used command manager scripts to create/modify schema/public objects in bulk
• Implemented object manager for moving objects between different environments
• Handled set up and operations of system, enterprise and integration manager
• Managed users, user groups and licenses for quick onboarding
• Responded to support calls and provided technical assistance to user community
• Troubleshooted and performed root-cause analysis for outages, system SLA breaches to trace BI vs Database issues
• Migrated on premises MicroStrategy to AWS and upgraded to latest Version of MicroStrategy 2019.
• Automated all installation and configurations on AWS servers through Jenkins Jobs.
• Custom login and landing page deployed for easy access to the reports.
• Created advanced Dossiers and Visual Insights for Predictive Analysis.
• Extensively worked on Cubes. Designed interactive and visually stunning Dynamic Dashboards using multi layout, widgets, Grid/Graph combinations etc.

Environment: MicroStrategy 10.4 and MicroStrategy 2020/2019/11.0 , SQL Server 2012 R2, Linux, AWS, Agile Methodology.

Sr. MicroStrategy Developer/ Tableau Developer

Confidential, San Antonio, TX

Responsibilities:

• Created Logical model and defined variety of Relationships and Hierarchies in MicroStrategy
• Created schema and application objects for MicroStrategy reporting purposes.
• Created Multi layout report services document with multiple panel stacks, selectors, information windows, Hyperlinks ( Passing Prompt Parameters to destination report).
• Created Advance Dashboards in Tableau using visualizations like Tree maps, combination graphs, scatter plots etc.
• Designed visual insight dashboard using pie and bar charts.
• Created Area graphs and line graphs for time series comparisons.
• Deisgned multi source dashboards using data blending technique in MicroStrategy
• Created advance calculative fields from the existing measures.
• Worked on Visual Insight dashboards which includes ESRI Maps and other D3 Visualizations In MicroStrategy.
• Sdk plugins for all visual,cosmetic changes.
• Freeform definition reports for Transactional services reports allowing user to write back to the databases.
• Created dashboards exclusively for mobile purposes using custom widgets like ( bubble, gauge, thermometer, Heat Maps etc.)
• Involved in gathering business requirement meetings and preparing BRD documents
• Involved in complete SDLC processes and scrum meetings.

Environment: MicroStrategy 10.8/10.4, Tableau 10,Netezza, SQL Server 2012 R2, Windows 8, Erwin, Agile Environment

Confidential

Sr. MicroStrategy Architect/Admin

Responsibilities:

• MicroStrategy v10 Architect- build schemas and data cubes to be used by clients. Build in hierarchy and alias tables as needed.
• Coordinating with business users, scrum masters, ETL team and gathering requirements.
• Designing Logical data model which includes creation of Schema and Public objects
• Created various Dynamic Dashboard/documents for the business users with multiple panel stacks, selectors and customized widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
• Designed and Developed MicroStrategy Dashboards using customized Widgets.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• MicroStrategy Mobile application configuration and development (Developing Transaction reports, Dashboards).
• Developed Transactional report services documents using Free Form SQL definition reports
• MSTR- Server configuration and maintenance.
• Upgraded MicroStrategy version from 10.2 to 10.4, installing HF on regular basis Narrowcast Services (Event Based and time triggered).
• Creating User groups, security roles, Meta Data security filters, Subscription and schedules (event and time based).
• Configuring and setting up Enterprise Manager for statistical Analysis.
• Using command manager for bulk operations, System Manger to create automating scripts.
• Objects migration and comparison using object Manager tool.
• Monitoring the server performance across the project servers using operations manager (like Memory Usage, Disk space, CPU etc).
• Managing large variety of user base by creating different user groups with different security filters.

Environment: s: MicroStrategy 10.2/10.4, Oracle 12g, Teradata, Linux, Tomcat. DataStage, Informatica, Pig, Hive, Agile Environment.

Confidential, Woodland Hills, CA

Sr. MicroStrategy Consultant (Architect, Lead)

Responsibilities:

• Lead, Develop and support several MicroStrategy projects Confidential UMG.
• Collecting business requirements from BA and Lead by understanding the Source System and translating them into report specifications for MicroStrategy platform.
• MSTR- Server configuration and maintenance.
• Managing large variety of user base by creating different user groups with different security filters.
• Responsible for gathering complex business and functional requirements and documented them into Conceptual Approach, Business Requirements, Functional Requirement, Detailed Design Document, and User Stories.
• Created schema objects (Attributes, Facts, Relationships between various attributes, Logical Tables, Drill Maps) to implement MicroStrategy Reports.
• Created Analytical engine bypass functions like Apply Simple & Apply Comparison, wherever necessary.
• Upgraded MicroStrategy environment from 9.3.0 to 9.4.1. Technical lead for the upgrade and the servers including I-servers, web servers, Narrowcast servers, Enterprise Manager, etc. Successful upgrade with zero issues.
• Performed MicroStrategy administration tasks like creation of users, groups, projects, workbooks and permission sets for MicroStrategy server logons and security checks.
• Regular Tuning of MicroStrategy reports for optimized performance using VLDB properties.
• Providing support to consultants, Technical Support engineers in creating and troubleshooting MicroStrategy SDK customizations.
• Experience in Hive/Pig No SQL languages and Hadoop Integration
• AWS Redshift Configuration and implementation.
• Handling issues and identifying bugs in the multiple database environments like- SQL Server, SQL Developer.
• Onsite training & demonstration for new business users and providing clarification to business users when and required.
• Offshore Coordination- Guiding and helping team in resolving complex production issues.

Environment: s: MicroStrategy 9.3.0/9.4.1/10.0 , SQL server 2012 R2, Oracle Sql Developer, AWS Redshift, Informatica. Windows ERWIN, IIS Web server, Agile Environment.

Confidential

Sr. BI developer

Responsibilities:

• Gathered and analyzed relevant data and created Schemas that fit reporting requirements. Defined fact and dimension tables, created aggregate table for performance.
• Performed Requirement Analysis to collect various business measures and attributes to develop a reliable Star Schema and required Facts and Attributes.
• Created Administration Tasks like creating User Accounts, Assigning Privileges and applied Security Filters.
• Utilize in-depth knowledge of functional and Technical experience in data warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Extensively worked with MicroStrategy Desktop. Extensive experience in building filters, consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generated reports meeting the Business Analyst needs.
• Developed reports, dashboards, SQL queries using Tableau.
• Synthesized and translate Business data needs into creative visualizations in Tableau.
• Performed Tableau administration tasks like creation of users, groups, projects, workbooks and permission sets for Tableau server logons and security checks.
• Tuned KPI Retail reports for optimized performance.
• Assisted with best practices during implementation and integration of Tableau Platform.
• Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions
• Provided various management levels with reports, Time series analysis and wide range of graphs using MicroStrategy Web.
• Worked in handling the MicroStrategy BI tools and Narrowcast Administration.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
• Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.

Environment: MicroStrategy 9.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, OLAP, Tableau 7/8/8.1, Oracle 11g, Windows 2003, MicroStrategy Dashboard, Oracle.