PROFESSIONAL SUMMARY:

• Over Seven and half years of IT experience, with more than 3 years of experience in the Analysis, Design, Development and Implementation of Microstrategy developer as with major focus on Business Intelligence tools.
• Worked in installing and configuring Microstrategy 9.3.1, 9.4.1 and 10.3, Microstrategy Desktop, Microstrategy Web, Microstrategy Intelligence Server & Distribution Services.
• Expertise in working with Schema Objects like Attributes, Facts, Tables, Transformations, Hierarchies, Functions and operators
• Extensively worked in creating and integrating Public Objects (Filters, Metrics, Prompts, Reports, Templates, Documents, Custom groups and Consolidations)
• Experience in implementing all phases of the Software Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Client - Server, Multi-tier, Web, Data Modeling and Data Warehousing/OLAP/Business Intelligence Applications.
• Experience in Microstrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation, migration and testing.
• Worked in Upgrades from Microstrategy 9.x to 10.x on Windows platform.
• Hands-on experience working with VLDB and Optimization of query performance.
• Well versed in developing interactive Dashboards and Scorecards.
• Worked in creating and integrating Microstrategy Reports and Intelligent Cubes.
• Good Knowledge in Oracle, SQL Server and Data warehousing modeling including Star Schema and Snowflake schema.
• Exposure to client interaction, user-requirement analysis and User support.
• Exceptional analytical and problem solving skills. Self-motivated team player with the ability to communicate effectively at all levels of the development process.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good leadership qualities with experience in leading a team of 20+ members, developers, advising technical groups on coding best practices.

TECHNICAL SKILLS:

BI Tools: Microstrategy 10.x/9.x (Microstrategy Desktop/ Web)

Data Modeling Tools: MS Visio

ETL Tools: Informatica Power Mart 7.1/6.0

Operating Systems: Windows 10/8/7/Vista/XP, Windows NT, UNIX, Linux.

Programming: VB 6.0, VBA, C, C++, C# .net, SQL & PL/SQL

Scripting Language: HTML, Java

RDBMS: Oracle 12c/11g/10g, SQL Server 2008 & 2012 and Netezza.

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, IL

Microstrategy Lead/Developer

Responsibilities:

• Involved in large scale implementations for PepsiCo.
• Development of new Documents and Dashboards.
• Extensively involved in data modeling to create attribute relationships, and hierarchies
• Developed new reports and converted existing reports for the business line to satisfy the specifications.
• Creating Dashboard Reports to view personalized reports based on company’s requirements
• Created different kind of Dashboards like Trend, performance summary, traditional metric, dynamic content in both the interactive & express mode.
• Created Dynamic Dashboards as per client’s requirements using various graphs and widgets
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Generated and implemented Microstrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates.
• 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
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Knowledge on Microstrategy Distribution Services.

Environment: Microstrategy 9.3.1, 9.4.1, 10.3 (Microstrategy Administrator, Microstrategy Architect, Microstrategy Desktop, Microstrategy Object Manager, Microstrategy OLAP Services, Microstrategy Project Manager, Microstrategy Intelligence Server), Oracle 12c/11g, UNIX, Windows 7.

Confidential, Schaumburg City, IL

Microstrategy Developer

Responsibilities:

• Involved in largescale implementation for clients Nestle and Unilever.
• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications.
• Worked in Installation and configuration of Microstrategy 9.3.1.
• Worked in creation of Projects, ODBC, database instances and configuration of project.
• Worked in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Microstrategy objects necessary for the deliverable.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• 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.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Creating Dash Board Reports to view personalized reports based on user requirements
• Worked in Developing Reports by using Free Hand SQL Queries in Microstrategy Desktop.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Worked in the creation of three types of reports like Standard reports, Ad hoc Reports and Dart mart reports.
• Worked in optimization of code and tuning queries for performance.
• Extensively worked on resolving of user issue.
• Provided post production support to end-users.

Environment: Microstrategy 9.3.1/9.4.1 (Microstrategy Administrator, Microstrategy Architect, Microstrategy Desktop, Microstrategy Object Manager, Microstrategy OLAP Services, Microstrategy Project Manager, Microstrategy Intelligence Server), Netezza, Oracle 12c/11g, UNIX, Windows 7.

Confidential, Schaumburg IL

Project Lead

Responsibilities:

• Extensively involved in interacting with the users and gathering the requirements, and analyzed the needs of the end users.
• Worked in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
• Lead a Development & Testing teams of 20 + members
• Requirements gathering, Analysis, Design and Documentation of new features and services based on the Change Requests (CR) requested by the clients
• Carry out code changes and enhancements to the existing systems based on the Change Requests (CR) requested by the clients
• Educating project team members about the requirements and then feasibility of the solution and also the new team members.
• SME (Subject Matter Expert) support for External Clients in-case of high severity issues.
• Key role in migrating external clients from NITRO (Nielsen proprietary BI tool) to Nielsen Insight Studio (NIS).

Environment: Visual Studio 2005/ 2012 IDE, Install Shield 2014, C#.net, VBA, Windows 10, 8.1 & 7.