PROFESSIONAL SUMMARY:

• Created Custom Documents in MicroStrategy Reports to combine the Data sets of multiple reports and also created custom Dash Boards using XSL, HTML, and DHTML.
• Created Data Mart Reports using Complex Filters and Compound Metrics.
• Created complex Reports in MicroStrategy using Templates, Filters, Prompts, Consolidations and Custom Groups.
• Created various Schema objects using MicroStrategy Desktop like simple and compound Facts and Attributes, Custom Hierarchies.
• Worked extensively on Dashboards in MicroStrategy Product suite 9.2.1/9.4.1
• Worked extensively on MicroStrategy Desktop, Narrowcast Server, Intelligence Server, and Web. Also, have a good familiarity with MicroStrategy SDK.
• Involved in Analysis, Design, Development and implementation of Business Intelligence and maintaining applications using MicroStrategy DSS Tool suite.
• Advanced Certification of Administrating, Reporting design and Architecture, Dashboards and Scorecards and engineering in MicroStrategy version 8 x/9.2.1
• Proficient using TOAD, Queryman WinSQL for system testing of the reports.
• Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server.
• Expertise in Database development skills using SQL, PL/SQL, Pro C, stored procedures, stored functions, packages, and triggers.
• Created and configured the Enterprise Manager for Statistical Reporting purposes.
• Over 8 years of strong experience using Business Intelligence suites including MicroStrategy Suite Intelligence Server, Administrator, Architect, Desktop, MDX Adapter/MSTR Office/ OLAP Provider, Web, Narrowcast Server , Business Objects, SSRS, Oracle XML publisher and SAP BW.
• Used SQL Server DTS Data Transformation Services to create packages with transformations mappings.
• Used ERwin to generate logical Physical models of the Datawarehouse Structures.
• Very good experience with web based applications using ASP, HTML, DHTML, XSL and XML.

SKILLS

PROFESSIONAL EXPERIENCE

BI Solutions Architect

Confidential

• Demonstrated ability to develop BI Roadmap, with success for given projects by prioritization of Corelogic Tax Business Intelligence.
• Proficient requirements analysis, design, and technical delivery of critical business reports, dashboards, and analytical tools using MicroStrategy 9.2 against a Teradata data warehouse and other data sources like oracle, SQL server and IBM DB2.
• Interfaced with Sr. Management as necessary, providing reports, presentations, and recommendations covering the operational aspects of the BI system. Identifying risks and system needs, defining solutions and appropriate standards, establishing standards and procedures
• Demonstrated ability to prioritize IT Projects, organize tasks and delegate assignments to teams. Provided technical leadership to the team.
• Extensively worked in DCM Data Center Migration project as a single POC and SME for MicroStrategy Administration that includes Intelligence Server Administration, Installation and configuration on Red hat Linux Servers, Performance Monitoring, Assigning Privileges and Job Monitoring, Memory Settings etc.
• Proven technical, administrative and developer experience in Data Warehousing, Analytics, Reporting Portal and Dashboard development and Scorecard methodologies.
• Professional level understanding of performance impacts of report design choices, and help implement MicroStrategy best practices across the reporting environment.
• Performing problem assessment, resolution and documentation for new and existing report objects using MicroStrategy Schema Modelling for many complex projects.
• Architectural and functional understanding of Business Intelligence information architecture, master data, data modeling and dimensions providing recommendations for standards on achieving maximum performance and efficiency of BI DW ecosystem.
• Delivered several proof of concepts and demo's to Business users providing a clear and precise understanding of the product.
• Demonstrated ability to manage BI initiatives in progress within the identified project priorities consistent with the company's vision to deliver reliable and highly available applications.
• Business Intelligence best practices implemented while producing effective BI applications across Business Units using BI Tools like MicroStrategy, Business objects, SSRS and Oracle XML publisher.
• Developed UNIX scripts for automating BI process, MicroStrategy/BO dashboard/reports refreshed based on ETL informatica loads completion cycles.
• Hands on working knowledge of MicroStrategy newer products like Suite 9.0.2 dynamic sourcing, intelligent cubes and interactive dashboards/scorecards.
• Involved in migration of 60 business objects reports and documents to MicroStrategy environment.
• Hands on working experience with Business Objects administration, Business Object components, including but not limited to Business Objects 6.x, Web Intelligence, Crystal reports, Auditor, Supervisor, Administration Console etc.
• Administering the large-scale MicroStrategy projects and providing production support in the environment including monitoring system usage, job scheduling, and user security monitoring and cache validity improving the overall reporting user experience.
• Good understanding of SSIS and control flows elements and containers that are executed when a package runs.
• Expertise using SSRS in creating interactive, tabular, graphical, and free-form reports from relational, multidimensional, or XML-based data sources.'
• Good working knowledge of informatica ETL process like mapping, workflows, sessions, triggers and batch processing.
• Applied SDK techniques using configuration files for visualizations and customizations like adding custom logo's, redesigning page-layouts and changing the overall outlook of the BI Web pages.
• Proactively Involved in the evaluation and selection of Enterprise Data warehouse application solutions like Neteeza, Oracle, HP and Teradata.
• Entailed writing extensive SQL scripts to transform source data according to the business requirements and compare column by column to target tables loaded.
• Integration of several BI administration functions CTRL M batch processing.
• Timely reporting deliveries were scheduled, managed and monitored through NarrowCast applications.

