Archita TableauDeveloper Resume
Archita TableauDeveloper Resume
Archita TableauDeveloper Resume
Tableau Developer
[email protected]
+1(609)-853-0657
ProfessionalSummary
TechnicalExposure
Reporting Tools Tableau, Tableau Reader, Tableau Server, Tableau Public, Power BI, Workday, MS
Excel, SSRS, SandDance, Zoho Analytics and Excel Power View.
Languages C, SQL
Operating Systems MacOS, Windows 7/8/10
Office Tools Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access,
Microsoft Outlook, Google Sheets
Software Tools Jira, Zendesk
Methodologies Software Development Life Cycle, Agile, Waterfall, Data Modeling Logical/ Physical/
Dimensional, MS Project
Embedded Systems 8086 Microprocessors, 8051 Microcontroller
Concepts Microprocessors and Networking concepts
WorkExperience
Responsibilities:
• Worked as an architect to advice management and business stakeholders on use of quality business
analytics, tools, and methods to improve efficiency, accuracy, and interpretation of various business
metrics.
• Working on developing dashboards based on downtime of a given product, Health score of a given product
Cost of labour, parts, andProfit.
• Worked on developing dashboards based on given Metrics like Head count of employees by location and
grade, number of releases and additions of employees from current month, current quarter and
comparison of additions and releases of employees betweenquarters.
• Developed and supported reports that are needed to analyze business operations and processes. Gathered
data to be used in the development of high-level analytics and quantitativetechniques.
• Worked on SSIS to combine data from multiple data sources like SQL server, Oracle, Postgres into data
warehouse.
• Worked on SSIS to populate data warehouses, to clean and standardizedata.
• Experience in SSAS to analyse the loaded and do the required transformations and joins the tables to load
the data intocubes.
• Worked on SSRS to create the required reports and deployed them intoserver.
• Worked on migration of SSRS reports toTableau.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in
PowerBI.
• Worked on creating new columns, measures using DAX in powerBI.
• Worked with Aggregation, Counting, Logical, information, text and date functions in creating variablesusing
DAX in Power BI.
• Generated PowerBI dashboards with forecasting, Combochart.
• Worked on various transformations available like join, union, aggregation in Tableau Prep tool.
• Created email notifications for flow failures for flows that are run either on-demand or using a schedule
using Tableau Prep Conductor.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, heat maps, bullet charts, Gantt
charts demonstrating key information for decision-making.
• Worked on performing various dashboard activities such as grouping, sorting, ranking and ordering the data
and using PowerBI / Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Trend
Analysis (Data vsTime).
• Conducted necessary ad-hoc data analysis and quantitative investigations for supporting businessgroups.
• Developed several Postgres SQL Queries using PG Admin for ad-hoc data pullrequest.
• Created customized reports with prompts and features like Conditional formatting, Master -Detail, Drill -
through using Tableaudesktop.
• Developed and/or update existing best practices for SAP Business Objects Performance Management
solutions.
• Developed Business Objects universe for financial and risk reporting, working closely with data warehouse
developers.
• Developed complex queries using Postgres database to drive process automation and reportdevelopment.
• Worked on optimizing and tuning the Postgres views and queries to improve the performance of batch and
response time of data forusers.
• UsedT-SQL for data wrangling and effectively transform the data to be consumed into Tableau.
• Extensively worked in OLTP & OLAP environments that include QA, Production and development.
• Scheduled Dashboards using Tableau Bridge and made them available to users like Hourly, Daily, weekly,
Monthly.
• Worked as a Qlikview Technical Consultant for a wide variety of businessapplications
• Was active in the Server migration and the Fresh Qlikview Installationprocess.
• Conducted user acceptance testing and mentored business users to slice and dice data using filters and
parameters.
• Knowledge of Relational Databases, Relational Data Model, SQL and Data Security Implementation
Concepts inRDBMS.
Environment: Tableau Desktop, Tableau server, Tableau Bridge, Tableau Prep, Power BI, SQL developer,
SSRS, SSAS, SSIS, Azure, Postgres database, Microsoft Excel, Qlikview
Responsibilities:
• Worked with Business Analysts to understand the user requirements, layout, and look and feel of the
application to bedeveloped.
• Created ad-hoc reports to users in Tableauby connecting various datasources.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies
inTableau.
• Technical hands-on experience mainly with full range of Tableau, Tableau Desktop, Tableau Server and
Tableau Public, MS SQL Server, SSIS, SSRS, MS Performance Point Server and Informatica.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using Parameters.
• Used SQL tools like Toad, PL/SQL to run SQL queries and validate the data in the warehouse
• and DataMart.
• Design Ad-hoc reports Analysis Studio and QueryStudio.
• Worked on creating complex reports as per user requirements andSME.
• Created Tabular reports, Charts, and graphs as per customer requirements usingSSRS.
• Made complex chart like Spider chart and funnel chart to better visualize thedata.
• GeneratedDashboardswithQuickfilters,Parametersandsetstohandleviewsmoreefficiently.
• Strong understanding of SDLCprocess
• Used SAS ODS to format reports.
• Optimized SAS code to reduce run time and make the process more efficient.
• Developed SAS code using Macros to run recurring jobs and optimized code.
• Configured flow timeout settings using Tableau Prep Conductor.
• Analyzedthesourcedataandhandledefficientlybymodifyingthedatatypes.Usedexcelsheet, flat files, CSV files to
generated Tableau ad-hocreports.
• Generated tableau dashboards with combination charts for clearunderstanding.
• Experienced in defining and rationalizing complex data models within data warehousingenvironment.
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports user- friendly in
analysis purposes.
• Created dynamic Tableau dashboards with KPIs, Heat Maps, Scatterplots, Bar Charts, Slicers, and Drill down,
Drill up etc.
Environment: Tableau Desktop, Tableau server, SQL developer, SSRS, SSIS, Informatica,
Tableau Bridge, Tableau Prep, Microsoft Excel, MS Access, Microsoft office.
Client:UBER,India Nov 2016 - Jan2018
Role: BI / Tableau Developer
Responsibilities:
• Participated in requirements gathering and translate business requirements into report
visualization specifications designdocuments.
• Translate business requirements into TableauDashboards
• Created and managed plans using JIRAPortfolio.
• Assigned the appropriate resources to the JIRA agile Portfolio - Story,Epics.Produce
highqualityandhighvaluevisualizationsin Tableauthat arewidelyadoptedbyCPI.
• Facilitateddiscussion,decisionmaking,andconflictresolutiontoensureconsistentprogresses.
• Trackedmetricsthatareimportanttotheteam todeliversuccessandcontinuous
improvement.
• Helpedthescrumteamensuretheymeetthedefinitionof'done'foreachproductfeatureand
removed internal and external impediments to theirprogress
• Quickly resolve any internal customers issues raised and publish new versions of dashboards
on a regularbasis.
• ConductedstakeholderJointApplicationDesign(JAD)interviewsandfacilitatedmeetingswith
project teams.
• Translated business user concepts and ideas into comprehensive business requirements and
designdocuments.
• Created project plans in accordance with project management framework standards and
procedures.
• Identified ongoing issues and gaps within project plans, to eliminateimplementationissues.
• Planned, facilitated, and reported on quality assurance testingefforts.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots,
geographical maps, Gantt charts using show mefunctionality.
• WorkwithexistingdatamodeltoproduceaccuratedashboardswithrespecttoRallyandother tools.
• Experience in Data Warehousing, ETL & BItechnologies.
• InvolvedintheuserrequirementgatheringandDesignmeetings.Translatebusinessneedsinto
reporting and analyticrequirements.
• Created different views in workbook to visually analyze thedata.
• Createdextracts,publisheddatasourcestotableauserver,refreshedextractinTableauserver from
TableauDesktop.
• Gathered user requirements analyzed and designed software solution based on the
requirements.
• Building, publishing customized interactive reports and dashboards, report schedulingusing
Tableau server.
• CreatedTableauworksheetwhichinvolvesSchemaImport,Implementingthebusinesslogicby
customization.
• CreatedmanyDashboardreportsforcompany'sdecision-makingpurposeandmadethemKey
Performance Indicators(KPI).
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters,
Sub- Reports, Drilldown, Drill-Through, Multi-valued parametersetc.
Environment: Oracle11g, ABC 11g, OWB 10g Release2, TOAD, PL/SQL, Bigdata (python, java) JDE,
SQL Loader, Microsoft SQL Server.
Responsibilities:
• Created dashboards to analyze summary of risks of all suppliers and associatedsupplyingparts.
• Createddashboardstoanalyzetheriskbasedonvariousriskindicatorsforeachpartsuppliercombinationfor a given
timeperiod.
• Coordinated with business and analyzed therequirements.
• Worked on the modeling, cleaning, and formatting of the data as perthe requirement.
• Created parameters, groups, sets, action filters and globalFilters.
• Generated Contextfilters.
• Worked on calculating the values of metrics related to all risks associated withgiven suppliers.
• Worked on publishing, organizingdashboards.
• Worked on tableau scheduling of extractrefresh.
• Conducted UAT and user trainingsessions.
Responsibilities:
• Gathered user requirements, analyzed, and designed software solution based ontherequirements.
• Played critical role in establishing Best practices for tableau Reporting by conduct meeting with
the clients for gathering reporting requirements; identify the KPI's and developing POC
Dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,
Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed
Reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau
server.
• CreatedRelationships,actions,datablending,filters,parameters,hierarchies,calculatedfields,sorting,
groupings, live connections, and in -memory in both tableau andexcel.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were
any changes in underlyingdata
• Created organized, customized analysis and visualized projects and dashboards to present to executive
leadership.
• Created Complicated Calculation Based LOD (Level of detail)feature.
• Involved in managing the application's users, groups, and integration withActiveDirectory
• Evaluated database performance issues and executeddatabaseoptimization.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with
stakeholders and businessgroups.
• Prepared project reports for management and assisted the project manager in the development of
weekly and monthly status reports, policies, andprocedures.
Environment: Tableau (Desktop and Server), SQL Server, JIRA, Oracle, SharePoint, Agile, Tableau.