SUMMARY

• 9+ years of experience in Business Intelligence, ETL and Data warehousing Technologies with expertise in MicroStrategy versions 8.x/9.x/10.x: Intelligence Server, Administrator, Architect, Desktop Designer, MicroStrategyWeb Administration, Security Administration, Object Manager, Integrity Manager, Report Services, Dashboards, Enterprise Manager and Narrowcast Server
• Strong experience with full Software Development Life Cycle(SDLC) which includes Requirement Analysis, Design, Development, Implementation, Testing, Deployment, Production Support, Maintenance, Built and Release management.
• Skilled in Tableau Desktop for Data visualization, Reporting and Analysis.
• Expertise in resolving the reports, dashboards, performance issues and implementing best practices using Tableau/OBIEE/SAP BO.
• Extensive Experience in various TableauDesktop reporting features like Measures, dimensions, Folder, Hierarchies, Extract, Filters, Table Calculations, Calculated fields, Sets, Groups, Parameters, Forecasting, blending and Trend Lines.
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates.
• Involved in training Business Users on MicroStrategy OLAP Services such as view filter and derived metrics, Adhocreports.
• Excellent experience in MicroStrategy Report development, Report testing, Report tuning, Ad - hoc and Custom Groups.
• Extensive knowledge in various reporting objects like facts, Attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.
• Expertise in Tableau Server Configuration, Administration and Cloud Deployment
• Expertise in Tableau Enterprise Scalability and Integration with existing Data Flow Architecture
• Involved in Deployment, Maintenance and Troubleshooting of Tableau Servers and integration with Databases
• Experienced in Optimization and Performance improvement of Tableau Workbooks
• Troubleshoot existing reports, understanding of data connections to Oracle, MS-SQL Server and other Databases.
• Experience in more advanced features, such as Freeform SQL reports, complex filters, metrics, Data Mining Services, custom groups, consolidations, and prompts for advanced and predictive analysis.
• Expert in designing Schema, Public Objects, Reports, Dashboards, Scorecards in MicroStrategy and strong experience in SQL Development.
• Specialized in designing Report Service Documents and Dashboards with multiple datasets.
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments and MicroStrategy Command Manager to run the automated scripts.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Extensive experience on all types of MicroStrategy Filters, Prompts, Templates, Metrics, Consolidations
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets).
• Worked with heterogeneous data sources like Oracle, SQL Server 2005, Teradata, Sybase flat files, XML files, and DB2 files.
• Experience in Business Intelligence, ETL Applications, Data modeling techniques like star and snowflake schemas using Erwin tool.
• Experience in Converting Legacy reports into MicroStrategy reports and working in offshore-onsite environment.
• Worked with Logical and physical modeling along with design and implementation.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Experience in coordinating with Database Management team, End users, Business Analysts in understanding their requirements, assisting and providing technical solution and knowledge.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS

BI/Visualization Tools: MicroStrategy 10/9.x/8.1.x (Intelligence Server, Administrator, Desktop/Developer, Architect, Web, Distribution Services, Visual Insight, Narrowcast Server, Mobile, Integrity Manager, OLAP) Tableau, Cognos, SAS Enterprise Miner, predictive, sentiment Base SAS, SAS Enterprise Guide.

Scripting Languages: SQL, Base SAS, C, C++, HTML, Python, R Programming.

Utilities: MS Office Suite, MS SharePoint, Putty, Toad

Front End Tools: MS Project, MS Office.

Databases & ETL Tools: Oracle SQL, MS Access, MS SQL Server, SSIS, SSAS, SSRS,Teradata, SAS/ACCESS, OLAP, Micro Strategy.

Document Management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum.

Platforms: Windows7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX.

Data Modeling: Erwin, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Fairfax, VA

MicroStrategy Consultant

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.
• Managed the Global team comprising of onshore, offshore resources.
• Involved in MicroStrategy upgrade to version 10.x.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy.
• Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users.
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
• Used Information windows extensively on iPad based dashboards for better interactivity and navigation.
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets. Using I-cubes improved performance of the RS documents significantly.
• Used MicroStrategy Distribution Manager for automation of reports that saved many man hours every day and helped departments focus on data analysis instead of data generation. This helped in accuracy and integrity of data presentation.
• Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects
• Widely used VLDB properties to set default criteria at project level and also at individual report levels to overcome performance issues.
• Experience working in various environments with change management, defect tracking and status reporting processes.

