PROFESSIONAL SUMMARY:

• 7 years of IT experience in various fields like Data Warehousing, PL/SQL Business Intelligence, Database applications.
• Strong experience in MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, Web, Distribution Services, Mobile).
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data Warehouse.
• Expertise in creating complex reports in MicroStrategy Desktop using features like Templates, Filters, Prompts, Consolidations and Custom Groups.
• Developed various Micro Strategy Distribution Server Objects like Service, Schedule, Publication, Information objects, Information Source and Subscription etc.
• Extensively worked on delivering reports and business intelligence solutions using Microstrategy Distribution Services.
• Expertise in creating custom Dash Boards and Scorecards in Flash and DHTML.
• Experience in configuring the Intelligence Server and pointing the database instances in both development & Production environments.
• Experience in designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Physical and logical data modeling.
• Expertise in using MicroStrategy Report Services to generate electronic snapshots of business data and present them in a visually appealing and intuitive format.
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.
• Good experience in RDBMS - Teradata, Oracle, and SQL server.
• Worked on upgrading the MicroStrategy project created in MicroStrategy version 8.x to version 9.4.1.
• Very well versed with Data Warehousing concepts.
• Performance monitoring and tuning experience for both MicroStrategy and Teradata.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS:

BI Tools: MicroStrategy v9.4.1, v9.3.1, v9.2.1, v9.1.0, v9.0.2, v8.0.3/8.1 (Microstrategy Administrator, MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services, MicroStrategy Architect, MicroStrategy Distribution Services, MicroStrategy Office), Narrowcast Server, Cognos, Business Objects.

Databases: Oracle 10g/9i/8i, MS Access, Teradata, MS SQL Server, DB2

Front End Tools: Oracle Developer 2000, Oracle Designer 2000, Visual Basic 6, SQL Navigator, Toad

Operating Systems: Windows 2000, Windows XP, Windows vista, Windows 7, UNIX

Languages: SQL, PL/SQL, C/ C++, C#

Office Tools: MS Word, Excel, MS Visio, MS Project, MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential

Sr. MicroStrategy Developer/Admin

Responsibilities:

• Met regularly with Business Team to discuss requirements and designs of reports and documents
• Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
• Coordinating with IT and Business in the planning, design, development, and deployment of New Dashboards and Reports and mapping of data from Data warehouse as per requirements
• Work Closely with Business Team to get the requirements for Dashboard designs
• Architected the projects and created schema objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, prompts, Consolidations, Custom Groups, Drill maps and Templates.
• Trained team of 5 Data Analysts and Business Analysts for creating cost benefit analysis dashboards and reports using report objects and metrics
• Helped client to implement design and Business Intelligence solutions including MicroStrategy Schema Model, Data Warehouse semantic model and other BI/DWH technology platforms and delivery strategies
• Created multiple flash and dynamic dashboards using Intelligence Cube and Documents
• Coordinating with Data Architects to create new schemas and view in Greenplum for new Reporting Environments
• Migrating Project objects using Object Manager and comparing different environments using Integrity Manager of MicroStrategy
• Help Data Analysts to create reports for Analysis using Cubes, Documents and Dashboards
• Created security filters for the Dashboards for as per Clients Requirements for Single User and User Groups

Environment: MicroStrategy 9.4.1, Intelligence Server, Web, Administration, Greenplum, pgAdmin 8.3.1, SQL Server 2012, PL/SQL

Confidential, Boston, MA

MicroStrategy Developer/Admin

Responsibilities:

