SUMMARY

• 7 years of rigorous IT experience, leveraging expertise in Data Warehousing, Data Modeling, ETL and BI (MicroStrategy, Crystal Reports) tools.
• Over 5 years of strong experience using MicroStrategy Suite (Intelligence Server, Administrator, Desktop, Web, Enterprise Manager, Object Manager, Narrowcast Server, Report Services, Dashboards)
• Strong experience with full Software Development Life Cycle(SDLC) which includes Requirement Analysis, Design, Development, Implementation, Testing, Deployment, production Support and Maintenance, Built and Release management.
• Gathered and documented business requirements for existing and future business systems.
• Experience in creating MicroStrategy documents, reports, dashboards for various business environments.
• Expertise in Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Expertise in Developing User Objects (filters, metrics, prompts, Custom Groups, Consolidations, Searches) to develop Documents and reports.
• Involved in Business Users on MicroStrategy OLAP Services (such as view filter and derived metric).
• Expertise in creating interactive Dynamic dashboard Reports and Scorecards to view personalized reports based on user requirements.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets) and Business solutions on web, wireless devices.
• In depth technical background with Databases like Teradata, Oracle, SQL Server, DB2 and Natezza.
• Experience in Data modeling techniques like star and snowflake schemas using Erwin tool.
• Good Knowledge on data extraction and transformation (ETL) process and had exposure on tools like Data Stage, Informatica Power Center 7.0
• Experience in Converting Legacy reports into MicroStrategy reports and working in offshore - onsite environment.
• Worked with Logical and physical modeling along with design and implementation.
• Strong SQL skills (including use of unions, multi-table joins, functions, outer joins, derived columns).
• Excellence in coordinating with Database Management team, End users, Business Analysts in understanding their requirements, assisting and providing technical solution and knowledge.
• Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS

OLAP / BI Tools: MicroStrategy Desktop 9.0.1/ 9.0/8.1. x/7.5/7i/7.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services, Microsoft OLAP Manager, Microsoft Excel, Crystal Reports.

ETL Tools: Informatica Power Center 7.1.1 (Designer, Repository Manager, Server Manager), Ascential DataStage 7.0/6.0.

Databases: Oracle 11g/10g/9i/8.0/7.x, Teradata V2R6 and V2R5, IBM DB2, Netezza, SQL Server 2005, Sybase IQ, MS Access 7.0.

Programming: SQL, PL/SQL, Visual Basic 6.0/5.0, HTML, XML, C, C++, JAVA and Unix Shell Scripting.

Operating Systems: Microsoft Windows 95/98/00/NT/XP, UNIX, LINUX, MS DOS.

Other Tools: CA Erwin, Oracle SQL * Loader, TOAD, WIN SQL, SQL*Plus.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

MicroStrategy Developer

Responsibilities:

• Involved in interacting with the users and gathering the requirements and analyzed the needs of the end users.
• Understanding the MicroStrategy Reporting environment of the organization.
• Extensively involved in designing the data model with data model designer according to the changing dimensions in the project as client is changing Database from Oracle to Sql Server.
• Understanding the Datamodel and identifying the tables to be used for reports.
• Involved in Upgrade MicroStrategy environment from 8.1.2 to 9.0.1.
• Created public objects (Reports, Filters, Drill Maps, Metrics, Templates).
• Created schema objects (Attributes, Facts, Tables, and Hierarchies).
• Developed report services documents and Executive dashboards for higher level Management (Senior Vice President/Vice President).
• Involved in creation of Datamart Reports, Partition Mappings and Aggregate tables to improve performance of MicroStrategy reports
• Clustered I- servers and created a remote cache location for performance improvement.
• Triggered both static and dynamic subscriptions using narrowcast server.
• Created dash boards which evaluates and compares data for Current and Prior months, quarters, years for leaders and regions and made available in Interactive mode, Flash mode and PDF mode.
• Worked on Converting reports from Oblicore reporting to Microstrategy Reports.
• Used MicroStrategy Command Manager to create scripts for creating users, groups, setting user options and authentication modes, clearing caches, dropping connections, generating user lists etc.
• Worked with back end Database Administrators to provide requirements for necessary back end tables.
• Organized MicroStrategy sessions to educate the business users on MicroStartegy Web.
• Used Object Manager to migrate objects from DEV to QA and QA to PROD Environments.
• Created and maintained Narrowcast services to deliver reports to users.
• Involved in designing Templates to generate reports in grid and graph mode and used filters with Auto prompt feature to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Involved in production support (24/7) and coordinating with Offshore Team.
• Maintained a stable platform by proactively identifying and resolving any issues or bugs.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals

Environment: MicroStrategy 9.0.1/9.0 (Administrator, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Command Manager, Integrity Manager), Informatica 8.6.1, Teradata,Oblicore, SQL Server 2005.

Confidential, Columbus, OH

MicroStrategy Developer

Responsibilities:

• Involved in interacting with the users and gathering the requirements and analyzed the needs of the end users.
• Understanding the MicroStrategy Reporting environment of the organization.
• Extensively involved in designing the data model with data model designer according to the changing dimensions in the project.
• Understanding the Datamodel and identifying the tables to be used for reports.
• Created Attributes, Facts, Transformations and Hierarchies using the MicroStrategy Architect.
• Extensively worked in developing Metrics, Filters, Prompts, Consolidations, Custom Groups and Drill maps for reports.
• Used MicroStrategy Command Manager to create scripts for creating users, groups, setting user options and authentication modes, clearing caches, dropping connections, generating user lists etc.
• Involved in creation of Datamart Reports, Partition Mappings and Aggregate tables to improve performance of MicroStrategy reports
• Developed report services documents and dashboards and formatted the reports.
• Clustered I- servers and created a remote cache location for performance improvement.
• Set-up the narrowcast environment and created services using subscription sets, schedules, Information objects.
• Used Object Manager to migrate objects from DEV to QA and QA to PROD Environments.
• Created and maintained Narrowcast services to deliver reports to users.
• Invovled in UAT Testing to validate the data using SQL queries against the data warehouse.
• Involved in production support (24/7).
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals

Environment: MicroStrategy 9.0/8.1.x (Administrator, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Command Manager, Integrity Manager),Cognos, Informatica, Teradata,Oracle11g, SQL Server 2005.

Confidential, Katy, TX

MicroStrategy Consultant

Responsibilities:

• Worked with client to gather requirements and prepared technical specification Documents.
• Understanding the reporting requirements and developed the reports and rebuilded the legacy reports in MicroStrategy.
• Developed MicroStrategy Schema objects like Attributes, Facts, and Hierarchies Application objects like Metrics, Templates, Filters, Prompts, Consolidations, Custom Groups and Project objects like Subtotals.
• Designed Reports, Documents and Dynamic Dashboards using Desktop and Report Services 8.1.1.
• Developed Report Service Pixel perfect Documents using MicroStrategy 8.1.1 with multiple grids and graphs and formatted the documents.
• Involved in optimization of code and tuning queries for performance.
• Created users, roles, privileges and groups and assigned access to the MicroStrategy projects.
• Involved in setting Report caches, Object Caches and Element Caches at Intelligence server to improve performance of the report.
• Production Support has been done for ongoing issues and trouble shooted the issues to identify the bugs.
• Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries)
• Provided post production support to end-users.

