SUMMARY

• Overall 7 years of IT experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment.
• Extensive experience in working wif Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x, 9.x, 8.x, 7.x and other BI technologies like Business Objects, Alteryx, Informatics etc.
• Expertise in designing and developing dashboards using Tableau 10.x/9.x/8.x/7.x (Desktop/Server) using data from multiple sources like Oracle, SQL Server, Teradata, DB2 and Flat Files.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall, Scrum and Agile.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
• Interaction wif teh Power Users & Business users during teh various stages of teh project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards wif page and dashboard Prompts.
• Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart - Box (Drill Down, drill up & Cyclic Grouping), Heat Maps, Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations (Detailed and filled in maps), etc.
• Extensive noledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Actions, Parameters etc., in Tableau.
• Extensively worked wif various database systems like Oracle, Teradata, MS Access, Flat files, XML and SQL Server.
• Proficient in creating teh Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experienced in working wif Data modelers to translate Business rules/requirements into conceptual/logical dimensional models and worked wif complex de-normalized and normalized data models.
• Outstanding noledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Designed teh data conversion strategy, development of data mappings and teh design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Extensively involved in Reverse-Engineering and Business rules extraction expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Flexible, enthusiastic and project oriented team player wif excellent communication skills wif leadership abilities to develop creative solution for challenging requirement of client

TECHNICAL SKILL

Analytical Tools: Tableau (Desktop/ Sever/ Reader), Business Objects, SSRS, SSAS, Google Analytics.

ETL Tools: Data Stage, Informatica, Alteryx, SSIS

Databases: Teradata, Oracle, DB2 UDB, MS-SQL Server

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management: TFS, Documentum, Visual Source Safe, Share point, Ultra Edit

Methodologies: Kimball, Scrum, Agile, Iterative

Data Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Languages: SQL, PL/SQL, JavaScript, HTML, XML.

Operating System: Windows, UNIX, Linux

Scheduling Tools: AutoSys, ESP Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr.Tableau Developer

Responsibilities:

• Developed interactiveTableauvisualizations after gathering Business Requirements, interacting wif teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• StretchedTableaulimits to create unconventionalTableaucharts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
• Worked on Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Context filters, User filters, Table Calculations and Trend Lines also calculated measures.
• Implemented data blending and joins to work wif data from multiple databases in a single report.
• Implemented Data Representation using Visualization Techniques inTableauusing Alteryx (Graphs, Charts etc.)
• Involved in Data modeling, designing, and building relational databases.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded teh data into various Targets.
• Designed and developed several mappings to load data from Source systems to ODS and tan to Data Mart.
• Created and maintained several custom reports using Business Objects.
• Understood underlying Data and reworked Data Analysis wif Power BI.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Developed & Implemented Reports usingTableauServer.
• Responsible for Creating of Users, Groups and Projects onTableauServer.
• Created Customized and interactive dashboards (pulling data from multiple data sources).
• Used Java Script API to customize teh views, selects, filters, date and time.
• Implementedtableaudata extracts and created dependencies to trigger subscriptions once teh extracts are finished through TABCMD utility.
• Leveragedtableaubuilt in graphical capabilities to create bar charts, tree maps, area charts and also created custom visualization like donut charts, trellis plots etc.
• Worked on Visual Studio 2012 wif SSIS and SSRS Integration.

Environment: Tableau (Desktop/Server) V10/9.1, Oracle, Teradata, SQL Server, Adobe Marketing Cloud, Alteryx, TOAD, Teradata SQL Assistant, AutoSys, MS VISIO, MS Office (Word, Access, Excel, Outlook).

Confidential, Richardson, TX

Tableau Developer/Admin

Responsibilities:

• Supported Risk Management, Commercial Bank divisions of Chase as a BOBJ/Tableau Developer and Business Systems Analyst; and was involved in all phases of SDLC from data warehouse implementation to Business Intelligence report creation using BOBJ and dashboard development by creating data visualizations inTableau.
• Involved in report and dashboard requirement gathering from teh end users to define accurate requirements.
• Good understanding of teh customer business and implementing teh same over to teh reporting needs.
• Implemented new universes using IDT and modified existing ones per requirements and performed cardinality checks, resolving traps, using contexts, aggregate awareness, hierarchies and derived tables.
• Performed report/universe optimizations in greatly reducing teh run time of reports.
• Created complex Web reports wif multiple queries, custom SQL, complex functions, merge dimensions, drilldown/up/across/through and complex filters.
• Performed Admin tasks such as monitoring DB services, BO Server running wif optimal performance, monitoring licenses, monitoring user activity/sessions, consulting SAP to define bugs in patches.
• Migrated reports/universes from Dev to QA to Prod using import wizard.
• Created Dashboards and visualizations usingTableaufor several teams and delivered demo sessions to expand teh tools reach in teh IT environment.
• Created users, user's groups and maintained user access rights inTableau.
• Created Architecture Design documents and Technical Specifications Documents.
• ConnectedTableauto various databases and performed live data connections, query auto updates on data refresh.
• ImplementedTableauMobile across several lines of businesses.
• ImplementedTableauBI application creation,TableauAdministration, Installs and Server-side functionalities.
• Provided technical support to all team members during project execution.
• Performed reports/dashboards performance optimization.
• Involved in User Training ofTableaudashboards.
• Created intuitive ways in Dashboards to implement multi-level drill trough’s, Ranking, Dual Axis, Geo Coded Mapped views and Histograms.
• Helped in testing and impact assessment on dashboards wif changes to teh data warehouse.
• Created test documents that halp in validating reports and dashboards in QA.
• Utilized Knowledge Link of Capital One to create and update logs for project maintenance.

Environment: Tableau 9.x/8.x, Oracle, SQL Server, Toad, Informatica, Power Designer, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Fairlawn, OH

Tableau Developer/Admin

Responsibilities:

• Analyzed teh reports requirements and transformed teh Functional Design Specifications into Technical Design Specifications for reports development.
• Developed dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables inTableau.
• Tuning long running reports for better performance.
• Created Complex Dashboard to show/hide multiple layouts based on parameter selection.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• DevelopedTableauworkbooks from multiple data sources using Joins/Data Blending.
• DevelopedTableauworkbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Scheduled frequency and time to refresh data for teh when sources are published or extracted to server.
• Provided customer support toTableauusers and Wrote Custom SQL to support business requirements.
• Effectively used data blending feature to bring together teh data from Oracle and SQL server databases.
• Deployed/published workbooks and data sources to theTableauserver.
• Schedule teh reports and setup email reports usingTableauServer.
• Implemented advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data.
• Implemented parameters and input controls to give users control over certain values doing analysis intableau.
• Making enhancements of teh report/Dashboards based upon teh requirements of teh user.

Environment: Tableau (Desktop/Server) V9.1/8.2, Oracle, Teradata, SQL Server, Alteryx, TOAD, Teradata SQL Assistant, AutoSys, MS VISIO, MS Office (Word, Access, Excel, Outlook).

Confidential

Tableau developer

Responsibilities:

• Designed Technical dashboard document using tableau desktop based on teh business requirements.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Data blending implemented on Oracle database and generated interactive dashboards.
• Generated tableau dashboards wif combination worksheets for clear understanding.
• Performed Tableau Admin related activities like Tableau Server installation, backup, upgrades.
• Created users, groups, security roles and SSL autantications.
• Performance tuning of DB and Tableau Server, data sources, workbooks and extracts.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Created Test Scripts, Test hierarchy to represent teh features and functionality that need to be test in teh application.
• Handled Tableau admin activities granting access, managing extracts and Installations.

Environment: Tableau (Desktop/ Server), Teradata, Oracle 11g, SQL Server 2012, Informatica Power Center, Toad /PLSQL Developer.

Confidential

SQL Developer

Responsibilities:

• Communicated wif clients regarding system requirements, ensuring teh development and implementation of customized products to customer satisfaction.
• Prepared functional specifications for user requirements.
• Experience in writing, testing and implementation of teh PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
• Involved in creation of schema objects, roles and privileges, users.
• Prepared User manual, Technical documents for teh end user.
• Prepared executables for system deployment and led teh release of applications following.
• Experience in UNIX Environment in file transfers, job scheduling and error handling.
• Maintenance and support for teh system. Involved in end user training.

Environment: Oracle, SQL Server, Putty, UNIX, SQL/PLSQL and Windows 2000.