Tableau Data Analyst/developer Resume
Long Beach, CA
SUMMARY
- Over 7+ years of Data warehousing experience with Business Intelligence Tableau 8.0/ 7.0 OBIEE, SAS, OLTP and OLAP Microsoft SQL Server, Microsoft Excel as a Developer in various companies.
- Also had vast experience in administering and creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7 and Tableau 8.
- Involved in all phases of Software Development Life Cycle (SDLC) such as Requirements Gathering, Development, Testing, Migrating BO Universes, Reports, Administering, Security management and production support on various platforms like UNIX, Windows 2008 R2 / 7/NT/2000/XP/98
- Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
- Provided 24/7 customer support to tableau users.
- Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
- Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
- Extensively used Tabadmin and Tabcmd commands in creating backup’s and restoring backup's of Tableau repository.
- Experience in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
- Extensive TableauExperience in Enterprise Environment and TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
- Extensive experience on building dashboards using Tableau.
- Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
- Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
- Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
- Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
- Extensive experience in monitoring the database server for deadlocks, long running queries and tuning the same to improve performance.
- Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS.
- Well versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
- In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
- Working knowledge on reporting using QlikView
- Experience in designing and developing web based and windows based applications using ASP.Net, C#. Net, ADO.Net, Web Services, ASP, IIS, HTML, DHTML, XML and XSL.
- Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
TECHNICAL SKILLS
Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection.
Data Visualization: Tableau, Qlikview, PowerPivot, Excel, SSRS, SSAS, Visual Analytics, Crystal reports XI/2008, Business Objects XI/4.0
Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access.
Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, Crystal Reports
Languages: SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL
Web/App Servers: MS IIS 5/6.0, Apache Tomcat, Web logic Server 8.1/9.2/10, JBoss
Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.
Configuration Management Tools: Team Foundation Server, Visual Source Safe, Clear Case
PROFESSIONAL EXPERIENCE
Confidential, Long Beach, CA
Tableau Data Analyst/Developer
Responsibilities:
- Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
- Gathered user requirements, analyzed and designed software solution based on the requirements.
- Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Effectively used data blending feature in Tableau.
- Defined best practices for Tableau report development.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Executed and tested required queries and reports before publishing.
- Converted metric insight reports to tableau reports.
- Create, customize & share interactive web dashboards in minutes with simple drag & drop.
- See a comprehensive view of your sales pipeline and results.
- Access dashboards from any browser or tablet.
- Involved in installation of Tableau desktop 7.0, Tableau server Application software
- Creating users, groups, projects, Data connections, settings as a tableau administrator.
- Involved in creating dashboards and reports in Tableau 8.1.
- Created report schedules on Tableau server.
- Creating New Schedule's and checking the task's daily on the server
- Maintaining server activities, user activity, and customized views on Server Analysis.
- Worked on tabcmd to schedule the report's and setup email reports using command lines.
- Created Business requirement documents and plans for creating dashboards.
- 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
- Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
- Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended
- Deep experience with the design and development of Tableau visualization solutions
Environment: Tableau Desktop 8.0/ 7.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2008
Confidential, Chicago, IL
Tableau Report Developer
Responsibilities:
- 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.
- Experience in standardizing Tableau for shared service deployment.
- 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, analyzed 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 Server 7.0, Oracle SQL Developer, SQL Assistant, HPQC, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL
Confidential, NYC
Business Intelligence & Tableau Reporting Developer
Responsibilities:
- Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
- Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
- Built complex formulas in Tableau for various business calculations.
- Resolved various performance issues and analyzed the best process distribution for different projects.
- Created and assisted users in Tableau dashboard development
- Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
- Worked on several complex visualizations that all had to do with improving the programs offered to various schools in NYC.
- Developed business process and technical design documentation for each reporting service developed in this project.
- Designed and developed reports such asDrill down, Drill Through usingMicrosoft Reporting Services.
- Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
- Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
- Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
- Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
- Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
- Optimized queries by looking at Execution Plan for better tuning of the database.
- Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.
Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad,MSOffice,TeamFoundationServer,VisualStudio2010,WCFwebservice.
Confidential
Data Analyst, ETL Developer
Responsibilities:
- Extracting the Data from the required sources and loading into the Target system
- Developed complex Talend ETL jobs to migrate the data from flat files to database
- Monitoring the system objects like huge files/ unused indexes and taking necessary steps to improve the performance of applications as well as batch jobs
- Improving the batch jobs performance, by suggesting the effective ways of design to application development team
- Resolution and analysis of critical end-user issues
- Responsible for the system stability
- Integration of the new web services into the other applications, to improve the system performance by reducing the number of connections
- Created Talend jobs to load data into various Oracle tables and wrote few Java code to capture global context variables and use them in the job.
- Created local and global Context variables in the job.
- Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs and daily batches for executing the Talend Jobs.
- Creation of tickets and getting the required approvals to perform any changes in production environment if required
- Performing Analysis like Column Analysis, Table Analysis and Redundancy Analysis necessary for the Data
- Generation of reports using built-in Templates as well as using user defined JRXML Templates by using iReports software in Talend
- Grooming junior associates in the technical and functional areas
Environment: Talend Data Quality, Talend Integration Suite 4x, Oracle 10g/11g, Flat Files, Windows XP, iReport, SVN
Confidential
Business Objects Developer
Responsibilities:
- Worked on all phases of data warehouse lifecycle, from gathering requirements to testing, implementation, and support.
- Analyzed thebusinessrequirements from the given specifications.
- Involved in developing the Audit, Complaint Management, and Event management related reports using Web Intelligence.
- Designed Queries and developed universe for the Webi Reporting needs.
- Worked with ETL developers, DBAs, and systems support in elevating and automating successful code to production.
- Modified the existing Universe and created New Universe against Oracle database as per the reporting requirement to add new features to the reports.
- Developed the reports in Reports Designer using Vertical stacked chart, Pie Chart to view the quarterly metrics.
- Created complex reports using the multiple data providers and synchronized the data providers by linking the commonobjectsto create the common reports.
- Created parameter driven reports according to user requirements using Web I.
- Developed the Quarterly Quality Metrics report for end users to view Quarter wise using Drill Down feature.
- Documented Design Documents for reports to provide the detail design and explanation of the reports. And also documented Unit Test documents to evaluate and validate reports.
- Created Universe consisting of Derived tables to create the report for differentBusinessSegments.
- Involved in troubleshooting and tuning of the existing reports.
Environment: Business Objects6.i, Web Intelligence, Oracle 9i, PL/SQL, TOAD and Windows NT