Environment: MicroStrategy 9.4.1/9.2.1/9.0/8.0.1/8.1.1, Business Objects 6.5, Narrowcast Administrator 9.2.1/9.0/8.1.1/8.0.1, Informatica Power Center 8.6, Neteeza, QlikView, Teradata V12.0, SSRS, Business Objects 6.5, SQL Server 2005, Oracle 10g, DB2 iSeries/ zSeries Mainframe.

Business Intelligence consultant

Confidential

• Understanding the source system and interacting with users to get the elaborate report requirements.
• Implemented complex retail business logic using composite techniques in MicroStrategy Desktop 8.1.1
• Developed State of the art dashboards for retail sales reporting, managing and monitoring business performance
• Extensively worked on MicroStrategy Mobile delivering dynamic reports.
• Proactively involved in delivering High priority reports through e-mail, file servers and portals using MicroStrategy NarrowCast Server 8.1.1.
• Produced speed-of-thought analytics with MicroStrategy OLAP services
• Superior expertise in building BI reports and Interactive dashboards with enterprise wide key performance indicators KPI , providing simple yet user intuitive layouts with effective drill down capabilities.
• Developed Interactive scorecards and dashboards providing business users with highly intuitive interface.
• Designed Documents, created Hyperlinks, Grouping, Sorting, Drilling and Advanced Metric Calculation for pixel perfect layout documents.
• MicroStrategy development of the project with emphasis on Dashboarding using latest report services 8.1.1
• Used Auto Prompts filter nested Prompting feature to give the end-user a choice of different filtering criteria each time they run the report.
• Customizing SQL statements using advanced freeform SQL.
• Created more than 50 reports for ad-hoc analysis using Prompts, Filters, Advanced filters Custom Groups and Consolidations.
• Created complex metrics like Transformation metrics for periodic analysis like YTD, MTD etc and used conditional metrics for complex reports.

Environment: MicroStrategy 8.0.1 -- 8.1.1, Narrowcast Administrator 8.1.1, Netezza v6 , Oracle BI XML Publisher, IBM Datastage

Lead MicroStrategy Consultant Architect/Report Developer/Administrator

Confidential

• Working with developers offshore ensuring a superior deliverables every release.
• Created 4 new MicroStrategy Projects which includes importing tables from various data sources and a creating Attributes and relationships for different dimensions and created facts for the billing an d Financial projects.
• Heavily worked on the MicroStrategy Project schema on data modeling related issues like how to handle many to many relationships and resolved the issue by proposing the right data model .
• Created a proof of concept for the end users at billing Finance to display the capabilities of dynamic dashboards and scorecards using MicroStrategy 8.1.
• Created more than 60 reports for ad-hoc analysis using Prompts, Filters, Advanced filters Custom Groups and Consolidations.
• Created complex metrics like Transformation metrics for periodic analysis like YTD, MTD etc and used conditional metrics for complex reports.
• Used Advanced Subtotal features for complex aggregations at various report levels.
• Used VLDB properties to optimize the SQL generation of the MicroStrategy reports for performance.
• Extensively worked on troubleshooting SQL for several complex reports.
• Created and configured the Metadata layer
• Narrowcasting batch process and automate deliver pixel-perfect quality reports/documents using dynamic/static subscriptions.
• Authentication Integration of LDAP server with MicroStrategy
• Verifying, auditing, and updating licenses. MSTR License check conducted 24hrs a day and summary sheet posted monthly, Optimizing request response time using advanced caching,Enterprise portal integration evaluation
• Integration of several MicroStrategy administration functions Autosys batch processing
• Customizing SQL statements using advanced freeform SQL.

