jessica claire 9 resumesampleexamplecom 555 4321000 montgomery street san francisco ca 94105 summary creative resourceful flexible professional offering broad range experience proven abilities pc midrange mainframe systems design implementation legacy system conversions database developmentmanagement strategic planning installations support principal strengths include analytical technical team building problem solving offering excellent communication interpersonal research planning abilities highlights db2 sql cobol 2 ms sql server jcl sas chrystal reports ms office suite mvs ispftso electronic data interchange edi ibm utilities unix shell c informix connect direct ftp visual basic oracle changeman syncsort education devry institute technology atlanta ga bachelor science computer science computer science accomplishments experience college william mary programmeranalystdatabase administrator williamsburg va 012008 012009 analyzed created installed 3 new microsoft sql server 2000 databases replace 6 existing databases att treasury operations group reducing database management cost 50 drafted new reports using crystal reports returned mail application collected composed requirements new clientserver web application working directly programmers india tracking progress internal tracking system production support maintenance new development cobol ii db2 mainframe application database management performed maintenance 27 microsoft sql server databases used 6 att treasury operations applications result databases stable efficient reliable 100 time non maintenance periods college william mary programmeranalystdatabase administrator williamsburg va 011997 012008 created 100 new tables columns indexes table loads 5 ibm db2 databases used development testing production continuously provided subject matter expertise 65 banks billers financial institutions using connectdirect ensure uninterrupted flow transactions tofrom remittance resolution system planned coded tested debugged 35 cobol ii db2 application programs redirect lost payments maintaining legacy pl1 application designed implemented large ibm db2 database consisting 60 tables using normalization methodologies techniques resulting stable efficient database requiring minimum enhancements enhancements software development created designed implemented solution corrupted data largest consumer billers writing 3 cobol ii programs correct data report upper management daily 6 months result customers accounts 100 accurate saving att 8m obtained one highest honors circle excellence award daniel claire page 2 process design automation developed weekly archive process reduce amount production data stored 31 db2 tables result data moved successfully saving time cost reducing production data storage 85 increasing data retrieval time 60 database development planned created installed 100 new tables columns indexes table loads 5 ibm db2 databases used development testing production result tables columns indexes created updated timely manner applications supported databases trouble shooting investigated several long running batch jobs determine root cause creating testing new indexes 7 key db2 tables result job run time reduced 5 hours 3 minutes lucent technologies programmeranalyst city state 011996011997 successfully cloned implemented edi processes att financial services organization lucent technologies giving lucent technologies stateoftheart edi system allowing lucent technologies conduct electronic transactions first day business cost reduction avoidance utilized existing resources developed process receive 100s electronic files using connectdirect 3 different trading partners sent electronic files back trading partners result 50k savings cost avoidance plus 480 man hours development time att inc programmeranalyst city state 011984 011996 streamlined production edi processes att financial systems organization saving att 100k annually designed developed entire host interface att transfer system interact conversant script builder establishing largest conversant system ever att hr systems implemented 10 12 hour shifts att hourly manufacturing payroll system contributed development att customer network design tool replacing manual method system engineers increasing efficiency work flow operations 500 programming coding participated edi pilot program irs designing developing coding processes required file quarterly payroll taxes electronically result major corporations use variation trial report payroll taxes electronically irs interests database administrator programmer analyst db2 dba ms sqlserver etl sql cobol sas mvs excel powerpoint word access rpg edi jcl file transfer ftp connect direct coding software development cost reduction team building crystal reports additional information awards circle excellence award exceptional software development star excellence award outstanding cost reduction avoidance star excellence award outstanding process design automation award patriotic service us department treasury keywords database administrator programmer analyst db2 dba ms sqlserver etl sql cobol sas mvs excel powerpoint word access rpg edi jcl file transfer ftp connect direct coding software development cost reduction team building crystal reports skills art automation c clientserver cobol ii cobol 2 cost reduction crystal reports databases database database development database management designing electronic data interchange edi financial ftp hr ibm db2 mvs informix ispf jcl mainframe mail ms office suite 2000 network design oracle payroll pl1 process design processes coding programming progress sas shell script software development ms sql server microsoft sql server sql syncsort tables taxes treasury trouble shooting tso unix ibm utilities visual basic work flow