SUMMARY

• 7 years of experience in Business Intelligence, ETL and Data warehousing Technologies with expertise in MicroStrategy versions 8, 9 and 10x: Intelligence Server, Administrator, Architect, Desktop Designer, MicroStrategy Web Administration, Security Administration, Object Manager, Integrity Manager, Report Services, Dashboards, Enterprise Manager and Narrowcast Server
• Expertise in building projects and creating reports using MicroStrategy product suites including MicroStrategy Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, and MicroStrategy Intelligence Server.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• In - depth understanding of fundamental data warehousing concepts such as Dimensional Modeling, ER Modeling, Star and Snowflake Schemas, Datamarts, Security and deployment, FACT and Dimensional tables, Logical and Physical data modeling.
• Good experience in schema objects (Facts, Attributes, Hierarchies, and Transformations).
• Expertise in MicroStrategy Reporting techniques such as Interactive Dashboards and Visualization techniques.
• Worked extensively on VLDB Properties for performance tuning.
• Worked on all phases of the data warehouse development Lifecycle, from gathering requirements to design, development, testing, deployment, and support.
• Experience in using tools such as Oracle reports 8i, Oracle BI publisher according to the client applications
• Experienced on IntelligentCubeDevelopment, Custom widget, visualization development and implementation
• Strong analytical skills and detail oriented, Ability to multitask. Self-motivated, dedicated and team player with excellent communication skills and curiosity to learn new technologies and can work with minimal supervision.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C Language

BI Tools: MicroStrategy 10x, v9.4.1, v9.3.1, v9.2.1, v9.1.0, v9.0.2, v8.1.1 (MicroStrategy Administrator, Desktop, Intelligence Server, Web, Narrowcast Server, OLAP Services, Architect, Distribution Services, Office), Narrowcast Server, Cognos, Business Objects

Databases: Oracle, MS Access, SQL Server, DB2

Operations Systems: UNIX, Linux, Windows 7/8.1/XP/2000/2003 Server

Office tools: Web Sphere, MS Office

PROFESSIONAL EXPERIENCE

Confidential, NC

MicroStrategy Developer

Responsibilities:

• Worked as a MicroStrategy developer in a team of three for design and development in the Wholesale credit Risk Technology
• Created logical data models, recognize source tables and columns, to build MicroStrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in Teradata production environment.
• Experienced knowledge in different types of data modeling, like- star schema modeling, snowflake modeling.
• Data Warehouse and Business Intelligence(BI) tool evaluation
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Created joins and relationship according to the data model Schema.
• Implemented various Oracle 8i features and created various Oracle packages with new utilities.
• Conducted meetings to gather user/business requirements and also carried out quality reviews with the Users and created documentation for the same.
• Identify and modified source tables and columns in the warehouse required to create the MicroStrategy project. Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports.
• Designed Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Proactively created report formats and delivered personalized messages from the BI platform through distribution services.

Environment: MicroStrategy 10x, MicroStrategy 9.3, MicroStrategy Desktop 8.x, MicroStrategy Web 8.x, MicroStrategy Intelligence Server 8.x, MicroStrategy Narrowcast Server, Netezza, TOAD, Teradata, Oracle 8i, Windows XP.

Confidential, PA

MicroStrategy Developer

Responsibilities:

• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created Logical views in MicroStrategy for complex report creation scenarios.
• Used free form SQL editor for complex report creation.
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
• Design and development of BI applications for health business using Microstrategy tool.
• Generated and implemented MicroStrategy reports by creating projects, Custom Groups, attributes, hierarchies, metrics, filters, and templates.
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report
• Configured MicroStrategy Distributions Services to do bulk export of MicroStrategy Reports.
• Up-gradation of MicroStrategy product suite from lower version to higher version.
• Extensively used Report Services to generate Documents for exporting to Excel & PDF.
• Performed enhancements and provided on-call support for existing projects.
• Worked closely with Program Management to ensure that the development team fully understand the project requirements and manage production of appropriate project documentation, maintain under version control, and ensure appropriate sign off.
• Worked extensively with Advance metrics such as Level Metrics, Transformation metrics and Compound Metrics based on the requirements.
• Worked on Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.

Environment: MicroStrategy 9.0x, Narrowcast Server, Intelligence Server, Web, Administration, MS SQL Server, Teradata.

Confidential, MI

MicroStrategy Developer

Responsibilities:

• Involved in Requirements gathering by interacting with the Internet Business Users.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
• Generated MicroStrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Experience on Data Mart and Web BI suits and reporting tools.
• Created complex custom groups using hierarchy to overcome the restriction of MicroStrategy where total on columns and average on rows cannot be calculated at the same time.
• Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
• Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in MicroStrategy environment.
• Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Environment: MicroStrategy Desktop 9, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MS SQL Server 2005, Windows Server 2003.

Confidential

MicroStrategy Developer

Responsibilities:

• Created project plan for the development, implementation and operation of the MicroStrategy system using Microsoft Project.
• Architected schema objects such as attributes, facts and transformations.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, compound Metrics and Prompts.
• Created reports with various object prompts to generate various Ad hoc reports.
• Implemented the user defined MicroStrategy objects like custom groups and consolidations according to the requirement.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop 7.x that can be re-used to build any number of metrics.
• Involved in Testing of reports and Migrated Microstrategy7i projects from development to acceptance and to production.
• Created reports with various object prompts to generate
• Various Ad hoc reports.

Environment: MicroStrategy 7.x, Windows 95/NT/2000.

Confidential

SQL BI Developer

Responsibilities:

• Developed reports and cubes according to analyst defined specifications within the warehouse framework.
• Several reports generated regarding prepaid and postpaid customers, inventory and billings.
• Involved in designing and implementing several forms for each module and Designed user interface screens.
• System incorporates all the user-friendly functionality's like pop-ups, list boxes and other object oriented events.
• Developed the user interface and menus using triggers, functions and procedures. Also took active part in testing.
• Constructed several Normalized database tables with different constraints to maintain integrity. Triggers were implemented on the tables to maintain validity check on the data.
• Constructed several forms in Visual Basic to make it user friendly for the users to add, delete or update information.
• Carried out detailed study of business, data analysis and configuring the materials management module to user specification.

Environment: Windows Server 2003, SQL Server 2005, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.