Environment: MicroStrategy 8.0.2 -- 8.1, Narrowcast Administrator 8.1, Oracle 9i RAC, Teradata V2R5, Informatica 7.1.4, Internet Explorer IE 5.50, IIS, Windows XP Professional, Windows NT, Windows Server 2000, MS Office, Oracle 10g, ERwin 4.1, Visio 2002 10.1

SR BUSINESS INTELLIGENCE CONSULTANT

Confidential

• Implementing data warehousing concepts including dimensional and relational modeling like star and snowflake Models.
• Clear and precise documentation for Business and Logical Dimensional Modeling for better understanding of the overall structure
• Prepared a comprehensive Source to Target mapping for all the concerned individual MSTR objects to be included in the project.
• Created MicroStrategy Projects Schema for the Global Operations reporting System which includes creation of new Attributes, Facts, and Hierarchies.
• Build Complex Hierarchies many to many relationships and model real world analysis elements and relationships
• Designed Documents, created Hyperlinks, Grouping, Sorting, Drilling and Advanced Metric Calculation for pixel perfect layout documents.
• MicroStrategy development of the project with emphasis on Dashboarding using latest report services 8.1
• Installed and Configured MicroStrategy NarrowCast as an Information Delivery Platform and automated timely report alerts to the concerned end users using services and subscription sets.
• Advanced Analysis performed using all the five styles of BI on a unified user interface.
• Created Logical Views, Fact Extensions, Custom Groups, Transformations and Complex prompts. Etc
• Designed Documents, created Hyperlinks, Grouping and sorting datasets with grid and graph views in Enterprise Reports.
• Created Filter objects including security filters, Reports complex, Ad hoc, Parameter-driven, personalized, indicator, Set analysis, What-if analysis, Data-mining, Data mart reports .
• Provided Data Access to executives, managers end users and Business Analysts Power Users .

Environment: MicroStrategy Desktop 8. 1 / 8.0.2/, MicroStrategy Intelligence Server 7i, MicroStrategy Administration 7i, MicroStrategy Web 7i, Internet Explorer IE 5.50, IIS, Windows XP Professional, Windows NT, Windows Server 2000, MS Office, Oracle 10g, ERwin 4.1, Visio 2002 10.1

DATABASE ARCHITECT/ BUSINESS INTELLIGENCE ANALYST

Confidential

Responsibilities:

• Developed Design and Analysis Documents for the reporting applications like business objects, crystal reporting.
• Developed Logical and Physical reporting elements for new reports, adhering to current methods and standards
• Created Business Objects Filters, Variables, Prompts, Drill Maps, Transformations, Documents, Facts, Attributes, and Hierarchies etc. for developing project.
• Involved in migration from Crystal 7.0 to 10
• Extensively worked on crash recovery and backup restore of database
• Scheduled backups of databases
• Responsible for maintaining database schema, creation of DB install scripts
• Created Filter objects including security filters, Reports complex, Ad hoc, Parameter-driven, personalized, indicator, Set analysis, What-if analysis, Data-mining, Data mart reports .
• Developed BO schema objects, application objects, delivery objects including Metrics, Metric properties dimensionality, filter, transformation ,
• Created new Facts, Attributes and attribute form expressions and Hierarchies as needed in the project.
• Supported Web Intelligence to offer interactive reporting to the end users through a web browser.
• Employed Business Objects Desktop in designing the BO Cube reports giving an analytical view of business data. The business rules of the data warehouse were implemented in BO Designer.
• Managing development DB servers, testing DB servers, demo DB servers, replication of data among servers
• Preparing database for test purpose by populating required test case data
• Responsible for defining appropriate database structure
• Responsible for verifying ER and appropriate normalization of designs made by designers
• Authority to approve or reject database design in the interest of product
• Developing, Performance tuning of database queries

Environment: Oracle 7i, BO 6.5, Developer 2000, PL/SQL, Windows NT.