Exclusive FY 2023-24 Year End Offer - upto 40% off | Hurry up - Offer valid till 31st March 2024
OnBenchMark Logo

Nabeel (RID : g8qolg3msp32)

designation   Power BI Developer

location   Location : Noida

experience   Experience : 2.5 Year

rate   Rate: $8 / Hourly

Availability   Availability : Immediate

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 0
Total Views : 94
Key Skills
Power BI SQL
Discription

ProfileSummary

2.5 Years Experience in PowerBi andSQL Server Database with duties of SQL Developer and BI
Solution(SQL, PowerBI).

 ExperiencedincreatingTables,StoredProcedures,Views,Indexes,UserDefinedFunctions.
 CreatingDDLandDMLscriptsinT- SQLtofullfilltherequirements,Creatingviewsandproceduresasperrequirements.
 Creatinguserdefinedfunctionsforthepurposeofcomplexcalculations.
 ExpertiseinimplementingbusinesslogicusingViewsandStoredProcedures.
 Experienceindatanormalizationandde-normalization.
 Developingvisualreports,KPIscorecardanddashboardsusingPowerBIdesktop
 Connectingdatasources,importingdataandtransformingdataforbusinessintelligent.
 Analyticalthinkingfortranslatingdataintoinformativereportsandvisual.
 Expertinusingadvanced-levelcalculationsonthedataset
 ExperienceonPowerBI(DesktopandService)andDAX.
 Workedon thePowerBIreports &dashboardswith SQLServerandOthersources.UsedTable,Matrix,Bar, Card,Gauge,Slicersvisualizations.
 Experience in business solution implementation, development activities and Support. Hasexperience in development of reports and dashboards in Power BI integrated with
SQLServerandExcel,andOnlineWebServices.
 Very good communication skills, good interpersonal skill & desire to excel, fast learner,hardworkingandaversatileteamplayer.


TechnicalSkills

 ProgrammingLanguages:SQLServer.
 OperatingSystem :Window7,Window8,Window10.
 Databases :SQLServer,SQLServer2012,2014and2016.
 DatabaseTool :PowerBI.
 Architecture :RelationalDatabase,ClientserverArchitecture.
 MSTechnologies :DAXandDataModeling.

CompanyName : AWC Software Pvt. Ltd.,
Noida.PositionTitle :SoftwareEngineer
WorkDuration :CurrentlyWorking
JobDescription :Currently, IamworkingonPowerBI DesktopApplicationandPowerBI Servicesto developReport andDashboards fordifferentProject. My basic role is to understand the requirement of the client, integrate user database with power bifrom different source, prepare the module, create measure, design report, dashboard and deliver toclient.


P r oj ec ts

Client: Indus Tower
Duration:Jan 2022 till now.
Technology:
MicrosoftSQLServer2016(T-
SQL),PowerBI,


Roles&Responsibility:

 CreatingDDLandDMLscripts inT-SQLto fullfilltherequirements.
 Creatinguserdefinedfunctionsforthepurposeofcomplexcalculations.
 IdentifyingColumnsforPrimarykeys inallthetablesattheDesigntime andcreateStarSchema.
 CreateDatabaseObjectsuchasTable’sViewsandStoredProcedures.
 Responsibleforthe preparation,ReportoutandmaintenanceDaily,Weekly,MonthlyandAdhoc reportsusingPower BI.
 Responsible for Power BI Integration with SQL Server and Excel, fetching necessary tablespreparingModule, creatingReport,Dashboardandpublish toPowerBIPortal.
 Workin RelationalDatabaseandManagingRelationshipbetween theTablesinPowerBI.
 Developedvariousoperational Drill-downReport usingPowerBI.
 Developed Daily needed Reports and Dashboard like Time Sheet, Head-Count , Employee BenchDays,ResourceUtilization,Currentv/sPreviousMonth/YearRevenueReport.
 WorkedondevelopmentofPowerBIReports usingSharePoint OnlineasaDataSource.
 WorkingonDaxqueries inPowerBidesktop
 Workedongivingsolutionstoclientbasedonbusinessrequirements.
 Involvedincreatinggoodlookingdashboardsinpowerbiservice








Client: GYFTR (Vouchers)
Duration: Jan 2021 till Jan
2022.
Technology: MicrosoftSQL
Server 2016 (T-SQL), PowerBI.

Roles & Responsibility:

 Creating DDL and DML scripts in T-SQL to full fill the requirements.
 Creating user defined functions for the purpose of complex calculations.
 Identifying Columns for Primary keys in all the tables at the Design time and create Star Schema.
 Create Database Object such as Table’s Views and Stored Procedures.
 Responsible for the preparation, Report out and maintenance Daily, Weekly, Monthly and Ad hoc reports using Power BI.
 Responsible for Power BI Integration with SQL Server and Excel, fetching necessary tables preparing Module, creating Report, Dashboard and publish to Power BI Portal.
 Work in Relational Database and Managing Relationship between the Tables in Power BI.
 Developed various operational Drill- down Report using Power BI.
 Developed Daily needed Reports and Dashboard like Time Sheet, Head-Count , Employee Bench Days, Resource Utilization, Current v/s Previous Month/Year Revenue Report.
 Worked on development of Power BI Reports using SharePoint Online as a Data Source.
 Working on dax queries in Power BI desktop
 Worked on giving solutions to client based on business requirements.
 Involved in creating good looking dash boards in power bi service

 

 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!