SUMMARY:

• Over7+yearsofDataWarehousingexperiencewithBusinessIntelligenceTableau 10.5/10.0/9.0/8.0/7.0 ,, SAS,SQL,MicrosoftExcel,MicrosoftOfficeasaDeveloper/Analystinvariouscompanies
• KnowledgeinDataJoining,Blendingofdata,Crossdatajoinsfromdifferentdatasources.
• ExtensivelyworkedincreatingComplexFiltersandCalculated felids forComplex reports.
• WorkedwithLiveConnections,Extract,DataSourceFilters,GlobalFilters,QuickFilters, Parameters,ContextFilters,ActionFilters,SetsandGroups
• ExperienceinTableauDesktopforAnalysisandDataVisualizations;TabularReports,TreeMaps,HeatMaps,LineCharts,AreaCharts,DualAxisCharts,GeographicMaps,PieCharts,differenttypes of BarCharts,BumpCharts,WaterFallCharts,ButterflyCharts,DonutCharts,PyramidCharts,PageTrailsand Density Chart.
• InvolvedincreatingVisualizations,DashboardsandWorkbooks,StoriesasneededusingTableauDesktopandpublishingonTableauServer,creatingReportswithappropriatedesignandlayoutasperrequirementsfromEnduserusingTableau
• ExtensiveknowledgeindealingwithRelationalDatabaseManagementSystems, includingNormalization,StoredProcedures,Constraints,Querying,Joins,Keys,Indexes,DataImport/Export,Triggers,Cursors..
• InvolvedinwritingComplexSQLQueriesandcreatingCustomReportsinTableau,TestingofTableauReportsincludingDataValidationwithdifferentTestscenariosbeforepublishingonTableauServer
• ExperiencetransformingcomplexbusinessrequirementsintorichdatavisualizationsusingTableau.
• ConnectingtodifferenttypesoffileslikeExcel,MicrosoftAccess,Text filesanddifferentServerslikeMicrosoftSQLServer,Oracle,MySQL,Teradata.
• Manipulating,cleansing&processingdatausingExcel,Access,SQLandSAS.
• ExtensiveusedTabadminandTabcmdcommandsincreatingbackupsandrestoringbackups fTableaurepository.Implementedflexibleviewofdashboardbyusingtableau.
• CreatedincrementalrefreshesfordatasourcesonTableauserver.
• ImprovedDashboardsperformanceinTableauusingExtracts,usingappropriatefilters likeDatasourcefiltersandContextfilters.
• Abilitytohandlemultipletasksandworkindependentlyaswellasinateam.
• BuiltdatawarehouseforMicrosoftAdventureworks2012database
• CreatedaStarSchema(Facts&Dimensions)usingExtract,Transform,Loadprocess(SSIS).
• Developed&loadedadimensionalmodelDatawarehousewhichisusefulforOLAPpurposes.
• ExperienceinusingpublisheddatasourcesandDatablendingtechniques.
• CreateViewswithFormattingorstandardtemplates,Applyingsorts,calculations
• Involvedinrequirementgatheringfromuserthroughmeetings,understandingthebusinessfromenduserandtechnicalperspective.
• ExtensiveExperienceinworkingwithTableautechnicalsupport,troubleshooting,reportdesignandmonitoringoftheserverusage.
• ExtensivelyworkedondatabaseslikeOracle,Teradata,MySQL,Microsoft SQLServer
• StrongwrittenandVerbalCommunicationSkills.
• ExcellentAnalytical,logicaland ProgrammingSkills.
• ExperienceinworkinginWaterfall,Agile
• ExtensiveknowledgeinvariousreportingobjectslikeFacts,Attributes,Hierarchies,Transformations, filters,prompts,Calculatedfields,Sets,Groups,Parametersetc.,inTableau.
• ExperienceindocumentingthetestingprocessusingMS - OfficetoolsincludingMS-Word,MS-Excel,andMS-Project.

PROFESSIONAL EXPERIENCE:

TableauDeveloper

Confidential - JerseyCity,NewJersey

Responsibilities:

