SUMMARY:

• Around 9+ years of professional experience in Software System Design, Development, Testing and Implementation of Client/Server applications using databases as SQL - Server 2000/2005, Oracle 9i/10g, Teradata, Netezza, DB2 UDB, SAP HANA and reporting tools as Micro Strategy 10x/9.X/ 8.1/8.0/7.5. Proficient in implementing Business Intelligence, and have a good understanding about Star schema, and Snowflake schema.
• Installing, configuring and working with MicroStrategy tool Suite (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect, MicroStrategy Administration, MicroStrategy Intelligence server, MicroStrategy Narrowcast server, and MicroStrategy OLAP Services and MicroStrategy Distribution Services).
• Designing Data Marts using multi-dimensional Data modeling techniques, which include Fact, Dimension tables, Logical and Physical data modeling Creating MicroStrategy metadata repository through a 3-tier architecture involving MicroStrategy Intelligence Server
• Creating and implementing various Schema Objects (Facts, Attributes, Hierarchies, and Transformation) and Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches and Templates) to develop documents and reports.
• Developed Proactive Delivery Reports as well as Complex Reports in MicroStrategy Web using MicroStrategy Narrowcast Sever.
• Software development kit used for developing custom widgets.
• Developed fully interactive scorecards, dashboards, and enterprise reports using MicroStrategy Report Services.
• Testing the reports using the MicroStrategy Integrity Manager.
• Using TOAD, Query Manager, and WinSQL for system testing of reports.
• Created new users and giving them access to MicroStrategy Platform.
• MicroStrategy Administration that includes Intelligence Sever Administration configuration of Memory Settings, Performance Monitoring, Creating New Users, Roles, Privileges, Shared Folders and access Control Lists.
• Used administration tools like Project Merge and Object Manager to move the objects from one environment to other.
• Performance Optimizing by creating Caching & Intelligence cubes. Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, Security, queries execution and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
• Developed Procedures, Functions, Triggers and other database objects using SQL, and PL/SQL.
• Experience in using Erwin to generate logical & Physical models of the Data warehouse Structures.
• Involved in ETL process using Informatica Power Center.
• Significant experience in Banking, Retail, Healthcare, Insurance and Manufacturing sectors. Excellent interpersonal skills and communication skills.
• Active team player between Client, Project Manager, Development team, Marketing Team and Quality Assurance team.

TECHNICAL SKILLS:

Business Intelligence: Informatica Power Center 8.5/8.1.1/7.1. x/6.x/5.1, Microsoft OLAP Manager, MicroStrategy Desktop 7.5.0/8.X/9.X,10.X MicroStrategy Architect, MicroStrategyWeb, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Cogno s, MicrosoftSQLServer, Analysis Services

RDBMS: MySQL, Oracle8i/9i/10g/11g, Access 2000, DB2.

Languages: C, C++, SQL.

Environment: Windows 7/Vista/XP/2K/NT/98, Linux and

Web Technologies: UNIX.

Applications: HTML, CSS, XML. MS Project, MS Access, MS word

PROFESSIONAL EXPERIENCE:

Confidential, Camden NJ

MicroStrategy Developer /Architect

Responsibilities:

• Determining the source table and columns needed to make a MicroStrategy project. Configuring reports needed by the end users through Developer and MicroStrategy web. Created metrics and filters in the process of making a report.
• Created Schema Objects (Attributes, Facts, Transformations and Hierarchies).
• Created Public objects based on the report requirement.
• Created documents and Dashboards.
• Created cubes to increase the performance of the report and Dashboards.
• Created web link for the dashboard with default prompt answers using HTMP code.
• Created reports based on multi sourcing.
• Involved in Testing and Data validation of Reports and document and given production support.

Environment: MicroStrategy 10.2, MicroStrategy Developer, MicroStrategy Intelligence Server, MicroStrategy Web, Informatica Power Center, SQL Developer, Oracle, SAP Hana Studio, Windows 2003 Server

Confidential, MD

MicroStrategy Developer /Architect

Responsibilities:

• Involved in design ETL Process based on the business.
• Download and Install the MSTR tool on the server and established the connections.
• Created schema objects like Attributes, facts by using MicroStrategy Desktop.
• Created Applications Objects like Advanced Metric, Filters, Prompts, Custom Groups and Consolidations.
• Created Microstrategy reports, documents and dynamic dashboards based on the requirements.
• Created cubes to increase the performance of the report and Dashboards.
• Created the logical views as required.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
• Setup the Test environment and moved the objects from DEV to TEST by using object manager.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Validated end user requirements using Microstrategy tools.
• Worked on administrative tasks like creating User and User Groups, Roles, and Privileges.
• Involved in Testing and Data validation of Reports.

Environment: MicroStrategy 10.1 (Administrator, Architect, Desktop, MicroStrategy Web, Object Manager), SQL Assistant, SQL Server.

