Test Sql Server

R esume

Subha Balu

E ma i l : - s u_ ra ***@*****.***

Phone: - 781-***-**** ( Mob i le)

Wor k A u t ho r iza t io n: - Pe r ma nen t Residen t (G reen Ca rd)

PROF I LE

I n fo r ma t ional Technology p rofessional w i t h 6+ years of exper ience i n Sof t wa re

S ystems & Appl ica t ions Test i ng, Fu nct ional Analysis, SQL Que ry Developmen t and

Repor t i ng .

• Prof icien t i n Fu nct ional Test i ng of Web & Mobi le App l icat ions, Da tabase Test ing

a nd Au toma t ion Test i ng. Special ized i n M i g ra t ion test i ng f rom Web to Mobi le

p la tfo r m.

• Exper ience i n usi ng Test tools l i ke HP QC and I B M Clear Quest.

• Exper t ise i n Da tabase Tools l i ke Oracle SQL Developer and M ic rosof t SQL

Server.

• Used va r ious Test Techn iques l i ke Wh i te Box, B lack Box and Regression

A nalysis.

• Worked i n p rojects using Wate rfa l l and I te ra t ive SD LC Me t hodologies .

• Worked i n Onsi te-Offshore model for Test Execut ion and Sta t us t r ack i ng.

E X P E R I E N C E D E TA I LS

Sen io r Test E ng i nee r – J u l 2011 to M a r 2013, E HS Solu t ions, Boston, M A

Cl ien t: - P r iva te Weal t h Ma nagemen t Serv ice Companies

Project / Appl ica t ion: - Weal t h M anagemen t Mobi le appl icat ion

Th is Project is to rol l ou t t he Weal t h managemen t Dashboard on Mob i le Pla tfo r m

f or iOS devices. Ex is t i ng Dashboard and Repor t i ng appl ica t ion was re-engineered

f or Mobi le pla t fo r ms. T h is mobi le pla t fo r m del ivered capabi l i t ies i n Dashboard

r epo r t i ng needs of P r iva te Weal t h managemen t Cl ien ts l i ke H igh Net wor t h

I nd i v idua ls i nvestmen t Accoun ts Rela t ionship summa ry, Accoun t level Snapshots

a nd detai led t r ansact ions repo r t i ng.

Role & Con t r i b u t ions:-

• Perfor m i ng Test Analyst ro le for developing t he Mobi le pla tfo r m Test

r equ i remen ts and cont r ibu ted for developing t he Test St ra tegy and app roach.

• Crea ted deta i led Test Cases and execu ted usi ng iPad and iPhone.

Resume of Subha Balu Page 1 of 4

R esume

• Defect logging i n Clea r Quest and p repa red weekly sta t us Repor ts for I T

M anagemen t.

• Crea ted SQL que r ies to ext ract Da ta f rom SQL Server Da tabase for

v al ida t i ng t he Da ta repor ted i n t he Mobi le appl icat ion.

• I n te racted w i t h Developmen t & B usiness teams to review t he Defects &

I ssues and plan for re test i ng of Defect f ixes.

Test E ng i nee r – J u l y 2009 to J u n 201 0, I nvestors Ban k & T r us t Company,

B oston, M A

I nvest T ransfer Agency is t he t ransfer agen t record-keeping system used by I B T

( Investors Ban k & T r us t Company) for adm i n is te r i ng t he shareholder serv ices

o ffered by M u t ua l F unds, such as paymen t of div idends, capi ta l gains and t ax

r epo r t i ng.

T h is p roject is for new Cl ien t conversions i n to I nvest TA appl ica t ion, mappi ng t he

I nbound and Ou tbound Da ta feeds, val ida t i ng t he da ta using menu d r iven database

s ystem al low ing access to al l i nqu i r y and p rocessing screens .

Role & Con t r i b u t ions:-

• Analyst & Tester for t he F unct ional enhancemen ts of t he I nvest TA

