Associate MicroStrategy Consultant Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Pratima Kundu

Pratima_kundu445@hotmail.com

call (516) 056 3955

Professional Summary:

·          Over 6 years of experience in Business Intelligence focused on MicroStrategy

·          MicroStrategy Certified Developer v9.3.1.

·          Extensive experience in providing Business Intelligence solutions in Data warehousing using Reporting Tool :MicroStrategy (Desktop, Architect, Report Services, Intelligence Server, Web and OfficeOLAP)

·          Experience with MicroStrategy 9.x and 8.x.

·          Strong experience in designing and developing MicroStrategy Reports using Application Objects like Metrics, Filters, Prompts, Custom Groups & Consolidations.

·          Experience in creating Documents, Dashboards using Selectors, Panel Stacks and Widgets.

·          Experience in architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies.

·          Involved in Optimizing queries generated from MSTR.

·          Actively involved in Development and Unit Testing of BI Tool (MicroStrategy) mainly Desktop, MicroStrategy Web.

·          Custom Expressions using Pass-Through functions( ApplySimple, ApplyComparison)

·          Knowledge inMicroStrategy System Administration in setting up the Metadata, configure the Intelligence server, creating users, user groups, security filters, roles, privileges, and security roles.

·          Good Knowledge on data warehouse Concepts like Star schemas, Snow flake schema, Dimension and Fact tables.

·          Involved in MSBI projects with extensive usage of ReportingTools like SQL Server Reporting Service (SSRS), EXCEL SERVICES, POWER PIVOT, POWERVIEW and SQL Server Analysis Services (SSAS), Tabular Cubes.

·          Involved in providing Security and Many to Many relationship in Tabular Cubes.

·          Involved in providing Drill through in Excel service Reports.

·          Experience in writing complex Dax queries, Dax expressions.

·          Involved in PerformanceTuning of SSRS Reports.

   Detailed Work Experience:

§   Worked as Technical Lead in HCL Technologies from May 2013 to Present.

§   Worked as a Sr Associate MicroStrategy Consultant with Sunview Consulting (P) LTD from September 2012 to May 2013.

§   Worked as an Analyst in BA Continuum India Pvt Ltd. from March 2008 to June 2012.

Certifications:

§   MicroStrategy Certified Developer (MCD) v9.3.1 in Jan 2014

§   Certified Platform Administrator v9.3.1

 Qualification:                                       

·          AMIE in Electronics & Communications from Institute of Engineers, Kolkata in 2011.

Technical Expertise:

·          Business Intelligence Tools      :MicroStrategy9.4.1/9.3/9.2.1/9.0.2/8.x, MSBI-SSRS,

Excel Services, MSBI-SSAS, Tabular Cubes, Power View

·          Operating System                    : Windows Family OS

·          RDBMS                         : Teradata v13.10 &Oracle 10g

·          Utilities                         : SQL Assistant, Toad

Client: Intel Corporation

1)    Migration from MSTR to MSBI (Jan 2014 to Present)

Role   : Technical Lead/Architect

Environment: SSAS 2012, SSRS 2012, Performance Point Server (PPS) 2010 / 2013, Power Pivot , Power View , SQL Server 2012, SharePoint 2010 / 2013 and .Net, MSTR 9.3

Roles and responsibilities:

·          Involved in planning, quantification, effort estimation for the entire project.

·          Provided level of effort estimates for the existing MSTR project to be migrated to MSBI.

·          Analysis of the Existing reports, and Creating Mapping document.

·          Involvement in taking decision for the approaches for MSBI tools and Data Modelling.

·          Involved in providing solution for the requirement from MSTR to MSBI.

·          Involved in performance tuning of SSRS reports and Dashboard.

·          Extensively Involved in Data Modeling and Design of Cube.

·          Extensively Involved in Creating & Deploying Tabular Cubes.

·          Modelling of Tabular cubes which involves Many to Many Relationship, Security.

·          Extensively Worked in Creating SSRS Reports Using With SQL Server, Teradata, MDX and DAX Queries.

·          Extensively Created SSRS Reports like Table, Matrix and Chart Reports.

·          Generated Sub Reports, Drilldown Reports, Drill through Reportsas per Client Requirement.

·          Generated parameterized Reports & Enabled Multi Search Concept to Search Parameter Values using Teradata queries and Dax queries.

·          Involved in writing complexDaxqueries which involves calculating time based measures like Rolling last 4 weeks values.

·          Created Reports as per Client’s Requirement in the form of Tabbed Reports.

·          Extensively Involved in Enabling Caching & Subscriptions As per Client’s Requirements.

·          Worked on Creating Data Alerts For SSRS Reports into SharePoint.

·          Extensively involved in Creating BISM Connection in SharePoint.

·          Extensively involved in Creating Excel Service Reports Using with BISM.

