SUMMARY

• Over 7+ Years of extensive work experience in the field of Information Technology implementing Business Intelligence, Data warehousing and Decision Support Systems.
• Extensively worked in developing DW applications using MicroStrategyDesktop, Web, Administrator, Narrowcast Server, Intelligence Server. Also have a good familiarity with MicroStrategy SDK.
• 2+ Yrs of extensive experience in Tableau Desktop, Tableau Server in various version of tableau including Tableau 7 x and Tableau 8x
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
• Created complex Reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
• Experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
• Experience with creating the Tableau dashboards with relational and multi - dimensional databases including SQL, MS Access, and SAP BW Adept at gathering and manipulating data from various sources
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Experience in Data Modeling using ERWIN3.x/4.0, Data mart and OLAP for business analysis using star&snowflake schemas, for faster and effective querying.
• Experience with integratingMicroStrategywith heterogeneous data sources and the implementation of dynamic-sourcing.
• Decent Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages and triggers
• Very good experience in working with very large databases on Oracle, Teradata, SQL Server, DB2 with Micro strategy Suite. Strong SQL skills in a Netezza and SQL server Environment.
• Using Intelligent Cubes to access reports ofall of the OLAP Services features for analysis and reporting purposes.
• Creating and publishing Intelligent cubes for use as a shared data source for the users to build reports from. Intelligent Cubes provide the fast response time and analytic calculations that are often associated with Multidimensional Online Analytic Processing (MOLAP) cubes, while also benefiting from the ability to use Relational Online Analytic Processing (ROLAP)

TECHNICAL SKILLS

