SUMMARY

• Over 8 Years of extensive work experience in the field of Information Technology implementing Data warehousing, Decision Support Systems.
• Extensively worked in developing DW applications using MicroStrategy Desktop, Web, Administrator, Narrowcast Server, and Intelligence Server.
• Extensively worked in creating and integrating MicroStrategy reports and objects Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations with the data warehouse.
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
• Created complex Reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
• Experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
• Experience in Data Modeling using ERWIN3.x/4.0, Data mart and OLAP for business analysis using star snowflake schemas, for faster and effective querying.
• Experience with integrating MicroStrategy with heterogeneous data sources and the implementation of dynamic-sourcing.
• Handled Slowly Changing dimensions in a Data warehouse depending on the changes in business dimensions.
• Decent Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages and triggers
• Very good experience in working with very large databases on Oracle, SQL Server with Micro strategy Suite. Strong SQL skills in SQL server Environment.
• Experience in developing and deploying MicroStrategy mobile apps on Apple IOS/iPad and/or similar other devices.
• Exceptional analytical and problem solving skills. Self-motivated team player with the ability to communicate effectively at all levels of the development process.
• Involved in Product Support on Call Support on rotation basis.

SKILLS

PROFESSIONAL PROFILE

Responsibilities:

• Involved in the complete Life Cycle of the project.
• Interacted with the data modeling team for the Logical and Physical model design.
• Involved in designing the Conceptual model.
• Involved in creating the Aggregate tables considering both the Technical Feasibility and Business Feasibility to improve reports performance.
• Created Attributes, Facts, Dimensional Hierarchies and all the public objects like Metrics, Custom groups, prompts and filters.
• Created Hierarchical prompts, nested prompts, object prompts.
• Created Cubes to assist the quick analysis for the Demand and Deployment Team. In turn reduced a large amount of load on the MicroStrategy and Database.
• Experienced in performance tuning of the reports and the environment.
• Involved along with Oracle DBAs to create partitioned tables and indexes to improve the overall report performance.
• Worked on District Manager Mobile DashBoards for Better, quick and best Analysis of store performance.
• Developed Dashboards using widgets and selectors for summary level reporting.
• Created Dashboards using report services documents.
• Developed Dynamic Dashboards and Scorecard reports.
• Developed departmental dashboards for different brands and Key Performance Index corporate dashboards.
• Migrated Narrocast Services to Distribution Services.
• Created customized Custom Groups with complex filters and Relationship filters.
• Created Complex reports for analysis like Market Basket analysis with custom groups, Transformations and complex filters.
• Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both Microstrategy Desktop and MicroStrategy Web.
• Created Ad-hoc reports with dynamic prompt answers for the end users to generate.
• Worked with the Microstrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues
• Used the VLDB properties for performance tuning and SQL optimization.
• Created Transformations like Last Month to This Month and also created the required transformation tables.
• Experience in analysis the explain plans of SQL and analyzing the indexes in the process of tuning the reports.
• Coordinating with offshore team during migrations and any production support issues.
• Working on CA Technologies Unicenter ServicePlus Service Desk for support.
• Performed the ETL, UAT and System tests on the warehouse tables and the reports.

Environment: MicroStrategy 9.0.1/9.2.1/9.3/9.4/9.4.1 Desktop, Administrator, Architect, Intelligence Server, Web , Microstrategy, Object Manager, Teradata, SQL Server, Windows

Confidential

MicroStrategy Architect/ Developer

Responsibilities:

• Gathering requirements from business users and analysts.
• Has worked on MicroStrategy 9.3 cloud and have down POC with 9.3.1.
• Worked with the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
• Collaborate with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Involved with ETL team in fixing complex data modeling issues like slowly changing dimensions and designing physical schema model.
• Architected the Schema for the project by creating facts, attributes, and hierarchies.
• Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Desktop to meet report requirements.
• Created daily, monthly reports and dashboards for iPhone, iPad using MicroStrategy mobile.
• Dashboard design--Utilized standard templates and added panels.
• OLAP services Intelligent cube design for advanced analytics and Trend analysis reporting.
• Developed the OLAP services by creating the cubes, view filters and derived elements to improve the performance of the Executive dashboards.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Respond to business users inquires directly to provide technical support and best-practice report consulting.
• Perform code review and unit, system, regression testing.
• Involved in Performance tuning of SQL for long running reports.
• Unit/System Testing validation of reports using Complex SQL,PL/SQL scripts.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.

