professional summary skills work history jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom experienced professional 11 years serving clients across finance retail healthcare telecom industries expertise designing implementing solutions using distributed centralized databases javaj2ee python angular adept delivering scalable highperformance applications constantly seeking enhance skills stay current emerging technologies hands experience databases environment like singlestore sql server mysql5xoracle 12cpostgres extensive experience etl data processing including extracting data file systems kafka transforming loading singlestore using singlestore pipeline experience extracting transforming loading etl data excel flat file oracle ms sql server using bcp utility dts ssis services experience database migration sql servermysqldb2postgres singlestore sql server working knowledge msqlplsqltsql query table views indexes complex queries expertise writing effective welltuned complex sql queries using joins technically proficient writing complex mpsqltsqlplsql code procedures functions triggers indexes complex view sequences packages involving exception handling analyze long running slow queries tune optimize application system performance proficient using python write automated scripts continuous integration continuous deployment cicd processes implemented kafka producer consumer applications kafka cluster setup help zookeeper extensive experience searching engines like apache solr working experience chat bot framework using aiml language experience object oriented programming core java se including collections api threads multithreading generics reflection data structures algorithms jdbc proficient java enterprise technologies ejb jms log 4j advanced j2ee frameworks spring struts hibernate orm successfully implemented hibernatejpa framework objectrelational mapping orm solution efficiently interact databases extensively worked many java concepts restful web services json soapwsdl web services xml parsers proficient agile scrum waterfall methodologies experience build tools like ant maven gradle indepth knowledge jenkins continuous integration serverinstallation configuration design administration integrating tools systems databases singlestore oracle sql server postgresql relational database management development testing ops support core java jspservlet ejb springjdbc tech lead data migration specialist torch technologies inc eglin air force base fl agilescrum methodology build tool maven gradle apache tomcat glassfish server weblogic websphere server 092020 current brokerage auth sari projects bank america bofa involve migrating data sql server db2 singlestore rowstore distributed database goal streamline data storage improve system efficiency consolidating data single database management system project team responsible designing executing plan extract data legacy systems clean validate data load singlestore using singlestore pipeline etl extract transform load process team also convert existing dml data manipulation language statements stored procedures compatible singlestore performance evaluated using dbbench projects ongoing involve testing verifying data transferred correctly new system meets required performance functional specifications bofa responsibilities participating requirement gathering meetings discussions stakeholders bofa team business analysts understanding business requirements use cases project translating business requirements technical specifications functional requirements providing input feasibility requirements suggesting alternative solutions necessary identifying technical limitations challenges may arise development process design execute data migration plan including extraction validation cleaning loading data singlestore convert dml statements stored procedures compatible singlestore ensure data accurately transferred properly accessible new system comparing data source system sql server db2 target system singlestore ensure data accurately completely transferred using row verificator tool using row verification tool validate data transferred correctly data lost altered migration process reviewing discrepancies issues identified verification process addressing resolving data integrity issues errors identified verification process documenting results verification process including issues identified resolved conduct performance testing using dbbench validate new system meets exceeds bofas requirements identify resolve performance bottlenecks issues arise testing tech lead solutions architecture fiserv city state 082019 082020 deposit line project consists two components analytical engine ae relationship advance business application raba ae standalone javabased scheduler application determines dda account holders eligibility advance raba webbased application allows account holders enroll advance based credit line eligibility status calculated ae responsibilities interaction bu order capture requirement study architectural designs created stored procedures triggers functions indexes views joins tsql code applications optimize stored procedures functions using tsql import data text files sql server database using bulk insert analyzed long running slow queries tune optimize application system performance added functionality existing applications using java sql wrote complex sql queriessp retrieve data database using jdbc integrated unit tested stored procedures using tsqlt testing framework implemented kafka producer consumer applications kafka cluster setup help zookeeper used spring kafka api calls process messages smoothly kafka cluster setup planned tested implemented data migration mysql sql server tech lead solutions architecture 062014 082019 fiserv city state skills used angularjs j2ee jasmine javascript frameworks spring framework oracle 12 c project summary virtual archive responsive web application designed allow users access estatements tax statements stock documents either physical cddvd digital format thirdparty vendors individual broker dealers app developed using angularjs bootstrap making compatible mobile platforms operates single page application spa blueprint application configuration application used add new clients board add site clients configure per requirements blueprint web application used add sites clients ie web enterprise view webclient view responsibilities interaction output solutions order capture requirement study architectural designs developed various objects like tables indexes sequences procedure functions using sql developer oracle plsql 12c involved converting xml document store data generate xml document feed java program design create entity relationship diagrams erd java interface create entities classes analyzed long running slow queries tune optimize application system performance performance tune optimize sqls using explain tables design json requestresponse according frontend pages involved writing jpa classes hql named queries involved end end integration angularjs develop design new functionality existing application write unit test specs code coverage jasmine junit architecture design development device sso ui client virtual archive softovare developer previous organizations initiatives city state medsolis care management system sns technology inc customer point sale cpos disha tcs 072011 062014 education master computer applications computer science savitribai phule pune university pune india 072009 bachelor computer applications computer science 072006 bundelkhand university jhansi india