Business Intelligence/OLAP: MicroStrategy 9.2.1/9.0.2/8.1.2/8.1.1/8.0.2/ (MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Tableau8.0/7.0/6.0, Business Objects, Microsoft Excel

Database: Teradata/SQL Server-2000/2005,ORACLE 10g/9i/8i, Netezza, MS-Access

Tools: Crystal Report, Microsoft-Office, Microsoft Visio, N Unit, I Rise

ETL Tools: Informatica8.1/7.1/6.2,Ab Initio

Data Modeling: ERWIN Platinum4.1.4, Enterprise Architecture, Microsoft VISIO

Programming Languages: C, C++, Java, JavaScript, Jsp, Ajax, Visual Basic6.0, PL/SQL

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2005 Server, UNIX

Others: HTML4.0,DHTML,XML,LDAP,VBScript,JavaScript,MS Office, Macromedia Dreamweaver, Macromedia Fireworks, Macromedia Flash, Microsoft FrontPage

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. MicroStrategy / Tableau Developer

Responsibilities:

• Analyzed the business requirements, identifying the requirements, reviewing and communicating with business and getting sign offs from business.
• Created Metadata Repository and Statistical tables in the data warehouse using the Configuration Wizard.
• Used MicroStrategy Project Builder in creating different Reports to meet the in-house Business Requirements.
• Worked with MicroStrategy Architect to build Attributes, Facts and Dimensions and developed perfect logical models for reporting environment.
• Configured reports for end users in Desktop, MicroStrategy Web, and Narrowcast Server.
• Generated and implemented advanced MicroStrategy Reports concepts by creating projects, attributes, hierarchies, facts, metrics, filters, and templates.
• Assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
• Extensively used filters, facts, consolidations, transformations and custom groups to generate reports for Business analysis.
• UsedTableauDesktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• UsingTableauDesktop created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues withinTableauServer and Reports
• Gone through various levels of dimensionalities to execute the reports with different result sets.
• Extensively used report services to create dashboards.
• Have created Dashboards in both the interactive & flash mode.
• Have used several Widgets for Dashboard reporting.
• Created Transformations for using in comparative reports like sales this year to sales last year.
• Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect.
• Performed administrator tasks during absence of MicroStrategy administrator.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Involved in troubleshooting MicroStrategy Web Reports and optimizing the SQL using the VLDB properties.

Environment: MicroStrategy 9.4.1, 9.3.1, (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Tableau 8/7, Teradata V2R6, ORACLE 10g, DB2, Windows 2003.

Confidential, Warren, NJ

Tableau Developer

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Involved in architecting the schema objects Attributes, Facts, Hierarchies.
• Involved in the development of Data Models (physical/logical) using Erwin tool as KBB data and reporting requirements are completely different from the existing scenario.
• Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.
• Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.
• Involved in Installation and configuration of Tableau Software. Have also configured distributed installation of Worker Servers for production environment.
• Created Users, groups and Domains from Active directory and created different License level for each User on Tableau Servers.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.
• Assisted the team in integrating the current project with new Enterprise analytics.
• Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
• Involved in development interactive dashboards and scorecards for high level management.
• Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.
• Assisted the team in identifying the errors in the underlying data.
• Customized reports using Custom Groups and Consolidations.
• Designed Compound metrics and Complex filters and Time filters.
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Configured Data Marts in Microstrategy Desktop to update tables in database.
• Optimized query performance by updating VLDB properties at project level and report level.
• Performed optimizations using Report Data Options.
• Used Microstrategy Web to offer interactive reporting to the end users through a web browser
• Extensively used Microstrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Unit tested the reports developed by the other developers.

Environment: Microstrategy 9.2.1, Tableau 7, Architect, Web Intelligence, Object Manager, Integrity manager, Configuration Wizard, Informatica 9, Report Studio 8,Netezza 5.0, Windows NT and UNIX.

Confidential, San Francisco, CA

MicroStrategy Developer

Roles & Responsibilities

• Design and development of new MicroStrategy Reports for the new Retail BI system- created Schema objects / Application objects as well as configuration objects in Test environment.
• As MicroStrategy Architect Involved in building schema objects to supported business process change or enhancements throughout projects.
• Handling Daily user issues - Setting up and maintaining MicroStrategy web user roles and ps, helped in resolving daily issues in running Reports and Data Integrity issues.
• Created advanced metrics (simple, nested & compound), advanced filters, advanced prompts, report designs and drill maps.
• Delivered personalized reports from MicroStrategy project to subscribers using MicroStrategy Narrowcast Server.
• Analyzed Business Requirements and interacted with the Business Analysts for designing ad-hoc reports.
• Developed various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts and Filters etc.
• Provided access to the Datawarehouse to a much larger audience by using Narrowcast Server.
• Personalized the report delivery as per user requirements.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated reports like forecasting.
• Created Complex filters with advanced qualifications involving the ‘Apply’ functions.
• Worked on MicroStrategy Intelligence server and MicroStrategy Webserver in production and development environments for performance tuning.

Environment: MicroStrategy Architect 9, MicroStrategy Desktop 9, MicroStrategy Web 9, MicroStrategy Intelligence Server, MicroStrategy Report Services, Teradata.

Confidential, Dallas, TX

MicroStrategy consultant

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Communicate business user requirements and provide clarifications as needed.
• Speed up project loading process by increasing/extending the size of element and object caches.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Experienced administrative capabilities, Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Custom Groups and Consolidations.
• Developed Documents to show prompted Grid and Graph modes of reports for users working with MicroStrategy Desktop interface.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Managing schema objects and application objects across the project by using Object Manager.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of Enterprise Reports.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: MicroStrategy Desktop8.0.0, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, SQL Server 2005 and Windows Server 2000.

Confidential, MI

MicroStrategy consultant

Responsibilities:

• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Create connection maps to map users to different homogeneous databases or table spaces in a single project to direct end users against production and power users against development database.
• Designed, Developed and altered html document objects by placing multiple reports on it in Grid as well as Graph View applying XSL formatting for each in the process of automating IT Dashboard reports.
• Project duplication within and in between different project sources of Prod, Dev and UAT environments.
• Installed and configured complete MicroStrategy product suite on Prod, Dev and RE&I Lab environments.
• Personalize the end user experience at report runtime by providing flexibility with reusable prompts/report parameters
• Validate, Detect and Repair logical/physical inconsistencies and corruptions of MicroStrategy metadata by running Scan MD/MD Doctor utilities.
• Actively involved in the Implementation of Novell LDAP authentication for MicroStrategy Products.
• Extensively used Object Manager, Project Merge and User Merge utilities to manage MicroStrategy Tier 1/ High Impact applications and objects.
• Responsible for creating the MicroStrategy DB instances, DB connections, DB logins and ODBC DSNs.
• Actively involved in the full life cycle of Migration process from MicroStrategyv7.2.3 to MicroStrategyV7.5.1
• Actively participated in the proof of concept for the MicroSrategyv8.01 upgrade.

Environment: MicroStrategy tool suit 7.2.3/7.5.1/8.0 , MicroStrategy Office 7.5.1, DB2 UDB V7.1/V8.1 for Unix/Windows, Teradata, Windows 2000/2003, Sun Solaris V9/V10, Altiris Client Management Suite V6.0.