Confidential, Atlanta, GA

MicroStrategy Developer /Architect

Responsibilities:

• Involved in design ETL Process based on the business.
• Created schema objects like Attributes, facts by using MicroStrategy Desktop.
• Created Applications Objects like Advanced Metric, Filters, Prompts, Custom Groups and Consolidations.
• Created Microstrategy reports based on existing reports in the project.
• Created cubes to increase the performance of the report and Dashboards.
• Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.
• Created Dynamic Dashboards showing Company's yearly, Monthly and Quarterly performance using various graphs and widgets.
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Validated end user requirements using Microstrategy tools.
• Worked on administrative tasks like creating User and User Groups, Roles, and Privileges.
• Used the Object Manager to migrate objects to different environments.
• Involved in End-User training, Support and Maintenance.
• Involved in Testing and Data validation of Reports.

Environment: MicroStrategy 9.4.1 (Administrator, Architect, Desktop, MicroStrategy Web, Object Manager), SQL Assistant, SQL Server.

Confidential, AL

MicroStrategy Developer

Responsibilities:

• Collaborated with business partners to define requirements and reporting specifications and provide technical report assistance.
• Conducted regular working sessions with the users to analyse their reporting needs and provide solutions for the same.
• Created Attributes, Facts, Hierarchies and Relationship between various Attributes
• Created application objects such as Metrics, Compound Metrics, Filters, Custom Groups, Consolidations, Templates, Auto Prompt Filters and OLAP Reports.
• Designed and Developed Dashboards, Documents and Reports.
• Assisted the users in their end user testing and resolved issues if any
• Involved in creating user groups, security filters for users and assigning privileges to those groups.
• Worked with analytical and governing settings in VLDB properties for performance tuning of reports.

Environment: MicroStrategy Desktop 9.3, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy, Oracle, Windows XP 2002

Confidential, MN

MicroStrategy Architect/ Developer

Responsibilities:

• Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
• Developed Flash Dashboards in 9.3 using Widgets and Selectors for summary level reporting.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics 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.
• Created highly visual dashboard by using visual insight.
• Created Complex filters with advanced qualifications involving the ‘Apply’ functions.
• Developed various Adhoc and created Documents using Report Services Documents.
• Knowledge in Developing Mobile Dashboards.
• Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
• Imported data from excel and created intelligent cube and created reports, documents and dashboards from the cube
• Create Drilling path and implement those into reports such that user can Drill across different System and User hierarchies. Create Intelligent Cube and use that in reports to decrease the workload on database.
• Work on VLDB properties like query optimization to optimize the query.
• Used Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report. Worked along with Microstrategy Knowledge Base to troubleshoot some Report related issues.
• Schedule and Deliver Reports to Business Users in Desktop and Web via Narrowcast Server.
• Work with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Played a key role in User Acceptance Testing of the reports.

Environment: MicroStrategy Desktop 9.3, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy, Teradata, Windows 7

Confidential, CT

MicroStrategy Developer/Architect

Responsibilities:

• Involved in meetings with business users to discuss and finalize the requirements and design of the reports. Create dynamic dashboard using Widget, Panels, Selectors, Graphs and Grid.
• Participated in design of database architecture, ELT processes specifically usage of data loading features available in Netezza.
• Created on the fly dashboard by using visual insight
• Worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.
• Worked on the MSTR Narrowcast module to Schedules to have the reports delivered business users. Performed routine administrator tasks during absence of MicroStrategy administrator.
• Created Users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Used custom widgets developed by SDK.
• Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
• Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.
• Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.
• Worked with back end Database Administrators to provide requirements for necessary back end tables. Extensively worked in both Ad-hoc and Standard Reporting Environments and Involved in creating Reports scalable to large volumes of data.
• Managed projects through entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.

Environment: MicroStrategy Desktop 9.2, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy, Oracle 10g, Erwin 7.1, Windows server 2007

Confidential, NC

Sr.MicroStrategy Architect/Developer

Responsibilities:

• Involved in designing functional specification of reports based on requirements.
• Analyzed the business model to understand the Existing Systems and Business Requirements. Migrated Reports from Cogno’s to MicroStrategy.
• Created MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop. Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Worked on development of Dashboards, Reports and Intelligent Cubes based on the technical and business specifications of the customer.
• Tuned reports performance by tweaking VLDB properties.
• Worked with Free-Form SQL reports to create reports that are not supported by existing schema model.
• Created logical views for reports and documents. Created simple and complex report in MicroStrategy Desktop and web and provide Production support.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies. Involved in creating Security filters to end users to access data based on their privileges. Used Apply Simple and Apply Comparison functions to develop complex Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Created Administration Tasks like creating User Accounts, Assigning Privileges and applied Security Filters. Worked with Object Manager to move Objects and Packages between different environments.
• Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Environment: MicroStrategy Desktop 9.0.2, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy, Oracle 10g, Erwin 7.1, Windows server 2003