Environment: MicroStrategy 9.3, Architect,Web Intelligence, Object Manager, Integrity manager, Configuration Wizard, SSIS, Windows NT and UNIX.

Confidential

MicroStrategy System Analyst / Architect

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Collected information from business users for finalizing system and reporting requirements. Analyzed and lead the development work of MicroStrategy Environment.
• Involved in architecting the schema objects Attributes, Facts, Hierarchies.
• Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.
• Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.
• Involved in working with centers for Medicaid/Medicare Services CMS . Have experience on Medicaid claim processing.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.
• Assisted the team in integrating the current project with new Enterprise analytics.
• Optimized query performance by updating VLDB very large database properties and by modifying cache behavior.
• Involved in development interactive dashboards and scorecards for high level management.
• Designed reports and documents for iPad, iPhone and Blackberry.
• Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.
• Customized reports using Custom Groups and Consolidations.
• Designed Compound metrics and Complex filters and Time filters.
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Set up new security filters for the user roles to limit the access to the data.
• Configured Data Marts in MicroStrategy Desktop to update tables in database.
• Optimized query performance by updating VLDB properties at project level and report level.
• Performed optimizations using Report Data Options.
• Have developed dashboards on different versions iPhone for different screen sizes.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser
• Extensively used Microstrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Unit tested the reports developed by the other developers.

Environment: MicroStrategy 9.2.1, Architect,Web Intelligence, Object Manager, Integrity manager, Configuration Wizard, Informatica 9, Report Studio 8, SSIS, Windows NT and UNIX.

Confidential

MicroStrategy System Analyst / Architect

Responsibilities:

• Worked with the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
• Collaborate with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Architected the Schema for the project by creating facts, attributes, and hierarchies.
• Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Desktop to meet report requirements.
• Created daily, monthly reports and dashboards for iPhone, iPad using microstrategy mobile.
• Dashboard design--Utilised standard templates and added panels.
• Designed Interactive Dashboards in MicroStrategy Web to assess companys performance and monitored the overall goals of the business. Used various selectors, gauges, thermometers, and funnels in the process.
• OLAP services Intelligent cube design for advanced analytics and Trend analysis reporting.
• Developed the OLAP services by creating the cubes, view filters and derived elements to improve the performance of the Executive dashboards.
• Designed and built pixel perfect report service documents and interactive Flash dashboards.
• Build the report builder interface for the Adhoc Analysis.
• Created transformations using Transformations by tables for YTD Year to date , and MTD Month to date for Time Series Analysis.
• Set up the distribution services for distributing the report output to the different levels of users.
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Resolved the defects during the QA and UAT testing process.
• Having experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Designed and develop VB.net application that utilized MicroStrategy SDK to automated e-mail and multiple MicroStrategy attachments.
• Designed and developed dashboards for iPad, iPhone and blackberry by providing flash analysis and interactivity using widgets.
• Troubleshooting connection issues and reports, documents.
• Managed subscriptions through MicroStrategy desktop, command manager and web.
• Recreated all existing desktop dashboards into mobile platform using layout adjustments as needed.
• Strong skills in Requirement gathering and study, Gap Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms Documentation, UAT.

Environment: MicroStrategy9.2.1, MicroStrategy Intelligence Server and web AIX , Informatica8.1/7.1/6.2, Teradata, Oracle.

Confidential

MicroStrategy Analyst

Responsibilities:

• Worked with business requirements analyst's subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Created the Detail design documents and Technical Specification Documents based on Business requirement documents.
• Participate in daily status and monthly planning meetings
• As per business requirement, Designed developed and maintained MicroStrategy based reports.
• Design and development ofMicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Respond to business users inquires directly to provide technical support and best-practice report consulting.
• Perform code review and unit, system, regression testing.
• Involved in Performance tuning of SQL for long running reports.
• Created Dashboard for Corporate Financial Forecasting.
• Unit/System Testing validation of reports using Complex SQL,PL/SQL scripts.
• Deployment automation of report objects from Serena Dimensions using shell scripts.
• Used report services for various banded report to satisfy the printing requirements of the user.
• Provide production support of MicroStrategyreporting application.
• Create users in MicroStrategy and grant required access for projects.
• Coordinated in moving the objects from Development to Production Environment in MicroStrategy by using Object Manager.
• Configuration of Narrowcast server and Involved in various Narrowcast task like creating Documents, service designs, subscription, administration and scheduling.
• Prepared technical project related documentation.

