SUMMARY

• 8+ years of IT experience in software development, documentation, designing, and requirement gathering with major focus around Business Intelligence, Data Warehousing and Database Applications.
• Good domain knowledge on Retail, Telecom, Health, Banking and Finance industry.
• Expert in MicroStrategy and hands on experience on Tableau, Power BI.
• Work on designing, developing, and implementing Enterprise Management application throughout the lifecycle of the project using MicroStrategy Suite 11.x, MicroStrategy Desktop, MicroStrategy Web and Teradata.
• Extensively worked on Desktop to create Applications Objects, Reports and Dossiers (Documents & Dashboards)
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Expert Confidential Planning, analysis, design and development of complex reports and scorecards for several business units.
• Hands on Experience in Creating Dashboards and Dossiers from multiple Datasets like Grid and Graph.
• Heavily worked with the end users to finalize the Dashboard layouts and worked on fine detail formatting for a desired look and feel on dashboard layouts.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Experience in designing, developing, debugging and enhancing reports by following business rules using MicroStrategy desktop and MicroStrategy web.
• Worked on MicroStrategy administration including intelligence server administration, configuration of memory settings, performance monitoring and VLDB settings.
• Experienced in working with different databases like Teradata, SQL Server, Oracle and Data stage.
• Good knowledge and understanding in translating business needs into end - user reports.
• Ability to rapidly learn new concepts together with excellent interpersonal skills. Very flexible and can work independently as well as in a team environment.
• Management skills include Team Management, Leading projects, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILLS:

Business Intelligence Tools: MicroStrategy 11.1x, 2019, Tableau, Power BI

MicroStrategy Components: MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web and Admin

Databases: Oracle 11g/10g/9i, Teradata, DB2, SQL Server

Operating Systems: Windows Servers, UNIX and Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr MicroStrategy Consultant

Responsibilities:

• Design, develop, debug and enhance reports using MicroStrategy Developer and MicroStrategy web.
• Responsible for gathering and refining business requirements from the Business Analyst for Overall performance dashboard.
• Develop self-service reporting to the business intelligence solutions on the web using MicroStrategy developer.
• Responsible for efficient design and usage of various attribute dimensions like Spend Visibility, Vendors, Contracts and Time dimensions, and integrating them into reports displaying Invoice and PO metrics.
• Develop new change requests, fixing defects in and enhancements from the business
• Extensively worked on creating Dossiers, Self-service reporting and Dynamic Dashboards with multiple panel’s stacks and along with and Different graphs.
• Developed Intelligent Cubes and used as datasets for dash boarding and extensively used Incremental cubes to insert the data update functionality.
• Designed Schema and Public Objects as per the report and Dashboard requirements.
• Developed reports and Dynamic Dashboards to support the client in decision-making.
• Creating all kinds of metrics, filters, reports, custom groups and consolidations.
• Identify migration list of objects for deployment team to make on time migrations. Perform migration reviews and guiding the admin for quality and timely deliverables.
• Preparation of Test Cases, Unit testing of report and Support UAT & Production environments.
• Quality assurance for the design, development, and testing of system enhancements.
• Preparing Migration list and sending list of objects to deployment team to make on time migrations.
• Performed quality assurance for the design, development, and testing of system enhancements.
• Provided technical support, responded to error reports, problems or questions, and adhered to defined SLA's for project delivery.

Environment: MicroStrategy 11.1, MicroStrategy 2019, Vertica, Data lake, Power BI, Teradata SQL Assistant.

Confidential

Business Intelligence Developer/Admin/Production Support

Responsibilities:

• Design, develop, debug and enhance reports using MicroStrategy and MicroStrategy web.
• Design source to target mapping in compliance with all business rules, create schema objects (attributes, facts, hierarchies, transformations), Create applications objects - filters, metrics, prompts, reports, report services documents, templates.
• Develop new change requests, fixing defects in and enhancements from the business
• Develop Reports and business intelligence solutions on the web using MicroStrategy Distribution Services.
• Perform code reviews and guiding the developers for quality and timely Deliverables.
• Identify migration list of objects for deployment team to make on time migrations. Perform migration reviews and guiding the admin for quality and timely deliverables.
• Preparation of Test Cases, Unit testing of report and Support UAT & Production environments.
• Quality assurance for the design, development, and testing of system enhancements.
• Performance tuning of the mappings, MicroStrategy standards and provide technical support, analyzing error reports, issues, and adhered to defined SLA's for project delivery.
• Extensively worked using MicroStrategy web environment and created VI dashboards and Documents.
• Responsible for gathering and refining business requirements from the Business Analyst for Overall performance dashboard.
• Worked in the development team on the new change requests, fixing defects in MicroStrategy reports and enhancements from the business.
• Designed Schema and Public Objects as per the report and Dashboard requirements.
• Developed reports and Dynamic Dashboards to support the client in decision-making.
• Creating all kinds of metrics, filters, reports, custom groups and consolidations.
• Preparing Migration list and sending list of objects to deployment team to make on time migrations.
• Performed quality assurance for the design, development, and testing of system enhancements.
• Provided technical support, responded to error reports, problems or questions, and adhered to defined SLA's for project delivery.
• Preparation of Test Cases, Unit testing of report and Support UAT & Prod.

Environment: MicroStrategy 10.7, Informatica, MicroStrategy Web, SQL Server.