Confidential, MA

MicroStrategy Developer

Responsibilities:

• Involved in Requirements gathering from Business Users.
• Developed Facts, Attributes, and Hierarchies using respective editors. Designing and developing advanced grid reports, consisting of data analysis by combining a template with advanced Metric Objects.
• Developed and customized Ad-hoc reports using Templates, Metrics, Filters, Auto Prompts, and Custom Groups.
• Creating Report Services Documents out of existing reports and customized them to reflect the company’s logos and color palette. Created Dashboards which helps in better understanding of the Business trends.
• Created reports with View Filters and Derived Metrics on a report for further analysis of report which reduced database load.
• Created several Intelligence Cubes for reports to reduce the database load on data warehouse. Created Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Developed reports with View Filters and Derived Metrics for further analysis which reduced database load and improved respond time to end users.
• Created various Security Filters to enforce security on the sensitive people data. Used Administrator tools like Project Merge and Object Manager to move the objects from one environment to another environment.
• Transmitted reports and documents to various levels of users by using Delivery manager. Test the reports by running SQL statements against database in BD Query Tool.
• Tuned reports performance by tweaking VLDB properties.

Environment: MicroStrategy Desktop 9.2, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy, Oracle 11g, Erwin 7.1, Windows server 2002

Confidential, NJ

MicroStrategy Architect/Developer & Data Analyst

Responsibilities:

• Gathered requirements from user and converted them to technical specifications. Extensively created MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Developed and customized Ad-hoc reports using Templates, Metrics, Filters, Auto Prompts, Custom Groups, and Transformations using MicroStrategy 8.1.
• Designed and developed advanced grid reports, consisting of data analysis by combining a template with advanced Metric Objects, Filters and Prompts.
• Created simple and complex report in MicroStrategy Desktop and web and provide Production support.
• Created Report Services Documents out of existing reports and customized them to reflect the company’s logos and color palette.
• Constructed reports with View Filters and Derived Metrics on a report for further analysis of report which reduced database load and improved respond time to end users.
• Created Dynamic Dashboards showing facilities yearly performance using various graphs and widgets. Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Designed and customized reports in development and production phases to supply the business with improved flexibility and functionality. Extensively used Narrowcast Server in various phases of Report generation namely Self-Subscription portal, Profile Management, Web, Proactive Information Delivery, Content Management and Personalization. Created various Security Filters to enforce security on the sensitive people data
• Tuned reports performance by tweaking VLDB properties. Worked with Free-Form SQL reports to create reports that are not supported by existing schema model.

Environment: MicroStrategy Desktop 9/8.1, MicroStrategy Administrator, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, Oracle 10g, Erwin 7.1, Windows server 2002

Confidential, Burlington, VT

MicroStrategy Developer

Responsibilities:

• Analyzed the business model to understand the Existing Systems and Business Requirements. Worked with project manager for project scope, team work assignment and setting deadlines
• Created Dashboards and Scorecards which helps in better understanding of the Business trends.
• Communicated with the users to understand the requirements of Dynamic Dashboards and Scorecards.
• Used several new controls for Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in 8.1 Identified Source tables and columns required to create a MicroStrategy Project.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser. Proactively created report formats and delivered personalized messages from the Data warehouse through MicroStrategy Narrowcast Server to a wide range of users.
• Developed Facts, Attributes, and Hierarchies using respective editors. Designed Components, Templates and Filters to generate reports in Grid and Graph mode using MicroStrategy 8.1.
• Migrated Schema and Configuration Objects into various environments using Object Manager.
• Developed and customized Ad-hoc reports using Templates, Metrics, Filters, Auto Prompts, Custom Groups, and Transformations using MicroStrategy 8.1.
• Administered projects Unloading, Loading, and Checking Status of project. Constructed reports with View Filters and Derived Metrics on a report for further analysis of report which reduced database load and improved respond time to end users. Transmitted reports and documents to various levels of users by using Delivery manager.
• Improved report and document response time by creating Reports, Object and Element Caches. Generated several Intelligence Cubes for reports to reduce the database load on data warehouse. Created various Security Filters to enforce security on the sensitive people data.
• Involved in upgrading MicroStrategy 8.1 to MicroStrategy 9. Made several necessary changes in Very Large Databases (VLDB) setting like Cartesian join warning, SQL Global optimization, to make absolute use of database flexibility, effective queries execution and scalability issues suited for Oracle, Teradata, DB2 and MS SQL Server.
• Created and Scheduled reports for automatic execution by time and event base. Provided Data Access to executives, managers (Casual users) and Business Analysts (Power Users).

Environment: MicroStrategy Desktop 9/8.1, MicroStrategy Administrator, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, Netezza, Teradata, Erwin 7.1, DB2,Windows server 2003