PROFESSIONAL SUMMARY:

• Overall 10+ of experience as Data Analyst and Tableau Developer in Software Design, Development, Integration, Implementation and Maintenance of Data Warehousing and Database applications
• 5+ of Data warehousing experience with Business Intelligence tools Tableau Desktop, Tableau Server administration activities using Tableau 2019.1,10.x,9.x,8.x, 7.x and 6.x and Microsoft SQL Server, Microsoft Excel as Developer.
• Experience in Insurance domain with business knowledge of life insurance, General insurance, Motor Insurance and commercial insurance. Expertise in Financial, Retail domains and supply chain management industries.
• Proficient in creating dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Experienced in BI agile development and testing with extensive knowledge of agile software testing and development lifecycle.
• Expert in strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata management.
• Experience in working with different data sources like Oracle, SQL, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Strong Knowledge and good ability in designing, developing, implementing and maintaining business intelligence solutions using Tableau visualization tool along with administrative activities.
• Extensive experience in Installation, configuration, creation of sites, projects, groups, users, maintaining security levels, user permissions and administration of the Tableau Server.
• Experience in reusable codes, Grouping, translation rules, calculation rules, shared encoding parameters, sets and hierarchies in Tableau.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other Local and Global filters according to the end user requirement.
• Expert in Preparing dashboards using calculated (Table Calculations, Level of Detail Calculations, Hide Columns, Creating/Using Parameter, Totals) fields and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding parameters, calculations, groups, sets and hierarchies in Tableau.
• Extensive Experience in working with Tableau technical support, troubleshooting, report design and monitoring of the server usage.
• Managed multiple technical project workflows and ensuring data quality from end-to-end. Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Expertise in for assessing the impact and strategizing the implementation approach.
• Supporting development, BA team, QA Team and data warehouse teams in compiling data used for reporting.
• Expertise in Test management tool and defect management tools. Good ability to develop advanced standards techniques and concepts.
• Expertise in using Jira studio, service now, footprints management tools.
• Excellent trainer - trained senior management, business users, business analysts and developers.
• Work closely with the business to develop, recommend and establish strategies, plans, and processes to improve efficiency.

TECHNICAL SKILLS:

Operating Systems: Windows/NT, Windows 95/98/2000/7, Linux

Languages: T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES

Reporting Tools: Tableau Desktop/ Server 6,8,9,10.x,2019 Tableau reader/Public

Databases & Related Methodologies: SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DB2 MS excel 2010. Agile, Waterfall and Complete Software Development Life Cycle, Iterative, Scrum.

Management Tool: Jira studio, Service Now, Footprints, Quality Center, Bug zero.

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, FL

