Engineer Sql Server

Avinash D. Kumar

a vid***@gmai l.com 9-08-217-****

P R O F ESS I O N A L S U M M A R Y

Ta len ted I T p rofessiona l w i t h 18+ years of Business I n tel l igence, technology

•

a rch i tectu re design, developmen t and managemen t exper ience. Ex tensive exper ience

i mp lemen t i ng and i n teg ra t i ng f i nancia l business app l ica t ions i n h igh paced t rad ing

f loor envi ronmen t and hosted p r iva te cloud envi ronmen t.

Proven exper t ise i n al l phases of sof twa re developmen t (SD LC) and I T serv ice l ife

•

cycle. St rong techn ical backg round, across mu l t i-language, mu l t i-pla tfo rm

p rogramm ing, bu i ld ing h igh business value appl icat ions di rectly i n f l uencing

p rof i tab i l i t y and grow th.

Demonst ra ted abi l i t y to manage end-to-end p roject del ive ry w i t h extensive hands-on

•

B usiness Analyst exper ience spann ing requi remen ts collect ion, analysis,

p r io r i t iza t ion, t ransla t ion to techn ical requ i remen ts and post-developmen t val ida t ion.

E xper t ise i n scope and schedu le managemen t. Abi l i t y to a r t icu la te I T-business

s t ra tegic al ignmen t to execu t ive audience.

Techn ical Exper t ise: S Q L Se rver, SS IS, SSRS, O B I E E B I, SQ L Ad m i n, da t a

•

m ode l i ng us i ng E r w i n, C#, .Ne t, X M L, Web Se r v ice ca l ls, Sha r e Po i n t

Key Business areas i nclude Equ i t ies, P r iva te Equ i t y funds, Hedge funds, f unds of

•

f unds, Real Esta te pa r t nersh ips, Cl ien t Performance repor t i ng and Por t fol io

m anagemen t.

I nd ust r y specif ic p roduct exper t ise: I nvest ran and I nvesTier f rom Sungard, Backstop

•

f rom Backstop Solu t ions Group.

Resul t-or ien ted en t repreneu r p rovid ing sof twa re & I T consul tancy serv ices and

•

h uman resou rces, di rect ly i n f l uencing company g row t h.

T E C H N I C A L SK I L LS

Languages: C #, T-SQ L, X M L, Powe rSc r i p t, Java, JavaScr ip t

•

Da tabase: M i c rosof t SQ L Se rve r, Sybase ASE, Netezza, Oracle, Sybase SQL

•

A nywhere

Sof twa re & Technologies : SQL Server Integration Services (SSIS), SQ L Se r ve r R e po r t i ng

•

S e r v ices (SS RS), O r ac le B usi ness I n t e l l igence E n t e r p r ise E d i t io n ( O B I E E ),

R e po r t B u i l der, C A E r w i n, V isio, .Net, ASP.Net, IIS, SharePoint Technologies, Visual Source

Safe, Subversion (SVN), TFS, SQ L Sou rce Con t ro l, Powe r B u i l de r, HTML, DHTML, MS

Project, Crystal Repor ts

EXPER IE NCE

Oct 2003 – Presen t

P r es i de n t

Avid Solu t ions, I nc. – Ed ison, N J

M a r 2012 – Present

B us i ness I n t e l l ige nce & D a t a A rc h i tec t

Cl ien t: Wells Fargo Secu r i t ies – New York, NY

Worked w i t h B loomberg and coordina ted w i t h Business Managers to i n teg ra te T icker

•

R ank data w i t h t rad ing act iv i t ies, p roducing dashboards and repo r ts to measu re

t rader p erformance using SSIS, C#, SSRS & OBIEE .

Designed and bu i l t O B I E E Reposi to ry def in i ng di fferen t layers, creat ing new subject

•

a reas, dashboards and repor ts for B loomberg, T radi ng revenue and commissions i n

I nvestor Perfo rmance Managemen t (IP M), an investmen t bank ing da ta wa rehouse

a ppl ica t ion, wor k i ng w i t h Repor t Developers.

I n teg ra ted corpora te access da ta provided by Deal Logic, a t h i rd-pa r t y vendor, i n to

•

d a ta wa rehouse, and genera ted analy t ical repo r ts, managing a team of t wo, using

S S IS & O B I E E .

Designed and developed ET L p rocesses to b r i ng i n t rad ing re la ted data f rom upst ream

•

O rder Managemen t and Set t lemen t Systems i n S ybase a nd O r ac le d a tabases.

A v i n a s h K u m a r a v i d 2 8 4 @ g m a i l . c o m 9 0 8 2 1 7 9 8 8 9 1

I nvolved i n daily mon i to r i ng of overn igh t ET L processes and reconci l i ng last business

•

day t rad i ng act iv i t ies wh i le at tend ing to business use r’s ad-hoc requests f rom t rad ing

f loor.

Jan 2008 – Feb 2012

Syste ms A rc h i t ec t

