SUMMARY:

• Around 8 years of experience in Information Technology industry with a strong background in Data Analysis, Data Integration, Data Warehousing and Business Intelligence.
• Strong knowledge on all phases of Software Development Life Cycle (SDLC), worked on Waterfall and Agile methodologies.
• Worked in Telecom, Sales and Healthcare domains.
• Solid experience in translating business requirements into Technical Design Documents.
• Experience in installing, configuring and upgrading Tableau Server.
• End to end involvement in designing, developing and deploying data visualizations using Tableau.
• Proficient in Data Visualization, Reporting, Analysis, Pie Charts, Bar Charts, Area Charts, Scatter Plots, Geographic Maps and making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive knowledge in different reporting objects like Hierarchies, Calculated fields, Filters, Sets, Groups, Parameters, etc., in Tableau.
• Knowledge on Tableau REST API and Tableau JavaScript API.
• Involved in analyzing data from various sources like BigQuery, Oracle, SQL Server and Excel.
• Experience with ETL tools like Informatica Power Center.
• Knowledge on Dimensional Modeling, ER Modeling, Star Schema, Snowflake Schema, Nested Tables, Slowly Changing Dimensions, FACT and Dimensional tables.
• Proficient in writing complex SQL Queries (Joins, Common Table Expressions, Indexes, Views) and stored procedures.
• Communicate with QA and System Administrator teams.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Reporting Tools: Tableau 10.5/10.3/10.1/9.1, Cognos 8.x, MS Excel

Database Tools: Google BigQuery Web UI, SQL Developer 4, SQL Plus, SQL Loader

ETL Tools: Informatica Power Center 9.x

Database: Google BigQuery, Oracle, MS SQL Server, MySQL, PostgreSQL

Operating Systems: Windows XP/7, UNIX (Redhat Linux 6.8), Windows Server 2012 R2

Programming Languages: SQL, PL/SQL, Batch & Shell Scripting, HTML

Microsoft Office Tools: MS Word, MS Excel, MS Access, MS PowerPoint, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Roswell, GA

Tableau Developer/Administrator

Responsibilities:

• Worked with Business Analyst to understand the user requirements, layout, and look and feel of the application to be developed.
• Installed and Configured Tableau Server on Windows Server 2012 R2.
• Created Sites, Projects, Users Groups, Users and assigned permissions as required.
• Preparing dashboards using calculated fields, parameters, calculations, groups and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Used Google BigQuery as the data source for Tableau ad - hoc reports and dashboards.
• Generated tableau dashboards with combination charts for clear understanding.
• Created the reports using charts like Pie, Bar, Stacked Bars, Line, Dual Axis, Heat maps etc. to make the reports user-friendly in analysis purposes.
• Created custom admin views using Tableau internal PostgreSQL database to track user activity and shared with internal users.
• Implemented dynamic conditional formatting, dynamic column selection and multiple conditional formatting within the reports.
• Creating and updating tables, views in Google BigQuery.
• Executed Batch scripts to automate the process of Tableau server daily backups.
• Used TabJolt to conduct Load/Performance Test on reports.
• Conducted Performance Monitoring on dashboards.
• Enhanced the performance of the reports by performing all possible aggregations at the database level.
• Tested reports and published Tableau dashboards on to server and provided production support for Tableau users.
• Involved in embedding the Tableau views into web application and also displaying user’s custom views as new reports within the application.

Confidential, Irving, TX

ETL/BI Developer

Responsibilities:

• Involved in gathering and analyzing the requirements, translating them into technical specification documents.
• Created ad-hoc reports to users in Tableau and Excel by connecting various data sources.
• Develop ETL applications based on the business rules, scheduled work flows and data transfers by analyzing the traffic between data centers.
• Design, develop and test the validations on the source data and develop appropriate reports and dashboards.
• Developed shell scripts to validate the flat files.
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, grouping in Tableau.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables and combination charts in Tableau.
• Involved in creating views to import data from Oracle to Tableau.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• 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.
• Involved in creating and refreshing tables and views.
• Provided Row Level Security while publishing reports to the Tableau Server.
• Administered users, user groups, and scheduled instances for reports in Tableau.
• Conducted Performance monitoring to long running dashboards.
• Coordinate with the System Administrators, Network Administrators and testing teams
• Reporting the data conversion metrics on a weekly basis to the client using Tableau and Excel Pivot tables.
• Coordinate with QA and UAT testing teams.

Confidential, Peoria, IL

Tableau Developer

Responsibilities:

• Understand the customer Requirements and the Technical specification Documents.
• Responsible for interacting with the users, gathering requirements and managing delivery.
• Creating row level security for tableau reports.
• Installed and configured tableau server in a multi-server environment.
• Developing data model to create reports and dashboards.
• Implemented Binning & Blending concepts in my Tableau Reports.
• Worked on Individual Axis, Blended Axis and Dual Axis concept while working with reports.
• Created Work sheet by using calculations and aggregations.
• Created reports using dynamic conditional formatting.
• Involved in refreshing the Data Extracts and Auto updates in Dashboards.
• Created Context Filters, Sharing Filters, Quick Filters in the reports.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
• Created Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau Server logons and security checks.
• Created Parameters to achieve desired functionality.
• Created Users, Groups and Set Permissions on Server.
• Experience working with network & other teams setting up Load Balancers, SSL security.
• Written Custom SQL queries to extract the data.

Confidential, Columbus, OH

Tableau Developer

Responsibilities:

• Involved in gathering the requirements and analyzing the requirements and interact with the customer to find the proper information.
• Responsible for Preparing the Report Design specifications based on the User’s requirement.
• Extracted data from various sources and performed data blending.
• Created different type of charts.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Coordinate with QA and UAT teams regarding data validation.
• Updating the weekly status and tracking the query sheet.

Confidential, Minneapolis, MN

Pl/SQL Developer

Responsibilities:

• Collecting user requirements and preparing use cases .
• Converting the user requirements to High level system requirements.
• Review of High Level Design documents.
• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Importing and exporting the data into multiple environments.
• Worked with ETL team involved in loading data to staging area.
• Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.