SUMMARY

• Over 7 years of progressive IT experience in executing Business Intelligence Solutions, ETL, BI Tools, Data Warehousing, Data Modeling and OLAP.
• Around 5 years of experience in using MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, SDK, Web and Distribution Services).
• Worked extensively on MicroStrategy Desktop, Administrator, Intelligence Server, and Web.
• Worked closely with Business Analysts and Financial Analysts to no teh requirements.
• Extensive experience working in an agile development environment.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with teh Data warehouse.
• Extensive noledge in Creating Data Mart Reports using Complex Filters and Compound Metrics.
• Experience in working on Reports and Visual Insights based on Intelligence Cubes.
• Expertise in developing executive summary Dashboards and interactive dashboards using selectors, panels and various widgets.
• Handled complex Reports in MicroStrategy Desktop using features like templates, custom groups and consolidations.
• Experience in report Caching and Optimization.
• Experience delivering reports in Desktop, Web and via Distribution Services.
• Experience in setting up teh MicroStrategy system administration including installation and configuration, Metadata, configure teh Intelligence server, creating users, user groups, security filters, roles, privileges, and security roles.
• Good Knowledge in data extraction and transformation (ETL) using Informatica Power Center 6.x, Power Mart 6.x and Data Stage.
• Proficient in database programming using SQL, PL/SQL for writing Stored Procedures, Triggers, Packages.
• Good noledge and understanding of Software Development Life Cycle (SDLC).
• Extensive noledge on SQL/PLSQL and very proficient in working with very large databases in Oracle, TERADATA, DB2 UDB, SQL Server.
• Excellent communication skills and teh ability to work individually as well as in a team environment.

TECHNICAL SKILLS

BI/DS Tools: MicroStrategy 10.1, 9.2.1, 9.0, 8.1, 8.0.1 (Administrator, Agent, Web Architect, Distribution Services, Report Services).

ETL Tools: Informatica 8.0/7.0/6.2 (Power Center, Power Mart), SQL Server DTS, Data Stage.

Data model: Star schema and Snowflake schema.

Databases: Oracle 7.x/8i/9.x/10g, DB2 UDB, SQL Server 6.5/7.0, Teradata V2R5/R4/R3/R2, Netezza.

Internet: HTML, DHTML, ASP and JavaScript.

Languages: C, C#, HTML, Java, Visual BASIC, Shell Scripting, XML, XSL and PL/SQL.

Operating Systems: UNIX, Linux, Microsoft Windows 95/98/00/NT/XP.

PROFESSIONAL EXPERIENCE

MicroStrategy Consultant

Confidential, NY

Responsibilities:

• Worked on Migration of Cognos reports to MicroStrategy.
• Planning, requirements analysis, design and development of new MicroStrategy 9.4.1/10.1 projects or enhancements of existing projects.
• Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics using MicroStrategy Desktop and Architect.
• Architected and performed teh report development.
• Experience in Upgrading MSTR 9.4.1 to MSTR 10.1.
• Interacted with business users extensively in gathering teh requirements and translated them into report specifications for teh MicroStrategy platform.
• Written and created logical views in MicroStrategy.
• Created complex filters with advanced qualification involving ‘ApplySimple’ and ‘Apply Comparison’ functions.
• Created complex reports using Advanced Prompts, Non - Aggregatable Metrics, Conditional Metrics, Transformation Metrics and Level Metrics.
• Used freeform SQL editor to meet teh requirements.
• Created Report Services Documents out of existing reports and customized them to reflect teh corporate logos and color palette.
• Converted Dashboards for Mobile (iPad/iPhone) versions and deployed them using MicroStrategy Mobile.
• Migrating objects from Dev to QA server by creating Packages using Object manager.
• Trained end users and power users on teh functionality and usage of MicroStrategy Reports.
• Installed and configured MicroStrategy in both QA and Production environments.
• Tested and worked with a team to troubleshoot some Report related issues.
• Experience working with Non-Relational transactional database.
• Assisted Business System Analysts in user training and creation of accurate documentation.

Environment: MicroStrategy 9.4.1 (Architect, Desktop, Dash Boards), SQL Server, Teradata, Teradata SQL Assistant.

MicroStrategy Developer/Architect

Confidential, GA

Responsibilities:

• Design and creating teh mockups for teh dashboards using third Party tools.
• Worked closely with Business Analyst, Business Users and testers in agile environment and coordinate with teh onshore team.
• Providing teh support to teh existing projects in production.
• Created and modified teh schema objects like Attributes, Facts, Views and Logical tables.
• Created Advanced Filters, Prompts and Complex Metrics for teh reports in MicroStrategy.
• Experience in working on Reports and Visual Insights based on Intelligence Cubes.
• Created complex reports and dashboards using 9.4.1.
• Creating teh reports based on Intelligence Cubes.
• Creating ad-hoc reporting and providing teh basic functionality training to teh users.
• Worked on Performance tuning teh reports.
• Used functions in MicroStrategy like Apply Simple whenever necessary.
• Done teh unit testing for teh reports developed.
• Coordinated with UAT and Testers in fixing teh defects.
• Coordinated with DBA and ETL Developers in creating teh semantic objects.
• Object Migration using teh object manager between different environments.

Environment: MicroStrategy 9.4.1 (Architect, Desktop, Dash Boards), SQL Server, Teradata, Teradata SQL Assistant.

Sr. MicroStrategy Developer

Confidential, AZ

Responsibilities:

• Involved in collecting teh business requirements and documenting teh specifications.
• Designing teh Report specification for teh requirement.
• Created Advanced Filters, Prompts and Complex Metrics for teh reports in Microstrategy.
• Implemented Schema objects like Attributes, Facts, Views and transformation tables.
• Created Reports and done unit testing.
• Created KPI Dashboards and Scorecards.
• Migrated teh objects from Dev to QA server by creating Packages using Object manager.
• Tested all teh reports by running queries against teh warehouse-using SQL Server developer. Also compared those queries with teh MicroStrategy SQL engine generated queries.
• Created Templates and custom drill maps.
• Linking between teh reports.
• Created Custom groups and Consolidations.
• Used functions in MicroStrategy like Apply Simple & Apply Comparison whenever necessary.
• Proficient in database programming using SQL, PL/SQL for writing Stored Procedures, Triggers, Packages.

Environment: MicroStrategy 9.2.1 (Architect, Desktop, Dash Boards, Object Manager, Enterprise Manager), SQL Server, Oracle 11g, Oracle SQL Developer, OLAP.

Sr. MicroStrategy Developer

Confidential, CA

Responsibilities:

• Worked on SSRS Migration project.
• Converted all existing SSRS reports to MSTR 9.2.1.
• Designed MicroStrategy Schema and Involved in creating application objects Facts and Attributes for teh requirement.
• Created Advanced Filters, Prompts and Complex Metrics for teh reports in MSTR by gathering teh information from teh store Procedures of teh existing SSRS reports.
• Developed reports similar to teh existing reports by using MicroStrategy functionality with small enhancements.
• Developed documents using teh reports to get teh feel of teh existing reports and functionality.
• Created Templates and custom drill maps.
• Created Edit links for drilling from one document to another.
• Involved in migrating teh documents to Test and Production.
• Provided test scenarios for teh testing team and done Data validation.
• Created formatting conditions for teh MSTR documents.
• Provided Demo for teh users to use teh MicroStrategy reports and given training on teh enhancements.

Environment: MicroStrategy 9.2.1 (Architect, Desktop, Dash Boards, Object Manager, Enterprise Manager), SQL Server, SQL Developer, OLAP.

MicroStrategy Consultant

Confidential, MN

Responsibilities:

• Architected and performed teh report development for teh MicroStrategy projects by creating facts, attributes, hierarchies, reports, filters, metrics and templates.
• Lead MicroStrategy technical resource on a large Windows server migration.
• Upgraded Narrowcast Server from 8x to 9x.
• Worked on integrity manager to create baselines for Projects in MicroStrategy Development and Production Environment.
• Used to run weekly and monthly reports in MicroStrategy and deliver them to teh users.
• Used Object manager to migrate objects from development to production environment and duplication of objects.
• Experience in Upgrading MSTR 8.1 to MSTR 9.0.1.
• Implemented MicroStrategy Schema Objects and Application Objects like Attributes, Hierarchies, Filters, and Metrics using MicroStrategy Desktop to create new and rebuild teh reports of teh existing environment in teh new environment.
• Involved in gathering teh requirements for teh reports to be created and transitioned into teh new environment from teh existing one.
• Extensively worked in delivering reports through MicroStrategy Office. Delivered ICRO formatted and conditional formatted reports through MicroStrategy Office.
• Created views, triggers, stored procedure in SQL Server and assisted SQL server DBAs and SQL server Administrators in making changes in teh Database as required for teh MicroStrategy Environment.
• Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
• Created different objects dat define Narrowcast Server services, including content Information Objects, Documents, Publications, Subscription Sets, and Schedules and Implemented proactive, personalized information delivery services using MicroStrategy Narrowcast Server.
• Designed Dynamic Dashboards and Scorecards as per teh business requirements.
• Created transformations for YTD (Year to date), MTD (Month to date) analysis.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Tested all teh reports by running queries against teh warehouse-using TOAD. Also compared those queries with teh MicroStrategy SQL engine generated queries.
• Created complex filters with advanced qualification involving ‘ApplySimple’ and ‘ApplyComparison’ functions.
• Used Enterprise Manager for logging statistics and reporting purposes.
• Developed Report Service Documents and dynamic dashboards using new and existing data sets.
• Built Prompted reports and dashboards for teh Planning and Strategy team using Complex Metrics, Advanced filters and Prompt filters.

Environment: MicroStrategy 9.0.1/8.1(Administrator, Architect, Desktop, Narrowcast Server, Dash Boards, Object Manager, Enterprise Manager), Oracle 10g, Toad, OLAP.