jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary seeking senior sql server net development position progressive varied experience sdlc software development life cycle database applications diversified industries services telecommunications retail companies possess excellent communication skills strong customer support troubleshooting skills recognized highly motivated proactive team player problem solver strengths include strong verbal written skills highly analytical well organized data normalization oltp olap star snowflake schema dts ssis etl report design development object oriented analysis design net development skills databases sql server 200020052008 r2 dts package ssis ssrs ssas sql server management studio enterprise manager sql server profiler informix informix4gl oracle cesql dbase iv languages c cc perl 4gl xml html javascript cgi shell script java vbscript excel vba tools visual studio 200320052008 adonet aspnet uml visio vss ssrs crystal reports odbc rational rose clearcase operating systems windows server 200020032008 unix sun solaris linux dos protocols corba tcpip ipc sip voip ssl work history 022009 present senior sql server database application developer hcl technologies ltd sacramento ca core developer small team within fastpaced environment provided solutions according user requirements timely efficient manner involved full life cycle software development including requirement analysis system design implementation testing deployment production support environment sql server 20052008 ssis ssrs windows server 20032008 visual studio 20082010 net 3540 c adonet batch file scripting ftpsecured ftp interacted wireless network design engineers business requirements designed backend database tables indexes created stored procedures implemented gold standard audit system using c adonet automated manual audit process array value parameters single value parameters range value parameters greatly improved productivity audit system providing daily audit att nation wide wireless network configurations created complex stored procedures functions views ssis cnet programs extract transform load data different data sources including excel xml files database servers utilized common table expression cte dynamic column pivot tables ranking functions outer joins sub queries complicated data extraction report generation experienced stored procedure performance tuning using execution plan dmvs sql profiler provided performance analysis identified index fragmentation missing index implemented nightly maintenance process defragment index pages necessary notify created etl packages using ssis download files sftp server utilized winscp execute process task extract data csv files load sql server database included error handling data integrity constraints enforcement developed reports using ssrs telerik farpoint c aspnet adonet installed configured sql server 2008 r2 database servers migrated databases sql server 2005 sql server 2008 r2 configured administrated sql server 2008r2 reporting services server users implemented procedures database backup restoration optimization designed intranet web applications upload format check user input files online update validation generate pdfexcel reports data extracted databases using aspnet c adonet visual studio 2008 designed implemented component used web applications populate data large user input excel filesmore 20m c sql bulk copy adonet gembox extracting 10000 records excel file within seconds evaluated recommended software 3rd party tool extract large amount data excel files macros graphs provided backend data collection midlayer web services access databases using c aspnet adonet participated development procedures processes mentored team members provided consultation advice contributed codereview 032008 102008 senior software developer consultant pennymac saint louis mo designed er diagrams developed database sql server 2005 involved database upgrade sql server 70 sql server 2005 participated requirement analysis technical design database server upgrade implemented tested stored procedure modifications according sql server 2005 upgrade advisor report provided solutions eliminate xp cmdshell usages using ssis packages sql agent jobs stored procedures experienced data modeling database design data normalization designed implemented credit card account number encryptiondecryption application using aspnet web services c net 20 redesigned developed tested salon schedule book broadcaster windows service application provided technical design documentations implementation unit testing using uml c net 20 tcpip sockets asynchronous multithreading technology 042005 022008 software engineer hcl technologies ltd austin tx participated system design development modifications enhancements ongoing production support enterprise data warehouse system enterprise information system system extracts data db2 database text files mainframe hosts loads sql server data warehouse using different data transformation service dts packages adonet c provides reports using ssrs relational oltp model multidimensional olap ssas cubes team also responsible scheduling packages using batch files sql agent jobs redesigned implemented unit tested database schema stored procedures dts packages casemix module applied multidimensional snowflake schema reduced system runtime 30 performance tuning sql queries stored procedures using sql profiler index tuning advisor designed created different etl packages migrate data db2 database flat data files implemented scheduled polling proactive incremental data extraction sql server 2000 environment using sql agent configured sql mail agent sending automatic emails errors identified tested resolved database performance issues monitoring tuning ensure database optimization created schema views stored procedures triggers functions data migration involved complete life cycle project planning staging pushing codes production designed developed reports ssrs provided solutions customer requested automation feeds using aspnet net development microsoft office c greatly improved productivity efficiency implemented documented major changes labor adjustments modules using cnet adonet oledb interacted client application teams coordinated monthly production release schedules implemented production deployments 012002 012004 application developer pennymac raleigh nc lead designer developer enterprise information support system companywide operational data integration report generation system capable extracting corporate data different systems providing single version truth reports timely costeffective manner er diagram tsql sql server dts package stored procedure trigger olap crystal reports excel conducted data modeling database design using er diagram automated enforcement data integrity utilizing triggers constrains reduced maintenance cost 50 streamlined automated report generation processes improved efficiency using sql agent job scheduler batch files dts packages 012000 012002 software engineer mci worldcom city state contractor core designer fdbaudit remote database synchronization subsystem used redirect server worldcoms next generation product voice ip cc idl corba oracle rational purify uml rational rose unix perl korn shell scripting clearcase designed interface fdbremote upper level subsystem using corba idl prototyped interface c code utilized rational purify debug runtime memory leakcorruption took appropriate action ensure availability resources reaching new milestone one half months earlier 011996 012000 application developer aegis communications group city state designed implemented backend data communication applications aegis dg system fortune 500 american express system using cc ibmhllapi sna3270 clientserver programming increased reliability backend communication server 30 developed customer relation management projects companys major client responsible whole development life cycle including business analysis application design implementation used cc esql informix4gl testing maintenance received recognition award american express top quality application delivery education ms computer science university north texas denton texas computer science bs computer science hunan university changsha computer science