• CapturedrequirementsbywhiteboardingwithBA'sandProductManagers
• DevelopedclutterfreeTableaudashboardsforvariousproductlinesanddepartments
• Setuptableaudatasourcesandrefreshschedulesinserver
• PlayedmanykeyrolesinthisprojectlikeDeveloper,Analyst
• Designedclean,easytouse,intuitivedashboardsconsideringenduserneeds
• EffectivelyutilizedTableaufeatureslikeparameters,calculatedfields, filters toprovideefficientdatavisualizationsolutionstothecustomer.
• EffectivelyusedTableauMarkstovisualizedata
• UsedCustomSQLtomanagecomplexdatarequirementsfromlegacysystemsandOLTP/OLAPsystems
• UpgradedtheexistingserverversiontoTableau10.4andsuccessfullymigratedexistingworkbooksanddatasources
• WorkedextensivelyincreatingdashboardsusingTableauDesktopandpublishedthemonTableau Server
• Tableaudashboardlayoutswereeffectivelyusedtogiveinteractivevisualanalysisexperience totheenduser.•HandledthehugedatavolumebyusingTableauextracts
• Usedadvancedconcepts-blending,LODtomeetthecustomerrequirements
• Useddashboardfilteractions,forecasting,tablecalculationstomeetuserrequirements.
• ScheduleddatarefreshonTableauServerfordailyandmonthlyincrements
• ExperienceinsettingupandusingbackgroundimageasMap
• WorkedwiththedataarchitectsandETLteamtofinalizethedatamodel and transformationsforthedatamart
• AssistedQAteaminunderstandingbusinessprocessandhelpedtheminsuccessfulcompletionofUnitTestingandIntegrationTesting
• DefinedandusedbestpracticesforTableauUIdesign
• Coordinatewithusertogatherthereportingrequirements.
• InvolvedinbuildingtheETLarchitectureandSourcetoTargetmapping toloaddataintoData warehouse.
• Createdmappingdocumentstooutlinedataflowfromsourcestotargets.
• ExtractedthedatafromtheflatfilesandotherRDBMSdatabasesintostagingareaand populatedontoDatawarehouse.
• Extraction,TransformationandLoading(ETL)ofdatabyusingSSIS.
• Extractedsourcedatafromflatfiles,OracleandloadedtoDimensionsinOracle.
• WorkedincoordinationwithClientsforfeasibilitystudyoftheprojectinTableau and drawingupthetimelinesandDBTeamsfordesigningthedatabaseasperprojectrequirement.
• CreatedUsers,UserGroupsandProjectsthroughTableauserverWebandassignedrolesandpermissionsforTableauUsers.
• ScheduleddatarefreshonTableauServerforweeklyandmonthlyincrementsbasedonthenewchanges to ensurethattheviewsanddashboardsweredisplayingthechangeddataaccurately.
• CreatedcomplexExecutivedashboardsusingTableauDesktopthatwaspublishedforthebusinessstakeholdersforanalysisandcustomizationusingfiltersandactions
• ImplementedvariousdataconnectionsfromdatasourcetoTableauServerforreportand dashboarddevelopment
• MigratedthePowerBiServicingReportstotheTableau
• Workedondifferentareasofbusinessservicing,Consumerlending,HR,CaptialMarketsandBankingSector.•Expertincreatingadual-axisbarchartwithmultiplemeasures.
• Extensivelyinvolvedincreatinggraphsandchartsbyusingmeasuresanddimensionsdatafromvariousdatabasesbyusingjoinsandblending.
• PreparingDashboardsusingcalculations,parameters,groups,sets,filtersInTableau.
• WorkedonMotionchart,Bubblechart,DrilldownanalysisusingTableauDesktop.

Environment: TableauDesktop2018.2.0,TableauServer,MSOffice2007/2010,SQLServer2012,Oracle11g,Windows7,MicrosoftExcel,Powerpoint,PowerBi.

BI/TableauDeveloper

Confidential - Riyadh,KSA

Responsibilities:

• InvolvedinfullprojectlifecycleofSDLCandcoordinatedwithallprojectteams ofFinancialsectoroftheBank.
• InteractedwithSubjectMatterExperts&EndUsersandgatheredbusinessrequirements.
• ResponsibleforwritingBusinessRequirementsDocument,UseCaseSpecifications,FunctionalSpecificationsDocument.
• PerformedGapanalysisbyidentifyingexistingsystem,documentingtheenhancementstomeet theendstaterequirements.
• ImplementedtheTableauprojectsusingAgile/Scrumdevelopmentmethodology. Designed&developedabusinessintelligencedashboardusingTableauDesktop,allowingexecutive managementtoviewpast,currentandforecastsalesdata.
• CreatedmultipleVisualizationreports/dashboardsusingDualAxescharts,Histograms,Filledmap,Bubblechart,Barchart,Linechart,Treemap,BoxandWhiskerPlot,StackedBaretc.
• UsedSSIStocreateETLpackagestovalidate,extract,transformandloaddatafromODStorelateddestinationdatabases.
• IntegratedTableauDesktoptoOBIEEtorecusethemetadatalayerandcalculationsand incorporatedtableauviewsinOBIEEdashboardsusingiframes.
• MigrateddatausingdifferentSSISpackagesandintegrateddataintothedatawarehouse.
• Createdandadministereduser,usergroups,andscheduledinstancesforreportsinTableauServer.
• Createddashboardsusingcalculations,parametersinTableau.
• CreatedadvancedanalyticaldashboardsusingReferenceLines,BandsandTrendLines.
• Experienceindifferentformattingtechniques,usingAnnotationsandMarkLabel.
• DevelopedeffectiveandinteractiveDashboardsusingParametersandActions.
• SettingtheuserpermissionsinTableauSever.
• Maintainingserveractivities,useractivity,andcustomizedviewsonServerAnalysis.
• PreparedproofofconceptforbestpracticesinTableaudeployment.
• Providedbusinesssolutionsbyanalyzingvarioustrends,risksandpatternsinthedatausinginteractivereports.
• WorkingontheSQLtuningandoptimizationoftheBusinessObjectsreports.
• Extensivelyusedadvancedfilters,groups,actions,complexcalculationsinTableau Desktop
• InvolvedinintegrationofTableauJavaScriptAPIFiltersinwebapplication
• DefinedbestpracticesforTableaureportdevelopment.
• Createddashboardsandreportsforad-HocReporting.
• Playedanimportantroleincoordinationwiththeentireteamand managingthetimeestimatesfortheentireproject.
• UsedSQLtoolslikeToadandTeradataSQLAssistanttorunSQLqueriesandvalidatethedatainthewarehouseandmarts.
• Providedpostimplementationproductionsupport.

Environment: Tableau(Desktop/Server),Teradata,SQLdeveloper,MSSQLServer,Oracle,SQL,PL/SQL,T-SQL,TeradataSQLAssistant,Toad,MSAccess,Windows