We provide IT Staff Augmentation Services!

Tableau Developer/data Analyst Resume

San Jose, CA

PROFESSIONAL SUMMARY:

  • Around 8 years of experience in IT with complete Software Development Life Cycle involved in various aspects of Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
  • Instrumental in developing time critical and mastering expertise in Extract Transform Load development using SQL Server Integration Services, Dimensional Data Modeling and Cube development in SQL Server Analysis Services, explored advanced extensible reporting skills using SQL Server Reporting Services.
  • Involved in all phases of DWBI implementation and development projects during this tenure including Study, Architecting, Design, Development, Implementation, Acceptance Testing and Production support.
  • Well versed in tuning ETL workflows and data warehousing reports in multi - database architecture in key financial systems
  • Esteemed knowledge in areas of Data warehousing and RDBMS Technologies for critical financial Applications.
  • Transformed complex business logic to extract data across multiple sources using well written SQL Queries and PL/SQL stored procedures.
  • Tuned complex business critical reports and ETL
  • Well versed with Scripting languages for various functional, operational and troubleshooting needs. Mastered in operating system concepts and Job Schedulers.
  • Apart from Technical skills well versed in soft skills and mentoring skills. Self starter and ability to work in small or big teams. Conducted technical presentations to peers and new hires to bring them to same level. Demonstrated excellent interpersonal and technical documentation skills and handling multiple projects simultaneously.
  • 4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0,9.0,9.2, 10.X as a developer and Administrator
  • Deep technical knowledge of the Qlikview Platform to design and develop dashboards and visualizations.
  • Experience in various integration options using Tableau Desktop, Tableau Server and Tableau Reader to minimize overall end user licensing requirements
  • Experience in Data analysis, with good data modeling exposure. I am a great team player and very easy to work with.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 10.x,9.X,8.X 2008R2/2005/2000,Tableau Admin, SSRS, Micro strategy, Qlik BI, Alteryx, ObIEE 11.X

ETL Tools: DataStage

Web server: IIS Web Server, Apache, Tomcat

Databases: Teradata, Aster Tera data, MS SQL Server 2005/2008/2012

Tools: MS Excel, MS Word, MS PowerPoint, MS project etc.

WEB Technologies: HTML.

PROFESSIONAL EXPERIENCE:

Confidential, San jose, CA

Tableau Developer/Data Analyst

Responsibilities:

  • Performed best BI solution (reports, dashboards, scorecards etc.) using Tableau 10.x
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
  • 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.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Environment: Tableau 10.X Desktop/ Server Spark/Hive, Excel reports.

Confidential, San Francisco, CA

Tableau Developer/ Admin

Responsibilities:

  • Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau 10.x
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
  • Worked on Excel reports weekly, Monthly.Maintained Credit Card reports worked with product managers and business users extensively.
  • Worked on reports existing in Micro strategy .Developed some ordinary reports in the micro strategy.
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
  • 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.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Updating weekly data and monthly in various excel reports and constantly talking with Business users and product managers and working on excel reports.
  • Develop load scripts for extracting, transforming and loading data into Tableau applications.
  • Worked on reports existing in Micro strategy .Developed some ordinary reports in the micro strategy.

Environment: Tableau 10.x Desktop, MS SQL Server 2008R2/2005, Teradata, , Aster Tera data Windows 7, Micro strategy, Phython,Excel reports.

Confidential, Plano, TX

Data Analyst / Tableau Developer/Admin

Responsibilities:

  • Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau 9.1
  • Work for EGE pod team where the requestor gives some kind of information which we need to do some enhancements and changes in the code and creating additional logics in Homebase Mortgage.
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
  • Loading live data into database and running the applications which are created in Tableau and sending them to users frequently.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Develop load scripts for extracting, transforming and loading data into Tableau applications
  • Monitoring daily jobs and make sure of them completed successfully.
  • Loading Daily data, weekly data and monthly data into the tables in Teradata development and production.

Environment: Tableau9.2, 9.1 Desktop, MS SQL Server 2008R2/2005, Teradata, Windows 7, Management Studio

Confidential, Houston, TX

Sr Tableau Admin/Developer

Responsibilities:

  • As part of the Development team, Designed and developed innovative dashboard, analytics, and reports using SSRS and Tableau 8.2
  • Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau
  • Created Stored Procedures to migrate data from Flat File Structure to a Normalized Data structure
  • Created Test Report Dashboards that helps in visualizing several thousands of App Status using SSRS and Tableau 8.2
  • Created Tableau and SSRS dashboards to know the App Status of machine for user/ organization
  • Created Adhoc reports in SSRS and Tableau 8.2 to visualize top 10 incompatible Apps based on User count
  • Developed stacked bar chart in SSRS and Tableau 8.2 for the top level management to view the Test Status of Apps across the organization
  • Designed/ developed generalized dashboards using SSRS and Tableau 8.2, which are helping Administrators to migrate over 25K machines form one environment to another
  • Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up), List, crosstab etc. using Tableau.
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports
  • Involved in project planning, scheduling for database module with project managers
  • Discussed with business people to understand the rules for defining the Test Status of Apps at the report level
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine
  • 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
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images and Maps
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report development
  • SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting
  • Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)
  • Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS
  • Generated Reports using Global Variables, Expressions in SSRS 2008
  • Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS. Developed a High level dashboard using SSRS 2005
  • Analysis of data for the purpose of Product Version Mapping

Environment: Tableau 8.2/8.4 Desktop, MS SQL Server 2008R2/2005, SSIS, SSRS, Windows 7, Management Studio

Confidential, Columbus, Ohio

Tableau Developer

Responsibilities:

  • Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
  • Worked on loading the data from several flat files sources to Staging using Teradata Multi load, Fast load.
  • Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
  • Written Teradata BTEQ scripts to implement the business logic.
  • Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes, Semantic Layer etc.) using Tableau
  • Develop load scripts for extracting, transforming and loading data into Tableau applications
  • Design and develop new interface elements and objects as required, developed Macros, SET ANALYSIS to provide custom functionality using Tableau
  • Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Used Cognos Report Studio (10.1) to develop reports for managed reporting and scheduling. Developed List Crosstab reports, Charts, master detail reports etc.
  • Thorough knowledge on Cognos Framework Manager modeling tool to import and establish cardinality and publish packages to develop Cognos Reports.
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
  • Used Parallel load utilities such as Multi Load, Fast Load, BTEQ for applications which we load data on daily basis, weekly basis . monthly basis.
  • Monitoring daily jobs and make sure of them completed successfully.
  • Loading weekly data and monthly data into the tables in Teradata development and production.
  • Written Fast load and Multi load scripts to load data into the table.

Environment: Tableau 8.0.1 Desktop, Teradata, MS SQL Server 2008,SSIS, SSRS, SSAS, Hadoop, Windows 7/XP, Management Studio.

Confidential, IL

BI/ Tableau Developer

Responsibilities:

  • Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
  • Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
  • Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
  • Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
  • Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
  • Working with User for requirements and part of the team developing the software.
  • Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
  • Designed Tableau Workbooks, Tableau Reports, Dashboards and Tableau Administration.
  • Scheduled reports debugged issues and provided resolutions for Tableau.
  • Done performance tuning to optimize the run time.
  • Changed stored procedures according to the new hierarchy.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data using Tableau.
  • Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements.

Environment: Tableau developer, Admin, SQL Server SAP HANA, SQL (SSAS, SSIS, SSRS), MS Access 2000 & Windows Server 2000.

Confidential

BI Developer

Responsibilities:

  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. Perform unit testing at various levels of the ETL.
  • Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
  • Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
  • Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS. Developed a High level dashboard using SSRS 2005.
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
  • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Wrote and integrated stored procedures to generate the special reports according to client’s need.
  • Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
  • Involved in migration and Conversion of Reports from SSRS .
  • Developed complex SSAS cubes with multiple fact measures and multiple dimensions.

Environment: SQL Server Enterprise Manager, MS SQL Server 2008R2/2005, MS Visual Studio 2008/2005, SSIS, SSRS, OLAP, ETL, T-SQL, OLTP, C#, VB.Net,

Hire Now