SUMMARY:

• Overall 7 years of IT experience as software development, documentation, designing and requirement gathering with major focus around Business Intelligence, Data Warehousing and Database Applications.
• Experience with MicroStrategy version (9.x/8.x) and MicroStrategy tool suite namely MicroStrategy Desktop and MicroStrategy Intelligence Server, MicroStrategy Narrowcast server, MicroStrategy Architect, MicroStrategy Administrator and good familiarity with MicroStrategy SDK.
• Good Knowledge of 2 - Tier (Direct project source) architecture and 3-Tier (Server Project source) architecture and gathering report requirements, from the business users and translating business needs into end-user reports and with the off-shore teams.
• Involved in creating projects that were connected to Data warehouse and Metadata Repository through a 3-tier architecture involving MicroStrategy Intelligence Server.
• Worked to a large extent in creating Schema Objects (Attributes, Facts, Hierarchies, and Transformations) to develop Application Objects.
• Created Application Objects (Filters, Prompts, Metrics, Custom Groups, and Consolidations) to develop Documents and Reports and also Used Quality Center to track the defects.
• Proficiency in creating complex Ad hoc reporting, Documents, Drill Reports and also creating document from multiple datasets like Grid and Graph.
• Well versed with dimensional modeling techniques both Star Schema and Snowflake Schema, Logical and Physical data modeling and duplicating the projects from one environment to another environment and monitor the overall goals of the business.
• Used Erwin to generate logical & Physical models of the Data Warehouse structures
• Extensively worked on creating Dynamic Dashboards with multi layout and used custom Widgets built on flex for specialized dashboard and scheduler cubes that deliver to the user every day.
• Work experience with I- Server and Narrowcast Server to Deliver Daily as well as weekly Reports to wide range of users to deploy the changes between environments.
• Hands on experience in working with very large databases on Oracle 10g/9i/8i/7.x, SQL Server 2005/08/10/12, PL/SQL, Teradata with MicroStrategy Suite and also on VLDB Properties for performance tuning.
• Good work experience in implementing Row Level Security, Report Scheduling and Performance Optimizations and Excellent communication skills and strong architecture skills.
• Ability to learn and adapt quickly to the emerging new technologies.
• Troubleshooting performance alerts, application availability alerts, system utilization alerts, delivery issues with Narrowcast reports and other similar issues with Intelligence Server, Narrowcast Server, Web Server and Mobile Server.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 9/9.3/9.4.1, Tableau.

Data Modeling: Erwin 4.0/3.5.2.

Database: SQL Server 05/08/12, ORACLE 10g/11g, DB2, MS Access, MY SQL,Teradata.

Programming Languages: C, C++, Java, Java Script, PL/SQL

Web Technologies: HTML, XML, CSS

Operating Systems: Windows, LINUX, UNIX.

Methodologies: Agile, Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, CA

MicroStrategy Architect (BI Developer)

Responsibilities:

• Extensively worked on MicroStrategy Desktop to develop interactive Dashboards, Datasets/Reports.
• Created Logical tables and Views for ETL Data.
• Wrote Stored Procedures to populate data into MicroStrategy tables and also performed ETL to fetch the data according to user requirement.
• Extensively created various Schema Objects like Attributes, Facts, Logical Tables etc.,
• Wrote Pass-through functions like ApplySimple in creation of various Attributes, Metrics and Filters.
• Extensively created various Public Objects like Metrics, Filters, Prompts etc.,
• Created various Customized Subtotals on Attribute elements so that Data aggregates on specific elements according to user requirements.
• Worked on enhancing the performance of the reports with the help of VLDB Properties.
• Created Dynamic prompts and filters for data rolling up to Current Month, Current Quarter, Current Year respectively.
• Assisted MicroStrategy Administrator in migration various Objects, Datasets and Dashboards to different Environments using MicroStrategy Object Manager.
• Assisted MicroStrategy Administrator in scheduling subscriptions to emails and local paths for various Business users.
• Involved in creating daily jobs for pre-caching of datasets for faster execution.
• Worked on testing the performance and data of the Dashboards in QA and also performed UAT.
• Extensively tested MicroStrategy data with that of SQL Server by running MicroStrategy generated SQL against SQL Server.
• Created Attributes (using ApplySimple) instead of Consolidations where ever thresholds needs to be applied.
• Created Advanced Level, Conditional and Transformational metrics which indirectly helps in Dashboard to satisfy user requirement.
• Interacted with Business users in understanding their requirements and custom formatting and design of the Dashboards.