Tableau Data Analyst/Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Working closely with data mapping SME and QA team to understand the business rules for acceptable data quality standards.
• Responsible for creating efficient design and developing User Interaction dashboards using Tableau Desktop versions 10.0.1/10.5 and 2019.
• Performed development activities by gathering requirements, designing solutions through report development and custom using Tableau APIs.
• Responsible for Scorecard - Technician Productivity, Marketing, Lead Performance, SMS Customer Texting dashboards which are used by the business users across the ADT.
• We developed Key Metrics page, Sections, Ranking, organization level and Summary Reports, Weekly Monthly, Quarterly Reports along with level of detail reports in scorecard project with Tableau Desktop/Server using Oracle and SQL data source.
• Loaded marketing social media data to SQL server and using it to develop Media trending reports.
• Created SQL and Oracle scripts, excel sheet, flat files, CSV files to generated Tableau Adhoc reports based on the business requirements including the validation of data mapping and data flow.
• Created numerous data source scripts using SQL and Oracle to validate and process data to Tableau desktop coming from the source systems.
• Worked on scorecard usage report to customize it more user friendly by adding filters, parameters, date ranges and level of details as per business requirement.
• Responsible for developing scorecard Technician productivity summary, Technician ranking report and Technician level of details dashboards which are used by business to measure the productivity of technician.
• Responsible for developing scorecard Marketing performance, lead Performance and Care Analytics project to develop reports of Weekly, Monthly, Yearly and Quarterly performance marketing channels which also includes social media reports.
• Used data blending techniques to combine data sources into a single view in Tableau. Restricted data for users using Row level security and User filters.
• Extensively used Calculation functions, date functions and custom filters for creating custom Report View in Tableau as per the business requirement.
• Extensively worked on creating Simple and Complex Logic date logics, Logic groups for different business calendar, Conditional calculation and Arithmetic calculation using Tableau Desktop Calculation fields.
• Responsible for server admin activities and User access management control for all the projects using Tableau within ADT.
• Used tableau admin background files and converted them to usage tableau workbooks.
• Work directly with BI Architect, Administrator, DW / DBA team and Business Units to deliver solutions
• Used the available PostgreSQL data and customized tableau reports to develop the reports to monitor on how every user is using and focusing on what parameters/filters of scorecard.
• Implemented sorting functionality for the available downloadable versions of scorecard reports.
• Worked with data analytics and reporting team to develop fore casting sales vs budget tableau reports using Dual axis, trend lines, filters and parameters with the available scorecard report data sources.
• Expertise in creating the User level, Data source level, row level security filters for the workbooks, views, dashboards and data sources.
• Participated in meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Responsible for deployment activities, administering, user management of Tableau server 10.1,10.5 and 2019.2.
• Configured Viz Alerts to trigger email to Production support whenever there is an extract failure.
• Creating/Managing the Projects, Groups, Users, Schedules, tasks and assigning the right permissions to them.
• Responsible for user security level of permissions setup and maintenance at project and user group level.
• Responsible to run the Batch scripts and monitoring of tableau extracts.
• Involved in validating the server after each major or minor version upgrades.
• Developed multiple custom admin views by connecting to PostgreSQL database to improve the Server performance and tuning it for optimization.
• Involved in performance tuning, Reports tuning, caching, specifying query thresholds and report optimizations.
• Responsible for working with Tableau professional services team and identify optimized architecture for ADT Tableau environment.

Environment: Tableau Desktop 10.0.1/10.5 , Tableau server 10.0.1/10.5 , 2019.2 Tortoise SVN, SQL Server 2012, Oracle, Jira, MS Office Suite, MS Access, MS Excel, MS Project, Windows.

Confidential, Cherry Hill, NJ

Business Data Analyst/Tableau Developer - Software Engineer

Responsibilities:

• Responsible for efficient design, developing and maintenance using Tableau desktop version 6.x,8.x, 9.x,10.x and server 6.x and 8.x,9.x and 10.x.
• Worked on Oracle, SQL and tableau server to configure data connectivity clients to connect production environment system and run queries through the supported drivers.
• Used techniques like data blending which brings data from multiple data sources into a single view in Tableau. Restricted data for users using Row level security and User filters.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Combined multiple dashboards into a single story to enhance the visual appeal of the report.
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Used excel sheet, flat files, CSV files to generated Tableau Adhoc reports.
• Analyzing the data by Google Big Query and then building the dashboards by connecting to Google Big Query.
• Used various join types (left, inner, right, outer joins) based on business requirements.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Built dashboards for measures with forecast, trend line and reference lines.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Bubble Charts, Waterfall Charts, Bump Charts, Funnel Charts, and Bollinger Charts) based on client's need.
• Used symbol maps, filled maps and other map options to plot geographical data.
• Worked on Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Used Tableau Desktop to create various analysis worksheets, including customer analysis and equipment analysis.
• Used landing page with navigations to provide quick access to target dashboards.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created side by side bars, Scatter Plots, Pie charts, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications. Created Workbooks and dashboards for analyzing statistical billing data using Tableau desktop.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and track on the update of versions.
• Created various Tableau Extracts with entitlements and published to server for self-servicing needs of the business users.
• Worked with stakeholders in gathering requirements to create Custom Portal for Tableau Server User interface.
• Installed and configured Tableau Server across different environments, Created Sites, Users, Groups, Projects and maintained object-level security by providing appropriate permissions.
• Defined best practices for Tableau report development, provided 24/7 production support for Tableau users. created documents for Tableau user support and trained Power users on self-servicing capability of the tool.

