OnBenchMark Logo

anand

Power BI
placeholder
Location Hyderabad
view-icon
Total Views40
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 3.5 Year
  • Cost
    Hourly Rate$5
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJune 06, 2024
Key Skills
Power BI
Summary

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

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon