-- Advise customers with Microstrategy projects implementations;-- Develop Business Intelligence roadmaps;-- Guide with Business Intelligence transitions and tool conversions;-- Manage and direct BI Consultants at client engagements;

-- Architected, developed and implemented reports, intelligent cubes, Visual Insight dashboards and Report Services dashboards; -- Troubleshot and resolved production issues;-- Redesigned filter panel on SNPR dashboard. Enabled manual filter apply option inside Information Window panel by inserting filter panel on top of Information Window panel;-- Created custom Enterprise Manager dashboard based on data from 3 sources: 2 Enterprise Manager databases and one external database;

-- Architected, developed and implemented reports, intelligent cubes, Visual Insight dashboards and Report Services dashboards; -- Converted existing monthly Report Services documents into trending Visual Insight dashboards;-- Productionized 3 Visual Insights dashboards;-- Conducted demos of work completed at the end of each phase;-- Created and conducted architectural design reviews;-- Architected automation of monthly Scorecard results for the third party vendor management using Multisource with Composite and Netezza as datasources. Over 30 manual Excel files are uploaded to Composite virtual store. Composite datasource is configured as read only data source. Data from Composite data source is transferred to the main datawarehouse in Netezza where all calculations are applied dynamically on Composite and Netezza data sources. Project required close collaboration with Composite development team, changing several VLDB settings at project and database instance and directing work of 5 developers;

-- Architecting, developing reports and dashboards;-- Creating database views and look up tables to meet business requirements;-- Converting reports from Business Objects to MicroStrategy platform;-- Developing powerful visualizations with Visual Insight;-- Giving presentations to developers and management at the end of sprints;-- Using numerous data wrangling techniques to create visualizations;-- Creating custom user guides and training exercises for users;-- Conducting user training;-- User security administration, setting up users, groups and security roles;

• Performing dual role of Lead MicroStrategy Developer and Administrator: • Lead MicroStrategy Developer:-- Architected, developed and implemented reports, dashboards and custom drilling templates for Commercial Lines Underwriting department;-- Architected, developed and implemented reports for sales department, related to agents compensation and dividend distribution;-- Architected, developed and implemented reports on the foundation of Microsoft Analysis MDX cube;-- Working on new product features, by conducting POCs and recommending for use where appropriate, currently working on Transaction Services POC;-- Responsible for Business Intelligence solutions architecture and best practices;-- Mentoring and directing junior Microstrategy developers;• MicroStrategy Administrator:-- Auditing and ensuring users’ license compliance;-- Product upgrades, most recent upgrade included upgrade from 9.3 to 9.4.1 version;-- Creating and running existing Enterprise Manager reports to assist with performance tuning, user maintenance, objects maintenance, etc.,;-- Automating object promotion process between Dev/Test/Prod via Powershell script;-- Responsible for package object promotions, completing 10-20 packages/month;-- User security administration, setting up users, groups and security roles;-- Act as last internal point of escalation for all MicroStrategy related issues;-- Responsible for opening tech cases with MicroStrategie’s tech support and working on resolution;-- Responsible for setting up regression tests in Integrity Manager;-- Working on metadata related issues and using Scan MD utility to resolve logical inconsistencies;

Implementation of Data Integration and Business Intelligence solutions with expertise in areas of analysis, design, development and administration.• Architecting and developing Microstrategy projects;• Designing and implementing security model in Microstrategy application;• Creating and administering users and groups;• Creating reports and dashboards;• Mentoring and directing junior Microstrategy developers;• Providing project estimates;• Overseeing and coordinating changes related to Business Analytics applications impacting multiple areas;• Developing data integration solutions using Informatica;• Automating number of various ETL extracts with email distribution capability to users;• Creating numerous Teradata BTEQ ETL extracts;• Developing best practices document for the data profiling activity;

Application development, configuration and administration using Microstrategy platform.Performance tuning of Teradata and Microstrategy applications.• Facilitating user requirements gathering sessions;• Dashboard requirements gathering;• Dashboard prototyping in Balsamiq tool;• Dashboard development for different types of Nationwide Agency user groups;• Technical design specification document creation;• Unit testing;• Deployed partition mapping table architecture to improve queries performance;• Designed dynamic currency conversion architecture via Microstrategy application that enables users to pick any of the existing currencies during report execution and convert results to a desired currency;• Converted 40 reports that were created using complex custom code that nobody could support to a Report Services documents;• Created over 40 dynamic subscription Narrowcast services;• Developing hundreds of new schema and application objects;• SQL Engine optimization (reducing number of SQL passes generated by the engine);• Metadata projects merge;

Business Intelligence application development using Microstrategy platform.• Full SDLC Microstrategy application development;• Architected and implemented numerous Microstrategy projects;• Acted in the roles of Project Manager and Tech Lead to deliver solutions to clients;• Enterprise Manager product customizations - developing new tables, schema and custom reports;• Provided recommendations to clients on use of Enterprise Manager product and best practices;• Developed interactive complex reports containing page by fields with subtotals, giving user ability to analyze information from different dimensions;• Created number of custom subtotals for metrics;• Free Form SQL reports development;• Installation of NarrowCast products and development of distribution services for large user base;• Performed software upgrades(Microstrategy, NarrowCast, Enterprise Manager) in Dev/QA/Prod environments;• Designed and developed custom integrated solution that produces output files in predetermined format. Results for final output files can come from Narrowcast scheduled service or user executing report in Web. After report execution, results were automatically exported to a network shared drive; • Recommended and implemented changes to I-Server and Web Server environments to improve performance and memory management;• Recommended and set up users and user groups for large user base clients;• Coached and mentored junior developers;

• Created technical design documents to be used for the MicroStrategy application development;• Developed data warehouse reporting applications using MicroStrategy 7.2.4 & 8.0 application;• Created detailed requirements for metrics and attributes for the Claims domain;• Developed data warehouse source to target mapping documents;• Developed project scope documents;• Developed, coordinated and executed comprehensive test plans; • Reviewed ETL designs and data models and validated against business requirements;• Automated publishing of monthly reports for the Office of Claims using MS Access databases, SQL Server 2000, Visual Basic that resulted in reducing turnaround time by 7-10 days;• Responsible for monthly publishing of Material Damage Scorecard; Casualty Scorecard; Non-Standard Casualty Scorecard; Non-Standard Severity Metrics Scorecard; Subrogation Scorecard;• Developed user requirements and documentation for the monthly reports;