PROFESSIONAL SUMMARY:

• 5+ years in MicroStrategy BI Analysis, design and Implementation of BI application using MicroStrategy 10i/9i/8i.
• Extensive working experience in installing and Configuring MicroStrategy 9.x/8.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Intelligence Server
• Involved in Administration, Analysis, Design, Development and implementation of business Intelligence and Maintaining Applications using MicroStrategy Tool suite.
• Experience in Upgrading the MSTR BI environment (9.2.1 to 9.3.1 and 9.3.1 to 9.4.1 and 9.4.1 to 10.0) both in UNIX and Windows Platforms.
• Experience in System Optimization, performance monitoring and tuning the MicroStrategy business Intelligence environment using MicroStrategy Enterprise Manager.
• Good understanding of using MicroStrategy Command Manager Script outlines to automate the administrative tasks.
• Extensive experience in Working with MSTR License manager and applying patches to MicroStrategy BI Application.
• Extensive experience in Working with MSTR User Manager, roles and security filters.
• Experience in handling the MSTR BI Application in Cluster Environment.
• Created different types of objects such as attributes, metrics, filters, prompts, Custom Groups and Consolidation.
• Experience in creating dashboards using Microstrategy
• Involved in validating data returned in all reports, provided a detailed analysis of data, and identified data quality issues.
• Involved in MicroStrategy reports tuning for best SQL performance and efficiency.
• Created various Schema objects with MicroStrategy Desktop like simple and Compound Metrics, Fact Extensions and Hierarchies, etc.
• Involved in continuous performance tuning & improvements for existing OLAP systems.
• Expertise in the concepts of Data Warehousing, Data Marts, Dimensional Modeling, Fact and Dimensional Tables.
• Knowledge in data extraction and transformation (ETL) using Informatica PowerCenter6.x and PowerMart6.X.
• Worked on waterfall and Agile software development life cycle process to data development projects.
• Extensive experience in VLDB/Optimization with databases like Oracle and Teradata.
• Document new development, procedures, or test plans as needed
• Self - initiative, excellent analytical and Communication skills.

TECHNICAL SKILLS:

BI Tools: Tableau 8.0/7.0, MicroStrategy 10.0/9.4.1/9.3.1/9. x/8.x Desktop, Web, Object ManagerSAP: BW, Command Manager, Dashboards and scorecards, UNIX platform.

ETL Tools: Data stage.

RDBMS: Oracle 11g/10g/9i/8i, Microsoft Access, Teradata, SQL Server 2008/2005

Languages: SQL, PL/SQL, HTML, Unix Shell Scripting, JavaOS: MS Windows NT/2003/XP/ME/95/98, Windows 7, Windows 8, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Greenville, SC

Microstrategy Developer

Responsibilities:

• Developed schema objects- Attributes, Facts, Transformations with proper hierarchy and data mapping.
• Test the dashboards from a UI, functionality, data and performance point of view Installing and Configuring the new MSTR clustered infrastructure from vCloud servers to Citrix servers.
• Documented the objects and their configuration details in the project for the migration tasks.
• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Involved in creation of Dashboards with various types of graphs, selectors, panel stacks and widgets based on business requirements.
• Scheduling of various reports, dashboards on a daily, weekly and monthly basis to history list and also e-mail subscription.
• Create stored procedures to handle Alert subscriptions to end users and handle this using Dynamic Email Subscription feature in Distribution services.
• Created personalized reports/dashboards to alert Analytics team based on the KPI thresholds.

Environment: MicroStrategy 9.4.1 (Desktop, Web, Mobile and Ad-Hoc), Informatica, Oracle 10g, SQL Server, IBM DB2, HTML, Windows, Linux

Confidential, Charlotee, NC

Microstrategy Developer

Responsibilities:

• Involved in creating user stories, tasks, project estimates in Rally tool as part of Agile project life cycle methodologies.
• Involved in MSTR up gradation from MSTR 9.3.1 to 9.4.1.
• Installing and Configuring the new MSTR clustered infrastructure from vCloud servers to Citrix servers.
• Actively involved in configuring the new DB data sources from SQL server to Natezza.
• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Creating the data load and Cube refresh automation scripts.
• Migration of Actuate and OBIEE BI documents in to MSTR environment.
• Created the ROI MSTR reports and dashboards.
• Actively involved in creating the MSTR logical data model.
• Understanding and Participate in creating system hierarchies with to physical data model.
• Applying security for all MSTR user groups.
• Leading the MSTR off-shore team with respective to business needs of the on shore business partners.
• Created a view of the SQL data and the data extracts were loaded to the tableau server for query performance
• Designing Tableau dashboard mock up for marketing Campaign analysis, Demographical analysis.
• Tableau dashboards are developed including quick filters, Context filters, Parameters and Sets.
• Involved with Tableau IT, Online and Marketing teams, providing data and statistics for use in marketing campaigns, data driven system analysis, functional requirements for product development and innovation.

Environment: MicroStrategy 9.4.1 (Desktop, Web, Mobile and Ad-Hoc), Informatica, Oracle 10g, SQL Server, IBM DB2, HTML, Windows, Linux

Confidential, Buffalo Groove, IL

Microstrategy Developer

Responsibilities:

• Actively involved in Production support of the MicroStrategy BI application (MSTR Desktop, Web and Mobile)
• Worked in creating Project duplications between the MSTR BI environments (DEV, UAT, SUP and PROD)
• Created MSTR Mobile links (iPad) by projects and Making sure all iPad xmls and images are in sync with all MSTR Mobile and Web servers.
• Involved in Packages creations and Packages migration using object manager.
• Activity involved in running the I-Cube refresh scripts in Linux server level once after the ETL data load completes.
• Actively involved in creating the Events, Schedules, Subscriptions and Scheduling administrative tasks.
• Created .udf files to load Bulk list of users in MSTR Projects.
• Installed Microsoft office plugin in MSTR 9.3.1 and created web services url.
• Actively involved in the schema level backups and worked closely with DBA team in DB level issues.
• Involved in creating the new DSNs and DB connections for MSTR new projects.
• Working knowledge of the odbc.ini file in MSTR Cluster environment.
• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Involved in Offshore coordination, attend daily status meetings with offshore team.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports.
• Created advanced objects like Derived Metrics, Compound Metrics.
• Worked on performance tuning of reports, Mobile Dashboards.
• Created Metrics, Prompts, Filters and Custom Groups for the report development. Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.
• Extracted and analyzed data from the database using SAP BW to troubleshoot reports as needed using MicroStrategy ODBC Test tools.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Developed a web course and took several classes to train the end users to efficiently use MSTR.
• Involved in the trouble shooting and performance enhancing of the reports.
• Validated end user requirements using MicroStrategy tools.
• Created a view of the SQL data and the data extracts were loaded to the tableau server for query performance.
• Designing Tableau dashboard mock up for marketing Campaign analysis, Demographical analysis.
• Tableau dashboards are developed including quick filters, Context filters, Parameters and Sets.

Environment: MicroStrategy 9.2.1M, 9.3.1 (Desktop, Web, Mobile and Ad-Hoc), Tableau 8.0, Informatica, Oracle 10g, SQL, HTML, Windows, Linux

Confidential

Microstrategy Consultant

Responsibilities:

• Involved in logical modeling and physical modeling of the database.
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Implemented the business logic and processing of the payment by developing stored procedures.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: SQL Server 7.0/2000, T-SQL, VB 6.0, Windows NT/2000 server.