Environment: MicroStrategy 10.x/9.x (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager), Linux, Windows Server, Oracle 11gR2, SQL Server, Informatica.

Broadridge Financials, Jersey City, NJ

MicroStrategy Consultant

Responsibilities:

• Worked with the Source Systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements.
• Created the requirements documentation for the MicroStrategyProjects and also documented the requirements in MicroStrategy Environment.
• Installed software, secured model design, troubleshooting of application and database connectivity and tested load.
• Created Reports using Complex Filters, Compound Metrics and Prompts.
• DevelopedMicroStrategyPayroll Analysis and Productivity reports for HR.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Good understanding of the type of schemas that best supportMicroStrategyin different scenarios.
• Used Advanced Prompts, Non-Aggregately Metrics, Transformation metrics and Level Metrics for complex reports.
• Created several base formulas using existing facts inMicroStrategy Desktop that can be reused to build number of Metrics.
• Customized reports, documents and deployed them toMicroStrategy Narrowcast Server.
• Managed configuration and version control of production systems, maintained procedures and monitored fault correction.
• Maintained scripts and documentation related to software licensing.
• Supported project teams and domain architects to improve reliability development and testing ofMicroStrategy.
• Worked on MicroStrategy Narrowcast to deliver the Weekly and Monthly Reports.
• Generated the Reports, which includes the public and schema objects using theMicroStrategy Components.
• Developed Customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis usingMicroStrategy.
• Desktop with features of Drilling options (drill down, drill up and drill anywhere).
• Performed the administration tasks like Tuning, Caching, specifying Query Governing, Thresholds, and Report Optimization.
• Performed testing of all reports for the final deployment.

Environment: MicroStrategy9.2.1(Desktop, Architect, Web, Object Manager), Tableau 7.0 (Desktop Server), Teradata 13.10, Ab Initio, HP Quality Center 10/9, SQL, Linux.

Citi Bank, Fort Mill, SC

MicroStrategy Consultant

Responsibilities:

• Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.
• Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters, dynamic aggregation and metrics using MicroStrategy Desktop
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableaureports.
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations
• Created and Published Tableau Dashboards into Tableau Server.
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets
• Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy
• Used MicroStrategy Command Manager to create scripts for creating users, groups, setting user options and authentication modes, clearing caches, dropping connections, generating user lists etc.
• Used MicroStrategy Distribution Manager, Narrowcast Server for automation of reports.
• Worked with Database to create the database tables, materialized views required for reporting.
• Involved in UAT Testing to validate the data using SQL queries against the data warehouse.
• Widely used VLDB properties at project level and also at individual report levels to overcome performance issues.
• Used database specific MicroStrategy OLAP pass through functions like ApplySimple, ApplyComparison to overcome complex logic in creating objects
• Involved in production support (24/7) and maintained a stable platform by proactively identifying and resolving any issues or bugs.

Environment: MicroStrategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), TableauDesktop 8.1-8.2, Tableau server / Administrator, UNIX, Windows Server, Oracle 11g, Sybase.

CVS Pharmacy, Rhode Island

MicroStrategy Consultant

Responsibilities:

• Involving in the design and development of logical and physical schema.
• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables such as reports, dashboards and visualizations.
• Worked as aMicroStrategy Architect and created best suited solutions to the existing system.
• Created different Schema Objects like Attributes, Facts, Transformations, and Hierarchies by using MicroStrategyArchitect of the MicroStrategyBI Suite.
• Developed Metrics, Filters, prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableaureports.
• 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.
• Designed and publishing visually rich and intuitive Tableaudashboards for executive decision making.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Developed MicroStrategyDynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets and MicroStrategy Visual Insights.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Creating complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality and conditional, generating Data Marts with per and post SQL for the Data Mart Tables.
• Using Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
• Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Worked with the DBA & ETL Team on issues of database performance and security.
• Prepare opportunity analysis report and business modeling for priority basis.
• Responsible for ensuring quality and standard in all the research activities.
• Determines which analytics approaches are best-suited for a particular desired result.
• Conducted Data validation testing to ensure data quality.
• Developed a web course and took several classes to train the end users to efficiently use MSTR.
• Conducted Unit/System/User Acceptance testing on theMicroStrategyobjects developed.
• Providing technical support; troubleshooting report design; monitor system usage and proactive troubleshooting.

  Environment: MicroStrategy10.0 (Architect, Developer, Object Manager, Distribution Services), Tableau Desktop 8.1-8.2, Tableau server / Administrator, Informatica Power Center, AWS, SQL Server, Oracle.

