SUMMARY

• 8+ years of strong experience in Business Intelligence in designing and implementing Web based and Standalone software application with major focus on Data Warehousing and Database Applications.
• Extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy … Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, and reports.
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments. Strong data modeling (Logical and Physical) experience with high proficiency in using Erwin for Dimensional Modeling (Star, Snowflake schemas) and Entity - Relationship Modeling.
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates.
• Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
• Creating users, user Groups and assigning security roles for the project.
• Monitoring user connections, caches and jobs.
• Developed basic and user-specified Metrics (level and conditional).
• Created drill maps for end users to drill down and recover data.
• Worked with Logical and physical modeling along with design and implementation.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Extensive knowledge of SQL, PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle and SQL Server.
• Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Extensive experience on all types of MicroStrategy Filters, Prompts, Templates, Metrics, Consolidations.
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets.
• Experience in Business Intelligence, ETL Applications, Data modeling techniques like star and snowflake schemas using Erwin tool.
• Experience in Converting Legacy reports into MicroStrategy reports and working in offshore-onsite environment.
• Worked with Logical and physical modeling along with design and implementation.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Experience in coordinating with Database Management team, End users, Business Analysts in understanding their requirements, assisting and providing technical solution and knowledge.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS

BI Tools: MicroStrategy 10/9.x/8.1.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight, Narrowcast Server, Mobile, Integrity Manager, OLAP), Tableau, Cognos 10.

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Databases: Oracle11g/10g/9i, Teradata 13.x/V2R6, Sybase, Netezza, MS SQL Server

Programming: PL/SQL, SQL Loader, SQL Plus, TSQL, s, HTML, CSS, JavaScript

Operating Systems: Windows Servers, UNIX, Linux

Other Tools: Toad, PL/SQL Developer, SQL Assistant, MS Office, Microsoft Visio, Erwin

PROFESSIONAL EXPERIENCE

Sr. Micro Strategy Developer

Confidential, Owings Mills, MD

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters, dynamic aggregation and metrics using MicroStrategy Desktop
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations. created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards
• Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.
• Widely used VLDB properties to set default criteria at project level and at individual report levels to overcome performance issues.
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using Intelligent cubes improved performance of the RS documents significantly.
• Analyzed existing SAP Business Objects reports, documented the Technical specifications and converted SAP Business Objects reports to MicroStrategy for CRES Workplace Utilization project.
• Used the Object Manager to migrate the objects from Development to UAT environment in MicroStrategy.
• Involved in MicroStrategy Upgrade to 9.4.1 and then to version 10.4. Used MicroStrategy Integrity Manager for regression testing during upgrade.
• Used Narrowcast Server to automate FX TCA Order Completion reports, Aggregate reports to internal and external clients.
• Involved in MicroStrategy migration from Solaris to Linux, also database migration from Physical Oracle database to DHS Virtual hosts

Environment: Micro Strategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, DB2.

Micro strategy Consultant

Confidential - Austin, TX

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Closely worked with MARS PO to have a clear understanding of their requirements involving Micro Strategy Implementation.
• Created the requirements documentation for the Micro Strategy project
• Documented the Micro Strategy Environment issues related to bugs in MicroStrategy Tool.
• Created New Users, Roles, Privileges, Shared folders, Access Control Lists as per the requirement.
• Architecting the Micro Strategy Project which involved in creating the Attributes, Facts and Hierarchies and created public objects Metrics, Filters, Prompts, Custom Groups and Consolidations.
• Created Schema and Public objects from tables of two different data warehouse using Multisource concept.
• Involved in the data analysis between two different data sources for one of the migration projects between DB2 to Oracle.
• Involved in the making of crucial decisions with Data Architects and DBA's related issue involving MicroStrategy and DB.
• •Moved objects from Development to QA using Object Manager.
• Involved in the documentation and validation of the Schema and Public objects migration in QA, UAT and PROD.
• Involved in the optimizing the SQL using the VLDB Properties for better report performance.
• Used free form SQL for creating complex reports and for the analysis & debugging purpose in PROD.
• Extensively worked with the Enterprise Manager Report and Dashboard for statistical reporting purposes. Created Cube and VI dashboard in Enterprise Manager project for higher management to show the performance of the reprots.
• Heavily worked with end users to support ongoing requests and Production support.
• Usage of Apply Simple functions in Attributes and metrics for meeting the business requirements. Created complex filters with advanced qualification involving pass through functions like 'Apply Simple' and 'Apply Comparison' functions
• Designed Dynamic Dashboards as per the business requirements
• Involved in troubleshooting Micro Strategy Reports
• Used Narrowcast server services to deliver different objects that define Narrowcast Server services, including content Information Objects, Documents, Subscription Sets, and Schedules to users.

