SUMMARY

• Having 8+ years of experience in Business Intelligence, Data warehousing, Data architecture, Data modeling.
• Experience including analysis, modeling, design, and development of Tableau, Microstrategy, reports and dashboards for analytics and reporting applications.
• 5 years of experience working with visualization tools like Tableau and SSRS.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7.x/8.x/9.x.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Expertise in Pareto charting, advanced calculations, work with demographic and geographic fields.
• Excellent analytical and problem solving using QlikView, tableau and SQL debugging skills.
• Very proficient in working with large Databases in Hive, Oracle, Teradata and SQL Server.
• Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas).
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization,Business ProcessAnalysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Team player and self - starter with good communication skills and ability to work independently and as a part of the team. Experience in working with big projects.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.

TECHNICAL SKILLS

Databases: MSSQL Server 2008/2005/2000, Oracle (10g/9i/8i), MSAccess

BI Tools: Tableau 9.0/8.0/7.0, Microstrategy

Programming Languages: C, C++, SQL, PERL, Core Java, HTML.

Hadoop Ecosystem: HDFS, Apache SQOOP, Hive

ETL: SQL Server Integration Services (SSIS), SQL Server DTS

Design Tools: ERwin, MS Visio.

Scheduling Tools: Autosys, Maestro/Tivoli, crontab

Office Tools: Office Suite 2010.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Tableau Analyst

Responsibilities:

• Analyzing the SAP BO report for various dimensions.
• Data collection and leveraging on data mining for required data.
• Sqooping data between Oracle & Hadoop environment.
• Using HiveQL for ETL and data validations
• Identifying potential areas for promotional and marketing activities.
• Create Tableau worksheets, design, develop dashboards and publish.
• Working with large volumes of datasets and loading delimited files into tableau Server Sources.
• Develop Scripts to load data into tableau and work with multiple data connections including Hadoop/Hive and by data blending.
• Using table Calculations and User Filter in tableau.
• Using Actions in order to provide additional drill down functionality and Linking to other tableau reports.
• Maintaining permissions of Tableau Views and Dashboards.
• Extensively worked on parameters, pareto charting, mapping, calculations, demographics and geographic fields.
• Worked with string functions, date calculations and swapping dimensions with parameters.
• Constantly monitor the accuracy of the data and modify the measures as per the business requirements.
• Forecasting demand and consumption patterns. Fixing bugs and updating the software periodically.

Environment: Tableau 9.0/8.3.4, Hive/Hadoop, sql, Oracle, Java Script.

Confidential, St. Louis, MO

Tableau Developer

Responsibilities:

• Gathering the clients, Suppliers and internal resource data from all the Vendor Management Systems.
• New KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau Desktop 7.0.2, Excel 2013, Outlook 2013, VMS Systems, Microsoft Office Suite (Word, Excel, Power Point, Visio).

Confidential, Eden Prairie, MN

Tableau Analyst

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Worked on Universe enhancements updating the tables, adding new tables, Joins, detecting loops. Created additional contexts, new dimension and measure objects in the Universe
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards with forecast and reference lines.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Generated Tableau dashboards with combination charts for clear understanding.
• Generated dashboards using dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.

Environment: -Tableau Desktop 6/7, Teradata, Oracle, Windows XP.

Confidential

Microstrategy Consultant

Responsibilities:

• Importing data from various formats as Csv, Excel to build cubes by user and create reports.
• Working with Passthrough functions.
• Implemented Report bursting to file location for delivery to widespread userbase.
• Participating in user and security group maintenance.
• Creating & maintaining schedule objects to create caches for dashboards, reports, Intelligent Cubes.
• Extensively used filters, prompts, metrics, consolidations and custom groups to generate reports.
• Working on customizing and optimizing the query performance of reports using Microstrategy features like VLDB settings.
• Involved in preparing technical design for Microstrategy reports.
• Involved in migration of Qlikview reports to Microstrategy reports.
• Managing schema objects and application objects across the projects by using Object Manager
• Developed mobile reports and Dashboards for Tablet users.
• Provided training to the users, created documents for the users, involved in customer support and stabilize the report in production environment.
• Configuring and creating reports based of Hive.
• Using Object Manager package for doing migrations from Development environment to Testing and Production.
• Scheduling various jobs using Opswise to use Event based triggers on cubes.
• Incremental load of data into cubes to include the data which are at different levels
• Managing Onsite - Offshore coordination for development.
• Using Time Series, Network Analysis and Information box widgets on Ipad.

Environment: Microstrategy, Intelligence Server, Web, Hive, Windows 7.

Confidential

Microstrtegy Developer

Responsibilities:

• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts
• Created KPIs and Metrics to analyze the existing system usage and performance using Enterprise Manager Tool.
• Implemented Narrowcast tasks like service designs, subscription, scheduling and administration.
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.
• Command manager Scripts for creating Users.
• Migration of objects using Object manager between environments.
• Automate all repetitive tasks, and allow them to be initiated on time-based or event-based triggers.

Environment: Microstrategy (Desktop, Administrator, Intelligence Server, Web, Architect, Agent), Object Manager, SQL Server, Oracle 10G, Toad, UNIX, Jira