SUMMARY

• 8.5 years of IT experience in Business Analysis, System Analysis, Data Analysis, Software Design, Development, Testing and maintenance of Business Intelligence/Data Warehousing environment across Financial, Insurance, Healthcare, Transportation, Technology and Banking industries.
• 6+ year’s extensive experience in working with Tableau 8.x/9.x/10.x/2018.x/2019.x/2020.x product suite (Desktop, Server, Public, Reader, and Mobile) and other BI technologies like Micro - Strategy, Alteryx, Informatica etc.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• Conducted Gap Analysis, created Use Cases, workflows, screen shots and Power Point presentations for teh Web Applications.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes, KPI's and gather business requirements as per project milestones.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating teh Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by teh teams across teh deliverables for a project.
• Strong understanding of Data warehouse concepts like Kimball/Inmon methodologies, Star Schema, Snowflake Schema, Dimensional data modeling, Fact and Dimensions tables, physical and logical data modeling.
• Proficient in designing teh Design Documents for loading data into Data Warehouse and Data Mart tables.
• Extensive experience in presenting Tableau visual analytics and best practices like Story Points, Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with 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.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into teh available data.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Experience with JavaScript API to customize teh views, selects, filters, date, and time.
• Extensive knowledge of Tableau Server Concepts like TABCMD, TABADMIN, creating/ adding users, sites, and projects, managing licenses and data connections, scheduling tasks.
• Extensively worked with various database systems like Oracle, Teradata, DB2, MS Access, Flat files, XML and SQL Server.
• Working with Tableau CRM (formerly Einstein Analytics) in business analytics platform that’s optimized for mobile use and brings flexible customer analytics to your CRM.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validations for all teh reports and dashboards generated from various database sources.
• Outstanding knowledge in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Flexible, enthusiastic, and project-oriented team player with excellent communication skills with leadership abilities to develop creative solutions in challenging environments.

TECHNICAL SKILLS

Analytical Tools: Tableau, MicroStrategy, Cognos, SSRS

Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio

Data Integration Tools: Alteryx, Informatica Power Center SQL Server DTS

SQL Tools: Rapid SQL, Toad, Teradata SQL Assistant, PL/SQL Developer

RDBMS: Teradata, Oracle, SQL Server, DB2, Access

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation: SharePoint, HP Quality Center

Scripting/Lang.: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL and XML

Scheduling Tools: AutoSys, Control M

Operating Systems: UNIX, Linux, Windows 7/XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Tableau Developer

Responsibilities:

• Responsible for interaction with Business stakeholders gathering requirements and managing teh delivery, covering teh entire Tableau Development Life Cycle.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Worked with Tableau Prep builder 2021.x, generated output files.
• Develop teh reports using different Date Calculations, LOD Expression, Set, Parameters, and Groups.
• Performed YTD, QTD, MTD calculations for current year and prior year using different Date Function and Calculations on Sales and Units comparisons based on conditional coloring.
• Developed teh reports using Parameter to display Dynamic Dimensions, Dynamic Measures, Top N Results, and Dynamic Graphs etc.
• Designed and Developed teh Dashboard with teh help of KPI Matrix and object like Texts, Images, and Layouts etc.
• Implemented user level security to restrict teh data for user of different region using user filters in Tableau Desktop.
• Published teh reports from Tableau Desktop to Tableau Server.
• Deployed dashboards using GitHub.
• Strong administration knowledge on content management, user’s management, graphs, scheduling, permissions in Tableau Server.
• Understanding teh KPIs and Requirements Documents.
• Installation of Tableau Desktop and database configurations.
• Creating custom basic and complex calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Used Trend Lines, Reference Lines, and statistical techniques to describe teh data.
• Used Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Responsible for dashboard design, look and feel and development.
• Use parameters and input controls to give users control over certain values.
• Combined data sources by joining multiple tables and using data blending.
• Involved in creating a dual-axis bar chart with multiple measures.
• Participating Daily, Weekly and Ad-hoc meetings.
• Involved in end-to-end implementation of reporting projects.

Environment: Tableau Desktop 2021.x, Tableau Server 2021.x, Tableau Prep Builder 2021.x, SharePoint 2018, Axure, Alteryx, Toad, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Tampa, FL

Sr. Tableau Developer

Responsibilities:

• Gatheird Business Requirements, Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications.
• Installed,configured and setup Tableau environment in teh organization.
• Develop, organize, manage, and maintain graphs, tables and document templates for teh efficient creation of reports.
• Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.
• Incorporating weekly changes of teh data source files by integration into Tableau data sources for timely leadership reporting.
• Creating reports and infrastructure to show migration activities by monthly release, business functions and IT projects.
• Created Visuals for Paypal team workflow optimization using different Tableau charts such as KPIs and sparklines in a single view.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Worked on converting map shape files to tableau readable CSV format using R software
• Conducted presentations to other lines of business as a Meta role to show value of Tableau as a BI tool.
• Participated and co-ordinated daily stand-ups with clients on daily design and development effort.
• Extensively used LOD expressions for cohort analysis and aggregation.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight teh value of analytics in Executive decision support control
• Extensively used calculated fields for different logics for Trend, Extended price calculations for teh different cost types
• Define best practices for creating Tableau dashboards by matching requirements to teh charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Generated teh test plans specifying an overview of testing approach, testing strategy, roles, responsibilities, and its scope.
• Prepared test scripts and documented user training modules.
• Maintained Test log and created Test Evaluations, Summary Reports.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Provided Ongoing support to BI applications running in production & troubleshoot any issues.

Environment: Tableau Desktop 2019.x/2020.x, Tableau Server 2019.x/2020.x, SharePoint 2018, OBIEE 11g, Axure, Alteryx, Toad, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Juno Beach, FL

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Gatheird Business Requirements, interacted with teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Develop, Organize, manage, and maintain graphs, tables, and document templates for teh efficient creation of reports.
• Mentored other Tableau users, provided training and novice in Tableau.
• Developing 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 teh different cost types.
• Created visualizations for logistics calculations and departmental spend analysis.
• Used SQL Queries at teh custom SQL level to pull teh data in Tableau desktop.
• Validated teh results in Tableau by running SQL queries in Oracle SQL developer
• Attended daily standup meetings to update scrum master with wat is achieved, wat is being done and is their 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 teh feedback and incorporated teh necessary changes.
• Created tableau functional design document.
• Performed performance tuning of teh dashboard in Tableau desktop.
• Published teh developed dashboards into production and ensured teh data was up to date by scheduling extract refreshes.
• Performed Parallel Testing or Production Testing, which ensures that teh new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in teh retrospective meetings and next sprint planning meetings.
• Involved in Onsite & Offshore coordination to ensure teh completeness of Deliverables.

Environment: Tableau Desktop 10.x\2018.x, Tableau server 10.x\2018.x, OBIEE 11g, Microsoft SQL Server, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, San Antonio, TX

Tableau Developer / Data Analyst

Responsibilities:

• Gathering teh clients, Suppliers, and internal resource data from all teh Vendor Management Systems.
• Actively involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance teh existing KPI's.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate teh data and use as teh source data files.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Analyzing teh data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with Teradata database and pull data to work on BI requirement.
• Provided Ongoing support to BI application running in production & troubleshoot.

Environment: Tableau (Desktop, Server) 8.x\9.x, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Cumberland, RI

Tableau Developer/ Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into teh existing procurement workflow executed through IT channels.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Worked with teh report development Manager and other team members on report requirements, timelines, testing, and technical delivery.
• Designed and developed Tableau reports, dashboard, and metrics to support Claims Reporting and Business Intelligence strategy
• DevelopedTableau objectslike Filters, Parameters, Calculated fields, Hierarchies, Actions, etc.
• Extensively usedTableauReport Servicesto generate Report Documents.
• Created calculated fields for comparative reports like claims dis year to last year (year to date and month to date).
• Designed different BI Dashboardsfor teh Company Executives, through an efficient use of Tableau Report Services.
• Created all possibleMetrics, for enabling teh end users to generate customized reports by creating their ownTemplatesandFilters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Responsible for teh testing, fixing teh bugs and troubleshooting teh technical problems.
• Creating and developing test strategies, test cases and test plans.

Environment: Tableau (Desktop, Server)7.x, Teradata, Oracle, SQL Server, Power Designer, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite ( Word, Excel, Power Point, Visio).

Confidential

Business Systems Analyst

Responsibilities:

• Interacted with teh Business Users and Supervisors to get a better understanding of client business processes and to gather business requirements. Analyzed teh Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Converted teh User Requirements into Business Requirements, Functional Requirements and Technical Requirement. Also created Business Process Models from teh requirement specifications.
• Created Use Case specifications, Business flow diagrams, Activity/State diagram and Sequence diagram using MS Visio, so teh developers and other stake holders can understand teh business process according to their perspective with possible alternate scenarios.
• Communicated extensively with teh Financial Examiners and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Implemented RUP and followed iterative, Use Case driven process for requirement documentation and deployment.
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Assisted teh PM in setting realistic project expectations and in evaluating teh impact of changes on teh organization and plans accordingly and conducted project related presentations.
• Developed Data Flow Diagrams, illustrating teh flow of data from teh legacy systems into teh Application database Tables, along with checkpoints for testing / verification.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing. Developed user test cases and validated test results during user acceptance testing.
• Assured that all Artefacts are in compliance with Department’s SLC Policies and guidelines.
• Used Test Director for Defect Tracking and prioritizing defects and for enhancements after base lining teh requirements.

Environment: MS SQL Server 2000, Microsoft Visio, MS Office, XML, MS Outlook.