Environment: Micro Strategy 9.0.2 & 9.4.1(Administrator, Architect, Object Manager, WEB, Enterprise Manager, Narrowcast), Oracle 11g, DB2, UNIX server.

MicroStrategy Developer

Confidential - Raleigh, NC

Responsibilities:

• Worked with the Source Systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements.
• Created the requirements documentation for the Micro Strategy Projects and documented the requirements in MicroStrategy Environment.
• Installed software, secured model design, troubleshooting of application and database connectivity and tested load.
• Created Reports using Complex Filters, Compound Metrics and Prompts.
• Developed Micro Strategy Payroll Analysis and Productivity reports for HR.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Good understanding of the type of schemas that best support MicroStrategy in different scenarios.
• Used Advanced Prompts, Non - Aggregately Metrics, Transformation metrics and Level Metrics for complex reports.
• Created several base formulas using existing facts in MicroStrategy Desktop that can be reused to build number of Metrics.
• Customized reports, documents and deployed them to MicroStrategy Narrowcast Server.
• Managed configuration and version control of production systems, maintained procedures and monitored fault correction.
• Maintained scripts and documentation related to software licensing.
• Supported project teams and domain architects to improve reliability development and testing of MicroStrategy.
• Worked on Micro Strategy Narrowcast to deliver the Weekly and Monthly Reports.
• Generated the Reports, which includes the public and schema objects using the MicroStrategy Components.
• Developed Customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy.
• Desktop with features of Drilling options (drill down, drill up and drill anywhere).
• Performed the administration tasks like Tuning, Caching, specifying Query Governing, Thresholds, and Report Optimization.
• Performed testing of all reports for the final deployment.

Environment: MicroStrategy 9.2.1(Desktop, Architect, Web, Object Manager), Tableau 7.0 (Desktop Server), Teradata 13.10, Ab Initio, HP Quality Center 10/9, SQL, Linux.

Micro strategy Developer

Confidential

Responsibilities:

• Involving in the designing of the Data Model.
• Preparation of the logical data model by using Power Designer.
• Responsible for gathering and refining business requirements from the Business users.
• Build the Schema Objects like Attributes, Facts, and Transformations & Hierarchies as per the use requirements by identifying the required tables.
• Worked on Public Objects like Metrics, Prompts, Filters, Custom Groups and Consolidations.
• Worked on the Migration of the Business Objects & SSRS reports to MicroStrategy reports & Dashboards.
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Optimized Query Performance by using VLDB settings.
• Analyzing the business Objects, SSRS reports and data structures to understand and create the model which supports to Micro Strategy.
• Created the Reports and Dashboards by using public objects and schema objects.
• Developed Reports and Dashboards using various functionalities like Prompts, Filters, Crosstab grids, Bar Charts, Pie Charts and Consolidations and Custom Groups.
• Worked on performance tuning to make the dashboards efficient in web mode.
• Preparation of the Unit test cases for the entire Reports and dashboards.
• Involved in End - User training, Support and Maintenance.
• Testing and scheduling reports as per the user requirements.
• Involved in Migrating reports from Development to Production by using Object Manager.
• Created Technical Document & Trained users at different levels of Report and Dashboard usage.

Environment: Micro Strategy 9.0.1 (Architect, Desktop, Object Manager), Informatica Power Center, Teradata, Oracle.

Confidential

MicroStrategy Developer

Responsibilities:

• Started with gathering requirements from the users and documenting the specifications.
• Created the Report Specification document and had it signed of, after suggesting some useful alterations
• Analyzed the source system data.
• Creation of new users, roles, privileges, shared folders, access controls Lists using security roles in MicroStrategy.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Created Complex Metrics forcing Dimensionality and Conditionality which are mainly used in Client scorecards, summary, detail level reports and trending related reports.
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters.
• Created Complex filters with advanced qualifications involving the Apply functions.
• Used MicroStrategy Narrowcast Server to monitor the business data and alert the users to unexpected exceptions and trends.
• Created Report Service documents with both Grids and graphs as per user requirements.
• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing.
• Tested all the reports by running queries against the warehouse - using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Played a key role in User Acceptance Testing of the reports.

Environment: Micro Strategy 7.x.x/8.x.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Windows Server, SQL server, Oracle.