jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary clientfocused senior software engineer years designing innovative applications achieving high client satisfaction 4 years experience team lead handling offshore onsite teams managed maintained banner cis application used utility billing inventory maintenance service order processing transmission distribution service provider utility company managed phases sdlc software development life cycle analysis design development testing implementation maintenance timely delivery extensive experience thorough knowledge plsql language shell scripting extensive hands experience ibm datastage etl tool data warehousing technologies good hands experience oracle apex application development proven experience developing internal tool scratch certified java professional excellent programing capabilities web application development experience production support activities like incident problem ticket management slas experience using oracle dba utilities like export import data pump working knowledge oracle forms 11g outstanding analytical problem solving skills excellent interpersonal communication organizational team management skills committed maintaining cutting edge technical skills uptodate industry knowledge skills operating systems windows xp2012 r2 linux unix programming languages sql plsql etl unix shell scripting javaj2ee xml net 2035 proc databases oracle 11g10g9i ms sql server 20052008 teradata certifications certified java professional work history 032014 current srplsql lead ceridian corporation chicago il development tools toad plsql developer datastage 11591 oracle forms reports apex eclipse rad visual studio 200820102012 sql server tools appworx autosys winscp putty jira snow project banner customer information system cis supports tnmps operations providing electric services perspective customers relational database designed receive process information related tnmps routine business functions application core customer information billing system tnmptx responsibilities manages customer information system banner application includes billing inventory maintenance service order processing utility customers investigating new technology solutions optimise existing process reduce development efforts key point contact users project technology related problems developing maintaining etl jobs revenue processing general ledger accounts manages supports web applications developed java net creating modifying oracle objects pl sql working application sme guide team members adding new functionality fixing defects application developed oracle forms 11g continued improving critical business process implementing modification resulting reduction execution time 67 faster turnaround time working application sme identified risks shortcomings developing solutions improve system responsible communication client regarding project progress environment plsql sql oracle 11g unix datastage 115 toad plsql developer oracleforms 11g tfs appworx java provided continued maintenance development bug fixes patch sets existing web applications provided continued maintenance development bug fixes patch sets existing web applications diagnosed troubleshooted unix windows processing problems applied solutions increase company efficiency proposed technical feasibility solutions new functional designs suggested options performance improvement technical objects 032013 032014 sr plsql lead cognizant technology solutions allen intermountain health care one reputed hospitals provide kind health medical services internal web application costing process intermountain hospitals designed developed enhanced part chart accounts project services intermountain hospitals like inpatient outpatient treatment emergency services lab services etc set defined cost based direct indirect expenses responsibilities responsible requirements gathering analysis design development unit testing responsible identifying pain areas proposing new optimised solutions developing modifying plsql packages procedures functions tables constraints triggers designed table structure used normalization techniques used refcursors collections bulk collects created indexes materialized views improve performance created applications using apex worked user location gather functional requirements proposed project prototypes created scheduled jobs automate process created procedures load data tables apex recruited trained team members conducting brainstorming sessions identify risks post production issues environment plsql sql oracle 10g unix datastage 91 toad sql developer apex subversion provided documentation startup shut first level troubleshooting processes help desk staff streamlined enhanced corporate accounting operations system 082012 032013 sr plsql lead cognizant technology solutions andover web applications pharmacy department suite applications designed developed enhanced walgreens pharmacy health wellness phwt department applications core applications used walgreens pharmacy across nation applications used various users like pharmacists pharmacy technicians business sponsors business partners various walgreens vendors applications used various purposes like prescription fulfilment rate settings inventory management patient follow drug interactions drug dispensing reviews etc responsibilities managing maintaining multiple applications developed oracle plsql javaj2ee worked application development enhancements using rad spring framework created database tables constraints triggers sme applications convert business requirements technical requirements developed plsql packages procedures functions monitored data loads process jobs prepared detailed design documents post production observations lessons learned preparing sql queries perform data management key participation requirements gathering unit testing integration testing managing offshore team train per new requirements project environment oracle plsql oracle 11g10g java spring unix sql plus toad putty winscp subversion consistently met deadlines requirements production work orders 022012 082012 sr software developer optum health linx city state role plsql lead description linx integrated care management system developed using java sybase provides bh eap wl services members enrolled optum health health plans linx manages member details sends authorizations various systems like p3 facets cosmos pbh facets etc also generates bh eap wl letters members providers responsibilities involved development activities enhancement change requests involved production support activities run monitor batch jobs required application involve requirements gathering analysis development enhancements application performed unit integration testing various modules integrated different modules within application administered application responsible deployment maintenance periodically check performance application using tool called bradmark norad surveillance tool take appropriate preventive corrective actions preparing knowledge documents related business process help new resource existing resource reference guide environment oracle plsql sql java spring oracle 10g db2 unix pega sql developer sql server 2005 autosys subversion established compatibility third party software products developing program modification integration provided documentation startup shut first level troubleshooting processes help desk staff 102009 022012 plsql developer united healthcare city state healthcare ovations provides insurance plans like comprehensive insurance ppo coverage endorsed aarp medicare supplemental insurance supplemental health insurance long term care insurance dental insurance plans vary location provides discounts prescription also eye care related products catalogue products also medicare reimbursed medical supplies ovations commissions project deals calculation incentives internal agents commission external agents incentives calculated every month commission calculated week process calculations system interacts several systems data feeds calculates incentivecommission sends external systems payment code developed using java jdbc rmi responsibilities developed plsql packages procedures functions used cursors collections creating complex queries perform data management created sql scripts make bulk data changes monitored data loads data management processes using autosys created executed jobs using unix commands unit testing integrity testing tracking task details prioritize tasks educating team members business technology wise environment oracle plsql sql java oracle 10g unix sql developer sql server2005 putty winscp autosys 102007 092009 plsql developer timeinc city state online fashion designer magazine time giving information designers items user search different types information responsibilities developed plsql procedures functions prepared complex sql queries perform data changes developed sql scripts running monitoring automated jobs using autosys coding unit testing integrity testing involving deployments involving quality audits environment oracle plsql sql java oracle 9i xml sql developer toad autosys consistently met deadlines requirements production work orders developed workflow charts diagrams ensure production team compliance client deadlines proposed technical feasibility solutions new functional designs suggested options performance improvement technical objects education 2007 master engineering cadcam andhra university college engineering cadcam topper class bachelors degree mechanical jnt university mechanical top 10 class emphasis problem solving