SUMMARY

• Having 7+ 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 Microstrategy.
• 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 6.x/7.x/8.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 DB2, 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 Process Analysis, 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, IBM DB2 (8.2/8.0). Netezza

BI Tools: Tableau8.0/7.0/6.0, Microstrategy, Business Objects

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

Tools: Adobe Photoshop Report Builder

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, St. Louis, MO

Tableau Analyst/ Developer

Responsibilities:

• Work closely with the Business Analyst to develop the visual analytics for the given data and make it available online and on mobile products.
• 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 8.1.4, Hive/Hadoop, Vertica, sql, DB2 V9.x, Oracle, Java Script, PHP, HTML 5.

Confidential, Miami, FL

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

Sr 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 8.1, Intelligence Server, Web, Hive, Greenplum, 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 7.5(Desktop, Administrator, Intelligence Server, Web, Architect, Agent), Object Manager, SQL Server, Oracle 10G, Toad, UNIX, Jira