Tableau Lead / Tableau Subject Matter Expert Resume
Portland, OregoN
SUMMARY:
- Over9+ years of experience in IT industry as a Sr. BI Developer.
- Extensive experience in Tableau Desktop, Tableau Server in various version of tableau including Tableau 7/8/9.x/10.x Proficient in data integration between different sources and reporting the same on Tableau environment.
- Extensive experience in SAP Business Objects development.
- In - depth knowledge of Tableau Desktop, Tableau Server, Tableau Reader, Tableau Online, Tableau Public and Alteryx for extracting data in to TDE files.
- Experience in developing Performance Dashboards, Score cards, Metrics, KPI’s, What if analysis, Prompts, Drills, Trend lines, Reference lines, advanced chart types, rich graphic visualizations
- Experienced in interacting with users, gathering requirements, drawing up Business / System requirements study, system analysis, unit testing, System integration testing, production support, creation of Service Request / TARS and trouble shooting.
- Involved in end-to-end Project development lifecycle in terms of requirements gathering and analysis, system study, designing, testing, de- bugging, documentation and implementation.
- Good understanding of Tableau architecture, design, development and end user experience
- Enthusiastic and project-oriented team player with good written and oral communication skills.
- Experience in conducting training to the end users.
- Experience in developing interactive dashboards in using Tableau with different data sources like Oracle, SQL server and flat files, convert them into TDE files and make use of them in dashboards to improve performance.
- Experience working with the complete Business intelligence project life cycle of -Administration, Business analysis, Meta data Modelling, security analysis, Development, testing and release management.
- Maintained project schedules and tasks. Worked with project managers and other team members.
- Experience in coordinating with offshore team on technical development and code review.
- Experience in installing and configuring SAP BusinessObjects 3.x and 4.x
- Expert technical skills in SAP BI4.1/4.0, BOXI3.1 and BOXIR2.
- Experience in migration from BusinessObjects XI to 3.1 and to BO 4.x
- Strong experience in universe development using InformationDesignTool(IDT), UniverseDesignTool(UDT).
- Experience in creating MultiSourceUniverses using InformationDesignTool (IDT).
- Experience in creating Users and UserGroups and scheduling reports using Central Management Console (CMC).
- Experience in creating dashboards using SAP Lumira.
TECHNICAL SKILLS:
BI TOOLS: Tableau 6/7/8/9, SAP BI4.2/4.1 / 4.0 / XI 3.1 / XI R2, Crystal Reports, SAP Explorer, SAP Lumira, QlikView11, XcelsiusDATAMODELS: Toad Data Modeler.
METHODOLOGIES: Agile Methodology, Waterfall Model.
ETL Tools: SQL Server Integration Services (SSIS), Alteryx, Informatica Power Center.
DATABASE: SQL Server, Oracle, SAP BW, Teradata and DB2.
LANGUAGES: HTML., CSS, Java and T-SQL
PROFESSIONAL EXPERIENCE:
Confidential, Portland, Oregon
Tableau Lead / Tableau Subject Matter Expert
Roles & Responsibilities:
- Interacting with client and gathering requirements.
- Preparing technical design documents, and gets sign off from client.
- Suggested new ideas for best approaches in dashboard development as well as
- Designing and optimizing data connections, data extracts, refreshing extracts by schedulingon daily basis in Tableau Server.
- Developed complex and dynamic dashboards using the Tableau Desktop and published them in server.
- Designed and deployed rich Graphic visualizations with Drill Up and Drill Down options as well as Drop down Menu options, Parameterized and Linked reports, Local and Global filters, context filters using Tableau desktop.
- Developed multi colored 80 / 20 Pareto analyses, Tornado charts, Quadrant Report, Bubble charts using Scatter Plot chart, Stack Bars, Line Graphs, Pie Charts and Heat Maps waterfall to find analyze key business metrics like Units, GSP Bookings, GEO Bookings and GPM %.
- Tested dashboard functionality as well as look and feel of the content before deployment
- Involved in User acceptance testing and fixed the defects.
- Performedcode review and data validation during unit testing.
- Prepared proof of concept dashboards for different functionalities and presented to client.
- Categorized dashboards into four areas like Division, Category, Leadership, and Archive, placed them as images with dashboard links in landing page form where users can access required dashboard.
ENVIRONMENT: Tableau 9.3 / 10, Oracle 10g.
Confidential, San Jose, California
Sr. Tableau Developer
Roles & Responsibilities:
- In-depth experience in dashboard development and report development using Tableau Software
- Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server
- Generated tableau dashboards with Tree Maps, Geo Maps, Stack Bars, Line Graphs, Histograms, Pie Charts, Donut charts, Heat Maps, Scatter Plots for showing Trends with Dual Axis
- Migrated SAP BusinessObjects reports to Tableau by auditing the usage of the reports, engaging the users and re-evaluated the tables / views / procedures
- Experienced in designing and developing multiple analytical reports from multiple data sources by using Alteryx data blending on a single worksheet in Tableau Desktop.
- Utilized the tableau web data connectors to connect to the Google sheets
- Tested dashboard functionality as well as look and feel of the content before deployment
- Used the tabcmd to refresh the extract and generated the .pdf/.csv/.png file
- Created and restored backups of the tableau repository using the tabadmin command
- Led a team of developers and coordinated technical efforts
- Perform Code Review and Data validations on extracted data
- Provide data hosting support and fix the issues reported by the testing team
ENVIRONMENT: Tableau 8/9, Oracle 10g, Oracle, Alteryx.
Confidential, Dallas, Texas
Tableau Developer / Senior Software Engineer
Roles & Responsibilities:
- Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
- Extensively used SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity and developed complex custom SQL scripts to use as Tableau data sources.
- Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop Down menu option and Parameters using Tableau.
- Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
- Building, publishing customized interactive reports and dashboards, report scheduling using Alteryx in Tableau Server
- Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
- Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
- Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
- Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
- Actively participated in clarification meeting with the Clients.
- Mentored business power users to create reports/dashboards using tableau desktop.
- Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
ENVIRONMENT: Tableau 8, Oracle 11g, Alteryx.
Confidential
Tableau Developer / Senior Software Engineer
Roles & Responsibilities:
- In-depth experience in dashboard development and report development using Tableau Software
- Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server
- Developed complex and dynamic dashboards using the Tableau Desktop and published the reports
- Designed and deployed rich Graphic visualizations with Drill Down and Drop down Menu options, Parameterized and Linked reports, Local and Global filters, context filters using Tableau desktop
- Generated tableau dashboards with Tree Maps, Geo Maps, Stack Bars, Line Graphs, Histograms, Pie Charts, Donut charts, Heat Maps, Scatter Plots for showing Trends with Dual Axis
- Created adhoc reports to analyze the data per user requests using the Sets and Groups
- Extracted, Transformed and Loaded the data into flat files and SQL Server, IConnect from various bank systems and created the dashboards using Data Blending.
- Migrated Cognos reports to Tableau by auditing the usage of the reports, engaging the users and re-evaluated the tables / views / procedures
- Utilized the tableau web data connectors to connect to the Google sheets
ENVIRONMENT: Tableau 6/7, Teradata.
Confidential
SAP Business Objects / Senior BO Developer
Roles & Responsibilities:
- Understanding the functional documents, report templates, (Entity Relationship) ER diagrams and database tables to meet the user’s requirement by creating the Universe and Reports.
- Resolved Loops using Contexts and Alias.
- Implemented Row Level Security to restrict the data for different countries.
- Created different Web Intelligence reports as part of requirement.
- Created Hyperlinks to open from one report to another using Opendoc function.
- Prepared technical design documents for universes and reports.
- Prepared release notes for production releases.
- Created simple Xcelsius dashboards based on client request.
ENVIRONMENT: BusinessObjects XI 3.1, Windows 2000 server/XP, Oracle 9i.
Confidential
SAP Business Objects / Senior BO Developer
Roles & Responsibilities:
- Involved in requirements gathering and analysis.
- Generated various reports on Daily, Monthly and Yearly basis.
- Used different functions like Logical, Numeric, Dates and Variables to fulfill the report requirements.
- Involved in defect fixing Confidential the time of User Acceptance Testing and used Quality Center Tool to track and update the status of the defect.
- Created Publications for various reports to burst the reports into various locations.
- Involved in UAT to fix the defects.
ENVIRONMENT: BusinessObjects XI R2, Windows 2000 server/XP, Oracle10g.