Cl ien t: E & E Capi ta l Adv isor, L LC – New York, NY

Played a key ro le i n imp lemen t i ng and i n teg ra t i ng best-of-breed business systems

•

a rch i tectu re:

I nvest ran – P r iva te Equ i t y Fund of Fund, Par t ne rsh ip Accoun t i ng and

o

A nalysis

I nvesTier – Hedge Fund of Fund and Par t ne rsh ip Accoun t i ng

o

Backstop – C RM, Por t fol io Managemen t, P r iva te Equ i t y & Hedge Fund

o

A dm in is t ra t ion and M anagemen t, I nvestmen t Research, Analy t ical, Perfo rmance

a nd Risk repor t i ng

Cl ien t Repor t i ng – Consol ida ted investor repo r t i ng f rom di fferen t systems

o

u sing S SRS

Designed and managed successfu l imp lemen ta t ion of I nvest ran, m ig ra t i ng f rom i n-

•

house appl ica t ion. Developed key funct ional aspects for I nvest ran, i nclud ing accoun t

a nd t ransact ion h iera rch ies, fund and investor valua t ions and al locat ions, by wor k i ng

c losely w i t h Subject Ma t te r Expe r ts, Vendor Consul tan ts, C IO, CFO and COO.

Lead and managed I T team i n imp lemen t i ng and developing cross systems

•

a rch i tectu re.

Designed founda t ional, robust and extensible cross systems archi tectu re, for cross

•

system da ta i n tegra t ion, physical to logical da ta t ransforma t ion across p rop r ieta ry

system forma ts, data wa rehousing and data reconci l ia t ion. Developed p ro totype using

S S IS, C#, Web Se r v ice ca l ls.

Used E r w i n extensively to create physical and logical models, da tabase compa r ison,

•

fo rwa rd engineer i ng, reverse engineer ing.

Perfo rmed S Q L Se rve r D B A act iv i t ies p r i ma r i ly creat i ng and ma in ta in ing

•

d a tabases, tab les, i ndexes, views, stored p rocedu res, funct ions, logins, users, ro les,

j obs, disaster recovery/backup, da tabase m i r ro r i ng, rep l ica t ion, da tabase logging and

performance t u n i ng.

Designed and developed Excel da ta temp la tes and add-i ns, using S Q L Se rver, . Ne t &

•

C #, to overcome m ig ra t ion chal lenges du r i ng da ta conversion and reconci l ia t ion.

I n t u i t ive designs i nclud ing h igh l igh t i ng di fferen t ia ls enhanced eff iciency and

accuracy by many folds.

Created S S IS p ackages, using . Ne t, C# & A P I Web Se r v ices for d ata m ig ra t ion,

•

consol ida t ion and i n teg ra t ion. Use of package conf igu ra t ion and logging enhanced

scalabi l i ty.

Designed and developed an Adm in ist ra t ive Con t rol Panel, using A SP.Ne t, C#, SS IS

•

& W eb Se r v ice ca l ls, to r u n SSIS packages on ad-hoc basis and for schedu l i ng. Th is

r obust and i n te ract ive solu t ion to t he i n teg ra t ion chal lenges al lowed da ta sync across

systems and elim i na ted redundan t da ta ent ry steps, imp roving p roduct iv i t y across

depa r t men ts.

Designed and developed A SP. Ne t Web app l ica t ion i n te rface, using C # & Web

•

S e r v ices f or I nvest ran da ta re t r ieval. Solu t ion p rovided a consisten t and easily

m a in ta inable developmen t arch i tectu re t ha t was easily adopted by developmen t team

t o w r i te custom repor ts i n S SRS .

I n teg ra ted S ha r e Po i n t Se rve r w i t h SQ L R e po r t i ng Se r v ices serv ing as t he

•

i n te r face for execu t ive dashboard and repo r ts. Conf igu red and used Bug Repor t i ng

a nd task manager appl ica t ions i n Sha rePoin t to manage appl icat ion conversion and

developmen t.

Oct 2003 – Dec 2007

D eve lop me n t M a n age r

Cl ien t: Eh ren k ranz & Eh renk ranz, L LP – New York, N Y

Responsib le for end-to-end developmen t and imp lemen ta t ion of custom bui l t clien t-

•

server appl ica t ion, SMART, using S Q L Se rver, . Ne t & C#, SS IS, SSRS,

PowerBu i lder.

Bu i l t and managed a developmen t team of 2-4 for developing SMART’s fol lowing

•

modu les cover ing f i r m’s diverse f i nancia l opera t ions:

A v i n a s h K u m a r a v i d 2 8 4 @ g m a i l . c o m 9 0 8 2 1 7 9 8 8 9 2

P r iva te Equ i t y – PE fund Adm in is t ra t ion, Accoun t i ng, Analysis and

o

Por tfol io Managemen t. E & E managed over 15-20 act ive PE funds spann ing

a l te r na te investmen t st ra tegies w i t h bi l l ions i n AU M.

