SUMMARY

• 7 years of IT experience in various fields like Data Warehousing, Business Intelligence, Database applications and Client server programming.
• Strong experience in MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, Web, Narrowcast Server, 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 Narrowcast Server Objects like Service, Schedule, Publication, Information objects, Information Source and Subscription etc.
• Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Knowledge in Tableau and SAS. waterfall and Agile software development life cycle process to data development projects
• Competent Systems Engineer and Operations Research Analyst, with a strong technical background in optimization and the project management capacity for implementing system development life cycles, optimal resource allocation and risk management
• Expertise in creating custom Dash Boards and Scorecards using 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.
• Build E-R Relationships using E-R Charts and Data Modeling Tools.
• 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 Desktop 9.x/8.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Administrator, Report Services, Command Manager, Object manager.

RDBMS: Oracle 8i/9i/10g, MS Access, MS SQL Server, Teradata 12/V2R6, MySQL.

Languages: SQL, PL/SQL, Unix shell scripting, Java, HTML, XML, ETL Informatica 8.6, SQL Loader, DataStage

OLAP Tools: MS SQL Analysis Services, DB2 OLAP Crystal Reports

Operating Systems: Windows, UNIX, Linux

Other Tools & S/W: TOAD, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Indiana

Sr.MicroStrategy Developer/Admin

Responsibilities:

• Responsible for understanding the business requirements from the users and analyzing the report specification documents.
• Worked on converting Teradata reports in SQL to MicroStrategy reports and documents.
• Analyzed logical data models, understand data warehouse tables and columns, map the columns to the MicroStrategy project by creating public objects.
• Identified the Source tables and columns required to create the MicroStrategy Project, thereby achieving a logical mapping of the physical data warehouse in the MicroStrategy Metadata Repository.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Worked with an agile framework involving rapid prototyping and quick, iterative dashboard development and enhancement.
• Worked on creation of views in Teradata for the creation of MicroStrategy objects.
• Created Dashboards through report services document through MicroStrategy Desktop.
• Worked in Market Basket analysis with Relationship filters.
• Created design and technical specification documents for realizing MicroStrategy objects to be integrated in the report.
• Demonstrated the Dashboard reports and documents to the users.

Environment: MicroStrategy 9.4.1 (Desktop, Object Manager, Enterprise Manager), QlikView, Informatica, Oracle 10g, SQL, Teradata, HTML, Windows.

Confidential, Boston, MA

MicroStrategy Developer/Admin

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 8.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, ETL, OLAP, Windows Server 2003, MicroStrategy Dashboard, Teradata

Confidential - New York, NY

MicroStrategy Consultant

Responsibilities:

• Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.
• Created and maintained Business Documents for reporting and Coordinated with business users and report development team for all reporting changes.
• Designed and developed different types of reports as per the requirements.
• Developed Transformations (table based, formula based) to be used for comparative analysis like loans this year to last year (year to date and month to date).
• Deployed MicroStrategy Desktop in designing the MicroStrategy projects. The business rules of the data warehouse were implemented into MicroStrategy Architecture.
• Worked with Pass-through functions, like Apply Simple in defining the attributes, facts and metrics.
• 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.
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
• Developed thorough understanding of the project’s technical details (e.g. call flow, billing, provisioning, operations, etc.); uncovered and assessed project’s risk and dependencies.
• Worked extensively with Intelligent Cubes in developing the dashboards to increase the performance.
• Created attributes, Consolidations and derived metrics on the reports from Intelligent Cubes.
• Designed Dashboards using selectors & widgets and summarized key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Created report services documents to personalize the reports as per user requirements, which included combination of several sets of individual grid reports, customizing and formatting.
• Created users and user groups, and granted them access to different projects based on the security.
• Created Dynamic Subscriptions for users to be able to receive reports via email.
• Prepared data migration plans including migration risk, milestones, quality and business sign-off details.
• Worked with end users in solving the current financial Issues.
• Extensively worked with end-users to resolve the issues faced during day-to-day activities.
• Integration with the User Interface application built for Chase client.

Environment: MicroStrategy Desktop 8.1.1, MicroStrategy Intelligence Server, MicroStrategy Web, Narrowcast Administrator, Oracle 10g, Oracle Data Integrator, MS SQL Server.

Confidential, Alpharetta GA

MicroStrategy Consultant

Responsibilities:

• Involved in the completeLife cycle of the Project and in thedata analysis process.
• Participated in the end user meetings to obtain thebusiness requirementsfor creating reports.
• Involved in Data-Modeling Analysis like Creation of Snowflake schema, report structure based on the user requirements.
• Installing, Configuring of allMicroStrategyproducts includingMicroStrategyDesktop, Administrator, Intelligence Server, Web Server.
• UsedAdvanced Filters,Conditional, Transformation andLevel Metricsfor creating complex reports.
• Extensively usedMicroStrategyReport Servicesto generate Report Documents.
• Designed an efficientBI Dashboardfor the Company Executives, through efficient use of MicroStrategyReport Services.
• Converted the previously created web flash dashboards to IPad dashboards with swipe and tap functionality using MicroStrategy Mobile Server.
• DevelopedMicroStrategySchema objectsandApplication objectssuch as Facts, Attributes, Transformations and Hierarchies.
• Responsible for the end Users training for the MicroStrategy Web interface.
• Involved in Implementation of Security layer for MicroStrategy.
• Involved in creating users inMicroStrategyDesktop for testing the reports on the Web interface.

Environment: MicroStrategy 8.1.2 Product Suite (Architect, Desktop, Web, Object Manager) Oracle 10g

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

Environment: MicroStrategy 7.1.0/8.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Informatics Power center, Oracle, Toad, Windows NT.

Confidential

SQL BI Developer

Responsibilities:

• Developed reports and cubes according to analyst defined specifications within the warehouse framework.
• Several reports generated regarding prepaid and postpaid customers, inventory and billings.
• Involved in designing and implementing several forms for each module and Designed user interface screens.
• System incorporates all the user-friendly functionality's like pop-ups, list boxes and other object oriented events.
• Developed the user interface and menus using triggers, functions and procedures. Also took active part in testing.
• Constructed several Normalized database tables with different constraints to maintain integrity. Triggers were implemented on the tables to maintain validity check on the data.
• Constructed several forms in Visual Basic to make it user friendly for the users to add, delete or update information.
• Carried out detailed study of business, data analysis and configuring the materials management module to user specification.

Environment: Windows Server 2003, SQL Server 2005, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.