• Involved in the complete Life cycle of the Project.
• Participated in the end user meetings to obtain the business requirements for creating reports.
• Involved in the data analysis.
• Used the Project Creation Wizard to create Facts and Attributes and used the respective editors to enhance them.
• Created Schema Objects like facts, attributes, hierarchies and application objects filters, prompts, metrics, reports.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes
• Created Advanced Reports in grid mode and graph mode using Microstrategy Desktop.
• Worked extensively in Microstrategy Administration like Creation of new users, roles, privileges, shared folders, access controls lists.
• Taking regular Backups of the Production Metadata in SQL Server Database
• Created advanced grid reports, consisting of data analysis by combining a template with filters.
• The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Created Customized Hierarchy for Drill Maps.
• Created Free form SQL Reports.
• Involved in creating users in Microstrategy Desktop for testing the reports on Web.
• Worked along with Microstrategy Knowledge Base to troubleshoot some Report related issues.
• Used Report cache sharing and Data mart reports to enhance the Report response time.
• Used Microstrategy Object Manager to deploy the Microstrategy Objects from the development stage to the Test stage and then to the Production environment.
• Extensively used Microstrategy Report Services to generate Report Documents.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of Microstrategy Report Services.
• Used conditional formatting feature to project trends for product sales and to enhance grid and graphs in documents.
• Involved in troubleshooting Microstrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Worked with Erwin in designing the schema for database views.
• Responsible for creating process flows to execute mappings with the dependencies in Oracle warehouse Builder.
• Involved in monitor users' typical actions and system usage by using Enterprise Manager.
• Involved in optimization of code and tuning queries for performance.

Environment: Microstrategy 9.0 (Desktop, Administrator, Architect, Narrowcast Server, Intelligence Server, Web and Enterprise Manager), Oracle 10g, Erwin, Windows, UNIX.

Confidential, Skokie, IL

MicroStrategy Consultant

Responsibilities:

• Involved in gathering of business requirements.
• Architected schema objects such as attributes, facts and transformations.
• Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Created various MicroStrategy objects such as Metrics (simple and compound), Filters, Prompts, Custom Groups, Consolidations, etc.
• Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.
• Involved in testing of the entire project when Teradata is upgraded from V2.5 to V2.6.
• Involved in upgrade process of Microstrategy 8.1.2 to 9.0.
• Writing BAT file to call Command manager to execute Service.
• Created custom attribute functionalities using OLAP services.
• Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Micro strategy Intelligent Server Tuning for performance.
• Creation of Intelligent Cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Involved in creating services and objects in Narrowcast server.
• Used Narrowcast Sever for timely delivery of report for authorized users.
• Created various event based Schedules.
• Actively participated in developing Report Delivery Schedules.
• Created reports with various object prompts to generate various Ad hoc reports.
• Worked with Erwin in designing the schema for database views.
• Actively participated in creation of Dashboards for Revenue recognition, Claims processing and employee Performance.
• Created Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.

Environment: MicroStrategy Desktop, MicroStrategy Intelligence Server 9.0 / 8.1.2, MicroStrategy Web, Teradata, and Windows 2000/2003.

Confidential

MicroStrategy Consultant

Responsibilities:

• Analyze requirements and develop derived metrics, custom report objects as required
• Developed Microstrategy reports and related objects
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Interface with business users for requirement definition, user acceptance testing, and deployment
• Maintain standardized Microstrategy design, development, testing and deployment task documentation
• Design, build and maintain logical model for Microstrategy reporting application
• Design, build and maintain all Microstrategy schema objects (attributes, facts, hierarchies)
• Created ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using Microstrategy desktop and web.
• Understand the type of schemas that best support Microstrategy in different scenarios
• Extensively worked with Microstrategy Intelligence Server, Microstrategy Web and Microstrategy Administrator reporting basic using Microstrategy Desktop and Microstrategy Web.
• Involved in troubleshooting Microstrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Developed the single sign on universal login integrating the Microstrategy metadata password with Siteminder.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Experienced in troubleshooting Microstrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Environment: Microstrategy Desktop 8.0, Microstrategy Intelligence Server8.0, Oracle 8i, SQL, Teradata, Windows NT / 2000

Confidential

SQL Developer

Responsibilities:

• Performed the Creation, manipulation and supporting the SQL Server databases.
• Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
• Created stored procedures and triggers which were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Written triggers, stored procedures and manipulated the data using DDL and DML functions.
• Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS)
• According to the business requirements made the documentation of the performed tasks.
• Extensively Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users