McGregor Boyall, London, UK

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Top gear, Stoke-on-Trent, UK

Tableau Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Develop Ad-hoc Business object reports per user's requests.
• Executed and tested required queries and reports before publishing dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop v7 & v8.1, Tableau Server, Oracle 10g, MS SQL Server 2005, MS Excel, Windows.

GEMS Techno India Private Ltd, Hyderabad, India

Business Objects Developer

Responsibilities:

• Created the BusinessObjects Universe (Interface Layer), Classes and Objects with the Collections warehouse and DLF System.
• Potential usage of alias, context, and joins concepts to resolve the loops.
• Designed aggregated tables on the most frequently queried data, and used @aggregate aware functionality in defining dimensions and measures. Setup custom hierarchies for drilldown paths.
• Worked extensively with @functions(@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts). Worked extensively with the major functionalities of BusinessObjects like Group By, query prompt, drill filter, andBreaks, Sorts, Ranking, Calculation using the Slice and Dice panel.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Planned the Migration from BusinessObjects 6.5 to XI R2.
• Prepared checklist for the migration of BusinessObjects 6.5which included users, user groups, documents, universes and security to BusinessObjects XIR2.
• Implemented Incremental method for migration.
• Worked closely with Business groups to ensure correct security was re-established and report formats were corrected after migration.
• Created required restriction sets to maintain the security for the users in Business Objects XI R2.
• Worked with Dashboard Manger which provides the ability to create management dashboards, chats which are at-a-glance displays that show the status of business metrics.
• Created complex reports using multiple data providers like Oracle, SQL and Excel to extract data and to Validate.
• Performance Tuning of Reports by creating Linked Universes, Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer module during development.
• Regular Production moves after the project got the UAT sign-off involving Universes, reports, groups and categories.
• Ensuring data accuracy, connectivity and format changes if any along with security model after the production move.
• Re-creating/validating the universe connections, report data source information to ensure data is extracted from the correct source.

Environment: BusinessObjects XIR2/ 6.5.1, BusinessObjects WEBI, BusinessObjects DESKI, Central Management Console XI (R2), Designer XI (R2)/ 6.5.1, BusinessObjects Enterprise Server XI (R2)/ 6.5.1, Oracle 9i, TOAD 8.5 / 7.4, Windows 2003.

FourSoft Private Ltd, Hyderabad,India

Business Analyst

Responsibilities:

• Gathered Requirements, Developed Process Model and detailed Business Policies.
• The SDLC Methodology used was Agile.
• Gathered functional business requirements from process owners and developed functional specifications for application enhancements.
• Insure member eligibility for DME services: both benefit and current Medicare guidelines.
• Worked with development / technical team members to ensure that the enhancements would meet the defined business requirements.
• Conferred with Business Users to Gather Requirements for the design and development teams.
• Involved in exporting data from the database to flat files.
• Facilitated Joint Application Development (JAD) sessions, as well as conducted interviews of appropriate business/technical stakeholders.
• Analyzed Business Requirements to produce System Requirements for the technical team using MS Visio.
• Conducted Business meetings for the claims adjudication process and its workflow.
• Identifying and documenting UML Use Cases.
• Work with business users to define Business, Process, and Data Models to understand the overall business.
• Interacted and assisted the entire team on the testing tools and processes.
• Involved in evaluation of the user request for new or modified program to determine feasibility, cost and compatibility with current system, and computer capabilities.

Environment: MS Office, Visio, SharePoint, UNIX, SQL, Toad, DB2, CMR, Citrix, Rational Suite, Windows 2000/XP