CURRI

CULUM VI
TAE
BORRAMAHESH E-
mailI
d:maheshbor
ra1908@gmai
l
.com
Cont
actNo:+917569929989
_
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
___
__
Pr
ofessi
onalSummar
y:
 Ar esul tsdr i
v ensof t
war epr of essional wi th3+y ear sofpr ogressi vel
yr esponsibleexperience
i
nDat aAnal y sis,Desi gn,Impl ement ation, Suppor tofBusi nessI ntell
igence.
 Abilityt owor kwi thv arioust ypesandst agesofSof twar eDev elopmentLi f
eCy cle(SDLC)
processesi ncl udingAnal ysi
s, Desi gn,Dev el
opment ,Test ingandI mpl ement ati
on.
 Exper iencei ncr eatingVi ews,Const raints,I ndexs,Tr i
gger s,Joi ns,Cur sors,TempTabl e,
Tabl eVar iabl e,Funct i
ons,Bat chScr iptsandnumer ousst oredpr ocedur econsumedat
variousst agesofmi gr ati
on/ cleansi ngpr ocess, repor tsordat av ali
dat i
on.
 Strongski ll
si ndat amodel li
ng, databasedesi gnandSQLdev elopment .
 Exper tisei nPowerBI , PowerBIPr o, PowerBIMobi l
e.
 Exper tincr eat i
nganddev elopi ngPowerBIDashboar dsi ntor ichlook.
 Dev elopedOLTPsy stem ( s)andi nvol v
edi ncr eat i
ngf acts,di mensi onsandSt arSchema
represent at i
onf orthedat amar t.
 Knowl edgewor ki
ngwi thmapr epor tsandst ackedr epor ts.
 Knowl edgeonpowerquer yf unct ions.
 Knowl edgeonDAXf unct ionsandusage.
 Knowl edgeonDAXmeasur esandcal culat i
ons.
 Dashboar di nganddat asetr ef reshusi nggat eway s.
 Knowl edgeonpowerBIcl oudandappcr eati
on, publ ishing.
 Ablet odesi gncompl exquer iesf orpowerBIr epor tvisual i
zations.
 Exper iencei ndev elopi ngDashboar dRepor t
, Subr eportsbyRegi on,Year ,Quarter,
Mont h..
 Abilitytodev el opappl icationsi nadet ai lori
ent t
edenv i
ronmentandst rongwor kethi
c.
 Ablet ocommuni catecl ear l
yandgetal ongwel lwi thot herco- wor kers.
 Progr ami ngandt oolsabi lit
yt owearmul ti
plehat s,anal yti
calabi lit
yt omakedeci si
onsand
solvepr oblems.

Wor
kingExper
ience:

 Worked as a PowerBIdev el
operin Accent
ureindia pv
t.Lt
d pay
rol
lEmployee t
hrough
VVVinf
otechpvt.
Ltdf
rom July2018toJul
y2019.
 WorkedasaSof twar
eTraineeinY.B.
Rinf
otechsPvt
.Lt
df r
om June2016toJul
y2018.

Educat
ionalQual
if
icat
ion:

 B.
TechinElectr
onicsAndCommunicati
onEngineeri
ngfr
om JNTUKaki
nadai
n2016.
 Di
plomainElect
ronicsAndCommunicat
ionEngineer
ingf
rom SBTETAPi
n2013.

Techni
calSki
ll
:

 Tools :PowerBI,SSMS,Ecl
i
pse
 ProgrammingLanguage :C,CoreJava
 Operati
ngSystems :WindowsFamiley
 DatabaseLanguage :MYSQL, SQLServ
er
Pr
ojectDet
ail
s:
Pr
oject#1:
Cl
ient : Cor
sairMicr
oSystems,US
Role : PowerBIDevel
oper
Durati
on : Apr
il-
2019toJune- 2019

Descr
ipt
ion:

CorsairMi crosyst
ems mai nt
ains the inf
ormation aboutsal es,profi
ts and contacts of
customer s.UsingSal esAnalysi
sdat abase,thesy stem wi
llanal y
zet hesalesandI nventoryand
generatesr eport
sf orSalesPart
nerwi se,Regionwi seinmont hwi se,Quart
erwi seandy earwise.
Ther esult
ingmodelgi v
esusani deaaboutgr owthinprofi
t,predict
ionaboutincreaseinsales.This
dashboar dcompl etelygiv
esananal ysi
sofCompl i
anceSummar ywherewecanmeasur ethedat a
Quality
.ThisDashboar dusest
heser eport
st odotrendanalysis,dataprocessi
ngandqual i
tychecks
onthedi stri
butor
sdat a.

Rol
esandResponsi
bil
it
ies:

 Ext ensi velyusedJoi nsandSub- Quer iestosi mplifycompl exqueri

