PROFESSIONAL SUMMARY:

• Overall IT experience of 10 years includes business requirement gathering, Data Analysis, Application Design, Development, Testing, Migration, Production Release and Post Production support of Business Intelligence Systems
• MicroStrategy certified and over 8+ years of experience in components of MicroStrategy Product Suite - MicroStrategy Intelligence Server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Developer and MicroStrategy Web.
• Designed and developed the Core Enterprise Reporting objects using MicroStrategy Architect.
• Defined the Project related tables by selecting from the available list.
• Created basic Schema Objects i.e. Tables, Attributes, Facts and Hierarchies.
• Defined relations between attributes and there by developed Hierarchies and their drilling configuration.
• Define and develop Transformation objects used for Time Analysis.
• Performed other architect tasks like Update Project Schema, Modify Logical Table size, Modify Attributes relationship, etc.
• Developed Static and Ad-hoc reports using simple reporting objects like Templates, Metrics, Filters, Prompts, Custom Groups, Consolidations, and Drill Maps.
• Developed reports using advanced reporting objects like Level Metrics, Conditional Metrics, Transformation Metrics, Compound Metrics, Custom Groups, Consolidations, Derived Elements and Drill Maps.
• Developed Custom SQL Reports using Freeform SQL.
• Designed and developed Dynamic Dashboards & Documents using MicroStrategy Report Services.
• Fine-tune report SQL queries to improve performance.
• Created/modified/deleted Users, User Groups. Controlled User access to functionality/data by creating Security Roles, Privileges, Access Control Lists and Security Filters.
• Managed database connections by creating/modifying Database Instances and defining job priorities for user requests.
• Created Time-Based & Event-Based schedules for users to run the reports/documents on schedules. Also, created schedules for Administrator Schedule tasks like Element/History List Cache delete.
• Designed and developed a secure, efficient personalized report & dashboards delivery system - Email Delivery, File Server, Network Printer and data-driven alerts using MicroStrategy Distribution Services.
• MicroStrategy objects migration between environments using MicroStrategy Object Manager. Performed batch migration using Create/Import package.
• Using MicroStrategy Integrity Manager, performed regression testing on reports and documents.
• Production support by resolving user related issue and ability to improve the report performance by fine-tuning the SQL.
• Designed and developed Custom Web Report Builders.
• Designed and developed Dynamic Dashboard & Documents using MicroStrategy Report Services.
• Designed and developed VI Dashboards using MicroStrategy Visual Insight.
• Worked with business users in understanding the business processes and document the reporting needs. Also worked closely with the data modeler in designing the data warehouse system.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10.x, 9.x, MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web Server, Tableau

Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Sr. Microstrategy Consultant/Architect

Responsibilities:

• Interacting with stakeholders in understanding the requirements.
• Worked with Data Architect teams to understand the architectural changes.
• Using MicroStrategy Developer/Architect tools created project schema objects.
• As a MicroStrategy Developer, designed the reports with advanced reporting techniques like Compound Metrics, Advanced Metrics/Filters, Thresholds, Custom Groups, and Consolidations etc.
• Designed and developed highly formatted Enterprise Dynamic Dashboards using Dashboard advanced features like Panel Stacks, Selectors, and Widgets in providing interactive capability to Enterprise Dashboards.
• Creating Documents and MSTR Office Reports.
• Responsible in addressing & fixing the issues raised during UAT.
• Used Microstrategy OLAP Services i.e. View Filters, derived metrics & Derived Elements.
• As an Administrator responsible for Creating Users, User groups, Creating Schedules and Events.
• Created cubes and built documents using the cubes.
• Using Object Manager created the Project migration packages that are used to migrate the objects between environments.
• Occasional use of Integrity Manager in performing base line comparisons.
• Performance tuning the reports to improve the report execution time for the reports/documents.
• Co-ordinating and managing the offshore team.
• Perform Post-PROD support.

Environment: MicroStrategy 10.1, SQL Server.

Confidential, Tampa, FL

Sr. Microstrategy Consultant

Responsibilities:

• Working with business in gathering requirements for enhancements.
• Understanding the business Objects Environment and Reports.
• Creating Facts, Attributes, Metrics and Filters for reporting.
• As a MicroStrategy Developer, designed the reports with advanced reporting techniques like Compound Metrics, Advanced Metrics/Filters, Thresholds, Custom Groups, and Consolidations etc.
• Creation of Simple metric, Compound metric, Derived Metric, Filter Metric and Transformation metric to meet end user requirements.
• Developed Prompt based reports to give end users a choice of different filtering criteria each time.
• Used Microstrategy OLAP Services i.e. View Filters, derived metrics & Derived Elements.
• Designed and developed highly formatted Enterprise Dynamic Dashboards using Dashboard advanced features like Panel Stacks, Selectors, and Widgets in providing interactive capability to Enterprise Dashboards.
• As an Administrator responsible for Creating Users, User groups, Creating Schedules and Events.
• Creating MSTR Documents by using MSTR Web.
• Guiding business users in creating Documents.
• Troubleshooting the issues raised by users in UAT.
• Data validation of reports.
• Work with Admins in Prod Migrations.

Environment: MicroStrategy 10.4, Business Objects, Oracle.

Confidential, Charlotte, NC

Sr. Microstrategy Developer/Architect

