SUMMARY

• Around 8 years of experience in Information Technology industry with a strong background in Analysis, Design and Development in the field of Data Warehouse, Business Intelligence, Data Modeling and Implementation of Tableau Desktop 8.X,9.X, Tableau Server.
• Ability to define and develop Report Structure withdata definition, report layout and report definition language.
• Excellent inrendering reports, managing subscriptions,creating reports in Tableau.
• Hands on experience in Developing, Designing and supporting interactive Tableau Dashboard reports.
• Hands on experience in creating Workbooks by Importing data, Defining Relationships.
• Strong knowledge on Software Development Life Cycle (SDLC).
• Experience in working with Marks, Action, Filters, Parameters, Cards, Publisher and Security.
• Experience in creating Derived Columns to fulfil the User Requirements.
• Worked with connecting multiple data sources with Data Blending technique.
• Hands on experience with Live and Extract connections.
• Providing the Security while Publishing to the Tableau Server.
• Excellent in scheduling and deployment of reports in Tableau.
• Familiar with Tableau JavaScript API and Tableau Data Extract API.
• ExcellentVerbal & Written Communicationskills and strong inDocumentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Proven background improving process quality and providing system automation recommendations and strategies to manage solutions and data efficiently.
• Solid experience in translating business requirements into Technical Design Documents.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Hands on experience withDimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, Collections.
• Proficient in writing complex SQL Queries, Stored procedures, creating Indexes, Functions and Triggers.
• Proficient in tuning queries used in the application
• Experience in understanding complicated performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Experience on solving Production Support Tickets or Issues.

TECHNICAL SKILLS

Business Intelligence: Tableau 9.x, Tableau 8.x / 7.x

Database Tools: TOAD, SQL Plus, PL/SQL Developer

ETL Tools: Informatica Power Center 9.1/8.5 /8.1/ 7.1

Database: Oracle 11g/10g /9i, MS SqlServer 2008, Teradata

Operating Systems: Windows XP/7, UNIX, LINUX

Programming Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Coppell, TX

Tableau Developer/Admin

Responsibilities:

• Involved in gathering the requirements andanalyzing the requirements.
• Regularly interacting with customer to resolve issues.
• Responsible for Preparing the Report Design specifications based onthe User’s requirement.
• Involved in Data modeling.
• Extracted data from various sources and performed data blending.
• Creating Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports.
• Created Bar Charts, Tree Maps, Heat Maps and Geographical Maps.
• Created Marks, Actions, Filters, Parameters, Cards, Publisher and Security.
• Created Derived Columns to fulfil the User Requirements.
• Created Parameters for the purpose of dynamic conditional formatting, dynamic column selection and dynamic sorting in the reports to make them more User friendly to End Users.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations and several calculated fields.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Validate the data for each report and review the reports.
• Executed and tested required queries and reports before publishing.
• Coordinating with Business Analyst in validating report requirements.
• Providing the Security while Publishing to the Tableau Server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Used Tableau SDK to create an extract and publish it to Tableau Server.

Confidential, Bloomfield, CT

Tableau Developer

Responsibilities:

• Understand the customer Requirements and the Technical specification Documents.
• Responsible for interacting with the users, gathering requirements and managing delivery.
• 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 Tableau work sheets by connecting TDE.
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
• Experienced with creation of Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau Server logons and security checks.
• Created Parameters to achieve desired functionality.
• Experienced in creating dashboards and various chart views in tableau.
• Created Users, Groups and Set Permissions on Server.
• Formatted the Reports as per the Client requirement.

Confidential

Tableau Developer

Responsibilities:

• Involved in gathering the requirements andanalyzing the requirements and interact with the customer to find the proper information.
• Responsible for Preparing the Report Design specifications based onthe 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.
• Updating the weekly status and tracking the query sheet.

Confidential

Pl/SQL Developer

Responsibilities:

• Collecting user requirements.
• Preparation of 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.

Confidential 

Pl/SQL Developer

Responsibilities:

• Gathering required data, data analysis and documentation of the plan.
• Gathering data elements needed for analysis of the data, decoding flat file data and loading into database tables using SQL*Loader.
• Provided excellent customer service support to external customers.
• Provide technical second-level support for company's Application.
• Responsible for tracking of trouble tickets and resolution of escalated incidents.
• Answer technical support queries and implements fixes for application problems.
• Involved in designing the ETL mapping documents.
• Design the mapping to load the data into the target based on primary, foreign key relationship (constrained based load order).
• Design a mapping to process the incremental changes that exits in the source table.
• Involved in UNIT TESTING of mapping.
• Involved in developing the system test cases for system testing.