SUMMARY:

• Around 8 years of total IT experience in software development, designing and implementing Web based and Stand alone software application with major focus on Data Warehousing and Database Applications.
• Extensive experience on MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy 6.X/7.X/8.X, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
• Experience in Performance Monitoring & Tuning for Oracle 9.x and MicroStrategy 8.X.
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the datawarehouse.
• Very strong in developing Proactive Delivery Reports and implementing business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Expert in Creating MicroStrategy Reports, Generic cubes and implementing MicroStrategy projects.
• Extensive work experience with Ad hoc reporting and standard reporting environment.
• Strong hands on experience using TERADATA utilities ( SQL, FastLoad, MultiLoad, OleLoad, FastExport, Queryman / SQL Assistant, etc) and Unix Korn Shell scripting
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Experience in designing ETL process for Data warehousing using ETL tools Informatica PowerCenter and PowerMart 4.6/4.7/5.0
• Experience in Designing and Modeling the Data for Data Warehouse using the different Data Modeling Tools Erwin 4.1.4, Rational Rose and have experience in UML as well.
• Strong knowledge and understanding of SQL and ability to write SQL queries
• Proficient in Analysis, Design and Development of applications using ORACLE, SQL Server, Teradata and MS Access as Backend and VB 5.0/6.0, Developer 2000 as a Front end.
• Well - Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.
• Have good knowledge and experience in Software Quality Assurance tested the web based applications and database application. Hands on experience in writing test Plans and test cases for testing team
• Excellent Analytical, Programming, Written and Verbal Communication Skills. Aptitude for problem solving and making critical decisions on a short time frame.

TECHNICAL SKILLS:

Data Modeling: ERWIN Platinum 4.1.4 OLAP Tools MicroStrategy Suite 6.X/7.X/8.X, Administrator Object ManagerCommand Manager, Enterprise Manager, Intelligence ServerMicroStrategy Architect, Web Narrowcast Server Services, SchedulingSubscription Portal, User Personalization, Business Objects 5.1/4.x/3.x, Ab-Initio 2.8 .

OS: WINDOWS 95/98/NT/2000, U NIX & MAC 7.x

ETL TOOLS: Informatica (PowerMart1.5/1.6/5.1, PowerCenter 1.5/1.6/4.5/5.1 )

Databases: Oracle 7.x/8.0/9.x, MS SQL Server 6.5, Db2, MS Access 97/2000 Teradata V2R6 & Sybase.

IDE Tools: Visual Basic 5.0/6.0, Power Builder & Developer 2000.

Other: Crystal Reports 8.5, Brio query and Data reports.

Reporting Tools: Internet skills HTML, DHTML, XML, ASP 2.0/3.0, JavaScript 1.3 and VBScript

Langages: COBOL, C, Java, SQL, PL/SQL, T-SQL, UML

Web & Application: IIS 5.0/6.0, SMTP, Apache 1.3, BEA Web Logic 6.1

PROFESSIONAL EXPERIENCE:

Confidential

Sr. MicroStrategy Analyst

Responsibilities:

• Identify Source tables and columns required to create a MicroStrategy project.
• Configured reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Created Metrics and filters for the reports.
• Employed MicroStrategy Desktop in designing the MicroStrategy projects. The business rules of the data warehouse were implemented in MicroStrategy Architect.
• 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.
• Designed Components, Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Developed logical models, building hierarchies, attributes and facts, extracting tables from warehouse.
• Created source and target definitions, mappings and transformation rules.
• Transferred the data from a combination of different input files to Oracle using Informatica Power mart.
• Identify Source tables and columns required to create a MicroStrategy project , which references Oracle data warehouse
• Created and scheduled many sequential and concurrent batches to group the sessions to tune at the same time.
• Generated SQL Loader scripts and Shell scripts for automated daily load processes.
• Provided Data Access to executives, managers (Casual users) and Business Analysts (Power Users). Worked as a link between Business and Technical groups.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints. Written complex stored procedures and triggers and optimized for maximum performance

Environment: MicroStrategy 8.1.2, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy SDK, Crystal Reports, Informatica Power Center, TOAD, Oracle 10, Solaris

Confidential, Wood Cliff Lake, NJ

Senior MicroStrategy Analyst

Environment: Microstrategy 8.1.1, Administrator, Architect, Desktop, Web, Report Services Documents, Office, Narrowcast Server, Teradata

Responsibilities:

• Gathering reporting and analytics requirements from the Sales and Marketing team for the data warehouse.
• Analyzed the Sales Reporting Data Warehouse .
• Created scope documentation for the static and ad-hoc reporting environment.
• Creation of Database instance in Microstrategy.
• Creating User and User groups using Microstrategy Administrator.
• Creation of user groups in Microstrategy using User Manager.
• Migration of the projects from Dev to QA and then to Prod Environment using Object Manager
• Created Subscription sets, documents, publications and Personalized Services in process of configuring the Narrowcast application
• Created Facts, Attributes, Transformations, Hierarchies using Microstrategy 8.1.1 Architect
• Created advanced metrics, filters, consolidations and Custom groups using Microstrategy 8.1.1 Desktop.
• Participated in requirements gathering for Enterprise Dynamic Dashboards for executives and created using Microstrategy 8.1.1 Report services.
• Design and development of static and ad-hoc reports using Microstrategy 8.1.1 Desktop.
• Validated end user report requests using Teradata SQL Assistant.
• Participated in performance tuning of the MicroStrategy reports by analyzing the sql .
• Power user training through Microstrategy Web.
• Created Excel dashboards using Microstrategy Office tool.
• Performed Power User training using Microstrategy Web and Desktop.
• Participated in user acceptance testing phases at different levels of the project.

Confidential, Phoenix, AZ

Senior MicroStrategy Analyst

Environment: MicroStrategy 8.1 Administrator, Architect, Desktop, Web, Report Services Documents, Narrowcast Server, Oracle 10i, TOAD 8.0.

Responsibilities:

• Participated in the design/development life cycle process including gathering requirements, user interaction and report design and development along with the ETL team
• Identifying and documenting all the Source tables and columns required to create project in MicroStrategy
• Participated in the meetings for Proof of Concept with Natezza.
• Used Web Customization upgrade utility tool in Microstrategy SDK.
• Adding required tables to the project using Data Warehouse Catalog
• Created Facts, Attributes, Hierarchies and Transformations using Microstrategy 8.1 Architect
• Created Advanced Metrics, Filters, Prompts, Reports and Dashboards using MicroStrategy Desktop 8.1
• Created Enterprise Dynamic Dashboards using Microstrategy 8.1
• Created complex Micro Strategy Documents involving Grids and Graphs
• Created/Modified Users, User groups and Database Instances using Microstrategy Administrator
• Created complex Data marts and enhancing the query performance by creating indexes
• Tuned the VLDB properties to enhance the performance of the reports at project level and report level
• Power User training using Microstrategy Web and support with the Microstrategy Objects and best practices in Reporting
• Participated in the meetings for Extraction, Transformation and Load was performed using Informatica Power Center to build the data warehouse
• Interacting with business users during the UAT process

Confidential, Columbus, OH

Senior MicroStrategy Consultant

Environment: MicroStrategy 8.0.2 Architect, Desktop, Web, Report Services Documents, Teradata v2r6, SQL Queryman 7.1.

Responsibilities:

• Meetings with business users to discuss system and reporting requirements and provided recommendations.
• Preparation of Functional Build Documentation
• Data modeling, logical database design, system architecture during all project implementation phases
• Created Facts, Attributes, Hierarchies and Transformations using Microstrategy 8.0.2 Architect
• Design and development of numerous static and ad-hoc reports using Microstrategy 8.0.2 Desktop, Web and Report Services
• Creating User groups using Microstrategy Administrator.
• Creating Database Instances for Development and Testing Environments in TeraData using Database Instance Manager.
• Providing plan for testing team and participated in Unit Testing
• End user training and power user support and answering user's technical questions
• Successful migration of the project from Development to QA and the Production Environment using Object Manager
• Extraction, Transformation and Load was performed using Data Stage to build the data warehouse

Confidential, Los Angeles, CA

Senior MicroStrategy Developer

Responsibilities:

• Involved in the business interaction with the users and gathered the reports that needed to be exist in the Project.
• Created the technical specification for the reports for the user acceptance.
• Used the Configuration Wizard to configure the Metadata Repository and Setup the Intelligence Server.
• Used MicroStrategy Architect to create Facts, Attributes, Relationships and Hierarchies.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Used MicroStrategy Desktop to generate Advanced Reports.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Worked on the performance tuning of the MicroStrategy reports.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Used MicroStrategy Administrator for accurate information regarding system usage and performance.
• Extraction, Transformation and Load was performed using Informatica PowerCenter to build the data warehouse .
• Designed database schemas for OLAP warehouse databases.
• Created/enhanced catalogs and set user profiles to grant user permissions for querying.
• Validated end user report requests using SQL and MicroStrategy tools.
• Used PL/SQL procedures in different places.
• Created reports in HTML format for easy navigation of data from web browser.

Environment: : MicroStrategy 8.0 Administrator, Desktop, Architect, Web, Intelligence Server, Administrator and Object Manager, Narrowcast Sever, Informatica PowerCenter, Db2, Oracle 9i, Embarcadero Rapid SQL 7.3 , PL/SQL, Teradata, Windows XP Professional, Unix, SMTP, IIS, Erwin 4.1.4

Confidential, Denver, CO

Senior MicroStrategy Developer

Responsibilities:

• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
• Created complex reports using MicroStrategy 7.5.2.
• Created facts, dimensions, and attributes using Microstrategy Architect.
• Created new users and groups and moved report objects under one user, using Object Manager.
• Created metrics, filters, and templates for the reports.
• Generated report for web-based query using MicroStrategy Web.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Worked on the performance tuning of the MicroStrategy reports.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Used MicroStrategy Administrator for accurate information regarding system usage and performance.
• Extraction, Transformation and Load was performed using Informatica PowerCenter to build the data warehouse .
• Designed database schemas for OLAP warehouse databases.
• Created/enhanced catalogs and set user profiles to grant user permissions for querying.
• Validated end user report requests using SQL and MicroStrategy tools.
• Used PL/SQL procedures in different places.
• Created reports in HTML format for easy navigation of data from web browser.

Environment: MicroStrategy 7.5/8.0 Administrator, Desktop, Architect, Web, Intelligence Server, Administrator and Object Manager, Narrowcast Sever, TOAD, Informatica PowerCenter, Oracle 9i, Teradata, SQL Server 2000, PL/SQL, Windows 2000 Server, Unix, SMTP, IIS, Erwin 4.1.4.

Confidential, Hercules, CA

Senior MicroStrategy Developer

Responsibilities:

• Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
• Generated status reports after performing thorough research in order to discuss the issues related to Warehouse tables, Zeroes/Nulls, missing columns and naming conventions etc.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Used project merge wizard and user merge wizard to merge projects and merging users & groups in Object Manager.
• Created Transformations (table based, formula based) for using in comparative reports like sales of various pharmaceutical products this year to last year (year to date and month to date).
• Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment.
• Converted existing interactive reports with prompts to non-prompted reports for Narrow casting.
• Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Exported data from Teradata using FastExport utility.
• Experience in using Teradata utilities such as Fastload, Multiload and FastExport.
• Involved in giving demos/Presentations to end-users and training other developers in MicroStrategy Desktop and Web.
• Involved in creating user groups and security filters for users and assign privileges.

Environment: MicroStrategy 7.5.2, MicroStrategy Agent 7.5.2,MicroStrategy Intelligence Server7.5.2, MicroStrategy Web 7.5.2, MicroStrategy Narrowcast Server 7.5.2, MicroStrategy SDK 7.5.2, Teradata, SQL, FastLoad, MultiLoad, FastExport, TPump, Visual Explain , Crystal Reports, ERWIN 4.1.4, Db2, Oracle 8i, Windows 2000 Server, Toad 8.5.

Confidential, Atlanta, GA

MicroStrategy Consultant

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.
• 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 Back ups 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 .
• Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
• Used Report cache sharing and Data mart reports to enhance the Report response time.

Environment: MicroStrategy 7i (Desktop, Administrator, Intelligence Server, Web), MicroStrategy Architect 7i, MicroStrategy Agent 7i, MicroStrategy Object Manager 7i, Teradata V2R3, SQL Server, Windows NT