Environment: MicroStrategy 8.1.x (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata V2R5, Oracle 10g/9i, SQL Server 2005, TOAD 7.2, SQL, Informatica 7.1.1, IBM DB2, XML, HTML

Confidential, Atlanta, GA

MicroStrategy Developer and Administrator

Responsibilities:

• Involved in the complete Life cycle of the Project.
• Gathered and documented business requirements and making of mock reports in Microsoft Excel by understanding the clients reporting requirements.
• Worked with database analysts to identify Entities, Relationships and Cardinality of relationships, attributes and tables.
• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Various types of prompts were created to give the users more flexibility to run ad hoc reports, which included object prompts, value prompts and nested prompts.
• Designed and developedtemplates for ad-hoc reporting.
• Involved in differentadministration taskssuch ascreating users, security rolesand assigning differentaccess rights to the users.
• Used Advanced Prompts, Non- Aggregately Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports
• Implemented MicroStrategy Narrowcast Server to send personalized business intelligence information and report via email, web and wireless devices.
• Customization of web to change the user interface using MicroStrategy SDK.
• Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
• Created transformations using transformation by tables for YTD, MTD and MTY analysis.
• Developed dashboards/ scorecards for quick and easy monitoring by higher level management.

Environment: MicroStrategy 7.2.3/7.5 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Teradata V2R5, Oracle 9i, SQL Server 7.0/2005, TOAD 7.2, Informatica 7.1.1, IBM DB2, XML, HTML

Confidential, St Louis, MO

MicroStrategy Architect/Developer

Responsibilities:

• Responsible for gathering and refining business requirements from the business users.
• Developed Multidimensional Model (Logical Model) by studying the source systems and business requirements.
• Implemented different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Involved in creating the Attributes, Facts, Transformations and Hierarchies.
• Responsible for creating Metrics, Filters, Custom Groups, Prompts using MicroStrategy Desktop and Web.
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Exploited the use of Analytical Engine bypass functions like Apply Simple & Apply Comparison effectively whenever necessary.
• Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, and week to year and effectively used them with the metrics.
• Optimized Query Performance by using VLDB settings.
• Configured the Intelligence Server and pointed the database instances in both development & Production environments.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Environment: MicroStrategy Desktop 7.5, MicroStrategy Intelligence Server 7.5, MicroStrategy Web 7.5, Informatica, IBM DB2.

Confidential, OH

Crystal Reports Consultant

Responsibilities:

• Analyzed Reporting requirements elicited from meetings held with business users and formulated Crystal Reports.
• Responsible for developing reports in accounting,, Conflicts, Merchandising, Execute, Purchase Order, Inventory,Finance,Loss Prevention, claim processing, supply chain, DC Operations(Distribution Center), Pricing, Sales Audit, Allocation.
• Created different type of reports like List Reports, Cross Tab Reports, Master / Detail and Charts, used filters, conditions, calculated columns.
• Designed various types of reports with Complex Formulas, Custom Functions, SQL Expressions, Multiple parameters (includes Dynamic), Drill Down and Sub Reports.
• Worked with SQL*Plus and TOAD to create and modify stored procedures and for writing queries on Oracle Database.
• Published and scheduled reports in Crystal Enterprise 10.0 using Crystal Management Console and Crystal Publishing Wizard.
• Rectified the defects that were logged into Mercury Quality Center9.0 and made necessary changes to the reports.
• Converted existing DB2 reports into RMS (Oracle database).

Environment: Windows XP, Crystal Report 10/XI, Crystal Enterprise 10, Oracle 10g/9i, TOAD, SQL,PL/SQL, WINSQL, and Mercury Quality Center 9.0

Confidential

Database Administrator/ Database Developer/ MicroStrategy Developer

Responsibilities:

• Created database for production environment In Oracle.
• Interacted with the Business Management Solutions team on a Data Warehousing project involving MicroStrategy implementation on Oracle database on NT platform. Involved in Full Life Cycle Development (FLCD) of the Project.
• Created users, roles and privileges on the Oracle databases.
• Created user groups, roles, privileges using Business Objects Supervisor.
• Created and configured database for development and production environments in SQL Server.
• Developed stored procedures and database triggers using PL/SQL.
• Monitor & tune SQL scripts. Creating upgrade scripts for production Database and supporting it.
• Performance monitoring and tuning of SQL servers
• Involved in evaluating and selecting all technology components such as software, hardware and networking capabilities for database management systems and applications.

Environment: Business Objects, SQL Server 2000, Developer 2000, SQL* Plus, PL/SQL Oracle 7i, Windows, UNIX and Windows NT 4.0