SUMMARY

• Around 4 years of IT experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Business Intelligence
• Extensive Tableau Experience in Enterprise Environment and Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions 7/8.1/9.3/10.1.
• Generating Dashboards with Quick filters, calculated fields, Groups, Parameters and Sets to handle views more efficiently in Tableau.
• Experience including Analysis, Modeling, design and development of Tableau reports and Dashboards for analytics for reporting applications.
• Experience in Creating Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the assigned groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Back ground images, Maps, Trend Lines, Statistics and Log Axes.
• Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Hands on experience working with various data sources such as Oracle, SQL Server, Tera data, ODBC and flat file sources.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multitier environment.
• Experience developing complex reports using Drill-through reports, Prompts, Dashboards, Master-detail, Burst-reports, Dynamic filtering in Cognos.
• Strong Knowledge in Software Development Life cycle(SDLC) and proficient in Agile, Test Driven, and Waterfall methodologies.
• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Worked in Teams and can be part of for the Organization Value addition and Self- disciplined / Self-Motivated/ Ability to work independently and quality conscience.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau, Cognos, MSBI

Database: SQL Server, Oracle 9, AS400

Programming Languages: Java, C#, JavaScript, SQL, PL/SQL, Oracle

Operating Systems: Windows 10/8/7/Vista/XP/2000, Mac OS.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Sr. Tableau Developer

Responsibilities:

• Created Tableauscorecards, dashboards using stack bars, bar graphs, scattered plots, Gantt charts using show me functionality.
• Involved in migrating client's reports from excel based solution to an interactive service.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring and Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying workbooks and data visualization dashboards.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Create, customize & share interactive web dashboards with simple drag & drop in generating complex, dashboard reports, business views along with user acceptance test and data accuracy test.
• Created incremental refreshes for data sources on Tableau server and Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Participated in database middleware issues with DBA's, system performance with System Architects.
• Utilized capabilities of Tableausuch as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Generated periodic reports based on the analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Converted Legacy Database into Data Warehouse by creating required Dimension and Fact tables.
• Defined best practices for Tableau report development and Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tableau admin and Tableau cmd commands in creating backups and restoring backups of Tableaurepository.

Environment: - Tableau Desktop 10.1, Tableau Server/Administrator 10.1, Tera Data, MS SQL, SSRS

Confidential, Maryland Heights, MO

Sr. Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements and Involved in reviewing business requirements and analyzing data sources.
• Used various Informaticatransformations like expressions, filters, joiners, aggregators, and lookups to load better and consistent data into the targets.
• Used Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in TableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map to show current subscribers by color that were broken into regions allowingbusiness user to understand most users vs least users.
• Worked closely with business power users to create reports/dashboards using Tableaudesktop.
• Developed various analytical reports from multiple data sources by blending data on a singleworksheet in TableauDesktop
• Using advance features of Tableau software like to link data from different connections together on onedashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local & Global) for various analyticalreports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within InteractiveDashboards.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Using SQL SSIS Migrated data to centralized SQL Server databases to overcome transformation constraints and limitations.
• Schedule the reports using Info View to run at specific times as desired by the BusinessUsers
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for datavalidation.
• Developed dashboards in TableauDesktop and published them on to TableauServer which allowed end users to understand the data on the fly.
• Participated in report tuning, caching, specifying query, and report optimizations

Environment: - Tableau Desktop 8.2, Tableau Server 8.2, SQL Server

Confidential, White house, OH

Sr. Tableau Developer

Responsibilities:

• Coordinated with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Developed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableauworkbooks for Data Visualization.
• Creation of user, groups, folder structures, library and repository Tableauserver logons and security checks.
• Creating New Schedules and checking the tasks daily on the server maintaining server activities, user activity, and customized views on Server Analysis.
• Create Data Extracts connecting to Tera data database, writing Free hand SQL Using SQL assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate TableauServer
• Designed and implemented near-real-time monitoring Dashboards for TableauServer and Visualization users
• Designed and developed monthly, quarterly and yearly reports at branch level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Create other data processing applications, utilizing SQL and SSIS, as required to scale and support for growth of business.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involving in creating process logging and new monitoring tools, integrity reports, and mapping tools.

Environment: - Tableau Desktop 7, Tableau Server, SQL, Tera data

Confidential

Cognos Developer

Responsibilities:

• Actively involved in Customized Cognos Connection with appropriate reports and security measures.
• Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
• Implemented Framework Manager Security for Data access, Object level access and Package access.
• Developed Business View of the data (Metadata Models) with Namespaces, Folders, Query Subjects and Query items in Framework Manager.
• Developed List Reports, Bar Charts, Drill-Through Reports, Master Detail Reports using Report Studio and Query Studio.
• Developed reports, which used Conditional blocks/Variables and associated them with queries to show data only when the conditions were fulfilled.
• Created Drill- through reports and Customized Reports with Prompts (List and Crosstab).
• Actively involved in developing Transformer model design and Power play cube building and implemented Securities on cubes.
• Worked on Performance Tuning to maintain fast performance of the cubes and Transformer models.
• Created Oracle PL/SQL Stored Procedures, Functions using Toad for use by Framework Manager Packages and Report Studio reports.
• Performed SQL Tuning to enhance the performance of the reports.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing)
• Unit testing, Integration testingand System testingof the reports in Development, Testingand Production environments.

Environment: - Cognos 8, MSBI, SSIS, SSRS, AS400