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 know the 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 the Data warehouse.
• Extensive knowledge 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 the MicroStrategy system administration including installation and configuration, Metadata, configure the 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 knowledge and understanding of Software Development Life Cycle (SDLC).
• Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle, TERADATA, DB2 UDB, SQL Server.
• Excellent communication skills and the 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 2014, 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/7/8, Windows 2008/2012 R2.

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 the report development.
• Experience in Upgrading MSTR 9.4.1 to MSTR 10.1.
• Interacted with business users extensively in gathering the requirements and translated them into report specifications for the 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 the requirements.
• Created Report Services Documents out of existing reports and customized them to reflect the 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 the 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/10.1 (Architect, Desktop, Dash Boards), SQL Server, Teradata, Teradata SQL Assistant.

MicroStrategy Developer/Architect

Confidential, GA

Responsibilities:

• Design and creating the mockups for the dashboards using third Party tools.
• Worked closely with Business Analyst, Business Users and testers in agile environment and coordinate with the onshore team.
• Providing the support to the existing projects in production.
• Created and modified the schema objects like Attributes, Facts, Views and Logical tables.
• Created Advanced Filters, Prompts and Complex Metrics for the 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 the reports based on Intelligence Cubes.
• Creating ad-hoc reporting and providing the basic functionality training to the users.
• Worked on Performance tuning the reports.
• Used functions in MicroStrategy like Apply Simple whenever necessary.
• Done the unit testing for the reports developed.
• Coordinated with UAT and Testers in fixing the defects.
• Coordinated with DBA and ETL Developers in creating the semantic objects.
• Object Migration using the 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 the business requirements and documenting the specifications.
• Designing the Report specification for the requirement.
• Created Advanced Filters, Prompts and Complex Metrics for the 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 the objects from Dev to QA server by creating Packages using Object manager.
• Tested all the reports by running queries against the warehouse-using SQL Server developer. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Created Templates and custom drill maps.
• Linking between the 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 the requirement.
• Created Advanced Filters, Prompts and Complex Metrics for the reports in MSTR by gathering the information from the store Procedures of the existing SSRS reports.
• Developed reports similar to the existing reports by using MicroStrategy functionality with small enhancements.
• Developed documents using the reports to get the feel of the existing reports and functionality.
• Created Templates and custom drill maps.
• Created Edit links for drilling from one document to another.
• Involved in migrating the documents to Test and Production.
• Provided test scenarios for the testing team and done Data validation.
• Created formatting conditions for the MSTR documents.
• Provided Demo for the users to use the MicroStrategy reports and given training on the 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 the report development for the 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 the 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 the reports of the existing environment in the new environment.
• Involved in gathering the requirements for the reports to be created and transitioned into the new environment from the 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 the Database as required for the 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 that 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 the 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 the reports by running queries against the warehouse-using TOAD. Also compared those queries with the 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 the 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.

Java Developer

Confidential

Responsibilities:

• Preparing the low level Design.
• Preparing the Task Estimation and Efforts.
• Design and Development with Onsite Team.
• Participating in the Bug Fixes.

Environment: Java, JDBC, EJB, Servlets, JSP, Struts, Hibernate, Tomcat Webserver & Oracle

Java Developer

Confidential

Responsibilities:

• Involved in development of JSP pages for sale document modules.
• Involved in writing validations.
• Involved in development of database integration using Hibernate.

Environment: Java, JDBC, Servlets, JSP, HTML & Oracle