SUMMARY:

• 9 Years of extensive IT industry experience in all phases of the System Development Life Cycle (SDLC) including Requirement Gatherings and Analysis, Design, Development, Testing, Implementation and Maintenance Support of OLAP/Data Warehousing Web Applications.
• Extensively worked on reporting tools such as MicroStrategy, Tableau.
• Strong in Data warehousing concepts and well versed with dimensional modeling (Start Schema and Snowflake Schema) & Good work experience in SQL.
• Strong experience in MicroStrategy Architect to work on Schema Objects such as Facts, Attributes, Transformations, Logical Tables, and Hierarchies.
• Worked on Desktop, Object Manager, Command Manager and Project Merge Wizard.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
• Created VI dashboards in web and used data blending features.
• Extensive knowledge in cubes creation and scheduled Maintenance of cubes for Data Load in cluster environment.
• Experience in performance tuning at database level - collecting statistics and at MicroStrategy level using VLDB properties, aggregate tables, intelligent cubes, caching and other configuration settings.
• Experience in analyzing the MicroStrategy system usage and performance by looking at the enterprise manager reports and taking appropriate actions to tune the system for improving the performance.
• Experience in using the command manager scripts to configure and manage the project settings.
• Experience in Project Duplications, Project Migrations using object manager from one environment to another.
• Extensively worked in MicroStrategy Report Services to design Static Document/Dashboard/Dynamic/ Interactive Dashboard/Flash Dashboards for amazing data visualizations in web and mobile (iPhone/iPad).
• Implemented OLAP Functions like Apply Simple, Apply Agg, and Apply Comparison for the complicated filters, attributes and metrics.
• Experience working with very large databases and large MicroStrategy projects.
• Worked with End Users and supported on UAT.
• Involved in MicroStrategy 9.0x and 10.0x version upgradation & testing.
• Worked in Team Oriented Environment with strong, analytical, interpersonal and communication skills.
• Extensive Knowledge in Server Upgradation, Configuration, Implementing, Maintaining Controls and security policies on MicroStrategy.
• Extensive experience in MicroStrategy 8.x/9.x (Desktop, Administrator, Narrowcast server).
• Administered MicroStrategy environments and formulated user groups.
• Worked on iPad 4, configuring the server setting, configuring the MicroStrategy projects etc.
• Created separate version dashboards for iPad view.
• Extensively worked on Microstrategy 9.3 Visual insights and explored the options in it.
• Trouble shooting & performance tuning Queries generated in MicroStrategy.

TECHNICAL SKILLS:

Reporting Tools:: MicroStrategy 8.x/9.x/10.x, Tableau 7.0/ 8.x

ETL Tools:: Informatica Power Center 8.1.1

Languages:: SQL, PL/SQL

Databases:: Oracle 9i/10g, Teradata

Operating System:: Windows 98/XP/2000

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MicroStrategy Developer & Architect

Responsibilities:

• Created Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Developed Public Objects (filters, prompts, metrics, Custom Groups, Consolidations, and Searches) to develop Documents and reports.
• Worked on Transactional services and write back data to DB and used same tables into Microstrategy.
• Automated batch process script in Microstrategy using FF SQL report and executes every month for data load.
• Created FreeForm SQL reports based on user requirement based on criticality of the requirement.
• Prepared excel template based formulas to generate report as per spec requirements.
• Assigned tasks handled and completed on time.
• Created logical views from MicroStrategy to accomplish report requirement to avoid backend views creation.
• Creating views from backend to avoid more join conditions from MicroStrategy.
• Implemented some logical condition at report level using derived metric and to avoid creating extra metric objects.
• Suggested and prepared some SQL queries as per user requirements.
• Performed unit testing and bug fixes in user acceptance testing.

Confidential, Wallingford, CT

MicroStrategy Administrator, Developer & Architect

Responsibilities:

• Interacting with business users for requirement gathering, analyzing the business requirements and translating them in to functional and technical specifications.
• Created technical design, Mockup data, Object mapping document, based on the requirement document.
• Interacted with ETL team to incorporated necessary changes in data model for Microstrategy Reporting.
• Created Schema objects & Public objects based on the requirements.
• Created dashboards based on cube reports.
• Each dashboard incorporated with visual insight link for end user to play around the reports.
• Prepared PPT’s for end user for better understanding on microstrategy dashboards.
• Created event based scheduling and published cubes.
• Installed and established connection mapping in DEV, SIT, UAT, PERF and PROD through Microstrategy configuration wizard.
• Configured Meta data for all the 5 environments and migrated the projects across the environments.
• Coordinated with DBA team to resolve buffer pool issues in microstrategy.
• Taking project & metadata backup in microstrategy by weekly.
• Acted as Liaisons, resolved License key issues and bugs related to 10.4 microstrategy installations.
• Handled object migrations from one environment to other environment.
• Improved report performance using VLDB properties, Caching.
• Given walkthrough on all the reports to business users.

