SUMMARY

• Over 7 years of IT experience in Business Intelligence(BI) Project Development and Implementation Using Micro strategy 10.3/10.2/10.1/9. x/8.x Product Suites including Microstrategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligence Server.
• Responsible for gathering complex business and functional requirements and documented them into Conceptual Approach, Business Requirements, Functional Requirement, Detailed Design Document, and User Stories.
• Extensive working experience with MicroStrategy 8.x/9.x tools suite (Architect, Administrator, Desktop, Report Services, and Narrowcast Server).
• Designed, Developed and Automated Interactive Dashboards, Documents, Reports in MicroStrategy to assess company's performance and financial data.
• Extensively involved in data modeling to create attribute relationships, and hierarchies
• Generated and implemented MicroStrategy Reports by creating projects, Attributes, Facts, Hierarchies, Transformation, Metrics, filters, and Templates
• Experience in development of reports with MicroStrategy Multisource fetching data from multiple data source systems.
• Extensive knowledge of KPIs/METRICs, Grids, Graphs, Data analysis, Data Visualization, Data Grouping, Data Drilling Capabilities and Ad - hoc reporting.
• 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.
• Experience in creating database views, SQL scripts, PL/SQL code.
• Co-ordinate with end users to resolve real time issues and quick turnaround of critical issues.
• Developed training documents and trained technical and business end users to create interactive Ad-hoc reports and to use MicroStrategy tool.
• 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.
• Expertise in Creating Hyper Links in Documents and Drill Reports.
• Understanding the requirements, analyzing the functional specs and involved in the designing of interfaces.
• System Optimization, performance monitoring and tuning experience in Multiple BI applications.
• Extensively worked, in Creating Interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.

TECHNICAL SKILLS

Business Intelligence: Microstrategy 10.3/10.2/10.1/9. x/8.x (Microstrategy Desktop, Web, SDKIntelligenceServer, OLAP Services, Report Services, Narrowcast ServerCommand Manager, Administration, Object manager, Command Manager,Tableau7/8/8.1

ETL: Informatica, SQL Server Intelligence Services (SSIS)

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

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

Web Technologies: MS Front Page, HTML.

Databases: Teradata, Oracle 12c, 11g,10g,9i, SQL Server 2008, MySQL

Tools: /Utilities: SQL loader / Toad 7.x/8.x, Management Studio, SQL Developer, MS Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Senior MicroStrategy Lead/Developer

Responsibilities:

• Collected business requirements from product manager and Lead by understanding the Source System and translating them into report specifications for MicroStrategy platform.
• Responsible for gathering complex business and functional requirements and documented them into Conceptual Approach, Business Requirements, Functional Requirement, Detailed Design Document, and User Stories.
• Designed, Developed and Automated Interactive Dashboards, Documents, Reports
• Implemented Schema/Warehouse changes to support Multi-Sourced reports from Impala (ClouderaHadoop), Hive (ClouderaHadoop), Exadata and DB2.
• Created schema objects (Attributes, Facts, Relationships between various attributes, Logical Tables, Drill Maps) to implement MicroStrategy Reports.
• Created database views to support schema design and report development.
• Created Analytical engine bypass functions like Apply Simple & Apply Comparison, wherever necessary
• Performance Tuning of SQL queries and reports by changing VLDB properties.
• Created Services in MicroStrategy Narrowcast server using static and dynamic subscription sets.
• Distributed reports in Narrowcast server by creating Narrowcast services and event based services on time-based schedule.
• Co-ordinated with the test team regarding the test plans and assisted them to understand the business functionality and in creating test cases.
• Provide support to QA team during testing and users during UAT testing for any MicroStrategy related issues.
• Provide end to end support right from Development to Production

Environment: MicroStrategy 10.2/9.4x, SQL Server 2008, OLAP, Windows Server 2003, MicroStrategy Administration, Dashboard, Business Objects Designer,Mobile, Visual Insights, Tableau and SQL.

Confidential, Minneapolis, MN

Micro Strategy Architect /Admin

Responsibilities:

• Gathered requirements from client
• Designed schema model
• Created schema objects, public objects
• Created complex MicroStrategy reports/dashboards
• Designed and developed logical data model for MicroStrategy reporting environment.
• Identified source tables and columns required to create MicroStrategy project.
• Improved the performance of the reports by changing VLDB properties.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies using the Tableau and Microstrategy mobile.
• Created custom designed business object reports and turned the report layouts to tables, charts and other representations as per the business requirement.
• Worked on the Oracle 12c which achieves the automatic data optimization that ensures the data usage is optimal.
• Worked with Logistics Analyst who developed business requirement. Build mock up reports and presented to the users before starting the report development.
• Took part in design and development of Data marts and integrating them with HR Data warehouse.
• Worked on creating a new development microstrategy application and its associated dashboards, reports etc.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Developed different transformations which help business users to compare present data with previous year’s data in reports.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Highly involved in working with Multi-Dimensional Model, Star & Snow Flake Schemas and other Data Modeling and Data Warehousing applications.
• Migrated projects from one environment to another
• Upgraded MicroStrategy environment from 9.0.2 to 9.2.1m. Technical lead for the upgrade. Upgraded 23 servers including I-servers, web servers, Narrowcast servers, Enterprise Manager, etc. Successful upgrade with zero issues. User base was 3500+
• Worked on Netezza upgrade MicroStrategy testing

Environment: MicroStrategy 8.0.2, Oracle9i, Informatica, Toad, Windows XP, SQL Server 2008, Oracle 12c,11g, Erwin, ETL, OLAP, Informatica, Windows Server 2003, Linux, MicroStrategy Administration, Dashboard, Business Objects Designer, Teradata,Tableau, Visual Insights and SQL.

Confidential

MicroStrategy/ BI Developer

Responsibilities:

• Worked along with the technical team and the business analyst to gather the report requirements, and analyzed the needs of the end users
• Identified and defined Schema objects like Facts, Attributes, Hierarchies, Transformations and Relationships between attributes.
• Extensively developed Metrics, filters and prompts to give Decision makers a handy tool to choose the criteria for reports and view information in different perspectives.
• Worked with business analysts to baseline the reporting requirements.
• Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer.
• Worked with data architects on data needed for testing the reports and dashboards.
• Extensively worked with Microstrategy architect to develop schema objects such as, attribute, facts, hierarchies, consolidations and transformations etc.
• Extensively used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups etc.
• Createddrill mapsfor end users to drill down and recover data.
• Extensively worked with MicrostrategyIntelligence Server, MicroStrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.

Environment: MicroStrategy 8.0.2, Teradata 7.0.1.05, Informatica, Windows XP.

Confidential

MicroStrategy Developer

Responsibilities:

• Analyzed the reporting requirements for the project
• Created Complex MicroStrategy Reports.
• Developed Documents by using Report services.
• Created Freeform SQL reports for complex reports.
• Involved extensively in troubleshooting and resolving all outstanding issues
• Assisted in preliminary data quality analysis
• Consolidated report requirements for the project, based on the dashboard requirements
• Developed reports required for the project in MSTR 8.1
• Wrote test cases for dashboards
• Conducted selective data testing on dashboards by writing SQL code against the database (SQL Server 2005)
• Tested the Dashboard and completed the Test Case
• Used Bugzilla as the Issue Reporting tool for the project

Environment: MicroStrategy 8.0.2, Teradata 7.0.1.05, Informatica, Windows XP