Environment: s: Tableau 6(Server and Desktop), Tableau 8(Server and Desktop), Tableau 9(Server and Desktop), Tableau 10.1(Server and Desktop), Tableau desktop 10.5, Tableau server 10.5, Oracle, SQL Server 2014, Google Big Query - Google Cloud, MS Office Suite, MS Access, MS Excel, MS Project, Window

Confidential, NJ

Software Engineer (Tableau Developer)

Responsibilities:

• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created of dashboards for business groups like finance and sales. Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Created Sets, Groups and Data Bins as per user requirements.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc.
• Provided visual/graphic analysis based on data content.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Extensively worked on creating packages using SSIS and to write more code in SQL in SQL Server.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power BI point.
• Developed various charts and graphs like bar chart side by side, stacked, line graphs, pie charts etc.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.

Environment: s: Tableau 6(Server and Desktop), Tableau 8((Server and Desktop), Tableau 9((Server and Desktop), Tableau desktop 10.4, Tableau server 10, Oracle, SQL Server 2014, Google Big Query - Google Cloud, MS Office Suite, MS Access, MS Excel, MS Project, Windows OS.

Confidential

Pega Quality Analyst Lead

Responsibilities:

• Responsible for planning and reporting Business as Usual QA monthly releases.
• Documentation preparation like scenarios and flow change metrics.
• Expertise in Jira analysis involved in testing to ensure the functionality.
• Conducting functional Scenario analysis with Valid / Invalid inputs under different scenarios.
• Prepared Preparation of Test data, Test cases and testing.
• G@ mapping testing, which involves comparison of the data values entered in PEGA with that of G@ (Forward Mapping), and checking the values are retained in PEGA (Reverse Mapping).
• Interact with Business Analyst for functional specifications discussions and clarifications.
• Ensure testing team is following testing standards, guidelines.
• Ensures Entry criteria are met before starting with testing.
• Ensure Exit Criteria is met and responsible for communicating the same to respective Managers.
• Used Jira studio for defects logging, tracking and reporting the defects.
• Effective communication with cross teams on release deliverables.
• Ensuring issues are managed and project deliverables remains on target time and quality.
• Mentoring team members to ramp-up on the functionality of the application and testing approaches.
• Review test deliverables, Test cases, test results created by team members.
• Create reports (daily status reports and weekly reports), responsible for creating testing metrics and publish it for every release.
• Manage Testers work (during test plan and test execution), ensure testing is completed on time, resolve conflicts arising between team members or with external team members, keep team members motivated.

Environment: s: Pega applications, G@ Mapping, SQL Server, Test Management tool.

Confidential

QA Lead/BI Developer

Responsibilities:

• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created of dashboards for business groups like finance and sales. Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Created Sets, Groups and Data Bins as per user requirements.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based on data content.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Extensively worked on creating packages using SSIS and to write more code in SQL in SQL Server.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power BI point.
• Developed various charts and graphs like bar chart side by side, stacked, line graphs, pie charts etc.
• Extract the data from various sources like SQL Server, Text files, and access into Data Warehouse.

Environment: s: Tableau 6, Tableau Server 6, Microsoft SQL Server 2008, Custom SQL, Microsoft Office 2010, MS Visio, Windows OS

Confidential

Quality Analyst

Responsibilities:

• Product requirements analysis and testing use cases preparation.
• Involved in requirements discussion with Product management team Business analysts.
• Involved in preparing Test cases, test data as per Product requirement.
• Involved in identifying the Test cases for Automation.
• Good ability in writing SQL queries to obtain the information.
• Developed Automation scripts for MAT using Selenium.
• Developed Automation scripts for Create Case and Admin modules using Selenium for functionality testing.
• Involved in Automation scripts execution and results analysis for all weekly (support) and Major Releases.
• Involved in test scripts, review and maintenance.
• Test set creations with required test cases in RTH.
• Conducting functional testing with Valid / Invalid inputs under different scenarios.
• Analyzing test results, interacting with developers in keeping track of status of the bugs.
• Performed regression testing, re-testing and functional.
• Active participation in bug triage meeting.
• Effective communication with developers and Business analysts about bugs and getting them fixed.
• Participated and contributed to business scenarios identification and test data preparation for automation data driven approach.

Environment: s: Java/ J2EE, Oracle, SQL Server, Web Sphere, Web logic