Projectprofile:

TECHNOLOGY                                   MicrosoftPowerBI

DATABASES                                                           SQLServer2005,2008,2008R2VERSIONCONTROLSYSTEMS                                                           VSS,SVNandTFS-2012,Jira,

Confluence

OPERATINGSYSTEMS                       Windows,Linux

PROJECT#1

Projectname:QuadraNeonCRMRole:PowerBIEngineer

TeamSize:6

Project Description: Quadra CRM application supports and maintains the outlet details, theircontract assignment, promotions, synchronizing the complete information between othersystems,volumeofproductspurchasedfrom/shippedto,promotionalandcontractualpayment and invoicing. Depending on user requirements we will setup the Data EnrollmentProcess configuration and process the data to Data Lake and provides reports to themdaily/monthly/dependingondate,somereportswillbesentthroughmailforabovedetails.

RolesandResponsibilities:

✓   Collect,summarize,analysedataandtoprovidereportsfordepartmentstoutilizeindecisionmakingandmeasuringresults.

✓ CreatedDataModeling.

✓ CreatingRLSimplementationforallpowerbireports

✓ IdentifyingtheDimensiontables&Measuretablestobeusedintheproject.

✓    GetthedatafromOn-Premisesdatabases&On-PremisesDataSourcestoperform

visualizationsusingPowerBIDesktop

✓    ImplementedDAX(DataAnalysisExpressions)functionsforCalculatedcolumnsandmeasures

✓   Designedcomplexreportsbasedondiscussionswithusergroupsandcreatedvarious

objectsusingbuiltinfunctionslikeprompt,select,where,andaggregate,complexreportlevel

filtersandcontextsandcomplexSQLqueriesandjoinsinvolvingcasestatementsetc.

✓ CreatedchartslikeLines,Pies,Bar,Scatter,Area,Treemap,Map,Filledmap,Gauge,Funnel,SingleCard,Multirowcard,Sliceretc.andcustomizedvisualization

✓ PerformanceTuninginSQLQueries.

✓ DevelopedPivotChartsandPivotTablesbyaccessingSSAScubesusingpowerBI.

✓ ImportcustomvisualsanddevelopedthePowerBIReports.

✓ ExperienceonpublishingPowerBIreportsondashboardsinPowerBIserver.

✓ InteractiveVisualsaresharedtobusinessusersandgiventheuserguidelines.

✓ Workedonendtoendprocesstodelivertheproject.

Environment:POWERBI,SSRS,SSAS,SqlserverManagementStudio.

PROJECT#2

ProjectTitle : E-TargetClient:MazdaUSDealersRole: PowerBIEngineerTeamSize:9

Project Description: Minacs’s one of the application for Mazda US dealers, Dealers will sentmails out to the customers for different purposes. Front end application developers willgeneratethefilesrelated to theemailsenttothecustomersand fileswillhavelistofcustomersreceivedtheemails,noofsubscriberssubscribedthelinksintheemail,unsubscribed, bounces, clicks, opens and how many completed surveys. The files are placedin the ftp and there the files need to be picked and should be loaded according to thereportingteam requirements.

RolesandResponsibilities:

✓  Creatingdashboards,volumereports,operatingsummaries,andpresentationsandgraphsinPowerBIDesktop.

✓ Loadingthedatafromdevelopmentsystemtostagingenvironment.

✓  Extractingdatafrommultiplesourceslikeflatfiles,Excel,andSQLserverandvalidating

dataandloadingintoFinalDestination.

✓   CreatingSSISPackagesbyusingdifferentDataTransformationslikeDerivedColumn,Lookup,Conditionalsplit,Lookup,Multicast,UnionallandExecuteSQL.

✓ OptimizationandPerformancetuningforSSISpackages.

✓ LoadingdataintofactanddimensiontablesbycreatingSSISpackages.

✓ Design,DevelopandDeploymentofSSISpackages.

✓ GoodExperienceonPowerQuery,PowerpivotandDAXfunctions.

✓ Creatingadrilldownanddrillthroughreports.

✓ CreatedchartslikeLines,Pies,Bar,Scatter,Area,Treemap,Map,Filledmap,Gauge,Funnel,

SingleCard,Multirowcard,Sliceretc.

✓ ImportingCustomVisualsfromMicrosoftPowerBigalleryasperclientrequest.

✓ HavegoodExperiencetoImplementRLSaspartofsecurity.

✓ WorkingonDAXfunctionslikeDate&Time,Information,Filter&Value,Logical,andText.

Environment:POWERBI,SSRS,SSAS,SqlserverManagementStudio