D ist r ibu t ion – Combined dist r ibu t ion fo r mu l t ip le f unds, check/w i re

o

p r i n t i ng & bank f i le.

Cash – Hedge fund fu t u re t ransact ions.

o

Accoun t i ng – P r iva te Equ i t y & Hedge Fund Accoun t i ng for f und

o

m anagemen t and audi t i ng.

Ban k – Fund bank accoun t reconci l ia t ion.

o

Tax – P r iva te Equ i ty, Hedge Fu nd and Real Esta te Par t nersh ip tax

o

m a in tenance, K1 da ta genera t ion, Tax Est ima tes and Act uals.

•

I ns t r u men ta l i n arch i tect ing da tabase design for SMART, using E r w i n d a ta modeler

•

for design and main tenance of p roduct ion and developmen t envi ronmen t.

Worked extensively i n S Q L Se rve r c reat i ng and ma in ta in ing databases, t ab les,

•

i ndexes, views, stored p rocedu res, funct ions, logins, users, ro les, jobs and perfo rmance

t u n i ng.

Nov 1998 – Sep 2003

Consul t a n t Syste ms E ng i nee r

Eh renk ranz & Eh renk ranz, L LP – New York, NY

Designed & developed fol lowing modules of SMART using S Q L Se r ve r &

•

PowerBu i lder:

Schedule of Assets – H ighly custom izable investor por t fol io and l i n ked

o

f am ily por t fol io summa ry repor t.

Da ta Up loader – Up loads investor t ransact ions and balances managed by

o

exte rna l managers, provided i n a p re-def i ned PGP encryp ted Excel or X M L

fo rma t.

Real Esta te Pa r t ne rsh ips – Real esta te pa r t nersh ip managemen t and

o

a dm in ist ra t ion.

CRM & Ma i l i ng – Cl ien t Rela t ionsh ip Managemen t, t ax sta tus, paymen t

o

p references, E & E rep resen ta t ive, accoun tan ts, at to rneys, CC’s, documen t

m a i l i ngs amongst others.

Reta iner – Retainer i nfo rma t ion, bi l l i ng t ype, bi l l i ng pa t te r n, invoice

o

genera t ion, paymen ts t rack ing, and outstand ing balance repo r ts.

Converted data from UNIX based legacy system, DejaWin to SMART’s SQL Server database.

•

Jun 1998 – Nov 1998

Consu l t a n t Systems A na lyst

ValuAme r ica – Pi t tsbu rgh, PA

Developmen t of ValuNet, real esta te t i t le and app ra isal sof twa re; g enera ted real

•

esta te app raisal repor t w i t h proper t y’s value range, comparable sales data –

PowerBu i lder & Oracle .

Ap r 1997 – May 1998

Consu l t a n t Sof t w a r e E ng i nee r

Askesis Developmen t Group, I nc. – Chicago, I L

Worked extensively on Managed Care f unct ional i t y of PsychConsu l t, a Behaviora l

H eal t hca re Managemen t System . Developed MemberConsu l t, a member serv ice t rack i ng

modu le; Cla imsConsul t, a claims adjud icat ion system; E l ig ib i l i t y I n load, up loads t h i rd

p a r t y da ta f i les i n to database reposi to ry w i t h f lexib le val ida t ion r u les & act ions –

PowerBu i lder & SQL Server.

Sep 1996 – Ma r 1997

P r og r a m me r A n al yst

Value Sof twa re technologies L i m i ted – Bangalore, I nd ia

Developmen t of Feeding Gu ide I n fo rma t ion Da ta En t r y Ou tpu t (F I DO), system

•

assist i ng veter i na r ians to use H i l ls pha rmaceu t ical p roducts – PowerBu i lder, Oracle &

COBOL.

Oct 1995 – Aug 1996

Sof t w a re Consul t a n t

Protech M ic rosystems – Bangalore, I nd ia

A v i n a s h K u m a r a v i d 2 8 4 @ g m a i l . c o m 9 0 8 2 1 7 9 8 8 9 3

Developed and imp lemen ted I nven to ry and B i l l i ng System, inven to ry cont rol system

•

for consumer products dist r ibu tor – PowerBu i lder & Sybase SQL Anywhere.

Aug 1994 – Oct 1995

Syste ms E xecu t i ve

PRA M Sof twa re Sciences – Bangalore, I nd ia

Worked on developing Payrol l App l ica t ion and Sales & I nven to ry Con t ro l System for

v a r ious clien ts – FoxPro, Cl ipper & Netwa re.

E D U CA T I O N

1989 – 1993

Ba nga lo re U n i ve rs i t y

Bachelor of Eng inee r i ng, E lect ron ics

1993 – 1996

Ap tech Comp u te r E d uca t io n

H igher D ip loma i n Sof twa re Engineer i ng

A v i n a s h K u m a r a v i d 2 8 4 @ g m a i l . c o m 9 0 8 2 1 7 9 8 8 9 4

Contact this candidate