a ppl icat ion.

• Systems Test i ng for I nbound & Ou tbound Da ta F i les as pa r t of Cl ien t

conversions.

• Unders tand t he User requ i remen ts, develop Test Plan and detai led Test

C ases.

• Test execu t ion, Sta t us repo r t i ng, Defect logging and Defect repor t i ng.

• Suppor t i ng Offshore Teams i n assign i ng and t rack i ng Test del iverables.

Test E ng i nee r – Oc t 2007 to J u n 2009, I nvestors Ban k & T r ust Company,

B oston, M A

I nvestor Ban k & T r us t Company was one of t he leadi ng f i nancial serv ices company

p rovid i ng Custody and Accoun t i ng serv ices to leading M u t ua l F und and Pension

F u nds. I nvest Repor t i ng is t he On l i ne I n fo r ma t ion Del ive ry pla tfo r m for Custody

a nd F u nd accoun t i ng repor t i ng needs p rovid i ng both onl i ne and of f l i ne repo r ts.

Resume of Subha Balu Page 2 of 4

R esume

Th is p roject is for m ig ra t i ng new Cl ien t da ta i n to I B T systems, test i ng few

f unct ional changes i n t he Repor t i ng modu les, val ida t i ng t he repor ts da ta i n PDF

a nd Excel for ma t.

Role & Con t r i b u t ions:-

• Test Engineer for t he Test l i fe cycle del iverables of I nvest Repor t i ng

a ppl icat ion.

• Study of Cl ien t Conversion and Da ta requ i remen ts and t ransla ted t hem i n to

D etai led Test Cases

• F u nct ional test i ng of Repor t modu les U I and val ida t ion of t he Repor ts da ta

as pa r t of Cl ien t conversions i n to I nvest repor t i ng serv ices

• Crea ted Da ta t ransact ions i n up-st ream accoun t i ng appl icat ions and

v al ida ted i n t he downst ream Da tabase and repo r ts.

• Used PDF compa ra to r tools to val ida te new repo r ts w i t h exist i ng repor ts.

• Execu ted M anua l Test Cases, logged Defects i n Clear Quest and upda ted

S ta t us Repor ts.

• Pa r t icipa ted i n Defect T r iag ing meet i ngs and p rovided sta t us upda tes.

Syste ms Analyst – Oc t 2005 to Ap r 2007, Sophus Technologies I nc.

C h icago, I L

Sophus Technologies p rovides I T Solu t ions Consul t i ng, Design & Suppor t serv ices

f or business across USA, Singapore & I n d ia.

C on t r i b u t ion:-

• Systems Test i ng of Sales Order M anagemen t appl icat ion and User que r ies

s uppo r t.

• Unders tand i ng of t he User requ i remen ts, develop Test Plan, created deta i led

T est Cases and Test execut ion and repor t i ng.

• Crea te SQL que r ies to ext ract da ta f rom t he backend to val ida te t he Business

l ogic layer as wel l val ida te User da ta issues.

• Execu t ion of Au toma t ion Scr ip ts for Regression Test i ng.

• Documen ta t ion of analysis f i nd i ngs for ongoing Systems reference.

Resume of Subha Balu Page 3 of 4

R esume

T E C H N O L OG I ES/ TOO LS E X P E R T IS E & E X POSU R E

Sof t wa re E ngi nee r i ng P rocess / Tools

• HP QC for Test i ng & Defect repor t i ng

• MS Word, Excel & Ou t look

• O racle SQL Developer, M ic rosof t SQL Server & VB

• Sha repoin t for Documen ts sha r i ng and collabora t ion

E D UCA T I O N

• Bachelor of Eng ineer i ng, Bha ra t h idasan U n iversi ty, T r ichy, Tam i l Nadu, I nd ia

• G radua ted w i t h D is t i nct ion, scored 69% aggregate ma r ks.

Resume of Subha Balu Page 4 of 4

Contact this candidate