Environment: MicroStrategy Desktop, MicroStrategy Intelligence Server8.1.0, MicroStrategy Web8.1.0, MicroStrategy Narrowcast Server8.1.0. MicroStrategyOLAP Provider, Oracle 10g and UNIX

Confidential

MicroStrategy Consultant

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Communicate business user requirements and provide clarifications as needed.
• Speed up project loading process by increasing/extending the size of element and object caches.
• Experienced administrative capabilities, Project Setup Installing, configuring, managing and controlling and Project Lifecycle Management.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Managing schema objects and application objects across the project by using Object Manager.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling lock, limit and filter out the attribute elements in hierarchy.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: MicroStrategy Desktop9.0.0, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.

Confidential

MicroStrategy System Analyst consultant

Responsibilities:

• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Extensively used Pass-through Apply Functions expressions to pass special functions.
• Designed, Developed and altered html document objects by placing multiple reports on it in Grid as well as Graph View applying XSL formatting for each in the process of automating IT Dashboard reports.
• Project duplication within and in between different project sources of Prod, Dev and UAT environments.
• Personalize the end user experience at report runtime by providing flexibility with reusable prompts/report parameters
• Validate, Detect and Repair logical/physical inconsistencies and corruptions of MicroStrategy metadata by running Scan MD/MD Doctor utilities.
• Extensively used Object Manager, Project Merge and User Merge utilities to manage MicroStrategy Tier 1/ High Impact applications and objects.
• Responsible for creating the MicroStrategy DB instances, DB connections, DB logins and ODBC DSNs.

Environment:MicroStrategy tool suit7.2.3/7.5.1/8.0/9.0, MicroStrategy Office 7.5.1, DB2 UDB V7.1/V8.1 for Unix/Windows, Teradata, Windows 2000/2003, Sun Solaris V9/V10, Altiris Client Management Suite V6.0.

Confidential

Crystal Report Developer

Responsibilities:

• Designed and developed reports using Crystal Reports XI version.
• Created Crystal Reports using Crystal Reports formulas, Grouping, Parameters, Selection criteria to handle the customer's requests from Tables, Stored Procedures, Views and Command Objects.
• Wrote several PL/SQL queries to query the database and use them as a command object for designing the reports.
• Designed and developed database calls using ODBC connectivity.
• Developed various charts and graphs like Bar chart side-by-side, stacked , line graphs, Gantt Chart etc. by using Chart Expert using Crystal Reports XI.
• Generated report for web-based query using Business Objects Enterprise XI.
• Used Central Management Console for deploying and managing the reports.
• Responsible for giving user access and setting restrictions to view the reports.
• Worked with other users and the project manager to gather requirements.
• Worked on reports that contained up to 10 sub-reports including drill-down sub reports . Handled both dependent and stand-alone sub reports.
• Extensively worked on reports that contained several parameters static and dynamic cascade prompts .
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Communicated reporting changes, enhancements, and modifications, verbally or through written documentation, to management and other employees so that issues and solutions were understood.
• Worked with the testing team to implement and debug the application.

Environment: Crystal Reports XI, Business Objects Enterprise XI, Oracle 9i, DB2 UDB, Java, Windows NT/2000, Microsoft.Net, IIS JSP

Confidential

Oracle Developer

Responsibilities:

• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Implemented a Database design using Designer/2000 in an Oracle 7.3 environment.
• Designed the database based on requirements of the system.
• Designed the User interface for forms with developer 2000 features.
• Generated necessary reports periodically using Reports.
• Created the database, table spaces, tables, indexes and other database objects.
• Loaded the data into the Oracle database using SQL Loader
• Responsible for performing various database administration duties using advanced querying tools and PL/SQL scripting techniques, Procedures.
• Responsible for troubleshooting various aspects of the client/server architecture in both a UNIX and an Oracle setting.

Environment: Oracle7.3, PL/SQL, SQL, Developer 2000 Forms 4.5, Reports3.0, UNIX and Windows 95