SUMMARY

• A distinguished result - oriented IT Professional over 6 years of experience in Data Warehousing and Business Intelligence technologies with strong experience of data visualization using Tableau and experience in delivering key technologies in Data Design and ETL.
• Extensive experience in Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 7, Tableau 8, 9.X and Tableau 10.X
• Performed analysis of reference data, data sets and asset classes to bring the data into the central repository.
• Very good experience on using Tableau functionalities for creating different Reports, Interactive Dashboards with page and Dashboard Prompts.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Extracted data from SQL Server into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Strong DW- BI skills and SQL skills.
• Widespread knowledge in using report building tools like Power BI, Tableau.
• Good Knowledge on Procedures, triggers, and appropriate User defined functions.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Defined, created and managed the business specifications, technical specifications, and other project documentation for applications development.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL Joins and statements for applications.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems.
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
• Worked on Motion chart, Bubble chart, and Drill Down analysis using Tableau Desktop.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Created SSRS reports such as drilldown, drill through, sub reports, tabular reports, chart reports, matrix report and document map.
• Experience working in Agile and Scrum Methodology.
• An Excellent Team Player with good problem-solving approach having strong communication, leadership skills and ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, SSIS/SSRS, Power BI

ETL Tools: Informatica, DataStage

Database: Oracle, Teradata, MS SQL Server and DB2

Programming languages: SQL, PL/SLQ

Data Modeling Tools: Star Schema Modeling, Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Amazon Redshift, Oracle SQL Server and MS Excel.
• Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data.
• Used Alteryx to publish Tableau data extracts to Tableau Server.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Oracle, Teradata and SQL Server.
• 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.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 7.0/8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel, PL/SQL, T-SQL

Confidential, Austin, TX

Tableau Developer

Responsibilities:

• Worked closely with the business community to gather business requirement and document functional requirement.
• Analyzed requirement and created prototype cases for the business.
• Developed interactive tableau visualization after gathering business requirement.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to business users, project managers and the BI team.
• Actively participated in clarification meeting with the Clients.
• Tested dashboards to ensure data was matching per the business requirements and checked for any changes in underlying data.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created drill through reports in dashboard.
• Involved in creating a dual-axis bar chart with multiple measures.

Environment: Tableau Desktop 8.1, Pl/SQL, MS Excel

Confidential

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of client requirements.
• Involved in reviewing business requirements and analyzing data sources form Excel SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Responsible for upgrading the Tableau 7.0 to Tableau 8.2.
• Installing and configuring of Tableau worker servers.
• Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards using tableau desktop.
• Experience working on Cognos Admin, FM Manager, Report Studio, Transformers.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Involved in writing Business Design Document for Cognos Reporting Section.
• Utilized advance features of Tableau software like, link data from different connections together on one dashboard and to filter data in multiple views at once.
• Effectively used data blending, filters, actions, and hierarchies feature in tableau.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Projected and forecasted future growth in terms of number of customers in developing Area Maps to show details on which states were connected the most.
• Tableau server maintenance, Tableau server backup activity.
• Created users using Tableau Admin and assigning privileges to create report/publishing reports to server.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Enabled the data security filters for the users/groups in an AD.
• Tuned the reports performance using Cache options / Timely refreshes of data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible for creating /delivering monthly reports to business users.

Environment: Windows Server 2012, Tableau Desktop 8.2/8.0/7.0, Tableau Server, SQL Server 2008/2012, MS-Access, MS Excel and JavaScript.

Confidential

Database Developer

Responsibilities:

• Capturing Business Requirements by collaborating with Business owners and Application teams.
• Creating DB objects such as Tables, Indexes, Views, Materialized Views, Sequences and Synonyms.
• Developed functional enhancements for application to enhance the software in performance and features using Oracle PL/SQL.
• Worked on the Low Level and High-Level Design Documents.
• Writing Complex SQL queries, Procedures, Functions and Packages.
• Performing Data loads by using the SQL loader, Imports & UTL files based on file formats
• Using Explain Plan for Performance improvement.
• Performing Process Improvement Initiatives related to Data Collection and Analysis.
• Responsible to provide project work update to the higher management.
• Involved in resolving issues during UT/IT and UAT testing phases.
• Involved in documentation of various functional modules.
• Implementing shell scripts for multiple builds.

Environment: Windows 95/98/2000, Oracle 10g, PL/SQL, SQL plus, UNIX Shell Scripts.