SUMMARY:

• Around 12 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 7.X/8.X/9.X/10.X/11, Distribution Services, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MDX Adapter, Office, MicroStrategy Intelligence Server and MicroStrategy Architect.
• Experience in Performance Monitoring & Tuning for YellowBrick, BIG DATA, Netezza, DB2, Oracle 10.x and MicroStrategy 7.X/8.X/9.X/10.X.
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• 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
• 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:

MicroStrategy Certified: OLAP Tools MicroStrategy Suite 7.X/8.X/9.X/10.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

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: Big Data, Netezza, DB2, Oracle 7.x/8.0/9.x/10.X, MS SQL Server

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

Other: Tableu, 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 Architect.

Responsibilities:

• Currently supporting the migration of Netezza database to Yellowbrick database and validate all the reports.
• Currently working on upgrading MSTR version v10.4 to V11.
• Interacted with Business Analysts, Business Users and Managers for g athering, analyzing, documenting business requirements, and functional requirements and data specifications .
• Created Functional Requirement Document (FRD) and technical specifications for creating reports.
• Involved in installation and configuration of MicroStrategy 10.4.
• Involved in creation of Aggregate tables to improve performance of reports.
• Used MicroStrategy Architect to create Facts, Attributes, Relationships, Dimensions and Hierarchies.
• Involved in creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the MicroStrategy objects necessary for the deliverable.
• Created transformational metrics (Volume and Counts) to compare monthly, quarterly and annual sales .
• Extensively worked in developing Metrics, Derived Metrics, Compound Metrics and Filters for complex reports.
• Creating advanced Metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Involved in troubleshooting MicroStrategy Reports, optimizing SQL using the VLDB Properties.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Created Dashboards in both the interactive & flash mode for Executive Mangers and Directors using Report Services.
• Extensively worked on creating Report Services documents using multiple grids and graphs.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies .
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Involved in the creation of Adhoc and static Reports.
• Involved in security setup and maintenance at all levels within the MicroStrategy tool.
• Involved in optimization of code and tuning queries for performance.
• Involved in managing and migrating objects across multiple environments using Object manager.
• Involved in analyzing BI usage patterns and developed performance tuning strategies to deliver the highest BI satisfaction using Enterprise manager.
• Involved in creating Security filters to end users to access data based on their privileges.
• Provided post production support to end-users.

Environment: Netezza, DB2, Microstrategy 10.4 Product Suite (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Web, Distribution Services), Fusion Charts, Oracle 10 for MSTR Metadata, Windows NT.

Confidential

MicroStrategy Architect.

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers for g athering, analyzing, documenting business requirements, and functional requirements and data specifications .
• Created Functional Requirement Document (FRD) and technical specifications for creating reports.
• Involved in installation and configuration of MicroStrategy 9.0.1.
• Created Star schema to develop the data mart in the data warehouse.
• Involved in creation of Aggregate tables to improve performance of reports.
• Used MicroStrategy Architect to create Facts, Attributes, Relationships, Dimensions and Hierarchies.
• Involved in creating Schema Objects (facts, attributes, hierarchies, Transformations) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the MicroStrategy objects necessary for the deliverable.
• Created transformational metrics (Sales, Sales Target, Market Share, and Growth) to compare monthly, quarterly and annual sales .
• Extensively worked in developing Metrics, Derived Metrics, Compound Metrics and Filters for complex reports.
• Creating advanced Metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Involved in troubleshooting MicroStrategy Reports, optimizing SQL using the VLDB Properties.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Created Dashboards in both the interactive & flash mode for Executive Mangers and Directors using Report Services.
• Extensively worked on creating Report Services documents using multiple grids and graphs.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies .
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Involved in the creation of Adhoc and static Reports.
• Involved in security setup and maintenance at all levels within the MicroStrategy tool.
• Involved in partitioning the tables, indexes and management of the schema objects.
• Involved in optimization of code and tuning queries for performance.
• Involved in managing and migrating objects across multiple environments using Object manager.
• Involved in analyzing BI usage patterns and developed performance tuning strategies to deliver the highest BI satisfaction using Enterprise manager.
• Involved in creating Security filters to end users to access data based on their privileges.
• Provided post production support to end-users.

Environment: Oracle 10, Microstrategy 9.0.1 Product Suite (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Web, Distribution Services), SAS, Windows NT.

Confidential, Wood Cliff Lake, NJ

Sr. Microstrategy Report Developer

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.

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

Confidential

Senior MicroStrategy Lead Consultant

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