PROFESSIONAL SUMMARY:

• Total 3.7 years of strong experience inMicroStrategy 10.x/9.x, MicroStrategyDesktop,MicroStrategyReport Services, MicroStrategyWeb, MicroStrategyIntelligence server.
• Excellent hands on work experience in building Ad - hoc/Analytical reports using ROLAP & MOLAP Business Intelligence reporting tools (MicroStrategy 10i & 9i), MicroStrategy Desktop, MicroStrategyAdministration, MicroStrategy Web, Object manager, Intelligent Cubes, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider and Data Mart.
• Expertise in using MicroStrategy OLAP Cubes to extensively improve the performance.
• Created I Cubes and automated the I Cubes refresh by using System Manager.
• Experience in Scheduling Intelligent Cubes Incrementally and on Time Schedule.
• Extensive Experience in creating the Dynamic Dashboards & Scorecard reports using MicroStrategy 9.4.1.
• Hands on experience working with Visual Insight Dashboards.
• Good exposure to BI reporting MicroStrategy 9i, 10i & Tableau & SQL programming, RDBMS - Teradata, Oracle, SSIS, SSRS and SQL server.
• Experience installing, configuring and administering MicroStrategy environments
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Knowledgeable in business functionality for developing multidimensional modeling (Data Modeling).
• Delivered reports inDesktopandWeband viaDistribution Servicesto multiple users.
• Experience inSchema designand creatingSchema objects usingStar and Snowflake(Hierarchies, Attributes and Facts, Transformations).
• Excellent experience in MicroStrategyReport development, Reporttesting, Reporttuning,Ad-hoc,scheduling report delivery andAlerts.
• Extensive experience on all types of MicrostrategyFilters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Proficient in creating Simple Metrics, Compound Metrics, applying Transformation, using Prompts, Filters.
• Experience in using Project Merge, Object Manager,and Enterprise Manager.
• Created workflows using System Manager and automated using windows Task Scheduler.
• Created Security Filter to restrict row level data for user / user group.
• Extensive MicroStrategy development hands on experience withDesktop,Architect,Intelligence Server,Report Services,Enterprise Reporting, OLAP provider,Data MartandWeb components
• Exceptional ability to quickly master new concepts and capable of working in-group as well as independently with excellent communication skills.
• Experience working in a structured, multi-person development environment.
• Experienced in preparing resource & effort estimations/forecasts, MicroStrategy Roadmap Creation for end-to-end BI projects.
• Extensive experience in onshore/offshore coordination and responsible for project deliverables.
• Ensure the team follows the change control process when there is any request to change the agreed scope.

TECHNICAL SKILLS:

Business Intelligence Tools: MicroStrategy Desktop 8x/ 9.0/9.4.1/10.4 (MicroStrategy Developer, MicroStrategy Web Microstrategy Intelligence Server, Report Services Documents, Dynamic Dashboards)

Databases: Oracle 8i/9i/10g, Teradata, SQL Server, Ms-Access

Platforms and Web Servers: Windows 7, 8, 9x, Vista, MS DOS, Internet Information Server (IIS) 5.x, Informatica 8.x/9.x, Data Stage, UNIX/LINUX, TOAD

Design Tools: MS Visio, Erwin, MS Excel, PowerPoint

PROFESSIONAL EXPERIENCE:

MicroStrategy Developer

Confidential, Dallas, TX

Responsibilities:

• Analyzed the business requirements identifying the requirements reviewing and communicating with business.
• Performed dataintegrity analysis and identified performance optimization opportunities.
• Administered MicroStrategyenvironments and formulated user groups.
• Creating dashboards compatible for viewing in Mobile.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Administered the object change management process: Object migration across the various environments using Object Manager.
• Extensive experience on Business analysis and Enterprise reporting solutions delivery usingCrystal Reports,CrystalEnterprise.
• Expert in creating complexCrystalReports(Ad-hocReports, FrequencyReports, SummaryReports, Drill Down, Dynamic Grouping, Graphical, agingReports)
• Created Datasets based on Intelligent Cubes, Derived Metrics and View filters using OLAP services.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc
• Created Datasets based on Intelligent Cubes, Derived Metrics and View filters using OLAP services.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Involved in Creation of Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Micro strategy objects necessary for the deliverable
• Analyzed and developed the new objects in Dev environment and after testing the objects and reports migrated to Production Environment.
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports.
• Defining Drill Hierarchies and creating relationship between attributes.
• Involved in project discussions related to schema objects which acts has a semantic layer for the MicroStrategy project.
• Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
• Coding of PL/SQL procedures, functions, packages and database triggers to implement business logic.
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements
• Coordinated with internal and external stakeholders.
• Developed Various SQL Server Reporting Services(SSRS) reports which are used to track agent performances.
• Designed and developed stored procedures, views and tables necessary to supportSSRSreports.
• Strong knowledge in creating Intelligent Cubes, which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Involved in creating security filters to end users to access data based on their privileges.
• Have used several Widgets for Dashboard reporting
• Formulated grid, graph, document and dashboard reports.
• Developed Dashboards that provide users a highly graphical, summary view of key metrics.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (Graph Matrix) both in flash modes.
• Have created Dashboards in both the Interactive, Presentation & flash mode
• Designed and developed the Dynamic dashboards.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Closely worked with ETL/DBA teams to troubleshoot data issues and enhance database performance
• Tested all the reports by running queries against the warehouse-using SQLDeveloper.
• Extensively used Report Services to generate Documents for exporting to Excel & PDF.
• Worked extensively on Transaction services for Creating Insert, Update & Delete Transactions
• Worked on Agile project tracking tools (such as JIRA) and structured development methodologies (such as Agile Scrum, iterative)

Environment: MicroStrategy 10.4.1, MicroStrategy Administrator, Architect, Report Services, MicroStrategyDesktop, MicroStrategy Web, MicroStrategy Dashboards, MS-Excel, Toad, Oracle 10g.

MicroStrategy Consultant

Confidential, Boston, MA

Responsibilities:

• Join in daily standup meetings with Project manager, business analyst, ETL team, data molders, testing teamto discuss the user requirements and status updates.
• 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.
• Experienced in implementing MicroStrategy Schema Objects and Application Objects like Attributes, Hierarchies, Filters, and Metrics using MicroStrategy Desktop to create reports and dashboards for the business users.
• Implemented infrastructure and software architecture modifications, best practices, and naming standards resulting in quicker delivery to the business and accelerating the software development lifecycle.
• Involved in troubleshooting MicroStrategy Reports, by optimizing the SQL using VLDB properties for creating complex reports using Advanced Filters, Compound Metrics, Conditional, Transformation and Level Metrics
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes.
• CreatingTableauscorecards, dashboards, Heat maps using show me functionality.
• Publishing reports and dashboards toTableauserver.
• Used Administrator for accurate information regarding system usage and performance to both MicroStrategy and Tableau
• Worked with MicroStrategy Desktop/Web to create new documents/dashboards and fix the issues with existing documents/dashboards.
• Involved in complete life cycle of multiple BI reporting projects of the group.
• Developing logical models, building hierarchies, attributes and facts, extracting tables from warehouse catalog.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Developed Scorecards and Dashboards that provide users a highly graphical, summary view of key metrics.
• Caching Reports in the Intelligence Server daily, enabling user to run the report immediately.
• Optimized the performance of the MicroStrategy platform by implementing suitable report design processes, and SQL tuning.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Designed and publishing visually rich and intuitive Tableau Dashboards for executive decision making.
• Worked on MicroStrategy Object Manager to move objects from development environment to the test environment.
• Involved in fork lifting the MicroStrategy project from Oracle to Teradata.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
• Worked in creation of Projects, ODBC, database instances and configuration of project.
• Created transformational metrics (Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Involved in maintaining optimal performance of BI application, performance monitoring, capacity planning, and tuning for multiple users.
• Designed automated Asset and Private Equity Rater to build the policy to determine premium using Excel /VBA.
• Validate data import usingVBA
• Designed configuration tab to map data fields betweenreporttemplate and various cost sheets.
• Configured Enterprise Manager to collect statistical data related to different projects.
• Adapt at managing projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Extensively involved in data modeling to create attribute relationships, and hierarchies.
• Worked in optimization of code and tuning queries for performance.
• Provided postproduction support to end-users.
• Worked on MicroStrategy Object Manager to move objects from development environment to the test environment.
• Created Cubes and scheduled them to run weekly bases.
• Created Visual Insights reports from Cubes.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Capture daily work progress and generate weekly status report.
• Worked on the performance tuning of the MicroStrategy reports.
• The Projects in Project Sources were connected to the Data warehouse and Metadata Repository through a 3-Tier Architecture involving MicroStrategy Intelligence Server.
• Scheduled jobs to executeSSISpackages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks
• Co-ordinate test plans and provided feature/functionality/usage scenarios for the Managers.
• Tested report layouts, validated the SQL query, prompt orderings, export/print functionality and drilling options
• Worked on data Integration for different sources using Informatica PowerCenter/Power Exchange 9.4.1 Tools- Repository Manager, Informatica Designer, Workflow Manager/ Monitor and Upgraded the system from 9.4.1 to 10. Participated in team meetings and proposed ETL strategies.

Environment: MicroStrategy 9.4.1, (Desktop, Web Server, Object Manager, Enterprise Manager, Distribution Services), Informatica Power Center, Quality Control, Teradata, ODBC, Windows 7, HTML.

MicroStrategy Developer/Administrator

Confidential

Responsibilities:

• Reviewing business and functional requirements for various modules so as to have better understanding of the overall application.
• Worked with BI team analysts to come up with the High priority reports for go live.
• Worked closely with the ETL developers to develop new MSTR attributes
• Involved in Dimensional Data Modeling (Snow-Flake schema) Data Architecture, Business and Data Analysis.
• Involved in designing of Schema Objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Involved in development of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports on top of the Schema Objects.
• Created Various Intelligent Cubes to improve the performance of the reports, Also used various capabilities like Banding, Page By, Pivoting, Sorting and Thresholds.
• Involved in creation of Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex MS reports in an efficient way.
• Creating Dashboard Reports, RS Documents to view personalized reports based on user requirements.
• Implemented infrastructure and software architecture modifications, best practices, and naming standards resulting in quicker delivery to the business and accelerating the software development lifecycle.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Created new Dashboards that are critical for the go live week so that leadership won’t miss any important information
• Involved in setting of VLDB properties at report and metric levels to define Outer joins between tables to get complete data from the required table and used different Query Optimization settings specific to database to improve performance of Query.
• Created various Monthly Dynamic Dashboard documents with multiple panel stacks, selectors and customized widgets
• Created Dashboard and Scorecards, using Report Services Documents. Created Relationship Filters based on Existing Model.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Involved in creation of Services using Subscription sets, Schedules, Device, Locale and Information objects.
• Involved in creation of User/User groups and assigning Privileges them the User Manager using administration.
• Involved in development of Reports against Intelligent Cubes, which involves faster execution of query compare to the data warehouse.
• Coordinate with DBAs and the ETL architects to design and create Tables in the SQL server database to improve the performance of reports.
• Involved in Data validation testing and UAT to ensure data quality.
• Provided postproduction support to end-users.

Environment: MicroStrategy 9.2.1 Product Suite (Architect, Desktop, Object Manager, Enterprise Manager, Web,), TeradataV2R5, Oracle 10GR2, DataStage, Toad.

MicroStrategy Developer

Confidential

Responsibilities:

• Involved in Creation of Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Micro strategy objects necessary for the deliverable.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Attended weekly project and team meetings and provided status on the assigned tasks.
• Created project plans for development of MicroStrategy projects.
• Worked on building IPAD mobile reporting platforms that supported Ecova field users. This project retired a legacy reporting application. The reports ran 80% faster than the legacy application and highly improving the user experience. The report used functionalities like Geo Coding and Google Map integration
• Extensively used INFORMATICA Power center 8.6 client to extract data from sequential files, Oracle databases and loaded into a single data warehouse repository in SQL Server.
• Developed PL/SQL Business Functions, which were used with MicroStrategy Reports.
• Designed and translated Logical Data Models into various Physical Warehouse Schemas.
• Partnering with our business clients to understand the business analysis to be performed and subsequent required reports.
• Wrote Stored Procedures to encapsulate Business processes.
• The Projects in Project Sources were connected to the Data warehouse and Metadata Repository through a 3-Tier Architecture involving MicroStrategy Intelligence Server.
• Checked all the reports available in previous project, Scan data were developed with same or more functionality in EDW.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Analyzed the user requirements and project specifications to identify entities.
• Implemented infrastructure and software architecture modifications, best practices, and naming standards resulting in quicker delivery to the business and accelerating the software development lifecycle.

Environment: MicroStrategy (Desktop, Intelligence Server, Web), SQL Server 2000 and Windows.