SUMMARY:

• 7+ years of extensive IT Experience as a Data Analyst, Business Systems Analystin Data Warehousing and Business Intelligence applications in Retail, Financial, Banking, and Healthcareindustries.
• 4+ years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 9.x/8.x/7. x.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Experience in facilitatingJoint Application Development (JAD) sessions with Business Analysts,IT Groups and Conflict Management with Project team members.
• In depth understanding of the As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.,
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots,Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Proficient in creating Tableau scorecards, Tableau dashboards using advance Tableau functions like Calculated fields, LOD (Level of Detail), Adhoc Calculations, etc.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Alteryx, Teradata, Oracle, Informatica, MicroStrategy, Unix technologies.
• Experience in integrating Tableau into Front-End Web Application using JavaScript API to call parameters and filters as well as individual sheets.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Proficient Star Schema dimensional modeling, which include understanding business processes, modeling dimensions, hierarchies and facts.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
• Working knowledge of performance improvement measures including aggregate tables, Indexes and explain plan.
• Experience in writing complex SQL queries to perform End-to-End Data validations and support Ad-hoc business requests.
• Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILLS:

BI Tools: Tableau 9.X/8.X/7.X ( Desktop, Server, Reader),SSRS, MicroStrategy

ETL Tools: Alteryx, Informatica, SSIS

Requirement Management: Requisite Pro, Microsoft Office

Front End Tools: ERwin, ER Studio, Composite, Microsoft Project, Visible Analyst, Lotus Notes

Document Management: Visual Source Safe, SharePoint, SVN, Ultra Edit, Documentum

RDBMS: Teradata, Oracle, SQL Server, DB2, MS Access

Defect Management Tools: Test Director, HP Quality center

Scripting Languages: PL/SQL, Vizql, HTML, CSS, JavaScript

Operating Systems: Windows 7/XP, Windows Server 2012/2008, UNIX/Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Johns Creek, GA

Tableau developer

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs for Loyalty Program.
• Performed data analysis and extracted data from various tables in the Enterprise Data Warehouse to identify the problem with the existing data and prepared documentation on the ongoing fix and data issues.
• Analyzed dimensional and fact tables in data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Worked with technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Worked with technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
• Extensively used advance chart visualizations in Tableau like Dual Axes, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Build custom time frame dashboards to compare any date range of one period with another.
• Created functional Stop/Pause button using JAVA Script.
• Used Java Script API to create functional Stop/Pause buttonand customize the views, selects, filters, date and time.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures
• Use MS Excel, Word, Access, and Power Point to process data, create reports in Tableau, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau (Desktop/ Sever/ Reader) 9.3/8.3, Oracle 11g, Teradata 14.10, Toad, Teradata SQL Assistant, Alteryx, ERwin, MS Project, JavaScript API, MS Excel, Confluence, Data visualization,D3.js,Infographics,TIBCO Spotfire, SVG, Qlikview, Visualization, VTK, Data science, Data analysis, Data mining, Algorithms, Dashboard, MicroStrategy, OBIEE

Confidential, Salt lake City, UT

Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience in creating dashboards using calculations, parameters in Tableau.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Setting the user permissions in Tableau Sever.
• Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive reports.
• Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop
• Defined best practices for Tableau report development.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Environment : Tableau (Desktop/ Server) 8.x, Teradata, ER Studio, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Business Objects, Ad hoc reporting, BI architecture, Business intelligence, Dimensional modeling, Microsoft SSAS, Star schema, ETL, Microsoft SSIS, Analytics, Business analytics, Web analytics, Google Analytics, Adobe Site, Catalyst, Strategy

Confidential, Minneapolis, MN

Sr.Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Involved in the complete Life cycle of the Project and in the data analysis process
• Gather the various requirement matrices from the business analysts.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Marts using Kimball Methodology.
• Created technical designs for the various reporting requirements.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed different BI Dashboards for the Company Executives, through an efficient use of Tableau Report Services.
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Defined best practices for Tableau report development.
• Created rich dashboards using tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Maintained Test Log and wrote Test Evaluation, Summary Reports.
• Implemented row level security and windows AD authentication for Tableau reports

Environment: Tableau (Desktop/Server) 8.x/7.x, Teradata, Oracle, SQL Server, Power Designer, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite (Word, Excel, Power Point, Visio).

Confidential, New Albany, OH

Tableau Developer/Sr. Data Analyst

Responsibilities:

• Gathered Business Requirements from SME and User interface sessions and documented the query, business analysis & reporting needs. Understood data and business logic with reports.
• Involved in Translating the Business Requirements into Technical Requirements and Dimensional modeling.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Utilized complex SQL join statements to represent relationship between facts and dimensions.

  Handled Tableau admin activities granting access, managing extracts and Installations.

• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Developed, published customized interactive reports and dashboards, scheduled data refreshes on reports using Tableau Desktop and Server.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Executed and tested required queries and reports before publishing.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Coordinated daily and weekly meetings with Line of Business managers, users and off shore (India) resources.

Environment: Tableau 8.x/7.x (Desktop / Server), Oracle, SharePoint, SQL Developer, PL/SQL, Microsoft Office Suite (Word, Excel, PowerPoint)

Confidential, Rochester, MN

SQL Developer

Responsibilities:

• Wrote program to export as text files or PDF to outside Business Users.
• Utilized SQL Queries, stored procedures, packages, used defined functions, views, cursors using Toad or SQL Developer to present data on the reports such as sales information, deposit and payout and their incentive compensation information.
• Created mid to complex Reports (Oracle data sources) with one or more of the following features to support statistical and operational business needs, Grouping, Sorting, Drill-down Dynamic Parameter prompts, Sub reports or Crosstab summaries
• Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports
• Created formulas and/or used statistical or financial functions for reports as needed.
• Used SQL stored procedures, created alias data tables as required to improve report performance.
• Created Stored Procedures and Views as data sources using Oracle databases for reports.
• Wrote different queries and stored procedures to make our daily data verification and conversion processes faster, more accurate and automated.
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
• Used SQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.
• Implementing performance tuning methods to resolve issues and bottlenecks. Identifying long running queries and performing performance tuning.
• Created Materialized Views and partitioning tables for performance reasons.

Environment: Microsoft SQL Server 2008, SSRS, SSIS, XML, T-SQL, MS Word and Excel, SQL Profiler, Toad.