SUMMARY

• 7+ years of experience in IT Industry
• 3+ years of experience in Tableau (9.x, 8.x) and Informatica
• 4 years of experience in SQL Development
• Data Visualization and Analysis using Tableau to:
• Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Define specification, design and build of Tableau Desktop reports and dashboards
• Ability to drive insight by designing visualizations with logical and meaningful data flow and ability to see patterns.
• End to end experience in Installation and configuration, designing and deploying data visualizations using Tableau.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in creating databases, schema objects, optimizing SQL statements.
• Extensive experience in Data Analysis, Reporting, ETL, Data Modeling, Maintenance, Testing and Documentation.
• Experience in analysis, design, development using Oracle, PL/SQL, SQL, Tableau and Informatica.
• Expertise in creating databases, schema objects, optimizing SQL statements.
• Extensive experience with SQL Server in constructing tables, views, triggers, normalization, indexes, functions, stored procedures, user profiles, relational database models.
• Business intelligence project work Expert with SQL and PL/SQL Experienced with SQL-Server databases.
• Strong understanding of the principles of Data warehousing using Fact Tables, Dimension Tables, Star Schema and Snowflake Schema modeling.
• Good understanding in database and data warehousing concepts (OLTP and OLAP)
• Familiar with entire software development life cycle (SDLC) and various project methodologies such as Agile and Scrum Methodology.
• Strong team member with good communication and analytical skills.
• Excellent problem solving, troubleshooting and decision-making skills.

TECHNICAL SKILLS

BI & ETL Tools: Tableau 8/9, Informatica PowerCenter 6.1, SSIS, SAP BW 3.0, SAP CRM

Databases: Oracle 11g/10g/8i, MS SQL Server 2005, MS Access, DTS, Flat Files

Database Tools: SQL Developer, Toad

Programming Languages: HTML/HTML5, CSS/ CSS-3, PL/SQL, T-SQL, XML, UNIX, DBMS

Operating System: Windows 2000, Linux

Modeling & Other Tools: MS-Office, Putty, MS Visio, Clear Case, Rational Rose

Methodologies: SDLC, Scrum, E-R Modeling, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential, Houston-TX

Tableau Developer

Responsibilities:

• Involved in generating proper data in excel for Tableau Dashboard.
• Extracts data from multiple database to create Tableau Dashboards.
• Involved in installation and patch up gradation of application on servers.
• Responsible for efficient timely backups, project, groups’ creation.
• Scheduled for auto refresh of dashboards on the application server.
• Skillfully Used Link Tables utility to update Access table to reflect the Excel changes.
• Skillful at creating multi-level hierarchy in Tableau Dashboard.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Recommended Dashboards per Tableau visualization features.
• Efficient at using Parameter in calculation field to give flexibility to end user.
• Created global filter for the dashboard that uses different data source.
• Created different kinds of actions to make the worksheet invisible while there is no selection.
• Skillfully created different kinds of actions for navigation and drill down.
• Created custom color pallet, custom shapes to use in dashboard.
• Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create complex Dashboards.

Environment: Tableau 9.x, Windows 7 SP1, Microsoft Excel 2010, Microsoft Access 2010, SAP BW 3.0, Oracle 10g,SQL Server, SAP CRM

Confidential, Cleveland, OH

Tableau Developer/ Data Analyst

Responsibilities:

• Interacted with business user group for domain requirements gathering.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Involved in defining the whole project life cycle, following agile methodology. Analyse business requirements and segregated them into high level and low level
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analysed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Environment: Tableau Desktop/Server 8.x, SQL Server 2008, HPQC, Oracle 11g, Business objects, SQL, PL/SQL, T-SQL, Microsoft office 2007.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Understood the source systems and collected requirements from business users.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Analyzed the source data coming from different sources (Oracle, Flat files).
• Created mappings for cleansing, transforming and loading data into warehouse.
• Used various transformations like Source Qualifier, Expressions, Aggregator, Update Strategy, Sequence Generator, Router and Lookups.
• Involved in writing PL/SQL stored procedures and functions.
• Created Mapplets to facilitate ease and reuse of common mapping logic.
• Created sessions for mappings and utilized workflow manager & monitor to create, schedule and monitor workflows.
• Involved in Unit Testing for Created mappings.
• Involved in code review of Informatica mappings and sessions.
• Worked with UNIX shell scripts to run Informatica workflows.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.

Environment: Informatica PowerCenter 6.1, Oracle 8i, PL/SQL, Toad, Flat files, UNIX,MS Visio, Control M and Windows 2000.

Confidential

MS SQL Server Developer/ DBA

Responsibilities:

• Database Administrator for Development, Test and Production servers with MS SQL Server 2005 on Windows 2000.
• Installed, administered and secured SQL Server 2005 on Server and Clients.
• Designed and implemented logical and physical data models using Visio and Erwin.
• Created database objects like tables, views, indexes etc.
• Created and modified stored-procedures, triggers, cursors.
• Wrote T-SQL for the retrieval of the data.
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Checked Performance Tuning, Indexing, Query Optimization.
• Generated reports using Microsoft Reporting Services and documented SQL Server architecture and overall system network diagrams using Visio.
• Monitored Database using system tools.

Environment: Windows 2000, MS SQL Server2005, DTS, XML, Visio Enterprise, MS SQL reporting Services.

Confidential

SQL Developer

Responsibilities:

• Understanding the business process/requirement and translate them into technical requirements.
• Created Database Objects like Tables, Views, Synonyms and Sequences.
• Extensively used of PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Tested the entire application in testing environment and exported to Production.
• Done the documentation and provided on-site production support.

Environment: Oracle, SQL, PL/SQL, Windows

Confidential

SQL Developer

Responsibilities:

• Creating and altering Tables, Views.
• Creating Primary Keys in the tables at the design time
• Finding appropriate solutions for those requirements in an easy way and preparing low level technical approach documents for them.
• Handled Maintenance, Development support activities.
• Documenting the Database activities and involved in System Documentation.

Environment: Oracle, Windows, Clear Case