Tableau Developer
Resume:
SNEHA REDDY
Tableau Developer
SUMMARY:
Over *+ years of extensive IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications and Tableau.
Extensive experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
In-depth knowledgeon Tableau Desktop, Tableau Reader and Tableau Server.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
End to end experience in designing and deploying data visualizations using Tableau
Deployed the reports and Scheduled Reports for the use of end users and customers
Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and SAP BO.
Extensive experience working in Windows, UNIX, LINUX environments.
Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphsand Breaks.
Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
Expertise in working with all modules of SAP Business Objects XIR3/XIR2/6.X/5.X,Crystal Reports 2008
Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
Extensive experience in PL/SQL and SQL andin performance tuning SQL queries in TOAD.
Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
Worked extensively with the major functionality of SAP BO ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
Professional in writing complex Formulas, Sub Reports, Summary Reports.
Involved in Trouble Shooting, Performance tuning of reports and resolving issues within SAP BO.
Installation, configuration and administration of Crystal reports and SAP BO.
In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment
Strong working knowledge in software development methodologies like Rational Unified Process (RUP), Agile, Waterfall across the span of various projects
Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2
Excellent data-analysis skills and ability to translate specifications into a working Universe and Report
Experienced in tuning long running SQL queries for better performance.
TECHNICAL SKILLS:
PROGRAMMING LANGUAGES
C, C++, T-SQL, XML,HTML, JavaScript, JQuery, .NET (ASP.NET, C#, VB.NET), UML.
BUSINESS INTELLIGENCE TOOLS
Tableau 6.0/ 7.0/ 8.0/ 8.1/ 8.2,Informatica Power Center 7.1/8.6/9.1, Cognos8.1,8.2, 8.3, 8.4&10,Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI.
DATA BASE
SQL, Oracle 9/10gi, Server 2000/2005/2008/2008R2/2012, MS Access2000, Teradata
OPERATING SYSTEMS
Windows 2000/2003 Server, Vista / XP, UNIX
SDLC TOOLS
Perforce, Team foundation Server (TFS), HP Quality center
PROFESSIONAL EXPERIENCE:
LCI, BURLINGAME, CA OCT 2014 –Till the Date
TABLEAU DEVELOPER
RESPONSIBILITIES:
Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
Involved in creating calculated fields, mapping and hierarchies.
Created drill through reports in dashboard.
Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
Performed Tableau type conversion functions when connected to relational data sources.
Maintained and Installed Tableau Server in all the environments.
Created incremental refreshes for data sources on Tableau server.
Monitored VizQL server, Application Server and data server activity to track performance and system stability.
Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
Administered user, user groups, and scheduled instances for reports in Tableau.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Created report schedules, data connections, projects, groups in Tableau server.
Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
ENVIRONMENT: Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX .
ADVANCE AMERICA, SPARTANBURG, SC AUG 2013 – SEP 2014
TABLEAUDEVELOPER
RESPONSIBILITIES:
Involved in creating dashboards by extracting data from different sources.
Created dashboard using parameters, sets, groups and calculations.
Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
Involved in creating calculated fields, mapping and hierarchies.
Created drill through reports in dashboard.
Involved in creating data blending in case of merging different sources.
Involved in creating a dual-axis bar chart with multiple measures.
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft AnalysisServices.
Performed Tableau type conversion functions when connected to relational data sources.
Maintained and Installed Tableau Server in all the environments.
Created incremental refreshes for data sources on Tableau server.
MonitoredVizQL server, Application Server and data server activity to track performance and system stability.
Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
Administered user, user groups, and scheduled instances for reports in Tableau.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Created report schedules, data connections, projects, groups in Tableau server.
Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
ENVIRONMENT: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX
METLIFE INSURANCE, HARTFORD, CT FEB 2012– JULY 2013
TABLEAU CONSULTANT
RESPONSIBILITIES:
Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
Involved in created stored procedures, views, and custom SQL queries to import data from sql server to tableau.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
Ability to work quickly and under tight delivery deadlines with focus on details.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
ENVIRONMENT: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service
CITIBANK, NY JUNE 2010 – DEC 2011
SQL DEVELOPER
RESPONSIBILITIES:
Involved in different phases of SDLC process of design, development and testing of License Information Repository application using SQL Server.
Participate in up gradation and migration of data from SQL 2000 to 2005
Modified a number of existing stored procedures based on the changes made to existing tables.
Migrated DTS packages to SSIS packages.
Worked with slowly changing dimensions type 2.
Created SSIS packages to perform cube processing from staging to Analysis Services Cube.
Developed aggregated queries to populate the fact tables.
Created a MOLAP Cube on SQL Server 2005 Analysis Services as an alternative prototype to an existing relational data mart.
Handled millions of records on changing dimensions as well as facts in SSAS.
Developed numerous reports off OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts and multiple datasets.
Created reports with Analysis Services Cube as the data source using SQL Server 2005 Reporting Services.
ENVIRONMENT: SQL Server 2005/2008 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports,SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP.
ZETA INTERACTIVE, HYDERABAD, INDIA AUG 2008 – MAY 2010
SQL DEVELOPER
RESPONSIBILITIES:
Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
Provide database coding support to application development team.
Maintain SQL Scripts for changes in database objects.
Provided support for database backup/restore and database transfer activity from test environment to production environment.
Design and develop data transformation processes.
Design and develop SSIS packages for data transformations and importing into new database.
Design T-SQL code blocks.
Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
Provide database coding support to application development team.
Maintain SQL Scripts for changes in database objects.
Provided support for database backup/restore and database transfer activity from test environment to production environment.
Implement application database objects such as tables, stored procedures, user defined functions, views.
Provide database coding support to application development team.
Maintain SQL Scripts for changes in database objects.
Provided support for database backup/restore and database transfer activity from test environment to production environment.
ENVIRONMENT: MS SQL Server 2008 R2/ 2005, SQL Server Management Studio, Crystal Reports 2008 XI.
Contact this candidate