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.
• 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.