esi nvol
vingmultipl
e
tabl es.
 Dev elopedt abularqueriesforef fi
cientanal y
sisofr eportusingPivot/UnpivotinT-SQL.
 Desi gnedandcr eateddataext racts, suppor ti
ngSSRS, POWERBI ,
Tabl eauorother
visual i
zati
ont oolsreporti
ngappl ications.
 Dev elopedExcel PowerView, Power Quer yandPower Pivotdashboar dsfordataanalysi
s
 Dev elopedconf idential
propr i
etaryanal yticaltoolsandr eportswit
hConf i
denti
alExcel,
and
PowerPi votandPowerPoi nt.
 Filter edbaddat ausi ngDer i
vedcol umn, Lookups, FuzzyLookups, Condi ti
onalspli
t.
 var i
oust ransformationsli
keDat aconv ersion,Fil
esy stem task,
Rowcount s,OLEDBSour ce,
OLEDBDest i
nation,OLEDBCommand, Mer geJoi n,Lookup, Sort
, Datafl
owt ask.
 Cr eat edRepor tsusingChar ts,Gauges, Tabl es,mat ri
x.
 Cr eat edPar amet eri
zedRepor t,Dashboar dRepor t,Linkedr epor
tandSubRepor tbyYear,
Quar ter,Mont h,andWeek.
 Cr eat edDr il
lDownRepor ts,Dri
llThr oughRepor tbyRegi on.

Pr
oject#2:
Proj
ectName : Order
sandCont ract
s(O&S)
Cl
ient : Hewlet
tPackard,US
Role : PowerBIdeveloper
Durati
on : December-2018t oMarch-
2019

Descr
ipt
ion:

Or
der sand Cont r
act sisoneoft heHP Ent erpr
iseBusinesspor tfoli
osresponsi
blefor
TechnologySer vi
cesWar rantyandSuppor tcontr
acts.I
tgetsitsdataf r
om SAPERPSy st
em.Sal es
andCont ractsist hefir
stst epf oranor gani
zat
ionwhi chentersi nt
obusinesswi t
hacust omer.
SalesDocument sorCont ractsar ecreatedandanagr eementest abli
shedbetweent heCustomer
andOr ganizati
onforasetofpr oductswhi chusuall
yspansf oraper i
odof1y ear.Bi
l
li
ngDocument s
arecreatedf ol
lowingthatf orrelevantSal esdocumentsandr ev
enuedet ai
llinesarecreat
edand
i
nsertedintotheRev enueRecogni tiontables.
Rol
esandResponsi
bil
it
ies:

 Devel opedpowerbi r
epor t
s&dashboar dsf r
om mut ipledat asour cesusingdat abl ending.
 devepl opedSQLquer i
es/ scri
ptst
ov al
idat ethedat asuchaschecki ngduplicatesnul lval
ues
andensur i
ngcor rectdat aaggegations.
 perf
or meddat aqual i
tyanal y
sisusingadv ancedSQLski ll
sper formedcountv alidation,
Dimensi onalanal ysi
sanddat aQual i
tyvalidationsindat aMigr ati
on.Ext ensi
v eSQLquer y
ing
onst agi ng,Datawar ehouseandDat aMar t.
 explor eddat ainav ari
etyofway sandcr ossmul ti
plev isuali
zations, usingpowerBI .
Str
at egi cexpertiseindesi gnofexper iment s,datacol lecti
on,anal y si
sandv i
sual izati
on.
 Inv
olv edi nTr oubleshoot i
ng, r
esol
vingandescal ati
ngdat arelatedi ssuesandv ali
dat i
ngdata
toimpr ovedat aqual it
y.
 Contr i
but edint hedev elopmentofknowl edget r
ansf erdocument ation.
 DesignedpowerBIdat av i
suali
zat
ionut il
izingcr osst abs,maps, scat t
etplot
s, pie,barand
densi tychar t
s.

I
nter
nshi
ps:
 Company
:Amer
icanPowerConv
ersi
on,
Bangal
ore
Dur
ati
on:Fr
om Dec2012t
oApr
il2013
 Company
:Ai
rpor
tAut
hor
it
yofVi
j
ayawada,
Indi
a
Dur
ati
on:Fr
om May2015t
oJune2015

Per
sonalPr
ofi
le:
Name :Bor
raMahesh
Fat
herName :Bor
raKondar
eddy
Nat
ional
i
ty :I
ndi
an
Gender :Mal
e
Dat
aofBi
rt
h :19/
08/
1995
Mar
it
alSt
atus : Si
ngl
e

Decl
arat
ion:
Iher
ebyment
ainedt
hatt
heabov
einf
ormat
ioni
str
uet
othebestofmyknowl
edge.
Pl
ace:I
ndi
a
Dat
e: (
BMAHESH)