SUMMARY:

• 7+ years of Extensive experience in System Designing, Analysis, Application Development, Maintenance, Implementation and Project Management.
• 5years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 9.x/8.x/7.x.
• Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.
• Proficient in Full Life Cycle Development of Reporting Projects includes Requirements gathering/analysis, Design, Development, Testing and Production rollover.
• Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions 7, 8 and 9.
• Extensive experience in Tableau Enterprise Environment and Administration.
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Established Best Practices for Enterprise Tableau Environment and development processes.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analyses and data management services.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
• 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.
• Experienced in understanding of Data Warehouse architecture. (ODS, EDS, EDW, Data Marts), Business Intelligence, dimensional modeling, requirement gathering.
• Proficient in designing Data Mart and Data Warehouse using StarSchemas.
• Experience with multiple RDBMS including Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2, Sybase, MS Access.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Knowledge of Oracle PL/SQL and ability to write complex logic to manipulate data, create Functional specifications for ETL mapping, mock up for Dashboard and Visualization frames.
• Involved Conceptual, Logical data models based on Source system analysis and then built Physical data models including tables, primary keys, foreign keys, indexes, views, Stored Procedures and data types.
• Developed templates for data mapping and facilitated workshops with cross functional business users to understand complex legacy systems data structures, mapping data into to-be data warehouses and developed conversion/transformation rules.
• 2 years of experience on ETL using Datastage 8.

TECHNICAL SKILLS:

Reporting Tools: Tableau 7/8/9, Desktop/Server, Tibco Spotfire 7.0, OBIEE 10.X

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, IBM DB2 UDB8.0/7.0, Sybase 12.x/11.x, MS Access 2000

ETL: Informatica (Power Center) 7.x, Data stage 8.1

Data Modelling: Erwin, TOAD, Pl/SQL Developer, SQL* Navigator, SQL*Loader

Scripting Languages: SQL, HTML, CSS, Java script

ProgrammingLanguages: C, C++, Java, SQL, PL/SQL, T-SQL

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

DocumentManagement: Serena PVCS Manager, Clear case, MS Visual Source Safe, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential,Atlanta, GA

Tableau Lead Developer/Business Analyst.

Responsibilities:

• Created various Dashboards that had Information:Loans By Status,(Bankruptcy,Foreclosures,Collections,Performing),Payments to Lenders,payments to Borrowers,Loan Summaries etc
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Analyzed requirements for various reports, dashboards and created them using Tableau desktop server.
• Set up Server based datasources and Mentored business power users to create reports/dashboards using tableau desktop.
• Used multiple data sources by blending data on a single worksheet in Tableau Desktop
• 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.
• Created customized Table Calculations, Conditions and Filters for various analytical reports and dashboards.
• Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created navigation page which had all the links to various dashboards.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
• Used SQL tools like Toad, Pl/SQL to run SQL queries and validate the data in the warehouse and datamarts.
• Used Performance recording on Desktop and on Tableau Server and Tuned the Performance of Dashboards.
• Followed Best practices while developing Dashboards
• Provided UAT assistance and post implementation production support.
• Used Dual Axes Charts-Shown multiple measures with dolalr numbers on left Y axis andPercentages on the right Y axis
• Created Tableau Server backups using Tabadmin utility
• Set up Users,Groups,Permissions,Schedules on Tableau Server
• Done unit testing of Dashboards for data quality and done Interface testing like Quick filters,parameters,Actions,

Environment: Tableau Desktop 8.1/8.2/9, Tableau server / Administrator, PL/SQL developer, Oracle 11g, Microsoft Excel 2013, Windows 2007 server

Tableau Lead Developer .

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 with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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.
• Actively involved in Setting up Tableau Environment in Cluster configuration.
• Creating Visualizations in tableau using Excel, DW and SharePoint data.
• 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.

Environment: Tableau Desktop 8.0/8.1, Tableau server / Administrator, Data stage 8.5/9.1,SQL developer, Oracle 11g, DB2, Microsoft Excel, MS Access, Windows 2007 server.

Tableau Developer .

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gathered user requirements, analysed and designed software solution based on the requirements.
• Developed various dashboards which derive insights into customer analytics and marketing analytics.
• Converted OBIEE reports and dashboards to Tableau reports and dashboards.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Development, Execution and testing of workbooks in Tableau desktop before publishing to Tableau server.
• Converted metric insight reports to tableau reports.
• Provided rich visuals to the Executive management to monitor important key performance Indicators.
• Involved in installation of Tableau desktop 7.0, Tableau server Application software.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Published data sources to the tableau server and setting up access permissions.
• Worked on tabcmd to schedule the report's and setup email reports using command lines.
• Created Business requirement documents and plans for creating dashboards.
• Involved in creating ad hoc analysis and dashboard development by visualizing the KPI’s that the business is interested to monitor.
• Worked extensively with calculated fields, filled Maps, scatter plots, bubble carts, Trend Lines, and various other views that are a part of show me feature.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Deep experience with the design and development of Tableau visualization solutions.
• Provided 24/7 production support for Tableau users.
• Effectively used context filters, quick filters and traditional filters.
• Responsible for Tableau Server Performance management.
• Configure Tableau Server for Failover and high availability.
• Creation of Sites, Projects and users.

Environment: Tableau Desktop6, 7.0, Oracle SQL developer, Toad, SQL 2008, Oracle 10g, DB2, Microsoft Excel, MS Access.

Tableau Developer

Responsibilities:

• 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.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• 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
• Involved in integration of Tableau JavaScript API Filters in web application
• Defined best practices for Tableau report development.
• Created dashboards and reports for ad-Hoc Reporting.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and SQL Developer to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Environment: Tableau6.X (Desktop/ Server), Oracle, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007 server.

ETL Developer

Responsibilities:

• The project involved creation of a data warehouse which the client would use to create reports that would help them to take better business decisions. This was a part of MRTU (Market Redesign and Technology Upgrade) program that is being instated by CAISO (California Independent System Operator) Corporation.
• Used Data Stage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Used Data Stage Director to schedule running the server jobs, monitoring scheduling and validating its components.
• Involved in identifying the data inputs from various source systems depending upon the business requirement.
• Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different stages of Data Stage and Pre-built routines, functions and macros.
• Parameterized Data Stage jobs to allow portability and flexibility during runtime.
• Responsible for Preparation of Design Documents / Test Case Specifications / Performance Review and Coding and getting it signed off from client.

Environment: IBM WebsphereDataStage 8.0, Oracle 10g, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting.