We provide IT Staff Augmentation Services!

Tableau Reports Developer And Analyst Resume

3.00/5 (Submit Your Rating)

Newark, DE

PROFESSIONAL SUMMARY

  • Tableau/BI Developer with Over 6+ Years of IT Experience in Business Intelligence and Data Warehousing applications in telecom, Financial, Health Care, Pharmacy and Manufacturing industries.
  • Extensive experience of 3+ years in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau10.0, 9, 9.1, 8.3, 8.2.
  • Worked on creating calculating fields on different Dimensions.
  • Extensive working experience in creating visualizations and Dashboards using Tableau Server, Tableau Desktop and Tableau Public.
  • Experience with Dimensional modeling, star and snowflake schema.
  • Experience in Data Analysis, Dimensional Data Modeling, Data Extraction Transformation & Loading (ETL), Building Cubes, Creating Meta layer, Data Mining, End User Reporting; Web based Reporting & Implementation, Creating Test scripts and user signoff documents.
  • Experience in creating reports using BO/Crystal/Tableau/Cognos reporting Applications.
  • Extensively created and maintained complex Business Objects Universes and Reports using teh Designer and Reporting modules.
  • Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.
  • 3 years of Tableau experience with extensive noledge as a Tableau Developer/SME & Server Administrator with strong understanding of Tableau Architecture, providing teh best practices for deployment and maintenance of Enterprise class dashboards on Tableau Server.
  • Extensively involved in design and development of Tableau visualization solutions using operational dashboards, reports, workbooks on various flavors of RDBMS like Oracle, Teradata and MS SQL Server.
  • Worked on implementing Tableau visualizations and dashboard design with best practices to facilitate in - depth analytics and decision making among business users.
  • Developed Interactive Dashboards, Analytics in Crystal Xcelsius using Live Office
  • Experience using Business Objects Administration, Web-Intelligence, BO Developer Suite using SDK, Application foundation. Broadcast Agent, Auditor, Web Admin tool, Supervisor, Designer, Web Intelligence/Info view
  • Testing, Debugging Reports, managing server for Crystal Reports, Worked in Development, Quality and Production Environments. Preparing Report Prototype, Prepared Report Design Document, Prepared User test cases for teh report
  • Strong technical background, and possess excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder successfully, any responsibility or challenges.
  • Strong experience in building Dashboards/Business Visualizations using Crystal Xcelsius against multiple data sources for Wat if Analysis, Interactive, Decision Support and other purposes.
  • Extensive experience building DashboardsUsing Advanced Multiple Drill Down, Dynamic Visibility, and Alert Features with Flash Variables, web services.
  • Professional in writing complex formulas, sub reports and summary reports.
  • Very good hands-on experience in writing complex SQL scripts/ queries to perform End-to-End
  • Experience in requirement gathering and designing windows and web application solution andDesign Patterns.
  • Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
  • Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS:

Reporting Tools: Tableau 10/9/8, BO 4.1/3.1, Crystal Reports 2008 /XI R3/ XI R2 / R1 / 10 / 9 / 8 (Designer, Reporter, Supervisor), Auditor, Performance Management, Application Foundation, Microsoft Visual Studio SDK using ASP, BO SDK Using JSP.

ETL Data: stage 7.5/7.0/6.x, Informatica 8.0/7.1/6.0 (Power Mart & Power Center)

RDBMS: Oracle 10g/9i/8i/7, DB2, Tera Data, SQL SERVER 2005/2000, MS-Access.

Internet: J2EE, XML, JSP, ASP, VBScript, JavaScript

Languages: PERL, C++, C, VB, Shell Scripting, Unix

OS AIX,: Sun Solaris UNIX, Windows NT/2003/2000/XP.

ToolsER: Studio 7.3.2. Erwin 4.1/4.0, MS Project, TOAD 6.5 and SQL Navigator 4.1, Data Studio 3.1

PROFESSIONAL EXPERIENCE

Confidential, Newark, DE

Tableau Reports Developer and Analyst

Responsibilities:

  • Interacted with business users and performed Gap Analysis of Client requirements.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Worked closely with business power users to create reports/dashboards using tableau desktop.
  • Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we has most users vs. least users.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Connected Tableau server to publish dashboards and visualizations to central location for portal integration.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
  • Involved in report tuning, caching, specifying query governing thresholds, and report optimizations; and created test cases and documented teh test results.
  • Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled teh performance issues TEMPeffectively.

Environment: Tableau Desktop 10/9, Tableau Server, Oracle 10g, SQL Server 2008, Toad 9.0, Agile Methodology

Confidential, Denver, CO

Tableau Reports Developer / Admin

Responsibilities:

  • Delivered a vision that is aligned with roadmap, along with a plan for evolution and iterative updates.
  • Analyze and understand teh existing Reporting system, legacy Excel dashboards and critical backend objects to setup teh base tables and views exclusively for Tableau visualizations.
  • Involve in requirement gathering and interface directly with stake holders and business teams in coordinating teh reporting needs.
  • Implemented few pilots and given demos to Dept. heads and executives to explain teh capabilities and functionality of Tableau tool.
  • Lead and drive teh Reporting team to develop 4 major Tableau visualizations which accommodates various KPIs and metrics related to Inventory, Demand, Sales and Manufacturing departments.
  • Developed dashboards with data being fed from multiple sources like JD Edwards and many other front-end legacy systems.
  • Dashboards included various components and functionalities involving dual axis, combo graphs/charts, complex conditional formatting, trend lines, parameters, filters (extract, context and quick filters) using Tableau desktop.
  • Supported .Net Framework for teh tableau Interface
  • Worked heavily on table calculations and Tableau window functions for KPI’s
  • Work with ETL team to setup aggregate tables, data security tables, Source to Target (STT) transformations and data mappings.
  • Setup Tableau Schedules and assign dashboards to schedules based on users/group security.
  • Worked on converting few SAP Business Objects and Cognos reports into Tableau visualizations.
  • Collaborated with internal stakeholders to drive efficiency and TEMPeffectiveness of teh metrics andreporting in Tableau Enterprise.

Environment: Tableau Desktop and Server 9.23/8.x, Big Data, Hive, SQL Server 2012, Management Studio, SAP Business Objects 4.1, Windows OS.

Confidential

Tableau Developer / SQL Developer

Responsibilities:

  • Understanding existing business model and customer's new requirements.
  • Created workbooks and Dashboards using calculated metrics for different visualization requirements
  • Drew upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
  • Created dashboard views from provider information data to members
  • Extensively created visualization dashboards for teh claims
  • Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
  • Involved in creating dashboards, reports and then published onto teh Tableau server.
  • Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance
  • TEMPEffectively used data blending, filters, actions, Hierarchies feature intableau
  • Created extensive custom joins for blending data from several different data sources
  • Helped customizeTableauServer with Company Logo
  • Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics. Created and assisted users inTableaudashboard development
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Coordinate new data development, which includes teh creation of new structure to meet business requirements or streamline existing processes to reduce overhead on teh existing warehouse with ETL Development team.
  • Collaborated with business users and members of teh BI team, including business analysts, data warehousedevelopers, and managers, to design and develop as per requirement.
  • Created a proof of concept for teh optimal data integration process.
  • CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC.
  • 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

Environment: Tableau Desktop 8.2, Windows XP, SQL, Oracle 11g, MS Access, MySQL, Flat files, CSV files, MS Excel, MS Visio, MS Word.

Confidential

SQL Developer

Responsibilities:

  • Create Database Objects - Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure, Constraints.
  • Transfer of data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server using SSIS/DTS using various features like data conversion etc.
  • Develop, maintain, implement and support all SSIS development & production efforts.
  • Create jobs, Alerts and schedule SSIS Packages and SSRS Reports.
  • Generation of multiple Enterprise reports (SSRS/Excel) from SQL Server Database (OLTP) with various reporting features such as Aggregate, drilldowns, drill through, sub-reports, matrix reports and Ad-hoc reports etc.
  • Experience in COSMOS using scope scripting language visual studio 2013/2015.
  • Scheduling of jobs in teh task scheduler and managing teh task.
  • Assign Read, Write and Execute Permissions for all teh users to access teh server, database and reports.
  • Create a tabular model cube and modified teh Relationship between a Measure group and dimension using SSAS.
  • Implemented Slowly changing dimension (SCD) tables to maintain history.
  • Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
  • Create Monthly and Weekly reports in MS Excel using teh Data Source as SQL Server and COSMOS.
  • Use of TFS (Team Foundation Server) for ticketing and storing teh data into repositories in TFS.
  • Responsible for building reports in Power BI from teh Scratch for POC Projects.
  • Connecting Power BI to different data sources - SQL databases, MS Access, Excel, Flat files.

Environment: MS SQL Server 2008/2012 SQL Server Integration Services, SQL Server Reporting Services, Business Intelligence Development Studio (BIDS), MS Excel, Windows 2008R2, Windows 7, Visual Studio 2013, Scope, Power Shell, C#, Cosmos, TFS, Cosmos Power Query, Power Pivot, Power BI.

We'd love your feedback!