Environment: MicroStrategy 9.4.1 Architect, Desktop, Object Manager, SQL Server 2012, Microsoft VisualStudio- Team Foundation Server (TFS), Windows 7 Professional.

Confidential, NC

MicroStrategy Developer

Responsibilities:

• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Created different Project Sources for different environments like production, testing and development.
• Created different Schema Objects like Attributes, Facts, Hierarchies, and Transformations by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters (Report Filters and View Filters), Prompts (Filter, Object, Level and Value), Templates and Reports.
• Worked on MicroStrategy SDK with Java.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, Information objects.
• Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that particular user.
• Worked on excel formatting, macros and templates of the documents which are used in different services.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.4.1 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Teradata, Narrowcast Server, SQL Server 2012, Windows XP Professional.

Confidential, Atlanta

MicroStrategy Report Developer

Responsibilities:

• Involved in the business interaction with the users and gathered the reports that needed to exist in the Project.
• Analyzed the business requirements, identifying the requirements, reviewing and communicating with business users.
• Created the technical specification for the reports for the user acceptance.
• Employed MicroStrategy Desktop in designing the projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• Designed and developed MicroStrategy Schema Objects like Attributes, Facts and Hierarchies using MicroStrategy Desktop.
• Extensively worked in developing Public Objects such as Metrics, Derived metrics, Compound metrics, Filters, Prompts, Consolidations, Custom Groups etc.., for complex reports.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to sales last year.
• Developed various nested prompts to give end users a choice of different filtering criteria each time they run the report.
• Created pre-cached OLAP reports/cubes.
• Created various Dynamic Dashboard documents with multiple panel stacks, selectors and customized widgets.
• Validated report data by running SQL queries in Oracle, and SQL Server databases.
• Created Database Tables, Views, Materialized Views and Procedures.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Proactively created report formats and delivered personalized messages from the Data warehouse through MicroStrategy Narrowcast Server to a wide range of users.
• Worked on the performance tuning of the MicroStrategy reports/dashboards.

Environment: MicroStrategy Desktop 9.4x/9.3x, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web, SQL Server 2012, Oracle 11g, Windows 7, Dashboards

Confidential, TX

MicroStrategy Developer

Responsibilities:

• Interacted with the Users for collecting their requirements for reports and dashboard design and formatting.
• Strictly followed the Content Management and Release Management schedule as per client guidelines.
• Extensive interaction with the Database experts to understand the Source System and efficient translation of technical data to Business terms through self developed design templates.
• Involved in Data model (Logical and Physical) with data modeling team for an efficient data.
• Created a Database Instance for MicroStrategy choosing all the needed tables, table prefixes and updated the Schema in the project.
• Identified and created Schema Objects such as Facts, Attributes, Hierarchies and Transformations.
• Created application objects such as Reports, Templates, Documents, Filters and Prompts.
• Administrated and maintained MicroStrategy Intelligence Server and Web Server.
• Created comparative reports using Transformations.
• Created Drill Maps for designing and implementing advanced data drilling that allows users to view data at different hierarchical levels.
• Created Database Tables, Views, Materialized Views and Procedures.
• Developed Adhoc-reports in grid and graph mode using MicroStrategy Desktop and Web by combining the template with filters.
• Defined customized sorts in report level to enhance the performance of dashboards.
• Worked on resolving issues relating to implementation of reports and performance enhancement at report level.
• Created complex report metrics, compound metrics and relationship filters.
• Created time based and event based triggers to initiate and automate repetitive tasks
• Attended meetings to discuss and finalize the business requirements and design for the reports.
• Created interactive Dashboards using radio buttons, check boxes, panels, slider, button bar, etc.
• Used Flash Widgets with rich interactivity to enable users understand the data more effectively.
• Implemented row level security for various user groups within MicroStrategy.