Responsibilities:

• As an Architect involved in meetings with business users & BA to discuss and finalize the requirements.
• Supported BA in creating the documentation from requirement gathering.
• Creating Facts, Attributes, Metrics and Filters for reporting.
• Developed Consolidations and Custom Groups to meet the requirements in generating the reports.
• Development of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups and Templates) on top of the Schema Objects.
• Creation of Simple metric, Compound metric, Derived Metric, Filter Metric and Transformation metric to meet end user requirements.
• Created Object Prompts by subject area to ensure business can create their own reports.
• In-depth analysis from Microstrategy Point of view from the DB Netezza Migration to Teradata.
• Worked on Performance Tuning of various mappings and sessions to identify and remove bottle necks.
• Data validation of reports by using hierarchies as well as SQL Queries.
• Responsible for migrating the objects from Dev to QA.
• Writing the test cases and production support activities.

Environment: MicroStrategy Suit 10.2/10.4, Netezza, Teradata, Agile.

Confidential, Atlanta, GA

Microstrategy Developer

Responsibilities:

• As a Business Analyst, had an opportunity to interact with the DW User community to identify the reporting/analysis needs and there by document & develop the business requirement document.
• As a MicroStrategy Architect, designed and developed Schema Objects, Configuration Objects using MicroStrategy Developer/Architect tools.
• As a MicroStrategy Developer, developed many Application Objects and designed the reports with advanced reporting techniques like Compound Metrics, Advanced Filtering, Drill Maps, Transformations, Data Marts, Thresholds, Custom Groups, and Consolidations etc.
• Worked extensively on MicroStrategy Enterprise Report Services in creating Business Reports, Trend Analysis Reports, Production and Operational Reports.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Performance Tuning of Reports and Dashboards.
• Admin activities like Creating User’s, User groups, assigning the access levels and migrating the projects from one box to another.
• Used Microstrategy OLAP Services i.e. creating View Filter, Report Objects, and derived metrics.
• Monitoring the Environment
• Creating the test cases.
• Production support activities.
• Creating Enterprise Manager Reports

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

Confidential, Milwaukee, WI

BI Consultant

Responsibilities:

• The Primary responsibility is to ensure the reports meet the defined SLA’s on Weekdays and Weekends.
• Co-ordination with the ETL and source teams.
• As a MicroStrategy Developer, developed many Application Objects and designed the reports with advanced reporting techniques like Compound Metrics, Advanced Filtering, Drill Maps, Transformations, Data Marts, Thresholds, Custom Groups, and Consolidations etc.
• Worked extensively on MicroStrategy Enterprise Report Services in creating Business Reports, Trend Analysis Reports, Production and Operational Reports.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Performance Tuning of Reports and Dashboards.
• Admin activities like Creating User’s, User groups, assigning the access levels and migrating the projects from one box to another.

Environment: MicroStrategy Desktop 8.1.1, MicroStrategy Intelligence Server, MicroStrategy Web, Narrowcast Administrator, Oracle 10g, Oracle Data Integrator,MSSQLServer 2007

Confidential, Phoenix, AZ

Microstrategy Consultant

Responsibilities:

• Responsible in creating the dashboards.
• Creating the Schema objects i.e. Attributes, Facts, Hierarchies and Transformations.
• Using MicroStrategy Desktop created Application Objects like Template, Filters, Prompts, and Reports according to the Business requirement.
• Used Microstrategy OLAP Services i.e. creating View Filter, Report Objects, and derived metrics.
• Used Drilling, pivoting, formatting, page-by, thresholds on the reports.
• Generated reports by using custom groups and included consolidations in order to group attributes and customize the reports
• Involved in Creation of Simple metric, Compound metric, Derived Metric, Filter Metric and Transformation metric to meet end user requirements.
• Developed Consolidations and Custom Groups to meet the requirements in generating the reports.
• Developed Prompts to give end users a choice of different filtering criteria each time.
• Involved in development of Freeform SQL Report with SQL queries in MicroStrategy Desktop.
• Involved in creation of Users/User Groups and assigning privilege through User Manager using administration.
• Used Microstrategy OLAP Services
• Involved in preparing the test cases.

Environment: MicroStrategy Desktop 8.1.1, MicroStrategy Intelligence Server, MicroStrategy Web, Narrowcast Administrator, Oracle 10g, Oracle Data Integrator,MSSQLServer 2007

Confidential, Phoenix, AZ

MicroStrategy Consultant

Responsibilities:

• Developing the Reports like standard and Adhoc.
• Developing Reports and creating metrics, hierarchies and filters using Micro Strategy Desktop.
• Used Prompts, Conditional, metrics and Level Metrics for creating complex reports.
• Developed Consolidations and Custom Groups to meet the requirements in generating the reports.
• Developed Prompts to give end users a choice of different filtering criteria each time.

Environment: Micro Strategy 8.1.1, Sybase.

Confidential

Data Stage Developer

Responsibilities:

• Created mappings using Data Stage Designer from source to Staging and Staging to Data Warehouse.
• Used Stages like Transformer, Look Up, Pivot, Aggregator, Sort, Copy and etc.
• Created Reusable Transformations using Shared Container.
• Prepared Unit Test Cases for the Reports.

Environment: Data Stage, Windows 2000, Oracle 8i.