SUMMARY

• Software consultant with 7 + years of extensive IT working experience in designing, developing, testing, deploying and documenting BI solutions with experience in installing, configuring and maintaining MicroStrategy BI applications, user interfaces, server modules and their administration.
• Expertise in complex report development, Flash, dynamic dashboard using MicroStrategy Web and Desktop.
• Expertise in Configuring Metadata, Repository Tables and creating new Project Sources using Configuration Wizard.
• Good knowledge in Star Schema Model, Snowflake Model Architecture of Data Warehouse
• Expertise in understanding Fact tables and Dimensional tables
• Very good at understanding Physical Data Model and Logical Data Model
• Expertise in Working on Direct Project Source (Two - Tier) and Server Project Source (Three-Tier).
• Fine Tuning of the MicroStrategy Reports using Data Mart Reports, Aggregatable Tables and Intelligent Cubes.
• Experience in working with MicroStrategy Multisource.
• Proficient in using RDBMS Such as Oracle and Teradata.
• Worked cross-functionally to identify measures and key performance indicators to support business objectives and improve decision making processes.
• Object Manager and Command Manager.
• Expertise in developing Reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop.
• Exposure to ETL methodology for supporting Data Extraction, Transformations and Loading processing in a corporate - wide-ETL solution using Informatica.
• Excellent Communication, Interpersonal, Analytical skills and Strong ability to perform as Part of the team.

TECHNICAL SKILLS:

Core Skills: Business Intelligence/ Data warehouse Implementations

BI Tools: MicroStrategy 9.4/9.3.1/9.0.1/9.0.0/8.1.1/ 8.1/ 8.0.2 / 7.5 / 7.2.3(MicroStrategy Desktop, MicroStrategy Web, Architect, Report Services, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server)

ETL Tools: Informatica 7.1

Databases: Oracle 9i, MS Access

Operating Systems: Windows 2003/NT / XP / 2000

Languages: SQL, PL / SQL, TOAD, SQL Assistant, C, C++

Testing Tools: Test Director 5.0, Win Runner 7.6, Load Runner 6.0, QTP 8.0

Other: Rally Software, Agile process

PROFESSIONAL EXPERIENCE

Confidential, Fairfax, VA

MicroStrategy Developer

Responsibilities:

• Involved in gathering business requirements and documenting specifications.
• Responsible for all MicroStrategy Architecture/Development.
• Modified Existing version of MicroStrategy objects in order to meet the requirements.
• Narrowcast services development, complete automation of services using page by execution for performance and Use of prompt answering of Narrowcast services
• Employed MicroStrategy Desktop in designing 3-tier and 4-tier MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• Created various reports which are part of dashboard having different interactive widgets that are accessed by top level executives.
• For complex reporting needs, worked extensively on creating Metrics, Filters, consolidations
• Resolved Cross joins in the SQL's by modifying the attribute definitions to generate the accurate results.
• Leveraged MicroStrategy OLAP services to develop reports, which use the functionality of the intelligent cubes and Derived Metrics.
• Created security filters and other report objects, drilling, defined hierarchies.
• Develop Standard as well as Ad-Hoc Reports based on the user need, the end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Tuned the reports by taking advantages of VLDB properties and complex report filters.
• Worked with DBA's in identifying the long running queries of daily reports data and enhanced the performance by indexing, data distribution, and monitoring other activity on box.
• Used the Object Manager to move the objects from Development to QA and to Production environment in MicroStrategy.
• Worked on upgraded version which is 9.4.

Environment: MicroStrategyDesktop 9.4/9.3.1,MicroStrategyArchitect, Object Manager, Visual Insights, Nexus Query Tool, Netezza.

Confidential, Baltimore

MicroStrategy Developer

Responsibilities:

• Involved in the meetings with business users and data modelers to discuss and finalize the requirements.
• Involved in meeting with business users to sizing of reports and projects.
• Involved in migration of Actuate Information Objects, SSRS and SSAS Reports into MicroStrategy reports.
• Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
• Involved in Designing of Schema Objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Expertise in using Apply simple Function in Attributes to make manipulations in attribute elements.
• Involved in Development of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and reports (Sandboxes)) on top of the Schema Objects.
• Involved in Creation of Simple metric, Compound metric, Derived Metric, Filter Metric and Transformation metric to meet end user requirements.
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Involved in setting of VLDB properties at report and Metric Levels to define outer joins between tables to get complete data from the required table and used different Query Optimization settings specific to database to improve performance of Query.
• Involved in development of Freeform SQL Report with SQL queries in MicroStrategy Desktop.
• Involved in development of Logical Views with complex queries against data warehouse.
• Involved in moving the objects between two projects and two different environments by using Object Manager and Resolve conflicts between environments by using conflicts resolution window.
• Create implementation plan document while sand boxes (Reports) are moving from DEV to QA and QA to Prod Environment.
• Involved in development of document, Grids & Graphs and dashboards for MicroStrategy Mobile Application for IPad and IPhone.
• Involved in using Enterprise Manager to view report statistics, top 10 reports and top 10 Users.
• Involved in creation of Users/User Groups and assigning privilege through User Manager using administration.
• Involved in unloading and reloading of projects through project monitor and check user connections through User Connection Monitor using administration.
• Involved in creating dashboard reports in Interactive and Flash Mode by using Selector, Sliders and Widgets to view selected data.
• Involved in creating summary reports and detail reports by pointing summary level tables and detail level tables in database level.
• Involved in creation of aggregate tables, intelligent cubes to improve performance of reports.
• Worked on Performance Tuning of various mappings and sessions to identify and remove bottle necks.
• Involved in data validation of reports by using hierarchies as well as SQL Queries.
• Involved in writing SQL queries by using union operator to develop logical views, freeform SQL reports and aggregate tables.

Environment: MicroStrategy 9/8.1.2, Architect, Desktop Reports, MicroStrategy Mobile Application for IPad and IPhone, Web Intelligence Reports, Report Services, Administration, Dashboards, Scan MD, Enterprise Manager, Object Manager, Informatica 8.1, SSIS, SSRS, SSAS, Toad, Netezza 5.0, DB2 UDB 7.0.

Confidential

MicroStrategy Developer

Responsibilities:

• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Actively participated in developing Report Delivery Schedules
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Taken various measures for performance enhancement like aggregation techniques, OLAP Feature, Data mart and report caching.
• Expertise in creating complex reports like Drill Down and Sub Reports and implementing Conditional Formatting, Grouping and Filtering.
• Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Developed reports for MicroStrategy Web users.
• 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.
• Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
• Employed MicroStrategy Desktop in designing 3-tier and 4-tier MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• Generated and implemented MicroStrategy reports by creating projects, Attributes, Hierarchies, Metrics, Filters, and Templates.

Environment: MicroStrategy tool suit 7x/8x, MicroStrategy Office 7.5.1, DB2 UDB V7.1/V8.1 for Unix/Windows, Sybase V10.5/V11., Windows 2000/2003, Sun Solaris V9/V10, BMC Remedy, Data Stage 7.1.7.5.2 and Microsoft Visio 2000, Teradata, SQL Server.

Confidential

MicroStrategy Analyst

Responsibilities:

• Worked as a MicroStrategy analyst in a team of three for design and development of the MicroStrategy reports.
• Gained good understanding of the logical data model.
• Collaborated with business partners to define requirements and reporting specifications and provide technical report assistance.
• Involved in dimensional data modeling (Star Schema), Business and Data Analysis.
• Validated reporting results against requirements. Troubleshoot and analyze data issues within reports.
• Worked with the ETL team and business operational teams to understand data sources and implement new requirements.
• Created schema objects (Attributes, Facts, Hierarchies, and Transformations) from Warehouse catalogue and public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Drill Maps) on top of schema objects.
• Expertise in using Apply Simple and Apply Comparison Operators in advanced qualification filters.
• Created ad-hoc reports by drilling up, down and across hierarchies.
• Developed reports by using Freeform SQL in MicroStrategy Desktop.
• Involved in creation of aggregate tables to improve performance of reports.
• Involved in moving the objects between two projects and two different environments by using Object Manager and Update Packages.

Environment: MicroStrategy Desktop 7x, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Teradata V2R4.1, Oracle 9i, Erwin Data Modeler 3.6, Ab Initio 1.0, Windows 2000/NT and UNIX.