SUMMARY:

• Over 7 years IT Experience in the Analysis, Design, Development and Implementation of Micro Strategy developer as with major focus on Business Intelligence tools, Data Warehousing and Database Applications.
• Worked in installing and Configuring Micro Strategy 9.x/8.x, Micro Strategy Desktop, Micro Strategy Web, Micro Strategy Mobile, Micro Strategy Intelligence Server
• Worked in creating and integrating Micro Strategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Experience in implementing all phases of the System 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 Micro strategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation, migration and testing.
• Worked in Upgrades from Micro Strategy 8.x to 9.x on Windows platform.
• In-depth understanding of designing physical Data Models using Micro Strategy Architecture.
• Hands-on experience working with VLDB and Optimization of query performance.
• Well versed in developing interactive Dashboards and Scorecards.
• Extensively worked on designing and deploying Dashboards on Micro Strategy Mobile.
• Extensive knowledge METRIC, Graphs, Data group, Explore the data, Visualize the data, Drill Through the data, Adhoc reports.
• Performance Optimization, performance monitoring, configuring and tuning experience in Micro Strategy Business Intelligence tool suite (Intelligence server, Web) and in database.
• Advocates definition of and adoption of best practices and standards. Adopt at assessing existing DW/BI oriented methodology and development process and recommending enhancements to improve deliverable quality, time to market and delivery to requirements
• Pro-active involvement in continuous performance improvements for existing OLAP systems.
• Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.

TECHNICAL SKILLS:

BI Tools: MicroStrategy9.x/8.x/7.x (Micro Strategy Desktop/ Web)

Data Modeling Tools: Erwin Tools

ETL Tools: Informatica Power Center 9.1

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

Programming: C, C++, SQL & PL/SQL

Scripting Language: HTML, Java

RDBMS: Oracle 12c/11g/10g, SQL Server 2012 and DB2.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Micro Strategy Developer

Responsibilities:

• 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 Micro Strategy 9.0.1.
• Worked in Upgrading of version 8.1.2 to 9.0.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 Micro strategy objects necessary for the deliverable.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• 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.
• Creating Dash Board Reports to view personalized reports based on user requirements
• Created different kind of Dashboards like traditional performance summery, traditional metric, dynamic content in both the interactive & flash mode.
• Worked in Developing Reports by using Free Hand SQL Queries in Micro Strategy 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.
• Extensively worked on Object manager and Command manager.
• Provided post production support to end-users.

Environment: MicroStrategy 9.4.1/9.3.1 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 14.0, Oracle 12c/11g, UNIX, Windows XP.

Confidential, Raleigh, NC

Sr. Micro Strategy Developer

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.
• 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.
• Designed Interactive Dashboards in Micro Strategy Web to assess company’s performance and monitored the overall goals of the business.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Micro Strategy Desktop and Micro Strategy web.
• Created Facts, Attributes and Hierarchies using the Micro Strategy Architect.
• Developed various Metrics, filters, consolidations, custom groups and prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• Worked in customization of Micro Strategy Web.
• Worked in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Worked in creating various transformations to analyze different metric values in this year to last year using Micro Strategy Architect.
• Extensively worked on Documents by adding additional functionalities using XSL sheets to create more personalized documents with images, hyperlinks and other report objects.
• Worked in performing various analyses using the Micro Strategy Desktop.
• Used Narrowcast server for content Management, Self-Subscription, Profile Management, Proactive information Delivery and alerting and to personalize the reports and information.
• Coordinate scrum, release committee meetings, defect triage for defect tracking and defect management, root cause analysis and speedy resolution.
• Capture daily work progress and generate weekly status report.

Environment: MicroStrategy 9.3.1/9.2x, Desktop, Web, Intelligence Server, Narrowcast Server, Teradata 13, Erwin r9, Visio 2013, Windows XP.

Confidential

Micro Strategy Consultant

Responsibilities:

• Analyzed the business requirements identifying the requirements reviewing and communicating with business.
• Installation of Micro strategy Desktop and creating a Micro strategy project.
• Creating Attributes, Facts and relationship between attributes using Micro strategy Architect.
• 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 Micro strategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using Micro strategy Architect.
• Defining Drill Hierarchies and creating relationship between attributes.
• Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
• Worked with Data Architect in Designing the Data Model.
• Created reports using complex filters and compound metrics and prompts.
• Creating reports from intelligent cubes, DataMart Reports.
• Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Worked on Creating Security Roles, Micro strategy User Groups and Users, assigning security roles to Users and Groups.
• Worked in creating security filters to end users to access data based on their privileges.
• Created services using Subscription sets, Schedules, and Information Objects.
• 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.

Environment: Microstrategy 9.2.1/9.0x, Desktop Reports, Narrowcast server, Oracle 11g, SQL Server 2008/12, SQL, PL/SQL, DB2, TOAD.

Confidential

Micro Strategy Consultant

Responsibilities:

• Join in daily standup meetings with Project manager, business analyst, ETL team, data molders, testing teamto discuss the user requirements and status updates.
• Supporting the Project team in SIT and UAT testing.
• 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.
• Extensively worked in creating and integrating Micro Strategy reports and Objects (Attributes, Facts, Filters, Metrics, Facts, Prompts, Templates, Consolidations, Custom Groups, Drill Maps, Transformations, etc.) using the Micro strategy Desktop and Micro strategy Web interfaces.
• Created ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using Micro Strategy desktop and web.
• Created Logical Tables/Freeform Reports within Micro strategy for complex reporting situations.
• Created Transactional reports to submit transactions to the database.
• Extensively worked on Report Services to create Performance Dashboard reporting.
• Deployed existing dashboard on iPhone/iPad to demonstrate Micro Strategy Dashboard capabilities.
• Worked in Query optimizations using VLDB properties.
• Troubleshoot and Debugging Reports and Documents for the web users.
• Working with Micro Strategy technical support for any critical issue resolution.

Environment: MicroStrategy Desktop 8.1x/9.0x, MicroStrategy Intelligence Server 8.1x, Informatica, IBM DB2. SQL, PL/SQL, TOAD.

Confidential

Database Developer

Responsibilities:

• Identifying and creating Oracle database objects (Tables, Views, Synonyms, Indexes, Constraints, Procedures, Functions, and Database Triggers).
• Deployed Oracle forms and Oracle Reports on web. Converted some of Forms 5.0 to Forms 6i
• Created visual attributes, property classes, object groups.
• Created object library to customize all forms uniformly.
• Converted some of Forms 5.0 to Forms 6i.
• Wrote complex triggers to build up the audit log tables for critical data updates.
• Powerful relational database allows for fast and detailed reporting.
• Developed shell scripts to automate.
• Assisting in the maintenance, review, and update of the User’s Guide.
• Wrote procedures to meet ad-hoc requirements to replicate data from one table to another.
• Involved in System Maintenance.
• Performed Backup and restoration of system and user databases and involved in scheduling the backups.
• Managing the use of disk space, memory and connections.
• Assisting in User Acceptance Testing and Assisting in providing user ;

Environment: Oracle 10g/9i, UNIX, SQL, PL/SQL, Windows NT.