·          Extensively worked in Creating Analytical Grids, Charts, KPIs and Scorecards Using PPS.

·          Created Power Pivot Reports and Deployed into Power Pivot Gallery in SharePoint.

2)   Project: Factory Materials Reporting (May 2013– Dec 2013)

            Factory Materials BI (FBI) is a multi-year program that delivers a comprehensive BI Solution in EDW to enable Velocity improvement and cost reduction for Intel Factory equipment spares. The vision of this Program is to enable a Word class Factory materials supply chain and the mission is to deliver simple, intuitive business process and data-driven solutions to optimize Factory Materials Supply Chain activities.

Role   : MicroStrategy Architect/Developer/Analyst

Environment: MicroStrategy 9.3, Teradata, Windows 7

Responsibilities:

·          Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies, Logical Tables.

·          Created MicroStrategy application Objects that included Metrics, Conditional and Compound Metrics, Embedded, Dynamic and Relationship Filters, Filter and Object Prompts, search based Prompt, Templates, Custom Groups, Consolidations and Reports.

·          Involved in developing Complex Reports, Documents and Dashboards through Micro Strategy Desktop.

·          Created Selectors, Panel Stacks, Filtered Panel Stack, Information Windowfor Dynamic Dashboards.

·          Created reports with various object prompts to generate various Ad hoc reports.

·          Used URL API’s for customized solution to client requirements like export to excel, passing values to other reports.

SunView Consulting (P) LTD(September 2012 – May 2013)

Client:IntelCorporation

Project:IssueManagementReporting

IM Reporting is an enterprise reporting solution which integrates SAP, non-SAP, External Data, and Master data. The project is to move EIM data from SAP to EDW and report out as MicroStrategy. Issue management is the process of identifying and resolving issues in a project or organization.This process helps to identify and resolve issues quickly, before they have an undesirable impact.

Role   : MicroStrategy Architect/Developer

Environment: MicroStrategy 9.0.1, Teradata, Windows XP.

Responsibilities:

·          Responsible for gathering and refining business requirements from the Business users.

·          Analyzed business requirements and translated them into technical language for MicroStrategy reporting environment.

·          Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies, Logical Tables.

·          Created MicroStrategy application Objects that included Metrics, Conditional and Compound Metrics, Embedded, Dynamic and Relationship Filters, Filter and Object Prompts, Templates, Custom Groups, Consolidations and Reports.

·          Involved in developing Complex Reports, Documents and Dashboards through Micro Strategy Desktop.

·          Created Selectors, Panel Stacks and Widgets for Dynamic Dashboards.

·          Created reports with various object prompts to generate various Ad hoc reports.

·          Responsible for managing change requests in Maintenance releases and released to Production by adhering to timelines.

·          Perform code reviews and unit testing.

·          Responsible for performing Regression Testing of the Reports and Dashboard for 9.3 MSTR Upgrade from 9.0.1

·          Transitioning the project to the production support team.

BA Continuum India Pvt Ltd. (March 2008 –June 2012)

Project: Global Monitoring Solutions

The GMS is a system developed primarily for loan compliance and monitoring, workload balancing and financial analysis. This application provides associates with customer information and exposure from the Enterprise Credit Risk Information System (ECRIS) along with an interface to schedule and track contractually required documents, loan covenant compliance, financial analysis, and other events required to ensure customers continue to meet agreed upon guidelines.

Role   : MicroStrategy Developer

Environment:MicroStrategy 9.0.2, Oracle 10g, Windows XP.

Responsibilities:

·          Worked as a Subject Matter Expertise in analyzing and understanding functional requirements from software Requirements specification

·          Communicated with the business, Data Modeling team and ETL team in various levels for the stabilization of the reports.

·          Involved in the Phase review and assignment of tasks to other team members.

·          Provided level of effort estimates for new project work, enhancements and fixes.

·          Created MicroStrategy application Objects that included Metrics, Conditional and Compound Metrics, Embedded, Dynamic and Relationship Filters, Filter and Object Prompts, Templates, Custom Groups, Consolidationsand Reports.

·          Involved in developing Complex Reports, Documents and Dashboards through Micro Strategy Desktop.

·          Created Selectors, Panel Stacks and Widgets for Dynamic Dashboards.

·          Created reports with various object prompts to generate various Ad hoc reports.

·          Involved in performance enhancement and tuning of MicroStrategy projects for better performance, accurate SQL and report using VLDB Settings.

·          Responsible for managing change requests in Maintenance releases and released to Production by adhering to timelines.

·          Creation of Intelligent Cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.

·          Worked with back end Database Administrators to provide requirements for necessary back end tables.

·          Understanding the business requirements for development of test plans and test cases.

·          Planning and setting test environment and test data.

·          Involved in Testing of reports and Migrated MicroStrategy 8.1 projects from development to acceptance and to production.

Download Resume Format