Environment: MicroStrategy desktop 10.4, MicroStrategy Administration, Architect, Developer, DB2.

Confidential

MicroStrategy Developer & Architect

Responsibilities:

• Created new Facts, Attributes and Attribute Form Expressions and Hierarchies as needed in the project.
• Involved in MicroStrategy version upgradation from 9.3 to 10.3 and testing done across all the reports and dashboards.
• Delivery of reports to the users through Narrowcast Server.
• Extensively worked on Report Services Documents using dashboards.
• Worked on different widgets like Bubble graph widget, Graph matrix widget etc.
• Developed transformations to generate reports of type Sales this period to Sales this period Month, M3M, QTD Month, YTD, MAT, Week, and QTD Week and so on.
• Designed Templates, 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.
• Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.
• Tested the Microstrategy objects across Database.
• Effectively used the VLDB settings.
• Used apply functions to execute the database specific function in the metrics and filters.

Environment: MicroStrategy desktop 9.3/ 10.x, MicroStrategy Administration, Oracle SQL (10g), Teradata.

Confidential

MicroStrategy Architect

Responsibilities:

• Extensively worked with Metrics, Facts, Transformations, and Custom Groups & Report Services.
• Responsible for creation of Canned/Ad-hoc Reports, Metrics with Public and Schema Objects for HR domain requirements.
• Gathered requirements from management users for generation of reports in Web and Desktop.
• Design and Development of Business Analysis Interactive Dashboards & Scorecards organizations HR's goals & KPI in Microstrategy Desktop and web.
• Once ETL is done and data gets loaded to Data warehouse, Defined and created Microstrategy objects including Attributes, Filters, Cubes, Nested Filters, Hierarchies, Templates, Prompts & Nested Prompts.
• Conditional formatting on metric thresholds, limiting report data access using security filters.
• Strong in Narrowcast Server especially using Scheduling, Subscription and Event Base Alert Services.
• Perform scope verification by obtaining stakeholder's formal acceptance\sign-off on completed deliverables.
• Using visual insight quickly add, rearrange, or remove report objects from a visualization in a quick dashboard.
• Create additional visualizations to display the data in multiple ways, then easily modify, rearrange, or resize visualizations in a quick dashboard in visual insight.
• Add filtering based on report objects to a quick dashboard, to allow users to only display the information they are interested in.
• Add thresholds to a quick dashboard, to change the display of data based on the value of a metric.
• Used Free Form SQL Editor for complex report creation

Environment: Microstrategy 9.2.1(Desktop, Architect, Web) and TOAD for testing Reports, Ms Office, Oracle 10g, Windows 7.

Confidential

MicroStrategy Developer

Responsibilities:

• Created Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Developed Public Objects (filters, prompts, metrics, Custom Groups, Consolidations, and Searches) to develop Documents and reports.
• Created Free Form SQL reports based on user requirement.
• Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison and Transformations.
• Worked with Object Manger to Migrate Objects from DEV to TEST & PRODUCTION environments.
• Designed Templates, 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.
• Developed Report Service Documents, interactive dashboards and scorecards with different widgets for High level Management.
• Optimized query performance by using VLDB (very large database) properties.
• Tested MicroStrategy Reports and Objects across Database.

Environment: Microstrategy 9.0.1(Desktop, Architect, Web, Administrator and Oracle Developer for testing Reports, Ms Office, Oracle 10g, Windows 2003 Server).

Confidential

MicroStrategy Developer

Roles and Responsibilities:

• Create Proof of Concept for implementing different Specifications for Microstrategy Reports.
• Created new Facts, Attributes and Attribute Form Expressions and Hierarchies as needed in the project.
• Performance tuning of the reports
• Analyze and Understand the Business reports and identify the rationalization opportunities.
• Content Analysis of reports to map the report data elements to Business Glossary.
• Creating a Report Specification Document for every report using the Content Analysis Document and sign-off specification documents with Business.
• Create Report Decomposition Document by referring the Specification document and validate all data elements in the decomposition document against the Business glossary.
• Review and understand the Technical Design Document and find out the gaps in Report specification documents.
• Created Ad-hoc reports with Dynamic prompt answers for the end users to generate.
• Improved report performance using VLDB properties, Caching.

Environment: Microstrategy 8.X,9.0.1(Desktop, Web and TOAD for testing Reports, Ms Office, Oracle 10g, Windows 2003 Server).