SUMMARY

• Over 8 years of experience in extensive IT industry, in all phases of a software development life cycle in which 4 + years of experience as SQL and Tableau developer and 3+ years of extensive experience in ETL testing in Insurance and Financial Domains.
• Expertise in Tableau 2019/2018/10.5/10.4/10.2 , Tableau Desktop, Tableau Online, Tableau Public, Tableau Reader, SQL.
• Currently working on Tableau 2019.2 extensions by pulling the TREX files in to the dashboard and enabled the Tableau worksheet to communicate with TREX file and filter the data in the extension worksheet accordingly.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters, etc., in Tableau Desktop.
• End to End experience in designing and deploying Data visualizations using Tableau.
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.
• Created highly interactive Data Visualization reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters and Aggregate Measures.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameters, Totals) and Formatting (Annotations, Layout containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
• Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports and Heat Maps.
• Extensive experience on building dashboards in Tableau and involved in Performance Tuning of reports.
• Used Tableau’s flexibility to build applications with wide range of options like quick filters, calculated fields in various functional areas like finance, sales, marketing.
• Worked on connecting tableau to various other data sources like Oracle, PostgreSQL.
• Worked on developing complex SQL scripts for Oracle database.
• Proficient in Data Warehousing Concepts.
• Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Knowledge on retrieving external data to QlikView dashboard by making connection through ODBC and OLEDB.
• Good knowledge in Star Schema and Snowflake Schema using fact and dimension tables and relational databases.
• Experience in handling and interfacing with Informatica Power Centre 10.0
• Experience in handling automated scripts using Control M 10.
• Exhaustive experience in the following four very important stages of SDLC and STLC: Requirements Gathering, FSD Writing, Testing and Implementation with timely delivery against aggressive deadlines.
• Created plan for ETL Testing, developed scripts for critical business process.
• Experience in test script design, Business Objects reports, ETL jobs and Web Services.
• Possess strong knowledge of test management tools like Application Life cycle Management 11.
• Experienced in testing Financial and Banking Applications.
• Experience on Automation scripts using QTP 10.0.
• Writing SQL queries, generating reports to ensure data integrity and validating business rules.
• Used UNIX commands and the vi editor to run scripts and validate.
• Experienced in developing Test Plan, Test Cases, writing Test Scripts by understanding Business Requirements and developing Test Scenarios to support quality deliverables.

TECHNICAL SKILLS

• Tableau Desktop, Tableau Online, Tableau Public, Tableau Mobile
• Tableau Reader, Microsoft Word, PowerPoint, Excel, Access
• OLAP, OLTP, Waterfall, Agile, Oracle 11g/12c, MS Access
• MS Excel, MS Share Point,, Informatica, ODBC, Quality Center
• ALM 11, JIRA, Rally, Putty, WinSCP.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Tableau Developer

Responsibilities:

• Create the functional specification document.
• Reviewed BRD and analyzed data from various sources within Tableau Desktop.
• Created Tableau Data Sources with combination of Tables and custom SQL with inner, left and right joins.
• Created extracts or live connection based on the amount of data that is pulled into Tableau to improve the workbook performance.
• Used Rank functions, Level of Detail Calculations, Table calculations, custom splits to build interactive dashboards.
• Developed the QlikView to support the business decisions.
• Performed data validation by writing SQL queries to make sure the data is correct in the reports and aligned with the business needs.
• QlikSense data modeling Used QlikView Maps to show the reports and dash board for good visualization to the managers. lead System Integrated Testing (SIT) to troubleshoot and resolve simple inquiries and requests from client.
• Collaborated with ETL team to make sure that correct data is pulled into the enterprise data warehouse (EDW) to fulfill the reporting requirements.
• Created automated scripts for tableau workbook refresh when not using live connections to refresh the workbook when published as zero extract.
• Created relationships, actions, data blending, filters, parameters, hierarchies, Level - of-Detail (LOD), calculated fields, sorting and grouping.
• Provide the estimates for the functional updates/changes.
• Co-ordinate with the different interface systems and identify the issues.
• Attend Daily and Weekly Status meeting to analyze on the task and ensure team co-ordination.
• Gathering of all detailed Business and Technical Requirements from Clients for enhancements.
• Analyze and develop additional features to improve the application.
• Design of the views (dashboards) and data retrievals.
• Perform unit testing to confirm if the coding standards are met as per the requirements.
• Perform code walk through to PO and scrum team to provide defect free delivery.
• Versions are maintained to avoid conflicts with other developers and to retrieve files when needed.
• Work with the interface systems and identify the potential issues that could arise because of the changes implemented in the application as well as the interface.
• Review Test plans, Test Scenarios and Test scripts.
• Conduct Daily status calls with project team both onshore and offshore.

Tools: and Technologies: Tableau Desktop, Tableau Online, Tableau Reader, SQL, Query Surge, Visio, MS Excel, MS Word, MS Powerpoint.

Confidential

Tableau Developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and created business requirement documents and plans for creating dashboards.
• Extensive experience in reviewing business requirements and analyzing data sources for design, development, testing and Production rollover within Tableau Desktop.
• Developing the QlikView and QlikSense environment and supporting the business decision process.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked extensively with LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images and Maps.
• Created Charts and Graphs (Bar graphs, Line Charts, Pie Charts, Tree maps, Bubble Charts, Waterfall Charts) based on clients need.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business users, Program Managers and End users.
• Review SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic connections.
• Tested dashboards to ensure data was matching as per business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews and user group discussions as well as in communications with stakeholders and business groups

Tools & Technologies: Tableau Desktop, Tableau server, Oracle 11g, Toad, MS Visio