SUMMARY:

• Certified Tableau professional with 8+ yearsof IT Experience in Business Analysis, Data Warehousing, Data Mining, Data Analysis focusing onDesign, Development, Implementation and Testing of Business Intelligence and Data Analytics applications.
• 4+ years of experience in data discovery, data visualization, data analysis, and report development using various versions of Tableau (Desktop/ Server/ Public/ Reader/ Online) (9.x/8.x/7.x).
• Expertise in interacting with end users, functional/technical experts and identifying, analyzing and developing the reports that meet the business needs.
• Experienced in all activities of full life cycle implementation includingRequirement analysis, Data Modeling, Design, Specification development, Reporting, Web publishing, Portal integration, Performance tuning, Testing, Documentation.
• Proficient in conducting Gap Analysis, Designing data flows and communicating the trade - off decisions on product features based on technology and customer requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Hands on experience in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Extensively providedtechnicalandanalyticalexpertise in responding tocomplex,specializedreport requests requiringhigher-level data analysisanddata management services.
• Outstanding knowledge in designing and developing Data Marts using Kimball/ Inmon methodologies.
• Expertise in analysis, design and implementation of database applications using Teradata, Netezza, DB2, Oracle and SQL Server database technologies.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
• Strong knowledge of business/process data flow in organizations and experienced in data modeling Concepts.
• Experience in working on development of Business ObjectsWeb Intelligence, Desktop Intelligence Reports.
• 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.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Excellent communication, interpersonal and analytical skills with ability to manage and work effectively to meet deadlines in fast paced environment.

TECHNICAL SKILLS:

Analytical Tools: Tableau 9.x/8.x/7.x (Desktop/Server/Public/Reader), Business Objects, SSRS

ETL Tools: Informatica, DataStage, SSIS

Databases: Teradata, Netezza, Oracle, SQL Server, MS Access

SQL Tools: Toad, Teradata SQL Assistant, PL/SQL Developer

Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

Scripting Languages: PL/SQL, SQL, Unix shell scripting, Java, C, HTML, XML

Testing Tools: Mercury Test Director, IBM Rational Tester, QTP

Operating Systems: UNIX, Linux, Microsoft 2008/2003

Others: AutoSys, Control M, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Liaison for project managers, managers, directors, and stakeholders.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Developed dashboards by extracting data from different sources in Tableau using parameters, sets, groups and calculations.
• Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as DB2, Oracle, and MS Excel.
• Extensively used data blending in Tableau to integrate data from different sources.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Enabled 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 creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.

Environment: Tableau (Desktop/Server) 9.x/8.x, Oracle, DB2, SQL Server, Java API, SQL developer, SQL, Microsoft Office Suite.

Confidential, Palo Alto, CA

Sr. Tableau Developer / Sr. SQL Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked as Tableau developer/SME in standardizing Tableau for shared service deployment.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Worked with Tableau administrator in installing Tableau Server in Dev, QA, UAT and Prod environments.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhone, and other smart mobile phones.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: s:Tableau (Desktop/Server), SAS, IBM DB2, Windows Server, Clearquest, Clearcase, Oracle 11i, Netezza, Excel, JAVA, J2EE, TSQL, UNIX, Linux.

Confidential, Greenwood Village, CO

Lead Tableau Developer

Responsibilities:

• 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.
• Involved in creating interactive, parametrized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Involved in data conversion to provide reporting capabilities as per the requirement.
• 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.
• Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop /Server), Oracle, SQL Server, DB2, SSIS, SQL, Toad, Unix, MS VISIO, Control-M, Erwin, MS Office Suite (Word, Excel, PowerPoint)

Confidential, New Albany, OH

Business Intelligence Consultant/ Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• Worked to ensure high levels of data consistency between systems.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.

Environment: Business Objects, Oracle, MS Access, Teradata, Informatica, TOAD, PL/SQL Developer, Autosys, HP Open View, Windows 2003/XP, ERwin, and MS Office Suite ( Word, Excel, PowerPoint).

Confidential, Providence, RI

Business Systems Analyst

Responsibilities:

• Interacted with Functional/End-users to gather requirement for core reporting system by understanding exceptional features and created Business requirement package (BRP’s) to successfully implement Business logic.
• Conducted JAD sessions with users and business clients to gather specific requirements and expectations and implement effective Data Modeling and ETL design.
• Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mockups for reporting.
• Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing / verification.
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Developed source to target data mapping document containing all the Business required fields along with the source rules, target rules, database, table names and transformation rules.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Designed various analytical reports, dashboards in SSRS on Sales, Finance data as per end user requirement.
• Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.

Environment: Oracle, SQL Server,SSIS, SSRS, ERwin, TOAD, SQL, Share Point, TFS, Agile-Scrum, UNIX, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook).

Confidential

Systems Analyst

• Involved in interacting with the Business Users and the Business Analysts to understand the requirements for development.
• Preserving quality data by implementing team-wide standard and independent QA processes, maintaining proprietary data collection programs, and resolving any data anomalies.
• Understanding core products by researching industry trends, knowing the base data used in all delivered reports, and keeping track of current and potential clients.
• Ensuring all deadlines and responsibilities are met.
• Effectively understanding and conveying the business issues and data challenges of both internal and external clients, as well as the industry as a whole.
• Translating questions and problems from clients into an analysis and solutions.
• Performing in-depth, cross-team feasibility checks.
• Utilizing current industry trends in order to create new analyses and products that are useful to clients.
• Becoming an expert in comScore Marketing Solutions products as well as the comScore syndicated product suite.
• Successfully coordinating between multiple internal teams and third-party data vendors to create and fully realize a new product or suite of reports.
• Meeting with external clients as needed.

Environment: SQL Server 2005, MS Excel, MS Access, Enterprise Manager, Management Studio, SQL Profiler,SSRS, Microsoft Office Suite.