Environment: MicroStrategy 9.3.1 Desktop/Web, Windows, MicroStrategy Intelligence server, MicroStrategy Administration, Dashboards, SQL 2008,Oracle 11g MS Office.

Confidential, AZ

MicroStrategy Developer

Responsibilities:

• Collected and documented business requirements from manager and translated them into report specifications for MicroStrategy platform. Generated reporting strategies and aided in presentations involving business teams.
• Developed reports using MicroStrategy 9.2.1, OLAP Services. Interacted with management to gather short term and long term business requirements and intended application purpose.
• Installed & configured Project Source, Metadata and Projects and performed administration tasks for the Projects using MicroStrategy 9.2.1.
• Worked as a part of the Data modeling and Data integration (ETL) team to create and implement the schema objects (Attributes, facts, Hierarchies) and public objects (Templates, Filters, Prompts, and Metrics), drilling, for the Trend and Ad-hoc Reports.
• Used consolidations and custom groups to enable for better analysis and enabled drill capabilities and ad-hoc analysis for the various user communities.
• Customized and optimized reports for various users using MicroStrategy features like Project and Desktop preferences
• Used MicroStrategy Narrowcast server to send personalized business intelligence information and report via email and web wireless.
• Managed the quality of reports and data presented to the users (Regional managers and senior executives).
• Performed various administration tasks like Cache Management, Scheduling Management, User Group Management and Performance Tuning.

Environment: MicroStrategy 9.2.1Desktop Reports, Web Intelligence Reports, OLAP Services, Narrowcast Server, Administration, Dashboards, Teradata 13.10, Windows.

Confidential, NJ

MicroStrategy Developer

Responsibilities:

• Data Validation & Documentation.
• Designing Logical Data Model, Physical data Model Lookup tables, Fact columns.
• Developed Schema Objects like Attributes, Facts, and Hierarchies.
• Developed Reports by defining Templates, Filters, and Metrics with Metric Dimensionality.
• Analysis was done incorporating Qualities & Consolidations.
• Reports were supported by Graphical representations and Alert facilities & Caching.
• Upgrading was done with MicroStrategy 9.0.2 to utilize Desktop facilities.
• Designed and created Multi Dimensional model using MicroStrategy Architect.
• Generated advanced reports in Grid, Graph and SQL Mode consisting of data analysis by combining template with filters.
• Created various report filters and view filters.
• Created Database Tables, Views, Materialized Views and Procedures.
• Created transformations for comparing values at various time periods.
• Involved in Administration of MicroStrategy Intelligent Server.
• Created Metrics for enabling end users to generate customized reports by creating their own templates and filters.
• Created dynamic prompts to provide various filtering criteria for end users.

Environment: MicroStrategy Desktop 9.0.2 /9.0.1, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, SQL Server 2008, Windows.

Confidential

BI Developer

Responsibilities:

• Gathered and analyzed business requirements from clients and end users.
• Developed data model by working closely with data modeling and ETL Teams.
• Improved data quality by reducing redundancy in reports.
• Involved in creating MicroStrategy objects like Metrics, Filters, Prompts, Templates, consolidations, Custom groups using MicroStrategy Desktop.
• Used Public Objects to generate reports for Business Analysis in grid, graph, map, scorecard and combination formats.
• Used MicroStrategy desktop to run existing reports.
• Understand the type of schemas that best support MicroStrategy in different scenarios.

Environment: MicroStrategy Desktop 9.0, MicroStrategy Web, MicroStrategy AdministrationMicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, SQL Server 2005, Oracle 10g Windows.

Confidential

Developer

Responsibilities:

• Identifying and creating Oracle database objects (Tables, Views, Synonyms, Indexes, Constraints, Procedures, Functions, 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.
• Wrote complex triggers to build up the audit log tables for critical data updates.
• Developed shell scripts to automate
• Assisting in the maintenance, review, and update of the User Guide
• Assisting in User Acceptance Testing and Assisting in providing user training;