SUMMARY:

• Over 5 years of experience in Software Development life - cycle and implementing in Data Warehouse, Business
• Intelligence, Client/Server Technologies and E-Commerce Applications for Financial, Insurance, Banking, Retail and Production systems.
• Over 3 years of solid expertise with Tableau Desktop and Tableau Server
• 4 years of experience in design and Implementation of BI applications using MicroStrategy 9/8/7
• Experience in Business Systems and Business Requirements Analysis & Documentation especially in the Ecommerce, Retail Industry, Pharmaceutical Industry, Financial Industry, Insurance and Telecommunications Industry.
• Created numerous interactive dashboards and worksheets using Tableau Desktop
• Very good experience in working with Parameters, Actions, Filters, Legends, Measures, Dimensions, Functions and Calculated Fields with Tableau
• Extensively worked in creating Story cards, gathering requirements for Interactive Dashboard Reports and
• Scorecards to view personalized reports based on user requirements.
• Worked with very complex data models for reporting in BI environment with multi-dimensional data.
• Involved in analysis, design, development, implementation and Support of Business Intelligence applications using
• Tableau as a Business Analyst.
• Involved in testing MicroStrategy objects such as attributes, facts, prompts, filters, hierarchies and complex metrics that conform to the dimensional and de-normalized data models.
• Strong Knowledge of Data Extraction, Data Integration, and Data Mining for Decision Support System using ETL and OLAP tools.
• Familiar with analyzing various data structures, query optimization and cost estimation of SQL queries.
• Extensive experience with SQL language with major database systems, including Oracle, Microsoft SQL Server, Teradata.
• Capable of verifying Tableau reports by writing complex SQL statements with joins, aggregate functions, and filter & search criteria to verify the integrity and correctness of the report outputs.
• Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi- dimensional data model analysis using OLAP, Physical and Logical data modeling.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 8.1/7/6.1/6.0 , Tableau Server

MicroStrategy: Desktop 9.x/8.x/7.x

RDBMS: Oracle 9i/10g/11i, MS Access, MS SQL Server 2000/2005/2008 , Teradata, Netezza.

Languages: SQL, PL/SQL, Java

Environment: Windows 7/2008 R2, HP-UX, Solaris and Redhat Linux Office Tools MS Word, Excel, PowerPoint, MS Project, MS Outlook Scheduling Tool Auto Sys, Version Control, Control-M.

Testing Tool: HP Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data form Excel/Oracle SQL Server for design, development, testing and production rollout of reporting and analysis projects with 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.
• Created Heat Map showing current service subscribers by color that was broken into regions allowing business user to understand the customer distribution and density.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from
• Oracle, MS SQL Server and 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 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 quick filters to filter needed information.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle, SQL Server R2, MS Excel

Confidential

BI/Tableau Reporting Analyst

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Migrated existing Microstrategy Reports to Tableau workbooks.
• Created Tableau 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.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Reviewed Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up - to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.

Environment: Microstrategy, Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Windows Server 2008 R2

Confidential, Phoenix, AZ

MicroStrategy Consultant

Responsibilities:

• Involved in the complete Life cycle of the Project.
• Participated in the end user meetings to obtain the business requirements for creating reports and dashboards
• Extensively involved in the creation of schema objects using the Project Creation Wizard to create Facts and Attributes and using the respective editors to enhance them.
• Worked closely with the developers to generate reports using Advanced Metric objects, Filters, Prompts and also Customized Templates to facilitate the End users to create customized reports by choosing
• Filters, Metrics and Report Attributes
• Delivered Advanced Reports in grid mode and graph mode using MicroStrategy Desktop.
• Participated in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, access controls lists.
• Involved in taking regular Backups of the Production Metadata in SQL Server Database
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end - users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Involved in creating users in MicroStrategy Desktop for testing the reports on Web.
• Worked along with MicroStrategy Knowledge Base to troubleshoot some Report related issues.
• Created some Ad-Hoc reports using the Actuate e.Report Designer professional.
• Familiar with MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy
• Report Services.
• Used conditional formatting feature to project trends for product sales and to enhance grid and graphs in documents.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.

Environment: MicroStrategy 8.1.2(Desktop, Administrator, Architect, Intelligence Server, Web, Agent), Object Manager, Teradata T12, SQL Server, Windows, Actuate e.Report Designer Professional, Oracle10g, Erwin, Informatica