SUMMARY

• Having around 6 years of IT experience and 5 years’ experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment, Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader and other BI technologies like Power BI, Alteryx, Informatica etc.
• Experience with creating the Tableau dashboards with relational and by using Text files, MS Excel and MS Access at gathering and manipulating data from various sources.
• Strong understanding of Data warehousing, relational database, ETL and data modeling. the data structures, difference between Joins / Blending, filters, Row - level security implementation, reporting basics,
• Advanced visualizations, parameters, Sets, Extracts, Incremental refreshes, Row-level and table calculations.
• Maintain, enhance, and modify existing reports and dashboards based on business requirements.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, SAP Hana, AWS Redshift, MS Access and Flat files.
• Strong Data warehousing concepts.
• Viz/Server: Advanced visualizations and dash boarding skills with interactivity and publishing.
• Develop ad-hoc SQL queries for analysis and studies to answer business questions.
• Database and SQL Knowledge: Clear understanding of Databases, difference between DBMS vs RDBMS, Normalization vs de normalization, visualizing the data can easily be viewed in Tableau, blended with other data sources, and put into beautiful dashboards.
• Tables, views. Select, joins, aggregations, sub queries, where, etc.
• Involved in discussion with other technical areas to meet the business and technical requirements for Service Now.
• Worked on the development of Dashboards for Key performance indicators for the top management.
• Good Experience in creating aggregates, hierarchies, filters, quick filters and calculated measures.
• Good Experience in Tableau report developing, testing and deploying reporting solutions and scheduling the reports using Tableau Server.
• Outstanding analytical and problem-solving skills, capable of learning new technologies quickly.
• Hands on experience in Desktop visualization and Server administration in various versions of Tableau 10.x/9.x/8.x

TECHNICAL SKILLS

BI Tools:: Tableau (Desktop/ Server/ Reader), Power BI, Business Objects

Data Base: : SQL Server, SSAS, SSRS, Excel, AWS, ServiceNow, Oracle.

Data Integration Tools:: Informatica Power Center, SSIS.

Documentation:: SharePoint, HP Quality Center.

Design Tools:: Microsoft Visio and Rational Rose.

Operating System:: Windows8/7, XP, Server 2012/2008/2003 and UNIX/Linux.

PROFESSIONAL EXPERIENCE

Confidential, OH

Tableau Developer/ Power BI

Responsibilities:

• Worked for an Actuarial Department, Annuity DM and Model Testing team.
• Created a variety of teams-based dashboards on Tableau like SOURCE OF PROFIT etc. Developed dashboards with a variety of charts like waterfall, donut chart etc.
• I have utilized Tableau features like (parameters, action filters and action URL Filters),
• I have also used SQL to collect data and, in this case, I am involved in creating store procedures and SQL Views. worked on a tableau server. Giving the access to the end users, scheduling the extracts and managing the Subscriptions.
• Assisted in the planning and execution of application testing, working with process owners, business and Digital product managers, functional areas, customer experience/design teams and development
• Designing, developing, and executing automation test scripts and assisting in creation of manual test scripts
• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Worked with SSIS Packages on SQL Server and SSIS packages on SQL Server for the automation of day to day Maintenance Jobs.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Interaction with the Power Users & Business users during the various stages of the project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL
• Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement.
• Experience in developing rich interactive 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.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Working with Multiple Data Connections. Extensively worked with various database systems like Oracle, Teradata, MS Access, Flat files, XML and SQL Server

Environment: BI Applications, Tableau 9.0/10.0/2018/2019 , SQL Server, Oracle 11g/12c, Excel, MS Access. JIRA, Assistant, AutoSys, MS Visio, and MS Office.

Confidential, Chicago, IL

Tableau Developer/Analytics and Reporting

Responsibilities:

• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
• Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period
• Building the customized and interactive dashboards using multiple data sources
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in
• Tableau.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developing Standard and Create reports using Tableau Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Creating DB views for the reporting purpose.
• Preparing Report Mapping Documents as per Specifications.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored 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.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• 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 Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Environment: BI Applications, Tableau 9.0/10.0, Tibco Spotfire, Windows 7, SQL Server 2012, Oracle 11g/12c, Excel, MS Access.

Confidential, Tampa, FL

Tableau Developer/Data Analyst

Responsibilities:

• Gathering requirements from business users for the development of Tableau visualization solutions.
• As part of the agile process need to attend the scrum calls and daily catchup meetings to discuss on daily updates.
• Synthesized and translated Business data needs into creative visualizations in Tableau
• Added value by providing innovative solutions and delivering improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Organized demos to the product /Stake holders for POC dashboards.
• Involved in end to end implementation of reporting projects.
• Interacting with business leads and users to provide better solutions and explaining the capabilities of the BI, Tableau and HANA.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Built reports in Tableau using advance functions like LOD, Parameters, Sets, Groups, and Quick table calculations.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Refreshed the Tableau Extract in production server using scheduler
• Worked in user management, group management and permission management for accessing dashboards based on security requirement
• Performed unit testing on dashboards.
• Involved in giving the training to end users about the product functionalities and features.
• Closely worked and supported the UAT and QA testing team.
• Executed and tested required queries and reports before publishing.
• Provide prompt and complete resolution to technical challenges and business issues.

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

Confidential, MD

Tableau Developer/ Data Analyst

Responsibilities:

• Experience with the design and development of Tableau visualization solutions.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard using AWS and Redshift.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Creating data blending in case of merging two different datasets.
• The ability to interact professionally with a diverse group including executives, managers.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
• Worked as Senior ETL developer and developed Informatica ETL programs to implement business requirements

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

Confidential

Tableau Developer

Responsibilities:

• Work with the businesses and project team members (Architect, Solution Designer, and SME’s) to understand and create reporting solutions. This includes prototyping potential solutions or modifying existing work to meet new or changing needs through the use of development standards, processes, and tools available to the team.
• Conducted JAD sessions, interacted with the End users on a regular basis for resolving issues pertaining to the reports, attending weekly status meetings.
• Understanding of using structured data, dimensional models or cubes and various forms of ETL for reporting.
• Created data mapping documents for the worksheets to be built.
• Designed and Developed data mapping procedures ETL-Data Extraction, Data Analysis and Loading process for integrating data using Informatica.
• Designed and developed a business intelligence dashboard using Tableau software allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Analyze business requirements from Black Box Testing perspective, business process and system architecture/design
• Maintained documents for change request and implemented procedures for testing changes.
• Actively tracked 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.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports
• Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company.
• Created and edited the update schedules, managed scheduled update tasks on Tableau server.
• Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, and geographical maps.

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

Confidential

Tableau Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Used Sql Queries at the custom Sql level to pull the data in tableau desktop.
• Validated the results in Tableau by running Sql queries in Oracle Sql developer and Google Big-Query.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Created tableau functional design document.
• Performed performance tuning of the dashboard in Tableau desktop.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
• Participated in the retrospective meetings and next sprint planning meetings.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 7.X, 8.X, Microsoft SQL Server 2012, Microsoft Analysis Services, Oracle Database