Tableau Developer/admin Resume
New York City, NY
OBJECTIVE:
- To work in a challenging and competitive environment which will suit my knowledge and skills that will allow me to use my skills experience for personal and professional growth.
SUMMARY
- Overall 8+ years of experience in Information Technology with a strong background in Data Visualization usingTABLEAU10.x /9.x/8.x, QlikView 10, Data warehousing and ETL process using Informatica Power Center 9.x/8. x.
- Worked on the development of Dashboard reports for the Key Performance Indicators for the top management. End - to-end experience in designing and deploying data visualizations using Tableau.
- Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
- Extensive knowledge in various reporting objects like Hierarchies, Filters, calculated fields, Sets, Groups and Parameters etc., in Tableau
- Generated Tableau combination charts using Tableau visualization software. And developed maps manually using custom geo-coding and WMS servers
- Extensive experience in PL/SQL and SQL and performance tuning SQL queries in TOAD Knowledge on dimensional data modelling, Star schema modelling and Snowflake modelling Effective communication, interpersonal & professional skills.
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
- DevelopedTableaudata visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
- Extensive experience working as a Business Intelligence Consultant with specialization in Business Objects 6.0/ 6.5/ XIR2/ Crystal XI and Web Intelligence.
TECHNICAL SKILLS
Tools: Tableau Desktop 10.2/9.1 /9.3 , 8.x, Tableau Server, TOAD, SQL-Developer, SAP Business Explorer, BEX Analyzer, Bex Query Designer, SAP-Lumira, Informatica, SQL Server Reporting Services SSRS, MS Suite, MS Visio, MongoDB, ETL.
Web Technologies: HTML, XML, CSS, Middle-Ware, Share Point, Visual Basic
Database: Oracle 8i/9i, /10g
Operating Systems: Windows 7, XP, Unix
Languages: C, C++, Java, PL/SQL
Database Server: Microsoft SQL Server, Oracle, IBM DB2, Access
Scripting Languages: VB Script, Jscript
PROFESSIONAL EXPERIENCE
Confidential, New York City, NY
Tableau Developer/Admin
Responsibilities:
- Developing worksheets with assorted styles like bar, pie, tree map, dual axis, filled maps.
- Creating rich dashboards using Tableau Dashboard and applying actionable insights.
- Write PL/ SQL queries to develop standard procedures and functions for developing reports using SSRS
- Strong experience in relational DB's such as Oracle DBMS, SQL, PL/SQL designing and development.
- Performed GAP analysis of business rules, business and system process flows, user administration, and requirements. Ensured cGMP and compliance requirements (Title 21 CFR Part 11) were met.
- Involved in creating stored procedures, triggers, functions, Indexes, tables, views and other T-SQL code and SQL joins for applications by maintaining best standards to perform efficiently.
- Created multiples sites DEV/QA/PROD and projects within each site for content management Tableau user security through windows Active Directory and row level data security at user level.
- Data blending, data preparation usingAlteryxand SQL for tableau consumption, publishing data sources to Tableau server.
- Created Data Sets from SQL server help client to transfer their Data to AWS Redshift
- AlteryxData blending with multiple data sources, Tableau data objects using SQL queries. Dashboards using interactive parameters, filters, sets, charts and table calculations.
Environment: Windows 7 and Linux, Tableau 9.2,10.2, Tableau server 9.2,10.2, SQL Server 2012/2008/R2, SSRS, SQL, PL/SQL, SQl Developer Oracle, MS Project, AWS Red shift, Oracle.
Confidential, Minneapolis, MN
Tableau Developer
Responsibilities:
- Gathering the requirements from the Business users and understanding the functionality & business rules.
- Preparing functional design document, requirement document & technical design document for reports.
- Developing worksheets with assorted styles like bar, pie, tree map, dual axis, filled maps.
- Implementing user level security to restrict the data by group level and user level.
- Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
- Worked with T-SQL to create Tables, Views, and triggers and stored Procedure
- Worked on Data blending as well as Newly introduced Cross data base joins
- Involved in resolving reporting issues and design issues throughout the reporting life cycle.
- Built Complex Formulas (using "calculated-field" feature) inTableaufor various business calculations.
- Developed complex visualizations using Amazon Redshift.
- Provided resolution to performance problems of dashboards deployed ontableauserver using out of the box performance analyzer tool oftableaudesktop andtableauserver.
- Develop Scripts to load data into tableau and work with multiple data connections including Hadoop/Hive and by data blending.
Environment: Windows XP, Linux, Windows 7,Tableau 8.2,9.2, Tableau Server 8.2,9.2 SQL Developer, MS-SQL 2008 R2, T-SQL, Teradata 12, Netezza, Flat File Microsoft SQL Server 2005\2008 data base.
Confidential, California
SQL Developer
Responsibilities:
- Involved in requirements gathering, analysis, design, development, change management, deployment. Installed and Configured SQL Server 2005 successfully.
- Involved in Login and User Management- Adding logins, roles, groups to the Window NT and SQL Server and maintaining proper security procedures.
- Expertise in Database creation (DDL, DML), performance planning, backup planning and database administration. Worked on Capacity planning involving in estimating and sizing of tables.
- Evaluated database performance and performed maintenance duties such as tuning, backup, restoration. Wrote DTS scripts for effective data transfer.
- Utilized SSRS reporting services to generate diverse types of reports from the database.
- Performed Data Analysis for automating various Customers Order Reports utilizing SQL Reporting Services. Involved in design, programming, deploy and Unit Testing of requested Reports.
Environment: Windows 00/XP,SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL-PLU, Java, Software Development Life Cycle - Agile
